From: <pk...@us...> - 2011-07-14 17:27:51
|
Revision: 35346 http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=35346&view=rev Author: pkdille Date: 2011-07-14 17:27:39 +0000 (Thu, 14 Jul 2011) Log Message: ----------- [REL] Preparing 3.9 release Modified Paths: -------------- branches/3.0/db/convertscripts/convertsqls.sh branches/3.0/db/convertscripts/mysql3tooci8.php branches/3.0/db/convertscripts/mysql3topgsql72.php branches/3.0/db/convertscripts/mysql3tosqlite.php branches/3.0/db/convertscripts/mysql3tosybase.php branches/3.0/lib/setup/twversion.class.php Added Paths: ----------- branches/3.0/db/tiki-3.9-mysql.sql branches/3.0/db/tiki-3.9-mysqli.sql branches/3.0/db/tiki-3.9-oci8.sql branches/3.0/db/tiki-3.9-pgsql.sql branches/3.0/db/tiki-3.9-sqlite.sql branches/3.0/db/tiki-3.9-sybase.sql Removed Paths: ------------- branches/3.0/db/tiki-3.8-mysql.sql branches/3.0/db/tiki-3.8-mysqli.sql branches/3.0/db/tiki-3.8-oci8.sql branches/3.0/db/tiki-3.8-pgsql.sql branches/3.0/db/tiki-3.8-sqlite.sql branches/3.0/db/tiki-3.8-sybase.sql Modified: branches/3.0/db/convertscripts/convertsqls.sh =================================================================== --- branches/3.0/db/convertscripts/convertsqls.sh 2011-07-14 17:15:27 UTC (rev 35345) +++ branches/3.0/db/convertscripts/convertsqls.sh 2011-07-14 17:27:39 UTC (rev 35346) @@ -9,7 +9,7 @@ # sh convertsqls.sh domain.com/subdomain/ # -VERSION="3.8" +VERSION="3.9" if [ "$1" = "-h" ]; then echo "Usage: ./convertsqls.sh <host> <tikiversion> or .//convertsqls.sh -h for this help" Modified: branches/3.0/db/convertscripts/mysql3tooci8.php =================================================================== --- branches/3.0/db/convertscripts/mysql3tooci8.php 2011-07-14 17:15:27 UTC (rev 35345) +++ branches/3.0/db/convertscripts/mysql3tooci8.php 2011-07-14 17:27:39 UTC (rev 35346) @@ -1,7 +1,7 @@ <?php if (array_key_exists('SHELL', $_ENV)) { - $tikiversion='3.8'; + $tikiversion='3.9'; } else { $tikiversion='1.9'; Modified: branches/3.0/db/convertscripts/mysql3topgsql72.php =================================================================== --- branches/3.0/db/convertscripts/mysql3topgsql72.php 2011-07-14 17:15:27 UTC (rev 35345) +++ branches/3.0/db/convertscripts/mysql3topgsql72.php 2011-07-14 17:27:39 UTC (rev 35346) @@ -1,7 +1,7 @@ <?php /* $Id$ */ -$tikiversion='3.8'; +$tikiversion='3.9'; if(!isset($_GET['version'])) { echo "version not given. Using default $tikiversion.<br />"; Modified: branches/3.0/db/convertscripts/mysql3tosqlite.php =================================================================== --- branches/3.0/db/convertscripts/mysql3tosqlite.php 2011-07-14 17:15:27 UTC (rev 35345) +++ branches/3.0/db/convertscripts/mysql3tosqlite.php 2011-07-14 17:27:39 UTC (rev 35346) @@ -1,7 +1,7 @@ <?php /* $Id$ */ -$tikiversion='3.8'; +$tikiversion='3.9'; if(!isset($_GET['version'])) { echo "version not given. Using default $tikiversion.<br />"; Modified: branches/3.0/db/convertscripts/mysql3tosybase.php =================================================================== --- branches/3.0/db/convertscripts/mysql3tosybase.php 2011-07-14 17:15:27 UTC (rev 35345) +++ branches/3.0/db/convertscripts/mysql3tosybase.php 2011-07-14 17:27:39 UTC (rev 35346) @@ -1,6 +1,6 @@ <?php -$tikiversion='3.8'; +$tikiversion='3.9'; if(!isset($_GET['version'])) { echo "version not given. Using default $tikiversion.<br />"; Deleted: branches/3.0/db/tiki-3.8-mysql.sql =================================================================== --- branches/3.0/db/tiki-3.8-mysql.sql 2011-07-14 17:15:27 UTC (rev 35345) +++ branches/3.0/db/tiki-3.8-mysql.sql 2011-07-14 17:27:39 UTC (rev 35346) @@ -1,3830 +0,0 @@ -# -------------------------------------------------------- -# Database : tikiwiki -# -------------------------------------------------------- - -DROP TABLE IF EXISTS galaxia_activities; -CREATE TABLE galaxia_activities ( - activityId int(14) NOT NULL auto_increment, - name varchar(80) default NULL, - normalized_name varchar(80) default NULL, - pId int(14) NOT NULL default '0', - type enum('start','end','split','switch','join','activity','standalone') default NULL, - isAutoRouted char(1) default NULL, - flowNum int(10) default NULL, - isInteractive char(1) default NULL, - lastModif int(14) default NULL, - description text, - expirationTime int(6) unsigned NOT NULL default '0', - PRIMARY KEY (activityId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS galaxia_activity_roles; -CREATE TABLE galaxia_activity_roles ( - activityId int(14) NOT NULL default '0', - roleId int(14) NOT NULL default '0', - PRIMARY KEY (activityId,roleId) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS galaxia_instance_activities; -CREATE TABLE galaxia_instance_activities ( - instanceId int(14) NOT NULL default '0', - activityId int(14) NOT NULL default '0', - started int(14) NOT NULL default '0', - ended int(14) NOT NULL default '0', - user varchar(200) default '', - status enum('running','completed') default NULL, - PRIMARY KEY (instanceId,activityId) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS galaxia_instance_comments; -CREATE TABLE galaxia_instance_comments ( - cId int(14) NOT NULL auto_increment, - instanceId int(14) NOT NULL default '0', - user varchar(200) default '', - activityId int(14) default NULL, - hash varchar(34) default NULL, - title varchar(250) default NULL, - comment text, - activity varchar(80) default NULL, - timestamp int(14) default NULL, - PRIMARY KEY (cId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS galaxia_instances; -CREATE TABLE galaxia_instances ( - instanceId int(14) NOT NULL auto_increment, - pId int(14) NOT NULL default '0', - started int(14) default NULL, - name varchar(200) NOT NULL default 'No Name', - owner varchar(200) default NULL, - nextActivity int(14) default NULL, - nextUser varchar(200) default NULL, - ended int(14) default NULL, - status enum('active','exception','aborted','completed') default NULL, - properties longblob, - PRIMARY KEY (instanceId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS galaxia_processes; -CREATE TABLE galaxia_processes ( - pId int(14) NOT NULL auto_increment, - name varchar(80) default NULL, - isValid char(1) default NULL, - isActive char(1) default NULL, - version varchar(12) default NULL, - description text, - lastModif int(14) default NULL, - normalized_name varchar(80) default NULL, - PRIMARY KEY (pId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS galaxia_roles; -CREATE TABLE galaxia_roles ( - roleId int(14) NOT NULL auto_increment, - pId int(14) NOT NULL default '0', - lastModif int(14) default NULL, - name varchar(80) default NULL, - description text, - PRIMARY KEY (roleId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS galaxia_transitions; -CREATE TABLE galaxia_transitions ( - pId int(14) NOT NULL default '0', - actFromId int(14) NOT NULL default '0', - actToId int(14) NOT NULL default '0', - PRIMARY KEY (actFromId,actToId) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS galaxia_user_roles; -CREATE TABLE galaxia_user_roles ( - pId int(14) NOT NULL default '0', - roleId int(14) NOT NULL auto_increment, - user varchar(200) NOT NULL default '', - PRIMARY KEY (roleId,user) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS galaxia_workitems; -CREATE TABLE galaxia_workitems ( - itemId int(14) NOT NULL auto_increment, - instanceId int(14) NOT NULL default '0', - orderId int(14) NOT NULL default '0', - activityId int(14) NOT NULL default '0', - properties longblob, - started int(14) default NULL, - ended int(14) default NULL, - user varchar(200) default '', - PRIMARY KEY (itemId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS messu_messages; -CREATE TABLE messu_messages ( - msgId int(14) NOT NULL auto_increment, - user varchar(200) NOT NULL default '', - user_from varchar(200) NOT NULL default '', - user_to text, - user_cc text, - user_bcc text, - subject varchar(255) default NULL, - body text, - hash varchar(32) default NULL, - replyto_hash varchar(32) default NULL, - date int(14) default NULL, - isRead char(1) default NULL, - isReplied char(1) default NULL, - isFlagged char(1) default NULL, - priority int(2) default NULL, - PRIMARY KEY (msgId), - KEY userIsRead (user, isRead) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS messu_archive; -CREATE TABLE messu_archive ( - msgId int(14) NOT NULL auto_increment, - user varchar(40) NOT NULL default '', - user_from varchar(40) NOT NULL default '', - user_to text, - user_cc text, - user_bcc text, - subject varchar(255) default NULL, - body text, - hash varchar(32) default NULL, - replyto_hash varchar(32) default NULL, - date int(14) default NULL, - isRead char(1) default NULL, - isReplied char(1) default NULL, - isFlagged char(1) default NULL, - priority int(2) default NULL, - PRIMARY KEY (msgId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS messu_sent; -CREATE TABLE messu_sent ( - msgId int(14) NOT NULL auto_increment, - user varchar(40) NOT NULL default '', - user_from varchar(40) NOT NULL default '', - user_to text, - user_cc text, - user_bcc text, - subject varchar(255) default NULL, - body text, - hash varchar(32) default NULL, - replyto_hash varchar(32) default NULL, - date int(14) default NULL, - isRead char(1) default NULL, - isReplied char(1) default NULL, - isFlagged char(1) default NULL, - priority int(2) default NULL, - PRIMARY KEY (msgId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS sessions; -CREATE TABLE sessions( - sesskey char(32) NOT NULL, - expiry int(11) unsigned NOT NULL, - expireref varchar(64), - data text NOT NULL, - PRIMARY KEY (sesskey), - KEY expiry (expiry) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_actionlog; -CREATE TABLE tiki_actionlog ( - actionId int(8) NOT NULL auto_increment, - action varchar(255) NOT NULL default '', - lastModif int(14) default NULL, - object varchar(255) default NULL, - objectType varchar(32) NOT NULL default '', - user varchar(200) default '', - ip varchar(15) default NULL, - comment varchar(200) default NULL, - categId int(12) NOT NULL default '0', - PRIMARY KEY (actionId), - KEY lastModif(lastModif), - KEY object(object(100), objectType, action(100)) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_actionlog_params; -CREATE TABLE tiki_actionlog_params ( - actionId int(8) NOT NULL, - name varchar(40) NOT NULL, - value text, - KEY (actionId), - KEY nameValue (name, value(200)) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_articles; -CREATE TABLE tiki_articles ( - articleId int(8) NOT NULL auto_increment, - topline varchar(255) default NULL, - title varchar(255) default NULL, - subtitle varchar(255) default NULL, - linkto varchar(255) default NULL, - lang varchar(16) default NULL, - state char(1) default 's', - authorName varchar(60) default NULL, - topicId int(14) default NULL, - topicName varchar(40) default NULL, - size int(12) default NULL, - useImage char(1) default NULL, - image_name varchar(80) default NULL, - image_caption text default NULL, - image_type varchar(80) default NULL, - image_size int(14) default NULL, - image_x int(4) default NULL, - image_y int(4) default NULL, - image_data longblob, - publishDate int(14) default NULL, - expireDate int(14) default NULL, - created int(14) default NULL, - heading text, - body text, - hash varchar(32) default NULL, - author varchar(200) default NULL, - nbreads int(14) default NULL, - votes int(8) default NULL, - points int(14) default NULL, - type varchar(50) default NULL, - rating decimal(3,2) default NULL, - isfloat char(1) default NULL, - PRIMARY KEY (articleId), - KEY title (title), - KEY heading (heading(255)), - KEY body (body(255)), - KEY nbreads (nbreads), - KEY author (author(32)), - KEY topicId (topicId), - KEY publishDate (publishDate), - KEY expireDate (expireDate), - KEY type (type), - FULLTEXT KEY ft (title,heading,body) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_article_types; -CREATE TABLE tiki_article_types ( - type varchar(50) NOT NULL, - use_ratings varchar(1) default NULL, - show_pre_publ varchar(1) default NULL, - show_post_expire varchar(1) default 'y', - heading_only varchar(1) default NULL, - allow_comments varchar(1) default 'y', - show_image varchar(1) default 'y', - show_avatar varchar(1) default NULL, - show_author varchar(1) default 'y', - show_pubdate varchar(1) default 'y', - show_expdate varchar(1) default NULL, - show_reads varchar(1) default 'y', - show_size varchar(1) default 'n', - show_topline varchar(1) default 'n', - show_subtitle varchar(1) default 'n', - show_linkto varchar(1) default 'n', - show_image_caption varchar(1) default 'n', - show_lang varchar(1) default 'n', - creator_edit varchar(1) default NULL, - comment_can_rate_article char(1) default NULL, - PRIMARY KEY (type), - KEY show_pre_publ (show_pre_publ), - KEY show_post_expire (show_post_expire) -) ENGINE=MyISAM ; - -INSERT IGNORE INTO tiki_article_types(type) VALUES ('Article'); -INSERT IGNORE INTO tiki_article_types(type,use_ratings) VALUES ('Review','y'); -INSERT IGNORE INTO tiki_article_types(type,show_post_expire) VALUES ('Event','n'); -INSERT IGNORE INTO tiki_article_types(type,show_post_expire,heading_only,allow_comments) VALUES ('Classified','n','y','n'); - -DROP TABLE IF EXISTS tiki_banners; -CREATE TABLE tiki_banners ( - bannerId int(12) NOT NULL auto_increment, - client varchar(200) NOT NULL default '', - url varchar(255) default NULL, - title varchar(255) default NULL, - alt varchar(250) default NULL, - which varchar(50) default NULL, - imageData longblob, - imageType varchar(200) default NULL, - imageName varchar(100) default NULL, - HTMLData text, - fixedURLData varchar(255) default NULL, - textData text, - fromDate int(14) default NULL, - toDate int(14) default NULL, - useDates char(1) default NULL, - mon char(1) default NULL, - tue char(1) default NULL, - wed char(1) default NULL, - thu char(1) default NULL, - fri char(1) default NULL, - sat char(1) default NULL, - sun char(1) default NULL, - hourFrom varchar(4) default NULL, - hourTo varchar(4) default NULL, - created int(14) default NULL, - maxImpressions int(8) default NULL, - impressions int(8) default NULL, - maxClicks int(8) default NULL, - clicks int(8) default NULL, - zone varchar(40) default NULL, - 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; -CREATE TABLE tiki_banning ( - banId int(12) NOT NULL auto_increment, - mode enum('user','ip') default NULL, - title varchar(200) default NULL, - ip1 char(3) default NULL, - ip2 char(3) default NULL, - ip3 char(3) default NULL, - ip4 char(3) default NULL, - user varchar(200) default '', - date_from timestamp(14) NOT NULL, - date_to timestamp(14) NOT NULL, - use_dates char(1) default NULL, - created int(14) default NULL, - message text, - PRIMARY KEY (banId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_banning_sections; -CREATE TABLE tiki_banning_sections ( - banId int(12) NOT NULL default '0', - section varchar(100) NOT NULL default '', - PRIMARY KEY (banId,section) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_blog_activity; -CREATE TABLE tiki_blog_activity ( - blogId int(8) NOT NULL default '0', - day int(14) NOT NULL default '0', - posts int(8) default NULL, - PRIMARY KEY (blogId,day) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_blog_posts; -CREATE TABLE tiki_blog_posts ( - postId int(8) NOT NULL auto_increment, - blogId int(8) NOT NULL default '0', - data text, - data_size int(11) unsigned NOT NULL default '0', - created int(14) default NULL, - user varchar(200) default '', - trackbacks_to text, - trackbacks_from text, - title varchar(255) default NULL, - priv varchar(1) default NULL, - PRIMARY KEY (postId), - KEY data (data(255)), - KEY blogId (blogId), - KEY created (created), - FULLTEXT KEY ft (data,title) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_blog_posts_images; -CREATE TABLE tiki_blog_posts_images ( - imgId int(14) NOT NULL auto_increment, - postId int(14) NOT NULL default '0', - filename varchar(80) default NULL, - filetype varchar(80) default NULL, - filesize int(14) default NULL, - data longblob, - PRIMARY KEY (imgId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_blogs; -CREATE TABLE tiki_blogs ( - blogId int(8) NOT NULL auto_increment, - created int(14) default NULL, - lastModif int(14) default NULL, - title varchar(200) default NULL, - description text, - user varchar(200) default '', - public char(1) default NULL, - posts int(8) default NULL, - maxPosts int(8) default NULL, - hits int(8) default NULL, - activity decimal(4,2) default NULL, - heading text, - use_find char(1) default NULL, - use_title char(1) default NULL, - add_date char(1) default NULL, - add_poster char(1) default NULL, - allow_comments char(1) default NULL, - show_avatar char(1) default NULL, - PRIMARY KEY (blogId), - KEY title (title), - KEY description (description(255)), - KEY hits (hits), - FULLTEXT KEY ft (title,description) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_calendar_categories; -CREATE TABLE tiki_calendar_categories ( - calcatId int(11) NOT NULL auto_increment, - calendarId int(14) NOT NULL default '0', - name varchar(255) NOT NULL default '', - PRIMARY KEY (calcatId), - UNIQUE KEY catname (calendarId,name(16)) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_calendar_recurrence; -CREATE TABLE tiki_calendar_recurrence ( - recurrenceId int(14) NOT NULL auto_increment, - calendarId int(14) NOT NULL default '0', - start int(4) NOT NULL default '0', - end int(4) NOT NULL default '2359', - allday tinyint(1) NOT NULL default '0', - locationId int(14) default NULL, - categoryId int(14) default NULL, - nlId int(12) NOT NULL default '0', - priority enum('1','2','3','4','5','6','7','8','9') NOT NULL default '1', - status enum('0','1','2') NOT NULL default '0', - url varchar(255) default NULL, - lang char(16) NOT NULL default 'en', - name varchar(255) NOT NULL default '', - description blob, - weekly tinyint(1) default '0', - weekday tinyint(1), - monthly tinyint(1) default '0', - dayOfMonth int(2), - yearly tinyint(1) default '0', - dateOfYear int(4), - nbRecurrences int(8), - startPeriod int(14), - endPeriod int(14), - user varchar(200) default '', - created int(14) NOT NULL default '0', - lastmodif int(14) NOT NULL default '0', - PRIMARY KEY (recurrenceId), - KEY calendarId (calendarId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_calendar_items; -CREATE TABLE tiki_calendar_items ( - calitemId int(14) NOT NULL auto_increment, - calendarId int(14) NOT NULL default '0', - start int(14) NOT NULL default '0', - end int(14) NOT NULL default '0', - locationId int(14) default NULL, - categoryId int(14) default NULL, - nlId int(12) NOT NULL default '0', - priority enum('0', '1','2','3','4','5','6','7','8','9') default '0', - status enum('0','1','2') NOT NULL default '0', - url varchar(255) default NULL, - lang char(16) NOT NULL default 'en', - name varchar(255) NOT NULL default '', - description text, - recurrenceId int(14), - changed tinyint(1) DEFAULT '0', - user varchar(200) default '', - created int(14) NOT NULL default '0', - lastmodif int(14) NOT NULL default '0', - allday tinyint(1) NOT NULL default '0', - PRIMARY KEY (calitemId), - KEY calendarId (calendarId), - FULLTEXT KEY ft (name,description), - CONSTRAINT fk_calitems_recurrence - FOREIGN KEY (recurrenceId) REFERENCES tiki_calendar_recurrence(recurrenceId) - ON UPDATE CASCADE ON DELETE SET NULL -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_calendar_locations; -CREATE TABLE tiki_calendar_locations ( - callocId int(14) NOT NULL auto_increment, - calendarId int(14) NOT NULL default '0', - name varchar(255) NOT NULL default '', - description blob, - PRIMARY KEY (callocId), - UNIQUE KEY locname (calendarId,name(16)) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_calendar_roles; -CREATE TABLE tiki_calendar_roles ( - calitemId int(14) NOT NULL default '0', - username varchar(200) NOT NULL default '', - role enum('0','1','2','3','6') NOT NULL default '0', - PRIMARY KEY (calitemId,username(16),role) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_calendars; -CREATE TABLE tiki_calendars ( - calendarId int(14) NOT NULL auto_increment, - name varchar(80) NOT NULL default '', - description varchar(255) default NULL, - user varchar(200) NOT NULL default '', - customlocations enum('n','y') NOT NULL default 'n', - customcategories enum('n','y') NOT NULL default 'n', - customlanguages enum('n','y') NOT NULL default 'n', - custompriorities enum('n','y') NOT NULL default 'n', - customparticipants enum('n','y') NOT NULL default 'n', - customsubscription enum('n','y') NOT NULL default 'n', - customstatus enum('n','y') NOT NULL default 'y', - created int(14) NOT NULL default '0', - lastmodif int(14) NOT NULL default '0', - personal enum ('n', 'y') NOT NULL default 'n', - PRIMARY KEY (calendarId) -) ENGINE=MyISAM ; - -DROP TABLE IF EXISTS tiki_calendar_options; -CREATE TABLE tiki_calendar_options ( - calendarId int(14) NOT NULL default 0, - optionName varchar(120) NOT NULL default '', - value varchar(255), - PRIMARY KEY (calendarId,optionName) -) ENGINE=MyISAM ; - -DROP TABLE IF EXISTS tiki_categories; -CREATE TABLE tiki_categories ( - categId int(12) NOT NULL auto_increment, - name varchar(100) default NULL, - description varchar(250) default NULL, - parentId int(12) default NULL, - hits int(8) default NULL, - PRIMARY KEY (categId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_objects; -CREATE TABLE tiki_objects ( - objectId int(12) NOT NULL auto_increment, - type varchar(50) default NULL, - itemId varchar(255) default NULL, - description text, - created int(14) default NULL, - name varchar(200) default NULL, - href varchar(200) default NULL, - hits int(8) default NULL, - comments_locked char(1) NOT NULL default 'n', - PRIMARY KEY (objectId), - KEY (type, objectId), - KEY (itemId, type) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS `tiki_categorized_objects`; -CREATE TABLE `tiki_categorized_objects` ( - `catObjectId` int(11) NOT NULL default '0', - PRIMARY KEY (`catObjectId`) -) ENGINE=MyISAM ; - -DROP TABLE IF EXISTS tiki_category_objects; -CREATE TABLE tiki_category_objects ( - catObjectId int(12) NOT NULL default '0', - categId int(12) NOT NULL default '0', - PRIMARY KEY (catObjectId,categId) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_object_ratings; -CREATE TABLE tiki_object_ratings ( - catObjectId int(12) NOT NULL default '0', - pollId int(12) NOT NULL default '0', - PRIMARY KEY (catObjectId,pollId) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_category_sites; -CREATE TABLE tiki_category_sites ( - categId int(10) NOT NULL default '0', - siteId int(14) NOT NULL default '0', - PRIMARY KEY (categId,siteId) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_chart_items; -CREATE TABLE tiki_chart_items ( - itemId int(14) NOT NULL auto_increment, - title varchar(250) default NULL, - description text, - chartId int(14) NOT NULL default '0', - created int(14) default NULL, - URL varchar(250) default NULL, - votes int(14) default NULL, - points int(14) default NULL, - average decimal(4,2) default NULL, - PRIMARY KEY (itemId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_charts; -CREATE TABLE tiki_charts ( - chartId int(14) NOT NULL auto_increment, - title varchar(250) default NULL, - description text, - hits int(14) default NULL, - singleItemVotes char(1) default NULL, - singleChartVotes char(1) default NULL, - suggestions char(1) default NULL, - autoValidate char(1) default NULL, - topN int(6) default NULL, - maxVoteValue int(4) default NULL, - frequency int(14) default NULL, - showAverage char(1) default NULL, - isActive char(1) default NULL, - showVotes char(1) default NULL, - useCookies char(1) default NULL, - lastChart int(14) default NULL, - voteAgainAfter int(14) default NULL, - created int(14) default NULL, - PRIMARY KEY (chartId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_charts_rankings; -CREATE TABLE tiki_charts_rankings ( - chartId int(14) NOT NULL default '0', - itemId int(14) NOT NULL default '0', - position int(14) NOT NULL default '0', - timestamp int(14) NOT NULL default '0', - lastPosition int(14) NOT NULL default '0', - period int(14) NOT NULL default '0', - rvotes int(14) NOT NULL default '0', - raverage decimal(4,2) NOT NULL default '0.00', - PRIMARY KEY (chartId,itemId,period) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_charts_votes; -CREATE TABLE tiki_charts_votes ( - user varchar(200) NOT NULL default '', - itemId int(14) NOT NULL default '0', - timestamp int(14) default NULL, - chartId int(14) default NULL, - PRIMARY KEY (user,itemId) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_chat_channels; -CREATE TABLE tiki_chat_channels ( - channelId int(8) NOT NULL auto_increment, - name varchar(30) default NULL, - description varchar(250) default NULL, - max_users int(8) default NULL, - mode char(1) default NULL, - moderator varchar(200) default NULL, - active char(1) default NULL, - refresh int(6) default NULL, - PRIMARY KEY (channelId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_chat_messages; -CREATE TABLE tiki_chat_messages ( - messageId int(8) NOT NULL auto_increment, - channelId int(8) NOT NULL default '0', - data varchar(255) default NULL, - poster varchar(200) NOT NULL default 'anonymous', - timestamp int(14) default NULL, - PRIMARY KEY (messageId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_chat_users; -CREATE TABLE tiki_chat_users ( - nickname varchar(200) NOT NULL default '', - channelId int(8) NOT NULL default '0', - timestamp int(14) default NULL, - PRIMARY KEY (nickname,channelId) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_comments; -CREATE TABLE tiki_comments ( - threadId int(14) NOT NULL auto_increment, - object varchar(255) NOT NULL default '', - objectType varchar(32) NOT NULL default '', - parentId int(14) default NULL, - userName varchar(200) default '', - commentDate int(14) default NULL, - hits int(8) default NULL, - type char(1) default NULL, - points decimal(8,2) default NULL, - votes int(8) default NULL, - average decimal(8,4) default NULL, - title varchar(255) default NULL, - data text, - hash varchar(32) default NULL, - user_ip varchar(15) default NULL, - summary varchar(240) default NULL, - smiley varchar(80) default NULL, - message_id varchar(128) default NULL, - 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', - locked char(1) NOT NULL default 'n', - PRIMARY KEY (threadId), - UNIQUE KEY no_repeats (parentId, userName(40), title(100), commentDate, message_id(40), in_reply_to(40)), - KEY title (title), - KEY data (data(255)), - KEY hits (hits), - KEY tc_pi (parentId), - KEY objectType (object, objectType), - KEY commentDate (commentDate), - KEY threaded (message_id, in_reply_to, parentId), - FULLTEXT KEY ft (title,data) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_content; -CREATE TABLE tiki_content ( - contentId int(8) NOT NULL auto_increment, - description text, - contentLabel varchar(255) NOT NULL default '', - PRIMARY KEY (contentId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_content_templates; -CREATE TABLE tiki_content_templates ( - templateId int(10) NOT NULL auto_increment, - content longblob, - name varchar(200) default NULL, - created int(14) default NULL, - PRIMARY KEY (templateId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_content_templates_sections; -CREATE TABLE tiki_content_templates_sections ( - templateId int(10) NOT NULL default '0', - section varchar(250) NOT NULL default '', - PRIMARY KEY (templateId,section) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_cookies; -CREATE TABLE tiki_cookies ( - cookieId int(10) NOT NULL auto_increment, - cookie text, - PRIMARY KEY (cookieId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_copyrights; -CREATE TABLE tiki_copyrights ( - copyrightId int(12) NOT NULL auto_increment, - page varchar(200) default NULL, - title varchar(200) default NULL, - year int(11) default NULL, - authors varchar(200) default NULL, - copyright_order int(11) default NULL, - userName varchar(200) default '', - PRIMARY KEY (copyrightId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_directory_categories; -CREATE TABLE tiki_directory_categories ( - categId int(10) NOT NULL auto_increment, - parent int(10) default NULL, - name varchar(240) default NULL, - description text, - childrenType char(1) default NULL, - sites int(10) default NULL, - viewableChildren int(4) default NULL, - allowSites char(1) default NULL, - showCount char(1) default NULL, - editorGroup varchar(200) default NULL, - hits int(12) default NULL, - PRIMARY KEY (categId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_directory_search; -CREATE TABLE tiki_directory_search ( - term varchar(250) NOT NULL default '', - hits int(14) default NULL, - PRIMARY KEY (term) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_directory_sites; -CREATE TABLE tiki_directory_sites ( - siteId int(14) NOT NULL auto_increment, - name varchar(240) default NULL, - description text, - url varchar(255) default NULL, - country varchar(255) default NULL, - hits int(12) default NULL, - isValid char(1) default NULL, - created int(14) default NULL, - lastModif int(14) default NULL, - cache longblob, - cache_timestamp int(14) default NULL, - PRIMARY KEY (siteId), - KEY (isValid), - KEY (url), - FULLTEXT KEY ft (name,description) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_drawings; -CREATE TABLE tiki_drawings ( - drawId int(12) NOT NULL auto_increment, - version int(8) default NULL, - name varchar(250) default NULL, - filename_draw varchar(250) default NULL, - filename_pad varchar(250) default NULL, - timestamp int(14) default NULL, - user varchar(200) default '', - PRIMARY KEY (drawId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_dsn; -CREATE TABLE tiki_dsn ( - dsnId int(12) NOT NULL auto_increment, - name varchar(200) NOT NULL default '', - dsn varchar(255) default NULL, - PRIMARY KEY (dsnId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_dynamic_variables; -CREATE TABLE tiki_dynamic_variables ( - name varchar(40) NOT NULL, - data text, - PRIMARY KEY (name) -); - -DROP TABLE IF EXISTS tiki_extwiki; -CREATE TABLE tiki_extwiki ( - extwikiId int(12) NOT NULL auto_increment, - name varchar(200) NOT NULL default '', - extwiki varchar(255) default NULL, - PRIMARY KEY (extwikiId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_faq_questions; -CREATE TABLE tiki_faq_questions ( - questionId int(10) NOT NULL auto_increment, - faqId int(10) default NULL, - position int(4) default NULL, - question text, - answer text, - PRIMARY KEY (questionId), - KEY faqId (faqId), - KEY question (question(255)), - KEY answer (answer(255)), - FULLTEXT KEY ft (question,answer) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_faqs; -CREATE TABLE tiki_faqs ( - faqId int(10) NOT NULL auto_increment, - title varchar(200) default NULL, - description text, - created int(14) default NULL, - questions int(5) default NULL, - hits int(8) default NULL, - canSuggest char(1) default NULL, - PRIMARY KEY (faqId), - KEY title (title), - KEY description (description(255)), - KEY hits (hits), - FULLTEXT KEY ft (title,description) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_featured_links; -CREATE TABLE tiki_featured_links ( - url varchar(200) NOT NULL default '', - title varchar(200) default NULL, - description text, - hits int(8) default NULL, - position int(6) default NULL, - type char(1) default NULL, - PRIMARY KEY (url) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_file_galleries; -CREATE TABLE tiki_file_galleries ( - galleryId int(14) NOT NULL auto_increment, - name varchar(80) NOT NULL default '', - type varchar(20) NOT NULL default 'default', - description text, - created int(14) default NULL, - visible char(1) default NULL, - lastModif int(14) default NULL, - user varchar(200) default '', - hits int(14) default NULL, - votes int(8) default NULL, - points decimal(8,2) default NULL, - maxRows int(10) default NULL, - public char(1) default NULL, - show_id char(1) default NULL, - show_icon char(1) default NULL, - show_name char(1) default NULL, - show_size char(1) default NULL, - show_description char(1) default NULL, - max_desc int(8) default NULL, - show_created char(1) default NULL, - show_hits char(1) default NULL, - parentId int(14) NOT NULL default -1, - lockable char(1) default 'n', - show_lockedby char(1) default NULL, - archives int(4) default -1, - sort_mode char(20) default NULL, - show_modified char(1) default NULL, - show_author char(1) default NULL, - show_creator char(1) default NULL, - subgal_conf varchar(200) default NULL, - show_last_user char(1) default NULL, - show_comment char(1) default NULL, - show_files char(1) default NULL, - show_explorer char(1) default NULL, - show_path char(1) default NULL, - show_slideshow char(1) default NULL, - default_view varchar(20) default NULL, - PRIMARY KEY (galleryId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_files; -CREATE TABLE tiki_files ( - fileId int(14) NOT NULL auto_increment, - galleryId int(14) NOT NULL default '0', - name varchar(200) NOT NULL default '', - description text, - created int(14) default NULL, - filename varchar(80) default NULL, - filesize int(14) default NULL, - filetype varchar(250) default NULL, - data longblob, - user varchar(200) default '', - author varchar(40) default NULL, - hits int(14) default NULL, - votes int(8) default NULL, - points decimal(8,2) default NULL, - path varchar(255) default NULL, - reference_url varchar(250) default NULL, - is_reference char(1) default NULL, - hash varchar(32) default NULL, - search_data longtext, - lastModif integer(14) DEFAULT NULL, - lastModifUser varchar(200) DEFAULT NULL, - lockedby varchar(200) default '', - comment varchar(200) default NULL, - archiveId int(14) default 0, - PRIMARY KEY (fileId), - KEY name (name), - KEY description (description(255)), - KEY created (created), - KEY archiveId (archiveId), - KEY galleryId (galleryId), - KEY hits (hits), - FULLTEXT KEY ft (name,description,search_data,filename) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_forum_attachments; -CREATE TABLE tiki_forum_attachments ( - attId int(14) NOT NULL auto_increment, - threadId int(14) NOT NULL default '0', - qId int(14) NOT NULL default '0', - forumId int(14) default NULL, - filename varchar(250) default NULL, - filetype varchar(250) default NULL, - filesize int(12) default NULL, - data longblob, - dir varchar(200) default NULL, - created int(14) default NULL, - path varchar(250) default NULL, - PRIMARY KEY (attId), - KEY threadId (threadId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_forum_reads; -CREATE TABLE tiki_forum_reads ( - user varchar(200) NOT NULL default '', - threadId int(14) NOT NULL default '0', - forumId int(14) default NULL, - timestamp int(14) default NULL, - PRIMARY KEY (user,threadId) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_forums; -CREATE TABLE tiki_forums ( - forumId int(8) NOT NULL auto_increment, - name varchar(255) default NULL, - description text, - created int(14) default NULL, - lastPost int(14) default NULL, - threads int(8) default NULL, - comments int(8) default NULL, - controlFlood char(1) default NULL, - floodInterval int(8) default NULL, - moderator varchar(200) default NULL, - hits int(8) default NULL, - mail varchar(200) default NULL, - useMail char(1) default NULL, - section varchar(200) default NULL, - usePruneUnreplied char(1) default NULL, - pruneUnrepliedAge int(8) default NULL, - usePruneOld char(1) default NULL, - pruneMaxAge int(8) default NULL, - topicsPerPage int(6) default NULL, - topicOrdering varchar(100) default NULL, - threadOrdering varchar(100) default NULL, - att varchar(80) default NULL, - att_store varchar(4) default NULL, - att_store_dir varchar(250) default NULL, - att_max_size int(12) default NULL, - ui_level char(1) default NULL, - forum_password varchar(32) default NULL, - forum_use_password char(1) default NULL, - moderator_group varchar(200) default NULL, - approval_type varchar(20) default NULL, - outbound_address varchar(250) default NULL, - outbound_mails_for_inbound_mails char(1) default NULL, - outbound_mails_reply_link char(1) default NULL, - outbound_from varchar(250) default NULL, - inbound_pop_server varchar(250) default NULL, - inbound_pop_port int(4) default NULL, - inbound_pop_user varchar(200) default NULL, - inbound_pop_password varchar(80) default NULL, - topic_smileys char(1) default NULL, - ui_avatar char(1) default NULL, - ui_flag char(1) default NULL, - ui_posts char(1) default NULL, - ui_email char(1) default NULL, - ui_online char(1) default NULL, - topic_summary char(1) default NULL, - show_description char(1) default NULL, - topics_list_replies char(1) default NULL, - topics_list_reads char(1) default NULL, - topics_list_pts char(1) default NULL, - topics_list_lastpost char(1) default NULL, - topics_list_author char(1) default NULL, - vote_threads char(1) default NULL, - forum_last_n int(2) default 0, - threadStyle varchar(100) default NULL, - commentsPerPage varchar(100) default NULL, - is_flat char(1) default NULL, - mandatory_contribution char(1) default NULL, - PRIMARY KEY (forumId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_forums_queue; -CREATE TABLE tiki_forums_queue ( - qId int(14) NOT NULL auto_increment, - object varchar(32) default NULL, - parentId int(14) default NULL, - forumId int(14) default NULL, - timestamp int(14) default NULL, - user varchar(200) default '', - title varchar(240) default NULL, - data text, - type varchar(60) default NULL, - hash varchar(32) default NULL, - topic_smiley varchar(80) default NULL, - topic_title varchar(240) default NULL, - summary varchar(240) default NULL, - in_reply_to varchar(128) default NULL, - tags varchar(255) default NULL, - email varchar(255) default NULL, - PRIMARY KEY (qId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_forums_reported; -CREATE TABLE tiki_forums_reported ( - threadId int(12) NOT NULL default '0', - forumId int(12) NOT NULL default '0', - parentId int(12) NOT NULL default '0', - user varchar(200) default '', - timestamp int(14) default NULL, - reason varchar(250) default NULL, - PRIMARY KEY (threadId) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_galleries; -CREATE TABLE tiki_galleries ( - galleryId int(14) NOT NULL auto_increment, - name varchar(80) NOT NULL default '', - description text, - created int(14) default NULL, - lastModif int(14) default NULL, - visible char(1) default NULL, - geographic char(1) default NULL, - theme varchar(60) default NULL, - user varchar(200) default '', - hits int(14) default NULL, - maxRows int(10) default NULL, - rowImages int(10) default NULL, - thumbSizeX int(10) default NULL, - thumbSizeY int(10) default NULL, - public char(1) default NULL, - sortorder varchar(20) NOT NULL default 'created', - sortdirection varchar(4) NOT NULL default 'desc', - galleryimage varchar(20) NOT NULL default 'first', - parentgallery int(14) NOT NULL default -1, - showname char(1) NOT NULL default 'y', - showimageid char(1) NOT NULL default 'n', - showdescription char(1) NOT NULL default 'n', - showcreated char(1) NOT NULL default 'n', - showuser char(1) NOT NULL default 'n', - showhits char(1) NOT NULL default 'y', - showxysize char(1) NOT NULL default 'y', - showfilesize char(1) NOT NULL default 'n', - showfilename char(1) NOT NULL default 'n', - defaultscale varchar(10) NOT NULL DEFAULT 'o', - showcategories char(1) NOT NULL default 'n', - PRIMARY KEY (galleryId), - KEY name (name), - KEY description (description(255)), - KEY hits (hits), - KEY parentgallery (parentgallery), - KEY visibleUser (visible, user), - FULLTEXT KEY ft (name,description) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_galleries_scales; -CREATE TABLE tiki_galleries_scales ( - galleryId int(14) NOT NULL default '0', - scale int(11) NOT NULL default '0', - PRIMARY KEY (galleryId,scale) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_games; -CREATE TABLE tiki_games ( - gameName varchar(200) NOT NULL default '', - hits int(8) default NULL, - votes int(8) default NULL, - points int(8) default NULL, - PRIMARY KEY (gameName) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_group_inclusion; -CREATE TABLE tiki_group_inclusion ( - groupName varchar(255) NOT NULL default '', - includeGroup varchar(255) NOT NULL default '', - PRIMARY KEY (groupName(30),includeGroup(30)) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_group_watches; -CREATE TABLE tiki_group_watches ( - watchId int(12) NOT NULL auto_increment, - `group` varchar(200) NOT NULL default '', - event varchar(40) NOT NULL default '', - object varchar(200) NOT NULL default '', - title varchar(250) default NULL, - type varchar(200) default NULL, - url varchar(250) default NULL, - KEY watchId (watchId), - PRIMARY KEY (`group`(50),event,object(100)) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_history; -CREATE TABLE tiki_history ( - historyId int(12) NOT NULL auto_increment, - pageName varchar(160) NOT NULL default '', - version int(8) NOT NULL default '0', - version_minor int(8) NOT NULL default '0', - lastModif int(14) default NULL, - description varchar(200) default NULL, - user varchar(200) not null default '', - ip varchar(15) default NULL, - comment varchar(200) default NULL, - data longblob, - type varchar(50) default NULL, - is_html TINYINT(1) NOT NULL DEFAULT 0, - PRIMARY KEY (pageName,version), - KEY `user` (`user`), - KEY(historyId) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_hotwords; -CREATE TABLE tiki_hotwords ( - word varchar(40) NOT NULL default '', - url varchar(255) NOT NULL default '', - PRIMARY KEY (word) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_html_pages; -CREATE TABLE tiki_html_pages ( - pageName varchar(200) NOT NULL default '', - content longblob, - refresh int(10) default NULL, - type char(1) default NULL, - created int(14) default NULL, - PRIMARY KEY (pageName) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_html_pages_dynamic_zones; -CREATE TABLE tiki_html_pages_dynamic_zones ( - pageName varchar(40) NOT NULL default '', - zone varchar(80) NOT NULL default '', - type char(2) default NULL, - content text, - PRIMARY KEY (pageName,zone) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_images; -CREATE TABLE tiki_images ( - imageId int(14) NOT NULL auto_increment, - galleryId int(14) NOT NULL default '0', - name varchar(200) NOT NULL default '', - description text, - lon float default NULL, - lat float default NULL, - created int(14) default NULL, - user varchar(200) default '', - hits int(14) default NULL, - path varchar(255) default NULL, - PRIMARY KEY (imageId), - KEY name (name), - KEY description (description(255)), - KEY hits (hits), - KEY ti_gId (galleryId), - KEY ti_cr (created), - KEY ti_us (user), - FULLTEXT KEY ft (name,description) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_images_data; -CREATE TABLE tiki_images_data ( - imageId int(14) NOT NULL default '0', - xsize int(8) NOT NULL default '0', - ysize int(8) NOT NULL default '0', - type char(1) NOT NULL default '', - filesize int(14) default NULL, - filetype varchar(80) default NULL, - filename varchar(80) default NULL, - data longblob, - etag varchar(32) default NULL, - PRIMARY KEY (imageId,xsize,ysize,type), - KEY t_i_d_it (imageId,type) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_language; -CREATE TABLE tiki_language ( - source tinyblob NOT NULL, - lang char(16) NOT NULL default '', - tran tinyblob, - PRIMARY KEY (source(255),lang) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_languages; -CREATE TABLE tiki_languages ( - lang char(16) NOT NULL default '', - language varchar(255) default NULL, - PRIMARY KEY (lang) -) ENGINE=MyISAM; - -INSERT INTO tiki_languages(lang, language) VALUES('en','English'); - -DROP TABLE IF EXISTS tiki_link_cache; -CREATE TABLE tiki_link_cache ( - cacheId int(14) NOT NULL auto_increment, - url varchar(250) default NULL, - data longblob, - refresh int(14) default NULL, - PRIMARY KEY (cacheId), - KEY url (url) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; -CREATE INDEX urlindex ON tiki_link_cache (url(250)); - -DROP TABLE IF EXISTS tiki_links; -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; - -DROP TABLE IF EXISTS tiki_live_support_events; -CREATE TABLE tiki_live_support_events ( - eventId int(14) NOT NULL auto_increment, - reqId varchar(32) NOT NULL default '', - type varchar(40) default NULL, - seqId int(14) default NULL, - senderId varchar(32) default NULL, - data text, - timestamp int(14) default NULL, - PRIMARY KEY (eventId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_live_support_message_comments; -CREATE TABLE tiki_live_support_message_comments ( - cId int(12) NOT NULL auto_increment, - msgId int(12) default NULL, - data text, - timestamp int(14) default NULL, - PRIMARY KEY (cId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_live_support_messages; -CREATE TABLE tiki_live_support_messages ( - msgId int(12) NOT NULL auto_increment, - data text, - timestamp int(14) default NULL, - user varchar(200) not null default '', - username varchar(200) default NULL, - priority int(2) default NULL, - status char(1) default NULL, - assigned_to varchar(200) default NULL, - resolution varchar(100) default NULL, - title varchar(200) default NULL, - module int(4) default NULL, - email varchar(250) default NULL, - PRIMARY KEY (msgId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_live_support_modules; -CREATE TABLE tiki_live_support_modules ( - modId int(4) NOT NULL auto_increment, - name varchar(90) default NULL, - PRIMARY KEY (modId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -INSERT INTO tiki_live_support_modules(name) VALUES('wiki'); -INSERT INTO tiki_live_support_modules(name) VALUES('forums'); -INSERT INTO tiki_live_support_modules(name) VALUES('image galleries'); -INSERT INTO tiki_live_support_modules(name) VALUES('file galleries'); -INSERT INTO tiki_live_support_modules(name) VALUES('directory'); -INSERT INTO tiki_live_support_modules(name) VALUES('workflow'); -INSERT INTO tiki_live_support_modules(name) VALUES('charts'); - -DROP TABLE IF EXISTS tiki_live_support_operators; -CREATE TABLE tiki_live_support_operators ( - user varchar(200) NOT NULL default '', - accepted_requests int(10) default NULL, - status varchar(20) default NULL, - longest_chat int(10) default NULL, - shortest_chat int(10) default NULL, - average_chat int(10) default NULL, - last_chat int(14) default NULL, - time_online int(10) default NULL, - votes int(10) default NULL, - points int(10) default NULL, - status_since int(14) default NULL, - PRIMARY KEY (user) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_live_support_requests; -CREATE TABLE tiki_live_support_requests ( - reqId varchar(32) NOT NULL default '', - user varchar(200) NOT NULL default '', - tiki_user varchar(200) default NULL, - email varchar(200) default NULL, - operator varchar(200) default NULL, - operator_id varchar(32) default NULL, - user_id varchar(32) default NULL, - reason text, - req_timestamp int(14) default NULL, - timestamp int(14) default NULL, - status varchar(40) default NULL, - resolution varchar(40) default NULL, - chat_started int(14) default NULL, - chat_ended int(14) default NULL, - PRIMARY KEY (reqId) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_logs; -CREATE TABLE tiki_logs ( - logId int(8) NOT NULL auto_increment, - logtype varchar(20) NOT NULL, - logmessage text NOT NULL, - loguser varchar(40) NOT NULL, - logip varchar(200), - logclient text NOT NULL, - logtime int(14) NOT NULL, - PRIMARY KEY (logId), - KEY logtype (logtype) -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_mail_events; -CREATE TABLE tiki_mail_events ( - event varchar(200) default NULL, - object varchar(200) default NULL, - email varchar(200) default NULL -) ENGINE=MyISAM; - -DROP TABLE IF EXISTS tiki_mailin_accounts; -CREATE TABLE tiki_mailin_accounts ( - accountId int(12) NOT NULL auto_increment, - user varchar(200) NOT NULL default '', - account varchar(50) NOT NULL default '', - pop varchar(255) default NULL, - port int(4) default NULL, - username varchar(100) default NULL, - pass varchar(100) default NULL, - active char(1) default NULL, - type varchar(40) default NULL, - smtp varchar(255) default NULL, - useAuth char(1) default NULL, - smtpPort int(4) default NULL, - anonymous char(1) NOT NULL default 'y', - attachments char(1) NOT NULL default 'n', - article_topicId int(4) default NULL, - article_type varchar(50) default NULL, - discard_after varchar(255) default NULL, - PRIMARY KEY (accountId) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_menu_languages; -CREATE TABLE tiki_menu_languages ( - menuId int(8) NOT NULL auto_increment, - language char(16) NOT NULL default '', - PRIMARY KEY (menuId,language) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -DROP TABLE IF EXISTS tiki_menu_options; -CREATE TABLE tiki_menu_options ( - optionId int(8) NOT NULL auto_increment, - menuId int(8) default NULL, - type char(1) default NULL, - name varchar(200) default NULL, - url varchar(255) default NULL, - position int(4) default NULL, - section text default NULL, - perm text default NULL, - groupname text default NULL, - userlevel int(4) default 0, - PRIMARY KEY (optionId), - UNIQUE KEY uniq_menu (menuId,name(30),url(50),position,section(60),perm(50),groupname(50)) -) ENGINE=MyISAM AUTO_INCREMENT=1 ; - -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (1,42,'o','Home','./',10,'','','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (3,42,'o','Contact Us','tiki-contact.php',20,'feature_contact,feature_messages','','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (4,42,'o','Stats','tiki-stats.php',23,'feature_stats','tiki_p_view_stats','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (5,42,'o','Categories','tiki-browse_categories.php',25,'feature_categories','tiki_p_view_categories','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (6,42,'o','Games','tiki-list_games.php',30,'feature_games','tiki_p_play_games','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (7,42,'o','Calendar','tiki-calendar.php',35,'feature_calendar','tiki_p_view_calendar','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (8,42,'o','Users Map','tiki-gmap_usermap.php',36,'feature_gmap','','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (9,42,'o','Mobile','tiki-mobile.php',37,'feature_mobile','','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (10,42,'o','(debug)','javascript:toggle(\'debugconsole\')',40,'feature_debug_console','tiki_p_admin','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (11,42,'s','MyTiki','tiki-my_tiki.php',50,'feature_mytiki','','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (12,42,'o','MyTiki Home','tiki-my_tiki.php',51,'feature_mytiki','','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (13,42,'o','Preferences','tiki-user_preferences.php',55,'feature_mytiki,feature_userPreferences','','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (14,42,'o','Messages','messu-mailbox.php',60,'feature_mytiki,feature_messages','tiki_p_messages','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (15,42,'o','Tasks','tiki-user_tasks.php',65,'feature_mytiki,feature_tasks','tiki_p_tasks','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (16,42,'o','Bookmarks','tiki-user_bookmarks.php',70,'feature_mytiki,feature_user_bookmarks','tiki_p_create_bookmarks','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (17,42,'o','Modules','tiki-user_assigned_modules.php',75,'feature_mytiki,user_assigned_modules','tiki_p_configure_modules','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (18,42,'o','Newsreader','tiki-newsreader_servers.php',80,'feature_mytiki,feature_newsreader','tiki_p_newsreader','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (19,42,'o','Webmail','tiki-webmail.php',85,'feature_mytiki,feature_webmail','tiki_p_use_webmail','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (20,42,'o','Notepad','tiki-notepad_list.php',90,'feature_mytiki,feature_notepad','tiki_p_notepad','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (21,42,'o','My Files','tiki-userfiles.php',95,'feature_mytiki,feature_userfiles','tiki_p_userfiles','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (22,42,'o','User Menu','tiki-usermenu.php',100,'feature_mytiki,feature_usermenu','tiki_p_usermenu','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (23,42,'o','Mini Calendar','tiki-minical.php',105,'feature_mytiki,feature_minical','tiki_p_minical','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (24,42,'o','My Watches','tiki-user_watches.php',110,'feature_mytiki,feature_user_watches','','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (25,42,'s','Workflow','tiki-g-user_processes.php',150,'feature_workflow','tiki_p_use_workflow','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (26,42,'o','Admin Processes','tiki-g-admin_processes.php',155,'feature_workflow','tiki_p_admin_workflow','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (27,42,'o','Monitor Processes','tiki-g-monitor_processes.php',160,'feature_workflow','tiki_p_admin_workflow','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (28,42,'o','Monitor Activities','tiki-g-monitor_activities.php',165,'feature_workflow','tiki_p_admin_workflow','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (29,42,'o','Monitor Instances','tiki-g-monitor_instances.php',170,'feature_workflow','tiki_p_admin_workflow','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (30,42,'o','User Processes','tiki-g-user_processes.php',175,'feature_workflow','tiki_p_use_workflow','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (31,42,'o','User activities','tiki-g-user_activities.php',180,'feature_workflow','tiki_p_use_workflow','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (32,42,'o','User instances','tiki-g-user_instances.php',185,'feature_workflow','tiki_p_use_workflow','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (33,42,'s','Community','tiki-list_users.php',187,'feature_friends','tiki_p_list_users','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (34,42,'o','User List','tiki-list_users.php',188,'feature_friends','tiki_p_list_users','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (35,42,'o','Friendship Network','tiki-friends.php',189,'feature_friends','','Registered',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (36,42,'s','Wiki','tiki-index.php',200,'feature_wiki','tiki_p_view','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (37,42,'o','Wiki Home','tiki-index.php',202,'feature_wiki','tiki_p_view','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (38,42,'o','Last Changes','tiki-lastchanges.php',205,'feature_wiki,feature_lastChanges','tiki_p_view','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (39,42,'o','Dump','dump/new.tar',210,'feature_wiki,feature_dump','tiki_p_view','',0); -INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `use... [truncated message content] |