-- 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 `country` -- DROP TABLE IF EXISTS `country`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `country` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '国家ID', `NAME` varchar(30) NOT NULL DEFAULT '' COMMENT '中文名字', `ENGLISH` varchar(30) NOT NULL DEFAULT '' COMMENT '英文名字', `CODE` varchar(30) NOT NULL DEFAULT '' COMMENT '国家代号', `NUMBER` varchar(30) NOT NULL DEFAULT '' COMMENT '数字代号', `PRICE` double NOT NULL COMMENT '成本价', `COUNT` int(11) NOT NULL COMMENT '计费', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) NOT NULL DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', PRIMARY KEY (`ID`), KEY `c_code` (`CODE`), KEY `c_number` (`NUMBER`) ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `country` -- LOCK TABLES `country` WRITE; /*!40000 ALTER TABLE `country` DISABLE KEYS */; INSERT INTO `country` VALUES (1,'中国','China','CHN','86',0.031,1,20,20,'2019-12-19 21:20:08','2019-12-19 21:20:08','',1),(2,'泰国','Thailand','TH','66',0.131,5,20,20,'2019-12-19 21:20:43','2019-12-19 21:20:43','',1),(3,'日本','Japan','JP','81',0.514,17,20,20,'2019-12-23 14:52:54','2019-12-23 14:52:54','',1),(4,'韩国','South Korea','KR','82',0.119,4,20,20,'2020-01-15 13:57:39','2020-01-15 13:57:39','',1),(5,'中国香港','Hong Kong','HK','852',0.268,9,20,20,'2020-01-15 14:01:06','2020-01-15 14:01:06','',1),(6,'中国澳门','Macau','MO','853',0.183,6,20,20,'2020-01-15 14:02:28','2020-01-15 14:02:28','',1),(7,'中国台湾','Taiwan','TW','886',0.266,9,20,20,'2020-01-15 14:03:19','2020-01-15 14:03:19','',1),(8,'越南','Vietnam','VN','84',0.279,10,20,20,'2020-01-15 14:07:51','2020-01-15 14:07:51','',1),(9,'柬埔寨','Cambodia','KH','855',0.308,10,20,20,'2020-01-15 14:09:30','2020-01-15 14:09:30','',1),(10,'新加坡','Singapore','SG','65',0.261,9,20,20,'2020-01-15 14:10:36','2020-01-15 14:10:36','',1),(11,'马来西亚','Malaysia','MY','60',0.228,8,20,20,'2020-01-15 14:12:45','2020-01-15 14:12:45','',1),(12,'印度尼西亚','Indonesia','ID','62',0.35,12,20,20,'2020-01-15 14:14:03','2020-01-15 14:14:03','',1),(13,'澳大利亚','Australia','AU','61',0.385,13,20,20,'2020-01-15 14:15:07','2020-01-15 14:15:07','',1),(14,'新西兰','New Zealand','NZ','64',0.6,20,20,20,'2020-01-15 14:15:50','2020-01-15 14:15:50','',1),(15,'印度','India','IN','91',0.044,2,20,20,'2020-01-15 14:16:46','2020-01-15 14:16:46','',1),(16,'俄罗斯','Russia','RU','7',0.35,12,20,20,'2020-01-15 14:20:53','2020-01-15 14:20:53','',1),(17,'老挝','Laos','LA','856',0.28,10,20,20,'2020-01-15 14:24:25','2020-01-15 14:24:25','',1),(18,'缅甸','Myanmar','MM','95',0.56,19,20,20,'2020-01-15 14:25:42','2020-01-15 14:25:42','',1),(19,'蒙古','Mongolia','MN','976',0.569,19,20,20,'2020-01-15 14:34:30','2020-01-15 14:34:30','',1),(20,'美国','United States','US','1',0.053,2,20,20,'2020-01-19 19:47:04','2020-01-19 19:47:04','',1),(21,'加拿大','Canada','CA','1',0.053,2,20,20,'2020-01-19 19:47:34','2020-01-19 19:47:34','',1),(22,'英国','United Kingdom','GB','44',0.28,10,20,20,'2020-01-19 19:48:23','2020-01-19 19:48:23','',1),(23,'德国','Germany','DE','49',0.595,20,20,20,'2020-01-19 19:49:28','2020-01-19 19:49:28','',1),(24,'法国','France','FR','33',0.532,18,20,20,'2020-01-19 19:50:06','2020-01-19 19:50:06','',1),(25,'荷兰','Netherlands','NL','31',1.073,35,20,20,'2020-01-19 19:51:11','2020-01-19 19:51:11','',1),(26,'比利时','Belgium','BE','32',0.566,19,20,20,'2020-01-19 19:51:56','2020-01-19 19:51:56','',1),(27,'瑞典','Sweden','SE','46',0.667,22,20,20,'2020-01-19 19:53:26','2020-01-19 19:53:26','',1),(28,'瑞士','Switzerland','CH','41',0.488,16,20,20,'2020-01-19 19:54:03','2020-01-19 19:54:03','',1),(29,'奥地利','Austria','AT','43',0.883,29,20,20,'2020-01-19 19:55:13','2020-01-19 19:55:13','',1),(30,'丹麦','Denmark','DK','45',0.365,12,20,20,'2020-01-19 19:56:58','2020-01-19 19:56:58','',1),(31,'芬兰','Finland','FI','358',0.953,31,20,20,'2020-01-19 19:57:42','2020-01-19 19:57:42','',1),(32,'希腊','Greece','GR','30',0.601,20,20,20,'2020-01-19 19:58:22','2020-01-19 19:58:22','',1),(33,'匈牙利','Hungary','HU','36',0.821,27,20,20,'2020-01-19 19:59:05','2020-01-19 19:59:05','',1),(34,'以色列','Israel','IL','972',0.093,3,20,20,'2020-01-19 20:00:00','2020-01-19 20:00:00','',1),(35,'爱尔兰','Ireland','IE','353',0.565,19,20,20,'2020-01-19 20:00:39','2020-01-19 20:00:39','',1),(36,'立陶宛','Lithuania','LT','370',0.287,10,20,20,'2020-01-19 20:01:32','2020-01-19 20:01:32','',1),(37,'卢森堡','Luxembourg','LU','352',0.107,4,20,20,'2020-01-19 20:02:47','2020-01-19 20:02:47','',1),(38,'墨西哥','Mexico','MX','52',0.145,5,20,20,'2020-01-19 20:03:27','2020-01-19 20:03:27','',1),(39,'挪威','Norway','NO','47',0.538,18,20,20,'2020-01-19 20:04:25','2020-01-19 20:04:25','',1),(40,'波兰','Poland','PL','48',0.282,10,20,20,'2020-01-19 20:05:10','2020-01-19 20:05:10','',1),(41,'葡萄牙','Portugal','PT','351',0.358,12,20,20,'2020-01-19 20:05:52','2020-01-19 20:05:52','',1),(42,'捷克','Czech','CZ','420',0.433,14,20,20,'2020-01-19 20:06:42','2020-01-19 20:06:42','',1),(43,'斯洛伐克','Slovakia','SK','421',0.685,23,20,20,'2020-01-19 20:07:23','2020-01-19 20:07:23','',1),(44,'南非','South Africa','ZA','27',0.219,8,20,20,'2020-01-19 20:08:01','2020-01-19 20:08:01','',1),(45,'西班牙','Spain','ES','34',0.583,19,20,20,'2020-01-19 20:08:39','2020-01-19 20:08:39','',1); /*!40000 ALTER TABLE `country` 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:44:26