db_config/SQL/pgsql.initial.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

CREATE TABLE IF NOT EXISTS db_config (
  id serial PRIMARY KEY,
  env varchar(255) DEFAULT NULL,
  conf text,
  admin varchar(128) NOT NULL
);

CREATE TABLE IF NOT EXISTS "system" (
  name varchar(64) NOT NULL PRIMARY KEY,
  value text
);

INSERT INTO "system" (name, value) VALUES ('myrc_db_config', 'initial');