dispatcher-create.sql 430 B

123456789101112
  1. CREATE TABLE `dispatcher` (
  2. `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
  3. `setid` INT DEFAULT 0 NOT NULL,
  4. `destination` VARCHAR(192) DEFAULT '' NOT NULL,
  5. `flags` INT DEFAULT 0 NOT NULL,
  6. `priority` INT DEFAULT 0 NOT NULL,
  7. `attrs` VARCHAR(128) DEFAULT '' NOT NULL,
  8. `description` VARCHAR(64) DEFAULT '' NOT NULL
  9. );
  10. INSERT INTO version (table_name, table_version) values ('dispatcher','4');