Changeset 58
- Timestamp:
- Aug 25, 2003, 1:00:01 AM (21 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/phpwebgallery_structure.sql
r43 r58 14 14 date_last date NOT NULL default '0000-00-00', 15 15 nb_images mediumint(8) unsigned NOT NULL default '0', 16 name varchar(255) default NULL,16 name varchar(255) NOT NULL default '', 17 17 id_uppercat smallint(5) unsigned default NULL, 18 18 comment text, 19 dir varchar(255) NOT NULL default '',19 dir varchar(255) default NULL, 20 20 rank tinyint(3) unsigned default NULL, 21 21 status enum('public','private') NOT NULL default 'public', … … 117 117 118 118 -- 119 -- Table structure for table 'phpwebgallery_image_category' 120 -- 121 122 DROP TABLE IF EXISTS phpwebgallery_image_category; 123 CREATE TABLE phpwebgallery_image_category ( 124 image_id mediumint(8) unsigned NOT NULL default '0', 125 category_id smallint(5) unsigned NOT NULL default '0', 126 PRIMARY KEY (image_id,category_id) 127 ) TYPE=MyISAM; 128 129 -- 119 130 -- Table structure for table 'phpwebgallery_images' 120 131 -- … … 124 135 id mediumint(8) unsigned NOT NULL auto_increment, 125 136 file varchar(255) NOT NULL default '', 126 cat_id smallint(5) unsigned NOT NULL default '0',127 137 date_available date NOT NULL default '0000-00-00', 128 138 date_creation date default NULL, … … 136 146 height smallint(9) unsigned default NULL, 137 147 keywords varchar(255) default NULL, 138 PRIMARY KEY (id),139 KEY cat_id (cat_id)148 storage_category_id smallint(5) unsigned default NULL, 149 PRIMARY KEY (id) 140 150 ) TYPE=MyISAM; 141 151
Note: See TracChangeset
for help on using the changeset viewer.