rtpengine-create.sql 397 B

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