/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 8.0.19 : Database - javaee_edit
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`javaee_edit` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `javaee_edit`;
/*Table structure for table `administrator` */
DROP TABLE IF EXISTS `administrator`;
CREATE TABLE `administrator` (
`user_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`username` varchar(200) DEFAULT NULL,
`password` varchar(200) DEFAULT NULL,
`role_list` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*Data for the table `administrator` */
insert into `administrator`(`user_id`,`username`,`password`,`role_list`) values ('1','199050327','123456','0'),('2','199050326','123456','1'),('3','100000000','123456','66'),('4','200000000','123456','66'),('20210519230028','admin','123456','66');
/*Table structure for table `announcement` */
DROP TABLE IF EXISTS `announcement`;
CREATE TABLE `announcement` (
`announcement_id` varchar(200) DEFAULT NULL,
`announcement_title` varchar(200) DEFAULT NULL,
`announcement_main` text,
`announcement_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*Data for the table `announcement` */
insert into `announcement`(`announcement_id`,`announcement_title`,`announcement_main`,`announcement_time`) values ('20210501151925','新加入的公告','通知，是运用广泛的知照性公文。用来发布法规、规章，转发上级机关、同级机关和不相隶属机关的公文，批转下级机关的公文，要求下级机关办理某项事务等。通知，一般由标题、主送单位（受文对象）、正文、落款四部分组成。','2021-05-01 15:19:25'),('20210501152756','测试公告2','我想说的话2','2021-05-01 15:27:56'),('20210517235227','测试公告3','dasdasdasda','2021-05-17 23:52:27'),('20210517235238','测试公告5','fdgdfgdfgdf','2021-05-17 23:52:38'),('20210519175054','新加入的公告qwe','wqeqwdasd','2021-05-19 17:50:54');
/*Table structure for table `annual_sale` */
DROP TABLE IF EXISTS `annual_sale`;
CREATE TABLE `annual_sale` (
`years` varchar(4) DEFAULT NULL,
`sales` double DEFAULT NULL,
`detail_id` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*Data for the table `annual_sale` */
insert into `annual_sale`(`years`,`sales`,`detail_id`) values ('2010',1201,NULL),('2011',1690,NULL),('2012',2000,NULL),('2013',1800,NULL),('2014',1699,NULL),('2015',1234,NULL),('2016',1596,NULL),('2017',1323,NULL),('2018',1500,NULL),('2019',1200,NULL),('2020',1150,NULL),('2021',60,NULL);
/*Table structure for table `goods` */
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
`goods_name` varchar(200) DEFAULT NULL,
`goods_price` double DEFAULT NULL,
`goods_inventory` int DEFAULT NULL,
`goods_id` varchar(200) DEFAULT NULL,
`goods_img` varchar(200) DEFAULT NULL,
`goods_sale` int DEFAULT '0',
`goods_type_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*Data for the table `goods` */
insert into `goods`(`goods_name`,`goods_price`,`goods_inventory`,`goods_id`,`goods_img`,`goods_sale`,`goods_type_id`) values ('酸奶',11,80,'1','../img/yark.jpg',4,'1'),('全麦面包',10,110,'50','../img/brand.jpg',5,'4'),('台湾饭团',6,133,'51','../img/rice.jpg',5,'5'),('葡式蛋挞',6,72,'100','../img/egg.jpg',0,'4'),('饼干',9,35,'101','../img/biscuits.jpg',4,'4'),('蓝莓牛奶',7,214,'2','../img/milk.jpg',5,'2'),('牛奶吐司',8,46,'52','../img/brand2.jpg',0,'4'),('香辣鱼罐头',15,25,'104','../img/fish.jpg',0,'7'),('水果罐头',15,12,'105','../img/fruit.jpg',0,'6'),('AAA',20,22,'999999','sadas',0,'7'),('测试A',18,50,'200','../56',0,NULL),('测试B',20,60,'201','../66',0,NULL),('测试C',22,70,'202','../76',0,NULL),('测试D',24,80,'203','../86',0,NULL);
/*Table structure for table `goods_type` */
DROP TABLE IF EXISTS `goods_type`;
CREATE TABLE `goods_type` (
`goods_type_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`goods_type_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
PRIMARY KEY (`goods_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*Data for the table `goods_type` */
insert into `goods_type`(`goods_type_id`,`goods_type_name`) values ('1','酸奶类'),('2','牛奶类'),('3','饮料类'),('4','点心类'),('5','正餐类'),('6','水果类'),('7','方便食品类');
/*Table structure for table `order_list` */
DROP TABLE IF EXISTS `order_list`;
CREATE TABLE `order_list` (
`order_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`user_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`goods_id` varchar(200) DEFAULT NULL,
`count` varchar(200) DEFAULT NULL,
`all_price` varchar(200) DEFAULT NULL,
`order_state_code` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0',
`order_date` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*Data for the table `order_list` */
insert into `order_list`(`order_id`,`user_id`,`goods_id`,`count`,`all_price`,`order_state_code`,`order_date`) values ('20210529144240','20210519230028','51','5','30.0','1','2020-05-29 14:24:35'),('20210529153105','20210519230028','51','4','24.0','1','2020-01-29 12:24:35'),('20210529153136','20210519230028','2','5','35.0','1','2021-02-29 18:24:35'),('20210529181746','20210519230028','2','3','21.0','1','2021-04-29 22:24:35'),('20210529181746','20210519230028','105','3','45.0','1','2021-04-29 22:24:35'),('20210601160809','20210519230028','51','3','18.0','1','2021-06-01 21:24:35'),('20210602122131','20210519230028','52','5','40.0','0','2021-06-02 16:24:35'),('20210602122131','20210519230028','51','2','12.0','0','2021-06-02 16:24:35'),('20210602122631','20210519230028','51','1','6.0','0','2021-06-02 16:24:35'),('20210605012824','20210519230028','101','4','36.0','1','2021-06-05 15:24:35'),('20210605012824','20210519230028','100','4','24.0','1','2021-06-05 15:24:35'),('20210608233653','20210519230028','101','4','36.0','0','2021-12-08 23:36:53'),('20210609104221','20210519230028','101','4','36.0','1','2020-06-09 10:42:21'),('20210711225003','20210519230028','52','2','16.0','0','2021-07-11 22:50:03');
/*Table structure for table `pc_show_main` */
DROP TABLE IF EXISTS `pc_show_main`;
CREATE TABLE `pc_show_main` (
`shop_id` varchar(200) DEFAULT NULL,
`shop_all_price` double DEFAULT NULL,
`shop_title` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*Data for the table `pc_show_main` */
insert into `pc_show_main`(`shop_id`,`shop_all_price`,`shop_title`) values (NULL,0,'一鸣真鲜店'),(NULL,88,'一鸣真鲜鲜奶吧南岸晶都花园奶吧'),(NULL,9,'一鸣真鲜店(学林街店)'),(NULL,91,'一鸣真鲜鲜奶吧(庆春广场店)'),(NULL,0,'一鸣真鲜店(新塘地铁2店)'),(NULL,0,'一鸣真鲜店(城仕公馆店)'),(NULL,63,'一鸣真鲜店(春江花月店)'),(NULL,35,'一鸣真鲜店(滨江滨兴东苑店)'),(NULL,0,'一鸣真鲜店(拱墅瑷颐湾店)'),(NULL,0,'一鸣真鲜店(晴川街店)');
/
