DROP TABLE IF EXISTS `#@_user_company_table`;
CREATE TABLE `#@_user_company_table` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `_parentId` smallint(5) unsigned NOT NULL DEFAULT '0',
  `name` varchar(16) NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '1',
  `access` smallint(5) unsigned NOT NULL DEFAULT '10',
  `comment` char(15) NOT NULL DEFAULT '',
  `sort` smallint(6) NOT NULL DEFAULT '50',
  `smtp` varchar(100) NOT NULL DEFAULT '',
  `ssl` tinyint(1) NOT NULL DEFAULT '0',
  `port` smallint(6) NOT NULL DEFAULT '25',
  PRIMARY KEY (`id`),
  KEY `status` (`status`) USING BTREE,
  KEY `comment` (`comment`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='公司';

