Menu
▾
▴
[Tikiwiki-cvs] tiki/db tiki-1.9-mysql.sql,1.38.2.42,1.38.2.43 tiki-1.9-oci8.sql,1.28.2.39,1.28.2.40 tiki-1.9-pgsql.sql,1.28.2.40,1.28.2.41 tiki-1.9-sqlite.sql,1.28.2.39,1.28.2.40 tiki-1.9-sybase.sql,1.28.2.41,1.28.2.42
Update of /cvsroot/tikiwiki/tiki/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14076 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: made convertscripts version independent and fixed a bug in sybase and oracle convertscripts. Refreshed schemas. Index: tiki-1.9-mysql.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/Attic/tiki-1.9-mysql.sql,v retrieving revision 1.38.2.42 retrieving revision 1.38.2.43 diff -u -d -r1.38.2.42 -r1.38.2.43 --- tiki-1.9-mysql.sql 11 Dec 2004 15:09:33 -0000 1.38.2.42 +++ tiki-1.9-mysql.sql 3 Jan 2005 22:47:59 -0000 1.38.2.43 @@ -629,6 +629,7 @@ customevents enum('n','y') default 'n' NOT NULL, created int(14) NOT NULL default '0', lastmodif int(14) NOT NULL default '0', + personal enum ('n', 'y') NOT NULL default 'n', PRIMARY KEY (calendarId) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # -------------------------------------------------------- @@ -2083,11 +2084,13 @@ INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Stats','tiki-survey_stats.php',860,'feature_surveys','tiki_p_view_survey_stats',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Admin surveys','tiki-admin_surveys.php',865,'feature_surveys','tiki_p_admin_surveys',''); -INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_subscribe_newsletters,tiki_p_send_newsletters,tiki_p_admin_newsletters',''); +INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_subscribe_newsletters',''); +INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_send_newsletters',''); +INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_admin_newsletters',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Send newsletters','tiki-send_newsletters.php',905,'feature_newsletters','tiki_p_send_newsletters',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Admin newsletters','tiki-admin_newsletters.php',910,'feature_newsletters','tiki_p_admin_newsletters',''); -INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Events','tiki-events.php',920,'feature_events','',''); +INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Events','tiki-events.php',920,'feature_events','tiki_p_subscribe_events',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Send events','tiki-send_events.php',925,'feature_events','tiki_p_send_events',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Admin events','tiki-admin_events.php',930,'feature_events','tiki_p_admin_events',''); @@ -2110,7 +2113,7 @@ INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_view_referer_stats',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_drawings',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_shoutbox',''); -INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_live_support',''); +INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_live_support_admin',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'r','Admin','tiki-admin.php',1050,'','user_is_operator',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'r','Admin','tiki-admin.php',1050,'feature_integrator','tiki_p_admin_integrator',''); INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Admin home','tiki-admin.php',1051,'','tiki_p_admin',''); @@ -2669,6 +2672,7 @@ sPrologue text, sData text, sEpilogue text, + passingperct int(4) default 0, PRIMARY KEY (quizId, nVersion) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # -------------------------------------------------------- @@ -4058,7 +4062,8 @@ INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_vote_poll', 'Can vote polls', 'basic', 'tiki'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_admin_attachments', 'Can admin attachments to wiki pages', 'editors', 'wiki'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_attach_files', 'Can attach files to wiki pages', 'registered', 'wiki'); -INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_view_comments', 'Can view wiki coments', 'basic', 'wiki'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_view_attachments', 'Can view wiki attachments and download', 'registered', 'wiki'); +INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_view_comments', 'Can view wiki comments', 'basic', 'wiki'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_view_ratings', 'Can view rating of wiki pages', 'basic', 'wiki'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_vote_ratings', 'Can participate to rating of wiki pages', 'registered', 'wiki'); INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_wiki_admin_ratings', 'Can add and change ratings on wiki pages', 'admin', 'wiki'); Index: tiki-1.9-oci8.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/Attic/tiki-1.9-oci8.sql,v retrieving revision 1.28.2.39 retrieving revision 1.28.2.40 diff -u -d -r1.28.2.39 -r1.28.2.40 --- tiki-1.9-oci8.sql 11 Dec 2004 15:09:34 -0000 1.28.2.39 +++ tiki-1.9-oci8.sql 3 Jan 2005 22:47:59 -0000 1.28.2.40 @@ -738,6 +738,7 @@ "customevents" varchar(3) default 'n' NOT NULL CHECK ("customevents" 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") ) ; @@ -1732,7 +1733,7 @@ "showxysize" char(1) default 'y' NOT NULL, "showfilesize" char(1) default 'n' NOT NULL, "showfilename" char(1) default 'n' NOT NULL, - "defaultscale" varchar(10) NOT NULL DEFAULT 'o', + "defaultscale" varchar(10) DEFAULT 'o' NOT NULL, PRIMARY KEY ("galleryId") ) ; @@ -2525,14 +2526,18 @@ INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Admin surveys','tiki-admin_surveys.php',865,'feature_surveys','tiki_p_admin_surveys',''); -INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_subscribe_newsletters,tiki_p_send_newsletters,tiki_p_admin_newsletters',''); +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_subscribe_newsletters',''); + +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_send_newsletters',''); + +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_admin_newsletters',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Send newsletters','tiki-send_newsletters.php',905,'feature_newsletters','tiki_p_send_newsletters',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Admin newsletters','tiki-admin_newsletters.php',910,'feature_newsletters','tiki_p_admin_newsletters',''); -INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Events','tiki-events.php',920,'feature_events','',''); +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Events','tiki-events.php',920,'feature_events','tiki_p_subscribe_events',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Send events','tiki-send_events.php',925,'feature_events','tiki_p_send_events',''); @@ -2575,7 +2580,7 @@ INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_shoutbox',''); -INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_live_support',''); +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_live_support_admin',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'r','Admin','tiki-admin.php',1050,'','user_is_operator',''); @@ -3283,6 +3288,7 @@ "sPrologue" clob, "sData" clob, "sEpilogue" clob, + "passingperct" number(4) default 0, PRIMARY KEY ("quizId","nVersion") ) ; @@ -5043,7 +5049,9 @@ INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_attach_files', 'Can attach files to wiki pages', 'registered', 'wiki'); -INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_view_comments', 'Can view wiki coments', 'basic', 'wiki'); +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_view_attachments', 'Can view wiki attachments and download', 'registered', 'wiki'); + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_view_comments', 'Can view wiki comments', 'basic', 'wiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_view_ratings', 'Can view rating of wiki pages', 'basic', 'wiki'); Index: tiki-1.9-pgsql.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/Attic/tiki-1.9-pgsql.sql,v retrieving revision 1.28.2.40 retrieving revision 1.28.2.41 diff -u -d -r1.28.2.40 -r1.28.2.41 --- tiki-1.9-pgsql.sql 11 Dec 2004 15:09:34 -0000 1.28.2.40 +++ tiki-1.9-pgsql.sql 3 Jan 2005 22:47:59 -0000 1.28.2.41 @@ -686,6 +686,7 @@ "customevents" varchar(3) CHECK ("customevents" IN ('n','y')) default 'n' NOT NULL, "created" bigint NOT NULL default '0', "lastmodif" bigint NOT NULL default '0', + "personal" enum ('n', 'y') NOT NULL default 'n', PRIMARY KEY ("calendarId") ) ; @@ -2380,14 +2381,18 @@ INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Admin surveys','tiki-admin_surveys.php',865,'feature_surveys','tiki_p_admin_surveys',''); -INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_subscribe_newsletters,tiki_p_send_newsletters,tiki_p_admin_newsletters',''); +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_subscribe_newsletters',''); + +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_send_newsletters',''); + +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_admin_newsletters',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Send newsletters','tiki-send_newsletters.php',905,'feature_newsletters','tiki_p_send_newsletters',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Admin newsletters','tiki-admin_newsletters.php',910,'feature_newsletters','tiki_p_admin_newsletters',''); -INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Events','tiki-events.php',920,'feature_events','',''); +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Events','tiki-events.php',920,'feature_events','tiki_p_subscribe_events',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Send events','tiki-send_events.php',925,'feature_events','tiki_p_send_events',''); @@ -2430,7 +2435,7 @@ INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_shoutbox',''); -INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_live_support',''); +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_live_support_admin',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'r','Admin','tiki-admin.php',1050,'','user_is_operator',''); @@ -3088,6 +3093,7 @@ "sPrologue" text, "sData" text, "sEpilogue" text, + "passingperct" smallint default 0, PRIMARY KEY ("quizId","nVersion") ) ; @@ -4775,7 +4781,9 @@ INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_attach_files', 'Can attach files to wiki pages', 'registered', 'wiki'); -INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_view_comments', 'Can view wiki coments', 'basic', 'wiki'); +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_view_attachments', 'Can view wiki attachments and download', 'registered', 'wiki'); + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_view_comments', 'Can view wiki comments', 'basic', 'wiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_view_ratings', 'Can view rating of wiki pages', 'basic', 'wiki'); Index: tiki-1.9-sqlite.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/Attic/tiki-1.9-sqlite.sql,v retrieving revision 1.28.2.39 retrieving revision 1.28.2.40 diff -u -d -r1.28.2.39 -r1.28.2.40 --- tiki-1.9-sqlite.sql 11 Dec 2004 15:09:35 -0000 1.28.2.39 +++ tiki-1.9-sqlite.sql 3 Jan 2005 22:47:59 -0000 1.28.2.40 @@ -686,6 +686,7 @@ "customevents" varchar(3) CHECK ("customevents" IN ('n','y')) default 'n' NOT NULL, "created" bigint NOT NULL default '0', "lastmodif" bigint NOT NULL default '0', + "personal" enum ('n', 'y') NOT NULL default 'n', PRIMARY KEY ("calendarId") ) ; @@ -2380,14 +2381,18 @@ INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Admin surveys','tiki-admin_surveys.php',865,'feature_surveys','tiki_p_admin_surveys',''); -INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_subscribe_newsletters,tiki_p_send_newsletters,tiki_p_admin_newsletters',''); +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_subscribe_newsletters',''); + +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_send_newsletters',''); + +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_admin_newsletters',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Send newsletters','tiki-send_newsletters.php',905,'feature_newsletters','tiki_p_send_newsletters',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Admin newsletters','tiki-admin_newsletters.php',910,'feature_newsletters','tiki_p_admin_newsletters',''); -INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Events','tiki-events.php',920,'feature_events','',''); +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'s','Events','tiki-events.php',920,'feature_events','tiki_p_subscribe_events',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'o','Send events','tiki-send_events.php',925,'feature_events','tiki_p_send_events',''); @@ -2430,7 +2435,7 @@ INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_shoutbox',''); -INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_admin_live_support',''); +INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'r','Admin','tiki-admin.php',1050,'','tiki_p_live_support_admin',''); INSERT INTO "tiki_menu_options" ("menuId","type","name","url","position","section","perm","groupname") VALUES (42,'r','Admin','tiki-admin.php',1050,'','user_is_operator',''); @@ -3088,6 +3093,7 @@ "sPrologue" text, "sData" text, "sEpilogue" text, + "passingperct" smallint default 0, PRIMARY KEY ("quizId","nVersion") ) ; @@ -4775,7 +4781,9 @@ INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_attach_files', 'Can attach files to wiki pages', 'registered', 'wiki'); -INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_view_comments', 'Can view wiki coments', 'basic', 'wiki'); +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_view_attachments', 'Can view wiki attachments and download', 'registered', 'wiki'); + +INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_view_comments', 'Can view wiki comments', 'basic', 'wiki'); INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_wiki_view_ratings', 'Can view rating of wiki pages', 'basic', 'wiki'); Index: tiki-1.9-sybase.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/Attic/tiki-1.9-sybase.sql,v retrieving revision 1.28.2.41 retrieving revision 1.28.2.42 diff -u -d -r1.28.2.41 -r1.28.2.42 --- tiki-1.9-sybase.sql 11 Dec 2004 15:09:36 -0000 1.28.2.41 +++ tiki-1.9-sybase.sql 3 Jan 2005 22:48:00 -0000 1.28.2.42 @@ -1671,8 +1671,8 @@ "is_reference" char(1) default NULL NULL, "hash" varchar(32) default NULL NULL, "search_data" longtext, - "lastModif" integer(14) DEFAULT NULL, - "lastModifUser" varchar(200) DEFAULT NULL, + "lastModif" integer(14) DEFAULT NULL NULL, + "lastModifUser" varchar(200) DEFAULT NULL NULL, PRIMARY KEY ("fileId") ) go @@ -1909,7 +1909,7 @@ "showxysize" char(1) default 'y' NOT NULL, "showfilesize" char(1) default 'n' NOT NULL, "showfilename" char(1) default 'n' NOT NULL, - "defaultscale" varchar(10) NOT NULL DEFAULT 'o', + "defaultscale" varchar(10) DEFAULT 'o' NOT NULL, PRIMARY KEY ("galleryId") ) go |