CREATE TABLE `users_domains` (
    `id` INT NOT NULL AUTO_INCREMENT ,
    `userid` INT NOT NULL ,
    `domain` VARCHAR( 50 ) NOT NULL ,
    `username` VARCHAR( 50 ) NOT NULL ,
    `password` TINYBLOB NOT NULL ,
    `period` INT NOT NULL ,
    `nextbilldate` DATE NOT NULL ,
    `domain_extra_attr` TEXT,
    `registration_option` TINYINT NOT NULL ,
    `registrar` VARCHAR( 20 ) NOT NULL ,
    `registrar_orderid` VARCHAR( 50 ) NOT NULL ,
    `status` TINYINT NOT NULL ,
    PRIMARY KEY ( `id` ) ,
    INDEX ( `userid` )
);
