1-- -------------------------------------------------------- 2-- Database : Tiki 3-- -------------------------------------------------------- 4 5ALTER DATABASE DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; 6SET FOREIGN_KEY_CHECKS = 0; /* tiki doesn't officially use foreign keys but sometimes they "appear", leading to table dropping errors */ 7 8DROP TABLE IF EXISTS `messu_messages`; 9CREATE TABLE `messu_messages` ( 10 `msgId` int(14) NOT NULL auto_increment, 11 `user` varchar(200) NOT NULL default '', 12 `user_from` varchar(200) NOT NULL default '', 13 `user_to` text, 14 `user_cc` text, 15 `user_bcc` text, 16 `subject` varchar(255) default NULL, 17 `body` text, 18 `hash` varchar(32) default NULL, 19 `replyto_hash` varchar(32) default NULL, 20 `date` int(14) default NULL, 21 `isRead` char(1) default NULL, 22 `isReplied` char(1) default NULL, 23 `isFlagged` char(1) default NULL, 24 `priority` int(2) default NULL, 25 PRIMARY KEY (`msgId`), 26 KEY `userIsRead` (user(190), `isRead`) 27) ENGINE=MyISAM AUTO_INCREMENT=1 ; 28 29DROP TABLE IF EXISTS `messu_archive`; 30CREATE TABLE `messu_archive` ( 31 `msgId` int(14) NOT NULL auto_increment, 32 `user` varchar(40) NOT NULL default '', 33 `user_from` varchar(40) NOT NULL default '', 34 `user_to` text, 35 `user_cc` text, 36 `user_bcc` text, 37 `subject` varchar(255) default NULL, 38 `body` text, 39 `hash` varchar(32) default NULL, 40 `replyto_hash` varchar(32) default NULL, 41 `date` int(14) default NULL, 42 `isRead` char(1) default NULL, 43 `isReplied` char(1) default NULL, 44 `isFlagged` char(1) default NULL, 45 `priority` int(2) default NULL, 46 PRIMARY KEY (`msgId`) 47) ENGINE=MyISAM AUTO_INCREMENT=1 ; 48 49DROP TABLE IF EXISTS `messu_sent`; 50CREATE TABLE `messu_sent` ( 51 `msgId` int(14) NOT NULL auto_increment, 52 `user` varchar(40) NOT NULL default '', 53 `user_from` varchar(40) NOT NULL default '', 54 `user_to` text, 55 `user_cc` text, 56 `user_bcc` text, 57 `subject` varchar(255) default NULL, 58 `body` text, 59 `hash` varchar(32) default NULL, 60 `replyto_hash` varchar(32) default NULL, 61 `date` int(14) default NULL, 62 `isRead` char(1) default NULL, 63 `isReplied` char(1) default NULL, 64 `isFlagged` char(1) default NULL, 65 `priority` int(2) default NULL, 66 PRIMARY KEY (`msgId`) 67) ENGINE=MyISAM AUTO_INCREMENT=1 ; 68 69DROP TABLE IF EXISTS `sessions`; 70CREATE TABLE `sessions` ( 71 `sesskey` char(32) NOT NULL, 72 `expiry` int(11) unsigned NOT NULL, 73 `expireref` varchar(64), 74 `data` text NOT NULL, 75 PRIMARY KEY (`sesskey`), 76 KEY `expiry` (expiry) 77) ENGINE=MyISAM; 78 79DROP TABLE IF EXISTS `tiki_actionlog`; 80CREATE TABLE `tiki_actionlog` ( 81 `actionId` int(8) NOT NULL auto_increment, 82 `action` varchar(255) NOT NULL default '', 83 `lastModif` int(14) default NULL, 84 `object` varchar(255) default NULL, 85 `objectType` varchar(32) NOT NULL default '', 86 `user` varchar(200) default '', 87 `ip` varchar(39) default NULL, 88 `comment` text default NULL, 89 `categId` int(12) NOT NULL default '0', 90 `client` VARCHAR( 200 ) NULL DEFAULT NULL, 91 `log` LONGTEXT NULL DEFAULT NULL, 92 PRIMARY KEY (`actionId`), 93 KEY `lastModif` (`lastModif`), 94 KEY `object` (`object`(100), `objectType`, `action`(100)) 95) ENGINE=MyISAM; 96 97DROP TABLE IF EXISTS `tiki_actionlog_params`; 98CREATE TABLE `tiki_actionlog_params` ( 99 `actionId` int(8) NOT NULL, 100 `name` varchar(40) NOT NULL, 101 `value` text, 102 KEY `actionId` (`actionId`), 103 KEY `nameValue` (`name`, `value`(151)) 104) ENGINE=MyISAM; 105 106DROP TABLE IF EXISTS `tiki_activity_stream`; 107CREATE TABLE `tiki_activity_stream` ( 108 `activityId` int(8) NOT NULL auto_increment, 109 `eventType` varchar(100) NOT NULL, 110 `eventDate` int NOT NULL, 111 `arguments` BLOB, 112 PRIMARY KEY(`activityId`) 113) ENGINE=MyISAM; 114 115DROP TABLE IF EXISTS `tiki_activity_stream_mapping`; 116CREATE TABLE `tiki_activity_stream_mapping` ( 117 `field_name` varchar(50) NOT NULL, 118 `field_type` varchar(15) NOT NULL, 119 PRIMARY KEY(`field_name`) 120) ENGINE=MyISAM; 121 122DROP TABLE IF EXISTS `tiki_activity_stream_rules`; 123CREATE TABLE `tiki_activity_stream_rules` ( 124 `ruleId` int(8) NOT NULL auto_increment, 125 `eventType` varchar(100) NOT NULL, 126 `ruleType` varchar(20) NOT NULL, 127 `rule` TEXT, 128 `notes` TEXT, 129 PRIMARY KEY(`ruleId`) 130) ENGINE=MyISAM; 131 132DROP TABLE IF EXISTS `tiki_address_books`; 133CREATE TABLE `tiki_address_books` ( 134 `addressBookId` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, 135 `user` VARCHAR(200), 136 `name` VARCHAR(255), 137 `uri` VARBINARY(200), 138 `description` TEXT, 139 UNIQUE(`user`(141), `uri`) 140) ENGINE=MyISAM; 141 142DROP TABLE IF EXISTS `tiki_address_cards`; 143CREATE TABLE `tiki_address_cards` ( 144 `addressCardId` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, 145 `addressBookId` INT UNSIGNED NOT NULL, 146 `carddata` MEDIUMBLOB, 147 `uri` VARBINARY(200), 148 `lastmodified` INT(11) UNSIGNED, 149 `etag` VARBINARY(32), 150 `size` INT(11) UNSIGNED NOT NULL, 151 INDEX(`addressBookId`, `uri`) 152) ENGINE=MyISAM; 153 154DROP TABLE IF EXISTS `tiki_articles`; 155CREATE TABLE `tiki_articles` ( 156 `articleId` int(8) NOT NULL auto_increment, 157 `topline` varchar(255) default NULL, 158 `title` varchar(255) default NULL, 159 `subtitle` varchar(255) default NULL, 160 `linkto` varchar(255) default NULL, 161 `lang` varchar(16) default NULL, 162 `state` char(1) default 's', 163 `authorName` varchar(60) default NULL, 164 `topicId` int(14) default NULL, 165 `topicName` varchar(40) default NULL, 166 `size` int(12) default NULL, 167 `useImage` char(1) default NULL, 168 `image_name` varchar(80) default NULL, 169 `image_caption` text default NULL, 170 `image_type` varchar(80) default NULL, 171 `image_size` int(14) default NULL, 172 `image_x` int(4) default NULL, 173 `image_y` int(4) default NULL, 174 `list_image_x` int(4) default NULL, 175 `list_image_y` int(4) default NULL, 176 `image_data` longblob, 177 `publishDate` int(14) default NULL, 178 `expireDate` int(14) default NULL, 179 `created` int(14) default NULL, 180 `heading` text, 181 `body` text, 182 `author` varchar(200) default NULL, 183 `nbreads` int(14) default NULL, 184 `votes` int(8) default NULL, 185 `points` int(14) default NULL, 186 `type` varchar(50) default NULL, 187 `rating` decimal(3,2) default NULL, 188 `isfloat` char(1) default NULL, 189 `ispublished` char(1) NOT NULL DEFAULT 'y', 190 PRIMARY KEY (`articleId`), 191 KEY `title` (`title` (191)), 192 KEY `heading` (`heading`(191)), 193 KEY `body` (`body`(191)), 194 KEY `nbreads` (`nbreads`), 195 KEY `author` (`author`(32)), 196 KEY `topicId` (`topicId`), 197 KEY `publishDate` (`publishDate`), 198 KEY `expireDate` (`expireDate`), 199 KEY `type` (`type`) 200) ENGINE=MyISAM AUTO_INCREMENT=1 ; 201 202DROP TABLE IF EXISTS `tiki_article_types`; 203CREATE TABLE `tiki_article_types` ( 204 `type` varchar(50) NOT NULL, 205 `use_ratings` varchar(1) default NULL, 206 `show_pre_publ` varchar(1) default NULL, 207 `show_post_expire` varchar(1) default 'y', 208 `heading_only` varchar(1) default NULL, 209 `allow_comments` varchar(1) default 'y', 210 `show_image` varchar(1) default 'y', 211 `show_avatar` varchar(1) default NULL, 212 `show_author` varchar(1) default 'y', 213 `show_pubdate` varchar(1) default 'y', 214 `show_expdate` varchar(1) default NULL, 215 `show_reads` varchar(1) default 'y', 216 `show_size` varchar(1) default 'n', 217 `show_topline` varchar(1) default 'n', 218 `show_subtitle` varchar(1) default 'n', 219 `show_linkto` varchar(1) default 'n', 220 `show_image_caption` varchar(1) default 'n', 221 `creator_edit` varchar(1) default NULL, 222 `comment_can_rate_article` char(1) default NULL, 223 PRIMARY KEY (`type`), 224 KEY `show_pre_publ` (`show_pre_publ`), 225 KEY `show_post_expire` (`show_post_expire`) 226) ENGINE=MyISAM ; 227 228INSERT IGNORE INTO tiki_article_types(type) VALUES ('Article'); 229INSERT IGNORE INTO tiki_article_types(type,use_ratings) VALUES ('Review','y'); 230INSERT IGNORE INTO tiki_article_types(type,show_post_expire) VALUES ('Event','n'); 231INSERT IGNORE INTO tiki_article_types(type,show_post_expire,heading_only,allow_comments) VALUES ('Classified','n','y','n'); 232 233DROP TABLE IF EXISTS `tiki_banners`; 234CREATE TABLE `tiki_banners` ( 235 `bannerId` int(12) NOT NULL auto_increment, 236 `client` varchar(200) NOT NULL default '', 237 `url` varchar(255) default NULL, 238 `title` varchar(255) default NULL, 239 `alt` varchar(250) default NULL, 240 `which` varchar(50) default NULL, 241 `imageData` longblob, 242 `imageType` varchar(200) default NULL, 243 `imageName` varchar(100) default NULL, 244 `HTMLData` text, 245 `fixedURLData` varchar(255) default NULL, 246 `textData` text, 247 `fromDate` int(14) default NULL, 248 `toDate` int(14) default NULL, 249 `useDates` char(1) default NULL, 250 `mon` char(1) default NULL, 251 `tue` char(1) default NULL, 252 `wed` char(1) default NULL, 253 `thu` char(1) default NULL, 254 `fri` char(1) default NULL, 255 `sat` char(1) default NULL, 256 `sun` char(1) default NULL, 257 `hourFrom` varchar(4) default NULL, 258 `hourTo` varchar(4) default NULL, 259 `created` int(14) default NULL, 260 `maxImpressions` int(8) default NULL, 261 `impressions` int(8) default NULL, 262 `maxUserImpressions` int(8) default -1, 263 `maxClicks` int(8) default NULL, 264 `clicks` int(8) default NULL, 265 `zone` varchar(40) default NULL, 266 `onlyInURIs` text, 267 `exceptInURIs` text, 268 PRIMARY KEY (`bannerId`), 269 INDEX ban1(zone,`useDates`,impressions,`maxImpressions`,`hourFrom`,`hourTo`,`fromDate`,`toDate`,mon,tue,wed,thu,fri,sat,sun) 270) ENGINE=MyISAM AUTO_INCREMENT=1 ; 271 272DROP TABLE IF EXISTS `tiki_banning`; 273CREATE TABLE `tiki_banning` ( 274 `banId` int(12) NOT NULL auto_increment, 275 `mode` enum('user','ip') default NULL, 276 `title` varchar(200) default NULL, 277 `ip1` char(3) default NULL, 278 `ip2` char(3) default NULL, 279 `ip3` char(3) default NULL, 280 `ip4` char(3) default NULL, 281 `user` varchar(200) default '', 282 `date_from` timestamp NULL, 283 `date_to` timestamp NULL, 284 `use_dates` char(1) default NULL, 285 `created` int(14) default NULL, 286 `message` text, 287 PRIMARY KEY (`banId`), 288 INDEX ban(`use_dates`, `date_from`, `date_to`) 289) ENGINE=MyISAM AUTO_INCREMENT=1 ; 290 291DROP TABLE IF EXISTS `tiki_banning_sections`; 292CREATE TABLE `tiki_banning_sections` ( 293 `banId` int(12) NOT NULL default '0', 294 `section` varchar(100) NOT NULL default '', 295 PRIMARY KEY (`banId`,`section`) 296) ENGINE=MyISAM; 297 298DROP TABLE IF EXISTS `tiki_blog_activity`; 299CREATE TABLE `tiki_blog_activity` ( 300 `blogId` int(8) NOT NULL default '0', 301 `day` int(14) NOT NULL default '0', 302 `posts` int(8) default NULL, 303 PRIMARY KEY (`blogId`,`day`) 304) ENGINE=MyISAM; 305 306DROP TABLE IF EXISTS `tiki_blog_posts`; 307CREATE TABLE `tiki_blog_posts` ( 308 `postId` int(8) NOT NULL auto_increment, 309 `blogId` int(8) NOT NULL default '0', 310 `data` text, 311 `data_size` int(11) unsigned NOT NULL default '0', 312 `excerpt` text default NULL, 313 `created` int(14) default NULL, 314 `user` varchar(200) default '', 315 `hits` bigint NULL default '0', 316 `trackbacks_to` text, 317 `trackbacks_from` text, 318 `title` varchar(255) default NULL, 319 `priv` varchar(1) default 'n', 320 `wysiwyg` varchar(1) default NULL, 321 PRIMARY KEY (`postId`), 322 KEY `data` (`data`(191)), 323 KEY `blogId` (`blogId`), 324 KEY `created` (`created`) 325) ENGINE=MyISAM AUTO_INCREMENT=1 ; 326 327DROP TABLE IF EXISTS `tiki_blog_posts_images`; 328CREATE TABLE `tiki_blog_posts_images` ( 329 `imgId` int(14) NOT NULL auto_increment, 330 `postId` int(14) NOT NULL default '0', 331 `filename` varchar(80) default NULL, 332 `filetype` varchar(80) default NULL, 333 `filesize` int(14) default NULL, 334 `data` longblob, 335 PRIMARY KEY (`imgId`) 336) ENGINE=MyISAM AUTO_INCREMENT=1 ; 337 338DROP TABLE IF EXISTS `tiki_blogs`; 339CREATE TABLE `tiki_blogs` ( 340 `blogId` int(8) NOT NULL auto_increment, 341 `created` int(14) default NULL, 342 `lastModif` int(14) default NULL, 343 `title` varchar(200) default NULL, 344 `description` text, 345 `user` varchar(200) default '', 346 `public` char(1) default NULL, 347 `posts` int(8) default NULL, 348 `maxPosts` int(8) default NULL, 349 `hits` int(8) default NULL, 350 `activity` decimal(4,2) default NULL, 351 `heading` text, 352 `post_heading` text, 353 `use_find` char(1) default NULL, 354 `use_title` char(1) default 'y', 355 `use_title_in_post` char(1) default 'y', 356 `use_description` char(1) default 'y', 357 `use_breadcrumbs` char(1) default 'n', 358 `use_author` char(1) default NULL, 359 `use_excerpt` char(1) default NULL, 360 `add_date` char(1) default NULL, 361 `add_poster` char(1) default NULL, 362 `allow_comments` char(1) default NULL, 363 `show_avatar` char(1) default NULL, 364 `always_owner` char(1) default NULL, 365 `show_related` char(1) default NULL, 366 `related_max` int(4) default 5, 367 PRIMARY KEY (`blogId`), 368 KEY `title` (`title`(191)), 369 KEY `description` (`description`(191)), 370 KEY `hits` (`hits`) 371) ENGINE=MyISAM AUTO_INCREMENT=1 ; 372 373DROP TABLE IF EXISTS `tiki_calendar_categories`; 374CREATE TABLE `tiki_calendar_categories` ( 375 `calcatId` int(11) NOT NULL auto_increment, 376 `calendarId` int(14) NOT NULL default '0', 377 `name` varchar(255) NOT NULL default '', 378 PRIMARY KEY (`calcatId`), 379 UNIQUE KEY `catname` (`calendarId`, `name`(16)) 380) ENGINE=MyISAM AUTO_INCREMENT=1 ; 381 382DROP TABLE IF EXISTS `tiki_calendar_recurrence`; 383CREATE TABLE `tiki_calendar_recurrence` ( 384 `recurrenceId` int(14) NOT NULL auto_increment, 385 `calendarId` int(14) NOT NULL default '0', 386 `start` int(4) NOT NULL default '0', 387 `end` int(4) NOT NULL default '2359', 388 `allday` tinyint(1) NOT NULL default '0', 389 `locationId` int(14) default NULL, 390 `categoryId` int(14) default NULL, 391 `nlId` int(12) NOT NULL default '0', 392 `priority` enum('1','2','3','4','5','6','7','8','9') NOT NULL default '1', 393 `status` enum('0','1','2') NOT NULL default '0', 394 `url` varchar(255) default NULL, 395 `lang` char(16) NOT NULL default 'en', 396 `name` varchar(255) NOT NULL default '', 397 `description` blob, 398 `weekly` tinyint(1) default '0', 399 `weekday` tinyint(1), 400 `monthly` tinyint(1) default '0', 401 `dayOfMonth` int(2), 402 `yearly` tinyint(1) default '0', 403 `dateOfYear` int(4), 404 `nbRecurrences` int(8), 405 `startPeriod` int(14), 406 `endPeriod` int(14), 407 `user` varchar(200) default '', 408 `created` int(14) NOT NULL default '0', 409 `lastmodif` int(14) NOT NULL default '0', 410 `uid` varchar(200), 411 `uri` varchar(200), 412 PRIMARY KEY (`recurrenceId`), 413 KEY `calendarId` (`calendarId`) 414) ENGINE=MyISAM AUTO_INCREMENT=1 ; 415 416DROP TABLE IF EXISTS `tiki_calendar_items`; 417CREATE TABLE `tiki_calendar_items` ( 418 `calitemId` int(14) NOT NULL auto_increment, 419 `calendarId` int(14) NOT NULL default '0', 420 `start` int(14) NOT NULL default '0', 421 `end` int(14) NOT NULL default '0', 422 `locationId` int(14) default NULL, 423 `categoryId` int(14) default NULL, 424 `nlId` int(12) NOT NULL default '0', 425 `priority` enum('0', '1','2','3','4','5','6','7','8','9') default '0', 426 `status` enum('0','1','2') NOT NULL default '0', 427 `url` varchar(255) default NULL, 428 `lang` char(16) NOT NULL default 'en', 429 `name` varchar(255) NOT NULL default '', 430 `description` text, 431 `recurrenceId` int(14), 432 `changed` tinyint(1) DEFAULT '0', 433 `recurrenceStart` int(14) default NULL, 434 `user` varchar(200) default '', 435 `created` int(14) NOT NULL default '0', 436 `lastmodif` int(14) NOT NULL default '0', 437 `allday` tinyint(1) NOT NULL default '0', 438 `uid` varchar(200), 439 `uri` varchar(200), 440 PRIMARY KEY (`calitemId`), 441 KEY `calendarId` (`calendarId`) 442) ENGINE=MyISAM AUTO_INCREMENT=1 ; 443 444DROP TABLE IF EXISTS `tiki_calendar_locations`; 445CREATE TABLE `tiki_calendar_locations` ( 446 `callocId` int(14) NOT NULL auto_increment, 447 `calendarId` int(14) NOT NULL default '0', 448 `name` varchar(255) NOT NULL default '', 449 `description` blob, 450 PRIMARY KEY (`callocId`), 451 UNIQUE KEY `locname` (`calendarId`, `name`(16)) 452) ENGINE=MyISAM AUTO_INCREMENT=1 ; 453 454DROP TABLE IF EXISTS `tiki_calendar_roles`; 455CREATE TABLE `tiki_calendar_roles` ( 456 `calitemId` int(14) NOT NULL default '0', 457 `username` varchar(200) NOT NULL default '', 458 `role` enum('0','1','2','3','6') NOT NULL default '0', 459 `partstat` VARCHAR(30) NULL DEFAULT NULL, 460 PRIMARY KEY (`calitemId`,`username`(16),`role`) 461) ENGINE=MyISAM; 462 463DROP TABLE IF EXISTS `tiki_calendars`; 464CREATE TABLE `tiki_calendars` ( 465 `calendarId` int(14) NOT NULL auto_increment, 466 `name` varchar(80) NOT NULL default '', 467 `description` varchar(255) default NULL, 468 `user` varchar(200) NOT NULL default '', 469 `customlocations` enum('n','y') NOT NULL default 'n', 470 `customcategories` enum('n','y') NOT NULL default 'n', 471 `customlanguages` enum('n','y') NOT NULL default 'n', 472 `custompriorities` enum('n','y') NOT NULL default 'n', 473 `customparticipants` enum('n','y') NOT NULL default 'n', 474 `customsubscription` enum('n','y') NOT NULL default 'n', 475 `customstatus` enum('n','y') NOT NULL default 'y', 476 `created` int(14) NOT NULL default '0', 477 `lastmodif` int(14) NOT NULL default '0', 478 `personal` enum ('n', 'y') NOT NULL default 'n', 479 PRIMARY KEY (`calendarId`) 480) ENGINE=MyISAM ; 481 482DROP TABLE IF EXISTS `tiki_calendar_changes`; 483CREATE TABLE `tiki_calendar_changes` ( 484 changeId INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, 485 calitemId INT(11) UNSIGNED NOT NULL, 486 synctoken INT(11) UNSIGNED NOT NULL, 487 calendarId INT(11) UNSIGNED NOT NULL, 488 operation TINYINT(1) NOT NULL, 489 INDEX (calendarId, synctoken), 490 INDEX (calitemId) 491) ENGINE=MyISAM; 492 493DROP TABLE IF EXISTS `tiki_calendar_instances`; 494CREATE TABLE `tiki_calendar_instances` ( 495 calendarInstanceId INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, 496 calendarId INT UNSIGNED NOT NULL, 497 user VARCHAR(200), 498 access TINYINT(1) NOT NULL DEFAULT '1' COMMENT '1 = owner, 2 = read, 3 = readwrite', 499 name VARCHAR(100), 500 uri VARBINARY(200), 501 description TEXT, 502 `order` INT(11) UNSIGNED NOT NULL DEFAULT '0', 503 color VARBINARY(10), 504 timezone TEXT, 505 transparent TINYINT(1) NOT NULL DEFAULT '0', 506 share_href VARBINARY(100), 507 share_name VARCHAR(100), 508 share_invite_status TINYINT(1) NOT NULL DEFAULT '2' COMMENT '1 = noresponse, 2 = accepted, 3 = declined, 4 = invalid', 509 UNIQUE(user(141), uri), 510 UNIQUE(calendarid, user(189)), 511 UNIQUE(calendarid, share_href) 512) ENGINE=MyISAM; 513 514DROP TABLE IF EXISTS `tiki_calendar_options`; 515CREATE TABLE `tiki_calendar_options` ( 516 `calendarId` int(14) NOT NULL default 0, 517 `optionName` varchar(120) NOT NULL default '', 518 `value` varchar(255), 519 PRIMARY KEY (`calendarId`,`optionName`) 520) ENGINE=MyISAM ; 521 522DROP TABLE IF EXISTS `tiki_calendar_scheduling_objects`; 523CREATE TABLE `tiki_calendar_scheduling_objects` ( 524 schedulingObjectId INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, 525 user VARCHAR(200), 526 calendardata MEDIUMBLOB, 527 uri VARBINARY(200), 528 lastmodif INT(11) UNSIGNED, 529 etag VARBINARY(32), 530 size INT(11) UNSIGNED NOT NULL 531) ENGINE=MyISAM; 532 533DROP TABLE IF EXISTS `tiki_calendar_subscriptions`; 534CREATE TABLE `tiki_calendar_subscriptions` ( 535 subscriptionId INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, 536 calendarId INT(11) UNSIGNED NOT NULL, 537 user VARCHAR(200) NOT NULL, 538 source TEXT, 539 name VARCHAR(100), 540 refresh_rate VARCHAR(10), 541 `order` INT(11) UNSIGNED NOT NULL DEFAULT '0', 542 color VARBINARY(10), 543 strip_todos TINYINT(1) NULL, 544 strip_alarms TINYINT(1) NULL, 545 strip_attachments TINYINT(1) NULL, 546 lastmodif INT(11) UNSIGNED, 547 UNIQUE(user(189), calendarId) 548) ENGINE=MyISAM; 549 550DROP TABLE IF EXISTS `tiki_categories`; 551CREATE TABLE `tiki_categories` ( 552 `categId` int(12) NOT NULL auto_increment, 553 `name` varchar(200) default NULL, 554 `description` varchar(500) default NULL, 555 `parentId` int(12) default NULL, 556 `rootId` int NOT NULL DEFAULT 0, 557 `hits` int(8) default NULL, 558 `tplGroupContainerId` int(12) default NULL, 559 `tplGroupPattern` varchar(200) default NULL, 560 PRIMARY KEY (`categId`) 561) ENGINE=MyISAM AUTO_INCREMENT=1 ; 562 563DROP TABLE IF EXISTS `tiki_categories_roles`; 564CREATE TABLE `tiki_categories_roles` ( 565 `categId` int(12) NOT NULL, 566 `categRoleId` int(12) NOT NULL, 567 `groupRoleId` int(12) NOT NULL, 568 `groupId` int(12) NOT NULL, 569 PRIMARY KEY (`categId`,`categRoleId`,`groupRoleId`) 570) ENGINE=MyISAM; 571 572DROP TABLE IF EXISTS `tiki_categories_roles_available`; 573CREATE TABLE `tiki_categories_roles_available` ( 574 `categId` int(12) NOT NULL, 575 `categRoleId` int(12) NOT NULL, 576 PRIMARY KEY (`categId`,`categRoleId`) 577) ENGINE=MyISAM; 578 579DROP TABLE IF EXISTS `tiki_objects`; 580CREATE TABLE `tiki_objects` ( 581 `objectId` int(12) NOT NULL auto_increment, 582 `type` varchar(50) default NULL, 583 `itemId` varchar(255) default NULL, 584 `description` text, 585 `created` int(14) default NULL, 586 `name` varchar(200) default NULL, 587 `href` varchar(256) default NULL, 588 `hits` int(8) default NULL, 589 `comments_locked` char(1) NOT NULL default 'n', 590 PRIMARY KEY (`objectId`), 591 KEY (`type`, `objectId`), 592 KEY (`itemId`(141), `type`) 593) ENGINE=MyISAM AUTO_INCREMENT=1 ; 594 595DROP TABLE IF EXISTS `tiki_categorized_objects`; 596CREATE TABLE `tiki_categorized_objects` ( 597 `catObjectId` int(11) NOT NULL default '0', 598 PRIMARY KEY (`catObjectId`) 599) ENGINE=MyISAM ; 600 601DROP TABLE IF EXISTS `tiki_category_objects`; 602CREATE TABLE `tiki_category_objects` ( 603 `catObjectId` int(12) NOT NULL default '0', 604 `categId` int(12) NOT NULL default '0', 605 PRIMARY KEY (`catObjectId`,`categId`) 606) ENGINE=MyISAM; 607 608DROP TABLE IF EXISTS `tiki_object_ratings`; 609CREATE TABLE `tiki_object_ratings` ( 610 `catObjectId` int(12) NOT NULL default '0', 611 `pollId` int(12) NOT NULL default '0', 612 PRIMARY KEY (`catObjectId`,`pollId`) 613) ENGINE=MyISAM; 614 615DROP TABLE IF EXISTS `tiki_category_sites`; 616CREATE TABLE `tiki_category_sites` ( 617 `categId` int(10) NOT NULL default '0', 618 `siteId` int(14) NOT NULL default '0', 619 PRIMARY KEY (`categId`,`siteId`) 620) ENGINE=MyISAM; 621 622DROP TABLE IF EXISTS `tiki_chat_channels`; 623CREATE TABLE `tiki_chat_channels` ( 624 `channelId` int(8) NOT NULL auto_increment, 625 `name` varchar(30) default NULL, 626 `description` varchar(250) default NULL, 627 `max_users` int(8) default NULL, 628 `mode` char(1) default NULL, 629 `moderator` varchar(200) default NULL, 630 `active` char(1) default NULL, 631 `refresh` int(6) default NULL, 632 PRIMARY KEY (`channelId`) 633) ENGINE=MyISAM AUTO_INCREMENT=1 ; 634 635DROP TABLE IF EXISTS `tiki_chat_messages`; 636CREATE TABLE `tiki_chat_messages` ( 637 `messageId` int(8) NOT NULL auto_increment, 638 `channelId` int(8) NOT NULL default '0', 639 `data` varchar(255) default NULL, 640 `poster` varchar(200) NOT NULL default 'anonymous', 641 `timestamp` int(14) default NULL, 642 PRIMARY KEY (`messageId`) 643) ENGINE=MyISAM AUTO_INCREMENT=1 ; 644 645DROP TABLE IF EXISTS `tiki_chat_users`; 646CREATE TABLE `tiki_chat_users` ( 647 `nickname` varchar(200) NOT NULL default '', 648 `channelId` int(8) NOT NULL default '0', 649 `timestamp` int(14) default NULL, 650 PRIMARY KEY (`nickname`(183),`channelId`) 651) ENGINE=MyISAM; 652 653DROP TABLE IF EXISTS `tiki_comments`; 654CREATE TABLE `tiki_comments` ( 655 `threadId` int(14) NOT NULL auto_increment, 656 `object` varchar(255) NOT NULL default '', 657 `objectType` varchar(32) NOT NULL default '', 658 `parentId` int(14) default NULL, 659 `userName` varchar(200) default '', 660 `commentDate` int(14) default NULL, 661 `hits` int(8) default NULL, 662 `type` char(1) default NULL, 663 `points` decimal(8,2) default NULL, 664 `votes` int(8) default NULL, 665 `average` decimal(8,4) default NULL, 666 `title` varchar(255) default NULL, 667 `data` text, 668 `hash` varchar(32) default NULL, 669 `email` varchar(200) default NULL, 670 `website` varchar(200) default NULL, 671 `user_ip` varchar(39) default NULL, 672 `summary` varchar(240) default NULL, 673 `smiley` varchar(80) default NULL, 674 `message_id` varchar(128) default NULL, 675 `in_reply_to` varchar(128) default NULL, 676 `comment_rating` tinyint(2) default NULL, 677 `archived` char(1) default NULL, 678 `approved` char(1) NOT NULL default 'y', 679 `locked` char(1) NOT NULL default 'n', 680 PRIMARY KEY (`threadId`), 681 UNIQUE KEY `no_repeats` (`parentId`, `userName`(40), `title`(43), `commentDate`, `message_id`(40), `in_reply_to`(40)), 682 KEY `title` (`title`(191)), 683 KEY `data` (`data`(191)), 684 KEY `hits` (hits), 685 KEY `tc_pi` (`parentId`), 686 KEY `objectType` (object(160), `objectType`), 687 KEY `commentDate` (`commentDate`), 688 KEY `threaded` (message_id(89), in_reply_to(88), `parentId`) 689) ENGINE=MyISAM AUTO_INCREMENT=1 ; 690 691DROP TABLE IF EXISTS `tiki_content`; 692CREATE TABLE `tiki_content` ( 693 `contentId` int(8) NOT NULL auto_increment, 694 `description` text, 695 `contentLabel` varchar(255) NOT NULL default '', 696 PRIMARY KEY (`contentId`) 697) ENGINE=MyISAM AUTO_INCREMENT=1 ; 698 699DROP TABLE IF EXISTS `tiki_content_templates`; 700CREATE TABLE `tiki_content_templates` ( 701 `templateId` int(10) NOT NULL auto_increment, 702 `template_type` VARCHAR( 20 ) NOT NULL DEFAULT 'static', 703 `content` longblob, 704 `name` varchar(200) default NULL, 705 `created` int(14) default NULL, 706 PRIMARY KEY (`templateId`) 707) ENGINE=MyISAM AUTO_INCREMENT=1 ; 708 709DROP TABLE IF EXISTS `tiki_content_templates_sections`; 710CREATE TABLE `tiki_content_templates_sections` ( 711 `templateId` int(10) NOT NULL default '0', 712 `section` varchar(250) NOT NULL default '', 713 PRIMARY KEY (`templateId`,`section`(181)) 714) ENGINE=MyISAM; 715 716DROP TABLE IF EXISTS `tiki_cookies`; 717CREATE TABLE `tiki_cookies` ( 718 `cookieId` int(10) NOT NULL auto_increment, 719 `cookie` text, 720 PRIMARY KEY (`cookieId`) 721) ENGINE=MyISAM AUTO_INCREMENT=1 ; 722 723DROP TABLE IF EXISTS `tiki_copyrights`; 724CREATE TABLE `tiki_copyrights` ( 725 `copyrightId` int(12) NOT NULL auto_increment, 726 `page` varchar(200) default NULL, 727 `title` varchar(200) default NULL, 728 `year` int(11) default NULL, 729 `authors` varchar(200) default NULL, 730 `holder` varchar(200) default NULL, 731 `copyright_order` int(11) default NULL, 732 `userName` varchar(200) default '', 733 PRIMARY KEY (`copyrightId`) 734) ENGINE=MyISAM AUTO_INCREMENT=1 ; 735 736DROP TABLE IF EXISTS `tiki_custom_route`; 737CREATE TABLE `tiki_custom_route` ( 738 `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, 739 `description` varchar(255) NULL, 740 `type` varchar(255) NOT NULL, 741 `from` varchar(255) NOT NULL, 742 `redirect` text NOT NULL, 743 `active` tinyint(1) NOT NULL DEFAULT '1', 744 `short_url` tinyint(1) DEFAULT '0' 745) ENGINE=MyISAM; 746 747DROP TABLE IF EXISTS `tiki_directory_categories`; 748CREATE TABLE `tiki_directory_categories` ( 749 `categId` int(10) NOT NULL auto_increment, 750 `parent` int(10) default NULL, 751 `name` varchar(240) default NULL, 752 `description` text, 753 `childrenType` char(1) default NULL, 754 `sites` int(10) default NULL, 755 `viewableChildren` int(4) default NULL, 756 `allowSites` char(1) default NULL, 757 `showCount` char(1) default NULL, 758 `editorGroup` varchar(200) default NULL, 759 `hits` int(12) default NULL, 760 PRIMARY KEY (`categId`) 761) ENGINE=MyISAM AUTO_INCREMENT=1 ; 762 763DROP TABLE IF EXISTS `tiki_directory_search`; 764CREATE TABLE `tiki_directory_search` ( 765 `term` varchar(250) NOT NULL default '', 766 `hits` int(14) default NULL, 767 PRIMARY KEY (`term`(191)) 768) ENGINE=MyISAM; 769 770DROP TABLE IF EXISTS `tiki_directory_sites`; 771CREATE TABLE `tiki_directory_sites` ( 772 `siteId` int(14) NOT NULL auto_increment, 773 `name` varchar(240) default NULL, 774 `description` text, 775 `url` varchar(255) default NULL, 776 `country` varchar(255) default NULL, 777 `hits` int(12) default NULL, 778 `isValid` char(1) default NULL, 779 `created` int(14) default NULL, 780 `lastModif` int(14) default NULL, 781 `cache` longblob, 782 `cache_timestamp` int(14) default NULL, 783 PRIMARY KEY (`siteId`), 784 KEY (`isValid`), 785 KEY (url(191)) 786) ENGINE=MyISAM AUTO_INCREMENT=1 ; 787 788DROP TABLE IF EXISTS `tiki_dsn`; 789CREATE TABLE `tiki_dsn` ( 790 `dsnId` int(12) NOT NULL auto_increment, 791 `name` varchar(200) NOT NULL default '', 792 `dsn` varchar(255) default NULL, 793 PRIMARY KEY (`dsnId`) 794) ENGINE=MyISAM AUTO_INCREMENT=1 ; 795 796DROP TABLE IF EXISTS `tiki_dynamic_variables`; 797CREATE TABLE `tiki_dynamic_variables` ( 798 `name` varchar(40) NOT NULL, 799 `data` text, 800 `lang` VARCHAR(16) NULL 801) ENGINE=MyISAM; 802 803DROP TABLE IF EXISTS `tiki_extwiki`; 804CREATE TABLE `tiki_extwiki` ( 805 `extwikiId` int(12) NOT NULL auto_increment, 806 `name` varchar(200) NOT NULL default '', 807 `extwiki` varchar(255) default NULL, 808 `indexname` varchar(255) default NULL, 809 `groups` varchar(1024) default NULL, 810 PRIMARY KEY (`extwikiId`) 811) ENGINE=MyISAM AUTO_INCREMENT=1 ; 812 813DROP TABLE IF EXISTS `tiki_faq_questions`; 814CREATE TABLE `tiki_faq_questions` ( 815 `questionId` int(10) NOT NULL auto_increment, 816 `faqId` int(10) default NULL, 817 `position` int(4) default NULL, 818 `question` text, 819 `answer` text, 820 `created` int(14) default NULL, 821 PRIMARY KEY (`questionId`), 822 KEY `faqId` (`faqId`), 823 KEY `question` (question(191)), 824 KEY `answer` (answer(191)), 825 KEY `created` (`created`) 826) ENGINE=MyISAM AUTO_INCREMENT=1 ; 827 828DROP TABLE IF EXISTS `tiki_faqs`; 829CREATE TABLE `tiki_faqs` ( 830 `faqId` int(10) NOT NULL auto_increment, 831 `title` varchar(200) default NULL, 832 `description` text, 833 `created` int(14) default NULL, 834 `questions` int(5) default NULL, 835 `hits` int(8) default NULL, 836 `canSuggest` char(1) default NULL, 837 PRIMARY KEY (`faqId`), 838 KEY `title` (title(191)), 839 KEY `description` (description(191)), 840 KEY `hits` (hits) 841) ENGINE=MyISAM AUTO_INCREMENT=1 ; 842 843DROP TABLE IF EXISTS `tiki_featured_links`; 844CREATE TABLE `tiki_featured_links` ( 845 `url` varchar(200) NOT NULL default '', 846 `title` varchar(200) default NULL, 847 `description` text, 848 `hits` int(8) default NULL, 849 `position` int(6) default NULL, 850 `type` char(1) default NULL, 851 PRIMARY KEY (`url`(191)) 852) ENGINE=MyISAM; 853 854DROP TABLE IF EXISTS `tiki_file_galleries`; 855CREATE TABLE `tiki_file_galleries` ( 856 `galleryId` int(14) NOT NULL auto_increment, 857 `name` varchar(80) NOT NULL default '', 858 `type` varchar(20) NOT NULL default 'default', 859 `template` int(10) default NULL, 860 `description` text, 861 `created` int(14) default NULL, 862 `visible` char(1) default NULL, 863 `lastModif` int(14) default NULL, 864 `user` varchar(200) default '', 865 `hits` int(14) default NULL, 866 `votes` int(8) default NULL, 867 `points` decimal(8,2) default NULL, 868 `maxRows` int(10) default NULL, 869 `public` char(1) default NULL, 870 `show_id` char(1) default NULL, 871 `show_icon` char(1) default NULL, 872 `show_name` char(1) default NULL, 873 `show_size` char(1) default NULL, 874 `show_description` char(1) default NULL, 875 `max_desc` int(8) default NULL, 876 `show_created` char(1) default NULL, 877 `show_hits` char(1) default NULL, 878 `show_lastDownload` char(1) default NULL, 879 `parentId` int(14) NOT NULL default -1, 880 `lockable` char(1) default 'n', 881 `show_lockedby` char(1) default NULL, 882 `archives` int(4) default 0, 883 `sort_mode` char(20) default NULL, 884 `show_modified` char(1) default NULL, 885 `show_author` char(1) default NULL, 886 `show_creator` char(1) default NULL, 887 `subgal_conf` varchar(200) default NULL, 888 `show_last_user` char(1) default NULL, 889 `show_comment` char(1) default NULL, 890 `show_files` char(1) default NULL, 891 `show_explorer` char(1) default NULL, 892 `show_path` char(1) default NULL, 893 `show_slideshow` char(1) default NULL, 894 `show_ocr_state` char(1) default NULL, 895 `default_view` varchar(20) default NULL, 896 `quota` int(8) default 0, 897 `size` int(14) default NULL, 898 `wiki_syntax` varchar(200) default NULL, 899 `backlinkPerms` char(1) default 'n', 900 `show_backlinks` char(1) default NULL, 901 `show_deleteAfter` char(1) default NULL, 902 `show_checked` char(1) default NULL, 903 `show_share` char(1) default NULL, 904 `image_max_size_x` int(8) NOT NULL default '0', 905 `image_max_size_y` int(8) NOT NULL default '0', 906 `show_source` char(1) NOT NULL DEFAULT 'o', 907 `icon_fileId` int(14) UNSIGNED NULL DEFAULT NULL, 908 `ocr_lang` VARCHAR(255) default NULL, 909 PRIMARY KEY (`galleryId`) 910) ENGINE=MyISAM AUTO_INCREMENT=1 ; 911 912INSERT INTO `tiki_file_galleries` (`galleryId`, `name`, `type`, `description`, `visible`, `user`, `public`, `parentId`) VALUES ('1','File Galleries', 'system', '', 'y', 'admin', 'y', -1); 913INSERT INTO `tiki_file_galleries` (`galleryId`, `name`, `type`, `description`, `visible`, `user`, `public`, `parentId`) VALUES ('2','Users File Galleries', 'system', '', 'y', 'admin', 'y', -1); 914INSERT INTO `tiki_file_galleries` (`galleryId`, `name`, `type`, `description`, `visible`, `user`, `public`, `parentId`) VALUES ('3','Wiki Attachments', 'system', '', 'y', 'admin', 'y', -1); 915 916 917DROP TABLE IF EXISTS `tiki_files`; 918CREATE TABLE `tiki_files` ( 919 `fileId` int(14) NOT NULL auto_increment, 920 `galleryId` int(14) NOT NULL default '0', 921 `name` varchar(200) NOT NULL default '', 922 `description` text, 923 `created` int(14) default NULL, 924 `filename` varchar(80) default NULL, 925 `filesize` int(14) default NULL, 926 `filetype` varchar(250) default NULL, 927 `data` longblob, 928 `user` varchar(200) default '', 929 `author` varchar(40) default NULL, 930 `hits` int(14) default NULL, 931 `maxhits` INT( 14 ) default NULL, 932 `lastDownload` int(14) default NULL, 933 `votes` int(8) default NULL, 934 `points` decimal(8,2) default NULL, 935 `path` varchar(255) default NULL, 936 `reference_url` varchar(250) default NULL, 937 `is_reference` char(1) default NULL, 938 `hash` varchar(32) default NULL, 939 `search_data` longtext, 940 `metadata` longtext, 941 `lastModif` integer(14) DEFAULT NULL, 942 `lastModifUser` varchar(200) DEFAULT NULL, 943 `lockedby` varchar(200) default '', 944 `comment` varchar(200) default NULL, 945 `archiveId` int(14) default 0, 946 `deleteAfter` int(14) default NULL, 947 `ocr_state` TINYINT(1) default NULL, 948 `ocr_lang` VARCHAR(255) default NULL, 949 `ocr_data` MEDIUMTEXT default NULL, 950 PRIMARY KEY (`fileId`), 951 KEY `name` (name(191)), 952 KEY `description` (description(191)), 953 KEY `created` (created), 954 KEY `archiveId` (`archiveId`), 955 KEY `galleryId` (`galleryId`), 956 KEY `hits` (hits) 957) ENGINE=MyISAM AUTO_INCREMENT=1 ; 958 959DROP TABLE IF EXISTS `tiki_file_drafts`; 960CREATE TABLE `tiki_file_drafts` ( 961 `fileId` int(14) NOT NULL, 962 `filename` varchar(80) default NULL, 963 `filesize` int(14) default NULL, 964 `filetype` varchar(250) default NULL, 965 `data` longblob, 966 `user` varchar(200) default '', 967 `path` varchar(255) default NULL, 968 `hash` varchar(32) default NULL, 969 `metadata` longtext, 970 `lastModif` integer(14) DEFAULT NULL, 971 `lockedby` varchar(200) default '', 972 PRIMARY KEY (`fileId`, `user`(177)) 973) ENGINE=MyISAM; 974 975DROP TABLE IF EXISTS `tiki_forum_attachments`; 976CREATE TABLE `tiki_forum_attachments` ( 977 `attId` int(14) NOT NULL auto_increment, 978 `threadId` int(14) NOT NULL default '0', 979 `qId` int(14) NOT NULL default '0', 980 `forumId` int(14) default NULL, 981 `filename` varchar(250) default NULL, 982 `filetype` varchar(250) default NULL, 983 `filesize` int(12) default NULL, 984 `data` longblob, 985 `dir` varchar(200) default NULL, 986 `created` int(14) default NULL, 987 `path` varchar(250) default NULL, 988 PRIMARY KEY (`attId`), 989 KEY `threadId` (`threadId`) 990) ENGINE=MyISAM AUTO_INCREMENT=1 ; 991 992DROP TABLE IF EXISTS `tiki_forum_reads`; 993CREATE TABLE `tiki_forum_reads` ( 994 `user` varchar(200) NOT NULL default '', 995 `threadId` int(14) NOT NULL default '0', 996 `forumId` int(14) default NULL, 997 `timestamp` int(14) default NULL, 998 PRIMARY KEY (`user`(177),`threadId`) 999) ENGINE=MyISAM; 1000 1001DROP TABLE IF EXISTS `tiki_forums`; 1002CREATE TABLE `tiki_forums` ( 1003 `forumId` int(8) NOT NULL auto_increment, 1004 `parentId` int(8) NOT NULL default 0, 1005 `name` varchar(255) default NULL, 1006 `description` text, 1007 `created` int(14) default NULL, 1008 `lastPost` int(14) default NULL, 1009 `threads` int(8) default NULL, 1010 `comments` int(8) default NULL, 1011 `controlFlood` char(1) default NULL, 1012 `floodInterval` int(8) default NULL, 1013 `moderator` varchar(200) default NULL, 1014 `hits` int(8) default NULL, 1015 `mail` varchar(200) default NULL, 1016 `useMail` char(1) default NULL, 1017 `section` varchar(200) default NULL, 1018 `usePruneUnreplied` char(1) default NULL, 1019 `pruneUnrepliedAge` int(8) default NULL, 1020 `usePruneOld` char(1) default NULL, 1021 `pruneMaxAge` int(8) default NULL, 1022 `topicsPerPage` int(6) default NULL, 1023 `topicOrdering` varchar(100) default NULL, 1024 `threadOrdering` varchar(100) default NULL, 1025 `att` varchar(80) default NULL, 1026 `att_store` varchar(4) default NULL, 1027 `att_store_dir` varchar(250) default NULL, 1028 `att_max_size` int(12) default NULL, 1029 `att_list_nb` char(1) default NULL, 1030 `ui_level` char(1) default NULL, 1031 `forum_password` varchar(32) default NULL, 1032 `forum_use_password` char(1) default NULL, 1033 `moderator_group` varchar(200) default NULL, 1034 `approval_type` varchar(20) default NULL, 1035 `outbound_address` varchar(250) default NULL, 1036 `outbound_mails_for_inbound_mails` char(1) default NULL, 1037 `outbound_mails_reply_link` char(1) default NULL, 1038 `outbound_from` varchar(250) default NULL, 1039 `inbound_pop_server` varchar(250) default NULL, 1040 `inbound_pop_port` int(4) default NULL, 1041 `inbound_pop_user` varchar(200) default NULL, 1042 `inbound_pop_password` varchar(80) default NULL, 1043 `topic_smileys` char(1) default NULL, 1044 `ui_avatar` char(1) default NULL, 1045 `ui_rating_choice_topic` char(1) DEFAULT NULL, 1046 `ui_flag` char(1) default NULL, 1047 `ui_posts` char(1) default NULL, 1048 `ui_email` char(1) default NULL, 1049 `ui_online` char(1) default NULL, 1050 `topic_summary` char(1) default NULL, 1051 `show_description` char(1) default NULL, 1052 `topics_list_replies` char(1) default NULL, 1053 `topics_list_reads` char(1) default NULL, 1054 `topics_list_pts` char(1) default NULL, 1055 `topics_list_lastpost` char(1) default NULL, 1056 `topics_list_lastpost_title` char(1) default NULL, 1057 `topics_list_lastpost_avatar` char(1) default NULL, 1058 `topics_list_author` char(1) default NULL, 1059 `topics_list_author_avatar` char(1) default NULL, 1060 `vote_threads` char(1) default NULL, 1061 `forum_last_n` int(2) default 0, 1062 `threadStyle` varchar(100) default NULL, 1063 `commentsPerPage` varchar(100) default NULL, 1064 `is_flat` char(1) default NULL, 1065 `mandatory_contribution` char(1) default NULL, 1066 `forumLanguage` varchar(255) default NULL, 1067 PRIMARY KEY (`forumId`) 1068) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1069 1070DROP TABLE IF EXISTS `tiki_forums_queue`; 1071CREATE TABLE `tiki_forums_queue` ( 1072 `qId` int(14) NOT NULL auto_increment, 1073 `object` varchar(32) default NULL, 1074 `parentId` int(14) default NULL, 1075 `forumId` int(14) default NULL, 1076 `timestamp` int(14) default NULL, 1077 `user` varchar(200) default '', 1078 `title` varchar(240) default NULL, 1079 `data` text, 1080 `type` varchar(60) default NULL, 1081 `hash` varchar(32) default NULL, 1082 `topic_smiley` varchar(80) default NULL, 1083 `topic_title` varchar(240) default NULL, 1084 `summary` varchar(240) default NULL, 1085 `in_reply_to` varchar(128) default NULL, 1086 `tags` varchar(255) default NULL, 1087 `email` varchar(255) default NULL, 1088 PRIMARY KEY (`qId`) 1089) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1090 1091DROP TABLE IF EXISTS `tiki_forums_reported`; 1092CREATE TABLE `tiki_forums_reported` ( 1093 `threadId` int(12) NOT NULL default '0', 1094 `forumId` int(12) NOT NULL default '0', 1095 `parentId` int(12) NOT NULL default '0', 1096 `user` varchar(200) default '', 1097 `timestamp` int(14) default NULL, 1098 `reason` varchar(250) default NULL, 1099 PRIMARY KEY (`threadId`, `forumId`, `parentId`, `user`(182)) 1100) ENGINE=MyISAM; 1101 1102DROP TABLE IF EXISTS `tiki_galleries`; 1103CREATE TABLE `tiki_galleries` ( 1104 `galleryId` int(14) NOT NULL auto_increment, 1105 `name` varchar(80) NOT NULL default '', 1106 `description` text, 1107 `created` int(14) default NULL, 1108 `lastModif` int(14) default NULL, 1109 `visible` char(1) default NULL, 1110 `geographic` char(1) default NULL, 1111 `theme` varchar(60) default NULL, 1112 `user` varchar(200) default '', 1113 `hits` int(14) default NULL, 1114 `maxRows` int(10) default NULL, 1115 `rowImages` int(10) default NULL, 1116 `thumbSizeX` int(10) default NULL, 1117 `thumbSizeY` int(10) default NULL, 1118 `public` char(1) default NULL, 1119 `sortorder` varchar(20) NOT NULL default 'created', 1120 `sortdirection` varchar(4) NOT NULL default 'desc', 1121 `galleryimage` varchar(20) NOT NULL default 'first', 1122 `parentgallery` int(14) NOT NULL default -1, 1123 `showname` char(1) NOT NULL default 'y', 1124 `showimageid` char(1) NOT NULL default 'n', 1125 `showdescription` char(1) NOT NULL default 'n', 1126 `showcreated` char(1) NOT NULL default 'n', 1127 `showuser` char(1) NOT NULL default 'n', 1128 `showhits` char(1) NOT NULL default 'y', 1129 `showxysize` char(1) NOT NULL default 'y', 1130 `showfilesize` char(1) NOT NULL default 'n', 1131 `showfilename` char(1) NOT NULL default 'n', 1132 `defaultscale` varchar(10) NOT NULL DEFAULT 'o', 1133 `showcategories` char(1) NOT NULL default 'n', 1134 PRIMARY KEY (`galleryId`), 1135 KEY `name` (name), 1136 KEY `description` (description(191)), 1137 KEY `hits` (hits), 1138 KEY `parentgallery` (parentgallery), 1139 KEY `visibleUser` (visible, user(190)) 1140) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1141 1142DROP TABLE IF EXISTS `tiki_galleries_scales`; 1143CREATE TABLE `tiki_galleries_scales` ( 1144 `galleryId` int(14) NOT NULL default '0', 1145 `scale` int(11) NOT NULL default '0', 1146 PRIMARY KEY (`galleryId`,`scale`) 1147) ENGINE=MyISAM; 1148 1149DROP TABLE IF EXISTS `tiki_group_inclusion`; 1150CREATE TABLE `tiki_group_inclusion` ( 1151 `groupName` varchar(255) NOT NULL default '', 1152 `includeGroup` varchar(255) NOT NULL default '', 1153 PRIMARY KEY (`groupName`(120),`includeGroup`(120)) 1154) ENGINE=MyISAM; 1155INSERT INTO `tiki_group_inclusion` (`groupName` ,`includeGroup`) VALUES ('Registered','Anonymous'); 1156 1157DROP TABLE IF EXISTS `tiki_group_watches`; 1158CREATE TABLE `tiki_group_watches` ( 1159 `watchId` int(12) NOT NULL auto_increment, 1160 `group` varchar(200) NOT NULL default '', 1161 `event` varchar(40) NOT NULL default '', 1162 `object` varchar(200) NOT NULL default '', 1163 `title` varchar(250) default NULL, 1164 `type` varchar(200) default NULL, 1165 `url` varchar(250) default NULL, 1166 PRIMARY KEY (`watchId`), 1167 INDEX `event-object-group` ( `event` , `object` ( 100 ) , `group` ( 50 ) ) 1168) ENGINE=MyISAM; 1169 1170# Keep track of h5p content entities > Pending in Tiki: Add FileId 1171DROP TABLE IF EXISTS `tiki_h5p_contents`; 1172CREATE TABLE tiki_h5p_contents ( 1173 id INT UNSIGNED NOT NULL AUTO_INCREMENT, 1174 file_id INT UNSIGNED NOT NULL, # reference to the file gallery object in tiki_files table 1175 created_at TIMESTAMP NULL, 1176 updated_at TIMESTAMP NULL, 1177 user_id INT UNSIGNED NOT NULL, 1178 title VARCHAR(255) NOT NULL, 1179 library_id INT UNSIGNED NOT NULL, 1180 parameters LONGTEXT NOT NULL, 1181 filtered LONGTEXT NULL, 1182 slug VARCHAR(127) NOT NULL, 1183 embed_type VARCHAR(127) NOT NULL, 1184 disable INT UNSIGNED NOT NULL DEFAULT 0, 1185 content_type VARCHAR(127) NULL, 1186 authors MEDIUMTEXT NULL, 1187 license VARCHAR(32) NULL DEFAULT NULL, 1188 keywords TEXT NULL, 1189 description TEXT NULL, 1190 source VARCHAR(2083) NULL, 1191 year_from INT UNSIGNED NULL, 1192 year_to INT UNSIGNED NULL, 1193 license_version VARCHAR(10) NULL, 1194 license_extras LONGTEXT NULL, 1195 author_comments LONGTEXT NULL, 1196 changes MEDIUMTEXT NULL, 1197 PRIMARY KEY (id), 1198 UNIQUE KEY `fileId` (`file_id`) 1199) ENGINE = MyISAM; 1200 1201# Keep track of content dependencies 1202DROP TABLE IF EXISTS `tiki_h5p_contents_libraries`; 1203CREATE TABLE tiki_h5p_contents_libraries ( 1204 content_id INT UNSIGNED NOT NULL, 1205 library_id INT UNSIGNED NOT NULL, 1206 dependency_type VARCHAR(31) NOT NULL, 1207 weight SMALLINT UNSIGNED NOT NULL DEFAULT 0, 1208 drop_css TINYINT UNSIGNED NOT NULL, 1209 PRIMARY KEY (content_id, library_id, dependency_type) 1210) ENGINE = MyISAM; 1211 1212# Keep track of h5p libraries 1213DROP TABLE IF EXISTS `tiki_h5p_libraries`; 1214CREATE TABLE tiki_h5p_libraries ( 1215 id INT UNSIGNED NOT NULL AUTO_INCREMENT, 1216 created_at TIMESTAMP NULL, 1217 updated_at TIMESTAMP NULL, 1218 name VARCHAR(127) NOT NULL, 1219 title VARCHAR(255) NOT NULL, 1220 major_version INT UNSIGNED NOT NULL, 1221 minor_version INT UNSIGNED NOT NULL, 1222 patch_version INT UNSIGNED NOT NULL, 1223 runnable INT UNSIGNED NOT NULL, 1224 restricted INT UNSIGNED NOT NULL DEFAULT 0, 1225 fullscreen INT UNSIGNED NOT NULL, 1226 embed_types VARCHAR(255) NOT NULL, 1227 preloaded_js TEXT NULL, 1228 preloaded_css TEXT NULL, 1229 drop_library_css TEXT NULL, 1230 semantics TEXT NOT NULL, 1231 tutorial_url VARCHAR(1023) NOT NULL, 1232 has_icon INT UNSIGNED NOT NULL DEFAULT '0', 1233 metadata_settings TEXT NULL, 1234 add_to TEXT DEFAULT NULL, 1235 PRIMARY KEY (id), 1236 KEY name_version (name, major_version, minor_version, patch_version), 1237 KEY runnable (runnable) 1238) ENGINE = MyISAM; 1239 1240DROP TABLE IF EXISTS `tiki_h5p_libraries_hub_cache`; 1241CREATE TABLE tiki_h5p_libraries_hub_cache ( 1242 id INT UNSIGNED NOT NULL AUTO_INCREMENT, 1243 machine_name VARCHAR(127) NOT NULL, 1244 major_version INT UNSIGNED NOT NULL, 1245 minor_version INT UNSIGNED NOT NULL, 1246 patch_version INT UNSIGNED NOT NULL, 1247 h5p_major_version INT UNSIGNED, 1248 h5p_minor_version INT UNSIGNED, 1249 title VARCHAR(255) NOT NULL, 1250 summary TEXT NOT NULL, 1251 description TEXT NOT NULL, 1252 icon VARCHAR(511) NOT NULL, 1253 created_at INT UNSIGNED NOT NULL, 1254 updated_at INT UNSIGNED NOT NULL, 1255 is_recommended INT UNSIGNED NOT NULL, 1256 popularity INT UNSIGNED NOT NULL, 1257 screenshots TEXT, 1258 license TEXT, 1259 example VARCHAR(511) NOT NULL, 1260 tutorial VARCHAR(511), 1261 keywords TEXT, 1262 categories TEXT, 1263 owner VARCHAR(511), 1264 PRIMARY KEY (id), 1265 KEY name_version (machine_name, major_version, minor_version, patch_version) 1266) ENGINE = MyISAM; 1267 1268# Keep track of h5p library dependencies 1269DROP TABLE IF EXISTS `tiki_h5p_libraries_libraries`; 1270CREATE TABLE tiki_h5p_libraries_libraries ( 1271 library_id INT UNSIGNED NOT NULL, 1272 required_library_id INT UNSIGNED NOT NULL, 1273 dependency_type VARCHAR(31) NOT NULL, 1274 PRIMARY KEY (library_id, required_library_id) 1275) ENGINE = MyISAM; 1276 1277# Keep track of h5p library translations 1278DROP TABLE IF EXISTS `tiki_h5p_libraries_languages`; 1279CREATE TABLE tiki_h5p_libraries_languages ( 1280 library_id INT UNSIGNED NOT NULL, 1281 language_code VARCHAR(31) NOT NULL, 1282 translation TEXT NOT NULL, 1283 PRIMARY KEY (library_id, language_code) 1284) ENGINE = MyISAM; 1285 1286# Keep track of temporary files uploaded in editor before saving content 1287DROP TABLE IF EXISTS `tiki_h5p_tmpfiles`; 1288CREATE TABLE tiki_h5p_tmpfiles ( 1289 id INT UNSIGNED NOT NULL AUTO_INCREMENT, 1290 path VARCHAR(255) NOT NULL, 1291 created_at INT UNSIGNED NOT NULL, 1292 PRIMARY KEY (id), 1293 KEY created_at (created_at), 1294 KEY path (path(191)) 1295) ENGINE = MyISAM; 1296 1297# Keep track of results (contents >-< users) 1298DROP TABLE IF EXISTS `tiki_h5p_results`; 1299CREATE TABLE tiki_h5p_results ( 1300 id INT UNSIGNED NOT NULL AUTO_INCREMENT, 1301 content_id INT UNSIGNED NOT NULL, 1302 user_id INT UNSIGNED NOT NULL, 1303 score INT UNSIGNED NOT NULL, 1304 max_score INT UNSIGNED NOT NULL, 1305 opened INT UNSIGNED NOT NULL, 1306 finished INT UNSIGNED NOT NULL, 1307 time INT UNSIGNED NOT NULL, 1308 PRIMARY KEY (id), 1309 KEY content_user (content_id, user_id) 1310) ENGINE = MyISAM; 1311 1312# Cache table for h5p libraries so we can reuse the existing h5p code for caching 1313DROP TABLE IF EXISTS `tiki_h5p_libraries_cachedassets`; 1314CREATE TABLE tiki_h5p_libraries_cachedassets ( 1315 library_id INT UNSIGNED NOT NULL, 1316 hash VARCHAR(64) NOT NULL, 1317 PRIMARY KEY (library_id, hash) 1318) ENGINE = MyISAM; 1319 1320DROP TABLE IF EXISTS `tiki_history`; 1321CREATE TABLE `tiki_history` ( 1322 `historyId` int(12) NOT NULL auto_increment, 1323 `pageName` varchar(160) NOT NULL default '', 1324 `version` int(8) NOT NULL default '0', 1325 `version_minor` int(8) NOT NULL default '0', 1326 `lastModif` int(14) default NULL, 1327 `description` varchar(200) default NULL, 1328 `user` varchar(200) not null default '', 1329 `ip` varchar(39) default NULL, 1330 `comment` varchar(255) default NULL, 1331 `data` longblob, 1332 `type` varchar(50) default NULL, 1333 `is_html` TINYINT(1) NOT NULL DEFAULT 0, 1334 PRIMARY KEY (`pageName`,`version`), 1335 KEY `user` (`user`(191)), 1336 KEY (`historyId`) 1337) ENGINE=MyISAM; 1338 1339DROP TABLE IF EXISTS `tiki_hotwords`; 1340CREATE TABLE `tiki_hotwords` ( 1341 `word` varchar(255) NOT NULL default '', 1342 `url` varchar(255) NOT NULL default '', 1343 PRIMARY KEY (`word`(191)) 1344) ENGINE=MyISAM; 1345 1346DROP TABLE IF EXISTS `tiki_html_pages`; 1347CREATE TABLE `tiki_html_pages` ( 1348 `pageName` varchar(200) NOT NULL default '', 1349 `content` longblob, 1350 `refresh` int(10) default NULL, 1351 `type` char(1) default NULL, 1352 `created` int(14) default NULL, 1353 PRIMARY KEY (`pageName`(191)) 1354) ENGINE=MyISAM; 1355 1356DROP TABLE IF EXISTS `tiki_html_pages_dynamic_zones`; 1357CREATE TABLE `tiki_html_pages_dynamic_zones` ( 1358 `pageName` varchar(40) NOT NULL default '', 1359 `zone` varchar(80) NOT NULL default '', 1360 `type` char(2) default NULL, 1361 `content` text, 1362 PRIMARY KEY (`pageName`,`zone`) 1363) ENGINE=MyISAM; 1364 1365DROP TABLE IF EXISTS `tiki_images`; 1366CREATE TABLE `tiki_images` ( 1367 `imageId` int(14) NOT NULL auto_increment, 1368 `galleryId` int(14) NOT NULL default '0', 1369 `name` varchar(200) NOT NULL default '', 1370 `description` text, 1371 `lon` float default NULL, 1372 `lat` float default NULL, 1373 `created` int(14) default NULL, 1374 `user` varchar(200) default '', 1375 `hits` int(14) default NULL, 1376 `path` varchar(255) default NULL, 1377 PRIMARY KEY (`imageId`), 1378 KEY `name` (name(191)), 1379 KEY `description` (description(191)), 1380 KEY `hits` (hits), 1381 KEY `ti_gId` (`galleryId`), 1382 KEY `ti_cr` (created), 1383 KEY `ti_us` (user(191)) 1384) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1385 1386DROP TABLE IF EXISTS `tiki_images_data`; 1387CREATE TABLE `tiki_images_data` ( 1388 `imageId` int(14) NOT NULL default '0', 1389 `xsize` int(8) NOT NULL default '0', 1390 `ysize` int(8) NOT NULL default '0', 1391 `type` char(1) NOT NULL default '', 1392 `filesize` int(14) default NULL, 1393 `filetype` varchar(80) default NULL, 1394 `filename` varchar(80) default NULL, 1395 `data` longblob, 1396 `etag` varchar(32) default NULL, 1397 PRIMARY KEY (`imageId`,`xsize`,`ysize`,`type`), 1398 KEY `t_i_d_it` (`imageId`,type) 1399) ENGINE=MyISAM; 1400 1401DROP TABLE IF EXISTS `tiki_language`; 1402CREATE TABLE `tiki_language` ( 1403 `id` int(14) NOT NULL auto_increment, 1404 `source` text NOT NULL, 1405 `lang` char(16) NOT NULL default '', 1406 `tran` text, 1407 `changed` bool, 1408 `general` bool DEFAULT NULL COMMENT 'true if this translation is general and can be contributed to the Tiki community, false if it is specific to this instance', 1409 `userId` int(8), 1410 `lastModif` int(14) NULL, 1411 PRIMARY KEY (`id`) 1412) ENGINE=MyISAM; 1413 1414DROP TABLE IF EXISTS `tiki_link_cache`; 1415CREATE TABLE `tiki_link_cache` ( 1416 `cacheId` int(14) NOT NULL auto_increment, 1417 `url` varchar(250) default NULL, 1418 `data` longblob, 1419 `refresh` int(14) default NULL, 1420 PRIMARY KEY (`cacheId`), 1421 KEY `url` (url(191)) 1422) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1423CREATE INDEX urlindex ON tiki_link_cache (url(191)); 1424 1425DROP TABLE IF EXISTS `tiki_links`; 1426CREATE TABLE `tiki_links` ( 1427 `fromPage` varchar(160) NOT NULL default '', 1428 `toPage` varchar(160) NOT NULL default '', 1429 PRIMARY KEY (`fromPage`(96),`toPage`(95)), 1430 KEY `toPage` (`toPage`) 1431) ENGINE=MyISAM; 1432 1433DROP TABLE IF EXISTS `tiki_live_support_events`; 1434CREATE TABLE `tiki_live_support_events` ( 1435 `eventId` int(14) NOT NULL auto_increment, 1436 `reqId` varchar(32) NOT NULL default '', 1437 `type` varchar(40) default NULL, 1438 `seqId` int(14) default NULL, 1439 `senderId` varchar(32) default NULL, 1440 `data` text, 1441 `timestamp` int(14) default NULL, 1442 PRIMARY KEY (`eventId`) 1443) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1444 1445DROP TABLE IF EXISTS `tiki_live_support_message_comments`; 1446CREATE TABLE `tiki_live_support_message_comments` ( 1447 `cId` int(12) NOT NULL auto_increment, 1448 `msgId` int(12) default NULL, 1449 `data` text, 1450 `timestamp` int(14) default NULL, 1451 PRIMARY KEY (`cId`) 1452) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1453 1454DROP TABLE IF EXISTS `tiki_live_support_messages`; 1455CREATE TABLE `tiki_live_support_messages` ( 1456 `msgId` int(12) NOT NULL auto_increment, 1457 `data` text, 1458 `timestamp` int(14) default NULL, 1459 `user` varchar(200) not null default '', 1460 `username` varchar(200) default NULL, 1461 `priority` int(2) default NULL, 1462 `status` char(1) default NULL, 1463 `assigned_to` varchar(200) default NULL, 1464 `resolution` varchar(100) default NULL, 1465 `title` varchar(200) default NULL, 1466 `module` int(4) default NULL, 1467 `email` varchar(250) default NULL, 1468 PRIMARY KEY (`msgId`) 1469) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1470 1471DROP TABLE IF EXISTS `tiki_live_support_modules`; 1472CREATE TABLE `tiki_live_support_modules` ( 1473 `modId` int(4) NOT NULL auto_increment, 1474 `name` varchar(90) default NULL, 1475 PRIMARY KEY (`modId`) 1476) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1477 1478INSERT INTO tiki_live_support_modules(name) VALUES('wiki'); 1479INSERT INTO tiki_live_support_modules(name) VALUES('forums'); 1480INSERT INTO tiki_live_support_modules(name) VALUES('image galleries'); 1481INSERT INTO tiki_live_support_modules(name) VALUES('file galleries'); 1482INSERT INTO tiki_live_support_modules(name) VALUES('directory'); 1483 1484DROP TABLE IF EXISTS `tiki_live_support_operators`; 1485CREATE TABLE `tiki_live_support_operators` ( 1486 `user` varchar(200) NOT NULL default '', 1487 `accepted_requests` int(10) default NULL, 1488 `status` varchar(20) default NULL, 1489 `longest_chat` int(10) default NULL, 1490 `shortest_chat` int(10) default NULL, 1491 `average_chat` int(10) default NULL, 1492 `last_chat` int(14) default NULL, 1493 `time_online` int(10) default NULL, 1494 `votes` int(10) default NULL, 1495 `points` int(10) default NULL, 1496 `status_since` int(14) default NULL, 1497 PRIMARY KEY (`user`(191)) 1498) ENGINE=MyISAM; 1499 1500DROP TABLE IF EXISTS `tiki_live_support_requests`; 1501CREATE TABLE `tiki_live_support_requests` ( 1502 `reqId` varchar(32) NOT NULL default '', 1503 `user` varchar(200) NOT NULL default '', 1504 `tiki_user` varchar(200) default NULL, 1505 `email` varchar(200) default NULL, 1506 `operator` varchar(200) default NULL, 1507 `operator_id` varchar(32) default NULL, 1508 `user_id` varchar(32) default NULL, 1509 `reason` text, 1510 `req_timestamp` int(14) default NULL, 1511 `timestamp` int(14) default NULL, 1512 `status` varchar(40) default NULL, 1513 `resolution` varchar(40) default NULL, 1514 `chat_started` int(14) default NULL, 1515 `chat_ended` int(14) default NULL, 1516 PRIMARY KEY (`reqId`) 1517) ENGINE=MyISAM; 1518 1519DROP TABLE IF EXISTS `tiki_logs`; 1520CREATE TABLE `tiki_logs` ( 1521 `logId` int(8) NOT NULL auto_increment, 1522 `logtype` varchar(20) NOT NULL, 1523 `logmessage` text NOT NULL, 1524 `loguser` varchar(40) NOT NULL, 1525 `logip` varchar(200), 1526 `logclient` text NOT NULL, 1527 `logtime` int(14) NOT NULL, 1528 PRIMARY KEY (`logId`), 1529 KEY `logtype` (logtype) 1530) ENGINE=MyISAM; 1531 1532DROP TABLE IF EXISTS `tiki_mail_events`; 1533CREATE TABLE `tiki_mail_events` ( 1534 `event` varchar(200) default NULL, 1535 `object` varchar(200) default NULL, 1536 `email` varchar(200) default NULL 1537) ENGINE=MyISAM; 1538 1539DROP TABLE IF EXISTS `tiki_mailin_accounts`; 1540CREATE TABLE `tiki_mailin_accounts` ( 1541 `accountId` int(12) NOT NULL auto_increment, 1542 `user` varchar(200) NOT NULL default '', 1543 `account` varchar(50) NOT NULL default '', 1544 `protocol` varchar(10) NOT NULL DEFAULT 'pop', 1545 `host` varchar(255) default NULL, 1546 `port` int(4) default NULL, 1547 `username` varchar(100) default NULL, 1548 `pass` varchar(100) default NULL, 1549 `active` char(1) default NULL, 1550 `type` varchar(40) default NULL, 1551 `anonymous` char(1) NOT NULL default 'y', 1552 `admin` char(1) NOT NULL default 'y', 1553 `attachments` char(1) NOT NULL default 'n', 1554 `routing` char(1) NOT NULL default 'y', 1555 `article_topicId` int(4) default NULL, 1556 `article_type` varchar(50) default NULL, 1557 `discard_after` varchar(255) default NULL, 1558 `show_inlineImages` char(1) NULL, 1559 `save_html` char(1) NULL default 'y', 1560 `categoryId` int(12) NULL, 1561 `namespace` varchar(20) default NULL, 1562 `respond_email` char(1) NOT NULL default 'y', 1563 `leave_email` char(1) NOT NULL default 'n', 1564 PRIMARY KEY (`accountId`) 1565) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1566 1567DROP TABLE IF EXISTS `tiki_menu_languages`; 1568CREATE TABLE `tiki_menu_languages` ( 1569 `menuId` int(8) NOT NULL auto_increment, 1570 `language` char(16) NOT NULL default '', 1571 PRIMARY KEY (`menuId`,`language`) 1572) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1573 1574DROP TABLE IF EXISTS `tiki_menu_options`; 1575CREATE TABLE `tiki_menu_options` ( 1576 `optionId` int(8) NOT NULL auto_increment, 1577 `menuId` int(8) default NULL, 1578 `type` char(1) default NULL, 1579 `name` varchar(200) default NULL, 1580 `url` varchar(255) default NULL, 1581 `position` int(4) default NULL, 1582 `section` text default NULL, 1583 `perm` text default NULL, 1584 `groupname` text default NULL, 1585 `userlevel` int(4) default 0, 1586 `icon` varchar(200), 1587 `class` text default NULL, 1588 PRIMARY KEY (`optionId`), 1589 UNIQUE KEY `uniq_menu` (`menuId`,`name`(30),`url`(50),`position`,`section`(60),`perm`(50),`groupname`(50)) 1590) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1591 1592-- when adding new inserts, order commands by position 1593INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Home','./',10,'','','',0); 1594INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Search','tiki-searchresults.php',13,'feature_search_fulltext','tiki_p_search','',0); 1595INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Search','tiki-searchindex.php',13,'feature_search','tiki_p_search','',0); 1596INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Contact Us','tiki-contact.php',20,'feature_contact,feature_messages','','',0); 1597INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Stats','tiki-stats.php',23,'feature_stats','tiki_p_view_stats','',0); 1598INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Categories','tiki-browse_categories.php',25,'feature_categories','tiki_p_view_category','',0); 1599INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Tags','tiki-browse_freetags.php',27,'feature_freetags','tiki_p_view_freetags','',0); 1600INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Calendar','tiki-calendar.php',35,'feature_calendar','tiki_p_view_calendar','',0); 1601INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Tiki Calendar','tiki-action_calendar.php',37,'feature_action_calendar','tiki_p_view_tiki_calendar','',0); 1602INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Payments','tiki-payment.php',39,'payment_feature','tiki_p_payment_view','',0); 1603INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Payments','tiki-payment.php',39,'payment_feature','tiki_p_payment_request','',0); 1604INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','(debug)','javascript:toggle(\'debugconsole\')',40,'feature_debug_console','tiki_p_admin','',0); 1605INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','User Wizard','tiki-wizard_user.php',45,'feature_wizard_user','','Registered',0); 1606INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','My Account','tiki-my_tiki.php',50,'feature_mytiki','','Registered',0); 1607INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','My Account Home','tiki-my_tiki.php',51,'feature_mytiki','','Registered',0); 1608INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Preferences','tiki-user_preferences.php',55,'feature_mytiki,feature_userPreferences','','Registered',0); 1609INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Messages','messu-mailbox.php',60,'feature_mytiki,feature_messages','tiki_p_messages','Registered',0); 1610INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Tasks','tiki-user_tasks.php',65,'feature_mytiki,feature_tasks','tiki_p_tasks','Registered',0); 1611INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Bookmarks','tiki-user_bookmarks.php',70,'feature_mytiki,feature_user_bookmarks','tiki_p_create_bookmarks','Registered',0); 1612INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Modules','tiki-user_assigned_modules.php',75,'feature_mytiki,user_assigned_modules','tiki_p_configure_modules','Registered',0); 1613INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Webmail','tiki-webmail.php',85,'feature_mytiki,feature_webmail','tiki_p_use_webmail','Registered',0); 1614INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Contacts','tiki-contacts.php',87,'feature_mytiki,feature_contacts','','Registered',0); 1615INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Mail-in','tiki-user_mailin.php',88,'feature_mytiki,feature_mailin','','Registered',0); 1616INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Notepad','tiki-notepad_list.php',90,'feature_mytiki,feature_notepad','tiki_p_notepad','Registered',0); 1617INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','My Files','tiki-userfiles.php',95,'feature_mytiki,feature_userfiles','tiki_p_userfiles','Registered',0); 1618INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','User Menu','tiki-usermenu.php',100,'feature_mytiki,feature_usermenu','tiki_p_usermenu','Registered',0); 1619INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Mini Calendar','tiki-minical.php',105,'feature_mytiki,feature_minical','tiki_p_minical','Registered',0); 1620INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','My Watches','tiki-user_watches.php',110,'feature_mytiki,feature_user_watches','','Registered',0); 1621INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Community','tiki-list_users.php',187,'feature_friends','tiki_p_list_users','',0); 1622INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','User List','tiki-list_users.php',188,'feature_friends','tiki_p_list_users','',0); 1623INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Friendship Network','tiki-friends.php',189,'feature_friends','','Registered',0); 1624INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Wiki','tiki-index.php',200,'feature_wiki','tiki_p_view','',0); 1625INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Wiki Home','tiki-index.php',202,'feature_wiki','tiki_p_view','',0); 1626INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Last Changes','tiki-lastchanges.php',205,'feature_wiki,feature_lastChanges','tiki_p_view','',0); 1627INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Rankings','tiki-wiki_rankings.php',215,'feature_wiki,feature_wiki_rankings','tiki_p_view','',0); 1628INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','List Pages','tiki-listpages.php?cookietab=1#tab1',220,'feature_wiki,feature_listPages','tiki_p_view','',0); 1629INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Create a Wiki Page','tiki-listpages.php?cookietab=2#tab2',222,'feature_wiki,feature_listPages','tiki_p_view,tiki_p_edit','',0); 1630INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Orphan Pages','tiki-orphan_pages.php',225,'feature_wiki,feature_listorphanPages','tiki_p_view','',0); 1631INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Sandbox','tiki-editpage.php?page=sandbox',230,'feature_wiki,feature_sandbox','tiki_p_view','',0); 1632INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Multiple Print','tiki-print_pages.php',235,'feature_wiki,feature_wiki_multiprint','tiki_p_view','',0); 1633INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Send Pages','tiki-send_objects.php',240,'feature_wiki,feature_comm','tiki_p_view,tiki_p_send_pages','',0); 1634INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Received Pages','tiki-received_pages.php',245,'feature_wiki,feature_comm','tiki_p_view,tiki_p_admin_received_pages','',0); 1635INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Structures','tiki-admin_structures.php',250,'feature_wiki,feature_wiki_structure','tiki_p_view','',0); 1636INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Mind Map','tiki-mindmap.php',255,'feature_wiki_mindmap','tiki_p_view','',0); 1637INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Image Galleries','tiki-galleries.php',300,'feature_galleries','tiki_p_view_image_gallery','',0); 1638INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Galleries','tiki-galleries.php',305,'feature_galleries','tiki_p_list_image_galleries','',0); 1639INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Rankings','tiki-galleries_rankings.php',310,'feature_galleries,feature_gal_rankings','tiki_p_list_image_galleries','',0); 1640INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Upload Image','tiki-upload_image.php',315,'feature_galleries','tiki_p_upload_images','',0); 1641INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Directory Batch','tiki-batch_upload.php',318,'feature_galleries,feature_gal_batch','tiki_p_batch_upload','',0); 1642INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','System Gallery','tiki-list_gallery.php?galleryId=0',320,'feature_galleries','tiki_p_admin_galleries','',0); 1643INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Articles','tiki-view_articles.php',350,'feature_articles','tiki_p_read_article','',0); 1644INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Articles','tiki-view_articles.php',350,'feature_articles','tiki_p_articles_read_heading','',0); 1645INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Articles Home','tiki-view_articles.php',355,'feature_articles','tiki_p_read_article','',0); 1646INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Articles Home','tiki-view_articles.php',355,'feature_articles','tiki_p_articles_read_heading','',0); 1647INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','List Articles','tiki-list_articles.php',360,'feature_articles','tiki_p_read_article','',0); 1648INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','List Articles','tiki-list_articles.php',360,'feature_articles','tiki_p_articles_read_heading','',0); 1649INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Rankings','tiki-cms_rankings.php',365,'feature_articles,feature_cms_rankings','tiki_p_read_article','',0); 1650INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Submit Article','tiki-edit_submission.php',370,'feature_articles,feature_submissions','tiki_p_read_article,tiki_p_submit_article','',0); 1651INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','View submissions','tiki-list_submissions.php',375,'feature_articles,feature_submissions','tiki_p_read_article,tiki_p_submit_article','',0); 1652INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','View submissions','tiki-list_submissions.php',375,'feature_articles,feature_submissions','tiki_p_read_article,tiki_p_approve_submission','',0); 1653INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','View Submissions','tiki-list_submissions.php',375,'feature_articles,feature_submissions','tiki_p_read_article,tiki_p_remove_submission','',0); 1654INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','New Article','tiki-edit_article.php',380,'feature_articles','tiki_p_read_article,tiki_p_edit_article','',0); 1655INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Send Articles','tiki-send_objects.php',385,'feature_articles,feature_comm','tiki_p_read_article,tiki_p_send_articles','',0); 1656INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Received Articles','tiki-received_articles.php',385,'feature_articles,feature_comm','tiki_p_read_article,tiki_p_admin_received_articles','',0); 1657INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Admin Types','tiki-article_types.php',395,'feature_articles','tiki_p_articles_admin_types','',0); 1658INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Admin Topics','tiki-admin_topics.php',390,'feature_articles','tiki_p_articles_admin_topics','',0); 1659INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Blogs','tiki-list_blogs.php',450,'feature_blogs','tiki_p_read_blog','',0); 1660INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','List Blogs','tiki-list_blogs.php',455,'feature_blogs','tiki_p_read_blog','',0); 1661INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Rankings','tiki-blog_rankings.php',460,'feature_blogs,feature_blog_rankings','tiki_p_read_blog','',0); 1662INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Create Blog','tiki-edit_blog.php',465,'feature_blogs','tiki_p_read_blog,tiki_p_create_blogs','',0); 1663INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','New Blog Post','tiki-blog_post.php',470,'feature_blogs','tiki_p_read_blog,tiki_p_blog_post','',0); 1664INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','List Blog Posts','tiki-list_posts.php',475,'feature_blogs','tiki_p_read_blog,tiki_p_blog_admin','',0); 1665INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Forums','tiki-forums.php',500,'feature_forums','tiki_p_forum_read','',0); 1666INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','List Forums','tiki-forums.php',505,'feature_forums','tiki_p_forum_read','',0); 1667INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Rankings','tiki-forum_rankings.php',510,'feature_forums,feature_forum_rankings','tiki_p_forum_read','',0); 1668INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Admin Forums','tiki-admin_forums.php',515,'feature_forums','tiki_p_forum_read,tiki_p_admin_forum','',0); 1669INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Directory','tiki-directory_browse.php',550,'feature_directory','tiki_p_view_directory','',0); 1670INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Submit a new link','tiki-directory_add_site.php',555,'feature_directory','tiki_p_submit_link','',0); 1671INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Browse Directory','tiki-directory_browse.php',560,'feature_directory','tiki_p_view_directory','',0); 1672INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Admin Directory','tiki-directory_admin.php',565,'feature_directory','tiki_p_view_directory,tiki_p_admin_directory_cats','',0); 1673INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Admin Directory','tiki-directory_admin.php',565,'feature_directory','tiki_p_view_directory,tiki_p_admin_directory_sites','',0); 1674INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Admin Directory','tiki-directory_admin.php',565,'feature_directory','tiki_p_view_directory,tiki_p_validate_links','',0); 1675INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','File Galleries','tiki-list_file_gallery.php',600,'feature_file_galleries','tiki_p_list_file_galleries|tiki_p_view_file_gallery|tiki_p_upload_files','',0); 1676INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','List Galleries','tiki-list_file_gallery.php',605,'feature_file_galleries','tiki_p_list_file_galleries','',0); 1677INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Rankings','tiki-file_galleries_rankings.php',610,'feature_file_galleries,feature_file_galleries_rankings','tiki_p_list_file_galleries','',0); 1678INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Upload File','tiki-upload_file.php',615,'feature_file_galleries','tiki_p_upload_files','',0); 1679INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Directory batch','tiki-batch_upload_files.php',617,'feature_file_galleries_batch','tiki_p_batch_upload_file_dir','',0); 1680INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','FAQs','tiki-list_faqs.php',650,'feature_faqs','tiki_p_view_faqs','',0); 1681INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','List FAQs','tiki-list_faqs.php',665,'feature_faqs','tiki_p_view_faqs','',0); 1682INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Admin FAQs','tiki-list_faqs.php',660,'feature_faqs','tiki_p_admin_faqs','',0); 1683INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Quizzes','tiki-list_quizzes.php',750,'feature_quizzes','tiki_p_take_quiz','',0); 1684INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','List Quizzes','tiki-list_quizzes.php',755,'feature_quizzes','tiki_p_take_quiz','',0); 1685INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Quiz Stats','tiki-quiz_stats.php',760,'feature_quizzes','tiki_p_view_quiz_stats','',0); 1686INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Admin Quizzes','tiki-edit_quiz.php',765,'feature_quizzes','tiki_p_admin_quizzes','',0); 1687INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Spreadsheets','tiki-sheets.php',780,'feature_sheet','tiki_p_view_sheet','',0); 1688INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','List Sheets','tiki-sheets.php',782,'feature_sheet','tiki_p_view_sheet','',0); 1689INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Trackers','tiki-list_trackers.php',800,'feature_trackers','tiki_p_list_trackers','',0); 1690INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','List Trackers','tiki-list_trackers.php',805,'feature_trackers','tiki_p_list_trackers','',0); 1691INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Manage Tabular Formats','tiki-tabular-manage',810,'tracker_tabular_enabled','tiki_p_tabular_admin','',0); 1692INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s', 'Accounting', 'tiki-accounting_books.php', 830, 'feature_accounting', 'tiki_p_acct_view', '', 0); 1693INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o', 'Accounting books', 'tiki-accounting_books.php', 835, 'feature_accounting', 'tiki_p_acct_view', '', 0); 1694INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Surveys','tiki-list_surveys.php',850,'feature_surveys','tiki_p_take_survey','',0); 1695INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','List Surveys','tiki-list_surveys.php',855,'feature_surveys','tiki_p_take_survey','',0); 1696INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Stats','tiki-survey_stats.php',860,'feature_surveys','tiki_p_view_survey_stats','',0); 1697INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Admin Surveys','tiki-admin_surveys.php',865,'feature_surveys','tiki_p_admin_surveys','',0); 1698INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_subscribe_newsletters','',0); 1699INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_send_newsletters','',0); 1700INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_admin_newsletters','',0); 1701INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_list_newsletters','',0); 1702INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Send Newsletters','tiki-send_newsletters.php',905,'feature_newsletters','tiki_p_send_newsletters','',0); 1703INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Admin Newsletters','tiki-admin_newsletters.php',910,'feature_newsletters','tiki_p_admin_newsletters','',0); 1704INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_admin','',0); 1705INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_admin_categories','',0); 1706INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_admin_banners','',0); 1707INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_edit_templates','',0); 1708INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_edit_cookies','',0); 1709INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_admin_dynamic','',0); 1710INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_admin_mailin','',0); 1711INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_edit_content_templates','',0); 1712INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_edit_html_pages','',0); 1713INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_view_referer_stats','',0); 1714INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_admin_shoutbox','',0); 1715INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_live_support_admin','',0); 1716INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','user_is_operator','',0); 1717INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'feature_integrator','tiki_p_admin_integrator','',0); 1718INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'feature_edit_templates','tiki_p_edit_templates','',0); 1719INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'feature_view_tpl','tiki_p_edit_templates','',0); 1720INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'feature_editcss','tiki_p_create_css','',0); 1721INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_admin_contribution','',0); 1722INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_admin_users','',0); 1723INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_admin_toolbars','',0); 1724INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_edit_menu','',0); 1725INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_clean_cache','',0); 1726INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_admin_modules','',0); 1727INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'r','Settings','tiki-admin.php',1050,'','tiki_p_admin_webservices','',0); 1728INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o',' Control Panels','tiki-admin.php',1051,'','tiki_p_admin','',0); 1729INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Live Support','tiki-live_support_admin.php',1055,'feature_live_support','tiki_p_live_support_admin','',0); 1730INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Live Support','tiki-live_support_admin.php',1055,'feature_live_support','user_is_operator','',0); 1731INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Banning','tiki-admin_banning.php',1060,'feature_banning','tiki_p_admin_banning','',0); 1732INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Calendar','tiki-admin_calendars.php',1065,'feature_calendar','tiki_p_admin_calendar','',0); 1733INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Admin credits','tiki-admin_credits.php',1067,'payment_feature','tiki_p_admin_users','',0); 1734INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Users','tiki-adminusers.php',1070,'','tiki_p_admin_users','',0); 1735INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Groups','tiki-admingroups.php',1075,'','tiki_p_admin','',0); 1736INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','External Pages Cache','tiki-list_cache.php',1080,'cachepages','tiki_p_admin','',0); 1737INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Modules','tiki-admin_modules.php',1085,'','tiki_p_admin_modules','',0); 1738INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Hotwords','tiki-admin_hotwords.php',1095,'feature_hotwords','tiki_p_admin','',0); 1739INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Edit languages','tiki-edit_languages.php',1098,'lang_use_db','tiki_p_edit_languages','',0); 1740INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','External Feeds','tiki-admin_rssmodules.php',1100,'','tiki_p_admin_rssmodules','',0); 1741INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','External Wikis','tiki-admin_external_wikis.php',1102,'','tiki_p_admin','',0); 1742INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Menus','tiki-admin_menus.php',1105,'','tiki_p_edit_menu','',0); 1743INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Polls','tiki-admin_polls.php',1110,'feature_polls','tiki_p_admin_polls','',0); 1744INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Mail Notifications','tiki-admin_notifications.php',1120,'','tiki_p_admin_notifications','',0); 1745INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Search Stats','tiki-search_stats.php',1125,'feature_search_stats','tiki_p_admin','',0); 1746INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Theme Control','tiki-theme_control.php',1130,'feature_theme_control','tiki_p_admin','',0); 1747INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Tokens','tiki-admin_tokens.php',1132,'auth_token_access','tiki_p_admin','',0); 1748INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Toolbars','tiki-admin_toolbars.php',1135,'','tiki_p_admin_toolbars','',0); 1749INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Transitions','tiki-admin_transitions.php',1140,'','tiki_p_admin','',0); 1750INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Categories','tiki-admin_categories.php',1145,'feature_categories','tiki_p_admin_categories','',0); 1751INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Banners','tiki-list_banners.php',1150,'feature_banners','tiki_p_admin_banners','',0); 1752INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Edit Templates','tiki-edit_templates.php',1155,'feature_edit_templates','tiki_p_edit_templates','',0); 1753INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','View Templates','tiki-edit_templates.php',1155,'feature_view_tpl','tiki_p_edit_templates','',2); 1754INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Edit CSS','tiki-edit_css.php',1158,'feature_editcss','tiki_p_create_css','',2); 1755INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Dynamic content','tiki-list_contents.php',1165,'feature_dynamic_content','tiki_p_admin_dynamic','',0); 1756INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Mail-in','tiki-admin_mailin.php',1175,'feature_mailin','tiki_p_admin_mailin','',0); 1757INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','HTML Pages','tiki-admin_html_pages.php',1185,'feature_html_pages','tiki_p_edit_html_pages','',0); 1758INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Shoutbox','tiki-shoutbox.php',1190,'feature_shoutbox','tiki_p_admin_shoutbox','',0); 1759INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Shoutbox Words','tiki-admin_shoutbox_words.php',1191,'feature_shoutbox','tiki_p_admin_shoutbox','',0); 1760INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Referer Stats','tiki-referer_stats.php',1195,'feature_referer_stats','tiki_p_view_referer_stats','',0); 1761INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Integrator','tiki-admin_integrator.php',1205,'feature_integrator','tiki_p_admin_integrator','',0); 1762INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','phpinfo','tiki-phpinfo.php',1215,'','tiki_p_admin','',0); 1763INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Tiki Cache/Sys Admin','tiki-admin_system.php',1230,'','tiki_p_clean_cache','',0); 1764INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Tiki Importer','tiki-importer.php',1240,'','tiki_p_admin_importer','',0); 1765INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Tiki Logs','tiki-syslog.php',1245,'','tiki_p_admin','',0); 1766INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Security Admin','tiki-admin_security.php',1250,'','tiki_p_admin','',0); 1767INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Action Log','tiki-admin_actionlog.php',1255,'feature_actionlog','tiki_p_admin','',0); 1768INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Action Log','tiki-admin_actionlog.php',1255,'feature_actionlog','tiki_p_view_actionlog','',0); 1769INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Action Log','tiki-admin_actionlog.php',1255,'feature_actionlog','tiki_p_view_actionlog_owngroups','',0); 1770INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Content Templates','tiki-admin_content_templates.php',1256,'feature_wiki_templates','tiki_p_edit_content_templates','',0); 1771INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Comments','tiki-list_comments.php',1260,'feature_wiki_comments','tiki_p_admin','',0); 1772INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Comments','tiki-list_comments.php',1260,'feature_article_comments','tiki_p_admin','',0); 1773INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Comments','tiki-list_comments.php',1260,'feature_file_galleries_comments','tiki_p_admin','',0); 1774INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Comments','tiki-list_comments.php',1260,'feature_image_galleries_comments','tiki_p_admin','',0); 1775INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Comments','tiki-list_comments.php',1260,'feature_poll_comments','tiki_p_admin','',0); 1776INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Comments','tiki-list_comments.php',1260,'feature_faq_comments','tiki_p_admin','',0); 1777INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Contribution','tiki-admin_contribution.php',1265,'feature_contribution','tiki_p_admin_contribution','',0); 1778INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'s', 'Kaltura Video', 'tiki-list_kaltura_entries.php', 950, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', '', 0); 1779INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o', 'List Media', 'tiki-list_kaltura_entries.php', 952, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_list_videos', '', 0); 1780INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o', 'Upload Media', 'tiki-kaltura_upload.php', 954, 'feature_kaltura', 'tiki_p_admin | tiki_p_admin_kaltura | tiki_p_upload_videos', '', 0); 1781INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Permissions','tiki-objectpermissions.php',1077,'','tiki_p_admin|tiki_p_admin_objects','',0); 1782INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Perspectives','tiki-edit_perspective.php',1081,'feature_perspective','tiki_p_admin','',0); 1783INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Social networks','tiki-socialnetworks.php',115,'feature_mytiki,feature_socialnetworks','tiki_p_socialnetworks|tiki_p_admin_socialnetworks','Registered',0); 1784INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42, 'o', 'TimeSheet', 'tiki-timesheet.php', 39, 'feature_time_sheet', '', '', 0); 1785INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Scheduler','tiki-admin_schedulers.php',1270,'','tiki_p_admin','', 0); 1786INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','Webservices','tiki-admin_webservices.php',1280,'feature_webservices','tiki_p_admin_webservices','', 0); 1787INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42,'o','References','tiki-references.php',255,'feature_wiki,feature_references','tiki_p_edit_references','', 0); 1788INSERT INTO `tiki_menu_options` (`menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (42, 'o', 'Custom Routes', 'tiki-admin_routes.php', 1290, 'feature_sefurl_routes', 'tiki_p_admin', '', 0); 1789 1790DROP TABLE IF EXISTS `tiki_menus`; 1791CREATE TABLE `tiki_menus` ( 1792 `menuId` int(8) NOT NULL auto_increment, 1793 `name` varchar(200) NOT NULL default '', 1794 `description` text, 1795 `type` char(1) default NULL, 1796 `icon` varchar(200) default NULL, 1797 `use_items_icons` char(1) NOT NULL DEFAULT 'n', 1798 `parse` char(1) NOT NULL DEFAULT 'n', 1799 PRIMARY KEY (`menuId`) 1800) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1801 1802INSERT INTO tiki_menus (`menuId`,`name`,`description`,`type`,`parse`) VALUES ('42','Application menu','Main extensive navigation menu','d','n'); 1803 1804DROP TABLE IF EXISTS `tiki_minical_events`; 1805CREATE TABLE `tiki_minical_events` ( 1806 `user` varchar(200) default '', 1807 `eventId` int(12) NOT NULL auto_increment, 1808 `title` varchar(250) default NULL, 1809 `description` text, 1810 `start` int(14) default NULL, 1811 `end` int(14) default NULL, 1812 `security` char(1) default NULL, 1813 `duration` int(3) default NULL, 1814 `topicId` int(12) default NULL, 1815 `reminded` char(1) default NULL, 1816 PRIMARY KEY (`eventId`) 1817) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1818 1819DROP TABLE IF EXISTS `tiki_minical_topics`; 1820CREATE TABLE `tiki_minical_topics` ( 1821 `user` varchar(200) default '', 1822 `topicId` int(12) NOT NULL auto_increment, 1823 `name` varchar(250) default NULL, 1824 `filename` varchar(200) default NULL, 1825 `filetype` varchar(200) default NULL, 1826 `filesize` varchar(200) default NULL, 1827 `data` longblob, 1828 `path` varchar(250) default NULL, 1829 `isIcon` char(1) default NULL, 1830 PRIMARY KEY (`topicId`) 1831) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1832 1833DROP TABLE IF EXISTS `tiki_modules`; 1834CREATE TABLE `tiki_modules` ( 1835 `moduleId` int(8) NOT NULL auto_increment, 1836 `name` varchar(200) NOT NULL default '', 1837 `position` varchar(20) NOT NULL DEFAULT '', 1838 `ord` int(4) NOT NULL DEFAULT '0', 1839 `type` char(1) default NULL, 1840 `title` varchar(255) default NULL, 1841 `cache_time` int(14) default NULL, 1842 `rows` int(4) default NULL, 1843 `params` text, 1844 `groups` text, 1845 PRIMARY KEY (`moduleId`), 1846 KEY `positionType` (position, type), 1847 KEY `namePosOrdParam` (`name`(100), `position`, `ord`, `params`(120)) 1848) ENGINE=MyISAM; 1849 1850INSERT INTO `tiki_modules` (name,position,ord,cache_time,params,groups) VALUES 1851 ('menu','left',1,7200,'id=42&title=System+Menu','a:1:{i:0;s:10:"Registered";}'), 1852 ('logo','top',1,7200,'nobox=y','a:0:{}'), 1853 ('login_box','top',2,0,'mode=popup&nobox=y','a:0:{}'), 1854 ('rsslist','bottom',1,7200,'nobox=y','a:0:{}'), 1855 ('poweredby','bottom',2,7200,'nobox=y&icons=n&version=n','a:0:{}'); 1856 1857DROP TABLE IF EXISTS `tiki_newsletter_subscriptions`; 1858CREATE TABLE `tiki_newsletter_subscriptions` ( 1859 `nlId` int(12) NOT NULL default '0', 1860 `email` varchar(255) NOT NULL default '', 1861 `code` varchar(32) default NULL, 1862 `valid` char(1) default NULL, 1863 `subscribed` int(14) default NULL, 1864 `isUser` char(1) NOT NULL default 'n', 1865 `included` char(1) NOT NULL default 'n', 1866 PRIMARY KEY (`nlId`,`email`(178),`isUser`) 1867) ENGINE=MyISAM; 1868 1869DROP TABLE IF EXISTS `tiki_newsletter_groups`; 1870CREATE TABLE `tiki_newsletter_groups` ( 1871 `nlId` int(12) NOT NULL default '0', 1872 `groupName` varchar(255) NOT NULL default '', 1873 `code` varchar(32) default NULL, 1874 `include_groups` char(1) DEFAULT 'y', 1875 PRIMARY KEY (`nlId`,`groupName`(179)) 1876) ENGINE=MyISAM; 1877 1878DROP TABLE IF EXISTS `tiki_newsletter_included`; 1879CREATE TABLE `tiki_newsletter_included` ( 1880 `nlId` int(12) NOT NULL default '0', 1881 `includedId` int(12) NOT NULL default '0', 1882 PRIMARY KEY (`nlId`,`includedId`) 1883) ENGINE=MyISAM; 1884 1885DROP TABLE IF EXISTS `tiki_newsletter_pages`; 1886CREATE TABLE `tiki_newsletter_pages` ( 1887 `nlId` INT( 12 ) NOT NULL , 1888 `wikiPageName` VARCHAR( 160 ) NOT NULL , 1889 `validateAddrs` CHAR( 1 ) NOT NULL DEFAULT 'n', 1890 `addToList` CHAR( 1 ) NOT NULL DEFAULT 'n', 1891 PRIMARY KEY ( `nlId` , `wikiPageName` ) 1892) ENGINE=MyISAM; 1893 1894DROP TABLE IF EXISTS `tiki_newsletters`; 1895CREATE TABLE `tiki_newsletters` ( 1896 `nlId` int(12) NOT NULL auto_increment, 1897 `name` varchar(200) default NULL, 1898 `description` text, 1899 `created` int(14) default NULL, 1900 `lastSent` int(14) default NULL, 1901 `editions` int(10) default NULL, 1902 `users` int(10) default NULL, 1903 `allowUserSub` char(1) default 'y', 1904 `allowAnySub` char(1) default NULL, 1905 `unsubMsg` char(1) default 'y', 1906 `validateAddr` char(1) default 'y', 1907 `frequency` int(14) default NULL, 1908 `allowTxt` char(1) default 'y', 1909 `author` varchar(200) default NULL, 1910 `allowArticleClip` char(1) default 'y', 1911 `autoArticleClip` char(1) default 'n', 1912 `articleClipTypes` text, 1913 `articleClipRange` int(14) default NULL, 1914 `emptyClipBlocksSend` char(1) default 'n', 1915 PRIMARY KEY (`nlId`) 1916) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1917 1918DROP TABLE IF EXISTS `tiki_page_footnotes`; 1919CREATE TABLE `tiki_page_footnotes` ( 1920 `user` varchar(200) NOT NULL default '', 1921 `pageName` varchar(250) NOT NULL default '', 1922 `data` text, 1923 PRIMARY KEY (`user`(150),`pageName`(100)) 1924) ENGINE=MyISAM; 1925 1926DROP TABLE IF EXISTS `tiki_pages`; 1927CREATE TABLE `tiki_pages` ( 1928 `page_id` int(14) NOT NULL auto_increment, 1929 `pageName` varchar(160) NOT NULL default '', 1930 `pageSlug` varchar(160) NULL, 1931 `hits` int(8) default NULL, 1932 `data` mediumtext, 1933 `description` varchar(200) default NULL, 1934 `lastModif` int(14) default NULL, 1935 `comment` varchar(255) default NULL, 1936 `version` int(8) NOT NULL default '0', 1937 `version_minor` int(8) NOT NULL default '0', 1938 `user` varchar(200) default '', 1939 `ip` varchar(39) default NULL, 1940 `flag` char(1) default NULL, 1941 `points` int(8) default NULL, 1942 `votes` int(8) default NULL, 1943 `cache` longtext, 1944 `wiki_cache` int(10) default NULL, 1945 `cache_timestamp` int(14) default NULL, 1946 `pageRank` decimal(4,3) default NULL, 1947 `creator` varchar(200) default NULL, 1948 `page_size` int(10) unsigned default '0', 1949 `lang` varchar(16) default NULL, 1950 `lockedby` varchar(200) default NULL, 1951 `is_html` tinyint(1) default 0, 1952 `created` int(14), 1953 `wysiwyg` char(1) default NULL, 1954 `wiki_authors_style` varchar(20) default '', 1955 `comments_enabled` char(1) default NULL, 1956 `keywords` TEXT, 1957 PRIMARY KEY (`page_id`), 1958 UNIQUE KEY `pageName` (`pageName`), 1959 UNIQUE KEY `pageSlug` (`pageSlug`), 1960 KEY `data` (`data`(191)), 1961 KEY `pageRank` (`pageRank`), 1962 KEY `lastModif`(`lastModif`) 1963) ENGINE=MyISAM AUTO_INCREMENT=1; 1964 1965DROP TABLE IF EXISTS `tiki_pageviews`; 1966CREATE TABLE `tiki_pageviews` ( 1967 `day` int(14) NOT NULL default '0', 1968 `pageviews` int(14) default NULL, 1969 PRIMARY KEY (`day`) 1970) ENGINE=MyISAM; 1971 1972DROP TABLE IF EXISTS `tiki_poll_objects`; 1973CREATE TABLE `tiki_poll_objects` ( 1974 `catObjectId` int(11) NOT NULL default '0', 1975 `pollId` int(11) NOT NULL default '0', 1976 `title` varchar(255) default NULL, 1977 PRIMARY KEY (`catObjectId`,`pollId`) 1978) ENGINE=MyISAM; 1979 1980DROP TABLE IF EXISTS `tiki_poll_options`; 1981CREATE TABLE `tiki_poll_options` ( 1982 `pollId` int(8) NOT NULL default '0', 1983 `optionId` int(8) NOT NULL auto_increment, 1984 `title` varchar(200) default NULL, 1985 `position` int(4) NOT NULL default '0', 1986 `votes` int(8) default NULL, 1987 PRIMARY KEY (`optionId`) 1988) ENGINE=MyISAM AUTO_INCREMENT=1 ; 1989 1990DROP TABLE IF EXISTS `tiki_polls`; 1991CREATE TABLE `tiki_polls` ( 1992 `pollId` int(8) NOT NULL auto_increment, 1993 `title` varchar(200) default NULL, 1994 `votes` int(8) default NULL, 1995 `active` char(1) default NULL, 1996 `publishDate` int(14) default NULL, 1997 `voteConsiderationSpan` int(4) default 0, 1998 PRIMARY KEY (`pollId`) 1999) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2000ALTER TABLE tiki_polls ADD INDEX tiki_poll_lookup ( active , title(190) ); 2001 2002DROP TABLE IF EXISTS `tiki_preferences`; 2003CREATE TABLE `tiki_preferences` ( 2004 `name` varchar(255) NOT NULL default '', 2005 `value` text, 2006 PRIMARY KEY (`name`(191)) 2007) ENGINE=MyISAM; 2008 2009DROP TABLE IF EXISTS `tiki_private_messages`; 2010CREATE TABLE `tiki_private_messages` ( 2011 `messageId` int(8) NOT NULL auto_increment, 2012 `toNickname` varchar(200) NOT NULL default '', 2013 `poster` varchar(200) NOT NULL default 'anonymous', 2014 `timestamp` int(14) default NULL, 2015 `received` tinyint(1) not null default 0, 2016 `message` varchar(255) default NULL, 2017 PRIMARY KEY (`messageId`), 2018 KEY (`received`), 2019 KEY (`timestamp`) 2020) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2021 2022DROP TABLE IF EXISTS `tiki_programmed_content`; 2023CREATE TABLE `tiki_programmed_content` ( 2024 `pId` int(8) NOT NULL auto_increment, 2025 `contentId` int(8) NOT NULL default '0', 2026 `content_type` VARCHAR( 20 ) NOT NULL DEFAULT 'static', 2027 `publishDate` int(14) NOT NULL default '0', 2028 `data` text, 2029 PRIMARY KEY (`pId`) 2030) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2031 2032DROP TABLE IF EXISTS `tiki_quiz_question_options`; 2033CREATE TABLE `tiki_quiz_question_options` ( 2034 `optionId` int(10) NOT NULL auto_increment, 2035 `questionId` int(10) default NULL, 2036 `optionText` text, 2037 `points` int(4) default NULL, 2038 PRIMARY KEY (`optionId`) 2039) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2040 2041DROP TABLE IF EXISTS `tiki_quiz_questions`; 2042CREATE TABLE `tiki_quiz_questions` ( 2043 `questionId` int(10) NOT NULL auto_increment, 2044 `quizId` int(10) default NULL, 2045 `question` text, 2046 `position` int(4) default NULL, 2047 `type` char(1) default NULL, 2048 `maxPoints` int(4) default NULL, 2049 PRIMARY KEY (`questionId`) 2050) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2051 2052DROP TABLE IF EXISTS `tiki_quiz_results`; 2053CREATE TABLE `tiki_quiz_results` ( 2054 `resultId` int(10) NOT NULL auto_increment, 2055 `quizId` int(10) default NULL, 2056 `fromPoints` int(4) default NULL, 2057 `toPoints` int(4) default NULL, 2058 `answer` text, 2059 PRIMARY KEY (`resultId`) 2060) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2061 2062DROP TABLE IF EXISTS `tiki_quiz_stats`; 2063CREATE TABLE `tiki_quiz_stats` ( 2064 `quizId` int(10) NOT NULL default '0', 2065 `questionId` int(10) NOT NULL default '0', 2066 `optionId` int(10) NOT NULL default '0', 2067 `votes` int(10) default NULL, 2068 PRIMARY KEY (`quizId`,`questionId`,`optionId`) 2069) ENGINE=MyISAM; 2070 2071DROP TABLE IF EXISTS `tiki_quiz_stats_sum`; 2072CREATE TABLE `tiki_quiz_stats_sum` ( 2073 `quizId` int(10) NOT NULL default '0', 2074 `quizName` varchar(255) default NULL, 2075 `timesTaken` int(10) default NULL, 2076 `avgpoints` decimal(5,2) default NULL, 2077 `avgavg` decimal(5,2) default NULL, 2078 `avgtime` decimal(5,2) default NULL, 2079 PRIMARY KEY (`quizId`) 2080) ENGINE=MyISAM; 2081 2082DROP TABLE IF EXISTS `tiki_quizzes`; 2083CREATE TABLE `tiki_quizzes` ( 2084 `quizId` int(10) NOT NULL auto_increment, 2085 `name` varchar(255) default NULL, 2086 `description` text, 2087 `canRepeat` char(1) default NULL, 2088 `storeResults` char(1) default NULL, 2089 `questionsPerPage` int(4) default NULL, 2090 `timeLimited` char(1) default NULL, 2091 `timeLimit` int(14) default NULL, 2092 `created` int(14) default NULL, 2093 `taken` int(10) default NULL, 2094 `immediateFeedback` char(1) default NULL, 2095 `showAnswers` char(1) default NULL, 2096 `shuffleQuestions` char(1) default NULL, 2097 `shuffleAnswers` char(1) default NULL, 2098 `publishDate` int(14) default NULL, 2099 `expireDate` int(14) default NULL, 2100 `bDeleted` char(1) default NULL, 2101 `nAuthor` int(4) default NULL, 2102 `bOnline` char(1) default NULL, 2103 `bRandomQuestions` char(1) default NULL, 2104 `nRandomQuestions` tinyint(4) default NULL, 2105 `bLimitQuestionsPerPage` char(1) default NULL, 2106 `nLimitQuestionsPerPage` tinyint(4) default NULL, 2107 `bMultiSession` char(1) default NULL, 2108 `nCanRepeat` tinyint(4) default NULL, 2109 `sGradingMethod` varchar(80) default NULL, 2110 `sShowScore` varchar(80) default NULL, 2111 `sShowCorrectAnswers` varchar(80) default NULL, 2112 `sPublishStats` varchar(80) default NULL, 2113 `bAdditionalQuestions` char(1) default NULL, 2114 `bForum` char(1) default NULL, 2115 `sForum` varchar(80) default NULL, 2116 `sPrologue` text, 2117 `sData` text, 2118 `sEpilogue` text, 2119 `passingperct` int(4) default 0, 2120 PRIMARY KEY (`quizId`) 2121) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2122 2123DROP TABLE IF EXISTS `tiki_received_articles`; 2124CREATE TABLE `tiki_received_articles` ( 2125 `receivedArticleId` int(14) NOT NULL auto_increment, 2126 `receivedFromSite` varchar(200) default NULL, 2127 `receivedFromUser` varchar(200) default NULL, 2128 `receivedDate` int(14) default NULL, 2129 `title` varchar(80) default NULL, 2130 `authorName` varchar(60) default NULL, 2131 `size` int(12) default NULL, 2132 `useImage` char(1) default NULL, 2133 `image_name` varchar(80) default NULL, 2134 `image_type` varchar(80) default NULL, 2135 `image_size` int(14) default NULL, 2136 `image_x` int(4) default NULL, 2137 `image_y` int(4) default NULL, 2138 `image_data` longblob, 2139 `publishDate` int(14) default NULL, 2140 `expireDate` int(14) default NULL, 2141 `created` int(14) default NULL, 2142 `heading` text, 2143 `body` longblob, 2144 `hash` varchar(32) default NULL, 2145 `author` varchar(200) default NULL, 2146 `type` varchar(50) default NULL, 2147 `rating` decimal(3,2) default NULL, 2148 PRIMARY KEY (`receivedArticleId`) 2149) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2150 2151DROP TABLE IF EXISTS `tiki_received_pages`; 2152CREATE TABLE `tiki_received_pages` ( 2153 `receivedPageId` int(14) NOT NULL auto_increment, 2154 `pageName` varchar(160) NOT NULL default '', 2155 `data` longblob, 2156 `description` varchar(200) default NULL, 2157 `comment` varchar(200) default NULL, 2158 `receivedFromSite` varchar(200) default NULL, 2159 `receivedFromUser` varchar(200) default NULL, 2160 `receivedDate` int(14) default NULL, 2161 `parent` varchar(255) default NULL, 2162 `position` tinyint(3) unsigned default NULL, 2163 `alias` varchar(255) default NULL, 2164 `structureName` varchar(250) default NULL, 2165 `parentName` varchar(250) default NULL, 2166 `page_alias` varchar(250) default '', 2167 `pos` int(4) default NULL, 2168 PRIMARY KEY (`receivedPageId`), 2169 KEY `structureName` (`structureName`(191)) 2170) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2171 2172DROP TABLE IF EXISTS `tiki_referer_stats`; 2173CREATE TABLE `tiki_referer_stats` ( 2174 `referer` varchar(255) NOT NULL default '', 2175 `hits` int(10) default NULL, 2176 `last` int(14) default NULL, 2177 `lasturl` text default NULL, 2178 PRIMARY KEY (`referer`(191)) 2179) ENGINE=MyISAM; 2180 2181DROP TABLE IF EXISTS `tiki_related_categories`; 2182CREATE TABLE `tiki_related_categories` ( 2183 `categId` int(10) NOT NULL default '0', 2184 `relatedTo` int(10) NOT NULL default '0', 2185 PRIMARY KEY (`categId`,`relatedTo`) 2186) ENGINE=MyISAM; 2187 2188DROP TABLE IF EXISTS `tiki_rss_modules`; 2189CREATE TABLE `tiki_rss_modules` ( 2190 `rssId` int(8) NOT NULL auto_increment, 2191 `name` varchar(30) NOT NULL default '', 2192 `description` text, 2193 `url` varchar(255) NOT NULL default '', 2194 `refresh` int(8) default NULL, 2195 `lastUpdated` int(14) default NULL, 2196 `showTitle` char(1) default 'n', 2197 `showPubDate` char(1) default 'n', 2198 `sitetitle` VARCHAR(255), 2199 `siteurl` VARCHAR(255), 2200 `actions` TEXT, 2201 PRIMARY KEY (`rssId`), 2202 KEY `name` (name) 2203) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2204 2205DROP TABLE IF EXISTS `tiki_rss_feeds`; 2206CREATE TABLE `tiki_rss_feeds` ( 2207 `name` varchar(60) NOT NULL default '', 2208 `rssVer` char(1) NOT NULL default '1', 2209 `refresh` int(8) default '300', 2210 `lastUpdated` int(14) default NULL, 2211 `cache` longblob, 2212 PRIMARY KEY (`name`,`rssVer`) 2213) ENGINE=MyISAM; 2214 2215DROP TABLE IF EXISTS `tiki_search_stats`; 2216CREATE TABLE `tiki_search_stats` ( 2217 `term` varchar(50) NOT NULL default '', 2218 `hits` int(10) default NULL, 2219 PRIMARY KEY (`term`) 2220) ENGINE=MyISAM; 2221 2222DROP TABLE IF EXISTS `tiki_secdb`; 2223CREATE TABLE tiki_secdb( 2224 `md5_value` varchar(32) NOT NULL, 2225 `filename` varchar(250) NOT NULL, 2226 `tiki_version` varchar(60) NOT NULL, 2227 `severity` int(4) NOT NULL default '0', 2228 PRIMARY KEY (`filename`(171),`tiki_version`(20)), 2229 KEY `sdb_fn` (filename(191)) 2230) ENGINE=MyISAM; 2231 2232DROP TABLE IF EXISTS `tiki_semaphores`; 2233CREATE TABLE `tiki_semaphores` ( 2234 `semName` varchar(250) NOT NULL default '', 2235 `objectType` varchar(20) default 'wiki page', 2236 `user` varchar(200) NOT NULL default '', 2237 `timestamp` int(14) default NULL, 2238 `value` VARCHAR(255) NULL, 2239 PRIMARY KEY (`semName`(191)) 2240) ENGINE=MyISAM; 2241 2242DROP TABLE IF EXISTS `tiki_sent_newsletters`; 2243CREATE TABLE `tiki_sent_newsletters` ( 2244 `editionId` int(12) NOT NULL auto_increment, 2245 `nlId` int(12) NOT NULL default '0', 2246 `users` int(10) default NULL, 2247 `sent` int(14) default NULL, 2248 `subject` varchar(200) default NULL, 2249 `data` longblob, 2250 `datatxt` longblob, 2251 `wysiwyg` char(1) default NULL, 2252 `is_html` varchar(2) default NULL, 2253 PRIMARY KEY (`editionId`) 2254) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2255 2256DROP TABLE IF EXISTS `tiki_sent_newsletters_errors`; 2257CREATE TABLE `tiki_sent_newsletters_errors` ( 2258 `editionId` int(12), 2259 `email` varchar(255), 2260 `login` varchar(40) default '', 2261 `error` char(1) default '', 2262 KEY (`editionId`) 2263) ENGINE=MyISAM ; 2264 2265DROP TABLE IF EXISTS `tiki_sessions`; 2266CREATE TABLE `tiki_sessions` ( 2267 `sessionId` varchar(32) NOT NULL default '', 2268 `user` varchar(200) default '', 2269 `timestamp` int(14) default NULL, 2270 `tikihost` varchar(200) default NULL, 2271 PRIMARY KEY (`sessionId`), 2272 KEY `user` (user(191)), 2273 KEY `timestamp` (`timestamp`) 2274) ENGINE=MyISAM; 2275 2276DROP TABLE IF EXISTS `tiki_sheet_layout`; 2277CREATE TABLE `tiki_sheet_layout` ( 2278 `sheetId` int(8) NOT NULL default '0', 2279 `begin` int(10) NOT NULL default '0', 2280 `end` int(10) default NULL, 2281 `headerRow` int(4) NOT NULL default '0', 2282 `footerRow` int(4) NOT NULL default '0', 2283 `className` varchar(64) default NULL, 2284 `parseValues` char( 1 ) NOT NULL default 'n', 2285 `clonedSheetId` int(8) NULL, 2286 `metadata` longblob, 2287 UNIQUE KEY `sheetId` (`sheetId`, `begin`) 2288) ENGINE=MyISAM; 2289 2290DROP TABLE IF EXISTS `tiki_sheet_values`; 2291CREATE TABLE `tiki_sheet_values` ( 2292 `sheetId` int(8) NOT NULL default '0', 2293 `begin` int(10) NOT NULL default '0', 2294 `end` int(10) default NULL, 2295 `rowIndex` int(4) NOT NULL default '0', 2296 `columnIndex` int(4) NOT NULL default '0', 2297 `value` varchar(255) default NULL, 2298 `calculation` varchar(255) default NULL, 2299 `width` int(4) NOT NULL default '1', 2300 `height` int(4) NOT NULL default '1', 2301 `format` varchar(255) default NULL, 2302 `user` varchar(200) default '', 2303 `style` varchar( 255 ) default '', 2304 `class` varchar( 255 ) default '', 2305 `clonedSheetId` int(8) NULL, 2306 UNIQUE KEY `sheetId` (`sheetId`,begin,`rowIndex`,`columnIndex`), 2307 KEY `sheetId_2` (`sheetId`,`rowIndex`,`columnIndex`) 2308) ENGINE=MyISAM; 2309 2310DROP TABLE IF EXISTS `tiki_sheets`; 2311CREATE TABLE `tiki_sheets` ( 2312 `sheetId` int(8) NOT NULL auto_increment, 2313 `title` varchar(200) NOT NULL default '', 2314 `description` text, 2315 `author` varchar(200) NOT NULL default '', 2316 `parentSheetId` int(8) NULL, 2317 `clonedSheetId` int(8) NULL, 2318 PRIMARY KEY (`sheetId`) 2319) ENGINE=MyISAM; 2320 2321DROP TABLE IF EXISTS `tiki_shoutbox`; 2322CREATE TABLE `tiki_shoutbox` ( 2323 `msgId` int(10) NOT NULL auto_increment, 2324 `message` varchar(255) default NULL, 2325 `timestamp` int(14) default NULL, 2326 `user` varchar(200) NULL default '', 2327 `hash` varchar(32) default NULL, 2328 `tweetId` bigint(20) unsigned NOT NULL default 0, 2329 PRIMARY KEY (`msgId`) 2330) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2331 2332DROP TABLE IF EXISTS `tiki_shoutbox_words`; 2333CREATE TABLE `tiki_shoutbox_words` ( 2334 `word` VARCHAR( 40 ) NOT NULL , 2335 `qty` INT DEFAULT '0' NOT NULL , 2336 PRIMARY KEY (`word`) 2337) ENGINE=MyISAM; 2338 2339DROP TABLE IF EXISTS `tiki_structure_versions`; 2340CREATE TABLE `tiki_structure_versions` ( 2341 `structure_id` int(14) NOT NULL auto_increment, 2342 `version` int(14) default NULL, 2343 PRIMARY KEY (`structure_id`) 2344) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2345 2346DROP TABLE IF EXISTS `tiki_structures`; 2347CREATE TABLE `tiki_structures` ( 2348 `page_ref_id` int(14) NOT NULL auto_increment, 2349 `structure_id` int(14) NOT NULL, 2350 `parent_id` int(14) default NULL, 2351 `page_id` int(14) NOT NULL, 2352 `page_version` int(8) default NULL, 2353 `page_alias` varchar(240) default '', 2354 `pos` int(4) default NULL, 2355 PRIMARY KEY (`page_ref_id`), 2356 KEY `pidpaid` (page_id,parent_id), 2357 KEY `page_id` (page_id) 2358) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2359 2360DROP TABLE IF EXISTS `tiki_submissions`; 2361CREATE TABLE `tiki_submissions` ( 2362 `subId` int(8) NOT NULL auto_increment, 2363 `topline` varchar(255) default NULL, 2364 `title` varchar(255) default NULL, 2365 `subtitle` varchar(255) default NULL, 2366 `linkto` varchar(255) default NULL, 2367 `lang` varchar(16) default NULL, 2368 `authorName` varchar(60) default NULL, 2369 `topicId` int(14) default NULL, 2370 `topicName` varchar(40) default NULL, 2371 `size` int(12) default NULL, 2372 `useImage` char(1) default NULL, 2373 `image_name` varchar(80) default NULL, 2374 `image_caption` text default NULL, 2375 `image_type` varchar(80) default NULL, 2376 `image_size` int(14) default NULL, 2377 `image_x` int(4) default NULL, 2378 `image_y` int(4) default NULL, 2379 `image_data` longblob, 2380 `publishDate` int(14) default NULL, 2381 `expireDate` int(14) default NULL, 2382 `created` int(14) default NULL, 2383 `bibliographical_references` text, 2384 `resume` text, 2385 `heading` text, 2386 `body` text, 2387 `author` varchar(200) default NULL, 2388 `nbreads` int(14) default NULL, 2389 `votes` int(8) default NULL, 2390 `points` int(14) default NULL, 2391 `type` varchar(50) default NULL, 2392 `rating` decimal(3,2) default NULL, 2393 `isfloat` char(1) default NULL, 2394 PRIMARY KEY (`subId`) 2395) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2396 2397DROP TABLE IF EXISTS `tiki_suggested_faq_questions`; 2398CREATE TABLE `tiki_suggested_faq_questions` ( 2399 `sfqId` int(10) NOT NULL auto_increment, 2400 `faqId` int(10) NOT NULL default '0', 2401 `question` text, 2402 `answer` text, 2403 `created` int(14) default NULL, 2404 `user` varchar(200) NOT NULL default '', 2405 PRIMARY KEY (`sfqId`) 2406) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2407 2408DROP TABLE IF EXISTS `tiki_survey_question_options`; 2409CREATE TABLE `tiki_survey_question_options` ( 2410 `optionId` int(12) NOT NULL auto_increment, 2411 `questionId` int(12) NOT NULL default '0', 2412 `qoption` text, 2413 `votes` int(10) default NULL, 2414 PRIMARY KEY (`optionId`) 2415) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2416 2417DROP TABLE IF EXISTS `tiki_survey_questions`; 2418CREATE TABLE `tiki_survey_questions` ( 2419 `questionId` int(12) NOT NULL auto_increment, 2420 `surveyId` int(12) NOT NULL default '0', 2421 `question` text, 2422 `options` text, 2423 `type` char(1) default NULL, 2424 `position` int(5) default NULL, 2425 `votes` int(10) default 0, 2426 `value` int(10) default 0, 2427 `average` decimal(4,2) default NULL, 2428 `mandatory` char(1) NOT NULL default 'n', 2429 `max_answers` int(5) NOT NULL default 0, 2430 `min_answers` int(5) NOT NULL default 0, 2431 PRIMARY KEY (`questionId`) 2432) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2433 2434DROP TABLE IF EXISTS `tiki_surveys`; 2435CREATE TABLE `tiki_surveys` ( 2436 `surveyId` int(12) NOT NULL auto_increment, 2437 `name` varchar(200) default NULL, 2438 `description` text, 2439 `taken` int(10) default NULL, 2440 `lastTaken` int(14) default NULL, 2441 `created` int(14) default NULL, 2442 `status` char(1) default NULL, 2443 PRIMARY KEY (`surveyId`) 2444) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2445 2446DROP TABLE IF EXISTS `tiki_tags`; 2447CREATE TABLE `tiki_tags` ( 2448 `tagName` varchar(80) NOT NULL default '', 2449 `pageName` varchar(160) NOT NULL default '', 2450 `hits` int(8) default NULL, 2451 `description` varchar(200) default NULL, 2452 `data` longblob, 2453 `lastModif` int(14) default NULL, 2454 `comment` varchar(200) default NULL, 2455 `version` int(8) NOT NULL default '0', 2456 `user` varchar(200) NOT NULL default '', 2457 `ip` varchar(39) default NULL, 2458 `flag` char(1) default NULL, 2459 PRIMARY KEY (`tagName`,`pageName`) 2460) ENGINE=MyISAM; 2461 2462DROP TABLE IF EXISTS `tiki_theme_control_categs`; 2463CREATE TABLE `tiki_theme_control_categs` ( 2464 `categId` int(12) NOT NULL default '0', 2465 `theme` varchar(250) NOT NULL default '', 2466 PRIMARY KEY (`categId`) 2467) ENGINE=MyISAM; 2468 2469DROP TABLE IF EXISTS `tiki_theme_control_objects`; 2470CREATE TABLE `tiki_theme_control_objects` ( 2471 `objId` varchar(250) NOT NULL default '', 2472 `type` varchar(250) NOT NULL default '', 2473 `name` varchar(250) NOT NULL default '', 2474 `theme` varchar(250) NOT NULL default '', 2475 PRIMARY KEY (`objId`(100), `type`(100)) 2476) ENGINE=MyISAM; 2477 2478DROP TABLE IF EXISTS `tiki_theme_control_sections`; 2479CREATE TABLE `tiki_theme_control_sections` ( 2480 `section` varchar(250) NOT NULL default '', 2481 `theme` varchar(250) NOT NULL default '', 2482 PRIMARY KEY (`section`(191)) 2483) ENGINE=MyISAM; 2484 2485DROP TABLE IF EXISTS `tiki_topics`; 2486CREATE TABLE `tiki_topics` ( 2487 `topicId` int(14) NOT NULL auto_increment, 2488 `name` varchar(40) default NULL, 2489 `image_name` varchar(80) default NULL, 2490 `image_type` varchar(80) default NULL, 2491 `image_size` int(14) default NULL, 2492 `image_data` longblob, 2493 `active` char(1) default NULL, 2494 `created` int(14) default NULL, 2495 PRIMARY KEY (`topicId`) 2496) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2497 2498DROP TABLE IF EXISTS `tiki_tracker_fields`; 2499CREATE TABLE `tiki_tracker_fields` ( 2500 `fieldId` int(12) NOT NULL auto_increment, 2501 `trackerId` int(12) NOT NULL default '0', 2502 `name` varchar(255) default NULL, 2503 `permName` VARCHAR(100) NULL, 2504 `options` text, 2505 `type` varchar(15) default NULL, 2506 `isMain` char(1) default NULL, 2507 `isTblVisible` char(1) default NULL, 2508 `position` int(4) default NULL, 2509 `isSearchable` char(1) NOT NULL default 'y', 2510 `isPublic` char(1) NOT NULL default 'n', 2511 `isHidden` char(1) NOT NULL default 'n', 2512 `isMandatory` char(1) NOT NULL default 'n', 2513 `description` text, 2514 `isMultilingual` char(1) default 'n', 2515 `itemChoices` text, 2516 `errorMsg` text, 2517 `visibleBy` text, 2518 `editableBy` text, 2519 `descriptionIsParsed` char(1) default 'n', 2520 `validation` varchar(255) default '', 2521 `validationParam` varchar(255) default '', 2522 `validationMessage` varchar(255) default '', 2523 `rules` TEXT, 2524 PRIMARY KEY (`fieldId`), 2525 INDEX `trackerId` (`trackerId`), 2526 UNIQUE `permName` (`permName`, `trackerId`) 2527) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2528 2529DROP TABLE IF EXISTS `tiki_tracker_item_attachments`; 2530CREATE TABLE `tiki_tracker_item_attachments` ( 2531 `attId` int(12) NOT NULL auto_increment, 2532 `itemId` int(12) NOT NULL default 0, 2533 `filename` varchar(80) default NULL, 2534 `filetype` varchar(80) default NULL, 2535 `filesize` int(14) default NULL, 2536 `user` varchar(200) default NULL, 2537 `data` longblob, 2538 `path` varchar(255) default NULL, 2539 `hits` int(10) default NULL, 2540 `created` int(14) default NULL, 2541 `comment` varchar(250) default NULL, 2542 `longdesc` blob, 2543 `version` varchar(40) default NULL, 2544 PRIMARY KEY (`attId`), 2545 INDEX `itemId` (`itemId`) 2546) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2547 2548DROP TABLE IF EXISTS `tiki_tracker_item_fields`; 2549CREATE TABLE `tiki_tracker_item_fields` ( 2550 `itemId` int(12) NOT NULL default '0', 2551 `fieldId` int(12) NOT NULL default '0', 2552 `value` text, 2553 PRIMARY KEY (`itemId`,`fieldId`), 2554 INDEX `fieldId` (`fieldId`), 2555 INDEX value (value(191)) 2556) ENGINE=MyISAM; 2557 2558DROP TABLE IF EXISTS `tiki_tracker_item_field_logs`; 2559CREATE TABLE `tiki_tracker_item_field_logs` ( 2560 `version` int(12) NOT NULL, 2561 `itemId` int(12) NOT NULL default '0', 2562 `fieldId` int(12) NOT NULL default '0', 2563 `value` text, 2564 INDEX `version` (`version`), 2565 INDEX `itemId` (`itemId`), 2566 INDEX `fieldId` (`fieldId`) 2567) ENGINE=MyISAM; 2568 2569DROP TABLE IF EXISTS `tiki_tracker_items`; 2570CREATE TABLE `tiki_tracker_items` ( 2571 `itemId` int(12) NOT NULL auto_increment, 2572 `trackerId` int(12) NOT NULL default '0', 2573 `created` int(14) default NULL, 2574 `createdBy` varchar(200) default NULL, 2575 `status` char(1) default NULL, 2576 `lastModif` int(14) default NULL, 2577 `lastModifBy` varchar(200) default NULL, 2578 PRIMARY KEY (`itemId`), 2579 INDEX `trackerId` (`trackerId`) 2580) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2581 2582DROP TABLE IF EXISTS `tiki_tracker_options`; 2583CREATE TABLE `tiki_tracker_options` ( 2584 `trackerId` int(12) NOT NULL default '0', 2585 `name` varchar(80) NOT NULL default '', 2586 `value` text default NULL, 2587 PRIMARY KEY (`trackerId`,`name`(30)) 2588) ENGINE=MyISAM ; 2589 2590DROP TABLE IF EXISTS `tiki_trackers`; 2591CREATE TABLE `tiki_trackers` ( 2592 `trackerId` int(12) NOT NULL auto_increment, 2593 `name` varchar(255) default NULL, 2594 `description` text, 2595 `descriptionIsParsed` varchar(1) NULL default '0', 2596 `created` int(14) default NULL, 2597 `lastModif` int(14) default NULL, 2598 `items` int(10) default NULL, 2599 PRIMARY KEY (`trackerId`) 2600) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2601 2602DROP TABLE IF EXISTS `tiki_untranslated`; 2603CREATE TABLE `tiki_untranslated` ( 2604 `id` int(14) NOT NULL auto_increment, 2605 `source` tinyblob NOT NULL, 2606 `lang` char(16) NOT NULL default '', 2607 PRIMARY KEY (`source`(255),`lang`), 2608 UNIQUE KEY `id` (id), 2609 KEY `id_2` (id) 2610) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2611 2612DROP TABLE IF EXISTS `tiki_user_answers`; 2613CREATE TABLE `tiki_user_answers` ( 2614 `userResultId` int(10) NOT NULL default '0', 2615 `quizId` int(10) NOT NULL default '0', 2616 `questionId` int(10) NOT NULL default '0', 2617 `optionId` int(10) NOT NULL default '0', 2618 PRIMARY KEY (`userResultId`,`quizId`,`questionId`,`optionId`) 2619) ENGINE=MyISAM; 2620 2621DROP TABLE IF EXISTS `tiki_user_answers_uploads`; 2622CREATE TABLE `tiki_user_answers_uploads` ( 2623 `answerUploadId` int(4) NOT NULL auto_increment, 2624 `userResultId` int(11) NOT NULL default '0', 2625 `questionId` int(11) NOT NULL default '0', 2626 `filename` varchar(255) NOT NULL default '', 2627 `filetype` varchar(64) NOT NULL default '', 2628 `filesize` varchar(255) NOT NULL default '', 2629 `filecontent` longblob NOT NULL, 2630 PRIMARY KEY (`answerUploadId`) 2631) ENGINE=MyISAM; 2632 2633DROP TABLE IF EXISTS `tiki_user_assigned_modules`; 2634CREATE TABLE `tiki_user_assigned_modules` ( 2635 `moduleId` int(8) NOT NULL, 2636 `name` varchar(200) NOT NULL default '', 2637 `position` varchar(20) NOT NULL default '', 2638 `ord` int(4) NOT NULL default 0, 2639 `type` char(1) default NULL, 2640 `user` varchar(200) NOT NULL default '', 2641 PRIMARY KEY (`name`(30),`user`(137),`position`, `ord`), 2642 KEY `id` (moduleId) 2643) ENGINE=MyISAM; 2644 2645DROP TABLE IF EXISTS `tiki_user_bookmarks_folders`; 2646CREATE TABLE `tiki_user_bookmarks_folders` ( 2647 `folderId` int(12) NOT NULL, 2648 `parentId` int(12) default NULL, 2649 `user` varchar(200) NOT NULL default '', 2650 `name` varchar(30) default NULL, 2651 PRIMARY KEY (`user`(179),`folderId`) 2652) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2653 2654DROP TABLE IF EXISTS `tiki_user_bookmarks_urls`; 2655CREATE TABLE `tiki_user_bookmarks_urls` ( 2656 `urlId` int(12) NOT NULL auto_increment, 2657 `name` varchar(200) default NULL, 2658 `url` varchar(250) default NULL, 2659 `data` longblob, 2660 `lastUpdated` int(14) default NULL, 2661 `folderId` int(12) NOT NULL default '0', 2662 `user` varchar(200) NOT NULL default '', 2663 PRIMARY KEY (`urlId`) 2664) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2665 2666DROP TABLE IF EXISTS `tiki_user_login_cookies`; 2667CREATE TABLE `tiki_user_login_cookies` ( 2668 `userId` INT NOT NULL, 2669 `secret` CHAR(64) NOT NULL, 2670 `expiration` TIMESTAMP NULL, 2671 PRIMARY KEY (`userId`, `secret`) 2672) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2673 2674DROP TABLE IF EXISTS `tiki_user_menus`; 2675CREATE TABLE `tiki_user_menus` ( 2676 `user` varchar(200) NOT NULL default '', 2677 `menuId` int(12) NOT NULL auto_increment, 2678 `url` varchar(250) default NULL, 2679 `name` varchar(40) default NULL, 2680 `position` int(4) default NULL, 2681 `mode` char(1) default NULL, 2682 PRIMARY KEY (`menuId`) 2683) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2684 2685DROP TABLE IF EXISTS `tiki_user_modules`; 2686CREATE TABLE `tiki_user_modules` ( 2687 `name` varchar(200) NOT NULL default '', 2688 `title` varchar(40) default NULL, 2689 `data` longblob, 2690 `parse` char(1) default NULL, 2691 `status` VARCHAR(60) default '', 2692 PRIMARY KEY (`name`(191)) 2693) ENGINE=MyISAM; 2694 2695DROP TABLE IF EXISTS `tiki_user_notes`; 2696CREATE TABLE `tiki_user_notes` ( 2697 `user` varchar(200) NOT NULL default '', 2698 `noteId` int(12) NOT NULL auto_increment, 2699 `created` int(14) default NULL, 2700 `name` varchar(255) default NULL, 2701 `lastModif` int(14) default NULL, 2702 `data` LONGBLOB, 2703 `size` int(14) default NULL, 2704 `parse_mode` varchar(20) default NULL, 2705 PRIMARY KEY (`noteId`) 2706) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2707 2708DROP TABLE IF EXISTS `tiki_user_postings`; 2709CREATE TABLE `tiki_user_postings` ( 2710 `user` varchar(200) NOT NULL default '', 2711 `posts` int(12) default NULL, 2712 `last` int(14) default NULL, 2713 `first` int(14) default NULL, 2714 `level` int(8) default NULL, 2715 PRIMARY KEY (`user`(191)) 2716) ENGINE=MyISAM; 2717 2718DROP TABLE IF EXISTS `tiki_user_preferences`; 2719CREATE TABLE `tiki_user_preferences` ( 2720 `user` varchar(200) NOT NULL default '', 2721 `prefName` varchar(40) NOT NULL default '', 2722 `value` TEXT, 2723 PRIMARY KEY (`user`(151),`prefName`) 2724) ENGINE=MyISAM; 2725 2726DROP TABLE IF EXISTS `tiki_user_quizzes`; 2727CREATE TABLE `tiki_user_quizzes` ( 2728 `user` varchar(200) default '', 2729 `quizId` int(10) default NULL, 2730 `timestamp` int(14) default NULL, 2731 `timeTaken` int(14) default NULL, 2732 `points` int(12) default NULL, 2733 `maxPoints` int(12) default NULL, 2734 `resultId` int(10) default NULL, 2735 `userResultId` int(10) NOT NULL auto_increment, 2736 PRIMARY KEY (`userResultId`) 2737) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2738 2739DROP TABLE IF EXISTS `tiki_user_taken_quizzes`; 2740CREATE TABLE `tiki_user_taken_quizzes` ( 2741 `user` varchar(200) NOT NULL default '', 2742 `quizId` varchar(255) NOT NULL default '', 2743 PRIMARY KEY (`user`(141),`quizId`(50)) 2744) ENGINE=MyISAM; 2745 2746DROP TABLE IF EXISTS `tiki_user_tasks_history`; 2747CREATE TABLE `tiki_user_tasks_history` ( 2748 `belongs_to` integer(14) NOT NULL, -- the first task in a history it has the same id as the task id 2749 `task_version` integer(4) NOT NULL DEFAULT 0, -- version number for the history it starts with 0 2750 `title` varchar(250) NOT NULL, -- title 2751 `description` text DEFAULT NULL, -- description 2752 `start` integer(14) DEFAULT NULL, -- date of the starting, if it is not set than there is no starting date 2753 `end` integer(14) DEFAULT NULL, -- date of the end, if it is not set than there is not dealine 2754 `lasteditor` varchar(200) NOT NULL, -- lasteditor: username of last editior 2755 `lastchanges` integer(14) NOT NULL, -- date of last changes 2756 `priority` integer(2) NOT NULL DEFAULT 3, -- priority 2757 `completed` integer(14) DEFAULT NULL, -- date of the completation if it is null it is not yet completed 2758 `deleted` integer(14) DEFAULT NULL, -- date of the deleteation it it is null it is not deleted 2759 `status` char(1) DEFAULT NULL, -- null := waiting, o := open / in progress, c := completed -> (percentage = 100) 2760 `percentage` int(4) DEFAULT NULL, 2761 `accepted_creator` char(1) DEFAULT NULL, -- y - yes, n - no, null - waiting 2762 `accepted_user` char(1) DEFAULT NULL, -- y - yes, n - no, null - waiting 2763 PRIMARY KEY (`belongs_to`, `task_version`) 2764) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2765 2766DROP TABLE IF EXISTS `tiki_user_tasks`; 2767CREATE TABLE `tiki_user_tasks` ( 2768 `taskId` integer(14) NOT NULL auto_increment, -- task id 2769 `last_version` integer(4) NOT NULL DEFAULT 0, -- last version of the task starting with 0 2770 `user` varchar(200) NOT NULL DEFAULT '', -- task user 2771 `creator` varchar(200) NOT NULL, -- username of creator 2772 `public_for_group` varchar(30) DEFAULT NULL, -- this group can also view the task, if it is null it is not public 2773 `rights_by_creator` char(1) DEFAULT NULL, -- null the user can delete the task, 2774 `created` integer(14) NOT NULL, -- date of the creation 2775 `status` char(1) default NULL, 2776 `priority` int(2) default NULL, 2777 `completed` int(14) default NULL, 2778 `percentage` int(4) default NULL, 2779 PRIMARY KEY (`taskId`), 2780 UNIQUE(creator(177), created) 2781) ENGINE=MyISAM AUTO_INCREMENT=1; 2782 2783DROP TABLE IF EXISTS `tiki_user_votings`; 2784CREATE TABLE `tiki_user_votings` ( 2785 `user` varchar(200) NOT NULL default '', 2786 `ip` varchar(39) default NULL, 2787 `id` varchar(255) NOT NULL default '', 2788 `optionId` int(10) NOT NULL default 0, 2789 `time` int(14) NOT NULL default 0, 2790 KEY (`user`(100),id(100)), 2791 KEY `ip` (`ip`), 2792 KEY `id` (`id`(191)) 2793) ENGINE=MyISAM; 2794 2795DROP TABLE IF EXISTS `tiki_user_watches`; 2796CREATE TABLE `tiki_user_watches` ( 2797 `watchId` int(12) NOT NULL auto_increment, 2798 `user` varchar(200) NOT NULL default '', 2799 `event` varchar(40) NOT NULL default '', 2800 `object` varchar(200) NOT NULL default '', 2801 `title` varchar(250) default NULL, 2802 `type` varchar(200) default NULL, 2803 `url` varchar(250) default NULL, 2804 `email` varchar(200) default NULL, 2805 PRIMARY KEY (`watchId`), 2806 INDEX `event-object-user` ( `event` , `object` ( 100 ) , `user` ( 50 ) ) 2807) ENGINE=MyISAM; 2808 2809DROP TABLE IF EXISTS `tiki_userfiles`; 2810CREATE TABLE `tiki_userfiles` ( 2811 `user` varchar(200) NOT NULL default '', 2812 `fileId` int(12) NOT NULL auto_increment, 2813 `name` varchar(200) default NULL, 2814 `filename` varchar(200) default NULL, 2815 `filetype` varchar(200) default NULL, 2816 `filesize` varchar(200) default NULL, 2817 `data` longblob, 2818 `hits` int(8) default NULL, 2819 `isFile` char(1) default NULL, 2820 `path` varchar(255) default NULL, 2821 `created` int(14) default NULL, 2822 PRIMARY KEY (`fileId`) 2823) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2824 2825DROP TABLE IF EXISTS `tiki_userpoints`; 2826CREATE TABLE `tiki_userpoints` ( 2827 `user` varchar(200) NOT NULL default '', 2828 `points` decimal(8,2) default NULL, 2829 `voted` int(8) default NULL 2830) ENGINE=MyISAM; 2831 2832DROP TABLE IF EXISTS `tiki_webmail_contacts`; 2833CREATE TABLE `tiki_webmail_contacts` ( 2834 `contactId` int(12) NOT NULL auto_increment, 2835 `firstName` varchar(80) default NULL, 2836 `lastName` varchar(80) default NULL, 2837 `email` varchar(250) default NULL, 2838 `nickname` varchar(200) default NULL, 2839 `user` varchar(200) NOT NULL default '', 2840 PRIMARY KEY (`contactId`) 2841) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2842 2843DROP TABLE IF EXISTS `tiki_webmail_contacts_groups`; 2844CREATE TABLE `tiki_webmail_contacts_groups` ( 2845 `contactId` int(12) NOT NULL, 2846 `groupName` varchar(255) NOT NULL, 2847 PRIMARY KEY (`contactId`,`groupName`(179)) 2848) ENGINE=MyISAM ; 2849 2850DROP TABLE IF EXISTS `tiki_wiki_attachments`; 2851CREATE TABLE `tiki_wiki_attachments` ( 2852 `attId` int(12) NOT NULL auto_increment, 2853 `page` varchar(200) NOT NULL default '', 2854 `filename` varchar(255) default NULL, 2855 `filetype` varchar(80) default NULL, 2856 `filesize` int(14) default NULL, 2857 `user` varchar(200) default NULL, 2858 `data` longblob, 2859 `path` varchar(255) default NULL, 2860 `hits` int(10) default NULL, 2861 `created` int(14) default NULL, 2862 `comment` varchar(250) default NULL, 2863 PRIMARY KEY (`attId`), 2864 KEY `page` (page(191)) 2865) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2866 2867DROP TABLE IF EXISTS `tiki_zones`; 2868CREATE TABLE `tiki_zones` ( 2869 `zone` varchar(40) NOT NULL default '', 2870 PRIMARY KEY (`zone`) 2871) ENGINE=MyISAM; 2872 2873DROP TABLE IF EXISTS `tiki_download`; 2874CREATE TABLE `tiki_download` ( 2875 `id` int(11) NOT NULL auto_increment, 2876 `object` varchar(255) NOT NULL default '', 2877 `userId` int(8) NOT NULL default '0', 2878 `type` varchar(20) NOT NULL default '', 2879 `date` int(14) NOT NULL default '0', 2880 `IP` varchar(50) NOT NULL default '', 2881 PRIMARY KEY (`id`), 2882 KEY `object` (object(163),`userId`,type), 2883 KEY `userId` (`userId`), 2884 KEY `type` (type), 2885 KEY `date` (date) 2886) ENGINE=MyISAM; 2887 2888DROP TABLE IF EXISTS `users_grouppermissions`; 2889CREATE TABLE `users_grouppermissions` ( 2890 `groupName` varchar(255) NOT NULL default '', 2891 `permName` varchar(40) NOT NULL default '', 2892 `value` char(1) default '', 2893 PRIMARY KEY (`groupName`(30),`permName`) 2894) ENGINE=MyISAM; 2895 2896 2897INSERT INTO users_grouppermissions (`groupName`,`permName`) 2898 VALUES('Anonymous','tiki_p_view'),('Anonymous','tiki_p_search'),('Anonymous','tiki_p_download_files'); 2899 2900DROP TABLE IF EXISTS `users_groups`; 2901CREATE TABLE `users_groups` ( 2902 `id` int(11) NOT NULL auto_increment, 2903 `groupName` varchar(255) NOT NULL default '', 2904 `groupDesc` varchar(255) default NULL, 2905 `groupHome` varchar(255), 2906 `usersTrackerId` int(11), 2907 `groupTrackerId` int(11), 2908 `usersFieldId` int(11), 2909 `groupFieldId` int(11), 2910 `registrationChoice` char(1) default NULL, 2911 `registrationUsersFieldIds` text, 2912 `userChoice` char(1) default NULL, 2913 `groupDefCat` int(12) default 0, 2914 `groupTheme` varchar(255) default '', 2915 `groupColor` VARCHAR(20) NOT NULL DEFAULT '', 2916 `isExternal` char(1) default 'n', 2917 `expireAfter` int(14) default 0, 2918 `emailPattern` varchar(255) default '', 2919 `anniversary` char(4) default '', 2920 `prorateInterval` varchar(255) default '', 2921 `isRole` char(1) DEFAULT 'n', 2922 `isTplGroup` char(1) DEFAULT 'n', 2923 PRIMARY KEY (`id`), 2924 UNIQUE KEY `groupName` (`groupName` (191)), 2925 KEY `expireAfter` (`expireAfter`) 2926) ENGINE=MyISAM AUTO_INCREMENT=1; 2927 2928DROP TABLE IF EXISTS `users_objectpermissions`; 2929CREATE TABLE `users_objectpermissions` ( 2930 `groupName` varchar(255) NOT NULL default '', 2931 `permName` varchar(40) NOT NULL default '', 2932 `objectType` varchar(20) NOT NULL default '', 2933 `objectId` varchar(32) NOT NULL default '', 2934 PRIMARY KEY `uo` (`objectId`, `objectType`, `groupName`(99),`permName`) 2935) ENGINE=MyISAM; 2936 2937DROP TABLE IF EXISTS `users_permissions`; 2938CREATE TABLE `users_permissions` ( 2939 `permName` varchar(40) NOT NULL default '', 2940 `level` varchar(80) default NULL, 2941 PRIMARY KEY (`permName`) 2942) ENGINE=MyISAM; 2943 2944DROP TABLE IF EXISTS `users_usergroups`; 2945CREATE TABLE `users_usergroups` ( 2946 `userId` int(8) NOT NULL default '0', 2947 `groupName` varchar(255) NOT NULL default '', 2948 `created` int(14) default NULL, 2949 `expire` int(14) default NULL, 2950 PRIMARY KEY (`userId`,`groupName`(183)) 2951) ENGINE=MyISAM; 2952 2953INSERT INTO users_groups (`groupName`,`groupDesc`) VALUES ('Anonymous','Public users not logged'); 2954INSERT INTO users_groups (`groupName`,`groupDesc`) VALUES ('Registered','Users logged into the system'); 2955INSERT INTO users_groups (`groupName`,`groupDesc`) VALUES ('Admins','Administrator and accounts managers.'); 2956 2957DROP TABLE IF EXISTS `users_users`; 2958CREATE TABLE `users_users` ( 2959 `userId` int(8) NOT NULL auto_increment, 2960 `email` varchar(200) default NULL, 2961 `login` varchar(200) NOT NULL default '', 2962 `provpass` varchar(30) default NULL, 2963 `default_group` varchar(255), 2964 `lastLogin` int(14) default NULL, 2965 `currentLogin` int(14) default NULL, 2966 `registrationDate` int(14) default NULL, 2967 `pass_confirm` int(14) default NULL, 2968 `email_confirm` int(14) default NULL, 2969 `hash` varchar(60) default NULL, 2970 `created` int(14) default NULL, 2971 `avatarName` varchar(80) default NULL, 2972 `avatarSize` int(14) default NULL, 2973 `avatarFileType` varchar(250) default NULL, 2974 `avatarData` longblob, 2975 `avatarLibName` varchar(200) default NULL, 2976 `avatarType` char(1) default NULL, 2977 `valid` varchar(32) default NULL, 2978 `unsuccessful_logins` int(14) default 0, 2979 `openid_url` varchar(255) default NULL, 2980 `waiting` char(1) default NULL, 2981 `twoFactorSecret` varchar(16) default NULL, 2982 PRIMARY KEY (`userId`), 2983 UNIQUE KEY `login` (login (191)), 2984 KEY `registrationDate` (`registrationDate`), 2985 KEY `openid_url` (openid_url(191)) 2986) ENGINE=MyISAM AUTO_INCREMENT=1 ; 2987 2988-- Administrator account 2989INSERT INTO users_users(email,login,hash,created,registrationDate) VALUES ('','admin','$2y$10$nzMJ64PLyjKqgKvqSvO/S.n8jtgAiRzmNMYPLq/TQVLfYIFa0xqkG',UNIX_TIMESTAMP(),UNIX_TIMESTAMP()); 2990INSERT INTO tiki_user_preferences (user,`prefName`,value) VALUES ('admin','realName','System Administrator'); 2991INSERT INTO users_usergroups (`userId`, `groupName`) VALUES(1,'Admins'); 2992INSERT INTO users_grouppermissions (`groupName`, `permName`) VALUES ('Admins','tiki_p_admin'); 2993 2994DROP TABLE IF EXISTS `tiki_integrator_reps`; 2995CREATE TABLE `tiki_integrator_reps` ( 2996 `repID` int(11) NOT NULL auto_increment, 2997 `name` varchar(255) NOT NULL default '', 2998 `path` varchar(255) NOT NULL default '', 2999 `start_page` varchar(255) NOT NULL default '', 3000 `css_file` varchar(255) NOT NULL default '', 3001 `visibility` char(1) NOT NULL default 'y', 3002 `cacheable` char(1) NOT NULL default 'y', 3003 `expiration` int(11) NOT NULL default '0', 3004 `description` text NOT NULL, 3005 PRIMARY KEY (`repID`) 3006) ENGINE=MyISAM; 3007 3008INSERT 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 :)'); 3009 3010DROP TABLE IF EXISTS `tiki_integrator_rules`; 3011CREATE TABLE `tiki_integrator_rules` ( 3012 `ruleID` int(11) NOT NULL auto_increment, 3013 `repID` int(11) NOT NULL default '0', 3014 `ord` int(2) unsigned NOT NULL default '0', 3015 `srch` blob NOT NULL, 3016 `repl` blob NOT NULL, 3017 `type` char(1) NOT NULL default 'n', 3018 `casesense` char(1) NOT NULL default 'y', 3019 `rxmod` varchar(20) NOT NULL default '', 3020 `enabled` char(1) NOT NULL default 'n', 3021 `description` text NOT NULL, 3022 PRIMARY KEY (`ruleID`), 3023 KEY `repID` (repID) 3024) ENGINE=MyISAM; 3025 3026INSERT INTO tiki_integrator_rules VALUES ('1','1','1','.*<body[^>]*?>(.*?)</body.*','\1','y','n','i','y','Extract code between <body> and </body> tags'); 3027INSERT INTO tiki_integrator_rules VALUES ('2','1','2','img src=(\"|\')(?!http://)','img src=\1{path}/','y','n','i','y','Fix image paths'); 3028INSERT INTO tiki_integrator_rules VALUES ('3','1','3','href=(\"|\')(?!(#|(http|ftp)://))','href=\1tiki-integrator.php?repID={repID}&file=','y','n','i','y','Replace internal links to integrator. Don not touch an external link.'); 3029 3030-- Translated objects table 3031DROP TABLE IF EXISTS `tiki_translated_objects`; 3032CREATE TABLE `tiki_translated_objects` ( 3033 `traId` int(14) NOT NULL auto_increment, 3034 `type` varchar(50) NOT NULL, 3035 `objId` varchar(255) NOT NULL, 3036 `lang` varchar(16) default NULL, 3037 PRIMARY KEY (`type`, `objId`(141)), 3038 KEY `traId` ( `traId` ) 3039) ENGINE=MyISAM AUTO_INCREMENT=1; 3040 3041DROP TABLE IF EXISTS `tiki_score`; 3042CREATE TABLE `tiki_score` ( 3043 event varchar(255) NOT NULL default '', 3044 data text, 3045 reversalEvent varchar(255), 3046 PRIMARY KEY (`event`(191)) 3047) ENGINE=MyISAM; 3048 3049INSERT INTO `tiki_score` VALUES 3050('tiki.user.login','[ 3051 {"ruleId":"User logs in","recipientType":"user","recipient":"user","score":"1","validObjectIds":[""],"expiration":""} 3052]',''), 3053('tiki.user.view','[ 3054 {"ruleId":"See other user\'s profile","recipientType":"user","recipient":"user","score":"2","validObjectIds":[""],"expiration":""}, 3055 {"ruleId":"Have your profile seen","recipientType":"user","recipient":"object","score":"1","validObjectIds":[""],"expiration":""} 3056]',''), 3057('tiki.user.friend','[ 3058 {"ruleId":"Make friends","recipientType":"user","recipient":"user","score":"10","validObjectIds":[""],"expiration":""} 3059]',''), 3060('tiki.user.message','[ 3061 {"ruleId":"Send message","recipientType":"user","recipient":"user","score":"2","validObjectIds":[""],"expiration":""}, 3062 {"ruleId":"Receive message","recipientType":"user","recipient":"object","score":"1","validObjectIds":[""],"expiration":""} 3063]',''), 3064('tiki.article.create','[ 3065 {"ruleId":"Publish new article","recipientType":"user","recipient":"user","score":"20","validObjectIds":[""],"expiration":""} 3066]',''), 3067('tiki.article.view','[ 3068 {"ruleId":"Read an article","recipientType":"user","recipient":"user","score":"2","validObjectIds":[""],"expiration":""}, 3069 {"ruleId":"Have your article read","recipientType":"user","recipient":"author","score":"1","validObjectIds":[""],"expiration":""} 3070]',''), 3071('tiki.filegallery.create','[ 3072 {"ruleId":"Create new file gallery","recipientType":"user","recipient":"user","score":"10","validObjectIds":[""],"expiration":""} 3073]',''), 3074('tiki.file.create','[ 3075 {"ruleId":"Upload new file to gallery","recipientType":"user","recipient":"user","score":"10","validObjectIds":[""],"expiration":""} 3076]',''), 3077('tiki.file.download','[ 3078 {"ruleId":"Download other user\'s file","recipientType":"user","recipient":"user","score":"5","validObjectIds":[""],"expiration":""}, 3079 {"ruleId":"Have your file downloaded","recipientType":"user","recipient":"owner","score":"5","validObjectIds":[""],"expiration":""} 3080]',''), 3081('tiki.imagegallery.create','[ 3082 {"ruleId":"Create new image gallery","recipientType":"user","recipient":"user","score":"10","validObjectIds":[""],"expiration":""} 3083]',''), 3084('tiki.image.create','[ 3085 {"ruleId":"Upload new image to gallery","recipientType":"user","recipient":"user","score":"6","validObjectIds":[""],"expiration":""} 3086]',''), 3087('tiki.image.view','[ 3088 {"ruleId":"See other user\'s image","recipientType":"user","recipient":"user","score":"3","validObjectIds":[""],"expiration":""}, 3089 {"ruleId":"Have your image seen","recipientType":"user","recipient":"owner","score":"1","validObjectIds":[""],"expiration":""} 3090]',''), 3091('tiki.blog.create','[ 3092 {"ruleId":"Create new blog","recipientType":"user","recipient":"user","score":"20","validObjectIds":[""],"expiration":""} 3093]',''), 3094('tiki.blogpost.create','[ 3095 {"ruleId":"Post in a blog","recipientType":"user","recipient":"user","score":"5","validObjectIds":[""],"expiration":""} 3096]',''), 3097('tiki.blog.view','[ 3098 {"ruleId":"Read other user\'s blog","recipientType":"user","recipient":"user","score":"2","validObjectIds":[""],"expiration":""}, 3099 {"ruleId":"Have your blog read","recipientType":"user","recipient":"author","score":"3","validObjectIds":[""],"expiration":""} 3100]',''), 3101('tiki.wiki.create','[ 3102 {"ruleId":"Create a wiki page","recipientType":"user","recipient":"user","score":"10","validObjectIds":[""],"expiration":""} 3103]',''), 3104('tiki.wiki.update','[ 3105 {"ruleId":"Edit an existing wiki page","recipientType":"user","recipient":"user","score":"5","validObjectIds":[""],"expiration":""} 3106]',''), 3107('tiki.wiki.attachfile','[ 3108 {"ruleId":"Attach file to wiki page","recipientType":"user","recipient":"user","score":"3","validObjectIds":[""],"expiration":""} 3109]',''); 3110 3111DROP TABLE IF EXISTS `tiki_object_scores`; 3112CREATE TABLE `tiki_object_scores` ( 3113 `id` INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 3114 `triggerObjectType` VARCHAR(255) NOT NULL, 3115 `triggerObjectId` VARCHAR(255) NOT NULL, 3116 `triggerUser` VARCHAR(255) NOT NULL, 3117 `triggerEvent` VARCHAR(255) NOT NULL, 3118 `ruleId` VARCHAR(255) NOT NULL, 3119 `recipientObjectType` VARCHAR(255) NOT NULL, 3120 `recipientObjectId` VARCHAR(255) NOT NULL, 3121 `pointsAssigned` INT NOT NULL, 3122 `pointsBalance` INT NOT NULL, 3123 `date` INT NOT NULL, 3124 `reversalOf` INT UNSIGNED 3125) ENGINE=MyISAM; 3126 3127DROP TABLE IF EXISTS `tiki_file_handlers`; 3128CREATE TABLE `tiki_file_handlers` ( 3129 `mime_type` varchar(128) default NULL, 3130 `cmd` varchar(238) default NULL 3131) ENGINE=MyISAM; 3132 3133DROP TABLE IF EXISTS `tiki_stats`; 3134CREATE TABLE `tiki_stats` ( 3135 `object` varchar(255) NOT NULL default '', 3136 `type` varchar(20) NOT NULL default '', 3137 `day` int(14) NOT NULL default '0', 3138 `hits` int(14) NOT NULL default '0', 3139 PRIMARY KEY (`object`(157),`type`,`day`) 3140) ENGINE=MyISAM; 3141 3142DROP TABLE IF EXISTS `tiki_registration_fields`; 3143CREATE TABLE `tiki_registration_fields` ( 3144 `id` int(11) NOT NULL auto_increment, 3145 `field` varchar(255) NOT NULL default '', 3146 `name` varchar(255) default NULL, 3147 `type` varchar(255) NOT NULL default 'text', 3148 `show` tinyint(1) NOT NULL default '1', 3149 `size` varchar(10) default '10', 3150 PRIMARY KEY (`id`) 3151) ENGINE=MyISAM; 3152 3153DROP TABLE IF EXISTS `tiki_actionlog_conf`; 3154CREATE TABLE `tiki_actionlog_conf` ( 3155 `id` int(11) NOT NULL auto_increment, 3156 `action` varchar(32) NOT NULL default '', 3157 `objectType` varchar(32) NOT NULL default '', 3158 `status` char(1) default '', 3159 PRIMARY KEY (`action`, `objectType`), 3160 KEY (id) 3161) ENGINE=MyISAM; 3162 3163INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Created', 'wiki page', 'y'); 3164INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Updated', 'wiki page', 'y'); 3165INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed', 'wiki page', 'y'); 3166INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Viewed', 'wiki page', 'n'); 3167INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Viewed', 'forum', 'n'); 3168INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Posted', 'forum', 'n'); 3169INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Replied', 'forum', 'n'); 3170INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Updated', 'forum', 'n'); 3171INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Viewed', 'file gallery', 'n'); 3172INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Viewed', 'image gallery', 'n'); 3173INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Uploaded', 'file gallery', 'n'); 3174INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Uploaded', 'image gallery', 'n'); 3175INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('%', 'category', 'n'); 3176INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('login', 'system', 'y'); 3177INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Posted', 'message', 'n'); 3178INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Replied', 'message', 'n'); 3179INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Viewed', 'message', 'n'); 3180INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed version', 'wiki page', 'n'); 3181INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed last version', 'wiki page', 'n'); 3182INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Rollback', 'wiki page', 'n'); 3183INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed', 'forum', 'n'); 3184INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Downloaded', 'file gallery', 'n'); 3185INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Posted', 'comment', 'n'); 3186INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Replied', 'comment', 'n'); 3187INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Updated', 'comment', 'n'); 3188INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed', 'comment', 'n'); 3189INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Renamed', 'wiki page', 'n'); 3190INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Created', 'sheet', 'n'); 3191INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Updated', 'sheet', 'n'); 3192INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed', 'sheet', 'n'); 3193INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Viewed', 'sheet', 'n'); 3194INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Viewed', 'blog', 'n'); 3195INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Posted', 'blog', 'n'); 3196INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Updated', 'blog', 'n'); 3197INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed', 'blog', 'n'); 3198INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed', 'file', 'n'); 3199INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Viewed', 'article', 'n'); 3200INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('%', 'system', 'y'); 3201INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('feature', 'system', 'y'); 3202INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Updated', 'trackeritem', 'y'); 3203INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Created', 'trackeritem', 'y'); 3204INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Viewed', 'trackeritem', 'y'); 3205INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed', 'trackeritem', 'y'); 3206INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Created', 'wiki page attachment', 'n'); 3207INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed', 'wiki page attachment', 'n'); 3208INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Categorized', 'wiki page', 'n'); 3209INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Uncategorized', 'wiki page', 'n'); 3210INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Flagged', 'wiki page', 'n'); 3211INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Fetch', 'url', 'n'); 3212INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Refresh', 'url', 'n'); 3213INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Joined Room', 'bigbluebutton', 'n'); 3214INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Left Room', 'bigbluebutton', 'n'); 3215INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Created', 'tracker', 'y'); 3216INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Updated', 'tracker', 'y'); 3217INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed', 'tracker', 'y'); 3218INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Created', 'category', 'y'); 3219INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Updated', 'category', 'y'); 3220INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed', 'category', 'y'); 3221INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Created', 'calendar event', 'n'); 3222INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Updated', 'calendar event', 'n'); 3223INSERT IGNORE INTO tiki_actionlog_conf(action, `objectType`, status) VALUES ('Removed', 'calendar event', 'n'); 3224 3225DROP TABLE IF EXISTS `tiki_freetags`; 3226CREATE TABLE `tiki_freetags` ( 3227 `tagId` int(10) unsigned NOT NULL auto_increment, 3228 `tag` varchar(128) NOT NULL default '', 3229 `raw_tag` varchar(150) NOT NULL default '', 3230 `lang` varchar(16) NULL, 3231 PRIMARY KEY (`tagId`) 3232) ENGINE=MyISAM; 3233 3234DROP TABLE IF EXISTS `tiki_freetagged_objects`; 3235CREATE TABLE `tiki_freetagged_objects` ( 3236 `tagId` int(12) NOT NULL auto_increment, 3237 `objectId` int(11) NOT NULL default 0, 3238 `user` varchar(200) default '', 3239 `created` int(14) NOT NULL default '0', 3240 PRIMARY KEY (`tagId`,`user`(168),`objectId`), 3241 KEY (`tagId`), 3242 KEY (user(191)), 3243 KEY (`objectId`) 3244) ENGINE=MyISAM; 3245 3246DROP TABLE IF EXISTS `tiki_contributions`; 3247CREATE TABLE `tiki_contributions` ( 3248 `contributionId` int(12) NOT NULL auto_increment, 3249 `name` varchar(100) default NULL, 3250 `description` varchar(250) default NULL, 3251 PRIMARY KEY (`contributionId`) 3252) ENGINE=MyISAM; 3253 3254DROP TABLE IF EXISTS `tiki_contributions_assigned`; 3255CREATE TABLE `tiki_contributions_assigned` ( 3256 `contributionId` int(12) NOT NULL, 3257 `objectId` int(12) NOT NULL, 3258 PRIMARY KEY (`objectId`, `contributionId`) 3259) ENGINE=MyISAM; 3260 3261DROP TABLE IF EXISTS `tiki_webmail_contacts_ext`; 3262CREATE TABLE `tiki_webmail_contacts_ext` ( 3263 `contactId` int(11) NOT NULL, 3264 `value` varchar(255) NOT NULL, 3265 `hidden` tinyint(1) NOT NULL, 3266 `fieldId` int(10) unsigned NOT NULL, 3267 KEY `contactId` (`contactId`) 3268) ENGINE=MyISAM; 3269 3270DROP TABLE IF EXISTS `tiki_webmail_contacts_fields`; 3271CREATE TABLE `tiki_webmail_contacts_fields` ( 3272 `user` VARCHAR( 200 ) NOT NULL , 3273 `fieldname` VARCHAR( 255 ) NOT NULL , 3274 `order` int(2) NOT NULL default '0', 3275 `show` char(1) NOT NULL default 'n', 3276 `fieldId` int(10) unsigned NOT NULL auto_increment, 3277 `flagsPublic` CHAR( 1 ) NOT NULL DEFAULT 'n', 3278 PRIMARY KEY ( `fieldId` ), 3279 INDEX ( `user` (191)) 3280) ENGINE = MyISAM ; 3281 3282DROP TABLE IF EXISTS `tiki_pages_translation_bits`; 3283CREATE TABLE `tiki_pages_translation_bits` ( 3284 `translation_bit_id` int(14) NOT NULL auto_increment, 3285 `page_id` int(14) NOT NULL, 3286 `version` int(8) NOT NULL, 3287 `source_translation_bit` int(10) NULL, 3288 `original_translation_bit` int(10) NULL, 3289 `flags` SET('critical') NULL DEFAULT '', 3290 PRIMARY KEY (`translation_bit_id`), 3291 KEY (`page_id`), 3292 KEY (`original_translation_bit`), 3293 KEY (`source_translation_bit`) 3294) ENGINE=MyISAM; 3295 3296DROP TABLE IF EXISTS `tiki_pages_changes`; 3297CREATE TABLE `tiki_pages_changes` ( 3298 `page_id` int(14) DEFAULT '0', 3299 `version` int(10) DEFAULT '0', 3300 `segments_added` int(10), 3301 `segments_removed` int(10), 3302 `segments_total` int(10), 3303 PRIMARY KEY (page_id, version) 3304) ENGINE=MyISAM; 3305 3306DROP TABLE IF EXISTS `tiki_minichat`; 3307CREATE TABLE `tiki_minichat` ( 3308 `id` int(10) unsigned NOT NULL auto_increment, 3309 `channel` varchar(31), 3310 `ts` int(10) unsigned NOT NULL, 3311 `user` varchar(31) default NULL, 3312 `nick` varchar(31) default NULL, 3313 `msg` varchar(255) NOT NULL, 3314 PRIMARY KEY (`id`), 3315 KEY `channel` (`channel`) 3316) ENGINE=MyISAM; 3317 3318DROP TABLE IF EXISTS `tiki_profile_symbols`; 3319CREATE TABLE `tiki_profile_symbols` ( 3320 `domain` VARCHAR(50) NOT NULL, 3321 `profile` VARCHAR(100) NOT NULL, 3322 `object` VARCHAR(150) NOT NULL, 3323 `type` VARCHAR(20) NOT NULL, 3324 `value` VARCHAR(160) NOT NULL, 3325 `named` ENUM('y','n') NOT NULL, 3326 `creation_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 3327 PRIMARY KEY ( `domain`, `profile`(70), `object`(71) ), 3328 INDEX(`named`) 3329) ENGINE=MyISAM; 3330 3331DROP TABLE IF EXISTS `tiki_feature`; 3332CREATE TABLE `tiki_feature` ( 3333 `feature_id` mediumint(9) NOT NULL auto_increment, 3334 `feature_name` varchar(150) NOT NULL, 3335 `parent_id` mediumint(9) NOT NULL, 3336 `status` varchar(12) NOT NULL default 'active', 3337 `setting_name` varchar(50) default NULL, 3338 `feature_type` varchar(30) NOT NULL default 'feature', 3339 `template` varchar(50) default NULL, 3340 `permission` varchar(50) default NULL, 3341 `ordinal` mediumint(9) NOT NULL default '1', 3342 `depends_on` mediumint(9) default NULL, 3343 `keyword` varchar(30) default NULL, 3344 `tip` text NULL, 3345 `feature_count` mediumint(9) NOT NULL default '0', 3346 `feature_path` varchar(20) NOT NULL default '0', 3347 PRIMARY KEY (`feature_id`) 3348) ENGINE=MyISAM AUTO_INCREMENT=1; 3349 3350DROP TABLE IF EXISTS `tiki_schema`; 3351CREATE TABLE `tiki_schema` ( 3352 `patch_name` VARCHAR(100) PRIMARY KEY, 3353 `install_date` TIMESTAMP 3354) ENGINE=MyISAM; 3355 3356DROP TABLE IF EXISTS `tiki_semantic_tokens`; 3357CREATE TABLE `tiki_semantic_tokens` ( 3358 `token` VARCHAR(15) PRIMARY KEY, 3359 `label` VARCHAR(25) NOT NULL, 3360 `invert_token` VARCHAR(15) 3361) ENGINE=MyISAM ; 3362 3363INSERT INTO tiki_semantic_tokens (token, label) VALUES('alias', 'Page Alias'); 3364INSERT INTO tiki_semantic_tokens (token, label) VALUES('prefixalias', 'Page Prefix Alias'); 3365INSERT INTO tiki_semantic_tokens (token, label) VALUES('titlefieldid', 'Field Id for Page Title'),('trackerid', 'Id of Embedded Tracker'); 3366 3367 3368DROP TABLE IF EXISTS `tiki_webservice`; 3369CREATE TABLE `tiki_webservice` ( 3370 `service` VARCHAR(25) NOT NULL PRIMARY KEY, 3371 `url` VARCHAR(250), 3372 `wstype` CHAR(4), 3373 `operation` VARCHAR(250), 3374 `body` TEXT, 3375 `schema_version` VARCHAR(5), 3376 `schema_documentation` VARCHAR(250) 3377) ENGINE=MyISAM ; 3378 3379DROP TABLE IF EXISTS `tiki_webservice_template`; 3380CREATE TABLE `tiki_webservice_template` ( 3381 `service` VARCHAR(25) NOT NULL, 3382 `template` VARCHAR(25) NOT NULL, 3383 `engine` VARCHAR(15) NOT NULL, 3384 `output` VARCHAR(15) NOT NULL, 3385 `content` TEXT NOT NULL, 3386 `last_modif` INT, 3387 PRIMARY KEY ( service, template ) 3388) ENGINE=MyISAM ; 3389 3390DROP TABLE IF EXISTS `tiki_groupalert`; 3391CREATE TABLE `tiki_groupalert` ( 3392 `groupName` varchar(255) NOT NULL default '', 3393 `objectType` varchar( 20 ) NOT NULL default '', 3394 `objectId` varchar(10) NOT NULL default '', 3395 `displayEachuser` char( 1 ) default NULL , 3396 PRIMARY KEY (`groupName`(161), `objectType`, `objectId` ) 3397) ENGINE=MyISAM ; 3398 3399DROP TABLE IF EXISTS `tiki_sent_newsletters_files`; 3400CREATE TABLE `tiki_sent_newsletters_files` ( 3401 `id` int(11) NOT NULL auto_increment, 3402 `editionId` int(11) NOT NULL, 3403 `name` varchar(256) NOT NULL, 3404 `type` varchar(64) NOT NULL, 3405 `size` int(11) NOT NULL, 3406 `filename` varchar(256) NOT NULL, 3407 PRIMARY KEY (`id`), 3408 KEY `editionId` (`editionId`) 3409) ENGINE=MyISAM; 3410 3411DROP TABLE IF EXISTS `tiki_sefurl_regex_out`; 3412CREATE TABLE `tiki_sefurl_regex_out` ( 3413 `id` int(11) NOT NULL auto_increment, 3414 `left` varchar(256) NOT NULL, 3415 `right` varchar(256) NULL default NULL, 3416 `type` varchar(32) NULL default NULL, 3417 `silent` char(1) NULL default 'n', 3418 `feature` varchar(256) NULL default NULL, 3419 `comment` varchar(256), 3420 `order` int(11) NULL default 0, 3421 PRIMARY KEY (`id`), 3422 UNIQUE KEY `left` (`left`(128)), 3423 INDEX `idx1` (silent, type, feature(30)) 3424) ENGINE=MyISAM; 3425 3426INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-index.php\\?page=(.+)', '$1', 'wiki', 'feature_wiki'); 3427INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-slideshow.php\\?page=(.+)', 'show:$1', '', 'feature_wiki'); 3428INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-read_article.php\\?articleId=(\\d+)', 'article$1', 'article', 'feature_articles'); 3429INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-browse_categories.php\\?parentId=(\\d+)', 'cat$1', 'category', 'feature_categories'); 3430INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_blog.php\\?blogId=(\\d+)', 'blog$1', 'blog', 'feature_blogs'); 3431INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_blog_post.php\\?postId=(\\d+)', 'blogpost$1', 'blogpost', 'feature_blogs'); 3432INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-browse_image.php\\?imageId=(\\d+)', 'browseimage$1', 'image', 'feature_galleries'); 3433INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-directory_browse.php\\?parent=(\\d+)', 'directory$1', 'directory', 'feature_directory'); 3434INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_faq.php\\?faqId=(\\d+)', 'faq$1', 'faq', 'feature_faqs'); 3435INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-download_file.php\\?fileId=(\\d+)', 'dl$1', 'file', 'feature_file_galleries', 10); 3436INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-download_file.php\\?fileId=(\\d+)&thumbnail', 'thumbnail$1', 'thumbnail', 'feature_file_galleries'); 3437INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-download_file.php\\?fileId=(\\d+)&display', 'display$1', 'display', 'feature_file_galleries'); 3438INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-download_file.php\\?fileId=(\\d+)&preview', 'preview$1', 'preview', 'feature_file_galleries'); 3439INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_forum.php\\?forumId=(\\d+)', 'forum$1', 'forum', 'feature_forums'); 3440INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-browse_gallery.php\\?galleryId=(\\d+)', 'gallery$1', 'gallery', 'feature_galleries'); 3441INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('show_image.php\\?id=(\\d+)', 'image$1', 'image', 'feature_galleries'); 3442INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('show_image.php\\?id=(\\d+)&scalesize=(\\d+)', 'imagescale$1/$2', 'image', 'feature_galleries'); 3443INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-newsletters.php\\?nlId=(\\d+)', 'newsletter$1', 'newsletter', 'feature_newsletters'); 3444INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-take_quiz.php\\?quizId=(\\d+)', 'quiz$1', 'quiz', 'feature_quizzes'); 3445INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-take_survey.php\\?surveyId=(\\d+)', 'survey$1', 'survey', 'feature_surveys'); 3446INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_tracker.php\\?trackerId=(\\d+)', 'tracker$1', 'tracker', 'feature_trackers'); 3447INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-integrator.php\\?repID=(\\d+)', 'int$1', '', 'feature_integrator'); 3448INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_sheets.php\\?sheetId=(\\d+)', 'sheet$1', 'sheet', 'feature_sheet'); 3449INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-directory_redirect.php\\?siteId=(\\d+)', 'dirlink$1', 'directory', 'feature_directory'); 3450INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3,$4,$5,$6,$7', '7', 'calendar', 'feature_calendar', 100); 3451INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3,$4,$5,$6', '6', 'calendar', 'feature_calendar', 101); 3452INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3,$4,$5', '5', 'calendar', 'feature_calendar', 102); 3453INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3,$4', '4', 'calendar', 'feature_calendar', 103); 3454INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3', '3', 'calendar', 'feature_calendar', 104); 3455INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)&calIds\\[\\]=(\\d+)', 'cal$1,$2', '2', 'calendar', 'feature_calendar', 105); 3456INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)', 'cal$1', '1', 'calendar', 'feature_calendar', 106); 3457INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-calendar.php', 'calendar', 'calendar', 'feature_calendar', 200); 3458INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-view_articles.php', 'articles', '', 'feature_articles', 200); 3459INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_blogs.php', 'blogs', '', 'feature_blogs', 200); 3460INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-browse_categories.php', 'categories', '', 'feature_categories', 200); 3461INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-contact.php', 'contact', '', 'feature_contact', 200); 3462INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-directory_browse.php', 'directories', '', 'feature_directory', 200); 3463INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_faqs.php', 'faqs', '', 'feature_faqs', 200); 3464INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-file_galleries.php', 'files', '', 'feature_file_galleries', 200); 3465INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-forums.php', 'forums', '', 'feature_forums', 200); 3466INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-galleries.php', 'galleries', '', 'feature_galleries', 200); 3467INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-login_scr.php', 'login', '', '', 200); 3468INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-my_tiki.php', 'my', '', '', 200); 3469INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-newsletters.php', 'newsletters', 'newsletter', 'feature_newsletters', 200); 3470INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_quizzes.php', 'quizzes', '', 'feature_quizzes', 200); 3471INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-stats.php', 'statistics', '', 'feature_stats', 200); 3472INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_surveys.php', 'surveys', '', 'feature_surveys', 200); 3473INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_trackers.php', 'trackers', 'tracker', 'feature_trackers', 200); 3474INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-sheets.php', 'sheets', '', 'feature_sheet', 200); 3475INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-view_tracker_item.php\\?trackerId=(\\d+)\\&itemId=(\\d+)', 'item$2', 'trackeritem', 'feature_trackers', 200); 3476INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-view_tracker_item.php\\?itemId=(\\d+)', 'item$1', 'trackeritem', 'feature_trackers', 200); 3477INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_file_gallery.php\\?galleryId=(\\d+)', 'file$1', 'file gallery', 'feature_file_galleries', 200); 3478INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-user_information.php\\?userId=(\\d+)','user$1', '', '', 200); 3479INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-view_forum_thread.php\\?comments_parentId=(\\d+)', 'forumthread$1', 'forumthread', 'feature_forums', 0); 3480 3481UPDATE tiki_menu_options SET icon = 'icon-configuration48x48' WHERE name = 'Settings'; 3482UPDATE tiki_menu_options SET icon = 'xfce4-appfinder48x48' WHERE name = 'Search'; 3483UPDATE tiki_menu_options SET icon = 'wikipages48x48' WHERE name = 'Wiki'; 3484UPDATE tiki_menu_options SET icon = 'blogs48x48' WHERE name = 'Blogs'; 3485UPDATE tiki_menu_options SET icon = 'stock_select-color48x48' WHERE name = 'Image Galleries'; 3486UPDATE tiki_menu_options SET icon = 'file-manager48x48' WHERE name = 'File Galleries'; 3487UPDATE tiki_menu_options SET icon = 'stock_bold48x48' WHERE name = 'Articles'; 3488UPDATE tiki_menu_options SET icon = 'stock_index48x48' WHERE name = 'Forums'; 3489UPDATE tiki_menu_options SET icon = 'gnome-settings-font48x48' WHERE name = 'Trackers'; 3490UPDATE tiki_menu_options SET icon = 'users48x48' WHERE name = 'Community'; 3491UPDATE tiki_menu_options SET icon = 'stock_dialog_question48x48' WHERE name = 'FAQs'; 3492UPDATE tiki_menu_options SET icon = 'maps48x48' WHERE name = 'Maps'; 3493UPDATE tiki_menu_options SET icon = 'messages48x48' WHERE name = 'Newsletters'; 3494UPDATE tiki_menu_options SET icon = 'vcard48x48' WHERE name = 'Tags'; 3495UPDATE tiki_menu_options SET icon = 'date48x48' WHERE name = 'Calendar' AND url = 'tiki-calendar.php'; 3496UPDATE tiki_menu_options SET icon = 'userfiles48x48' WHERE name = 'My Account'; 3497UPDATE tiki_menu_options SET icon = 'home48x48' WHERE name = 'Home'; 3498UPDATE tiki_menu_options SET icon = 'categories48x48' WHERE name = 'Categories'; 3499UPDATE tiki_menu_options SET icon = 'accounting48x48' WHERE name = 'Accounting'; 3500UPDATE tiki_menu_options SET icon = 'directory48x48' WHERE name = 'Directory'; 3501UPDATE tiki_menu_options SET icon = 'invoice48x48' WHERE name = 'Invoice'; 3502UPDATE tiki_menu_options SET icon = 'quizzes48x48' WHERE name = 'Quizzes'; 3503UPDATE tiki_menu_options SET icon = 'reports48x48' WHERE name = 'Reports'; 3504UPDATE tiki_menu_options SET icon = 'stats48x48' WHERE name = 'Stats'; 3505UPDATE tiki_menu_options SET icon = 'surveys48x48' WHERE name = 'Surveys'; 3506UPDATE tiki_menu_options SET icon = 'spreadsheet48x48' WHERE name = 'Spreadsheets'; 3507UPDATE tiki_menu_options SET icon = 'timesheet48x48' WHERE name = 'Timesheet'; 3508UPDATE tiki_menu_options SET icon = 'usersmap48x48' WHERE name = 'Users Map'; 3509UPDATE tiki_menu_options SET icon = 'contactus48x48' WHERE name = 'Contact Us'; 3510UPDATE tiki_menu_options SET icon = 'debug48x48' WHERE name = '(debug)'; 3511UPDATE tiki_menu_options SET icon = 'kaltura48x48' WHERE name = 'Kaltura Video'; 3512UPDATE tiki_menu_options SET icon = 'tikicalendar48x48' WHERE name = 'Tiki Calendar'; 3513UPDATE tiki_menu_options SET icon = 'wizard_user48x48' WHERE name = 'User Wizard'; 3514UPDATE tiki_menus SET use_items_icons='y' WHERE `menuId`=42; 3515 3516DROP TABLE IF EXISTS `tiki_plugin_security`; 3517CREATE TABLE `tiki_plugin_security` ( 3518 `fingerprint` VARCHAR(200) NOT NULL, 3519 `status` VARCHAR(10) NOT NULL, 3520 `added_by` VARCHAR(200) NULL, 3521 `approval_by` VARCHAR(200) NULL, 3522 `last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 3523 `last_objectType` VARCHAR(20) NOT NULL, 3524 `last_objectId` VARCHAR(200) NOT NULL, 3525 PRIMARY KEY (`fingerprint`(191)), 3526 KEY `last_object` (last_objectType, last_objectId(171)) 3527) ENGINE=MyISAM; 3528 3529DROP TABLE IF EXISTS `tiki_user_reports`; 3530CREATE TABLE `tiki_user_reports` ( 3531 `id` int(11) NOT NULL AUTO_INCREMENT, 3532 `user` varchar(200) NOT NULL, 3533 `interval` varchar(20) NOT NULL, 3534 `view` varchar(8) NOT NULL, 3535 `type` varchar(5) NOT NULL, 3536 `always_email` tinyint(1) NOT NULL, 3537 `last_report` datetime DEFAULT NULL, 3538 PRIMARY KEY (`id`) 3539) ENGINE=MyISAM; 3540 3541DROP TABLE IF EXISTS `tiki_user_reports_cache`; 3542CREATE TABLE `tiki_user_reports_cache` ( 3543 `id` int(11) NOT NULL AUTO_INCREMENT, 3544 `user` varchar(200) NOT NULL, 3545 `event` varchar(200) NOT NULL, 3546 `data` text NOT NULL, 3547 `time` datetime DEFAULT NULL, 3548 PRIMARY KEY (`id`) 3549) ENGINE=MyISAM; 3550 3551DROP TABLE IF EXISTS `tiki_perspectives`; 3552CREATE TABLE `tiki_perspectives` ( 3553 `perspectiveId` int NOT NULL AUTO_INCREMENT, 3554 `name` varchar(100) NOT NULL, 3555 PRIMARY KEY ( `perspectiveId` ) 3556) ENGINE=MyISAM; 3557 3558DROP TABLE IF EXISTS `tiki_perspective_preferences`; 3559CREATE TABLE `tiki_perspective_preferences` ( 3560 `perspectiveId` int NOT NULL, 3561 `pref` varchar(40) NOT NULL, 3562 `value` text, 3563 PRIMARY KEY ( `perspectiveId`, pref ) 3564) ENGINE=MyISAM; 3565 3566DROP TABLE IF EXISTS `tiki_transitions`; 3567CREATE TABLE `tiki_transitions` ( 3568 `transitionId` int NOT NULL AUTO_INCREMENT, 3569 `preserve` int(1) NOT NULL DEFAULT 0, 3570 `name` varchar(50), 3571 `type` varchar(20) NOT NULL, 3572 `from` varchar(255) NOT NULL, 3573 `to` varchar(255) NOT NULL, 3574 `guards` text, 3575 PRIMARY KEY(`transitionId`), 3576 KEY `transition_lookup` (`type`, `from`(171)) 3577) ENGINE=MyISAM; 3578 3579DROP TABLE IF EXISTS `tiki_auth_tokens`; 3580CREATE TABLE `tiki_auth_tokens` ( 3581 `tokenId` INT NOT NULL AUTO_INCREMENT, 3582 `creation` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 3583 `timeout` INT NOT NULL DEFAULT 0, 3584 `hits` INT NOT NULL DEFAULT 1, 3585 `maxhits` INT NOT NULL DEFAULT 1, 3586 `token` CHAR(32), 3587 `entry` VARCHAR(50), 3588 `email` varchar(255) NOT NULL, 3589 `parameters` VARCHAR(255), 3590 `groups` TEXT, 3591 `createUser` CHAR(1) DEFAULT 'n', 3592 `userPrefix` VARCHAR(200) DEFAULT '_token', 3593 PRIMARY KEY( `tokenId` ), 3594 KEY `tiki_auth_tokens_token` (`token`) 3595) ENGINE=MyISAM; 3596 3597DROP TABLE IF EXISTS `tiki_file_backlinks`; 3598CREATE TABLE `tiki_file_backlinks` ( 3599 `fileId` int(14) NOT NULL, 3600 `objectId` int(12) NOT NULL, 3601 KEY `objectId` (`objectId`), 3602 KEY `fileId` (`fileId`) 3603) ENGINE=MyISAM; 3604 3605DROP TABLE IF EXISTS `tiki_payment_requests`; 3606CREATE TABLE `tiki_payment_requests` ( 3607 `paymentRequestId` INT NOT NULL AUTO_INCREMENT, 3608 `amount` DECIMAL(7,2) NOT NULL, 3609 `amount_paid` DECIMAL(7,2) NOT NULL DEFAULT 0.0, 3610 `currency` CHAR(3) NOT NULL, 3611 `request_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 3612 `due_date` TIMESTAMP NULL, 3613 `authorized_until` TIMESTAMP NULL, 3614 `cancel_date` TIMESTAMP NULL, 3615 `description` VARCHAR(100) NOT NULL, 3616 `actions` TEXT, 3617 `detail` TEXT, 3618 `userId` int(8), 3619 PRIMARY KEY( `paymentRequestId` ) 3620) ENGINE=MyISAM; 3621 3622DROP TABLE IF EXISTS `tiki_payment_received`; 3623CREATE TABLE `tiki_payment_received` ( 3624 `paymentReceivedId` INT NOT NULL AUTO_INCREMENT, 3625 `paymentRequestId` INT NOT NULL, 3626 `payment_date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 3627 `amount` DECIMAL(7,2), 3628 `type` VARCHAR(15), 3629 `status` VARCHAR(15) NOT NULL DEFAULT 'paid', 3630 `details` TEXT, 3631 `userId` int(8), 3632 PRIMARY KEY(`paymentReceivedId`), 3633 KEY `payment_request_ix` (`paymentRequestId`) 3634) ENGINE=MyISAM; 3635DROP TABLE IF EXISTS `tiki_discount`; 3636CREATE TABLE `tiki_discount` ( 3637 `id` INT NOT NULL AUTO_INCREMENT, 3638 `code` VARCHAR(255), 3639 `value` VARCHAR(255), 3640 `max` INT, 3641 `comment` TEXT, 3642 PRIMARY KEY(`id`), 3643 KEY `code` (`code`(191)) 3644) ENGINE=MyISAM; 3645DROP TABLE IF EXISTS `tiki_translations_in_progress`; 3646CREATE TABLE `tiki_translations_in_progress` ( 3647 `page_id` int(14) NOT NULL, 3648 `language` char(2) NOT NULL, 3649 KEY `page_id` (`page_id`), 3650 KEY `language` (`language`), 3651 UNIQUE (`page_id`, `language`) 3652) ENGINE=MyISAM; 3653 3654DROP TABLE IF EXISTS `tiki_rss_items`; 3655CREATE TABLE `tiki_rss_items` ( 3656 `rssItemId` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 3657 `rssId` INT NOT NULL, 3658 `guid` VARCHAR(255) NOT NULL, 3659 `url` TEXT NOT NULL, 3660 `publication_date` INT UNSIGNED NOT NULL, 3661 `title` VARCHAR(255) NOT NULL, 3662 `author` VARCHAR(255), 3663 `description` TEXT, 3664 `content` TEXT, 3665 `categories` TEXT, 3666 KEY `tiki_rss_items_rss` (`rssId`), 3667 KEY `tiki_rss_items_item` (`rssId`, `guid`(177)) 3668) ENGINE=MyISAM; 3669 3670DROP TABLE IF EXISTS `tiki_object_attributes`; 3671CREATE TABLE `tiki_object_attributes` ( 3672 `attributeId` INT PRIMARY KEY AUTO_INCREMENT, 3673 `type` varchar(50) NOT NULL, 3674 `itemId` varchar(160) NOT NULL, 3675 `attribute` varchar(70) NOT NULL, 3676 `value` varchar(255), 3677 `comment` varchar(255), 3678 UNIQUE `item_attribute_uq` ( `type`, `itemId`(91), `attribute`(50) ), 3679 KEY `attribute_lookup_ix` (`attribute`, `value`(121)) 3680) ENGINE=MyISAM; 3681 3682DROP TABLE IF EXISTS `tiki_rating_configs`; 3683CREATE TABLE `tiki_rating_configs` ( 3684 `ratingConfigId` INT PRIMARY KEY AUTO_INCREMENT, 3685 `name` VARCHAR(50) NOT NULL, 3686 `expiry` INT NOT NULL DEFAULT 3600, 3687 `formula` TEXT NOT NULL, 3688 `callbacks` TEXT 3689) ENGINE=MyISAM; 3690 3691DROP TABLE IF EXISTS `tiki_rating_obtained`; 3692CREATE TABLE `tiki_rating_obtained` ( 3693 `ratingId` INT PRIMARY KEY AUTO_INCREMENT, 3694 `ratingConfigId` INT NOT NULL, 3695 `type` VARCHAR(50) NOT NULL, 3696 `object` INT NOT NULL, 3697 `expire` INT NOT NULL, 3698 `value` FLOAT NOT NULL, 3699 UNIQUE `tiki_obtained_rating_uq` (`type`, `object`, `ratingConfigId`) 3700) ENGINE=MyISAM; 3701 3702DROP TABLE IF EXISTS `tiki_object_relations`; 3703CREATE TABLE `tiki_object_relations` ( 3704 `relationId` INT PRIMARY KEY AUTO_INCREMENT, 3705 `relation` varchar(70) NOT NULL, 3706 `source_type` varchar(50) NOT NULL, 3707 `source_itemId` varchar(160) NOT NULL, 3708 `target_type` varchar(50) NOT NULL, 3709 `target_itemId` varchar(160) NOT NULL, 3710 KEY `relation_source_ix` (`source_type`, `source_itemId`), 3711 KEY `relation_target_ix` (`target_type`, `target_itemId`) 3712) ENGINE=MyISAM; 3713 3714DROP TABLE IF EXISTS `tiki_todo`; 3715CREATE TABLE `tiki_todo` ( 3716 `todoId` INT(12) NOT NULL auto_increment, 3717 `after` INT(12) NOT NULL, 3718 `event` VARCHAR(50) NOT NULL, 3719 `objectType` VARCHAR(50), 3720 `objectId` VARCHAR(255) default NULL, 3721 `from` VARCHAR(255) default NULL, 3722 `to` VARCHAR(255) default NULL, 3723 PRIMARY KEY (`todoId`), 3724 KEY `what` (`objectType`, `objectId`(141)), 3725 KEY `after` (`after`) 3726) ENGINE=MyISAM; 3727DROP TABLE IF EXISTS `tiki_todo_notif`; 3728CREATE TABLE `tiki_todo_notif` ( 3729 `todoId` INT(12) NOT NULL, 3730 `objectType` VARCHAR(50), 3731 `objectId` VARCHAR(255) default NULL, 3732 KEY `todoId` (`todoId`), 3733 KEY `objectId` (`objectId`(191)) 3734) ENGINE=MyISAM; 3735 3736DROP TABLE IF EXISTS `tiki_url_shortener`; 3737CREATE TABLE `tiki_url_shortener` ( 3738 `urlId` int(10) unsigned NOT NULL AUTO_INCREMENT, 3739 `user` varchar(200) NOT NULL, 3740 `longurl` tinytext NOT NULL, 3741 `longurl_hash` varchar(32) NOT NULL, 3742 `service` varchar(32) NOT NULL, 3743 `shorturl` varchar(63) NOT NULL, 3744 PRIMARY KEY (`urlId`), 3745 UNIQUE KEY `shorturl` (`shorturl`), 3746 KEY `longurl_hash` (`longurl_hash`) 3747) ENGINE=MyISAM AUTO_INCREMENT=1 ; 3748 3749DROP TABLE IF EXISTS `tiki_invite`; 3750CREATE TABLE `tiki_invite` ( 3751 `id` int(11) NOT NULL auto_increment, 3752 `inviter` varchar(200) NOT NULL, 3753 `groups` varchar(255) default NULL, 3754 `ts` int(11) NOT NULL, 3755 `emailsubject` varchar(255) NOT NULL, 3756 `emailcontent` text NOT NULL, 3757 `wikicontent` text, 3758 `wikipageafter` varchar(255) default NULL, 3759 PRIMARY KEY (`id`) 3760) ENGINE=MyISAM; 3761 3762DROP TABLE IF EXISTS `tiki_invited`; 3763CREATE TABLE `tiki_invited` ( 3764 `id` int(11) NOT NULL auto_increment, 3765 `id_invite` int(11) NOT NULL, 3766 `email` varchar(255) NOT NULL, 3767 `firstname` varchar(24) NOT NULL, 3768 `lastname` varchar(24) NOT NULL, 3769 `used` enum('no','registered','logged') NOT NULL, 3770 `used_on_user` varchar(200) default NULL, 3771 PRIMARY KEY (`id`), 3772 KEY `id_invite` (`id_invite`), 3773 KEY `used_on_user` (`used_on_user`(191)) 3774) ENGINE=MyISAM; 3775 3776DROP TABLE IF EXISTS `tiki_credits`; 3777CREATE TABLE `tiki_credits` ( 3778 `creditId` INT UNSIGNED NOT NULL AUTO_INCREMENT , 3779 `userId` INT( 8 ) NOT NULL , 3780 `credit_type` VARCHAR( 25 ) NOT NULL , 3781 `creation_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , 3782 `expiration_date` TIMESTAMP NULL , 3783 `total_amount` FLOAT NOT NULL DEFAULT 0, 3784 `used_amount` FLOAT NOT NULL DEFAULT 0, 3785 `product_id` INT( 8 ) NULL , 3786 PRIMARY KEY ( `creditId` ) , 3787 INDEX ( `userId` , `credit_type` ) 3788) ENGINE=MyISAM; 3789 3790DROP TABLE IF EXISTS `tiki_credits_usage`; 3791CREATE TABLE `tiki_credits_usage` ( 3792 `usageId` INT NOT NULL AUTO_INCREMENT, 3793 `userId` INT NOT NULL, 3794 `usage_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 3795 `credit_type` VARCHAR( 25 ) NOT NULL, 3796 `used_amount` FLOAT NOT NULL DEFAULT 0, 3797 `product_id` INT( 8 ) NULL , 3798 PRIMARY KEY ( `usageId` ) 3799) ENGINE=MyISAM; 3800 3801DROP TABLE IF EXISTS `tiki_credits_types`; 3802CREATE TABLE `tiki_credits_types` ( 3803 `credit_type` VARCHAR( 25 ) NOT NULL, 3804 `display_text` VARCHAR( 50 ) DEFAULT NULL, 3805 `unit_text` VARCHAR( 25 ) DEFAULT NULL, 3806 `is_static_level` CHAR( 1 ) DEFAULT 'n', 3807 `scaling_divisor` FLOAT NOT NULL DEFAULT 1, 3808 PRIMARY KEY ( `credit_type` ) 3809) ENGINE=MyISAM; 3810 3811DROP TABLE IF EXISTS `tiki_acct_account`; 3812CREATE TABLE `tiki_acct_account` ( 3813 `accountBookId` int(10) unsigned NOT NULL, 3814 `accountId` int(10) unsigned NOT NULL DEFAULT '0', 3815 `accountName` varchar(255) NOT NULL, 3816 `accountNotes` text NOT NULL, 3817 `accountBudget` double NOT NULL DEFAULT '0', 3818 `accountLocked` int(1) NOT NULL DEFAULT '0', 3819 `accountTax` int(11) NOT NULL DEFAULT '0', 3820 `accountUserId` int(8) NOT NULL DEFAULT '0', 3821 PRIMARY KEY (`accountBookId`,`accountId`), 3822 KEY `accountTax` (`accountTax`) 3823) ENGINE=MyISAM; 3824 3825DROP TABLE IF EXISTS `tiki_acct_bankaccount`; 3826CREATE TABLE `tiki_acct_bankaccount` ( 3827 `bankBookId` int(10) unsigned NOT NULL, 3828 `bankAccountId` int(10) unsigned NOT NULL, 3829 `externalNumber` int(10) NOT NULL, 3830 `bankCountry` varchar(2) NOT NULL, 3831 `bankCode` varchar(11) NOT NULL, 3832 `bankIBAN` varchar(63) NOT NULL, 3833 `bankBIC` varchar(63) NOT NULL, 3834 `bankDelimeter` varchar(15) NOT NULL DEFAULT ';', 3835 `bankDecPoint` varchar(1) NOT NULL DEFAULT ',', 3836 `bankThousand` varchar(1) NOT NULL DEFAULT '.', 3837 `bankHasHeader` tinyint(1) NOT NULL DEFAULT '1', 3838 `fieldNameAccount` varchar(63) NOT NULL, 3839 `fieldNameBookingDate` varchar(63) NOT NULL, 3840 `formatBookingDate` varchar(31) NOT NULL, 3841 `fieldNameValueDate` varchar(63) NOT NULL, 3842 `formatValueDate` varchar(31) NOT NULL, 3843 `fieldNameBookingText` varchar(63) NOT NULL, 3844 `fieldNameReason` varchar(63) NOT NULL, 3845 `fieldNameCounterpartName` varchar(63) NOT NULL, 3846 `fieldNameCounterpartAccount` varchar(63) NOT NULL, 3847 `fieldNameCounterpartBankCode` varchar(63) NOT NULL, 3848 `fieldNameAmount` varchar(63) NOT NULL, 3849 `amountType` int(10) unsigned NOT NULL, 3850 `fieldNameAmountSign` varchar(63) NOT NULL, 3851 `SignPositive` varchar(7) NOT NULL, 3852 `SignNegative` varchar(7) NOT NULL, 3853 PRIMARY KEY (`bankBookId`,`bankAccountId`) 3854) ENGINE=MyISAM; 3855 3856DROP TABLE IF EXISTS `tiki_acct_book`; 3857CREATE TABLE `tiki_acct_book` ( 3858 `bookId` int(10) unsigned NOT NULL AUTO_INCREMENT, 3859 `bookName` varchar(255) NOT NULL, 3860 `bookClosed` enum('y','n') NOT NULL DEFAULT 'n', 3861 `bookStartDate` date NULL, 3862 `bookEndDate` date NULL, 3863 `bookCurrency` varchar(3) NOT NULL DEFAULT 'EUR', 3864 `bookCurrencyPos` int(11) NOT NULL, 3865 `bookDecimals` int(11) NOT NULL DEFAULT '2', 3866 `bookDecPoint` varchar(1) NOT NULL DEFAULT ',', 3867 `bookThousand` varchar(1) NOT NULL DEFAULT '.', 3868 `exportSeparator` varchar(4) NOT NULL DEFAULT ';', 3869 `exportEOL` varchar(4) NOT NULL DEFAULT 'LF', 3870 `exportQuote` varchar(4) NOT NULL DEFAULT '"', 3871 `bookAutoTax` enum('y','n') NOT NULL DEFAULT 'y', 3872 PRIMARY KEY (`bookId`) 3873) ENGINE=MyISAM; 3874 3875DROP TABLE IF EXISTS `tiki_acct_item`; 3876CREATE TABLE `tiki_acct_item` ( 3877 `itemId` int(11) NOT NULL AUTO_INCREMENT, 3878 `itemBookId` int(10) unsigned NOT NULL, 3879 `itemJournalId` int(10) unsigned NOT NULL DEFAULT '0', 3880 `itemAccountId` int(10) unsigned NOT NULL DEFAULT '0', 3881 `itemType` int(1) NOT NULL DEFAULT '-1', 3882 `itemAmount` double NOT NULL DEFAULT '0', 3883 `itemText` varchar(255) NOT NULL DEFAULT '', 3884 `itemTs` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 3885 PRIMARY KEY (`itemId`) 3886) ENGINE=MyISAM; 3887 3888DROP TABLE IF EXISTS `tiki_acct_journal`; 3889CREATE TABLE `tiki_acct_journal` ( 3890 `journalBookId` int(10) unsigned NOT NULL, 3891 `journalId` int(10) unsigned NOT NULL AUTO_INCREMENT, 3892 `journalDate` date NULL, 3893 `journalDescription` varchar(255) NOT NULL, 3894 `journalCancelled` int(1) NOT NULL DEFAULT '0', 3895 `journalTs` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 3896 PRIMARY KEY (`journalId`) 3897) ENGINE=MyISAM; 3898 3899DROP TABLE IF EXISTS `tiki_acct_stack`; 3900CREATE TABLE `tiki_acct_stack` ( 3901 `stackBookId` int(10) unsigned NOT NULL, 3902 `stackId` int(10) unsigned NOT NULL AUTO_INCREMENT, 3903 `stackDate` date NULL, 3904 `stackDescription` varchar(255) NOT NULL, 3905 `stackTs` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 3906 PRIMARY KEY (`stackId`) 3907) ENGINE=MyISAM; 3908 3909DROP TABLE IF EXISTS `tiki_acct_stackitem`; 3910CREATE TABLE `tiki_acct_stackitem` ( 3911 `stackBookId` int(10) unsigned NOT NULL, 3912 `stackItemStackId` int(10) unsigned NOT NULL DEFAULT '0', 3913 `stackItemAccountId` int(10) unsigned NOT NULL DEFAULT '0', 3914 `stackItemType` int(1) NOT NULL DEFAULT '-1', 3915 `stackItemAmount` double NOT NULL DEFAULT '0', 3916 `stackItemText` varchar(255) NOT NULL DEFAULT '', 3917 PRIMARY KEY (`stackBookId`,`stackItemStackId`,`stackItemAccountId`,`stackItemType`) 3918) ENGINE=MyISAM; 3919 3920DROP TABLE IF EXISTS `tiki_acct_statement`; 3921CREATE TABLE `tiki_acct_statement` ( 3922 `statementBookId` int(10) unsigned NOT NULL, 3923 `statementAccountId` int(10) unsigned NOT NULL DEFAULT '0', 3924 `statementId` int(10) unsigned NOT NULL AUTO_INCREMENT, 3925 `statementBookingDate` date NULL, 3926 `statementValueDate` date NULL, 3927 `statementBookingText` varchar(255) NOT NULL, 3928 `statementReason` varchar(255) NOT NULL, 3929 `statementCounterpart` varchar(63) NOT NULL, 3930 `statementCounterpartAccount` varchar(63) NOT NULL, 3931 `statementCounterpartBankCode` varchar(63) NOT NULL, 3932 `statementAmount` double NOT NULL, 3933 `statementJournalId` int(10) unsigned NOT NULL DEFAULT '0', 3934 `statementStackId` int(11) NOT NULL, 3935 PRIMARY KEY (`statementId`) 3936) ENGINE=MyISAM; 3937 3938DROP TABLE IF EXISTS `tiki_acct_tax`; 3939CREATE TABLE `tiki_acct_tax` ( 3940 `taxBookId` int(10) unsigned NOT NULL, 3941 `taxId` int(10) unsigned NOT NULL AUTO_INCREMENT, 3942 `taxText` varchar(63) NOT NULL, 3943 `taxAmount` double NOT NULL DEFAULT '0', 3944 `taxIsFix` enum('y','n') NOT NULL DEFAULT 'n', 3945 PRIMARY KEY (`taxId`) 3946) ENGINE=MyISAM; 3947 3948DROP TABLE IF EXISTS `tiki_queue`; 3949CREATE TABLE `tiki_queue` ( 3950 `entryId` INT PRIMARY KEY AUTO_INCREMENT, 3951 `queue` VARCHAR(25) NOT NULL, 3952 `timestamp` INT NOT NULL, 3953 `handler` VARCHAR(64) NULL, 3954 `message` TEXT NOT NULL, 3955 KEY `queue_name_ix` (`queue`), 3956 KEY `queue_handler_ix` (`handler`) 3957) ENGINE=MyISAM; 3958 3959DROP TABLE IF EXISTS `tiki_cart_inventory_hold`; 3960CREATE TABLE `tiki_cart_inventory_hold` ( 3961 `productId` INT( 14 ) NOT NULL, 3962 `quantity` INT( 14 ) NOT NULL, 3963 `timeHeld` INT( 14 ) NOT NULL, 3964 `hash` CHAR( 32 ) NOT NULL 3965) ENGINE=MyISAM; 3966 3967DROP TABLE IF EXISTS `tiki_source_auth`; 3968CREATE TABLE `tiki_source_auth` ( 3969 `identifier` VARCHAR(50) PRIMARY KEY, 3970 `scheme` VARCHAR(20) NOT NULL, 3971 `domain` VARCHAR(200) NOT NULL, 3972 `path` VARCHAR(200) NOT NULL, 3973 `method` VARCHAR(20) NOT NULL, 3974 `arguments` TEXT NOT NULL, 3975 KEY `tiki_source_auth_ix` (`scheme`, `domain`(171)) 3976) ENGINE=MyISAM; 3977 3978DROP TABLE IF EXISTS `tiki_connect`; 3979CREATE TABLE `tiki_connect` ( 3980 `id` INT(11) unsigned NOT NULL AUTO_INCREMENT, 3981 `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 3982 `type` VARCHAR(64) NOT NULL DEFAULT '', 3983 `data` TEXT, 3984 `guid` VARCHAR(64) DEFAULT NULL, 3985 `server` TINYINT(1) NOT NULL DEFAULT '0', 3986 PRIMARY KEY (`id`), 3987 KEY `server` (`server`) 3988) ENGINE=MyISAM; 3989 3990DROP TABLE IF EXISTS `tiki_areas`; 3991CREATE TABLE `tiki_areas` ( 3992 `categId` int(11) NOT NULL, 3993 `perspectives` text, 3994 `exclusive` char(1) NOT NULL DEFAULT 'n', 3995 `share_common` char(1) NOT NULL DEFAULT 'y', 3996 `enabled` char(1) NOT NULL DEFAULT 'y', 3997 KEY `categId` (`categId`) 3998) ENGINE=MyISAM; 3999 4000DROP TABLE IF EXISTS `tiki_page_references`; 4001CREATE TABLE `tiki_page_references` ( 4002 `ref_id` INT(14) NOT NULL AUTO_INCREMENT, 4003 `page_id` INT(14) DEFAULT NULL, 4004 `biblio_code` VARCHAR(50) DEFAULT NULL, 4005 `author` VARCHAR(255) DEFAULT NULL, 4006 `title` VARCHAR(255) DEFAULT NULL, 4007 `part` VARCHAR(255) DEFAULT NULL, 4008 `uri` VARCHAR(255) DEFAULT NULL, 4009 `code` VARCHAR(255) DEFAULT NULL, 4010 `year` VARCHAR(255) DEFAULT NULL, 4011 `publisher` VARCHAR(255) DEFAULT NULL, 4012 `location` VARCHAR(255) DEFAULT NULL, 4013 `style` VARCHAR(30) DEFAULT NULL, 4014 `template` varchar(255) DEFAULT NULL, 4015 `last_modified` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 4016 PRIMARY KEY (`ref_id`), 4017 KEY `PageId` (`page_id`) 4018) ENGINE=MyISAM; 4019ALTER TABLE tiki_page_references ADD UNIQUE INDEX uk1_tiki_page_ref_biblio_code (page_id, biblio_code); 4020ALTER TABLE tiki_page_references ADD INDEX idx_tiki_page_ref_title (title(191)); 4021ALTER TABLE tiki_page_references ADD INDEX idx_tiki_page_ref_author (author(191)); 4022 4023DROP TABLE IF EXISTS `tiki_db_status`; 4024CREATE TABLE `tiki_db_status` ( 4025 `id` int(11) NOT NULL AUTO_INCREMENT, 4026 `objectId` varchar(100) NOT NULL, 4027 `tableName` varchar(100) NOT NULL, 4028 `status` varchar(100) NOT NULL, 4029 `other` varchar(100) DEFAULT NULL, 4030 PRIMARY KEY (`id`) 4031) ENGINE=MyISAM AUTO_INCREMENT=1; 4032 4033DROP TABLE IF EXISTS `tiki_mail_queue`; 4034CREATE TABLE `tiki_mail_queue` ( 4035 `messageId` INT NOT NULL AUTO_INCREMENT , 4036 `message` LONGTEXT NULL , 4037 `attempts` INT NOT NULL DEFAULT 0 , 4038 PRIMARY KEY (`messageId`) 4039) ENGINE=MyISAM AUTO_INCREMENT=1; 4040 4041DROP TABLE IF EXISTS `tiki_workspace_templates`; 4042CREATE TABLE `tiki_workspace_templates` ( 4043 `templateId` INT PRIMARY KEY AUTO_INCREMENT, 4044 `name` VARCHAR(50), 4045 `definition` TEXT, 4046 `is_advanced` CHAR(1) NOT NULL DEFAULT 'n' 4047) ENGINE=MyISAM; 4048 4049DROP TABLE IF EXISTS `tiki_user_mailin_struct`; 4050CREATE TABLE `tiki_user_mailin_struct` ( 4051 `mailin_struct_id` int(12) NOT NULL auto_increment, 4052 `username` varchar(200) NOT NULL, 4053 `subj_pattern` varchar(255) NULL, 4054 `body_pattern` varchar(255) NULL, 4055 `structure_id` int(14) NOT NULL, 4056 `page_id` int(14) NULL, 4057 `is_active` char(1) NULL DEFAULT 'n', 4058 PRIMARY KEY (`mailin_struct_id`) 4059) ENGINE=MyISAM AUTO_INCREMENT=1; 4060 4061DROP TABLE IF EXISTS `tiki_search_queries`; 4062CREATE TABLE `tiki_search_queries` ( 4063 `queryId` INT NOT NULL PRIMARY KEY AUTO_INCREMENT, 4064 `userId` INT NOT NULL, 4065 `lastModif` INT, 4066 `label` VARCHAR(100) NOT NULL, 4067 `priority` VARCHAR(15) NOT NULL, 4068 `query` BLOB, 4069 `description` TEXT, 4070 INDEX `query_userId` (`userId`), 4071 UNIQUE KEY `tiki_user_query_uq` (`userId`, `label`) 4072) ENGINE=MyISAM AUTO_INCREMENT=1; 4073 4074DROP TABLE IF EXISTS `tiki_user_monitors`; 4075CREATE TABLE `tiki_user_monitors` ( 4076 `monitorId` INT NOT NULL PRIMARY KEY AUTO_INCREMENT, 4077 `userId` INT NOT NULL, 4078 `event` VARCHAR(50) NOT NULL, 4079 `priority` VARCHAR(10) NOT NULL, 4080 `target` VARCHAR(25) NOT NULL, 4081 INDEX `userid_target_ix` (`userId`, `target`), 4082 UNIQUE `event_target_uq` (`event`, `target`, `userId`) 4083) ENGINE=MyISAM; 4084 4085DROP TABLE IF EXISTS `tiki_output`; 4086CREATE TABLE `tiki_output` ( 4087 `entityId` varchar(160) NOT NULL default '', 4088 `objectType` varchar(32) NOT NULL default '', 4089 `outputType` varchar(32) NOT NULL default '', 4090 `version` int(8) NOT NULL default '0', 4091 `outputId` INT NOT NULL PRIMARY KEY AUTO_INCREMENT 4092) ENGINE=MyISAM AUTO_INCREMENT=1; 4093 4094DROP TABLE IF EXISTS `tiki_goals`; 4095CREATE TABLE `tiki_goals` ( 4096 `goalId` INT NOT NULL PRIMARY KEY AUTO_INCREMENT, 4097 `name` VARCHAR(50) NOT NULL, 4098 `type` VARCHAR(10) NOT NULL DEFAULT 'user', 4099 `description` TEXT, 4100 `enabled` INT NOT NULL DEFAULT 0, 4101 `daySpan` INT NOT NULL DEFAULT 14, 4102 `from` DATETIME, 4103 `to` DATETIME, 4104 `eligible` BLOB, 4105 `conditions` BLOB, 4106 `rewards` BLOB 4107) ENGINE=MyISAM; 4108 4109DROP TABLE IF EXISTS `tiki_goal_events`; 4110CREATE TABLE `tiki_goal_events` ( 4111 `eventId` INT NOT NULL PRIMARY KEY AUTO_INCREMENT, 4112 `eventDate` INT NOT NULL, 4113 `eventType` VARCHAR(50) NOT NULL, 4114 `targetType` VARCHAR(50), 4115 `targetObject` VARCHAR(255), 4116 `user` VARCHAR(200) NOT NULL, 4117 `groups` BLOB NOT NULL 4118) ENGINE=MyISAM; 4119 4120DROP TABLE IF EXISTS `tiki_tabular_formats`; 4121CREATE TABLE `tiki_tabular_formats` ( 4122 `tabularId` INT NOT NULL PRIMARY KEY AUTO_INCREMENT, 4123 `trackerId` INT NOT NULL, 4124 `name` VARCHAR(255) NOT NULL, 4125 `format_descriptor` TEXT, 4126 `filter_descriptor` TEXT, 4127 `config` TEXT, 4128 KEY `tabular_tracker_ix` (`trackerId`) 4129) ENGINE=MyISAM; 4130 4131DROP TABLE IF EXISTS `tiki_scheduler`; 4132CREATE TABLE `tiki_scheduler` ( 4133 `id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT, 4134 `name` VARCHAR(255), 4135 `description` VARCHAR(255), 4136 `task`VARCHAR(255), 4137 `params` TEXT, 4138 `run_time` VARCHAR(255), 4139 `status` VARCHAR(10), 4140 `re_run` TINYINT, 4141 `run_only_once` TINYINT, 4142 `creation_date` INT(14) 4143) ENGINE=MyISAM; 4144 4145DROP TABLE IF EXISTS `tiki_scheduler_run`; 4146CREATE TABLE `tiki_scheduler_run` ( 4147 `id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT, 4148 `scheduler_id` INT NOT NULL, 4149 `start_time` INT(14), 4150 `end_time` INT(14), 4151 `status` VARCHAR(10), 4152 `output` TEXT, 4153 `stalled` TINYINT DEFAULT 0, 4154 `healed` TINYINT DEFAULT 0 4155) ENGINE=MyISAM; 4156 4157DROP TABLE IF EXISTS `tiki_oauthserver_clients`; 4158CREATE TABLE `tiki_oauthserver_clients` ( 4159 `id` INT(14) NOT NULL AUTO_INCREMENT, 4160 `name` VARCHAR(128) NOT NULL DEFAULT '', 4161 `client_id` VARCHAR(128) UNIQUE NOT NULL DEFAULT '', 4162 `client_secret` VARCHAR(255) NOT NULL DEFAULT '', 4163 `redirect_uri` VARCHAR(255) NOT NULL DEFAULT '', 4164 PRIMARY KEY (`id`) 4165) ENGINE=MyISAM AUTO_INCREMENT=1; 4166 4167SET FOREIGN_KEY_CHECKS = 1; 4168