FilesExpand file tree

master

/

initDB.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

16 lines (12 loc) · 419 Bytes

master

/

initDB.sql

Copy path

Top

File metadata and controls

• Code
• Blame

16 lines (12 loc) · 419 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

DROP TABLE IF EXISTS users;

DROP SEQUENCE IF EXISTS user_seq;

DROP TYPE IF EXISTS user_flag;

CREATE TYPE user_flag AS ENUM ('active', 'deleted', 'superuser');

CREATE SEQUENCE user_seq START 100000;

CREATE TABLE users (

id INTEGER PRIMARY KEY DEFAULT nextval('user_seq'),

full_name TEXT NOT NULL,

email TEXT NOT NULL,

flag user_flag NOT NULL

);

CREATE UNIQUE INDEX email_idx ON users (email);