git.squeep.com Git - websub-hub/blob - src/db/postgres/sql/schema/init.sql

   1 --
   2 CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
   3 CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
   4
   5 --
   6 BEGIN;
   7 CREATE TABLE IF NOT EXISTS _meta_schema_version (
   8         major BIGINT NOT NULL,
   9         minor BIGINT NOT NULL,
  10         patch BIGINT NOT NULL,
  11         applied TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
  12         PRIMARY KEY (major, minor, patch)
  13 );
  14 INSERT INTO _meta_schema_version (major, minor, patch) VALUES (0, 0, 0);
  15 COMMIT;