-- MySQL dump 10.10
--
-- Host: localhost    Database: procore-db_dbo
-- ------------------------------------------------------
-- Server version	5.0.17-standard-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

DROP DATABASE IF EXISTS `proj1`;
CREATE DATABASE `proj1`;
USE `proj1`;

--
-- Table structure for table `msp_assignment_baselines`
--

DROP TABLE IF EXISTS `msp_assignment_baselines`;
CREATE TABLE `msp_assignment_baselines` (
  `proj_id` int(11) default NULL,
  `assn_uid` int(11) default NULL,
  `ab_base_num` int(11) default NULL,
  `ab_base_start` datetime default NULL,
  `ab_base_finish` datetime default NULL,
  `ab_base_work` float default NULL,
  `ab_base_cost` float default NULL,
  `ab_base_cost_per_use` float default NULL,
  `ab_ref_ent_proj_id` int(11) default NULL,
  UNIQUE KEY `i_msp_assignment_baselines` (`proj_id`,`assn_uid`,`ab_base_num`,`ab_ref_ent_proj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_assignment_baselines`
--


/*!40000 ALTER TABLE `msp_assignment_baselines` DISABLE KEYS */;
LOCK TABLES `msp_assignment_baselines` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_assignment_baselines` ENABLE KEYS */;

--
-- Table structure for table `msp_assignments`
--

DROP TABLE IF EXISTS `msp_assignments`;
CREATE TABLE `msp_assignments` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `assn_act_finish` datetime default NULL,
  `assn_act_start` datetime default NULL,
  `assn_acwp` float default NULL,
  `assn_bcwp` float default NULL,
  `assn_bcws` float default NULL,
  `assn_res_type` tinyint(1) default '0',
  `assn_is_overallocated` tinyint(1) default '0',
  `assn_work_contour` int(11) default NULL,
  `assn_start_var` int(11) default NULL,
  `assn_finish_var` int(11) default NULL,
  `assn_update_needed` tinyint(1) default '0',
  `ext_edit_ref_data` text,
  `assn_uid` int(11) default NULL,
  `assn_has_linked_fields` tinyint(1) default '0',
  `assn_is_confirmed` tinyint(1) default '0',
  `assn_response_pending` tinyint(1) default '0',
  `assn_has_notes` tinyint(1) default '0',
  `assn_team_status_pending` tinyint(1) default '0',
  `task_uid` int(11) default NULL,
  `res_uid` int(11) default NULL,
  `assn_start_date` datetime default NULL,
  `assn_finish_date` datetime default NULL,
  `assn_delay` int(11) default NULL,
  `assn_delay_fmt` int(11) default NULL,
  `assn_leveling_delay` int(11) default NULL,
  `assn_cost_rate_table` int(11) default NULL,
  `assn_base_start` datetime default NULL,
  `assn_base_finish` datetime default NULL,
  `assn_material_rate_fmt` int(11) default NULL,
  `assn_units` float default NULL,
  `assn_work` float default NULL,
  `assn_act_work` float default NULL,
  `assn_reg_work` float default NULL,
  `assn_rem_work` float default NULL,
  `assn_base_work` float default NULL,
  `assn_cost` float default NULL,
  `assn_act_cost` float default NULL,
  `assn_rem_cost` float default NULL,
  `assn_base_cost` float default NULL,
  `assn_base_cost_per_use` float default NULL,
  `assn_ovt_work` float default NULL,
  `assn_act_ovt_work` float default NULL,
  `assn_rem_ovt_work` float default NULL,
  `assn_act_ovt_cost` float default NULL,
  `assn_rem_ovt_cost` float default NULL,
  `assn_rtf_notes` blob,
  `assn_entsumprojid` int(11) default NULL,
  `assn_booking_type` int(11) default NULL,
  `assn_act_work_prot` float default NULL,
  `assn_act_ovt_work_prot` float default NULL,
  `assn_creation_date` datetime default NULL,
  UNIQUE KEY `i_msp_assignments` (`proj_id`,`assn_uid`),
  KEY `ix_task_uid_res_uid` (`task_uid`,`res_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_assignments`
--


/*!40000 ALTER TABLE `msp_assignments` DISABLE KEYS */;
LOCK TABLES `msp_assignments` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_assignments` ENABLE KEYS */;

--
-- Table structure for table `msp_assn_enterprise`
--

DROP TABLE IF EXISTS `msp_assn_enterprise`;
CREATE TABLE `msp_assn_enterprise` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `assn_act_finish` datetime default NULL,
  `assn_act_start` datetime default NULL,
  `assn_acwp` float default NULL,
  `assn_bcwp` float default NULL,
  `assn_bcws` float default NULL,
  `assn_res_type` tinyint(1) default '0',
  `assn_is_overallocated` tinyint(1) default '0',
  `assn_work_contour` int(11) default NULL,
  `assn_start_var` int(11) default NULL,
  `assn_finish_var` int(11) default NULL,
  `assn_update_needed` tinyint(1) default '0',
  `ext_edit_ref_data` text,
  `assn_uid` int(11) default NULL,
  `assn_has_linked_fields` tinyint(1) default '0',
  `assn_is_confirmed` tinyint(1) default '0',
  `assn_response_pending` tinyint(1) default '0',
  `assn_has_notes` tinyint(1) default '0',
  `assn_team_status_pending` tinyint(1) default '0',
  `task_uid` int(11) default NULL,
  `res_uid` int(11) default NULL,
  `assn_start_date` datetime default NULL,
  `assn_finish_date` datetime default NULL,
  `assn_delay` int(11) default NULL,
  `assn_delay_fmt` int(11) default NULL,
  `assn_leveling_delay` int(11) default NULL,
  `assn_cost_rate_table` int(11) default NULL,
  `assn_base_start` datetime default NULL,
  `assn_base_finish` datetime default NULL,
  `assn_material_rate_fmt` int(11) default NULL,
  `assn_units` float default NULL,
  `assn_work` float default NULL,
  `assn_act_work` float default NULL,
  `assn_reg_work` float default NULL,
  `assn_rem_work` float default NULL,
  `assn_base_work` float default NULL,
  `assn_cost` float default NULL,
  `assn_act_cost` float default NULL,
  `assn_rem_cost` float default NULL,
  `assn_base_cost` float default NULL,
  `assn_base_cost_per_use` float default NULL,
  `assn_ovt_work` float default NULL,
  `assn_act_ovt_work` float default NULL,
  `assn_rem_ovt_work` float default NULL,
  `assn_act_ovt_cost` float default NULL,
  `assn_rem_ovt_cost` float default NULL,
  `assn_rtf_notes` blob,
  `assn_entsumprojid` int(11) default NULL,
  `assn_booking_type` int(11) default NULL,
  `assn_act_work_prot` float default NULL,
  `assn_act_ovt_work_prot` float default NULL,
  `assn_creation_date` datetime default NULL,
  UNIQUE KEY `i_msp_assn_enterprise` (`proj_id`,`assn_uid`,`assn_entsumprojid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_assn_enterprise`
--


/*!40000 ALTER TABLE `msp_assn_enterprise` DISABLE KEYS */;
LOCK TABLES `msp_assn_enterprise` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_assn_enterprise` ENABLE KEYS */;

--
-- Table structure for table `msp_attribute_strings`
--

DROP TABLE IF EXISTS `msp_attribute_strings`;
CREATE TABLE `msp_attribute_strings` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `as_id` int(11) default NULL,
  `as_position` int(11) default NULL,
  `as_value` varchar(255) default NULL,
  UNIQUE KEY `i_msp_attribute_strings` (`proj_id`,`as_id`,`as_position`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_attribute_strings`
--


/*!40000 ALTER TABLE `msp_attribute_strings` DISABLE KEYS */;
LOCK TABLES `msp_attribute_strings` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_attribute_strings` ENABLE KEYS */;

--
-- Table structure for table `msp_availability`
--

DROP TABLE IF EXISTS `msp_availability`;
CREATE TABLE `msp_availability` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `avail_uid` int(11) default NULL,
  `res_uid` int(11) default NULL,
  `avail_from` datetime default NULL,
  `avail_to` datetime default NULL,
  `avail_units` float default NULL,
  UNIQUE KEY `i_msp_availability` (`proj_id`,`avail_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_availability`
--


/*!40000 ALTER TABLE `msp_availability` DISABLE KEYS */;
LOCK TABLES `msp_availability` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_availability` ENABLE KEYS */;

--
-- Table structure for table `msp_calendar_data`
--

DROP TABLE IF EXISTS `msp_calendar_data`;
CREATE TABLE `msp_calendar_data` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `cd_uid` int(11) default NULL,
  `cal_uid` int(11) default NULL,
  `cd_day_or_exception` int(11) default NULL,
  `cd_working` int(11) default NULL,
  `cd_from_date` datetime default NULL,
  `cd_to_date` datetime default NULL,
  `cd_from_time1` datetime default NULL,
  `cd_to_time1` datetime default NULL,
  `cd_from_time2` datetime default NULL,
  `cd_to_time2` datetime default NULL,
  `cd_from_time3` datetime default NULL,
  `cd_to_time3` datetime default NULL,
  `cd_from_time4` datetime default NULL,
  `cd_to_time4` datetime default NULL,
  `cd_from_time5` datetime default NULL,
  `cd_to_time5` datetime default NULL,
  UNIQUE KEY `i_msp_calendar_data` (`proj_id`,`cd_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_calendar_data`
--


/*!40000 ALTER TABLE `msp_calendar_data` DISABLE KEYS */;
LOCK TABLES `msp_calendar_data` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_calendar_data` ENABLE KEYS */;

--
-- Table structure for table `msp_calendars`
--

DROP TABLE IF EXISTS `msp_calendars`;
CREATE TABLE `msp_calendars` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `cal_uid` int(11) default NULL,
  `cal_base_uid` int(11) default NULL,
  `res_uid` int(11) default NULL,
  `cal_is_base_cal` tinyint(1) default '0',
  `cal_name` varchar(255) default NULL,
  `cal_entuid` int(11) default NULL,
  UNIQUE KEY `i_msp_calendars` (`proj_id`,`cal_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_calendars`
--


/*!40000 ALTER TABLE `msp_calendars` DISABLE KEYS */;
LOCK TABLES `msp_calendars` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_calendars` ENABLE KEYS */;

--
-- Table structure for table `msp_code_fields`
--

DROP TABLE IF EXISTS `msp_code_fields`;
CREATE TABLE `msp_code_fields` (
  `proj_id` int(11) default NULL,
  `code_category` int(11) default NULL,
  `code_ref_uid` int(11) default NULL,
  `code_field_id` int(11) default NULL,
  `code_uid` int(11) default NULL,
  UNIQUE KEY `i_msp_code_fields` (`proj_id`,`code_category`,`code_ref_uid`,`code_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_code_fields`
--


/*!40000 ALTER TABLE `msp_code_fields` DISABLE KEYS */;
LOCK TABLES `msp_code_fields` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_code_fields` ENABLE KEYS */;

--
-- Table structure for table `msp_conversions`
--

DROP TABLE IF EXISTS `msp_conversions`;
CREATE TABLE `msp_conversions` (
  `string_type_id` int(11) default NULL,
  `conv_value` int(11) default NULL,
  `conv_lang_id` int(11) default NULL,
  `conv_string` varchar(200) default NULL,
  UNIQUE KEY `i_msp_conversions` (`conv_value`,`conv_lang_id`,`string_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_conversions`
--


/*!40000 ALTER TABLE `msp_conversions` DISABLE KEYS */;
LOCK TABLES `msp_conversions` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_conversions` ENABLE KEYS */;

--
-- Table structure for table `msp_date_fields`
--

DROP TABLE IF EXISTS `msp_date_fields`;
CREATE TABLE `msp_date_fields` (
  `proj_id` int(11) default NULL,
  `date_category` int(11) default NULL,
  `date_ref_uid` int(11) default NULL,
  `date_field_id` int(11) default NULL,
  `date_value` datetime default NULL,
  UNIQUE KEY `i_msp_date_fields` (`proj_id`,`date_category`,`date_ref_uid`,`date_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_date_fields`
--


/*!40000 ALTER TABLE `msp_date_fields` DISABLE KEYS */;
LOCK TABLES `msp_date_fields` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_date_fields` ENABLE KEYS */;

--
-- Table structure for table `msp_duration_fields`
--

DROP TABLE IF EXISTS `msp_duration_fields`;
CREATE TABLE `msp_duration_fields` (
  `proj_id` int(11) default NULL,
  `dur_category` int(11) default NULL,
  `dur_ref_uid` int(11) default NULL,
  `dur_field_id` int(11) default NULL,
  `dur_value` int(11) default NULL,
  `dur_fmt` int(11) default NULL,
  UNIQUE KEY `i_msp_duration_fields` (`proj_id`,`dur_category`,`dur_ref_uid`,`dur_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_duration_fields`
--


/*!40000 ALTER TABLE `msp_duration_fields` DISABLE KEYS */;
LOCK TABLES `msp_duration_fields` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_duration_fields` ENABLE KEYS */;

--
-- Table structure for table `msp_field_attributes`
--

DROP TABLE IF EXISTS `msp_field_attributes`;
CREATE TABLE `msp_field_attributes` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `attrib_field_id` int(11) default NULL,
  `attrib_id` int(11) default NULL,
  `attrib_value` int(11) default NULL,
  `as_id` int(11) default NULL,
  `attrib_ext_edited` tinyint(1) default '0',
  UNIQUE KEY `i_msp_field_attributes` (`proj_id`,`attrib_field_id`,`attrib_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_field_attributes`
--


/*!40000 ALTER TABLE `msp_field_attributes` DISABLE KEYS */;
LOCK TABLES `msp_field_attributes` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_field_attributes` ENABLE KEYS */;

--
-- Table structure for table `msp_flag_fields`
--

DROP TABLE IF EXISTS `msp_flag_fields`;
CREATE TABLE `msp_flag_fields` (
  `proj_id` int(11) default NULL,
  `flag_category` int(11) default NULL,
  `flag_ref_uid` int(11) default NULL,
  `flag_field_id` int(11) default NULL,
  `flag_value` tinyint(1) default '0',
  UNIQUE KEY `i_msp_flag_fields` (`proj_id`,`flag_category`,`flag_ref_uid`,`flag_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_flag_fields`
--


/*!40000 ALTER TABLE `msp_flag_fields` DISABLE KEYS */;
LOCK TABLES `msp_flag_fields` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_flag_fields` ENABLE KEYS */;

--
-- Table structure for table `msp_links`
--

DROP TABLE IF EXISTS `msp_links`;
CREATE TABLE `msp_links` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `ext_edit_ref_data` text,
  `link_uid` int(11) default NULL,
  `link_is_cross_proj` tinyint(1) default '0',
  `link_pred_uid` int(11) default NULL,
  `link_succ_uid` int(11) default NULL,
  `link_type` int(11) default NULL,
  `link_lag_fmt` int(11) default NULL,
  `link_lag` int(11) default NULL,
  UNIQUE KEY `i_msp_links` (`proj_id`,`link_uid`),
  KEY `ix_msp_links` (`proj_id`,`link_pred_uid`),
  KEY `ix_msp_links_1` (`proj_id`,`link_succ_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_links`
--


/*!40000 ALTER TABLE `msp_links` DISABLE KEYS */;
LOCK TABLES `msp_links` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_links` ENABLE KEYS */;

--
-- Table structure for table `msp_mv_fields`
--

DROP TABLE IF EXISTS `msp_mv_fields`;
CREATE TABLE `msp_mv_fields` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `code_mv_uid` int(11) default NULL,
  `code_category` int(11) default NULL,
  `code_ref_uid` int(11) default NULL,
  `code_field_id` int(11) default NULL,
  `code_uid` int(11) default NULL,
  KEY `i_msp_mv_fields` (`proj_id`,`code_mv_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_mv_fields`
--


/*!40000 ALTER TABLE `msp_mv_fields` DISABLE KEYS */;
LOCK TABLES `msp_mv_fields` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_mv_fields` ENABLE KEYS */;

--
-- Table structure for table `msp_number_fields`
--

DROP TABLE IF EXISTS `msp_number_fields`;
CREATE TABLE `msp_number_fields` (
  `proj_id` int(11) default NULL,
  `num_category` int(11) default NULL,
  `num_ref_uid` int(11) default NULL,
  `num_field_id` int(11) default NULL,
  `num_value` float default NULL,
  UNIQUE KEY `i_msp_number_fields` (`proj_id`,`num_category`,`num_ref_uid`,`num_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_number_fields`
--


/*!40000 ALTER TABLE `msp_number_fields` DISABLE KEYS */;
LOCK TABLES `msp_number_fields` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_number_fields` ENABLE KEYS */;

--
-- Table structure for table `msp_outline_codes`
--

DROP TABLE IF EXISTS `msp_outline_codes`;
CREATE TABLE `msp_outline_codes` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `code_uid` int(11) default NULL,
  `oc_parent` int(11) default NULL,
  `oc_field_id` int(11) default NULL,
  `oc_name` text,
  `oc_description` text,
  `oc_cached_is_valid` tinyint(1) default '0',
  `oc_cached_full_name` text,
  UNIQUE KEY `i_msp_outline_codes` (`proj_id`,`code_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_outline_codes`
--


/*!40000 ALTER TABLE `msp_outline_codes` DISABLE KEYS */;
LOCK TABLES `msp_outline_codes` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_outline_codes` ENABLE KEYS */;

--
-- Table structure for table `msp_projects`
--

DROP TABLE IF EXISTS `msp_projects`;
CREATE TABLE `msp_projects` (
  `proj_id` int(11) default NULL,
  `proj_name` varchar(255) default NULL,
  `proj_read_only` varchar(10) default NULL,
  `proj_read_write` varchar(4) default NULL,
  `proj_read_count` varchar(10) default NULL,
  `proj_locked` varchar(4) default NULL,
  `proj_machine_id` varchar(100) default NULL,
  `reserved_binary_data` blob,
  `proj_type` int(11) default '0',
  `proj_checkedout` int(11) default '0',
  `proj_checkoutby` varchar(255) default NULL,
  `proj_checkoutdate` datetime default NULL,
  `proj_project` varchar(200) default NULL,
  `proj_version` varchar(50) default NULL,
  `proj_creation_date_ex` datetime default NULL,
  `proj_actuals_synch` int(11) default NULL,
  `proj_adminproject` int(11) default NULL,
  `proj_ent_list_separator` varchar(2) default NULL,
  `proj_ignore_front_end` tinyint(1) default '0',
  `proj_prop_author` text,
  `proj_opt_calc_act_costs` tinyint(1) default '0',
  `proj_prop_category` text,
  `proj_prop_company` text,
  `proj_opt_critical_slack_limit` int(11) default NULL,
  `proj_opt_currency_digits` int(11) default NULL,
  `proj_opt_currency_position` int(11) default NULL,
  `proj_opt_currency_symbol` varchar(20) default NULL,
  `proj_opt_new_are_effort_driven` tinyint(1) default '0',
  `proj_info_current_date` datetime default NULL,
  `proj_opt_def_finish_time` datetime default NULL,
  `proj_opt_def_fix_cost_accrual` int(11) default NULL,
  `proj_opt_minutes_per_day` int(11) default NULL,
  `proj_opt_minutes_per_week` int(11) default NULL,
  `proj_opt_def_ovt_rate` float default NULL,
  `proj_opt_def_std_rate` float default NULL,
  `proj_opt_def_start_time` datetime default NULL,
  `proj_opt_def_task_type` int(11) default NULL,
  `proj_opt_dur_entry_fmt` int(11) default NULL,
  `proj_info_finish_date` datetime default NULL,
  `proj_opt_honor_constraints` tinyint(1) default '0',
  `proj_prop_keywords` text,
  `proj_last_saved` datetime default NULL,
  `proj_prop_manager` text,
  `proj_opt_mult_critical_paths` tinyint(1) default '0',
  `proj_creation_date` datetime default NULL,
  `proj_pool_attached_to` text,
  `proj_info_cal_name` text,
  `proj_is_res_pool` tinyint(1) default '0',
  `proj_info_sched_from` int(11) default NULL,
  `proj_opt_split_in_progress` tinyint(1) default '0',
  `proj_opt_spread_act_costs` tinyint(1) default '0',
  `proj_opt_spread_pct_comp` tinyint(1) default '0',
  `proj_info_start_date` datetime default NULL,
  `proj_info_status_date` datetime default NULL,
  `proj_prop_subject` text,
  `proj_prop_title` text,
  `proj_opt_task_updates_res` tinyint(1) default '0',
  `proj_opt_work_entry_fmt` int(11) default NULL,
  `proj_opt_calc_sub_as_summary` tinyint(1) default '0',
  `proj_opt_week_start_day` int(11) default NULL,
  `proj_opt_fy_start_month` int(11) default NULL,
  `proj_opt_fy_use_start_yr` tinyint(1) default '0',
  `proj_opt_days_per_month` int(11) default NULL,
  `proj_opt_new_task_est` tinyint(1) default '0',
  `proj_opt_show_est_dur` tinyint(1) default '0',
  `proj_opt_expand_timephased` tinyint(1) default '0',
  `proj_ext_edited_date` tinyint(1) default '0',
  `proj_ext_edited_dur` tinyint(1) default '0',
  `proj_ext_edited_num` tinyint(1) default '0',
  `proj_ext_edited_flag` tinyint(1) default '0',
  `proj_ext_edited_code` tinyint(1) default '0',
  `proj_ext_edited_text` tinyint(1) default '0',
  `proj_ext_edited` tinyint(1) default '0',
  `proj_data_source` varchar(128) default NULL,
  UNIQUE KEY `i_msp_projects` (`proj_id`),
  UNIQUE KEY `i_proj_name` (`proj_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_projects`
--


/*!40000 ALTER TABLE `msp_projects` DISABLE KEYS */;
LOCK TABLES `msp_projects` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_projects` ENABLE KEYS */;

--
-- Table structure for table `msp_res_global_binary`
--

DROP TABLE IF EXISTS `msp_res_global_binary`;
CREATE TABLE `msp_res_global_binary` (
  `proj_id` int(11) default NULL,
  `glb_category` int(11) default NULL,
  `glb_ref_uid` int(11) default NULL,
  `glb_ref_ent_proj_id` int(11) default NULL,
  `glb_binary_data` blob,
  UNIQUE KEY `i_msp_res_globa` (`proj_id`,`glb_category`,`glb_ref_uid`,`glb_ref_ent_proj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_res_global_binary`
--


/*!40000 ALTER TABLE `msp_res_global_binary` DISABLE KEYS */;
LOCK TABLES `msp_res_global_binary` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_res_global_binary` ENABLE KEYS */;

--
-- Table structure for table `msp_resource_baselines`
--

DROP TABLE IF EXISTS `msp_resource_baselines`;
CREATE TABLE `msp_resource_baselines` (
  `proj_id` int(11) default NULL,
  `res_uid` int(11) default NULL,
  `rb_base_num` int(11) default NULL,
  `rb_base_work` float default NULL,
  `rb_base_cost` float default NULL,
  UNIQUE KEY `i_msp_resource_baselines` (`proj_id`,`res_uid`,`rb_base_num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_resource_baselines`
--


/*!40000 ALTER TABLE `msp_resource_baselines` DISABLE KEYS */;
LOCK TABLES `msp_resource_baselines` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_resource_baselines` ENABLE KEYS */;

--
-- Table structure for table `msp_resource_rates`
--

DROP TABLE IF EXISTS `msp_resource_rates`;
CREATE TABLE `msp_resource_rates` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `rr_uid` int(11) default NULL,
  `res_uid` int(11) default NULL,
  `rr_rate_table` int(11) default NULL,
  `rr_from_date` datetime default NULL,
  `rr_to_date` datetime default NULL,
  `rr_std_rate` float default NULL,
  `rr_std_rate_fmt` int(11) default NULL,
  `rr_ovt_rate` float default NULL,
  `rr_ovt_rate_fmt` int(11) default NULL,
  `rr_per_use_cost` float default NULL,
  UNIQUE KEY `i_msp_resource_rates` (`proj_id`,`rr_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_resource_rates`
--


/*!40000 ALTER TABLE `msp_resource_rates` DISABLE KEYS */;
LOCK TABLES `msp_resource_rates` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_resource_rates` ENABLE KEYS */;

--
-- Table structure for table `msp_resources`
--

DROP TABLE IF EXISTS `msp_resources`;
CREATE TABLE `msp_resources` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `res_acwp` float default NULL,
  `res_bcwp` float default NULL,
  `res_bcws` float default NULL,
  `res_num_objects` int(11) default NULL,
  `ext_edit_ref_data` text,
  `res_uid` int(11) default NULL,
  `res_id` int(11) default NULL,
  `res_has_linked_fields` tinyint(1) default '0',
  `res_is_overallocated` tinyint(1) default '0',
  `res_type` tinyint(1) default '0',
  `res_has_notes` tinyint(1) default '0',
  `res_can_level` tinyint(1) default '0',
  `res_std_rate_fmt` int(11) default NULL,
  `res_ovt_rate_fmt` int(11) default NULL,
  `res_accrue_at` int(11) default NULL,
  `res_workgroup_messaging` int(11) default NULL,
  `res_cal_uid` int(11) default NULL,
  `res_avail_from` datetime default NULL,
  `res_avail_to` datetime default NULL,
  `res_std_rate` float default NULL,
  `res_ovt_rate` float default NULL,
  `res_max_units` float default NULL,
  `res_work` float default NULL,
  `res_act_work` float default NULL,
  `res_base_work` float default NULL,
  `res_ovt_work` float default NULL,
  `res_cost_per_use` float default NULL,
  `res_rem_work` float default NULL,
  `res_reg_work` float default NULL,
  `res_act_ovt_work` float default NULL,
  `res_rem_ovt_work` float default NULL,
  `res_peak` float default NULL,
  `res_act_cost` float default NULL,
  `res_cost` float default NULL,
  `res_base_cost` float default NULL,
  `res_rem_cost` float default NULL,
  `res_ovt_cost` float default NULL,
  `res_act_ovt_cost` float default NULL,
  `res_rem_ovt_cost` float default NULL,
  `res_name` varchar(255) default NULL,
  `res_initials` varchar(255) default NULL,
  `res_phonetics` text,
  `res_material_label` text,
  `res_rtf_notes` blob,
  `res_rtype` int(11) default NULL,
  `res_checkedout` int(11) default '0',
  `res_checkoutby` varchar(255) default NULL,
  `res_checkoutdate` datetime default NULL,
  `res_enterprise_timestamp` datetime default NULL,
  `res_euid` int(11) default NULL,
  `res_booking_type` int(11) default NULL,
  `res_ad_guid` varchar(16) default NULL,
  `res_act_work_prot` float default NULL,
  `res_act_ovt_work_prot` float default NULL,
  `res_creation_date` datetime default NULL,
  UNIQUE KEY `i_msp_resources` (`proj_id`,`res_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_resources`
--


/*!40000 ALTER TABLE `msp_resources` DISABLE KEYS */;
LOCK TABLES `msp_resources` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_resources` ENABLE KEYS */;

--
-- Table structure for table `msp_string_types`
--

DROP TABLE IF EXISTS `msp_string_types`;
CREATE TABLE `msp_string_types` (
  `string_type_id` int(11) default NULL,
  `string_lang_id` int(11) default NULL,
  `string_type` varchar(200) default NULL,
  UNIQUE KEY `i_msp_string_types` (`string_type_id`,`string_lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_string_types`
--


/*!40000 ALTER TABLE `msp_string_types` DISABLE KEYS */;
LOCK TABLES `msp_string_types` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_string_types` ENABLE KEYS */;

--
-- Table structure for table `msp_task_baselines`
--

DROP TABLE IF EXISTS `msp_task_baselines`;
CREATE TABLE `msp_task_baselines` (
  `proj_id` int(11) default NULL,
  `task_uid` int(11) default NULL,
  `tb_base_num` int(11) default NULL,
  `tb_base_dur` int(11) default NULL,
  `tb_base_dur_fmt` int(11) default NULL,
  `tb_base_start` datetime default NULL,
  `tb_base_finish` datetime default NULL,
  `tb_base_work` float default NULL,
  `tb_base_cost` float default NULL,
  UNIQUE KEY `i_msp_task_baselines` (`proj_id`,`task_uid`,`tb_base_num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_task_baselines`
--


/*!40000 ALTER TABLE `msp_task_baselines` DISABLE KEYS */;
LOCK TABLES `msp_task_baselines` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_task_baselines` ENABLE KEYS */;

--
-- Table structure for table `msp_tasks`
--

DROP TABLE IF EXISTS `msp_tasks`;
CREATE TABLE `msp_tasks` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `task_base_start` datetime default NULL,
  `task_base_finish` datetime default NULL,
  `task_constraint_date` datetime default NULL,
  `task_priority` int(11) default NULL,
  `task_pct_comp` int(11) default NULL,
  `task_pct_work_comp` int(11) default NULL,
  `task_type` int(11) default NULL,
  `task_fixed_cost_accrual` int(11) default NULL,
  `task_creation_date` datetime default NULL,
  `task_preleveled_start` datetime default NULL,
  `task_preleveled_finish` datetime default NULL,
  `task_early_start` datetime default NULL,
  `task_late_finish` datetime default NULL,
  `task_cal_uid` int(11) default NULL,
  `task_deadline` datetime default NULL,
  `task_work` float default NULL,
  `task_base_work` float default NULL,
  `task_act_work` float default NULL,
  `task_rem_work` float default NULL,
  `task_cost` float default NULL,
  `task_fixed_cost` float default NULL,
  `task_act_cost` float default NULL,
  `task_rem_cost` float default NULL,
  `task_base_cost` float default NULL,
  `task_act_ovt_work` float default NULL,
  `task_rem_ovt_work` float default NULL,
  `task_ovt_cost` float default NULL,
  `task_act_ovt_cost` float default NULL,
  `task_rem_ovt_cost` float default NULL,
  `task_wbs` text,
  `task_name` varchar(255) default NULL,
  `task_wbs_rightmost_level` text,
  `task_rtf_notes` blob,
  `task_eac` float default NULL,
  `task_phy_pct_comp` int(11) default NULL,
  `task_evmethod` int(11) default NULL,
  `task_act_work_prot` float default NULL,
  `task_act_ovt_work_prot` float default NULL,
  `task_acwp` float default NULL,
  `task_bcwp` float default NULL,
  `task_bcws` float default NULL,
  `task_dur_var` int(11) default NULL,
  `task_finish_var` int(11) default NULL,
  `task_outline_num` varchar(255) default NULL,
  `task_start_var` int(11) default NULL,
  `task_is_overallocated` tinyint(1) default '0',
  `task_ovt_work` float default NULL,
  `task_vac` float default NULL,
  `task_reg_work` float default NULL,
  `task_num_objects` int(11) default NULL,
  `task_total_slack` int(11) default NULL,
  `ext_edit_ref_data` text,
  `task_uid` int(11) default NULL,
  `task_id` int(11) default NULL,
  `task_has_linked_fields` tinyint(1) default '0',
  `task_is_milestone` tinyint(1) default '0',
  `task_is_critical` tinyint(1) default '0',
  `task_is_summary` tinyint(1) default '0',
  `task_is_subproj` tinyint(1) default '0',
  `task_is_marked` tinyint(1) default '0',
  `task_ignores_res_cal` tinyint(1) default '0',
  `task_is_rolled_up` tinyint(1) default '0',
  `task_is_from_finish_subproj` tinyint(1) default '0',
  `task_bar_is_hidden` tinyint(1) default '0',
  `task_is_recurring` tinyint(1) default '0',
  `task_is_recurring_summary` tinyint(1) default '0',
  `task_is_external` tinyint(1) default '0',
  `task_is_effort_driven` tinyint(1) default '0',
  `task_is_collapsed` tinyint(1) default '0',
  `task_has_notes` tinyint(1) default '0',
  `task_is_readonly_subproj` tinyint(1) default '0',
  `task_leveling_can_split` tinyint(1) default '0',
  `task_leveling_adjusts_assn` tinyint(1) default '0',
  `task_dur_is_est` tinyint(1) default '0',
  `task_early_finish` datetime default NULL,
  `task_late_start` datetime default NULL,
  `task_stop_date` datetime default NULL,
  `task_resume_date` datetime default NULL,
  `task_free_slack` int(11) default NULL,
  `task_outline_level` int(11) default NULL,
  `task_dur` int(11) default NULL,
  `task_dur_fmt` int(11) default NULL,
  `task_act_dur` int(11) default NULL,
  `task_rem_dur` int(11) default NULL,
  `task_base_dur` int(11) default NULL,
  `task_base_dur_fmt` int(11) default NULL,
  `task_constraint_type` int(11) default NULL,
  `task_leveling_delay` int(11) default NULL,
  `task_leveling_delay_fmt` int(11) default NULL,
  `task_start_date` datetime default NULL,
  `task_finish_date` datetime default NULL,
  `task_act_start` datetime default NULL,
  `task_act_finish` datetime default NULL,
  UNIQUE KEY `i_msp_tasks` (`proj_id`,`task_uid`),
  KEY `ix_task_uid` (`task_uid`),
  KEY `ix_task_uid_task_pct_comp` (`task_uid`,`task_pct_comp`,`task_start_date`,`task_finish_date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_tasks`
--


/*!40000 ALTER TABLE `msp_tasks` DISABLE KEYS */;
LOCK TABLES `msp_tasks` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_tasks` ENABLE KEYS */;

--
-- Table structure for table `msp_text_fields`
--

DROP TABLE IF EXISTS `msp_text_fields`;
CREATE TABLE `msp_text_fields` (
  `proj_id` int(11) default NULL,
  `text_category` int(11) default NULL,
  `text_ref_uid` int(11) default NULL,
  `text_field_id` int(11) default NULL,
  `text_value` varchar(255) default NULL,
  UNIQUE KEY `i_msp_text_fields` (`proj_id`,`text_category`,`text_ref_uid`,`text_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_text_fields`
--


/*!40000 ALTER TABLE `msp_text_fields` DISABLE KEYS */;
LOCK TABLES `msp_text_fields` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_text_fields` ENABLE KEYS */;

--
-- Table structure for table `msp_timephased_data`
--

DROP TABLE IF EXISTS `msp_timephased_data`;
CREATE TABLE `msp_timephased_data` (
  `reserved_data` varchar(1) default NULL,
  `proj_id` int(11) default NULL,
  `td_uid` int(11) default NULL,
  `td_field_id` int(11) default NULL,
  `td_category` int(11) default NULL,
  `td_ref_uid` int(11) default NULL,
  `td_start` datetime default NULL,
  `td_finish` datetime default NULL,
  `td_units` int(11) default NULL,
  `td_value1` float default NULL,
  `td_value2` float default NULL,
  `td_value3` float default NULL,
  `td_value4` float default NULL,
  `td_value5` float default NULL,
  `td_value6` float default NULL,
  `td_value7` float default NULL,
  `td_ext_edited` tinyint(1) default '0',
  UNIQUE KEY `i_msp_timephased_data` (`proj_id`,`td_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msp_timephased_data`
--


/*!40000 ALTER TABLE `msp_timephased_data` DISABLE KEYS */;
LOCK TABLES `msp_timephased_data` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `msp_timephased_data` ENABLE KEYS */;

alter table MSP_PROJECTS MODIFY COLUMN reserved_binary_data LONGBLOB;