rtpengine-create.sql 428 B

123456789101112
  1. CREATE TABLE rtpengine (
  2. id INTEGER PRIMARY KEY NOT NULL,
  3. setid INTEGER DEFAULT 0 NOT NULL,
  4. url VARCHAR(64) NOT NULL,
  5. weight INTEGER DEFAULT 1 NOT NULL,
  6. disabled INTEGER DEFAULT 0 NOT NULL,
  7. stamp TIMESTAMP WITHOUT TIME ZONE DEFAULT '1900-01-01 00:00:01' NOT NULL,
  8. CONSTRAINT rtpengine_rtpengine_nodes UNIQUE (setid, url)
  9. );
  10. INSERT INTO version (table_name, table_version) values ('rtpengine','1');