uac-create.sql 650 B

12345678910111213141516
  1. INSERT INTO version (table_name, table_version) values ('uacreg','1');
  2. CREATE TABLE uacreg (
  3. id INTEGER PRIMARY KEY NOT NULL,
  4. l_uuid VARCHAR(64) DEFAULT '' NOT NULL,
  5. l_username VARCHAR(64) DEFAULT '' NOT NULL,
  6. l_domain VARCHAR(128) DEFAULT '' NOT NULL,
  7. r_username VARCHAR(64) DEFAULT '' NOT NULL,
  8. r_domain VARCHAR(128) DEFAULT '' NOT NULL,
  9. realm VARCHAR(64) DEFAULT '' NOT NULL,
  10. auth_username VARCHAR(64) DEFAULT '' NOT NULL,
  11. auth_password VARCHAR(64) DEFAULT '' NOT NULL,
  12. auth_proxy VARCHAR(64) DEFAULT '' NOT NULL,
  13. expires INTEGER DEFAULT 0 NOT NULL,
  14. CONSTRAINT uacreg_l_uuid_idx UNIQUE (l_uuid)
  15. );