MYSQL 用户表

最新推荐文章于 2024-08-11 00:05:10 发布

jingmin

最新推荐文章于 2024-08-11 00:05:10 发布

阅读量4.6k

点赞数

分类专栏： JAVA 文章标签： mysql user null table email

本文链接：https://blog.csdn.net/jingmin/article/details/1393198

版权

JAVA 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

drop table IF EXISTS `group_user`;
drop table IF EXISTS `users`;
drop table IF EXISTS `groups`;

CREATE TABLE `users` (
`user_id` char(32) NOT NULL,
`user_name` varchar(40) NOT NULL,
`user_password` varchar(40) NOT NULL,
`user_email` varchar(60) NOT NULL,
`register_time` datetime default NULL,
`valid` int(1) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

create table `groups` (`group_id` char(32) not null,
    `group_name` varchar(40) not null,
    `description` varchar(40),
    primary key (`group_id`))
    ENGINE=InnoDB DEFAULT CHARSET=utf8;

create table `group_user`(`group_id` char(32) not null,
    `user_id` char(32) not null,
    key(`group_id`),
    key(`user_id`),
    CONSTRAINT `group_user_fk_1` FOREIGN KEY (`group_id`)
    REFERENCES `groups`(`group_id`),
    CONSTRAINT `group_user_fk_2` FOREIGN KEY (`user_id`)
    REFERENCES `users`(`user_id`))
    ENGINE=InnoDB DEFAULT CHARSET=utf8;