dispatcher-create.sql 400 B

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