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,
53 -------------------------------------------------------------------------
55 -------------------------------------------------------------------------
57 CREATE TABLE ir_actions (
59 name varchar(64) DEFAULT ''::varchar NOT NULL,
60 "type" varchar(32) DEFAULT 'window'::varchar NOT NULL,
61 usage varchar(32) DEFAULT null,
65 CREATE TABLE ir_act_window (
67 res_model varchar(64),
68 view_type varchar(16),
69 "domain" varchar(250),
72 INHERITS (ir_actions);
74 CREATE TABLE ir_act_report_xml (
75 model varchar(64) NOT NULL,
76 report_name varchar(64) NOT NULL,
77 report_xsl varchar(256),
78 report_xml varchar(256),
79 auto boolean default true,
82 INHERITS (ir_actions);
84 create table ir_act_report_custom (
86 -- report_id int references ir_report_custom
89 INHERITS (ir_actions);
91 CREATE TABLE ir_act_wizard (
92 wiz_name varchar(64) NOT NULL,
95 INHERITS (ir_actions);
97 CREATE TABLE ir_act_url (
99 target varchar(64) NOT NULL,
102 INHERITS (ir_actions);
104 CREATE TABLE ir_act_server (
107 INHERITS (ir_actions);
109 CREATE TABLE ir_act_client (
112 INHERITS (ir_actions);
115 CREATE TABLE ir_ui_view (
117 name varchar(64) DEFAULT ''::varchar NOT NULL,
118 model varchar(64) DEFAULT ''::varchar NOT NULL,
119 "type" varchar(64) DEFAULT 'form'::varchar NOT NULL,
121 field_parent varchar(64),
122 priority integer DEFAULT 5 NOT NULL,
126 CREATE TABLE ir_ui_menu (
128 parent_id int references ir_ui_menu on delete set null,
129 name varchar(64) DEFAULT ''::varchar NOT NULL,
130 icon varchar(64) DEFAULT ''::varchar,
134 select setval('ir_ui_menu_id_seq', 2);
136 ---------------------------------
138 ---------------------------------
141 -- 0 RESTRICT TO USER
142 -- 1 RESTRICT TO GROUP
145 CREATE TABLE res_users (
147 name varchar(64) not null,
148 active boolean default True,
149 login varchar(64) NOT NULL UNIQUE,
150 password varchar(64) default null,
151 email varchar(64) default null,
152 context_tz varchar(64) default null,
154 context_lang varchar(64) default '',
155 -- No FK references below, will be added later by ORM
156 -- (when the destination rows exist)
160 alter table res_users add constraint res_users_login_uniq unique (login);
162 CREATE TABLE res_groups (
164 name varchar(64) NOT NULL,
168 CREATE TABLE res_groups_users_rel (
169 uid integer NOT NULL references res_users on delete cascade,
170 gid integer NOT NULL references res_groups on delete cascade,
174 create index res_groups_users_rel_uid_idx on res_groups_users_rel (uid);
175 create index res_groups_users_rel_gid_idx on res_groups_users_rel (gid);
178 ---------------------------------
180 ---------------------------------
187 on_create bool default False,
191 create table wkf_activity
194 wkf_id int references wkf on delete cascade,
195 subflow_id int references wkf on delete set null,
196 split_mode varchar(3) default 'XOR',
197 join_mode varchar(3) default 'XOR',
198 kind varchar(16) not null default 'dummy',
200 signal_send varchar(32) default null,
201 flow_start boolean default False,
202 flow_stop boolean default False,
203 action text default null,
207 create table wkf_transition
210 act_from int references wkf_activity on delete cascade,
211 act_to int references wkf_activity on delete cascade,
212 condition varchar(128) default NULL,
214 trigger_type varchar(128) default NULL,
215 trigger_expr_id varchar(128) default NULL,
217 signal varchar(64) default null,
218 group_id int references res_groups on delete set null,
223 create table wkf_instance
226 wkf_id int references wkf on delete restrict,
227 uid int default null,
229 res_type varchar(64) not null,
230 state varchar(32) not null default 'active',
234 create table wkf_workitem
237 act_id int not null references wkf_activity on delete cascade,
238 inst_id int not null references wkf_instance on delete cascade,
239 subflow_id int references wkf_instance on delete cascade,
240 state varchar(64) default 'blocked',
244 create table wkf_witm_trans
246 trans_id int not null references wkf_transition on delete cascade,
247 inst_id int not null references wkf_instance on delete cascade
250 create index wkf_witm_trans_inst_idx on wkf_witm_trans (inst_id);
252 create table wkf_logs
255 res_type varchar(128) not null,
257 uid int references res_users on delete set null,
258 act_id int references wkf_activity on delete set null,
260 info varchar(128) default NULL,
264 ---------------------------------
266 ---------------------------------
268 CREATE TABLE ir_module_category (
270 create_uid integer references res_users on delete set null,
271 create_date timestamp without time zone,
272 write_date timestamp without time zone,
273 write_uid integer references res_users on delete set null,
274 parent_id integer REFERENCES ir_module_category ON DELETE SET NULL,
275 name character varying(128) NOT NULL,
280 CREATE TABLE ir_module_module (
282 create_uid integer references res_users on delete set null,
283 create_date timestamp without time zone,
284 write_date timestamp without time zone,
285 write_uid integer references res_users on delete set null,
286 website character varying(256),
287 name character varying(128) NOT NULL,
288 author character varying(128),
289 url character varying(128),
290 state character varying(16),
291 latest_version character varying(64),
292 shortdesc character varying(256),
293 complexity character varying(32),
294 category_id integer REFERENCES ir_module_category ON DELETE SET NULL,
295 certificate character varying(64),
297 demo boolean default False,
298 web boolean DEFAULT FALSE,
299 license character varying(32),
302 ALTER TABLE ir_module_module add constraint name_uniq unique (name);
304 CREATE TABLE ir_module_module_dependency (
306 create_uid integer references res_users on delete set null,
307 create_date timestamp without time zone,
308 write_date timestamp without time zone,
309 write_uid integer references res_users on delete set null,
310 name character varying(128),
311 version_pattern character varying(128) default NULL,
312 module_id integer REFERENCES ir_module_module ON DELETE cascade,
316 CREATE TABLE res_company (
318 name character varying(64) not null,
319 parent_id integer references res_company on delete set null,
323 CREATE TABLE ir_model_data (
326 create_date timestamp without time zone,
327 write_date timestamp without time zone,
330 name character varying(128) NOT NULL,
331 date_init timestamp without time zone,
332 date_update timestamp without time zone,
333 module character varying(64) NOT NULL,
334 model character varying(64) NOT NULL,
335 res_id integer, primary key(id)
338 ---------------------------------
340 ---------------------------------
342 insert into res_users (id,login,password,name,active,company_id,context_lang) values (1,'admin','admin','Administrator',True,1,'en_US');
343 insert into ir_model_data (name,module,model,noupdate,res_id) values ('user_root','base','res.users',True,1);
345 -- Compatibility purpose, to remove V6.0
346 insert into ir_model_data (name,module,model,noupdate,res_id) values ('user_admin','base','res.users',True,1);
348 select setval('res_users_id_seq', 2);