[SR-Users] Kamailio 3.0.2 mysql create table domain definition

[Stagg Shelton]

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