From: <te...@us...> - 2004-07-20 19:59:07
|
Update of /cvsroot/tikiwiki/tiki/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16554/db Modified Files: tiki-1.10-pgsql.sql tiki-1.10-sybase.sql tiki-1.10-oci8.sql tiki-1.10-sqlite.sql tiki-1.10-mysql.sql Log Message: added tiki_p_view_wiki_history Index: tiki-1.10-pgsql.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.10-pgsql.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- tiki-1.10-pgsql.sql 17 Jul 2004 13:31:42 -0000 1.4 +++ tiki-1.10-pgsql.sql 20 Jul 2004 19:58:57 -0000 1.5 @@ -4618,6 +4618,8 @@ INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_view_user_results', 'Can view user quiz results', 'editors', 'quizzes'); +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_view_wiki_history', 'Can view wiki page history', 'registered', 'wiki'); + INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_vote_chart', 'Can vote', 'basic', 'charts'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_vote_comments', 'Can vote comments', 'registered', 'comments'); @@ -5812,8 +5814,6 @@ -- Community tables end -- - - -- -- Tables of the Opinion-Network -- @@ -5821,48 +5821,47 @@ DROP TABLE "tiki_opnet_question"; CREATE TABLE "tiki_opnet_question" ( - "id" INT(10) NOT NULL AUTO_INCREMENT, - "which_formtype" INT(10) NOT NULL, - "question_str" VARCHAR(100) NOT NULL, - PRIMARY KEY ("id") + "id" INT( 10 ) NOT NULL AUTO_INCREMENT , + "formtype" INT(10) NOT NULL, + "question" VARCHAR( 100 ) NOT NULL , +PRIMARY KEY ( id ) ); DROP TABLE "tiki_opnet_formtype"; CREATE TABLE "tiki_opnet_formtype" ( - "id" INT( 10 ) NOT NULL AUTO_INCREMENT, - "name" VARCHAR(30) NOT NULL, - "timestamp" INT(14) NOT NULL, - PRIMARY KEY ("id") + "id" INT( 10 ) NOT NULL AUTO_INCREMENT , + "name" VARCHAR( 30 ) NOT NULL , + "timestamp" INT( 14 ) NOT NULL, +PRIMARY KEY ( id ) ); DROP TABLE "tiki_opnet_answer"; CREATE TABLE "tiki_opnet_answer" ( - "id" INT(10) NOT NULL AUTO_INCREMENT, - "id_question" INT(10) NOT NULL, - "id_filledform" INT(10) NOT NULL, - "value" TEXT NOT NULL, - PRIMARY KEY ("id") + "id" INT( 10 ) NOT NULL AUTO_INCREMENT , + "question_id" INT( 10 ) NOT NULL , + "filledform_id" INT( 10 ) NOT NULL , + "value" TEXT NOT NULL , +PRIMARY KEY ( id ) ); DROP TABLE "tiki_opnet_filledform"; CREATE TABLE "tiki_opnet_filledform" ( - "id" INT(10) NOT NULL AUTO_INCREMENT, - "who" INT(10) NOT NULL, - "about_who" INT(10) NOT NULL, - "which_form" INT(10) NOT NULL, - "timestamp" INT(14) NOT NULL, - PRIMARY KEY ("id") + "id" INT( 10 ) NOT NULL AUTO_INCREMENT , + "who" VARCHAR( 40 ) NOT NULL , + "about_who" VARCHAR( 40 ) NOT NULL , + "formtype" INT( 10 ) NOT NULL , + "timestamp" INT( 14 ) NOT NULL, +PRIMARY KEY ( id ) ); -- -- Opinion-Network tables END --- -; +--; Index: tiki-1.10-sybase.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.10-sybase.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- tiki-1.10-sybase.sql 17 Jul 2004 13:31:42 -0000 1.4 +++ tiki-1.10-sybase.sql 20 Jul 2004 19:58:57 -0000 1.5 @@ -6058,6 +6058,10 @@ go +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_view_wiki_history', 'Can view wiki page history', 'registered', 'wiki') +go + + INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_vote_chart', 'Can vote', 'basic', 'charts') go @@ -8173,8 +8177,6 @@ -- Community tables end -- - - -- -- Tables of the Opinion-Network -- @@ -8184,10 +8186,10 @@ CREATE TABLE "tiki_opnet_question" ( - "id" INT(10) NOT NULL AUTO_INCREMENT, - "which_formtype" INT(10) NOT NULL, - "question_str" VARCHAR(100) NOT NULL, - PRIMARY KEY (id) + "id" INT( 10 ) NOT NULL AUTO_INCREMENT , + "formtype" INT(10) NOT NULL, + "question" VARCHAR( 100 ) NOT NULL , +PRIMARY KEY ( id ) ) go @@ -8198,10 +8200,10 @@ CREATE TABLE "tiki_opnet_formtype" ( - "id" INT( 10 ) NOT NULL AUTO_INCREMENT, - "name" VARCHAR(30) NOT NULL, - "timestamp" INT(14) NOT NULL, - PRIMARY KEY (id) + "id" INT( 10 ) NOT NULL AUTO_INCREMENT , + "name" VARCHAR( 30 ) NOT NULL , + "timestamp" INT( 14 ) NOT NULL, +PRIMARY KEY ( id ) ) go @@ -8212,11 +8214,11 @@ CREATE TABLE "tiki_opnet_answer" ( - "id" INT(10) NOT NULL AUTO_INCREMENT, - "id_question" INT(10) NOT NULL, - "id_filledform" INT(10) NOT NULL, - "value" TEXT NOT NULL, - PRIMARY KEY (id) + "id" INT( 10 ) NOT NULL AUTO_INCREMENT , + "question_id" INT( 10 ) NOT NULL , + "filledform_id" INT( 10 ) NOT NULL , + "value" TEXT NOT NULL , +PRIMARY KEY ( id ) ) go @@ -8227,12 +8229,12 @@ CREATE TABLE "tiki_opnet_filledform" ( - "id" INT(10) NOT NULL AUTO_INCREMENT, - "who" INT(10) NOT NULL, - "about_who" INT(10) NOT NULL, - "which_form" INT(10) NOT NULL, - "timestamp" INT(14) NOT NULL, - PRIMARY KEY (id) + "id" INT( 10 ) NOT NULL AUTO_INCREMENT , + "who" VARCHAR( 40 ) NOT NULL , + "about_who" VARCHAR( 40 ) NOT NULL , + "formtype" INT( 10 ) NOT NULL , + "timestamp" INT( 14 ) NOT NULL, +PRIMARY KEY ( id ) ) go @@ -8241,7 +8243,6 @@ -- -- Opinion-Network tables END -- - go Index: tiki-1.10-oci8.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.10-oci8.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- tiki-1.10-oci8.sql 17 Jul 2004 13:31:42 -0000 1.4 +++ tiki-1.10-oci8.sql 20 Jul 2004 19:58:57 -0000 1.5 @@ -2004,6 +2004,8 @@ ; +; + CREATE SEQUENCE "_sequ" INCREMENT BY 1 START WITH 1; ; Index: tiki-1.10-sqlite.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.10-sqlite.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- tiki-1.10-sqlite.sql 17 Jul 2004 13:31:42 -0000 1.4 +++ tiki-1.10-sqlite.sql 20 Jul 2004 19:58:57 -0000 1.5 @@ -4618,6 +4618,8 @@ INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_view_user_results', 'Can view user quiz results', 'editors', 'quizzes'); +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_view_wiki_history', 'Can view wiki page history', 'registered', 'wiki'); + INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_vote_chart', 'Can vote', 'basic', 'charts'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_vote_comments', 'Can vote comments', 'registered', 'comments'); @@ -5812,8 +5814,6 @@ -- Community tables end -- - - -- -- Tables of the Opinion-Network -- @@ -5821,48 +5821,47 @@ DROP TABLE "tiki_opnet_question"; CREATE TABLE "tiki_opnet_question" ( - "id" INT(10) NOT NULL AUTO_INCREMENT, - "which_formtype" INT(10) NOT NULL, - "question_str" VARCHAR(100) NOT NULL, - PRIMARY KEY (id) + "id" INT( 10 ) NOT NULL AUTO_INCREMENT , + "formtype" INT(10) NOT NULL, + "question" VARCHAR( 100 ) NOT NULL , +PRIMARY KEY ( id ) ); DROP TABLE "tiki_opnet_formtype"; CREATE TABLE "tiki_opnet_formtype" ( - "id" INT( 10 ) NOT NULL AUTO_INCREMENT, - "name" VARCHAR(30) NOT NULL, - "timestamp" INT(14) NOT NULL, - PRIMARY KEY (id) + "id" INT( 10 ) NOT NULL AUTO_INCREMENT , + "name" VARCHAR( 30 ) NOT NULL , + "timestamp" INT( 14 ) NOT NULL, +PRIMARY KEY ( id ) ); DROP TABLE "tiki_opnet_answer"; CREATE TABLE "tiki_opnet_answer" ( - "id" INT(10) NOT NULL AUTO_INCREMENT, - "id_question" INT(10) NOT NULL, - "id_filledform" INT(10) NOT NULL, - "value" TEXT NOT NULL, - PRIMARY KEY (id) + "id" INT( 10 ) NOT NULL AUTO_INCREMENT , + "question_id" INT( 10 ) NOT NULL , + "filledform_id" INT( 10 ) NOT NULL , + "value" TEXT NOT NULL , +PRIMARY KEY ( id ) ); DROP TABLE "tiki_opnet_filledform"; CREATE TABLE "tiki_opnet_filledform" ( - "id" INT(10) NOT NULL AUTO_INCREMENT, - "who" INT(10) NOT NULL, - "about_who" INT(10) NOT NULL, - "which_form" INT(10) NOT NULL, - "timestamp" INT(14) NOT NULL, - PRIMARY KEY (id) + "id" INT( 10 ) NOT NULL AUTO_INCREMENT , + "who" VARCHAR( 40 ) NOT NULL , + "about_who" VARCHAR( 40 ) NOT NULL , + "formtype" INT( 10 ) NOT NULL , + "timestamp" INT( 14 ) NOT NULL, +PRIMARY KEY ( id ) ); -- -- Opinion-Network tables END --- -; +--; Index: tiki-1.10-mysql.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.10-mysql.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -u -d -r1.4 -r1.5 --- tiki-1.10-mysql.sql 17 Jul 2004 13:31:42 -0000 1.4 +++ tiki-1.10-mysql.sql 20 Jul 2004 19:58:57 -0000 1.5 @@ -3932,6 +3932,7 @@ INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_view_trackers_closed', 'Can view trackers closed items', 'registered', 'trackers'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_view_trackers_pending', 'Can view trackers pending items', 'editors', 'trackers'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_view_user_results', 'Can view user quiz results', 'editors', 'quizzes'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_view_wiki_history', 'Can view wiki page history', 'registered', 'wiki'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_vote_chart', 'Can vote', 'basic', 'charts'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_vote_comments', 'Can vote comments', 'registered', 'comments'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_vote_poll', 'Can vote polls', 'basic', 'tiki'); @@ -4670,47 +4671,45 @@ # Community tables end # - - # # Tables of the Opinion-Network # DROP TABLE IF EXISTS tiki_opnet_question; CREATE TABLE tiki_opnet_question ( - id INT(10) NOT NULL AUTO_INCREMENT, - which_formtype INT(10) NOT NULL, - question_str VARCHAR(100) NOT NULL, - PRIMARY KEY (id) + id INT( 10 ) NOT NULL AUTO_INCREMENT , + formtype INT(10) NOT NULL, + question VARCHAR( 100 ) NOT NULL , +PRIMARY KEY ( id ) ); DROP TABLE IF EXISTS tiki_opnet_formtype; CREATE TABLE tiki_opnet_formtype ( - id INT( 10 ) NOT NULL AUTO_INCREMENT, - name VARCHAR(30) NOT NULL, - timestamp INT(14) NOT NULL, - PRIMARY KEY (id) + id INT( 10 ) NOT NULL AUTO_INCREMENT , + name VARCHAR( 30 ) NOT NULL , + timestamp INT( 14 ) NOT NULL, +PRIMARY KEY ( id ) ); DROP TABLE IF EXISTS tiki_opnet_answer; CREATE TABLE tiki_opnet_answer ( - id INT(10) NOT NULL AUTO_INCREMENT, - id_question INT(10) NOT NULL, - id_filledform INT(10) NOT NULL, - value TEXT NOT NULL, - PRIMARY KEY (id) + id INT( 10 ) NOT NULL AUTO_INCREMENT , + question_id INT( 10 ) NOT NULL , + filledform_id INT( 10 ) NOT NULL , + value TEXT NOT NULL , +PRIMARY KEY ( id ) ); DROP TABLE IF EXISTS tiki_opnet_filledform; CREATE TABLE tiki_opnet_filledform ( - id INT(10) NOT NULL AUTO_INCREMENT, - who INT(10) NOT NULL, - about_who INT(10) NOT NULL, - which_form INT(10) NOT NULL, - timestamp INT(14) NOT NULL, - PRIMARY KEY (id) + id INT( 10 ) NOT NULL AUTO_INCREMENT , + who VARCHAR( 40 ) NOT NULL , + about_who VARCHAR( 40 ) NOT NULL , + formtype INT( 10 ) NOT NULL , + timestamp INT( 14 ) NOT NULL, +PRIMARY KEY ( id ) ); # # Opinion-Network tables END -# +# \ No newline at end of file |