[381] | 1 | -- MySQL dump 8.21 |
---|
| 2 | -- |
---|
| 3 | -- Host: localhost Database: pwg-bsf |
---|
| 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, |
---|
| 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', |
---|
[602] | 22 | site_id tinyint(4) unsigned default '1', |
---|
[381] | 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 | uppercats varchar(255) NOT NULL default '', |
---|
[602] | 27 | commentable enum('true','false') NOT NULL default 'true', |
---|
[381] | 28 | PRIMARY KEY (id), |
---|
| 29 | KEY categories_i2 (id_uppercat) |
---|
| 30 | ) TYPE=MyISAM; |
---|
| 31 | |
---|
| 32 | -- |
---|
| 33 | -- Table structure for table 'phpwebgallery_comments' |
---|
| 34 | -- |
---|
| 35 | |
---|
| 36 | DROP TABLE IF EXISTS phpwebgallery_comments; |
---|
| 37 | CREATE TABLE phpwebgallery_comments ( |
---|
| 38 | id int(11) unsigned NOT NULL auto_increment, |
---|
| 39 | image_id mediumint(8) unsigned NOT NULL default '0', |
---|
[420] | 40 | date datetime NOT NULL default '0000-00-00 00:00:00', |
---|
[381] | 41 | author varchar(255) default NULL, |
---|
| 42 | content longtext, |
---|
| 43 | validated enum('true','false') NOT NULL default 'false', |
---|
| 44 | PRIMARY KEY (id) |
---|
| 45 | ) TYPE=MyISAM; |
---|
| 46 | |
---|
| 47 | -- |
---|
| 48 | -- Table structure for table 'phpwebgallery_config' |
---|
| 49 | -- |
---|
| 50 | |
---|
| 51 | DROP TABLE IF EXISTS phpwebgallery_config; |
---|
| 52 | CREATE TABLE phpwebgallery_config ( |
---|
[385] | 53 | param varchar(40) NOT NULL default '', |
---|
| 54 | value varchar(255) default NULL, |
---|
| 55 | comment varchar(255) default NULL, |
---|
| 56 | PRIMARY KEY (param) |
---|
| 57 | ) TYPE=MyISAM COMMENT='configuration table'; |
---|
[381] | 58 | |
---|
| 59 | -- |
---|
| 60 | -- Table structure for table 'phpwebgallery_favorites' |
---|
| 61 | -- |
---|
| 62 | |
---|
| 63 | DROP TABLE IF EXISTS phpwebgallery_favorites; |
---|
| 64 | CREATE TABLE phpwebgallery_favorites ( |
---|
| 65 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
| 66 | image_id mediumint(8) unsigned NOT NULL default '0', |
---|
| 67 | PRIMARY KEY (user_id,image_id) |
---|
| 68 | ) TYPE=MyISAM; |
---|
| 69 | |
---|
| 70 | -- |
---|
| 71 | -- Table structure for table 'phpwebgallery_group_access' |
---|
| 72 | -- |
---|
| 73 | |
---|
| 74 | DROP TABLE IF EXISTS phpwebgallery_group_access; |
---|
| 75 | CREATE TABLE phpwebgallery_group_access ( |
---|
| 76 | group_id smallint(5) unsigned NOT NULL default '0', |
---|
| 77 | cat_id smallint(5) unsigned NOT NULL default '0', |
---|
| 78 | PRIMARY KEY (group_id,cat_id) |
---|
| 79 | ) TYPE=MyISAM; |
---|
| 80 | |
---|
| 81 | -- |
---|
| 82 | -- Table structure for table 'phpwebgallery_groups' |
---|
| 83 | -- |
---|
| 84 | |
---|
| 85 | DROP TABLE IF EXISTS phpwebgallery_groups; |
---|
| 86 | CREATE TABLE phpwebgallery_groups ( |
---|
| 87 | id smallint(5) unsigned NOT NULL auto_increment, |
---|
| 88 | name varchar(255) NOT NULL default '', |
---|
| 89 | PRIMARY KEY (id) |
---|
| 90 | ) TYPE=MyISAM; |
---|
| 91 | |
---|
| 92 | -- |
---|
| 93 | -- Table structure for table 'phpwebgallery_history' |
---|
| 94 | -- |
---|
| 95 | |
---|
| 96 | DROP TABLE IF EXISTS phpwebgallery_history; |
---|
| 97 | CREATE TABLE phpwebgallery_history ( |
---|
[537] | 98 | date datetime NOT NULL default '0000-00-00 00:00:00', |
---|
[381] | 99 | login varchar(15) default NULL, |
---|
| 100 | IP varchar(50) NOT NULL default '', |
---|
| 101 | category varchar(150) default NULL, |
---|
| 102 | file varchar(50) default NULL, |
---|
[537] | 103 | picture varchar(150) default NULL, |
---|
[602] | 104 | PRIMARY KEY (date) |
---|
[381] | 105 | ) TYPE=MyISAM; |
---|
| 106 | |
---|
| 107 | -- |
---|
| 108 | -- Table structure for table 'phpwebgallery_image_category' |
---|
| 109 | -- |
---|
| 110 | |
---|
| 111 | DROP TABLE IF EXISTS phpwebgallery_image_category; |
---|
| 112 | CREATE TABLE phpwebgallery_image_category ( |
---|
| 113 | image_id mediumint(8) unsigned NOT NULL default '0', |
---|
| 114 | category_id smallint(5) unsigned NOT NULL default '0', |
---|
| 115 | PRIMARY KEY (image_id,category_id), |
---|
| 116 | KEY image_category_i1 (image_id), |
---|
| 117 | KEY image_category_i2 (category_id) |
---|
| 118 | ) TYPE=MyISAM; |
---|
| 119 | |
---|
| 120 | -- |
---|
| 121 | -- Table structure for table 'phpwebgallery_images' |
---|
| 122 | -- |
---|
| 123 | |
---|
| 124 | DROP TABLE IF EXISTS phpwebgallery_images; |
---|
| 125 | CREATE TABLE phpwebgallery_images ( |
---|
| 126 | id mediumint(8) unsigned NOT NULL auto_increment, |
---|
| 127 | file varchar(255) NOT NULL default '', |
---|
| 128 | date_available date NOT NULL default '0000-00-00', |
---|
| 129 | date_creation date default NULL, |
---|
[474] | 130 | tn_ext varchar(4) default '', |
---|
[381] | 131 | name varchar(255) default NULL, |
---|
| 132 | comment text, |
---|
| 133 | author varchar(255) default NULL, |
---|
| 134 | hit int(10) unsigned NOT NULL default '0', |
---|
| 135 | filesize mediumint(9) unsigned default NULL, |
---|
| 136 | width smallint(9) unsigned default NULL, |
---|
| 137 | height smallint(9) unsigned default NULL, |
---|
| 138 | keywords varchar(255) default NULL, |
---|
| 139 | storage_category_id smallint(5) unsigned default NULL, |
---|
[474] | 140 | representative_ext varchar(4) default NULL, |
---|
[486] | 141 | date_metadata_update date default NULL, |
---|
[507] | 142 | average_rate float(5,2) unsigned default NULL, |
---|
[606] | 143 | path varchar(255) NOT NULL default '', |
---|
[381] | 144 | PRIMARY KEY (id), |
---|
[444] | 145 | KEY images_i2 (date_available), |
---|
[602] | 146 | KEY images_i1 (storage_category_id), |
---|
| 147 | KEY images_i3 (average_rate), |
---|
[612] | 148 | KEY images_i4 (hit), |
---|
| 149 | KEY images_i5 (date_creation) |
---|
[381] | 150 | ) TYPE=MyISAM; |
---|
| 151 | |
---|
| 152 | -- |
---|
[507] | 153 | -- Table structure for table 'phpwebgallery_rate' |
---|
| 154 | -- |
---|
| 155 | |
---|
| 156 | DROP TABLE IF EXISTS phpwebgallery_rate; |
---|
| 157 | CREATE TABLE phpwebgallery_rate ( |
---|
| 158 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
| 159 | element_id mediumint(8) unsigned NOT NULL default '0', |
---|
| 160 | rate tinyint(2) unsigned NOT NULL default '0', |
---|
| 161 | PRIMARY KEY (user_id,element_id) |
---|
| 162 | ) TYPE=MyISAM; |
---|
| 163 | |
---|
| 164 | -- |
---|
[381] | 165 | -- Table structure for table 'phpwebgallery_sessions' |
---|
| 166 | -- |
---|
| 167 | |
---|
| 168 | DROP TABLE IF EXISTS phpwebgallery_sessions; |
---|
| 169 | CREATE TABLE phpwebgallery_sessions ( |
---|
| 170 | id varchar(255) binary NOT NULL default '', |
---|
| 171 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
| 172 | expiration int(10) unsigned NOT NULL default '0', |
---|
| 173 | ip varchar(255) NOT NULL default '', |
---|
| 174 | PRIMARY KEY (id) |
---|
| 175 | ) TYPE=MyISAM; |
---|
| 176 | |
---|
| 177 | -- |
---|
| 178 | -- Table structure for table 'phpwebgallery_sites' |
---|
| 179 | -- |
---|
| 180 | |
---|
| 181 | DROP TABLE IF EXISTS phpwebgallery_sites; |
---|
| 182 | CREATE TABLE phpwebgallery_sites ( |
---|
| 183 | id tinyint(4) NOT NULL auto_increment, |
---|
| 184 | galleries_url varchar(255) NOT NULL default '', |
---|
| 185 | PRIMARY KEY (id), |
---|
| 186 | UNIQUE KEY sites_ui1 (galleries_url) |
---|
| 187 | ) TYPE=MyISAM; |
---|
| 188 | |
---|
| 189 | -- |
---|
| 190 | -- Table structure for table 'phpwebgallery_user_access' |
---|
| 191 | -- |
---|
| 192 | |
---|
| 193 | DROP TABLE IF EXISTS phpwebgallery_user_access; |
---|
| 194 | CREATE TABLE phpwebgallery_user_access ( |
---|
| 195 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
| 196 | cat_id smallint(5) unsigned NOT NULL default '0', |
---|
| 197 | PRIMARY KEY (user_id,cat_id) |
---|
| 198 | ) TYPE=MyISAM; |
---|
| 199 | |
---|
| 200 | -- |
---|
| 201 | -- Table structure for table 'phpwebgallery_user_group' |
---|
| 202 | -- |
---|
| 203 | |
---|
| 204 | DROP TABLE IF EXISTS phpwebgallery_user_group; |
---|
| 205 | CREATE TABLE phpwebgallery_user_group ( |
---|
| 206 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
| 207 | group_id smallint(5) unsigned NOT NULL default '0', |
---|
| 208 | PRIMARY KEY (group_id,user_id) |
---|
| 209 | ) TYPE=MyISAM; |
---|
| 210 | |
---|
| 211 | -- |
---|
| 212 | -- Table structure for table 'phpwebgallery_users' |
---|
| 213 | -- |
---|
| 214 | |
---|
| 215 | DROP TABLE IF EXISTS phpwebgallery_users; |
---|
| 216 | CREATE TABLE phpwebgallery_users ( |
---|
| 217 | id smallint(5) unsigned NOT NULL auto_increment, |
---|
| 218 | username varchar(20) binary NOT NULL default '', |
---|
| 219 | password varchar(255) NOT NULL default '', |
---|
| 220 | mail_address varchar(255) default NULL, |
---|
| 221 | nb_image_line tinyint(1) unsigned NOT NULL default '5', |
---|
| 222 | nb_line_page tinyint(3) unsigned NOT NULL default '3', |
---|
| 223 | status enum('admin','guest') NOT NULL default 'guest', |
---|
| 224 | language varchar(50) NOT NULL default 'english', |
---|
| 225 | maxwidth smallint(6) default NULL, |
---|
| 226 | maxheight smallint(6) default NULL, |
---|
| 227 | expand enum('true','false') NOT NULL default 'false', |
---|
| 228 | show_nb_comments enum('true','false') NOT NULL default 'false', |
---|
[474] | 229 | recent_period tinyint(3) unsigned NOT NULL default '7', |
---|
[381] | 230 | template varchar(255) NOT NULL default 'default', |
---|
| 231 | forbidden_categories text, |
---|
| 232 | PRIMARY KEY (id), |
---|
| 233 | UNIQUE KEY users_ui1 (username) |
---|
| 234 | ) TYPE=MyISAM; |
---|
| 235 | |
---|
| 236 | -- |
---|
| 237 | -- Table structure for table 'phpwebgallery_waiting' |
---|
| 238 | -- |
---|
| 239 | |
---|
| 240 | DROP TABLE IF EXISTS phpwebgallery_waiting; |
---|
| 241 | CREATE TABLE phpwebgallery_waiting ( |
---|
| 242 | id int(10) unsigned NOT NULL auto_increment, |
---|
| 243 | storage_category_id smallint(5) unsigned NOT NULL default '0', |
---|
| 244 | file varchar(255) NOT NULL default '', |
---|
| 245 | username varchar(255) NOT NULL default '', |
---|
| 246 | mail_address varchar(255) NOT NULL default '', |
---|
| 247 | date int(10) unsigned NOT NULL default '0', |
---|
| 248 | tn_ext char(3) default NULL, |
---|
| 249 | validated enum('true','false') NOT NULL default 'false', |
---|
| 250 | infos text, |
---|
| 251 | PRIMARY KEY (id) |
---|
| 252 | ) TYPE=MyISAM; |
---|
| 253 | |
---|