登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
2 Star 0 Fork 0

闵一鸣/mypetstore后台的管理程序

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
克隆/下载
jpetstore.sql 26.03 KB
一键复制 编辑 原始数据 按行查看 历史
闵一鸣 提交于 2022-03-19 17:42 . first commit
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471
/*

Navicat MySQL Data Transfer



Source Server         : mysql

Source Server Version : 50562

Source Host           : localhost:3306

Source Database       : jpetstore



Target Server Type    : MYSQL

Target Server Version : 50562

File Encoding         : 65001



Date: 2020-04-05 15:28:31

*/



SET FOREIGN_KEY_CHECKS=0;



-- ----------------------------

-- Table structure for account

-- ----------------------------

DROP TABLE IF EXISTS `account`;

CREATE TABLE `account` (

  `userid` varchar(80) NOT NULL,

  `email` varchar(80) NOT NULL,

  `firstname` varchar(80) NOT NULL,

  `lastname` varchar(80) NOT NULL,

  `status` varchar(2) DEFAULT NULL,

  `addr1` varchar(80) NOT NULL,

  `addr2` varchar(40) DEFAULT NULL,

  `city` varchar(80) NOT NULL,

  `state` varchar(80) NOT NULL,

  `zip` varchar(20) NOT NULL,

  `country` varchar(20) NOT NULL,

  `phone` varchar(80) NOT NULL,

  PRIMARY KEY (`userid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of account

-- ----------------------------

INSERT INTO `account` VALUES ('a', 'a', 'a', 'a', null, 'a', 'a', 'aa', 'a', 'a', 'a', 'a');

INSERT INTO `account` VALUES ('ACID', 'acid@yourdomain.com', 'ABC', 'XYX', 'OK', '901 San Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA', '555-555-5555');

INSERT INTO `account` VALUES ('j2ee', 'yourname@yourdomain.com', 'ABC', 'XYX', null, '901 San Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA', '555-555-5555');



-- ----------------------------

-- Table structure for bannerdata

-- ----------------------------

DROP TABLE IF EXISTS `bannerdata`;

CREATE TABLE `bannerdata` (

  `favcategory` varchar(80) NOT NULL,

  `bannername` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`favcategory`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of bannerdata

-- ----------------------------

INSERT INTO `bannerdata` VALUES ('BIRDS', '<image src=\"../images/banner_birds.gif\">');

INSERT INTO `bannerdata` VALUES ('CATS', '<image src=\"../images/banner_cats.gif\">');

INSERT INTO `bannerdata` VALUES ('DOGS', '<image src=\"../images/banner_dogs.gif\">');

INSERT INTO `bannerdata` VALUES ('FISH', '<image src=\"../images/banner_fish.gif\">');

INSERT INTO `bannerdata` VALUES ('REPTILES', '<image src=\"../images/banner_reptiles.gif\">');



-- ----------------------------

-- Table structure for cart

-- ----------------------------

DROP TABLE IF EXISTS `cart`;

CREATE TABLE `cart` (

  `userId` varchar(255) NOT NULL,

  `itemId` varchar(255) NOT NULL,

  `quantity` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of cart

-- ----------------------------



-- ----------------------------

-- Table structure for category

-- ----------------------------

DROP TABLE IF EXISTS `category`;

CREATE TABLE `category` (

  `catid` varchar(10) NOT NULL,

  `name` varchar(80) DEFAULT NULL,

  `descn` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`catid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of category

-- ----------------------------

INSERT INTO `category` VALUES ('BIRDS', 'Birds', '<image src=\"../images/birds_icon.gif\"><font size=\"5\" color=\"blue\"> Birds</font>');

INSERT INTO `category` VALUES ('CATS', 'Cats', '<image src=\"../images/cats_icon.gif\"><font size=\"5\" color=\"blue\"> Cats</font>');

INSERT INTO `category` VALUES ('DOGS', 'Dogs', '<image src=\"../images/dogs_icon.gif\"><font size=\"5\" color=\"blue\"> Dogs</font>');

INSERT INTO `category` VALUES ('FISH', 'Fish', '<image src=\"../images/fish_icon.gif\"><font size=\"5\" color=\"blue\"> Fish</font>');

INSERT INTO `category` VALUES ('REPTILES', 'Reptiles', '<image src=\"../images/reptiles_icon.gif\"><font size=\"5\" color=\"blue\"> Reptiles</font>');



-- ----------------------------

-- Table structure for inventory

-- ----------------------------

DROP TABLE IF EXISTS `inventory`;

CREATE TABLE `inventory` (

  `itemid` varchar(10) NOT NULL,

  `qty` int(11) NOT NULL,

  PRIMARY KEY (`itemid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of inventory

-- ----------------------------

INSERT INTO `inventory` VALUES ('EST-1', '10000');

INSERT INTO `inventory` VALUES ('EST-10', '10000');

INSERT INTO `inventory` VALUES ('EST-11', '10000');

INSERT INTO `inventory` VALUES ('EST-12', '10000');

INSERT INTO `inventory` VALUES ('EST-13', '10000');

INSERT INTO `inventory` VALUES ('EST-14', '10000');

INSERT INTO `inventory` VALUES ('EST-15', '9998');

INSERT INTO `inventory` VALUES ('EST-16', '10000');

INSERT INTO `inventory` VALUES ('EST-17', '10000');

INSERT INTO `inventory` VALUES ('EST-18', '10000');

INSERT INTO `inventory` VALUES ('EST-19', '10000');

INSERT INTO `inventory` VALUES ('EST-2', '10000');

INSERT INTO `inventory` VALUES ('EST-20', '10000');

INSERT INTO `inventory` VALUES ('EST-21', '10000');

INSERT INTO `inventory` VALUES ('EST-22', '10000');

INSERT INTO `inventory` VALUES ('EST-23', '10000');

INSERT INTO `inventory` VALUES ('EST-24', '10000');

INSERT INTO `inventory` VALUES ('EST-25', '10000');

INSERT INTO `inventory` VALUES ('EST-26', '10000');

INSERT INTO `inventory` VALUES ('EST-27', '10000');

INSERT INTO `inventory` VALUES ('EST-28', '10000');

INSERT INTO `inventory` VALUES ('EST-3', '10000');

INSERT INTO `inventory` VALUES ('EST-4', '10000');

INSERT INTO `inventory` VALUES ('EST-5', '10000');

INSERT INTO `inventory` VALUES ('EST-6', '9997');

INSERT INTO `inventory` VALUES ('EST-7', '10000');

INSERT INTO `inventory` VALUES ('EST-8', '10000');

INSERT INTO `inventory` VALUES ('EST-9', '10000');



-- ----------------------------

-- Table structure for item

-- ----------------------------

DROP TABLE IF EXISTS `item`;

CREATE TABLE `item` (

  `itemid` varchar(10) NOT NULL,

  `productid` varchar(10) NOT NULL,

  `listprice` decimal(10,2) DEFAULT NULL,

  `unitcost` decimal(10,2) DEFAULT NULL,

  `supplier` int(11) DEFAULT NULL,

  `status` varchar(2) DEFAULT NULL,

  `attr1` varchar(80) DEFAULT NULL,

  `attr2` varchar(80) DEFAULT NULL,

  `attr3` varchar(80) DEFAULT NULL,

  `attr4` varchar(80) DEFAULT NULL,

  `attr5` varchar(80) DEFAULT NULL,

  PRIMARY KEY (`itemid`),

  KEY `fk_item_2` (`supplier`),

  KEY `itemProd` (`productid`),

  CONSTRAINT `fk_item_1` FOREIGN KEY (`productid`) REFERENCES `product` (`productid`),

  CONSTRAINT `fk_item_2` FOREIGN KEY (`supplier`) REFERENCES `supplier` (`suppid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of item

-- ----------------------------

INSERT INTO `item` VALUES ('EST-1', 'FI-SW-01', '16.50', '10.00', '1', 'P', 'Large', null, null, null, null);

INSERT INTO `item` VALUES ('EST-10', 'K9-DL-01', '18.50', '12.00', '1', 'P', 'Spotted Adult Female', null, null, null, null);

INSERT INTO `item` VALUES ('EST-11', 'RP-SN-01', '18.50', '12.00', '1', 'P', 'Venomless', null, null, null, null);

INSERT INTO `item` VALUES ('EST-12', 'RP-SN-01', '18.50', '12.00', '1', 'P', 'Rattleless', null, null, null, null);

INSERT INTO `item` VALUES ('EST-13', 'RP-LI-02', '18.50', '12.00', '1', 'P', 'Green Adult', null, null, null, null);

INSERT INTO `item` VALUES ('EST-14', 'FL-DSH-01', '58.50', '12.00', '1', 'P', 'Tailless', null, null, null, null);

INSERT INTO `item` VALUES ('EST-15', 'FL-DSH-01', '23.50', '12.00', '1', 'P', 'With tail', null, null, null, null);

INSERT INTO `item` VALUES ('EST-16', 'FL-DLH-02', '93.50', '12.00', '1', 'P', 'Adult Female', null, null, null, null);

INSERT INTO `item` VALUES ('EST-17', 'FL-DLH-02', '93.50', '12.00', '1', 'P', 'Adult Male', null, null, null, null);

INSERT INTO `item` VALUES ('EST-18', 'AV-CB-01', '193.50', '92.00', '1', 'P', 'Adult Male', null, null, null, null);

INSERT INTO `item` VALUES ('EST-19', 'AV-SB-02', '15.50', '2.00', '1', 'P', 'Adult Male', null, null, null, null);

INSERT INTO `item` VALUES ('EST-2', 'FI-SW-01', '16.50', '10.00', '1', 'P', 'Small', null, null, null, null);

INSERT INTO `item` VALUES ('EST-20', 'FI-FW-02', '5.50', '2.00', '1', 'P', 'Adult Male', null, null, null, null);

INSERT INTO `item` VALUES ('EST-21', 'FI-FW-02', '5.29', '1.00', '1', 'P', 'Adult Female', null, null, null, null);

INSERT INTO `item` VALUES ('EST-22', 'K9-RT-02', '135.50', '100.00', '1', 'P', 'Adult Male', null, null, null, null);

INSERT INTO `item` VALUES ('EST-23', 'K9-RT-02', '145.49', '100.00', '1', 'P', 'Adult Female', null, null, null, null);

INSERT INTO `item` VALUES ('EST-24', 'K9-RT-02', '255.50', '92.00', '1', 'P', 'Adult Male', null, null, null, null);

INSERT INTO `item` VALUES ('EST-25', 'K9-RT-02', '325.29', '90.00', '1', 'P', 'Adult Female', null, null, null, null);

INSERT INTO `item` VALUES ('EST-26', 'K9-CW-01', '125.50', '92.00', '1', 'P', 'Adult Male', null, null, null, null);

INSERT INTO `item` VALUES ('EST-27', 'K9-CW-01', '155.29', '90.00', '1', 'P', 'Adult Female', null, null, null, null);

INSERT INTO `item` VALUES ('EST-28', 'K9-RT-01', '155.29', '90.00', '1', 'P', 'Adult Female', null, null, null, null);

INSERT INTO `item` VALUES ('EST-3', 'FI-SW-02', '18.50', '12.00', '1', 'P', 'Toothless', null, null, null, null);

INSERT INTO `item` VALUES ('EST-4', 'FI-FW-01', '18.50', '12.00', '1', 'P', 'Spotted', null, null, null, null);

INSERT INTO `item` VALUES ('EST-5', 'FI-FW-01', '18.50', '12.00', '1', 'P', 'Spotless', null, null, null, null);

INSERT INTO `item` VALUES ('EST-6', 'K9-BD-01', '18.50', '12.00', '1', 'P', 'Male Adult', null, null, null, null);

INSERT INTO `item` VALUES ('EST-7', 'K9-BD-01', '18.50', '12.00', '1', 'P', 'Female Puppy', null, null, null, null);

INSERT INTO `item` VALUES ('EST-8', 'K9-PO-02', '18.50', '12.00', '1', 'P', 'Male Puppy', null, null, null, null);

INSERT INTO `item` VALUES ('EST-9', 'K9-DL-01', '18.50', '12.00', '1', 'P', 'Spotless Male Puppy', null, null, null, null);



-- ----------------------------

-- Table structure for lineitem

-- ----------------------------

DROP TABLE IF EXISTS `lineitem`;

CREATE TABLE `lineitem` (

  `orderid` int(11) NOT NULL,

  `linenum` int(11) NOT NULL,

  `itemid` varchar(10) NOT NULL,

  `quantity` int(11) NOT NULL,

  `unitprice` decimal(10,2) NOT NULL,

  PRIMARY KEY (`orderid`,`linenum`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of lineitem

-- ----------------------------

INSERT INTO `lineitem` VALUES ('1000', '1', 'EST-6', '3', '18.50');

INSERT INTO `lineitem` VALUES ('1000', '2', 'EST-15', '2', '23.50');



-- ----------------------------

-- Table structure for log

-- ----------------------------

DROP TABLE IF EXISTS `log`;

CREATE TABLE `log` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `username` varchar(255) DEFAULT NULL,

  `ip` varchar(255) NOT NULL,

  `type` varchar(255) DEFAULT NULL,

  `operation` varchar(255) NOT NULL,

  `date` datetime DEFAULT NULL,

  `remark` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of log

-- ----------------------------

INSERT INTO `log` VALUES ('1', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 15:35:52', null);

INSERT INTO `log` VALUES ('2', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 15:35:57', null);

INSERT INTO `log` VALUES ('3', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 15:51:16', null);

INSERT INTO `log` VALUES ('4', null, '127.0.0.1', 'INFO', '用户查看商品(categoryId: REPTILES)', '2020-03-31 15:51:19', null);

INSERT INTO `log` VALUES ('5', null, '127.0.0.1', 'INFO', '用户查看商品(productId: RP-LI-02)', '2020-03-31 15:51:20', null);

INSERT INTO `log` VALUES ('6', null, '127.0.0.1', 'INFO', '用户查看商品(itemId: EST-13)', '2020-03-31 15:51:21', null);

INSERT INTO `log` VALUES ('7', null, '127.0.0.1', 'INFO', '搜索商品(keyword: Amazon Parrot)', '2020-03-31 15:51:51', null);

INSERT INTO `log` VALUES ('8', null, '127.0.0.1', 'INFO', '用户查看商品(productId: AV-CB-01)', '2020-03-31 15:51:54', null);

INSERT INTO `log` VALUES ('9', null, '127.0.0.1', 'INFO', '用户查看商品(itemId: EST-18)', '2020-03-31 15:51:55', null);

INSERT INTO `log` VALUES ('10', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:17:14', null);

INSERT INTO `log` VALUES ('11', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:17:19', null);

INSERT INTO `log` VALUES ('12', 'j2ee', '127.0.0.1', 'INFO', '查看订单列表', '2020-03-31 16:17:22', null);

INSERT INTO `log` VALUES ('13', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(categoryId: DOGS)', '2020-03-31 16:17:23', null);

INSERT INTO `log` VALUES ('14', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(productId: K9-BD-01)', '2020-03-31 16:17:24', null);

INSERT INTO `log` VALUES ('15', 'j2ee', '127.0.0.1', 'INFO', '添加物品到购物车(itemId: EST-6)', '2020-03-31 16:17:25', null);

INSERT INTO `log` VALUES ('16', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(categoryId: CATS)', '2020-03-31 16:17:27', null);

INSERT INTO `log` VALUES ('17', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(productId: FL-DSH-01)', '2020-03-31 16:17:28', null);

INSERT INTO `log` VALUES ('18', 'j2ee', '127.0.0.1', 'INFO', '添加物品到购物车(itemId: EST-15)', '2020-03-31 16:17:29', null);

INSERT INTO `log` VALUES ('19', 'j2ee', '127.0.0.1', 'INFO', '新增订单', '2020-03-31 16:17:37', null);

INSERT INTO `log` VALUES ('20', 'j2ee', '127.0.0.1', 'INFO', '确认订单', '2020-03-31 16:17:40', null);

INSERT INTO `log` VALUES ('21', 'j2ee', '127.0.0.1', 'INFO', '查看订单列表', '2020-03-31 16:17:45', null);

INSERT INTO `log` VALUES ('22', 'j2ee', '127.0.0.1', 'INFO', '查看订单(orderId: 1000)', '2020-03-31 16:17:46', null);

INSERT INTO `log` VALUES ('23', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(itemId: EST-6)', '2020-03-31 16:17:48', null);

INSERT INTO `log` VALUES ('24', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:18:05', null);

INSERT INTO `log` VALUES ('25', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:18:10', null);

INSERT INTO `log` VALUES ('26', 'j2ee', '127.0.0.1', 'INFO', '查看订单列表', '2020-03-31 16:18:12', null);

INSERT INTO `log` VALUES ('27', 'j2ee', '127.0.0.1', 'INFO', '查看订单(orderId: 1000)', '2020-03-31 16:18:14', null);

INSERT INTO `log` VALUES ('28', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(itemId: EST-6)', '2020-03-31 16:18:15', null);

INSERT INTO `log` VALUES ('29', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(categoryId: CATS)', '2020-03-31 16:18:16', null);

INSERT INTO `log` VALUES ('30', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(productId: K9-BD-01)', '2020-03-31 16:18:20', null);

INSERT INTO `log` VALUES ('31', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(categoryId: DOGS)', '2020-03-31 16:18:21', null);

INSERT INTO `log` VALUES ('32', 'j2ee', '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:18:22', null);

INSERT INTO `log` VALUES ('33', 'j2ee', '127.0.0.1', 'INFO', '搜索商品(keyword: b)', '2020-03-31 16:18:27', null);

INSERT INTO `log` VALUES ('34', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(productId: K9-BD-01)', '2020-03-31 16:18:28', null);

INSERT INTO `log` VALUES ('35', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(itemId: EST-7)', '2020-03-31 16:18:29', null);

INSERT INTO `log` VALUES ('36', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(categoryId: FISH)', '2020-03-31 16:18:37', null);

INSERT INTO `log` VALUES ('37', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:33:55', null);

INSERT INTO `log` VALUES ('38', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:34:01', null);

INSERT INTO `log` VALUES ('39', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:34:28', null);

INSERT INTO `log` VALUES ('40', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:34:32', null);

INSERT INTO `log` VALUES ('41', 'j2ee', '127.0.0.1', 'INFO', '查看订单列表', '2020-03-31 16:34:36', null);

INSERT INTO `log` VALUES ('42', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:36:19', null);

INSERT INTO `log` VALUES ('43', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:36:22', null);

INSERT INTO `log` VALUES ('44', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:38:07', null);

INSERT INTO `log` VALUES ('45', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:38:10', null);

INSERT INTO `log` VALUES ('46', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:38:19', null);

INSERT INTO `log` VALUES ('47', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(categoryId: REPTILES)', '2020-03-31 16:38:21', null);

INSERT INTO `log` VALUES ('48', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:39:53', null);

INSERT INTO `log` VALUES ('49', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:39:59', null);

INSERT INTO `log` VALUES ('50', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:42:38', null);

INSERT INTO `log` VALUES ('51', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:42:42', null);

INSERT INTO `log` VALUES ('52', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:47:57', null);

INSERT INTO `log` VALUES ('53', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:49:03', null);

INSERT INTO `log` VALUES ('54', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:49:56', null);

INSERT INTO `log` VALUES ('55', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:50:23', null);

INSERT INTO `log` VALUES ('56', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:50:28', null);

INSERT INTO `log` VALUES ('57', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:51:43', null);

INSERT INTO `log` VALUES ('58', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:51:47', null);

INSERT INTO `log` VALUES ('59', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:52:38', null);

INSERT INTO `log` VALUES ('60', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:53:56', null);

INSERT INTO `log` VALUES ('61', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:54:03', null);

INSERT INTO `log` VALUES ('62', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-03-31 16:54:10', null);

INSERT INTO `log` VALUES ('63', 'j2ee', '127.0.0.1', 'INFO', '查看订单列表', '2020-03-31 16:54:13', null);

INSERT INTO `log` VALUES ('64', 'j2ee', '127.0.0.1', 'INFO', '查看订单(orderId: 1000)', '2020-03-31 16:54:14', null);

INSERT INTO `log` VALUES ('65', 'j2ee', '127.0.0.1', 'INFO', '用户进入主界面', '2020-03-31 16:54:19', null);

INSERT INTO `log` VALUES ('66', null, '127.0.0.1', 'INFO', '用户进入主界面', '2020-04-01 21:56:06', null);

INSERT INTO `log` VALUES ('67', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-04-05 15:16:40', null);

INSERT INTO `log` VALUES ('68', 'j2ee', '127.0.0.1', 'INFO', '查看购物车', '2020-04-05 15:16:43', null);

INSERT INTO `log` VALUES ('69', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-04-05 15:19:44', null);

INSERT INTO `log` VALUES ('70', 'j2ee', '127.0.0.1', 'INFO', '查看购物车', '2020-04-05 15:19:47', null);

INSERT INTO `log` VALUES ('71', 'j2ee', '127.0.0.1', 'INFO', '用户登录', '2020-04-05 15:22:06', null);

INSERT INTO `log` VALUES ('72', 'j2ee', '127.0.0.1', 'INFO', '查看购物车', '2020-04-05 15:22:08', null);

INSERT INTO `log` VALUES ('73', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(categoryId: CATS)', '2020-04-05 15:22:11', null);

INSERT INTO `log` VALUES ('74', 'j2ee', '127.0.0.1', 'INFO', '用户查看商品(productId: FL-DLH-02)', '2020-04-05 15:22:12', null);



-- ----------------------------

-- Table structure for orders

-- ----------------------------

DROP TABLE IF EXISTS `orders`;

CREATE TABLE `orders` (

  `orderid` int(11) NOT NULL,

  `userid` varchar(80) NOT NULL,

  `orderdate` date NOT NULL,

  `shipaddr1` varchar(80) NOT NULL,

  `shipaddr2` varchar(80) DEFAULT NULL,

  `shipcity` varchar(80) NOT NULL,

  `shipstate` varchar(80) NOT NULL,

  `shipzip` varchar(20) NOT NULL,

  `shipcountry` varchar(20) NOT NULL,

  `billaddr1` varchar(80) NOT NULL,

  `billaddr2` varchar(80) DEFAULT NULL,

  `billcity` varchar(80) NOT NULL,

  `billstate` varchar(80) NOT NULL,

  `billzip` varchar(20) NOT NULL,

  `billcountry` varchar(20) NOT NULL,

  `courier` varchar(80) NOT NULL,

  `totalprice` decimal(10,2) NOT NULL,

  `billtofirstname` varchar(80) NOT NULL,

  `billtolastname` varchar(80) NOT NULL,

  `shiptofirstname` varchar(80) NOT NULL,

  `shiptolastname` varchar(80) NOT NULL,

  `creditcard` varchar(80) NOT NULL,

  `exprdate` varchar(7) NOT NULL,

  `cardtype` varchar(80) NOT NULL,

  `locale` varchar(80) NOT NULL,

  PRIMARY KEY (`orderid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of orders

-- ----------------------------

INSERT INTO `orders` VALUES ('1000', 'j2ee', '2020-03-31', '901 San Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA', '901 San Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA', 'UPS', '102.50', 'ABC', 'XYX', 'ABC', 'XYX', '999 9999 9999 9999', '12/03', 'Visa', 'CA');



-- ----------------------------

-- Table structure for orderstatus

-- ----------------------------

DROP TABLE IF EXISTS `orderstatus`;

CREATE TABLE `orderstatus` (

  `orderid` int(11) NOT NULL,

  `linenum` int(11) NOT NULL,

  `timestamp` date NOT NULL,

  `status` varchar(2) NOT NULL,

  PRIMARY KEY (`orderid`,`linenum`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of orderstatus

-- ----------------------------

INSERT INTO `orderstatus` VALUES ('1000', '1000', '2020-03-31', 'P');



-- ----------------------------

-- Table structure for product

-- ----------------------------

DROP TABLE IF EXISTS `product`;

CREATE TABLE `product` (

  `productid` varchar(10) NOT NULL,

  `category` varchar(10) NOT NULL,

  `name` varchar(80) DEFAULT NULL,

  `descn` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`productid`),

  KEY `productCat` (`category`),

  KEY `productName` (`name`),

  CONSTRAINT `fk_product_1` FOREIGN KEY (`category`) REFERENCES `category` (`catid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of product

-- ----------------------------

INSERT INTO `product` VALUES ('AV-CB-01', 'BIRDS', 'Amazon Parrot', '../images/bird2.gif Great companion for up to 75 years');

INSERT INTO `product` VALUES ('AV-SB-02', 'BIRDS', 'Finch', '../images/bird1.gif Great stress reliever');

INSERT INTO `product` VALUES ('FI-FW-01', 'FISH', 'Koi', '../images/fish3.gif Fresh Water fish from Japan');

INSERT INTO `product` VALUES ('FI-FW-02', 'FISH', 'Goldfish', '../images/fish2.gif Fresh Water fish from China');

INSERT INTO `product` VALUES ('FI-SW-01', 'FISH', 'Angelfish', '../images/fish1.jpg Salt Water fish from Australia');

INSERT INTO `product` VALUES ('FI-SW-02', 'FISH', 'Tiger Shark', '../images/fish4.gif Salt Water fish from Australia');

INSERT INTO `product` VALUES ('FL-DLH-02', 'CATS', 'Persian', '../images/cat1.gif Friendly house cat, doubles as a princess');

INSERT INTO `product` VALUES ('FL-DSH-01', 'CATS', 'Manx', '../images/cat2.gif Great for reducing mouse populations');

INSERT INTO `product` VALUES ('K9-BD-01', 'DOGS', 'Bulldog', '../images/dog2.gif Friendly dog from England');

INSERT INTO `product` VALUES ('K9-CW-01', 'DOGS', 'Chihuahua', '../images/dog4.gif Great companion dog');

INSERT INTO `product` VALUES ('K9-DL-01', 'DOGS', 'Dalmation', '../images/dog5.gif Great dog for a Fire Station');

INSERT INTO `product` VALUES ('K9-PO-02', 'DOGS', 'Poodle', '../images/dog6.gif Cute dog from France');

INSERT INTO `product` VALUES ('K9-RT-01', 'DOGS', 'Golden Retriever', '../images/dog1.gif Great family dog');

INSERT INTO `product` VALUES ('K9-RT-02', 'DOGS', 'Labrador Retriever', '../images/dog3.gif Great hunting dog');

INSERT INTO `product` VALUES ('RP-LI-02', 'REPTILES', 'Iguana', '../images/lizard1.gif Friendly green friend');

INSERT INTO `product` VALUES ('RP-SN-01', 'REPTILES', 'Rattlesnake', '../images/lizard1.gif Doubles as a watch dog');



-- ----------------------------

-- Table structure for profile

-- ----------------------------

DROP TABLE IF EXISTS `profile`;

CREATE TABLE `profile` (

  `userid` varchar(80) NOT NULL,

  `langpref` varchar(80) NOT NULL,

  `favcategory` varchar(30) DEFAULT NULL,

  `mylistopt` tinyint(1) DEFAULT NULL,

  `banneropt` tinyint(1) DEFAULT NULL,

  PRIMARY KEY (`userid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of profile

-- ----------------------------

INSERT INTO `profile` VALUES ('a', 'japanese', 'DOGS', null, null);

INSERT INTO `profile` VALUES ('ACID', 'english', 'CATS', '1', '1');

INSERT INTO `profile` VALUES ('j2ee', 'english', 'FISH', '1', '1');



-- ----------------------------

-- Table structure for sequence

-- ----------------------------

DROP TABLE IF EXISTS `sequence`;

CREATE TABLE `sequence` (

  `name` varchar(30) NOT NULL,

  `nextid` int(11) NOT NULL,

  PRIMARY KEY (`name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of sequence

-- ----------------------------

INSERT INTO `sequence` VALUES ('linenum', '1000');

INSERT INTO `sequence` VALUES ('ordernum', '1001');



-- ----------------------------

-- Table structure for signon

-- ----------------------------

DROP TABLE IF EXISTS `signon`;

CREATE TABLE `signon` (

  `username` varchar(25) NOT NULL,

  `password` varchar(25) NOT NULL,

  PRIMARY KEY (`username`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of signon

-- ----------------------------

INSERT INTO `signon` VALUES ('a', 'a');

INSERT INTO `signon` VALUES ('ACID', 'ACID');

INSERT INTO `signon` VALUES ('j2ee', 'j2ee');



-- ----------------------------

-- Table structure for supplier

-- ----------------------------

DROP TABLE IF EXISTS `supplier`;

CREATE TABLE `supplier` (

  `suppid` int(11) NOT NULL,

  `name` varchar(80) DEFAULT NULL,

  `status` varchar(2) NOT NULL,

  `addr1` varchar(80) DEFAULT NULL,

  `addr2` varchar(80) DEFAULT NULL,

  `city` varchar(80) DEFAULT NULL,

  `state` varchar(80) DEFAULT NULL,

  `zip` varchar(5) DEFAULT NULL,

  `phone` varchar(80) DEFAULT NULL,

  PRIMARY KEY (`suppid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of supplier

-- ----------------------------

INSERT INTO `supplier` VALUES ('1', 'XYZ Pets', 'AC', '600 Avon Way', '', 'Los Angeles', 'CA', '94024', '212-947-0797');

INSERT INTO `supplier` VALUES ('2', 'ABC Pets', 'AC', '700 Abalone Way', '', 'San Francisco ', 'CA', '94024', '415-947-0797');
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/atq1234/mypetstore-management-2.git
git@gitee.com:atq1234/mypetstore-management-2.git
atq1234
mypetstore-management-2
mypetstore后台的管理程序
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部