Menu
▾
▴
[Tikiwiki-cvs] tiki/db tiki-1.9-mysql.sql, 1.38.2.87, 1.38.2.88 tiki-1.9-oci8.sql, 1.28.2.78, 1.28.2.79 tiki-1.9-pgsql.sql, 1.28.2.82, 1.28.2.83 tiki-1.9-sqlite.sql, 1.28.2.77, 1.28.2.78 tiki-1.9-sybase.sql, 1.28.2.80, 1.28.2.81
Update of /cvsroot/tikiwiki/tiki/db In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv11183 Modified Files: Tag: BRANCH-1-9 tiki-1.9-mysql.sql tiki-1.9-oci8.sql tiki-1.9-pgsql.sql tiki-1.9-sqlite.sql tiki-1.9-sybase.sql Log Message: sync Index: tiki-1.9-mysql.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/Attic/tiki-1.9-mysql.sql,v retrieving revision 1.38.2.87 retrieving revision 1.38.2.88 diff -u -d -r1.38.2.87 -r1.38.2.88 --- tiki-1.9-mysql.sql 14 Aug 2006 13:27:05 -0000 1.38.2.87 +++ tiki-1.9-mysql.sql 3 Sep 2006 18:28:47 -0000 1.38.2.88 @@ -105,7 +105,7 @@ instanceId int(14) NOT NULL auto_increment, pId int(14) NOT NULL default '0', started int(14) default NULL, - name varchar(200) default 'No Name', + name varchar(200) NOT NULL default 'No Name', owner varchar(200) default NULL, nextActivity int(14) default NULL, nextUser varchar(200) default NULL, @@ -368,8 +368,8 @@ KEY title (title), KEY heading (heading(255)), KEY body (body(255)), - KEY nbreads (nbreads), KEY author (author(32)), + KEY nbreads (nbreads), FULLTEXT KEY ft (title,heading,body) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # -------------------------------------------------------- @@ -519,10 +519,10 @@ data_size int(11) unsigned NOT NULL default '0', created int(14) default NULL, user varchar(40) default NULL, - priv varchar(1) default NULL, trackbacks_to text, trackbacks_from text, title varchar(80) default NULL, + priv varchar(1) default NULL, PRIMARY KEY (postId), KEY data (data(255)), KEY blogId (blogId), @@ -618,6 +618,7 @@ end int(14) NOT NULL default '0', locationId int(14) default NULL, categoryId int(14) default NULL, + nlId int(12) NOT NULL default '0', priority enum('1','2','3','4','5','6','7','8','9') NOT NULL default '1', status enum('0','1','2') NOT NULL default '0', url varchar(255) default NULL, @@ -625,7 +626,6 @@ name varchar(255) NOT NULL default '', description blob, user varchar(40) default NULL, - nlId int(12) default NULL, created int(14) NOT NULL default '0', lastmodif int(14) NOT NULL default '0', PRIMARY KEY (calitemId), @@ -1660,8 +1660,8 @@ galleryId int(14) NOT NULL default '0', name varchar(200) NOT NULL default '', description text, - lat float default NULL, lon float default NULL, + lat float default NULL, created int(14) default NULL, user varchar(40) default NULL, hits int(14) default NULL, @@ -1694,8 +1694,8 @@ filesize int(14) default NULL, filetype varchar(80) default NULL, filename varchar(80) default NULL, - etag varchar(32) default NULL, data longblob, + etag varchar(32) default NULL, PRIMARY KEY (imageId,xsize,ysize,type), KEY t_i_d_it (imageId,type) ) TYPE=MyISAM; @@ -2437,8 +2437,8 @@ page_size int(10) unsigned default '0', lang varchar(16) default NULL, lockedby varchar(200) default NULL, - created int(14), is_html tinyint(1) default 0, + created int(14), PRIMARY KEY (page_id), UNIQUE KEY pageName (pageName), KEY data (data(255)), @@ -3272,11 +3272,11 @@ trackerId int(12) NOT NULL default '0', name varchar(255) default NULL, options text, - position int(4) default NULL, type char(1) default NULL, isMain char(1) default NULL, isTblVisible char(1) default NULL, - isSearchable char(1) default NULL, + position int(4) default NULL, + isSearchable char(1) NOT NULL default 'y', isPublic char(1) NOT NULL default 'n', isHidden char(1) NOT NULL default 'n', isMandatory char(1) NOT NULL default 'n', @@ -3300,12 +3300,12 @@ filesize int(14) default NULL, user varchar(40) default NULL, data longblob, - longdesc blob, path varchar(255) default NULL, downloads int(10) default NULL, - version varchar(40) default NULL, created int(14) default NULL, comment varchar(250) default NULL, + longdesc blob, + version varchar(40) default NULL, PRIMARY KEY (attId) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # -------------------------------------------------------- @@ -3341,7 +3341,8 @@ itemId int(12) NOT NULL default '0', fieldId int(12) NOT NULL default '0', value text, - PRIMARY KEY (itemId,fieldId) + PRIMARY KEY (itemId,fieldId), + FULLTEXT KEY ft (value) ) TYPE=MyISAM; # -------------------------------------------------------- @@ -3398,11 +3399,11 @@ showStatus char(1) default NULL, showLastModif char(1) default NULL, useComments char(1) default NULL, - showComments char(1) default NULL, useAttachments char(1) default NULL, + items int(10) default NULL, + showComments char(1) default NULL, showAttachments char(1) default NULL, orderAttachments varchar(255) NOT NULL default 'filename,created,filesize,downloads,desc', - items int(10) default NULL, PRIMARY KEY (trackerId) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # -------------------------------------------------------- @@ -4278,6 +4279,7 @@ INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('blog_list_user','n'); INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('blog_list_visits','y'); INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('blog_spellcheck','n'); +INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_blogposts_pings','y'); INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('cacheimages','n'); INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('cachepages','n'); INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('calendar_sticky_popup','n'); @@ -4415,7 +4417,7 @@ INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_userVersions','n'); INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_user_bookmarks','n'); INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_user_watches','n'); -INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_user_watches_translations','n'); +INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_user_watches_translations','y'); INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_userfiles','n'); INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_usermenu','n'); INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_view_tpl','n'); @@ -4622,6 +4624,13 @@ INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('wiki_wikisyntax_in_html','full'); INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('default_wiki_diff_style', 'minsidediff'); INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('limitedGoGroupHome','y'); +INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_gal_slideshow','y'); +INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_galleries','y'); +INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_ranking','n'); +INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_trackbackpings','y'); +INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('rssfeed_creator',''); +INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('rssfeed_css','y'); +INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('rssfeed_publisher',''); # default sizes for mailbox, read box and mail archive @@ -4698,8 +4707,8 @@ tagicon varchar(255) default NULL, tagcategory varchar(255) default NULL, PRIMARY KEY (tagId), - KEY taglabel (taglabel), - KEY tagcategory (tagcategory) + KEY tagcategory (tagcategory), + KEY taglabel (taglabel) ) TYPE=MyISAM AUTO_INCREMENT=1 ; INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('bold','__text__','images/ed_format_bold.gif','wiki'); @@ -4720,7 +4729,7 @@ INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('colored text','~~#FF0000:text~~','images/fontfamily.gif','wiki'); INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('dynamic variable','%text%','images/book.gif','wiki'); INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('image','{img src= width= height= align= desc= link= }','images/ed_image.gif','wiki'); -INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('New wms Metadata','METADATA\r\n "wms_name" "myname"\r\n "wms_srs" "EPSG:4326"\r\n "wms_server_version" " "\r\n "wms_layers" "mylayers"\r\n "wms_request" "myrequest"\r\n "wms_format" " "\r\n "wms_time" " "\r\n END', 'img/icons/admin_metatags.png','maps'); +INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('New wms Metadata','METADATA\r\n \"wms_name\" \"myname\"\r\n "wms_srs" "EPSG:4326"\r\n "wms_server_version" " "\r\n "wms_layers" "mylayers"\r\n "wms_request" "myrequest"\r\n "wms_format" " "\r\n "wms_time" " "\r\n END', 'img/icons/admin_metatags.png','maps'); INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('New Class', 'CLASS\r\n EXPRESSION ()\r\n SYMBOL 0\r\n OUTLINECOLOR\r\n COLOR\r\n NAME "myclass" \r\nEND #end of class', 'img/icons/mini_triangle.gif','maps'); INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('New Projection','PROJECTION\r\n "init=epsg:4326"\r\nEND','images/ico_mode.gif','maps'); INSERT INTO tiki_quicktags (taglabel, taginsert, tagicon, tagcategory) VALUES ('New Query','#\r\n# Start of query definitions\r\n#\r\n QUERYMAP\r\n STATUS ON\r\n STYLE HILITE\r\nEND','img/icons/questions.gif','maps'); @@ -4760,7 +4769,7 @@ objId varchar(255) NOT NULL, lang varchar(16) default NULL, PRIMARY KEY (type, objId), - KEY tradid (traId) + KEY traId ( traId ) ) TYPE=MyISAM AUTO_INCREMENT=1; @@ -4791,6 +4800,38 @@ PRIMARY KEY (event) ) TYPE=MyISAM; + +INSERT INTO tiki_score (event, score, expiration) VALUES ('login',1,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('login_remain',2,60); +INSERT INTO tiki_score (event, score, expiration) VALUES ('profile_fill',10,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('profile_see',2,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('profile_is_seen',1,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('friend_new',10,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('message_receive',1,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('message_send',2,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('article_read',2,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('article_comment',5,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('article_new',20,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('article_is_read',1,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('article_is_commented',2,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('fgallery_new',10,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('fgallery_new_file',10,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('fgallery_download',5,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('fgallery_is_downloaded',5,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('igallery_new',10,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('igallery_new_img',6,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('igallery_see_img',3,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('igallery_img_seen',1,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('blog_new',20,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('blog_post',5,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('blog_read',2,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('blog_comment',2,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('blog_is_read',3,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('blog_is_commented',3,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('wiki_new',10,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('wiki_edit',5,0); +INSERT INTO tiki_score (event, score, expiration) VALUES ('wiki_attach_file',3,0); + DROP TABLE IF EXISTS tiki_users_score; CREATE TABLE tiki_users_score ( user char(40) NOT NULL default '', Index: tiki-1.9-oci8.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/Attic/tiki-1.9-oci8.sql,v retrieving revision 1.28.2.78 retrieving revision 1.28.2.79 diff -u -d -r1.28.2.78 -r1.28.2.79 --- tiki-1.9-oci8.sql 14 Aug 2006 13:27:05 -0000 1.28.2.78 +++ tiki-1.9-oci8.sql 3 Sep 2006 18:28:47 -0000 1.28.2.79 @@ -117,7 +117,7 @@ "instanceId" number(14) NOT NULL, "pId" number(14) default '0' NOT NULL, "started" number(14) default NULL, - "name" varchar(200) default 'No Name', + "name" varchar(200) default 'No Name' NOT NULL, "owner" varchar(200) default NULL, "nextActivity" number(14) default NULL, "nextUser" varchar(200) default NULL, @@ -437,8 +437,8 @@ 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_nbreads" ON "tiki_articles"("nbreads"); CREATE INDEX "tiki_articles_ft" ON "tiki_articles"("title","heading","body"); -- -------------------------------------------------------- DROP TABLE "tiki_article_types"; @@ -605,10 +605,10 @@ "data_size" number(11) default '0' NOT NULL, "created" number(14) default NULL, "user" varchar(40) default NULL, - "priv" varchar(1) default NULL, "trackbacks_to" clob, "trackbacks_from" clob, "title" varchar(80) default NULL, + "priv" varchar(1) default NULL, PRIMARY KEY ("postId") ) ; @@ -728,6 +728,7 @@ "end" number(14) default '0' NOT NULL, "locationId" number(14) default NULL, "categoryId" number(14) default NULL, + "nlId" number(12) default '0' NOT NULL, "priority" varchar(3) default '1' NOT NULL CHECK ("priority" IN ('1','2','3','4','5','6','7','8','9')), "status" varchar(3) default '0' NOT NULL CHECK ("status" IN ('0','1','2')), "url" varchar(255) default NULL, @@ -735,7 +736,6 @@ "name" varchar(255) default '' NOT NULL, "description" blob, "user" varchar(40) default NULL, - "nlId" number(12) default NULL, "created" number(14) default '0' NOT NULL, "lastmodif" number(14) default '0' NOT NULL, PRIMARY KEY ("calitemId") @@ -1940,8 +1940,8 @@ "galleryId" number(14) default '0' NOT NULL, "name" varchar(200) default '' NOT NULL, "description" clob, - "lat" float default NULL, "lon" float default NULL, + "lat" float default NULL, "created" number(14) default NULL, "user" varchar(40) default NULL, "hits" number(14) default NULL, @@ -1979,8 +1979,8 @@ "filesize" number(14) default NULL, "filetype" varchar(80) default NULL, "filename" varchar(80) default NULL, - "etag" varchar(32) default NULL, "data" blob, + "etag" varchar(32) default NULL, PRIMARY KEY ("imageId","xsize","ysize","type") ) ; @@ -2994,8 +2994,8 @@ "page_size" number(10) default '0', "lang" varchar(16) default NULL, "lockedby" varchar(200) default NULL, - "created" number(14), "is_html" number(1) default 0, + "created" number(14), PRIMARY KEY ("page_id") ) ; @@ -3980,11 +3980,11 @@ "trackerId" number(12) default '0' NOT NULL, "name" varchar(255) default NULL, "options" clob, - "position" number(4) default NULL, "type" char(1) default NULL, "isMain" char(1) default NULL, "isTblVisible" char(1) default NULL, - "isSearchable" char(1) default NULL, + "position" number(4) default NULL, + "isSearchable" char(1) default 'y' NOT NULL, "isPublic" char(1) default 'n' NOT NULL, "isHidden" char(1) default 'n' NOT NULL, "isMandatory" char(1) default 'n' NOT NULL, @@ -4014,12 +4014,12 @@ "filesize" number(14) default NULL, "user" varchar(40) default NULL, "data" blob, - "longdesc" blob, "path" varchar(255) default NULL, "downloads" number(10) default NULL, - "version" varchar(40) default NULL, "created" number(14) default NULL, "comment" varchar(250) default NULL, + "longdesc" blob, + "version" varchar(40) default NULL, PRIMARY KEY ("attId") ) ; @@ -4069,6 +4069,7 @@ PRIMARY KEY ("itemId","fieldId") ) ; +CREATE INDEX "tiki_tracker_item_fields_ft" ON "tiki_tracker_item_fields"("value"); -- -------------------------------------------------------- -- -- Table structure for table tiki_tracker_items @@ -4129,11 +4130,11 @@ "showStatus" char(1) default NULL, "showLastModif" char(1) default NULL, "useComments" char(1) default NULL, - "showComments" char(1) default NULL, "useAttachments" char(1) default NULL, + "items" number(10) default NULL, + "showComments" char(1) default NULL, "showAttachments" char(1) default NULL, "orderAttachments" varchar(255) default 'filename,created,filesize,downloads,desc' NOT NULL, - "items" number(10) default NULL, PRIMARY KEY ("trackerId") ) ; @@ -5326,6 +5327,8 @@ INSERT INTO "tiki_preferences" ("name","value") VALUES ('blog_spellcheck','n'); +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_blogposts_pings','y'); + INSERT INTO "tiki_preferences" ("name","value") VALUES ('cacheimages','n'); INSERT INTO "tiki_preferences" ("name","value") VALUES ('cachepages','n'); @@ -5600,7 +5603,7 @@ INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_user_watches','n'); -INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_user_watches_translations','n'); +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_user_watches_translations','y'); INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_userfiles','n'); @@ -6014,6 +6017,20 @@ INSERT INTO "tiki_preferences" ("name","value") VALUES ('limitedGoGroupHome','y'); +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_gal_slideshow','y'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_galleries','y'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_ranking','n'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_trackbackpings','y'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('rssfeed_creator',''); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('rssfeed_css','y'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('rssfeed_publisher',''); + -- default sizes for mailbox, read box and mail archive -- in messages per user and box (0=unlimited) @@ -6124,8 +6141,8 @@ 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"); +CREATE INDEX "tiki_quicktags_taglabel" ON "tiki_quicktags"("taglabel"); INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('bold','__text__','images/ed_format_bold.gif','wiki'); @@ -6163,7 +6180,7 @@ INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('image','{img src= width= height= align= desc= link= }','images/ed_image.gif','wiki'); -INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('New wms Metadata','METADATA\r\n "wms_name" "myname"\r\n "wms_srs" "EPSG:4326"\r\n "wms_server_version" " "\r\n "wms_layers" "mylayers"\r\n "wms_request" "myrequest"\r\n "wms_format" " "\r\n "wms_time" " "\r\n END', 'img/icons/admin_metatags.png','maps'); +INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('New wms Metadata','METADATA\r\n \"wms_name\" \"myname\"\r\n "wms_srs" "EPSG:4326"\r\n "wms_server_version" " "\r\n "wms_layers" "mylayers"\r\n "wms_request" "myrequest"\r\n "wms_format" " "\r\n "wms_time" " "\r\n END', 'img/icons/admin_metatags.png','maps'); INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('New Class', 'CLASS\r\n EXPRESSION ()\r\n SYMBOL 0\r\n OUTLINECOLOR\r\n COLOR\r\n NAME "myclass" \r\nEND --end of class', 'img/icons/mini_triangle.gif','maps'); @@ -6243,7 +6260,7 @@ SELECT "tiki_translated_objects_sequ".nextval into :NEW."traId" FROM DUAL; END; / -CREATE INDEX "tiki_translated_objects_tradid" ON "tiki_translated_objects"("traId"); +CREATE INDEX "tiki_translated_objects_traId" ON "tiki_translated_objects"( "traId" ); -- -- Community tables begin @@ -6277,6 +6294,67 @@ ) ; +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('login',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('login_remain',2,60); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('profile_fill',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('profile_see',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('profile_is_seen',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('friend_new',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('message_receive',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('message_send',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_read',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_comment',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_new',20,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_is_read',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_is_commented',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_new',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_new_file',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_download',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_is_downloaded',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_new',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_new_img',6,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_see_img',3,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_img_seen',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_new',20,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_post',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_read',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_comment',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_is_read',3,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_is_commented',3,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('wiki_new',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('wiki_edit',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('wiki_attach_file',3,0); + + DROP TABLE "tiki_users_score"; CREATE TABLE "tiki_users_score" ( Index: tiki-1.9-pgsql.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/Attic/tiki-1.9-pgsql.sql,v retrieving revision 1.28.2.82 retrieving revision 1.28.2.83 diff -u -d -r1.28.2.82 -r1.28.2.83 --- tiki-1.9-pgsql.sql 14 Aug 2006 13:27:06 -0000 1.28.2.82 +++ tiki-1.9-pgsql.sql 3 Sep 2006 18:28:47 -0000 1.28.2.83 @@ -114,7 +114,7 @@ "instanceId" bigserial, "pId" bigint NOT NULL default '0', "started" bigint default NULL, - "name" varchar(200) default 'No Name', + "name" varchar(200) NOT NULL default 'No Name', "owner" varchar(200) default NULL, "nextActivity" bigint default NULL, "nextUser" varchar(200) default NULL, @@ -401,8 +401,8 @@ CREATE INDEX "tiki_articles_title" ON "tiki_articles"("title"); CREATE INDEX "tiki_articles_heading" ON "tiki_articles"(substr("heading", 0, 255)); CREATE INDEX "tiki_articles_body" ON "tiki_articles"(substr("body", 0, 255)); -CREATE INDEX "tiki_articles_nbreads" ON "tiki_articles"("nbreads"); CREATE INDEX "tiki_articles_author" ON "tiki_articles"(substr("author", 0, 32)); +CREATE INDEX "tiki_articles_nbreads" ON "tiki_articles"("nbreads"); -- -------------------------------------------------------- DROP TABLE "tiki_article_types"; @@ -565,10 +565,10 @@ "data_size" bigint NOT NULL default '0', "created" bigint default NULL, "user" varchar(40) default NULL, - "priv" varchar(1) default NULL, "trackbacks_to" text, "trackbacks_from" text, "title" varchar(80) default NULL, + "priv" varchar(1) default NULL, PRIMARY KEY ("postId") ) ; @@ -670,6 +670,7 @@ "end" bigint NOT NULL default '0', "locationId" bigint default NULL, "categoryId" bigint default NULL, + "nlId" bigint NOT NULL default '0', "priority" varchar(3) CHECK ("priority" IN ('1','2','3','4','5','6','7','8','9')) NOT NULL default '1', "status" varchar(3) CHECK ("status" IN ('0','1','2')) NOT NULL default '0', "url" varchar(255) default NULL, @@ -677,7 +678,6 @@ "name" varchar(255) NOT NULL default '', "description" bytea, "user" varchar(40) default NULL, - "nlId" bigint default NULL, "created" bigint NOT NULL default '0', "lastmodif" bigint NOT NULL default '0', PRIMARY KEY ("calitemId") @@ -1802,8 +1802,8 @@ "galleryId" bigint NOT NULL default '0', "name" varchar(200) NOT NULL default '', "description" text, - "lat" float default NULL, "lon" float default NULL, + "lat" float default NULL, "created" bigint default NULL, "user" varchar(40) default NULL, "hits" bigint default NULL, @@ -1837,8 +1837,8 @@ "filesize" bigint default NULL, "filetype" varchar(80) default NULL, "filename" varchar(80) default NULL, - "etag" varchar(32) default NULL, "data" bytea, + "etag" varchar(32) default NULL, PRIMARY KEY ("imageId","xsize","ysize","type") ) ; @@ -2820,8 +2820,8 @@ "page_size" bigint default '0', "lang" varchar(16) default NULL, "lockedby" varchar(200) default NULL, - "created" bigint, "is_html" smallint default 0, + "created" bigint, PRIMARY KEY ("page_id") ) ; @@ -3744,11 +3744,11 @@ "trackerId" bigint NOT NULL default '0', "name" varchar(255) default NULL, "options" text, - "position" smallint default NULL, "type" char(1) default NULL, "isMain" char(1) default NULL, "isTblVisible" char(1) default NULL, - "isSearchable" char(1) default NULL, + "position" smallint default NULL, + "isSearchable" char(1) NOT NULL default 'y', "isPublic" char(1) NOT NULL default 'n', "isHidden" char(1) NOT NULL default 'n', "isMandatory" char(1) NOT NULL default 'n', @@ -3774,12 +3774,12 @@ "filesize" bigint default NULL, "user" varchar(40) default NULL, "data" bytea, - "longdesc" bytea, "path" varchar(255) default NULL, "downloads" bigint default NULL, - "version" varchar(40) default NULL, "created" bigint default NULL, "comment" varchar(250) default NULL, + "longdesc" bytea, + "version" varchar(40) default NULL, PRIMARY KEY ("attId") ) ; @@ -3882,11 +3882,11 @@ "showStatus" char(1) default NULL, "showLastModif" char(1) default NULL, "useComments" char(1) default NULL, - "showComments" char(1) default NULL, "useAttachments" char(1) default NULL, + "items" bigint default NULL, + "showComments" char(1) default NULL, "showAttachments" char(1) default NULL, "orderAttachments" varchar(255) NOT NULL default 'filename,created,filesize,downloads,desc', - "items" bigint default NULL, PRIMARY KEY ("trackerId") ) ; @@ -5061,6 +5061,8 @@ INSERT INTO "tiki_preferences" ("name","value") VALUES ('blog_spellcheck','n'); +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_blogposts_pings','y'); + INSERT INTO "tiki_preferences" ("name","value") VALUES ('cacheimages','n'); INSERT INTO "tiki_preferences" ("name","value") VALUES ('cachepages','n'); @@ -5335,7 +5337,7 @@ INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_user_watches','n'); -INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_user_watches_translations','n'); +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_user_watches_translations','y'); INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_userfiles','n'); @@ -5749,6 +5751,20 @@ INSERT INTO "tiki_preferences" ("name","value") VALUES ('limitedGoGroupHome','y'); +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_gal_slideshow','y'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_galleries','y'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_ranking','n'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_trackbackpings','y'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('rssfeed_creator',''); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('rssfeed_css','y'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('rssfeed_publisher',''); + -- default sizes for mailbox, read box and mail archive @@ -5842,8 +5858,8 @@ PRIMARY KEY ("tagId") ) ; -CREATE INDEX "tiki_quicktags_taglabel" ON "tiki_quicktags"("taglabel"); CREATE INDEX "tiki_quicktags_tagcategory" ON "tiki_quicktags"("tagcategory"); +CREATE INDEX "tiki_quicktags_taglabel" ON "tiki_quicktags"("taglabel"); INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('bold','__text__','images/ed_format_bold.gif','wiki'); @@ -5881,7 +5897,7 @@ INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('image','{img src= width= height= align= desc= link= }','images/ed_image.gif','wiki'); -INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('New wms Metadata','METADATA\r\n "wms_name" "myname"\r\n "wms_srs" "EPSG:4326"\r\n "wms_server_version" " "\r\n "wms_layers" "mylayers"\r\n "wms_request" "myrequest"\r\n "wms_format" " "\r\n "wms_time" " "\r\n END', 'img/icons/admin_metatags.png','maps'); +INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('New wms Metadata','METADATA\r\n \"wms_name\" \"myname\"\r\n "wms_srs" "EPSG:4326"\r\n "wms_server_version" " "\r\n "wms_layers" "mylayers"\r\n "wms_request" "myrequest"\r\n "wms_format" " "\r\n "wms_time" " "\r\n END', 'img/icons/admin_metatags.png','maps'); INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('New Class', 'CLASS\r\n EXPRESSION ()\r\n SYMBOL 0\r\n OUTLINECOLOR\r\n COLOR\r\n NAME "myclass" \r\nEND --end of class', 'img/icons/mini_triangle.gif','maps'); @@ -5955,7 +5971,7 @@ PRIMARY KEY ("type","objId") ) ; -CREATE INDEX "tiki_translated_objects_tradid" ON "tiki_translated_objects"("traId"); +CREATE INDEX "tiki_translated_objects_traId" ON "tiki_translated_objects"("traId"); -- @@ -5991,6 +6007,68 @@ ) ; + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('login',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('login_remain',2,60); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('profile_fill',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('profile_see',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('profile_is_seen',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('friend_new',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('message_receive',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('message_send',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_read',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_comment',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_new',20,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_is_read',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_is_commented',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_new',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_new_file',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_download',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_is_downloaded',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_new',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_new_img',6,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_see_img',3,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_img_seen',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_new',20,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_post',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_read',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_comment',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_is_read',3,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_is_commented',3,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('wiki_new',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('wiki_edit',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('wiki_attach_file',3,0); + + DROP TABLE "tiki_users_score"; CREATE TABLE "tiki_users_score" ( Index: tiki-1.9-sqlite.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/Attic/tiki-1.9-sqlite.sql,v retrieving revision 1.28.2.77 retrieving revision 1.28.2.78 diff -u -d -r1.28.2.77 -r1.28.2.78 --- tiki-1.9-sqlite.sql 14 Aug 2006 13:27:06 -0000 1.28.2.77 +++ tiki-1.9-sqlite.sql 3 Sep 2006 18:28:47 -0000 1.28.2.78 @@ -114,7 +114,7 @@ "instanceId" bigserial, "pId" bigint NOT NULL default '0', "started" bigint default NULL, - "name" varchar(200) default 'No Name', + "name" varchar(200) NOT NULL default 'No Name', "owner" varchar(200) default NULL, "nextActivity" bigint default NULL, "nextUser" varchar(200) default NULL, @@ -401,8 +401,8 @@ 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_nbreads" ON "tiki_articles"("nbreads"); CREATE INDEX "tiki_articles_ft" ON "tiki_articles"("title","heading","body"); -- -------------------------------------------------------- @@ -566,10 +566,10 @@ "data_size" bigint unsigned NOT NULL default '0', "created" bigint default NULL, "user" varchar(40) default NULL, - "priv" varchar(1) default NULL, "trackbacks_to" text, "trackbacks_from" text, "title" varchar(80) default NULL, + "priv" varchar(1) default NULL, PRIMARY KEY ("postId") ) ; @@ -673,6 +673,7 @@ "end" bigint NOT NULL default '0', "locationId" bigint default NULL, "categoryId" bigint default NULL, + "nlId" bigint NOT NULL default '0', "priority" varchar(3) CHECK ("priority" IN ('1','2','3','4','5','6','7','8','9')) NOT NULL default '1', "status" varchar(3) CHECK ("status" IN ('0','1','2')) NOT NULL default '0', "url" varchar(255) default NULL, @@ -680,7 +681,6 @@ "name" varchar(255) NOT NULL default '', "description" bytea, "user" varchar(40) default NULL, - "nlId" bigint default NULL, "created" bigint NOT NULL default '0', "lastmodif" bigint NOT NULL default '0', PRIMARY KEY ("calitemId") @@ -1811,8 +1811,8 @@ "galleryId" bigint NOT NULL default '0', "name" varchar(200) NOT NULL default '', "description" text, - "lat" float default NULL, "lon" float default NULL, + "lat" float default NULL, "created" bigint default NULL, "user" varchar(40) default NULL, "hits" bigint default NULL, @@ -1847,8 +1847,8 @@ "filesize" bigint default NULL, "filetype" varchar(80) default NULL, "filename" varchar(80) default NULL, - "etag" varchar(32) default NULL, "data" bytea, + "etag" varchar(32) default NULL, PRIMARY KEY ("imageId","xsize","ysize","type") ) ; @@ -2829,8 +2829,8 @@ "page_size" bigint unsigned default '0', "lang" varchar(16) default NULL, "lockedby" varchar(200) default NULL, - "created" bigint, "is_html" smallint default 0, + "created" bigint, PRIMARY KEY ("page_id") ) ; @@ -3754,11 +3754,11 @@ "trackerId" bigint NOT NULL default '0', "name" varchar(255) default NULL, "options" text, - "position" smallint default NULL, "type" char(1) default NULL, "isMain" char(1) default NULL, "isTblVisible" char(1) default NULL, - "isSearchable" char(1) default NULL, + "position" smallint default NULL, + "isSearchable" char(1) NOT NULL default 'y', "isPublic" char(1) NOT NULL default 'n', "isHidden" char(1) NOT NULL default 'n', "isMandatory" char(1) NOT NULL default 'n', @@ -3784,12 +3784,12 @@ "filesize" bigint default NULL, "user" varchar(40) default NULL, "data" bytea, - "longdesc" bytea, "path" varchar(255) default NULL, "downloads" bigint default NULL, - "version" varchar(40) default NULL, "created" bigint default NULL, "comment" varchar(250) default NULL, + "longdesc" bytea, + "version" varchar(40) default NULL, PRIMARY KEY ("attId") ) ; @@ -3832,6 +3832,7 @@ PRIMARY KEY ("itemId","fieldId") ) ; +CREATE INDEX "tiki_tracker_item_fields_ft" ON "tiki_tracker_item_fields"("value"); -- -------------------------------------------------------- -- @@ -3892,11 +3893,11 @@ "showStatus" char(1) default NULL, "showLastModif" char(1) default NULL, "useComments" char(1) default NULL, - "showComments" char(1) default NULL, "useAttachments" char(1) default NULL, + "items" bigint default NULL, + "showComments" char(1) default NULL, "showAttachments" char(1) default NULL, "orderAttachments" varchar(255) NOT NULL default 'filename,created,filesize,downloads,desc', - "items" bigint default NULL, PRIMARY KEY ("trackerId") ) ; @@ -5071,6 +5072,8 @@ INSERT INTO "tiki_preferences" ("name","value") VALUES ('blog_spellcheck','n'); +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_blogposts_pings','y'); + INSERT INTO "tiki_preferences" ("name","value") VALUES ('cacheimages','n'); INSERT INTO "tiki_preferences" ("name","value") VALUES ('cachepages','n'); @@ -5345,7 +5348,7 @@ INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_user_watches','n'); -INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_user_watches_translations','n'); +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_user_watches_translations','y'); INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_userfiles','n'); @@ -5759,6 +5762,20 @@ INSERT INTO "tiki_preferences" ("name","value") VALUES ('limitedGoGroupHome','y'); +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_gal_slideshow','y'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_galleries','y'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_ranking','n'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_trackbackpings','y'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('rssfeed_creator',''); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('rssfeed_css','y'); + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('rssfeed_publisher',''); + -- default sizes for mailbox, read box and mail archive @@ -5852,8 +5869,8 @@ PRIMARY KEY ("tagId") ) ; -CREATE INDEX "tiki_quicktags_taglabel" ON "tiki_quicktags"("taglabel"); CREATE INDEX "tiki_quicktags_tagcategory" ON "tiki_quicktags"("tagcategory"); +CREATE INDEX "tiki_quicktags_taglabel" ON "tiki_quicktags"("taglabel"); INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('bold','__text__','images/ed_format_bold.gif','wiki'); @@ -5891,7 +5908,7 @@ INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('image','{img src= width= height= align= desc= link= }','images/ed_image.gif','wiki'); -INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('New wms Metadata','METADATA\r\n "wms_name" "myname"\r\n "wms_srs" "EPSG:4326"\r\n "wms_server_version" " "\r\n "wms_layers" "mylayers"\r\n "wms_request" "myrequest"\r\n "wms_format" " "\r\n "wms_time" " "\r\n END', 'img/icons/admin_metatags.png','maps'); +INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('New wms Metadata','METADATA\r\n \"wms_name\" \"myname\"\r\n "wms_srs" "EPSG:4326"\r\n "wms_server_version" " "\r\n "wms_layers" "mylayers"\r\n "wms_request" "myrequest"\r\n "wms_format" " "\r\n "wms_time" " "\r\n END', 'img/icons/admin_metatags.png','maps'); INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('New Class', 'CLASS\r\n EXPRESSION ()\r\n SYMBOL 0\r\n OUTLINECOLOR\r\n COLOR\r\n NAME "myclass" \r\nEND --end of class', 'img/icons/mini_triangle.gif','maps'); @@ -5965,7 +5982,7 @@ PRIMARY KEY (type, objId) ) ; -CREATE INDEX "tiki_translated_objects_tradid" ON "tiki_translated_objects"("traId"); +CREATE INDEX "tiki_translated_objects_traId" ON "tiki_translated_objects"( "traId" ); -- @@ -6001,6 +6018,68 @@ ) ; + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('login',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('login_remain',2,60); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('profile_fill',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('profile_see',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('profile_is_seen',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('friend_new',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('message_receive',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('message_send',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_read',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_comment',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_new',20,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_is_read',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_is_commented',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_new',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_new_file',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_download',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_is_downloaded',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_new',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_new_img',6,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_see_img',3,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_img_seen',1,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_new',20,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_post',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_read',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_comment',2,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_is_read',3,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_is_commented',3,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('wiki_new',10,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('wiki_edit',5,0); + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('wiki_attach_file',3,0); + + DROP TABLE "tiki_users_score"; CREATE TABLE "tiki_users_score" ( Index: tiki-1.9-sybase.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/Attic/tiki-1.9-sybase.sql,v retrieving revision 1.28.2.80 retrieving revision 1.28.2.81 diff -u -d -r1.28.2.80 -r1.28.2.81 --- tiki-1.9-sybase.sql 14 Aug 2006 13:27:06 -0000 1.28.2.80 +++ tiki-1.9-sybase.sql 3 Sep 2006 18:28:47 -0000 1.28.2.81 @@ -135,7 +135,7 @@ "instanceId" numeric(14 ,0) identity, "pId" numeric(14,0) default '0' NOT NULL, "started" numeric(14,0) default NULL NULL, - "name" varchar(200) default 'No Name', + "name" varchar(200) default 'No Name' NOT NULL, "owner" varchar(200) default NULL NULL, "nextActivity" numeric(14,0) default NULL NULL, "nextUser" varchar(200) default NULL NULL, @@ -472,10 +472,10 @@ go CREATE INDEX "tiki_articles_body" ON "tiki_articles"("body") go -CREATE INDEX "tiki_articles_nbreads" ON "tiki_articles"("nbreads") -go CREATE INDEX "tiki_articles_author" ON "tiki_articles"("author") go +CREATE INDEX "tiki_articles_nbreads" ON "tiki_articles"("nbreads") +go CREATE INDEX "tiki_articles_ft" ON "tiki_articles"("title","heading","body") go -- -------------------------------------------------------- @@ -670,10 +670,10 @@ "data_size" numeric(11,0) default '0' NOT NULL, "created" numeric(14,0) default NULL NULL, "user" varchar(40) default NULL NULL, - "priv" varchar(1) default NULL NULL, "trackbacks_to" text default '', "trackbacks_from" text default '', "title" varchar(80) default NULL NULL, + "priv" varchar(1) default NULL NULL, PRIMARY KEY ("postId") ) go @@ -802,6 +802,7 @@ "end" numeric(14,0) default '0' NOT NULL, "locationId" numeric(14,0) default NULL NULL, "categoryId" numeric(14,0) default NULL NULL, + "nlId" numeric(12,0) default '0' NOT NULL, "priority" varchar(3) default '1' NOT NULL CHECK ("priority" IN ('1','2','3','4','5','6','7','8','9')), "status" varchar(3) default '0' NOT NULL CHECK ("status" IN ('0','1','2')), "url" varchar(255) default NULL NULL, @@ -809,7 +810,6 @@ "name" varchar(255) default '' NOT NULL, "description" image default '', "user" varchar(40) default NULL NULL, - "nlId" numeric(12,0) default NULL NULL, "created" numeric(14,0) default '0' NOT NULL, "lastmodif" numeric(14,0) default '0' NOT NULL, PRIMARY KEY ("calitemId") @@ -2157,8 +2157,8 @@ "galleryId" numeric(14,0) default '0' NOT NULL, "name" varchar(200) default '' NOT NULL, "description" text default '', - "lat" float default NULL NULL, "lon" float default NULL NULL, + "lat" float default NULL NULL, "created" numeric(14,0) default NULL NULL, "user" varchar(40) default NULL NULL, "hits" numeric(14,0) default NULL NULL, @@ -2204,8 +2204,8 @@ "filesize" numeric(14,0) default NULL NULL, "filetype" varchar(80) default NULL NULL, "filename" varchar(80) default NULL NULL, - "etag" varchar(32) default NULL NULL, "data" image default '', + "etag" varchar(32) default NULL NULL, PRIMARY KEY ("imageId","xsize","ysize","type") ) go @@ -3666,8 +3666,8 @@ "page_size" numeric(10,0) default '0', "lang" varchar(16) default NULL NULL, "lockedby" varchar(200) default NULL NULL, - "created" numeric(14,0) default NULL NULL, "is_html" numeric(1,0) default 0, + "created" numeric(14,0) default NULL NULL, PRIMARY KEY ("page_id") ) go @@ -4782,11 +4782,11 @@ "trackerId" numeric(12,0) default '0' NOT NULL, "name" varchar(255) default NULL NULL, "options" text default '', - "position" numeric(4,0) default NULL NULL, "type" char(1) default NULL NULL, "isMain" char(1) default NULL NULL, "isTblVisible" char(1) default NULL NULL, - "isSearchable" char(1) default NULL NULL, + "position" numeric(4,0) default NULL NULL, + "isSearchable" char(1) default 'y' NOT NULL, "isPublic" char(1) default 'n' NOT NULL, "isHidden" char(1) default 'n' NOT NULL, "isMandatory" char(1) default 'n' NOT NULL, @@ -4816,12 +4816,12 @@ "filesize" numeric(14,0) default NULL NULL, "user" varchar(40) default NULL NULL, "data" image default '', - "longdesc" image default '', "path" varchar(255) default NULL NULL, "downloads" numeric(10,0) default NULL NULL, - "version" varchar(40) default NULL NULL, "created" numeric(14,0) default NULL NULL, "comment" varchar(250) default NULL NULL, + "longdesc" image default '', + "version" varchar(40) default NULL NULL, PRIMARY KEY ("attId") ) go @@ -4874,6 +4874,8 @@ go +CREATE INDEX "tiki_tracker_item_fields_ft" ON "tiki_tracker_item_fields"("value") +go -- -------------------------------------------------------- -- @@ -4944,11 +4946,11 @@ "showStatus" char(1) default NULL NULL, "showLastModif" char(1) default NULL NULL, "useComments" char(1) default NULL NULL, - "showComments" char(1) default NULL NULL, "useAttachments" char(1) default NULL NULL, + "items" numeric(10,0) default NULL NULL, + "showComments" char(1) default NULL NULL, "showAttachments" char(1) default NULL NULL, "orderAttachments" varchar(255) default 'filename,created,filesize,downloads,desc' NOT NULL, - "items" numeric(10,0) default NULL NULL, PRIMARY KEY ("trackerId") ) go @@ -6728,6 +6730,10 @@ go +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_blogposts_pings','y') +go + + INSERT INTO "tiki_preferences" ("name","value") VALUES ('cacheimages','n') go @@ -7276,7 +7282,7 @@ go -INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_user_watches_translations','n') +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_user_watches_translations','y') go @@ -8104,6 +8110,34 @@ go +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_gal_slideshow','y') +go + + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_galleries','y') +go + + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_ranking','n') +go + + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('feature_trackbackpings','y') +go + + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('rssfeed_creator','') +go + + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('rssfeed_css','y') +go + + +INSERT INTO "tiki_preferences" ("name","value") VALUES ('rssfeed_publisher','') +go + + -- default sizes for mailbox, read box and mail archive @@ -8230,10 +8264,10 @@ go -CREATE INDEX "tiki_quicktags_taglabel" ON "tiki_quicktags"("taglabel") -go CREATE INDEX "tiki_quicktags_tagcategory" ON "tiki_quicktags"("tagcategory") go +CREATE INDEX "tiki_quicktags_taglabel" ON "tiki_quicktags"("taglabel") +go INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('bold','__text__','images/ed_format_bold.gif','wiki') go @@ -8307,7 +8341,7 @@ go -INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('New wms Metadata','METADATA\r\n "wms_name" "myname"\r\n "wms_srs" "EPSG:4326"\r\n "wms_server_version" " "\r\n "wms_layers" "mylayers"\r\n "wms_request" "myrequest"\r\n "wms_format" " "\r\n "wms_time" " "\r\n END', 'img/icons/admin_metatags.png','maps') +INSERT INTO "tiki_quicktags" ("taglabel","taginsert","tagicon","tagcategory") VALUES ('New wms Metadata','METADATA\r\n \"wms_name\" \"myname\"\r\n "wms_srs" "EPSG:4326"\r\n "wms_server_version" " "\r\n "wms_layers" "mylayers"\r\n "wms_request" "myrequest"\r\n "wms_format" " "\r\n "wms_time" " "\r\n END', 'img/icons/admin_metatags.png','maps') go @@ -8447,7 +8481,7 @@ go -CREATE INDEX "tiki_translated_objects_tradid" ON "tiki_translated_objects"("traId") +CREATE INDEX "tiki_translated_objects_traId" ON "tiki_translated_objects"( "traId" ) go @@ -8496,6 +8530,128 @@ + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('login',1,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('login_remain',2,60) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('profile_fill',10,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('profile_see',2,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('profile_is_seen',1,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('friend_new',10,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('message_receive',1,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('message_send',2,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_read',2,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_comment',5,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_new',20,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_is_read',1,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('article_is_commented',2,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_new',10,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_new_file',10,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_download',5,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('fgallery_is_downloaded',5,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_new',10,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_new_img',6,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_see_img',3,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('igallery_img_seen',1,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_new',20,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_post',5,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_read',2,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_comment',2,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_is_read',3,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('blog_is_commented',3,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('wiki_new',10,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('wiki_edit',5,0) +go + + +INSERT INTO "tiki_score" ("event","score","expiration") VALUES ('wiki_attach_file',3,0) +go + + + -- DROP TABLE "tiki_users_score" go |