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