Changeset 273
- Timestamp:
- Jan 11, 2004, 10:02:49 PM (20 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/release-1_3/admin/phpwebgallery_structure.sql
r149 r273 1 1 -- MySQL dump 8.21 2 2 -- 3 -- Host: localhost Database: devel3 -- Host: localhost Database: perfs_test 4 4 --------------------------------------------------------- 5 5 -- Server version 3.23.49-log … … 24 24 uploadable enum('true','false') NOT NULL default 'false', 25 25 representative_picture_id mediumint(8) unsigned default NULL, 26 PRIMARY KEY (id) 26 uppercats varchar(255) NOT NULL default '', 27 PRIMARY KEY (id), 28 KEY id (id), 29 KEY id_uppercat (id_uppercat) 27 30 ) TYPE=MyISAM; 28 31 … … 126 129 image_id mediumint(8) unsigned NOT NULL default '0', 127 130 category_id smallint(5) unsigned NOT NULL default '0', 128 PRIMARY KEY (image_id,category_id) 131 PRIMARY KEY (image_id,category_id), 132 KEY category_id (category_id), 133 KEY image_id (image_id) 129 134 ) TYPE=MyISAM; 130 135 … … 187 192 cat_id smallint(5) unsigned NOT NULL default '0', 188 193 PRIMARY KEY (user_id,cat_id) 194 ) TYPE=MyISAM; 195 196 -- 197 -- Table structure for table 'phpwebgallery_user_category' 198 -- 199 200 DROP TABLE IF EXISTS phpwebgallery_user_category; 201 CREATE TABLE phpwebgallery_user_category ( 202 user_id smallint(5) unsigned NOT NULL default '0', 203 category_id smallint(5) unsigned NOT NULL default '0', 204 date_last date default NULL, 205 nb_sub_categories smallint(5) unsigned NOT NULL default '0', 206 PRIMARY KEY (user_id,category_id) 189 207 ) TYPE=MyISAM; 190 208 … … 221 239 long_period tinyint(3) unsigned NOT NULL default '14', 222 240 template varchar(255) NOT NULL default 'default', 241 forbidden_categories text, 223 242 PRIMARY KEY (id), 224 243 UNIQUE KEY username (username)
Note: See TracChangeset
for help on using the changeset viewer.