Miscellany

CREATE TABLE `ws_hosting` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `webspace_id` varchar(20) NOT NULL,
  `quota` mediumint(8) unsigned NOT NULL default '0',
  `login` varchar(32) default NULL,
  `pass` varchar(32) default NULL,
  `dir` tinytext,
  `vhost` mediumtext,
  `vhost_status` enum('active','disabled') default 'active',
  `dirty` tinyint(1) default '0',
  `log` longtext,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `login` (`login`),
  KEY `webspace_id` (`webspace_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;