cpl-create.sql 337 B

1234567891011
  1. CREATE TABLE `cpl` (
  2. `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
  3. `username` VARCHAR(64) NOT NULL,
  4. `domain` VARCHAR(64) DEFAULT '' NOT NULL,
  5. `cpl_xml` TEXT,
  6. `cpl_bin` TEXT,
  7. CONSTRAINT account_idx UNIQUE (`username`, `domain`)
  8. );
  9. INSERT INTO version (table_name, table_version) values ('cpl','1');