Code: Select all
CREATE TABLE `members` (
`id` mediumint(9) NOT NULL auto_increment,
`first_name` varchar(25) collate utf8_unicode_ci NOT NULL,
`middle_name` varchar(25) collate utf8_unicode_ci default NULL,
`last_name` varchar(40) collate utf8_unicode_ci NOT NULL,
`nick_name` varchar(25) collate utf8_unicode_ci default NULL,
`spouse_name` varchar(75) collate utf8_unicode_ci default NULL,
`home_phone` int(10) default NULL,
`home_fax` int(10) default NULL,
`cell_phone` int(10) default NULL,
`personal_email` varchar(100) collate utf8_unicode_ci default NULL,
`home_address` varchar(100) collate utf8_unicode_ci NOT NULL,
`home_city` varchar(50) collate utf8_unicode_ci NOT NULL,
`home_state` varchar(2) collate utf8_unicode_ci NOT NULL,
`home_zip` mediumint(9) NOT NULL,
`gender` varchar(1) collate utf8_unicode_ci default NULL,
`join_date` datetime NOT NULL,
`birth_date` datetime NOT NULL,
`photo` varchar(255) collate utf8_unicode_ci NOT NULL,
`business_name` varchar(100) collate utf8_unicode_ci NOT NULL,
`business_phone` int(10) NOT NULL,
`business_phone2` int(10) default NULL,
`business_email` varchar(100) collate utf8_unicode_ci default NULL,
`business_website` varchar(255) collate utf8_unicode_ci default NULL,
`business_address` varchar(100) collate utf8_unicode_ci NOT NULL,
`business_city` varchar(50) collate utf8_unicode_ci NOT NULL,
`business_state` varchar(2) collate utf8_unicode_ci NOT NULL,
`business_zip` mediumint(9) NOT NULL,
`business_classification` varchar(255) collate utf8_unicode_ci NOT NULL,
`business_keywords` text collate utf8_unicode_ci NOT NULL,
`business_description` text collate utf8_unicode_ci NOT NULL,
`last_modified` datetime NOT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `business_keywords` (`business_keywords`,`business_description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE `teams` (
`id` mediumint(9) NOT NULL auto_increment,
`name` varchar(50) collate utf8_unicode_ci NOT NULL,
`ytd_points` int(11) NOT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE `teams_members` (
`member_id` mediumint(9) NOT NULL,
`coordinator` tinyint(1) NOT NULL,
`captain` tinyint(1) NOT NULL,
`cocaptain` tinyint(1) NOT NULL,
`team_id` mediumint(9) NOT NULL,
KEY `teams_members` (`member_id`,`team_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;