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) DEFAULT 'window'::varchar 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 name character varying(128) NOT NULL,
290 author character varying(128),
291 url character varying(128),
292 state character varying(16),
293 latest_version character varying(64),
294 shortdesc character varying(256),
295 category_id integer REFERENCES ir_module_category ON DELETE SET NULL,
296 certificate character varying(64),
298 demo boolean default False,
299 web boolean DEFAULT FALSE,
300 license character varying(32),
303 ALTER TABLE ir_module_module add constraint name_uniq unique (name);
305 CREATE TABLE ir_module_module_dependency (
307 create_uid integer references res_users on delete set null,
308 create_date timestamp without time zone,
309 write_date timestamp without time zone,
310 write_uid integer references res_users on delete set null,
311 name character varying(128),
312 version_pattern character varying(128) default NULL,
313 module_id integer REFERENCES ir_module_module ON DELETE cascade,
317 CREATE TABLE res_company (
319 name character varying(64) not null,
320 parent_id integer references res_company on delete set null,
324 CREATE TABLE ir_model_data (
327 create_date timestamp without time zone,
328 write_date timestamp without time zone,
331 name character varying(128) NOT NULL,
332 date_init timestamp without time zone,
333 date_update timestamp without time zone,
334 module character varying(64) NOT NULL,
335 model character varying(64) NOT NULL,
336 res_id integer, primary key(id)
339 ---------------------------------
341 ---------------------------------
343 insert into res_users (id,login,password,name,active,company_id,context_lang) values (1,'admin','admin','Administrator',True,1,'en_US');
344 insert into ir_model_data (name,module,model,noupdate,res_id) values ('user_root','base','res.users',True,1);
346 -- Compatibility purpose, to remove V6.0
347 insert into ir_model_data (name,module,model,noupdate,res_id) values ('user_admin','base','res.users',True,1);
349 select setval('res_users_id_seq', 2);