Вы не можете выбрать более 25 тем
Темы должны начинаться с буквы или цифры, могут содержать дефисы(-) и должны содержать не более 35 символов.
38 строки
1.8 KiB
38 строки
1.8 KiB
|
|
-- use DeliveryTakingSystem;
|
|
|
|
CREATE TABLE `user` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`username` varchar(20) DEFAULT NULL,
|
|
`password` varchar(20) DEFAULT NULL,
|
|
`phone` varchar(20) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB;
|
|
|
|
|
|
CREATE TABLE `order` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`description` text,
|
|
`when` datetime DEFAULT NULL,
|
|
`location` text,
|
|
`sender_id` int(11) DEFAULT NULL,
|
|
`receiver_id` int(11) DEFAULT NULL,
|
|
`price` int(11) DEFAULT NULL,
|
|
`status` varchar(20) DEFAULT NULL,
|
|
`comment` text,
|
|
`timestamp` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `fk_sender_id` (`sender_id`),
|
|
CONSTRAINT `fk_sender_id` FOREIGN KEY (`sender_id`) REFERENCES `user` (`id`)
|
|
) ENGINE=InnoDB;
|
|
|
|
|
|
insert into `user` values(5,"betaberry","100299","110");
|
|
|
|
insert into `order` values(1,"订单1","2020/12/10","中北校区，河西食堂后面", 5, 1, 10, "已接单","加油！奥力给","2020/12/10 10:30:30");
|
|
insert into `order` values(2,"订单2","2020/12/11","中北校区，河西食堂后面", 5, 6, 60, "已接单","加油！奥力给","2020/12/10 10:30:30");
|
|
insert into `order` values(3,"订单3","2020/12/12","中北校区，河西食堂后面", 5, 8, 80, "已接单","加油！奥力给","2020/12/10 10:30:30");
|
|
insert into `order` values(4,"订单4","2020/12/13","中北校区，河西食堂后面", 5, null, 10, "未接单","加油！奥力给","2020/12/10 10:30:30");
|
|
insert into `order` values(5,"订单5","2020/12/14","中北校区，河西食堂后面", 5, null, 60, "未接单","加油！奥力给","2020/12/10 10:30:30");
|
|
insert into `order` values(6,"订单6","2020/12/15","中北校区，河西食堂后面", 5, null, 60, "未接单","加油！奥力给","2020/12/10 10:30:30");
|
|
|