taskcafe/migrations/0007_add-organization-table.up.sql

8 lines
239 B
MySQL
Raw Permalink Normal View History

2020-04-10 04:40:22 +02:00
CREATE TABLE organization (
organization_id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
created_at timestamptz NOT NULL,
name text NOT NULL
);
INSERT INTO organization (created_at, name) VALUES (NOW(), 'sys_default_organization');