-
Notifications
You must be signed in to change notification settings - Fork 7
/
Copy pathdemo.sql
57 lines (37 loc) · 2.38 KB
/
demo.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
#
# SQL Export
# Created by Querious (1068)
# Created: 2017年9月1日 GMT+8 22:20:11
# Encoding: Unicode (UTF-8)
#
SET @PREVIOUS_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`title` varchar(50) NOT NULL DEFAULT '' COMMENT '书名',
`subtitle` varchar(50) NOT NULL DEFAULT '' COMMENT '副标题',
`author` varchar(50) NOT NULL DEFAULT '' COMMENT '作者',
`version` varchar(20) NOT NULL DEFAULT '' COMMENT '版本',
`price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '价格',
`publisher` varchar(50) NOT NULL DEFAULT '' COMMENT '出版社',
`publish_date` varchar(50) NOT NULL DEFAULT '' COMMENT '出版日期',
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
SET FOREIGN_KEY_CHECKS = @PREVIOUS_FOREIGN_KEY_CHECKS;
SET @PREVIOUS_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS;
SET FOREIGN_KEY_CHECKS = 0;
LOCK TABLES `book` WRITE;
ALTER TABLE `book` DISABLE KEYS;
INSERT INTO `book` (`id`, `title`, `subtitle`, `author`, `version`, `price`, `publisher`, `publish_date`, `created_at`, `updated_at`) VALUES
(1,'PHP从入门到精通','','明日科技','第三版',69.80,'清华大学出版社','2012年9月','2017-06-19 17:23:13','2017-06-19 17:36:21'),
(2,'Go语言编程','','许世伟 吕桂华','第一版',49.00,'人民邮电出版社','2012年8月','2017-06-19 17:23:51','2017-06-19 17:36:45'),
(3,'C程序设计','新世纪计算机基础教育丛书','谭浩强','第三版',26.00,'清华大学出版社','2005年7月','2017-06-19 17:24:28','2017-06-19 17:35:22'),
(4,'Docker技术入门与实战','','杨保华 戴王剑 曹亚仑','第一版',59.00,'机械工业出版社','2015年1月','2017-06-19 17:27:23','2017-06-19 17:34:10'),
(5,'Go Web编程','','谢孟军','第一版',65.00,'电子工业出版社','2013年6月','2017-06-19 17:29:54','2017-06-19 17:33:57'),
(6,'鸟哥的Linux私房菜','基础学习篇','鸟哥','第三版',88.00,'人民邮电出版社','2010年8月','2017-06-19 17:32:29','2017-06-19 17:38:08');
ALTER TABLE `book` ENABLE KEYS;
UNLOCK TABLES;
SET FOREIGN_KEY_CHECKS = @PREVIOUS_FOREIGN_KEY_CHECKS;