李青林的博客

所有汽车品牌的名称,子品牌,以及首字母,以及logo; 数据表结构如下: CREATE TABLE `firstbirds_car_brands_copy` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '品牌 ID', `rank` tinyint(4) NOT NULL DEFAULT '50' COMMENT '排名', `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '品牌名', `initial` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '首字母', `logo_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'logo', PRIMARY KEY (`id`), KEY `car_brands_initial_index` (`initial`) ) ENGINE=InnoDB AUTO_INCREMENT=409 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; INSERT INTO `firstbirds_car_brands_copy` VALUES ('1', '50', '上海大众', 'D', '/upload/car_brands/1.png'); 附带图片文件夹:

5w个用户昵称,供后台模拟生成批量账号使用,例如:(me = [ 'avi melwani', 'LIU jian liang', 'david', 'Andrew Foster', 'Michael J Roberts', 'RAJKUMAR GUPTA',)

5w个国内公司名称,供后台模拟批量生成公司名称使用,

CREATE TABLE `cn_base_district` ( `district_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '索引ID', `district_name` varchar(50) NOT NULL COMMENT '地区名称', `district_name_en` varchar(50) NOT NULL DEFAULT '', `district_parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '地区父ID', `district_displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `district_region` varchar(3) NOT NULL DEFAULT '' COMMENT '大区名称', `district_is_level` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '地区深度，从1开始', `district_is_leaf` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '无子类', PRIMARY KEY (`district_id`), KEY `area_parent_id` (`district_parent_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=46743 DEFAULT CHARSET=utf8 COMMENT='地区表'; -- ---------------------------- -- Records of cn_base_district -- ---------------------------- INSERT INTO `cn_base_district` VALUES ('1', '北京市', 'BeiJing City', '0', '0', '华北', '1', '0'); INSERT INTO `cn_base_district` VALUES ('2', '天津市', 'TianJin City', '0', '0', '华北', '1', '0'); CREATE TABLE `cn_base_district` ( `district_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '索引ID', `district_name` varchar(50) NOT NULL COMMENT '地区名称', `district_name_en` varchar(50) NOT NULL DEFAULT '', `district_parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '地区父ID', `district_displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `district_region` varchar(3) NOT NULL DEFAULT '' COMMENT '大区名称', `district_is_level` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '地区深度，从1开始', `district_is_leaf` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '无子类', PRIMARY KEY (`district_id`), KEY `area_parent_id` (`district_parent_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=46743 DEFAULT CHARSET=utf8 COMMENT='地区表'; -- ---------------------------- -- Records of cn_base_district -- ---------------------------- INSERT INTO `cn_base_district` VALUES ('1', '北京市', 'BeiJing City', '0', '0', '华北', '1', '0

Xshell免费版,,永久使用,破解版,主要用于连接linux,以及其他的服务器

CREATE TABLE IF NOT EXISTS `j_position` ( `id` int(11) NOT NULL AUTO_INCREMENT, `province_id` bigint(20) unsigned NOT NULL, `province_name` char(64) NOT NULL, `city_id` bigint(20) unsigned NOT NULL, `city_name` char(64) NOT NULL, `county_id` bigint(20) unsigned NOT NULL, `county_name` char(64) NOT NULL, `town_id` bigint(20) unsigned NOT NULL, `town_name` char(64) NOT NULL, `village_id` bigint(20) unsigned NOT NULL, `village_name` char(64) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `village_id` (`village_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='省市县镇村数据' AUTO_INCREMENT=693338 ;.............................. -- -- 转存表中的数据 `j_position` -- INSERT INTO `j_position` (`id`, `province_id`, `province_name`, `city_id`, `city_name`, `county_id`, `county_name`, `town_id`, `town_name`, `village_id`, `village_name`) VALUES (1, 110, '北京市', 110100000000, '市辖区', 110101000000, '东城区', 110101001000, '东华门街道办事处', 110101001001, '多福巷社区'), (2, 110, '北京市', 110100000000, '市辖区', 110101000000, '东城区', 110101001000, '东华门街道办事处', 110101001002, '银闸社区'), (3, 110, '北京市', 110100000000, '市辖区', 110101000000, '东城区', 110101001000, '东华门街道办事处', 110101001005, '东厂社区'), (4, 110, '北京市', 110100000000, '市辖区', 110101000000, '东城区', 110101001000, '东华门街道办事处', 110101001006, '智德社区'),

包含了全国所有的地区: CREATE TABLE `b_region` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` longtext, `level` tinyint(4) DEFAULT '0', `parent_id` int(10) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3784 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of b_region -- ---------------------------- INSERT INTO `b_region` VALUES ('1', '北京', '1', '0');