Update of /cvsroot/tikiwiki/tiki/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20911/db Modified Files: tiki_1.8to1.9.sql tiki-1.9-mysql.sql tiki-1.9-oci8.sql tiki-1.9-pgsql.sql tiki-1.9-sqlite.sql tiki-1.9-sybase.sql tiki.sql Log Message: added a choice of field for use with admin-groups tracker option Index: tiki_1.8to1.9.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki_1.8to1.9.sql,v retrieving revision 1.31 retrieving revision 1.32 diff -u -d -r1.31 -r1.32 --- tiki_1.8to1.9.sql 1 Mar 2004 17:21:28 -0000 1.31 +++ tiki_1.8to1.9.sql 2 Mar 2004 07:11:53 -0000 1.32 @@ -241,3 +241,6 @@ INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Shoutbox','tiki-admin_shoutbox_words.php',1191,'','tiki_p_admin_shoutbox',''); # -------------------------------------------------------- +# added on 2004-03-02 by mose for more details in groups +ALTER TABLE `users_groups` ADD `usersFieldId` INT( 11 ), ADD `groupFieldId` INT( 11 ); + Index: tiki-1.9-mysql.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.9-mysql.sql,v retrieving revision 1.11 retrieving revision 1.12 diff -u -d -r1.11 -r1.12 --- tiki-1.9-mysql.sql 28 Feb 2004 03:47:02 -0000 1.11 +++ tiki-1.9-mysql.sql 2 Mar 2004 07:11:53 -0000 1.12 @@ -503,7 +503,7 @@ add_date char(1) default NULL, add_poster char(1) default NULL, allow_comments char(1) default NULL, - show_avatar char(1) default NULL, + show_avatar char(1) default NULL, PRIMARY KEY (blogId), KEY title (title), KEY description (description(255)), @@ -2054,6 +2054,7 @@ INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Content templates','tiki-admin_content_templates.php',1180,'','tiki_p_edit_content_templates',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','HTML pages','tiki-admin_html_pages.php',1185,'','tiki_p_edit_html_pages',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Shoutbox','tiki-shoutbox.php',1190,'','tiki_p_admin_shoutbox',''); +INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Shoutbox','tiki-admin_shoutbox_words.php',1191,'','tiki_p_admin_shoutbox',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Referer stats','tiki-referer_stats.php',1195,'','tiki_p_view_referer_stats',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Edit languages','tiki-edit_languages.php',1200,'','tiki_p_edit_languages,lang_use_db',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Integrator','tiki-admin_integrator.php',1205,'feature_integrator','tiki_p_admin_integrator',''); @@ -2732,6 +2733,18 @@ # -------------------------------------------------------- # +# Table structure for table `tiki_shoutbox_words` +# + +DROP TABLE IF EXISTS tiki_shoutbox_words; +CREATE TABLE `tiki_shoutbox_words` ( + word VARCHAR( 40 ) NOT NULL , + qty INT DEFAULT '0' NOT NULL , + PRIMARY KEY ( `word` ) +) TYPE=MyISAM; +# -------------------------------------------------------- + +# # Table structure for table `tiki_structures` # # Creation: Jul 03, 2003 at 07:42 PM @@ -3567,6 +3580,8 @@ groupHome varchar(255), usersTrackerId int(11), groupTrackerId int(11), + usersFieldId int(11), + groupFieldId int(11), PRIMARY KEY (groupName(30)) ) TYPE=MyISAM; # -------------------------------------------------------- Index: tiki-1.9-oci8.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.9-oci8.sql,v retrieving revision 1.8 retrieving revision 1.9 diff -u -d -r1.8 -r1.9 --- tiki-1.9-oci8.sql 28 Feb 2004 03:47:02 -0000 1.8 +++ tiki-1.9-oci8.sql 2 Mar 2004 07:11:53 -0000 1.9 @@ -588,7 +588,7 @@ "add_date" char(1) default NULL, "add_poster" char(1) default NULL, "allow_comments" char(1) default NULL, - show_avatar char(1) default NULL, + "show_avatar" char(1) default NULL, PRIMARY KEY ("blogId") ) ; @@ -2536,6 +2536,8 @@ INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Shoutbox','tiki-shoutbox.php',1190,'','tiki_p_admin_shoutbox',''); +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Shoutbox','tiki-admin_shoutbox_words.php',1191,'','tiki_p_admin_shoutbox',''); + INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Referer stats','tiki-referer_stats.php',1195,'','tiki_p_view_referer_stats',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Edit languages','tiki-edit_languages.php',1200,'','tiki_p_edit_languages,lang_use_db',''); @@ -3342,6 +3344,18 @@ / -- -------------------------------------------------------- -- +-- Table structure for table `tiki_shoutbox_words` +-- +DROP TABLE "tiki_shoutbox_words"; + +CREATE TABLE `tiki_shoutbox_words` ( + "word" VARCHAR( 40 ) NOT NULL , + "qty" INT DEFAULT '0' NOT NULL , + PRIMARY KEY ( `word` ) +) ; + +-- -------------------------------------------------------- +-- -- Table structure for table `tiki_structures` -- -- Creation: Jul 03, 2003 at 07:42 PM @@ -4314,6 +4328,8 @@ "groupHome" varchar(255), "usersTrackerId" number(11), "groupTrackerId" number(11), + "usersFieldId" number(11), + "groupFieldId" number(11), PRIMARY KEY ("groupName") ) ; Index: tiki-1.9-pgsql.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.9-pgsql.sql,v retrieving revision 1.8 retrieving revision 1.9 diff -u -d -r1.8 -r1.9 --- tiki-1.9-pgsql.sql 28 Feb 2004 03:47:02 -0000 1.8 +++ tiki-1.9-pgsql.sql 2 Mar 2004 07:11:53 -0000 1.9 @@ -560,7 +560,7 @@ "add_date" char(1) default NULL, "add_poster" char(1) default NULL, "allow_comments" char(1) default NULL, - show_avatar char(1) default NULL, + "show_avatar" char(1) default NULL, PRIMARY KEY ("blogId") @@ -2437,6 +2437,8 @@ INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Shoutbox','tiki-shoutbox.php',1190,'','tiki_p_admin_shoutbox',''); +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Shoutbox','tiki-admin_shoutbox_words.php',1191,'','tiki_p_admin_shoutbox',''); + INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Referer stats','tiki-referer_stats.php',1195,'','tiki_p_view_referer_stats',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Edit languages','tiki-edit_languages.php',1200,'','tiki_p_edit_languages,lang_use_db',''); @@ -3203,6 +3205,20 @@ -- -------------------------------------------------------- -- +-- Table structure for table `tiki_shoutbox_words` +-- + +DROP TABLE "tiki_shoutbox_words"; + +CREATE TABLE `tiki_shoutbox_words` ( + "word" VARCHAR( 40 ) NOT NULL , + "qty" INT DEFAULT '0' NOT NULL , + PRIMARY KEY ( `word` ) +) ; + +-- -------------------------------------------------------- + +-- -- Table structure for table `tiki_structures` -- -- Creation: Jul 03, 2003 at 07:42 PM @@ -4126,6 +4142,8 @@ "groupHome" varchar(255), "usersTrackerId" bigint, "groupTrackerId" bigint, + "usersFieldId" bigint, + "groupFieldId" bigint, PRIMARY KEY ("groupName") ) ; Index: tiki-1.9-sqlite.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.9-sqlite.sql,v retrieving revision 1.8 retrieving revision 1.9 diff -u -d -r1.8 -r1.9 --- tiki-1.9-sqlite.sql 28 Feb 2004 03:47:02 -0000 1.8 +++ tiki-1.9-sqlite.sql 2 Mar 2004 07:11:53 -0000 1.9 @@ -560,7 +560,7 @@ "add_date" char(1) default NULL, "add_poster" char(1) default NULL, "allow_comments" char(1) default NULL, - show_avatar char(1) default NULL, + "show_avatar" char(1) default NULL, PRIMARY KEY ("blogId") @@ -2437,6 +2437,8 @@ INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Shoutbox','tiki-shoutbox.php',1190,'','tiki_p_admin_shoutbox',''); +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Shoutbox','tiki-admin_shoutbox_words.php',1191,'','tiki_p_admin_shoutbox',''); + INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Referer stats','tiki-referer_stats.php',1195,'','tiki_p_view_referer_stats',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Edit languages','tiki-edit_languages.php',1200,'','tiki_p_edit_languages,lang_use_db',''); @@ -3203,6 +3205,20 @@ -- -------------------------------------------------------- -- +-- Table structure for table `tiki_shoutbox_words` +-- + +DROP TABLE "tiki_shoutbox_words"; + +CREATE TABLE `tiki_shoutbox_words` ( + "word" VARCHAR( 40 ) NOT NULL , + "qty" INT DEFAULT '0' NOT NULL , + PRIMARY KEY ( `word` ) +) ; + +-- -------------------------------------------------------- + +-- -- Table structure for table `tiki_structures` -- -- Creation: Jul 03, 2003 at 07:42 PM @@ -4126,6 +4142,8 @@ "groupHome" varchar(255), "usersTrackerId" bigint, "groupTrackerId" bigint, + "usersFieldId" bigint, + "groupFieldId" bigint, PRIMARY KEY ("groupName") ) ; Index: tiki-1.9-sybase.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.9-sybase.sql,v retrieving revision 1.8 retrieving revision 1.9 diff -u -d -r1.8 -r1.9 --- tiki-1.9-sybase.sql 28 Feb 2004 03:47:02 -0000 1.8 +++ tiki-1.9-sybase.sql 2 Mar 2004 07:11:53 -0000 1.9 @@ -667,7 +667,7 @@ "add_date" char(1) default NULL NULL, "add_poster" char(1) default NULL NULL, "allow_comments" char(1) default NULL NULL, - show_avatar char(1) default NULL NULL, + "show_avatar" char(1) default NULL NULL, PRIMARY KEY ("blogId") @@ -3157,6 +3157,10 @@ go +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Shoutbox','tiki-admin_shoutbox_words.php',1191,'','tiki_p_admin_shoutbox','') +go + + INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Referer stats','tiki-referer_stats.php',1195,'','tiki_p_view_referer_stats','') go @@ -4094,6 +4098,24 @@ -- -------------------------------------------------------- -- +-- Table structure for table `tiki_shoutbox_words` +-- + +-- DROP TABLE "tiki_shoutbox_words" +go + + +CREATE TABLE `tiki_shoutbox_words` ( + "word" VARCHAR( 40 ) NOT NULL , + "qty" INT DEFAULT '0' NOT NULL , + PRIMARY KEY ( `word` ) +) +go + + +-- -------------------------------------------------------- + +-- -- Table structure for table `tiki_structures` -- -- Creation: Jul 03, 2003 at 07:42 PM @@ -5190,6 +5212,8 @@ "groupHome" varchar(255) default '', "usersTrackerId" numeric(11,0) default NULL NULL, "groupTrackerId" numeric(11,0) default NULL NULL, + "usersFieldId" numeric(11,0) default NULL NULL, + "groupFieldId" numeric(11,0) default NULL NULL, PRIMARY KEY ("groupName") ) go Index: tiki.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki.sql,v retrieving revision 1.166 retrieving revision 1.167 diff -u -d -r1.166 -r1.167 --- tiki.sql 1 Mar 2004 17:21:28 -0000 1.166 +++ tiki.sql 2 Mar 2004 07:11:53 -0000 1.167 @@ -503,7 +503,7 @@ add_date char(1) default NULL, add_poster char(1) default NULL, allow_comments char(1) default NULL, - show_avatar char(1) default NULL, + show_avatar char(1) default NULL, PRIMARY KEY (blogId), KEY title (title), KEY description (description(255)), @@ -3580,6 +3580,8 @@ groupHome varchar(255), usersTrackerId int(11), groupTrackerId int(11), + usersFieldId int(11), + groupFieldId int(11), PRIMARY KEY (groupName(30)) ) TYPE=MyISAM; # -------------------------------------------------------- |