summaryrefslogtreecommitdiff
path: root/src/YalpInputs/YalpPGSqlInput/db-design-sql.backup
blob: 8dc69e0e1aaa379569037158dd2879437fc7ca41 (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 2c 0a 09 09 70 61 73 73 77 64 20 74 65 78 74 20 4e 4f 54 20 4e 55 4c 4c 0a 29 3b 0a 00 1b 00 00 ,...passwd.text.NOT.NULL.);.....
0c80 00 44 52 4f 50 20 54 41 42 4c 45 20 70 75 62 6c 69 63 2e 22 55 73 65 72 73 22 3b 0a 01 01 00 00 .DROP.TABLE.public."Users";.....
0ca0 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 00 00 00 66 ......public..........yalp.....f
0cc0 61 6c 73 65 00 04 00 00 00 31 34 39 30 00 04 00 00 00 31 34 39 31 00 01 00 00 00 35 01 01 00 00 alse.....1490.....1491.....5....
0ce0 00 03 00 00 00 00 00 00 00 00 00 f6 05 00 00 00 00 00 00 00 00 01 00 00 00 30 00 01 00 00 00 30 .........................0.....0
0d00 00 0c 00 00 00 55 73 65 72 73 5f 69 64 5f 73 65 71 00 0c 00 00 00 53 45 51 55 45 4e 43 45 20 53 .....Users_id_seq.....SEQUENCE.S
0d20 45 54 00 58 00 00 00 53 45 4c 45 43 54 20 70 67 5f 63 61 74 61 6c 6f 67 2e 73 65 74 76 61 6c 28 ET.X...SELECT.pg_catalog.setval(
0d40 70 67 5f 63 61 74 61 6c 6f 67 2e 70 67 5f 67 65 74 5f 73 65 72 69 61 6c 5f 73 65 71 75 65 6e 63 pg_catalog.pg_get_serial_sequenc
0d60 65 28 27 22 55 73 65 72 73 22 27 2c 20 27 69 64 27 29 2c 20 31 2c 20 66 61 6c 73 65 29 3b 0a 00 e('"Users"',.'id'),.1,.false);..
0d80 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 79 61 ..............public..........ya
0da0 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 36 38 01 01 00 00 00 03 00 00 00 00 00 lp.....false.....1168...........
0dc0 00 00 00 00 f7 05 00 00 00 00 00 00 00 00 01 00 00 00 30 00 01 00 00 00 30 00 18 00 00 00 70 72 ..................0.....0.....pr
0de0 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 5f 69 64 5f 73 65 71 00 0c 00 00 00 53 45 51 55 45 opertyConnector_id_seq.....SEQUE
0e00 4e 43 45 20 53 45 54 00 64 00 00 00 53 45 4c 45 43 54 20 70 67 5f 63 61 74 61 6c 6f 67 2e 73 65 NCE.SET.d...SELECT.pg_catalog.se
0e20 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 5f 73 65 tval(pg_catalog.pg_get_serial_se
0e40 71 75 65 6e 63 65 28 27 22 50 72 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 22 27 2c 20 27 69 quence('"PropertyConnector"',.'i
0e60 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 06 00 00 00 70 d'),.1,.false);................p
0e80 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 73 65 00 04 00 ublic..........yalp.....false...
0ea0 00 00 31 31 37 35 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 eb 05 00 00 00 01 00 00 00 00 01 ..1175..........................
0ec0 00 00 00 30 00 05 00 00 00 31 37 33 30 36 00 0d 00 00 00 49 6e 74 50 72 6f 70 65 72 74 69 65 73 ...0.....17306.....IntProperties
0ee0 00 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 3a 00 00 00 43 4f .....TABLE.DATA...........:...CO
0f00 50 59 20 22 49 6e 74 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 PY."IntProperties".(id,.descript
0f20 69 6f 6e 2c 20 76 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 ion,.value).FROM.stdin;......pub
0f40 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 00 lic..........yalp.....false.....
0f60 31 31 37 32 01 01 00 00 00 02 df 1d 00 00 00 00 00 00 00 ec 05 00 00 00 01 00 00 00 00 01 00 00 1172............................
0f80 00 30 00 05 00 00 00 31 37 33 31 33 00 06 00 00 00 4d 65 64 69 61 73 00 0a 00 00 00 54 41 42 4c .0.....17313.....Medias.....TABL
0fa0 45 20 44 41 54 41 00 00 00 00 00 00 00 00 00 00 00 4f 00 00 00 43 4f 50 59 20 22 4d 65 64 69 61 E.DATA...........O...COPY."Media
0fc0 73 22 20 28 69 64 2c 20 22 74 79 70 65 22 2c 20 70 61 74 68 2c 20 22 66 69 6c 65 4e 61 6d 65 22 s".(id,."type",.path,."fileName"
0fe0 2c 20 64 75 72 61 74 69 6f 6e 2c 20 6e 61 6d 65 2c 20 74 61 67 73 29 20 46 52 4f 4d 20 73 74 64 ,.duration,.name,.tags).FROM.std
1000 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 00 05 00 in;......public..........yalp...
1020 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 34 01 01 00 00 00 02 fc 1d 00 00 00 00 00 00 00 ed ..false.....1174................
1040 05 00 00 00 01 00 00 00 00 01 00 00 00 30 00 05 00 00 00 31 37 33 32 33 00 11 00 00 00 50 72 6f .............0.....17323.....Pro
1060 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 00 0a 00 00 00 54 41 42 4c 45 20 44 41 54 41 00 00 00 pertyConnector.....TABLE.DATA...
1080 00 00 00 00 00 00 00 00 5a 00 00 00 43 4f 50 59 20 22 50 72 6f 70 65 72 74 79 43 6f 6e 6e 65 63 ........Z...COPY."PropertyConnec
10a0 74 6f 72 22 20 28 22 6d 65 64 69 61 49 64 22 2c 20 22 73 74 72 69 6e 67 50 72 6f 70 65 72 74 79 tor".("mediaId",."stringProperty
10c0 49 64 22 2c 20 22 69 6e 74 50 72 6f 70 65 72 74 79 49 64 22 2c 20 69 64 29 20 46 52 4f 4d 20 73 Id",."intPropertyId",.id).FROM.s
10e0 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 00 tdin;......public..........yalp.
1100 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 36 01 01 00 00 00 02 79 1e 00 00 00 00 00 00 ....false.....1176......y.......
1120 00 ea 05 00 00 00 01 00 00 00 00 01 00 00 00 30 00 05 00 00 00 31 37 32 39 34 00 10 00 00 00 53 ...............0.....17294.....S
1140 74 72 69 6e 67 50 72 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 tringProperties.....TABLE.DATA..
1160 00 00 00 00 00 00 00 00 00 3d 00 00 00 43 4f 50 59 20 22 53 74 72 69 6e 67 50 72 6f 70 65 72 74 .........=...COPY."StringPropert
1180 69 65 73 22 20 28 69 64 2c 20 64 65 73 63 72 69 70 74 69 6f 6e 2c 20 76 61 6c 75 65 29 20 46 52 ies".(id,.description,.value).FR
11a0 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 00 79 OM.stdin;......public..........y
11c0 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 30 01 01 00 00 00 02 96 1e 00 00 alp.....false.....1170..........
11e0 00 00 00 00 00 e9 05 00 00 00 01 00 00 00 00 01 00 00 00 30 00 05 00 00 00 31 37 32 36 39 00 05 ...................0.....17269..
1200 00 00 00 55 73 65 72 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 ...Users.....TABLE.DATA.........
1220 00 00 39 00 00 00 43 4f 50 59 20 22 55 73 65 72 73 22 20 28 22 6c 65 76 65 6c 22 2c 20 69 64 2c ..9...COPY."Users".("level",.id,
1240 20 6e 61 6d 65 2c 20 22 72 65 61 6c 4e 61 6d 65 22 29 20 46 52 4f 4d 20 73 74 64 69 6e 3b 0a 00 .name,."realName").FROM.stdin;..
1260 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
1280 73 65 00 04 00 00 00 31 31 36 37 01 01 00 00 00 02 b3 1e 00 00 00 00 00 00 00 ee 05 00 00 00 01 se.....1167.....................
12a0 00 00 00 00 01 00 00 00 30 00 01 00 00 00 30 00 05 00 00 00 42 4c 4f 42 53 00 05 00 00 00 42 4c ........0.....0.....BLOBS.....BL
12c0 4f 42 53 00 00 00 00 00 00 00 00 00 00 01 01 00 00 00 01 01 00 00 00 01 01 00 00 00 00 00 00 00 OBS.............................
12e0 00 00 05 00 00 00 66 61 6c 73 65 01 01 00 00 00 02 d0 1e 00 00 00 00 00 00 00 e5 05 00 00 00 00 ......false.....................
1300 00 00 00 00 05 00 00 00 31 36 33 38 36 00 05 00 00 00 31 37 33 32 39 00 0a 00 00 00 6b 65 79 5f ........16386.....17329.....key_
1320 69 64 5f 63 6f 6e 00 0a 00 00 00 43 4f 4e 53 54 52 41 49 4e 54 00 55 00 00 00 41 4c 54 45 52 20 id_con.....CONSTRAINT.U...ALTER.
1340 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 63 74 6f 72 22 0a 20 TABLE.ONLY."PropertyConnector"..
1360 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 6b 65 79 5f 69 64 5f 63 6f 6e 20 50 52 49 ...ADD.CONSTRAINT.key_id_con.PRI
1380 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 42 4c 45 20 MARY.KEY.(id);..H...ALTER.TABLE.
13a0 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 63 74 6f 72 22 20 ONLY.public."PropertyConnector".
13c0 44 52 4f 50 20 43 4f 4e 53 54 52 41 49 4e 54 20 6b 65 79 5f 69 64 5f 63 6f 6e 3b 0a 01 01 00 00 DROP.CONSTRAINT.key_id_con;.....
13e0 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 00 00 00 66 ......public..........yalp.....f
1400 61 6c 73 65 00 04 00 00 00 31 31 37 36 00 04 00 00 00 31 31 37 36 01 01 00 00 00 03 00 00 00 00 alse.....1176.....1176..........
1420 00 00 00 00 00 db 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 32 ...................16386.....172
1440 39 31 00 09 00 00 00 6b 65 79 5f 69 73 5f 69 64 00 0a 00 00 00 43 4f 4e 53 54 52 41 49 4e 54 00 91.....key_is_id.....CONSTRAINT.
1460 48 00 00 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 H...ALTER.TABLE.ONLY."Users"....
1480 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 6b 65 79 5f 69 73 5f 69 64 20 50 52 49 4d 41 52 .ADD.CONSTRAINT.key_is_id.PRIMAR
14a0 59 20 4b 45 59 20 28 69 64 29 3b 0a 00 3b 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c Y.KEY.(id);..;...ALTER.TABLE.ONL
14c0 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 49 4e 54 Y.public."Users".DROP.CONSTRAINT
14e0 20 6b 65 79 5f 69 73 5f 69 64 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 00 00 00 00 .key_is_id;...........public....
1500 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 37 00 04 00 ......yalp.....false.....1167...
1520 00 00 31 31 36 37 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 df 05 00 00 00 00 00 00 00 00 05 ..1167..........................
1540 00 00 00 31 36 33 38 36 00 05 00 00 00 31 37 32 39 38 00 0b 00 00 00 70 72 69 6d 5f 6b 65 79 5f ...16386.....17298.....prim_key_
1560 69 64 00 0a 00 00 00 43 4f 4e 53 54 52 41 49 4e 54 00 55 00 00 00 41 4c 54 45 52 20 54 41 42 4c id.....CONSTRAINT.U...ALTER.TABL
1580 45 20 4f 4e 4c 59 20 22 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 22 0a 20 20 20 20 41 44 E.ONLY."StringProperties".....AD
15a0 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 70 72 69 6d 5f 6b 65 79 5f 69 64 20 50 52 49 4d 41 52 59 D.CONSTRAINT.prim_key_id.PRIMARY
15c0 20 4b 45 59 20 28 69 64 29 3b 0a 00 48 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 .KEY.(id);..H...ALTER.TABLE.ONLY
15e0 20 70 75 62 6c 69 63 2e 22 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 22 20 44 52 4f 50 20 .public."StringProperties".DROP.
1600 43 4f 4e 53 54 52 41 49 4e 54 20 70 72 69 6d 5f 6b 65 79 5f 69 64 3b 0a 01 01 00 00 00 00 06 00 CONSTRAINT.prim_key_id;.........
1620 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
1640 00 04 00 00 00 31 31 37 30 00 04 00 00 00 31 31 37 30 01 01 00 00 00 03 00 00 00 00 00 00 00 00 .....1170.....1170..............
1660 00 e1 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 31 30 00 0f ...............16386.....17310..
1680 00 00 00 70 72 69 6d 5f 6b 65 79 5f 69 6e 74 5f 69 64 00 0a 00 00 00 43 4f 4e 53 54 52 41 49 4e ...prim_key_int_id.....CONSTRAIN
16a0 54 00 56 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 22 49 6e 74 50 72 6f 70 65 T.V...ALTER.TABLE.ONLY."IntPrope
16c0 72 74 69 65 73 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 rties".....ADD.CONSTRAINT.prim_k
16e0 65 79 5f 69 6e 74 5f 69 64 20 50 52 49 4d 41 52 59 20 4b 45 59 20 28 69 64 29 3b 0a 00 49 00 00 ey_int_id.PRIMARY.KEY.(id);..I..
1700 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 49 6e 74 50 72 6f .ALTER.TABLE.ONLY.public."IntPro
1720 70 65 72 74 69 65 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 perties".DROP.CONSTRAINT.prim_ke
1740 79 5f 69 6e 74 5f 69 64 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 00 00 00 00 00 00 y_int_id;...........public......
1760 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 32 00 04 00 00 00 ....yalp.....false.....1172.....
1780 31 31 37 32 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 e3 05 00 00 00 00 00 00 00 00 05 00 00 1172............................
17a0 00 31 36 33 38 36 00 05 00 00 00 31 37 33 32 30 00 0d 00 00 00 70 72 69 6d 5f 6b 65 79 5f 6d 5f .16386.....17320.....prim_key_m_
17c0 69 64 00 0a 00 00 00 43 4f 4e 53 54 52 41 49 4e 54 00 4d 00 00 00 41 4c 54 45 52 20 54 41 42 4c id.....CONSTRAINT.M...ALTER.TABL
17e0 45 20 4f 4e 4c 59 20 22 4d 65 64 69 61 73 22 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 E.ONLY."Medias".....ADD.CONSTRAI
1800 4e 54 20 70 72 69 6d 5f 6b 65 79 5f 6d 5f 69 64 20 50 52 49 4d 41 52 59 20 4b 45 59 20 28 69 64 NT.prim_key_m_id.PRIMARY.KEY.(id
1820 29 3b 0a 00 40 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 );..@...ALTER.TABLE.ONLY.public.
1840 22 4d 65 64 69 61 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 "Medias".DROP.CONSTRAINT.prim_ke
1860 79 5f 6d 5f 69 64 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 y_m_id;...........public........
1880 00 00 79 61 6c 70 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 34 00 04 00 00 00 31 31 ..yalp.....false.....1174.....11
18a0 37 34 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 dd 05 00 00 00 00 00 00 00 00 05 00 00 00 31 74.............................1
18c0 36 33 38 36 00 05 00 00 00 31 37 34 30 35 00 12 00 00 00 75 73 65 72 6e 61 6d 65 5f 69 73 5f 75 6386.....17405.....username_is_u
18e0 6e 69 71 75 65 00 0a 00 00 00 43 4f 4e 53 54 52 41 49 4e 54 00 4e 00 00 00 41 4c 54 45 52 20 54 nique.....CONSTRAINT.N...ALTER.T
1900 41 42 4c 45 20 4f 4e 4c 59 20 22 55 73 65 72 73 22 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 ABLE.ONLY."Users".....ADD.CONSTR
1920 41 49 4e 54 20 75 73 65 72 6e 61 6d 65 5f 69 73 5f 75 6e 69 71 75 65 20 55 4e 49 51 55 45 20 28 AINT.username_is_unique.UNIQUE.(
1940 6e 61 6d 65 29 3b 0a 00 44 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 70 75 62 name);..D...ALTER.TABLE.ONLY.pub
1960 6c 69 63 2e 22 55 73 65 72 73 22 20 44 52 4f 50 20 43 4f 4e 53 54 52 41 49 4e 54 20 75 73 65 72 lic."Users".DROP.CONSTRAINT.user
1980 6e 61 6d 65 5f 69 73 5f 75 6e 69 71 75 65 3b 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 name_is_unique;...........public
19a0 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 36 ..........yalp.....false.....116
19c0 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 e7 05 00 00 00 00 00 7.....1167......................
19e0 00 00 00 05 00 00 00 31 36 33 38 36 00 05 00 00 00 31 37 33 33 34 00 08 00 00 00 69 6e 74 5f 70 .......16386.....17334.....int_p
1a00 72 6f 70 00 0d 00 00 00 46 4b 20 43 4f 4e 53 54 52 41 49 4e 54 00 7f 00 00 00 41 4c 54 45 52 20 rop.....FK.CONSTRAINT.....ALTER.
1a20 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 63 74 6f 72 22 0a 20 TABLE.ONLY."PropertyConnector"..
1a40 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 69 6e 74 5f 70 72 6f 70 20 46 4f 52 45 49 ...ADD.CONSTRAINT.int_prop.FOREI
1a60 47 4e 20 4b 45 59 20 28 22 69 6e 74 50 72 6f 70 65 72 74 79 49 64 22 29 20 52 45 46 45 52 45 4e GN.KEY.("intPropertyId").REFEREN
1a80 43 45 53 20 22 49 6e 74 50 72 6f 70 65 72 74 69 65 73 22 28 69 64 29 3b 0a 00 46 00 00 00 41 4c CES."IntProperties"(id);..F...AL
1aa0 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 6f 70 65 72 74 79 43 TER.TABLE.ONLY.public."PropertyC
1ac0 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 20 69 6e 74 5f 70 72 onnector".DROP.CONSTRAINT.int_pr
1ae0 6f 70 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 op;...........public..........ya
1b00 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 32 00 04 lp.....false.....1176.....1172..
1b20 00 00 00 31 35 30 34 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 e6 05 00 00 00 00 00 00 00 00 ...1504.........................
1b40 05 00 00 00 31 36 33 38 36 00 05 00 00 00 31 37 33 33 30 00 0a 00 00 00 6d 65 64 69 61 5f 70 72 ....16386.....17330.....media_pr
1b60 6f 70 00 0d 00 00 00 46 4b 20 43 4f 4e 53 54 52 41 49 4e 54 00 74 00 00 00 41 4c 54 45 52 20 54 op.....FK.CONSTRAINT.t...ALTER.T
1b80 41 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 ABLE.ONLY."PropertyConnector"...
1ba0 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 6d 65 64 69 61 5f 70 72 6f 70 20 46 4f 52 45 ..ADD.CONSTRAINT.media_prop.FORE
1bc0 49 47 4e 20 4b 45 59 20 28 22 6d 65 64 69 61 49 64 22 29 20 52 45 46 45 52 45 4e 43 45 53 20 22 IGN.KEY.("mediaId").REFERENCES."
1be0 4d 65 64 69 61 73 22 28 69 64 29 3b 0a 00 48 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e Medias"(id);..H...ALTER.TABLE.ON
1c00 4c 59 20 70 75 62 6c 69 63 2e 22 50 72 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 22 20 44 52 LY.public."PropertyConnector".DR
1c20 4f 50 20 43 4f 4e 53 54 52 41 49 4e 54 20 6d 65 64 69 61 5f 70 72 6f 70 3b 0a 01 01 00 00 00 00 OP.CONSTRAINT.media_prop;.......
1c40 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
1c60 73 65 00 04 00 00 00 31 31 37 36 00 04 00 00 00 31 31 37 34 00 04 00 00 00 31 35 30 36 01 01 00 se.....1176.....1174.....1506...
1c80 00 00 03 00 00 00 00 00 00 00 00 00 e8 05 00 00 00 00 00 00 00 00 05 00 00 00 31 36 33 38 36 00 ..........................16386.
1ca0 05 00 00 00 31 37 33 33 38 00 0b 00 00 00 73 74 72 69 6e 67 5f 70 72 6f 70 00 0d 00 00 00 46 4b ....17338.....string_prop.....FK
1cc0 20 43 4f 4e 53 54 52 41 49 4e 54 00 88 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 .CONSTRAINT.....ALTER.TABLE.ONLY
1ce0 20 22 50 72 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 22 0a 20 20 20 20 41 44 44 20 43 4f 4e ."PropertyConnector".....ADD.CON
1d00 53 54 52 41 49 4e 54 20 73 74 72 69 6e 67 5f 70 72 6f 70 20 46 4f 52 45 49 47 4e 20 4b 45 59 20 STRAINT.string_prop.FOREIGN.KEY.
1d20 28 22 73 74 72 69 6e 67 50 72 6f 70 65 72 74 79 49 64 22 29 20 52 45 46 45 52 45 4e 43 45 53 20 ("stringPropertyId").REFERENCES.
1d40 22 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 22 28 69 64 29 3b 0a 00 49 00 00 00 41 4c 54 "StringProperties"(id);..I...ALT
1d60 45 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 ER.TABLE.ONLY.public."PropertyCo
1d80 6e 6e 65 63 74 6f 72 22 20 44 52 4f 50 20 43 4f 4e 53 54 52 41 49 4e 54 20 73 74 72 69 6e 67 5f nnector".DROP.CONSTRAINT.string_
1da0 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 00 00 04 00 00 00 prop;...........public..........
1dc0 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 00 00 31 31 37 30 yalp.....false.....1176.....1170
1de0 00 04 00 00 00 31 35 30 32 01 01 00 00 00 03 00 00 00 00 00 00 00 00 01 00 eb 05 00 00 00 0d 00 .....1502.......................
1e00 00 00 78 9c 8b d1 e3 e2 e2 02 00 02 c5 00 a9 00 00 00 00 00 01 00 ec 05 00 00 00 6d 00 00 00 78 ..x........................m...x
1e20 9c 65 cc 4b 0e c2 30 0c 45 d1 f1 cb 2a bc 80 d2 8a a0 4c ba 16 26 51 6b 6a a3 c4 a0 fc ba 7d 60 .e.K..0.E...*.....L..&Qkj.....}`
1e40 cc f0 4a 47 f7 8a 81 45 5e 99 97 1c ad 37 34 ae 6d 8e 43 11 d6 10 20 5d 3a 44 45 9d 47 fd 77 f9 ..JG...E^....74.m.C....]:DE.G.w.
1e60 7d 83 5f bd c7 26 71 b0 1d 5c e8 42 cf 6e 07 75 db e9 51 78 13 24 1d 3c 91 68 6a 6c f5 64 4d 5c }._..&q..\.B.n.u..Qx.$.<.hjl.dM\
1e80 7e f9 5d de 67 e7 dc 07 38 f4 28 ca 00 00 00 00 00 01 00 ed 05 00 00 00 0d 00 00 00 78 9c 8b d1 ~.].g...8.(.................x...
1ea0 e3 e2 e2 02 00 02 c5 00 a9 00 00 00 00 00 01 00 ea 05 00 00 00 0d 00 00 00 78 9c 8b d1 e3 e2 e2 .........................x......
1ec0 02 00 02 c5 00 a9 00 00 00 00 00 01 00 e9 05 00 00 00 0d 00 00 00 78 9c 8b d1 e3 e2 e2 02 00 02 ......................x.........
1ee0 c5 00 a9 00 00 00 00 00 03 00 ee 05 00 00 00 00 00 00 00 0a ....................