[801] | 1 | -- MySQL dump 9.11 |
---|
[381] | 2 | -- |
---|
| 3 | -- Host: localhost Database: pwg-bsf |
---|
[801] | 4 | -- ------------------------------------------------------ |
---|
| 5 | -- Server version 4.0.24_Debian-10-log |
---|
[381] | 6 | |
---|
| 7 | -- |
---|
[801] | 8 | -- Table structure for table `phpwebgallery_caddie` |
---|
[757] | 9 | -- |
---|
| 10 | |
---|
[801] | 11 | DROP TABLE IF EXISTS `phpwebgallery_caddie`; |
---|
| 12 | CREATE TABLE `phpwebgallery_caddie` ( |
---|
| 13 | `user_id` smallint(5) NOT NULL default '0', |
---|
| 14 | `element_id` mediumint(8) NOT NULL default '0', |
---|
| 15 | PRIMARY KEY (`user_id`,`element_id`) |
---|
[757] | 16 | ) TYPE=MyISAM; |
---|
| 17 | |
---|
| 18 | -- |
---|
[801] | 19 | -- Table structure for table `phpwebgallery_categories` |
---|
[381] | 20 | -- |
---|
| 21 | |
---|
[801] | 22 | DROP TABLE IF EXISTS `phpwebgallery_categories`; |
---|
| 23 | CREATE TABLE `phpwebgallery_categories` ( |
---|
| 24 | `id` smallint(5) unsigned NOT NULL auto_increment, |
---|
| 25 | `date_last` datetime default NULL, |
---|
| 26 | `nb_images` mediumint(8) unsigned NOT NULL default '0', |
---|
| 27 | `name` varchar(255) NOT NULL default '', |
---|
| 28 | `id_uppercat` smallint(5) unsigned default NULL, |
---|
| 29 | `comment` text, |
---|
| 30 | `dir` varchar(255) default NULL, |
---|
| 31 | `rank` tinyint(3) unsigned default NULL, |
---|
| 32 | `status` enum('public','private') NOT NULL default 'public', |
---|
| 33 | `site_id` tinyint(4) unsigned default '1', |
---|
| 34 | `visible` enum('true','false') NOT NULL default 'true', |
---|
| 35 | `uploadable` enum('true','false') NOT NULL default 'false', |
---|
| 36 | `representative_picture_id` mediumint(8) unsigned default NULL, |
---|
| 37 | `uppercats` varchar(255) NOT NULL default '', |
---|
| 38 | `commentable` enum('true','false') NOT NULL default 'true', |
---|
| 39 | `global_rank` varchar(255) default NULL, |
---|
| 40 | PRIMARY KEY (`id`), |
---|
| 41 | KEY `categories_i2` (`id_uppercat`) |
---|
[381] | 42 | ) TYPE=MyISAM; |
---|
| 43 | |
---|
| 44 | -- |
---|
[801] | 45 | -- Table structure for table `phpwebgallery_comments` |
---|
[381] | 46 | -- |
---|
| 47 | |
---|
[801] | 48 | DROP TABLE IF EXISTS `phpwebgallery_comments`; |
---|
| 49 | CREATE TABLE `phpwebgallery_comments` ( |
---|
| 50 | `id` int(11) unsigned NOT NULL auto_increment, |
---|
| 51 | `image_id` mediumint(8) unsigned NOT NULL default '0', |
---|
| 52 | `date` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
| 53 | `author` varchar(255) default NULL, |
---|
| 54 | `content` longtext, |
---|
| 55 | `validated` enum('true','false') NOT NULL default 'false', |
---|
| 56 | `validation_date` datetime default NULL, |
---|
| 57 | PRIMARY KEY (`id`), |
---|
| 58 | KEY `comments_i2` (`validation_date`), |
---|
| 59 | KEY `comments_i1` (`image_id`) |
---|
[381] | 60 | ) TYPE=MyISAM; |
---|
| 61 | |
---|
| 62 | -- |
---|
[801] | 63 | -- Table structure for table `phpwebgallery_config` |
---|
[381] | 64 | -- |
---|
| 65 | |
---|
[801] | 66 | DROP TABLE IF EXISTS `phpwebgallery_config`; |
---|
| 67 | CREATE TABLE `phpwebgallery_config` ( |
---|
| 68 | `param` varchar(40) NOT NULL default '', |
---|
| 69 | `value` varchar(255) default NULL, |
---|
| 70 | `comment` varchar(255) default NULL, |
---|
| 71 | PRIMARY KEY (`param`) |
---|
[385] | 72 | ) TYPE=MyISAM COMMENT='configuration table'; |
---|
[381] | 73 | |
---|
| 74 | -- |
---|
[801] | 75 | -- Table structure for table `phpwebgallery_favorites` |
---|
[381] | 76 | -- |
---|
| 77 | |
---|
[801] | 78 | DROP TABLE IF EXISTS `phpwebgallery_favorites`; |
---|
| 79 | CREATE TABLE `phpwebgallery_favorites` ( |
---|
[858] | 80 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 81 | `image_id` mediumint(8) unsigned NOT NULL default '0', |
---|
| 82 | PRIMARY KEY (`user_id`,`image_id`) |
---|
[381] | 83 | ) TYPE=MyISAM; |
---|
| 84 | |
---|
| 85 | -- |
---|
[801] | 86 | -- Table structure for table `phpwebgallery_group_access` |
---|
[381] | 87 | -- |
---|
| 88 | |
---|
[801] | 89 | DROP TABLE IF EXISTS `phpwebgallery_group_access`; |
---|
| 90 | CREATE TABLE `phpwebgallery_group_access` ( |
---|
| 91 | `group_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 92 | `cat_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 93 | PRIMARY KEY (`group_id`,`cat_id`) |
---|
[381] | 94 | ) TYPE=MyISAM; |
---|
| 95 | |
---|
| 96 | -- |
---|
[801] | 97 | -- Table structure for table `phpwebgallery_groups` |
---|
[381] | 98 | -- |
---|
| 99 | |
---|
[801] | 100 | DROP TABLE IF EXISTS `phpwebgallery_groups`; |
---|
| 101 | CREATE TABLE `phpwebgallery_groups` ( |
---|
| 102 | `id` smallint(5) unsigned NOT NULL auto_increment, |
---|
| 103 | `name` varchar(255) NOT NULL default '', |
---|
| 104 | PRIMARY KEY (`id`) |
---|
[381] | 105 | ) TYPE=MyISAM; |
---|
| 106 | |
---|
| 107 | -- |
---|
[801] | 108 | -- Table structure for table `phpwebgallery_history` |
---|
[381] | 109 | -- |
---|
| 110 | |
---|
[801] | 111 | DROP TABLE IF EXISTS `phpwebgallery_history`; |
---|
| 112 | CREATE TABLE `phpwebgallery_history` ( |
---|
| 113 | `date` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
| 114 | `login` varchar(15) default NULL, |
---|
| 115 | `IP` varchar(50) NOT NULL default '', |
---|
| 116 | `category` varchar(150) default NULL, |
---|
| 117 | `file` varchar(50) default NULL, |
---|
| 118 | `picture` varchar(150) default NULL, |
---|
| 119 | KEY `history_i1` (`date`) |
---|
[381] | 120 | ) TYPE=MyISAM; |
---|
| 121 | |
---|
| 122 | -- |
---|
[801] | 123 | -- Table structure for table `phpwebgallery_image_category` |
---|
[381] | 124 | -- |
---|
| 125 | |
---|
[801] | 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', |
---|
| 130 | PRIMARY KEY (`image_id`,`category_id`), |
---|
| 131 | KEY `image_category_i1` (`image_id`), |
---|
| 132 | KEY `image_category_i2` (`category_id`) |
---|
[381] | 133 | ) TYPE=MyISAM; |
---|
| 134 | |
---|
| 135 | -- |
---|
[801] | 136 | -- Table structure for table `phpwebgallery_images` |
---|
[381] | 137 | -- |
---|
| 138 | |
---|
[801] | 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` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
| 144 | `date_creation` date default NULL, |
---|
| 145 | `tn_ext` varchar(4) default '', |
---|
| 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, |
---|
| 154 | `storage_category_id` smallint(5) unsigned default NULL, |
---|
| 155 | `representative_ext` varchar(4) default NULL, |
---|
| 156 | `date_metadata_update` date default NULL, |
---|
| 157 | `average_rate` float(5,2) unsigned default NULL, |
---|
| 158 | `path` varchar(255) NOT NULL default '', |
---|
| 159 | PRIMARY KEY (`id`), |
---|
| 160 | KEY `images_i2` (`date_available`), |
---|
| 161 | KEY `images_i1` (`storage_category_id`), |
---|
| 162 | KEY `images_i3` (`average_rate`), |
---|
| 163 | KEY `images_i4` (`hit`), |
---|
| 164 | KEY `images_i5` (`date_creation`) |
---|
[381] | 165 | ) TYPE=MyISAM; |
---|
| 166 | |
---|
| 167 | -- |
---|
[801] | 168 | -- Table structure for table `phpwebgallery_rate` |
---|
[507] | 169 | -- |
---|
| 170 | |
---|
[801] | 171 | DROP TABLE IF EXISTS `phpwebgallery_rate`; |
---|
| 172 | CREATE TABLE `phpwebgallery_rate` ( |
---|
[858] | 173 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 174 | `element_id` mediumint(8) unsigned NOT NULL default '0', |
---|
| 175 | `rate` tinyint(2) unsigned NOT NULL default '0', |
---|
| 176 | PRIMARY KEY (`user_id`,`element_id`) |
---|
[507] | 177 | ) TYPE=MyISAM; |
---|
| 178 | |
---|
| 179 | -- |
---|
[801] | 180 | -- Table structure for table `phpwebgallery_sessions` |
---|
[381] | 181 | -- |
---|
| 182 | |
---|
[801] | 183 | DROP TABLE IF EXISTS `phpwebgallery_sessions`; |
---|
| 184 | CREATE TABLE `phpwebgallery_sessions` ( |
---|
| 185 | `id` varchar(255) binary NOT NULL default '', |
---|
[858] | 186 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 187 | `expiration` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
| 188 | PRIMARY KEY (`id`) |
---|
[381] | 189 | ) TYPE=MyISAM; |
---|
| 190 | |
---|
| 191 | -- |
---|
[801] | 192 | -- Table structure for table `phpwebgallery_sites` |
---|
[381] | 193 | -- |
---|
| 194 | |
---|
[801] | 195 | DROP TABLE IF EXISTS `phpwebgallery_sites`; |
---|
| 196 | CREATE TABLE `phpwebgallery_sites` ( |
---|
| 197 | `id` tinyint(4) NOT NULL auto_increment, |
---|
| 198 | `galleries_url` varchar(255) NOT NULL default '', |
---|
| 199 | PRIMARY KEY (`id`), |
---|
| 200 | UNIQUE KEY `sites_ui1` (`galleries_url`) |
---|
[381] | 201 | ) TYPE=MyISAM; |
---|
| 202 | |
---|
| 203 | -- |
---|
[801] | 204 | -- Table structure for table `phpwebgallery_user_access` |
---|
[381] | 205 | -- |
---|
| 206 | |
---|
[801] | 207 | DROP TABLE IF EXISTS `phpwebgallery_user_access`; |
---|
| 208 | CREATE TABLE `phpwebgallery_user_access` ( |
---|
[858] | 209 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 210 | `cat_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 211 | PRIMARY KEY (`user_id`,`cat_id`) |
---|
[381] | 212 | ) TYPE=MyISAM; |
---|
| 213 | |
---|
| 214 | -- |
---|
[808] | 215 | -- Table structure for table `phpwebgallery_user_cache` |
---|
[648] | 216 | -- |
---|
| 217 | |
---|
[808] | 218 | DROP TABLE IF EXISTS `phpwebgallery_user_cache`; |
---|
| 219 | CREATE TABLE `phpwebgallery_user_cache` ( |
---|
[858] | 220 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 221 | `need_update` enum('true','false') NOT NULL default 'true', |
---|
| 222 | `forbidden_categories` text, |
---|
| 223 | PRIMARY KEY (`user_id`) |
---|
[648] | 224 | ) TYPE=MyISAM; |
---|
| 225 | |
---|
| 226 | -- |
---|
[833] | 227 | -- Table structure for table `phpwebgallery_user_feed` |
---|
| 228 | -- |
---|
| 229 | |
---|
| 230 | DROP TABLE IF EXISTS `phpwebgallery_user_feed`; |
---|
| 231 | CREATE TABLE `phpwebgallery_user_feed` ( |
---|
| 232 | `id` varchar(50) binary NOT NULL default '', |
---|
[858] | 233 | `user_id` smallint(5) NOT NULL default '0', |
---|
[833] | 234 | `last_check` datetime default NULL, |
---|
| 235 | PRIMARY KEY (`id`) |
---|
| 236 | ) TYPE=MyISAM; |
---|
| 237 | |
---|
| 238 | -- |
---|
[801] | 239 | -- Table structure for table `phpwebgallery_user_group` |
---|
[381] | 240 | -- |
---|
| 241 | |
---|
[801] | 242 | DROP TABLE IF EXISTS `phpwebgallery_user_group`; |
---|
| 243 | CREATE TABLE `phpwebgallery_user_group` ( |
---|
[858] | 244 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 245 | `group_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 246 | PRIMARY KEY (`group_id`,`user_id`) |
---|
[381] | 247 | ) TYPE=MyISAM; |
---|
| 248 | |
---|
| 249 | -- |
---|
[808] | 250 | -- Table structure for table `phpwebgallery_user_infos` |
---|
[381] | 251 | -- |
---|
| 252 | |
---|
[808] | 253 | DROP TABLE IF EXISTS `phpwebgallery_user_infos`; |
---|
| 254 | CREATE TABLE `phpwebgallery_user_infos` ( |
---|
[858] | 255 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 256 | `nb_image_line` tinyint(1) unsigned NOT NULL default '5', |
---|
| 257 | `nb_line_page` tinyint(3) unsigned NOT NULL default '3', |
---|
| 258 | `status` enum('admin','guest') NOT NULL default 'guest', |
---|
| 259 | `language` varchar(50) NOT NULL default 'english', |
---|
| 260 | `maxwidth` smallint(6) default NULL, |
---|
| 261 | `maxheight` smallint(6) default NULL, |
---|
| 262 | `expand` enum('true','false') NOT NULL default 'false', |
---|
| 263 | `show_nb_comments` enum('true','false') NOT NULL default 'false', |
---|
| 264 | `recent_period` tinyint(3) unsigned NOT NULL default '7', |
---|
[860] | 265 | `template` varchar(255) NOT NULL default 'yoga', |
---|
[801] | 266 | `registration_date` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
[808] | 267 | UNIQUE KEY `user_infos_ui1` (`user_id`) |
---|
| 268 | ) TYPE=MyISAM; |
---|
| 269 | |
---|
| 270 | -- |
---|
| 271 | -- Table structure for table `phpwebgallery_users` |
---|
| 272 | -- |
---|
| 273 | |
---|
| 274 | DROP TABLE IF EXISTS `phpwebgallery_users`; |
---|
| 275 | CREATE TABLE `phpwebgallery_users` ( |
---|
[858] | 276 | `id` smallint(5) NOT NULL auto_increment, |
---|
[808] | 277 | `username` varchar(20) binary NOT NULL default '', |
---|
| 278 | `password` varchar(32) default NULL, |
---|
| 279 | `mail_address` varchar(255) default NULL, |
---|
[801] | 280 | PRIMARY KEY (`id`), |
---|
| 281 | UNIQUE KEY `users_ui1` (`username`) |
---|
[381] | 282 | ) TYPE=MyISAM; |
---|
| 283 | |
---|
| 284 | -- |
---|
[801] | 285 | -- Table structure for table `phpwebgallery_waiting` |
---|
[381] | 286 | -- |
---|
| 287 | |
---|
[801] | 288 | DROP TABLE IF EXISTS `phpwebgallery_waiting`; |
---|
| 289 | CREATE TABLE `phpwebgallery_waiting` ( |
---|
| 290 | `id` int(10) unsigned NOT NULL auto_increment, |
---|
| 291 | `storage_category_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 292 | `file` varchar(255) NOT NULL default '', |
---|
| 293 | `username` varchar(255) NOT NULL default '', |
---|
| 294 | `mail_address` varchar(255) NOT NULL default '', |
---|
| 295 | `date` int(10) unsigned NOT NULL default '0', |
---|
| 296 | `tn_ext` char(3) default NULL, |
---|
| 297 | `validated` enum('true','false') NOT NULL default 'false', |
---|
| 298 | `infos` text, |
---|
| 299 | PRIMARY KEY (`id`) |
---|
[381] | 300 | ) TYPE=MyISAM; |
---|
| 301 | |
---|