data make

数据编写

piano

INSERT INTO piano (piano_list, piano_rule, piano_status, piano_id, piano_room, piano_picurl, piano_info, piano_stuvalue, piano_teavalue, piano_socvalue, piano_multivalue, piano_type)VALUES          ('000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',1,0, 201, 'this is a nice pic', '201房间琴声音动听，手感细腻',15,20,25,30,'叶葳蕤钢琴');
INSERT INTO piano (piano_list, piano_rule, piano_status, piano_id, piano_room, piano_picurl, piano_info, piano_stuvalue, piano_teavalue, piano_socvalue, piano_multivalue, piano_type)VALUES          ('000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',1,1, 202, 'this is a nice pic', '202房间琴声音动听，手感细腻',15,20,25,30,'吴海旭钢琴');
INSERT INTO piano (piano_list, piano_rule, piano_status, piano_id, piano_room, piano_picurl, piano_info, piano_stuvalue, piano_teavalue, piano_socvalue, piano_multivalue, piano_type)VALUES          ('000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 1,2, 203, 'this is a nice pic', '203房间琴声音动听，手感细腻',15,20,25,30,'赵哲晖钢琴');
INSERT INTO piano (piano_list, piano_rule, piano_status, piano_id, piano_room, piano_picurl, piano_info, piano_stuvalue, piano_teavalue, piano_socvalue, piano_multivalue, piano_type)VALUES          ('000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 1,3, 204, 'this is a nice pic', '204房间琴声音动听，手感细腻',15,20,25,30,'陈曦钢琴');

notice

INSERT INTO notice (notice_title, notice_cont, notice_time, notice_auth,notice_type)VALUES('清华大学放假两个月', '经过不知道哪里的同学讨论，近两个月的雾霾严重，故全员放假。望相关同学做好回家准备。', '2018-11-14 08:00:00', '小吴同学',1);
INSERT INTO notice (notice_title, notice_cont, notice_time, notice_auth,notice_type)VALUES('THU琴房预约上线', '经过多方协调，小程序终于上线，各位用户可以在线预约琴房啦。', '2018-11-14 09:00:00', '小吴同学',1);