summaryrefslogtreecommitdiff
path: root/bin/addons/base/base.sql
diff options
context:
space:
mode:
Diffstat (limited to 'bin/addons/base/base.sql')
-rw-r--r--bin/addons/base/base.sql20
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