1 drop sequence SEQ_GEN_SEQUENCE;
2 create sequence SEQ_GEN_SEQUENCE INCREMENT BY 50;
4 DROP TABLE attribute_group CASCADE;
5 CREATE TABLE attribute_group (
9 DROP TABLE attribute CASCADE;
10 CREATE TABLE attribute (
15 group_id int8 REFERENCES attribute_group (id),
19 DROP TABLE file CASCADE;
24 checksum varchar(255),
25 creation_date timestamp,
26 update_date timestamp,
29 deletion_date timestamp,
30 group_id int8 REFERENCES attribute_group (id)
33 DROP TABLE chunk CASCADE;
36 file_id int8 REFERENCES file (id),
38 checksum varchar(255),
43 DROP TABLE data CASCADE;
45 file_id int8 REFERENCES file (id),
46 metadata_id int8 REFERENCES attribute_group (id),
47 PRIMARY KEY (file_id, metadata_id)
50 DROP TABLE profile CASCADE;
51 CREATE TABLE profile (
56 DROP TABLE profile_attribute CASCADE;
57 CREATE TABLE profile_attribute (
62 profile_id int8 REFERENCES profile (id)