Salt-Library/SQL/data.sql at main · zcysxy/Salt-Library · GitHub

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
/* Books */
INSERT INTO books(ISBN, title, author, publisher, publish_year, publish_month, price) VALUES
    ('9787500742586', '长袜子皮皮', '阿斯特丽德·林格伦', '中国少年儿童出版社', 1999, 3, 17.80),
    ('9787208072107', '灿烂千阳', '卡勒德·胡赛尼', '上海人民出版社', 2007, 9, 28.00),
    ('9787020081080', '而河马被煮死在水槽里', '杰克·凯鲁亚克', '人民文学出版社', 2012, 1, 20.00),
    ('9787020095599', '尘埃落定', '阿来', '人民文学出版社', 2013, 4, 38.00),
    ('9787506344791', '俗世奇人', '冯骥才', '作家出版社', 2008, 12, 18.00),
    ('9787020114825', '上升的一切必将汇合', '弗兰纳里·奥康纳', '人民文学出版社', 2016, 10, 38.00),
    ('9787532763863', '来自新世界', '贵志祐介', '上海译文出版社', 2014, 4, 88.00),
    ('9787550297142', '美国众神', '尼尔·盖曼', '北京联合出版公司', 2017, 4, 69.90),
    ('9787305137990', '染血之室与其他故事', '安吉拉·卡特', '南京大学出版社', 2015, 1, 22.00),
    ('9787544769297', '覆舟的愉悦', '朱塞培·翁加雷蒂', '译林出版社', 2018, 2, 56),
    ('9787020033768', '食指的诗', '食指', '人民文学出版社', 2000, 12, 12.00),
    ('9787532750214', '死于威尼斯', '托马斯·曼', '上海译文出版社', 2010, 5, 20.00),
    ('9787508653167', '所有我们看不见的光', '安东尼·多尔', '中信出版集团', 2015, 8, 42.00),
    ('9787532776337', '使女的故事', '玛格丽特·阿特伍德', '上海译文出版社', 2017, 12, 49.00),
    ('9787549574209', '痖弦诗集', '痖弦', '广西师范大学出版社', 2016, 1, 59.00),
    ('9787530213636', '动物凶猛', '王朔', '北京十月文艺出版社', 2015, 3, 35.00),
    ('9787545914634', '欢喜在人间', '汪曾祺', '鹭江出版社', 2018, 4, 42.00),
    ('9787544261654', '米格尔街', 'V.S.奈保尔', '南海出版公司', 2013, 7, 28.00),
    ('9787544738309', '白噪音', '唐·德里罗', '译林出版社', 2013, 9, 42),
    ('9787544707206', '万有引力之虹', '托马斯·品钦', '译林出版社', 2009, 1, 48.00);

INSERT INTO miners VALUES
    ('zcysxy', MD5('1234'), 'zcy', '18300180101@fudan.edu.cn', '13600000000', 2, 20, '2008-11-1'),
    ('zcy', MD5('1234'), 'zcy', 'zcysxy.wyzdz@gmail.com', '13600000000', 2, 18, '2018-11-1'),
    ('cmy', MD5('1234'), 'Mia', 'mia@163.com', '13500000000', 1, 20, '2021-04-28'),
    ('wcy', MD5('1234'), 'Little Price', 'prince@hotmail.com', '13400000000', 0, 20, '2021-04-15'),
    ('yph', MD5('1234'), 'Miss Yu', 'peihuayu@qilin.com', '13600000000', 1, 20, '2021-04-25'),
    ('liven', MD5('1234'), 'Liven', 'wentaolai@nssy.com', '13600000000', 0, 20, '2021-03-18'),
    ('jhh', MD5('1234'), 'Sister Jiang', 'haohanjiang@sms.com', '13500000000', 2, 20, '2021-2-1'),
    ('hld', MD5('1234'), 'Mr Huang', '18300180100@fudan.edu.cn', '15700000000', 0, 19, '2021-5-5'),
    ('lyf', MD5('1234'), 'TA Liang', '20212010026@fudan.edu.cn', NULL, 1, 18, '2021-06-02'),
    ('gzq', MD5('1234'), 'TA Guan', '20212010034@fudan.edu.cn', NULL, 0, 18, '2021-06-02'),
    ('lt', MD5('1234'), 'Professor Lu', 'tunlu@fudan.edu.cn', NULL, 0, 18, '2021-06-02')