1 -------------------------------------------------------------------------
3 -------------------------------------------------------------------------
5 -------------------------------------------------------------------------
7 -------------------------------------------------------------------------
12 name varchar(128) not null,
13 key varchar(128) not null,
14 key2 varchar(128) 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,
51 -------------------------------------------------------------------------
53 -------------------------------------------------------------------------
55 CREATE TABLE ir_actions (
57 name varchar(64) DEFAULT ''::varchar NOT NULL,
58 "type" varchar(64) DEFAULT 'window'::varchar NOT NULL,
59 usage varchar(32) DEFAULT null,
63 CREATE TABLE ir_act_window (
65 res_model varchar(64),
66 view_type varchar(16),
67 "domain" varchar(127),
70 INHERITS (ir_actions);
72 CREATE TABLE ir_act_report_xml (
73 model varchar(64) NOT NULL,
74 report_name varchar(64) NOT NULL,
75 report_xsl varchar(64),
76 report_xml varchar(64),
77 auto boolean default true,
80 INHERITS (ir_actions);
82 create table ir_act_report_custom (
84 -- report_id int references ir_report_custom
87 INHERITS (ir_actions);
89 CREATE TABLE ir_act_wizard (
90 wiz_name varchar(64) NOT NULL,
93 INHERITS (ir_actions);
95 CREATE TABLE ir_act_url (
97 target varchar(64) NOT NULL,
100 INHERITS (ir_actions);
102 CREATE TABLE ir_act_server (
105 INHERITS (ir_actions);
108 CREATE TABLE ir_ui_view (
110 name varchar(64) DEFAULT ''::varchar NOT NULL,
111 model varchar(64) DEFAULT ''::varchar NOT NULL,
112 "type" varchar(64) DEFAULT 'form'::varchar NOT NULL,
114 field_parent varchar(64),
115 priority integer DEFAULT 5 NOT NULL,
119 CREATE TABLE ir_ui_menu (
121 parent_id int references ir_ui_menu on delete set null,
122 name varchar(64) DEFAULT ''::varchar NOT NULL,
123 icon varchar(64) DEFAULT ''::varchar,
127 select setval('ir_ui_menu_id_seq', 2);
129 ---------------------------------
131 ---------------------------------
134 -- 0 RESTRICT TO USER
135 -- 1 RESTRICT TO GROUP
138 CREATE TABLE res_users (
140 name varchar(64) not null,
141 active boolean default True,
142 login varchar(64) NOT NULL UNIQUE,
143 password varchar(32) default null,
144 context_tz varchar(64) default null,
146 -- action_id int references ir_act_window on delete set null,
150 alter table res_users add constraint res_users_login_uniq unique (login);
152 CREATE TABLE res_groups (
154 name varchar(32) NOT NULL,
158 create table res_roles (
160 parent_id int references res_roles on delete set null,
161 name varchar(32) NOT NULL,
165 CREATE TABLE res_roles_users_rel (
166 uid integer NOT NULL references res_users on delete cascade,
167 rid integer NOT NULL references res_roles on delete cascade
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
175 ---------------------------------
177 ---------------------------------
184 on_create bool default False,
188 create table wkf_activity
191 wkf_id int references wkf on delete cascade,
192 subflow_id int references wkf on delete set null,
193 split_mode varchar(3) default 'XOR',
194 join_mode varchar(3) default 'XOR',
195 kind varchar(16) not null default 'dummy',
197 signal_send varchar(32) default null,
198 flow_start boolean default False,
199 flow_stop boolean default False,
200 action varchar(64) default null,
204 create table wkf_transition
207 act_from int references wkf_activity on delete cascade,
208 act_to int references wkf_activity on delete cascade,
209 condition varchar(128) default NULL,
211 trigger_type varchar(128) default NULL,
212 trigger_expr_id varchar(128) default NULL,
214 signal varchar(64) default null,
215 role_id int references res_roles on delete set null,
220 create table wkf_instance
223 wkf_id int references wkf on delete restrict,
224 uid int default null,
226 res_type varchar(64) not null,
227 state varchar(32) not null default 'active',
231 create table wkf_workitem
234 act_id int not null references wkf_activity on delete cascade,
235 inst_id int not null references wkf_instance on delete cascade,
236 subflow_id int references wkf_instance on delete cascade,
237 state varchar(64) default 'blocked',
241 create table wkf_witm_trans
243 trans_id int not null references wkf_transition on delete cascade,
244 inst_id int not null references wkf_instance on delete cascade
247 create table wkf_logs
250 res_type varchar(128) not null,
252 uid int references res_users on delete set null,
253 act_id int references wkf_activity on delete set null,
255 info varchar(128) default NULL,
259 ---------------------------------
261 ---------------------------------
263 CREATE TABLE ir_module_category (
265 create_uid integer references res_users on delete set null,
266 create_date timestamp without time zone,
267 write_date timestamp without time zone,
268 write_uid integer references res_users on delete set null,
269 parent_id integer REFERENCES ir_module_category ON DELETE SET NULL,
270 name character varying(128) NOT NULL,
275 CREATE TABLE ir_module_module (
277 create_uid integer references res_users on delete set null,
278 create_date timestamp without time zone,
279 write_date timestamp without time zone,
280 write_uid integer references res_users on delete set null,
281 website character varying(256),
282 name character varying(128) NOT NULL,
283 author character varying(128),
284 url character varying(128),
285 state character varying(16),
286 latest_version character varying(64),
287 shortdesc character varying(256),
288 category_id integer REFERENCES ir_module_category ON DELETE SET NULL,
290 demo boolean default False,
293 ALTER TABLE ir_module_module add constraint name_uniq unique (name);
295 CREATE TABLE ir_module_module_dependency (
297 create_uid integer references res_users on delete set null,
298 create_date timestamp without time zone,
299 write_date timestamp without time zone,
300 write_uid integer references res_users on delete set null,
301 name character varying(128),
302 version_pattern character varying(128) default NULL,
303 module_id integer REFERENCES ir_module_module ON DELETE cascade,
307 CREATE TABLE res_company (
309 name character varying(64) not null,
310 parent_id integer references res_company on delete set null,
314 CREATE TABLE ir_model_data (
317 create_date timestamp without time zone,
318 write_date timestamp without time zone,
321 name character varying(64) NOT NULL,
322 date_init timestamp without time zone,
323 date_update timestamp without time zone,
324 module character varying(64) NOT NULL,
325 model character varying(64) NOT NULL,
326 res_id integer, primary key(id)
329 ---------------------------------
331 ---------------------------------
333 insert into res_users (id,login,password,name,action_id,active) values (1,'admin',NULL,'Administrator',NULL,True);
334 insert into ir_model_data (name,module,model,noupdate,res_id) values ('user_root','base','res.users',True,1);
336 -- Compatibility purpose, to remove V6.0
337 insert into ir_model_data (name,module,model,noupdate,res_id) values ('user_admin','base','res.users',True,1);
339 select setval('res_users_id_seq', 2);