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),
52 -------------------------------------------------------------------------
54 -------------------------------------------------------------------------
56 CREATE TABLE ir_actions (
58 name varchar(64) DEFAULT ''::varchar NOT NULL,
59 "type" varchar(32) DEFAULT 'window'::varchar NOT NULL,
60 usage varchar(32) DEFAULT null,
64 CREATE TABLE ir_act_window (
66 res_model varchar(64),
67 view_type varchar(16),
68 "domain" varchar(250),
71 INHERITS (ir_actions);
73 CREATE TABLE ir_act_report_xml (
74 model varchar(64) NOT NULL,
75 report_name varchar(64) NOT NULL,
76 report_xsl varchar(256),
77 report_xml varchar(256),
78 auto boolean default true,
81 INHERITS (ir_actions);
83 create table ir_act_report_custom (
85 -- report_id int references ir_report_custom
88 INHERITS (ir_actions);
90 CREATE TABLE ir_act_wizard (
91 wiz_name varchar(64) NOT NULL,
94 INHERITS (ir_actions);
96 CREATE TABLE ir_act_url (
98 target varchar(64) NOT NULL,
101 INHERITS (ir_actions);
103 CREATE TABLE ir_act_server (
106 INHERITS (ir_actions);
109 CREATE TABLE ir_ui_view (
111 name varchar(64) DEFAULT ''::varchar NOT NULL,
112 model varchar(64) DEFAULT ''::varchar NOT NULL,
113 "type" varchar(64) DEFAULT 'form'::varchar NOT NULL,
115 field_parent varchar(64),
116 priority integer DEFAULT 5 NOT NULL,
120 CREATE TABLE ir_ui_menu (
122 parent_id int references ir_ui_menu on delete set null,
123 name varchar(64) DEFAULT ''::varchar NOT NULL,
124 icon varchar(64) DEFAULT ''::varchar,
128 select setval('ir_ui_menu_id_seq', 2);
130 ---------------------------------
132 ---------------------------------
135 -- 0 RESTRICT TO USER
136 -- 1 RESTRICT TO GROUP
139 CREATE TABLE res_users (
141 name varchar(64) not null,
142 active boolean default True,
143 login varchar(64) NOT NULL UNIQUE,
144 password varchar(64) default null,
145 email varchar(64) default null,
146 context_tz varchar(64) default null,
148 context_lang varchar(64) default '',
149 -- No FK references below, will be added later by ORM
150 -- (when the destination rows exist)
155 alter table res_users add constraint res_users_login_uniq unique (login);
157 CREATE TABLE res_groups (
159 name varchar(64) NOT NULL,
163 create table res_roles (
165 parent_id int references res_roles on delete set null,
166 name varchar(64) NOT NULL,
170 CREATE TABLE res_roles_users_rel (
171 uid integer NOT NULL references res_users on delete cascade,
172 rid integer NOT NULL references res_roles on delete cascade
174 create index res_roles_users_rel_uid_idx on res_roles_users_rel (uid);
175 create index res_roles_users_rel_rid_idx on res_roles_users_rel (rid);
177 CREATE TABLE res_groups_users_rel (
178 uid integer NOT NULL references res_users on delete cascade,
179 gid integer NOT NULL references res_groups on delete cascade
182 create index res_groups_users_rel_uid_idx on res_groups_users_rel (uid);
183 create index res_groups_users_rel_gid_idx on res_groups_users_rel (gid);
186 ---------------------------------
188 ---------------------------------
195 on_create bool default False,
199 create table wkf_activity
202 wkf_id int references wkf on delete cascade,
203 subflow_id int references wkf on delete set null,
204 split_mode varchar(3) default 'XOR',
205 join_mode varchar(3) default 'XOR',
206 kind varchar(16) not null default 'dummy',
208 signal_send varchar(32) default null,
209 flow_start boolean default False,
210 flow_stop boolean default False,
211 action text default null,
215 create table wkf_transition
218 act_from int references wkf_activity on delete cascade,
219 act_to int references wkf_activity on delete cascade,
220 condition varchar(128) default NULL,
222 trigger_type varchar(128) default NULL,
223 trigger_expr_id varchar(128) default NULL,
225 signal varchar(64) default null,
226 role_id int references res_roles on delete set null,
231 create table wkf_instance
234 wkf_id int references wkf on delete restrict,
235 uid int default null,
237 res_type varchar(64) not null,
238 state varchar(32) not null default 'active',
242 create table wkf_workitem
245 act_id int not null references wkf_activity on delete cascade,
246 inst_id int not null references wkf_instance on delete cascade,
247 subflow_id int references wkf_instance on delete cascade,
248 state varchar(64) default 'blocked',
252 create table wkf_witm_trans
254 trans_id int not null references wkf_transition on delete cascade,
255 inst_id int not null references wkf_instance on delete cascade
258 create index wkf_witm_trans_inst_idx on wkf_witm_trans (inst_id);
260 create table wkf_logs
263 res_type varchar(128) not null,
265 uid int references res_users on delete set null,
266 act_id int references wkf_activity on delete set null,
268 info varchar(128) default NULL,
272 ---------------------------------
274 ---------------------------------
276 CREATE TABLE ir_module_category (
278 create_uid integer references res_users on delete set null,
279 create_date timestamp without time zone,
280 write_date timestamp without time zone,
281 write_uid integer references res_users on delete set null,
282 parent_id integer REFERENCES ir_module_category ON DELETE SET NULL,
283 name character varying(128) NOT NULL,
288 CREATE TABLE ir_module_module (
290 create_uid integer references res_users on delete set null,
291 create_date timestamp without time zone,
292 write_date timestamp without time zone,
293 write_uid integer references res_users on delete set null,
294 website character varying(256),
295 name character varying(128) NOT NULL,
296 author character varying(128),
297 url character varying(128),
298 state character varying(16),
299 latest_version character varying(64),
300 shortdesc character varying(256),
301 category_id integer REFERENCES ir_module_category ON DELETE SET NULL,
302 certificate character varying(64),
304 demo boolean default False,
307 ALTER TABLE ir_module_module add constraint name_uniq unique (name);
309 CREATE TABLE ir_module_module_dependency (
311 create_uid integer references res_users on delete set null,
312 create_date timestamp without time zone,
313 write_date timestamp without time zone,
314 write_uid integer references res_users on delete set null,
315 name character varying(128),
316 version_pattern character varying(128) default NULL,
317 module_id integer REFERENCES ir_module_module ON DELETE cascade,
321 CREATE TABLE res_company (
323 name character varying(64) not null,
324 parent_id integer references res_company on delete set null,
328 CREATE TABLE ir_model_data (
331 create_date timestamp without time zone,
332 write_date timestamp without time zone,
335 name character varying(128) NOT NULL,
336 date_init timestamp without time zone,
337 date_update timestamp without time zone,
338 module character varying(64) NOT NULL,
339 model character varying(64) NOT NULL,
340 res_id integer, primary key(id)
343 ---------------------------------
345 ---------------------------------
347 insert into res_users (id,login,password,name,action_id,active,company_id) values (1,'admin',NULL,'Administrator',NULL,True,1);
348 insert into ir_model_data (name,module,model,noupdate,res_id) values ('user_root','base','res.users',True,1);
350 -- Compatibility purpose, to remove V6.0
351 insert into ir_model_data (name,module,model,noupdate,res_id) values ('user_admin','base','res.users',True,1);
353 select setval('res_users_id_seq', 2);