diff options
Diffstat (limited to 'install')
| -rw-r--r-- | install/config.sql | 7 | ||||
| -rw-r--r-- | install/phpwebgallery_structure.sql | 18 |
2 files changed, 9 insertions, 16 deletions
diff --git a/install/config.sql b/install/config.sql index ba7e8875d..fa27ce1e3 100644 --- a/install/config.sql +++ b/install/config.sql @@ -1,17 +1,10 @@ -- initial configuration for PhpWebGallery -INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('prefix_thumbnail','TN-','thumbnails filename prefix'); -INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('mail_webmaster','','webmaster mail'); INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('default_language','en_UK.iso-8859-1','Default gallery language'); INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('default_template','default','Default gallery style'); INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('default_maxwidth','','maximum width authorized for displaying images'); INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('default_maxheight','','maximum height authorized for the displaying images'); INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('nb_comment_page','10','number of comments to display on each page'); -INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('upload_maxfilesize','150','maximum filesize for the uploaded pictures'); -INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('upload_maxwidth','800','maximum width authorized for the uploaded images'); -INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('upload_maxheight','600','maximum height authorized for the uploaded images'); -INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('upload_maxwidth_thumbnail','150','maximum width authorized for the uploaded thumbnails'); -INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('upload_maxheight_thumbnail','100','maximum height authorized for the uploaded thumbnails'); INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('log','false','keep an history of visits on your website'); INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('comments_validation','false','administrators validate users comments before becoming visible'); INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('comments_forall','false','even guest not registered can post comments'); diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index 28368df69..5d0bac12a 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -77,7 +77,7 @@ CREATE TABLE `phpwebgallery_config` ( DROP TABLE IF EXISTS `phpwebgallery_favorites`; CREATE TABLE `phpwebgallery_favorites` ( - `user_id` smallint(5) unsigned NOT NULL default '0', + `user_id` smallint(5) NOT NULL default '0', `image_id` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`user_id`,`image_id`) ) TYPE=MyISAM; @@ -170,7 +170,7 @@ CREATE TABLE `phpwebgallery_images` ( DROP TABLE IF EXISTS `phpwebgallery_rate`; CREATE TABLE `phpwebgallery_rate` ( - `user_id` smallint(5) unsigned NOT NULL default '0', + `user_id` smallint(5) NOT NULL default '0', `element_id` mediumint(8) unsigned NOT NULL default '0', `rate` tinyint(2) unsigned NOT NULL default '0', PRIMARY KEY (`user_id`,`element_id`) @@ -183,7 +183,7 @@ CREATE TABLE `phpwebgallery_rate` ( DROP TABLE IF EXISTS `phpwebgallery_sessions`; CREATE TABLE `phpwebgallery_sessions` ( `id` varchar(255) binary NOT NULL default '', - `user_id` smallint(5) unsigned NOT NULL default '0', + `user_id` smallint(5) NOT NULL default '0', `expiration` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) TYPE=MyISAM; @@ -206,7 +206,7 @@ CREATE TABLE `phpwebgallery_sites` ( DROP TABLE IF EXISTS `phpwebgallery_user_access`; CREATE TABLE `phpwebgallery_user_access` ( - `user_id` smallint(5) unsigned NOT NULL default '0', + `user_id` smallint(5) NOT NULL default '0', `cat_id` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`user_id`,`cat_id`) ) TYPE=MyISAM; @@ -217,7 +217,7 @@ CREATE TABLE `phpwebgallery_user_access` ( DROP TABLE IF EXISTS `phpwebgallery_user_cache`; CREATE TABLE `phpwebgallery_user_cache` ( - `user_id` smallint(5) unsigned NOT NULL default '0', + `user_id` smallint(5) NOT NULL default '0', `need_update` enum('true','false') NOT NULL default 'true', `forbidden_categories` text, PRIMARY KEY (`user_id`) @@ -230,7 +230,7 @@ CREATE TABLE `phpwebgallery_user_cache` ( DROP TABLE IF EXISTS `phpwebgallery_user_feed`; CREATE TABLE `phpwebgallery_user_feed` ( `id` varchar(50) binary NOT NULL default '', - `user_id` smallint(5) unsigned NOT NULL default '0', + `user_id` smallint(5) NOT NULL default '0', `last_check` datetime default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; @@ -241,7 +241,7 @@ CREATE TABLE `phpwebgallery_user_feed` ( DROP TABLE IF EXISTS `phpwebgallery_user_group`; CREATE TABLE `phpwebgallery_user_group` ( - `user_id` smallint(5) unsigned NOT NULL default '0', + `user_id` smallint(5) NOT NULL default '0', `group_id` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`group_id`,`user_id`) ) TYPE=MyISAM; @@ -252,7 +252,7 @@ CREATE TABLE `phpwebgallery_user_group` ( DROP TABLE IF EXISTS `phpwebgallery_user_infos`; CREATE TABLE `phpwebgallery_user_infos` ( - `user_id` smallint(5) unsigned NOT NULL default '0', + `user_id` smallint(5) NOT NULL default '0', `nb_image_line` tinyint(1) unsigned NOT NULL default '5', `nb_line_page` tinyint(3) unsigned NOT NULL default '3', `status` enum('admin','guest') NOT NULL default 'guest', @@ -273,7 +273,7 @@ CREATE TABLE `phpwebgallery_user_infos` ( DROP TABLE IF EXISTS `phpwebgallery_users`; CREATE TABLE `phpwebgallery_users` ( - `id` smallint(5) unsigned NOT NULL auto_increment, + `id` smallint(5) NOT NULL auto_increment, `username` varchar(20) binary NOT NULL default '', `password` varchar(32) default NULL, `mail_address` varchar(255) default NULL, |