· 6 years ago · Dec 08, 2019, 04:34 PM
1--
2-- Table structure for table `item_sell_prices`
3--
4
5DROP TABLE IF EXISTS `item_sell_prices`;
6/*!40101 SET @saved_cs_client = @@character_set_client */;
7/*!50503 SET character_set_client = utf8mb4 */;
8CREATE TABLE `item_sell_prices` (
9 `id` int(6) NOT NULL AUTO_INCREMENT,
10 `classname` varchar(256) NOT NULL,
11 `displaytext` text NOT NULL,
12 `price` int(6) NOT NULL DEFAULT '100',
13 `type` varchar(100) NOT NULL DEFAULT 'item',
14 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
15 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
16 PRIMARY KEY (`id`)
17) ENGINE=InnoDB AUTO_INCREMENT=3332 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
18/*!40101 SET character_set_client = @saved_cs_client */;
19
20--
21-- Dumping data for table `item_sell_prices`
22--
23
24LOCK TABLES `item_sell_prices` WRITE;
25/*!40000 ALTER TABLE `item_sell_prices` DISABLE KEYS */;
26INSERT INTO `item_sell_prices` VALUES XXXX
27/*!40000 ALTER TABLE `item_sell_prices` ENABLE KEYS */;
28UNLOCK TABLES;