Changeset 265
- Timestamp:
- Jan 6, 2004, 1:00:01 AM (20 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/phpwebgallery_structure.sql
r149 r265 1 -- MySQL dump 8.212 --3 -- Host: localhost Database: devel4 ---------------------------------------------------------5 -- Server version 3.23.49-log6 7 --8 -- Table structure for table 'phpwebgallery_categories'9 --10 11 DROP TABLE IF EXISTS phpwebgallery_categories;12 CREATE TABLE phpwebgallery_categories (13 id smallint(5) unsigned NOT NULL auto_increment,14 date_last date default NULL,15 nb_images mediumint(8) unsigned NOT NULL default '0',16 name varchar(255) NOT NULL default '',17 id_uppercat smallint(5) unsigned default NULL,18 comment text,19 dir varchar(255) default NULL,20 rank tinyint(3) unsigned default NULL,21 status enum('public','private') NOT NULL default 'public',22 site_id tinyint(4) unsigned NOT NULL default '1',23 visible enum('true','false') NOT NULL default 'true',24 uploadable enum('true','false') NOT NULL default 'false',25 representative_picture_id mediumint(8) unsigned default NULL,26 PRIMARY KEY (id)27 ) TYPE=MyISAM;28 29 --30 -- Table structure for table 'phpwebgallery_comments'31 --32 33 DROP TABLE IF EXISTS phpwebgallery_comments;34 CREATE TABLE phpwebgallery_comments (35 id int(11) unsigned NOT NULL auto_increment,36 image_id mediumint(8) unsigned NOT NULL default '0',37 date int(11) unsigned NOT NULL default '0',38 author varchar(255) default NULL,39 content longtext,40 validated enum('true','false') NOT NULL default 'false',41 PRIMARY KEY (id)42 ) TYPE=MyISAM;43 44 --45 -- Table structure for table 'phpwebgallery_config'46 --47 48 DROP TABLE IF EXISTS phpwebgallery_config;49 CREATE TABLE phpwebgallery_config (50 prefix_thumbnail varchar(10) default 'TN-',51 webmaster varchar(255) NOT NULL default '',52 mail_webmaster varchar(255) NOT NULL default '',53 access enum('free','restricted') default 'free',54 session_id_size tinyint(3) unsigned NOT NULL default '4',55 session_keyword varchar(255) default NULL,56 session_time tinyint(3) unsigned NOT NULL default '30',57 max_user_listbox tinyint(3) unsigned NOT NULL default '10',58 show_comments enum('true','false') NOT NULL default 'true',59 nb_comment_page tinyint(4) NOT NULL default '10',60 upload_available enum('true','false') NOT NULL default 'false',61 upload_maxfilesize smallint(5) unsigned NOT NULL default '150',62 upload_maxwidth smallint(5) unsigned NOT NULL default '800',63 upload_maxheight smallint(5) unsigned NOT NULL default '600',64 upload_maxwidth_thumbnail smallint(5) unsigned NOT NULL default '150',65 upload_maxheight_thumbnail smallint(5) unsigned NOT NULL default '100',66 log enum('true','false') NOT NULL default 'false',67 comments_validation enum('true','false') NOT NULL default 'false',68 comments_forall enum('true','false') NOT NULL default 'false',69 authorize_cookies enum('true','false') NOT NULL default 'false',70 mail_notification enum('true','false') NOT NULL default 'false'71 ) TYPE=MyISAM;72 73 --74 -- Table structure for table 'phpwebgallery_favorites'75 --76 77 DROP TABLE IF EXISTS phpwebgallery_favorites;78 CREATE TABLE phpwebgallery_favorites (79 user_id smallint(5) unsigned NOT NULL default '0',80 image_id mediumint(8) unsigned NOT NULL default '0',81 KEY user_id (user_id,image_id)82 ) TYPE=MyISAM;83 84 --85 -- Table structure for table 'phpwebgallery_group_access'86 --87 88 DROP TABLE IF EXISTS phpwebgallery_group_access;89 CREATE TABLE phpwebgallery_group_access (90 group_id smallint(5) unsigned NOT NULL default '0',91 cat_id smallint(5) unsigned NOT NULL default '0',92 PRIMARY KEY (group_id,cat_id)93 ) TYPE=MyISAM;94 95 --96 -- Table structure for table 'phpwebgallery_groups'97 --98 99 DROP TABLE IF EXISTS phpwebgallery_groups;100 CREATE TABLE phpwebgallery_groups (101 id smallint(5) unsigned NOT NULL auto_increment,102 name varchar(255) NOT NULL default '',103 PRIMARY KEY (id)104 ) TYPE=MyISAM;105 106 --107 -- Table structure for table 'phpwebgallery_history'108 --109 110 DROP TABLE IF EXISTS phpwebgallery_history;111 CREATE TABLE phpwebgallery_history (112 date int(11) NOT NULL default '0',113 login varchar(15) default NULL,114 IP varchar(50) NOT NULL default '',115 category varchar(150) default NULL,116 file varchar(50) default NULL,117 picture varchar(150) default NULL118 ) TYPE=MyISAM;119 120 --121 -- Table structure for table 'phpwebgallery_image_category'122 --123 124 DROP TABLE IF EXISTS phpwebgallery_image_category;125 CREATE TABLE phpwebgallery_image_category (126 image_id mediumint(8) unsigned NOT NULL default '0',127 category_id smallint(5) unsigned NOT NULL default '0',128 PRIMARY KEY (image_id,category_id)129 ) TYPE=MyISAM;130 131 --132 -- Table structure for table 'phpwebgallery_images'133 --134 135 DROP TABLE IF EXISTS phpwebgallery_images;136 CREATE TABLE phpwebgallery_images (137 id mediumint(8) unsigned NOT NULL auto_increment,138 file varchar(255) NOT NULL default '',139 date_available date NOT NULL default '0000-00-00',140 date_creation date default NULL,141 tn_ext char(3) NOT NULL default 'jpg',142 name varchar(255) default NULL,143 comment text,144 author varchar(255) default NULL,145 hit int(10) unsigned NOT NULL default '0',146 filesize mediumint(9) unsigned default NULL,147 width smallint(9) unsigned default NULL,148 height smallint(9) unsigned default NULL,149 keywords varchar(255) default NULL,150 storage_category_id smallint(5) unsigned default NULL,151 PRIMARY KEY (id),152 KEY storage_category_id (storage_category_id)153 ) TYPE=MyISAM;154 155 --156 -- Table structure for table 'phpwebgallery_sessions'157 --158 159 DROP TABLE IF EXISTS phpwebgallery_sessions;160 CREATE TABLE phpwebgallery_sessions (161 id varchar(255) binary NOT NULL default '',162 user_id smallint(5) unsigned NOT NULL default '0',163 expiration int(10) unsigned NOT NULL default '0',164 ip varchar(255) NOT NULL default '',165 PRIMARY KEY (id)166 ) TYPE=MyISAM;167 168 --169 -- Table structure for table 'phpwebgallery_sites'170 --171 172 DROP TABLE IF EXISTS phpwebgallery_sites;173 CREATE TABLE phpwebgallery_sites (174 id tinyint(4) NOT NULL auto_increment,175 galleries_url varchar(255) NOT NULL default '',176 PRIMARY KEY (id),177 UNIQUE KEY galleries_url (galleries_url)178 ) TYPE=MyISAM;179 180 --181 -- Table structure for table 'phpwebgallery_user_access'182 --183 184 DROP TABLE IF EXISTS phpwebgallery_user_access;185 CREATE TABLE phpwebgallery_user_access (186 user_id smallint(5) unsigned NOT NULL default '0',187 cat_id smallint(5) unsigned NOT NULL default '0',188 PRIMARY KEY (user_id,cat_id)189 ) TYPE=MyISAM;190 191 --192 -- Table structure for table 'phpwebgallery_user_group'193 --194 195 DROP TABLE IF EXISTS phpwebgallery_user_group;196 CREATE TABLE phpwebgallery_user_group (197 user_id smallint(5) unsigned NOT NULL default '0',198 group_id smallint(5) unsigned NOT NULL default '0',199 PRIMARY KEY (group_id,user_id)200 ) TYPE=MyISAM;201 202 --203 -- Table structure for table 'phpwebgallery_users'204 --205 206 DROP TABLE IF EXISTS phpwebgallery_users;207 CREATE TABLE phpwebgallery_users (208 id smallint(5) unsigned NOT NULL auto_increment,209 username varchar(20) binary NOT NULL default '',210 password varchar(255) NOT NULL default '',211 mail_address varchar(255) default NULL,212 nb_image_line tinyint(1) unsigned NOT NULL default '5',213 nb_line_page tinyint(3) unsigned NOT NULL default '3',214 status enum('admin','guest') NOT NULL default 'guest',215 language varchar(50) NOT NULL default 'english',216 maxwidth smallint(6) default NULL,217 maxheight smallint(6) default NULL,218 expand enum('true','false') NOT NULL default 'false',219 show_nb_comments enum('true','false') NOT NULL default 'false',220 short_period tinyint(3) unsigned NOT NULL default '7',221 long_period tinyint(3) unsigned NOT NULL default '14',222 template varchar(255) NOT NULL default 'default',223 PRIMARY KEY (id),224 UNIQUE KEY username (username)225 ) TYPE=MyISAM;226 227 --228 -- Table structure for table 'phpwebgallery_waiting'229 --230 231 DROP TABLE IF EXISTS phpwebgallery_waiting;232 CREATE TABLE phpwebgallery_waiting (233 id int(10) unsigned NOT NULL auto_increment,234 storage_category_id smallint(5) unsigned NOT NULL default '0',235 file varchar(255) NOT NULL default '',236 username varchar(255) NOT NULL default '',237 mail_address varchar(255) NOT NULL default '',238 date int(10) unsigned NOT NULL default '0',239 tn_ext char(3) default NULL,240 validated enum('true','false') NOT NULL default 'false',241 infos text,242 PRIMARY KEY (id)243 ) TYPE=MyISAM;244
Note: See TracChangeset
for help on using the changeset viewer.