sql.migration.V20150502124700__CreateDepartments.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of actor-persist Show documentation

actor-persist

There is a newer version: 3.0.0

CREATE extension IF NOT EXISTS ltree;
CREATE TABLE departments (
    id int NOT NULL PRIMARY KEY,
    name varchar(255) NOT NULL,
    struct ltree NOT NULL,
    deleted_at TIMESTAMP
);
CREATE UNIQUE INDEX departments_struct_idx ON departments (struct);
CREATE TABLE user_department(
    user_id int NOT NULL,
    department_id int NOT NULL,
    PRIMARY KEY(user_id, department_id)
);