基于Python Django实现的餐厅点餐系统源代码+数据库

/* SQLyog Community v13.1.1 (32 bit) MySQL - 5.7.29 : Database - osdb ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`osdb` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `osdb`; /*Table structure for table `category` */ DROP TABLE IF EXISTS `category`; CREATE TABLE `category` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜品分类id', `shop_id` int(11) DEFAULT NULL COMMENT '店铺id', `name` varchar(50) DEFAULT NULL COMMENT '分类名称', `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1正常 9删除', `create_at` datetime DEFAULT NULL COMMENT '添加时间', `update_at` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8; /*Data for the table `category` */ insert into `category`(`id`,`shop_id`,`name`,`status`,`create_at`,`update_at`) values (1,1,'双拼套餐',1,'2020-07-25 10:20:30','2020-07-25 10:20:30'), (2,1,'盖饭',1,'2020-07-25 10:20:30','2020-07-25 10:20:30'), (3,1,'小菜',1,'2020-07-25 10:20:30','2020-07-25 10:20:30'), (4,1,'汤/饮料',1,'2020-07-25 10:20:30','2020-07-25 10:20:30'), (5,2,'双拼套餐',1,'2020-07-25 10:20:30','2020-07-25 10:20:30'), (6,2,'盖饭',1,'2020-07-25 10:20:30','2020-07-25 10:20:30'), (7,2,'小菜',1,'2020-07-25 10:20:30','2020-07-25 10:20:30'), (8,2,'汤/饮料',1,'2020-07-25 10:20:30','2020-07-25 10:20:30'), (9,3,'盖饭',1,'2020-07-25 10:20:30','2020-07-25 10:20:30'), (10,3,'双拼套餐',1,'2020-07-25 10:20:30','2020-07-25 10:20:30'), (11,3,'小炒',1,'2020-07-25 10:20:30','2020-07-25 10:20:30'), (13,3,'bbbbb',1,'2020-08-15 13:01:17','2020-08-15 13:11:45'); /*Table structure for table `django_migrations` */ DROP TABLE IF EXISTS `django_migrations`; CREATE TABLE `django_migrations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `app` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `applied` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `django_migrations` */ /*Table structure for table `django_session` */ DROP TABLE IF EXISTS `django_session`; CREATE TABLE `django_session` ( `session_key` varchar(40) NOT NULL, `session_data` longtext NOT NULL, `expire_date` datetime(6) NOT NULL, PRIMARY KEY (`session_key`), KEY `django_session_expire_date_a5c62663` (`expire_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `django_session` */ insert into `django_session`(`session_key`,`session_data`,`expire_date`) values ('4glsi74lggeu9jvrql457uyu24fnjqqf','ZWI4YzJkMzE0OGMwZGMzZjFiMWVhMmJiMGFjODU0NDgwOWFkYzhhMTp7InZlcmlmeWNvZGUiOiI1Mjk1IiwibW9iaWxldXNlciI6eyJpZCI6MTgsIm5pY2tuYW1lIjoiXHU5ODdlXHU1YmEyIiwiYXZhdGFyIjoibW9yZW4ucG5nIiwibW9iaWxlIjoiMTIzNDU2Nzg5MDgiLCJzdGF0dXMiOjF9LCJzaG9waW5mbyI6eyJpZCI6MSwibmFtZSI6Ilx1NzUzMFx1ODAwMVx1NWUwOFx1N2VhMlx1NzBlN1x1ODA4OSIsInNob3AiOiJcdTY3MWRcdTk2MzNcdTVjMDZcdTUzZjBcdThkZWZcdTVlOTciLCJjb3Zlcl9waWMiOiIxMjM0MTIzNC5qcGciLCJiYW5uZXJfcGljIjoibGcuanBnIiwiYWRkcmVzcyI6Ilx1NTMxN1x1NGVhY1x1NWUwMlx1NjcxZFx1OTYzM1x1NTMzYVx1NWMwNlx1NTNmMFx1NGU2MVx1NGUxY1x1NTE2Ylx1OTVmNFx1NjIzZlx1Njc1MVx1ODk3Zlx1NGUzNDhcdTUzZjciLCJwaG9uZSI6IjEyMzQ1Njc4OTA1Iiwic3RhdHVzIjoxLCJjcmVhdGVfYXQiOiIyMDIwLTA3LTIwIDEwOjEyOjM0IiwidXBkYXRlX2F0IjoiMjAyMC0wNy0yNCAxMjozNDo1NiJ9fQ==','2020-09-11 02:36:46.772005'), ('9v574nheq1zd2al4jaw4citzw68vmmer','Y2JkYTFiYWY4M2I1NTY0YzgxNmZhNTE1OTA1OTI2YmUwYzU1NWExZjp7InNob3BpbmZvIjp7ImlkIjoxLCJuYW1lIjoiXHU3NTMwXHU4MDAxXHU1ZTA4XHU3ZWEyXHU3MGU3XHU4MDg5Iiwic2hvcCI6Ilx1NjcxZFx1OTYzM1x1NWMwNlx1NTNmMFx1OGRlZlx1NWU5NyIsImNvdmVyX3BpYyI6IjEyMzQxMjM0LmpwZyIsImJhbm5lcl9waWMiOiJsZy5qcGciLCJhZGRyZXNzIjoiXHU1MzE3XHU0ZWFjXHU1ZTAyXHU2NzFkXHU5NjMzXHU1MzNhXHU1YzA2XHU1M2YwXHU0ZTYxXHU0ZTFjXHU1MTZiXHU5NWY0XHU2MjNmXHU2NzUxXHU4OTdmXHU0ZTM0OFx1NTNmNyIsInBob25lIjoiMTIzNDU2Nzg5MDUiLCJzdGF0dXMiOjEsImNyZWF0ZV9hdCI6IjIwMjAtMDctMjAgMTA6MTI6MzQiLCJ1cGRhdGVfYXQiOiIyMDIwLTA3LTI0IDEyOjM0OjU2In0sInZlcmlmeWNvZGUiOiIxODUzIiwiY2F0ZWdvcnlsaXN0Ijp7IjEiOnsiaWQiOjEsIm5hbWUiOiJcdTUzY2NcdTYyZmNcdTU5NTdcdTk5MTAiLCJwaWRzIjpbeyJpZCI6MSwic2hvcF9pZCI6MSwiY2F0ZWdvcnlfaWQiOjEsImNvdmVyX3BpYyI6IjE1MzY2NTc2MjAuNTQ4NTcwNC5qcGciLCJuYW1lIjoiXHU3ZWEyXHU3MGU3XHU4MDg5K1x1NzJlZVx1NWI1MFx1NTkzNCtcdTk5NmVcdTY1OTkiLCJwcmljZSI6MjUuMCwic3RhdHVzIjoxLCJjcmVhdGVfYXQiOiIyMDIwLTA3LTExIDA5OjIwOjIwIiwidXBkYXRlX2F0IjoiMjAyMC0wNy0yNSAxMDoyMDozMCJ9LHsiaWQiOjIsInNob3BfaWQiOjEsImNhdGVnb3J5X2lkIjoxLCJjb3Zlcl9waWMiOiIxNTM2NjU4MzUyLjkzNDE1NTcuanBnIiwibmFtZSI6Ilx1N2VhMlx1NzBlN1x1ODA4OStcdTc1NmFcdTgzMDRcdTllMjFcdTg2Y2IiLCJwcmljZSI6MjIuMCwic3RhdHVzIjoxLCJjcmVhdGVfYXQiOiIyMDIwLTA3LTExIDA5OjMyOjMyIiwidXBkYXRlX2F0IjoiMjAyMC0wNy0yNSAxMDoyMDozMCJ9LHsiaWQiOjMsInNob3BfaWQiOjEsImNhdGVnb3J5X2lkIjoxLCJjb3Zlcl9waWMiOiIxNTM2NjU4NDE1LjY4MzgwMDIuanBnIiwibmFtZSI6Ilx1Njg4NVx1ODNkY1x1NjI2M1x1ODA4OStcdTc1NmFcdTgzMDRcdTllMjFcdTg2Y2IiLCJwcmljZSI6MjIuMCwic3RhdHVzIjoxLCJjcmVhdGVfYXQiOiIyMDIwLTA3LTExIDA5OjMzOjM1IiwidXBkYXRlX2F0IjoiMjAyMC0wNy0yNSAxMDoyMDozMCJ9LHsiaWQiOjQsInNob3BfaWQiOjEsImNhdGVnb3J5X2lkIjoxLCJjb3Zlcl9waWMiOiIxNTM2NjU4NTc0LjI4NDczNzMuanBnIiwibmFtZSI6Ilx1ODBhNVx1NzI1YitcdTc1NmFcdTgzMDRcdTllMjFcdTg2Y2IiLCJwcmljZSI6MjIuMCwic3RhdHVzIjoxLCJjcmVhdGVfYXQiOiIyMDIwLTA3LTExIDA5OjM2OjE0IiwidXBkYXRlX2F0IjoiMjAyMC0wNy0yNSAxMDoyMDozMCJ9XX0sIjIiOnsiaWQiOjIsIm5hbWUiOiJcdTc2ZDZcdTk5NmQiLCJwaWRzIjpbeyJpZCI6NSwic2hvcF9pZCI6MSwiY2F0ZWdvcnlfaWQiOjIsImNvdmVyX3BpYyI6IjE1MzY2NTg2NTkuMDQ0Njk5My5qcGciLCJuYW1lIjoiXHU2ODg1XHU4M2RjXHU2MjYzXHU4MDg5XHU5OTZkIiwicHJpY2UiOjE5LjAsInN0YXR1cyI6MSwiY3JlYXRlX2F0IjoiMjAyMC0wNy0xMSAwOTozNzozOSIsInVwZGF0ZV9hdCI6IjIwMjAtMDctMjUgMTA6MjA6MzAifSx7ImlkIjo2LCJzaG9wX2lkIjoxLCJjYXRlZ29yeV9pZCI6MiwiY292ZXJfcGljIjoiMTUzNjY1ODgyNC4zOTc2NTA1LmpwZyIsIm5hbWUiOiJcdTY3MjhcdTk4N2JcdTgwODlcdTk5NmQiLCJwcmljZSI6MTYuMCwic3RhdHVzIjoxLCJjcmVhdGVfYXQiOiIyMDIwLTA3LTExIDA5OjQwOjI0IiwidXBkYXRlX2F0IjoiMjAyMC0wNy0yNSAxMDoyMDozMCJ9LHsiaWQiOjcsInNob3BfaWQiOjEsImNhdGVnb3J5X2lkIjoyLCJjb3Zlcl9waWMiOiIxNTM2NjU4ODYzLjY3MzI4NTUuanBnIiwibmFtZSI6Ilx1ODBhNVx1NzI1Ylx1OTk2ZCIsInByaWNlIjoxOS4wLCJzdGF0dXMiOjEsImNyZWF0ZV9hdCI6IjIwMjAtMDctMTEgMDk6NDE6MDMiLCJ1cGRhdGVfYXQiOiIyMDIwLTA3LTI1IDEwOjIwOjMwIn0seyJpZCI6OCwic2hvcF9pZCI6MSwiY2F0ZWdvcnlfaWQiOjIsImNvdmVyX3BpYyI6IjE1MzY2NTg5NjAuMzk1NDEzNC5qcGciLCJuYW1lIjoiXHU2NWUwXHU5YWE4XHU1NDk2XHU1NWIxXHU5ZTIxXHU5OTZkIiwicHJpY2UiOjE4LjAsInN0YXR1cyI6MSwiY3JlYXRlX2F0IjoiMjAyMC0wNy0xMSAwOTo0Mjo0MCIsInVwZGF0ZV9hdCI6IjIwMjAtMDctMjUgMTA6MjA6MzAifV19LCIzIjp7ImlkIjozLCJuYW1lIjoiXHU1YzBmXHU4M2RjIiwicGlkcyI6W3siaWQiOjksInNob3BfaWQiOjEsImNhdGVnb3J5X2lkIjozLCJjb3Zlcl9waWMiOiIxNTM2NjU5MTE0LjA0NDAyMzUuanBnIiwibmFtZSI6Ilx1NjcyOFx1OTg3Ylx1ODA4OSIsInByaWNlIjoxMi4wLCJzdGF0dXMiOjEsImNyZWF0ZV9hdCI6IjIwMjAtMDctMTEgMDk6NDQ6MjUiLCJ1cGRhdGVfYXQiOiIyMDIwLTA3LTI1IDEwOjIwOjMwIn0seyJpZCI6MTAsInNob3BfaWQiOjEsImNhdGVnb3J5X2lkIjozLCJjb3Zlcl9waWMiOiIxNTM2NjU5MDY1Ljc5NzI2MzcuanBnIiwibmFtZSI6Ilx1NzU2YVx1ODMwNFx1OWUyMVx1ODZjYiIsInByaWNlIjo0LjAsInN0YXR1cyI6MSwiY3JlYXRlX2F0IjoiMjAyMC0wNy0xMSAwOTo0NToxNCIsInVwZGF0ZV9hdCI6IjIwMjAtMDctMjUgMTA6MjA6MzAifSx7ImlkIjoxMSwic2hvcF9pZCI6MSwiY2F0ZWdvcnlfaWQiOjMsImNvdmVyX3BpYyI6IjE1MzY2NTkxOTcuNzIzMTIyMS5qcGciLCJuYW1lIjoiXHU5NzUyXHU4M2RjIiwicHJpY2UiOjQuMCwic3RhdHVzIjoxLCJjcmVhdGVfYXQiOiIyMDIwLTA3LTExIDA5OjQ2OjM3IiwidXBkYXRlX2F0IjoiMjAyMC0wNy0yNSAxMDoyMDozMCJ9LHsiaWQiOjEyLCJzaG9wX2lkIjoxLCJjYXRlZ29yeV9pZCI6MywiY292ZXJfcGljIjoiMTUzNjY1OTI1My44ODQyNzE2LmpwZyIsIm5hbWUiOiJcdTUzNTVcdTRlZmRcdTk5OTlcdThmYTNcdTdiMGJcdTVlNzJcdTcwZTdcdTgwODkiLCJwcmljZSI6MTUuMCwic3RhdHVzIjoxLCJjcmVhdGVfYXQiOiIyMDIwLTA3LTExIDA5OjQ3OjMzIiwidXBkYXRlX2F0IjoiMjAyMC0wNy0yNSAxMDoyMDozMCJ9XX0sIjQiOnsiaWQiOjQsIm5hbWUiOiJcdTZjNjQvXHU5OTZlXHU2NTk5IiwicGlkcyI6W3siaWQiOjEzLCJzaG9wX2lkIjoxLCJjYXRlZ29yeV9pZCI6NCwiY292