uri_db-create.sql 418 B

1234567891011
  1. CREATE TABLE uri (
  2. id INTEGER PRIMARY KEY NOT NULL,
  3. username VARCHAR(64) DEFAULT '' NOT NULL,
  4. domain VARCHAR(64) DEFAULT '' NOT NULL,
  5. uri_user VARCHAR(64) DEFAULT '' NOT NULL,
  6. last_modified TIMESTAMP WITHOUT TIME ZONE DEFAULT '2000-01-01 00:00:01' NOT NULL,
  7. CONSTRAINT uri_account_idx UNIQUE (username, domain, uri_user)
  8. );
  9. INSERT INTO version (table_name, table_version) values ('uri','1');