当前位置：首页 > news >正文

SQL创建数据表的一些语句

news 2025/7/9 7:05:19

SQL创建数据表


/*Navicat Premium Data TransferSource Server         : dockermysqlSource Server Type    : MySQLSource Server Version : 80023Source Host           : localhost:3306Source Schema         : nestleTarget Server Type    : MySQLTarget Server Version : 80023File Encoding         : 65001Date: 14/04/2024 03:09:46
*/SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (`id` int(0) NOT NULL AUTO_INCREMENT,`username` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`email` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`password_hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`created_at` datetime(0) NULL DEFAULT NULL,`updated_at` datetime(0) 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;


/*Navicat Premium Data TransferSource Server         : dockermysqlSource Server Type    : MySQLSource Server Version : 80023Source Host           : localhost:3306Source Schema         : thTarget Server Type    : MySQLTarget Server Version : 80023File Encoding         : 65001Date: 14/04/2024 20:24:55
*/SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;-- ----------------------------
-- Table structure for projects
-- ----------------------------
DROP TABLE IF EXISTS `projects`;
CREATE TABLE `projects`  (`id` int(0) NOT NULL AUTO_INCREMENT,`name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,`city` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`status` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`predict_contract` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`created_at` datetime(0) NULL DEFAULT NULL,`updated_at` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE,UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for timenodes
-- ----------------------------
DROP TABLE IF EXISTS `timenodes`;
CREATE TABLE `timenodes`  (`id` int(0) NOT NULL AUTO_INCREMENT,`name` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,`start` datetime(6) NULL DEFAULT NULL,`end` datetime(6) NULL DEFAULT NULL,`project_id` int(0) NULL DEFAULT NULL,`created_at` datetime(0) NULL DEFAULT NULL,`updated_at` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE,INDEX `project_id`(`project_id`) USING BTREE,CONSTRAINT `timenodes_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for todos
-- ----------------------------
DROP TABLE IF EXISTS `todos`;
CREATE TABLE `todos`  (`id` int(0) NOT NULL AUTO_INCREMENT,`name` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,`priority` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`project_id` int(0) NULL DEFAULT NULL,`created_at` datetime(0) NULL DEFAULT NULL,`updated_at` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE,INDEX `project_id`(`project_id`) USING BTREE,CONSTRAINT `todos_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for travelitems
-- ----------------------------
DROP TABLE IF EXISTS `travelitems`;
CREATE TABLE `travelitems`  (`id` int(0) NOT NULL AUTO_INCREMENT,`name` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`category` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`total` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`ticket_id` int(0) NULL DEFAULT NULL,`created_at` datetime(0) NULL DEFAULT NULL,`updated_at` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE,INDEX `ticket_id`(`ticket_id`) USING BTREE,CONSTRAINT `travelitems_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `traveltickets` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for traveltickets
-- ----------------------------
DROP TABLE IF EXISTS `traveltickets`;
CREATE TABLE `traveltickets`  (`id` int(0) NOT NULL AUTO_INCREMENT,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`project_id` int(0) NULL DEFAULT NULL,`created_at` datetime(0) NULL DEFAULT NULL,`updated_at` datetime(0) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE,UNIQUE INDEX `name`(`name`) USING BTREE,INDEX `project_id`(`project_id`) USING BTREE,CONSTRAINT `traveltickets_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (`id` int(0) NOT NULL AUTO_INCREMENT,`username` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`email` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`password_hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`created_at` datetime(0) NULL DEFAULT NULL,`updated_at` datetime(0) 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;