Unterschiede in der Datenbank von ISPCP zu VHCS

[joximu]

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