[1727] | 1 | -- MySQL dump 9.11 |
---|
[381] | 2 | -- |
---|
[1064] | 3 | -- Host: localhost Database: pwg-bsf |
---|
[801] | 4 | -- ------------------------------------------------------ |
---|
[1064] | 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, |
---|
[1312] | 31 | `rank` smallint(5) unsigned default NULL, |
---|
[801] | 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, |
---|
[1500] | 40 | `image_order` varchar(128) default NULL, |
---|
[1883] | 41 | `permalink` varchar(64) default NULL, |
---|
[801] | 42 | PRIMARY KEY (`id`), |
---|
[1883] | 43 | UNIQUE KEY `categories_i3` (`permalink`), |
---|
| 44 | KEY `categories_i2` (`id_uppercat`) |
---|
[381] | 45 | ) TYPE=MyISAM; |
---|
| 46 | |
---|
| 47 | -- |
---|
[801] | 48 | -- Table structure for table `phpwebgallery_comments` |
---|
[381] | 49 | -- |
---|
| 50 | |
---|
[801] | 51 | DROP TABLE IF EXISTS `phpwebgallery_comments`; |
---|
| 52 | CREATE TABLE `phpwebgallery_comments` ( |
---|
| 53 | `id` int(11) unsigned NOT NULL auto_increment, |
---|
| 54 | `image_id` mediumint(8) unsigned NOT NULL default '0', |
---|
| 55 | `date` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
| 56 | `author` varchar(255) default NULL, |
---|
| 57 | `content` longtext, |
---|
| 58 | `validated` enum('true','false') NOT NULL default 'false', |
---|
| 59 | `validation_date` datetime default NULL, |
---|
| 60 | PRIMARY KEY (`id`), |
---|
| 61 | KEY `comments_i2` (`validation_date`), |
---|
| 62 | KEY `comments_i1` (`image_id`) |
---|
[381] | 63 | ) TYPE=MyISAM; |
---|
| 64 | |
---|
| 65 | -- |
---|
[801] | 66 | -- Table structure for table `phpwebgallery_config` |
---|
[381] | 67 | -- |
---|
| 68 | |
---|
[801] | 69 | DROP TABLE IF EXISTS `phpwebgallery_config`; |
---|
| 70 | CREATE TABLE `phpwebgallery_config` ( |
---|
| 71 | `param` varchar(40) NOT NULL default '', |
---|
[1071] | 72 | `value` text, |
---|
[801] | 73 | `comment` varchar(255) default NULL, |
---|
| 74 | PRIMARY KEY (`param`) |
---|
[385] | 75 | ) TYPE=MyISAM COMMENT='configuration table'; |
---|
[381] | 76 | |
---|
| 77 | -- |
---|
[801] | 78 | -- Table structure for table `phpwebgallery_favorites` |
---|
[381] | 79 | -- |
---|
| 80 | |
---|
[801] | 81 | DROP TABLE IF EXISTS `phpwebgallery_favorites`; |
---|
| 82 | CREATE TABLE `phpwebgallery_favorites` ( |
---|
[858] | 83 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 84 | `image_id` mediumint(8) unsigned NOT NULL default '0', |
---|
| 85 | PRIMARY KEY (`user_id`,`image_id`) |
---|
[381] | 86 | ) TYPE=MyISAM; |
---|
| 87 | |
---|
| 88 | -- |
---|
[801] | 89 | -- Table structure for table `phpwebgallery_group_access` |
---|
[381] | 90 | -- |
---|
| 91 | |
---|
[801] | 92 | DROP TABLE IF EXISTS `phpwebgallery_group_access`; |
---|
| 93 | CREATE TABLE `phpwebgallery_group_access` ( |
---|
| 94 | `group_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 95 | `cat_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 96 | PRIMARY KEY (`group_id`,`cat_id`) |
---|
[381] | 97 | ) TYPE=MyISAM; |
---|
| 98 | |
---|
| 99 | -- |
---|
[801] | 100 | -- Table structure for table `phpwebgallery_groups` |
---|
[381] | 101 | -- |
---|
| 102 | |
---|
[801] | 103 | DROP TABLE IF EXISTS `phpwebgallery_groups`; |
---|
| 104 | CREATE TABLE `phpwebgallery_groups` ( |
---|
| 105 | `id` smallint(5) unsigned NOT NULL auto_increment, |
---|
| 106 | `name` varchar(255) NOT NULL default '', |
---|
[1583] | 107 | `is_default` enum('true','false') NOT NULL default 'false', |
---|
[1963] | 108 | PRIMARY KEY (`id`), |
---|
| 109 | UNIQUE KEY `groups_ui1` (`name`) |
---|
[381] | 110 | ) TYPE=MyISAM; |
---|
| 111 | |
---|
| 112 | -- |
---|
[801] | 113 | -- Table structure for table `phpwebgallery_history` |
---|
[381] | 114 | -- |
---|
| 115 | |
---|
[801] | 116 | DROP TABLE IF EXISTS `phpwebgallery_history`; |
---|
| 117 | CREATE TABLE `phpwebgallery_history` ( |
---|
[1727] | 118 | `id` int(10) unsigned NOT NULL auto_increment, |
---|
| 119 | `date` date NOT NULL default '0000-00-00', |
---|
| 120 | `time` time NOT NULL default '00:00:00', |
---|
| 121 | `year` smallint(4) NOT NULL default '0', |
---|
| 122 | `month` tinyint(2) NOT NULL default '0', |
---|
| 123 | `day` tinyint(2) NOT NULL default '0', |
---|
| 124 | `hour` tinyint(2) NOT NULL default '0', |
---|
| 125 | `user_id` smallint(5) NOT NULL default '0', |
---|
| 126 | `IP` varchar(15) NOT NULL default '', |
---|
| 127 | `section` enum('categories','tags','search','list','favorites','most_visited','best_rated','recent_pics','recent_cats') default NULL, |
---|
| 128 | `category_id` smallint(5) default NULL, |
---|
| 129 | `tag_ids` varchar(50) default NULL, |
---|
| 130 | `image_id` mediumint(8) default NULL, |
---|
| 131 | `summarized` enum('true','false') default 'false', |
---|
[1844] | 132 | `image_type` enum('picture','high','other') default NULL, |
---|
[1727] | 133 | PRIMARY KEY (`id`), |
---|
| 134 | KEY `history_i1` (`summarized`) |
---|
[381] | 135 | ) TYPE=MyISAM; |
---|
| 136 | |
---|
| 137 | -- |
---|
[1727] | 138 | -- Table structure for table `phpwebgallery_history_summary` |
---|
| 139 | -- |
---|
| 140 | |
---|
| 141 | DROP TABLE IF EXISTS `phpwebgallery_history_summary`; |
---|
| 142 | CREATE TABLE `phpwebgallery_history_summary` ( |
---|
| 143 | `id` varchar(13) NOT NULL default '', |
---|
| 144 | `year` smallint(4) NOT NULL default '0', |
---|
| 145 | `month` tinyint(2) default NULL, |
---|
| 146 | `day` tinyint(2) default NULL, |
---|
| 147 | `hour` tinyint(2) default NULL, |
---|
| 148 | `nb_pages` int(11) default NULL, |
---|
| 149 | PRIMARY KEY (`id`) |
---|
| 150 | ) TYPE=MyISAM; |
---|
| 151 | |
---|
| 152 | -- |
---|
[801] | 153 | -- Table structure for table `phpwebgallery_image_category` |
---|
[381] | 154 | -- |
---|
| 155 | |
---|
[801] | 156 | DROP TABLE IF EXISTS `phpwebgallery_image_category`; |
---|
| 157 | CREATE TABLE `phpwebgallery_image_category` ( |
---|
| 158 | `image_id` mediumint(8) unsigned NOT NULL default '0', |
---|
| 159 | `category_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 160 | PRIMARY KEY (`image_id`,`category_id`), |
---|
[1925] | 161 | KEY `image_category_i1` (`category_id`) |
---|
[381] | 162 | ) TYPE=MyISAM; |
---|
| 163 | |
---|
| 164 | -- |
---|
[1119] | 165 | -- Table structure for table `phpwebgallery_image_tag` |
---|
| 166 | -- |
---|
| 167 | |
---|
| 168 | DROP TABLE IF EXISTS `phpwebgallery_image_tag`; |
---|
| 169 | CREATE TABLE `phpwebgallery_image_tag` ( |
---|
| 170 | `image_id` mediumint(8) unsigned NOT NULL default '0', |
---|
| 171 | `tag_id` smallint(5) unsigned NOT NULL default '0', |
---|
[1131] | 172 | PRIMARY KEY (`image_id`,`tag_id`), |
---|
| 173 | KEY `image_tag_i1` (`tag_id`) |
---|
[1119] | 174 | ) TYPE=MyISAM; |
---|
| 175 | |
---|
| 176 | -- |
---|
[801] | 177 | -- Table structure for table `phpwebgallery_images` |
---|
[381] | 178 | -- |
---|
| 179 | |
---|
[801] | 180 | DROP TABLE IF EXISTS `phpwebgallery_images`; |
---|
| 181 | CREATE TABLE `phpwebgallery_images` ( |
---|
| 182 | `id` mediumint(8) unsigned NOT NULL auto_increment, |
---|
| 183 | `file` varchar(255) NOT NULL default '', |
---|
| 184 | `date_available` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
| 185 | `date_creation` date default NULL, |
---|
| 186 | `tn_ext` varchar(4) default '', |
---|
| 187 | `name` varchar(255) default NULL, |
---|
| 188 | `comment` text, |
---|
| 189 | `author` varchar(255) default NULL, |
---|
| 190 | `hit` int(10) unsigned NOT NULL default '0', |
---|
| 191 | `filesize` mediumint(9) unsigned default NULL, |
---|
| 192 | `width` smallint(9) unsigned default NULL, |
---|
| 193 | `height` smallint(9) unsigned default NULL, |
---|
| 194 | `representative_ext` varchar(4) default NULL, |
---|
| 195 | `date_metadata_update` date default NULL, |
---|
| 196 | `average_rate` float(5,2) unsigned default NULL, |
---|
[1020] | 197 | `has_high` enum('true') default NULL, |
---|
[801] | 198 | `path` varchar(255) NOT NULL default '', |
---|
[1121] | 199 | `storage_category_id` smallint(5) unsigned default NULL, |
---|
[1883] | 200 | `high_filesize` mediumint(9) unsigned default NULL, |
---|
[2084] | 201 | `level` tinyint unsigned NOT NULL default '0', |
---|
[801] | 202 | PRIMARY KEY (`id`), |
---|
| 203 | KEY `images_i2` (`date_available`), |
---|
| 204 | KEY `images_i3` (`average_rate`), |
---|
| 205 | KEY `images_i4` (`hit`), |
---|
[1159] | 206 | KEY `images_i5` (`date_creation`), |
---|
| 207 | KEY `images_i1` (`storage_category_id`) |
---|
[381] | 208 | ) TYPE=MyISAM; |
---|
| 209 | |
---|
| 210 | -- |
---|
[1866] | 211 | -- Table structure for table `phpwebgallery_old_permalinks` |
---|
| 212 | -- |
---|
| 213 | |
---|
| 214 | DROP TABLE IF EXISTS `phpwebgallery_old_permalinks`; |
---|
| 215 | CREATE TABLE `phpwebgallery_old_permalinks` ( |
---|
[1883] | 216 | `cat_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 217 | `permalink` varchar(64) NOT NULL default '', |
---|
| 218 | `date_deleted` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
[1866] | 219 | `last_hit` datetime default NULL, |
---|
| 220 | `hit` int(10) unsigned NOT NULL default '0', |
---|
[1883] | 221 | PRIMARY KEY (`permalink`) |
---|
[1866] | 222 | ) TYPE=MyISAM; |
---|
| 223 | |
---|
| 224 | -- |
---|
[1584] | 225 | -- Table structure for table `phpwebgallery_plugins` |
---|
| 226 | -- |
---|
| 227 | |
---|
| 228 | DROP TABLE IF EXISTS `phpwebgallery_plugins`; |
---|
| 229 | CREATE TABLE `phpwebgallery_plugins` ( |
---|
| 230 | `id` varchar(64) binary NOT NULL default '', |
---|
| 231 | `state` enum('inactive','active') NOT NULL default 'inactive', |
---|
| 232 | `version` varchar(64) NOT NULL default '0', |
---|
| 233 | PRIMARY KEY (`id`) |
---|
| 234 | ) TYPE=MyISAM; |
---|
| 235 | |
---|
| 236 | -- |
---|
[801] | 237 | -- Table structure for table `phpwebgallery_rate` |
---|
[507] | 238 | -- |
---|
| 239 | |
---|
[801] | 240 | DROP TABLE IF EXISTS `phpwebgallery_rate`; |
---|
| 241 | CREATE TABLE `phpwebgallery_rate` ( |
---|
[858] | 242 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 243 | `element_id` mediumint(8) unsigned NOT NULL default '0', |
---|
[1041] | 244 | `anonymous_id` varchar(45) NOT NULL default '', |
---|
[801] | 245 | `rate` tinyint(2) unsigned NOT NULL default '0', |
---|
[1041] | 246 | `date` date NOT NULL default '0000-00-00', |
---|
| 247 | PRIMARY KEY (`element_id`,`user_id`,`anonymous_id`) |
---|
[507] | 248 | ) TYPE=MyISAM; |
---|
| 249 | |
---|
| 250 | -- |
---|
[1008] | 251 | -- Table structure for table `phpwebgallery_search` |
---|
| 252 | -- |
---|
| 253 | |
---|
| 254 | DROP TABLE IF EXISTS `phpwebgallery_search`; |
---|
| 255 | CREATE TABLE `phpwebgallery_search` ( |
---|
| 256 | `id` int(10) unsigned NOT NULL auto_increment, |
---|
| 257 | `last_seen` date default NULL, |
---|
| 258 | `rules` text, |
---|
| 259 | PRIMARY KEY (`id`) |
---|
| 260 | ) TYPE=MyISAM; |
---|
| 261 | |
---|
| 262 | -- |
---|
[801] | 263 | -- Table structure for table `phpwebgallery_sessions` |
---|
[381] | 264 | -- |
---|
| 265 | |
---|
[801] | 266 | DROP TABLE IF EXISTS `phpwebgallery_sessions`; |
---|
| 267 | CREATE TABLE `phpwebgallery_sessions` ( |
---|
| 268 | `id` varchar(255) binary NOT NULL default '', |
---|
[1004] | 269 | `data` text NOT NULL, |
---|
[801] | 270 | `expiration` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
| 271 | PRIMARY KEY (`id`) |
---|
[381] | 272 | ) TYPE=MyISAM; |
---|
| 273 | |
---|
| 274 | -- |
---|
[801] | 275 | -- Table structure for table `phpwebgallery_sites` |
---|
[381] | 276 | -- |
---|
| 277 | |
---|
[801] | 278 | DROP TABLE IF EXISTS `phpwebgallery_sites`; |
---|
| 279 | CREATE TABLE `phpwebgallery_sites` ( |
---|
| 280 | `id` tinyint(4) NOT NULL auto_increment, |
---|
| 281 | `galleries_url` varchar(255) NOT NULL default '', |
---|
| 282 | PRIMARY KEY (`id`), |
---|
| 283 | UNIQUE KEY `sites_ui1` (`galleries_url`) |
---|
[381] | 284 | ) TYPE=MyISAM; |
---|
| 285 | |
---|
| 286 | -- |
---|
[1119] | 287 | -- Table structure for table `phpwebgallery_tags` |
---|
| 288 | -- |
---|
| 289 | |
---|
| 290 | DROP TABLE IF EXISTS `phpwebgallery_tags`; |
---|
| 291 | CREATE TABLE `phpwebgallery_tags` ( |
---|
| 292 | `id` smallint(5) unsigned NOT NULL auto_increment, |
---|
| 293 | `name` varchar(255) binary NOT NULL default '', |
---|
| 294 | `url_name` varchar(255) binary NOT NULL default '', |
---|
[1131] | 295 | PRIMARY KEY (`id`), |
---|
| 296 | KEY `tags_i1` (`url_name`) |
---|
[1119] | 297 | ) TYPE=MyISAM; |
---|
| 298 | |
---|
| 299 | -- |
---|
[953] | 300 | -- Table structure for table `phpwebgallery_upgrade` |
---|
| 301 | -- |
---|
| 302 | |
---|
| 303 | DROP TABLE IF EXISTS `phpwebgallery_upgrade`; |
---|
| 304 | CREATE TABLE `phpwebgallery_upgrade` ( |
---|
| 305 | `id` varchar(20) NOT NULL default '', |
---|
| 306 | `applied` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
| 307 | `description` varchar(255) default NULL, |
---|
| 308 | PRIMARY KEY (`id`) |
---|
| 309 | ) TYPE=MyISAM; |
---|
| 310 | |
---|
| 311 | -- |
---|
[801] | 312 | -- Table structure for table `phpwebgallery_user_access` |
---|
[381] | 313 | -- |
---|
| 314 | |
---|
[801] | 315 | DROP TABLE IF EXISTS `phpwebgallery_user_access`; |
---|
| 316 | CREATE TABLE `phpwebgallery_user_access` ( |
---|
[858] | 317 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 318 | `cat_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 319 | PRIMARY KEY (`user_id`,`cat_id`) |
---|
[381] | 320 | ) TYPE=MyISAM; |
---|
| 321 | |
---|
| 322 | -- |
---|
[808] | 323 | -- Table structure for table `phpwebgallery_user_cache` |
---|
[648] | 324 | -- |
---|
| 325 | |
---|
[808] | 326 | DROP TABLE IF EXISTS `phpwebgallery_user_cache`; |
---|
| 327 | CREATE TABLE `phpwebgallery_user_cache` ( |
---|
[858] | 328 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 329 | `need_update` enum('true','false') NOT NULL default 'true', |
---|
| 330 | `forbidden_categories` text, |
---|
[1119] | 331 | `nb_total_images` mediumint(8) unsigned default NULL, |
---|
[2084] | 332 | `image_access_type` enum('NOT IN','IN') NOT NULL default 'NOT IN', |
---|
| 333 | `image_access_list` text default NULL, |
---|
[801] | 334 | PRIMARY KEY (`user_id`) |
---|
[648] | 335 | ) TYPE=MyISAM; |
---|
| 336 | |
---|
| 337 | -- |
---|
[1624] | 338 | -- Table structure for table `phpwebgallery_user_cache_categories` |
---|
| 339 | -- |
---|
| 340 | |
---|
| 341 | DROP TABLE IF EXISTS `phpwebgallery_user_cache_categories`; |
---|
| 342 | CREATE TABLE `phpwebgallery_user_cache_categories` ( |
---|
| 343 | `user_id` smallint(5) NOT NULL default '0', |
---|
| 344 | `cat_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 345 | `max_date_last` datetime default NULL, |
---|
[1727] | 346 | `count_images` mediumint(8) unsigned default '0', |
---|
| 347 | `count_categories` mediumint(8) unsigned default '0', |
---|
| 348 | PRIMARY KEY (`user_id`,`cat_id`) |
---|
[1624] | 349 | ) TYPE=MyISAM; |
---|
| 350 | |
---|
| 351 | -- |
---|
[833] | 352 | -- Table structure for table `phpwebgallery_user_feed` |
---|
| 353 | -- |
---|
| 354 | |
---|
| 355 | DROP TABLE IF EXISTS `phpwebgallery_user_feed`; |
---|
| 356 | CREATE TABLE `phpwebgallery_user_feed` ( |
---|
| 357 | `id` varchar(50) binary NOT NULL default '', |
---|
[858] | 358 | `user_id` smallint(5) NOT NULL default '0', |
---|
[833] | 359 | `last_check` datetime default NULL, |
---|
| 360 | PRIMARY KEY (`id`) |
---|
| 361 | ) TYPE=MyISAM; |
---|
| 362 | |
---|
| 363 | -- |
---|
[801] | 364 | -- Table structure for table `phpwebgallery_user_group` |
---|
[381] | 365 | -- |
---|
| 366 | |
---|
[801] | 367 | DROP TABLE IF EXISTS `phpwebgallery_user_group`; |
---|
| 368 | CREATE TABLE `phpwebgallery_user_group` ( |
---|
[858] | 369 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 370 | `group_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 371 | PRIMARY KEY (`group_id`,`user_id`) |
---|
[381] | 372 | ) TYPE=MyISAM; |
---|
| 373 | |
---|
| 374 | -- |
---|
[808] | 375 | -- Table structure for table `phpwebgallery_user_infos` |
---|
[381] | 376 | -- |
---|
| 377 | |
---|
[808] | 378 | DROP TABLE IF EXISTS `phpwebgallery_user_infos`; |
---|
| 379 | CREATE TABLE `phpwebgallery_user_infos` ( |
---|
[858] | 380 | `user_id` smallint(5) NOT NULL default '0', |
---|
[801] | 381 | `nb_image_line` tinyint(1) unsigned NOT NULL default '5', |
---|
| 382 | `nb_line_page` tinyint(3) unsigned NOT NULL default '3', |
---|
[1119] | 383 | `status` enum('webmaster','admin','normal','generic','guest') NOT NULL default 'guest', |
---|
[1085] | 384 | `adviser` enum('true','false') NOT NULL default 'false', |
---|
[2127] | 385 | `language` varchar(50) NOT NULL default 'en_UK', |
---|
[801] | 386 | `maxwidth` smallint(6) default NULL, |
---|
| 387 | `maxheight` smallint(6) default NULL, |
---|
| 388 | `expand` enum('true','false') NOT NULL default 'false', |
---|
| 389 | `show_nb_comments` enum('true','false') NOT NULL default 'false', |
---|
[1762] | 390 | `show_nb_hits` enum('true','false') NOT NULL default 'false', |
---|
[801] | 391 | `recent_period` tinyint(3) unsigned NOT NULL default '7', |
---|
[965] | 392 | `template` varchar(255) NOT NULL default 'yoga/clear', |
---|
[801] | 393 | `registration_date` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
[1078] | 394 | `enabled_high` enum('true','false') NOT NULL default 'true', |
---|
[2084] | 395 | `level` tinyint unsigned NOT NULL default '0', |
---|
[808] | 396 | UNIQUE KEY `user_infos_ui1` (`user_id`) |
---|
| 397 | ) TYPE=MyISAM; |
---|
| 398 | |
---|
| 399 | -- |
---|
[1064] | 400 | -- Table structure for table `phpwebgallery_user_mail_notification` |
---|
| 401 | -- |
---|
| 402 | |
---|
| 403 | DROP TABLE IF EXISTS `phpwebgallery_user_mail_notification`; |
---|
| 404 | CREATE TABLE `phpwebgallery_user_mail_notification` ( |
---|
| 405 | `user_id` smallint(5) NOT NULL default '0', |
---|
[1116] | 406 | `check_key` varchar(16) binary NOT NULL default '', |
---|
[1064] | 407 | `enabled` enum('true','false') NOT NULL default 'false', |
---|
| 408 | `last_send` datetime default NULL, |
---|
| 409 | PRIMARY KEY (`user_id`), |
---|
[1925] | 410 | UNIQUE KEY `user_mail_notification_ui1` (`check_key`) |
---|
[1064] | 411 | ) TYPE=MyISAM; |
---|
| 412 | |
---|
| 413 | -- |
---|
[808] | 414 | -- Table structure for table `phpwebgallery_users` |
---|
| 415 | -- |
---|
| 416 | |
---|
| 417 | DROP TABLE IF EXISTS `phpwebgallery_users`; |
---|
| 418 | CREATE TABLE `phpwebgallery_users` ( |
---|
[858] | 419 | `id` smallint(5) NOT NULL auto_increment, |
---|
[1495] | 420 | `username` varchar(100) binary NOT NULL default '', |
---|
[808] | 421 | `password` varchar(32) default NULL, |
---|
| 422 | `mail_address` varchar(255) default NULL, |
---|
[801] | 423 | PRIMARY KEY (`id`), |
---|
| 424 | UNIQUE KEY `users_ui1` (`username`) |
---|
[381] | 425 | ) TYPE=MyISAM; |
---|
| 426 | |
---|
| 427 | -- |
---|
[801] | 428 | -- Table structure for table `phpwebgallery_waiting` |
---|
[381] | 429 | -- |
---|
| 430 | |
---|
[801] | 431 | DROP TABLE IF EXISTS `phpwebgallery_waiting`; |
---|
| 432 | CREATE TABLE `phpwebgallery_waiting` ( |
---|
| 433 | `id` int(10) unsigned NOT NULL auto_increment, |
---|
| 434 | `storage_category_id` smallint(5) unsigned NOT NULL default '0', |
---|
| 435 | `file` varchar(255) NOT NULL default '', |
---|
| 436 | `username` varchar(255) NOT NULL default '', |
---|
| 437 | `mail_address` varchar(255) NOT NULL default '', |
---|
| 438 | `date` int(10) unsigned NOT NULL default '0', |
---|
| 439 | `tn_ext` char(3) default NULL, |
---|
| 440 | `validated` enum('true','false') NOT NULL default 'false', |
---|
| 441 | `infos` text, |
---|
| 442 | PRIMARY KEY (`id`) |
---|
[381] | 443 | ) TYPE=MyISAM; |
---|
| 444 | |
---|
[1727] | 445 | -- |
---|
[1662] | 446 | -- Table structure for table `phpwebgallery_ws_access` |
---|
[1727] | 447 | -- |
---|
[1662] | 448 | |
---|
[1727] | 449 | DROP TABLE IF EXISTS `phpwebgallery_ws_access`; |
---|
| 450 | CREATE TABLE `phpwebgallery_ws_access` ( |
---|
| 451 | `id` smallint(5) unsigned NOT NULL auto_increment, |
---|
| 452 | `name` varchar(32) NOT NULL default '', |
---|
| 453 | `access` varchar(255) default NULL, |
---|
[1662] | 454 | `start` datetime default NULL, |
---|
| 455 | `end` datetime default NULL, |
---|
[1727] | 456 | `request` varchar(255) default NULL, |
---|
[1662] | 457 | `limit` smallint(5) unsigned default NULL, |
---|
| 458 | `comment` varchar(255) default NULL, |
---|
[1727] | 459 | PRIMARY KEY (`id`), |
---|
[1925] | 460 | UNIQUE KEY `ws_access_ui1` (`name`) |
---|
[1727] | 461 | ) TYPE=MyISAM COMMENT='Access for Web Services'; |
---|
| 462 | |
---|