8 lines
312 B
SQL
8 lines
312 B
SQL
CREATE TABLE public.account
|
|
(
|
|
id uuid DEFAULT public.uuid_generate_v4() PRIMARY KEY NOT NULL,
|
|
account varchar(100) NOT NULL,
|
|
password varchar(200) NOT NULL,
|
|
ctime timestamp with time zone DEFAULT current_timestamp NOT NULL,
|
|
mtime timestamp with time zone DEFAULT current_timestamp NOT NULL
|
|
); |