pdt-create.sql 338 B

123456789
  1. INSERT INTO version (table_name, table_version) values ('pdt','1');
  2. CREATE TABLE pdt (
  3. id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
  4. sdomain VARCHAR(128) NOT NULL,
  5. prefix VARCHAR(32) NOT NULL,
  6. domain VARCHAR(128) DEFAULT '' NOT NULL,
  7. CONSTRAINT sdomain_prefix_idx UNIQUE (sdomain, prefix)
  8. ) ENGINE=MyISAM;