· 7 years ago · Sep 10, 2018, 10:18 AM
1DROP TABLE IF EXISTS `ps_guest`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `ps_guest` (
5 `id_guest` int(10) unsigned NOT NULL AUTO_INCREMENT,
6 `id_operating_system` int(10) unsigned DEFAULT NULL,
7 `id_web_browser` int(10) unsigned DEFAULT NULL,
8 `id_customer` int(10) unsigned DEFAULT NULL,
9 `javascript` tinyint(1) DEFAULT '0',
10 `screen_resolution_x` smallint(5) unsigned DEFAULT NULL,
11 `screen_resolution_y` smallint(5) unsigned DEFAULT NULL,
12 `screen_color` tinyint(3) unsigned DEFAULT NULL,
13 `sun_java` tinyint(1) DEFAULT NULL,
14 `adobe_flash` tinyint(1) DEFAULT NULL,
15 `adobe_director` tinyint(1) DEFAULT NULL,
16 `apple_quicktime` tinyint(1) DEFAULT NULL,
17 `real_player` tinyint(1) DEFAULT NULL,
18 `windows_media` tinyint(1) DEFAULT NULL,
19 `accept_language` varchar(8) DEFAULT NULL,
20 `mobile_theme` tinyint(1) NOT NULL DEFAULT '0',