LEFT | RIGHT |
1 CREATE TABLE ir_model ( | 1 CREATE TABLE ir_model ( |
2 id BIGINT AUTO_INCREMENT NOT NULL, | 2 id BIGINT AUTO_INCREMENT NOT NULL, |
3 model VARCHAR(255) NOT NULL, | 3 model VARCHAR(255) NOT NULL, |
4 name VARCHAR(255), | 4 name VARCHAR(255), |
5 info TEXT, | 5 info TEXT, |
6 module VARCHAR(255), | 6 module VARCHAR(255), |
7 PRIMARY KEY(id) | 7 PRIMARY KEY(id) |
8 ) ENGINE=InnoDB; | 8 ) ENGINE=InnoDB; |
9 | 9 |
10 CREATE TABLE ir_model_field ( | 10 CREATE TABLE ir_model_field ( |
(...skipping 25 matching lines...) Expand all Loading... |
36 name VARCHAR(255) NOT NULL, | 36 name VARCHAR(255) NOT NULL, |
37 icon VARCHAR(255), | 37 icon VARCHAR(255), |
38 PRIMARY KEY (id), | 38 PRIMARY KEY (id), |
39 CONSTRAINT ir_ui_menu_parent_fkey FOREIGN KEY (parent) REFERENCES ir_ui_menu
(id) ON DELETE SET NULL | 39 CONSTRAINT ir_ui_menu_parent_fkey FOREIGN KEY (parent) REFERENCES ir_ui_menu
(id) ON DELETE SET NULL |
40 ) ENGINE=InnoDB; | 40 ) ENGINE=InnoDB; |
41 | 41 |
42 CREATE TABLE ir_translation ( | 42 CREATE TABLE ir_translation ( |
43 id BIGINT AUTO_INCREMENT NOT NULL, | 43 id BIGINT AUTO_INCREMENT NOT NULL, |
44 lang VARCHAR(255), | 44 lang VARCHAR(255), |
45 src TEXT, | 45 src TEXT, |
| 46 src_md5 VARCHAR(32) NOT NULL, |
46 name VARCHAR(255) NOT NULL, | 47 name VARCHAR(255) NOT NULL, |
47 res_id BIGINT NOT NULL DEFAULT 0, | 48 res_id BIGINT, |
48 value TEXT, | 49 value TEXT, |
49 type VARCHAR(255), | 50 type VARCHAR(255), |
50 module VARCHAR(255), | 51 module VARCHAR(255), |
51 fuzzy BOOLEAN NOT NULL, | 52 fuzzy BOOLEAN NOT NULL, |
52 PRIMARY KEY(id) | 53 PRIMARY KEY(id) |
53 ) ENGINE=InnoDB; | 54 ) ENGINE=InnoDB; |
54 | 55 |
55 CREATE TABLE ir_lang ( | 56 CREATE TABLE ir_lang ( |
56 id BIGINT AUTO_INCREMENT NOT NULL, | 57 id BIGINT AUTO_INCREMENT NOT NULL, |
57 name VARCHAR(255) NOT NULL, | 58 name VARCHAR(255) NOT NULL, |
(...skipping 10 matching lines...) Expand all Loading... |
68 active BOOLEAN NOT NULL, | 69 active BOOLEAN NOT NULL, |
69 login VARCHAR(255) NOT NULL, | 70 login VARCHAR(255) NOT NULL, |
70 password VARCHAR(40), | 71 password VARCHAR(40), |
71 PRIMARY KEY(id) | 72 PRIMARY KEY(id) |
72 ) ENGINE=InnoDB; | 73 ) ENGINE=InnoDB; |
73 | 74 |
74 ALTER TABLE res_user ADD CONSTRAINT res_user_login_uniq UNIQUE (login); | 75 ALTER TABLE res_user ADD CONSTRAINT res_user_login_uniq UNIQUE (login); |
75 | 76 |
76 INSERT INTO res_user (id, login, password, name, active) VALUES (0, 'root', NULL
, 'Root', False); | 77 INSERT INTO res_user (id, login, password, name, active) VALUES (0, 'root', NULL
, 'Root', False); |
77 UPDATE res_user set id = 0; | 78 UPDATE res_user set id = 0; |
| 79 ALTER TABLE res_user AUTO_INCREMENT = 1; |
78 | 80 |
79 CREATE TABLE res_group ( | 81 CREATE TABLE res_group ( |
80 id BIGINT AUTO_INCREMENT NOT NULL, | 82 id BIGINT AUTO_INCREMENT NOT NULL, |
81 name VARCHAR(255) NOT NULL, | 83 name VARCHAR(255) NOT NULL, |
82 PRIMARY KEY(id) | 84 PRIMARY KEY(id) |
83 ) ENGINE=InnoDB; | 85 ) ENGINE=InnoDB; |
84 | 86 |
85 CREATE TABLE `res_user-res_group` ( | 87 CREATE TABLE `res_user-res_group` ( |
86 uid BIGINT NOT NULL, | 88 `user` BIGINT NOT NULL, |
87 gid BIGINT NOT NULL, | 89 `group` BIGINT NOT NULL, |
88 CONSTRAINT `res_user-res_group_uid_fkey` FOREIGN KEY (uid) REFERENCES res_us
er (id) ON DELETE CASCADE, | 90 CONSTRAINT `res_user-res_group_user_fkey` FOREIGN KEY (`user`) REFERENCES re
s_user (id) ON DELETE CASCADE, |
89 CONSTRAINT `res_user-res_group_gid_fkey` FOREIGN KEY (gid) REFERENCES res_gr
oup (id) ON DELETE CASCADE | 91 CONSTRAINT `res_user-res_group_group_fkey` FOREIGN KEY (`group`) REFERENCES
res_group (id) ON DELETE CASCADE |
90 ) ENGINE=InnoDB; | |
91 | |
92 CREATE TABLE wkf ( | |
93 id BIGINT AUTO_INCREMENT NOT NULL, | |
94 name VARCHAR(255), | |
95 model VARCHAR(255), | |
96 on_create BOOLEAN NOT NULL, | |
97 PRIMARY KEY(id) | |
98 ) ENGINE=InnoDB; | |
99 | |
100 CREATE TABLE wkf_activity ( | |
101 id BIGINT AUTO_INCREMENT NOT NULL, | |
102 workflow BIGINT, | |
103 subflow BIGINT, | |
104 split_mode VARCHAR(255), | |
105 join_mode VARCHAR(255), | |
106 kind VARCHAR(255) NOT NULL, | |
107 name VARCHAR(255), | |
108 signal_send VARCHAR(255), | |
109 flow_start BOOLEAN NOT NULL, | |
110 flow_stop BOOLEAN NOT NULL, | |
111 action TEXT, | |
112 PRIMARY KEY(id), | |
113 CONSTRAINT wkf_activity_workflow_fkey FOREIGN KEY (workflow) REFERENCES wkf
(id) ON DELETE CASCADE, | |
114 CONSTRAINT wkf_activity_subflow_fkey FOREIGN KEY (subflow) REFERENCES wkf (i
d) ON DELETE SET NULL | |
115 ) ENGINE=InnoDB; | |
116 | |
117 CREATE TABLE wkf_transition ( | |
118 id BIGINT AUTO_INCREMENT NOT NULL, | |
119 act_from BIGINT, | |
120 act_to BIGINT, | |
121 `condition` VARCHAR(255), | |
122 trigger_expr_id VARCHAR(255), | |
123 signal VARCHAR(255), | |
124 `group` BIGINT, | |
125 PRIMARY KEY(id), | |
126 CONSTRAINT wkf_transition_act_from_fkey FOREIGN KEY (act_from) REFERENCES wk
f_activity (id) ON DELETE CASCADE, | |
127 CONSTRAINT wkf_transition_act_to_fkey FOREIGN KEY (act_to) REFERENCES wkf_ac
tivity (id) ON DELETE CASCADE, | |
128 CONSTRAINT wkf_transition_group_fkey FOREIGN KEY (`group`) REFERENCES res_gr
oup (id) ON DELETE SET NULL | |
129 ) ENGINE=InnoDB; | |
130 | |
131 CREATE TABLE wkf_instance ( | |
132 id BIGINT AUTO_INCREMENT NOT NULL, | |
133 workflow BIGINT, | |
134 uid BIGINT DEFAULT 0, | |
135 res_id BIGINT NOT NULL DEFAULT 0, | |
136 res_type VARCHAR(255) NOT NULL, | |
137 state VARCHAR(255) NOT NULL, | |
138 PRIMARY KEY(id), | |
139 CONSTRAINT wkf_instance_workflow_fkey FOREIGN KEY (workflow) REFERENCES wkf
(id) ON DELETE RESTRICT | |
140 ) ENGINE=InnoDB; | |
141 | |
142 CREATE TABLE wkf_workitem ( | |
143 id BIGINT AUTO_INCREMENT NOT NULL, | |
144 activity BIGINT, | |
145 instance BIGINT, | |
146 subflow BIGINT, | |
147 state VARCHAR(255), | |
148 PRIMARY KEY(id), | |
149 CONSTRAINT wkf_workitem_activity_fkey FOREIGN KEY (activity) REFERENCES wkf_
activity (id) ON DELETE CASCADE, | |
150 CONSTRAINT wkf_workitem_instance_fkey FOREIGN KEY (instance) REFERENCES wkf_
instance (id) ON DELETE CASCADE, | |
151 CONSTRAINT wkf_workitem_subflow_fkey FOREIGN KEY (subflow) REFERENCES wkf_in
stance (id) ON DELETE CASCADE | |
152 ) ENGINE=InnoDB; | |
153 | |
154 CREATE TABLE wkf_witm_trans ( | |
155 trans_id BIGINT, | |
156 inst_id BIGINT, | |
157 CONSTRAINT wkf_witm_trans_trans_id_fkey FOREIGN KEY (trans_id) REFERENCES wk
f_transition (id) ON DELETE CASCADE, | |
158 CONSTRAINT wkf_witm_trans_inst_id_fkey FOREIGN KEY (inst_id) REFERENCES wkf_
instance (id) ON DELETE CASCADE | |
159 ) ENGINE=InnoDB; | 92 ) ENGINE=InnoDB; |
160 | 93 |
161 CREATE TABLE ir_module_module ( | 94 CREATE TABLE ir_module_module ( |
162 id BIGINT AUTO_INCREMENT NOT NULL, | 95 id BIGINT AUTO_INCREMENT NOT NULL, |
163 create_uid BIGINT, | 96 create_uid BIGINT, |
164 create_date TIMESTAMP NOT NULL, | 97 create_date TIMESTAMP NOT NULL, |
165 write_date TIMESTAMP NULL, | 98 write_date TIMESTAMP NULL, |
166 write_uid BIGINT, | 99 write_uid BIGINT, |
167 website VARCHAR(255), | |
168 name VARCHAR(255) NOT NULL, | 100 name VARCHAR(255) NOT NULL, |
169 author VARCHAR(255), | |
170 url VARCHAR(255), | |
171 state VARCHAR(255), | 101 state VARCHAR(255), |
172 shortdesc VARCHAR(255), | |
173 description TEXT, | |
174 PRIMARY KEY(id), | 102 PRIMARY KEY(id), |
175 CONSTRAINT ir_module_module_create_uid_fkey FOREIGN KEY (create_uid) REFEREN
CES res_user (id) ON DELETE SET NULL, | 103 CONSTRAINT ir_module_module_create_uid_fkey FOREIGN KEY (create_uid) REFEREN
CES res_user (id) ON DELETE SET NULL, |
176 CONSTRAINT ir_module_module_write_uid_fkey FOREIGN KEY (write_uid) REFERENCE
S res_user (id) ON DELETE SET NULL | 104 CONSTRAINT ir_module_module_write_uid_fkey FOREIGN KEY (write_uid) REFERENCE
S res_user (id) ON DELETE SET NULL |
177 ) ENGINE=InnoDB; | 105 ) ENGINE=InnoDB; |
178 | 106 |
179 ALTER TABLE ir_module_module ADD CONSTRAINT name_uniq UNIQUE (name); | 107 ALTER TABLE ir_module_module ADD CONSTRAINT name_uniq UNIQUE (name); |
180 | 108 |
181 CREATE TABLE ir_module_module_dependency ( | 109 CREATE TABLE ir_module_module_dependency ( |
182 id BIGINT AUTO_INCREMENT NOT NULL, | 110 id BIGINT AUTO_INCREMENT NOT NULL, |
183 create_uid BIGINT, | 111 create_uid BIGINT, |
184 create_date TIMESTAMP NOT NULL, | 112 create_date TIMESTAMP NOT NULL, |
185 write_date TIMESTAMP NULL, | 113 write_date TIMESTAMP NULL, |
186 write_uid BIGINT, | 114 write_uid BIGINT, |
187 name VARCHAR(255), | 115 name VARCHAR(255), |
188 module BIGINT, | 116 module BIGINT, |
189 PRIMARY KEY(id), | 117 PRIMARY KEY(id), |
190 CONSTRAINT ir_module_module_dependency_create_uid_fkey FOREIGN KEY (create_u
id) REFERENCES res_user (id) ON DELETE SET NULL, | 118 CONSTRAINT ir_module_module_dependency_create_uid_fkey FOREIGN KEY (create_u
id) REFERENCES res_user (id) ON DELETE SET NULL, |
191 CONSTRAINT ir_module_module_dependency_write_uid_fkey FOREIGN KEY (write_uid
) REFERENCES res_user (id) ON DELETE SET NULL, | 119 CONSTRAINT ir_module_module_dependency_write_uid_fkey FOREIGN KEY (write_uid
) REFERENCES res_user (id) ON DELETE SET NULL, |
192 CONSTRAINT ir_module_module_dependency_module_fkey FOREIGN KEY (module) REFE
RENCES ir_module_module (id) ON DELETE CASCADE | 120 CONSTRAINT ir_module_module_dependency_module_fkey FOREIGN KEY (module) REFE
RENCES ir_module_module (id) ON DELETE CASCADE |
193 ) ENGINE=InnoDB; | 121 ) ENGINE=InnoDB; |
LEFT | RIGHT |