1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98
|
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `diningcar`; CREATE TABLE `diningcar` ( `id` int(11) NOT NULL COMMENT '点餐编号', `userid` int(11) NOT NULL COMMENT '用户编号', `foodid` int(11) NOT NULL COMMENT '菜品编号', PRIMARY KEY (`id`) USING BTREE, INDEX `userid`(`userid`) USING BTREE, INDEX `foodid`(`foodid`) USING BTREE, CONSTRAINT `diningcar_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `diningcar_ibfk_2` FOREIGN KEY (`foodid`) REFERENCES `food` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
DROP TABLE IF EXISTS `food`; CREATE TABLE `food` ( `id` int(11) NOT NULL COMMENT '菜品编号', `foodname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜品名称', `feature` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '特色', `material` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '食材', `price` int(11) NOT NULL COMMENT '价格', `type` int(11) NOT NULL COMMENT '分类', `picture` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片', `hits` int(11) NOT NULL COMMENT '点餐率', `commcnt` int(11) NOT NULL COMMENT '备注(-1:正常菜;0:厨师推荐菜品;正整数:特价菜品价格)', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `foodname_index`(`foodname`) USING BTREE, INDEX `type_index`(`type`) USING BTREE, CONSTRAINT `food_ibfk_1` FOREIGN KEY (`type`) REFERENCES `foodtype` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
DROP TABLE IF EXISTS `foodtype`; CREATE TABLE `foodtype` ( `id` int(11) NOT NULL COMMENT '分类编号', `typename` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类名称', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `typename`(`typename`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL COMMENT '用户编号', `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名', `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码', `ident` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户身份(0:普通用户;1:管理员)', `telephone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '电话', `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '地址', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `username_index`(`username`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;
SET FOREIGN_KEY_CHECKS = 1;
|