drop sequence if exists SEQ_GEN_SEQUENCE;
create sequence SEQ_GEN_SEQUENCE START WITH 1000 INCREMENT BY 50;

drop table if exists study_files cascade;
DROP TABLE IF EXISTS GROUP_ CASCADE;
DROP TABLE IF EXISTS USERS CASCADE;
DROP TABLE IF EXISTS USERGROUP CASCADE;
DROP TABLE IF EXISTS GROUPPERMISSIONS CASCADE;
DROP TABLE IF EXISTS attribute_group CASCADE;
DROP TABLE IF EXISTS attribute CASCADE;
DROP TABLE IF EXISTS profile CASCADE;
DROP TABLE IF EXISTS profile_attribute CASCADE;
DROP TABLE IF EXISTS gde_file CASCADE;
DROP TABLE IF EXISTS chunk CASCADE;
DROP TABLE IF EXISTS study CASCADE;
