Changeset 9086
- Timestamp:
- Feb 3, 2011, 10:59:51 PM (13 years ago)
- Location:
- trunk/install
- Files:
-
- 6 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/install/db/85-database.php
r8728 r9086 35 35 `name` varchar(64) default NULL, 36 36 PRIMARY KEY (`id`) 37 ) ";37 ) ENGINE=MyISAM"; 38 38 39 39 if (DB_CHARSET == 'utf8') -
trunk/install/db/90-database.php
r8728 r9086 35 35 `name` varchar(64) default NULL, 36 36 PRIMARY KEY (`id`) 37 ) ";37 ) ENGINE=MyISAM"; 38 38 39 39 if (DB_CHARSET == 'utf8') -
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; -
trunk/install/upgrade_1.3.1.php
r8728 r9086 56 56 comment varchar(255) default NULL, 57 57 PRIMARY KEY (param) 58 ) TYPE=MyISAM COMMENT='configuration table'58 ) ENGINE=MyISAM COMMENT='configuration table' 59 59 ;", 60 60 … … 280 280 rate tinyint(2) unsigned NOT NULL default '0', 281 281 PRIMARY KEY (user_id,element_id) 282 ) TYPE=MyISAM282 ) ENGINE=MyISAM 283 283 ;", 284 284 … … 289 289 forbidden_categories text, 290 290 PRIMARY KEY (user_id) 291 ) TYPE=MyISAM291 ) ENGINE=MyISAM 292 292 ;", 293 293 -
trunk/install/upgrade_1.4.0.php
r8728 r9086 139 139 element_id mediumint(8) NOT NULL default '0', 140 140 PRIMARY KEY (user_id,element_id) 141 ) TYPE=MyISAM141 ) ENGINE=MyISAM 142 142 ;", 143 143 … … 148 148 forbidden_categories text, 149 149 PRIMARY KEY (user_id) 150 ) TYPE=MyISAM150 ) ENGINE=MyISAM 151 151 ;", 152 152 … … 157 157 last_check datetime default NULL, 158 158 PRIMARY KEY (id) 159 ) TYPE=MyISAM159 ) ENGINE=MyISAM 160 160 ;", 161 161 … … 175 175 registration_date datetime NOT NULL default '0000-00-00 00:00:00', 176 176 UNIQUE KEY user_infos_ui1 (user_id) 177 ) TYPE=MyISAM177 ) ENGINE=MyISAM 178 178 ;" 179 179 ); -
trunk/install/upgrade_1.6.2.php
r8728 r9086 78 78 PRIMARY KEY (`id`), 79 79 KEY `history_i1` (`summarized`) 80 ) TYPE=MyISAM80 ) ENGINE=MyISAM 81 81 ;", 82 82 … … 136 136 `nb_pages` int(11) default NULL, 137 137 PRIMARY KEY (`id`) 138 ) TYPE=MyISAM138 ) ENGINE=MyISAM 139 139 ;", 140 140 … … 147 147 `hit` int(10) unsigned NOT NULL default '0', 148 148 PRIMARY KEY (`permalink`) 149 ) TYPE=MyISAM149 ) ENGINE=MyISAM 150 150 ;", 151 151 … … 156 156 `version` varchar(64) NOT NULL default '0', 157 157 PRIMARY KEY (`id`) 158 ) TYPE=MyISAM158 ) ENGINE=MyISAM 159 159 ;", 160 160 … … 167 167 `count_categories` mediumint(8) unsigned default '0', 168 168 PRIMARY KEY (`user_id`,`cat_id`) 169 ) TYPE=MyISAM169 ) ENGINE=MyISAM 170 170 ;", 171 171 … … 183 183 PRIMARY KEY (`id`), 184 184 UNIQUE KEY `ws_access_ui1` (`name`) 185 ) TYPE=MyISAM COMMENT='Access for Web Services'185 ) ENGINE=MyISAM COMMENT='Access for Web Services' 186 186 ;",*/ 187 187
Note: See TracChangeset
for help on using the changeset viewer.