rtpengine-create.sql 401 B

1234567891011
  1. CREATE TABLE `rtpengine` (
  2. `setid` INT(10) UNSIGNED DEFAULT 0 NOT NULL,
  3. `url` VARCHAR(64) NOT NULL,
  4. `weight` INT(10) UNSIGNED DEFAULT 1 NOT NULL,
  5. `disabled` INT(1) DEFAULT 0 NOT NULL,
  6. `stamp` DATETIME DEFAULT '1900-01-01 00:00:01' NOT NULL,
  7. CONSTRAINT rtpengine_nodes PRIMARY KEY (`setid`, `url`)
  8. );
  9. INSERT INTO version (table_name, table_version) values ('rtpengine','1');