基于Android点餐系统毕业设计

CREATE DATABASE IF NOT EXISTS `mydata` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `mydata`; -- MySQL dump 10.13 Distrib 5.6.13, for Win32 (x86) -- -- Host: localhost Database: mydata -- ------------------------------------------------------ -- Server version 5.6.16-enterprise-commercial-advanced /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 */; -- -- Table structure for table `order_log` -- DROP TABLE IF EXISTS `order_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `order_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_rec_id` varchar(11) NOT NULL, `order_id` varchar(11) NOT NULL, `order_sum` varchar(11) DEFAULT '1', `price` varchar(11) NOT NULL, `op_type` varchar(10) DEFAULT '0', `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `order_log` -- LOCK TABLES `order_log` WRITE; /*!40000 ALTER TABLE `order_log` DISABLE KEYS */; INSERT INTO `order_log` VALUES (1,'1','1','1','25','0','2016-12-06 12:12:24'),(2,'1','2','1','7.92','0','2016-12-06 12:12:24'),(3,'1','3','1','88','0','2016-12-06 12:12:24'),(4,'1','4','1','55.44','0','2016-12-06 12:12:25'),(5,'1','5','1','128','0','2016-12-06 12:12:25'),(6,'1','8','4','308.88','0','2016-12-06 12:12:25'),(7,'1','11','2','280.8','0','2016-12-06 12:12:25'),(8,'1','13','2','254.84','0','2016-12-06 12:12:25'),(9,'2','5','1','128','0','2016-12-06 13:30:37'),(10,'2','8','1','77.22','0','2016-12-06 13:30:37'),(11,'2','13','1','127.42','0','2016-12-06 13:30:37'),(12,'3','2','2','15.84','0','2016-12-11 03:52:42'),(13,'4','1','1','25','0','2016-12-15 06:30:04'),(14,'4','5','1','128','0','2016-12-15 06:30:04'),(15,'4','6','1','58.08','0','2016-12-15 06:30:04'),(16,'4','7','1','88','0','2016-12-15 06:30:04'),(17,'4','8','1','77.22','0','2016-12-15 06:30:04'),(18,'5','5','1','128','0','2016-12-20 03:28:51'),(19,'5','8','1','77.22','0','2016-12-20 03:28:51'),(20,'5','13','1','127.42','0','2016-12-20 03:28:51'),(21,'6','1','1','25','0','2016-12-20 03:38:13'),(22,'6','2','1','7.92','0','2016-12-20 03:38:13'),(23,'7','1','1','25','0','2016-12-20 03:43:34'),(24,'7','2','1','7.92','0','2016-12-20 03:43:34'),(25,'8','3','3','264','0','2016-12-20 03:46:30'),(26,'8','4','1','55.44','0','2016-12-20 03:46:30'),(27,'9','1','2','50','0','2016-12-20 04:24:59'),(28,'9','2','2','15.84','0','2016-12-20 04:25:00'),(29,'9','3','3','264','0','2016-12-20 04:25:00'),(30,'9','4','7','388.08','0','2016-12-20 04:25:00'),(31,'9','5','3','384','0','2016-12-20 04:25:00'),(32,'10','2','1','7.92','0','2016-12-20 05:00:30'),(33,'10','3','1','88','0','2016-12-20 05:00:30'),(34,'11','3','2','176','0','2016-12-20 05:38:29'),(35,'11','4','2','110.88','0','2016-12-20 05:38:29'),(36,'11','10','1','73.8','0','2016-12-20 05:38:29'),(37,'12','2','1','7.92','0','2016-12-20 05:41:16'),(38,'12','3','3','264','0','2016-12-20 05:41:16'),(39,'12','5','1','128','0','2016-12-20 05:41:16'),(40,'12','7','1','88','0','2016-12-20 05:41:16'),(41,'13','1','2','50','0','2016-12-20 14:16:32'),(42,'13','3','1','88','0','2016-12-20 14:16:33'),(43,'13','4','1','55.44','0','2016-12-20 14:16:33'),(44,'14','1','1','25','0','2017-01-05 00:58:07'),(45,'14','2','1','7.92','0','2017-01-05 00:58:07'),(46,'14','3','1','88','0','2017-01-05 00:58:07'),(47,'14','4','1','55.44','0','2017-01-05 00:58:07'),(48,'15','5','1','128','0','2017-01-05 01:01:22'),(49,'15','7','1','88','0','2017-01-05 01:01:23'),(50,'15','10','1','73.8','0','2017-01-05 01:01:23'),(51,'15','11','1','140.4','0','2017-01-05 01:01:23'),(52,'16','2','2','15.84','0','2017-01-05 01:28:20'),(53,'17','1','1','25','0','2017-01-05 02:31:24'),(54,'17','5','1','128','0','2017-01-05 02:31:24'),(55,'18','2','5','39.6','0','2017-01-05 02:32:14'),(56,'18','8','1','77.22','0','2017-01-05 02:32:14'),(57,'19','2','1','7.92','0','2017-01-05 02:40:46'),(58,'19','9','1','55.44','0','2017-01-05 02:40:46'),(59,'19','11','1','140.4','0','2017-01-05 02:40:46'),(60,'20','3','4','352','0','2017-01-05 02:41:55'); /*!40000 ALTER TABLE `order_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_rec` -- DROP TABLE IF EXISTS `order_rec`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `order_rec` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rec_id` varchar(11) NOT NULL, `login_id` varchar(11) NOT NULL, `desk_id` varchar(11) NOT NULL, `guests_num` varchar(11) NOT NULL, `status` varchar(2) NOT NULL, `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `order_rec` -- LOCK TABLES `order_rec` WRITE; /*!40000 ALTER TABLE `order_rec` DISABLE KEYS */; INSERT INTO `order_rec` VALUES (1,'1','simple','1','3','2','2016-12-06 12:12:24'),(2,'2','simple','5','5','3','2016-12-06 13:30:37'),(3,'3','simple','4','7','3','2016-12-11 03:52:42'),(4,'4','simple','10','4','2','2016-12-15 06:30:03'),(5,'5','simple','6','7','1','2016-12-20 03:28:50'),(6,'6','simple','3','7','3','2016-12-20 03:38:13'),(7,'7','simple','8','8','1','2016-12-20 03:43:34'),(8,'8','simple','9','2','1','2016-12-20 03:46:29'),(9,'9','simple','10','5','1','2016-12-20 04:24:58'),(10,'10','simple','12','3','1','2016-12-20 05:00:30'),(11,'11','simple','10','3','1','2016-12-20 05:38:29'),(12,'12','simple','12','4','1','2016-12-20 05:41:15'),(13,'13','simple','10','5','3','2016-12-20 14:16:32'),(14,'14','admin','5','3','3','2017-01-05 00:58:06'),(15,'15','Taste','6','4','1','2017-01-05 01:01:22'),(16,'16','Taste','4','2','1','2017-01-05 01:28:20'),(17,'17','simple','4','3','1','2017-01-05 02:31:24'),(18,'18','simple','3','5','1','2017-01-05 02:32:14'),(19,'19','Taste','5','2','1','2017-01-05 02:40:45'),(20,'20','Taste','5','2','1','2017-01-05 02:41:55'); /*!40000 ALTER TABLE `order_rec` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders` -- DROP TABLE IF EXISTS `orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `description` varchar(400) DEFAULT NULL, `type` varchar(30) NOT NULL, `order_version` varchar(10) DEFAULT '0', `image_path` varchar(255) DEFAULT NULL, `price` varchar(20) NOT NULL, `is_delete` varchar(1) DEFAULT '0', `update_at` varchar(20) DEFAULT NULL, `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `discount` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orders` -- LOCK TABLES `orders` WRITE; /*!40000 ALTER TABLE `orders` DISABLE KEYS */; INSERT INTO `orders` VALUES (1,'红烧肉',' 红烧肉起码有上百年的历史，也起码有上百种烧法，这也是很受欢迎的一道家常美味。肥而不腻、酥而不碎、甜而不粘、浓而不咸。','recommend','7','file/images/1481783260563.png','25','0','2016-12-15 14:27:40','2016-12-05 03:40:06','1'),(2,'松�