基础表结构SQL语句
-基础表结构SQL语句
-- ---------------------------- -- Table structure for basetable -- ---------------------------- DROP TABLE IF EXISTS `basetable`; CREATE TABLE `basetable` ( `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号,唯一标识', `Name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称', `AddTime` timestamp(0) NULL DEFAULT NULL COMMENT '添加时间', `UpdateTime` timestamp(0) NULL DEFAULT NULL COMMENT '更新时间', `DeleteState` int(11) NULL DEFAULT 0 COMMENT '删除状态,默认为0,为1表示已删除', `DeleteTime` timestamp(0) NULL DEFAULT NULL COMMENT '删除时间', PRIMARY KEY (`Code`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; SET FOREIGN_KEY_CHECKS = 1;
本文转载 " 整理 "
原文地址 " "