Changeset 29072
- Timestamp:
- Jul 24, 2014, 10:34:02 AM (10 years ago)
- Location:
- trunk/install
- Files:
-
- 1 added
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/install/piwigo_structure-mysql.sql
r28532 r29072 11 11 DROP TABLE IF EXISTS `piwigo_caddie`; 12 12 CREATE TABLE `piwigo_caddie` ( 13 `user_id` smallint(5)NOT NULL default '0',13 `user_id` mediumint(8) unsigned NOT NULL default '0', 14 14 `element_id` mediumint(8) NOT NULL default '0', 15 15 PRIMARY KEY (`user_id`,`element_id`) … … 55 55 `author` varchar(255) default NULL, 56 56 `email` varchar(255) default NULL, 57 `author_id` smallint(5)DEFAULT NULL,57 `author_id` mediumint(8) unsigned DEFAULT NULL, 58 58 `anonymous_id` varchar(45) NOT NULL, 59 59 `website_url` varchar(255) DEFAULT NULL, … … 84 84 DROP TABLE IF EXISTS `piwigo_favorites`; 85 85 CREATE TABLE `piwigo_favorites` ( 86 `user_id` smallint(5)NOT NULL default '0',86 `user_id` mediumint(8) unsigned NOT NULL default '0', 87 87 `image_id` mediumint(8) unsigned NOT NULL default '0', 88 88 PRIMARY KEY (`user_id`,`image_id`) … … 124 124 `date` date NOT NULL default '0000-00-00', 125 125 `time` time NOT NULL default '00:00:00', 126 `user_id` smallint(5)NOT NULL default '0',126 `user_id` mediumint(8) unsigned NOT NULL default '0', 127 127 `IP` varchar(15) NOT NULL default '', 128 128 `section` enum('categories','tags','search','list','favorites','most_visited','best_rated','recent_pics','recent_cats') default NULL, … … 200 200 `level` tinyint unsigned NOT NULL default '0', 201 201 `md5sum` char(32) default NULL, 202 `added_by` smallint(5)NOT NULL default '0',202 `added_by` mediumint(8) unsigned NOT NULL default '0', 203 203 `rotation` tinyint unsigned default NULL, 204 204 `latitude` double(8, 6) default NULL, … … 259 259 DROP TABLE IF EXISTS `piwigo_rate`; 260 260 CREATE TABLE `piwigo_rate` ( 261 `user_id` smallint(5)NOT NULL default '0',261 `user_id` mediumint(8) unsigned NOT NULL default '0', 262 262 `element_id` mediumint(8) unsigned NOT NULL default '0', 263 263 `anonymous_id` varchar(45) NOT NULL default '', … … 348 348 DROP TABLE IF EXISTS `piwigo_user_access`; 349 349 CREATE TABLE `piwigo_user_access` ( 350 `user_id` smallint(5)NOT NULL default '0',350 `user_id` mediumint(8) unsigned NOT NULL default '0', 351 351 `cat_id` smallint(5) unsigned NOT NULL default '0', 352 352 PRIMARY KEY (`user_id`,`cat_id`) … … 359 359 DROP TABLE IF EXISTS `piwigo_user_cache`; 360 360 CREATE TABLE `piwigo_user_cache` ( 361 `user_id` smallint(5)NOT NULL default '0',361 `user_id` mediumint(8) unsigned NOT NULL default '0', 362 362 `need_update` enum('true','false') NOT NULL default 'true', 363 363 `cache_update_time` integer unsigned NOT NULL default 0, … … 378 378 DROP TABLE IF EXISTS `piwigo_user_cache_categories`; 379 379 CREATE TABLE `piwigo_user_cache_categories` ( 380 `user_id` smallint(5)NOT NULL default '0',380 `user_id` mediumint(8) unsigned NOT NULL default '0', 381 381 `cat_id` smallint(5) unsigned NOT NULL default '0', 382 382 `date_last` datetime default NULL, … … 397 397 CREATE TABLE `piwigo_user_feed` ( 398 398 `id` varchar(50) binary NOT NULL default '', 399 `user_id` smallint(5)NOT NULL default '0',399 `user_id` mediumint(8) unsigned NOT NULL default '0', 400 400 `last_check` datetime default NULL, 401 401 PRIMARY KEY (`id`) … … 408 408 DROP TABLE IF EXISTS `piwigo_user_group`; 409 409 CREATE TABLE `piwigo_user_group` ( 410 `user_id` smallint(5)NOT NULL default '0',410 `user_id` mediumint(8) unsigned NOT NULL default '0', 411 411 `group_id` smallint(5) unsigned NOT NULL default '0', 412 412 PRIMARY KEY (`group_id`,`user_id`) … … 419 419 DROP TABLE IF EXISTS `piwigo_user_infos`; 420 420 CREATE TABLE `piwigo_user_infos` ( 421 `user_id` smallint(5)NOT NULL default '0',421 `user_id` mediumint(8) unsigned NOT NULL default '0', 422 422 `nb_image_page` smallint(3) unsigned NOT NULL default '15', 423 423 `status` enum('webmaster','admin','normal','generic','guest') NOT NULL default 'guest', … … 443 443 DROP TABLE IF EXISTS `piwigo_user_mail_notification`; 444 444 CREATE TABLE `piwigo_user_mail_notification` ( 445 `user_id` smallint(5)NOT NULL default '0',445 `user_id` mediumint(8) unsigned NOT NULL default '0', 446 446 `check_key` varchar(16) binary NOT NULL default '', 447 447 `enabled` enum('true','false') NOT NULL default 'false', … … 457 457 DROP TABLE IF EXISTS `piwigo_users`; 458 458 CREATE TABLE `piwigo_users` ( 459 `id` smallint(5)NOT NULL auto_increment,459 `id` mediumint(8) unsigned NOT NULL auto_increment, 460 460 `username` varchar(100) binary NOT NULL default '', 461 461 `password` varchar(255) default NULL,
Note: See TracChangeset
for help on using the changeset viewer.