hy_storecard.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

-- DataBase Name: 易想会员管理营销 系统数据库字典
-- author hy_admin
-- Date: 2019-08-10
-- Server version: 5.6.25- 7.2.0

-- 
-- Table structure for hysc_admin
-- 
DROP TABLE IF EXISTS `hysc_admin`;
CREATE TABLE `hysc_admin` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`group_id` INT(11) NOT NULL DEFAULT '1',
	`name` VARCHAR(100) NOT NULL,
	`password` CHAR(32) NOT NULL,
	`email` CHAR(32) NOT NULL,
	`mobile` VARCHAR(20) NOT NULL,
	`status` TINYINT(4) NOT NULL DEFAULT 1,
	`remark` TEXT NOT NULL,
	`create_time` INT(10) NOT NULL,
	`update_time` INT(10) NOT NULL,
	`delete_time` INT(10) DEFAULT NULL,
	PRIMARY KEY (`id`)
) ENGINE=INNODB CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT='后台管理员表';

-- 
-- Table structure for hysc_store
-- 
DROP TABLE IF EXISTS `hysc_admin_group`;
CREATE TABLE `hysc_admin_group` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100) NOT NULL,
	`status` TINYINT(1) NOT NULL DEFAULT '1',
	`create_time` INT(10) NOT NULL,
	`update_time` INT(10) NOT NULL,
	`delete_time` INT(10) DEFAULT NULL,
	PRIMARY KEY (`id`)
) ENGINE=INNODB CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT='管理员分组表';


-- 
-- Table structure for hysc_store
-- 
DROP TABLE IF EXISTS `hysc_store`;
CREATE TABLE `hysc_store` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(50) NOT NULL,
	`identifier` VARCHAR(100) NOT NULL,
	`thumb` VARCHAR(150) NOT NULL,
	`banner` VARCHAR(150) NOT NULL,
	`uid` VARCHAR(100) NOT NULL,
	`workers` VARCHAR(100) NOT NULL,
	`mobile` VARCHAR(100) NOT NULL,
	`introduce` TEXT NOT NULL,
	`label` VARCHAR(200) NOT NULL,
	`announcement` TEXT NOT NULL,
	`category_id` INT(10) NOT NULL,
	`address` VARCHAR(255) NOT NULL,
	`lng` DOUBLE NOT NULL,
	`lat` DOUBLE NOT NULL,
	`provinces` VARCHAR(40) NOT NULL,