LEFT | RIGHT |
1 CREATE SEQUENCE ir_model_id_seq; | 1 CREATE SEQUENCE ir_model_id_seq; |
2 | 2 |
3 CREATE TABLE ir_model ( | 3 CREATE TABLE ir_model ( |
4 id INTEGER DEFAULT NEXTVAL('ir_model_id_seq') NOT NULL, | 4 id INTEGER DEFAULT NEXTVAL('ir_model_id_seq') NOT NULL, |
5 model VARCHAR NOT NULL, | 5 model VARCHAR NOT NULL, |
6 name VARCHAR, | 6 name VARCHAR, |
7 info TEXT, | 7 info TEXT, |
8 module VARCHAR, | 8 module VARCHAR, |
9 PRIMARY KEY(id) | 9 PRIMARY KEY(id) |
10 ); | 10 ); |
(...skipping 14 matching lines...) Expand all Loading... |
25 ); | 25 ); |
26 | 26 |
27 CREATE SEQUENCE ir_ui_view_id_seq; | 27 CREATE SEQUENCE ir_ui_view_id_seq; |
28 | 28 |
29 CREATE TABLE ir_ui_view ( | 29 CREATE TABLE ir_ui_view ( |
30 id INTEGER DEFAULT NEXTVAL('ir_ui_view_id_seq') NOT NULL, | 30 id INTEGER DEFAULT NEXTVAL('ir_ui_view_id_seq') NOT NULL, |
31 model VARCHAR NOT NULL, | 31 model VARCHAR NOT NULL, |
32 "type" VARCHAR, | 32 "type" VARCHAR, |
33 data TEXT NOT NULL, | 33 data TEXT NOT NULL, |
34 field_childs VARCHAR, | 34 field_childs VARCHAR, |
35 priority INTEGER NOT NULL DEFAULT 0, | 35 priority INTEGER NOT NULL, |
36 PRIMARY KEY(id) | 36 PRIMARY KEY(id) |
37 ); | 37 ); |
38 | 38 |
39 CREATE SEQUENCE ir_ui_menu_id_seq; | 39 CREATE SEQUENCE ir_ui_menu_id_seq; |
40 | 40 |
41 CREATE TABLE ir_ui_menu ( | 41 CREATE TABLE ir_ui_menu ( |
42 id INTEGER DEFAULT NEXTVAL('ir_ui_menu_id_seq') NOT NULL, | 42 id INTEGER DEFAULT NEXTVAL('ir_ui_menu_id_seq') NOT NULL, |
43 parent INTEGER, | 43 parent INTEGER, |
44 name VARCHAR NOT NULL, | 44 name VARCHAR NOT NULL, |
45 icon VARCHAR, | 45 icon VARCHAR, |
46 PRIMARY KEY (id), | 46 PRIMARY KEY (id), |
47 FOREIGN KEY (parent) REFERENCES ir_ui_menu (id) ON DELETE SET NULL | 47 FOREIGN KEY (parent) REFERENCES ir_ui_menu (id) ON DELETE SET NULL |
48 ); | 48 ); |
49 | 49 |
50 CREATE SEQUENCE ir_translation_id_seq; | 50 CREATE SEQUENCE ir_translation_id_seq; |
51 | 51 |
52 CREATE TABLE ir_translation ( | 52 CREATE TABLE ir_translation ( |
53 id INTEGER DEFAULT NEXTVAL('ir_translation_id_seq') NOT NULL, | 53 id INTEGER DEFAULT NEXTVAL('ir_translation_id_seq') NOT NULL, |
54 lang VARCHAR, | 54 lang VARCHAR, |
55 src TEXT, | 55 src TEXT, |
| 56 src_md5 VARCHAR(32) NOT NULL, |
56 name VARCHAR NOT NULL, | 57 name VARCHAR NOT NULL, |
57 res_id INTEGER NOT NULL DEFAULT 0, | 58 res_id INTEGER, |
58 value TEXT, | 59 value TEXT, |
59 "type" VARCHAR, | 60 "type" VARCHAR, |
60 module VARCHAR, | 61 module VARCHAR, |
61 fuzzy BOOLEAN NOT NULL, | 62 fuzzy BOOLEAN NOT NULL, |
62 PRIMARY KEY(id) | 63 PRIMARY KEY(id) |
63 ); | 64 ); |
64 | 65 |
65 CREATE SEQUENCE ir_lang_id_seq; | 66 CREATE SEQUENCE ir_lang_id_seq; |
66 | 67 |
67 CREATE TABLE ir_lang ( | 68 CREATE TABLE ir_lang ( |
(...skipping 26 matching lines...) Expand all Loading... |
94 CREATE TABLE res_group ( | 95 CREATE TABLE res_group ( |
95 id INTEGER DEFAULT NEXTVAL('res_group_id_seq') NOT NULL, | 96 id INTEGER DEFAULT NEXTVAL('res_group_id_seq') NOT NULL, |
96 name VARCHAR NOT NULL, | 97 name VARCHAR NOT NULL, |
97 PRIMARY KEY(id) | 98 PRIMARY KEY(id) |
98 ); | 99 ); |
99 | 100 |
100 CREATE SEQUENCE "res_user-res_group_id_seq"; | 101 CREATE SEQUENCE "res_user-res_group_id_seq"; |
101 | 102 |
102 CREATE TABLE "res_user-res_group" ( | 103 CREATE TABLE "res_user-res_group" ( |
103 id INTEGER DEFAULT NEXTVAL('res_user-res_group_id_seq') NOT NULL, | 104 id INTEGER DEFAULT NEXTVAL('res_user-res_group_id_seq') NOT NULL, |
104 uid INTEGER NOT NULL, | 105 "user" INTEGER NOT NULL, |
105 gid INTEGER NOT NULL, | 106 "group" INTEGER NOT NULL, |
106 FOREIGN KEY (uid) REFERENCES res_user (id) ON DELETE CASCADE, | 107 FOREIGN KEY ("user") REFERENCES res_user (id) ON DELETE CASCADE, |
107 FOREIGN KEY (gid) REFERENCES res_group (id) ON DELETE CASCADE, | 108 FOREIGN KEY ("group") REFERENCES res_group (id) ON DELETE CASCADE, |
108 PRIMARY KEY(id) | 109 PRIMARY KEY(id) |
109 ); | |
110 | |
111 CREATE SEQUENCE wkf_id_seq; | |
112 | |
113 CREATE TABLE wkf ( | |
114 id INTEGER DEFAULT NEXTVAL('wkf_id_seq') NOT NULL, | |
115 name VARCHAR, | |
116 model VARCHAR, | |
117 on_create BOOL NOT NULL, | |
118 PRIMARY KEY(id) | |
119 ); | |
120 | |
121 CREATE SEQUENCE wkf_activity_id_seq; | |
122 | |
123 CREATE TABLE wkf_activity ( | |
124 id INTEGER DEFAULT NEXTVAL('wkf_activity_id_seq') NOT NULL, | |
125 workflow INTEGER, | |
126 subflow INTEGER, | |
127 split_mode VARCHAR NOT NULL, | |
128 join_mode VARCHAR NOT NULL, | |
129 kind VARCHAR NOT NULL, | |
130 name VARCHAR NOT NULL, | |
131 signal_send VARCHAR, | |
132 flow_start BOOLEAN NOT NULL, | |
133 flow_stop BOOLEAN NOT NULL, | |
134 action TEXT, | |
135 PRIMARY KEY(id), | |
136 FOREIGN KEY (workflow) REFERENCES wkf (id) ON DELETE CASCADE, | |
137 FOREIGN KEY (subflow) REFERENCES wkf (id) ON DELETE SET NULL | |
138 ); | |
139 | |
140 CREATE SEQUENCE wkf_transition_id_seq; | |
141 | |
142 CREATE TABLE wkf_transition ( | |
143 id INTEGER DEFAULT NEXTVAL('wkf_transition_id_seq') NOT NULL, | |
144 act_from INTEGER NOT NULL, | |
145 act_to INTEGER NOT NULL, | |
146 condition VARCHAR NOT NULL, | |
147 trigger_expr_id VARCHAR, | |
148 signal VARCHAR, | |
149 "group" INTEGER, | |
150 PRIMARY KEY(id), | |
151 FOREIGN KEY (act_from) REFERENCES wkf_activity (id) ON DELETE CASCADE, | |
152 FOREIGN KEY (act_to) REFERENCES wkf_activity (id) ON DELETE CASCADE, | |
153 FOREIGN KEY ("group") REFERENCES res_group (id) ON DELETE SET NULL | |
154 ); | |
155 | |
156 CREATE SEQUENCE wkf_instance_id_seq; | |
157 | |
158 CREATE TABLE wkf_instance ( | |
159 id INTEGER DEFAULT NEXTVAL('wkf_instance_id_seq') NOT NULL, | |
160 workflow INTEGER, | |
161 uid INTEGER DEFAULT 0, | |
162 res_id INT NOT NULL DEFAULT 0, | |
163 res_type VARCHAR NOT NULL, | |
164 state VARCHAR NOT NULL, | |
165 PRIMARY KEY(id), | |
166 FOREIGN KEY (workflow) REFERENCES wkf (id) ON DELETE RESTRICT | |
167 ); | |
168 | |
169 CREATE SEQUENCE wkf_workitem_id_seq; | |
170 | |
171 CREATE TABLE wkf_workitem ( | |
172 id INTEGER DEFAULT NEXTVAL('wkf_workitem_id_seq') NOT NULL, | |
173 activity INTEGER NOT NULL, | |
174 instance INTEGER NOT NULL, | |
175 subflow INTEGER, | |
176 state VARCHAR, | |
177 PRIMARY KEY(id), | |
178 FOREIGN KEY (activity) REFERENCES wkf_activity (id) ON DELETE CASCADE, | |
179 FOREIGN KEY (instance) REFERENCES wkf_instance (id) ON DELETE CASCADE, | |
180 FOREIGN KEY (subflow) REFERENCES wkf_instance (id) ON DELETE CASCADE | |
181 ); | |
182 | |
183 CREATE SEQUENCE wkf_witm_trans_id_seq; | |
184 | |
185 CREATE TABLE wkf_witm_trans ( | |
186 id INTEGER DEFAULT NEXTVAL('wkf_witm_trans_id_seq') NOT NULL, | |
187 trans_id INTEGER NOT NULL, | |
188 inst_id INTEGER NOT NULL, | |
189 PRIMARY KEY(id), | |
190 FOREIGN KEY (trans_id) REFERENCES wkf_transition ON DELETE CASCADE, | |
191 FOREIGN KEY (inst_id) REFERENCES wkf_instance ON DELETE CASCADE | |
192 ); | 110 ); |
193 | 111 |
194 CREATE SEQUENCE ir_module_module_id_seq; | 112 CREATE SEQUENCE ir_module_module_id_seq; |
195 | 113 |
196 CREATE TABLE ir_module_module ( | 114 CREATE TABLE ir_module_module ( |
197 id INTEGER DEFAULT NEXTVAL('ir_module_module_id_seq') NOT NULL, | 115 id INTEGER DEFAULT NEXTVAL('ir_module_module_id_seq') NOT NULL, |
198 create_uid INTEGER NOT NULL, | 116 create_uid INTEGER NOT NULL, |
199 create_date TIMESTAMP WITHOUT TIME ZONE NOT NULL, | 117 create_date TIMESTAMP WITHOUT TIME ZONE NOT NULL, |
200 write_date TIMESTAMP WITHOUT TIME ZONE, | 118 write_date TIMESTAMP WITHOUT TIME ZONE, |
201 write_uid INTEGER, | 119 write_uid INTEGER, |
202 website VARCHAR, | |
203 name VARCHAR NOT NULL, | 120 name VARCHAR NOT NULL, |
204 author VARCHAR, | |
205 url VARCHAR, | |
206 state VARCHAR, | 121 state VARCHAR, |
207 shortdesc VARCHAR, | |
208 description TEXT, | |
209 PRIMARY KEY(id), | 122 PRIMARY KEY(id), |
210 FOREIGN KEY (create_uid) REFERENCES res_user ON DELETE SET NULL, | 123 FOREIGN KEY (create_uid) REFERENCES res_user ON DELETE SET NULL, |
211 FOREIGN KEY (write_uid) REFERENCES res_user ON DELETE SET NULL | 124 FOREIGN KEY (write_uid) REFERENCES res_user ON DELETE SET NULL |
212 ); | 125 ); |
213 | 126 |
214 ALTER TABLE ir_module_module ADD CONSTRAINT name_uniq UNIQUE (name); | 127 ALTER TABLE ir_module_module ADD CONSTRAINT name_uniq UNIQUE (name); |
215 | 128 |
216 CREATE SEQUENCE ir_module_module_dependency_id_seq; | 129 CREATE SEQUENCE ir_module_module_dependency_id_seq; |
217 | 130 |
218 CREATE TABLE ir_module_module_dependency ( | 131 CREATE TABLE ir_module_module_dependency ( |
219 id INTEGER DEFAULT NEXTVAL('ir_module_module_dependency_id_seq') NOT NULL, | 132 id INTEGER DEFAULT NEXTVAL('ir_module_module_dependency_id_seq') NOT NULL, |
220 create_uid INTEGER NOT NULL, | 133 create_uid INTEGER NOT NULL, |
221 create_date TIMESTAMP WITHOUT TIME ZONE NOT NULL, | 134 create_date TIMESTAMP WITHOUT TIME ZONE NOT NULL, |
222 write_date TIMESTAMP WITHOUT TIME ZONE, | 135 write_date TIMESTAMP WITHOUT TIME ZONE, |
223 write_uid INTEGER, | 136 write_uid INTEGER, |
224 name VARCHAR, | 137 name VARCHAR, |
225 module INTEGER, | 138 module INTEGER, |
226 PRIMARY KEY(id), | 139 PRIMARY KEY(id), |
227 FOREIGN KEY (create_uid) REFERENCES res_user ON DELETE SET NULL, | 140 FOREIGN KEY (create_uid) REFERENCES res_user ON DELETE SET NULL, |
228 FOREIGN KEY (write_uid) REFERENCES res_user ON DELETE SET NULL, | 141 FOREIGN KEY (write_uid) REFERENCES res_user ON DELETE SET NULL, |
229 FOREIGN KEY (module) REFERENCES ir_module_module ON DELETE CASCADE | 142 FOREIGN KEY (module) REFERENCES ir_module_module ON DELETE CASCADE |
230 ); | 143 ); |
LEFT | RIGHT |