DROP TABLE IF EXISTS `site_plugin_team_fields`;
CREATE TABLE `site_plugin_team_fields` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `module_id` int(11) NOT NULL,
  `item_order` int(11) NOT NULL,
  `item_name` varchar(100) NOT NULL,
  `item_icon` varchar(200) NOT NULL,
  PRIMARY KEY (`item_id`),
  KEY `module_id` (`module_id`,`item_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `site_plugin_team_fields_values`;
CREATE TABLE `site_plugin_team_fields_values` (
  `val_id` int(11) NOT NULL AUTO_INCREMENT,
  `module_id` int(11) NOT NULL,
  `field_id` int(11) NOT NULL,
  `team_id` int(11) NOT NULL,
  `val_value` varchar(255) NOT NULL,
  PRIMARY KEY (`val_id`),
  KEY `module_id` (`module_id`,`field_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
