diff options
| author | Numerigraphe - Lionel Sausin <ls@numerigraphe.fr> | 2010-11-12 15:10:41 +0100 |
|---|---|---|
| committer | Numerigraphe - Lionel Sausin <ls@numerigraphe.fr> | 2010-11-12 15:10:41 +0100 |
| commit | 182cf2b196da0d1f55ddfdcff62058b423e1bbc0 (patch) | |
| tree | 779b50e2e54b1624ba669b4a3f56bb6407c08d49 /bin/addons/base/base.sql | |
| parent | e013734045bbaae906748a8026455bac6786568e (diff) | |
| parent | cc0d270bab0d0b7862430c3e527f7edc02d1d587 (diff) | |
[MERGE] sync with the trunk
bzr revid: ls@numerigraphe.fr-20101112141041-19kpvr7pzxqankqo
Diffstat (limited to 'bin/addons/base/base.sql')
| -rw-r--r-- | bin/addons/base/base.sql | 20 |
1 files changed, 3 insertions, 17 deletions
diff --git a/bin/addons/base/base.sql b/bin/addons/base/base.sql index bb792b78845..71bfda541c4 100644 --- a/bin/addons/base/base.sql +++ b/bin/addons/base/base.sql @@ -148,7 +148,6 @@ CREATE TABLE res_users ( context_lang varchar(64) default '', -- No FK references below, will be added later by ORM -- (when the destination rows exist) - action_id int, company_id int, primary key(id) ); @@ -160,20 +159,6 @@ CREATE TABLE res_groups ( primary key(id) ); -create table res_roles ( - id serial NOT NULL, - parent_id int references res_roles on delete set null, - name varchar(64) NOT NULL, - primary key(id) -); - -CREATE TABLE res_roles_users_rel ( - uid integer NOT NULL references res_users on delete cascade, - rid integer NOT NULL references res_roles on delete cascade -); -create index res_roles_users_rel_uid_idx on res_roles_users_rel (uid); -create index res_roles_users_rel_rid_idx on res_roles_users_rel (rid); - 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 @@ -223,7 +208,7 @@ create table wkf_transition trigger_expr_id varchar(128) default NULL, signal varchar(64) default null, - role_id int references res_roles on delete set null, + group_id int references res_groups on delete set null, primary key(id) ); @@ -302,6 +287,7 @@ CREATE TABLE ir_module_module ( certificate character varying(64), description text, demo boolean default False, + web boolean DEFAULT FALSE, primary key(id) ); ALTER TABLE ir_module_module add constraint name_uniq unique (name); @@ -344,7 +330,7 @@ CREATE TABLE ir_model_data ( -- Users --------------------------------- -insert into res_users (id,login,password,name,action_id,active,company_id) values (1,'admin',NULL,'Administrator',NULL,True,1); +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 |
