1 -------------------------------------------------------------------------
3 -------------------------------------------------------------------------
5 -------------------------------------------------------------------------
7 -------------------------------------------------------------------------
12 name varchar(128) not null,
13 key varchar(128) not null,
14 key2 varchar(256) not null,
15 model varchar(128) not null,
17 meta text default NULL,
18 res_id integer default null,
22 -------------------------------------------------------------------------
23 -- Modules Description
24 -------------------------------------------------------------------------
26 CREATE TABLE ir_model (
28 model varchar(64) DEFAULT ''::varchar NOT NULL,
35 CREATE TABLE ir_model_fields (
37 model varchar(64) DEFAULT ''::varchar NOT NULL,
38 model_id int references ir_model on delete cascade,
39 name varchar(64) DEFAULT ''::varchar NOT NULL,
41 select_level varchar(4),
42 field_description varchar(256),
44 state varchar(64) default 'base',
46 relate boolean default False,
47 relation_field varchar(128),
48 translate boolean default False,
52 ALTER TABLE ir_model_fields ADD column serialization_field_id int references ir_model_fields on delete cascade;
55 -------------------------------------------------------------------------
57 -------------------------------------------------------------------------
59 CREATE TABLE ir_actions (
61 name varchar(64) DEFAULT ''::varchar NOT NULL,
62 "type" varchar(32) NOT NULL,
63 usage varchar(32) DEFAULT null,
67 CREATE TABLE ir_act_window (
69 res_model varchar(64),
70 view_type varchar(16),
71 "domain" varchar(250),
74 INHERITS (ir_actions);
76 CREATE TABLE ir_act_report_xml (
77 model varchar(64) NOT NULL,
78 report_name varchar(64) NOT NULL,
79 report_xsl varchar(256),
80 report_xml varchar(256),
81 auto boolean default true,
84 INHERITS (ir_actions);
86 create table ir_act_report_custom (
88 -- report_id int references ir_report_custom
91 INHERITS (ir_actions);
93 CREATE TABLE ir_act_wizard (
94 wiz_name varchar(64) NOT NULL,
97 INHERITS (ir_actions);
99 CREATE TABLE ir_act_url (
101 target varchar(64) NOT NULL,
104 INHERITS (ir_actions);
106 CREATE TABLE ir_act_server (
109 INHERITS (ir_actions);
111 CREATE TABLE ir_act_client (
114 INHERITS (ir_actions);
117 CREATE TABLE ir_ui_view (
119 name varchar(64) DEFAULT ''::varchar NOT NULL,
120 model varchar(64) DEFAULT ''::varchar NOT NULL,
121 "type" varchar(64) DEFAULT 'form'::varchar NOT NULL,
123 field_parent varchar(64),
124 priority integer DEFAULT 5 NOT NULL,
128 CREATE TABLE ir_ui_menu (
130 parent_id int references ir_ui_menu on delete set null,
131 name varchar(64) DEFAULT ''::varchar NOT NULL,
132 icon varchar(64) DEFAULT ''::varchar,
136 select setval('ir_ui_menu_id_seq', 2);
138 ---------------------------------
140 ---------------------------------
143 -- 0 RESTRICT TO USER
144 -- 1 RESTRICT TO GROUP
147 CREATE TABLE res_users (
149 name varchar(64) not null,
150 active boolean default True,
151 login varchar(64) NOT NULL UNIQUE,
152 password varchar(64) default null,
153 email varchar(64) default null,
154 context_tz varchar(64) default null,
156 context_lang varchar(64) default '',
157 -- No FK references below, will be added later by ORM
158 -- (when the destination rows exist)
162 alter table res_users add constraint res_users_login_uniq unique (login);
164 CREATE TABLE res_groups (
166 name varchar(64) NOT NULL,
170 CREATE TABLE res_groups_users_rel (
171 uid integer NOT NULL references res_users on delete cascade,
172 gid integer NOT NULL references res_groups on delete cascade,
176 create index res_groups_users_rel_uid_idx on res_groups_users_rel (uid);
177 create index res_groups_users_rel_gid_idx on res_groups_users_rel (gid);
180 ---------------------------------
182 ---------------------------------
189 on_create bool default False,
193 create table wkf_activity
196 wkf_id int references wkf on delete cascade,
197 subflow_id int references wkf on delete set null,
198 split_mode varchar(3) default 'XOR',
199 join_mode varchar(3) default 'XOR',
200 kind varchar(16) not null default 'dummy',
202 signal_send varchar(32) default null,
203 flow_start boolean default False,
204 flow_stop boolean default False,
205 action text default null,
209 create table wkf_transition
212 act_from int references wkf_activity on delete cascade,
213 act_to int references wkf_activity on delete cascade,
214 condition varchar(128) default NULL,
216 trigger_type varchar(128) default NULL,
217 trigger_expr_id varchar(128) default NULL,
219 signal varchar(64) default null,
220 group_id int references res_groups on delete set null,
225 create table wkf_instance
228 wkf_id int references wkf on delete restrict,
229 uid int default null,
231 res_type varchar(64) not null,
232 state varchar(32) not null default 'active',
236 create table wkf_workitem
239 act_id int not null references wkf_activity on delete cascade,
240 inst_id int not null references wkf_instance on delete cascade,
241 subflow_id int references wkf_instance on delete cascade,
242 state varchar(64) default 'blocked',
246 create table wkf_witm_trans
248 trans_id int not null references wkf_transition on delete cascade,
249 inst_id int not null references wkf_instance on delete cascade
252 create index wkf_witm_trans_inst_idx on wkf_witm_trans (inst_id);
254 create table wkf_logs
257 res_type varchar(128) not null,
259 uid int references res_users on delete set null,
260 act_id int references wkf_activity on delete set null,
262 info varchar(128) default NULL,
266 ---------------------------------
268 ---------------------------------
270 CREATE TABLE ir_module_category (
272 create_uid integer references res_users on delete set null,
273 create_date timestamp without time zone,
274 write_date timestamp without time zone,
275 write_uid integer references res_users on delete set null,
276 parent_id integer REFERENCES ir_module_category ON DELETE SET NULL,
277 name character varying(128) NOT NULL,
282 CREATE TABLE ir_module_module (
284 create_uid integer references res_users on delete set null,
285 create_date timestamp without time zone,
286 write_date timestamp without time zone,
287 write_uid integer references res_users on delete set null,
288 website character varying(256),
289 summary character varying(256),
290 name character varying(128) NOT NULL,
291 author character varying(128),
292 url character varying(128),
293 icon character varying(64),
294 state character varying(16),
295 latest_version character varying(64),
296 shortdesc character varying(256),
297 complexity character varying(32),
298 category_id integer REFERENCES ir_module_category ON DELETE SET NULL,
299 certificate character varying(64),
301 application boolean default False,
302 demo boolean default False,
303 web boolean DEFAULT FALSE,
304 license character varying(32),
305 sequence integer DEFAULT 100,
306 auto_install boolean default False,
309 ALTER TABLE ir_module_module add constraint name_uniq unique (name);
311 CREATE TABLE ir_module_module_dependency (
313 create_uid integer references res_users on delete set null,
314 create_date timestamp without time zone,
315 write_date timestamp without time zone,
316 write_uid integer references res_users on delete set null,
317 name character varying(128),
318 version_pattern character varying(128) default NULL,
319 module_id integer REFERENCES ir_module_module ON DELETE cascade,
323 CREATE TABLE res_company (
325 name character varying(64) not null,
326 parent_id integer references res_company on delete set null,
330 CREATE TABLE res_lang (
331 id serial PRIMARY KEY,
332 name VARCHAR(64) NOT NULL UNIQUE,
333 code VARCHAR(16) NOT NULL UNIQUE
336 CREATE TABLE ir_model_data (
339 create_date timestamp without time zone,
340 write_date timestamp without time zone,
343 name character varying(128) NOT NULL,
344 date_init timestamp without time zone,
345 date_update timestamp without time zone,
346 module character varying(64) NOT NULL,
347 model character varying(64) NOT NULL,
348 res_id integer, primary key(id)
351 -- Records foreign keys and constraints installed by a module (so they can be
352 -- removed when the module is uninstalled):
353 -- - for a foreign key: type is 'f',
354 -- - for a constraint: type is 'u' (this is the convention PostgreSQL uses).
355 CREATE TABLE ir_model_constraint (
358 create_date timestamp without time zone,
359 write_date timestamp without time zone,
361 date_init timestamp without time zone,
362 date_update timestamp without time zone,
363 module integer NOT NULL references ir_module_module on delete restrict,
364 model integer NOT NULL references ir_model on delete restrict,
365 type character varying(1) NOT NULL,
366 name character varying(128) NOT NULL
369 -- Records relation tables (i.e. implementing many2many) installed by a module
370 -- (so they can be removed when the module is uninstalled).
371 CREATE TABLE ir_model_relation (
374 create_date timestamp without time zone,
375 write_date timestamp without time zone,
377 date_init timestamp without time zone,
378 date_update timestamp without time zone,
379 module integer NOT NULL references ir_module_module on delete restrict,
380 model integer NOT NULL references ir_model on delete restrict,
381 name character varying(128) NOT NULL
384 ---------------------------------
386 ---------------------------------
388 insert into res_users (id,login,password,name,active,company_id,context_lang) values (1,'admin','admin','Administrator',True,1,'en_US');
389 insert into ir_model_data (name,module,model,noupdate,res_id) values ('user_root','base','res.users',True,1);
391 -- Compatibility purpose, to remove V6.0
392 insert into ir_model_data (name,module,model,noupdate,res_id) values ('user_admin','base','res.users',True,1);
394 select setval('res_users_id_seq', 2);