Hello,

On 7/27/10 1:22 PM, Henning Westerholt wrote:
On Monday 26 July 2010, Stagg Shelton wrote:
The script in the source scripts/mysql/my_create.sql  uses the the
following definition

CREATE TABLE domain (
      did VARCHAR(64) NOT NULL,
[..]
);

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,
[..]
) ENGINE=MyISAM;

Which table definition is the correct definition to be used.
Hi Stagg,

the first one is the version for the domain module from sr (modules_s), the
latter is the one for the kamailio (modules_k) domain module.
just to mention that in this particular case both structure should work as modules_k/domain uses only domain column. There is no effect if there are other columns around.

But as Henning said, the structure specified by kamailio is the one created by kamdbctl (i.e., kamdbctl create) and managed via kamctl.

Cheers,
Daniel

--
Daniel-Constantin Mierla
http://www.asipto.com/


_______________________________________________
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

Reply via email to