forked from htmlk/angular
-
Notifications
You must be signed in to change notification settings - Fork 0
/
mysqlangular.sql
112 lines (81 loc) · 6.65 KB
/
mysqlangular.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
/*
SQLyog 企业版 - MySQL GUI v8.14
MySQL - 5.5.40 : Database - test
*********************************************************************
*/
/*!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*/`test` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `test`;
/*Table structure for table `good` */
DROP TABLE IF EXISTS `good`;
CREATE TABLE `good` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`desc` varchar(255) DEFAULT NULL,
`price` int(20) DEFAULT NULL,
`sum` int(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=121 DEFAULT CHARSET=utf8;
/*Data for the table `good` */
insert into `good`(`id`,`name`,`desc`,`price`,`sum`) values (119,'567','全世界最好吃的苹果',12,115),(118,'567','全世界最好吃的苹果',12,23);
/*Table structure for table `yg_category` */
DROP TABLE IF EXISTS `yg_category`;
CREATE TABLE `yg_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`CategoryId` char(50) DEFAULT NULL,
`CategoryCode` char(50) DEFAULT NULL,
`CategoryName` char(100) DEFAULT NULL,
`Grade` int(11) DEFAULT NULL,
`PriorId` char(50) DEFAULT NULL,
`HighId` char(50) DEFAULT NULL,
`PictureUrl` char(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*Data for the table `yg_category` */
insert into `yg_category`(`id`,`CategoryId`,`CategoryCode`,`CategoryName`,`Grade`,`PriorId`,`HighId`,`PictureUrl`) values (1,'b5fff91c-caef-4a8e-a1b4-bc2f44475110','0101_qiyiguo','奇异果',2,'ad7f227d-73c0-44a2-9edd-924006deb134','8a85c9c0-9e61-4709-92ea-4259c3060ea2',NULL),(2,'afffecb2-ddba-4dbc-9da1-698fdfbcd0f8','0201_pingguo','苹果',2,'1e17a99d-ca4b-49be-908b-93c8faa20baf','1e17a99d-ca4b-49be-908b-93c8faa20baf',NULL);
/*Table structure for table `yg_good` */
DROP TABLE IF EXISTS `yg_good`;
CREATE TABLE `yg_good` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`CommodityId` char(50) DEFAULT NULL,
`CommodityName` char(100) DEFAULT NULL,
`CommodityCode` char(50) DEFAULT NULL,
`OriginalPrice` int(11) DEFAULT NULL,
`CommodityPrice` int(11) DEFAULT NULL,
`Spec` char(50) DEFAULT NULL,
`SpecId` char(50) DEFAULT NULL,
`SmallPic` char(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;
/*Data for the table `yg_good` */
insert into `yg_good`(`id`,`CommodityId`,`CommodityName`,`CommodityCode`,`OriginalPrice`,`CommodityPrice`,`Spec`,`SpecId`,`SmallPic`) values (49,'63206793-55eb-427a-9e0a-45b59b545888','美国青啤梨6个约200g/个(北京)','1208981',69,69,'6个/份','YG10332','http://img13.yiguoimg.com/e/items/2016/161020/9288697816129876_300.jpg'),(50,'f24e71e0-6e54-4c22-82a5-32b80041830d','泰国龙眼2kg','10957',58,58,'2kg/份','YG10067','http://img14.yiguoimg.com/e/items/2016/160810/9288696306442506_300.jpg'),(51,'f6ccde4a-dc81-46fc-8a35-571ee46b56a6','南非柠檬4个（北京）','10403',15,15,'4个/份','YG10068','http://img06.yiguoimg.com/e/web/151010/133902/151010133902555_10403_300.jpg'),(52,'bf65a4e9-2141-456e-b117-8800d7924d52','美国红啤梨12个约210g/个','11830',128,128,'12个/份','YG10423','http://img05.yiguoimg.com/e/web/151117/161716/151117161716161_11830_300.jpg'),(55,'09b8defb-3922-48f8-997f-e177e86cb1cb','进口香蕉2.6kg装（北京）','11421',34,34,'2.6kg/箱','YG10718','http://img08.yiguoimg.com/e/web/151010/145005/151010145005129_11421_300.jpg'),(56,'429c0682-ed97-465b-9dca-572111f8845b','智利嘎啦果20个约140g/个(北京)','1005241',65,65,'20个/份','YG10055','http://img12.yiguoimg.com/e/items/2016/160919/9288697256354099_300.jpg'),(57,'cf2b7e94-338d-4303-851b-6d41ec15a65c','进口香蕉1.3kg装（北京）','12743',18,18,'1.3kg/份','YG10718','http://img05.yiguoimg.com/e/web/151010/145002/151010145002430_12743_300.jpg'),(58,'85e48834-abbe-4961-baad-c5a0163f49c6','美国嘎啦果6个约125g/个','61481',35,35,'6个/份','YG10761','http://img14.yiguoimg.com/e/items/2016/160928/9288697418457404_300.jpg'),(62,'9de07671-6d88-4978-8a0a-551b9252e5e6','美国红提2kg(北京)','11003',109,109,'2kg/份','YG10094','http://img14.yiguoimg.com/e/items/2016/160929/9288697467511101_300.jpg'),(63,'134a485d-4975-41a2-8428-a825f0c943e9','美国无籽红提2kg','10974',160,160,'2kg/份','YG10743','http://img14.yiguoimg.com/e/items/2016/160816/9288696415756560_300.jpg'),(64,'9377b0d3-efd6-436f-9348-5017012c0418','泰国椰青4个装(北京)','12144',59,59,'4个/份','YG10164','http://img11.yiguoimg.com/e/items/2016/160823/9288696600240407_300.jpg'),(65,'8b7d6554-c07f-4cca-a606-c970a35d337b','美国红蛇果8个装（约190g/个）','10975',68,68,'8个/组','YG10056','http://img09.yiguoimg.com/e/items/2016/160922/9288697306784054_300.jpg'),(66,'420b5dad-2e0b-46bc-9eaa-ee5ed94687d9','越南白心火龙果2.8kg（北京）','12064',35,35,'2.8kg/箱','YG10066','http://img11.yiguoimg.com/e/items/2015/151224/9288691316989848_300.jpg'),(67,'57ede725-f7f7-483c-922d-9b5041b5bc71','智利蓝莓2盒（约125g/盒）','11722',77,77,'2盒/份','YG10442','http://img09.yiguoimg.com/e/items/2016/160905/9288696992702757_300.jpg');
/*Table structure for table `yg_menu` */
DROP TABLE IF EXISTS `yg_menu`;
CREATE TABLE `yg_menu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`CategoryId` char(50) DEFAULT NULL,
`CategoryName` char(50) DEFAULT NULL,
`CategoryCode` char(50) DEFAULT NULL,
`Description` char(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*Data for the table `yg_menu` */
insert into `yg_menu`(`id`,`CategoryId`,`CategoryName`,`CategoryCode`,`Description`) values (1,'ad7f227d-73c0-44a2-9edd-924006deb134','进口水果','01_channelhome','奇异果/车厘子/牛油果/柑桔橙柚'),(2,'1e17a99d-ca4b-49be-908b-93c8faa20baf','国产水果','02_channelhome','苹果/梨/猕猴桃/瓜/葡萄/枣');
/*Table structure for table `yg_user` */
DROP TABLE IF EXISTS `yg_user`;
CREATE TABLE `yg_user` (
`id` int(11) DEFAULT NULL,
`name` char(50) DEFAULT NULL,
`pwd` char(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `yg_user` */
insert into `yg_user`(`id`,`name`,`pwd`) values (0,'admin','admin'),(1,'root','root');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;