patch-slot_roles-table.sql

   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
   7 CREATE UNIQUE INDEX role_name ON slot_roles (role_name);