summaryrefslogtreecommitdiff
path: root/src/YalpInputs/YalpPGSqlInput/db-design-sql.backup
blob: 37c158542d6ae55c68e3db6494dad8848fe15ef4 (plain)
ofshex dumpascii
0000 50 47 44 4d 50 01 0a 00 04 08 01 01 01 00 00 00 00 34 00 00 00 00 2c 00 00 00 00 16 00 00 00 00 PGDMP............4....,.........
0020 0f 00 00 00 00 09 00 00 00 00 6c 00 00 00 00 01 00 00 00 00 04 00 00 00 79 61 6c 70 00 06 00 00 ..........l.............yalp....
0040 00 38 2e 30 2e 31 33 00 06 00 00 00 38 2e 30 2e 31 33 00 1e 00 00 00 00 ef 05 00 00 00 00 00 00 .8.0.13.....8.0.13..............
0060 00 00 01 00 00 00 30 00 01 00 00 00 30 00 08 00 00 00 45 4e 43 4f 44 49 4e 47 00 08 00 00 00 45 ......0.....0.....ENCODING.....E
0080 4e 43 4f 44 49 4e 47 00 21 00 00 00 53 45 54 20 63 6c 69 65 6e 74 5f 65 6e 63 6f 64 69 6e 67 20 NCODING.!...SET.client_encoding.
00a0 3d 20 27 55 4e 49 43 4f 44 45 27 3b 0a 00 00 00 00 00 01 01 00 00 00 01 01 00 00 00 01 01 00 00 =.'UNICODE';....................
00c0 00 00 00 00 00 00 00 05 00 00 00 66 61 6c 73 65 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 f0 ...........false................
00e0 05 00 00 00 00 00 00 00 00 04 00 00 00 31 32 36 32 00 05 00 00 00 31 37 32 35 30 00 04 00 00 00 .............1262.....17250.....
0100 79 61 6c 70 00 08 00 00 00 44 41 54 41 42 41 53 45 00 45 00 00 00 43 52 45 41 54 45 20 44 41 54 yalp.....DATABASE.E...CREATE.DAT
0120 41 42 41 53 45 20 79 61 6c 70 20 57 49 54 48 20 54 45 4d 50 4c 41 54 45 20 3d 20 74 65 6d 70 6c ABASE.yalp.WITH.TEMPLATE.=.templ
0140 61 74 65 30 20 45 4e 43 4f 44 49 4e 47 20 3d 20 27 55 4e 49 43 4f 44 45 27 3b 0a 00 14 00 00 00 ate0.ENCODING.=.'UNICODE';......
0160 44 52 4f 50 20 44 41 54 41 42 41 53 45 20 79 61 6c 70 3b 0a 01 01 00 00 00 01 01 00 00 00 01 01 DROP.DATABASE.yalp;.............
0180 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 01 01 00 00 00 03 00 00 00 00 ........yalp.....false..........
01a0 00 00 00 00 00 05 00 00 00 00 00 00 00 00 00 05 00 00 00 31 36 36 37 32 00 04 00 00 00 32 32 30 ...................16672.....220
01c0 30 00 06 00 00 00 70 75 62 6c 69 63 00 06 00 00 00 53 43 48 45 4d 41 00 16 00 00 00 43 52 45 41 0.....public.....SCHEMA.....CREA
01e0 54 45 20 53 43 48 45 4d 41 20 70 75 62 6c 69 63 3b 0a 00 14 00 00 00 44 52 4f 50 20 53 43 48 45 TE.SCHEMA.public;......DROP.SCHE
0200 4d 41 20 70 75 62 6c 69 63 3b 0a 01 01 00 00 00 01 01 00 00 00 01 01 00 00 00 00 08 00 00 00 70 MA.public;.....................p
0220 6f 73 74 67 72 65 73 00 05 00 00 00 66 61 6c 73 65 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 ostgres.....false...............
0240 f1 05 00 00 00 00 00 00 00 00 01 00 00 00 30 00 01 00 00 00 30 00 0d 00 00 00 53 43 48 45 4d 41 ..............0.....0.....SCHEMA
0260 20 70 75 62 6c 69 63 00 07 00 00 00 43 4f 4d 4d 45 4e 54 00 36 00 00 00 43 4f 4d 4d 45 4e 54 20 .public.....COMMENT.6...COMMENT.
0280 4f 4e 20 53 43 48 45 4d 41 20 70 75 62 6c 69 63 20 49 53 20 27 53 74 61 6e 64 61 72 64 20 70 75 ON.SCHEMA.public.IS.'Standard.pu
02a0 62 6c 69 63 20 73 63 68 65 6d 61 27 3b 0a 00 00 00 00 00 01 01 00 00 00 01 01 00 00 00 01 01 00 blic.schema';...................
02c0 00 00 00 08 00 00 00 70 6f 73 74 67 72 65 73 00 05 00 00 00 66 61 6c 73 65 00 01 00 00 00 35 01 .......postgres.....false.....5.
02e0 01 00 00 00 03 00 00 00 00 00 00 00 00 00 f2 05 00 00 00 00 00 00 00 00 01 00 00 00 30 00 01 00 ............................0...
0300 00 00 30 00 06 00 00 00 70 75 62 6c 69 63 00 03 00 00 00 41 43 4c 00 c6 00 00 00 52 45 56 4f 4b ..0.....public.....ACL.....REVOK
0320 45 20 41 4c 4c 20 4f 4e 20 53 43 48 45 4d 41 20 70 75 62 6c 69 63 20 46 52 4f 4d 20 50 55 42 4c E.ALL.ON.SCHEMA.public.FROM.PUBL
0340 49 43 3b 0a 52 45 56 4f 4b 45 20 41 4c 4c 20 4f 4e 20 53 43 48 45 4d 41 20 70 75 62 6c 69 63 20 IC;.REVOKE.ALL.ON.SCHEMA.public.
0360 46 52 4f 4d 20 70 6f 73 74 67 72 65 73 3b 0a 47 52 41 4e 54 20 41 4c 4c 20 4f 4e 20 53 43 48 45 FROM.postgres;.GRANT.ALL.ON.SCHE
0380 4d 41 20 70 75 62 6c 69 63 20 54 4f 20 70 6f 73 74 67 72 65 73 3b 0a 47 52 41 4e 54 20 41 4c 4c MA.public.TO.postgres;.GRANT.ALL
03a0 20 4f 4e 20 53 43 48 45 4d 41 20 70 75 62 6c 69 63 20 54 4f 20 79 61 6c 70 3b 0a 47 52 41 4e 54 .ON.SCHEMA.public.TO.yalp;.GRANT
03c0 20 41 4c 4c 20 4f 4e 20 53 43 48 45 4d 41 20 70 75 62 6c 69 63 20 54 4f 20 50 55 42 4c 49 43 3b .ALL.ON.SCHEMA.public.TO.PUBLIC;
03e0 0a 00 00 00 00 00 01 01 00 00 00 01 01 00 00 00 01 01 00 00 00 00 08 00 00 00 70 6f 73 74 67 72 ..........................postgr
0400 65 73 00 05 00 00 00 66 61 6c 73 65 00 01 00 00 00 35 01 01 00 00 00 03 00 00 00 00 00 00 00 00 es.....false.....5..............
0420 00 94 04 00 00 00 00 00 00 00 00 04 00 00 00 31 32 35 39 00 05 00 00 00 31 37 33 30 36 00 0d 00 ...............1259.....17306...
0440 00 00 49 6e 74 50 72 6f 70 65 72 74 69 65 73 00 05 00 00 00 54 41 42 4c 45 00 65 00 00 00 43 52 ..IntProperties.....TABLE.e...CR
0460 45 41 54 45 20 54 41 42 4c 45 20 22 49 6e 74 50 72 6f 70 65 72 74 69 65 73 22 20 28 0a 20 20 20 EATE.TABLE."IntProperties".(....
0480 20 69 64 20 62 69 67 73 65 72 69 61 6c 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20 20 20 64 65 73 63 .id.bigserial.NOT.NULL,.....desc
04a0 72 69 70 74 69 6f 6e 20 74 65 78 74 2c 0a 20 20 20 20 76 61 6c 75 65 20 69 6e 74 65 67 65 72 0a ription.text,.....value.integer.
04c0 29 3b 0a 00 23 00 00 00 44 52 4f 50 20 54 41 42 4c 45 20 70 75 62 6c 69 63 2e 22 49 6e 74 50 72 );..#...DROP.TABLE.public."IntPr
04e0 6f 70 65 72 74 69 65 73 22 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 00 00 00 00 00 operties";...........public.....
0500 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 34 39 33 00 01 00 00 .....yalp.....false.....1493....
0520 00 35 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 f3 05 00 00 00 00 00 00 00 00 01 00 00 00 30 .5.............................0
0540 00 01 00 00 00 30 00 14 00 00 00 49 6e 74 50 72 6f 70 65 72 74 69 65 73 5f 69 64 5f 73 65 71 00 .....0.....IntProperties_id_seq.
0560 0c 00 00 00 53 45 51 55 45 4e 43 45 20 53 45 54 00 60 00 00 00 53 45 4c 45 43 54 20 70 67 5f 63 ....SEQUENCE.SET.`...SELECT.pg_c
0580 61 74 61 6c 6f 67 2e 73 65 74 76 61 6c 28 70 67 5f 63 61 74 61 6c 6f 67 2e 70 67 5f 67 65 74 5f atalog.setval(pg_catalog.pg_get_
05a0 73 65 72 69 61 6c 5f 73 65 71 75 65 6e 63 65 28 27 22 49 6e 74 50 72 6f 70 65 72 74 69 65 73 22 serial_sequence('"IntProperties"
05c0 27 2c 20 27 69 64 27 29 2c 20 31 2c 20 66 61 6c 73 65 29 3b 0a 00 00 00 00 00 01 01 00 00 00 00 ',.'id'),.1,.false);............
05e0 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c ....public..........yalp.....fal
0600 73 65 00 04 00 00 00 31 31 37 31 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 96 04 00 00 00 00 se.....1171.....................
0620 00 00 00 00 04 00 00 00 31 32 35 39 00 05 00 00 00 31 37 33 31 33 00 06 00 00 00 4d 65 64 69 61 ........1259.....17313.....Media
0640 73 00 05 00 00 00 54 41 42 4c 45 00 a3 00 00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 22 4d 65 s.....TABLE.....CREATE.TABLE."Me
0660 64 69 61 73 22 20 28 0a 20 20 20 20 69 64 20 62 69 67 73 65 72 69 61 6c 20 4e 4f 54 20 4e 55 4c dias".(.....id.bigserial.NOT.NUL
0680 4c 2c 0a 20 20 20 20 22 74 79 70 65 22 20 63 68 61 72 61 63 74 65 72 28 31 29 2c 0a 20 20 20 20 L,....."type".character(1),.....
06a0 70 61 74 68 20 74 65 78 74 2c 0a 20 20 20 20 22 66 69 6c 65 4e 61 6d 65 22 20 74 65 78 74 2c 0a path.text,....."fileName".text,.
06c0 20 20 20 20 64 75 72 61 74 69 6f 6e 20 74 65 78 74 2c 0a 20 20 20 20 6e 61 6d 65 20 74 65 78 74 ....duration.text,.....name.text
06e0 2c 0a 20 20 20 20 74 61 67 73 20 74 65 78 74 0a 29 3b 0a 00 1c 00 00 00 44 52 4f 50 20 54 41 42 ,.....tags.text.);......DROP.TAB
0700 4c 45 20 70 75 62 6c 69 63 2e 22 4d 65 64 69 61 73 22 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 LE.public."Medias";...........pu
0720 62 6c 69 63 00 00 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 blic..........yalp.....false....
0740 00 31 34 39 34 00 01 00 00 00 35 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 f4 05 00 00 00 00 .1494.....5.....................
0760 00 00 00 00 01 00 00 00 30 00 01 00 00 00 30 00 0d 00 00 00 4d 65 64 69 61 73 5f 69 64 5f 73 65 ........0.....0.....Medias_id_se
0780 71 00 0c 00 00 00 53 45 51 55 45 4e 43 45 20 53 45 54 00 58 00 00 00 53 45 4c 45 43 54 20 70 67 q.....SEQUENCE.SET.X...SELECT.pg
07a0 5f 63 61 74 61 6c 6f 67 2e 73 65 74 76 61 6c 28 70 67 5f 63 61 74 61 6c 6f 67 2e 70 67 5f 67 65 _catalog.setval(pg_catalog.pg_ge
07c0 74 5f 73 65 72 69 61 6c 5f 73 65 71 75 65 6e 63 65 28 27 22 4d 65 64 69 61 73 22 27 2c 20 27 69 t_serial_sequence('"Medias"',.'i
07e0 64 27 29 2c 20 32 2c 20 74 72 75 65 29 3b 0a 00 00 00 00 00 01 01 00 00 00 00 06 00 00 00 70 75 d'),.2,.true);................pu
0800 62 6c 69 63 01 01 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 blic..........yalp.....false....
0820 00 31 31 37 33 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 98 04 00 00 00 00 00 00 00 00 04 00 .1173...........................
0840 00 00 31 32 35 39 00 05 00 00 00 31 37 33 32 33 00 11 00 00 00 50 72 6f 70 65 72 74 79 43 6f 6e ..1259.....17323.....PropertyCon
0860 6e 65 63 74 6f 72 00 05 00 00 00 54 41 42 4c 45 00 a8 00 00 00 43 52 45 41 54 45 20 54 41 42 4c nector.....TABLE.....CREATE.TABL
0880 45 20 22 50 72 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 22 20 28 0a 20 20 20 20 22 6d 65 64 E."PropertyConnector".(....."med
08a0 69 61 49 64 22 20 69 6e 74 65 67 65 72 2c 0a 20 20 20 20 22 73 74 72 69 6e 67 50 72 6f 70 65 72 iaId".integer,....."stringProper
08c0 74 79 49 64 22 20 69 6e 74 65 67 65 72 20 44 45 46 41 55 4c 54 20 30 2c 0a 20 20 20 20 22 69 6e tyId".integer.DEFAULT.0,....."in
08e0 74 50 72 6f 70 65 72 74 79 49 64 22 20 69 6e 74 65 67 65 72 20 44 45 46 41 55 4c 54 20 30 2c 0a tPropertyId".integer.DEFAULT.0,.
0900 20 20 20 20 69 64 20 62 69 67 73 65 72 69 61 6c 20 4e 4f 54 20 4e 55 4c 4c 0a 29 3b 0a 00 27 00 ....id.bigserial.NOT.NULL.);..'.
0920 00 00 44 52 4f 50 20 54 41 42 4c 45 20 70 75 62 6c 69 63 2e 22 50 72 6f 70 65 72 74 79 43 6f 6e ..DROP.TABLE.public."PropertyCon
0940 6e 65 63 74 6f 72 22 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 00 00 00 00 00 00 04 nector";...........public.......
0960 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 34 39 35 00 04 00 00 00 31 ...yalp.....false.....1495.....1
0980 34 39 36 00 04 00 00 00 31 34 39 37 00 01 00 00 00 35 01 01 00 00 00 03 00 00 00 00 00 00 00 00 496.....1497.....5..............
09a0 00 92 04 00 00 00 00 00 00 00 00 04 00 00 00 31 32 35 39 00 05 00 00 00 31 37 32 39 34 00 10 00 ...............1259.....17294...
09c0 00 00 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 00 05 00 00 00 54 41 42 4c 45 00 65 00 00 ..StringProperties.....TABLE.e..
09e0 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 22 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 22 .CREATE.TABLE."StringProperties"
0a00 20 28 0a 20 20 20 20 69 64 20 62 69 67 73 65 72 69 61 6c 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20 .(.....id.bigserial.NOT.NULL,...
0a20 20 20 64 65 73 63 72 69 70 74 69 6f 6e 20 74 65 78 74 2c 0a 20 20 20 20 76 61 6c 75 65 20 74 65 ..description.text,.....value.te
0a40 78 74 0a 29 3b 0a 00 26 00 00 00 44 52 4f 50 20 54 41 42 4c 45 20 70 75 62 6c 69 63 2e 22 53 74 xt.);..&...DROP.TABLE.public."St
0a60 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 22 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 ringProperties";...........publi
0a80 63 00 00 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 34 c..........yalp.....false.....14
0aa0 39 32 00 01 00 00 00 35 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 f5 05 00 00 00 00 00 00 00 92.....5........................
0ac0 00 01 00 00 00 30 00 01 00 00 00 30 00 17 00 00 00 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 .....0.....0.....StringPropertie
0ae0 73 5f 69 64 5f 73 65 71 00 0c 00 00 00 53 45 51 55 45 4e 43 45 20 53 45 54 00 63 00 00 00 53 45 s_id_seq.....SEQUENCE.SET.c...SE
0b00 4c 45 43 54 20 70 67 5f 63 61 74 61 6c 6f 67 2e 73 65 74 76 61 6c 28 70 67 5f 63 61 74 61 6c 6f LECT.pg_catalog.setval(pg_catalo
0b20 67 2e 70 67 5f 67 65 74 5f 73 65 72 69 61 6c 5f 73 65 71 75 65 6e 63 65 28 27 22 53 74 72 69 6e g.pg_get_serial_sequence('"Strin
0b40 67 50 72 6f 70 65 72 74 69 65 73 22 27 2c 20 27 69 64 27 29 2c 20 31 2c 20 66 61 6c 73 65 29 3b gProperties"',.'id'),.1,.false);
0b60 0a 00 00 00 00 00 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 00 00 04 00 00 00 ................public..........
0b80 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 36 39 01 01 00 00 00 03 00 00 00 yalp.....false.....1169.........
0ba0 00 00 00 00 00 00 8f 04 00 00 00 00 00 00 00 00 04 00 00 00 31 32 35 39 00 05 00 00 00 31 37 32 ....................1259.....172
0bc0 36 39 00 05 00 00 00 55 73 65 72 73 00 05 00 00 00 54 41 42 4c 45 00 89 00 00 00 43 52 45 41 54 69.....Users.....TABLE.....CREAT
0be0 45 20 54 41 42 4c 45 20 22 55 73 65 72 73 22 20 28 0a 20 20 20 20 22 6c 65 76 65 6c 22 20 69 6e E.TABLE."Users".(....."level".in
0c00 74 65 67 65 72 20 44 45 46 41 55 4c 54 20 31 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20 20 20 69 64 teger.DEFAULT.1.NOT.NULL,.....id
0c20 20 62 69 67 73 65 72 69 61 6c 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20 20 20 6e 61 6d 65 20 74 65 .bigserial.NOT.NULL,.....name.te
0c40 78 74 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20 20 20 22 72 65 61 6c 4e 61 6d 65 22 20 74 65 78 74 xt.NOT.NULL,....."realName".text
0c60 0a 29 3b 0a 00 1b 00 00 00 44 52 4f 50 20 54 41 42 4c 45 20 70 75 62 6c 69 63 2e 22 55 73 65 72 .);......DROP.TABLE.public."User
0c80 73 22 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 00 00 00 00 00 00 04 00 00 00 79 61 s";...........public..........ya
0ca0 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 34 39 30 00 04 00 00 00 31 34 39 31 00 01 lp.....false.....1490.....1491..
0cc0 00 00 00 35 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 f6 05 00 00 00 00 00 00 00 00 01 00 00 ...5............................
0ce0 00 30 00 01 00 00 00 30 00 0c 00 00 00 55 73 65 72 73 5f 69 64 5f 73 65 71 00 0c 00 00 00 53 45 .0.....0.....Users_id_seq.....SE
0d00 51 55 45 4e 43 45 20 53 45 54 00 58 00 00 00 53 45 4c 45 43 54 20 70 67 5f 63 61 74 61 6c 6f 67 QUENCE.SET.X...SELECT.pg_catalog
0d20 2e 73 65 74 76 61 6c 28 70 67 5f 63 61 74 61 6c 6f 67 2e 70 67 5f 67 65 74 5f 73 65 72 69 61 6c .setval(pg_catalog.pg_get_serial
0d40 5f 73 65 71 75 65 6e 63 65 28 27 22 55 73 65 72 73 22 27 2c 20 27 69 64 27 29 2c 20 31 2c 20 66 _sequence('"Users"',.'id'),.1,.f
0d60 61 6c 73 65 29 3b 0a 00 00 00 00 00 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 alse);................public....
0d80 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 36 38 01 01 00 ......yalp.....false.....1168...
0da0 00 00 03 00 00 00 00 00 00 00 00 00 f7 05 00 00 00 00 00 00 00 00 01 00 00 00 30 00 01 00 00 00 ..........................0.....
0dc0 30 00 18 00 00 00 70 72 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 5f 69 64 5f 73 65 71 00 0c 0.....propertyConnector_id_seq..
0de0 00 00 00 53 45 51 55 45 4e 43 45 20 53 45 54 00 64 00 00 00 53 45 4c 45 43 54 20 70 67 5f 63 61 ...SEQUENCE.SET.d...SELECT.pg_ca
0e00 74 61 6c 6f 67 2e 73 65 74 76 61 6c 28 70 67 5f 63 61 74 61 6c 6f 67 2e 70 67 5f 67 65 74 5f 73 talog.setval(pg_catalog.pg_get_s
0e20 65 72 69 61 6c 5f 73 65 71 75 65 6e 63 65 28 27 22 50 72 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 erial_sequence('"PropertyConnect
0e40 6f 72 22 27 2c 20 27 69 64 27 29 2c 20 31 2c 20 66 61 6c 73 65 29 3b 0a 00 00 00 00 00 01 01 00 or"',.'id'),.1,.false);.........
0e60 00 00 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 .......public..........yalp.....
0e80 66 61 6c 73 65 00 04 00 00 00 31 31 37 35 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 eb 05 00 false.....1175..................
0ea0 00 00 01 00 00 00 00 01 00 00 00 30 00 05 00 00 00 31 37 33 30 36 00 0d 00 00 00 49 6e 74 50 72 ...........0.....17306.....IntPr
0ec0 6f 70 65 72 74 69 65 73 00 0a 00 00 00 54 41 42 4c 45 20 44 41 54 41 00 00 00 00 00 00 00 00 00 operties.....TABLE.DATA.........
0ee0 00 00 3a 00 00 00 43 4f 50 59 20 22 49 6e 74 50 72 6f 70 65 72 74 69 65 73 22 20 28 69 64 2c 20 ..:...COPY."IntProperties".(id,.
0f00 64 65 73 63 72 69 70 74 69 6f 6e 2c 20 76 61 6c 75 65 29 20 46 52 4f 4d 20 73 74 64 69 6e 3b 0a description,.value).FROM.stdin;.
0f20 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 .....public..........yalp.....fa
0f40 6c 73 65 00 04 00 00 00 31 31 37 32 01 01 00 00 00 02 df 1d 00 00 00 00 00 00 00 ec 05 00 00 00 lse.....1172....................
0f60 01 00 00 00 00 01 00 00 00 30 00 05 00 00 00 31 37 33 31 33 00 06 00 00 00 4d 65 64 69 61 73 00 .........0.....17313.....Medias.
0f80 0a 00 00 00 54 41 42 4c 45 20 44 41 54 41 00 00 00 00 00 00 00 00 00 00 00 4f 00 00 00 43 4f 50 ....TABLE.DATA...........O...COP
0fa0 59 20 22 4d 65 64 69 61 73 22 20 28 69 64 2c 20 22 74 79 70 65 22 2c 20 70 61 74 68 2c 20 22 66 Y."Medias".(id,."type",.path,."f
0fc0 69 6c 65 4e 61 6d 65 22 2c 20 64 75 72 61 74 69 6f 6e 2c 20 6e 61 6d 65 2c 20 74 61 67 73 29 20 ileName",.duration,.name,.tags).
0fe0 46 52 4f 4d 20 73 74 64 69 6e 3b 0a 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 00 00 04 00 00 FROM.stdin;......public.........
1000 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 34 01 01 00 00 00 02 fc 1d .yalp.....false.....1174........
1020 00 00 00 00 00 00 00 ed 05 00 00 00 01 00 00 00 00 01 00 00 00 30 00 05 00 00 00 31 37 33 32 33 .....................0.....17323
1040 00 11 00 00 00 50 72 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 00 0a 00 00 00 54 41 42 4c 45 .....PropertyConnector.....TABLE
1060 20 44 41 54 41 00 00 00 00 00 00 00 00 00 00 00 5a 00 00 00 43 4f 50 59 20 22 50 72 6f 70 65 72 .DATA...........Z...COPY."Proper
1080 74 79 43 6f 6e 6e 65 63 74 6f 72 22 20 28 22 6d 65 64 69 61 49 64 22 2c 20 22 73 74 72 69 6e 67 tyConnector".("mediaId",."string
10a0 50 72 6f 70 65 72 74 79 49 64 22 2c 20 22 69 6e 74 50 72 6f 70 65 72 74 79 49 64 22 2c 20 69 64 PropertyId",."intPropertyId",.id
10c0 29 20 46 52 4f 4d 20 73 74 64 69 6e 3b 0a 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 00 00 04 ).FROM.stdin;......public.......
10e0 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 36 01 01 00 00 00 02 ...yalp.....false.....1176......
1100 79 1e 00 00 00 00 00 00 00 ea 05 00 00 00 01 00 00 00 00 01 00 00 00 30 00 05 00 00 00 31 37 32 y......................0.....172
1120 39 34 00 10 00 00 00 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 00 0a 00 00 00 54 41 42 4c 94.....StringProperties.....TABL
1140 45 20 44 41 54 41 00 00 00 00 00 00 00 00 00 00 00 3d 00 00 00 43 4f 50 59 20 22 53 74 72 69 6e E.DATA...........=...COPY."Strin
1160 67 50 72 6f 70 65 72 74 69 65 73 22 20 28 69 64 2c 20 64 65 73 63 72 69 70 74 69 6f 6e 2c 20 76 gProperties".(id,.description,.v
1180 61 6c 75 65 29 20 46 52 4f 4d 20 73 74 64 69 6e 3b 0a 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 alue).FROM.stdin;......public...
11a0 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 30 01 01 .......yalp.....false.....1170..
11c0 00 00 00 02 96 1e 00 00 00 00 00 00 00 e9 05 00 00 00 01 00 00 00 00 01 00 00 00 30 00 05 00 00 ...........................0....
11e0 00 31 37 32 36 39 00 05 00 00 00 55 73 65 72 73 00 0a 00 00 00 54 41 42 4c 45 20 44 41 54 41 00 .17269.....Users.....TABLE.DATA.
1200 00 00 00 00 00 00 00 00 00 00 39 00 00 00 43 4f 50 59 20 22 55 73 65 72 73 22 20 28 22 6c 65 76 ..........9...COPY."Users".("lev
1220 65 6c 22 2c 20 69 64 2c 20 6e 61 6d 65 2c 20 22 72 65 61 6c 4e 61 6d 65 22 29 20 46 52 4f 4d 20 el",.id,.name,."realName").FROM.
1240 73 74 64 69 6e 3b 0a 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 00 00 04 00 00 00 79 61 6c 70 stdin;......public..........yalp
1260 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 36 37 01 01 00 00 00 02 b3 1e 00 00 00 00 00 .....false.....1167.............
1280 00 00 ee 05 00 00 00 01 00 00 00 00 01 00 00 00 30 00 01 00 00 00 30 00 05 00 00 00 42 4c 4f 42 ................0.....0.....BLOB
12a0 53 00 05 00 00 00 42 4c 4f 42 53 00 00 00 00 00 00 00 00 00 00 01 01 00 00 00 01 01 00 00 00 01 S.....BLOBS.....................
12c0 01 00 00 00 00 00 00 00 00 00 05 00 00 00 66 61 6c 73 65 01 01 00 00 00 02 d0 1e 00 00 00 00 00 ..............false.............
12e0 00 00 e5 05 00 00 00 00 00 00 00 00 05 00 00 00 31 36 33 38 36 00 05 00 00 00 31 37 33 32 39 00 ................16386.....17329.
1300 0a 00 00 00 6b 65 79 5f 69 64 5f 63 6f 6e 00 0a 00 00 00 43 4f 4e 53 54 52 41 49 4e 54 00 55 00 ....key_id_con.....CONSTRAINT.U.
1320 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 22 50 72 6f 70 65 72 74 79 43 6f 6e 6e ..ALTER.TABLE.ONLY."PropertyConn
1340 65 63 74 6f 72 22 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 6b 65 79 5f 69 64 ector".....ADD.CONSTRAINT.key_id
1360 5f 63 6f 6e 20 50 52 49 4d 41 52 59 20 4b 45 59 20 28 69 64 29 3b 0a 00 48 00 00 00 41 4c 54 45 _con.PRIMARY.KEY.(id);..H...ALTE
1380 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 70 75 62 6c 69 63 2e 22 50 72 6f 70 65 72 74 79 43 6f 6e R.TABLE.ONLY.public."PropertyCon
13a0 6e 65 63 74 6f 72 22 20 44 52 4f 50 20 43 4f 4e 53 54 52 41 49 4e 54 20 6b 65 79 5f 69 64 5f 63 nector".DROP.CONSTRAINT.key_id_c
13c0 6f 6e 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 00 00 00 00 00 00 04 00 00 00 79 61 on;...........public..........ya
13e0 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 36 00 04 00 00 00 31 31 37 36 01 01 lp.....false.....1176.....1176..
1400 00 00 00 03 00 00 00 00 00 00 00 00 00 db 05 00 00 00 00 00 00 00 00 05 00 00 00 31 36 33 38 36 ...........................16386
1420 00 05 00 00 00 31 37 32 39 31 00 09 00 00 00 6b 65 79 5f 69 73 5f 69 64 00 0a 00 00 00 43 4f 4e .....17291.....key_is_id.....CON
1440 53 54 52 41 49 4e 54 00 48 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 22 55 73 STRAINT.H...ALTER.TABLE.ONLY."Us
1460 65 72 73 22 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 6b 65 79 5f 69 73 5f 69 ers".....ADD.CONSTRAINT.key_is_i
1480 64 20 50 52 49 4d 41 52 59 20 4b 45 59 20 28 69 64 29 3b 0a 00 3b 00 00 00 41 4c 54 45 52 20 54 d.PRIMARY.KEY.(id);..;...ALTER.T
14a0 41 42 4c 45 20 4f 4e 4c 59 20 70 75 62 6c 69 63 2e 22 55 73 65 72 73 22 20 44 52 4f 50 20 43 4f ABLE.ONLY.public."Users".DROP.CO
14c0 4e 53 54 52 41 49 4e 54 20 6b 65 79 5f 69 73 5f 69 64 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 NSTRAINT.key_is_id;...........pu
14e0 62 6c 69 63 00 00 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 blic..........yalp.....false....
1500 00 31 31 36 37 00 04 00 00 00 31 31 36 37 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 df 05 00 .1167.....1167..................
1520 00 00 00 00 00 00 00 05 00 00 00 31 36 33 38 36 00 05 00 00 00 31 37 32 39 38 00 0b 00 00 00 70 ...........16386.....17298.....p
1540 72 69 6d 5f 6b 65 79 5f 69 64 00 0a 00 00 00 43 4f 4e 53 54 52 41 49 4e 54 00 55 00 00 00 41 4c rim_key_id.....CONSTRAINT.U...AL
1560 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 22 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 TER.TABLE.ONLY."StringProperties
1580 22 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 70 72 69 6d 5f 6b 65 79 5f 69 64 ".....ADD.CONSTRAINT.prim_key_id
15a0 20 50 52 49 4d 41 52 59 20 4b 45 59 20 28 69 64 29 3b 0a 00 48 00 00 00 41 4c 54 45 52 20 54 41 .PRIMARY.KEY.(id);..H...ALTER.TA
15c0 42 4c 45 20 4f 4e 4c 59 20 70 75 62 6c 69 63 2e 22 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 BLE.ONLY.public."StringPropertie
15e0 73 22 20 44 52 4f 50 20 43 4f 4e 53 54 52 41 49 4e 54 20 70 72 69 6d 5f 6b 65 79 5f 69 64 3b 0a s".DROP.CONSTRAINT.prim_key_id;.
1600 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 00 00 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 ..........public..........yalp..
1620 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 30 00 04 00 00 00 31 31 37 30 01 01 00 00 00 03 ...false.....1170.....1170......
1640 00 00 00 00 00 00 00 00 00 e1 05 00 00 00 00 00 00 00 00 05 00 00 00 31 36 33 38 36 00 05 00 00 .......................16386....
1660 00 31 37 33 31 30 00 0f 00 00 00 70 72 69 6d 5f 6b 65 79 5f 69 6e 74 5f 69 64 00 0a 00 00 00 43 .17310.....prim_key_int_id.....C
1680 4f 4e 53 54 52 41 49 4e 54 00 56 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 22 ONSTRAINT.V...ALTER.TABLE.ONLY."
16a0 49 6e 74 50 72 6f 70 65 72 74 69 65 73 22 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e IntProperties".....ADD.CONSTRAIN
16c0 54 20 70 72 69 6d 5f 6b 65 79 5f 69 6e 74 5f 69 64 20 50 52 49 4d 41 52 59 20 4b 45 59 20 28 69 T.prim_key_int_id.PRIMARY.KEY.(i
16e0 64 29 3b 0a 00 49 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 70 75 62 6c 69 63 d);..I...ALTER.TABLE.ONLY.public
1700 2e 22 49 6e 74 50 72 6f 70 65 72 74 69 65 73 22 20 44 52 4f 50 20 43 4f 4e 53 54 52 41 49 4e 54 ."IntProperties".DROP.CONSTRAINT
1720 20 70 72 69 6d 5f 6b 65 79 5f 69 6e 74 5f 69 64 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c .prim_key_int_id;...........publ
1740 69 63 00 00 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 ic..........yalp.....false.....1
1760 31 37 32 00 04 00 00 00 31 31 37 32 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 e3 05 00 00 00 172.....1172....................
1780 00 00 00 00 00 05 00 00 00 31 36 33 38 36 00 05 00 00 00 31 37 33 32 30 00 0d 00 00 00 70 72 69 .........16386.....17320.....pri
17a0 6d 5f 6b 65 79 5f 6d 5f 69 64 00 0a 00 00 00 43 4f 4e 53 54 52 41 49 4e 54 00 4d 00 00 00 41 4c m_key_m_id.....CONSTRAINT.M...AL
17c0 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 22 4d 65 64 69 61 73 22 0a 20 20 20 20 41 44 44 20 TER.TABLE.ONLY."Medias".....ADD.
17e0 43 4f 4e 53 54 52 41 49 4e 54 20 70 72 69 6d 5f 6b 65 79 5f 6d 5f 69 64 20 50 52 49 4d 41 52 59 CONSTRAINT.prim_key_m_id.PRIMARY
1800 20 4b 45 59 20 28 69 64 29 3b 0a 00 40 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 .KEY.(id);..@...ALTER.TABLE.ONLY
1820 20 70 75 62 6c 69 63 2e 22 4d 65 64 69 61 73 22 20 44 52 4f 50 20 43 4f 4e 53 54 52 41 49 4e 54 .public."Medias".DROP.CONSTRAINT
1840 20 70 72 69 6d 5f 6b 65 79 5f 6d 5f 69 64 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 .prim_key_m_id;...........public
1860 00 00 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 ..........yalp.....false.....117
1880 34 00 04 00 00 00 31 31 37 34 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 dd 05 00 00 00 00 00 4.....1174......................
18a0 00 00 00 05 00 00 00 31 36 33 38 36 00 05 00 00 00 31 37 34 30 35 00 12 00 00 00 75 73 65 72 6e .......16386.....17405.....usern
18c0 61 6d 65 5f 69 73 5f 75 6e 69 71 75 65 00 0a 00 00 00 43 4f 4e 53 54 52 41 49 4e 54 00 4e 00 00 ame_is_unique.....CONSTRAINT.N..
18e0 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 22 55 73 65 72 73 22 0a 20 20 20 20 41 44 .ALTER.TABLE.ONLY."Users".....AD
1900 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 75 73 65 72 6e 61 6d 65 5f 69 73 5f 75 6e 69 71 75 65 20 D.CONSTRAINT.username_is_unique.
1920 55 4e 49 51 55 45 20 28 6e 61 6d 65 29 3b 0a 00 44 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 UNIQUE.(name);..D...ALTER.TABLE.
1940 4f 4e 4c 59 20 70 75 62 6c 69 63 2e 22 55 73 65 72 73 22 20 44 52 4f 50 20 43 4f 4e 53 54 52 41 ONLY.public."Users".DROP.CONSTRA
1960 49 4e 54 20 75 73 65 72 6e 61 6d 65 5f 69 73 5f 75 6e 69 71 75 65 3b 0a 01 01 00 00 00 00 06 00 INT.username_is_unique;.........
1980 00 00 70 75 62 6c 69 63 00 00 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 ..public..........yalp.....false
19a0 00 04 00 00 00 31 31 36 37 00 04 00 00 00 31 31 36 37 01 01 00 00 00 03 00 00 00 00 00 00 00 00 .....1167.....1167..............
19c0 00 e7 05 00 00 00 00 00 00 00 00 05 00 00 00 31 36 33 38 36 00 05 00 00 00 31 37 33 33 34 00 08 ...............16386.....17334..
19e0 00 00 00 69 6e 74 5f 70 72 6f 70 00 0d 00 00 00 46 4b 20 43 4f 4e 53 54 52 41 49 4e 54 00 7f 00 ...int_prop.....FK.CONSTRAINT...
1a00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 22 50 72 6f 70 65 72 74 79 43 6f 6e 6e ..ALTER.TABLE.ONLY."PropertyConn
1a20 65 63 74 6f 72 22 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 69 6e 74 5f 70 72 ector".....ADD.CONSTRAINT.int_pr
1a40 6f 70 20 46 4f 52 45 49 47 4e 20 4b 45 59 20 28 22 69 6e 74 50 72 6f 70 65 72 74 79 49 64 22 29 op.FOREIGN.KEY.("intPropertyId")
1a60 20 52 45 46 45 52 45 4e 43 45 53 20 22 49 6e 74 50 72 6f 70 65 72 74 69 65 73 22 28 69 64 29 3b .REFERENCES."IntProperties"(id);
1a80 0a 00 46 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 70 75 62 6c 69 63 2e 22 50 ..F...ALTER.TABLE.ONLY.public."P
1aa0 72 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 22 20 44 52 4f 50 20 43 4f 4e 53 54 52 41 49 4e ropertyConnector".DROP.CONSTRAIN
1ac0 54 20 69 6e 74 5f 70 72 6f 70 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 T.int_prop;...........public....
1ae0 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 36 00 04 00 ......yalp.....false.....1176...
1b00 00 00 31 31 37 32 00 04 00 00 00 31 35 30 34 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 e6 05 ..1172.....1504.................
1b20 00 00 00 00 00 00 00 00 05 00 00 00 31 36 33 38 36 00 05 00 00 00 31 37 33 33 30 00 0a 00 00 00 ............16386.....17330.....
1b40 6d 65 64 69 61 5f 70 72 6f 70 00 0d 00 00 00 46 4b 20 43 4f 4e 53 54 52 41 49 4e 54 00 74 00 00 media_prop.....FK.CONSTRAINT.t..
1b60 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 22 50 72 6f 70 65 72 74 79 43 6f 6e 6e 65 .ALTER.TABLE.ONLY."PropertyConne
1b80 63 74 6f 72 22 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 6d 65 64 69 61 5f 70 ctor".....ADD.CONSTRAINT.media_p
1ba0 72 6f 70 20 46 4f 52 45 49 47 4e 20 4b 45 59 20 28 22 6d 65 64 69 61 49 64 22 29 20 52 45 46 45 rop.FOREIGN.KEY.("mediaId").REFE
1bc0 52 45 4e 43 45 53 20 22 4d 65 64 69 61 73 22 28 69 64 29 3b 0a 00 48 00 00 00 41 4c 54 45 52 20 RENCES."Medias"(id);..H...ALTER.
1be0 54 41 42 4c 45 20 4f 4e 4c 59 20 70 75 62 6c 69 63 2e 22 50 72 6f 70 65 72 74 79 43 6f 6e 6e 65 TABLE.ONLY.public."PropertyConne
1c00 63 74 6f 72 22 20 44 52 4f 50 20 43 4f 4e 53 54 52 41 49 4e 54 20 6d 65 64 69 61 5f 70 72 6f 70 ctor".DROP.CONSTRAINT.media_prop
1c20 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 00 00 04 00 00 00 79 61 6c 70 ;...........public..........yalp
1c40 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 36 00 04 00 00 00 31 31 37 34 00 04 00 00 .....false.....1176.....1174....
1c60 00 31 35 30 36 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 e8 05 00 00 00 00 00 00 00 00 05 00 .1506...........................
1c80 00 00 31 36 33 38 36 00 05 00 00 00 31 37 33 33 38 00 0b 00 00 00 73 74 72 69 6e 67 5f 70 72 6f ..16386.....17338.....string_pro
1ca0 70 00 0d 00 00 00 46 4b 20 43 4f 4e 53 54 52 41 49 4e 54 00 88 00 00 00 41 4c 54 45 52 20 54 41 p.....FK.CONSTRAINT.....ALTER.TA
1cc0 42 4c 45 20 4f 4e 4c 59 20 22 50 72 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 22 0a 20 20 20 BLE.ONLY."PropertyConnector"....
1ce0 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 73 74 72 69 6e 67 5f 70 72 6f 70 20 46 4f 52 45 .ADD.CONSTRAINT.string_prop.FORE
1d00 49 47 4e 20 4b 45 59 20 28 22 73 74 72 69 6e 67 50 72 6f 70 65 72 74 79 49 64 22 29 20 52 45 46 IGN.KEY.("stringPropertyId").REF
1d20 45 52 45 4e 43 45 53 20 22 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 22 28 69 64 29 3b 0a ERENCES."StringProperties"(id);.
1d40 00 49 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 70 75 62 6c 69 63 2e 22 50 72 .I...ALTER.TABLE.ONLY.public."Pr
1d60 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 22 20 44 52 4f 50 20 43 4f 4e 53 54 52 41 49 4e 54 opertyConnector".DROP.CONSTRAINT
1d80 20 73 74 72 69 6e 67 5f 70 72 6f 70 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 01 01 .string_prop;...........public..
1da0 00 00 00 00 04 00 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 36 00 ........yalp.....false.....1176.
1dc0 04 00 00 00 31 31 37 30 00 04 00 00 00 31 35 30 32 01 01 00 00 00 03 00 00 00 00 00 00 00 00 01 ....1170.....1502...............
1de0 00 eb 05 00 00 00 0d 00 00 00 78 9c 8b d1 e3 e2 e2 02 00 02 c5 00 a9 00 00 00 00 00 01 00 ec 05 ..........x.....................
1e00 00 00 00 6d 00 00 00 78 9c 65 cc 4b 0e c2 30 0c 45 d1 f1 cb 2a bc 80 d2 8a a0 4c ba 16 26 51 6b ...m...x.e.K..0.E...*.....L..&Qk
1e20 6a a3 c4 a0 fc ba 7d 60 cc f0 4a 47 f7 8a 81 45 5e 99 97 1c ad 37 34 ae 6d 8e 43 11 d6 10 20 5d j.....}`..JG...E^....74.m.C....]
1e40 3a 44 45 9d 47 fd 77 f9 7d 83 5f bd c7 26 71 b0 1d 5c e8 42 cf 6e 07 75 db e9 51 78 13 24 1d 3c :DE.G.w.}._..&q..\.B.n.u..Qx.$.<
1e60 91 68 6a 6c f5 64 4d 5c 7e f9 5d de 67 e7 dc 07 38 f4 28 ca 00 00 00 00 00 01 00 ed 05 00 00 00 .hjl.dM\~.].g...8.(.............
1e80 0d 00 00 00 78 9c 8b d1 e3 e2 e2 02 00 02 c5 00 a9 00 00 00 00 00 01 00 ea 05 00 00 00 0d 00 00 ....x...........................
1ea0 00 78 9c 8b d1 e3 e2 e2 02 00 02 c5 00 a9 00 00 00 00 00 01 00 e9 05 00 00 00 0d 00 00 00 78 9c .x............................x.
1ec0 8b d1 e3 e2 e2 02 00 02 c5 00 a9 00 00 00 00 00 03 00 ee 05 00 00 00 00 00 00 00 ...........................
generated by cgit v1.2.3 (git 2.46.0) at 2025-12-09 18:36:00 +0000