in VHCS 2.4.8rc1 war's das:
Code:
CREATE TABLE `admin` (
`admin_id` int(10) unsigned NOT NULL auto_increment,
`admin_name` varchar(200) default NULL,
`admin_pass` varchar(200) default NULL,
`admin_type` varchar(10) default NULL,
`domain_created` int(10) unsigned NOT NULL default '0',
`customer_id` varchar(200) default NULL,
`created_by` int(10) unsigned default NULL,
`fname` varchar(200) default NULL,
`lname` varchar(200) default NULL,
`firm` varchar(200) default NULL,
`zip` varchar(10) default NULL,
`city` varchar(200) default NULL,
`country` varchar(200) default NULL,
`email` varchar(200) default NULL,
`phone` varchar(200) default NULL,
`fax` varchar(200) default NULL,
`street1` varchar(200) default NULL,
`street2` varchar(200) default NULL,
`uniqkey` varchar(255) default NULL,
`uniqkey_time` TIMESTAMP NULL,
UNIQUE KEY `admin_id` (`admin_id`),
UNIQUE KEY `admin_name` (`admin_name`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
2.4.7.1:
Code:
CREATE TABLE `admin` (
`admin_id` int(10) unsigned NOT NULL auto_increment,
`admin_name` varchar(200) default NULL,
`admin_pass` varchar(200) default NULL,
`admin_type` varchar(10) default NULL,
`domain_created` int(10) unsigned NOT NULL default '0',
`customer_id` varchar(200) default NULL,
`created_by` int(10) unsigned default NULL,
`fname` varchar(200) default NULL,
`lname` varchar(200) default NULL,
`firm` varchar(200) default NULL,
`zip` varchar(10) default NULL,
`city` varchar(200) default NULL,
`country` varchar(200) default NULL,
`email` varchar(200) default NULL,
`phone` varchar(200) default NULL,
`fax` varchar(200) default NULL,
`street1` varchar(200) default NULL,
`street2` varchar(200) default NULL,
`uniqkey` varchar(255) default NULL,
UNIQUE KEY `admin_id` (`admin_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
/J