You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
17 lines
929 B
SQL
17 lines
929 B
SQL
create table users
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
nickname varchar(100) not null,
|
|
avatar varchar(200) not null,
|
|
dev tinyint default 2 not null comment '1-测试 2-普通',
|
|
pay decimal(8, 2) default -1.00 not null comment '支付金额 负数按实际金额支付',
|
|
status tinyint default 1 not null comment '1-正常 2-禁用',
|
|
del tinyint default 2 not null comment '1-删除 2-正常',
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
INSERT INTO lkpe.users (id, nickname, avatar, dev, pay, status, del, created_at, updated_at) VALUES (1, 'sa0', '/storage/assets/upload/image/2023/04/98e93d7d-5518-432a-9e0e-1533390cb231.png', 1, 0.01, 1, 2, '2023-04-12 11:45:59', '2023-04-13 13:08:08');
|