Home Explore Help
Sign In
Gyee_web
/
Gyee_sis_phone_nx
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
Gyee_sis_pho...
/
doc
/
t_sys_province.sql

t_sys_province.sql 6.8 KB
Permalink History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374 
  1. /*
    2. 

  2. Navicat MySQL Data Transfer
    3. 

  3. 

  4. Source Server         : 127.0.0.1_3306
    5. 

  5. Source Server Version : 50725
    6. 

  6. Source Host           : 127.0.0.1:3306
    7. 

  7. Source Database       : gyee
    8. 

  8. 

  9. Target Server Type    : MYSQL
    10. 

  10. Target Server Version : 50725
    11. 

  11. File Encoding         : 65001
    12. 

  12. 

  13. Date: 2019-10-05 01:42:50
    14. 

  14. */
    15. 

  15. 

  16. SET FOREIGN_KEY_CHECKS=0;
    17. 

  17. 

  18. -- ----------------------------
    19. 

  19. -- Table structure for t_sys_province
    20. 

  20. -- ----------------------------
    21. 

  21. DROP TABLE IF EXISTS `t_sys_province`;
    22. 

  22. CREATE TABLE `t_sys_province` (
    23. 

  23.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增列',
    24. 

  24.   `province_code` varchar(40) NOT NULL COMMENT '省份代码',
    25. 

  25.   `province_name` varchar(50) NOT NULL COMMENT '省份名称',
    26. 

  26.   `short_name` varchar(20) NOT NULL COMMENT '简称',
    27. 

  27.   `lng` varchar(20) DEFAULT NULL COMMENT '经度',
    28. 

  28.   `lat` varchar(20) DEFAULT NULL COMMENT '纬度',
    29. 

  29.   `sort` int(6) DEFAULT NULL COMMENT '排序',
    30. 

  30.   `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
    31. 

  31.   `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
    32. 

  32.   `memo` varchar(250) DEFAULT NULL COMMENT '备注',
    33. 

  33.   `data_state` int(11) DEFAULT NULL COMMENT '状态',
    34. 

  34.   PRIMARY KEY (`id`),
    35. 

  35.   KEY `Index_1` (`province_code`)
    36. 

  36. ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COMMENT='省份表';
    37. 

  37. 

  38. -- ----------------------------
    39. 

  39. -- Records of t_sys_province
    40. 

  40. -- ----------------------------
    41. 

  41. INSERT INTO `t_sys_province` VALUES ('1', '110000', '北京', '北京', '116.405289', '39.904987', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    42. 

  42. INSERT INTO `t_sys_province` VALUES ('2', '120000', '天津', '天津', '117.190186', '39.125595', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    43. 

  43. INSERT INTO `t_sys_province` VALUES ('3', '130000', '河北省', '河北', '114.502464', '38.045475', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    44. 

  44. INSERT INTO `t_sys_province` VALUES ('4', '140000', '山西省', '山西', '112.549248', '37.857014', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    45. 

  45. INSERT INTO `t_sys_province` VALUES ('5', '150000', '内蒙古自治区', '内蒙古', '111.670799', '40.81831', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    46. 

  46. INSERT INTO `t_sys_province` VALUES ('6', '210000', '辽宁省', '辽宁', '123.429092', '41.796768', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    47. 

  47. INSERT INTO `t_sys_province` VALUES ('7', '220000', '吉林省', '吉林', '125.324501', '43.886841', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    48. 

  48. INSERT INTO `t_sys_province` VALUES ('8', '230000', '黑龙江省', '黑龙江', '126.642464', '45.756966', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    49. 

  49. INSERT INTO `t_sys_province` VALUES ('9', '310000', '上海', '上海', '121.472641', '31.231707', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    50. 

  50. INSERT INTO `t_sys_province` VALUES ('10', '320000', '江苏省', '江苏', '118.76741', '32.041546', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    51. 

  51. INSERT INTO `t_sys_province` VALUES ('11', '330000', '浙江省', '浙江', '120.15358', '30.287458', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    52. 

  52. INSERT INTO `t_sys_province` VALUES ('12', '340000', '安徽省', '安徽', '117.283043', '31.861191', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    53. 

  53. INSERT INTO `t_sys_province` VALUES ('13', '350000', '福建省', '福建', '119.306236', '26.075302', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    54. 

  54. INSERT INTO `t_sys_province` VALUES ('14', '360000', '江西省', '江西', '115.892151', '28.676493', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    55. 

  55. INSERT INTO `t_sys_province` VALUES ('15', '370000', '山东省', '山东', '117.000923', '36.675808', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    56. 

  56. INSERT INTO `t_sys_province` VALUES ('16', '410000', '河南省', '河南', '113.665413', '34.757977', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    57. 

  57. INSERT INTO `t_sys_province` VALUES ('17', '420000', '湖北省', '湖北', '114.298569', '30.584354', '17', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    58. 

  58. INSERT INTO `t_sys_province` VALUES ('18', '430000', '湖南省', '湖南', '112.982277', '28.19409', '18', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    59. 

  59. INSERT INTO `t_sys_province` VALUES ('19', '440000', '广东省', '广东', '113.28064', '23.125177', '19', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    60. 

  60. INSERT INTO `t_sys_province` VALUES ('20', '450000', '广西壮族自治区', '广西', '108.320007', '22.82402', '20', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    61. 

  61. INSERT INTO `t_sys_province` VALUES ('21', '460000', '海南省', '海南', '110.331192', '20.031971', '21', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    62. 

  62. INSERT INTO `t_sys_province` VALUES ('22', '500000', '重庆', '重庆', '106.504959', '29.533155', '22', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    63. 

  63. INSERT INTO `t_sys_province` VALUES ('23', '510000', '四川省', '四川', '104.065735', '30.659462', '23', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    64. 

  64. INSERT INTO `t_sys_province` VALUES ('24', '520000', '贵州省', '贵州', '106.713478', '26.578342', '24', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    65. 

  65. INSERT INTO `t_sys_province` VALUES ('25', '530000', '云南省', '云南', '102.71225', '25.040609', '25', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    66. 

  66. INSERT INTO `t_sys_province` VALUES ('26', '540000', '西藏自治区', '西藏', '91.13221', '29.66036', '26', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    67. 

  67. INSERT INTO `t_sys_province` VALUES ('27', '610000', '陕西省', '陕西', '108.948021', '34.263161', '27', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    68. 

  68. INSERT INTO `t_sys_province` VALUES ('28', '620000', '甘肃省', '甘肃', '103.823555', '36.058041', '28', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    69. 

  69. INSERT INTO `t_sys_province` VALUES ('29', '630000', '青海省', '青海', '101.778915', '36.623177', '29', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    70. 

  70. INSERT INTO `t_sys_province` VALUES ('30', '640000', '宁夏回族自治区', '宁夏', '106.278175', '38.46637', '30', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    71. 

  71. INSERT INTO `t_sys_province` VALUES ('31', '650000', '新疆维吾尔自治区', '新疆', '87.617729', '43.792816', '31', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    72. 

  72. INSERT INTO `t_sys_province` VALUES ('32', '710000', '台湾', '台湾', '121.509064', '25.044333', '34', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    73. 

  73. INSERT INTO `t_sys_province` VALUES ('33', '810000', '香港特别行政区', '香港', '114.173355', '22.320047', '32', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    74. 

  74. INSERT INTO `t_sys_province` VALUES ('34', '820000', '澳门特别行政区', '澳门', '113.549088', '22.198952', '33', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
    75.