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
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
