Menu
▾
▴
[Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[35346] branches/3.0
|
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] |