-- MySQL dump 10.9
--
-- Host: localhost    Database: mythusm_tiwi1
-- ------------------------------------------------------
-- Server version	4.1.22-standard

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `galaxia_activities`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `galaxia_activities`
--

LOCK TABLES `galaxia_activities` WRITE;
/*!40000 ALTER TABLE `galaxia_activities` DISABLE KEYS */;
/*!40000 ALTER TABLE `galaxia_activities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `galaxia_activity_roles`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `galaxia_activity_roles`
--

LOCK TABLES `galaxia_activity_roles` WRITE;
/*!40000 ALTER TABLE `galaxia_activity_roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `galaxia_activity_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `galaxia_instance_activities`
--

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(40) default NULL,
  `status` enum('running','completed') default NULL,
  PRIMARY KEY  (`instanceId`,`activityId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `galaxia_instance_activities`
--

LOCK TABLES `galaxia_instance_activities` WRITE;
/*!40000 ALTER TABLE `galaxia_instance_activities` DISABLE KEYS */;
/*!40000 ALTER TABLE `galaxia_instance_activities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `galaxia_instance_comments`
--

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(40) default NULL,
  `activityId` int(14) default NULL,
  `hash` varchar(32) default NULL,
  `title` varchar(250) default NULL,
  `comment` text,
  `activity` varchar(80) default NULL,
  `timestamp` int(14) default NULL,
  PRIMARY KEY  (`cId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `galaxia_instance_comments`
--

LOCK TABLES `galaxia_instance_comments` WRITE;
/*!40000 ALTER TABLE `galaxia_instance_comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `galaxia_instance_comments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `galaxia_instances`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `galaxia_instances`
--

LOCK TABLES `galaxia_instances` WRITE;
/*!40000 ALTER TABLE `galaxia_instances` DISABLE KEYS */;
/*!40000 ALTER TABLE `galaxia_instances` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `galaxia_processes`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `galaxia_processes`
--

LOCK TABLES `galaxia_processes` WRITE;
/*!40000 ALTER TABLE `galaxia_processes` DISABLE KEYS */;
/*!40000 ALTER TABLE `galaxia_processes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `galaxia_roles`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `galaxia_roles`
--

LOCK TABLES `galaxia_roles` WRITE;
/*!40000 ALTER TABLE `galaxia_roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `galaxia_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `galaxia_transitions`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `galaxia_transitions`
--

LOCK TABLES `galaxia_transitions` WRITE;
/*!40000 ALTER TABLE `galaxia_transitions` DISABLE KEYS */;
/*!40000 ALTER TABLE `galaxia_transitions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `galaxia_user_roles`
--

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(40) NOT NULL default '',
  PRIMARY KEY  (`roleId`,`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `galaxia_user_roles`
--

LOCK TABLES `galaxia_user_roles` WRITE;
/*!40000 ALTER TABLE `galaxia_user_roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `galaxia_user_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `galaxia_workitems`
--

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(40) default NULL,
  PRIMARY KEY  (`itemId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `galaxia_workitems`
--

LOCK TABLES `galaxia_workitems` WRITE;
/*!40000 ALTER TABLE `galaxia_workitems` DISABLE KEYS */;
/*!40000 ALTER TABLE `galaxia_workitems` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `messu_archive`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `messu_archive`
--

LOCK TABLES `messu_archive` WRITE;
/*!40000 ALTER TABLE `messu_archive` DISABLE KEYS */;
/*!40000 ALTER TABLE `messu_archive` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `messu_messages`
--

DROP TABLE IF EXISTS `messu_messages`;
CREATE TABLE `messu_messages` (
  `msgId` int(14) NOT NULL auto_increment,
  `user` varchar(40) 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `messu_messages`
--

LOCK TABLES `messu_messages` WRITE;
/*!40000 ALTER TABLE `messu_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `messu_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `messu_sent`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `messu_sent`
--

LOCK TABLES `messu_sent` WRITE;
/*!40000 ALTER TABLE `messu_sent` DISABLE KEYS */;
/*!40000 ALTER TABLE `messu_sent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `sesskey` varchar(32) NOT NULL default '',
  `expiry` int(11) unsigned NOT NULL default '0',
  `expireref` varchar(64) default NULL,
  `data` text NOT NULL,
  PRIMARY KEY  (`sesskey`),
  KEY `expiry` (`expiry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_actionlog`
--

DROP TABLE IF EXISTS `tiki_actionlog`;
CREATE TABLE `tiki_actionlog` (
  `action` varchar(255) NOT NULL default '',
  `lastModif` int(14) default NULL,
  `pageName` varchar(200) default NULL,
  `user` varchar(40) default NULL,
  `ip` varchar(15) default NULL,
  `comment` varchar(200) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_actionlog`
--

LOCK TABLES `tiki_actionlog` WRITE;
/*!40000 ALTER TABLE `tiki_actionlog` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_actionlog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_article_types`
--

DROP TABLE IF EXISTS `tiki_article_types`;
CREATE TABLE `tiki_article_types` (
  `type` varchar(50) NOT NULL default '',
  `use_ratings` char(1) default NULL,
  `show_pre_publ` char(1) default NULL,
  `show_post_expire` char(1) default 'y',
  `heading_only` char(1) default NULL,
  `allow_comments` char(1) default 'y',
  `show_image` char(1) default 'y',
  `show_avatar` char(1) default NULL,
  `show_author` char(1) default 'y',
  `show_pubdate` char(1) default 'y',
  `show_expdate` char(1) default NULL,
  `show_reads` char(1) default 'y',
  `show_size` char(1) default 'y',
  `show_topline` char(1) default 'n',
  `show_subtitle` char(1) default 'n',
  `show_linkto` char(1) default 'n',
  `show_image_caption` char(1) default 'n',
  `show_lang` char(1) default 'n',
  `creator_edit` char(1) default NULL,
  `comment_can_rate_article` char(1) default NULL,
  PRIMARY KEY  (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_article_types`
--

LOCK TABLES `tiki_article_types` WRITE;
/*!40000 ALTER TABLE `tiki_article_types` DISABLE KEYS */;
INSERT INTO `tiki_article_types` VALUES ('Article',NULL,NULL,'y',NULL,'y','y',NULL,'y','y',NULL,'y','y','n','n','n','n','n',NULL,NULL),('Review','y',NULL,'y',NULL,'y','y',NULL,'y','y',NULL,'y','y','n','n','n','n','n',NULL,NULL),('Event',NULL,NULL,'n',NULL,'y','y',NULL,'y','y',NULL,'y','y','n','n','n','n','n',NULL,NULL),('Classified',NULL,NULL,'n','y','n','y',NULL,'y','y',NULL,'y','y','n','n','n','n','n',NULL,NULL);
/*!40000 ALTER TABLE `tiki_article_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_articles`
--

DROP TABLE IF EXISTS `tiki_articles`;
CREATE TABLE `tiki_articles` (
  `articleId` int(8) NOT NULL auto_increment,
  `topline` varchar(255) default NULL,
  `title` varchar(80) 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,
  `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 `author` (`author`(32)),
  KEY `nbreads` (`nbreads`),
  FULLTEXT KEY `ft` (`title`,`heading`,`body`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_articles`
--

LOCK TABLES `tiki_articles` WRITE;
/*!40000 ALTER TABLE `tiki_articles` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_articles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_banners`
--

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,
  `clicks` int(8) default NULL,
  `zone` varchar(40) default NULL,
  PRIMARY KEY  (`bannerId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_banners`
--

LOCK TABLES `tiki_banners` WRITE;
/*!40000 ALTER TABLE `tiki_banners` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_banners` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_banning`
--

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(40) default NULL,
  `date_from` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `date_to` timestamp NOT NULL default '0000-00-00 00:00:00',
  `use_dates` char(1) default NULL,
  `created` int(14) default NULL,
  `message` text,
  PRIMARY KEY  (`banId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_banning`
--

LOCK TABLES `tiki_banning` WRITE;
/*!40000 ALTER TABLE `tiki_banning` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_banning` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_banning_sections`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_banning_sections`
--

LOCK TABLES `tiki_banning_sections` WRITE;
/*!40000 ALTER TABLE `tiki_banning_sections` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_banning_sections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_blog_activity`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_blog_activity`
--

LOCK TABLES `tiki_blog_activity` WRITE;
/*!40000 ALTER TABLE `tiki_blog_activity` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_blog_activity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_blog_posts`
--

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(40) default NULL,
  `trackbacks_to` text,
  `trackbacks_from` text,
  `title` varchar(80) default NULL,
  `priv` char(1) default NULL,
  PRIMARY KEY  (`postId`),
  KEY `data` (`data`(255)),
  KEY `blogId` (`blogId`),
  KEY `created` (`created`),
  FULLTEXT KEY `ft` (`data`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_blog_posts`
--

LOCK TABLES `tiki_blog_posts` WRITE;
/*!40000 ALTER TABLE `tiki_blog_posts` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_blog_posts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_blog_posts_images`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_blog_posts_images`
--

LOCK TABLES `tiki_blog_posts_images` WRITE;
/*!40000 ALTER TABLE `tiki_blog_posts_images` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_blog_posts_images` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_blogs`
--

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(40) default NULL,
  `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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_blogs`
--

LOCK TABLES `tiki_blogs` WRITE;
/*!40000 ALTER TABLE `tiki_blogs` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_blogs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_calendar_categories`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_calendar_categories`
--

LOCK TABLES `tiki_calendar_categories` WRITE;
/*!40000 ALTER TABLE `tiki_calendar_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_calendar_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_calendar_items`
--

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('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` varchar(16) NOT NULL default 'en',
  `name` varchar(255) NOT NULL default '',
  `description` blob,
  `user` varchar(40) default NULL,
  `created` int(14) NOT NULL default '0',
  `lastmodif` int(14) NOT NULL default '0',
  PRIMARY KEY  (`calitemId`),
  KEY `calendarId` (`calendarId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_calendar_items`
--

LOCK TABLES `tiki_calendar_items` WRITE;
/*!40000 ALTER TABLE `tiki_calendar_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_calendar_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_calendar_locations`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_calendar_locations`
--

LOCK TABLES `tiki_calendar_locations` WRITE;
/*!40000 ALTER TABLE `tiki_calendar_locations` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_calendar_locations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_calendar_roles`
--

DROP TABLE IF EXISTS `tiki_calendar_roles`;
CREATE TABLE `tiki_calendar_roles` (
  `calitemId` int(14) NOT NULL default '0',
  `username` varchar(40) NOT NULL default '',
  `role` enum('0','1','2','3','6') NOT NULL default '0',
  PRIMARY KEY  (`calitemId`,`username`(16),`role`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_calendar_roles`
--

LOCK TABLES `tiki_calendar_roles` WRITE;
/*!40000 ALTER TABLE `tiki_calendar_roles` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_calendar_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_calendars`
--

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(40) 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',
  `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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_calendars`
--

LOCK TABLES `tiki_calendars` WRITE;
/*!40000 ALTER TABLE `tiki_calendars` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_calendars` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_categories`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_categories`
--

LOCK TABLES `tiki_categories` WRITE;
/*!40000 ALTER TABLE `tiki_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_categorized_objects`
--

DROP TABLE IF EXISTS `tiki_categorized_objects`;
CREATE TABLE `tiki_categorized_objects` (
  `catObjectId` int(12) NOT NULL auto_increment,
  `type` varchar(50) default NULL,
  `objId` 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,
  PRIMARY KEY  (`catObjectId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_categorized_objects`
--

LOCK TABLES `tiki_categorized_objects` WRITE;
/*!40000 ALTER TABLE `tiki_categorized_objects` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_categorized_objects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_category_objects`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_category_objects`
--

LOCK TABLES `tiki_category_objects` WRITE;
/*!40000 ALTER TABLE `tiki_category_objects` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_category_objects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_category_sites`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_category_sites`
--

LOCK TABLES `tiki_category_sites` WRITE;
/*!40000 ALTER TABLE `tiki_category_sites` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_category_sites` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_chart_items`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_chart_items`
--

LOCK TABLES `tiki_chart_items` WRITE;
/*!40000 ALTER TABLE `tiki_chart_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_chart_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_charts`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_charts`
--

LOCK TABLES `tiki_charts` WRITE;
/*!40000 ALTER TABLE `tiki_charts` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_charts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_charts_rankings`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_charts_rankings`
--

LOCK TABLES `tiki_charts_rankings` WRITE;
/*!40000 ALTER TABLE `tiki_charts_rankings` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_charts_rankings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_charts_votes`
--

DROP TABLE IF EXISTS `tiki_charts_votes`;
CREATE TABLE `tiki_charts_votes` (
  `user` varchar(40) 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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_charts_votes`
--

LOCK TABLES `tiki_charts_votes` WRITE;
/*!40000 ALTER TABLE `tiki_charts_votes` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_charts_votes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_chat_channels`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_chat_channels`
--

LOCK TABLES `tiki_chat_channels` WRITE;
/*!40000 ALTER TABLE `tiki_chat_channels` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_chat_channels` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_chat_messages`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_chat_messages`
--

LOCK TABLES `tiki_chat_messages` WRITE;
/*!40000 ALTER TABLE `tiki_chat_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_chat_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_chat_users`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_chat_users`
--

LOCK TABLES `tiki_chat_users` WRITE;
/*!40000 ALTER TABLE `tiki_chat_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_chat_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_comments`
--

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(40) default NULL,
  `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(100) 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(250) default NULL,
  `in_reply_to` varchar(250) default NULL,
  `comment_rating` tinyint(2) default NULL,
  PRIMARY KEY  (`threadId`),
  KEY `title` (`title`),
  KEY `data` (`data`(255)),
  KEY `object` (`object`),
  KEY `hits` (`hits`),
  KEY `tc_pi` (`parentId`),
  FULLTEXT KEY `ft` (`title`,`data`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_comments`
--

LOCK TABLES `tiki_comments` WRITE;
/*!40000 ALTER TABLE `tiki_comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_comments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_content`
--

DROP TABLE IF EXISTS `tiki_content`;
CREATE TABLE `tiki_content` (
  `contentId` int(8) NOT NULL auto_increment,
  `description` text,
  PRIMARY KEY  (`contentId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_content`
--

LOCK TABLES `tiki_content` WRITE;
/*!40000 ALTER TABLE `tiki_content` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_content` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_content_templates`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_content_templates`
--

LOCK TABLES `tiki_content_templates` WRITE;
/*!40000 ALTER TABLE `tiki_content_templates` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_content_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_content_templates_sections`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_content_templates_sections`
--

LOCK TABLES `tiki_content_templates_sections` WRITE;
/*!40000 ALTER TABLE `tiki_content_templates_sections` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_content_templates_sections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_cookies`
--

DROP TABLE IF EXISTS `tiki_cookies`;
CREATE TABLE `tiki_cookies` (
  `cookieId` int(10) NOT NULL auto_increment,
  `cookie` text,
  PRIMARY KEY  (`cookieId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_cookies`
--

LOCK TABLES `tiki_cookies` WRITE;
/*!40000 ALTER TABLE `tiki_cookies` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_cookies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_copyrights`
--

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(40) default NULL,
  PRIMARY KEY  (`copyrightId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_copyrights`
--

LOCK TABLES `tiki_copyrights` WRITE;
/*!40000 ALTER TABLE `tiki_copyrights` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_copyrights` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_directory_categories`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_directory_categories`
--

LOCK TABLES `tiki_directory_categories` WRITE;
/*!40000 ALTER TABLE `tiki_directory_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_directory_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_directory_search`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_directory_search`
--

LOCK TABLES `tiki_directory_search` WRITE;
/*!40000 ALTER TABLE `tiki_directory_search` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_directory_search` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_directory_sites`
--

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`),
  FULLTEXT KEY `ft` (`name`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_directory_sites`
--

LOCK TABLES `tiki_directory_sites` WRITE;
/*!40000 ALTER TABLE `tiki_directory_sites` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_directory_sites` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_download`
--

DROP TABLE IF EXISTS `tiki_download`;
CREATE TABLE `tiki_download` (
  `id` int(11) NOT NULL auto_increment,
  `object` varchar(255) NOT NULL default '',
  `userId` int(8) NOT NULL default '0',
  `type` varchar(20) NOT NULL default '',
  `date` int(14) NOT NULL default '0',
  `IP` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `object` (`object`,`userId`,`type`),
  KEY `userId` (`userId`),
  KEY `type` (`type`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_download`
--

LOCK TABLES `tiki_download` WRITE;
/*!40000 ALTER TABLE `tiki_download` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_download` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_drawings`
--

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(40) default NULL,
  PRIMARY KEY  (`drawId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_drawings`
--

LOCK TABLES `tiki_drawings` WRITE;
/*!40000 ALTER TABLE `tiki_drawings` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_drawings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_dsn`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_dsn`
--

LOCK TABLES `tiki_dsn` WRITE;
/*!40000 ALTER TABLE `tiki_dsn` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_dsn` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_dynamic_variables`
--

DROP TABLE IF EXISTS `tiki_dynamic_variables`;
CREATE TABLE `tiki_dynamic_variables` (
  `name` varchar(40) NOT NULL default '',
  `data` text,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_dynamic_variables`
--

LOCK TABLES `tiki_dynamic_variables` WRITE;
/*!40000 ALTER TABLE `tiki_dynamic_variables` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_dynamic_variables` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_eph`
--

DROP TABLE IF EXISTS `tiki_eph`;
CREATE TABLE `tiki_eph` (
  `ephId` int(12) NOT NULL auto_increment,
  `title` varchar(250) default NULL,
  `isFile` char(1) default NULL,
  `filename` varchar(250) default NULL,
  `filetype` varchar(250) default NULL,
  `filesize` varchar(250) default NULL,
  `data` longblob,
  `textdata` longblob,
  `publish` int(14) default NULL,
  `hits` int(10) default NULL,
  PRIMARY KEY  (`ephId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_eph`
--

LOCK TABLES `tiki_eph` WRITE;
/*!40000 ALTER TABLE `tiki_eph` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_eph` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_extwiki`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_extwiki`
--

LOCK TABLES `tiki_extwiki` WRITE;
/*!40000 ALTER TABLE `tiki_extwiki` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_extwiki` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_faq_questions`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_faq_questions`
--

LOCK TABLES `tiki_faq_questions` WRITE;
/*!40000 ALTER TABLE `tiki_faq_questions` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_faq_questions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_faqs`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_faqs`
--

LOCK TABLES `tiki_faqs` WRITE;
/*!40000 ALTER TABLE `tiki_faqs` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_faqs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_featured_links`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_featured_links`
--

LOCK TABLES `tiki_featured_links` WRITE;
/*!40000 ALTER TABLE `tiki_featured_links` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_featured_links` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_file_galleries`
--

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 '',
  `description` text,
  `created` int(14) default NULL,
  `visible` char(1) default NULL,
  `lastModif` int(14) default NULL,
  `user` varchar(40) default NULL,
  `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_dl` char(1) default NULL,
  PRIMARY KEY  (`galleryId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_file_galleries`
--

LOCK TABLES `tiki_file_galleries` WRITE;
/*!40000 ALTER TABLE `tiki_file_galleries` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_file_galleries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_file_handlers`
--

DROP TABLE IF EXISTS `tiki_file_handlers`;
CREATE TABLE `tiki_file_handlers` (
  `mime_type` varchar(64) default NULL,
  `cmd` varchar(238) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_file_handlers`
--

LOCK TABLES `tiki_file_handlers` WRITE;
/*!40000 ALTER TABLE `tiki_file_handlers` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_file_handlers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_files`
--

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(40) default NULL,
  `downloads` 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` int(14) default NULL,
  `lastModifUser` varchar(200) default NULL,
  PRIMARY KEY  (`fileId`),
  KEY `name` (`name`),
  KEY `description` (`description`(255)),
  KEY `downloads` (`downloads`),
  FULLTEXT KEY `ft` (`name`,`description`,`search_data`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_files`
--

LOCK TABLES `tiki_files` WRITE;
/*!40000 ALTER TABLE `tiki_files` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_forum_attachments`
--

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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_forum_attachments`
--

LOCK TABLES `tiki_forum_attachments` WRITE;
/*!40000 ALTER TABLE `tiki_forum_attachments` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_forum_attachments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_forum_reads`
--

DROP TABLE IF EXISTS `tiki_forum_reads`;
CREATE TABLE `tiki_forum_reads` (
  `user` varchar(40) 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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_forum_reads`
--

LOCK TABLES `tiki_forum_reads` WRITE;
/*!40000 ALTER TABLE `tiki_forum_reads` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_forum_reads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_forums`
--

DROP TABLE IF EXISTS `tiki_forums`;
CREATE TABLE `tiki_forums` (
  `forumId` int(8) NOT NULL auto_increment,
  `name` varchar(200) 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',
  PRIMARY KEY  (`forumId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_forums`
--

LOCK TABLES `tiki_forums` WRITE;
/*!40000 ALTER TABLE `tiki_forums` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_forums` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_forums_queue`
--

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(40) default NULL,
  `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,
  PRIMARY KEY  (`qId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_forums_queue`
--

LOCK TABLES `tiki_forums_queue` WRITE;
/*!40000 ALTER TABLE `tiki_forums_queue` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_forums_queue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_forums_reported`
--

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(40) default NULL,
  `timestamp` int(14) default NULL,
  `reason` varchar(250) default NULL,
  PRIMARY KEY  (`threadId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_forums_reported`
--

LOCK TABLES `tiki_forums_reported` WRITE;
/*!40000 ALTER TABLE `tiki_forums_reported` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_forums_reported` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_friends`
--

DROP TABLE IF EXISTS `tiki_friends`;
CREATE TABLE `tiki_friends` (
  `user` char(40) NOT NULL default '',
  `friend` char(40) NOT NULL default '',
  PRIMARY KEY  (`user`,`friend`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_friends`
--

LOCK TABLES `tiki_friends` WRITE;
/*!40000 ALTER TABLE `tiki_friends` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_friends` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_friendship_requests`
--

DROP TABLE IF EXISTS `tiki_friendship_requests`;
CREATE TABLE `tiki_friendship_requests` (
  `userFrom` char(40) NOT NULL default '',
  `userTo` char(40) NOT NULL default '',
  `tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`userFrom`,`userTo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_friendship_requests`
--

LOCK TABLES `tiki_friendship_requests` WRITE;
/*!40000 ALTER TABLE `tiki_friendship_requests` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_friendship_requests` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_galleries`
--

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(40) default NULL,
  `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',
  PRIMARY KEY  (`galleryId`),
  KEY `name` (`name`),
  KEY `description` (`description`(255)),
  KEY `hits` (`hits`),
  FULLTEXT KEY `ft` (`name`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_galleries`
--

LOCK TABLES `tiki_galleries` WRITE;
/*!40000 ALTER TABLE `tiki_galleries` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_galleries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_galleries_scales`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_galleries_scales`
--

LOCK TABLES `tiki_galleries_scales` WRITE;
/*!40000 ALTER TABLE `tiki_galleries_scales` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_galleries_scales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_games`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_games`
--

LOCK TABLES `tiki_games` WRITE;
/*!40000 ALTER TABLE `tiki_games` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_games` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_group_inclusion`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_group_inclusion`
--

LOCK TABLES `tiki_group_inclusion` WRITE;
/*!40000 ALTER TABLE `tiki_group_inclusion` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_group_inclusion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_history`
--

DROP TABLE IF EXISTS `tiki_history`;
CREATE TABLE `tiki_history` (
  `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(40) default NULL,
  `ip` varchar(15) default NULL,
  `comment` varchar(200) default NULL,
  `data` longblob,
  PRIMARY KEY  (`pageName`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_history`
--

LOCK TABLES `tiki_history` WRITE;
/*!40000 ALTER TABLE `tiki_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_hotwords`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_hotwords`
--

LOCK TABLES `tiki_hotwords` WRITE;
/*!40000 ALTER TABLE `tiki_hotwords` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_hotwords` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_html_pages`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_html_pages`
--

LOCK TABLES `tiki_html_pages` WRITE;
/*!40000 ALTER TABLE `tiki_html_pages` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_html_pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_html_pages_dynamic_zones`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_html_pages_dynamic_zones`
--

LOCK TABLES `tiki_html_pages_dynamic_zones` WRITE;
/*!40000 ALTER TABLE `tiki_html_pages_dynamic_zones` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_html_pages_dynamic_zones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_images`
--

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(40) default NULL,
  `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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_images`
--

LOCK TABLES `tiki_images` WRITE;
/*!40000 ALTER TABLE `tiki_images` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_images` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_images_data`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_images_data`
--

LOCK TABLES `tiki_images_data` WRITE;
/*!40000 ALTER TABLE `tiki_images_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_images_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_integrator_reps`
--

DROP TABLE IF EXISTS `tiki_integrator_reps`;
CREATE TABLE `tiki_integrator_reps` (
  `repID` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `path` varchar(255) NOT NULL default '',
  `start_page` varchar(255) NOT NULL default '',
  `css_file` varchar(255) NOT NULL default '',
  `visibility` char(1) NOT NULL default 'y',
  `cacheable` char(1) NOT NULL default 'y',
  `expiration` int(11) NOT NULL default '0',
  `description` text NOT NULL,
  PRIMARY KEY  (`repID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_integrator_reps`
--

LOCK TABLES `tiki_integrator_reps` WRITE;
/*!40000 ALTER TABLE `tiki_integrator_reps` DISABLE KEYS */;
INSERT INTO `tiki_integrator_reps` VALUES (1,'Doxygened (1.3.4) Documentation','','index.html','doxygen.css','n','y',0,'Use this repository as rule source for all your repositories based on doxygened docs. To setup yours just add new repository and copy rules from this repository :)');
/*!40000 ALTER TABLE `tiki_integrator_reps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_integrator_rules`
--

DROP TABLE IF EXISTS `tiki_integrator_rules`;
CREATE TABLE `tiki_integrator_rules` (
  `ruleID` int(11) NOT NULL auto_increment,
  `repID` int(11) NOT NULL default '0',
  `ord` int(2) unsigned NOT NULL default '0',
  `srch` blob NOT NULL,
  `repl` blob NOT NULL,
  `type` char(1) NOT NULL default 'n',
  `casesense` char(1) NOT NULL default 'y',
  `rxmod` varchar(20) NOT NULL default '',
  `enabled` char(1) NOT NULL default 'n',
  `description` text NOT NULL,
  PRIMARY KEY  (`ruleID`),
  KEY `repID` (`repID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_integrator_rules`
--

LOCK TABLES `tiki_integrator_rules` WRITE;
/*!40000 ALTER TABLE `tiki_integrator_rules` DISABLE KEYS */;
INSERT INTO `tiki_integrator_rules` VALUES (1,1,1,'.*<body[^>]*?>(.*?)</body.*','1','y','n','i','y','Extract code between <BODY> tags'),(2,1,2,'img src=(\"|\')(?!http://)','img src=1{path}/','y','n','i','y','Fix images path'),(3,1,3,'href=(\"|\')(?!(#|(http|ftp)://))','href=1tiki-integrator.php?repID={repID}&file=','y','n','i','y','Relace internal links to integrator. Dont touch an external links.');
/*!40000 ALTER TABLE `tiki_integrator_rules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_language`
--

DROP TABLE IF EXISTS `tiki_language`;
CREATE TABLE `tiki_language` (
  `source` tinyblob NOT NULL,
  `lang` varchar(16) NOT NULL default '',
  `tran` tinyblob,
  PRIMARY KEY  (`source`(255),`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_language`
--

LOCK TABLES `tiki_language` WRITE;
/*!40000 ALTER TABLE `tiki_language` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_language` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_languages`
--

DROP TABLE IF EXISTS `tiki_languages`;
CREATE TABLE `tiki_languages` (
  `lang` varchar(16) NOT NULL default '',
  `language` varchar(255) default NULL,
  PRIMARY KEY  (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_languages`
--

LOCK TABLES `tiki_languages` WRITE;
/*!40000 ALTER TABLE `tiki_languages` DISABLE KEYS */;
INSERT INTO `tiki_languages` VALUES ('en','English');
/*!40000 ALTER TABLE `tiki_languages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_link_cache`
--

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 `urlindex` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_link_cache`
--

LOCK TABLES `tiki_link_cache` WRITE;
/*!40000 ALTER TABLE `tiki_link_cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_link_cache` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_links`
--

DROP TABLE IF EXISTS `tiki_links`;
CREATE TABLE `tiki_links` (
  `fromPage` varchar(160) NOT NULL default '',
  `toPage` varchar(160) NOT NULL default '',
  PRIMARY KEY  (`fromPage`,`toPage`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_links`
--

LOCK TABLES `tiki_links` WRITE;
/*!40000 ALTER TABLE `tiki_links` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_links` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_live_support_events`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_live_support_events`
--

LOCK TABLES `tiki_live_support_events` WRITE;
/*!40000 ALTER TABLE `tiki_live_support_events` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_live_support_events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_live_support_message_comments`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_live_support_message_comments`
--

LOCK TABLES `tiki_live_support_message_comments` WRITE;
/*!40000 ALTER TABLE `tiki_live_support_message_comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_live_support_message_comments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_live_support_messages`
--

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(40) default NULL,
  `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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_live_support_messages`
--

LOCK TABLES `tiki_live_support_messages` WRITE;
/*!40000 ALTER TABLE `tiki_live_support_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_live_support_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_live_support_modules`
--

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=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_live_support_modules`
--

LOCK TABLES `tiki_live_support_modules` WRITE;
/*!40000 ALTER TABLE `tiki_live_support_modules` DISABLE KEYS */;
INSERT INTO `tiki_live_support_modules` VALUES (1,'wiki'),(2,'forums'),(3,'image galleries'),(4,'file galleries'),(5,'directory'),(6,'workflow'),(7,'charts');
/*!40000 ALTER TABLE `tiki_live_support_modules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_live_support_operators`
--

DROP TABLE IF EXISTS `tiki_live_support_operators`;
CREATE TABLE `tiki_live_support_operators` (
  `user` varchar(40) 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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_live_support_operators`
--

LOCK TABLES `tiki_live_support_operators` WRITE;
/*!40000 ALTER TABLE `tiki_live_support_operators` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_live_support_operators` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_live_support_requests`
--

DROP TABLE IF EXISTS `tiki_live_support_requests`;
CREATE TABLE `tiki_live_support_requests` (
  `reqId` varchar(32) NOT NULL default '',
  `user` varchar(40) default NULL,
  `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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_live_support_requests`
--

LOCK TABLES `tiki_live_support_requests` WRITE;
/*!40000 ALTER TABLE `tiki_live_support_requests` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_live_support_requests` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_logs`
--

DROP TABLE IF EXISTS `tiki_logs`;
CREATE TABLE `tiki_logs` (
  `logId` int(8) NOT NULL auto_increment,
  `logtype` varchar(20) NOT NULL default '',
  `logmessage` text NOT NULL,
  `loguser` varchar(40) NOT NULL default '',
  `logip` varchar(200) NOT NULL default '',
  `logclient` text NOT NULL,
  `logtime` int(14) NOT NULL default '0',
  PRIMARY KEY  (`logId`),
  KEY `logtype` (`logtype`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_logs`
--

LOCK TABLES `tiki_logs` WRITE;
/*!40000 ALTER TABLE `tiki_logs` DISABLE KEYS */;
INSERT INTO `tiki_logs` VALUES (1,'login','logged out','admin','69.85.154.59','Mozilla/5.0 (Macintosh; U; PPC; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02',1192982039),(2,'login','logged from /tiki-index.php','mythusmage','69.85.154.59','Mozilla/5.0 (Macintosh; U; PPC; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02',1192982053),(3,'login','logged out','mythusmage','69.85.154.59','Mozilla/5.0 (Macintosh; U; PPC; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02',1192982095),(4,'login','logged from /tiki-index.php','admin','69.85.154.59','Mozilla/5.0 (Macintosh; U; PPC; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02',1192982114),(5,'adminusers','','changed password for mythusmage','69.85.154.59','Mozilla/5.0 (Macintosh; U; PPC; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02',1192982272),(6,'adminusers','','changed login for mythusmage from admin','69.85.154.59','Mozilla/5.0 (Macintosh; U; PPC; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02',1192982272);
/*!40000 ALTER TABLE `tiki_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_mail_events`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_mail_events`
--

LOCK TABLES `tiki_mail_events` WRITE;
/*!40000 ALTER TABLE `tiki_mail_events` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_mail_events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_mailin_accounts`
--

DROP TABLE IF EXISTS `tiki_mailin_accounts`;
CREATE TABLE `tiki_mailin_accounts` (
  `accountId` int(12) NOT NULL auto_increment,
  `user` varchar(40) 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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_mailin_accounts`
--

LOCK TABLES `tiki_mailin_accounts` WRITE;
/*!40000 ALTER TABLE `tiki_mailin_accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_mailin_accounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_menu_languages`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_menu_languages`
--

LOCK TABLES `tiki_menu_languages` WRITE;
/*!40000 ALTER TABLE `tiki_menu_languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_menu_languages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_menu_options`
--

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` varchar(255) default NULL,
  `perm` varchar(255) default NULL,
  `groupname` varchar(255) default NULL,
  PRIMARY KEY  (`optionId`)
) ENGINE=MyISAM AUTO_INCREMENT=171 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_menu_options`
--

LOCK TABLES `tiki_menu_options` WRITE;
/*!40000 ALTER TABLE `tiki_menu_options` DISABLE KEYS */;
INSERT INTO `tiki_menu_options` VALUES (1,42,'o','Home','tiki-index.php',10,'','',''),(2,42,'o','Chat','tiki-chat.php',15,'feature_chat','tiki_p_chat',''),(3,42,'o','Contact us','tiki-contact.php',20,'feature_contact','',''),(4,42,'o','Stats','tiki-stats.php',23,'feature_stats','tiki_p_view_stats',''),(5,42,'o','Categories','tiki-browse_categories.php',25,'feature_categories','tiki_p_view_categories',''),(6,42,'o','Games','tiki-list_games.php',30,'feature_games','tiki_p_play_games',''),(7,42,'o','Calendar','tiki-calendar.php',35,'feature_calendar','tiki_p_view_calendar',''),(8,42,'o','Mobile','tiki-mobile.php',37,'feature_mobile','',''),(9,42,'o','(debug)','javascript:toggle(\"debugconsole\")',40,'feature_debug_console','tiki_p_admin',''),(10,42,'s','MyTiki','tiki-my_tiki.php',50,'','','Registered'),(11,42,'o','MyTiki home','tiki-my_tiki.php',51,'','','Registered'),(12,42,'o','Preferences','tiki-user_preferences.php',55,'feature_userPreferences','','Registered'),(13,42,'o','Messages','messu-mailbox.php',60,'feature_messages','tiki_p_messages','Registered'),(14,42,'o','Tasks','tiki-user_tasks.php',65,'feature_tasks','tiki_p_tasks','Registered'),(15,42,'o','Bookmarks','tiki-user_bookmarks.php',70,'feature_user_bookmarks','tiki_p_create_bookmarks','Registered'),(16,42,'o','Modules','tiki-user_assigned_modules.php',75,'user_assigned_modules','tiki_p_configure_modules','Registered'),(17,42,'o','Newsreader','tiki-newsreader_servers.php',80,'feature_newsreader','tiki_p_newsreader','Registered'),(18,42,'o','Webmail','tiki-webmail.php',85,'feature_webmail','tiki_p_use_webmail','Registered'),(19,42,'o','Notepad','tiki-notepad_list.php',90,'feature_notepad','tiki_p_notepad','Registered'),(20,42,'o','My files','tiki-userfiles.php',95,'feature_userfiles','tiki_p_userfiles','Registered'),(21,42,'o','User menu','tiki-usermenu.php',100,'feature_usermenu','','Registered'),(22,42,'o','Mini calendar','tiki-minical.php',105,'feature_minical','','Registered'),(23,42,'o','My watches','tiki-user_watches.php',110,'feature_user_watches','','Registered'),(24,42,'s','Workflow','tiki-g-user_processes.php',150,'feature_workflow','tiki_p_use_workflow',''),(25,42,'o','Admin processes','tiki-g-admin_processes.php',155,'feature_workflow','tiki_p_admin_workflow',''),(26,42,'o','Monitor processes','tiki-g-monitor_processes.php',160,'feature_workflow','tiki_p_admin_workflow',''),(27,42,'o','Monitor activities','tiki-g-monitor_activities.php',165,'feature_workflow','tiki_p_admin_workflow',''),(28,42,'o','Monitor instances','tiki-g-monitor_instances.php',170,'feature_workflow','tiki_p_admin_workflow',''),(29,42,'o','User processes','tiki-g-user_processes.php',175,'feature_workflow','tiki_p_use_workflow',''),(30,42,'o','User activities','tiki-g-user_activities.php',180,'feature_workflow','tiki_p_use_workflow',''),(31,42,'o','User instances','tiki-g-user_instances.php',185,'feature_workflow','tiki_p_use_workflow',''),(32,42,'s','Community','tiki-list_users.php',187,'feature_friends','tiki_p_list_users',''),(33,42,'o','User list','tiki-list_users.php',188,'feature_friends','tiki_p_list_users',''),(34,42,'o','Friendship Network','tiki-friends.php',189,'feature_friends','',''),(35,42,'s','Wiki','tiki-index.php',200,'feature_wiki','tiki_p_view',''),(36,42,'o','Wiki Home','tiki-index.php',202,'feature_wiki','tiki_p_view',''),(37,42,'o','Last Changes','tiki-lastchanges.php',205,'feature_wiki,feature_lastChanges','tiki_p_view',''),(38,42,'o','Dump','dump/new.tar',210,'feature_wiki,feature_dump','tiki_p_view',''),(39,42,'o','Rankings','tiki-wiki_rankings.php',215,'feature_wiki,feature_wiki_rankings','tiki_p_view',''),(40,42,'o','List pages','tiki-listpages.php',220,'feature_wiki,feature_listPages','tiki_p_view',''),(41,42,'o','Orphan pages','tiki-orphan_pages.php',225,'feature_wiki,feature_listPages','tiki_p_view',''),(42,42,'o','Sandbox','tiki-editpage.php?page=sandbox',230,'feature_wiki,feature_sandbox','tiki_p_view',''),(43,42,'o','Print','tiki-print_pages.php',235,'feature_wiki,feature_wiki_multiprint','tiki_p_view',''),(44,42,'o','Send pages','tiki-send_objects.php',240,'feature_wiki,feature_comm','tiki_p_view,tiki_p_send_pages',''),(45,42,'o','Received pages','tiki-received_pages.php',245,'feature_wiki,feature_comm','tiki_p_view,tiki_p_admin_received_pages',''),(46,42,'o','Structures','tiki-admin_structures.php',250,'feature_wiki','tiki_p_edit_structures',''),(47,42,'s','Image Galleries','tiki-galleries.php',300,'feature_galleries','tiki_p_view_image_gallery',''),(48,42,'o','Galleries','tiki-galleries.php',305,'feature_galleries','tiki_p_view_image_gallery',''),(49,42,'o','Rankings','tiki-galleries_rankings.php',310,'feature_galleries,feature_gal_rankings','tiki_p_view_image_gallery',''),(50,42,'o','Upload image','tiki-upload_image.php',315,'feature_galleries','tiki_p_upload_images',''),(51,42,'o','Directory batch','tiki-batch_upload.php',318,'feature_galleries,feature_gal_batch','tiki_p_batch_upload',''),(52,42,'o','System gallery','tiki-list_gallery.php?galleryId=0',320,'feature_galleries','tiki_p_admin_galleries',''),(53,42,'s','Articles','tiki-view_articles.php',350,'feature_articles','tiki_p_read_article',''),(54,42,'o','Articles home','tiki-view_articles.php',355,'feature_articles','tiki_p_read_article',''),(55,42,'o','List articles','tiki-list_articles.php',360,'feature_articles','tiki_p_read_article',''),(56,42,'o','Rankings','tiki-cms_rankings.php',365,'feature_articles,feature_cms_rankings','tiki_p_read_article',''),(57,42,'o','Submit article','tiki-edit_submission.php',370,'feature_articles,feature_submissions','tiki_p_read_article,tiki_p_submit_article',''),(58,42,'o','View submissions','tiki-list_submissions.php',375,'feature_articles,feature_submissions','tiki_p_read_article,tiki_p_submit_article',''),(59,42,'o','View submissions','tiki-list_submissions.php',375,'feature_articles,feature_submissions','tiki_p_read_article,tiki_p_approve_submission',''),(60,42,'o','View submissions','tiki-list_submissions.php',375,'feature_articles,feature_submissions','tiki_p_read_article,tiki_p_remove_submission',''),(61,42,'o','Edit article','tiki-edit_article.php',380,'feature_articles','tiki_p_read_article,tiki_p_edit_article',''),(62,42,'o','Send articles','tiki-send_objects.php',385,'feature_articles,feature_comm','tiki_p_read_article,tiki_p_send_articles',''),(63,42,'o','Received articles','tiki-received_articles.php',385,'feature_articles,feature_comm','tiki_p_read_article,tiki_p_admin_received_articles',''),(64,42,'o','Admin topics','tiki-admin_topics.php',390,'feature_articles','tiki_p_read_article,tiki_p_admin_cms',''),(65,42,'o','Admin types','tiki-article_types.php',395,'feature_articles','tiki_p_read_article,tiki_p_admin_cms',''),(66,42,'s','Blogs','tiki-list_blogs.php',450,'feature_blogs','tiki_p_read_blog',''),(67,42,'o','List blogs','tiki-list_blogs.php',455,'feature_blogs','tiki_p_read_blog',''),(68,42,'o','Rankings','tiki-blog_rankings.php',460,'feature_blogs,feature_blog_rankings','tiki_p_read_blog',''),(69,42,'o','Create/Edit blog','tiki-edit_blog.php',465,'feature_blogs','tiki_p_read_blog,tiki_p_create_blogs',''),(70,42,'o','Post','tiki-blog_post.php',470,'feature_blogs','tiki_p_read_blog,tiki_p_blog_post',''),(71,42,'o','Admin posts','tiki-list_posts.php',475,'feature_blogs','tiki_p_read_blog,tiki_p_blog_admin',''),(72,42,'s','Forums','tiki-forums.php',500,'feature_forums','tiki_p_forum_read',''),(73,42,'o','List forums','tiki-forums.php',505,'feature_forums','tiki_p_forum_read',''),(74,42,'o','Rankings','tiki-forum_rankings.php',510,'feature_forums,feature_forum_rankings','tiki_p_forum_read',''),(75,42,'o','Admin forums','tiki-admin_forums.php',515,'feature_forums','tiki_p_forum_read,tiki_p_admin_forum',''),(76,42,'s','Directory','tiki-directory_browse.php',550,'feature_directory','tiki_p_view_directory',''),(77,42,'o','Submit a new link','tiki-directory_add_site.php',555,'feature_directory','tiki_p_submit_link',''),(78,42,'o','Browse directory','tiki-directory_browse.php',560,'feature_directory','tiki_p_view_directory',''),(79,42,'o','Admin directory','tiki-directory_admin.php',565,'feature_directory','tiki_p_view_directory,tiki_p_admin_directory_cats',''),(80,42,'o','Admin directory','tiki-directory_admin.php',565,'feature_directory','tiki_p_view_directory,tiki_p_admin_directory_sites',''),(81,42,'o','Admin directory','tiki-directory_admin.php',565,'feature_directory','tiki_p_view_directory,tiki_p_validate_links',''),(82,42,'s','File Galleries','tiki-file_galleries.php',600,'feature_file_galleries','tiki_p_view_file_gallery',''),(83,42,'o','List galleries','tiki-file_galleries.php',605,'feature_file_galleries','tiki_p_view_file_gallery',''),(84,42,'o','Rankings','tiki-file_galleries_rankings.php',610,'feature_file_galleries,feature_file_galleries_rankings','tiki_p_view_file_gallery',''),(85,42,'o','Upload file','tiki-upload_file.php',615,'feature_file_galleries','tiki_p_view_file_gallery,tiki_p_upload_files',''),(86,42,'s','FAQs','tiki-list_faqs.php',650,'feature_faqs','tiki_p_view_faqs',''),(87,42,'o','List FAQs','tiki-list_faqs.php',665,'feature_faqs','tiki_p_view_faqs',''),(88,42,'o','Admin FAQs','tiki-list_faqs.php',660,'feature_faqs','tiki_p_admin_faqs',''),(89,42,'s','Maps','tiki-map.phtml',700,'feature_maps','tiki_p_map_view',''),(90,42,'o','Mapfiles','tiki-map_edit.php',705,'feature_maps','tiki_p_map_view',''),(91,42,'o','Layer management','tiki-map_upload.php',710,'feature_maps','tiki_p_map_edit',''),(92,42,'s','Quizzes','tiki-list_quizzes.php',750,'feature_quizzes','',''),(93,42,'o','List quizzes','tiki-list_quizzes.php',755,'feature_quizzes','',''),(94,42,'o','Quiz stats','tiki-quiz_stats.php',760,'feature_quizzes','tiki_p_view_quiz_stats',''),(95,42,'o','Admin quiz','tiki-edit_quiz.php',765,'feature_quizzes','tiki_p_admin_quizzes',''),(96,42,'s','TikiSheet','tiki-sheets.php',780,'feature_sheet','',''),(97,42,'s','Trackers','tiki-list_trackers.php',800,'feature_trackers','tiki_p_view_trackers',''),(98,42,'o','List trackers','tiki-list_trackers.php',805,'feature_trackers','tiki_p_view_trackers',''),(99,42,'o','Admin trackers','tiki-admin_trackers.php',810,'feature_trackers','tiki_p_admin_trackers',''),(100,42,'s','Surveys','tiki-list_surveys.php',850,'feature_surveys','',''),(101,42,'o','List surveys','tiki-list_surveys.php',855,'feature_surveys','',''),(102,42,'o','Stats','tiki-survey_stats.php',860,'feature_surveys','tiki_p_view_survey_stats',''),(103,42,'o','Admin surveys','tiki-admin_surveys.php',865,'feature_surveys','tiki_p_admin_surveys',''),(104,42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_subscribe_newsletters',''),(105,42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_send_newsletters',''),(106,42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_admin_newsletters',''),(107,42,'o','Send newsletters','tiki-send_newsletters.php',905,'feature_newsletters','tiki_p_send_newsletters',''),(108,42,'o','Admin newsletters','tiki-admin_newsletters.php',910,'feature_newsletters','tiki_p_admin_newsletters',''),(109,42,'s','Ephemerides','tiki-eph.php',950,'feature_eph','',''),(110,42,'o','Admin ephemerides','tiki-eph_admin.php',955,'feature_eph','tiki_p_eph_admin',''),(111,42,'s','Charts','tiki-charts.php',1000,'feature_charts','',''),(112,42,'o','Admin charts','tiki-admin_charts.php',1005,'feature_charts','tiki_p_admin_charts',''),(113,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin',''),(114,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_chat',''),(115,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_categories',''),(116,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_banners',''),(117,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_edit_templates',''),(118,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_edit_cookies',''),(119,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_dynamic',''),(120,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_mailin',''),(121,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_edit_content_templates',''),(122,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_edit_html_pages',''),(123,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_view_referer_stats',''),(124,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_drawings',''),(125,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_shoutbox',''),(126,42,'r','Admin','tiki-admin.php',1050,'','tiki_p_live_support_admin',''),(127,42,'r','Admin','tiki-admin.php',1050,'','user_is_operator',''),(128,42,'r','Admin','tiki-admin.php',1050,'feature_integrator','tiki_p_admin_integrator',''),(129,42,'o','Admin home','tiki-admin.php',1051,'','tiki_p_admin',''),(130,42,'o','Live support','tiki-live_support_admin.php',1055,'feature_live_support','tiki_p_live_support_admin',''),(131,42,'o','Live support','tiki-live_support_admin.php',1055,'feature_live_support','user_is_operator',''),(132,42,'o','Banning','tiki-admin_banning.php',1060,'feature_banning','tiki_p_admin_banning',''),(133,42,'o','Calendar','tiki-admin_calendars.php',1065,'feature_calendar','tiki_p_admin_calendar',''),(134,42,'o','Users','tiki-adminusers.php',1070,'','tiki_p_admin_users',''),(135,42,'o','Groups','tiki-admingroups.php',1075,'','tiki_p_admin',''),(136,42,'o','Cache','tiki-list_cache.php',1080,'','tiki_p_admin',''),(137,42,'o','Modules','tiki-admin_modules.php',1085,'','tiki_p_admin',''),(138,42,'o','Links','tiki-admin_links.php',1090,'feature_featuredLinks','tiki_p_admin',''),(139,42,'o','Hotwords','tiki-admin_hotwords.php',1095,'feature_hotwords','tiki_p_admin',''),(140,42,'o','RSS modules','tiki-admin_rssmodules.php',1100,'','tiki_p_admin',''),(141,42,'o','Menus','tiki-admin_menus.php',1105,'','tiki_p_admin',''),(142,42,'o','Polls','tiki-admin_polls.php',1110,'feature_polls','tiki_p_admin',''),(143,42,'o','Backups','tiki-backup.php',1115,'','tiki_p_admin',''),(144,42,'o','Mail notifications','tiki-admin_notifications.php',1120,'','tiki_p_admin',''),(145,42,'o','Search stats','tiki-search_stats.php',1125,'feature_search','tiki_p_admin',''),(146,42,'o','Theme control','tiki-theme_control.php',1130,'feature_theme_control','tiki_p_admin',''),(147,42,'o','QuickTags','tiki-admin_quicktags.php',1135,'','tiki_p_admin',''),(148,42,'o','Chat','tiki-admin_chat.php',1140,'feature_chat','tiki_p_admin_chat',''),(149,42,'o','Categories','tiki-admin_categories.php',1145,'feature_categories','tiki_p_admin_categories',''),(150,42,'o','Banners','tiki-list_banners.php',1150,'feature_banners','tiki_p_admin_banners',''),(151,42,'o','Edit templates','tiki-edit_templates.php',1155,'feature_edit_templates','tiki_p_edit_templates',''),(152,42,'o','Drawings','tiki-admin_drawings.php',1160,'feature_drawings','tiki_p_admin_drawings',''),(153,42,'o','Dynamic content','tiki-list_contents.php',1165,'feature_dynamic_content','tiki_p_admin_dynamic',''),(154,42,'o','Cookies','tiki-admin_cookies.php',1170,'','tiki_p_edit_cookies',''),(155,42,'o','Mail-in','tiki-admin_mailin.php',1175,'feature_mailin','tiki_p_admin_mailin',''),(156,42,'o','Content templates','tiki-admin_content_templates.php',1180,'','tiki_p_edit_content_templates',''),(157,42,'o','HTML pages','tiki-admin_html_pages.php',1185,'feature_html_pages','tiki_p_edit_html_pages',''),(158,42,'o','Shoutbox','tiki-shoutbox.php',1190,'feature_shoutbox','tiki_p_admin_shoutbox',''),(159,42,'o','Shoutbox Words','tiki-admin_shoutbox_words.php',1191,'feature_shoutbox','tiki_p_admin_shoutbox',''),(160,42,'o','Referer stats','tiki-referer_stats.php',1195,'feature_referer_stats','tiki_p_view_referer_stats',''),(161,42,'o','Edit languages','tiki-edit_languages.php',1200,'','tiki_p_edit_languages,lang_use_db',''),(162,42,'o','Integrator','tiki-admin_integrator.php',1205,'feature_integrator','tiki_p_admin_integrator',''),(163,42,'o','phpinfo','tiki-phpinfo.php',1215,'','tiki_p_admin',''),(164,42,'o','DSN','tiki-admin_dsn.php',1220,'','tiki_p_admin',''),(165,42,'o','External wikis','tiki-admin_external_wikis.php',1225,'','tiki_p_admin',''),(166,42,'o','System Admin','tiki-admin_system.php',1230,'','tiki_p_admin',''),(167,42,'o','Score','tiki-admin_score.php',1235,'feature_score','tiki_p_admin',''),(168,42,'o','Admin mods','tiki-mods.php',1240,'','tiki_p_admin',''),(169,42,'o','Tiki Logs','tiki-syslog.php',1245,'','tiki_p_admin',''),(170,42,'o','Security Admin','tiki-admin_security.php',1250,'','tiki_p_admin','');
/*!40000 ALTER TABLE `tiki_menu_options` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_menus`
--

DROP TABLE IF EXISTS `tiki_menus`;
CREATE TABLE `tiki_menus` (
  `menuId` int(8) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL default '',
  `description` text,
  `type` char(1) default NULL,
  PRIMARY KEY  (`menuId`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_menus`
--

LOCK TABLES `tiki_menus` WRITE;
/*!40000 ALTER TABLE `tiki_menus` DISABLE KEYS */;
INSERT INTO `tiki_menus` VALUES (42,'Application menu','Main extensive navigation menu','d');
/*!40000 ALTER TABLE `tiki_menus` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_minical_events`
--

DROP TABLE IF EXISTS `tiki_minical_events`;
CREATE TABLE `tiki_minical_events` (
  `user` varchar(40) default NULL,
  `eventId` int(12) NOT NULL auto_increment,
  `title` varchar(250) default NULL,
  `description` text,
  `start` int(14) default NULL,
  `end` int(14) default NULL,
  `security` char(1) default NULL,
  `duration` int(3) default NULL,
  `topicId` int(12) default NULL,
  `reminded` char(1) default NULL,
  PRIMARY KEY  (`eventId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_minical_events`
--

LOCK TABLES `tiki_minical_events` WRITE;
/*!40000 ALTER TABLE `tiki_minical_events` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_minical_events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_minical_topics`
--

DROP TABLE IF EXISTS `tiki_minical_topics`;
CREATE TABLE `tiki_minical_topics` (
  `user` varchar(40) default NULL,
  `topicId` int(12) NOT NULL auto_increment,
  `name` varchar(250) default NULL,
  `filename` varchar(200) default NULL,
  `filetype` varchar(200) default NULL,
  `filesize` varchar(200) default NULL,
  `data` longblob,
  `path` varchar(250) default NULL,
  `isIcon` char(1) default NULL,
  PRIMARY KEY  (`topicId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_minical_topics`
--

LOCK TABLES `tiki_minical_topics` WRITE;
/*!40000 ALTER TABLE `tiki_minical_topics` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_minical_topics` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_modules`
--

DROP TABLE IF EXISTS `tiki_modules`;
CREATE TABLE `tiki_modules` (
  `name` varchar(200) NOT NULL default '',
  `position` char(1) default NULL,
  `ord` int(4) default NULL,
  `type` char(1) default NULL,
  `title` varchar(255) default NULL,
  `cache_time` int(14) default NULL,
  `rows` int(4) default NULL,
  `params` varchar(255) default NULL,
  `groups` text,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_modules`
--

LOCK TABLES `tiki_modules` WRITE;
/*!40000 ALTER TABLE `tiki_modules` DISABLE KEYS */;
INSERT INTO `tiki_modules` VALUES ('login_box','r',1,NULL,NULL,0,NULL,NULL,'a:2:{i:0;s:10:\"Registered\";i:1;s:9:\"Anonymous\";}'),('mnu_application_menu','l',1,NULL,NULL,0,NULL,'flip=y','a:2:{i:0;s:10:\"Registered\";i:1;s:9:\"Anonymous\";}'),('quick_edit','l',2,NULL,NULL,0,NULL,NULL,'a:1:{i:0;s:10:\"Registered\";}'),('assistant','l',10,NULL,NULL,0,NULL,NULL,'a:2:{i:0;s:10:\"Registered\";i:1;s:9:\"Anonymous\";}');
/*!40000 ALTER TABLE `tiki_modules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_newsletter_groups`
--

DROP TABLE IF EXISTS `tiki_newsletter_groups`;
CREATE TABLE `tiki_newsletter_groups` (
  `nlId` int(12) NOT NULL default '0',
  `groupName` varchar(255) NOT NULL default '',
  `code` varchar(32) default NULL,
  PRIMARY KEY  (`nlId`,`groupName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_newsletter_groups`
--

LOCK TABLES `tiki_newsletter_groups` WRITE;
/*!40000 ALTER TABLE `tiki_newsletter_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_newsletter_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_newsletter_subscriptions`
--

DROP TABLE IF EXISTS `tiki_newsletter_subscriptions`;
CREATE TABLE `tiki_newsletter_subscriptions` (
  `nlId` int(12) NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `code` varchar(32) default NULL,
  `valid` char(1) default NULL,
  `subscribed` int(14) default NULL,
  `isUser` char(1) NOT NULL default 'n',
  PRIMARY KEY  (`nlId`,`email`,`isUser`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_newsletter_subscriptions`
--

LOCK TABLES `tiki_newsletter_subscriptions` WRITE;
/*!40000 ALTER TABLE `tiki_newsletter_subscriptions` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_newsletter_subscriptions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_newsletters`
--

DROP TABLE IF EXISTS `tiki_newsletters`;
CREATE TABLE `tiki_newsletters` (
  `nlId` int(12) NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  `description` text,
  `created` int(14) default NULL,
  `lastSent` int(14) default NULL,
  `editions` int(10) default NULL,
  `users` int(10) default NULL,
  `allowUserSub` char(1) default 'y',
  `allowAnySub` char(1) default NULL,
  `unsubMsg` char(1) default 'y',
  `validateAddr` char(1) default 'y',
  `frequency` int(14) default NULL,
  PRIMARY KEY  (`nlId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_newsletters`
--

LOCK TABLES `tiki_newsletters` WRITE;
/*!40000 ALTER TABLE `tiki_newsletters` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_newsletters` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_newsreader_marks`
--

DROP TABLE IF EXISTS `tiki_newsreader_marks`;
CREATE TABLE `tiki_newsreader_marks` (
  `user` varchar(40) NOT NULL default '',
  `serverId` int(12) NOT NULL default '0',
  `groupName` varchar(255) NOT NULL default '',
  `timestamp` int(14) NOT NULL default '0',
  PRIMARY KEY  (`user`,`serverId`,`groupName`(100))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_newsreader_marks`
--

LOCK TABLES `tiki_newsreader_marks` WRITE;
/*!40000 ALTER TABLE `tiki_newsreader_marks` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_newsreader_marks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_newsreader_servers`
--

DROP TABLE IF EXISTS `tiki_newsreader_servers`;
CREATE TABLE `tiki_newsreader_servers` (
  `user` varchar(40) NOT NULL default '',
  `serverId` int(12) NOT NULL auto_increment,
  `server` varchar(250) default NULL,
  `port` int(4) default NULL,
  `username` varchar(200) default NULL,
  `password` varchar(200) default NULL,
  PRIMARY KEY  (`serverId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_newsreader_servers`
--

LOCK TABLES `tiki_newsreader_servers` WRITE;
/*!40000 ALTER TABLE `tiki_newsreader_servers` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_newsreader_servers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_object_ratings`
--

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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_object_ratings`
--

LOCK TABLES `tiki_object_ratings` WRITE;
/*!40000 ALTER TABLE `tiki_object_ratings` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_object_ratings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_page_footnotes`
--

DROP TABLE IF EXISTS `tiki_page_footnotes`;
CREATE TABLE `tiki_page_footnotes` (
  `user` varchar(40) NOT NULL default '',
  `pageName` varchar(250) NOT NULL default '',
  `data` text,
  PRIMARY KEY  (`user`,`pageName`(100))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_page_footnotes`
--

LOCK TABLES `tiki_page_footnotes` WRITE;
/*!40000 ALTER TABLE `tiki_page_footnotes` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_page_footnotes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_pages`
--

DROP TABLE IF EXISTS `tiki_pages`;
CREATE TABLE `tiki_pages` (
  `page_id` int(14) NOT NULL auto_increment,
  `pageName` varchar(160) NOT NULL default '',
  `hits` int(8) default NULL,
  `data` text,
  `description` varchar(200) default NULL,
  `lastModif` int(14) default NULL,
  `comment` varchar(200) default NULL,
  `version` int(8) NOT NULL default '0',
  `user` varchar(40) default NULL,
  `ip` varchar(15) default NULL,
  `flag` char(1) default NULL,
  `points` int(8) default NULL,
  `votes` int(8) default NULL,
  `cache` text,
  `wiki_cache` int(10) default NULL,
  `cache_timestamp` int(14) default NULL,
  `pageRank` decimal(4,3) default NULL,
  `creator` varchar(200) default NULL,
  `page_size` int(10) unsigned default '0',
  `lang` varchar(16) default NULL,
  `lockedby` varchar(200) default NULL,
  `is_html` tinyint(1) default '0',
  `created` int(14) default NULL,
  PRIMARY KEY  (`page_id`),
  UNIQUE KEY `pageName` (`pageName`),
  KEY `data` (`data`(255)),
  KEY `pageRank` (`pageRank`),
  FULLTEXT KEY `ft` (`pageName`,`description`,`data`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_pages`
--

LOCK TABLES `tiki_pages` WRITE;
/*!40000 ALTER TABLE `tiki_pages` DISABLE KEYS */;
INSERT INTO `tiki_pages` VALUES (1,'HomePage',407,'','',1192980321,'Tiki initialization',1,'mythusmage','0.0.0.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'mythusmage',0,NULL,NULL,0,1192980321);
/*!40000 ALTER TABLE `tiki_pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_pageviews`
--

DROP TABLE IF EXISTS `tiki_pageviews`;
CREATE TABLE `tiki_pageviews` (
  `day` int(14) NOT NULL default '0',
  `pageviews` int(14) default NULL,
  PRIMARY KEY  (`day`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_pageviews`
--

LOCK TABLES `tiki_pageviews` WRITE;
/*!40000 ALTER TABLE `tiki_pageviews` DISABLE KEYS */;
INSERT INTO `tiki_pageviews` VALUES (1192939200,52),(1193025600,113),(1193112000,134),(1193198400,71),(1193284800,43),(1193371200,44),(1193457600,39),(1193544000,95),(1193630400,80),(1193716800,85),(1193803200,70),(1193889600,51),(1193976000,40),(1194062400,69),(1194148800,103),(1194238800,70),(1194325200,21);
/*!40000 ALTER TABLE `tiki_pageviews` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_poll_objects`
--

DROP TABLE IF EXISTS `tiki_poll_objects`;
CREATE TABLE `tiki_poll_objects` (
  `catObjectId` int(11) NOT NULL default '0',
  `pollId` int(11) NOT NULL default '0',
  `title` varchar(255) default NULL,
  PRIMARY KEY  (`catObjectId`,`pollId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_poll_objects`
--

LOCK TABLES `tiki_poll_objects` WRITE;
/*!40000 ALTER TABLE `tiki_poll_objects` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_poll_objects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_poll_options`
--

DROP TABLE IF EXISTS `tiki_poll_options`;
CREATE TABLE `tiki_poll_options` (
  `pollId` int(8) NOT NULL default '0',
  `optionId` int(8) NOT NULL auto_increment,
  `title` varchar(200) default NULL,
  `position` int(4) NOT NULL default '0',
  `votes` int(8) default NULL,
  PRIMARY KEY  (`optionId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_poll_options`
--

LOCK TABLES `tiki_poll_options` WRITE;
/*!40000 ALTER TABLE `tiki_poll_options` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_poll_options` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_polls`
--

DROP TABLE IF EXISTS `tiki_polls`;
CREATE TABLE `tiki_polls` (
  `pollId` int(8) NOT NULL auto_increment,
  `title` varchar(200) default NULL,
  `votes` int(8) default NULL,
  `active` char(1) default NULL,
  `publishDate` int(14) default NULL,
  PRIMARY KEY  (`pollId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_polls`
--

LOCK TABLES `tiki_polls` WRITE;
/*!40000 ALTER TABLE `tiki_polls` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_polls` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_preferences`
--

DROP TABLE IF EXISTS `tiki_preferences`;
CREATE TABLE `tiki_preferences` (
  `name` varchar(40) NOT NULL default '',
  `value` varchar(250) default NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_preferences`
--

LOCK TABLES `tiki_preferences` WRITE;
/*!40000 ALTER TABLE `tiki_preferences` DISABLE KEYS */;
INSERT INTO `tiki_preferences` VALUES ('allowRegister','n'),('anonCanEdit','n'),('art_list_author','y'),('art_list_date','y'),('art_list_expire','y'),('art_list_img','y'),('art_list_reads','y'),('art_list_size','y'),('art_list_title','y'),('art_list_topic','y'),('art_list_type','y'),('art_list_visible','y'),('article_comments_default_ordering','points_desc'),('article_comments_per_page','10'),('auth_create_user_auth','n'),('auth_create_user_tiki','n'),('auth_imap_pop3_basedsn',''),('auth_ldap_adminpass',''),('auth_ldap_adminuser',''),('auth_ldap_basedn',''),('auth_ldap_groupattr','cn'),('auth_ldap_groupdn',''),('auth_ldap_groupoc','groupOfUniqueNames'),('auth_ldap_memberattr','uniqueMember'),('auth_ldap_memberisdn','n'),('auth_ldap_scope','sub'),('auth_ldap_url',''),('auth_ldap_userattr','uid'),('auth_ldap_userdn',''),('auth_ldap_useroc','inetOrgPerson'),('auth_method','tiki'),('auth_pear_host','localhost'),('auth_pear_port','389'),('auth_skip_admin','y'),('auth_type','LDAP'),('available_languages','a:0:{}'),('available_styles','a:0:{}'),('blog_comments_default_ordering','points_desc'),('blog_comments_per_page','10'),('blog_list_activity','y'),('blog_list_created','y'),('blog_list_description','y'),('blog_list_lastmodif','y'),('blog_list_order','created_desc'),('blog_list_posts','y'),('blog_list_title','y'),('blog_list_user','n'),('blog_list_visits','y'),('blog_spellcheck','n'),('cacheimages','n'),('cachepages','n'),('calendar_sticky_popup','n'),('calendar_view_tab','n'),('change_language','y'),('change_password','y'),('change_theme','y'),('cms_bot_bar','y'),('cms_left_column','y'),('cms_right_column','y'),('cms_spellcheck','y'),('cms_top_bar','n'),('contact_anon','n'),('contact_user','admin'),('count_admin_pvs','y'),('default_map','pacific.map'),('default_wiki_diff_style','minsidediff'),('direct_pagination','n'),('directory_columns','3'),('directory_cool_sites','y'),('directory_links_per_page','20'),('directory_open_links','n'),('directory_validate_urls','n'),('display_timezone','EST'),('eponymousGroups','n'),('faq_comments_default_ordering','points_desc'),('faq_comments_per_page','10'),('feature_article_comments','n'),('feature_articles','y'),('feature_autolinks','y'),('feature_babelfish','y'),('feature_babelfish_logo','n'),('feature_backlinks','y'),('feature_banners','n'),('feature_banning','y'),('feature_blog_comments','n'),('feature_blog_rankings','y'),('feature_blogposts_comments','n'),('feature_blogposts_pings','y'),('feature_blogs','y'),('feature_bot_bar','y'),('feature_bot_bar_debug','y'),('feature_bot_bar_icons','y'),('feature_calendar','y'),('feature_categories','y'),('feature_categoryobjects','y'),('feature_categorypath','y'),('feature_challenge','n'),('feature_charts','n'),('feature_chat','n'),('feature_clear_passwords','n'),('feature_cms_print','y'),('feature_cms_rankings','y'),('feature_cms_templates','y'),('feature_comm','n'),('feature_contact','y'),('feature_custom_home','n'),('feature_debug_console','n'),('feature_debugger_console','n'),('feature_detect_language','n'),('feature_directory','y'),('feature_drawings','n'),('feature_dump','n'),('feature_dynamic_content','n'),('feature_edit_templates','n'),('feature_editcss','n'),('feature_eph','n'),('feature_faq_comments','y'),('feature_faqs','y'),('feature_featuredLinks','y'),('feature_file_galleries','n'),('feature_file_galleries_comments','n'),('feature_file_galleries_rankings','n'),('feature_forum_parse','n'),('feature_forum_quickjump','n'),('feature_forum_rankings','y'),('feature_forum_topicd','n'),('feature_forums','y'),('feature_friends','n'),('feature_gal_batch','n'),('feature_gal_imgcache','n'),('feature_gal_rankings','y'),('feature_gal_slideshow','y'),('feature_galleries','n'),('feature_games','n'),('feature_help','y'),('feature_history','y'),('feature_hotwords','y'),('feature_hotwords_nw','n'),('feature_html_pages','n'),('feature_image_galleries_comments','n'),('feature_integrator','n'),('feature_jscalendar','n'),('feature_lastChanges','y'),('feature_left_column','y'),('feature_likePages','y'),('feature_listPages','y'),('feature_live_support','n'),('feature_maps','n'),('feature_menusfolderstyle','y'),('feature_messages','y'),('feature_minical','y'),('feature_mobile','n'),('feature_modulecontrols','n'),('feature_multilingual','n'),('feature_newsletters','y'),('feature_newsreader','y'),('feature_notepad','n'),('feature_obzip','n'),('feature_page_title','y'),('feature_phplayers','n'),('feature_phpopentracker','n'),('feature_poll_anonymous','n'),('feature_poll_comments','n'),('feature_polls','y'),('feature_quizzes','y'),('feature_ranking','n'),('feature_referer_stats','y'),('feature_right_column','y'),('feature_sandbox','y'),('feature_score','y'),('feature_search','y'),('feature_search_fulltext','y'),('feature_search_stats','n'),('feature_sheet','n'),('feature_shoutbox','n'),('feature_smileys','y'),('feature_stats','y'),('feature_submissions','y'),('feature_surveys','y'),('feature_tabs','y'),('feature_tasks','n'),('feature_theme_control','n'),('feature_ticketlib','n'),('feature_ticketlib2','y'),('feature_top_bar','y'),('feature_trackbackpings','y'),('feature_trackers','n'),('feature_userPreferences','y'),('feature_userVersions','n'),('feature_user_bookmarks','y'),('feature_user_watches','n'),('feature_user_watches_translations','y'),('feature_userfiles','n'),('feature_usermenu','y'),('feature_view_tpl','n'),('feature_warn_on_edit','n'),('feature_webmail','n'),('feature_wiki','y'),('feature_wiki_allowhtml','n'),('feature_wiki_attachments','n'),('feature_wiki_comments','n'),('feature_wiki_description','n'),('feature_wiki_discuss','n'),('feature_wiki_export','n'),('feature_wiki_footnotes','n'),('feature_wiki_import_html','n'),('feature_wiki_monosp','y'),('feature_wiki_multiprint','n'),('feature_wiki_notepad','n'),('feature_wiki_open_as_structure','n'),('feature_wiki_pdf','n'),('feature_wiki_pictures','n'),('feature_wiki_rankings','y'),('feature_wiki_ratings','n'),('feature_wiki_tables','old'),('feature_wiki_templates','n'),('feature_wiki_undo','n'),('feature_wiki_userpage','y'),('feature_wiki_userpage_prefix','UserPage'),('feature_wiki_usrlock','n'),('feature_wikiwords','y'),('feature_workflow','n'),('feature_wysiwyg','no'),('feature_xmlrpc','n'),('fgal_allow_duplicates','n'),('fgal_list_created','y'),('fgal_list_description','n'),('fgal_list_files','y'),('fgal_list_hits','y'),('fgal_list_lastmodif','y'),('fgal_list_name','y'),('fgal_list_user','y'),('fgal_match_regex',''),('fgal_nmatch_regex',''),('fgal_use_db','y'),('fgal_use_dir',''),('file_galleries_comments_default_ordering','points_desc'),('file_galleries_comments_per_page','10'),('forgotPass','n'),('forum_list_desc','y'),('forum_list_lastpost','y'),('forum_list_posts','y'),('forum_list_ppd','y'),('forum_list_topics','y'),('forum_list_visits','y'),('forums_ordering','created_desc'),('gal_batch_dir',''),('gal_imgcache_dir','temp/cache'),('gal_list_created','y'),('gal_list_description','y'),('gal_list_imgs','y'),('gal_list_lastmodif','y'),('gal_list_name','y'),('gal_list_user','y'),('gal_list_visits','y'),('gal_match_regex',''),('gal_nmatch_regex',''),('gal_use_db','y'),('gal_use_dir',''),('gal_use_lib','gd'),('groupTracker','n'),('home_file_gallery',''),('http_domain',''),('http_port','80'),('http_prefix','/'),('https','auto'),('https_domain',''),('https_login','n'),('https_login_required','n'),('https_port','443'),('https_prefix','/'),('image_galleries_comments_default_order','points_desc'),('image_galleries_comments_per_page','10'),('keep_versions','1'),('lang_use_db','n'),('language','en'),('layout_section','n'),('limitedGoGroupHome','y'),('long_date_format','%A %d of %B, %Y'),('long_time_format','%H:%M:%S %Z'),('mail_crlf','LF'),('map_path','/home/mythusm/public_html/map/'),('maxArticles','10'),('maxRecords','10'),('maxVersions','0'),('max_rss_articles','10'),('max_rss_blog','10'),('max_rss_blogs','10'),('max_rss_directories','10'),('max_rss_file_galleries','10'),('max_rss_file_gallery','10'),('max_rss_forum','10'),('max_rss_forums','10'),('max_rss_image_galleries','10'),('max_rss_image_gallery','10'),('max_rss_mapfiles','10'),('max_rss_tracker','10'),('max_rss_wiki','10'),('min_pass_length','1'),('modallgroups','y'),('pass_chr_num','n'),('pass_due','999'),('poll_comments_default_ordering','points_desc'),('poll_comments_per_page','10'),('popupLinks','n'),('proxy_host',''),('proxy_port',''),('record_untranslated','n'),('registerPasscode',''),('rememberme','disabled'),('remembertime','7200'),('rnd_num_reg','n'),('rss_articles','y'),('rss_blog','n'),('rss_blogs','y'),('rss_directories','y'),('rss_file_galleries','y'),('rss_file_gallery','n'),('rss_forum','y'),('rss_forums','y'),('rss_image_galleries','y'),('rss_image_gallery','n'),('rss_mapfiles','y'),('rss_tracker','n'),('rss_wiki','y'),('rssfeed_creator',''),('rssfeed_css','y'),('rssfeed_default_version','2'),('rssfeed_editor',''),('rssfeed_language','en-us'),('rssfeed_publisher',''),('rssfeed_webmaster',''),('search_lru_length','100'),('search_lru_purge_rate','5'),('search_max_syllwords','100'),('search_min_wordlength','3'),('search_refresh_rate','5'),('search_syll_age','48'),('sender_email',''),('short_date_format','%a %d of %b, %Y'),('short_time_format','%H:%M %Z'),('shoutbox_autolink','n'),('siteTitle',''),('slide_style','slidestyle.css'),('style','tikineat.css'),('system_os','unix'),('t_use_db','y'),('t_use_dir',''),('tikiIndex','tiki-index.php'),('tmpDir','temp'),('trk_with_mirror_tables','n'),('uf_use_db','y'),('uf_use_dir',''),('urlIndex',''),('useRegisterPasscode','n'),('useUrlIndex','n'),('use_proxy','n'),('userTracker','n'),('user_assigned_modules','n'),('user_list_order','score_desc'),('userfiles_quota','30'),('validateEmail','n'),('validateRegistration','n'),('validateUsers','n'),('w_use_db','y'),('w_use_dir',''),('warn_on_edit_time','2'),('webmail_max_attachment','1500000'),('webmail_view_html','y'),('webserverauth','n'),('wikiHomePage','HomePage'),('wikiLicensePage',''),('wikiSubmitNotice',''),('wiki_bot_bar','n'),('wiki_cache','0'),('wiki_comments_default_ordering','points_desc'),('wiki_comments_per_page','10'),('wiki_creator_admin','n'),('wiki_feature_copyrights','n'),('wiki_forum',''),('wiki_forum_id',''),('wiki_left_column','y'),('wiki_list_backlinks','y'),('wiki_list_comment','y'),('wiki_list_creator','y'),('wiki_list_hits','y'),('wiki_list_lastmodif','y'),('wiki_list_lastver','y'),('wiki_list_links','y'),('wiki_list_name','y'),('wiki_list_size','y'),('wiki_list_status','y'),('wiki_list_user','y'),('wiki_list_versions','y'),('wiki_page_regex','strict'),('wiki_right_column','y'),('wiki_spellcheck','n'),('wiki_top_bar','n'),('wiki_uses_slides','n'),('wiki_wikisyntax_in_html','full'),('messu_mailbox_size','0'),('messu_archive_size','200'),('messu_sent_size','200'),('case_patched','y'),('feature_mailin','y'),('feature_siteidentity','y'),('user_flip_modules','module');
/*!40000 ALTER TABLE `tiki_preferences` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_private_messages`
--

DROP TABLE IF EXISTS `tiki_private_messages`;
CREATE TABLE `tiki_private_messages` (
  `messageId` int(8) NOT NULL auto_increment,
  `toNickname` varchar(200) NOT NULL default '',
  `data` varchar(255) default NULL,
  `poster` varchar(200) NOT NULL default 'anonymous',
  `timestamp` int(14) default NULL,
  PRIMARY KEY  (`messageId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_private_messages`
--

LOCK TABLES `tiki_private_messages` WRITE;
/*!40000 ALTER TABLE `tiki_private_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_private_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_programmed_content`
--

DROP TABLE IF EXISTS `tiki_programmed_content`;
CREATE TABLE `tiki_programmed_content` (
  `pId` int(8) NOT NULL auto_increment,
  `contentId` int(8) NOT NULL default '0',
  `publishDate` int(14) NOT NULL default '0',
  `data` text,
  PRIMARY KEY  (`pId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_programmed_content`
--

LOCK TABLES `tiki_programmed_content` WRITE;
/*!40000 ALTER TABLE `tiki_programmed_content` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_programmed_content` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_quicktags`
--

DROP TABLE IF EXISTS `tiki_quicktags`;
CREATE TABLE `tiki_quicktags` (
  `tagId` int(4) unsigned NOT NULL auto_increment,
  `taglabel` varchar(255) default NULL,
  `taginsert` text,
  `tagicon` varchar(255) default NULL,
  `tagcategory` varchar(255) default NULL,
  PRIMARY KEY  (`tagId`),
  KEY `tagcategory` (`tagcategory`),
  KEY `taglabel` (`taglabel`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_quicktags`
--

LOCK TABLES `tiki_quicktags` WRITE;
/*!40000 ALTER TABLE `tiki_quicktags` DISABLE KEYS */;
INSERT INTO `tiki_quicktags` VALUES (1,'bold','__text__','images/ed_format_bold.gif','wiki'),(2,'italic','\'\'text\'\'','images/ed_format_italic.gif','wiki'),(3,'underline','===text===','images/ed_format_underline.gif','wiki'),(4,'table','||r1c1|r1c2||r2c1|r2c2||','images/insert_table.gif','wiki'),(5,'table new','||r1c1|r1c2\nr2c1|r2c2||','images/insert_table.gif','wiki'),(6,'external link','[http://example.com|text]','images/ed_link.gif','wiki'),(7,'wiki link','((text))','images/ed_copy.gif','wiki'),(8,'heading1','!text','images/ed_custom.gif','wiki'),(9,'title bar','-=text=-','images/fullscreen_maximize.gif','wiki'),(10,'box','^text^','images/ed_about.gif','wiki'),(11,'rss feed','{rss id= }','images/ico_link.gif','wiki'),(12,'dynamic content','{content id= }','images/book.gif','wiki'),(13,'tagline','{cookie}','images/footprint.gif','wiki'),(14,'hr','---','images/ed_hr.gif','wiki'),(15,'center text','::text::','images/ed_align_center.gif','wiki'),(16,'colored text','~~#FF0000:text~~','images/fontfamily.gif','wiki'),(17,'dynamic variable','%text%','images/book.gif','wiki'),(18,'image','{img src= width= height= align= desc= link= }','images/ed_image.gif','wiki'),(19,'New wms Metadata','METADATA\r\n		\"wms_name\" \"myname\"\r\n 	\"wms_srs\" \"EPSG:4326\"\r\n 	\"wms_server_version\" \" \"\r\n 	\"wms_layers\" \"mylayers\"\r\n 	\"wms_request\" \"myrequest\"\r\n 	\"wms_format\" \" \"\r\n 	\"wms_time\" \" \"\r\n END','img/icons/admin_metatags.png','maps'),(20,'New Class','CLASS\r\n EXPRESSION ()\r\n SYMBOL 0\r\n OUTLINECOLOR\r\n COLOR\r\n NAME \"myclass\" \r\nEND #end of class','img/icons/mini_triangle.gif','maps'),(21,'New Projection','PROJECTION\r\n \"init=epsg:4326\"\r\nEND','images/ico_mode.gif','maps'),(22,'New Query','#\r\n# Start of query definitions\r\n#\r\n QUERYMAP\r\n STATUS ON\r\n STYLE HILITE\r\nEND','img/icons/questions.gif','maps'),(23,'New Scalebar','#\r\n# Start of scalebar\r\n#\r\nSCALEBAR\r\n IMAGECOLOR 255 255 255\r\n STYLE 1\r\n SIZE 400 2\r\n COLOR 0 0 0\r\n UNITS KILOMETERS\r\n INTERVALS 5\r\n STATUS ON\r\nEND','img/icons/desc_length.gif','maps'),(24,'New Layer','LAYER\r\n NAME\r\n TYPE\r\n STATUS ON\r\n DATA \"mydata\"\r\nEND #end of layer','images/ed_copy.gif','maps'),(25,'New Label','LABEL\r\n COLOR\r\n ANGLE\r\n FONT arial\r\n TYPE TRUETYPE\r\n POSITION\r\n PARTIALS TRUE\r\n SIZE 6\r\n BUFFER 0\r\n OUTLINECOLOR \r\nEND #end of label','img/icons/fontfamily.gif','maps'),(26,'New Reference','#\r\n#start of reference\r\n#\r\n REFERENCE\r\n SIZE 120 60\r\n STATUS ON\r\n EXTENT -180 -90 182 88\r\n OUTLINECOLOR 255 0 0\r\n IMAGE \"myimagedata\"\r\n COLOR -1 -1 -1\r\nEND','images/ed_image.gif','maps'),(27,'New Legend','#\r\n#start of Legend\r\n#\r\n LEGEND\r\n KEYSIZE 18 12\r\n POSTLABELCACHE TRUE\r\n STATUS ON\r\nEND','images/ed_about.gif','maps'),(28,'New Web','#\r\n# Start of web interface definition\r\n#\r\nWEB\r\n TEMPLATE \"myfile/url\"\r\n MINSCALE 1000\r\n MAXSCALE 40000\r\n IMAGEPATH \"myimagepath\"\r\n IMAGEURL \"mypath\"\r\nEND','img/icons/ico_link.gif','maps'),(29,'New Outputformat','OUTPUTFORMAT\r\n NAME\r\n DRIVER \" \"\r\n MIMETYPE \"myimagetype\"\r\n IMAGEMODE RGB\r\n EXTENSION \"png\"\r\nEND','img/icons/opera.gif','maps'),(30,'New Mapfile','#\r\n# Start of mapfile\r\n#\r\nNAME MYMAPFLE\r\n STATUS ON\r\nSIZE \r\nEXTENT\r\nUNITS \r\nSHAPEPATH \" \"\r\nIMAGETYPE \" \"\r\nFONTSET \" \"\r\nIMAGECOLOR -1 -1 -1\r\n\r\n#remove this text and add objects here\r\n\r\nEND # end of mapfile','img/icons/global.gif','maps'),(31,'bold','__text__','images/ed_format_bold.gif','newsletters'),(32,'italic','\'\'text\'\'','images/ed_format_italic.gif','newsletters'),(33,'underline','===text===','images/ed_format_underline.gif','newsletters'),(34,'external link','[http://example.com|text|nocache]','images/ed_link.gif','newsletters'),(35,'heading1','!text','images/ed_custom.gif','newsletters'),(36,'hr','---','images/ed_hr.gif','newsletters'),(37,'center text','::text::','images/ed_align_center.gif','newsletters'),(38,'colored text','~~#FF0000:text~~','images/fontfamily.gif','newsletters'),(39,'image','{img src= width= height= align= desc= link= }','images/ed_image.gif','newsletters'),(40,'New wms Metadata','METADATA\r\n		\"wms_name\" \"myname\"\r\n		\"wms_srs\" \"EPSG:4326\"\r\n	\"wms_server_version\" \" \"\r\n	\"wms_layers\" \"mylayers\"\r\n	\"wms_request\" \"myrequest\"\r\n	\"wms_format\" \" \"\r\n	\"wms_time\" \" \"\r\n END','img/icons/admin_metatags.png','maps'),(41,'New Class','CLASS\r\n EXPRESSION ()\r\n SYMBOL 0\r\n OUTLINECOLOR\r\n COLOR\r\n  NAME \"myclass\"\r\nEND #end of class','img/icons/mini_triangle.gif','maps'),(42,'New Query','#\r\n#Start of query definitions\r\n QUERYMAP\r\n STATUS ON\r\n STYLE HILITE\r\nEND','img/icons/question.gif','maps'),(43,'New Scalebar','#\r\n#start of scalebar\r\nSCALEBAR\r\n IMAGECOLOR 255 255 255\r\n STYLE 1\r\n SIZE 400 2\r\n COLOR 0 0 0\r\n  UNITS KILOMETERS\r\n INTERVALS 5\r\n STATUS ON\r\nEND','img/icons/desc_lenght.gif','maps'),(44,'New Layer','LAYER\r\n NAME \"mylayer\"\r\n TYPE\r\n STATUS ON\r\n DATA \"mydata\"\r\nEND #end of layer','img/ed_copy.gif','maps'),(45,'New Label','LABEL\r\n  COLOR\r\n ANGLE\r\n FONT arial\r\n TYPE TRUETYPE\r\n  POSITION\r\n  PARTIALS TRUE\r\n  SIZE 6\r\n  BUFFER 0\r\n OUTLINECOLOR\r\nEND #end of label','img/icons/fontfamily.gif','maps'),(46,'New Reference','#\r\n#start of reference\r\nREFERENCE\r\n SIZE 120 60\r\n STATUS ON\r\n  EXTENT -180 -90 182 88\r\n OUTLINECOLOR 255 0 0\r\n IMAGE \"myimagedata\"\r\nCOLOR -1 -1 -1\r\nEND','images/ed_image.gif','maps'),(47,'New Legend','#\r\n#start of legend\r\n#\r\nLEGENDr\n KEYSIZE 18 12\r\n POSTLABELCACHE TRUE\r\n STATUS ON\r\nEND','images/ed_about.gif','maps'),(48,'New Web','#\r\n#Start of web interface definition\r\n#\r\nWEB\r\n TEMPLATE \"myfile/url\"\r\n MINSCALE 1000\r\n MAXSCALE 40000\r\n IMAGEPATH \"myimagepath\"\r\n IMAGEURL \"mypath\"\r\nEND','img/icons/ico_link.gif','maps'),(49,'New Mapfile','#\r\n#Start of mapfile\r\n#\r\nNAME MYMAPFILE\r\n STATUS ON\r\nSIZE \r\nEXTENT\r\n UNITS\r\nSHAPEPATH \" \"\r\nIMAGETYPE \" \"\r\nFONTSET \" \"\r\nIMAGECOLOR -1 -1 -1\r\n\r\n#remove this text and add objects here\r\n\r\nEND # end of mapfile','img/icons/global.gif','maps');
/*!40000 ALTER TABLE `tiki_quicktags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_quiz_question_options`
--

DROP TABLE IF EXISTS `tiki_quiz_question_options`;
CREATE TABLE `tiki_quiz_question_options` (
  `optionId` int(10) NOT NULL auto_increment,
  `questionId` int(10) default NULL,
  `optionText` text,
  `points` int(4) default NULL,
  PRIMARY KEY  (`optionId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_quiz_question_options`
--

LOCK TABLES `tiki_quiz_question_options` WRITE;
/*!40000 ALTER TABLE `tiki_quiz_question_options` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_quiz_question_options` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_quiz_questions`
--

DROP TABLE IF EXISTS `tiki_quiz_questions`;
CREATE TABLE `tiki_quiz_questions` (
  `questionId` int(10) NOT NULL auto_increment,
  `quizId` int(10) default NULL,
  `question` text,
  `position` int(4) default NULL,
  `type` char(1) default NULL,
  `maxPoints` int(4) default NULL,
  PRIMARY KEY  (`questionId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_quiz_questions`
--

LOCK TABLES `tiki_quiz_questions` WRITE;
/*!40000 ALTER TABLE `tiki_quiz_questions` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_quiz_questions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_quiz_results`
--

DROP TABLE IF EXISTS `tiki_quiz_results`;
CREATE TABLE `tiki_quiz_results` (
  `resultId` int(10) NOT NULL auto_increment,
  `quizId` int(10) default NULL,
  `fromPoints` int(4) default NULL,
  `toPoints` int(4) default NULL,
  `answer` text,
  PRIMARY KEY  (`resultId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_quiz_results`
--

LOCK TABLES `tiki_quiz_results` WRITE;
/*!40000 ALTER TABLE `tiki_quiz_results` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_quiz_results` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_quiz_stats`
--

DROP TABLE IF EXISTS `tiki_quiz_stats`;
CREATE TABLE `tiki_quiz_stats` (
  `quizId` int(10) NOT NULL default '0',
  `questionId` int(10) NOT NULL default '0',
  `optionId` int(10) NOT NULL default '0',
  `votes` int(10) default NULL,
  PRIMARY KEY  (`quizId`,`questionId`,`optionId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_quiz_stats`
--

LOCK TABLES `tiki_quiz_stats` WRITE;
/*!40000 ALTER TABLE `tiki_quiz_stats` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_quiz_stats` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_quiz_stats_sum`
--

DROP TABLE IF EXISTS `tiki_quiz_stats_sum`;
CREATE TABLE `tiki_quiz_stats_sum` (
  `quizId` int(10) NOT NULL default '0',
  `quizName` varchar(255) default NULL,
  `timesTaken` int(10) default NULL,
  `avgpoints` decimal(5,2) default NULL,
  `avgavg` decimal(5,2) default NULL,
  `avgtime` decimal(5,2) default NULL,
  PRIMARY KEY  (`quizId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_quiz_stats_sum`
--

LOCK TABLES `tiki_quiz_stats_sum` WRITE;
/*!40000 ALTER TABLE `tiki_quiz_stats_sum` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_quiz_stats_sum` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_quizzes`
--

DROP TABLE IF EXISTS `tiki_quizzes`;
CREATE TABLE `tiki_quizzes` (
  `quizId` int(10) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `description` text,
  `canRepeat` char(1) default NULL,
  `storeResults` char(1) default NULL,
  `questionsPerPage` int(4) default NULL,
  `timeLimited` char(1) default NULL,
  `timeLimit` int(14) default NULL,
  `created` int(14) default NULL,
  `taken` int(10) default NULL,
  `immediateFeedback` char(1) default NULL,
  `showAnswers` char(1) default NULL,
  `shuffleQuestions` char(1) default NULL,
  `shuffleAnswers` char(1) default NULL,
  `publishDate` int(14) default NULL,
  `expireDate` int(14) default NULL,
  `bDeleted` char(1) default NULL,
  `nVersion` int(4) NOT NULL default '0',
  `nAuthor` int(4) default NULL,
  `bOnline` char(1) default NULL,
  `bRandomQuestions` char(1) default NULL,
  `nRandomQuestions` tinyint(4) default NULL,
  `bLimitQuestionsPerPage` char(1) default NULL,
  `nLimitQuestionsPerPage` tinyint(4) default NULL,
  `bMultiSession` char(1) default NULL,
  `nCanRepeat` tinyint(4) default NULL,
  `sGradingMethod` varchar(80) default NULL,
  `sShowScore` varchar(80) default NULL,
  `sShowCorrectAnswers` varchar(80) default NULL,
  `sPublishStats` varchar(80) default NULL,
  `bAdditionalQuestions` char(1) default NULL,
  `bForum` char(1) default NULL,
  `sForum` varchar(80) default NULL,
  `sPrologue` text,
  `sData` text,
  `sEpilogue` text,
  `passingperct` int(4) default '0',
  PRIMARY KEY  (`quizId`,`nVersion`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_quizzes`
--

LOCK TABLES `tiki_quizzes` WRITE;
/*!40000 ALTER TABLE `tiki_quizzes` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_quizzes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_received_articles`
--

DROP TABLE IF EXISTS `tiki_received_articles`;
CREATE TABLE `tiki_received_articles` (
  `receivedArticleId` int(14) NOT NULL auto_increment,
  `receivedFromSite` varchar(200) default NULL,
  `receivedFromUser` varchar(200) default NULL,
  `receivedDate` int(14) default NULL,
  `title` varchar(80) default NULL,
  `authorName` varchar(60) default NULL,
  `size` int(12) default NULL,
  `useImage` char(1) default NULL,
  `image_name` varchar(80) 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` longblob,
  `hash` varchar(32) default NULL,
  `author` varchar(200) default NULL,
  `type` varchar(50) default NULL,
  `rating` decimal(3,2) default NULL,
  PRIMARY KEY  (`receivedArticleId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_received_articles`
--

LOCK TABLES `tiki_received_articles` WRITE;
/*!40000 ALTER TABLE `tiki_received_articles` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_received_articles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_received_pages`
--

DROP TABLE IF EXISTS `tiki_received_pages`;
CREATE TABLE `tiki_received_pages` (
  `receivedPageId` int(14) NOT NULL auto_increment,
  `pageName` varchar(160) NOT NULL default '',
  `data` longblob,
  `description` varchar(200) default NULL,
  `comment` varchar(200) default NULL,
  `receivedFromSite` varchar(200) default NULL,
  `receivedFromUser` varchar(200) default NULL,
  `receivedDate` int(14) default NULL,
  PRIMARY KEY  (`receivedPageId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tiki_received_pages`
--

LOCK TABLES `tiki_received_pages` WRITE;
/*!40000 ALTER TABLE `tiki_received_pages` DISABLE KEYS */;
/*!40000 ALTER TABLE `tiki_received_pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiki_referer_stats`
--

DROP TABLE IF EXISTS `tiki_referer_stats`;
CREATE TABLE `tiki_referer_stats` (
  `referer` varchar(255) NOT NULL defa