mysql demo sql 初始化数据库--- highlight: a11y-dark --- ```sql CRE


CREATE database db_test;   
USE db_test;   
CREATE TABLE t_user (   
    `id` BIGINT AUTO_INCREMENT PRIMARY KEY,   
    `username` VARCHAR(50) NOT NULL,     
    `mobile` VARCHAR(100) NOT NULL,    
    `email` VARCHAR(100) DEFAULT NULL, 
    `birthdate` DATE  DEFAULT NULL,     
    `is_active`  BOOLEAN DEFAULT TRUE,     
    `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,     
    `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,            
    `deleted_at` datetime NULL DEFAULT NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';