You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

38 lines
1.8 KiB

3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
  1. -- use DeliveryTakingSystem;
  2. CREATE TABLE `user` (
  3. `id` int(11) NOT NULL AUTO_INCREMENT,
  4. `username` varchar(20) DEFAULT NULL,
  5. `password` varchar(20) DEFAULT NULL,
  6. `phone` varchar(20) DEFAULT NULL,
  7. PRIMARY KEY (`id`)
  8. ) ENGINE=InnoDB;
  9. CREATE TABLE `order` (
  10. `id` int(11) NOT NULL AUTO_INCREMENT,
  11. `description` text,
  12. `when` datetime DEFAULT NULL,
  13. `location` text,
  14. `sender_id` int(11) DEFAULT NULL,
  15. `receiver_id` int(11) DEFAULT NULL,
  16. `price` int(11) DEFAULT NULL,
  17. `status` varchar(20) DEFAULT NULL,
  18. `comment` text,
  19. `timestamp` datetime DEFAULT NULL,
  20. PRIMARY KEY (`id`),
  21. KEY `fk_sender_id` (`sender_id`),
  22. CONSTRAINT `fk_sender_id` FOREIGN KEY (`sender_id`) REFERENCES `user` (`id`)
  23. ) ENGINE=InnoDB;
  24. insert into `user` values(5,"betaberry","100299","110");
  25. insert into `order` values(1,"订单1","2020/12/10","中北校区,河西食堂后面", 5, 1, 10, "已接单","加油!奥力给","2020/12/10 10:30:30");
  26. insert into `order` values(2,"订单2","2020/12/11","中北校区,河西食堂后面", 5, 6, 60, "已接单","加油!奥力给","2020/12/10 10:30:30");
  27. insert into `order` values(3,"订单3","2020/12/12","中北校区,河西食堂后面", 5, 8, 80, "已接单","加油!奥力给","2020/12/10 10:30:30");
  28. insert into `order` values(4,"订单4","2020/12/13","中北校区,河西食堂后面", 5, null, 10, "未接单","加油!奥力给","2020/12/10 10:30:30");
  29. insert into `order` values(5,"订单5","2020/12/14","中北校区,河西食堂后面", 5, null, 60, "未接单","加油!奥力给","2020/12/10 10:30:30");
  30. insert into `order` values(6,"订单6","2020/12/15","中北校区,河西食堂后面", 5, null, 60, "未接单","加油!奥力给","2020/12/10 10:30:30");