Alec Smith <[EMAIL PROTECTED]> wrote:
> I have two tables as below:
>
> CREATE TABLE domain_types (
> type_id INT(4) NOT NULL AUTO_INCREMENT,
> name VARCHAR(10) UNIQUE NOT NULL,
> description VARCHAR(75),
> PRIMARY KEY(type_id)
> ) TYPE=INNODB COMMENT="Types of domains we store";
>
> CREATE T
I have two tables as below:
CREATE TABLE domain_types (
type_id INT(4) NOT NULL AUTO_INCREMENT,
name VARCHAR(10) UNIQUE NOT NULL,
description VARCHAR(75),
PRIMARY KEY(type_id)
) TYPE=INNODB COMMENT="Types of domains we store";
CREATE TABLE domains (
domain_id INT(6) NOT NULL AUTO_INCREM