summaryrefslogtreecommitdiff
path: root/src/YalpInputs/YalpPGSqlInput/db-design-sql.backup
blob: d6b273dbb90323e9d15d46a5f6d00e092a626023 (plain)
ofshex dumpascii
0000 ef bb bf 50 47 44 4d 50 01 0d 0a 00 04 08 01 01 01 00 00 00 00 34 00 00 00 00 2c 00 00 00 00 16 ...PGDMP.............4....,.....
0020 00 00 00 00 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 ..............l.............yalp
0040 00 06 00 00 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 .....8.0.13.....8.0.13..........
0060 00 00 00 00 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 ..........0.....0.....ENCODING..
0080 00 00 00 45 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 ...ENCODING.!...SET.client_encod
00a0 69 6e 67 20 3d 20 27 55 4e 49 43 4f 44 45 27 3b 0d 0a 00 00 00 00 00 01 01 00 00 00 01 01 00 00 ing.=.'UNICODE';................
00c0 00 01 01 00 00 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 ................false...........
00e0 00 00 00 00 f0 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 ..................1262.....17250
0100 00 04 00 00 00 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 .....yalp.....DATABASE.E...CREAT
0120 45 20 44 41 54 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 E.DATABASE.yalp.WITH.TEMPLATE.=.
0140 74 65 6d 70 6c 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 0d template0.ENCODING.=.'UNICODE';.
0160 0a 00 14 00 00 00 44 52 4f 50 20 44 41 54 41 42 41 53 45 20 79 61 6c 70 3b 0d 0a 01 01 00 00 00 ......DROP.DATABASE.yalp;.......
0180 01 01 00 00 00 01 01 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 ...............yalp.....false...
01a0 00 00 03 00 00 00 00 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 ..........................16672.
01c0 04 00 00 00 32 32 30 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 ....2200.....public.....SCHEMA..
01e0 00 00 00 43 52 45 41 54 45 20 53 43 48 45 4d 41 20 70 75 62 6c 69 63 3b 0d 0a 00 14 00 00 00 44 ...CREATE.SCHEMA.public;.......D
0200 52 4f 50 20 53 43 48 45 4d 41 20 70 75 62 6c 69 63 3b 0d 0a 01 01 00 00 00 01 01 00 00 00 01 01 ROP.SCHEMA.public;..............
0220 00 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 01 01 00 00 00 03 ........postgres.....false......
0240 00 00 00 00 00 00 00 00 00 f1 05 00 00 00 00 00 00 00 00 01 00 00 00 30 00 01 00 00 00 30 00 0d .......................0.....0..
0260 0a 00 00 00 53 43 48 45 4d 41 20 70 75 62 6c 69 63 00 07 00 00 00 43 4f 4d 4d 45 4e 54 00 36 00 ....SCHEMA.public.....COMMENT.6.
0280 00 00 43 4f 4d 4d 45 4e 54 20 4f 4e 20 53 43 48 45 4d 41 20 70 75 62 6c 69 63 20 49 53 20 27 53 ..COMMENT.ON.SCHEMA.public.IS.'S
02a0 74 61 6e 64 61 72 64 20 70 75 62 6c 69 63 20 73 63 68 65 6d 61 27 3b 0d 0a 00 00 00 00 00 01 01 tandard.public.schema';.........
02c0 00 00 00 01 01 00 00 00 01 01 00 00 00 00 08 00 00 00 70 6f 73 74 67 72 65 73 00 05 00 00 00 66 ..................postgres.....f
02e0 61 6c 73 65 00 01 00 00 00 35 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 f2 05 00 00 00 00 00 alse.....5......................
0300 00 00 00 01 00 00 00 30 00 01 00 00 00 30 00 06 00 00 00 70 75 62 6c 69 63 00 03 00 00 00 41 43 .......0.....0.....public.....AC
0320 4c 00 c6 00 00 00 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 L.....REVOKE.ALL.ON.SCHEMA.publi
0340 63 20 46 52 4f 4d 20 50 55 42 4c 49 43 3b 0d 0a 52 45 56 4f 4b 45 20 41 4c 4c 20 4f 4e 20 53 43 c.FROM.PUBLIC;..REVOKE.ALL.ON.SC
0360 48 45 4d 41 20 70 75 62 6c 69 63 20 46 52 4f 4d 20 70 6f 73 74 67 72 65 73 3b 0d 0a 47 52 41 4e HEMA.public.FROM.postgres;..GRAN
0380 54 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 70 6f 73 74 67 72 T.ALL.ON.SCHEMA.public.TO.postgr
03a0 65 73 3b 0d 0a 47 52 41 4e 54 20 41 4c 4c 20 4f 4e 20 53 43 48 45 4d 41 20 70 75 62 6c 69 63 20 es;..GRANT.ALL.ON.SCHEMA.public.
03c0 54 4f 20 79 61 6c 70 3b 0d 0a 47 52 41 4e 54 20 41 4c 4c 20 4f 4e 20 53 43 48 45 4d 41 20 70 75 TO.yalp;..GRANT.ALL.ON.SCHEMA.pu
03e0 62 6c 69 63 20 54 4f 20 50 55 42 4c 49 43 3b 0d 0a 00 00 00 00 00 01 01 00 00 00 01 01 00 00 00 blic.TO.PUBLIC;.................
0400 01 01 00 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 ..........postgres.....false....
0420 00 35 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 94 04 00 00 00 00 00 00 00 00 04 00 00 00 31 .5.............................1
0440 32 35 39 00 05 00 00 00 31 37 33 30 36 00 0d 0a 00 00 00 49 6e 74 50 72 6f 70 65 72 74 69 65 73 259.....17306......IntProperties
0460 00 05 00 00 00 54 41 42 4c 45 00 65 00 00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 22 49 6e 74 .....TABLE.e...CREATE.TABLE."Int
0480 50 72 6f 70 65 72 74 69 65 73 22 20 28 0d 0a 20 20 20 20 69 64 20 62 69 67 73 65 72 69 61 6c 20 Properties".(......id.bigserial.
04a0 4e 4f 54 20 4e 55 4c 4c 2c 0d 0a 20 20 20 20 64 65 73 63 72 69 70 74 69 6f 6e 20 74 65 78 74 2c NOT.NULL,......description.text,
04c0 0d 0a 20 20 20 20 76 61 6c 75 65 20 69 6e 74 65 67 65 72 0d 0a 29 3b 0d 0a 00 23 00 00 00 44 52 ......value.integer..);...#...DR
04e0 4f 50 20 54 41 42 4c 45 20 70 75 62 6c 69 63 2e 22 49 6e 74 50 72 6f 70 65 72 74 69 65 73 22 3b OP.TABLE.public."IntProperties";
0500 0d 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 6c 70 ............public..........yalp
0520 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 34 39 33 00 01 00 00 00 35 01 01 00 00 00 03 00 .....false.....1493.....5.......
0540 00 00 00 00 00 00 00 00 f3 05 00 00 00 00 00 00 00 00 01 00 00 00 30 00 01 00 00 00 30 00 14 00 ......................0.....0...
0560 00 00 49 6e 74 50 72 6f 70 65 72 74 69 65 73 5f 69 64 5f 73 65 71 00 0c 00 00 00 53 45 51 55 45 ..IntProperties_id_seq.....SEQUE
0580 4e 43 45 20 53 45 54 00 60 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.`...SELECT.pg_catalog.se
05a0 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
05c0 71 75 65 6e 63 65 28 27 22 49 6e 74 50 72 6f 70 65 72 74 69 65 73 22 27 2c 20 27 69 64 27 29 2c quence('"IntProperties"',.'id'),
05e0 20 31 2c 20 66 61 6c 73 65 29 3b 0d 0a 00 00 00 00 00 01 01 00 00 00 00 06 00 00 00 70 75 62 6c .1,.false);.................publ
0600 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 31 ic..........yalp.....false.....1
0620 31 37 31 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 96 04 00 00 00 00 00 00 00 00 04 00 00 00 171.............................
0640 31 32 35 39 00 05 00 00 00 31 37 33 31 33 00 06 00 00 00 4d 65 64 69 61 73 00 05 00 00 00 54 41 1259.....17313.....Medias.....TA
0660 42 4c 45 00 a3 00 00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 22 4d 65 64 69 61 73 22 20 28 0d BLE.....CREATE.TABLE."Medias".(.
0680 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 0d 0a 20 20 20 .....id.bigserial.NOT.NULL,.....
06a0 20 22 74 79 70 65 22 20 63 68 61 72 61 63 74 65 72 28 31 29 2c 0d 0a 20 20 20 20 70 61 74 68 20 ."type".character(1),......path.
06c0 74 65 78 74 2c 0d 0a 20 20 20 20 22 66 69 6c 65 4e 61 6d 65 22 20 74 65 78 74 2c 0d 0a 20 20 20 text,......"fileName".text,.....
06e0 20 64 75 72 61 74 69 6f 6e 20 74 65 78 74 2c 0d 0a 20 20 20 20 6e 61 6d 65 20 74 65 78 74 2c 0d .duration.text,......name.text,.
0700 0a 20 20 20 20 74 61 67 73 20 74 65 78 74 0d 0a 29 3b 0d 0a 00 1c 00 00 00 44 52 4f 50 20 54 41 .....tags.text..);.......DROP.TA
0720 42 4c 45 20 70 75 62 6c 69 63 2e 22 4d 65 64 69 61 73 22 3b 0d 0a 01 01 00 00 00 00 06 00 00 00 BLE.public."Medias";............
0740 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 00 04 public..........yalp.....false..
0760 00 00 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 ...1494.....5...................
0780 00 00 00 00 00 00 01 00 00 00 30 00 01 00 00 00 30 00 0d 0a 00 00 00 4d 65 64 69 61 73 5f 69 64 ..........0.....0......Medias_id
07a0 5f 73 65 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 _seq.....SEQUENCE.SET.X...SELECT
07c0 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 67 2e 70 67 .pg_catalog.setval(pg_catalog.pg
07e0 5f 67 65 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 _get_serial_sequence('"Medias"',
0800 20 27 69 64 27 29 2c 20 32 2c 20 74 72 75 65 29 3b 0d 0a 00 00 00 00 00 01 01 00 00 00 00 06 00 .'id'),.2,.true);...............
0820 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 73 65 ..public..........yalp.....false
0840 00 04 00 00 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 .....1173.......................
0860 00 00 04 00 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 ......1259.....17323.....Propert
0880 79 43 6f 6e 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 yConnector.....TABLE.....CREATE.
08a0 54 41 42 4c 45 20 22 50 72 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 22 20 28 0d 0a 20 20 20 TABLE."PropertyConnector".(.....
08c0 20 22 6d 65 64 69 61 49 64 22 20 69 6e 74 65 67 65 72 2c 0d 0a 20 20 20 20 22 73 74 72 69 6e 67 ."mediaId".integer,......"string
08e0 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 0d 0a PropertyId".integer.DEFAULT.0,..
0900 20 20 20 20 22 69 6e 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 ...."intPropertyId".integer.DEFA
0920 55 4c 54 20 30 2c 0d 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 ULT.0,......id.bigserial.NOT.NUL
0940 4c 0d 0a 29 3b 0d 0a 00 27 00 00 00 44 52 4f 50 20 54 41 42 4c 45 20 70 75 62 6c 69 63 2e 22 50 L..);...'...DROP.TABLE.public."P
0960 72 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 22 3b 0d 0a 01 01 00 00 00 00 06 00 00 00 70 75 ropertyConnector";............pu
0980 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....
09a0 00 31 34 39 35 00 04 00 00 00 31 34 39 36 00 04 00 00 00 31 34 39 37 00 01 00 00 00 35 01 01 00 .1495.....1496.....1497.....5...
09c0 00 00 03 00 00 00 00 00 00 00 00 00 92 04 00 00 00 00 00 00 00 00 04 00 00 00 31 32 35 39 00 05 ..........................1259..
09e0 00 00 00 31 37 32 39 34 00 10 00 00 00 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 00 05 00 ...17294.....StringProperties...
0a00 00 00 54 41 42 4c 45 00 65 00 00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 22 53 74 72 69 6e 67 ..TABLE.e...CREATE.TABLE."String
0a20 50 72 6f 70 65 72 74 69 65 73 22 20 28 0d 0a 20 20 20 20 69 64 20 62 69 67 73 65 72 69 61 6c 20 Properties".(......id.bigserial.
0a40 4e 4f 54 20 4e 55 4c 4c 2c 0d 0a 20 20 20 20 64 65 73 63 72 69 70 74 69 6f 6e 20 74 65 78 74 2c NOT.NULL,......description.text,
0a60 0d 0a 20 20 20 20 76 61 6c 75 65 20 74 65 78 74 0d 0a 29 3b 0d 0a 00 26 00 00 00 44 52 4f 50 20 ......value.text..);...&...DROP.
0a80 54 41 42 4c 45 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 3b TABLE.public."StringProperties";
0aa0 0d 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 6c 70 ............public..........yalp
0ac0 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 34 39 32 00 01 00 00 00 35 01 01 00 00 00 03 00 .....false.....1492.....5.......
0ae0 00 00 00 00 00 00 00 00 f5 05 00 00 00 00 00 00 00 00 01 00 00 00 30 00 01 00 00 00 30 00 17 00 ......................0.....0...
0b00 00 00 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 5f 69 64 5f 73 65 71 00 0c 00 00 00 53 45 ..StringProperties_id_seq.....SE
0b20 51 55 45 4e 43 45 20 53 45 54 00 63 00 00 00 53 45 4c 45 43 54 20 70 67 5f 63 61 74 61 6c 6f 67 QUENCE.SET.c...SELECT.pg_catalog
0b40 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
0b60 5f 73 65 71 75 65 6e 63 65 28 27 22 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 22 27 2c 20 _sequence('"StringProperties"',.
0b80 27 69 64 27 29 2c 20 31 2c 20 66 61 6c 73 65 29 3b 0d 0a 00 00 00 00 00 01 01 00 00 00 00 06 00 'id'),.1,.false);...............
0ba0 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 73 65 ..public..........yalp.....false
0bc0 00 04 00 00 00 31 31 36 39 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 8f 04 00 00 00 00 00 00 .....1169.......................
0be0 00 00 04 00 00 00 31 32 35 39 00 05 00 00 00 31 37 32 36 39 00 05 00 00 00 55 73 65 72 73 00 05 ......1259.....17269.....Users..
0c00 00 00 00 54 41 42 4c 45 00 89 00 00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 22 55 73 65 72 73 ...TABLE.....CREATE.TABLE."Users
0c20 22 20 28 0d 0a 20 20 20 20 22 6c 65 76 65 6c 22 20 69 6e 74 65 67 65 72 20 44 45 46 41 55 4c 54 ".(......"level".integer.DEFAULT
0c40 20 31 20 4e 4f 54 20 4e 55 4c 4c 2c 0d 0a 20 20 20 20 69 64 20 62 69 67 73 65 72 69 61 6c 20 4e .1.NOT.NULL,......id.bigserial.N
0c60 4f 54 20 4e 55 4c 4c 2c 0d 0a 20 20 20 20 6e 61 6d 65 20 74 65 78 74 20 4e 4f 54 20 4e 55 4c 4c OT.NULL,......name.text.NOT.NULL
0c80 2c 0d 0a 20 20 20 20 22 72 65 61 6c 4e 61 6d 65 22 20 74 65 78 74 2c 0d 0a 09 09 70 61 73 73 77 ,......"realName".text,....passw
0ca0 64 20 74 65 78 74 20 4e 4f 54 20 4e 55 4c 4c 0d 0a 29 3b 0d 0a 00 1b 00 00 00 44 52 4f 50 20 54 d.text.NOT.NULL..);.......DROP.T
0cc0 41 42 4c 45 20 70 75 62 6c 69 63 2e 22 55 73 65 72 73 22 3b 0d 0a 01 01 00 00 00 00 06 00 00 00 ABLE.public."Users";............
0ce0 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 00 04 public..........yalp.....false..
0d00 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 00 03 00 00 00 00 ...1490.....1491.....5..........
0d20 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 00 0c 00 00 00 55 ...................0.....0.....U
0d40 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 45 54 00 58 00 00 sers_id_seq.....SEQUENCE.SET.X..
0d60 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 70 67 5f 63 61 74 .SELECT.pg_catalog.setval(pg_cat
0d80 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 65 28 27 22 55 73 alog.pg_get_serial_sequence('"Us
0da0 65 72 73 22 27 2c 20 27 69 64 27 29 2c 20 31 2c 20 66 61 6c 73 65 29 3b 0d 0a 00 00 00 00 00 01 ers"',.'id'),.1,.false);........
0dc0 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 00 05 00 .........public..........yalp...
0de0 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 00 00 00 00 f7 ..false.....1168................
0e00 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 6f 70 65 72 74 .............0.....0.....propert
0e20 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 4e 43 45 20 53 yConnector_id_seq.....SEQUENCE.S
0e40 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 74 76 61 6c 28 ET.d...SELECT.pg_catalog.setval(
0e60 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
0e80 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 64 27 29 2c 20 e('"PropertyConnector"',.'id'),.
0ea0 31 2c 20 66 61 6c 73 65 29 3b 0d 0a 00 00 00 00 00 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 1,.false);.................publi
0ec0 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 31 31 c..........yalp.....false.....11
0ee0 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 00 00 00 30 75.............................0
0f00 00 05 00 00 00 31 37 33 30 36 00 0d 0a 00 00 00 49 6e 74 50 72 6f 70 65 72 74 69 65 73 00 0d 0a .....17306......IntProperties...
0f20 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 50 59 ...TABLE.DATA...........:...COPY
0f40 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 69 6f ."IntProperties".(id,.descriptio
0f60 6e 2c 20 76 61 6c 75 65 29 20 46 52 4f 4d 20 73 74 64 69 6e 3b 0d 0a 00 06 00 00 00 70 75 62 6c n,.value).FROM.stdin;.......publ
0f80 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 31 ic..........yalp.....false.....1
0fa0 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 00 172.............................
0fc0 30 00 05 00 00 00 31 37 33 31 33 00 06 00 00 00 4d 65 64 69 61 73 00 0d 0a 00 00 00 54 41 42 4c 0.....17313.....Medias......TABL
0fe0 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
1000 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"
1020 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
1040 69 6e 3b 0d 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 in;.......public..........yalp..
1060 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 00 00 00 00 00 00 00 ...false.....1174...............
1080 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 00 11 00 00 00 50 72 ..............0.....17323.....Pr
10a0 6f 70 65 72 74 79 43 6f 6e 6e 65 63 74 6f 72 00 0d 0a 00 00 00 54 41 42 4c 45 20 44 41 54 41 00 opertyConnector......TABLE.DATA.
10c0 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 74 79 43 6f 6e 6e ..........Z...COPY."PropertyConn
10e0 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 50 72 6f 70 65 72 ector".("mediaId",."stringProper
1100 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 29 20 46 52 4f 4d tyId",."intPropertyId",.id).FROM
1120 20 73 74 64 69 6e 3b 0d 0a 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 00 00 04 00 00 00 79 61 .stdin;.......public..........ya
1140 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 79 1e 00 00 00 lp.....false.....1176......y....
1160 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 39 34 00 10 00 ..................0.....17294...
1180 00 00 53 74 72 69 6e 67 50 72 6f 70 65 72 74 69 65 73 00 0d 0a 00 00 00 54 41 42 4c 45 20 44 41 ..StringProperties......TABLE.DA
11a0 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 67 50 72 6f TA...........=...COPY."StringPro
11c0 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 61 6c 75 65 perties".(id,.description,.value
11e0 29 20 46 52 4f 4d 20 73 74 64 69 6e 3b 0d 0a 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 00 00 ).FROM.stdin;.......public......
1200 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 00 00 00 ....yalp.....false.....1170.....
1220 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 00 31 37 ........................0.....17
1240 32 36 39 00 05 00 00 00 55 73 65 72 73 00 0d 0a 00 00 00 54 41 42 4c 45 20 44 41 54 41 00 00 00 269.....Users......TABLE.DATA...
1260 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 65 6c ........9...COPY."Users".("level
1280 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 73 74 ",.id,.name,."realName").FROM.st
12a0 64 69 6e 3b 0d 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 din;.......public..........yalp.
12c0 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 00 ....false.....1167..............
12e0 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 53 ...............0.....0.....BLOBS
1300 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 01 .....BLOBS......................
1320 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 00 .............false..............
1340 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 0d ...............16386.....17329..
1360 0a 00 00 00 6b 65 79 5f 69 64 5f 63 6f 6e 00 0d 0a 00 00 00 43 4f 4e 53 54 52 41 49 4e 54 00 55 ....key_id_con......CONSTRAINT.U
1380 00 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 ...ALTER.TABLE.ONLY."PropertyCon
13a0 6e 65 63 74 6f 72 22 0d 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 6b 65 79 5f nector"......ADD.CONSTRAINT.key_
13c0 69 64 5f 63 6f 6e 20 50 52 49 4d 41 52 59 20 4b 45 59 20 28 69 64 29 3b 0d 0a 00 48 00 00 00 41 id_con.PRIMARY.KEY.(id);...H...A
13e0 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 6f 70 65 72 74 79 LTER.TABLE.ONLY.public."Property
1400 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 20 6b 65 79 5f 69 Connector".DROP.CONSTRAINT.key_i
1420 64 5f 63 6f 6e 3b 0d 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 d_con;............public........
1440 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 00 00 31 31 ..yalp.....false.....1176.....11
1460 37 36 01 01 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 76.............................1
1480 36 33 38 36 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 0d 0a 00 6386.....17291.....key_is_id....
14a0 00 00 43 4f 4e 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 ..CONSTRAINT.H...ALTER.TABLE.ONL
14c0 59 20 22 55 73 65 72 73 22 0d 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 6b 65 Y."Users"......ADD.CONSTRAINT.ke
14e0 79 5f 69 73 5f 69 64 20 50 52 49 4d 41 52 59 20 4b 45 59 20 28 69 64 29 3b 0d 0a 00 3b 00 00 00 y_is_id.PRIMARY.KEY.(id);...;...
1500 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 55 73 65 72 73 22 20 ALTER.TABLE.ONLY.public."Users".
1520 44 52 4f 50 20 43 4f 4e 53 54 52 41 49 4e 54 20 6b 65 79 5f 69 73 5f 69 64 3b 0d 0a 01 01 00 00 DROP.CONSTRAINT.key_is_id;......
1540 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
1560 61 6c 73 65 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 alse.....1167.....1167..........
1580 00 00 00 00 00 df 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
15a0 39 38 00 0b 00 00 00 70 72 69 6d 5f 6b 65 79 5f 69 64 00 0d 0a 00 00 00 43 4f 4e 53 54 52 41 49 98.....prim_key_id......CONSTRAI
15c0 4e 54 00 55 00 00 00 41 4c 54 45 52 20 54 41 42 4c 45 20 4f 4e 4c 59 20 22 53 74 72 69 6e 67 50 NT.U...ALTER.TABLE.ONLY."StringP
15e0 72 6f 70 65 72 74 69 65 73 22 0d 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 70 roperties"......ADD.CONSTRAINT.p
1600 72 69 6d 5f 6b 65 79 5f 69 64 20 50 52 49 4d 41 52 59 20 4b 45 59 20 28 69 64 29 3b 0d 0a 00 48 rim_key_id.PRIMARY.KEY.(id);...H
1620 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 53 74 72 69 ...ALTER.TABLE.ONLY.public."Stri
1640 6e 67 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 20 70 72 ngProperties".DROP.CONSTRAINT.pr
1660 69 6d 5f 6b 65 79 5f 69 64 3b 0d 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 00 00 00 00 im_key_id;............public....
1680 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 00 04 00 ......yalp.....false.....1170...
16a0 00 00 31 31 37 30 01 01 00 00 00 03 00 00 00 00 00 00 00 00 00 e1 05 00 00 00 00 00 00 00 00 05 ..1170..........................
16c0 00 00 00 31 36 33 38 36 00 05 00 00 00 31 37 33 31 30 00 0f 00 00 00 70 72 69 6d 5f 6b 65 79 5f ...16386.....17310.....prim_key_
16e0 69 6e 74 5f 69 64 00 0d 0a 00 00 00 43 4f 4e 53 54 52 41 49 4e 54 00 56 00 00 00 41 4c 54 45 52 int_id......CONSTRAINT.V...ALTER
1700 20 54 41 42 4c 45 20 4f 4e 4c 59 20 22 49 6e 74 50 72 6f 70 65 72 74 69 65 73 22 0d 0a 20 20 20 .TABLE.ONLY."IntProperties".....
1720 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 6e 74 5f 69 64 20 .ADD.CONSTRAINT.prim_key_int_id.
1740 50 52 49 4d 41 52 59 20 4b 45 59 20 28 69 64 29 3b 0d 0a 00 49 00 00 00 41 4c 54 45 52 20 54 41 PRIMARY.KEY.(id);...I...ALTER.TA
1760 42 4c 45 20 4f 4e 4c 59 20 70 75 62 6c 69 63 2e 22 49 6e 74 50 72 6f 70 65 72 74 69 65 73 22 20 BLE.ONLY.public."IntProperties".
1780 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 6e 74 5f 69 64 3b DROP.CONSTRAINT.prim_key_int_id;
17a0 0d 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 6c 70 ............public..........yalp
17c0 00 05 00 00 00 66 61 6c 73 65 00 04 00 00 00 31 31 37 32 00 04 00 00 00 31 31 37 32 01 01 00 00 .....false.....1172.....1172....
17e0 00 03 00 00 00 00 00 00 00 00 00 e3 05 00 00 00 00 00 00 00 00 05 00 00 00 31 36 33 38 36 00 05 .........................16386..
1800 00 00 00 31 37 33 32 30 00 0d 0a 00 00 00 70 72 69 6d 5f 6b 65 79 5f 6d 5f 69 64 00 0d 0a 00 00 ...17320......prim_key_m_id.....
1820 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 45 20 4f 4e 4c 59 .CONSTRAINT.M...ALTER.TABLE.ONLY
1840 20 22 4d 65 64 69 61 73 22 0d 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 49 4e 54 20 70 72 ."Medias"......ADD.CONSTRAINT.pr
1860 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 29 3b 0d 0a 00 im_key_m_id.PRIMARY.KEY.(id);...
1880 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 22 4d 65 64 @...ALTER.TABLE.ONLY.public."Med
18a0 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 79 5f 6d 5f ias".DROP.CONSTRAINT.prim_key_m_
18c0 69 64 3b 0d 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 id;............public..........y
18e0 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 37 34 01 alp.....false.....1174.....1174.
1900 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 36 33 38 ............................1638
1920 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 6e 69 71 6.....17405.....username_is_uniq
1940 75 65 00 0d 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 41 42 ue......CONSTRAINT.N...ALTER.TAB
1960 4c 45 20 4f 4e 4c 59 20 22 55 73 65 72 73 22 0d 0a 20 20 20 20 41 44 44 20 43 4f 4e 53 54 52 41 LE.ONLY."Users"......ADD.CONSTRA
1980 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 6e INT.username_is_unique.UNIQUE.(n
19a0 61 6d 65 29 3b 0d 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 ame);...D...ALTER.TABLE.ONLY.pub
19c0 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
19e0 6e 61 6d 65 5f 69 73 5f 75 6e 69 71 75 65 3b 0d 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 name_is_unique;............publi
1a00 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 31 c..........yalp.....false.....11
1a20 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 e7 05 00 00 00 00 67.....1167.....................
1a40 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 00 00 00 69 6e 74 5f ........16386.....17334.....int_
1a60 70 72 6f 70 00 0d 0a 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 prop......FK.CONSTRAINT.....ALTE
1a80 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 63 74 6f 72 22 R.TABLE.ONLY."PropertyConnector"
1aa0 0d 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 6f 70 20 46 4f ......ADD.CONSTRAINT.int_prop.FO
1ac0 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 20 52 45 46 45 REIGN.KEY.("intPropertyId").REFE
1ae0 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 0d 0a 00 46 00 RENCES."IntProperties"(id);...F.
1b00 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 6f 70 65 ..ALTER.TABLE.ONLY.public."Prope
1b20 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 20 69 6e rtyConnector".DROP.CONSTRAINT.in
1b40 74 5f 70 72 6f 70 3b 0d 0a 01 01 00 00 00 00 06 00 00 00 70 75 62 6c 69 63 01 01 00 00 00 00 04 t_prop;............public.......
1b60 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 00 00 31 ...yalp.....false.....1176.....1
1b80 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 00 00 00 172.....1504....................
1ba0 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 0d 0a 00 00 00 6d 65 .........16386.....17330......me
1bc0 64 69 61 5f 70 72 6f 70 00 0d 0a 00 00 00 46 4b 20 43 4f 4e 53 54 52 41 49 4e 54 00 74 00 00 00 dia_prop......FK.CONSTRAINT.t...
1be0 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 63 ALTER.TABLE.ONLY."PropertyConnec
1c00 74 6f 72 22 0d 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 tor"......ADD.CONSTRAINT.media_p
1c20 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
1c40 52 45 4e 43 45 53 20 22 4d 65 64 69 61 73 22 28 69 64 29 3b 0d 0a 00 48 00 00 00 41 4c 54 45 52 RENCES."Medias"(id);...H...ALTER
1c60 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 6e .TABLE.ONLY.public."PropertyConn
1c80 65 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 ector".DROP.CONSTRAINT.media_pro
1ca0 70 3b 0d 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 p;............public..........ya
1cc0 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 34 00 04 lp.....false.....1176.....1174..
1ce0 00 00 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 ...1506.........................
1d00 05 00 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 ....16386.....17338.....string_p
1d20 72 6f 70 00 0d 0a 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 rop......FK.CONSTRAINT.....ALTER
1d40 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 63 74 6f 72 22 0d .TABLE.ONLY."PropertyConnector".
1d60 0a 20 20 20 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 .....ADD.CONSTRAINT.string_prop.
1d80 46 4f 52 45 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 FOREIGN.KEY.("stringPropertyId")
1da0 20 52 45 46 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 .REFERENCES."StringProperties"(i
1dc0 64 29 3b 0d 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 d);...I...ALTER.TABLE.ONLY.publi
1de0 63 2e 22 50 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 c."PropertyConnector".DROP.CONST
1e00 52 41 49 4e 54 20 73 74 72 69 6e 67 5f 70 72 6f 70 3b 0d 0a 01 01 00 00 00 00 06 00 00 00 70 75 RAINT.string_prop;............pu
1e20 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....
1e40 00 31 31 37 36 00 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 .1176.....1170.....1502.........
1e60 00 00 00 00 00 01 00 eb 05 00 00 00 0d 0a 00 00 00 78 9c 8b d1 e3 e2 e2 02 00 02 c5 00 a9 00 00 .................x..............
1e80 00 00 00 01 00 ec 05 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 ..........m...x.e.K..0.E...*....
1ea0 a0 4c ba 16 26 51 6b 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 .L..&Qkj.....}`..JG...E^....74.m
1ec0 8e 43 11 d6 10 20 5d 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 .C....]:DE.G.w.}._..&q..\.B.n.u.
1ee0 e9 51 78 13 24 1d 3c 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 .Qx.$.<.hjl.dM\~.].g...8.(......
1f00 01 00 ed 05 00 00 00 0d 0a 00 00 00 78 9c 8b d1 e3 e2 e2 02 00 02 c5 00 a9 00 00 00 00 00 01 00 ............x...................
1f20 ea 05 00 00 00 0d 0a 00 00 00 78 9c 8b d1 e3 e2 e2 02 00 02 c5 00 a9 00 00 00 00 00 01 00 e9 05 ..........x.....................
1f40 00 00 00 0d 0a 00 00 00 78 9c 8b d1 e3 e2 e2 02 00 02 c5 00 a9 00 00 00 00 00 03 00 ee 05 00 00 ........x.......................
1f60 00 00 00 00 00 0d 0a .......