summaryrefslogtreecommitdiff
path: root/bin/addons/base/base.sql
diff options
context:
space:
mode:
authorVo Minh Thu <vmt@openerp.com>2011-02-07 13:57:23 +0100
committerVo Minh Thu <vmt@openerp.com>2011-02-07 13:57:23 +0100
commitf8572e5c602798f37c2a94d54ab5e3ac79ff0185 (patch)
tree35687977b932ac91bd31fece229ab78cc70926f5 /bin/addons/base/base.sql
parent9c287abc143a7b187635c75751a29baeefa58c15 (diff)
[IMP] openerp python module.
- Some logging code moved from netsvc.py to loglevels.py - Changed imports to use the new openerp module - config and netsvc initialization calls move to openerp-server.py - Moved openerp-server.py outside the old bin directory - Some imports in tools moved inside the methods to break mutual-dependencies bzr revid: vmt@openerp.com-20110207125723-ooee7d7ng5elmkso
Diffstat (limited to 'bin/addons/base/base.sql')
-rw-r--r--bin/addons/base/base.sql341
1 files changed, 0 insertions, 341 deletions
diff --git a/bin/addons/base/base.sql b/bin/addons/base/base.sql
deleted file mode 100644
index 802e71cfeb6..00000000000
--- a/bin/addons/base/base.sql
+++ /dev/null
@@ -1,341 +0,0 @@
--------------------------------------------------------------------------
--- Pure SQL
--------------------------------------------------------------------------
-
--------------------------------------------------------------------------
--- IR dictionary
--------------------------------------------------------------------------
-
-create table ir_values
-(
- id serial,
- name varchar(128) not null,
- key varchar(128) not null,
- key2 varchar(256) not null,
- model varchar(128) not null,
- value text,
- meta text default NULL,
- res_id integer default null,
- primary key (id)
-);
-
--------------------------------------------------------------------------
--- Modules Description
--------------------------------------------------------------------------
-
-CREATE TABLE ir_model (
- id serial,
- model varchar(64) DEFAULT ''::varchar NOT NULL,
- name varchar(64),
- state varchar(16),
- info text,
- primary key(id)
-);
-
-CREATE TABLE ir_model_fields (
- id serial,
- model varchar(64) DEFAULT ''::varchar NOT NULL,
- model_id int references ir_model on delete cascade,
- name varchar(64) DEFAULT ''::varchar NOT NULL,
- relation varchar(64),
- select_level varchar(4),
- field_description varchar(256),
- ttype varchar(64),
- state varchar(64) default 'base',
- view_load boolean,
- relate boolean default False,
- relation_field varchar(128),
- primary key(id)
-);
-
-
--------------------------------------------------------------------------
--- Actions
--------------------------------------------------------------------------
-
-CREATE TABLE ir_actions (
- id serial NOT NULL,
- name varchar(64) DEFAULT ''::varchar NOT NULL,
- "type" varchar(32) DEFAULT 'window'::varchar NOT NULL,
- usage varchar(32) DEFAULT null,
- primary key(id)
-);
-
-CREATE TABLE ir_act_window (
- view_id integer,
- res_model varchar(64),
- view_type varchar(16),
- "domain" varchar(250),
- primary key(id)
-)
-INHERITS (ir_actions);
-
-CREATE TABLE ir_act_report_xml (
- model varchar(64) NOT NULL,
- report_name varchar(64) NOT NULL,
- report_xsl varchar(256),
- report_xml varchar(256),
- auto boolean default true,
- primary key(id)
-)
-INHERITS (ir_actions);
-
-create table ir_act_report_custom (
- report_id int,
--- report_id int references ir_report_custom
- primary key(id)
-)
-INHERITS (ir_actions);
-
-CREATE TABLE ir_act_wizard (
- wiz_name varchar(64) NOT NULL,
- primary key(id)
-)
-INHERITS (ir_actions);
-
-CREATE TABLE ir_act_url (
- url text NOT NULL,
- target varchar(64) NOT NULL,
- primary key(id)
-)
-INHERITS (ir_actions);
-
-CREATE TABLE ir_act_server (
- primary key(id)
-)
-INHERITS (ir_actions);
-
-
-CREATE TABLE ir_ui_view (
- id serial NOT NULL,
- name varchar(64) DEFAULT ''::varchar NOT NULL,
- model varchar(64) DEFAULT ''::varchar NOT NULL,
- "type" varchar(64) DEFAULT 'form'::varchar NOT NULL,
- arch text NOT NULL,
- field_parent varchar(64),
- priority integer DEFAULT 5 NOT NULL,
- primary key(id)
-);
-
-CREATE TABLE ir_ui_menu (
- id serial NOT NULL,
- parent_id int references ir_ui_menu on delete set null,
- name varchar(64) DEFAULT ''::varchar NOT NULL,
- icon varchar(64) DEFAULT ''::varchar,
- primary key (id)
-);
-
-select setval('ir_ui_menu_id_seq', 2);
-
----------------------------------
--- Res users
----------------------------------
-
--- level:
--- 0 RESTRICT TO USER
--- 1 RESTRICT TO GROUP
--- 2 PUBLIC
-
-CREATE TABLE res_users (
- id serial NOT NULL,
- name varchar(64) not null,
- active boolean default True,
- login varchar(64) NOT NULL UNIQUE,
- password varchar(64) default null,
- email varchar(64) default null,
- context_tz varchar(64) default null,
- signature text,
- context_lang varchar(64) default '',
- -- No FK references below, will be added later by ORM
- -- (when the destination rows exist)
- company_id int,
- primary key(id)
-);
-alter table res_users add constraint res_users_login_uniq unique (login);
-
-CREATE TABLE res_groups (
- id serial NOT NULL,
- name varchar(64) NOT NULL,
- primary key(id)
-);
-
-CREATE TABLE res_groups_users_rel (
- uid integer NOT NULL references res_users on delete cascade,
- gid integer NOT NULL references res_groups on delete cascade,
- UNIQUE("uid","gid")
-);
-
-create index res_groups_users_rel_uid_idx on res_groups_users_rel (uid);
-create index res_groups_users_rel_gid_idx on res_groups_users_rel (gid);
-
-
----------------------------------
--- Workflows
----------------------------------
-
-create table wkf
-(
- id serial,
- name varchar(64),
- osv varchar(64),
- on_create bool default False,
- primary key(id)
-);
-
-create table wkf_activity
-(
- id serial,
- wkf_id int references wkf on delete cascade,
- subflow_id int references wkf on delete set null,
- split_mode varchar(3) default 'XOR',
- join_mode varchar(3) default 'XOR',
- kind varchar(16) not null default 'dummy',
- name varchar(64),
- signal_send varchar(32) default null,
- flow_start boolean default False,
- flow_stop boolean default False,
- action text default null,
- primary key(id)
-);
-
-create table wkf_transition
-(
- id serial,
- act_from int references wkf_activity on delete cascade,
- act_to int references wkf_activity on delete cascade,
- condition varchar(128) default NULL,
-
- trigger_type varchar(128) default NULL,
- trigger_expr_id varchar(128) default NULL,
-
- signal varchar(64) default null,
- group_id int references res_groups on delete set null,
-
- primary key(id)
-);
-
-create table wkf_instance
-(
- id serial,
- wkf_id int references wkf on delete restrict,
- uid int default null,
- res_id int not null,
- res_type varchar(64) not null,
- state varchar(32) not null default 'active',
- primary key(id)
-);
-
-create table wkf_workitem
-(
- id serial,
- act_id int not null references wkf_activity on delete cascade,
- inst_id int not null references wkf_instance on delete cascade,
- subflow_id int references wkf_instance on delete cascade,
- state varchar(64) default 'blocked',
- primary key(id)
-);
-
-create table wkf_witm_trans
-(
- trans_id int not null references wkf_transition on delete cascade,
- inst_id int not null references wkf_instance on delete cascade
-);
-
-create index wkf_witm_trans_inst_idx on wkf_witm_trans (inst_id);
-
-create table wkf_logs
-(
- id serial,
- res_type varchar(128) not null,
- res_id int not null,
- uid int references res_users on delete set null,
- act_id int references wkf_activity on delete set null,
- time time not null,
- info varchar(128) default NULL,
- primary key(id)
-);
-
----------------------------------
--- Modules
----------------------------------
-
-CREATE TABLE ir_module_category (
- id serial NOT NULL,
- create_uid integer references res_users on delete set null,
- create_date timestamp without time zone,
- write_date timestamp without time zone,
- write_uid integer references res_users on delete set null,
- parent_id integer REFERENCES ir_module_category ON DELETE SET NULL,
- name character varying(128) NOT NULL,
- primary key(id)
-);
-
-
-CREATE TABLE ir_module_module (
- id serial NOT NULL,
- create_uid integer references res_users on delete set null,
- create_date timestamp without time zone,
- write_date timestamp without time zone,
- write_uid integer references res_users on delete set null,
- website character varying(256),
- name character varying(128) NOT NULL,
- author character varying(128),
- url character varying(128),
- state character varying(16),
- latest_version character varying(64),
- shortdesc character varying(256),
- category_id integer REFERENCES ir_module_category ON DELETE SET NULL,
- certificate character varying(64),
- description text,
- demo boolean default False,
- web boolean DEFAULT FALSE,
- license character varying(32),
- primary key(id)
-);
-ALTER TABLE ir_module_module add constraint name_uniq unique (name);
-
-CREATE TABLE ir_module_module_dependency (
- id serial NOT NULL,
- create_uid integer references res_users on delete set null,
- create_date timestamp without time zone,
- write_date timestamp without time zone,
- write_uid integer references res_users on delete set null,
- name character varying(128),
- version_pattern character varying(128) default NULL,
- module_id integer REFERENCES ir_module_module ON DELETE cascade,
- primary key(id)
-);
-
-CREATE TABLE res_company (
- id serial NOT NULL,
- name character varying(64) not null,
- parent_id integer references res_company on delete set null,
- primary key(id)
-);
-
-CREATE TABLE ir_model_data (
- id serial NOT NULL,
- create_uid integer,
- create_date timestamp without time zone,
- write_date timestamp without time zone,
- write_uid integer,
- noupdate boolean,
- name character varying(128) NOT NULL,
- date_init timestamp without time zone,
- date_update timestamp without time zone,
- module character varying(64) NOT NULL,
- model character varying(64) NOT NULL,
- res_id integer, primary key(id)
-);
-
----------------------------------
--- Users
----------------------------------
-
-insert into res_users (id,login,password,name,active,company_id,context_lang) values (1,'admin','admin','Administrator',True,1,'en_US');
-insert into ir_model_data (name,module,model,noupdate,res_id) values ('user_root','base','res.users',True,1);
-
--- Compatibility purpose, to remove V6.0
-insert into ir_model_data (name,module,model,noupdate,res_id) values ('user_admin','base','res.users',True,1);
-
-select setval('res_users_id_seq', 2);