-- MySQL dump 10.14 Distrib 5.5.60-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: qicheoa -- ------------------------------------------------------ -- Server version 5.5.60-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `sub_product` -- DROP TABLE IF EXISTS `sub_product`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sub_product` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '子商品ID', `NAME` varchar(45) NOT NULL COMMENT '子商品名字', `PRODUCT_ID` int(11) NOT NULL COMMENT '商品ID', `PRICE` double NOT NULL COMMENT '价格', `RENEW_YEAR` int(11) NOT NULL DEFAULT '1' COMMENT '续年', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1024) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除标识', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', PRIMARY KEY (`ID`), KEY `product` (`PRODUCT_ID`), KEY `name_product` (`NAME`,`PRODUCT_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sub_product` -- LOCK TABLES `sub_product` WRITE; /*!40000 ALTER TABLE `sub_product` DISABLE KEYS */; INSERT INTO `sub_product` VALUES (1,'设备+1年服务',1385,320,1,'2020-02-16 13:58:49','2020-02-16 14:17:08','',2,24,24),(2,'设备+3年流量及平台服务',1385,420,3,'2020-02-16 13:59:12','2020-04-28 17:49:23','',1,24,23),(3,'设备+1年服务',1386,460,1,'2020-02-16 14:04:56','2020-02-16 14:17:00','',2,24,24),(4,'设备+3年流量及平台服务',1386,620,3,'2020-02-16 14:05:13','2020-04-29 14:27:30','',1,24,23),(5,'设备+1年服务',1393,200,1,'2020-02-16 14:16:50','2020-03-05 15:20:15','',2,24,24),(6,'设备+3年流量及平台服务',1393,300,3,'2020-02-16 14:17:24','2020-04-29 14:27:27','',1,24,23),(7,'设备+1年服务',1388,300,1,'2020-02-16 14:18:58','2020-02-16 14:18:58','',2,24,24),(8,'设备+3年流量及平台服务',1388,400,3,'2020-02-16 14:19:11','2020-04-29 14:27:21','',1,24,23),(9,'设备+1年服务',1391,300,1,'2020-02-16 14:21:05','2020-03-05 15:19:32','',2,24,24),(10,'设备+3年流量及平台服务',1391,400,3,'2020-02-16 14:21:19','2020-04-29 14:27:18','',1,24,23),(11,'设备+1年服务',1392,200,1,'2020-03-05 15:06:12','2020-03-05 15:19:57','',2,24,20),(12,'设备+3年服务',1392,300,3,'2020-03-05 15:06:28','2020-03-05 15:19:52','',2,24,20),(13,'设备+1年服务',1402,300,1,'2020-04-13 18:32:07','2020-04-13 18:32:07','',2,468620,24),(14,'设备+3年流量及平台服务',1402,400,3,'2020-04-13 18:32:39','2020-04-29 14:27:14','',1,468620,23),(15,'设备+1年服务',1392,200,1,'2020-04-14 11:22:02','2020-04-14 16:48:12','',2,23,24),(16,'设备+3年流量及平台服务',1392,300,3,'2020-04-14 11:22:20','2020-04-29 14:27:11','',1,23,23),(17,'设备+1年流量及平台服务',1385,320,1,'2020-04-27 20:24:45','2020-04-28 17:48:57','',1,24,23),(18,'设备+1年流量及平台服务',1386,460,1,'2020-04-27 20:25:49','2020-04-29 14:27:06','',1,24,23),(19,'设备+1年流量及平台服务',1393,200,1,'2020-04-27 20:26:23','2020-04-29 14:27:03','',1,24,23),(20,'设备+1年流量及平台服务',1388,300,1,'2020-04-27 20:26:59','2020-04-29 14:26:59','',1,24,23),(21,'设备+1年流量及平台服务',1391,300,1,'2020-04-27 20:27:32','2020-04-29 14:26:56','',1,24,23),(22,'设备+1年流量及平台服务',1402,300,1,'2020-04-27 20:28:23','2020-04-29 14:26:52','',1,24,23),(23,'设备+1年流量及平台服务',1392,200,1,'2020-04-27 20:29:20','2020-04-29 14:26:49','',1,24,23),(24,'1年服务',1406,980,1,'2020-06-04 16:25:53','2020-06-04 16:25:53','',2,23,23),(25,'3年服务',1406,2380,3,'2020-06-04 16:26:28','2020-06-04 16:26:28','',2,23,24),(26,'1年服务',1406,980,1,'2020-06-04 16:27:41','2020-06-04 16:27:41','',2,23,24),(27,'3年服务',1406,2380,3,'2020-06-05 13:56:12','2020-06-05 13:56:12','',1,24,24),(28,'1年服务',1406,980,1,'2020-06-05 13:57:27','2020-06-05 13:57:27','',1,24,24),(29,'设备+1年流量及平台服务+继电器',1402,330,1,'2020-06-08 11:01:52','2020-06-08 11:01:52','',2,26,26),(30,'设备+1年流量及平台服务+继电器',1393,230,1,'2020-06-08 11:02:24','2020-06-08 11:02:24','',2,26,26),(31,'设备+3年流量及平台服务+继电器',1402,430,3,'2020-06-08 11:03:18','2020-06-08 11:03:18','',2,26,26),(32,'设备+3年流量及平台服务+继电器',1393,330,3,'2020-06-08 11:03:49','2020-06-08 11:03:49','',2,26,26),(33,'3年服务',1407,11980,3,'2020-06-08 15:39:11','2020-06-09 09:29:27','',1,26,26),(34,'1年服务',1407,4980,1,'2020-06-08 15:39:33','2020-06-09 09:29:40','',1,26,26),(35,'3年服务',1408,21980,3,'2020-06-08 16:14:33','2020-06-09 09:29:56','',1,26,26),(36,'1年服务',1408,8980,1,'2020-06-08 16:14:55','2020-06-09 09:30:11','',1,26,26),(37,'3年服务',1409,31980,3,'2020-06-08 16:17:38','2020-06-09 09:30:29','',1,26,26),(38,'1年服务',1409,12980,1,'2020-06-08 16:17:58','2020-06-09 09:30:42','',1,26,26),(39,'套餐4(标准版+SD卡+流量费+7寸高清显示屏)',1410,2839,1,'2020-06-09 10:12:45','2020-06-09 10:20:56','',2,26,26),(40,'7寸高清显示屏',1410,220,1,'2020-06-09 10:14:36','2020-06-09 10:55:02','',1,26,26),(41,'套餐3(标准版+流量卡+SD卡+上门安装)',1410,3069,1,'2020-06-09 10:15:36','2020-06-09 10:54:46','',1,26,26),(42,'套餐2(标准版+流量卡+上门安装)',1410,2949,1,'2020-06-09 10:15:59','2020-06-09 10:54:09','',1,26,26),(43,'套餐1(标准版+上门安装)',1410,2449,1,'2020-06-09 10:18:49','2020-06-09 10:53:38','',1,26,26),(44,'标准版(主机+2路摄像头+延长线+平台费)',1410,1999,1,'2020-06-09 10:53:06','2020-06-09 10:53:06','',1,26,26),(45,'720车厢内置摄像头',1411,80,1,'2020-06-09 11:13:10','2020-06-09 11:13:28','',2,26,26),(46,'720防水摄像头',1411,100,1,'2020-06-09 11:13:43','2020-06-09 11:13:43','',2,26,26),(47,'7寸高清显示屏',1411,220,1,'2020-06-09 11:13:58','2020-06-09 11:13:58','',2,26,26),(48,'套餐3(标准版+流量卡+SD卡+上门安装)',1411,3369,1,'2020-06-09 11:14:12','2020-06-09 11:15:54','',2,26,26),(49,'套餐2(标准版+流量卡+上门安装)',1411,3249,1,'2020-06-09 11:14:30','2020-06-09 11:14:30','',2,26,26),(50,'套餐1(标准版+上门安装)',1411,2749,1,'2020-06-09 11:14:44','2020-06-09 11:14:44','',2,26,26),(51,'标准版(主机+平台费)',1411,2299,1,'2020-06-09 11:14:59','2020-06-09 11:14:59','',2,26,26),(52,'12米延长线',1411,60,1,'2020-06-09 11:27:27','2020-06-10 11:55:53','',1,26,26),(53,'720P 车厢内置摄像头',1411,80,1,'2020-06-09 11:27:40','2020-06-09 13:33:57','',1,26,26),(54,'720P 防水摄像头',1411,100,1,'2020-06-09 11:27:53','2020-06-09 13:33:51','',1,26,26),(55,'7寸高清显示屏',1411,220,1,'2020-06-09 11:28:07','2020-06-09 11:28:07','',1,26,26),(56,'套餐3(标准版+流量卡+SD卡+上门安装)',1411,3369,1,'2020-06-09 11:28:23','2020-06-09 13:31:54','',1,26,26),(57,'套餐2(标准版+流量卡+上门安装)',1411,3249,1,'2020-06-09 11:28:38','2020-06-09 13:31:36','',1,26,26),(58,'套餐1(标准版+上门安装)',1411,2749,1,'2020-06-09 11:28:53','2020-06-09 13:31:26','',1,26,26),(59,'标准版(主机+平台费)',1411,2299,1,'2020-06-09 11:29:08','2020-06-09 13:31:14','',1,26,26),(60,'12米延长线',1412,60,1,'2020-06-09 11:34:06','2020-06-10 11:55:45','',1,26,26),(61,'720P 车厢内置摄像头',1412,80,1,'2020-06-09 11:34:19','2020-06-09 13:33:35','',1,26,26),(62,'720P 防水摄像头',1412,100,1,'2020-06-09 11:34:35','2020-06-09 13:33:38','',1,26,26),(63,'7寸高清显示屏',1412,220,1,'2020-06-09 11:34:48','2020-06-09 11:34:48','',1,26,26),(64,'套餐3(标准版+流量卡+500G固态硬盘+上门安装)',1412,4499,1,'2020-06-09 11:35:03','2020-06-09 11:35:03','',1,26,26),(65,'套餐2(标准版+流量卡+上门安装)',1412,3949,1,'2020-06-09 11:35:18','2020-06-09 11:35:18','',1,26,26),(66,'套餐1(标准版+上门安装)',1412,3449,1,'2020-06-09 11:35:32','2020-06-09 11:35:32','',1,26,26),(67,'标准版(主机+平台费)',1412,2999,1,'2020-06-09 11:35:48','2020-06-09 11:35:48','',1,26,26),(68,'设备+3年流量及平台服务+继电器',1402,430,3,'2020-06-09 12:28:50','2020-06-09 12:28:50','',1,26,26),(69,'设备+3年流量及平台服务+继电器',1393,330,3,'2020-06-09 12:29:12','2020-06-09 12:29:12','',1,26,26),(70,'设备+1年流量及平台服务+继电器',1393,230,1,'2020-06-09 12:29:32','2020-06-09 12:29:32','',1,26,26),(71,'设备+1年流量及平台服务+继电器',1402,330,1,'2020-06-09 12:29:53','2020-06-09 12:29:53','',1,26,26); /*!40000 ALTER TABLE `sub_product` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2020-07-06 10:59:14