bHnAF3cZ

1ALTER TABLE permissions DROP FOREIGN KEY FKpermission87764;
2ALTER TABLE users_roles DROP FOREIGN KEY FKusers_role866388;
3ALTER TABLE users_roles DROP FOREIGN KEY FKusers_role35086;
4ALTER TABLE workstations DROP FOREIGN KEY FKworkstatio774440;
5ALTER TABLE users_workstations DROP FOREIGN KEY FKusers_work19477;
6ALTER TABLE samples DROP FOREIGN KEY FKsamples507415;
7ALTER TABLE carriers DROP FOREIGN KEY FKcarriers138877;
8ALTER TABLE jobs DROP FOREIGN KEY FKjobs387783;
9ALTER TABLE process_steps_process_chains DROP FOREIGN KEY FKprocess_st127702;
10ALTER TABLE process_steps_process_chains DROP FOREIGN KEY FKprocess_st919801;
11ALTER TABLE process_steps DROP FOREIGN KEY FKprocess_st145702;
12ALTER TABLE users_workstations DROP FOREIGN KEY FKusers_work361746;
13ALTER TABLE process_steps DROP FOREIGN KEY FKprocess_st72547;
14ALTER TABLE states DROP FOREIGN KEY FKstates100632;
15ALTER TABLE process_parameters DROP FOREIGN KEY FKprocess_pa377313;
16ALTER TABLE process_step_init DROP FOREIGN KEY FKprocess_st364381;
17ALTER TABLE process_param_init DROP FOREIGN KEY FKprocess_pa127725;
18ALTER TABLE comments DROP FOREIGN KEY FKcomments36192;
19ALTER TABLE process_param_init DROP FOREIGN KEY FKprocess_pa398077;
20ALTER TABLE comments DROP FOREIGN KEY FKcomments525542;
21ALTER TABLE comments DROP FOREIGN KEY FKcomments582422;
22ALTER TABLE states DROP FOREIGN KEY FKstates700369;
23ALTER TABLE process_step_init DROP FOREIGN KEY FKprocess_st380022;
24ALTER TABLE carriers DROP FOREIGN KEY FKcarriers154653;
25DROP TABLE IF EXISTS users;
26DROP TABLE IF EXISTS roles;
27DROP TABLE IF EXISTS permissions;
28DROP TABLE IF EXISTS users_roles;
29DROP TABLE IF EXISTS workstations;
30DROP TABLE IF EXISTS locations;
31DROP TABLE IF EXISTS users_workstations;
32DROP TABLE IF EXISTS comments;
33DROP TABLE IF EXISTS carriers;
34DROP TABLE IF EXISTS samples;
35DROP TABLE IF EXISTS jobs;
36DROP TABLE IF EXISTS process_chains;
37DROP TABLE IF EXISTS process_steps;
38DROP TABLE IF EXISTS process_steps_process_chains;
39DROP TABLE IF EXISTS state_diagrams;
40DROP TABLE IF EXISTS process_parameters;
41DROP TABLE IF EXISTS process_param_init;
42DROP TABLE IF EXISTS states;
43DROP TABLE IF EXISTS process_step_init;
44DROP TABLE IF EXISTS settings;
45CREATE TABLE users (email varchar(345) NOT NULL, name varchar(32) NOT NULL, password varchar(64) NOT NULL, language varchar(8), PRIMARY KEY (email));
46CREATE TABLE roles (name varchar(32) NOT NULL, PRIMARY KEY (name));
47CREATE TABLE permissions (permission varchar(64) NOT NULL, rolesname varchar(32) NOT NULL);
48CREATE TABLE users_roles (usersemail varchar(345) NOT NULL, rolesname varchar(32) NOT NULL, PRIMARY KEY (usersemail, rolesname));
49CREATE TABLE workstations (name varchar(64) NOT NULL, alias varchar(64) NOT NULL, status varchar(16) NOT NULL, locationsname varchar(32) NOT NULL, PRIMARY KEY (name));
50CREATE TABLE locations (name varchar(32) NOT NULL, room varchar(16) NOT NULL, address varchar(48) NOT NULL, PRIMARY KEY (name));
51CREATE TABLE users_workstations (usersemail varchar(345) NOT NULL, workstationsname varchar(64) NOT NULL, PRIMARY KEY (usersemail, workstationsname));
52CREATE TABLE comments (id int(11) NOT NULL AUTO_INCREMENT, message varchar(255) NOT NULL, `date` int(10) NOT NULL, usersemail varchar(345) NOT NULL, target varchar(64) NOT NULL, PRIMARY KEY (id));
53CREATE TABLE carriers (name varchar(32) NOT NULL, type varchar(16) NOT NULL, width int(10), height int(10), locationsname varchar(32) NOT NULL, jobsid varchar(64), PRIMARY KEY (name));
54CREATE TABLE samples (id varchar(64) NOT NULL, state varchar(16) NOT NULL, alloy varchar(32) NOT NULL, treatment varchar(32), position int(11), carriersname varchar(32) NOT NULL, PRIMARY KEY (id));
55CREATE TABLE jobs (id varchar(64) NOT NULL, priority varchar(16) NOT NULL, status varchar(16) NOT NULL, creation timestamp NOT NULL, process_chainsname varchar(32), PRIMARY KEY (id));
56CREATE TABLE process_chains (name varchar(32) NOT NULL, status varchar(16) NOT NULL, PRIMARY KEY (name));
57CREATE TABLE process_steps (name varchar(32) NOT NULL, type varchar(16) NOT NULL, estimatedDuration int(20) NOT NULL, workstationsname varchar(64) NOT NULL, state_diagramsname varchar(32) NOT NULL, PRIMARY KEY (name));
58CREATE TABLE process_steps_process_chains (process_stepsname varchar(32) NOT NULL, process_chainsname varchar(32) NOT NULL, PRIMARY KEY (process_stepsname, process_chainsname));
59CREATE TABLE state_diagrams (name varchar(32) NOT NULL, PRIMARY KEY (name));
60CREATE TABLE process_parameters (name varchar(64) NOT NULL, unit varchar(32), process_stepsname varchar(32) NOT NULL, PRIMARY KEY (name));
61CREATE TABLE process_param_init (id int(11) NOT NULL AUTO_INCREMENT, value varchar(32) NOT NULL, jobsid varchar(64) NOT NULL, process_parametersname varchar(64) NOT NULL, process_step_initid int(11) NOT NULL, PRIMARY KEY (id));
62CREATE TABLE states (id int(11) NOT NULL AUTO_INCREMENT, name varchar(32) NOT NULL, rolesname varchar(32) NOT NULL, sort int(11) NOT NULL, state_diagramsname varchar(32) NOT NULL, PRIMARY KEY (id));
63CREATE TABLE process_step_init (id int(11) NOT NULL AUTO_INCREMENT, sort int(11) NOT NULL, active bit(1) NOT NULL, active_state int(11), duration int(20), jobsid varchar(64) NOT NULL, process_stepsname varchar(32) NOT NULL, PRIMARY KEY (id));
64CREATE TABLE settings (`key` varchar(32) NOT NULL, value varchar(32) NOT NULL, PRIMARY KEY (`key`));
65ALTER TABLE permissions ADD CONSTRAINT FKpermission87764 FOREIGN KEY (rolesname) REFERENCES roles (name);
66ALTER TABLE users_roles ADD CONSTRAINT FKusers_role866388 FOREIGN KEY (usersemail) REFERENCES users (email);
67ALTER TABLE users_roles ADD CONSTRAINT FKusers_role35086 FOREIGN KEY (rolesname) REFERENCES roles (name);
68ALTER TABLE workstations ADD CONSTRAINT FKworkstatio774440 FOREIGN KEY (locationsname) REFERENCES locations (name);
69ALTER TABLE users_workstations ADD CONSTRAINT FKusers_work19477 FOREIGN KEY (usersemail) REFERENCES users (email);
70ALTER TABLE samples ADD CONSTRAINT FKsamples507415 FOREIGN KEY (carriersname) REFERENCES carriers (name);
71ALTER TABLE carriers ADD CONSTRAINT FKcarriers138877 FOREIGN KEY (locationsname) REFERENCES locations (name);
72ALTER TABLE jobs ADD CONSTRAINT FKjobs387783 FOREIGN KEY (process_chainsname) REFERENCES process_chains (name);
73ALTER TABLE process_steps_process_chains ADD CONSTRAINT FKprocess_st127702 FOREIGN KEY (process_stepsname) REFERENCES process_steps (name);
74ALTER TABLE process_steps_process_chains ADD CONSTRAINT FKprocess_st919801 FOREIGN KEY (process_chainsname) REFERENCES process_chains (name);
75ALTER TABLE process_steps ADD CONSTRAINT FKprocess_st145702 FOREIGN KEY (workstationsname) REFERENCES workstations (name);
76ALTER TABLE users_workstations ADD CONSTRAINT FKusers_work361746 FOREIGN KEY (workstationsname) REFERENCES workstations (name);
77ALTER TABLE process_steps ADD CONSTRAINT FKprocess_st72547 FOREIGN KEY (state_diagramsname) REFERENCES state_diagrams (name);
78ALTER TABLE states ADD CONSTRAINT FKstates100632 FOREIGN KEY (rolesname) REFERENCES roles (name);
79ALTER TABLE process_parameters ADD CONSTRAINT FKprocess_pa377313 FOREIGN KEY (process_stepsname) REFERENCES process_steps (name);
80ALTER TABLE process_step_init ADD CONSTRAINT FKprocess_st364381 FOREIGN KEY (jobsid) REFERENCES jobs (id);
81ALTER TABLE process_param_init ADD CONSTRAINT FKprocess_pa127725 FOREIGN KEY (process_parametersname) REFERENCES process_parameters (name);
82ALTER TABLE comments ADD CONSTRAINT FKcomments36192 FOREIGN KEY (usersemail) REFERENCES users (email);
83ALTER TABLE process_param_init ADD CONSTRAINT FKprocess_pa398077 FOREIGN KEY (process_step_initid) REFERENCES process_step_init (id);
84ALTER TABLE comments ADD CONSTRAINT FKcomments525542 FOREIGN KEY (target) REFERENCES samples (id);
85ALTER TABLE comments ADD CONSTRAINT FKcomments582422 FOREIGN KEY (target) REFERENCES workstations (name);
86ALTER TABLE states ADD CONSTRAINT FKstates700369 FOREIGN KEY (state_diagramsname) REFERENCES state_diagrams (name);
87ALTER TABLE process_step_init ADD CONSTRAINT FKprocess_st380022 FOREIGN KEY (process_stepsname) REFERENCES process_steps (name);
88ALTER TABLE carriers ADD CONSTRAINT FKcarriers154653 FOREIGN KEY (jobsid) REFERENCES jobs (id);