dispatcher-create.sql 402 B

123456789101112
  1. CREATE TABLE dispatcher (
  2. id INTEGER PRIMARY KEY NOT NULL,
  3. setid INTEGER DEFAULT 0 NOT NULL,
  4. destination VARCHAR(192) DEFAULT '' NOT NULL,
  5. flags INTEGER DEFAULT 0 NOT NULL,
  6. priority INTEGER 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');