Changeset 1064 for trunk/install/phpwebgallery_structure.sql
- Timestamp:
- Mar 5, 2006, 12:31:46 AM (18 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/install/phpwebgallery_structure.sql
r1041 r1064 1 -- MySQL dump 10.92 -- 3 -- Host: localhost Database: pwg _dev_bsf1 -- MySQL dump 9.11 2 -- 3 -- Host: localhost Database: pwg-bsf 4 4 -- ------------------------------------------------------ 5 -- Server version 4. 1.15-nt5 -- Server version 4.0.24_Debian-10-log 6 6 7 7 -- … … 43 43 44 44 -- 45 -- Table structure for table `phpwebgallery_categories_link` 46 -- 47 48 DROP TABLE IF EXISTS `phpwebgallery_categories_link`; 49 CREATE TABLE `phpwebgallery_categories_link` ( 50 `source` smallint(5) unsigned NOT NULL default '0', 51 `destination` smallint(5) unsigned NOT NULL default '0', 52 PRIMARY KEY (`source`,`destination`) 53 ) TYPE=MyISAM; 54 55 -- 45 56 -- Table structure for table `phpwebgallery_comments` 46 57 -- … … 128 139 `image_id` mediumint(8) unsigned NOT NULL default '0', 129 140 `category_id` smallint(5) unsigned NOT NULL default '0', 141 `is_storage` enum('true','false') default 'false', 130 142 PRIMARY KEY (`image_id`,`category_id`), 131 143 KEY `image_category_i1` (`image_id`), … … 296 308 297 309 -- 310 -- Table structure for table `phpwebgallery_user_mail_notification` 311 -- 312 313 DROP TABLE IF EXISTS `phpwebgallery_user_mail_notification`; 314 CREATE TABLE `phpwebgallery_user_mail_notification` ( 315 `user_id` smallint(5) NOT NULL default '0', 316 `check_key` varchar(128) binary NOT NULL default '', 317 `enabled` enum('true','false') NOT NULL default 'false', 318 `last_send` datetime default NULL, 319 PRIMARY KEY (`user_id`), 320 UNIQUE KEY `uidx_check_key` (`check_key`) 321 ) TYPE=MyISAM; 322 323 -- 298 324 -- Table structure for table `phpwebgallery_users` 299 325 -- … … 327 353 ) TYPE=MyISAM; 328 354 329 --330 -- Table structure for table `phpwebgallery_user_mail_notification`331 --332 333 DROP TABLE IF EXISTS `phpwebgallery_user_mail_notification`;334 CREATE TABLE `phpwebgallery_user_mail_notification`335 (336 `user_id` smallint(5) NOT NULL default '0',337 `check_key` varchar(128) binary NOT NULL,338 `enabled` enum('true','false') NOT NULL default 'false',339 `last_send` datetime default NULL,340 PRIMARY KEY (`user_id`),341 UNIQUE KEY `uidx_check_key` (`check_key`)342 ) TYPE=MyISAM;
Note: See TracChangeset
for help on using the changeset viewer.