Changeset 9086 for trunk/install/piwigo_structure-mysql.sql
- Timestamp:
- Feb 3, 2011, 10:59:51 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/install/piwigo_structure-mysql.sql
r9073 r9086 14 14 `element_id` mediumint(8) NOT NULL default '0', 15 15 PRIMARY KEY (`user_id`,`element_id`) 16 ) TYPE=MyISAM;16 ) ENGINE=MyISAM; 17 17 18 18 -- … … 40 40 UNIQUE KEY `categories_i3` (`permalink`), 41 41 KEY `categories_i2` (`id_uppercat`) 42 ) TYPE=MyISAM;42 ) ENGINE=MyISAM; 43 43 44 44 -- … … 59 59 KEY `comments_i2` (`validation_date`), 60 60 KEY `comments_i1` (`image_id`) 61 ) TYPE=MyISAM;61 ) ENGINE=MyISAM; 62 62 63 63 -- … … 71 71 `comment` varchar(255) default NULL, 72 72 PRIMARY KEY (`param`) 73 ) TYPE=MyISAM COMMENT='configuration table';73 ) ENGINE=MyISAM COMMENT='configuration table'; 74 74 75 75 -- … … 82 82 `image_id` mediumint(8) unsigned NOT NULL default '0', 83 83 PRIMARY KEY (`user_id`,`image_id`) 84 ) TYPE=MyISAM;84 ) ENGINE=MyISAM; 85 85 86 86 -- … … 93 93 `cat_id` smallint(5) unsigned NOT NULL default '0', 94 94 PRIMARY KEY (`group_id`,`cat_id`) 95 ) TYPE=MyISAM;95 ) ENGINE=MyISAM; 96 96 97 97 -- … … 106 106 PRIMARY KEY (`id`), 107 107 UNIQUE KEY `groups_ui1` (`name`) 108 ) TYPE=MyISAM;108 ) ENGINE=MyISAM; 109 109 110 110 -- … … 127 127 PRIMARY KEY (`id`), 128 128 KEY `history_i1` (`summarized`) 129 ) TYPE=MyISAM;129 ) ENGINE=MyISAM; 130 130 131 131 -- … … 141 141 `nb_pages` int(11) default NULL, 142 142 UNIQUE KEY history_summary_ymdh (`year`,`month`,`day`,`hour`) 143 ) TYPE=MyISAM;143 ) ENGINE=MyISAM; 144 144 145 145 -- … … 154 154 PRIMARY KEY (`image_id`,`category_id`), 155 155 KEY `image_category_i1` (`category_id`) 156 ) TYPE=MyISAM;156 ) ENGINE=MyISAM; 157 157 158 158 -- … … 166 166 PRIMARY KEY (`image_id`,`tag_id`), 167 167 KEY `image_tag_i1` (`tag_id`) 168 ) TYPE=MyISAM;168 ) ENGINE=MyISAM; 169 169 170 170 -- … … 202 202 KEY `images_i5` (`date_creation`), 203 203 KEY `images_i1` (`storage_category_id`) 204 ) TYPE=MyISAM;204 ) ENGINE=MyISAM; 205 205 206 206 -- … … 214 214 `name` varchar(64) default NULL, 215 215 PRIMARY KEY (`id`) 216 ) TYPE=MyISAM;216 ) ENGINE=MyISAM; 217 217 218 218 -- … … 228 228 `hit` int(10) unsigned NOT NULL default '0', 229 229 PRIMARY KEY (`permalink`) 230 ) TYPE=MyISAM;230 ) ENGINE=MyISAM; 231 231 232 232 -- … … 240 240 `version` varchar(64) NOT NULL default '0', 241 241 PRIMARY KEY (`id`) 242 ) TYPE=MyISAM;242 ) ENGINE=MyISAM; 243 243 244 244 -- … … 254 254 `date` date NOT NULL default '0000-00-00', 255 255 PRIMARY KEY (`element_id`,`user_id`,`anonymous_id`) 256 ) TYPE=MyISAM;256 ) ENGINE=MyISAM; 257 257 258 258 -- … … 266 266 `rules` text, 267 267 PRIMARY KEY (`id`) 268 ) TYPE=MyISAM;268 ) ENGINE=MyISAM; 269 269 270 270 -- … … 278 278 `expiration` datetime NOT NULL default '0000-00-00 00:00:00', 279 279 PRIMARY KEY (`id`) 280 ) TYPE=MyISAM;280 ) ENGINE=MyISAM; 281 281 282 282 -- … … 290 290 PRIMARY KEY (`id`), 291 291 UNIQUE KEY `sites_ui1` (`galleries_url`) 292 ) TYPE=MyISAM;292 ) ENGINE=MyISAM; 293 293 294 294 -- … … 303 303 PRIMARY KEY (`id`), 304 304 KEY `tags_i1` (`url_name`) 305 ) TYPE=MyISAM;305 ) ENGINE=MyISAM; 306 306 307 307 -- … … 315 315 `name` varchar(64) default NULL, 316 316 PRIMARY KEY (`id`) 317 ) TYPE=MyISAM;317 ) ENGINE=MyISAM; 318 318 319 319 -- … … 327 327 `description` varchar(255) default NULL, 328 328 PRIMARY KEY (`id`) 329 ) TYPE=MyISAM;329 ) ENGINE=MyISAM; 330 330 331 331 -- … … 338 338 `cat_id` smallint(5) unsigned NOT NULL default '0', 339 339 PRIMARY KEY (`user_id`,`cat_id`) 340 ) TYPE=MyISAM;340 ) ENGINE=MyISAM; 341 341 342 342 -- … … 354 354 `image_access_list` mediumtext default NULL, 355 355 PRIMARY KEY (`user_id`) 356 ) TYPE=MyISAM;356 ) ENGINE=MyISAM; 357 357 358 358 -- … … 371 371 `user_representative_picture_id` mediumint(8) unsigned default NULL, 372 372 PRIMARY KEY (`user_id`,`cat_id`) 373 ) TYPE=MyISAM;373 ) ENGINE=MyISAM; 374 374 375 375 -- … … 383 383 `last_check` datetime default NULL, 384 384 PRIMARY KEY (`id`) 385 ) TYPE=MyISAM;385 ) ENGINE=MyISAM; 386 386 387 387 -- … … 394 394 `group_id` smallint(5) unsigned NOT NULL default '0', 395 395 PRIMARY KEY (`group_id`,`user_id`) 396 ) TYPE=MyISAM;396 ) ENGINE=MyISAM; 397 397 398 398 -- … … 418 418 `level` tinyint unsigned NOT NULL default '0', 419 419 UNIQUE KEY `user_infos_ui1` (`user_id`) 420 ) TYPE=MyISAM;420 ) ENGINE=MyISAM; 421 421 422 422 -- … … 432 432 PRIMARY KEY (`user_id`), 433 433 UNIQUE KEY `user_mail_notification_ui1` (`check_key`) 434 ) TYPE=MyISAM;434 ) ENGINE=MyISAM; 435 435 436 436 -- … … 446 446 PRIMARY KEY (`id`), 447 447 UNIQUE KEY `users_ui1` (`username`) 448 ) TYPE=MyISAM;448 ) ENGINE=MyISAM;
Note: See TracChangeset
for help on using the changeset viewer.