10月18日作业-MYSQL新增表及导出
16lz
2021-10-19
用户表
SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for php_user-- ----------------------------DROP TABLE IF EXISTS `php_user`;CREATE TABLE `php_user` (`id` int(11) NOT NULL,`uid` int(11) NULL DEFAULT NULL,`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`mobile` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;SET FOREIGN_KEY_CHECKS = 1;
商品表
SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for php_goods-- ----------------------------DROP TABLE IF EXISTS `php_goods`;CREATE TABLE `php_goods` (`id` int(11) NOT NULL,`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`price` decimal(10, 2) NULL DEFAULT NULL,`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;SET FOREIGN_KEY_CHECKS = 1;
订单表
SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for php_order-- ----------------------------DROP TABLE IF EXISTS `php_order`;CREATE TABLE `php_order` (`id` int(11) NOT NULL,`goods_id` int(11) NULL DEFAULT NULL,`uid` int(11) NULL DEFAULT NULL,`pay_price` decimal(10, 2) NULL DEFAULT NULL,`pay_time` datetime NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;SET FOREIGN_KEY_CHECKS = 1;
更多相关文章
- 仿作京东网页
- 【前端】手机端页面购物车功能JS如何实现产品数量，商品价格去相加
- 给购物车加上选择时自动计算功能
- 用户注册表单以及选择器权重与上下文选择器
- 什么是虚拟主机？虚拟主机的优点和缺点有什么？
- SEO内容策略有哪几种？
- 影响搜索排名的用户行为
- 拼团小程序功能及商家怎样通过拼团盈利
- 意派Epub360|2021中秋H5互动案例大比拼