patch-slot_roles-table.sql 245 B

1234567
  1. CREATE SEQUENCE slot_roles_role_id_seq;
  2. CREATE TABLE slot_roles (
  3. role_id SMALLINT NOT NULL PRIMARY KEY DEFAULT nextval('slot_roles_role_id_seq'),
  4. role_name TEXT NOT NULL
  5. );
  6. CREATE UNIQUE INDEX role_name ON slot_roles (role_name);