CREATE TABLE Contract_Table (
   contract_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
   contract_date date DEFAULT '0000-00-00' NOT NULL,
   contract_lastmodified timestamp(6),
   contract_close_date date DEFAULT '0000-00-00' NOT NULL,
   contract_ship_date date DEFAULT '0000-00-00' NOT NULL,
   contract_project_start_date date DEFAULT '0000-00-00' NOT NULL,
   contract_project_end_date date DEFAULT '0000-00-00' NOT NULL,
   contract_posted enum('yes','no') DEFAULT 'no' NOT NULL,
   contract_client_id smallint(5) unsigned DEFAULT '0' NOT NULL,
   contract_product_id smallint(5) unsigned DEFAULT '0' NOT NULL,
   contract_product_owner varchar(25) NOT NULL,
   contract_business_unit_id tinyint(2) unsigned DEFAULT '0' NOT NULL,
   contract_status_id tinyint(2) unsigned DEFAULT '0' NOT NULL,
   contract_percent tinyint(3) unsigned DEFAULT '0' NOT NULL,
   contract_total int(10) DEFAULT '0' NOT NULL,
   contract_fiscal_year_01 int(10) DEFAULT '0' NOT NULL,
   contract_fiscal_year_02 int(10) DEFAULT '0' NOT NULL,
   contract_FY01_Q1 int(10) DEFAULT '0' NOT NULL,
   contract_FY01_Q2 int(10) DEFAULT '0' NOT NULL,
   contract_FY01_Q3 int(10) DEFAULT '0' NOT NULL,
   contract_FY01_Q4 int(10) DEFAULT '0' NOT NULL,
   contract_FY02_Q1 int(10) DEFAULT '0' NOT NULL,
   contract_FY02_Q2 int(10) DEFAULT '0' NOT NULL,
   contract_FY02_Q3 int(10) DEFAULT '0' NOT NULL,
   contract_FY02_Q4 int(10) DEFAULT '0' NOT NULL,
   contract_jul_00 int(10) DEFAULT '0' NOT NULL,
   contract_aug_00 int(10) DEFAULT '0' NOT NULL,
   contract_sep_00 int(10) DEFAULT '0' NOT NULL,
   contract_oct_00 int(10) DEFAULT '0' NOT NULL,
   contract_nov_00 int(10) DEFAULT '0' NOT NULL,
   contract_dec_00 int(10) DEFAULT '0' NOT NULL,
   contract_jan_01 int(10) DEFAULT '0' NOT NULL,
   contract_feb_01 int(10) DEFAULT '0' NOT NULL,
   contract_mar_01 int(10) DEFAULT '0' NOT NULL,
   contract_apr_01 int(10) DEFAULT '0' NOT NULL,
   contract_may_01 int(10) DEFAULT '0' NOT NULL,
   contract_jun_01 int(10) DEFAULT '0' NOT NULL,
   contract_jul_01 int(10) DEFAULT '0' NOT NULL,
   contract_aug_01 int(10) DEFAULT '0' NOT NULL,
   contract_sep_01 int(10) DEFAULT '0' NOT NULL,
   contract_oct_01 int(10) DEFAULT '0' NOT NULL,
   contract_nov_01 int(10) DEFAULT '0' NOT NULL,
   contract_dec_01 int(10) DEFAULT '0' NOT NULL,
   contract_after_dec01 int(10) DEFAULT '0' NOT NULL,
   contract_jan_02 int(10) DEFAULT '0' NOT NULL,
   contract_feb_02 int(10) DEFAULT '0' NOT NULL,
   contract_mar_02 int(10) DEFAULT '0' NOT NULL,
   contract_apr_02 int(10) DEFAULT '0' NOT NULL,
   contract_may_02 int(10) DEFAULT '0' NOT NULL,
   contract_jun_02 int(10) DEFAULT '0' NOT NULL,
   contract_commit_Q3 mediumint(8) DEFAULT '0' NOT NULL,
   contract_best_Q3 mediumint(8) DEFAULT '0' NOT NULL,
   contract_commit_Q4 mediumint(8) DEFAULT '0' NOT NULL,
   contract_best_Q4 mediumint(8) DEFAULT '0' NOT NULL,
   contract_commit_Q1 mediumint(8) DEFAULT '0' NOT NULL,
   contract_best_Q1 mediumint(8) DEFAULT '0' NOT NULL,
   contract_commit_Q2 mediumint(8) DEFAULT '0' NOT NULL,
   contract_best_Q2 mediumint(8) DEFAULT '0' NOT NULL,
   contract_hidden enum('true','false') DEFAULT 'false' NOT NULL,
   contract_notes varchar(255),
   PRIMARY KEY (contract_id),
   KEY contract_client_id (contract_client_id),
   KEY contract_product_id (contract_product_id),
   KEY contract_status_id (contract_status_id),
   KEY contract_date (contract_date),
   KEY contract_lastmodified (contract_lastmodified),
   KEY business_unit_table_id (contract_business_unit_id),
   KEY contract_hidden (contract_hidden)
);