db-lab1/test/DBTest.sql

8 lines
192 B
MySQL
Raw Permalink Normal View History

2021-11-26 10:37:49 +08:00
DROP TABLE IF EXISTS db_test;
CREATE TABLE db_test (
id serial PRIMARY KEY,
name character varying(255) NOT NULL UNIQUE,
active boolean NOT NULL,
email character varying(255),
code int
);