From: <mar...@us...> - 2008-10-18 12:48:31
|
Revision: 15211 http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=15211&view=rev Author: marclaporte Date: 2008-10-18 12:48:28 +0000 (Sat, 18 Oct 2008) Log Message: ----------- [DB] syncdb Modified Paths: -------------- trunk/db/tiki-3.0-mysql.sql trunk/db/tiki-3.0-mysqli.sql trunk/db/tiki-3.0-oci8.sql trunk/db/tiki-3.0-pgsql.sql trunk/db/tiki-3.0-sqlite.sql trunk/db/tiki-3.0-sybase.sql Modified: trunk/db/tiki-3.0-mysql.sql =================================================================== --- trunk/db/tiki-3.0-mysql.sql 2008-10-18 12:26:25 UTC (rev 15210) +++ trunk/db/tiki-3.0-mysql.sql 2008-10-18 12:48:28 UTC (rev 15211) @@ -321,7 +321,8 @@ impressions int(8) default NULL, clicks int(8) default NULL, zone varchar(40) default NULL, - PRIMARY KEY (bannerId) + PRIMARY KEY (bannerId), + INDEX ban1(zone,useDates,impressions,maxImpressions,hourFrom,hourTo,fromDate,toDate,mon,tue,wed,thu,fri,sat,sun) ) ENGINE=MyISAM AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS tiki_banning; @@ -655,6 +656,7 @@ in_reply_to varchar(128) default NULL, comment_rating tinyint(2) default NULL, archived char(1) default NULL, + approved char(1) NOT NULL default 'y', PRIMARY KEY (threadId), UNIQUE KEY no_repeats (parentId, userName(40), title(100), commentDate, message_id(40), in_reply_to(40)), KEY title (title), @@ -1198,6 +1200,7 @@ CREATE TABLE tiki_links ( fromPage varchar(160) NOT NULL default '', toPage varchar(160) NOT NULL default '', + reltype varchar(50), PRIMARY KEY (fromPage,toPage), KEY toPage (toPage) ) ENGINE=MyISAM; @@ -1401,6 +1404,7 @@ INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (45,42,'o','Send pages','tiki-send_objects.php',240,'feature_wiki,feature_comm','tiki_p_view,tiki_p_send_pages','',0); INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (46,42,'o','Received pages','tiki-received_pages.php',245,'feature_wiki,feature_comm','tiki_p_view,tiki_p_admin_received_pages','',0); INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (47,42,'o','Structures','tiki-admin_structures.php',250,'feature_wiki_structure','tiki_p_view','',0); +INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (197,42,'o','Mind Map','tiki-mindmap.php',255,'feature_wiki_mindmap','tiki_p_view','',0); INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (48,42,'s','Image Galleries','tiki-galleries.php',300,'feature_galleries','tiki_p_view_image_gallery','',0); INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (49,42,'o','Galleries','tiki-galleries.php',305,'feature_galleries','tiki_p_list_image_galleries','',0); INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (50,42,'o','Rankings','tiki-galleries_rankings.php',310,'feature_galleries,feature_gal_rankings','tiki_p_list_image_galleries','',0); @@ -2730,6 +2734,7 @@ level varchar(80) default NULL, type varchar(20) default NULL, admin varchar(1) default NULL, + feature_check VARCHAR(50) NULL, PRIMARY KEY (permName), KEY type (type) ) ENGINE=MyISAM; @@ -2991,10 +2996,44 @@ INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_map_view_mapfiles', 'Can view contents of mapfiles', 'registered', 'maps'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_use_webmail', 'Can use webmail', 'registered', 'webmail'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_use_group_webmail', 'Can use group webmail', 'registered', 'webmail'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_admin_group_webmail', 'Can administrate group webmail accounts', 'registered', 'webmail'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_use_personal_webmail', 'Can use personal webmail accounts', 'registered', 'webmail'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_admin_personal_webmail', 'Can administrate personal webmail accounts', 'registered', 'webmail'); + + INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_plugin_viewdetail', 'Can view unapproved plugin details', 'registered', 'wiki'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_plugin_preview', 'Can execute unapproved plugin', 'registered', 'wiki'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_plugin_approve', 'Can approve plugin execution', 'editors', 'wiki'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_trust_input', 'Trust all user inputs (no security checks)', 'admin', 'tiki'); +UPDATE users_permissions SET feature_check = 'feature_wiki' WHERE permName IN( + 'tiki_p_admin_wiki', + 'tiki_p_assign_perm_wiki_page', + 'tiki_p_edit', + 'tiki_p_export_wiki', + 'tiki_p_lock', + 'tiki_p_minor', + 'tiki_p_remove', + 'tiki_p_rename', + 'tiki_p_rollback', + 'tiki_p_view', + 'tiki_p_view_history', + 'tiki_p_view_source' +); +UPDATE users_permissions SET feature_check = 'wiki_feature_copyrights' WHERE permName = 'tiki_p_edit_copyrights'; +UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE permName = 'tiki_p_edit_structures'; +UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE permName = 'tiki_p_watch_structure'; +UPDATE users_permissions SET feature_check = 'feature_wiki_pictures' WHERE permName = 'tiki_p_upload_picture'; +UPDATE users_permissions SET feature_check = 'feature_wiki_templates' WHERE permName = 'tiki_p_use_as_template'; +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_admin_attachments'; +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_attach_files'; +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_wiki_view_attachments'; +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_admin_ratings'; +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_wiki_view_ratings'; +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_wiki_vote_ratings'; +UPDATE users_permissions SET feature_check = 'feature_wiki_comments' WHERE permName = 'tiki_p_wiki_view_comments'; + DROP TABLE IF EXISTS users_usergroups; CREATE TABLE users_usergroups ( userId int(8) NOT NULL default '0', @@ -3499,7 +3538,7 @@ `version` int(8) NOT NULL, `source_translation_bit` int(10) NULL, `original_translation_bit` int(10) NULL, - `flags` SET('critical') NOT NULL DEFAULT '', + `flags` SET('critical') NULL DEFAULT '', PRIMARY KEY (`translation_bit_id`), KEY(`page_id`), KEY(`original_translation_bit`), @@ -3560,8 +3599,38 @@ PRIMARY KEY (`feature_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1; +DROP TABLE IF EXISTS tiki_schema; CREATE TABLE tiki_schema ( patch_name VARCHAR(100) PRIMARY KEY, install_date TIMESTAMP ) ENGINE=MyISAM; +DROP TABLE IF EXISTS tiki_semantic_tokens; +CREATE TABLE tiki_semantic_tokens ( + token VARCHAR(15) PRIMARY KEY, + label VARCHAR(25) NOT NULL, + invert_token VARCHAR(15) +) ENGINE=MyISAM ; + +INSERT INTO tiki_semantic_tokens (token, label) VALUES('alias', 'Page Alias'); + + +DROP TABLE IF EXISTS tiki_webservice; +CREATE TABLE tiki_webservice ( + service VARCHAR(25) NOT NULL PRIMARY KEY, + url VARCHAR(250), + schema_version VARCHAR(5), + schema_documentation VARCHAR(250) +) ENGINE=MyISAM ; + +DROP TABLE IF EXISTS tiki_webservice_template; +CREATE TABLE tiki_webservice_template ( + service VARCHAR(25) NOT NULL, + template VARCHAR(25) NOT NULL, + engine VARCHAR(15) NOT NULL, + output VARCHAR(15) NOT NULL, + content TEXT NOT NULL, + last_modif INT, + PRIMARY KEY( service, template ) +) ENGINE=MyISAM ; + Modified: trunk/db/tiki-3.0-mysqli.sql =================================================================== --- trunk/db/tiki-3.0-mysqli.sql 2008-10-18 12:26:25 UTC (rev 15210) +++ trunk/db/tiki-3.0-mysqli.sql 2008-10-18 12:48:28 UTC (rev 15211) @@ -321,7 +321,8 @@ impressions int(8) default NULL, clicks int(8) default NULL, zone varchar(40) default NULL, - PRIMARY KEY (bannerId) + PRIMARY KEY (bannerId), + INDEX ban1(zone,useDates,impressions,maxImpressions,hourFrom,hourTo,fromDate,toDate,mon,tue,wed,thu,fri,sat,sun) ) ENGINE=MyISAM AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS tiki_banning; @@ -655,6 +656,7 @@ in_reply_to varchar(128) default NULL, comment_rating tinyint(2) default NULL, archived char(1) default NULL, + approved char(1) NOT NULL default 'y', PRIMARY KEY (threadId), UNIQUE KEY no_repeats (parentId, userName(40), title(100), commentDate, message_id(40), in_reply_to(40)), KEY title (title), @@ -1198,6 +1200,7 @@ CREATE TABLE tiki_links ( fromPage varchar(160) NOT NULL default '', toPage varchar(160) NOT NULL default '', + reltype varchar(50), PRIMARY KEY (fromPage,toPage), KEY toPage (toPage) ) ENGINE=MyISAM; @@ -1401,6 +1404,7 @@ INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (45,42,'o','Send pages','tiki-send_objects.php',240,'feature_wiki,feature_comm','tiki_p_view,tiki_p_send_pages','',0); INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (46,42,'o','Received pages','tiki-received_pages.php',245,'feature_wiki,feature_comm','tiki_p_view,tiki_p_admin_received_pages','',0); INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (47,42,'o','Structures','tiki-admin_structures.php',250,'feature_wiki_structure','tiki_p_view','',0); +INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (197,42,'o','Mind Map','tiki-mindmap.php',255,'feature_wiki_mindmap','tiki_p_view','',0); INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (48,42,'s','Image Galleries','tiki-galleries.php',300,'feature_galleries','tiki_p_view_image_gallery','',0); INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (49,42,'o','Galleries','tiki-galleries.php',305,'feature_galleries','tiki_p_list_image_galleries','',0); INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (50,42,'o','Rankings','tiki-galleries_rankings.php',310,'feature_galleries,feature_gal_rankings','tiki_p_list_image_galleries','',0); @@ -2730,6 +2734,7 @@ level varchar(80) default NULL, type varchar(20) default NULL, admin varchar(1) default NULL, + feature_check VARCHAR(50) NULL, PRIMARY KEY (permName), KEY type (type) ) ENGINE=MyISAM; @@ -2991,10 +2996,44 @@ INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_map_view_mapfiles', 'Can view contents of mapfiles', 'registered', 'maps'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_use_webmail', 'Can use webmail', 'registered', 'webmail'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_use_group_webmail', 'Can use group webmail', 'registered', 'webmail'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_admin_group_webmail', 'Can administrate group webmail accounts', 'registered', 'webmail'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_use_personal_webmail', 'Can use personal webmail accounts', 'registered', 'webmail'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_admin_personal_webmail', 'Can administrate personal webmail accounts', 'registered', 'webmail'); + + INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_plugin_viewdetail', 'Can view unapproved plugin details', 'registered', 'wiki'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_plugin_preview', 'Can execute unapproved plugin', 'registered', 'wiki'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_plugin_approve', 'Can approve plugin execution', 'editors', 'wiki'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_trust_input', 'Trust all user inputs (no security checks)', 'admin', 'tiki'); +UPDATE users_permissions SET feature_check = 'feature_wiki' WHERE permName IN( + 'tiki_p_admin_wiki', + 'tiki_p_assign_perm_wiki_page', + 'tiki_p_edit', + 'tiki_p_export_wiki', + 'tiki_p_lock', + 'tiki_p_minor', + 'tiki_p_remove', + 'tiki_p_rename', + 'tiki_p_rollback', + 'tiki_p_view', + 'tiki_p_view_history', + 'tiki_p_view_source' +); +UPDATE users_permissions SET feature_check = 'wiki_feature_copyrights' WHERE permName = 'tiki_p_edit_copyrights'; +UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE permName = 'tiki_p_edit_structures'; +UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE permName = 'tiki_p_watch_structure'; +UPDATE users_permissions SET feature_check = 'feature_wiki_pictures' WHERE permName = 'tiki_p_upload_picture'; +UPDATE users_permissions SET feature_check = 'feature_wiki_templates' WHERE permName = 'tiki_p_use_as_template'; +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_admin_attachments'; +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_attach_files'; +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_wiki_view_attachments'; +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_admin_ratings'; +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_wiki_view_ratings'; +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_wiki_vote_ratings'; +UPDATE users_permissions SET feature_check = 'feature_wiki_comments' WHERE permName = 'tiki_p_wiki_view_comments'; + DROP TABLE IF EXISTS users_usergroups; CREATE TABLE users_usergroups ( userId int(8) NOT NULL default '0', @@ -3499,7 +3538,7 @@ `version` int(8) NOT NULL, `source_translation_bit` int(10) NULL, `original_translation_bit` int(10) NULL, - `flags` SET('critical') NOT NULL DEFAULT '', + `flags` SET('critical') NULL DEFAULT '', PRIMARY KEY (`translation_bit_id`), KEY(`page_id`), KEY(`original_translation_bit`), @@ -3560,8 +3599,38 @@ PRIMARY KEY (`feature_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1; +DROP TABLE IF EXISTS tiki_schema; CREATE TABLE tiki_schema ( patch_name VARCHAR(100) PRIMARY KEY, install_date TIMESTAMP ) ENGINE=MyISAM; +DROP TABLE IF EXISTS tiki_semantic_tokens; +CREATE TABLE tiki_semantic_tokens ( + token VARCHAR(15) PRIMARY KEY, + label VARCHAR(25) NOT NULL, + invert_token VARCHAR(15) +) ENGINE=MyISAM ; + +INSERT INTO tiki_semantic_tokens (token, label) VALUES('alias', 'Page Alias'); + + +DROP TABLE IF EXISTS tiki_webservice; +CREATE TABLE tiki_webservice ( + service VARCHAR(25) NOT NULL PRIMARY KEY, + url VARCHAR(250), + schema_version VARCHAR(5), + schema_documentation VARCHAR(250) +) ENGINE=MyISAM ; + +DROP TABLE IF EXISTS tiki_webservice_template; +CREATE TABLE tiki_webservice_template ( + service VARCHAR(25) NOT NULL, + template VARCHAR(25) NOT NULL, + engine VARCHAR(15) NOT NULL, + output VARCHAR(15) NOT NULL, + content TEXT NOT NULL, + last_modif INT, + PRIMARY KEY( service, template ) +) ENGINE=MyISAM ; + Modified: trunk/db/tiki-3.0-oci8.sql =================================================================== --- trunk/db/tiki-3.0-oci8.sql 2008-10-18 12:26:25 UTC (rev 15210) +++ trunk/db/tiki-3.0-oci8.sql 2008-10-18 12:48:28 UTC (rev 15211) @@ -434,7 +434,8 @@ "impressions" number(8) default NULL, "clicks" number(8) default NULL, "zone" varchar(40) default NULL, - PRIMARY KEY (bannerId) + PRIMARY KEY (bannerId), + "INDEX" ban1(zone,useDates,impressions,maxImpressions,hourFrom,hourTo,fromDate,toDate,mon,tue,wed,thu,fri,sat,sun) ) ENGINE=MyISAM ; CREATE TRIGGER "tiki_banners_trig" BEFORE INSERT ON "tiki_banners" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW @@ -910,6 +911,7 @@ "in_reply_to" varchar(128) default NULL, "comment_rating" number(2) default NULL, "archived" char(1) default NULL, + "approved" char(1) default 'y' NOT NULL, PRIMARY KEY (threadId) ) ENGINE=MyISAM ; @@ -1652,6 +1654,7 @@ CREATE TABLE "tiki_links" ( "fromPage" varchar(160) default '' NOT NULL, "toPage" varchar(160) default '' NOT NULL, + "reltype" varchar(50), PRIMARY KEY (fromPage,toPage) ) ENGINE=MyISAM; @@ -1979,6 +1982,8 @@ INSERT INTO "," ("`optionId`","`menuId`","`type`","`name`","`url`","`position`","`section`","`perm`","`groupname`","`userlevel`") VALUES (47,42,'o','Structures','tiki-admin_structures.php',250,'feature_wiki_structure','tiki_p_view','',0); +INSERT INTO "," ("`optionId`","`menuId`","`type`","`name`","`url`","`position`","`section`","`perm`","`groupname`","`userlevel`") VALUES (197,42,'o','Mind Map','tiki-mindmap.php',255,'feature_wiki_mindmap','tiki_p_view','',0); + INSERT INTO "," ("`optionId`","`menuId`","`type`","`name`","`url`","`position`","`section`","`perm`","`groupname`","`userlevel`") VALUES (48,42,'s','Image Galleries','tiki-galleries.php',300,'feature_galleries','tiki_p_view_image_gallery','',0); INSERT INTO "," ("`optionId`","`menuId`","`type`","`name`","`url`","`position`","`section`","`perm`","`groupname`","`userlevel`") VALUES (49,42,'o','Galleries','tiki-galleries.php',305,'feature_galleries','tiki_p_list_image_galleries','',0); @@ -3926,6 +3931,7 @@ "level" varchar(80) default NULL, "type" varchar(20) default NULL, "admin" varchar(1) default NULL, + "feature_check" VARCHAR(50) NULL, PRIMARY KEY (permName) ) ENGINE=MyISAM; @@ -4409,13 +4415,64 @@ INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_use_webmail', 'Can use webmail', 'registered', 'webmail'); +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_use_group_webmail', 'Can use group webmail', 'registered', 'webmail'); + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_admin_group_webmail', 'Can administrate group webmail accounts', 'registered', 'webmail'); + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_use_personal_webmail', 'Can use personal webmail accounts', 'registered', 'webmail'); + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_admin_personal_webmail', 'Can administrate personal webmail accounts', 'registered', 'webmail'); + + INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_plugin_viewdetail', 'Can view unapproved plugin details', 'registered', 'wiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_plugin_preview', 'Can execute unapproved plugin', 'registered', 'wiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_plugin_approve', 'Can approve plugin execution', 'editors', 'wiki'); +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_trust_input', 'Trust all user inputs (no security checks)', 'admin', 'tiki'); + +UPDATE users_permissions SET feature_check = 'feature_wiki' WHERE permName IN( + 'tiki_p_admin_wiki', + 'tiki_p_assign_perm_wiki_page', + 'tiki_p_edit', + 'tiki_p_export_wiki', + 'tiki_p_lock', + 'tiki_p_minor', + 'tiki_p_remove', + 'tiki_p_rename', + 'tiki_p_rollback', + 'tiki_p_view', + 'tiki_p_view_history', + 'tiki_p_view_source' +); + +UPDATE users_permissions SET feature_check = 'wiki_feature_copyrights' WHERE permName = 'tiki_p_edit_copyrights'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE permName = 'tiki_p_edit_structures'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE permName = 'tiki_p_watch_structure'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_pictures' WHERE permName = 'tiki_p_upload_picture'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_templates' WHERE permName = 'tiki_p_use_as_template'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_admin_attachments'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_attach_files'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_wiki_view_attachments'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_admin_ratings'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_wiki_view_ratings'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_wiki_vote_ratings'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_comments' WHERE permName = 'tiki_p_wiki_view_comments'; + + DROP TABLE "users_usergroups"; CREATE TABLE "users_usergroups" ( @@ -5258,7 +5315,7 @@ `version` number(8) NOT NULL, `source_translation_bit` number(10) NULL, `original_translation_bit` number(10) NULL, - `flags` SET('critical') DEFAULT '' NOT NULL, + `flags` SET('critical') NULL DEFAULT '', PRIMARY KEY (`translation_bit_id`), KEY(`page_id`), KEY(`original_translation_bit`), @@ -5328,11 +5385,48 @@ ) ENGINE=MyISAM ; +DROP TABLE "tiki_schema"; + CREATE TABLE "tiki_schema" ( "patch_name" VARCHAR(100) PRIMARY KEY, "install_date" TIMESTAMP ) ENGINE=MyISAM; +DROP TABLE "tiki_semantic_tokens"; + +CREATE TABLE "tiki_semantic_tokens" ( + "token" VARCHAR(15) PRIMARY KEY, + "label" VARCHAR(25) NOT NULL, + "invert_token" VARCHAR(15) +) ENGINE=MyISAM ; + + +INSERT INTO tiki_semantic_tokens (token, label) VALUES('alias', 'Page Alias'); + + +DROP TABLE "tiki_webservice"; + +CREATE TABLE "tiki_webservice" ( + "service" VARCHAR(25) NOT NULL PRIMARY KEY, + "url" VARCHAR(250), + "schema_version" VARCHAR(5), + "schema_documentation" VARCHAR(250) +) ENGINE=MyISAM ; + + +DROP TABLE "tiki_webservice_template"; + +CREATE TABLE "tiki_webservice_template" ( + "service" VARCHAR(25) NOT NULL, + "template" VARCHAR(25) NOT NULL, + "engine" VARCHAR(15) NOT NULL, + "output" VARCHAR(15) NOT NULL, + "content" TEXT NOT NULL, + "last_modif" INT, + PRIMARY KEY( service, template ) +) ENGINE=MyISAM ; + + ; Modified: trunk/db/tiki-3.0-pgsql.sql =================================================================== --- trunk/db/tiki-3.0-pgsql.sql 2008-10-18 12:26:25 UTC (rev 15210) +++ trunk/db/tiki-3.0-pgsql.sql 2008-10-18 12:48:28 UTC (rev 15211) @@ -361,7 +361,8 @@ "impressions" integer default NULL, "clicks" integer default NULL, "zone" varchar(40) default NULL, - PRIMARY KEY ("bannerId") + PRIMARY KEY ("bannerId"), + "INDEX" ban1(zone,useDates,impressions,maxImpressions,hourFrom,hourTo,fromDate,toDate,mon,tue,wed,thu,fri,sat,sun) ) ENGINE=MyISAM ; @@ -745,6 +746,7 @@ "in_reply_to" varchar(128) default NULL, "comment_rating" smallint default NULL, "archived" char(1) default NULL, + "approved" char(1) NOT NULL default 'y', PRIMARY KEY ("threadId") ) ENGINE=MyISAM ; @@ -1356,6 +1358,7 @@ CREATE TABLE "tiki_links" ( "fromPage" varchar(160) NOT NULL default '', "toPage" varchar(160) NOT NULL default '', + "reltype" varchar(50), PRIMARY KEY ("fromPage","toPage") ) ENGINE=MyISAM; @@ -1635,6 +1638,8 @@ INSERT INTO "tiki_menu_options" ("optionId","menuId","type","name","url","position","section","perm","groupname","userlevel") VALUES (47,42,'o','Structures','tiki-admin_structures.php',250,'feature_wiki_structure','tiki_p_view','',0); +INSERT INTO "tiki_menu_options" ("optionId","menuId","type","name","url","position","section","perm","groupname","userlevel") VALUES (197,42,'o','Mind Map','tiki-mindmap.php',255,'feature_wiki_mindmap','tiki_p_view','',0); + INSERT INTO "tiki_menu_options" ("optionId","menuId","type","name","url","position","section","perm","groupname","userlevel") VALUES (48,42,'s','Image Galleries','tiki-galleries.php',300,'feature_galleries','tiki_p_view_image_gallery','',0); INSERT INTO "tiki_menu_options" ("optionId","menuId","type","name","url","position","section","perm","groupname","userlevel") VALUES (49,42,'o','Galleries','tiki-galleries.php',305,'feature_galleries','tiki_p_list_image_galleries','',0); @@ -3299,6 +3304,7 @@ "level" varchar(80) default NULL, "type" varchar(20) default NULL, "admin" varchar(1) default NULL, + "feature_check" VARCHAR(50) NULL, PRIMARY KEY ("permName") ) ENGINE=MyISAM; @@ -3782,13 +3788,65 @@ INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_use_webmail', 'Can use webmail', 'registered', 'webmail'); +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_use_group_webmail', 'Can use group webmail', 'registered', 'webmail'); + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_admin_group_webmail', 'Can administrate group webmail accounts', 'registered', 'webmail'); + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_use_personal_webmail', 'Can use personal webmail accounts', 'registered', 'webmail'); + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_admin_personal_webmail', 'Can administrate personal webmail accounts', 'registered', 'webmail'); + + + INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_plugin_viewdetail', 'Can view unapproved plugin details', 'registered', 'wiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_plugin_preview', 'Can execute unapproved plugin', 'registered', 'wiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_plugin_approve', 'Can approve plugin execution', 'editors', 'wiki'); +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_trust_input', 'Trust all user inputs (no security checks)', 'admin', 'tiki'); + +UPDATE users_permissions SET feature_check = 'feature_wiki' WHERE permName IN( + 'tiki_p_admin_wiki', + 'tiki_p_assign_perm_wiki_page', + 'tiki_p_edit', + 'tiki_p_export_wiki', + 'tiki_p_lock', + 'tiki_p_minor', + 'tiki_p_remove', + 'tiki_p_rename', + 'tiki_p_rollback', + 'tiki_p_view', + 'tiki_p_view_history', + 'tiki_p_view_source' +); + +UPDATE users_permissions SET feature_check = 'wiki_feature_copyrights' WHERE permName = 'tiki_p_edit_copyrights'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE permName = 'tiki_p_edit_structures'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE permName = 'tiki_p_watch_structure'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_pictures' WHERE permName = 'tiki_p_upload_picture'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_templates' WHERE permName = 'tiki_p_use_as_template'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_admin_attachments'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_attach_files'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_wiki_view_attachments'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_admin_ratings'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_wiki_view_ratings'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_wiki_vote_ratings'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_comments' WHERE permName = 'tiki_p_wiki_view_comments'; + + DROP TABLE "users_usergroups"; CREATE TABLE "users_usergroups" ( @@ -4577,7 +4635,7 @@ "version" integer NOT NULL, "source_translation_bit" bigint NULL, "original_translation_bit" bigint NULL, - "flags" SET('critical') NOT NULL DEFAULT '', + "flags" SET('critical') NULL DEFAULT '', PRIMARY KEY ("translation_bit_id"), KEY(page_id), KEY(original_translation_bit), @@ -4647,11 +4705,49 @@ ) ENGINE=MyISAM ; +DROP TABLE "tiki_schema"; + CREATE TABLE "tiki_schema" ( "patch_name" VARCHAR(100) PRIMARY KEY, "install_date" TIMESTAMP ) ENGINE=MyISAM; +DROP TABLE "tiki_semantic_tokens"; + +CREATE TABLE "tiki_semantic_tokens" ( + "token" VARCHAR(15) PRIMARY KEY, + "label" VARCHAR(25) NOT NULL, + "invert_token" VARCHAR(15) +) ENGINE=MyISAM ; + + +INSERT INTO "tiki_semantic_tokens" ("token","label") VALUES ('alias', 'Page Alias'); + + + +DROP TABLE "tiki_webservice"; + +CREATE TABLE "tiki_webservice" ( + "service" VARCHAR(25) NOT NULL PRIMARY KEY, + "url" VARCHAR(250), + "schema_version" VARCHAR(5), + "schema_documentation" VARCHAR(250) +) ENGINE=MyISAM ; + + +DROP TABLE "tiki_webservice_template"; + +CREATE TABLE "tiki_webservice_template" ( + "service" VARCHAR(25) NOT NULL, + "template" VARCHAR(25) NOT NULL, + "engine" VARCHAR(15) NOT NULL, + "output" VARCHAR(15) NOT NULL, + "content" TEXT NOT NULL, + "last_modif" INT, + PRIMARY KEY ("service","template") +) ENGINE=MyISAM ; + + ; Modified: trunk/db/tiki-3.0-sqlite.sql =================================================================== --- trunk/db/tiki-3.0-sqlite.sql 2008-10-18 12:26:25 UTC (rev 15210) +++ trunk/db/tiki-3.0-sqlite.sql 2008-10-18 12:48:28 UTC (rev 15211) @@ -362,7 +362,8 @@ "impressions" integer default NULL, "clicks" integer default NULL, "zone" varchar(40) default NULL, - PRIMARY KEY (bannerId) + PRIMARY KEY (bannerId), + "INDEX" ban1(zone,useDates,impressions,maxImpressions,hourFrom,hourTo,fromDate,toDate,mon,tue,wed,thu,fri,sat,sun) ) ENGINE=MyISAM ; @@ -748,6 +749,7 @@ "in_reply_to" varchar(128) default NULL, "comment_rating" smallint default NULL, "archived" char(1) default NULL, + "approved" char(1) NOT NULL default 'y', PRIMARY KEY (threadId) ) ENGINE=MyISAM ; @@ -1365,6 +1367,7 @@ CREATE TABLE 'tiki_links' ( "fromPage" varchar(160) NOT NULL default '', "toPage" varchar(160) NOT NULL default '', + "reltype" varchar(50), PRIMARY KEY (fromPage,toPage) ) ENGINE=MyISAM; @@ -1644,6 +1647,8 @@ INSERT INTO "," ("optionId","menuId","type","name","url","position","section","perm","groupname","userlevel") VALUES (47,42,'o','Structures','tiki-admin_structures.php',250,'feature_wiki_structure','tiki_p_view','',0); +INSERT INTO "," ("optionId","menuId","type","name","url","position","section","perm","groupname","userlevel") VALUES (197,42,'o','Mind Map','tiki-mindmap.php',255,'feature_wiki_mindmap','tiki_p_view','',0); + INSERT INTO "," ("optionId","menuId","type","name","url","position","section","perm","groupname","userlevel") VALUES (48,42,'s','Image Galleries','tiki-galleries.php',300,'feature_galleries','tiki_p_view_image_gallery','',0); INSERT INTO "," ("optionId","menuId","type","name","url","position","section","perm","groupname","userlevel") VALUES (49,42,'o','Galleries','tiki-galleries.php',305,'feature_galleries','tiki_p_list_image_galleries','',0); @@ -3310,6 +3315,7 @@ "level" varchar(80) default NULL, "type" varchar(20) default NULL, "admin" varchar(1) default NULL, + "feature_check" VARCHAR(50) NULL, PRIMARY KEY (permName) ) ENGINE=MyISAM; @@ -3793,13 +3799,65 @@ INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_use_webmail', 'Can use webmail', 'registered', 'webmail'); +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_use_group_webmail', 'Can use group webmail', 'registered', 'webmail'); + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_admin_group_webmail', 'Can administrate group webmail accounts', 'registered', 'webmail'); + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_use_personal_webmail', 'Can use personal webmail accounts', 'registered', 'webmail'); + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_admin_personal_webmail', 'Can administrate personal webmail accounts', 'registered', 'webmail'); + + + INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_plugin_viewdetail', 'Can view unapproved plugin details', 'registered', 'wiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_plugin_preview', 'Can execute unapproved plugin', 'registered', 'wiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_plugin_approve', 'Can approve plugin execution', 'editors', 'wiki'); +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_trust_input', 'Trust all user inputs (no security checks)', 'admin', 'tiki'); + +UPDATE users_permissions SET feature_check = 'feature_wiki' WHERE permName IN( + 'tiki_p_admin_wiki', + 'tiki_p_assign_perm_wiki_page', + 'tiki_p_edit', + 'tiki_p_export_wiki', + 'tiki_p_lock', + 'tiki_p_minor', + 'tiki_p_remove', + 'tiki_p_rename', + 'tiki_p_rollback', + 'tiki_p_view', + 'tiki_p_view_history', + 'tiki_p_view_source' +); + +UPDATE users_permissions SET feature_check = 'wiki_feature_copyrights' WHERE permName = 'tiki_p_edit_copyrights'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE permName = 'tiki_p_edit_structures'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE permName = 'tiki_p_watch_structure'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_pictures' WHERE permName = 'tiki_p_upload_picture'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_templates' WHERE permName = 'tiki_p_use_as_template'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_admin_attachments'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_attach_files'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_wiki_view_attachments'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_admin_ratings'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_wiki_view_ratings'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_wiki_vote_ratings'; + +UPDATE users_permissions SET feature_check = 'feature_wiki_comments' WHERE permName = 'tiki_p_wiki_view_comments'; + + DROP TABLE IF EXISTS 'users_usergroups'; CREATE TABLE 'users_usergroups' ( @@ -4588,7 +4646,7 @@ version integer NOT NULL, source_translation_bit bigint NULL, original_translation_bit bigint NULL, - flags SET('critical') NOT NULL DEFAULT '', + flags SET('critical') NULL DEFAULT '', PRIMARY KEY (translation_bit_id), KEY(page_id), KEY(original_translation_bit), @@ -4658,11 +4716,49 @@ ) ENGINE=MyISAM; +DROP TABLE IF EXISTS 'tiki_schema'; + CREATE TABLE 'tiki_schema' ( "patch_name" VARCHAR(100) PRIMARY KEY, "install_date" TIMESTAMP ) ENGINE=MyISAM; +DROP TABLE IF EXISTS 'tiki_semantic_tokens'; + +CREATE TABLE 'tiki_semantic_tokens' ( + "token" VARCHAR(15) PRIMARY KEY, + "label" VARCHAR(25) NOT NULL, + "invert_token" VARCHAR(15) +) ENGINE=MyISAM ; + + +INSERT INTO "tiki_semantic_tokens" ("token","label") VALUES ('alias', 'Page Alias'); + + + +DROP TABLE IF EXISTS 'tiki_webservice'; + +CREATE TABLE 'tiki_webservice' ( + "service" VARCHAR(25) NOT NULL PRIMARY KEY, + "url" VARCHAR(250), + "schema_version" VARCHAR(5), + "schema_documentation" VARCHAR(250) +) ENGINE=MyISAM ; + + +DROP TABLE IF EXISTS 'tiki_webservice_template'; + +CREATE TABLE 'tiki_webservice_template' ( + "service" VARCHAR(25) NOT NULL, + "template" VARCHAR(25) NOT NULL, + "engine" VARCHAR(15) NOT NULL, + "output" VARCHAR(15) NOT NULL, + "content" TEXT NOT NULL, + "last_modif" INT, + PRIMARY KEY( service, template ) +) ENGINE=MyISAM ; + + ; Modified: trunk/db/tiki-3.0-sybase.sql =================================================================== --- trunk/db/tiki-3.0-sybase.sql 2008-10-18 12:26:25 UTC (rev 15210) +++ trunk/db/tiki-3.0-sybase.sql 2008-10-18 12:48:28 UTC (rev 15211) @@ -462,7 +462,8 @@ "impressions" numeric(8,0) default NULL NULL, "clicks" numeric(8,0) default NULL NULL, "zone" varchar(40) default NULL NULL, - PRIMARY KEY (bannerId) + PRIMARY KEY (bannerId), + "INDEX" ban1(zone,useDates,impressions,maxImpressions,hourFrom,hourTo,fromDate,toDate,mon,tue,wed,thu,fri,sat,sun) ) ENGINE=MyISAM go @@ -963,6 +964,7 @@ "in_reply_to" varchar(128) default NULL NULL, "comment_rating" numeric(2,0) default NULL NULL, "archived" char(1) default NULL NULL, + "approved" char(1) default 'y' NOT NULL, PRIMARY KEY (threadId) ) ENGINE=MyISAM go @@ -1769,6 +1771,7 @@ CREATE TABLE "tiki_links" ( "fromPage" varchar(160) default '' NOT NULL, "toPage" varchar(160) default '' NOT NULL, + "reltype" varchar(50) default '', PRIMARY KEY (fromPage,toPage) ) ENGINE=MyISAM go @@ -2203,6 +2206,10 @@ go +INSERT INTO "," ("`optionId`","`menuId`","`type`","`name`","`url`","`position`","`section`","`perm`","`groupname`","`userlevel`") VALUES (197,42,'o','Mind Map','tiki-mindmap.php',255,'feature_wiki_mindmap','tiki_p_view','',0) +go + + INSERT INTO "," ("`optionId`","`menuId`","`type`","`name`","`url`","`position`","`section`","`perm`","`groupname`","`userlevel`") VALUES (48,42,'s','Image Galleries','tiki-galleries.php',300,'feature_galleries','tiki_p_view_image_gallery','',0) go @@ -4570,6 +4577,7 @@ "level" varchar(80) default NULL NULL, "type" varchar(20) default NULL NULL, "admin" varchar(1) default NULL NULL, + "feature_check" VARCHAR(50) NULL, PRIMARY KEY (permName) ) ENGINE=MyISAM go @@ -5498,6 +5506,24 @@ go +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_use_group_webmail', 'Can use group webmail', 'registered', 'webmail') +go + + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_admin_group_webmail', 'Can administrate group webmail accounts', 'registered', 'webmail') +go + + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_use_personal_webmail', 'Can use personal webmail accounts', 'registered', 'webmail') +go + + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_admin_personal_webmail', 'Can administrate personal webmail accounts', 'registered', 'webmail') +go + + + + INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_plugin_viewdetail', 'Can view unapproved plugin details', 'registered', 'wiki') go @@ -5510,7 +5536,77 @@ go +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_trust_input', 'Trust all user inputs (no security checks)', 'admin', 'tiki') +go + + +UPDATE users_permissions SET feature_check = 'feature_wiki' WHERE permName IN( + 'tiki_p_admin_wiki', + 'tiki_p_assign_perm_wiki_page', + 'tiki_p_edit', + 'tiki_p_export_wiki', + 'tiki_p_lock', + 'tiki_p_minor', + 'tiki_p_remove', + 'tiki_p_rename', + 'tiki_p_rollback', + 'tiki_p_view', + 'tiki_p_view_history', + 'tiki_p_view_source' +) +go + + +UPDATE users_permissions SET feature_check = 'wiki_feature_copyrights' WHERE permName = 'tiki_p_edit_copyrights' +go + + +UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE permName = 'tiki_p_edit_structures' +go + + +UPDATE users_permissions SET feature_check = 'feature_wiki_structure' WHERE permName = 'tiki_p_watch_structure' +go + + +UPDATE users_permissions SET feature_check = 'feature_wiki_pictures' WHERE permName = 'tiki_p_upload_picture' +go + + +UPDATE users_permissions SET feature_check = 'feature_wiki_templates' WHERE permName = 'tiki_p_use_as_template' +go + + +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_admin_attachments' +go + + +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_attach_files' +go + + +UPDATE users_permissions SET feature_check = 'feature_wiki_attachments' WHERE permName = 'tiki_p_wiki_view_attachments' +go + + +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_admin_ratings' +go + + +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_wiki_view_ratings' +go + + +UPDATE users_permissions SET feature_check = 'feature_wiki_ratings' WHERE permName = 'tiki_p_wiki_vote_ratings' +go + + +UPDATE users_permissions SET feature_check = 'feature_wiki_comments' WHERE permName = 'tiki_p_wiki_view_comments' +go + + + -- DROP TABLE "users_usergroups" go @@ -6876,7 +6972,7 @@ `version` numeric(8,0) NOT NULL, `source_translation_bit` numeric(10,0) NULL, `original_translation_bit` numeric(10,0) NULL, - `flags` SET('critical') DEFAULT '' NOT NULL, + `flags` SET('critical') NULL DEFAULT '', PRIMARY KEY (`translation_bit_id`), KEY(`page_id`), KEY(`original_translation_bit`), @@ -6964,6 +7060,10 @@ +-- DROP TABLE "tiki_schema" +go + + CREATE TABLE "tiki_schema" ( "patch_name" VARCHAR(100) PRIMARY KEY, "install_date" TIMESTAMP @@ -6972,7 +7072,57 @@ +-- DROP TABLE "tiki_semantic_tokens" +go + +CREATE TABLE "tiki_semantic_tokens" ( + "token" VARCHAR(15) PRIMARY KEY, + "label" VARCHAR(25) NOT NULL, + "invert_token" VARCHAR(15) +) ENGINE=MyISAM go + +INSERT INTO tiki_semantic_tokens (token, label) VALUES('alias', 'Page Alias') +go + + + + +-- DROP TABLE "tiki_webservice" +go + + +CREATE TABLE "tiki_webservice" ( + "service" VARCHAR(25) NOT NULL PRIMARY KEY, + "url" VARCHAR(250), + "schema_version" VARCHAR(5), + "schema_documentation" VARCHAR(250) +) ENGINE=MyISAM +go + + + +-- DROP TABLE "tiki_webservice_template" +go + + +CREATE TABLE "tiki_webservice_template" ( + "service" VARCHAR(25) NOT NULL, + "template" VARCHAR(25) NOT NULL, + "engine" VARCHAR(15) NOT NULL, + "output" VARCHAR(15) NOT NULL, + "content" TEXT NOT NULL, + "last_modif" INT, + PRIMARY KEY( service, template ) +) ENGINE=MyISAM +go + + + + +go + + This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |