Jump to content

Obsolete:Sugar/tables

From Wikitech

accounts CREATE TABLE `accounts` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) NOT NULL,
 `assigned_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `name` varchar(150) default NULL,
 `parent_id` char(36) default NULL,
 `account_type` varchar(25) default NULL,
 `industry` varchar(25) default NULL,
 `annual_revenue` varchar(25) default NULL,
 `phone_fax` varchar(25) default NULL,
 `billing_address_street` varchar(150) default NULL,
 `billing_address_city` varchar(100) default NULL,
 `billing_address_state` varchar(100) default NULL,
 `billing_address_postalcode` varchar(20) default NULL,
 `billing_address_country` varchar(100) default NULL,
 `description` text,
 `rating` varchar(25) default NULL,
 `phone_office` varchar(25) default NULL,
 `phone_alternate` varchar(25) default NULL,
 `email1` varchar(100) default NULL,
 `email2` varchar(100) default NULL,
 `website` varchar(255) default NULL,
 `ownership` varchar(100) default NULL,
 `employees` varchar(10) default NULL,
 `sic_code` varchar(10) default NULL,
 `ticker_symbol` varchar(10) default NULL,
 `shipping_address_street` varchar(150) default NULL,
 `shipping_address_city` varchar(100) default NULL,
 `shipping_address_state` varchar(100) default NULL,
 `shipping_address_postalcode` varchar(20) default NULL,
 `shipping_address_country` varchar(100) default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_accnt_id_del` (`id`,`deleted`),
 KEY `idx_accnt_assigned_del` (`deleted`,`assigned_user_id`),
 KEY `idx_accnt_parent_id` (`parent_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

accounts_audit CREATE TABLE `accounts_audit` ( 

 `id` char(36) NOT NULL,
 `parent_id` char(36) NOT NULL,
 `date_created` datetime default NULL,
 `created_by` varchar(36) default NULL,
 `field_name` varchar(100) default NULL,
 `data_type` varchar(100) default NULL,
 `before_value_string` varchar(255) default NULL,
 `after_value_string` varchar(255) default NULL,
 `before_value_text` text,
 `after_value_text` text

) ENGINE=MyISAM DEFAULT CHARSET=latin1

accounts_bugs CREATE TABLE `accounts_bugs` ( 

 `id` varchar(36) NOT NULL,
 `account_id` varchar(36) default NULL,
 `bug_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_acc_bug_acc` (`account_id`),
 KEY `idx_acc_bug_bug` (`bug_id`),
 KEY `idx_account_bug` (`account_id`,`bug_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

accounts_cases CREATE TABLE `accounts_cases` ( 

 `id` varchar(36) NOT NULL,
 `account_id` varchar(36) default NULL,
 `case_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_acc_case_acc` (`account_id`),
 KEY `idx_acc_acc_case` (`case_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

accounts_contacts CREATE TABLE `accounts_contacts` ( 

 `id` varchar(36) NOT NULL,
 `contact_id` varchar(36) default NULL,
 `account_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_acc_cont_acc` (`account_id`),
 KEY `idx_acc_cont_cont` (`contact_id`),
 KEY `idx_account_contact` (`account_id`,`contact_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

accounts_opportunities CREATE TABLE `accounts_opportunities` ( 

 `id` varchar(36) NOT NULL,
 `opportunity_id` varchar(36) default NULL,
 `account_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_acc_opp_acc` (`account_id`),
 KEY `idx_acc_opp_opp` (`opportunity_id`),
 KEY `idx_a_o_opp_acc_del` (`opportunity_id`,`account_id`,`deleted`),
 KEY `idx_account_opportunity` (`account_id`,`opportunity_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

acl_actions CREATE TABLE `acl_actions` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) NOT NULL,
 `created_by` char(36) default NULL,
 `name` varchar(150) default NULL,
 `category` varchar(100) default NULL,
 `acltype` varchar(100) default NULL,
 `aclaccess` int(3) default NULL,
 `deleted` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_aclaction_id_del` (`id`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

acl_roles CREATE TABLE `acl_roles` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) NOT NULL,
 `created_by` char(36) default NULL,
 `name` varchar(150) default NULL,
 `description` text,
 `deleted` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_aclrole_id_del` (`id`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

acl_roles_actions CREATE TABLE `acl_roles_actions` ( 

 `id` varchar(36) NOT NULL,
 `role_id` varchar(36) default NULL,
 `action_id` varchar(36) default NULL,
 `access_override` int(3) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_acl_role_id` (`role_id`),
 KEY `idx_acl_action_id` (`action_id`),
 KEY `idx_aclrole_action` (`role_id`,`action_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

acl_roles_users CREATE TABLE `acl_roles_users` ( 

 `id` varchar(36) NOT NULL,
 `role_id` varchar(36) default NULL,
 `user_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_aclrole_id` (`role_id`),
 KEY `idx_acluser_id` (`user_id`),
 KEY `idx_aclrole_user` (`role_id`,`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

bugs CREATE TABLE `bugs` ( 

 `id` char(36) NOT NULL,
 `bug_number` int(11) NOT NULL auto_increment,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` varchar(36) NOT NULL,
 `assigned_user_id` varchar(36) default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `name` varchar(255) default NULL,
 `status` varchar(25) default NULL,
 `priority` varchar(25) default NULL,
 `description` text,
 `created_by` varchar(36) default NULL,
 `resolution` varchar(255) default NULL,
 `found_in_release` varchar(255) default NULL,
 `type` varchar(255) default NULL,
 `fixed_in_release` varchar(255) default NULL,
 `work_log` text,
 `source` varchar(255) default NULL,
 `product_category` varchar(255) default NULL,
 PRIMARY KEY  (`id`),
 KEY `bug_number` (`bug_number`),
 KEY `idx_bug_name` (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

bugs_audit CREATE TABLE `bugs_audit` ( 

 `id` char(36) NOT NULL,
 `parent_id` char(36) NOT NULL,
 `date_created` datetime default NULL,
 `created_by` varchar(36) default NULL,
 `field_name` varchar(100) default NULL,
 `data_type` varchar(100) default NULL,
 `before_value_string` varchar(255) default NULL,
 `after_value_string` varchar(255) default NULL,
 `before_value_text` text,
 `after_value_text` text

) ENGINE=MyISAM DEFAULT CHARSET=latin1

calls CREATE TABLE `calls` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `assigned_user_id` char(36) default NULL,
 `modified_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `name` varchar(50) default NULL,
 `duration_hours` int(2) default NULL,
 `duration_minutes` int(2) default NULL,
 `date_start` date default NULL,
 `time_start` time default NULL,
 `date_end` date default NULL,
 `parent_type` varchar(25) default NULL,
 `status` varchar(25) default NULL,
 `direction` varchar(25) default NULL,
 `parent_id` char(36) default NULL,
 `description` text,
 `deleted` tinyint(1) NOT NULL default '0',
 `reminder_time` int(4) default '-1',
 `outlook_id` varchar(255) default NULL,
 PRIMARY KEY  (`id`),
 KEY `idx_call_name` (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

calls_contacts CREATE TABLE `calls_contacts` ( 

 `id` varchar(36) NOT NULL,
 `call_id` varchar(36) default NULL,
 `contact_id` varchar(36) default NULL,
 `required` varchar(1) default '1',
 `accept_status` varchar(25) default 'none',
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_con_call_call` (`call_id`),
 KEY `idx_con_call_con` (`contact_id`),
 KEY `idx_call_contact` (`call_id`,`contact_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

calls_users CREATE TABLE `calls_users` ( 

 `id` varchar(36) NOT NULL,
 `call_id` varchar(36) default NULL,
 `user_id` varchar(36) default NULL,
 `required` varchar(1) default '1',
 `accept_status` varchar(25) default 'none',
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_usr_call_call` (`call_id`),
 KEY `idx_usr_call_usr` (`user_id`),
 KEY `idx_call_users` (`call_id`,`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

campaign_log CREATE TABLE `campaign_log` ( 

 `id` char(36) NOT NULL,
 `campaign_id` varchar(36) default NULL,
 `target_tracker_key` varchar(36) default NULL,
 `target_id` varchar(36) default NULL,
 `target_type` varchar(25) default NULL,
 `activity_type` varchar(25) default NULL,
 `activity_date` datetime default NULL,
 `related_id` varchar(36) default NULL,
 `related_type` varchar(25) default NULL,
 `archived` tinyint(1) default '0',
 `hits` int(11) default '0',
 `list_id` char(36) default NULL,
 `deleted` tinyint(1) default '0',
 `date_modified` datetime default NULL,
 `more_information` varchar(100) default NULL,
 PRIMARY KEY  (`id`),
 KEY `idx_camp_tracker` (`target_tracker_key`),
 KEY `idx_camp_campaign_id` (`campaign_id`),
 KEY `idx_camp_more_info` (`more_information`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

campaign_trkrs CREATE TABLE `campaign_trkrs` ( 

 `id` char(36) NOT NULL,
 `tracker_name` varchar(30) default NULL,
 `tracker_url` varchar(255) default 'http://',
 `tracker_key` int(11) NOT NULL auto_increment,
 `campaign_id` char(36) default NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `is_optout` tinyint(1) NOT NULL default '0',
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `campaign_tracker_key_idx` (`tracker_key`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

campaigns CREATE TABLE `campaigns` ( 

 `id` char(36) NOT NULL,
 `tracker_key` int(11) NOT NULL auto_increment,
 `tracker_count` int(11) default '0',
 `name` varchar(50) default NULL,
 `refer_url` varchar(255) default 'http://',
 `tracker_text` varchar(255) default NULL,
 `date_entered` datetime default NULL,
 `date_modified` datetime default NULL,
 `modified_user_id` char(36) default NULL,
 `assigned_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `start_date` date default NULL,
 `end_date` date default NULL,
 `status` varchar(25) default NULL,
 `currency_id` char(36) default NULL,
 `budget` double default NULL,
 `expected_cost` double default NULL,
 `actual_cost` double default NULL,
 `expected_revenue` double default NULL,
 `campaign_type` varchar(25) default NULL,
 `objective` text,
 `content` text,
 PRIMARY KEY  (`id`),
 KEY `auto_tracker_key` (`tracker_key`),
 KEY `idx_campaign_name` (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

campaigns_audit CREATE TABLE `campaigns_audit` ( 

 `id` char(36) NOT NULL,
 `parent_id` char(36) NOT NULL,
 `date_created` datetime default NULL,
 `created_by` varchar(36) default NULL,
 `field_name` varchar(100) default NULL,
 `data_type` varchar(100) default NULL,
 `before_value_string` varchar(255) default NULL,
 `after_value_string` varchar(255) default NULL,
 `before_value_text` text,
 `after_value_text` text

) ENGINE=MyISAM DEFAULT CHARSET=latin1

cases CREATE TABLE `cases` ( 

 `id` char(36) NOT NULL,
 `case_number` int(11) NOT NULL auto_increment,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) NOT NULL,
 `assigned_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `name` varchar(255) default NULL,
 `account_name` varchar(100) default NULL,
 `account_id` char(36) default NULL,
 `status` varchar(25) default NULL,
 `priority` varchar(25) default NULL,
 `description` text,
 `resolution` text,
 PRIMARY KEY  (`id`),
 KEY `case_number` (`case_number`),
 KEY `idx_case_name` (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

cases_audit CREATE TABLE `cases_audit` ( 

 `id` char(36) NOT NULL,
 `parent_id` char(36) NOT NULL,
 `date_created` datetime default NULL,
 `created_by` varchar(36) default NULL,
 `field_name` varchar(100) default NULL,
 `data_type` varchar(100) default NULL,
 `before_value_string` varchar(255) default NULL,
 `after_value_string` varchar(255) default NULL,
 `before_value_text` text,
 `after_value_text` text

) ENGINE=MyISAM DEFAULT CHARSET=latin1

cases_bugs CREATE TABLE `cases_bugs` ( 

 `id` varchar(36) NOT NULL,
 `case_id` varchar(36) default NULL,
 `bug_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_cas_bug_cas` (`case_id`),
 KEY `idx_cas_bug_bug` (`bug_id`),
 KEY `idx_case_bug` (`case_id`,`bug_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

config CREATE TABLE `config` ( 

 `category` varchar(32) default NULL,
 `name` varchar(32) default NULL,
 `value` text,
 KEY `idx_config_cat` (`category`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

contacts CREATE TABLE `contacts` ( 

 `id` char(36) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) default NULL,
 `assigned_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `salutation` varchar(5) default NULL,
 `first_name` varchar(100) default NULL,
 `last_name` varchar(100) default NULL,
 `lead_source` varchar(100) default NULL,
 `title` varchar(50) default NULL,
 `department` varchar(100) default NULL,
 `reports_to_id` char(36) default NULL,
 `birthdate` date default NULL,
 `do_not_call` varchar(3) default '0',
 `phone_home` varchar(25) default NULL,
 `phone_mobile` varchar(25) default NULL,
 `phone_work` varchar(25) default NULL,
 `phone_other` varchar(25) default NULL,
 `phone_fax` varchar(25) default NULL,
 `email1` varchar(100) default NULL,
 `email2` varchar(100) default NULL,
 `assistant` varchar(75) default NULL,
 `assistant_phone` varchar(25) default NULL,
 `email_opt_out` varchar(3) default '0',
 `primary_address_street` varchar(150) default NULL,
 `primary_address_city` varchar(100) default NULL,
 `primary_address_state` varchar(100) default NULL,
 `primary_address_postalcode` varchar(20) default NULL,
 `primary_address_country` varchar(100) default NULL,
 `alt_address_street` varchar(150) default NULL,
 `alt_address_city` varchar(100) default NULL,
 `alt_address_state` varchar(100) default NULL,
 `alt_address_postalcode` varchar(20) default NULL,
 `alt_address_country` varchar(100) default NULL,
 `description` text,
 `portal_name` varchar(255) default NULL,
 `portal_active` tinyint(1) NOT NULL default '0',
 `portal_app` varchar(255) default NULL,
 `invalid_email` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_cont_last_first` (`last_name`,`first_name`,`deleted`),
 KEY `idx_contacts_del_last` (`deleted`,`last_name`),
 KEY `idx_cont_del_reports` (`deleted`,`reports_to_id`,`last_name`),
 KEY `idx_cont_assigned` (`assigned_user_id`),
 KEY `idx_cont_email1` (`email1`),
 KEY `idx_cont_email2` (`email2`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

contacts_audit CREATE TABLE `contacts_audit` ( 

 `id` char(36) NOT NULL,
 `parent_id` char(36) NOT NULL,
 `date_created` datetime default NULL,
 `created_by` varchar(36) default NULL,
 `field_name` varchar(100) default NULL,
 `data_type` varchar(100) default NULL,
 `before_value_string` varchar(255) default NULL,
 `after_value_string` varchar(255) default NULL,
 `before_value_text` text,
 `after_value_text` text

) ENGINE=MyISAM DEFAULT CHARSET=latin1

contacts_bugs CREATE TABLE `contacts_bugs` ( 

 `id` varchar(36) NOT NULL,
 `contact_id` varchar(36) default NULL,
 `bug_id` varchar(36) default NULL,
 `contact_role` varchar(50) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_con_bug_con` (`contact_id`),
 KEY `idx_con_bug_bug` (`bug_id`),
 KEY `idx_contact_bug` (`contact_id`,`bug_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

contacts_cases CREATE TABLE `contacts_cases` ( 

 `id` varchar(36) NOT NULL,
 `contact_id` varchar(36) default NULL,
 `case_id` varchar(36) default NULL,
 `contact_role` varchar(50) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_con_case_con` (`contact_id`),
 KEY `idx_con_case_case` (`case_id`),
 KEY `idx_contacts_cases` (`contact_id`,`case_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

contacts_users CREATE TABLE `contacts_users` ( 

 `id` varchar(36) NOT NULL,
 `contact_id` varchar(36) default NULL,
 `user_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_con_users_con` (`contact_id`),
 KEY `idx_con_users_user` (`user_id`),
 KEY `idx_contacts_users` (`contact_id`,`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

currencies CREATE TABLE `currencies` ( 

 `id` char(36) NOT NULL,
 `name` varchar(36) NOT NULL,
 `symbol` varchar(36) NOT NULL,
 `iso4217` varchar(3) NOT NULL,
 `conversion_rate` double NOT NULL default '0',
 `status` varchar(25) default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `created_by` char(36) NOT NULL,
 PRIMARY KEY  (`id`),
 KEY `idx_cont_name` (`name`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

custom_fields CREATE TABLE `custom_fields` ( 

 `bean_id` varchar(36) default NULL,
 `set_num` int(11) default '0',
 `field0` varchar(255) default NULL,
 `field1` varchar(255) default NULL,
 `field2` varchar(255) default NULL,
 `field3` varchar(255) default NULL,
 `field4` varchar(255) default NULL,
 `field5` varchar(255) default NULL,
 `field6` varchar(255) default NULL,
 `field7` varchar(255) default NULL,
 `field8` varchar(255) default NULL,
 `field9` varchar(255) default NULL,
 `deleted` tinyint(1) default '0',
 KEY `idx_beanid_set_num` (`bean_id`,`set_num`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

dashboards CREATE TABLE `dashboards` ( 

 `id` char(36) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) NOT NULL,
 `assigned_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `name` varchar(100) default NULL,
 `description` text,
 `content` text,
 PRIMARY KEY  (`id`),
 KEY `idx_desc` (`name`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

document_revisions CREATE TABLE `document_revisions` ( 

 `id` varchar(36) NOT NULL,
 `change_log` varchar(255) default NULL,
 `document_id` varchar(36) NOT NULL,
 `date_entered` datetime default NULL,
 `created_by` char(36) default NULL,
 `filename` varchar(255) NOT NULL,
 `file_ext` varchar(25) default NULL,
 `file_mime_type` varchar(100) default NULL,
 `revision` varchar(25) default NULL,
 `deleted` tinyint(1) default '0',
 `date_modified` datetime default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

documents CREATE TABLE `documents` ( 

 `id` varchar(36) NOT NULL,
 `document_name` varchar(255) NOT NULL,
 `active_date` date default NULL,
 `exp_date` date default NULL,
 `description` text,
 `category_id` varchar(25) default NULL,
 `subcategory_id` varchar(25) default NULL,
 `status_id` varchar(25) default NULL,
 `date_entered` datetime default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) default '0',
 `modified_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `document_revision_id` varchar(36) default NULL,
 `mail_merge_document` varchar(3) default 'off',
 `related_doc_id` char(36) default NULL,
 `related_doc_rev_id` char(36) default NULL,
 `is_template` tinyint(1) default '0',
 `template_type` varchar(25) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

email_marketing CREATE TABLE `email_marketing` ( 

 `id` char(36) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `name` varchar(255) default NULL,
 `from_addr` varchar(100) default NULL,
 `from_name` varchar(100) default NULL,
 `inbound_email_id` varchar(36) default NULL,
 `date_start` date default NULL,
 `time_start` time default NULL,
 `template_id` char(36) NOT NULL,
 `status` varchar(25) NOT NULL,
 `campaign_id` char(36) NOT NULL,
 `all_prospect_lists` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_emmkt_name` (`name`),
 KEY `idx_emmkit_del` (`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

email_marketing_prospect_lists CREATE TABLE `email_marketing_prospect_lists` ( 

 `id` varchar(36) NOT NULL,
 `prospect_list_id` varchar(36) default NULL,
 `email_marketing_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_realted_id` (`email_marketing_id`,`prospect_list_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

email_templates CREATE TABLE `email_templates` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) default NULL,
 `created_by` varchar(36) default NULL,
 `published` varchar(3) default NULL,
 `name` varchar(255) default NULL,
 `description` text,
 `subject` varchar(255) default NULL,
 `body` text,
 `body_html` text,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_email_template_name` (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emailman CREATE TABLE `emailman` ( 

 `date_entered` datetime default NULL,
 `date_modified` datetime default NULL,
 `user_id` char(36) default NULL,
 `id` int(11) NOT NULL auto_increment,
 `campaign_id` char(36) default NULL,
 `marketing_id` char(36) default NULL,
 `list_id` char(36) default NULL,
 `send_date_time` datetime default NULL,
 `modified_user_id` char(36) default NULL,
 `in_queue` tinyint(1) default '0',
 `in_queue_date` datetime default NULL,
 `send_attempts` int(11) default '0',
 `deleted` tinyint(1) default '0',
 `related_id` char(36) default NULL,
 `related_type` varchar(100) default NULL,
 PRIMARY KEY  (`id`),
 KEY `idx_eman_list` (`list_id`,`user_id`,`deleted`),
 KEY `idx_eman_campaign_id` (`campaign_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emails CREATE TABLE `emails` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `assigned_user_id` char(36) default NULL,
 `modified_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `name` varchar(255) default NULL,
 `date_start` date default NULL,
 `time_start` time default NULL,
 `parent_type` varchar(25) default NULL,
 `parent_id` char(36) default NULL,
 `description` text,
 `description_html` text,
 `from_addr` varchar(100) default NULL,
 `from_name` varchar(100) default NULL,
 `to_addrs` text,
 `cc_addrs` text,
 `bcc_addrs` text,
 `to_addrs_ids` text,
 `to_addrs_names` text,
 `to_addrs_emails` text,
 `cc_addrs_ids` text,
 `cc_addrs_names` text,
 `cc_addrs_emails` text,
 `bcc_addrs_ids` text,
 `bcc_addrs_names` text,
 `bcc_addrs_emails` text,
 `type` varchar(25) default NULL,
 `status` varchar(25) default NULL,
 `message_id` varchar(100) default NULL,
 `reply_to_name` varchar(100) default NULL,
 `reply_to_addr` varchar(100) default NULL,
 `intent` varchar(25) default 'pick',
 `mailbox_id` char(36) default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_email_name` (`name`),
 KEY `idx_message_id` (`message_id`),
 KEY `idx_email_parent_id` (`parent_id`),
 KEY `idx_email_assigned` (`assigned_user_id`,`type`,`status`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emails_accounts CREATE TABLE `emails_accounts` ( 

 `id` varchar(36) NOT NULL,
 `email_id` varchar(36) default NULL,
 `account_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_acc_email_email` (`email_id`),
 KEY `idx_acc_email_acc` (`account_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emails_bugs CREATE TABLE `emails_bugs` ( 

 `id` varchar(36) NOT NULL,
 `email_id` varchar(36) default NULL,
 `bug_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_bug_email_email` (`email_id`),
 KEY `idx_bug_email_bug` (`bug_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emails_cases CREATE TABLE `emails_cases` ( 

 `id` varchar(36) NOT NULL,
 `email_id` varchar(36) default NULL,
 `case_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_case_email_email` (`email_id`),
 KEY `idx_case_email_case` (`case_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emails_contacts CREATE TABLE `emails_contacts` ( 

 `id` varchar(36) NOT NULL,
 `email_id` varchar(36) default NULL,
 `contact_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_con_email_email` (`email_id`),
 KEY `idx_con_email_con` (`contact_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emails_leads CREATE TABLE `emails_leads` ( 

 `id` varchar(36) NOT NULL,
 `email_id` varchar(36) default NULL,
 `lead_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_lead_email_email` (`email_id`),
 KEY `idx_lead_email_lead` (`lead_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emails_opportunities CREATE TABLE `emails_opportunities` ( 

 `id` varchar(36) NOT NULL,
 `email_id` varchar(36) default NULL,
 `opportunity_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_opp_email_email` (`email_id`),
 KEY `idx_opp_email_opp` (`opportunity_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emails_project_tasks CREATE TABLE `emails_project_tasks` ( 

 `id` varchar(36) NOT NULL,
 `email_id` varchar(36) default NULL,
 `project_task_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_project_task_email_email` (`email_id`),
 KEY `idx_project_task_email_project_task` (`project_task_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emails_projects CREATE TABLE `emails_projects` ( 

 `id` varchar(36) NOT NULL,
 `email_id` varchar(36) default NULL,
 `project_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_project_email_email` (`email_id`),
 KEY `idx_project_email_project` (`project_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emails_prospects CREATE TABLE `emails_prospects` ( 

 `id` varchar(36) NOT NULL,
 `email_id` varchar(36) default NULL,
 `prospect_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_prospect_email_email` (`email_id`),
 KEY `idx_prospect_email_prospect` (`prospect_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emails_tasks CREATE TABLE `emails_tasks` ( 

 `id` varchar(36) NOT NULL,
 `email_id` varchar(36) default NULL,
 `task_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_task_email_email` (`email_id`),
 KEY `idx_task_email_task` (`task_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

emails_users CREATE TABLE `emails_users` ( 

 `id` varchar(36) NOT NULL,
 `email_id` varchar(36) default NULL,
 `user_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_usr_email_email` (`email_id`),
 KEY `idx_usr_email_usr` (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

feeds CREATE TABLE `feeds` ( 

 `id` char(36) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) NOT NULL,
 `assigned_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `title` varchar(100) default NULL,
 `description` text,
 `url` varchar(255) default NULL,
 PRIMARY KEY  (`id`),
 KEY `idx_desc` (`title`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

fields_meta_data CREATE TABLE `fields_meta_data` ( 

 `id` varchar(255) NOT NULL,
 `name` varchar(255) default NULL,
 `label` varchar(255) default NULL,
 `custom_module` varchar(255) default NULL,
 `data_type` varchar(255) default NULL,
 `max_size` int(11) default NULL,
 `required_option` varchar(255) default NULL,
 `default_value` varchar(255) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) default '0',
 `audited` tinyint(1) default '0',
 `mass_update` tinyint(1) default '0',
 `ext1` varchar(255) default '0',
 `ext2` varchar(255) default '0',
 `ext3` varchar(255) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_meta_id_del` (`id`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

files CREATE TABLE `files` ( 

 `id` char(36) NOT NULL,
 `name` varchar(36) default NULL,
 `content` blob,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `assigned_user_id` char(36) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

iframes CREATE TABLE `iframes` ( 

 `id` char(36) NOT NULL,
 `name` varchar(255) NOT NULL,
 `url` varchar(255) NOT NULL,
 `type` varchar(255) NOT NULL,
 `placement` varchar(255) NOT NULL,
 `status` tinyint(1) NOT NULL default '0',
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `created_by` char(36) NOT NULL,
 PRIMARY KEY  (`id`),
 KEY `idx_cont_name` (`name`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

import_maps CREATE TABLE `import_maps` ( 

 `id` char(36) NOT NULL,
 `name` varchar(36) NOT NULL,
 `source` varchar(36) NOT NULL,
 `module` varchar(36) NOT NULL,
 `content` blob,
 `has_header` tinyint(1) NOT NULL default '1',
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `assigned_user_id` char(36) default NULL,
 `is_published` varchar(3) NOT NULL default 'no',
 PRIMARY KEY  (`id`),
 KEY `idx_cont_owner_id_module_and_name` (`assigned_user_id`,`module`,`name`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

inbound_email CREATE TABLE `inbound_email` ( 

 `id` varchar(36) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `name` varchar(255) default NULL,
 `status` varchar(25) NOT NULL default 'Active',
 `server_url` varchar(100) NOT NULL,
 `email_user` varchar(100) NOT NULL,
 `email_password` varchar(100) NOT NULL,
 `port` int(5) NOT NULL,
 `service` varchar(50) NOT NULL,
 `mailbox` varchar(50) NOT NULL,
 `delete_seen` tinyint(1) default '0',
 `mailbox_type` varchar(10) default NULL,
 `template_id` char(36) default NULL,
 `stored_options` varchar(255) default NULL,
 `group_id` char(36) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

inbound_email_autoreply CREATE TABLE `inbound_email_autoreply` ( 

 `id` char(36) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `autoreplied_to` varchar(100) NOT NULL,
 PRIMARY KEY  (`id`),
 KEY `idx_ie_autoreplied_to` (`autoreplied_to`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

leads CREATE TABLE `leads` ( 

 `id` char(36) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `converted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) default NULL,
 `assigned_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `salutation` varchar(5) default NULL,
 `first_name` varchar(25) default NULL,
 `last_name` varchar(25) default NULL,
 `title` varchar(100) default NULL,
 `refered_by` varchar(100) default NULL,
 `lead_source` varchar(100) default NULL,
 `lead_source_description` text,
 `status` varchar(100) default NULL,
 `status_description` text,
 `department` varchar(100) default NULL,
 `reports_to_id` char(36) default NULL,
 `do_not_call` varchar(3) default '0',
 `phone_home` varchar(25) default NULL,
 `phone_mobile` varchar(25) default NULL,
 `phone_work` varchar(25) default NULL,
 `phone_other` varchar(25) default NULL,
 `phone_fax` varchar(25) default NULL,
 `email1` varchar(100) default NULL,
 `email2` varchar(100) default NULL,
 `email_opt_out` varchar(3) default '0',
 `primary_address_street` varchar(150) default NULL,
 `primary_address_city` varchar(100) default NULL,
 `primary_address_state` varchar(100) default NULL,
 `primary_address_postalcode` varchar(20) default NULL,
 `primary_address_country` varchar(100) default NULL,
 `alt_address_street` varchar(150) default NULL,
 `alt_address_city` varchar(100) default NULL,
 `alt_address_state` varchar(100) default NULL,
 `alt_address_postalcode` varchar(20) default NULL,
 `alt_address_country` varchar(100) default NULL,
 `description` text,
 `account_name` varchar(150) default NULL,
 `account_description` text,
 `contact_id` char(36) default NULL,
 `account_id` char(36) default NULL,
 `opportunity_id` char(36) default NULL,
 `opportunity_name` varchar(255) default NULL,
 `opportunity_amount` varchar(50) default NULL,
 `campaign_id` char(36) default NULL,
 `portal_name` varchar(255) default NULL,
 `portal_app` varchar(255) default NULL,
 `invalid_email` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_lead_last_first` (`last_name`,`first_name`,`deleted`),
 KEY `idx_lead_del_stat` (`last_name`,`status`,`deleted`,`first_name`),
 KEY `idx_lead_opp_del` (`opportunity_id`,`deleted`),
 KEY `idx_leads_acct_del` (`account_id`,`deleted`),
 KEY `idx_cont_email1` (`email1`,`deleted`),
 KEY `idx_cont_email2` (`email2`,`deleted`),
 KEY `idx_lead_assigned` (`assigned_user_id`),
 KEY `idx_lead_contact` (`contact_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

leads_audit CREATE TABLE `leads_audit` ( 

 `id` char(36) NOT NULL,
 `parent_id` char(36) NOT NULL,
 `date_created` datetime default NULL,
 `created_by` varchar(36) default NULL,
 `field_name` varchar(100) default NULL,
 `data_type` varchar(100) default NULL,
 `before_value_string` varchar(255) default NULL,
 `after_value_string` varchar(255) default NULL,
 `before_value_text` text,
 `after_value_text` text

) ENGINE=MyISAM DEFAULT CHARSET=latin1

linked_documents CREATE TABLE `linked_documents` ( 

 `id` varchar(36) NOT NULL,
 `parent_id` varchar(36) default NULL,
 `parent_type` varchar(25) default NULL,
 `document_id` varchar(36) default NULL,
 `document_revision_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

meetings CREATE TABLE `meetings` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `assigned_user_id` char(36) default NULL,
 `modified_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `name` varchar(50) default NULL,
 `location` varchar(50) default NULL,
 `duration_hours` int(2) default NULL,
 `duration_minutes` int(2) default NULL,
 `date_start` date default NULL,
 `time_start` time default NULL,
 `date_end` date default NULL,
 `parent_type` varchar(25) default NULL,
 `status` varchar(25) default NULL,
 `parent_id` char(36) default NULL,
 `description` text,
 `deleted` tinyint(1) NOT NULL default '0',
 `reminder_time` int(11) default '-1',
 `outlook_id` varchar(255) default NULL,
 PRIMARY KEY  (`id`),
 KEY `idx_mtg_name` (`name`),
 KEY `idx_meet_par_del` (`parent_id`,`parent_type`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

meetings_contacts CREATE TABLE `meetings_contacts` ( 

 `id` varchar(36) NOT NULL,
 `meeting_id` varchar(36) default NULL,
 `contact_id` varchar(36) default NULL,
 `required` varchar(1) default '1',
 `accept_status` varchar(25) default 'none',
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_con_mtg_mtg` (`meeting_id`),
 KEY `idx_con_mtg_con` (`contact_id`),
 KEY `idx_meeting_contact` (`meeting_id`,`contact_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

meetings_users CREATE TABLE `meetings_users` ( 

 `id` varchar(36) NOT NULL,
 `meeting_id` varchar(36) default NULL,
 `user_id` varchar(36) default NULL,
 `required` varchar(1) default '1',
 `accept_status` varchar(25) default 'none',
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_usr_mtg_mtg` (`meeting_id`),
 KEY `idx_usr_mtg_usr` (`user_id`),
 KEY `idx_meeting_users` (`meeting_id`,`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

notes CREATE TABLE `notes` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `name` varchar(255) default NULL,
 `filename` varchar(255) default NULL,
 `file_mime_type` varchar(100) default NULL,
 `parent_type` varchar(25) default NULL,
 `parent_id` char(36) default NULL,
 `contact_id` char(36) default NULL,
 `portal_flag` tinyint(1) NOT NULL default '0',
 `description` text,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_note_name` (`name`),
 KEY `idx_notes_parent` (`parent_id`,`parent_type`),
 KEY `idx_note_contact` (`contact_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

opportunities CREATE TABLE `opportunities` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) default NULL,
 `assigned_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `name` varchar(50) default NULL,
 `opportunity_type` varchar(255) default NULL,
 `lead_source` varchar(50) default NULL,
 `amount` double default NULL,
 `amount_backup` varchar(25) default NULL,
 `amount_usdollar` double default NULL,
 `currency_id` char(36) default NULL,
 `date_closed` date default NULL,
 `next_step` varchar(100) default NULL,
 `sales_stage` varchar(25) default NULL,
 `probability` double default NULL,
 `description` text,
 PRIMARY KEY  (`id`),
 KEY `idx_opp_name` (`name`),
 KEY `idx_opp_assigned` (`assigned_user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

opportunities_audit CREATE TABLE `opportunities_audit` ( 

 `id` char(36) NOT NULL,
 `parent_id` char(36) NOT NULL,
 `date_created` datetime default NULL,
 `created_by` varchar(36) default NULL,
 `field_name` varchar(100) default NULL,
 `data_type` varchar(100) default NULL,
 `before_value_string` varchar(255) default NULL,
 `after_value_string` varchar(255) default NULL,
 `before_value_text` text,
 `after_value_text` text

) ENGINE=MyISAM DEFAULT CHARSET=latin1

opportunities_contacts CREATE TABLE `opportunities_contacts` ( 

 `id` varchar(36) NOT NULL,
 `contact_id` varchar(36) default NULL,
 `opportunity_id` varchar(36) default NULL,
 `contact_role` varchar(50) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_con_opp_con` (`contact_id`),
 KEY `idx_con_opp_opp` (`opportunity_id`),
 KEY `idx_opportunities_contacts` (`opportunity_id`,`contact_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

project CREATE TABLE `project` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `assigned_user_id` char(36) default NULL,
 `modified_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `name` varchar(50) NOT NULL,
 `description` text,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

project_relation CREATE TABLE `project_relation` ( 

 `id` char(36) NOT NULL,
 `project_id` char(36) NOT NULL,
 `relation_id` char(36) NOT NULL,
 `relation_type` varchar(255) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_modified` datetime NOT NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

project_task CREATE TABLE `project_task` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `assigned_user_id` char(36) default NULL,
 `modified_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `name` varchar(50) NOT NULL,
 `status` varchar(255) default NULL,
 `date_due` date default NULL,
 `time_due` time default NULL,
 `date_start` date default NULL,
 `time_start` time default NULL,
 `parent_id` char(36) NOT NULL,
 `priority` varchar(255) default NULL,
 `description` text,
 `order_number` int(11) default '1',
 `task_number` int(11) default NULL,
 `depends_on_id` char(36) default NULL,
 `milestone_flag` varchar(255) default NULL,
 `estimated_effort` int(11) default NULL,
 `actual_effort` int(11) default NULL,
 `utilization` int(11) default '100',
 `percent_complete` int(11) default '0',
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

project_task_audit CREATE TABLE `project_task_audit` ( 

 `id` char(36) NOT NULL,
 `parent_id` char(36) NOT NULL,
 `date_created` datetime default NULL,
 `created_by` varchar(36) default NULL,
 `field_name` varchar(100) default NULL,
 `data_type` varchar(100) default NULL,
 `before_value_string` varchar(255) default NULL,
 `after_value_string` varchar(255) default NULL,
 `before_value_text` text,
 `after_value_text` text

) ENGINE=MyISAM DEFAULT CHARSET=latin1

prospect_list_campaigns CREATE TABLE `prospect_list_campaigns` ( 

 `id` varchar(36) NOT NULL,
 `prospect_list_id` varchar(36) default NULL,
 `campaign_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_pro_id` (`prospect_list_id`),
 KEY `idx_cam_id` (`campaign_id`),
 KEY `idx_prospect_list_campaigns` (`prospect_list_id`,`campaign_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

prospect_lists CREATE TABLE `prospect_lists` ( 

 `id` char(36) NOT NULL,
 `name` varchar(50) default NULL,
 `list_type` varchar(25) default NULL,
 `date_entered` datetime default NULL,
 `date_modified` datetime default NULL,
 `modified_user_id` char(36) default NULL,
 `assigned_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `description` text,
 `domain_name` varchar(255) default NULL,
 PRIMARY KEY  (`id`),
 KEY `idx_prospect_list_name` (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

prospect_lists_prospects CREATE TABLE `prospect_lists_prospects` ( 

 `id` varchar(36) NOT NULL,
 `prospect_list_id` varchar(36) default NULL,
 `related_id` varchar(36) default NULL,
 `related_type` varchar(25) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_pro_id` (`prospect_list_id`),
 KEY `idx_realted_id` (`related_id`,`related_type`,`prospect_list_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

prospects CREATE TABLE `prospects` ( 

 `id` char(36) NOT NULL,
 `tracker_key` int(11) NOT NULL auto_increment,
 `deleted` tinyint(1) default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) default NULL,
 `assigned_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `salutation` varchar(5) default NULL,
 `first_name` varchar(100) default NULL,
 `last_name` varchar(100) default NULL,
 `title` varchar(25) default NULL,
 `department` varchar(255) default NULL,
 `birthdate` date default NULL,
 `do_not_call` varchar(3) default '0',
 `phone_home` varchar(25) default NULL,
 `phone_mobile` varchar(25) default NULL,
 `phone_work` varchar(25) default NULL,
 `phone_other` varchar(25) default NULL,
 `phone_fax` varchar(25) default NULL,
 `email1` varchar(100) default NULL,
 `email2` varchar(100) default NULL,
 `assistant` varchar(75) default NULL,
 `assistant_phone` varchar(25) default NULL,
 `email_opt_out` varchar(3) default '0',
 `primary_address_street` varchar(150) default NULL,
 `primary_address_city` varchar(100) default NULL,
 `primary_address_state` varchar(100) default NULL,
 `primary_address_postalcode` varchar(20) default NULL,
 `primary_address_country` varchar(100) default NULL,
 `alt_address_street` varchar(150) default NULL,
 `alt_address_city` varchar(100) default NULL,
 `alt_address_state` varchar(100) default NULL,
 `alt_address_postalcode` varchar(20) default NULL,
 `alt_address_country` varchar(100) default NULL,
 `description` text,
 `invalid_email` tinyint(1) default '0',
 `lead_id` char(36) default NULL,
 `account_name` varchar(150) default NULL,
 PRIMARY KEY  (`id`),
 KEY `auto_tracker_key` (`tracker_key`),
 KEY `idx_prospects_last_first` (`last_name`,`first_name`,`deleted`),
 KEY `idx_prospecs_del_last` (`last_name`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

relationships CREATE TABLE `relationships` ( 

 `id` char(36) NOT NULL,
 `relationship_name` varchar(150) NOT NULL,
 `lhs_module` varchar(100) NOT NULL,
 `lhs_table` varchar(64) NOT NULL,
 `lhs_key` varchar(64) NOT NULL,
 `rhs_module` varchar(100) NOT NULL,
 `rhs_table` varchar(64) NOT NULL,
 `rhs_key` varchar(64) NOT NULL,
 `join_table` varchar(64) default NULL,
 `join_key_lhs` varchar(64) default NULL,
 `join_key_rhs` varchar(64) default NULL,
 `relationship_type` varchar(64) default NULL,
 `relationship_role_column` varchar(64) default NULL,
 `relationship_role_column_value` varchar(50) default NULL,
 `reverse` tinyint(1) default '0',
 `deleted` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_rel_name` (`relationship_name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

releases CREATE TABLE `releases` ( 

 `id` char(36) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) NOT NULL,
 `created_by` char(36) default NULL,
 `name` varchar(50) NOT NULL,
 `list_order` int(4) default NULL,
 `status` varchar(25) default NULL,
 PRIMARY KEY  (`id`),
 KEY `idx_releases` (`name`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

roles CREATE TABLE `roles` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) NOT NULL,
 `created_by` char(36) default NULL,
 `name` varchar(150) default NULL,
 `description` text,
 `modules` text,
 `deleted` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_role_id_del` (`id`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

roles_modules CREATE TABLE `roles_modules` ( 

 `id` varchar(36) NOT NULL,
 `role_id` varchar(36) default NULL,
 `module_id` varchar(36) default NULL,
 `allow` tinyint(1) default '0',
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_role_id` (`role_id`),
 KEY `idx_module_id` (`module_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

roles_users CREATE TABLE `roles_users` ( 

 `id` varchar(36) NOT NULL,
 `role_id` varchar(36) default NULL,
 `user_id` varchar(36) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_role_id` (`role_id`),
 KEY `idx_user_id` (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

schedulers CREATE TABLE `schedulers` ( 

 `id` varchar(36) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `created_by` char(36) default NULL,
 `modified_user_id` char(36) default NULL,
 `name` varchar(255) NOT NULL,
 `job` varchar(255) NOT NULL,
 `date_time_start` datetime NOT NULL,
 `date_time_end` datetime default NULL,
 `job_interval` varchar(100) NOT NULL,
 `time_from` time default NULL,
 `time_to` time default NULL,
 `last_run` datetime default NULL,
 `status` varchar(25) default NULL,
 `catch_up` tinyint(1) default '1',
 PRIMARY KEY  (`id`),
 KEY `idx_schedule` (`date_time_start`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

schedulers_times CREATE TABLE `schedulers_times` ( 

 `id` char(36) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `scheduler_id` char(36) NOT NULL,
 `execute_time` datetime NOT NULL,
 `status` varchar(25) NOT NULL default 'ready',
 PRIMARY KEY  (`id`),
 KEY `idx_scheduler_id` (`scheduler_id`,`execute_time`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

tasks CREATE TABLE `tasks` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `assigned_user_id` char(36) default NULL,
 `modified_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `name` varchar(50) default NULL,
 `status` varchar(25) default NULL,
 `date_due_flag` varchar(5) default 'on',
 `date_due` date default NULL,
 `time_due` time default NULL,
 `date_start_flag` varchar(5) default 'on',
 `date_start` date default NULL,
 `time_start` time default NULL,
 `parent_type` varchar(25) default NULL,
 `parent_id` char(36) default NULL,
 `contact_id` char(36) default NULL,
 `priority` varchar(25) default NULL,
 `description` text,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_tsk_name` (`name`),
 KEY `idx_task_con_del` (`contact_id`,`deleted`),
 KEY `idx_task_par_del` (`parent_id`,`parent_type`,`deleted`),
 KEY `idx_task_assigned` (`assigned_user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

tracker CREATE TABLE `tracker` ( 

 `id` int(11) NOT NULL auto_increment,
 `user_id` char(36) default NULL,
 `module_name` varchar(25) default NULL,
 `item_id` char(36) default NULL,
 `item_summary` varchar(255) default NULL,
 `date_modified` datetime default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

upgrade_history CREATE TABLE `upgrade_history` ( 

 `id` char(36) NOT NULL,
 `filename` varchar(255) default NULL,
 `md5sum` varchar(32) default NULL,
 `type` varchar(30) default NULL,
 `status` varchar(50) default NULL,
 `version` varchar(10) default NULL,
 `date_entered` datetime NOT NULL,
 PRIMARY KEY  (`id`),
 UNIQUE KEY `upgrade_history_md5_uk` (`md5sum`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

users CREATE TABLE `users` ( 

 `id` char(36) NOT NULL,
 `user_name` varchar(20) default NULL,
 `user_password` varchar(30) default NULL,
 `user_hash` varchar(32) default NULL,
 `first_name` varchar(30) default NULL,
 `last_name` varchar(30) default NULL,
 `reports_to_id` char(36) default NULL,
 `is_admin` varchar(3) default '0',
 `receive_notifications` varchar(1) default '1',
 `description` text,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) default NULL,
 `created_by` char(36) default NULL,
 `title` varchar(50) default NULL,
 `department` varchar(50) default NULL,
 `phone_home` varchar(50) default NULL,
 `phone_mobile` varchar(50) default NULL,
 `phone_work` varchar(50) default NULL,
 `phone_other` varchar(50) default NULL,
 `phone_fax` varchar(50) default NULL,
 `email1` varchar(100) default NULL,
 `email2` varchar(100) default NULL,
 `status` varchar(25) default NULL,
 `address_street` varchar(150) default NULL,
 `address_city` varchar(100) default NULL,
 `address_state` varchar(100) default NULL,
 `address_country` varchar(25) default NULL,
 `address_postalcode` varchar(9) default NULL,
 `user_preferences` text,
 `deleted` tinyint(1) NOT NULL default '0',
 `portal_only` tinyint(1) default '0',
 `employee_status` varchar(25) default NULL,
 `messenger_id` varchar(25) default NULL,
 `messenger_type` varchar(25) default NULL,
 `is_group` tinyint(1) default '0',
 PRIMARY KEY  (`id`),
 KEY `user_name` (`user_name`),
 KEY `user_password` (`user_password`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

users_feeds CREATE TABLE `users_feeds` ( 

 `user_id` varchar(36) default NULL,
 `feed_id` varchar(36) default NULL,
 `rank` int(11) default NULL,
 `date_modified` datetime default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 KEY `idx_user_id` (`user_id`,`feed_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

users_last_import CREATE TABLE `users_last_import` ( 

 `id` char(36) NOT NULL,
 `assigned_user_id` char(36) default NULL,
 `bean_type` varchar(36) default NULL,
 `bean_id` char(36) default NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `idx_user_id` (`assigned_user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

users_signatures CREATE TABLE `users_signatures` ( 

 `id` char(36) NOT NULL,
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `user_id` varchar(36) default NULL,
 `name` varchar(255) default NULL,
 `signature` text,
 `signature_html` text,
 PRIMARY KEY  (`id`),
 KEY `idx_user_id` (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

vcals CREATE TABLE `vcals` ( 

 `id` char(36) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime default NULL,
 `date_modified` datetime default NULL,
 `user_id` char(36) NOT NULL,
 `type` varchar(25) default NULL,
 `source` varchar(25) default NULL,
 `content` text,
 PRIMARY KEY  (`id`),
 KEY `idx_vcal` (`type`,`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

versions CREATE TABLE `versions` ( 

 `id` char(36) NOT NULL,
 `deleted` tinyint(1) NOT NULL default '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) NOT NULL,
 `created_by` char(36) default NULL,
 `name` varchar(255) NOT NULL,
 `file_version` varchar(255) NOT NULL,
 `db_version` varchar(255) NOT NULL,
 PRIMARY KEY  (`id`),
 KEY `idx_version` (`name`,`deleted`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

Retrieved from "https://wikitech.wikimedia.org/w/index.php?title=Obsolete:Sugar/tables&oldid=1759937"