sample数据库建立

最新推荐文章于 2024-04-01 09:43:08 发布

qianxinwuhen

最新推荐文章于 2024-04-01 09:43:08 发布

阅读量633

点赞数 1

CC 4.0 BY-SA版权

文章标签：数据库 user login database character table

本文链接：https://blog.youkuaiyun.com/qianxinwuhen/article/details/4815238

DROP DATABASE IF EXISTS sampledb;
CREATE DATABASE sampledb DEFAULT CHARACTER SET utf8;
USE sampledb;

##创建用户表
CREATE TABLE t_user (
   user_id   INT AUTO_INCREMENT PRIMARY KEY,
   user_name VARCHAR(30),
   credits INT,
   password VARCHAR(32),
   last_visit datetime,
   last_ip VARCHAR(23)
)ENGINE=InnoDB;

##创建用户登录日志表
CREATE TABLE t_login_log (
   login_log_id INT AUTO_INCREMENT PRIMARY KEY,
   user_id   INT,
   ip VARCHAR(23),
   login_datetime datetime
)ENGINE=InnoDB;

   alter table t_login_log
        add constraint FKB86
        foreign key (user_id)
        references t_user(user_id);

##插入初始化数据
INSERT INTO t_user (user_name,password)
             VALUES('admin','123456');
COMMIT;