From 0a6d420fd4d1ce15df689daa2436a70bafb7086d Mon Sep 17 00:00:00 2001 From: z0rglub Date: Thu, 4 Mar 2004 23:57:39 +0000 Subject: new version of config table git-svn-id: http://piwigo.org/svn/trunk@385 68402e56-0260-453c-a942-63ccdbb3a9ee --- install/phpwebgallery_structure.sql | 27 +++++---------------------- 1 file changed, 5 insertions(+), 22 deletions(-) diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index 7f73acc73..c516f72d0 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -50,28 +50,11 @@ CREATE TABLE phpwebgallery_comments ( DROP TABLE IF EXISTS phpwebgallery_config; CREATE TABLE phpwebgallery_config ( - prefix_thumbnail varchar(10) default 'TN-', - webmaster varchar(255) NOT NULL default '', - mail_webmaster varchar(255) NOT NULL default '', - access enum('free','restricted') default 'free', - session_id_size tinyint(3) unsigned NOT NULL default '4', - session_keyword varchar(255) default NULL, - session_time tinyint(3) unsigned NOT NULL default '30', - max_user_listbox tinyint(3) unsigned NOT NULL default '10', - show_comments enum('true','false') NOT NULL default 'true', - nb_comment_page tinyint(4) NOT NULL default '10', - upload_available enum('true','false') NOT NULL default 'false', - upload_maxfilesize smallint(5) unsigned NOT NULL default '150', - upload_maxwidth smallint(5) unsigned NOT NULL default '800', - upload_maxheight smallint(5) unsigned NOT NULL default '600', - upload_maxwidth_thumbnail smallint(5) unsigned NOT NULL default '150', - upload_maxheight_thumbnail smallint(5) unsigned NOT NULL default '100', - log enum('true','false') NOT NULL default 'false', - comments_validation enum('true','false') NOT NULL default 'false', - comments_forall enum('true','false') NOT NULL default 'false', - authorize_cookies enum('true','false') NOT NULL default 'false', - mail_notification enum('true','false') NOT NULL default 'false' -) TYPE=MyISAM; + param varchar(40) NOT NULL default '', + value varchar(255) default NULL, + comment varchar(255) default NULL, + PRIMARY KEY (param) +) TYPE=MyISAM COMMENT='configuration table'; -- -- Table structure for table 'phpwebgallery_favorites' -- cgit v1.2.3