From f03493ad973f482e695e540275948628b8f8362b Mon Sep 17 00:00:00 2001 From: "mga (Tiny/Axelor)" Date: Thu, 19 Feb 2009 15:34:22 +0530 Subject: change the size of the fields in to the base.sql according to the object fields to, remove the warning on first start up the server bzr revid: mga@tinyerp.com-20090219100422-2g9sl00wg98ih53c --- bin/addons/base/base.sql | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) (limited to 'bin/addons/base/base.sql') diff --git a/bin/addons/base/base.sql b/bin/addons/base/base.sql index 50d793b6dd5..9a6c83bc8c7 100644 --- a/bin/addons/base/base.sql +++ b/bin/addons/base/base.sql @@ -11,7 +11,7 @@ create table ir_values id serial, name varchar(128) not null, key varchar(128) not null, - key2 varchar(128) not null, + key2 varchar(256) not null, model varchar(128) not null, value text, meta text default NULL, @@ -64,7 +64,7 @@ CREATE TABLE ir_act_window ( view_id integer, res_model varchar(64), view_type varchar(16), - "domain" varchar(127), + "domain" varchar(250), primary key(id) ) INHERITS (ir_actions); @@ -72,8 +72,8 @@ INHERITS (ir_actions); CREATE TABLE ir_act_report_xml ( model varchar(64) NOT NULL, report_name varchar(64) NOT NULL, - report_xsl varchar(64), - report_xml varchar(64), + report_xsl varchar(256), + report_xml varchar(256), auto boolean default true, primary key(id) ) @@ -140,7 +140,7 @@ CREATE TABLE res_users ( name varchar(64) not null, active boolean default True, login varchar(64) NOT NULL UNIQUE, - password varchar(32) default null, + password varchar(64) default null, context_tz varchar(64) default null, signature text, -- action_id int references ir_act_window on delete set null, @@ -151,14 +151,14 @@ alter table res_users add constraint res_users_login_uniq unique (login); CREATE TABLE res_groups ( id serial NOT NULL, - name varchar(32) NOT NULL, + name varchar(64) NOT NULL, primary key(id) ); create table res_roles ( id serial NOT NULL, parent_id int references res_roles on delete set null, - name varchar(32) NOT NULL, + name varchar(64) NOT NULL, primary key(id) ); -- cgit v1.2.3 From 0b9dbd7bd229a952d3853aff793c9fd9d4934711 Mon Sep 17 00:00:00 2001 From: "mga (Tiny/Axelor)" Date: Thu, 19 Feb 2009 16:54:00 +0530 Subject: solve the problem of changing size at first server run bzr revid: mga@tinyerp.com-20090219112400-2wtum8ywp73jqoug --- bin/addons/base/base.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'bin/addons/base/base.sql') diff --git a/bin/addons/base/base.sql b/bin/addons/base/base.sql index 9a6c83bc8c7..8dfc8d8f765 100644 --- a/bin/addons/base/base.sql +++ b/bin/addons/base/base.sql @@ -55,7 +55,7 @@ CREATE TABLE ir_model_fields ( CREATE TABLE ir_actions ( id serial NOT NULL, name varchar(64) DEFAULT ''::varchar NOT NULL, - "type" varchar(64) DEFAULT 'window'::varchar NOT NULL, + "type" varchar(32) DEFAULT 'window'::varchar NOT NULL, usage varchar(32) DEFAULT null, primary key(id) ); -- cgit v1.2.3 From 0ac72db82780d05c2fe85baacb6a455a9bd31d11 Mon Sep 17 00:00:00 2001 From: Fabien Pinckaers Date: Sun, 15 Mar 2009 19:52:19 +0100 Subject: adding_indexes bzr revid: fp@tinyerp.com-20090315185219-w5av977my2cs87qr --- bin/addons/base/base.sql | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'bin/addons/base/base.sql') diff --git a/bin/addons/base/base.sql b/bin/addons/base/base.sql index 8dfc8d8f765..047519708c8 100644 --- a/bin/addons/base/base.sql +++ b/bin/addons/base/base.sql @@ -172,6 +172,10 @@ CREATE TABLE res_groups_users_rel ( gid integer NOT NULL references res_groups on delete cascade ); +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 --------------------------------- -- cgit v1.2.3 From 4ab081becaa3822c8965933603924504694f5c11 Mon Sep 17 00:00:00 2001 From: Fabien Pinckaers Date: Sun, 15 Mar 2009 19:55:32 +0100 Subject: added_indexes bzr revid: fp@tinyerp.com-20090315185532-fr2b6cpuow43yjta --- bin/addons/base/base.sql | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'bin/addons/base/base.sql') diff --git a/bin/addons/base/base.sql b/bin/addons/base/base.sql index 047519708c8..c47e52864d4 100644 --- a/bin/addons/base/base.sql +++ b/bin/addons/base/base.sql @@ -166,6 +166,8 @@ 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_gid_idx on res_roles_users_rel (gid); CREATE TABLE res_groups_users_rel ( uid integer NOT NULL references res_users on delete cascade, @@ -248,6 +250,8 @@ create table wkf_witm_trans 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, -- cgit v1.2.3 From 67aecc544dda06fb11cbf1878e5ffac0a9cb6d85 Mon Sep 17 00:00:00 2001 From: Fabien Pinckaers Date: Mon, 16 Mar 2009 00:47:01 +0100 Subject: bugfix bzr revid: fp@tinyerp.com-20090315234701-7fsp0fp1ax2jewhw --- bin/addons/base/base.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'bin/addons/base/base.sql') diff --git a/bin/addons/base/base.sql b/bin/addons/base/base.sql index c47e52864d4..3585f1c4718 100644 --- a/bin/addons/base/base.sql +++ b/bin/addons/base/base.sql @@ -167,7 +167,7 @@ CREATE TABLE res_roles_users_rel ( 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_gid_idx on res_roles_users_rel (gid); +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, -- cgit v1.2.3 From 47a3a483eb2f15e94884310e3944830fc0075d89 Mon Sep 17 00:00:00 2001 From: Stephane Wirtel Date: Mon, 4 May 2009 14:35:21 +0200 Subject: [FIX] Add the context_lang field in the res_users table bzr revid: stephane@tinyerp.com-20090504123521-jqe9dyrd75kap5h3 --- bin/addons/base/base.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'bin/addons/base/base.sql') diff --git a/bin/addons/base/base.sql b/bin/addons/base/base.sql index 3585f1c4718..d38fc77b34c 100644 --- a/bin/addons/base/base.sql +++ b/bin/addons/base/base.sql @@ -144,6 +144,7 @@ CREATE TABLE res_users ( context_tz varchar(64) default null, signature text, -- action_id int references ir_act_window on delete set null, + context_lang varchar(64) default '', action_id int, primary key(id) ); -- cgit v1.2.3