diff options
| author | z0rglub <z0rglub@piwigo.org> | 2004-03-04 23:57:39 +0000 |
|---|---|---|
| committer | z0rglub <z0rglub@piwigo.org> | 2004-03-04 23:57:39 +0000 |
| commit | 0a6d420fd4d1ce15df689daa2436a70bafb7086d (patch) | |
| tree | 5d8e97f5ffc6dd53ffcca969441815fe72ee980b /install/phpwebgallery_structure.sql | |
| parent | 801e36f6d59358cb0163628adfb3ac965163cc2e (diff) | |
new version of config table
git-svn-id: http://piwigo.org/svn/trunk@385 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/phpwebgallery_structure.sql')
| -rw-r--r-- | install/phpwebgallery_structure.sql | 27 |
1 files 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' |