*** tiki-1.9-oci8.sql 2006-08-11 16:02:43.000000000 +1000 --- tiki-1.9-oci8.sql.old 2006-08-11 15:32:54.000000000 +1000 *************** *** 18,27 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "galaxia_activities"; - DROP SEQUENCE "galaxia_activities_sequ"; CREATE SEQUENCE "galaxia_activities_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "galaxia_activities" ( "activityId" number(14) NOT NULL, --- 18,25 ---- *************** *** 43,49 **** SELECT "galaxia_activities_sequ".nextval into :NEW."activityId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table galaxia_activity_roles --- 41,46 ---- *************** *** 51,57 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "galaxia_activity_roles"; CREATE TABLE "galaxia_activity_roles" ( --- 48,53 ---- *************** *** 67,73 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "galaxia_instance_activities"; CREATE TABLE "galaxia_instance_activities" ( --- 63,68 ---- *************** *** 87,96 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "galaxia_instance_comments"; - DROP SEQUENCE "galaxia_instance_comments_sequ"; CREATE SEQUENCE "galaxia_instance_comments_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "galaxia_instance_comments" ( "cId" number(14) NOT NULL, --- 82,89 ---- *************** *** 110,116 **** SELECT "galaxia_instance_comments_sequ".nextval into :NEW."cId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table galaxia_instances --- 103,108 ---- *************** *** 118,127 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "galaxia_instances"; - DROP SEQUENCE "galaxia_instances_sequ"; CREATE SEQUENCE "galaxia_instances_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "galaxia_instances" ( "instanceId" number(14) NOT NULL, --- 110,117 ---- *************** *** 142,148 **** SELECT "galaxia_instances_sequ".nextval into :NEW."instanceId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table galaxia_processes --- 132,137 ---- *************** *** 150,159 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "galaxia_processes"; - DROP SEQUENCE "galaxia_processes_sequ"; CREATE SEQUENCE "galaxia_processes_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "galaxia_processes" ( "pId" number(14) NOT NULL, --- 139,146 ---- *************** *** 172,178 **** SELECT "galaxia_processes_sequ".nextval into :NEW."pId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table galaxia_roles --- 159,164 ---- *************** *** 180,189 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "galaxia_roles"; - DROP SEQUENCE "galaxia_roles_sequ"; CREATE SEQUENCE "galaxia_roles_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "galaxia_roles" ( "roleId" number(14) NOT NULL, --- 166,173 ---- *************** *** 199,205 **** SELECT "galaxia_roles_sequ".nextval into :NEW."roleId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table galaxia_transitions --- 183,188 ---- *************** *** 207,213 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "galaxia_transitions"; CREATE TABLE "galaxia_transitions" ( --- 190,195 ---- *************** *** 224,233 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "galaxia_user_roles"; - DROP SEQUENCE "galaxia_user_roles_sequ"; CREATE SEQUENCE "galaxia_user_roles_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "galaxia_user_roles" ( "pId" number(14) default '0' NOT NULL, --- 206,213 ---- *************** *** 241,247 **** SELECT "galaxia_user_roles_sequ".nextval into :NEW."roleId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table galaxia_workitems --- 221,226 ---- *************** *** 249,258 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "galaxia_workitems"; - DROP SEQUENCE "galaxia_workitems_sequ"; CREATE SEQUENCE "galaxia_workitems_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "galaxia_workitems" ( "itemId" number(14) NOT NULL, --- 228,235 ---- *************** *** 271,277 **** SELECT "galaxia_workitems_sequ".nextval into :NEW."itemId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table messu_messages --- 248,253 ---- *************** *** 279,288 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 08:29 PM -- - DROP TABLE "messu_messages"; - DROP SEQUENCE "messu_messages_sequ"; CREATE SEQUENCE "messu_messages_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "messu_messages" ( "msgId" number(14) NOT NULL, --- 255,262 ---- *************** *** 308,314 **** SELECT "messu_messages_sequ".nextval into :NEW."msgId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table messu_archive (same structure as messu_messages) --- 282,287 ---- *************** *** 317,326 **** -- Creation: Feb 26, 2005 at 03:00 PM -- Last update: Feb 26, 2005 at 03:00 PM -- - DROP TABLE "messu_archive"; - DROP SEQUENCE "messu_archive_sequ"; CREATE SEQUENCE "messu_archive_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "messu_archive" ( "msgId" number(14) NOT NULL, --- 290,297 ---- *************** *** 346,352 **** SELECT "messu_archive_sequ".nextval into :NEW."msgId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table messu_sent (same structure as messu_messages) --- 317,322 ---- *************** *** 355,364 **** -- Creation: Feb 26, 2005 at 11:00 PM -- Last update: Feb 26, 2005 at 11:00 PM -- - DROP TABLE "messu_sent"; - DROP SEQUENCE "messu_sent_sequ"; CREATE SEQUENCE "messu_sent_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "messu_sent" ( "msgId" number(14) NOT NULL, --- 325,332 ---- *************** *** 384,392 **** SELECT "messu_sent_sequ".nextval into :NEW."msgId" FROM DUAL; END; / - -- -------------------------------------------------------- - DROP TABLE "sessions"; CREATE TABLE "sessions"( --- 352,358 ---- *************** *** 405,411 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 13, 2003 at 12:29 AM -- - DROP TABLE "tiki_actionlog"; CREATE TABLE "tiki_actionlog" ( --- 371,376 ---- *************** *** 425,434 **** -- Last update: Jul 13, 2003 at 01:30 AM -- Last check: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_articles"; - DROP SEQUENCE "tiki_articles_sequ"; CREATE SEQUENCE "tiki_articles_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_articles" ( "articleId" number(8) NOT NULL, --- 390,397 ---- *************** *** 471,491 **** SELECT "tiki_articles_sequ".nextval into :NEW."articleId" FROM DUAL; END; / - CREATE INDEX "tiki_articles_title" ON "tiki_articles"("title"); - CREATE INDEX "tiki_articles_heading" ON "tiki_articles"("heading"); - CREATE INDEX "tiki_articles_body" ON "tiki_articles"("body"); - CREATE INDEX "tiki_articles_nbreads" ON "tiki_articles"("nbreads"); - CREATE INDEX "tiki_articles_author" ON "tiki_articles"("author"); - CREATE INDEX "tiki_articles_ft" ON "tiki_articles"("title","heading","body"); - -- -------------------------------------------------------- - DROP TABLE "tiki_article_types"; CREATE TABLE "tiki_article_types" ( --- 434,446 ---- *************** *** 528,537 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_banners"; - DROP SEQUENCE "tiki_banners_sequ"; CREATE SEQUENCE "tiki_banners_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_banners" ( "bannerId" number(12) NOT NULL, --- 483,490 ---- *************** *** 571,577 **** SELECT "tiki_banners_sequ".nextval into :NEW."bannerId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_banning --- 524,529 ---- *************** *** 579,588 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_banning"; - DROP SEQUENCE "tiki_banning_sequ"; CREATE SEQUENCE "tiki_banning_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_banning" ( "banId" number(12) NOT NULL, --- 531,538 ---- *************** *** 606,612 **** SELECT "tiki_banning_sequ".nextval into :NEW."banId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_banning_sections --- 556,561 ---- *************** *** 614,620 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_banning_sections"; CREATE TABLE "tiki_banning_sections" ( --- 563,568 ---- *************** *** 630,636 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 04:52 PM -- - DROP TABLE "tiki_blog_activity"; CREATE TABLE "tiki_blog_activity" ( --- 578,583 ---- *************** *** 648,657 **** -- Last update: Jul 12, 2003 at 04:52 PM -- Last check: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_blog_posts"; - DROP SEQUENCE "tiki_blog_posts_sequ"; CREATE SEQUENCE "tiki_blog_posts_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_blog_posts" ( "postId" number(8) NOT NULL, --- 595,602 ---- *************** *** 672,686 **** SELECT "tiki_blog_posts_sequ".nextval into :NEW."postId" FROM DUAL; END; / - CREATE INDEX "tiki_blog_posts_data" ON "tiki_blog_posts"("data"); - CREATE INDEX "tiki_blog_posts_blogId" ON "tiki_blog_posts"("blogId"); - CREATE INDEX "tiki_blog_posts_created" ON "tiki_blog_posts"("created"); - CREATE INDEX "tiki_blog_posts_ft" ON "tiki_blog_posts"("data","title"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_blog_posts_images --- 617,626 ---- *************** *** 688,697 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_blog_posts_images"; - DROP SEQUENCE "tiki_blog_posts_images_sequ"; CREATE SEQUENCE "tiki_blog_posts_images_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_blog_posts_images" ( "imgId" number(14) NOT NULL, --- 628,635 ---- *************** *** 708,714 **** SELECT "tiki_blog_posts_images_sequ".nextval into :NEW."imgId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_blogs --- 646,651 ---- *************** *** 717,726 **** -- Last update: Jul 13, 2003 at 01:07 AM -- Last check: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_blogs"; - DROP SEQUENCE "tiki_blogs_sequ"; CREATE SEQUENCE "tiki_blogs_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_blogs" ( "blogId" number(8) NOT NULL, --- 654,661 ---- *************** *** 749,763 **** SELECT "tiki_blogs_sequ".nextval into :NEW."blogId" FROM DUAL; END; / - CREATE INDEX "tiki_blogs_title" ON "tiki_blogs"("title"); - CREATE INDEX "tiki_blogs_description" ON "tiki_blogs"("description"); - CREATE INDEX "tiki_blogs_hits" ON "tiki_blogs"("hits"); - CREATE INDEX "tiki_blogs_ft" ON "tiki_blogs"("title","description"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_calendar_categories --- 684,693 ---- *************** *** 765,774 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 07:05 AM -- - DROP TABLE "tiki_calendar_categories"; - DROP SEQUENCE "tiki_calendar_categories_sequ"; CREATE SEQUENCE "tiki_calendar_categories_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_calendar_categories" ( "calcatId" number(11) NOT NULL, --- 695,702 ---- *************** *** 782,790 **** SELECT "tiki_calendar_categories_sequ".nextval into :NEW."calcatId" FROM DUAL; END; / ! ! CREATE UNIQUE INDEX "tiki_calendar_categories_catna" ON "tiki_calendar_categories"("calendarId","name"); ! -- -------------------------------------------------------- -- -- Table structure for table tiki_calendar_items --- 710,716 ---- SELECT "tiki_calendar_categories_sequ".nextval into :NEW."calcatId" FROM DUAL; END; / ! CREATE UNIQUE INDEX "tiki_calendar_categories_catname" ON "tiki_calendar_categories"("calendarId","name"); -- -------------------------------------------------------- -- -- Table structure for table tiki_calendar_items *************** *** 792,801 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 07:43 AM -- - DROP TABLE "tiki_calendar_items"; - DROP SEQUENCE "tiki_calendar_items_sequ"; CREATE SEQUENCE "tiki_calendar_items_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_calendar_items" ( "calitemId" number(14) NOT NULL, --- 718,725 ---- *************** *** 822,830 **** SELECT "tiki_calendar_items_sequ".nextval into :NEW."calitemId" FROM DUAL; END; / - CREATE INDEX "tiki_calendar_items_calendarId" ON "tiki_calendar_items"("calendarId"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_calendar_locations --- 746,752 ---- *************** *** 832,841 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 07:05 AM -- - DROP TABLE "tiki_calendar_locations"; - DROP SEQUENCE "tiki_calendar_locations_sequ"; CREATE SEQUENCE "tiki_calendar_locations_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_calendar_locations" ( "callocId" number(14) NOT NULL, --- 754,761 ---- *************** *** 850,858 **** SELECT "tiki_calendar_locations_sequ".nextval into :NEW."callocId" FROM DUAL; END; / ! ! CREATE UNIQUE INDEX "tiki_calendar_locations_locnam" ON "tiki_calendar_locations"("calendarId","name"); ! -- -------------------------------------------------------- -- -- Table structure for table tiki_calendar_roles --- 770,776 ---- SELECT "tiki_calendar_locations_sequ".nextval into :NEW."callocId" FROM DUAL; END; / ! CREATE UNIQUE INDEX "tiki_calendar_locations_locname" ON "tiki_calendar_locations"("calendarId","name"); -- -------------------------------------------------------- -- -- Table structure for table tiki_calendar_roles *************** *** 860,866 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_calendar_roles"; CREATE TABLE "tiki_calendar_roles" ( --- 778,783 ---- *************** *** 877,886 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 05, 2003 at 02:03 PM -- - DROP TABLE "tiki_calendars"; - DROP SEQUENCE "tiki_calendars_sequ"; CREATE SEQUENCE "tiki_calendars_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_calendars" ( "calendarId" number(14) NOT NULL, --- 794,801 ---- *************** *** 895,904 **** "customsubscription" varchar(3) default 'n' NOT NULL CHECK ("customsubscription" IN ('n','y')), "created" number(14) default '0' NOT NULL, "lastmodif" number(14) default '0' NOT NULL, ! -- "personal" enum ('n', 'y') default 'n' NOT NULL, ! "personal" varchar2(1) default 'n' NOT NULL, ! constraint cons_personal_tc check ("personal" in ('n', 'y')), ! PRIMARY KEY ("calendarId") ) ; --- 810,816 ---- "customsubscription" varchar(3) default 'n' NOT NULL CHECK ("customsubscription" IN ('n','y')), "created" number(14) default '0' NOT NULL, "lastmodif" number(14) default '0' NOT NULL, ! "personal" enum ('n', 'y') default 'n' NOT NULL, PRIMARY KEY ("calendarId") ) ; *************** *** 907,913 **** SELECT "tiki_calendars_sequ".nextval into :NEW."calendarId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_categories --- 819,824 ---- *************** *** 915,924 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 04, 2003 at 09:47 PM -- - DROP TABLE "tiki_categories"; - DROP SEQUENCE "tiki_categories_sequ"; CREATE SEQUENCE "tiki_categories_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_categories" ( "categId" number(12) NOT NULL, --- 826,833 ---- *************** *** 934,940 **** SELECT "tiki_categories_sequ".nextval into :NEW."categId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_categorized_objects --- 843,848 ---- *************** *** 942,951 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 13, 2003 at 01:09 AM -- - DROP TABLE "tiki_categorized_objects"; - DROP SEQUENCE "tiki_categorized_objects_sequ"; CREATE SEQUENCE "tiki_categorized_objects_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_categorized_objects" ( "catObjectId" number(12) NOT NULL, --- 850,857 ---- *************** *** 964,970 **** SELECT "tiki_categorized_objects_sequ".nextval into :NEW."catObjectId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_category_objects --- 870,875 ---- *************** *** 972,978 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 13, 2003 at 01:09 AM -- - DROP TABLE "tiki_category_objects"; CREATE TABLE "tiki_category_objects" ( --- 877,882 ---- *************** *** 988,994 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 07, 2003 at 01:53 AM -- - DROP TABLE "tiki_object_ratings"; CREATE TABLE "tiki_object_ratings" ( --- 892,897 ---- *************** *** 1004,1010 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 07, 2003 at 01:53 AM -- - DROP TABLE "tiki_category_sites"; CREATE TABLE "tiki_category_sites" ( --- 907,912 ---- *************** *** 1020,1029 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_chart_items"; - DROP SEQUENCE "tiki_chart_items_sequ"; CREATE SEQUENCE "tiki_chart_items_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_chart_items" ( "itemId" number(14) NOT NULL, --- 922,929 ---- *************** *** 1043,1049 **** SELECT "tiki_chart_items_sequ".nextval into :NEW."itemId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_charts --- 943,948 ---- *************** *** 1051,1060 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 06, 2003 at 08:14 AM -- - DROP TABLE "tiki_charts"; - DROP SEQUENCE "tiki_charts_sequ"; CREATE SEQUENCE "tiki_charts_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_charts" ( "chartId" number(14) NOT NULL, --- 950,957 ---- *************** *** 1083,1089 **** SELECT "tiki_charts_sequ".nextval into :NEW."chartId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_charts_rankings --- 980,985 ---- *************** *** 1091,1097 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_charts_rankings"; CREATE TABLE "tiki_charts_rankings" ( --- 987,992 ---- *************** *** 1113,1119 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_charts_votes"; CREATE TABLE "tiki_charts_votes" ( --- 1008,1013 ---- *************** *** 1131,1140 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_chat_channels"; - DROP SEQUENCE "tiki_chat_channels_sequ"; CREATE SEQUENCE "tiki_chat_channels_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_chat_channels" ( "channelId" number(8) NOT NULL, --- 1025,1032 ---- *************** *** 1153,1159 **** SELECT "tiki_chat_channels_sequ".nextval into :NEW."channelId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_chat_messages --- 1045,1050 ---- *************** *** 1161,1170 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_chat_messages"; - DROP SEQUENCE "tiki_chat_messages_sequ"; CREATE SEQUENCE "tiki_chat_messages_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_chat_messages" ( "messageId" number(8) NOT NULL, --- 1052,1059 ---- *************** *** 1180,1186 **** SELECT "tiki_chat_messages_sequ".nextval into :NEW."messageId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_chat_users --- 1069,1074 ---- *************** *** 1188,1194 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_chat_users"; CREATE TABLE "tiki_chat_users" ( --- 1076,1081 ---- *************** *** 1206,1215 **** -- Last update: Jul 12, 2003 at 10:56 PM -- Last check: Jul 11, 2003 at 01:52 AM -- - DROP TABLE "tiki_comments"; - DROP SEQUENCE "tiki_comments_sequ"; CREATE SEQUENCE "tiki_comments_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_comments" ( "threadId" number(14) NOT NULL, --- 1093,1100 ---- *************** *** 1240,1253 **** SELECT "tiki_comments_sequ".nextval into :NEW."threadId" FROM DUAL; END; / - CREATE INDEX "tiki_comments_title" ON "tiki_comments"("title"); CREATE INDEX "tiki_comments_data" ON "tiki_comments"("data"); CREATE INDEX "tiki_comments_object" ON "tiki_comments"("object"); CREATE INDEX "tiki_comments_hits" ON "tiki_comments"("hits"); CREATE INDEX "tiki_comments_tc_pi" ON "tiki_comments"("parentId"); CREATE INDEX "tiki_comments_ft" ON "tiki_comments"("title","data"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_content --- 1125,1136 ---- *************** *** 1255,1264 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_content"; - DROP SEQUENCE "tiki_content_sequ"; CREATE SEQUENCE "tiki_content_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_content" ( "contentId" number(8) NOT NULL, --- 1138,1145 ---- *************** *** 1271,1277 **** SELECT "tiki_content_sequ".nextval into :NEW."contentId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_content_templates --- 1152,1157 ---- *************** *** 1279,1288 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 12:37 AM -- - DROP TABLE "tiki_content_templates"; - DROP SEQUENCE "tiki_content_templates_sequ"; CREATE SEQUENCE "tiki_content_templates_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_content_templates" ( "templateId" number(10) NOT NULL, --- 1159,1166 ---- *************** *** 1297,1314 **** SELECT "tiki_content_templates_sequ".nextval into :NEW."templateId" FROM DUAL; END; / - -- -------------------------------------------------------- -- ! -- Table structure for table tiki_content_templates_section -- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 12:37 AM -- ! DROP TABLE "tiki_content_templates_section"; ! ! CREATE TABLE "tiki_content_templates_section" ( "templateId" number(10) default '0' NOT NULL, "section" varchar(250) default '' NOT NULL, PRIMARY KEY ("templateId","section") --- 1175,1190 ---- SELECT "tiki_content_templates_sequ".nextval into :NEW."templateId" FROM DUAL; END; / -- -------------------------------------------------------- -- ! -- Table structure for table tiki_content_templates_sections -- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 12:37 AM -- + DROP TABLE "tiki_content_templates_sections"; ! CREATE TABLE "tiki_content_templates_sections" ( "templateId" number(10) default '0' NOT NULL, "section" varchar(250) default '' NOT NULL, PRIMARY KEY ("templateId","section") *************** *** 1321,1330 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 10, 2003 at 04:00 AM -- - DROP TABLE "tiki_cookies"; - DROP SEQUENCE "tiki_cookies_sequ"; CREATE SEQUENCE "tiki_cookies_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_cookies" ( "cookieId" number(10) NOT NULL, --- 1197,1204 ---- *************** *** 1337,1343 **** SELECT "tiki_cookies_sequ".nextval into :NEW."cookieId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_copyrights --- 1211,1216 ---- *************** *** 1345,1354 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_copyrights"; - DROP SEQUENCE "tiki_copyrights_sequ"; CREATE SEQUENCE "tiki_copyrights_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_copyrights" ( "copyrightId" number(12) NOT NULL, --- 1218,1225 ---- *************** *** 1366,1372 **** SELECT "tiki_copyrights_sequ".nextval into :NEW."copyrightId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_directory_categories --- 1237,1242 ---- *************** *** 1374,1383 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 08:59 PM -- - DROP TABLE "tiki_directory_categories"; - DROP SEQUENCE "tiki_directory_categories_sequ"; CREATE SEQUENCE "tiki_directory_categories_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_directory_categories" ( "categId" number(10) NOT NULL, --- 1244,1251 ---- *************** *** 1399,1405 **** SELECT "tiki_directory_categories_sequ".nextval into :NEW."categId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_directory_search --- 1267,1272 ---- *************** *** 1407,1413 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_directory_search"; CREATE TABLE "tiki_directory_search" ( --- 1274,1279 ---- *************** *** 1423,1432 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 07:32 PM -- - DROP TABLE "tiki_directory_sites"; - DROP SEQUENCE "tiki_directory_sites_sequ"; CREATE SEQUENCE "tiki_directory_sites_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_directory_sites" ( "siteId" number(14) NOT NULL, --- 1289,1296 ---- *************** *** 1448,1456 **** SELECT "tiki_directory_sites_sequ".nextval into :NEW."siteId" FROM DUAL; END; / - CREATE INDEX "tiki_directory_sites_ft" ON "tiki_directory_sites"("name","description"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_drawings --- 1312,1318 ---- *************** *** 1458,1467 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 08, 2003 at 05:02 AM -- - DROP TABLE "tiki_drawings"; - DROP SEQUENCE "tiki_drawings_sequ"; CREATE SEQUENCE "tiki_drawings_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_drawings" ( "drawId" number(12) NOT NULL, --- 1320,1327 ---- *************** *** 1479,1485 **** SELECT "tiki_drawings_sequ".nextval into :NEW."drawId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_dsn --- 1339,1344 ---- *************** *** 1487,1496 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_dsn"; - DROP SEQUENCE "tiki_dsn_sequ"; CREATE SEQUENCE "tiki_dsn_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_dsn" ( "dsnId" number(12) NOT NULL, --- 1346,1353 ---- *************** *** 1504,1512 **** SELECT "tiki_dsn_sequ".nextval into :NEW."dsnId" FROM DUAL; END; / - -- -------------------------------------------------------- - DROP TABLE "tiki_dynamic_variables"; CREATE TABLE "tiki_dynamic_variables" ( --- 1361,1367 ---- *************** *** 1522,1531 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 06, 2003 at 08:23 AM -- - DROP TABLE "tiki_eph"; - DROP SEQUENCE "tiki_eph_sequ"; CREATE SEQUENCE "tiki_eph_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_eph" ( "ephId" number(12) NOT NULL, --- 1377,1384 ---- *************** *** 1546,1552 **** SELECT "tiki_eph_sequ".nextval into :NEW."ephId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_extwiki --- 1399,1404 ---- *************** *** 1554,1563 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_extwiki"; - DROP SEQUENCE "tiki_extwiki_sequ"; CREATE SEQUENCE "tiki_extwiki_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_extwiki" ( "extwikiId" number(12) NOT NULL, --- 1406,1413 ---- *************** *** 1571,1577 **** SELECT "tiki_extwiki_sequ".nextval into :NEW."extwikiId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_faq_questions --- 1421,1426 ---- *************** *** 1580,1589 **** -- Last update: Jul 03, 2003 at 07:42 PM -- Last check: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_faq_questions"; - DROP SEQUENCE "tiki_faq_questions_sequ"; CREATE SEQUENCE "tiki_faq_questions_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_faq_questions" ( "questionId" number(10) NOT NULL, --- 1429,1436 ---- *************** *** 1599,1613 **** SELECT "tiki_faq_questions_sequ".nextval into :NEW."questionId" FROM DUAL; END; / - CREATE INDEX "tiki_faq_questions_faqId" ON "tiki_faq_questions"("faqId"); - CREATE INDEX "tiki_faq_questions_question" ON "tiki_faq_questions"("question"); - CREATE INDEX "tiki_faq_questions_answer" ON "tiki_faq_questions"("answer"); - CREATE INDEX "tiki_faq_questions_ft" ON "tiki_faq_questions"("question","answer"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_faqs --- 1446,1455 ---- *************** *** 1616,1625 **** -- Last update: Jul 12, 2003 at 09:09 PM -- Last check: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_faqs"; - DROP SEQUENCE "tiki_faqs_sequ"; CREATE SEQUENCE "tiki_faqs_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_faqs" ( "faqId" number(10) NOT NULL, --- 1458,1465 ---- *************** *** 1637,1651 **** SELECT "tiki_faqs_sequ".nextval into :NEW."faqId" FROM DUAL; END; / - CREATE INDEX "tiki_faqs_title" ON "tiki_faqs"("title"); - CREATE INDEX "tiki_faqs_description" ON "tiki_faqs"("description"); - CREATE INDEX "tiki_faqs_hits" ON "tiki_faqs"("hits"); - CREATE INDEX "tiki_faqs_ft" ON "tiki_faqs"("title","description"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_featured_links --- 1477,1486 ---- *************** *** 1653,1659 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 11:08 PM -- - DROP TABLE "tiki_featured_links"; CREATE TABLE "tiki_featured_links" ( --- 1488,1493 ---- *************** *** 1672,1681 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 13, 2003 at 01:13 AM -- - DROP TABLE "tiki_file_galleries"; - DROP SEQUENCE "tiki_file_galleries_sequ"; CREATE SEQUENCE "tiki_file_galleries_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_file_galleries" ( "galleryId" number(14) NOT NULL, --- 1506,1513 ---- *************** *** 1706,1712 **** SELECT "tiki_file_galleries_sequ".nextval into :NEW."galleryId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_files --- 1538,1543 ---- *************** *** 1715,1724 **** -- Last update: Nov 02, 2004 at 05:59 PM -- Last check: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_files"; - DROP SEQUENCE "tiki_files_sequ"; CREATE SEQUENCE "tiki_files_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_files" ( "fileId" number(14) NOT NULL, --- 1546,1553 ---- *************** *** 1738,1746 **** "reference_url" varchar(250) default NULL, "is_reference" char(1) default NULL, "hash" varchar(32) default NULL, ! "search_data" clob, ! -- "lastModif" integer(14) DEFAULT NULL, ! "lastModif" number(14) DEFAULT NULL, "lastModifUser" varchar(200) DEFAULT NULL, PRIMARY KEY ("fileId") ) ; --- 1567,1574 ---- "reference_url" varchar(250) default NULL, "is_reference" char(1) default NULL, "hash" varchar(32) default NULL, ! "search_data" longtext, ! "lastModif" integer(14) DEFAULT NULL, "lastModifUser" varchar(200) DEFAULT NULL, PRIMARY KEY ("fileId") ) ; *************** *** 1750,1761 **** SELECT "tiki_files_sequ".nextval into :NEW."fileId" FROM DUAL; END; / - CREATE INDEX "tiki_files_name" ON "tiki_files"("name"); CREATE INDEX "tiki_files_description" ON "tiki_files"("description"); CREATE INDEX "tiki_files_downloads" ON "tiki_files"("downloads"); CREATE INDEX "tiki_files_ft" ON "tiki_files"("name","description","search_data"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_forum_attachments --- 1578,1587 ---- *************** *** 1763,1772 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_forum_attachments"; - DROP SEQUENCE "tiki_forum_attachments_sequ"; CREATE SEQUENCE "tiki_forum_attachments_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_forum_attachments" ( "attId" number(14) NOT NULL, --- 1589,1596 ---- *************** *** 1788,1794 **** SELECT "tiki_forum_attachments_sequ".nextval into :NEW."attId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_forum_reads --- 1612,1617 ---- *************** *** 1796,1802 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 07:17 PM -- - DROP TABLE "tiki_forum_reads"; CREATE TABLE "tiki_forum_reads" ( --- 1619,1624 ---- *************** *** 1814,1823 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 11:14 PM -- - DROP TABLE "tiki_forums"; - DROP SEQUENCE "tiki_forums_sequ"; CREATE SEQUENCE "tiki_forums_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_forums" ( "forumId" number(8) NOT NULL, --- 1636,1643 ---- *************** *** 1851,1857 **** "moderator_group" varchar(200) default NULL, "approval_type" varchar(20) default NULL, "outbound_address" varchar(250) default NULL, ! "outbound_mails_for_inbound_mai" char(1) default NULL, "outbound_mails_reply_link" char(1) default NULL, "outbound_from" varchar(250) default NULL, "inbound_pop_server" varchar(250) default NULL, --- 1671,1677 ---- "moderator_group" varchar(200) default NULL, "approval_type" varchar(20) default NULL, "outbound_address" varchar(250) default NULL, ! "outbound_mails_for_inbound_mails" char(1) default NULL, "outbound_mails_reply_link" char(1) default NULL, "outbound_from" varchar(250) default NULL, "inbound_pop_server" varchar(250) default NULL, *************** *** 1881,1887 **** SELECT "tiki_forums_sequ".nextval into :NEW."forumId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_forums_queue --- 1701,1706 ---- *************** *** 1889,1898 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_forums_queue"; - DROP SEQUENCE "tiki_forums_queue_sequ"; CREATE SEQUENCE "tiki_forums_queue_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_forums_queue" ( "qId" number(14) NOT NULL, --- 1708,1715 ---- *************** *** 1916,1922 **** SELECT "tiki_forums_queue_sequ".nextval into :NEW."qId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_forums_reported --- 1733,1738 ---- *************** *** 1924,1930 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_forums_reported"; CREATE TABLE "tiki_forums_reported" ( --- 1740,1745 ---- *************** *** 1945,1954 **** -- Last update: Sep 18, 2004 at 11:56 PM -- Last check: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_galleries"; - DROP SEQUENCE "tiki_galleries_sequ"; CREATE SEQUENCE "tiki_galleries_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_galleries" ( "galleryId" number(14) NOT NULL, --- 1760,1767 ---- *************** *** 1988,1999 **** SELECT "tiki_galleries_sequ".nextval into :NEW."galleryId" FROM DUAL; END; / - CREATE INDEX "tiki_galleries_name" ON "tiki_galleries"("name"); CREATE INDEX "tiki_galleries_description" ON "tiki_galleries"("description"); CREATE INDEX "tiki_galleries_hits" ON "tiki_galleries"("hits"); CREATE INDEX "tiki_galleries_ft" ON "tiki_galleries"("name","description"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_galleries_scales --- 1801,1810 ---- *************** *** 2001,2007 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_galleries_scales"; CREATE TABLE "tiki_galleries_scales" ( --- 1812,1817 ---- *************** *** 2017,2023 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 05, 2003 at 08:23 PM -- - DROP TABLE "tiki_games"; CREATE TABLE "tiki_games" ( --- 1827,1832 ---- *************** *** 2035,2041 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 05, 2003 at 02:03 AM -- - DROP TABLE "tiki_group_inclusion"; CREATE TABLE "tiki_group_inclusion" ( --- 1844,1849 ---- *************** *** 2051,2057 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Mar 30, 2005 at 10:21 PM -- - DROP TABLE "tiki_history"; CREATE TABLE "tiki_history" ( --- 1859,1864 ---- *************** *** 2074,2080 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 10, 2003 at 11:04 PM -- - DROP TABLE "tiki_hotwords"; CREATE TABLE "tiki_hotwords" ( --- 1881,1886 ---- *************** *** 2090,2096 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_html_pages"; CREATE TABLE "tiki_html_pages" ( --- 1896,1901 ---- *************** *** 2109,2115 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_html_pages_dynamic_zones"; CREATE TABLE "tiki_html_pages_dynamic_zones" ( --- 1914,1919 ---- *************** *** 2128,2137 **** -- Last update: Sep 18, 2004 at 08:29 PM -- Last check: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_images"; - DROP SEQUENCE "tiki_images_sequ"; CREATE SEQUENCE "tiki_images_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_images" ( "imageId" number(14) NOT NULL, --- 1932,1939 ---- *************** *** 2152,2172 **** SELECT "tiki_images_sequ".nextval into :NEW."imageId" FROM DUAL; END; / - CREATE INDEX "tiki_images_name" ON "tiki_images"("name"); - CREATE INDEX "tiki_images_description" ON "tiki_images"("description"); - CREATE INDEX "tiki_images_hits" ON "tiki_images"("hits"); - CREATE INDEX "tiki_images_ti_gId" ON "tiki_images"("galleryId"); - CREATE INDEX "tiki_images_ti_cr" ON "tiki_images"("created"); - CREATE INDEX "tiki_images_ti_us" ON "tiki_images"("user"); - CREATE INDEX "tiki_images_ft" ON "tiki_images"("name","description"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_images_data --- 1954,1966 ---- *************** *** 2175,2181 **** -- Last update: Jul 12, 2003 at 12:49 PM -- Last check: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_images_data"; CREATE TABLE "tiki_images_data" ( --- 1969,1974 ---- *************** *** 2192,2198 **** ) ; CREATE INDEX "tiki_images_data_t_i_d_it" ON "tiki_images_data"("imageId","type"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_language --- 1985,1990 ---- *************** *** 2200,2214 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_language"; CREATE TABLE "tiki_language" ( "source" blob NOT NULL, "lang" char(16) default '' NOT NULL, "tran" blob, ! -- PRIMARY KEY ("source","lang") ! PRIMARY KEY ("lang") ) ; -- -------------------------------------------------------- --- 1992,2004 ---- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- DROP TABLE "tiki_language"; CREATE TABLE "tiki_language" ( "source" blob NOT NULL, "lang" char(16) default '' NOT NULL, "tran" blob, ! PRIMARY KEY ("source","lang") ) ; -- -------------------------------------------------------- *************** *** 2218,2224 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_languages"; CREATE TABLE "tiki_languages" ( --- 2008,2013 ---- *************** *** 2228,2234 **** ) ; -- -------------------------------------------------------- - INSERT INTO tiki_languages(lang, language) VALUES('en','English'); -- -------------------------------------------------------- --- 2017,2022 ---- *************** *** 2238,2247 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 06:06 PM -- - DROP TABLE "tiki_link_cache"; - DROP SEQUENCE "tiki_link_cache_sequ"; CREATE SEQUENCE "tiki_link_cache_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_link_cache" ( "cacheId" number(14) NOT NULL, --- 2026,2033 ---- *************** *** 2256,2262 **** SELECT "tiki_link_cache_sequ".nextval into :NEW."cacheId" FROM DUAL; END; / - CREATE INDEX urlindex ON tiki_link_cache (url(250)); -- -------------------------------------------------------- --- 2042,2047 ---- *************** *** 2266,2272 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 11:39 PM -- - DROP TABLE "tiki_links"; CREATE TABLE "tiki_links" ( --- 2051,2056 ---- *************** *** 2282,2291 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_live_support_events"; - DROP SEQUENCE "tiki_live_support_events_sequ"; CREATE SEQUENCE "tiki_live_support_events_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_live_support_events" ( "eventId" number(14) NOT NULL, --- 2066,2073 ---- *************** *** 2303,2322 **** SELECT "tiki_live_support_events_sequ".nextval into :NEW."eventId" FROM DUAL; END; / - -- -------------------------------------------------------- -- ! -- Table structure for table tiki_live_support_message_comm -- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- ! DROP TABLE "tiki_live_support_message_comm"; ! ! DROP SEQUENCE "tiki_live_support_message_c_sq"; ! CREATE SEQUENCE "tiki_live_support_message_c_sq" INCREMENT BY 1 START WITH 1; ! CREATE TABLE "tiki_live_support_message_comm" ( "cId" number(12) NOT NULL, "msgId" number(12) default NULL, "data" clob, --- 2085,2101 ---- SELECT "tiki_live_support_events_sequ".nextval into :NEW."eventId" FROM DUAL; END; / -- -------------------------------------------------------- -- ! -- Table structure for table tiki_live_support_message_comments -- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- + DROP TABLE "tiki_live_support_message_comments"; ! CREATE SEQUENCE "tiki_live_support_message_comments_sequ" INCREMENT BY 1 START WITH 1; ! CREATE TABLE "tiki_live_support_message_comments" ( "cId" number(12) NOT NULL, "msgId" number(12) default NULL, "data" clob, *************** *** 2324,2335 **** PRIMARY KEY ("cId") ) ; ! CREATE TRIGGER "tiki_live_support_message_c_t" BEFORE INSERT ON "tiki_live_support_message_comm" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_live_support_message_c_sq".nextval into :NEW."cId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_live_support_messages --- 2103,2113 ---- PRIMARY KEY ("cId") ) ; ! CREATE TRIGGER "tiki_live_support_message_comments_trig" BEFORE INSERT ON "tiki_live_support_message_comments" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_live_support_message_comments_sequ".nextval into :NEW."cId" FROM DUAL; END; / -- -------------------------------------------------------- -- -- Table structure for table tiki_live_support_messages *************** *** 2337,2347 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_live_support_messages"; ! DROP SEQUENCE "tiki_live_support_messages_s"; ! CREATE SEQUENCE "tiki_live_support_messages_s" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_live_support_messages" ( "msgId" number(12) NOT NULL, "data" clob, --- 2115,2123 ---- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- DROP TABLE "tiki_live_support_messages"; ! CREATE SEQUENCE "tiki_live_support_messages_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_live_support_messages" ( "msgId" number(12) NOT NULL, "data" clob, *************** *** 2358,2369 **** PRIMARY KEY ("msgId") ) ; ! CREATE TRIGGER "tiki_live_support_messages_tri" BEFORE INSERT ON "tiki_live_support_messages" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_live_support_messages_s".nextval into :NEW."msgId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_live_support_modules --- 2134,2144 ---- PRIMARY KEY ("msgId") ) ; ! CREATE TRIGGER "tiki_live_support_messages_trig" BEFORE INSERT ON "tiki_live_support_messages" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_live_support_messages_sequ".nextval into :NEW."msgId" FROM DUAL; END; / -- -------------------------------------------------------- -- -- Table structure for table tiki_live_support_modules *************** *** 2371,2380 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_live_support_modules"; - DROP SEQUENCE "tiki_live_support_modules_sequ"; CREATE SEQUENCE "tiki_live_support_modules_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_live_support_modules" ( "modId" number(4) NOT NULL, --- 2146,2153 ---- *************** *** 2387,2395 **** SELECT "tiki_live_support_modules_sequ".nextval into :NEW."modId" FROM DUAL; END; / - -- -------------------------------------------------------- - INSERT INTO tiki_live_support_modules(name) VALUES('wiki'); INSERT INTO tiki_live_support_modules(name) VALUES('forums'); --- 2160,2166 ---- *************** *** 2411,2417 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_live_support_operators"; CREATE TABLE "tiki_live_support_operators" ( --- 2182,2187 ---- *************** *** 2436,2442 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_live_support_requests"; CREATE TABLE "tiki_live_support_requests" ( --- 2206,2211 ---- *************** *** 2464,2473 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_logs"; - DROP SEQUENCE "tiki_logs_sequ"; CREATE SEQUENCE "tiki_logs_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_logs" ( "logId" number(8) NOT NULL, --- 2233,2240 ---- *************** *** 2485,2491 **** SELECT "tiki_logs_sequ".nextval into :NEW."logId" FROM DUAL; END; / - CREATE INDEX "tiki_logs_logtype" ON "tiki_logs"("logtype"); -- -------------------------------------------------------- --- 2252,2257 ---- *************** *** 2495,2501 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 05:28 AM -- - DROP TABLE "tiki_mail_events"; CREATE TABLE "tiki_mail_events" ( --- 2261,2266 ---- *************** *** 2511,2520 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jun 17, 2004 at 03:06 PM EST -- - DROP TABLE "tiki_mailin_accounts"; - DROP SEQUENCE "tiki_mailin_accounts_sequ"; CREATE SEQUENCE "tiki_mailin_accounts_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_mailin_accounts" ( "accountId" number(12) NOT NULL, --- 2276,2283 ---- *************** *** 2542,2548 **** SELECT "tiki_mailin_accounts_sequ".nextval into :NEW."accountId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_menu_languages --- 2305,2310 ---- *************** *** 2550,2559 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_menu_languages"; - DROP SEQUENCE "tiki_menu_languages_sequ"; CREATE SEQUENCE "tiki_menu_languages_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_menu_languages" ( "menuId" number(8) NOT NULL, --- 2312,2319 ---- *************** *** 2566,2572 **** SELECT "tiki_menu_languages_sequ".nextval into :NEW."menuId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_menu_options --- 2326,2331 ---- *************** *** 2574,2583 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Nov 21, 2003 at 07:05 AM -- - DROP TABLE "tiki_menu_options"; - DROP SEQUENCE "tiki_menu_options_sequ"; CREATE SEQUENCE "tiki_menu_options_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_menu_options" ( "optionId" number(8) NOT NULL, --- 2333,2340 ---- *************** *** 2597,2605 **** SELECT "tiki_menu_options_sequ".nextval into :NEW."optionId" FROM DUAL; END; / - -- -------------------------------------------------------- - INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Home','tiki-index.php',10,'','',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Chat','tiki-chat.php',15,'feature_chat','tiki_p_chat',''); --- 2354,2360 ---- *************** *** 2974,2983 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_menus"; - DROP SEQUENCE "tiki_menus_sequ"; CREATE SEQUENCE "tiki_menus_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_menus" ( "menuId" number(8) NOT NULL, --- 2729,2736 ---- *************** *** 2992,3000 **** SELECT "tiki_menus_sequ".nextval into :NEW."menuId" FROM DUAL; END; / - -- -------------------------------------------------------- - INSERT INTO "tiki_menus" ("menuId","name","description","type") VALUES ('42','Application menu','Main extensive navigation menu','d'); -- -------------------------------------------------------- --- 2745,2751 ---- *************** *** 3004,3013 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 09, 2003 at 04:06 AM -- - DROP TABLE "tiki_minical_events"; - DROP SEQUENCE "tiki_minical_events_sequ"; CREATE SEQUENCE "tiki_minical_events_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_minical_events" ( "user" varchar(40) default NULL, --- 2755,2762 ---- *************** *** 3028,3034 **** SELECT "tiki_minical_events_sequ".nextval into :NEW."eventId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_minical_topics --- 2777,2782 ---- *************** *** 3036,3045 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_minical_topics"; - DROP SEQUENCE "tiki_minical_topics_sequ"; CREATE SEQUENCE "tiki_minical_topics_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_minical_topics" ( "user" varchar(40) default NULL, --- 2784,2791 ---- *************** *** 3059,3065 **** SELECT "tiki_minical_topics_sequ".nextval into :NEW."topicId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_modules --- 2805,2810 ---- *************** *** 3067,3073 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 11:44 PM -- - DROP TABLE "tiki_modules"; CREATE TABLE "tiki_modules" ( --- 2812,2817 ---- *************** *** 3084,3090 **** ) ; -- -------------------------------------------------------- - INSERT INTO "tiki_modules" ("name","position","ord","cache_time","groups") VALUES ('login_box','r',1,0,'a:2:{i:0;s:10:"Registered";i:1;s:9:"Anonymous";}'); INSERT INTO "tiki_modules" ("name","position","ord","cache_time","params","groups") VALUES ('mnu_application_menu','l',1,0,'flip=y','a:2:{i:0;s:10:"Registered";i:1;s:9:"Anonymous";}'); --- 2828,2833 ---- *************** *** 3100,3106 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_newsletter_subscriptions"; CREATE TABLE "tiki_newsletter_subscriptions" ( --- 2843,2848 ---- *************** *** 3120,3126 **** -- Creation: Jan 18, 2005 -- Last update: Jan 18, 2005 -- - DROP TABLE "tiki_newsletter_groups"; CREATE TABLE "tiki_newsletter_groups" ( --- 2862,2867 ---- *************** *** 3137,3146 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_newsletters"; - DROP SEQUENCE "tiki_newsletters_sequ"; CREATE SEQUENCE "tiki_newsletters_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_newsletters" ( "nlId" number(12) NOT NULL, --- 2878,2885 ---- *************** *** 3163,3169 **** SELECT "tiki_newsletters_sequ".nextval into :NEW."nlId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_newsreader_marks --- 2902,2907 ---- *************** *** 3171,3177 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_newsreader_marks"; CREATE TABLE "tiki_newsreader_marks" ( --- 2909,2914 ---- *************** *** 3189,3198 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_newsreader_servers"; - DROP SEQUENCE "tiki_newsreader_servers_sequ"; CREATE SEQUENCE "tiki_newsreader_servers_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_newsreader_servers" ( "user" varchar(40) default '' NOT NULL, --- 2926,2933 ---- *************** *** 3209,3215 **** SELECT "tiki_newsreader_servers_sequ".nextval into :NEW."serverId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_page_footnotes --- 2944,2949 ---- *************** *** 3218,3224 **** -- Last update: Jul 12, 2003 at 10:00 AM -- Last check: Jul 12, 2003 at 10:00 AM -- - DROP TABLE "tiki_page_footnotes"; CREATE TABLE "tiki_page_footnotes" ( --- 2952,2957 ---- *************** *** 3236,3245 **** -- Last update: Jul 13, 2003 at 01:52 AM -- Last check: Jul 12, 2003 at 10:01 AM -- - DROP TABLE "tiki_pages"; - DROP SEQUENCE "tiki_pages_sequ"; CREATE SEQUENCE "tiki_pages_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_pages" ( "page_id" number(14) NOT NULL, --- 2969,2976 ---- *************** *** 3273,3284 **** SELECT "tiki_pages_sequ".nextval into :NEW."page_id" FROM DUAL; END; / - CREATE INDEX "tiki_pages_data" ON "tiki_pages"("data"); CREATE INDEX "tiki_pages_pageRank" ON "tiki_pages"("pageRank"); CREATE INDEX "tiki_pages_ft" ON "tiki_pages"("pageName","description","data"); CREATE UNIQUE INDEX "tiki_pages_pageName" ON "tiki_pages"("pageName"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_pageviews --- 3004,3013 ---- *************** *** 3286,3292 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 13, 2003 at 01:52 AM -- - DROP TABLE "tiki_pageviews"; CREATE TABLE "tiki_pageviews" ( --- 3015,3020 ---- *************** *** 3299,3312 **** -- -- Table structure for table tiki_poll_objects -- - DROP TABLE "tiki_poll_objects"; ! CREATE TABLE "tiki_poll_objects" ( ! "catObjectId" number(11) default '0' NOT NULL, ! "pollId" number(11) default '0' NOT NULL, ! "title" varchar(255) default NULL, ! PRIMARY KEY ("catObjectId","pollId") ) ; -- -------------------------------------------------------- --- 3027,3039 ---- -- -- Table structure for table tiki_poll_objects -- DROP TABLE "tiki_poll_objects"; ! CREATE TABLE `tiki_poll_objects` ( ! `catObjectId` number(11) default '0' NOT NULL, ! `pollId` number(11) default '0' NOT NULL, ! `title` varchar(255) default NULL, ! PRIMARY KEY ("`catObjectId`","`pollId`") ) ; -- -------------------------------------------------------- *************** *** 3316,3325 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 06, 2003 at 07:57 PM -- - DROP TABLE "tiki_poll_options"; - DROP SEQUENCE "tiki_poll_options_sequ"; CREATE SEQUENCE "tiki_poll_options_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_poll_options" ( "pollId" number(8) default '0' NOT NULL, --- 3043,3050 ---- *************** *** 3335,3341 **** SELECT "tiki_poll_options_sequ".nextval into :NEW."optionId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_polls --- 3060,3065 ---- *************** *** 3343,3352 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 06, 2003 at 07:57 PM -- - DROP TABLE "tiki_polls"; - DROP SEQUENCE "tiki_polls_sequ"; CREATE SEQUENCE "tiki_polls_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_polls" ( "pollId" number(8) NOT NULL, --- 3067,3074 ---- *************** *** 3362,3368 **** SELECT "tiki_polls_sequ".nextval into :NEW."pollId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_preferences --- 3084,3089 ---- *************** *** 3370,3376 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 12:04 PM -- - DROP TABLE "tiki_preferences"; CREATE TABLE "tiki_preferences" ( --- 3091,3096 ---- *************** *** 3386,3395 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_private_messages"; - DROP SEQUENCE "tiki_private_messages_sequ"; CREATE SEQUENCE "tiki_private_messages_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_private_messages" ( "messageId" number(8) NOT NULL, --- 3106,3113 ---- *************** *** 3405,3411 **** SELECT "tiki_private_messages_sequ".nextval into :NEW."messageId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_programmed_content --- 3123,3128 ---- *************** *** 3413,3422 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_programmed_content"; - DROP SEQUENCE "tiki_programmed_content_sequ"; CREATE SEQUENCE "tiki_programmed_content_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_programmed_content" ( "pId" number(8) NOT NULL, --- 3130,3137 ---- *************** *** 3431,3437 **** SELECT "tiki_programmed_content_sequ".nextval into :NEW."pId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_quiz_question_options --- 3146,3151 ---- *************** *** 3439,3449 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_quiz_question_options"; ! DROP SEQUENCE "tiki_quiz_question_options_seq"; ! CREATE SEQUENCE "tiki_quiz_question_options_seq" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_quiz_question_options" ( "optionId" number(10) NOT NULL, "questionId" number(10) default NULL, --- 3153,3161 ---- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- DROP TABLE "tiki_quiz_question_options"; ! CREATE SEQUENCE "tiki_quiz_question_options_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_quiz_question_options" ( "optionId" number(10) NOT NULL, "questionId" number(10) default NULL, *************** *** 3452,3463 **** PRIMARY KEY ("optionId") ) ; ! CREATE TRIGGER "tiki_quiz_question_options_tri" BEFORE INSERT ON "tiki_quiz_question_options" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_quiz_question_options_seq".nextval into :NEW."optionId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_quiz_questions --- 3164,3174 ---- PRIMARY KEY ("optionId") ) ; ! CREATE TRIGGER "tiki_quiz_question_options_trig" BEFORE INSERT ON "tiki_quiz_question_options" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_quiz_question_options_sequ".nextval into :NEW."optionId" FROM DUAL; END; / -- -------------------------------------------------------- -- -- Table structure for table tiki_quiz_questions *************** *** 3465,3474 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_quiz_questions"; - DROP SEQUENCE "tiki_quiz_questions_sequ"; CREATE SEQUENCE "tiki_quiz_questions_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_quiz_questions" ( "questionId" number(10) NOT NULL, --- 3176,3183 ---- *************** *** 3485,3491 **** SELECT "tiki_quiz_questions_sequ".nextval into :NEW."questionId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_quiz_results --- 3194,3199 ---- *************** *** 3493,3502 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_quiz_results"; - DROP SEQUENCE "tiki_quiz_results_sequ"; CREATE SEQUENCE "tiki_quiz_results_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_quiz_results" ( "resultId" number(10) NOT NULL, --- 3201,3208 ---- *************** *** 3512,3518 **** SELECT "tiki_quiz_results_sequ".nextval into :NEW."resultId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_quiz_stats --- 3218,3223 ---- *************** *** 3520,3526 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_quiz_stats"; CREATE TABLE "tiki_quiz_stats" ( --- 3225,3230 ---- *************** *** 3538,3544 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_quiz_stats_sum"; CREATE TABLE "tiki_quiz_stats_sum" ( --- 3242,3247 ---- *************** *** 3558,3567 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: April 29, 2004 -- - DROP TABLE "tiki_quizzes"; - DROP SEQUENCE "tiki_quizzes_sequ"; CREATE SEQUENCE "tiki_quizzes_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_quizzes" ( "quizId" number(10) NOT NULL, --- 3261,3268 ---- *************** *** 3609,3615 **** SELECT "tiki_quizzes_sequ".nextval into :NEW."quizId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_received_articles --- 3310,3315 ---- *************** *** 3617,3626 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_received_articles"; - DROP SEQUENCE "tiki_received_articles_sequ"; CREATE SEQUENCE "tiki_received_articles_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_received_articles" ( "receivedArticleId" number(14) NOT NULL, --- 3317,3324 ---- *************** *** 3654,3660 **** SELECT "tiki_received_articles_sequ".nextval into :NEW."receivedArticleId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_received_pages --- 3352,3357 ---- *************** *** 3662,3671 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 09, 2003 at 03:56 AM -- - DROP TABLE "tiki_received_pages"; - DROP SEQUENCE "tiki_received_pages_sequ"; CREATE SEQUENCE "tiki_received_pages_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_received_pages" ( "receivedPageId" number(14) NOT NULL, --- 3359,3366 ---- *************** *** 3684,3690 **** SELECT "tiki_received_pages_sequ".nextval into :NEW."receivedPageId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_referer_stats --- 3379,3384 ---- *************** *** 3692,3698 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 13, 2003 at 01:30 AM -- - DROP TABLE "tiki_referer_stats"; CREATE TABLE "tiki_referer_stats" ( --- 3386,3391 ---- *************** *** 3709,3715 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_related_categories"; CREATE TABLE "tiki_related_categories" ( --- 3402,3407 ---- *************** *** 3725,3734 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 10:19 AM -- - DROP TABLE "tiki_rss_modules"; - DROP SEQUENCE "tiki_rss_modules_sequ"; CREATE SEQUENCE "tiki_rss_modules_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_rss_modules" ( "rssId" number(8) NOT NULL, --- 3417,3424 ---- *************** *** 3748,3754 **** SELECT "tiki_rss_modules_sequ".nextval into :NEW."rssId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_rss_feeds --- 3438,3443 ---- *************** *** 3756,3762 **** -- Creation: Oct 14, 2003 at 20:34 PM -- Last update: Oct 14, 2003 at 20:34 PM -- - DROP TABLE "tiki_rss_feeds"; CREATE TABLE "tiki_rss_feeds" ( --- 3445,3450 ---- *************** *** 3769,3775 **** ) ; -- -------------------------------------------------------- - DROP TABLE "tiki_searchindex"; CREATE TABLE "tiki_searchindex"( --- 3457,3462 ---- *************** *** 3811,3817 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 10:55 PM -- - DROP TABLE "tiki_search_stats"; CREATE TABLE "tiki_search_stats" ( --- 3498,3503 ---- *************** *** 3825,3831 **** -- Table structure for table tiki_secdb -- -- - DROP TABLE "tiki_secdb"; CREATE TABLE "tiki_secdb"( --- 3511,3516 ---- *************** *** 3844,3850 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 13, 2003 at 01:52 AM -- - DROP TABLE "tiki_semaphores"; CREATE TABLE "tiki_semaphores" ( --- 3529,3534 ---- *************** *** 3861,3870 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_sent_newsletters"; - DROP SEQUENCE "tiki_sent_newsletters_sequ"; CREATE SEQUENCE "tiki_sent_newsletters_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_sent_newsletters" ( "editionId" number(12) NOT NULL, --- 3545,3552 ---- *************** *** 3881,3887 **** SELECT "tiki_sent_newsletters_sequ".nextval into :NEW."editionId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_sessions --- 3563,3568 ---- *************** *** 3889,3895 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 13, 2003 at 01:52 AM -- - DROP TABLE "tiki_sessions"; CREATE TABLE "tiki_sessions" ( --- 3570,3575 ---- *************** *** 3935,3941 **** DROP TABLE "tiki_sheets"; - DROP SEQUENCE "tiki_sheets_sequ"; CREATE SEQUENCE "tiki_sheets_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_sheets" ( "sheetId" number(8) NOT NULL, --- 3615,3620 ---- *************** *** 3957,3966 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 08:21 PM -- - DROP TABLE "tiki_shoutbox"; - DROP SEQUENCE "tiki_shoutbox_sequ"; CREATE SEQUENCE "tiki_shoutbox_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_shoutbox" ( "msgId" number(10) NOT NULL, --- 3636,3643 ---- *************** *** 3976,3987 **** SELECT "tiki_shoutbox_sequ".nextval into :NEW."msgId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_shoutbox_words -- - DROP TABLE "tiki_shoutbox_words"; CREATE TABLE "tiki_shoutbox_words" ( --- 3653,3662 ---- *************** *** 3997,4006 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_structure_versions"; - DROP SEQUENCE "tiki_structure_versions_sequ"; CREATE SEQUENCE "tiki_structure_versions_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_structure_versions" ( "structure_id" number(14) NOT NULL, --- 3672,3679 ---- *************** *** 4013,4019 **** SELECT "tiki_structure_versions_sequ".nextval into :NEW."structure_id" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_structures --- 3686,3691 ---- *************** *** 4021,4030 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_structures"; - DROP SEQUENCE "tiki_structures_sequ"; CREATE SEQUENCE "tiki_structures_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_structures" ( "page_ref_id" number(14) NOT NULL, --- 3693,3700 ---- *************** *** 4042,4050 **** SELECT "tiki_structures_sequ".nextval into :NEW."page_ref_id" FROM DUAL; END; / - CREATE INDEX "tiki_structures_pidpaid" ON "tiki_structures"("page_id","parent_id"); - -- -------------------------------------------------------- -- -- Table structure for table tiki_submissions --- 3712,3718 ---- *************** *** 4052,4061 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 08, 2003 at 04:16 PM -- - DROP TABLE "tiki_submissions"; - DROP SEQUENCE "tiki_submissions_sequ"; CREATE SEQUENCE "tiki_submissions_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_submissions" ( "subId" number(8) NOT NULL, --- 3720,3727 ---- *************** *** 4099,4105 **** SELECT "tiki_submissions_sequ".nextval into :NEW."subId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_suggested_faq_questions --- 3765,3770 ---- *************** *** 4107,4117 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 08:52 PM -- - DROP TABLE "tiki_suggested_faq_questions"; ! DROP SEQUENCE "tiki_suggested_faq_questions_s"; ! CREATE SEQUENCE "tiki_suggested_faq_questions_s" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_suggested_faq_questions" ( "sfqId" number(10) NOT NULL, "faqId" number(10) default '0' NOT NULL, --- 3772,3780 ---- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 08:52 PM -- DROP TABLE "tiki_suggested_faq_questions"; ! CREATE SEQUENCE "tiki_suggested_faq_questions_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_suggested_faq_questions" ( "sfqId" number(10) NOT NULL, "faqId" number(10) default '0' NOT NULL, *************** *** 4122,4133 **** PRIMARY KEY ("sfqId") ) ; ! CREATE TRIGGER "tiki_suggested_faq_questions_t" BEFORE INSERT ON "tiki_suggested_faq_questions" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_suggested_faq_questions_s".nextval into :NEW."sfqId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_survey_question_options --- 3785,3795 ---- PRIMARY KEY ("sfqId") ) ; ! CREATE TRIGGER "tiki_suggested_faq_questions_trig" BEFORE INSERT ON "tiki_suggested_faq_questions" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_suggested_faq_questions_sequ".nextval into :NEW."sfqId" FROM DUAL; END; / -- -------------------------------------------------------- -- -- Table structure for table tiki_survey_question_options *************** *** 4135,4145 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 12:55 AM -- - DROP TABLE "tiki_survey_question_options"; ! DROP SEQUENCE "tiki_survey_question_options_s"; ! CREATE SEQUENCE "tiki_survey_question_options_s" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_survey_question_options" ( "optionId" number(12) NOT NULL, "questionId" number(12) default '0' NOT NULL, --- 3797,3805 ---- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 12:55 AM -- DROP TABLE "tiki_survey_question_options"; ! CREATE SEQUENCE "tiki_survey_question_options_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_survey_question_options" ( "optionId" number(12) NOT NULL, "questionId" number(12) default '0' NOT NULL, *************** *** 4148,4159 **** PRIMARY KEY ("optionId") ) ; ! CREATE TRIGGER "tiki_survey_question_options_t" BEFORE INSERT ON "tiki_survey_question_options" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_survey_question_options_s".nextval into :NEW."optionId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_survey_questions --- 3808,3818 ---- PRIMARY KEY ("optionId") ) ; ! CREATE TRIGGER "tiki_survey_question_options_trig" BEFORE INSERT ON "tiki_survey_question_options" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_survey_question_options_sequ".nextval into :NEW."optionId" FROM DUAL; END; / -- -------------------------------------------------------- -- -- Table structure for table tiki_survey_questions *************** *** 4161,4170 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 11:55 PM -- - DROP TABLE "tiki_survey_questions"; - DROP SEQUENCE "tiki_survey_questions_sequ"; CREATE SEQUENCE "tiki_survey_questions_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_survey_questions" ( "questionId" number(12) NOT NULL, --- 3820,3827 ---- *************** *** 4184,4190 **** SELECT "tiki_survey_questions_sequ".nextval into :NEW."questionId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_surveys --- 3841,3846 ---- *************** *** 4192,4201 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 07:40 PM -- - DROP TABLE "tiki_surveys"; - DROP SEQUENCE "tiki_surveys_sequ"; CREATE SEQUENCE "tiki_surveys_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_surveys" ( "surveyId" number(12) NOT NULL, --- 3848,3855 ---- *************** *** 4213,4219 **** SELECT "tiki_surveys_sequ".nextval into :NEW."surveyId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_tags --- 3867,3872 ---- *************** *** 4221,4227 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 06, 2003 at 02:58 AM -- - DROP TABLE "tiki_tags"; CREATE TABLE "tiki_tags" ( --- 3874,3879 ---- *************** *** 4246,4252 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_theme_control_categs"; CREATE TABLE "tiki_theme_control_categs" ( --- 3898,3903 ---- *************** *** 4262,4268 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_theme_control_objects"; CREATE TABLE "tiki_theme_control_objects" ( --- 3913,3918 ---- *************** *** 4280,4286 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_theme_control_sections"; CREATE TABLE "tiki_theme_control_sections" ( --- 3930,3935 ---- *************** *** 4296,4305 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 04, 2003 at 10:10 PM -- - DROP TABLE "tiki_topics"; - DROP SEQUENCE "tiki_topics_sequ"; CREATE SEQUENCE "tiki_topics_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_topics" ( "topicId" number(14) NOT NULL, --- 3945,3952 ---- *************** *** 4318,4324 **** SELECT "tiki_topics_sequ".nextval into :NEW."topicId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_tracker_fields --- 3965,3970 ---- *************** *** 4326,4335 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 08, 2003 at 01:48 PM -- - DROP TABLE "tiki_tracker_fields"; - DROP SEQUENCE "tiki_tracker_fields_sequ"; CREATE SEQUENCE "tiki_tracker_fields_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_tracker_fields" ( "fieldId" number(12) NOT NULL, --- 3972,3979 ---- *************** *** 4352,4358 **** SELECT "tiki_tracker_fields_sequ".nextval into :NEW."fieldId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_tracker_item_attachments --- 3996,4001 ---- *************** *** 4360,4370 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_tracker_item_attachments"; ! DROP SEQUENCE "tiki_tracker_item_attachment_s"; ! CREATE SEQUENCE "tiki_tracker_item_attachment_s" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_tracker_item_attachments" ( "attId" number(12) NOT NULL, "itemId" number(12) default 0 NOT NULL, --- 4003,4011 ---- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- DROP TABLE "tiki_tracker_item_attachments"; ! CREATE SEQUENCE "tiki_tracker_item_attachments_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_tracker_item_attachments" ( "attId" number(12) NOT NULL, "itemId" number(12) default 0 NOT NULL, *************** *** 4382,4393 **** PRIMARY KEY ("attId") ) ; ! CREATE TRIGGER "tiki_tracker_item_attachment_t" BEFORE INSERT ON "tiki_tracker_item_attachments" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_tracker_item_attachment_s".nextval into :NEW."attId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_tracker_item_comments --- 4023,4033 ---- PRIMARY KEY ("attId") ) ; ! CREATE TRIGGER "tiki_tracker_item_attachments_trig" BEFORE INSERT ON "tiki_tracker_item_attachments" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_tracker_item_attachments_sequ".nextval into :NEW."attId" FROM DUAL; END; / -- -------------------------------------------------------- -- -- Table structure for table tiki_tracker_item_comments *************** *** 4395,4405 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 08:12 AM -- - DROP TABLE "tiki_tracker_item_comments"; ! DROP SEQUENCE "tiki_tracker_item_comments_seq"; ! CREATE SEQUENCE "tiki_tracker_item_comments_seq" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_tracker_item_comments" ( "commentId" number(12) NOT NULL, "itemId" number(12) default '0' NOT NULL, --- 4035,4043 ---- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 08:12 AM -- DROP TABLE "tiki_tracker_item_comments"; ! CREATE SEQUENCE "tiki_tracker_item_comments_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_tracker_item_comments" ( "commentId" number(12) NOT NULL, "itemId" number(12) default '0' NOT NULL, *************** *** 4410,4421 **** PRIMARY KEY ("commentId") ) ; ! CREATE TRIGGER "tiki_tracker_item_comments_tri" BEFORE INSERT ON "tiki_tracker_item_comments" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_tracker_item_comments_seq".nextval into :NEW."commentId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_tracker_item_fields --- 4048,4058 ---- PRIMARY KEY ("commentId") ) ; ! CREATE TRIGGER "tiki_tracker_item_comments_trig" BEFORE INSERT ON "tiki_tracker_item_comments" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_tracker_item_comments_sequ".nextval into :NEW."commentId" FROM DUAL; END; / -- -------------------------------------------------------- -- -- Table structure for table tiki_tracker_item_fields *************** *** 4423,4429 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 08:26 AM -- - DROP TABLE "tiki_tracker_item_fields"; CREATE TABLE "tiki_tracker_item_fields" ( --- 4060,4065 ---- *************** *** 4440,4449 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 08:26 AM -- - DROP TABLE "tiki_tracker_items"; - DROP SEQUENCE "tiki_tracker_items_sequ"; CREATE SEQUENCE "tiki_tracker_items_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_tracker_items" ( "itemId" number(12) NOT NULL, --- 4076,4083 ---- *************** *** 4459,4465 **** SELECT "tiki_tracker_items_sequ".nextval into :NEW."itemId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_tracker_options --- 4093,4098 ---- *************** *** 4467,4473 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 08, 2003 at 01:48 PM -- - DROP TABLE "tiki_tracker_options"; CREATE TABLE "tiki_tracker_options" ( --- 4100,4105 ---- *************** *** 4484,4493 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 08:26 AM -- - DROP TABLE "tiki_trackers"; - DROP SEQUENCE "tiki_trackers_sequ"; CREATE SEQUENCE "tiki_trackers_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_trackers" ( "trackerId" number(12) NOT NULL, --- 4116,4123 ---- *************** *** 4512,4518 **** SELECT "tiki_trackers_sequ".nextval into :NEW."trackerId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_untranslated --- 4142,4147 ---- *************** *** 4520,4535 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_untranslated"; - DROP SEQUENCE "tiki_untranslated_sequ"; CREATE SEQUENCE "tiki_untranslated_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_untranslated" ( "id" number(14) NOT NULL, "source" blob NOT NULL, "lang" char(16) default '' NOT NULL, ! PRIMARY KEY ("id", "lang") ) ; CREATE TRIGGER "tiki_untranslated_trig" BEFORE INSERT ON "tiki_untranslated" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW --- 4149,4162 ---- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- DROP TABLE "tiki_untranslated"; CREATE SEQUENCE "tiki_untranslated_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_untranslated" ( "id" number(14) NOT NULL, "source" blob NOT NULL, "lang" char(16) default '' NOT NULL, ! PRIMARY KEY ("source","lang") ) ; CREATE TRIGGER "tiki_untranslated_trig" BEFORE INSERT ON "tiki_untranslated" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW *************** *** 4537,4545 **** SELECT "tiki_untranslated_sequ".nextval into :NEW."id" FROM DUAL; END; / - CREATE INDEX "tiki_untranslated_id_2" ON "tiki_untranslated"("id"); ! -- -------------------------------------------------------- -- -- Table structure for table tiki_user_answers --- 4164,4171 ---- SELECT "tiki_untranslated_sequ".nextval into :NEW."id" FROM DUAL; END; / CREATE INDEX "tiki_untranslated_id_2" ON "tiki_untranslated"("id"); ! CREATE UNIQUE INDEX "tiki_untranslated_id" ON "tiki_untranslated"("id"); -- -------------------------------------------------------- -- -- Table structure for table tiki_user_answers *************** *** 4547,4553 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_user_answers"; CREATE TABLE "tiki_user_answers" ( --- 4173,4178 ---- *************** *** 4565,4574 **** -- Creation: Jan 25, 2005 at 07:42 PM -- Last update: Jan 25, 2005 at 07:42 PM -- - DROP TABLE "tiki_user_answers_uploads"; - DROP SEQUENCE "tiki_user_answers_uploads_sequ"; CREATE SEQUENCE "tiki_user_answers_uploads_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_user_answers_uploads" ( "answerUploadId" number(4) NOT NULL, --- 4190,4197 ---- *************** *** 4593,4599 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 08:25 PM -- - DROP TABLE "tiki_user_assigned_modules"; CREATE TABLE "tiki_user_assigned_modules" ( --- 4216,4221 ---- *************** *** 4612,4622 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 08:35 AM -- - DROP TABLE "tiki_user_bookmarks_folders"; ! DROP SEQUENCE "tiki_user_bookmarks_folders_s"; ! CREATE SEQUENCE "tiki_user_bookmarks_folders_s" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_user_bookmarks_folders" ( "folderId" number(12) NOT NULL, "parentId" number(12) default NULL, --- 4234,4242 ---- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 08:35 AM -- DROP TABLE "tiki_user_bookmarks_folders"; ! CREATE SEQUENCE "tiki_user_bookmarks_folders_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_user_bookmarks_folders" ( "folderId" number(12) NOT NULL, "parentId" number(12) default NULL, *************** *** 4625,4636 **** PRIMARY KEY ("user","folderId") ) ; ! CREATE TRIGGER "tiki_user_bookmarks_folders_t" BEFORE INSERT ON "tiki_user_bookmarks_folders" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_user_bookmarks_folders_s".nextval into :NEW."folderId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_user_bookmarks_urls --- 4245,4255 ---- PRIMARY KEY ("user","folderId") ) ; ! CREATE TRIGGER "tiki_user_bookmarks_folders_trig" BEFORE INSERT ON "tiki_user_bookmarks_folders" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN ! SELECT "tiki_user_bookmarks_folders_sequ".nextval into :NEW."folderId" FROM DUAL; END; / -- -------------------------------------------------------- -- -- Table structure for table tiki_user_bookmarks_urls *************** *** 4638,4647 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 08:36 AM -- - DROP TABLE "tiki_user_bookmarks_urls"; - DROP SEQUENCE "tiki_user_bookmarks_urls_sequ"; CREATE SEQUENCE "tiki_user_bookmarks_urls_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_user_bookmarks_urls" ( "urlId" number(12) NOT NULL, --- 4257,4264 ---- *************** *** 4659,4665 **** SELECT "tiki_user_bookmarks_urls_sequ".nextval into :NEW."urlId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_user_mail_accounts --- 4276,4281 ---- *************** *** 4667,4676 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_user_mail_accounts"; - DROP SEQUENCE "tiki_user_mail_accounts_sequ"; CREATE SEQUENCE "tiki_user_mail_accounts_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_user_mail_accounts" ( "accountId" number(12) NOT NULL, --- 4283,4290 ---- *************** *** 4693,4699 **** SELECT "tiki_user_mail_accounts_sequ".nextval into :NEW."accountId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_user_menus --- 4307,4312 ---- *************** *** 4701,4710 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 10:58 PM -- - DROP TABLE "tiki_user_menus"; - DROP SEQUENCE "tiki_user_menus_sequ"; CREATE SEQUENCE "tiki_user_menus_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_user_menus" ( "user" varchar(40) default '' NOT NULL, --- 4314,4321 ---- *************** *** 4721,4727 **** SELECT "tiki_user_menus_sequ".nextval into :NEW."menuId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_user_modules --- 4332,4337 ---- *************** *** 4729,4747 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 05, 2003 at 03:16 AM -- - DROP TABLE "tiki_user_modules"; CREATE TABLE "tiki_user_modules" ( "name" varchar(200) default '' NOT NULL, "title" varchar(40) default NULL, ! "data" clob, -- ?? cj "parse" char(1) default NULL, PRIMARY KEY ("name") ) ; -- -------------------------------------------------------- - INSERT INTO "tiki_user_modules" ("name","title","data","parse") VALUES ('mnu_application_menu', 'Menu', '{menu id=42}', 'n'); --- 4339,4355 ---- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 05, 2003 at 03:16 AM -- DROP TABLE "tiki_user_modules"; CREATE TABLE "tiki_user_modules" ( "name" varchar(200) default '' NOT NULL, "title" varchar(40) default NULL, ! "data" blob, "parse" char(1) default NULL, PRIMARY KEY ("name") ) ; -- -------------------------------------------------------- INSERT INTO "tiki_user_modules" ("name","title","data","parse") VALUES ('mnu_application_menu', 'Menu', '{menu id=42}', 'n'); *************** *** 4751,4760 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 07:52 AM -- - DROP TABLE "tiki_user_notes"; - DROP SEQUENCE "tiki_user_notes_sequ"; CREATE SEQUENCE "tiki_user_notes_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_user_notes" ( "user" varchar(40) default '' NOT NULL, --- 4359,4366 ---- *************** *** 4773,4779 **** SELECT "tiki_user_notes_sequ".nextval into :NEW."noteId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_user_postings --- 4379,4384 ---- *************** *** 4781,4787 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 13, 2003 at 01:12 AM -- - DROP TABLE "tiki_user_postings"; CREATE TABLE "tiki_user_postings" ( --- 4386,4391 ---- *************** *** 4800,4806 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 13, 2003 at 01:09 AM -- - DROP TABLE "tiki_user_preferences"; CREATE TABLE "tiki_user_preferences" ( --- 4404,4409 ---- *************** *** 4817,4826 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_user_quizzes"; - DROP SEQUENCE "tiki_user_quizzes_sequ"; CREATE SEQUENCE "tiki_user_quizzes_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_user_quizzes" ( "user" varchar(40) default NULL, --- 4420,4427 ---- *************** *** 4839,4845 **** SELECT "tiki_user_quizzes_sequ".nextval into :NEW."userResultId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_user_taken_quizzes --- 4440,4445 ---- *************** *** 4847,4853 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_user_taken_quizzes"; CREATE TABLE "tiki_user_taken_quizzes" ( --- 4447,4452 ---- *************** *** 4863,4890 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jan 25, 2005 by sir-b & moresun -- - DROP TABLE "tiki_user_tasks_history"; CREATE TABLE "tiki_user_tasks_history" ( ! "belongs_to" number(14) NOT NULL, -- the fist task in a history it has the same id as the task id ! "task_version" number(4) DEFAULT 0 NOT NULL, -- version number for the history it starts with 0 "title" varchar(250) NOT NULL, -- title "description" clob DEFAULT NULL, -- description ! "start" number(14) DEFAULT NULL, -- date of the starting, if it is not set than there is not starting date ! "end" number(14) DEFAULT NULL, -- date of the end, if it is not set than there is not dealine "lasteditor" varchar(200) NOT NULL, -- lasteditor: username of last editior ! "lastchanges" number(14) NOT NULL, -- date of last changes ! "priority" number(2) DEFAULT 3 NOT NULL, -- priority ! "completed" number(14) DEFAULT NULL, -- date of the completation if it is null it is not yet completed ! "deleted" number(14) DEFAULT NULL, -- date of the deleteation it it is null it is not deleted "status" char(1) DEFAULT NULL, -- null := waiting, -- o := open / in progress, -- c := completed -> (percentage = 100) "percentage" number(4) DEFAULT NULL, "accepted_creator" char(1) DEFAULT NULL, -- y - yes, n - no, null - waiting "accepted_user" char(1) DEFAULT NULL, -- y - yes, n - no, null - waiting ! PRIMARY KEY ("belongs_to", "task_version") ) ; --- 4462,4488 ---- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jan 25, 2005 by sir-b & moresun -- DROP TABLE "tiki_user_tasks_history"; CREATE TABLE "tiki_user_tasks_history" ( ! "belongs_to" integer(14) NOT NULL, -- the fist task in a history it has the same id as the task id ! "task_version" integer(4) DEFAULT 0 NOT NULL, -- version number for the history it starts with 0 "title" varchar(250) NOT NULL, -- title "description" clob DEFAULT NULL, -- description ! "start" integer(14) DEFAULT NULL, -- date of the starting, if it is not set than there is not starting date ! "end" integer(14) DEFAULT NULL, -- date of the end, if it is not set than there is not dealine "lasteditor" varchar(200) NOT NULL, -- lasteditor: username of last editior ! "lastchanges" integer(14) NOT NULL, -- date of last changes ! "priority" integer(2) DEFAULT 3 NOT NULL, -- priority ! "completed" integer(14) DEFAULT NULL, -- date of the completation if it is null it is not yet completed ! "deleted" integer(14) DEFAULT NULL, -- date of the deleteation it it is null it is not deleted "status" char(1) DEFAULT NULL, -- null := waiting, -- o := open / in progress, -- c := completed -> (percentage = 100) "percentage" number(4) DEFAULT NULL, "accepted_creator" char(1) DEFAULT NULL, -- y - yes, n - no, null - waiting "accepted_user" char(1) DEFAULT NULL, -- y - yes, n - no, null - waiting ! PRIMARY KEY (belongs_to, task_version) ) ; *************** *** 4894,4926 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jan 25, 2005 by sir-b & moresun -- - DROP TABLE "tiki_user_tasks"; - DROP SEQUENCE "tiki_user_tasks_sequ"; - CREATE SEQUENCE "tiki_user_tasks_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_user_tasks" ( ! "taskId" number(14) NOT NULL, -- task id ! "last_version" number(4) DEFAULT 0 NOT NULL, -- last version of the task starting with 0 "user" varchar(40) DEFAULT '' NOT NULL, -- task user "creator" varchar(200) NOT NULL, -- username of creator "public_for_group" varchar(30) DEFAULT NULL, -- this group can also view the task, if it is null it is not public "rights_by_creator" char(1) DEFAULT NULL, -- null the user can delete the task, ! "created" number(14) NOT NULL, -- date of the creation "status" char(1) default NULL, "priority" number(2) default NULL, "completed" number(14) default NULL, "percentage" number(4) default NULL, ! PRIMARY KEY ("taskId"), ! UNIQUE("creator", "created") ) ; - CREATE TRIGGER "tiki_user_tasks_trig" BEFORE INSERT ON "tiki_user_tasks" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW - BEGIN - SELECT "tiki_user_tasks_sequ".nextval into :NEW."taskId" FROM DUAL; - END; - / - -- -------------------------------------------------------- -- --- 4492,4515 ---- -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jan 25, 2005 by sir-b & moresun -- DROP TABLE "tiki_user_tasks"; CREATE TABLE "tiki_user_tasks" ( ! "taskId" integer(14) NOT NULL auto_increment, -- task id ! "last_version" integer(4) DEFAULT 0 NOT NULL, -- last version of the task starting with 0 "user" varchar(40) DEFAULT '' NOT NULL, -- task user "creator" varchar(200) NOT NULL, -- username of creator "public_for_group" varchar(30) DEFAULT NULL, -- this group can also view the task, if it is null it is not public "rights_by_creator" char(1) DEFAULT NULL, -- null the user can delete the task, ! "created" integer(14) NOT NULL, -- date of the creation "status" char(1) default NULL, "priority" number(2) default NULL, "completed" number(14) default NULL, "percentage" number(4) default NULL, ! PRIMARY KEY (taskId), ! UNIQUE(creator, created) ) ; -- -------------------------------------------------------- -- *************** *** 4929,4935 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 11:55 PM -- - DROP TABLE "tiki_user_votings"; CREATE TABLE "tiki_user_votings" ( --- 4518,4523 ---- *************** *** 4946,4952 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 08:07 AM -- - DROP TABLE "tiki_user_watches"; CREATE TABLE "tiki_user_watches" ( --- 4534,4539 ---- *************** *** 4968,4977 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_userfiles"; - DROP SEQUENCE "tiki_userfiles_sequ"; CREATE SEQUENCE "tiki_userfiles_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_userfiles" ( "user" varchar(40) default '' NOT NULL, --- 4555,4562 ---- *************** *** 4993,4999 **** SELECT "tiki_userfiles_sequ".nextval into :NEW."fileId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_userpoints --- 4578,4583 ---- *************** *** 5001,5007 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 05:47 AM -- - DROP TABLE "tiki_userpoints"; CREATE TABLE "tiki_userpoints" ( --- 4585,4590 ---- *************** *** 5017,5023 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_users"; CREATE TABLE "tiki_users" ( --- 4600,4605 ---- *************** *** 5035,5044 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_webmail_contacts"; - DROP SEQUENCE "tiki_webmail_contacts_sequ"; CREATE SEQUENCE "tiki_webmail_contacts_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_webmail_contacts" ( "contactId" number(12) NOT NULL, --- 4617,4624 ---- *************** *** 5055,5061 **** SELECT "tiki_webmail_contacts_sequ".nextval into :NEW."contactId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_webmail_messages --- 4635,4640 ---- *************** *** 5063,5069 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_webmail_messages"; CREATE TABLE "tiki_webmail_messages" ( --- 4642,4647 ---- *************** *** 5083,5092 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_wiki_attachments"; - DROP SEQUENCE "tiki_wiki_attachments_sequ"; CREATE SEQUENCE "tiki_wiki_attachments_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_wiki_attachments" ( "attId" number(12) NOT NULL, --- 4661,4668 ---- *************** *** 5108,5114 **** SELECT "tiki_wiki_attachments_sequ".nextval into :NEW."attId" FROM DUAL; END; / - -- -------------------------------------------------------- -- -- Table structure for table tiki_zones --- 4684,4689 ---- *************** *** 5116,5122 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 07:42 PM -- - DROP TABLE "tiki_zones"; CREATE TABLE "tiki_zones" ( --- 4691,4696 ---- *************** *** 5131,5140 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Apr 15 2004 at 07:42 PM -- - DROP TABLE "tiki_download"; - DROP SEQUENCE "tiki_download_sequ"; CREATE SEQUENCE "tiki_download_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_download" ( "id" number(11) NOT NULL, --- 4705,4712 ---- *************** *** 5151,5162 **** SELECT "tiki_download_sequ".nextval into :NEW."id" FROM DUAL; END; / - CREATE INDEX "tiki_download_object" ON "tiki_download"("object","userId","type"); CREATE INDEX "tiki_download_userId" ON "tiki_download"("userId"); CREATE INDEX "tiki_download_type" ON "tiki_download"("type"); CREATE INDEX "tiki_download_date" ON "tiki_download"("date"); - -- -------------------------------------------------------- -- -- Table structure for table users_grouppermissions --- 4723,4732 ---- *************** *** 5164,5170 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 07:22 AM -- - DROP TABLE "users_grouppermissions"; CREATE TABLE "users_grouppermissions" ( --- 4734,4739 ---- *************** *** 5175,5181 **** ) ; -- -------------------------------------------------------- - INSERT INTO "users_grouppermissions" ("groupName","permName") VALUES ('Anonymous','tiki_p_view'); INSERT INTO "users_grouppermissions" ("groupName","permName") VALUES ('Anonymous','tiki_p_wiki_view_history'); --- 4744,4749 ---- *************** *** 5189,5195 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 03, 2003 at 08:57 PM -- - DROP TABLE "users_groups"; CREATE TABLE "users_groups" ( --- 4757,4762 ---- *************** *** 5210,5216 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 07:20 AM -- - DROP TABLE "users_objectpermissions"; CREATE TABLE "users_objectpermissions" ( --- 4777,4782 ---- *************** *** 5228,5234 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 11, 2003 at 07:22 AM -- - DROP TABLE "users_permissions"; CREATE TABLE "users_permissions" ( --- 4794,4799 ---- *************** *** 5241,5247 **** -- -------------------------------------------------------- -- - INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_abort_instance', 'Can abort a process instance', 'editors', 'workflow'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_access_closed_site', 'Can access site when closed', 'admin', 'tiki'); --- 4806,4811 ---- *************** *** 5584,5590 **** INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_admin_ratings', 'Can add and change ratings on wiki pages', 'admin', 'wiki'); ! INSERT INTO "users_permissions" ("permName", "permDesc", "level", "type") VALUES('tiki_p_admin_users', 'Can admin users', 'admin', 'user'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_tasks_send', 'Can send tasks to other users', 'registered', 'user'); --- 5148,5154 ---- INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_admin_ratings', 'Can add and change ratings on wiki pages', 'admin', 'wiki'); ! INSERT INTO users_permissions (permName, permDesc, level, type) VALUES('tiki_p_admin_users', 'Can admin users', 'admin', 'user'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_tasks_send', 'Can send tasks to other users', 'registered', 'user'); *************** *** 5592,5598 **** INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_tasks_admin', 'Can admin public tasks', 'admin', 'user'); ! INSERT INTO "users_permissions" ("permName","permDesc","level","type") values ('tiki_p_admin_rssmodules','Can admin rss modules', 'admin', 'tiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_admin_polls','Can admin polls', 'admin', 'tiki'); --- 5156,5162 ---- INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_tasks_admin', 'Can admin public tasks', 'admin', 'user'); ! INSERT INTO users_permissions (permName,permDesc,level,type) values ('tiki_p_admin_rssmodules','Can admin rss modules', 'admin', 'tiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_admin_polls','Can admin polls', 'admin', 'tiki'); *************** *** 5605,5611 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 12, 2003 at 09:31 PM -- - DROP TABLE "users_usergroups"; CREATE TABLE "users_usergroups" ( --- 5169,5174 ---- *************** *** 5615,5621 **** ) ; -- -------------------------------------------------------- - INSERT INTO "users_groups" ("groupName","groupDesc") VALUES ('Anonymous','Public users not logged'); INSERT INTO "users_groups" ("groupName","groupDesc") VALUES ('Registered','Users logged into the system'); --- 5178,5183 ---- *************** *** 5627,5636 **** -- Creation: Jul 03, 2003 at 07:42 PM -- Last update: Jul 13, 2003 at 01:07 AM -- - DROP TABLE "users_users"; - DROP SEQUENCE "users_users_sequ"; CREATE SEQUENCE "users_users_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "users_users" ( "userId" number(8) NOT NULL, --- 5189,5196 ---- *************** *** 5661,5681 **** SELECT "users_users_sequ".nextval into :NEW."userId" FROM DUAL; END; / - CREATE INDEX "users_users_score" ON "users_users"("score"); - -- -------------------------------------------------------- ------ Administrator account - INSERT INTO "users_users" ("email","login","password","hash") VALUES ('','admin','admin','f6fdffe48c908deb0f4c3bd36c032e72'); ! UPDATE "users_users" SET "currentLogin"="lastLogin", "registrationDate"="lastLogin"; INSERT INTO "tiki_user_preferences" ("user","prefName","value") VALUES ('admin','realName','System Administrator'); -- -------------------------------------------------------- -- - INSERT INTO "tiki_preferences" ("name","value") VALUES ('allowRegister','n'); INSERT INTO "tiki_preferences" ("name","value") VALUES ('anonCanEdit','n'); --- 5221,5237 ---- SELECT "users_users_sequ".nextval into :NEW."userId" FROM DUAL; END; / CREATE INDEX "users_users_score" ON "users_users"("score"); -- -------------------------------------------------------- ------ Administrator account INSERT INTO "users_users" ("email","login","password","hash") VALUES ('','admin','admin','f6fdffe48c908deb0f4c3bd36c032e72'); ! UPDATE "users_users" SET "currentLogin"="lastLogin" "registrationDate"="lastLogin"; INSERT INTO "tiki_user_preferences" ("user","prefName","value") VALUES ('admin','realName','System Administrator'); -- -------------------------------------------------------- -- INSERT INTO "tiki_preferences" ("name","value") VALUES ('allowRegister','n'); INSERT INTO "tiki_preferences" ("name","value") VALUES ('anonCanEdit','n'); *************** *** 6475,6484 **** -- -- Table structure for table 'tiki_integrator_reps' -- - DROP TABLE "tiki_integrator_reps"; - DROP SEQUENCE "tiki_integrator_reps_sequ"; CREATE SEQUENCE "tiki_integrator_reps_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_integrator_reps" ( "repID" number(11) NOT NULL, --- 6031,6038 ---- *************** *** 6502,6518 **** -- -- Dumping data for table 'tiki_integrator_reps' -- - INSERT INTO tiki_integrator_reps VALUES ('1','Doxygened (1.3.4) Documentation','','index.html','doxygen.css','n','y','0','Use this repository as rule source for all your repositories based on doxygened docs. To setup yours just add new repository and copy rules from this repository :)'); -- -- Table structure for table 'tiki_integrator_rules' -- - DROP TABLE "tiki_integrator_rules"; - DROP SEQUENCE "tiki_integrator_rules_sequ"; CREATE SEQUENCE "tiki_integrator_rules_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_integrator_rules" ( "ruleID" number(11) NOT NULL, --- 6056,6069 ---- *************** *** 6533,6556 **** SELECT "tiki_integrator_rules_sequ".nextval into :NEW."ruleID" FROM DUAL; END; / - CREATE INDEX "tiki_integrator_rules_repID" ON "tiki_integrator_rules"("repID"); -- -- Dumping data for table 'tiki_integrator_rules' -- - INSERT INTO tiki_integrator_rules VALUES ('1','1','1','.*]*?>(.*?) tags'); ! INSERT INTO tiki_integrator_rules VALUES ('2','1','2','img src=(\"|'')(?!http://)','img src=\1{path}/','y','n','i','y','Fix images path'); ! INSERT INTO tiki_integrator_rules VALUES ('3','1','3','href=(\"|'')(?!(--|(http|ftp)://))','href=\1tiki-integrator.php?repID={repID}&file=','y','n','i','y','Relace internal links to integrator. Dont touch an external links.'); -- -- Integrator permissions -- - INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_admin_integrator', 'Can admin integrator repositories and rules', 'admin', 'tiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_view_integrator', 'Can view integrated repositories', 'basic', 'tiki'); --- 6084,6104 ---- SELECT "tiki_integrator_rules_sequ".nextval into :NEW."ruleID" FROM DUAL; END; / CREATE INDEX "tiki_integrator_rules_repID" ON "tiki_integrator_rules"("repID"); -- -- Dumping data for table 'tiki_integrator_rules' -- INSERT INTO tiki_integrator_rules VALUES ('1','1','1','.*]*?>(.*?) tags'); ! INSERT INTO tiki_integrator_rules VALUES ('2','1','2','img src=(\"|\')(?!http://)','img src=\1{path}/','y','n','i','y','Fix images path'); ! INSERT INTO tiki_integrator_rules VALUES ('3','1','3','href=(\"|\')(?!(--|(http|ftp)://))','href=\1tiki-integrator.php?repID={repID}&file=','y','n','i','y','Relace internal links to integrator. Dont touch an external links.'); -- -- Integrator permissions -- INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_admin_integrator', 'Can admin integrator repositories and rules', 'admin', 'tiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_view_integrator', 'Can view integrated repositories', 'basic', 'tiki'); *************** *** 6559,6568 **** -- -- Table structures for table 'tiki_quicktags' -- - DROP TABLE "tiki_quicktags"; - DROP SEQUENCE "tiki_quicktags_sequ"; CREATE SEQUENCE "tiki_quicktags_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_quicktags" ( "tagId" number(4) NOT NULL, --- 6107,6114 ---- *************** *** 6578,6590 **** SELECT "tiki_quicktags_sequ".nextval into :NEW."tagId" FROM DUAL; END; / - CREATE INDEX "tiki_quicktags_taglabel" ON "tiki_quicktags"("taglabel"); CREATE INDEX "tiki_quicktags_tagcategory" ON "tiki_quicktags"("tagcategory"); INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('bold','__text__','images/ed_format_bold.gif','wiki'); ! INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('italic','''''text''''','images/ed_format_italic.gif','wiki'); INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('underline','===text===','images/ed_format_underline.gif','wiki'); --- 6124,6135 ---- SELECT "tiki_quicktags_sequ".nextval into :NEW."tagId" FROM DUAL; END; / CREATE INDEX "tiki_quicktags_taglabel" ON "tiki_quicktags"("taglabel"); CREATE INDEX "tiki_quicktags_tagcategory" ON "tiki_quicktags"("tagcategory"); INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('bold','__text__','images/ed_format_bold.gif','wiki'); ! INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('italic','\'\'text\'\'','images/ed_format_italic.gif','wiki'); INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('underline','===text===','images/ed_format_underline.gif','wiki'); *************** *** 6644,6650 **** INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('bold', '__text__', 'images/ed_format_bold.gif', 'newsletters'); ! INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('italic', '''''text''''', 'images/ed_format_italic.gif', 'newsletters'); INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('underline', '===text===', 'images/ed_format_underline.gif', 'newsletters'); --- 6189,6195 ---- INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('bold', '__text__', 'images/ed_format_bold.gif', 'newsletters'); ! INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('italic', '\'\'text\'\'', 'images/ed_format_italic.gif', 'newsletters'); INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('underline', '===text===', 'images/ed_format_underline.gif', 'newsletters'); *************** *** 6684,6697 **** --translated objects table DROP TABLE "tiki_translated_objects"; - DROP SEQUENCE "tiki_translated_objects_sequ"; CREATE SEQUENCE "tiki_translated_objects_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_translated_objects" ( "traId" number(14) NOT NULL, ! "totype" varchar(50) NOT NULL, "objId" varchar(255) NOT NULL, "lang" varchar(16) default NULL, ! PRIMARY KEY ("totype", "objId") ) ; CREATE TRIGGER "tiki_translated_objects_trig" BEFORE INSERT ON "tiki_translated_objects" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW --- 6229,6241 ---- --translated objects table DROP TABLE "tiki_translated_objects"; CREATE SEQUENCE "tiki_translated_objects_sequ" INCREMENT BY 1 START WITH 1; CREATE TABLE "tiki_translated_objects" ( "traId" number(14) NOT NULL, ! "type" varchar(50) NOT NULL, "objId" varchar(255) NOT NULL, "lang" varchar(16) default NULL, ! PRIMARY KEY (type, objId) ) ; CREATE TRIGGER "tiki_translated_objects_trig" BEFORE INSERT ON "tiki_translated_objects" REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW *************** *** 6699,6711 **** SELECT "tiki_translated_objects_sequ".nextval into :NEW."traId" FROM DUAL; END; / - CREATE INDEX "tiki_translated_objects_tradid" ON "tiki_translated_objects"("traId"); -- -- Community tables begin -- - DROP TABLE "tiki_friends"; CREATE TABLE "tiki_friends" ( --- 6243,6253 ---- *************** *** 6756,6762 **** -- Creation: Nov 02, 2004 at 05:59 PM -- Last update: Nov 02, 2004 at 05:59 PM -- - DROP TABLE "tiki_file_handlers"; CREATE TABLE "tiki_file_handlers" ( --- 6298,6303 ---- *************** *** 6771,6785 **** -- Creation: Aug 04, 2005 at 05:59 PM -- Last update: Aug 04, 2005 at 05:59 PM -- ! DROP TABLE "tiki_stats"; ! ! CREATE TABLE "tiki_stats" ( ! "object" varchar(255) default '' NOT NULL, ! "type" varchar(20) default '' NOT NULL, ! "day" number(14) default '0' NOT NULL, ! "hits" number(14) default '0' NOT NULL, ! PRIMARY KEY ("object","type","day") ) ; --- 6312,6328 ---- -- Creation: Aug 04, 2005 at 05:59 PM -- Last update: Aug 04, 2005 at 05:59 PM -- + DROP TABLE `tiki_stats`; ! CREATE TABLE `tiki_stats` ( ! `object` varchar(255) default '' NOT NULL, ! `type` varchar(20) default '' NOT NULL, ! `day` number(14) default '0' NOT NULL, ! `hits` number(14) default '0' NOT NULL, ! PRIMARY KEY ("`object`","`type`","`day`") ) ; + -- -------------------------------------------------------- + ; +