Hello,
The script in the source scripts/mysql/my_create.sql uses the the following definition
CREATE TABLE domain ( did VARCHAR(64) NOT NULL, domain VARCHAR(128) NOT NULL, flags INT UNSIGNED NOT NULL DEFAULT '0', UNIQUE KEY domain_idx (domain), KEY did_idx (did) );
The script in the source utils/kamctl/mysql/domain-create.sql uses the following definition
CREATE TABLE domain ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, domain VARCHAR(64) DEFAULT '' NOT NULL, last_modified DATETIME DEFAULT '1900-01-01 00:00:01' NOT NULL, CONSTRAINT domain_idx UNIQUE (domain) ) ENGINE=MyISAM;
Which table definition is the correct definition to be used.
Thanks Stagg Shelton