SuiteCRM Table Schema Downloaded
SuiteCRM Table Schema Downloaded from EasyManage
/* Table Schema SQL (mysql format) for [suitecrm] */
/* Id: 5010158 Name: accounts */
create table accounts (
id VARCHAR (36)
, name VARCHAR (150)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, account_type VARCHAR (50)
, industry VARCHAR (50)
, annual_revenue VARCHAR (100)
, phone_fax VARCHAR (100)
, billing_address_street VARCHAR (150)
, billing_address_city VARCHAR (100)
, billing_address_state VARCHAR (100)
, billing_address_postalcode VARCHAR (20)
, billing_address_country VARCHAR (255)
, rating VARCHAR (100)
, phone_office VARCHAR (100)
, phone_alternate VARCHAR (100)
, website VARCHAR (255)
, ownership VARCHAR (100)
, employees VARCHAR (10)
, ticker_symbol VARCHAR (10)
, shipping_address_street VARCHAR (150)
, shipping_address_city VARCHAR (100)
, shipping_address_state VARCHAR (100)
, shipping_address_postalcode VARCHAR (20)
, shipping_address_country VARCHAR (255)
, parent_id VARCHAR (36)
, sic_code VARCHAR (10)
, campaign_id VARCHAR (36)
);
/* Id: 5010160 Name: accounts_audit */
create table accounts_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010162 Name: accounts_bugs */
create table accounts_bugs (
id VARCHAR (36)
, account_id VARCHAR (36)
, bug_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010164 Name: accounts_cases */
create table accounts_cases (
id VARCHAR (36)
, account_id VARCHAR (36)
, case_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010166 Name: accounts_contacts */
create table accounts_contacts (
id VARCHAR (36)
, contact_id VARCHAR (36)
, account_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010168 Name: accounts_cstm */
create table accounts_cstm (
id_c VARCHAR (36)
, jjwg_maps_lng_c DECIMAL(38,6)
, jjwg_maps_lat_c DECIMAL(38,6)
, jjwg_maps_geocode_status_c VARCHAR (255)
, jjwg_maps_address_c VARCHAR (255)
);
/* Id: 5010170 Name: accounts_opportunities */
create table accounts_opportunities (
id VARCHAR (36)
, opportunity_id VARCHAR (36)
, account_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010172 Name: acl_actions */
create table acl_actions (
id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, name VARCHAR (150)
, category VARCHAR (100)
, acltype VARCHAR (100)
, aclaccess INT
, deleted VARCHAR (0)
);
/* Id: 5010174 Name: acl_roles */
create table acl_roles (
id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, name VARCHAR (150)
, description MEDIUMTEXT
, deleted VARCHAR (0)
);
/* Id: 5010176 Name: acl_roles_actions */
create table acl_roles_actions (
id VARCHAR (36)
, role_id VARCHAR (36)
, action_id VARCHAR (36)
, access_override INT
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010178 Name: acl_roles_users */
create table acl_roles_users (
id VARCHAR (36)
, role_id VARCHAR (36)
, user_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010180 Name: address_book */
create table address_book (
assigned_user_id VARCHAR (36)
, bean VARCHAR (50)
, bean_id VARCHAR (36)
);
/* Id: 5010182 Name: alerts */
create table alerts (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, is_read VARCHAR (0)
, target_module VARCHAR (255)
, type VARCHAR (255)
, url_redirect VARCHAR (255)
, reminder_id VARCHAR (36)
, snooze TIMESTAMP
, date_start TIMESTAMP
);
/* Id: 5010184 Name: am_projecttemplates */
create table am_projecttemplates (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, status VARCHAR (100)
, priority VARCHAR (100)
, override_business_hours VARCHAR (0)
);
/* Id: 5010186 Name: am_projecttemplates_audit */
create table am_projecttemplates_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010188 Name: am_projecttemplates_contacts_1_c */
create table am_projecttemplates_contacts_1_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, am_projecttemplates_ida VARCHAR (36)
, contacts_idb VARCHAR (36)
);
/* Id: 5010190 Name: am_projecttemplates_project_1_c */
create table am_projecttemplates_project_1_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, am_projecttemplates_project_1pro VARCHAR (36)
);
/* Id: 5010192 Name: am_projecttemplates_users_1_c */
create table am_projecttemplates_users_1_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, am_projecttemplates_ida VARCHAR (36)
, users_idb VARCHAR (36)
);
/* Id: 5010194 Name: am_tasktemplates */
create table am_tasktemplates (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, status VARCHAR (100)
, priority VARCHAR (100)
, percent_complete INT
, predecessors INT
, milestone_flag VARCHAR (0)
, relationship_type VARCHAR (100)
, task_number INT
, order_number INT
, estimated_effort INT
, utilization VARCHAR (100)
, duration INT
);
/* Id: 5010196 Name: am_tasktemplates_am_projecttempl */
create table am_tasktemplates_am_projecttempl (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010198 Name: am_tasktemplates_audit */
create table am_tasktemplates_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010200 Name: aobh_businesshours */
create table aobh_businesshours (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, opening_hours VARCHAR (100)
, closing_hours VARCHAR (100)
, open_status VARCHAR (0)
, day VARCHAR (100)
);
/* Id: 5010202 Name: aok_knowledge_base_categories */
create table aok_knowledge_base_categories (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
);
/* Id: 5010204 Name: aok_knowledge_base_categories_au */
create table aok_knowledge_base_categories_au (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010206 Name: aok_knowledgebase */
create table aok_knowledgebase (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, status VARCHAR (100)
, revision VARCHAR (255)
, additional_info MEDIUMTEXT
, user_id_c VARCHAR (36)
, user_id1_c VARCHAR (36)
);
/* Id: 5010208 Name: aok_knowledgebase_audit */
create table aok_knowledgebase_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010210 Name: aok_knowledgebase_categories */
create table aok_knowledgebase_categories (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, aok_knowledgebase_id VARCHAR (36)
, aok_knowledge_base_categories_id VARCHAR (36)
);
/* Id: 5010212 Name: aop_case_events */
create table aop_case_events (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, case_id VARCHAR (36)
);
/* Id: 5010214 Name: aop_case_events_audit */
create table aop_case_events_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010216 Name: aop_case_updates */
create table aop_case_updates (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, case_id VARCHAR (36)
, contact_id VARCHAR (36)
, internal VARCHAR (0)
);
/* Id: 5010218 Name: aop_case_updates_audit */
create table aop_case_updates_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010220 Name: aor_charts */
create table aor_charts (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, aor_report_id VARCHAR (36)
, type VARCHAR (100)
, x_field INT
, y_field INT
);
/* Id: 5010222 Name: aor_conditions */
create table aor_conditions (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, aor_report_id VARCHAR (36)
, condition_order INT
, logic_op VARCHAR (255)
, parenthesis VARCHAR (255)
, module_path MEDIUMTEXT
, field VARCHAR (100)
, operator VARCHAR (100)
, value_type VARCHAR (100)
, value VARCHAR (255)
, parameter VARCHAR (0)
);
/* Id: 5010224 Name: aor_fields */
create table aor_fields (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, aor_report_id VARCHAR (36)
, field_order INT
, module_path MEDIUMTEXT
, field VARCHAR (100)
, display VARCHAR (0)
, link VARCHAR (0)
, label VARCHAR (255)
, field_function VARCHAR (100)
, sort_by VARCHAR (100)
, format VARCHAR (100)
, total VARCHAR (100)
, sort_order VARCHAR (100)
, group_by VARCHAR (0)
, group_order VARCHAR (100)
, group_display INT
);
/* Id: 5010226 Name: aor_reports */
create table aor_reports (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, report_module VARCHAR (100)
, graphs_per_row INT
);
/* Id: 5010228 Name: aor_reports_audit */
create table aor_reports_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010230 Name: aor_scheduled_reports */
create table aor_scheduled_reports (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, schedule VARCHAR (100)
, last_run TIMESTAMP
, status VARCHAR (100)
, email_recipients MEDIUMTEXT
, aor_report_id VARCHAR (36)
);
/* Id: 5010232 Name: aos_contracts */
create table aos_contracts (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, reference_code VARCHAR (255)
, start_date TIMESTAMP
, end_date TIMESTAMP
, total_contract_value DECIMAL(38,6)
, total_contract_value_usdollar DECIMAL(38,6)
, currency_id VARCHAR (36)
, status VARCHAR (100)
, customer_signed_date TIMESTAMP
, company_signed_date TIMESTAMP
, renewal_reminder_date TIMESTAMP
, contract_type VARCHAR (100)
, contract_account_id VARCHAR (36)
, opportunity_id VARCHAR (36)
, contact_id VARCHAR (36)
, call_id VARCHAR (36)
, total_amt DECIMAL(38,6)
, total_amt_usdollar DECIMAL(38,6)
, subtotal_amount DECIMAL(38,6)
, subtotal_amount_usdollar DECIMAL(38,6)
, discount_amount DECIMAL(38,6)
, discount_amount_usdollar DECIMAL(38,6)
, tax_amount DECIMAL(38,6)
, tax_amount_usdollar DECIMAL(38,6)
, shipping_amount DECIMAL(38,6)
, shipping_amount_usdollar DECIMAL(38,6)
, shipping_tax VARCHAR (100)
, shipping_tax_amt DECIMAL(38,6)
, shipping_tax_amt_usdollar DECIMAL(38,6)
, total_amount DECIMAL(38,6)
, total_amount_usdollar DECIMAL(38,6)
);
/* Id: 5010234 Name: aos_contracts_audit */
create table aos_contracts_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010236 Name: aos_contracts_documents */
create table aos_contracts_documents (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, aos_contracts_id VARCHAR (36)
, documents_id VARCHAR (36)
, document_revision_id VARCHAR (36)
);
/* Id: 5010238 Name: aos_invoices */
create table aos_invoices (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, billing_account_id VARCHAR (36)
, billing_contact_id VARCHAR (36)
, billing_address_street VARCHAR (150)
, billing_address_city VARCHAR (100)
, billing_address_state VARCHAR (100)
, billing_address_postalcode VARCHAR (20)
, billing_address_country VARCHAR (255)
, shipping_address_street VARCHAR (150)
, shipping_address_city VARCHAR (100)
, shipping_address_state VARCHAR (100)
, shipping_address_postalcode VARCHAR (20)
, shipping_address_country VARCHAR (255)
, number INT
, total_amt DECIMAL(38,6)
, total_amt_usdollar DECIMAL(38,6)
, subtotal_amount DECIMAL(38,6)
, subtotal_amount_usdollar DECIMAL(38,6)
, discount_amount DECIMAL(38,6)
, discount_amount_usdollar DECIMAL(38,6)
, tax_amount DECIMAL(38,6)
, tax_amount_usdollar DECIMAL(38,6)
, shipping_amount DECIMAL(38,6)
, shipping_amount_usdollar DECIMAL(38,6)
, shipping_tax VARCHAR (100)
, shipping_tax_amt DECIMAL(38,6)
, shipping_tax_amt_usdollar DECIMAL(38,6)
, total_amount DECIMAL(38,6)
, total_amount_usdollar DECIMAL(38,6)
, currency_id VARCHAR (36)
, quote_number INT
, quote_date TIMESTAMP
);
/* Id: 5010240 Name: aos_invoices_audit */
create table aos_invoices_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010242 Name: aos_line_item_groups */
create table aos_line_item_groups (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, total_amt DECIMAL(38,6)
, total_amt_usdollar DECIMAL(38,6)
, discount_amount DECIMAL(38,6)
, discount_amount_usdollar DECIMAL(38,6)
, subtotal_amount DECIMAL(38,6)
, subtotal_amount_usdollar DECIMAL(38,6)
, tax_amount DECIMAL(38,6)
, tax_amount_usdollar DECIMAL(38,6)
, subtotal_tax_amount DECIMAL(38,6)
, subtotal_tax_amount_usdollar DECIMAL(38,6)
, total_amount DECIMAL(38,6)
, total_amount_usdollar DECIMAL(38,6)
, parent_type VARCHAR (100)
, parent_id VARCHAR (36)
, number INT
, currency_id VARCHAR (36)
);
/* Id: 5010244 Name: aos_line_item_groups_audit */
create table aos_line_item_groups_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010246 Name: aos_pdf_templates */
create table aos_pdf_templates (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, active VARCHAR (0)
, type VARCHAR (100)
, pdfheader MEDIUMTEXT
, pdffooter MEDIUMTEXT
, margin_left INT
, margin_right INT
, margin_top INT
, margin_bottom INT
, margin_header INT
, margin_footer INT
, page_size VARCHAR (100)
, orientation VARCHAR (100)
);
/* Id: 5010248 Name: aos_pdf_templates_audit */
create table aos_pdf_templates_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010250 Name: aos_product_categories */
create table aos_product_categories (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, is_parent VARCHAR (0)
, parent_category_id VARCHAR (36)
);
/* Id: 5010252 Name: aos_product_categories_audit */
create table aos_product_categories_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010254 Name: aos_products */
create table aos_products (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, maincode VARCHAR (100)
, part_number VARCHAR (25)
, category VARCHAR (100)
, type VARCHAR (100)
, cost DECIMAL(38,6)
, cost_usdollar DECIMAL(38,6)
, currency_id VARCHAR (36)
, price DECIMAL(38,6)
, price_usdollar DECIMAL(38,6)
, url VARCHAR (255)
, contact_id VARCHAR (36)
, product_image VARCHAR (255)
, aos_product_category_id VARCHAR (36)
);
/* Id: 5010256 Name: aos_products_audit */
create table aos_products_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010258 Name: aos_products_quotes */
create table aos_products_quotes (
id VARCHAR (36)
, name MEDIUMTEXT
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, currency_id VARCHAR (36)
, part_number VARCHAR (255)
, item_description MEDIUMTEXT
, number INT
, product_qty DECIMAL(38,6)
, product_cost_price DECIMAL(38,6)
, product_cost_price_usdollar DECIMAL(38,6)
, product_list_price DECIMAL(38,6)
, product_list_price_usdollar DECIMAL(38,6)
, product_discount DECIMAL(38,6)
, product_discount_usdollar DECIMAL(38,6)
, product_discount_amount DECIMAL(38,6)
, product_discount_amount_usdollar DECIMAL(38,6)
, discount VARCHAR (255)
, product_unit_price DECIMAL(38,6)
, product_unit_price_usdollar DECIMAL(38,6)
, vat_amt DECIMAL(38,6)
, vat_amt_usdollar DECIMAL(38,6)
, product_total_price DECIMAL(38,6)
, product_total_price_usdollar DECIMAL(38,6)
, vat VARCHAR (100)
, parent_type VARCHAR (100)
, parent_id VARCHAR (36)
, product_id VARCHAR (36)
, group_id VARCHAR (36)
);
/* Id: 5010260 Name: aos_products_quotes_audit */
create table aos_products_quotes_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010262 Name: aos_quotes */
create table aos_quotes (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, approval_issue MEDIUMTEXT
, billing_account_id VARCHAR (36)
, billing_contact_id VARCHAR (36)
, billing_address_street VARCHAR (150)
, billing_address_city VARCHAR (100)
, billing_address_state VARCHAR (100)
, billing_address_postalcode VARCHAR (20)
, billing_address_country VARCHAR (255)
, shipping_address_street VARCHAR (150)
, shipping_address_city VARCHAR (100)
, shipping_address_state VARCHAR (100)
, shipping_address_postalcode VARCHAR (20)
, shipping_address_country VARCHAR (255)
, expiration TIMESTAMP
, number INT
, opportunity_id VARCHAR (36)
, template_ddown_c MEDIUMTEXT
, total_amt DECIMAL(38,6)
, total_amt_usdollar DECIMAL(38,6)
, subtotal_amount DECIMAL(38,6)
, subtotal_amount_usdollar DECIMAL(38,6)
, discount_amount DECIMAL(38,6)
, discount_amount_usdollar DECIMAL(38,6)
, tax_amount DECIMAL(38,6)
, tax_amount_usdollar DECIMAL(38,6)
, shipping_amount DECIMAL(38,6)
, shipping_amount_usdollar DECIMAL(38,6)
, shipping_tax VARCHAR (100)
, shipping_tax_amt DECIMAL(38,6)
, shipping_tax_amt_usdollar DECIMAL(38,6)
, total_amount DECIMAL(38,6)
);
/* Id: 5010264 Name: aos_quotes_aos_invoices_c */
create table aos_quotes_aos_invoices_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, aos_quotes77d9_quotes_ida VARCHAR (36)
, aos_quotes6b83nvoices_idb VARCHAR (36)
);
/* Id: 5010266 Name: aos_quotes_audit */
create table aos_quotes_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010268 Name: aos_quotes_os_contracts_c */
create table aos_quotes_os_contracts_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, aos_quotese81e_quotes_ida VARCHAR (36)
, aos_quotes4dc0ntracts_idb VARCHAR (36)
);
/* Id: 5010270 Name: aos_quotes_project_c */
create table aos_quotes_project_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, aos_quotes1112_quotes_ida VARCHAR (36)
, aos_quotes7207project_idb VARCHAR (36)
);
/* Id: 5010272 Name: aow_actions */
create table aow_actions (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, aow_workflow_id VARCHAR (36)
, action_order INT
, action VARCHAR (100)
, parameters MEDIUMTEXT
);
/* Id: 5010274 Name: aow_conditions */
create table aow_conditions (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, aow_workflow_id VARCHAR (36)
, condition_order INT
, module_path MEDIUMTEXT
, field VARCHAR (100)
, operator VARCHAR (100)
, value_type VARCHAR (255)
, value VARCHAR (255)
);
/* Id: 5010276 Name: aow_processed */
create table aow_processed (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, aow_workflow_id VARCHAR (36)
, parent_id VARCHAR (36)
, parent_type VARCHAR (100)
, status VARCHAR (100)
);
/* Id: 5010278 Name: aow_processed_aow_actions */
create table aow_processed_aow_actions (
id VARCHAR (36)
, aow_processed_id VARCHAR (36)
, aow_action_id VARCHAR (36)
, status VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010280 Name: aow_workflow */
create table aow_workflow (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, flow_module VARCHAR (100)
, flow_run_on VARCHAR (100)
, status VARCHAR (100)
, run_when VARCHAR (100)
, multiple_runs VARCHAR (0)
, run_on_import VARCHAR (0)
);
/* Id: 5010282 Name: aow_workflow_audit */
create table aow_workflow_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010284 Name: bugs */
create table bugs (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, bug_number INT
, type VARCHAR (255)
, status VARCHAR (100)
, priority VARCHAR (100)
, resolution VARCHAR (255)
, work_log MEDIUMTEXT
, found_in_release VARCHAR (255)
, fixed_in_release VARCHAR (255)
, source VARCHAR (255)
, product_category VARCHAR (255)
);
/* Id: 5010286 Name: bugs_audit */
create table bugs_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010288 Name: cache_rebuild */
create table cache_rebuild (
cache_key VARCHAR (255)
, rebuild VARCHAR (0)
);
/* Id: 5010290 Name: calls */
create table calls (
id VARCHAR (36)
, name VARCHAR (50)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, duration_hours INT
, duration_minutes INT
, date_start TIMESTAMP
, date_end TIMESTAMP
, parent_type VARCHAR (255)
, status VARCHAR (100)
, direction VARCHAR (100)
, parent_id VARCHAR (36)
, reminder_time INT
, email_reminder_time INT
, email_reminder_sent VARCHAR (0)
, outlook_id VARCHAR (255)
, repeat_type VARCHAR (36)
, repeat_interval INT
, repeat_dow VARCHAR (7)
, repeat_until TIMESTAMP
, repeat_count INT
, repeat_parent_id VARCHAR (36)
, recurring_source VARCHAR (36)
);
/* Id: 5010292 Name: calls_contacts */
create table calls_contacts (
id VARCHAR (36)
, call_id VARCHAR (36)
, contact_id VARCHAR (36)
, required VARCHAR (1)
, accept_status VARCHAR (25)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010294 Name: calls_leads */
create table calls_leads (
id VARCHAR (36)
, call_id VARCHAR (36)
, lead_id VARCHAR (36)
, required VARCHAR (1)
, accept_status VARCHAR (25)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010296 Name: calls_reschedule */
create table calls_reschedule (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, reason VARCHAR (100)
, call_id VARCHAR (36)
);
/* Id: 5010298 Name: calls_reschedule_audit */
create table calls_reschedule_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010300 Name: calls_users */
create table calls_users (
id VARCHAR (36)
, call_id VARCHAR (36)
, user_id VARCHAR (36)
, required VARCHAR (1)
, accept_status VARCHAR (25)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010302 Name: campaign_log */
create table campaign_log (
id VARCHAR (36)
, campaign_id VARCHAR (36)
, target_tracker_key VARCHAR (36)
, target_id VARCHAR (36)
, target_type VARCHAR (100)
, activity_type VARCHAR (100)
, activity_date TIMESTAMP
, related_id VARCHAR (36)
, related_type VARCHAR (100)
, archived VARCHAR (0)
, hits INT
, list_id VARCHAR (36)
, deleted VARCHAR (0)
, date_modified TIMESTAMP
, more_information VARCHAR (100)
, marketing_id VARCHAR (36)
);
/* Id: 5010304 Name: campaign_trkrs */
create table campaign_trkrs (
id VARCHAR (36)
, tracker_name VARCHAR (255)
, tracker_url VARCHAR (255)
, tracker_key INT
, campaign_id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, is_optout VARCHAR (0)
, deleted VARCHAR (0)
);
/* Id: 5010306 Name: campaigns */
create table campaigns (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, tracker_key INT
, tracker_count INT
, refer_url VARCHAR (255)
, tracker_text VARCHAR (255)
, start_date TIMESTAMP
, end_date TIMESTAMP
, status VARCHAR (100)
, impressions INT
, currency_id VARCHAR (36)
, budget DECIMAL(38,6)
, expected_cost DECIMAL(38,6)
, actual_cost DECIMAL(38,6)
, expected_revenue DECIMAL(38,6)
, campaign_type VARCHAR (100)
, objective MEDIUMTEXT
, content MEDIUMTEXT
, frequency VARCHAR (100)
, survey_id VARCHAR (36)
);
/* Id: 5010308 Name: campaigns_audit */
create table campaigns_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010310 Name: cases */
create table cases (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, case_number INT
, type VARCHAR (255)
, status VARCHAR (100)
, priority VARCHAR (100)
, resolution MEDIUMTEXT
, work_log MEDIUMTEXT
, account_id VARCHAR (36)
, state VARCHAR (100)
, contact_created_by_id VARCHAR (36)
);
/* Id: 5010312 Name: cases_audit */
create table cases_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010314 Name: cases_bugs */
create table cases_bugs (
id VARCHAR (36)
, case_id VARCHAR (36)
, bug_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010316 Name: cases_cstm */
create table cases_cstm (
id_c VARCHAR (36)
, jjwg_maps_lng_c DECIMAL(38,6)
, jjwg_maps_lat_c DECIMAL(38,6)
, jjwg_maps_geocode_status_c VARCHAR (255)
, jjwg_maps_address_c VARCHAR (255)
);
/* Id: 5010318 Name: config */
create table config (
category VARCHAR (32)
, name VARCHAR (32)
, value MEDIUMTEXT
);
/* Id: 5010320 Name: contacts */
create table contacts (
id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, salutation VARCHAR (255)
, first_name VARCHAR (100)
, last_name VARCHAR (100)
, title VARCHAR (100)
, photo VARCHAR (255)
, department VARCHAR (255)
, do_not_call VARCHAR (0)
, phone_home VARCHAR (100)
, phone_mobile VARCHAR (100)
, phone_work VARCHAR (100)
, phone_other VARCHAR (100)
, phone_fax VARCHAR (100)
, lawful_basis MEDIUMTEXT
, date_reviewed TIMESTAMP
, lawful_basis_source VARCHAR (100)
, primary_address_street VARCHAR (150)
, primary_address_city VARCHAR (100)
, primary_address_state VARCHAR (100)
, primary_address_postalcode VARCHAR (20)
, primary_address_country VARCHAR (255)
, alt_address_street VARCHAR (150)
, alt_address_city VARCHAR (100)
, alt_address_state VARCHAR (100)
, alt_address_postalcode VARCHAR (20)
, alt_address_country VARCHAR (255)
, assistant VARCHAR (75)
, assistant_phone VARCHAR (100)
, lead_source VARCHAR (255)
, reports_to_id VARCHAR (36)
, birthdate TIMESTAMP
, campaign_id VARCHAR (36)
, joomla_account_id VARCHAR (255)
);
/* Id: 5010322 Name: contacts_audit */
create table contacts_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010324 Name: contacts_bugs */
create table contacts_bugs (
id VARCHAR (36)
, contact_id VARCHAR (36)
, bug_id VARCHAR (36)
, contact_role VARCHAR (50)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010326 Name: contacts_cases */
create table contacts_cases (
id VARCHAR (36)
, contact_id VARCHAR (36)
, case_id VARCHAR (36)
, contact_role VARCHAR (50)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010328 Name: contacts_cstm */
create table contacts_cstm (
id_c VARCHAR (36)
, jjwg_maps_lng_c DECIMAL(38,6)
, jjwg_maps_lat_c DECIMAL(38,6)
, jjwg_maps_geocode_status_c VARCHAR (255)
, jjwg_maps_address_c VARCHAR (255)
);
/* Id: 5010330 Name: contacts_users */
create table contacts_users (
id VARCHAR (36)
, contact_id VARCHAR (36)
, user_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010332 Name: cron_remove_documents */
create table cron_remove_documents (
id VARCHAR (36)
, bean_id VARCHAR (36)
, module VARCHAR (25)
, date_modified TIMESTAMP
);
/* Id: 5010334 Name: currencies */
create table currencies (
id VARCHAR (36)
, name VARCHAR (36)
, symbol VARCHAR (36)
, iso4217 VARCHAR (3)
, conversion_rate DECIMAL(38,6)
, status VARCHAR (100)
, deleted VARCHAR (0)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, created_by VARCHAR (36)
);
/* Id: 5010336 Name: custom_fields */
create table custom_fields (
bean_id VARCHAR (36)
, set_num INT
, field0 VARCHAR (255)
, field1 VARCHAR (255)
, field2 VARCHAR (255)
, field3 VARCHAR (255)
, field4 VARCHAR (255)
, field5 VARCHAR (255)
, field6 VARCHAR (255)
, field7 VARCHAR (255)
, field8 VARCHAR (255)
, field9 VARCHAR (255)
, deleted VARCHAR (0)
);
/* Id: 5010338 Name: document_revisions */
create table document_revisions (
id VARCHAR (36)
, change_log VARCHAR (255)
, document_id VARCHAR (36)
, doc_id VARCHAR (100)
, doc_type VARCHAR (100)
, doc_url VARCHAR (255)
, date_entered TIMESTAMP
, created_by VARCHAR (36)
, filename VARCHAR (255)
, file_ext VARCHAR (100)
, file_mime_type VARCHAR (100)
, revision VARCHAR (100)
, deleted VARCHAR (0)
, date_modified TIMESTAMP
);
/* Id: 5010340 Name: documents */
create table documents (
id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, document_name VARCHAR (255)
, doc_id VARCHAR (100)
, doc_type VARCHAR (100)
, doc_url VARCHAR (255)
, active_date TIMESTAMP
, exp_date TIMESTAMP
, category_id VARCHAR (100)
, subcategory_id VARCHAR (100)
, status_id VARCHAR (100)
, document_revision_id VARCHAR (36)
, related_doc_id VARCHAR (36)
, related_doc_rev_id VARCHAR (36)
, is_template VARCHAR (0)
, template_type VARCHAR (100)
);
/* Id: 5010342 Name: documents_accounts */
create table documents_accounts (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, document_id VARCHAR (36)
, account_id VARCHAR (36)
);
/* Id: 5010344 Name: documents_bugs */
create table documents_bugs (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, document_id VARCHAR (36)
, bug_id VARCHAR (36)
);
/* Id: 5010346 Name: documents_cases */
create table documents_cases (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, document_id VARCHAR (36)
, case_id VARCHAR (36)
);
/* Id: 5010348 Name: documents_contacts */
create table documents_contacts (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, document_id VARCHAR (36)
, contact_id VARCHAR (36)
);
/* Id: 5010350 Name: documents_opportunities */
create table documents_opportunities (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, document_id VARCHAR (36)
, opportunity_id VARCHAR (36)
);
/* Id: 5010352 Name: eapm */
create table eapm (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, password VARCHAR (255)
, url VARCHAR (255)
, application VARCHAR (100)
, api_data MEDIUMTEXT
, consumer_key VARCHAR (255)
, consumer_secret VARCHAR (255)
, oauth_token VARCHAR (255)
, oauth_secret VARCHAR (255)
, validated VARCHAR (0)
);
/* Id: 5010354 Name: email_addr_bean_rel */
create table email_addr_bean_rel (
id VARCHAR (36)
, email_address_id VARCHAR (36)
, bean_id VARCHAR (36)
, bean_module VARCHAR (100)
, primary_address VARCHAR (0)
, reply_to_address VARCHAR (0)
, date_created TIMESTAMP
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010356 Name: email_addresses */
create table email_addresses (
id VARCHAR (36)
, email_address VARCHAR (255)
, email_address_caps VARCHAR (255)
, invalid_email VARCHAR (0)
, opt_out VARCHAR (0)
, confirm_opt_in VARCHAR (255)
, confirm_opt_in_date TIMESTAMP
, confirm_opt_in_sent_date TIMESTAMP
, confirm_opt_in_fail_date TIMESTAMP
, confirm_opt_in_token VARCHAR (255)
, date_created TIMESTAMP
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010358 Name: email_addresses_audit */
create table email_addresses_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010360 Name: email_cache */
create table email_cache (
ie_id VARCHAR (36)
, mbox VARCHAR (60)
, subject VARCHAR (255)
, fromaddr VARCHAR (100)
, toaddr VARCHAR (255)
, senddate TIMESTAMP
, message_id VARCHAR (255)
, mailsize INT
, imap_uid INT
, msgno INT
, recent INT
, flagged INT
, answered INT
, deleted INT
, seen INT
, draft INT
);
/* Id: 5010362 Name: email_marketing */
create table email_marketing (
id VARCHAR (36)
, deleted VARCHAR (0)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, name VARCHAR (255)
, from_name VARCHAR (100)
, from_addr VARCHAR (100)
, reply_to_name VARCHAR (100)
, reply_to_addr VARCHAR (100)
, inbound_email_id VARCHAR (36)
, date_start TIMESTAMP
, template_id VARCHAR (36)
, status VARCHAR (100)
, campaign_id VARCHAR (36)
, outbound_email_id VARCHAR (36)
, all_prospect_lists VARCHAR (0)
);
/* Id: 5010364 Name: email_marketing_prospect_lists */
create table email_marketing_prospect_lists (
id VARCHAR (36)
, prospect_list_id VARCHAR (36)
, email_marketing_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010366 Name: email_templates */
create table email_templates (
id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, published VARCHAR (3)
, name VARCHAR (255)
, description MEDIUMTEXT
, subject VARCHAR (255)
, body MEDIUMTEXT
, body_html MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, text_only VARCHAR (0)
, type VARCHAR (255)
);
/* Id: 5010368 Name: emailman */
create table emailman (
date_entered TIMESTAMP
, date_modified TIMESTAMP
, user_id VARCHAR (36)
, id INT
, campaign_id VARCHAR (36)
, marketing_id VARCHAR (36)
, list_id VARCHAR (36)
, send_date_time TIMESTAMP
, modified_user_id VARCHAR (36)
, in_queue VARCHAR (0)
, in_queue_date TIMESTAMP
, send_attempts INT
, deleted VARCHAR (0)
, related_id VARCHAR (36)
, related_type VARCHAR (100)
, related_confirm_opt_in VARCHAR (0)
);
/* Id: 5010370 Name: emails */
create table emails (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, orphaned VARCHAR (0)
, last_synced TIMESTAMP
, date_sent_received TIMESTAMP
, message_id VARCHAR (255)
, type VARCHAR (100)
, status VARCHAR (100)
, flagged VARCHAR (0)
, reply_to_status VARCHAR (0)
, intent VARCHAR (100)
, mailbox_id VARCHAR (36)
, parent_type VARCHAR (100)
, parent_id VARCHAR (36)
, uid VARCHAR (255)
, category_id VARCHAR (100)
);
/* Id: 5010372 Name: emails_beans */
create table emails_beans (
id VARCHAR (36)
, email_id VARCHAR (36)
, bean_id VARCHAR (36)
, bean_module VARCHAR (100)
, campaign_data MEDIUMTEXT
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010374 Name: emails_email_addr_rel */
create table emails_email_addr_rel (
id VARCHAR (36)
, email_id VARCHAR (36)
, address_type VARCHAR (4)
, email_address_id VARCHAR (36)
, deleted VARCHAR (0)
);
/* Id: 5010376 Name: emails_text */
create table emails_text (
email_id VARCHAR (36)
, from_addr VARCHAR (255)
, reply_to_addr VARCHAR (255)
, to_addrs MEDIUMTEXT
, cc_addrs MEDIUMTEXT
, bcc_addrs MEDIUMTEXT
, description MEDIUMTEXT
, description_html MEDIUMTEXT
, raw_source MEDIUMTEXT
, deleted VARCHAR (0)
);
/* Id: 5010378 Name: external_oauth_connections */
create table external_oauth_connections (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, type VARCHAR (255)
, client_id VARCHAR (32)
, client_secret VARCHAR (32)
, token_type VARCHAR (32)
, expires_in VARCHAR (32)
, access_token MEDIUMTEXT
, refresh_token MEDIUMTEXT
, external_oauth_provider_id VARCHAR (36)
);
/* Id: 5010380 Name: external_oauth_providers */
create table external_oauth_providers (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, type VARCHAR (255)
, connector VARCHAR (255)
, client_id VARCHAR (255)
, client_secret VARCHAR (255)
, scope MEDIUMTEXT
, url_authorize VARCHAR (255)
, authorize_url_options MEDIUMTEXT
, url_access_token VARCHAR (255)
, extra_provider_params MEDIUMTEXT
, get_token_request_grant VARCHAR (255)
, get_token_request_options MEDIUMTEXT
, refresh_token_request_grant VARCHAR (255)
, refresh_token_request_options MEDIUMTEXT
, access_token_mapping VARCHAR (255)
, expires_in_mapping VARCHAR (255)
, refresh_token_mapping VARCHAR (255)
, token_type_mapping VARCHAR (255)
);
/* Id: 5010382 Name: favorites */
create table favorites (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, parent_id VARCHAR (36)
, parent_type VARCHAR (255)
);
/* Id: 5010384 Name: fields_meta_data */
create table fields_meta_data (
id VARCHAR (255)
, name VARCHAR (255)
, vname VARCHAR (255)
, comments VARCHAR (255)
, help VARCHAR (255)
, custom_module VARCHAR (255)
, type VARCHAR (255)
, len INT
, required VARCHAR (0)
, default_value VARCHAR (255)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, audited VARCHAR (0)
, massupdate VARCHAR (0)
, duplicate_merge INT
, reportable VARCHAR (0)
, importable VARCHAR (255)
, ext1 VARCHAR (255)
, ext2 VARCHAR (255)
, ext3 VARCHAR (255)
, ext4 MEDIUMTEXT
);
/* Id: 5010386 Name: folders */
create table folders (
id VARCHAR (36)
, name VARCHAR (255)
, folder_type VARCHAR (25)
, parent_folder VARCHAR (36)
, has_child VARCHAR (0)
, is_group VARCHAR (0)
, is_dynamic VARCHAR (0)
, dynamic_query MEDIUMTEXT
, assign_to_id VARCHAR (36)
, created_by VARCHAR (36)
, modified_by VARCHAR (36)
, deleted VARCHAR (0)
);
/* Id: 5010388 Name: folders_rel */
create table folders_rel (
id VARCHAR (36)
, folder_id VARCHAR (36)
, polymorphic_module VARCHAR (25)
, polymorphic_id VARCHAR (36)
, deleted VARCHAR (0)
);
/* Id: 5010390 Name: folders_subscriptions */
create table folders_subscriptions (
id VARCHAR (36)
, folder_id VARCHAR (36)
, assigned_user_id VARCHAR (36)
);
/* Id: 5010392 Name: fp_event_locations */
create table fp_event_locations (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, address VARCHAR (255)
, address_city VARCHAR (100)
, address_country VARCHAR (100)
, address_postalcode VARCHAR (20)
, address_state VARCHAR (100)
, capacity VARCHAR (255)
);
/* Id: 5010394 Name: fp_event_locations_audit */
create table fp_event_locations_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010396 Name: fp_event_locations_fp_events_1_c */
create table fp_event_locations_fp_events_1_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, fp_event_locations_fp_events_1fp VARCHAR (36)
);
/* Id: 5010398 Name: fp_events */
create table fp_events (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, duration_hours INT
, duration_minutes INT
, date_start TIMESTAMP
, date_end TIMESTAMP
, budget DECIMAL(38,6)
, currency_id VARCHAR (36)
, invite_templates VARCHAR (100)
, accept_redirect VARCHAR (255)
, decline_redirect VARCHAR (255)
, activity_status_type VARCHAR (255)
);
/* Id: 5010400 Name: fp_events_audit */
create table fp_events_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010402 Name: fp_events_contacts_c */
create table fp_events_contacts_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, fp_events_contactsfp_events_ida VARCHAR (36)
, fp_events_contactscontacts_idb VARCHAR (36)
, invite_status VARCHAR (25)
, accept_status VARCHAR (25)
, email_responded INT
);
/* Id: 5010404 Name: fp_events_fp_event_delegates_1_c */
create table fp_events_fp_event_delegates_1_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, fp_events_fp_event_delegates_1fp VARCHAR (36)
);
/* Id: 5010406 Name: fp_events_fp_event_locations_1_c */
create table fp_events_fp_event_locations_1_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, fp_events_fp_event_locations_1fp VARCHAR (36)
);
/* Id: 5010408 Name: fp_events_leads_1_c */
create table fp_events_leads_1_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, fp_events_leads_1fp_events_ida VARCHAR (36)
, fp_events_leads_1leads_idb VARCHAR (36)
, invite_status VARCHAR (25)
, accept_status VARCHAR (25)
, email_responded INT
);
/* Id: 5010410 Name: fp_events_prospects_1_c */
create table fp_events_prospects_1_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, fp_events_prospects_1fp_events_i VARCHAR (36)
, fp_events_prospects_1prospects_i VARCHAR (36)
, invite_status VARCHAR (25)
, accept_status VARCHAR (25)
, email_responded INT
);
/* Id: 5010412 Name: import_maps */
create table import_maps (
id VARCHAR (36)
, name VARCHAR (254)
, source VARCHAR (36)
, enclosure VARCHAR (1)
, delimiter VARCHAR (1)
, module VARCHAR (36)
, content MEDIUMTEXT
, default_values MEDIUMTEXT
, has_header VARCHAR (0)
, deleted VARCHAR (0)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, assigned_user_id VARCHAR (36)
, is_published VARCHAR (3)
);
/* Id: 5010414 Name: inbound_email */
create table inbound_email (
id VARCHAR (36)
, deleted VARCHAR (0)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, name VARCHAR (255)
, status VARCHAR (100)
, email_body_filtering VARCHAR (255)
, server_url VARCHAR (100)
, connection_string VARCHAR (255)
, email_user VARCHAR (100)
, email_password VARCHAR (100)
, port INT
, service VARCHAR (50)
, mailbox MEDIUMTEXT
, sentFolder VARCHAR (255)
, trashFolder VARCHAR (255)
, delete_seen VARCHAR (0)
, move_messages_to_trash_after_imp VARCHAR (0)
, mailbox_type VARCHAR (10)
, template_id VARCHAR (36)
, stored_options MEDIUMTEXT
, group_id VARCHAR (36)
, is_personal VARCHAR (0)
, groupfolder_id VARCHAR (36)
, type VARCHAR (255)
, auth_type VARCHAR (255)
, protocol VARCHAR (255)
, is_ssl VARCHAR (0)
, distribution_user_id VARCHAR (36)
, outbound_email_id VARCHAR (36)
, create_case_template_id VARCHAR (36)
, external_oauth_connection_id VARCHAR (36)
);
/* Id: 5010416 Name: inbound_email_autoreply */
create table inbound_email_autoreply (
id VARCHAR (36)
, deleted VARCHAR (0)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, autoreplied_to VARCHAR (100)
, ie_id VARCHAR (36)
);
/* Id: 5010418 Name: inbound_email_cache_ts */
create table inbound_email_cache_ts (
id VARCHAR (255)
, ie_timestamp INT
);
/* Id: 5010420 Name: jjwg_address_cache */
create table jjwg_address_cache (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, lat DECIMAL(38,6)
, lng DECIMAL(38,6)
);
/* Id: 5010422 Name: jjwg_address_cache_audit */
create table jjwg_address_cache_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010424 Name: jjwg_areas */
create table jjwg_areas (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, city VARCHAR (255)
, state VARCHAR (255)
, country VARCHAR (255)
, coordinates MEDIUMTEXT
);
/* Id: 5010426 Name: jjwg_areas_audit */
create table jjwg_areas_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010428 Name: jjwg_maps */
create table jjwg_maps (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, distance DECIMAL(38,6)
, unit_type VARCHAR (100)
, module_type VARCHAR (100)
, parent_type VARCHAR (255)
, parent_id VARCHAR (36)
);
/* Id: 5010430 Name: jjwg_maps_audit */
create table jjwg_maps_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010432 Name: jjwg_maps_jjwg_areas_c */
create table jjwg_maps_jjwg_areas_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, jjwg_maps_5304wg_maps_ida VARCHAR (36)
, jjwg_maps_41f2g_areas_idb VARCHAR (36)
);
/* Id: 5010434 Name: jjwg_maps_jjwg_markers_c */
create table jjwg_maps_jjwg_markers_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, jjwg_maps_b229wg_maps_ida VARCHAR (36)
, jjwg_maps_2e31markers_idb VARCHAR (36)
);
/* Id: 5010436 Name: jjwg_markers */
create table jjwg_markers (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, city VARCHAR (255)
, state VARCHAR (255)
, country VARCHAR (255)
, jjwg_maps_lat DECIMAL(38,6)
, jjwg_maps_lng DECIMAL(38,6)
, marker_image VARCHAR (100)
);
/* Id: 5010438 Name: jjwg_markers_audit */
create table jjwg_markers_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010440 Name: job_queue */
create table job_queue (
assigned_user_id VARCHAR (36)
, id VARCHAR (36)
, name VARCHAR (255)
, deleted VARCHAR (0)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, scheduler_id VARCHAR (36)
, execute_time TIMESTAMP
, status VARCHAR (20)
, resolution VARCHAR (20)
, message MEDIUMTEXT
, target VARCHAR (255)
, data MEDIUMTEXT
, requeue VARCHAR (0)
, retry_count INT
, failure_count INT
, job_delay INT
, client VARCHAR (255)
, percent_complete INT
);
/* Id: 5010442 Name: leads */
create table leads (
id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, salutation VARCHAR (255)
, first_name VARCHAR (100)
, last_name VARCHAR (100)
, title VARCHAR (100)
, photo VARCHAR (255)
, department VARCHAR (100)
, do_not_call VARCHAR (0)
, phone_home VARCHAR (100)
, phone_mobile VARCHAR (100)
, phone_work VARCHAR (100)
, phone_other VARCHAR (100)
, phone_fax VARCHAR (100)
, lawful_basis MEDIUMTEXT
, date_reviewed TIMESTAMP
, lawful_basis_source VARCHAR (100)
, primary_address_street VARCHAR (150)
, primary_address_city VARCHAR (100)
, primary_address_state VARCHAR (100)
, primary_address_postalcode VARCHAR (20)
, primary_address_country VARCHAR (255)
, alt_address_street VARCHAR (150)
, alt_address_city VARCHAR (100)
, alt_address_state VARCHAR (100)
, alt_address_postalcode VARCHAR (20)
, alt_address_country VARCHAR (255)
, assistant VARCHAR (75)
, assistant_phone VARCHAR (100)
, converted VARCHAR (0)
, refered_by VARCHAR (100)
, lead_source VARCHAR (100)
, lead_source_description MEDIUMTEXT
, status VARCHAR (100)
);
/* Id: 5010444 Name: leads_audit */
create table leads_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010446 Name: leads_cstm */
create table leads_cstm (
id_c VARCHAR (36)
, jjwg_maps_lng_c DECIMAL(38,6)
, jjwg_maps_lat_c DECIMAL(38,6)
, jjwg_maps_geocode_status_c VARCHAR (255)
, jjwg_maps_address_c VARCHAR (255)
);
/* Id: 5010448 Name: linked_documents */
create table linked_documents (
id VARCHAR (36)
, parent_id VARCHAR (36)
, parent_type VARCHAR (25)
, document_id VARCHAR (36)
, document_revision_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010450 Name: meetings */
create table meetings (
id VARCHAR (36)
, name VARCHAR (50)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, location VARCHAR (50)
, password VARCHAR (50)
, join_url VARCHAR (200)
, host_url VARCHAR (400)
, displayed_url VARCHAR (400)
, creator VARCHAR (50)
, external_id VARCHAR (50)
, duration_hours INT
, duration_minutes INT
, date_start TIMESTAMP
, date_end TIMESTAMP
, parent_type VARCHAR (100)
, status VARCHAR (100)
, type VARCHAR (255)
, parent_id VARCHAR (36)
, reminder_time INT
, email_reminder_time INT
, email_reminder_sent VARCHAR (0)
, outlook_id VARCHAR (255)
, sequence INT
, repeat_type VARCHAR (36)
, repeat_interval INT
, repeat_dow VARCHAR (7)
, repeat_until TIMESTAMP
, repeat_count INT
, repeat_parent_id VARCHAR (36)
, recurring_source VARCHAR (36)
, gsync_id VARCHAR (1024)
, gsync_lastsync INT
);
/* Id: 5010452 Name: meetings_contacts */
create table meetings_contacts (
id VARCHAR (36)
, meeting_id VARCHAR (36)
, contact_id VARCHAR (36)
, required VARCHAR (1)
, accept_status VARCHAR (25)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010454 Name: meetings_cstm */
create table meetings_cstm (
id_c VARCHAR (36)
, jjwg_maps_lng_c DECIMAL(38,6)
, jjwg_maps_lat_c DECIMAL(38,6)
, jjwg_maps_geocode_status_c VARCHAR (255)
, jjwg_maps_address_c VARCHAR (255)
);
/* Id: 5010456 Name: meetings_leads */
create table meetings_leads (
id VARCHAR (36)
, meeting_id VARCHAR (36)
, lead_id VARCHAR (36)
, required VARCHAR (1)
, accept_status VARCHAR (25)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010458 Name: meetings_users */
create table meetings_users (
id VARCHAR (36)
, meeting_id VARCHAR (36)
, user_id VARCHAR (36)
, required VARCHAR (1)
, accept_status VARCHAR (25)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010460 Name: notes */
create table notes (
assigned_user_id VARCHAR (36)
, id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, name VARCHAR (255)
, file_mime_type VARCHAR (100)
, filename VARCHAR (255)
, parent_type VARCHAR (255)
, parent_id VARCHAR (36)
, contact_id VARCHAR (36)
, portal_flag VARCHAR (0)
, embed_flag VARCHAR (0)
, description MEDIUMTEXT
, deleted VARCHAR (0)
);
/* Id: 5010462 Name: oauth2clients */
create table oauth2clients (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, secret VARCHAR (4000)
, redirect_url VARCHAR (255)
, is_confidential VARCHAR (0)
, allowed_grant_type VARCHAR (255)
, duration_value INT
, duration_amount INT
, duration_unit VARCHAR (255)
, assigned_user_id VARCHAR (36)
);
/* Id: 5010464 Name: oauth2tokens */
create table oauth2tokens (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, token_is_revoked VARCHAR (0)
, token_type VARCHAR (255)
, access_token_expires TIMESTAMP
, access_token VARCHAR (4000)
, refresh_token VARCHAR (4000)
, refresh_token_expires TIMESTAMP
, grant_type VARCHAR (255)
, state VARCHAR (1024)
, client VARCHAR (36)
, assigned_user_id VARCHAR (36)
);
/* Id: 5010466 Name: oauth_consumer */
create table oauth_consumer (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, c_key VARCHAR (255)
, c_secret VARCHAR (255)
);
/* Id: 5010468 Name: oauth_nonce */
create table oauth_nonce (
conskey VARCHAR (32)
, nonce VARCHAR (32)
, nonce_ts INT
);
/* Id: 5010470 Name: oauth_tokens */
create table oauth_tokens (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, token_is_revoked VARCHAR (0)
, token_type VARCHAR (255)
, access_token_expires TIMESTAMP
, access_token VARCHAR (4000)
, refresh_token VARCHAR (4000)
, refresh_token_expires TIMESTAMP
, grant_type VARCHAR (255)
, state VARCHAR (1024)
, client VARCHAR (36)
, assigned_user_id VARCHAR (36)
, id VARCHAR (36)
, secret VARCHAR (32)
, tstate VARCHAR (1)
, consumer VARCHAR (36)
, token_ts INT
, verify VARCHAR (32)
, deleted VARCHAR (0)
, callback_url VARCHAR (255)
, assigned_user_id VARCHAR (36)
);
/* Id: 5010472 Name: opportunities */
create table opportunities (
id VARCHAR (36)
, name VARCHAR (50)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, opportunity_type VARCHAR (255)
, campaign_id VARCHAR (36)
, lead_source VARCHAR (50)
, amount DECIMAL(38,6)
, amount_usdollar DECIMAL(38,6)
, currency_id VARCHAR (36)
, date_closed TIMESTAMP
, next_step VARCHAR (100)
, sales_stage VARCHAR (255)
, probability DECIMAL(38,6)
);
/* Id: 5010474 Name: opportunities_audit */
create table opportunities_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010476 Name: opportunities_contacts */
create table opportunities_contacts (
id VARCHAR (36)
, contact_id VARCHAR (36)
, opportunity_id VARCHAR (36)
, contact_role VARCHAR (50)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010478 Name: opportunities_cstm */
create table opportunities_cstm (
id_c VARCHAR (36)
, jjwg_maps_lng_c DECIMAL(38,6)
, jjwg_maps_lat_c DECIMAL(38,6)
, jjwg_maps_geocode_status_c VARCHAR (255)
, jjwg_maps_address_c VARCHAR (255)
);
/* Id: 5010480 Name: outbound_email */
create table outbound_email (
id VARCHAR (36)
, name VARCHAR (255)
, type VARCHAR (15)
, user_id VARCHAR (36)
, smtp_from_name VARCHAR (255)
, smtp_from_addr VARCHAR (255)
, reply_to_name VARCHAR (255)
, reply_to_addr VARCHAR (255)
, signature MEDIUMTEXT
, mail_sendtype VARCHAR (8)
, mail_smtptype VARCHAR (20)
, mail_smtpserver VARCHAR (100)
, mail_smtpport VARCHAR (5)
, mail_smtpuser VARCHAR (100)
, mail_smtppass VARCHAR (100)
, mail_smtpauth_req VARCHAR (0)
, mail_smtpssl VARCHAR (1)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
);
/* Id: 5010482 Name: outbound_email_audit */
create table outbound_email_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010484 Name: project */
create table project (
id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, assigned_user_id VARCHAR (36)
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, name VARCHAR (50)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, estimated_start_date TIMESTAMP
, estimated_end_date TIMESTAMP
, status VARCHAR (255)
, priority VARCHAR (255)
, override_business_hours VARCHAR (0)
);
/* Id: 5010486 Name: project_contacts_1_c */
create table project_contacts_1_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, project_contacts_1project_ida VARCHAR (36)
, project_contacts_1contacts_idb VARCHAR (36)
);
/* Id: 5010488 Name: project_cstm */
create table project_cstm (
id_c VARCHAR (36)
, jjwg_maps_lng_c DECIMAL(38,6)
, jjwg_maps_lat_c DECIMAL(38,6)
, jjwg_maps_geocode_status_c VARCHAR (255)
, jjwg_maps_address_c VARCHAR (255)
);
/* Id: 5010490 Name: project_task */
create table project_task (
id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, project_id VARCHAR (36)
, project_task_id INT
, name VARCHAR (50)
, status VARCHAR (255)
, relationship_type VARCHAR (255)
, description MEDIUMTEXT
, predecessors MEDIUMTEXT
, date_start TIMESTAMP
, time_start INT
, time_finish INT
, date_finish TIMESTAMP
, duration INT
, duration_unit MEDIUMTEXT
, actual_duration INT
, percent_complete INT
, date_due TIMESTAMP
, time_due TIMESTAMP
, parent_task_id INT
, assigned_user_id VARCHAR (36)
, modified_user_id VARCHAR (36)
, priority VARCHAR (255)
, created_by VARCHAR (36)
, milestone_flag VARCHAR (0)
, order_number INT
, task_number INT
, estimated_effort INT
, actual_effort INT
, deleted VARCHAR (0)
, utilization INT
);
/* Id: 5010492 Name: project_task_audit */
create table project_task_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010494 Name: project_users_1_c */
create table project_users_1_c (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, project_users_1project_ida VARCHAR (36)
, project_users_1users_idb VARCHAR (36)
);
/* Id: 5010496 Name: projects_accounts */
create table projects_accounts (
id VARCHAR (36)
, account_id VARCHAR (36)
, project_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010498 Name: projects_bugs */
create table projects_bugs (
id VARCHAR (36)
, bug_id VARCHAR (36)
, project_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010500 Name: projects_cases */
create table projects_cases (
id VARCHAR (36)
, case_id VARCHAR (36)
, project_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010502 Name: projects_contacts */
create table projects_contacts (
id VARCHAR (36)
, contact_id VARCHAR (36)
, project_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010504 Name: projects_opportunities */
create table projects_opportunities (
id VARCHAR (36)
, opportunity_id VARCHAR (36)
, project_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010506 Name: projects_products */
create table projects_products (
id VARCHAR (36)
, product_id VARCHAR (36)
, project_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010508 Name: prospect_list_campaigns */
create table prospect_list_campaigns (
id VARCHAR (36)
, prospect_list_id VARCHAR (36)
, campaign_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010510 Name: prospect_lists */
create table prospect_lists (
assigned_user_id VARCHAR (36)
, id VARCHAR (36)
, name VARCHAR (255)
, list_type VARCHAR (100)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, deleted VARCHAR (0)
, description MEDIUMTEXT
, domain_name VARCHAR (255)
);
/* Id: 5010512 Name: prospect_lists_prospects */
create table prospect_lists_prospects (
id VARCHAR (36)
, prospect_list_id VARCHAR (36)
, related_id VARCHAR (36)
, related_type VARCHAR (25)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010514 Name: prospects */
create table prospects (
id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, salutation VARCHAR (255)
, first_name VARCHAR (100)
, last_name VARCHAR (100)
, title VARCHAR (100)
, photo VARCHAR (255)
, department VARCHAR (255)
, do_not_call VARCHAR (0)
, phone_home VARCHAR (100)
, phone_mobile VARCHAR (100)
, phone_work VARCHAR (100)
, phone_other VARCHAR (100)
, phone_fax VARCHAR (100)
, lawful_basis MEDIUMTEXT
, date_reviewed TIMESTAMP
, lawful_basis_source VARCHAR (100)
, primary_address_street VARCHAR (150)
, primary_address_city VARCHAR (100)
, primary_address_state VARCHAR (100)
, primary_address_postalcode VARCHAR (20)
, primary_address_country VARCHAR (255)
, alt_address_street VARCHAR (150)
, alt_address_city VARCHAR (100)
, alt_address_state VARCHAR (100)
, alt_address_postalcode VARCHAR (20)
, alt_address_country VARCHAR (255)
, assistant VARCHAR (75)
, assistant_phone VARCHAR (100)
, tracker_key INT
, birthdate TIMESTAMP
, lead_id VARCHAR (36)
, account_name VARCHAR (150)
, campaign_id VARCHAR (36)
);
/* Id: 5010516 Name: prospects_cstm */
create table prospects_cstm (
id_c VARCHAR (36)
, jjwg_maps_lng_c DECIMAL(38,6)
, jjwg_maps_lat_c DECIMAL(38,6)
, jjwg_maps_geocode_status_c VARCHAR (255)
, jjwg_maps_address_c VARCHAR (255)
);
/* Id: 5010518 Name: relationships */
create table relationships (
id VARCHAR (36)
, relationship_name VARCHAR (150)
, lhs_module VARCHAR (100)
, lhs_table VARCHAR (64)
, lhs_key VARCHAR (64)
, rhs_module VARCHAR (100)
, rhs_table VARCHAR (64)
, rhs_key VARCHAR (64)
, join_table VARCHAR (64)
, join_key_lhs VARCHAR (64)
, join_key_rhs VARCHAR (64)
, relationship_type VARCHAR (64)
, relationship_role_column VARCHAR (64)
, relationship_role_column_value VARCHAR (50)
, reverse VARCHAR (0)
, deleted VARCHAR (0)
);
/* Id: 5010520 Name: releases */
create table releases (
id VARCHAR (36)
, deleted VARCHAR (0)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, name VARCHAR (50)
, list_order INT
, status VARCHAR (100)
);
/* Id: 5010522 Name: reminders */
create table reminders (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, popup VARCHAR (0)
, email VARCHAR (0)
, email_sent VARCHAR (0)
, timer_popup VARCHAR (32)
, timer_email VARCHAR (32)
, related_event_module VARCHAR (32)
, related_event_module_id VARCHAR (36)
, date_willexecute INT
, popup_viewed VARCHAR (0)
);
/* Id: 5010524 Name: reminders_invitees */
create table reminders_invitees (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, reminder_id VARCHAR (36)
, related_invitee_module VARCHAR (32)
, related_invitee_module_id VARCHAR (36)
);
/* Id: 5010526 Name: roles */
create table roles (
id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, name VARCHAR (150)
, description MEDIUMTEXT
, modules MEDIUMTEXT
, deleted VARCHAR (0)
);
/* Id: 5010528 Name: roles_modules */
create table roles_modules (
id VARCHAR (36)
, role_id VARCHAR (36)
, module_id VARCHAR (36)
, allow VARCHAR (0)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010530 Name: roles_users */
create table roles_users (
id VARCHAR (36)
, role_id VARCHAR (36)
, user_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010532 Name: saved_search */
create table saved_search (
id VARCHAR (36)
, name VARCHAR (150)
, search_module VARCHAR (150)
, quick_filter VARCHAR (0)
, deleted VARCHAR (0)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, assigned_user_id VARCHAR (36)
, contents MEDIUMTEXT
, description MEDIUMTEXT
);
/* Id: 5010534 Name: schedulers */
create table schedulers (
id VARCHAR (36)
, deleted VARCHAR (0)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, created_by VARCHAR (36)
, modified_user_id VARCHAR (36)
, name VARCHAR (255)
, job VARCHAR (255)
, date_time_start TIMESTAMP
, date_time_end TIMESTAMP
, job_interval VARCHAR (100)
, time_from TIMESTAMP
, time_to TIMESTAMP
, last_run TIMESTAMP
, status VARCHAR (100)
, catch_up VARCHAR (0)
);
/* Id: 5010536 Name: securitygroups */
create table securitygroups (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, noninheritable VARCHAR (0)
);
/* Id: 5010538 Name: securitygroups_acl_roles */
create table securitygroups_acl_roles (
id VARCHAR (36)
, securitygroup_id VARCHAR (36)
, role_id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010540 Name: securitygroups_audit */
create table securitygroups_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010542 Name: securitygroups_default */
create table securitygroups_default (
id VARCHAR (36)
, securitygroup_id VARCHAR (36)
, module VARCHAR (50)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010544 Name: securitygroups_records */
create table securitygroups_records (
id VARCHAR (36)
, securitygroup_id VARCHAR (36)
, record_id VARCHAR (36)
, module VARCHAR (100)
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, deleted VARCHAR (0)
);
/* Id: 5010546 Name: securitygroups_users */
create table securitygroups_users (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, securitygroup_id VARCHAR (36)
, user_id VARCHAR (36)
, primary_group VARCHAR (0)
, noninheritable VARCHAR (0)
);
/* Id: 5010548 Name: sugarfeed */
create table sugarfeed (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, related_module VARCHAR (100)
, related_id VARCHAR (36)
, link_url VARCHAR (255)
, link_type VARCHAR (30)
);
/* Id: 5010550 Name: surveyquestionoptions */
create table surveyquestionoptions (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, sort_order INT
, survey_question_id VARCHAR (36)
);
/* Id: 5010552 Name: surveyquestionoptions_audit */
create table surveyquestionoptions_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010554 Name: surveyquestionoptions_surveyques */
create table surveyquestionoptions_surveyques (
id VARCHAR (36)
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, surveyq72c7options_ida VARCHAR (36)
, surveyq10d4sponses_idb VARCHAR (36)
);
/* Id: 5010556 Name: surveyquestionresponses */
create table surveyquestionresponses (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, answer MEDIUMTEXT
, answer_bool VARCHAR (0)
, answer_datetime TIMESTAMP
, surveyquestion_id VARCHAR (36)
, surveyresponse_id VARCHAR (36)
);
/* Id: 5010558 Name: surveyquestionresponses_audit */
create table surveyquestionresponses_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010560 Name: surveyquestions */
create table surveyquestions (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, sort_order INT
, type VARCHAR (100)
, happiness_question VARCHAR (0)
, survey_id VARCHAR (36)
);
/* Id: 5010562 Name: surveyquestions_audit */
create table surveyquestions_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010564 Name: surveyresponses */
create table surveyresponses (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, happiness INT
, email_response_sent VARCHAR (0)
, account_id VARCHAR (36)
, campaign_id VARCHAR (36)
, contact_id VARCHAR (36)
, survey_id VARCHAR (36)
);
/* Id: 5010566 Name: surveyresponses_audit */
create table surveyresponses_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010568 Name: surveys */
create table surveys (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, status VARCHAR (100)
, submit_text VARCHAR (255)
, satisfied_text VARCHAR (255)
, neither_text VARCHAR (255)
, dissatisfied_text VARCHAR (255)
);
/* Id: 5010570 Name: surveys_audit */
create table surveys_audit (
id VARCHAR (36)
, parent_id VARCHAR (36)
, date_created TIMESTAMP
, created_by VARCHAR (36)
, field_name VARCHAR (100)
, data_type VARCHAR (100)
, before_value_string VARCHAR (255)
, after_value_string VARCHAR (255)
, before_value_text MEDIUMTEXT
, after_value_text MEDIUMTEXT
);
/* Id: 5010572 Name: tasks */
create table tasks (
id VARCHAR (36)
, name VARCHAR (50)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, assigned_user_id VARCHAR (36)
, status VARCHAR (100)
, date_due_flag VARCHAR (0)
, date_due TIMESTAMP
, date_start_flag VARCHAR (0)
, date_start TIMESTAMP
, parent_type VARCHAR (255)
, parent_id VARCHAR (36)
, contact_id VARCHAR (36)
, priority VARCHAR (100)
);
/* Id: 5010574 Name: templatesectionline */
create table templatesectionline (
id VARCHAR (36)
, name VARCHAR (255)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, description MEDIUMTEXT
, deleted VARCHAR (0)
, thumbnail VARCHAR (255)
, grp VARCHAR (255)
, ord INT
);
/* Id: 5010576 Name: tracker */
create table tracker (
id INT
, monitor_id VARCHAR (36)
, user_id VARCHAR (36)
, module_name VARCHAR (255)
, item_id VARCHAR (36)
, item_summary VARCHAR (255)
, date_modified TIMESTAMP
, action VARCHAR (255)
, session_id VARCHAR (36)
, visible VARCHAR (0)
, deleted VARCHAR (0)
);
/* Id: 5010578 Name: upgrade_history */
create table upgrade_history (
id VARCHAR (36)
, filename VARCHAR (255)
, md5sum VARCHAR (32)
, type VARCHAR (30)
, status VARCHAR (50)
, version VARCHAR (64)
, name VARCHAR (255)
, description MEDIUMTEXT
, id_name VARCHAR (255)
, manifest MEDIUMTEXT
, date_entered TIMESTAMP
, enabled VARCHAR (0)
);
/* Id: 5010580 Name: user_preferences */
create table user_preferences (
id VARCHAR (36)
, category VARCHAR (50)
, deleted VARCHAR (0)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, assigned_user_id VARCHAR (36)
, contents MEDIUMTEXT
);
/* Id: 5010582 Name: users */
create table users (
id VARCHAR (36)
, user_name VARCHAR (60)
, user_hash VARCHAR (255)
, system_generated_password VARCHAR (0)
, pwd_last_changed TIMESTAMP
, authenticate_id VARCHAR (100)
, sugar_login VARCHAR (0)
, first_name VARCHAR (255)
, last_name VARCHAR (255)
, is_admin VARCHAR (0)
, external_auth_only VARCHAR (0)
, receive_notifications VARCHAR (0)
, description MEDIUMTEXT
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, modified_user_id VARCHAR (36)
, created_by VARCHAR (36)
, title VARCHAR (50)
, photo VARCHAR (255)
, department VARCHAR (50)
, phone_home VARCHAR (50)
, phone_mobile VARCHAR (50)
, phone_work VARCHAR (50)
, phone_other VARCHAR (50)
, phone_fax VARCHAR (50)
, status VARCHAR (100)
, address_street VARCHAR (150)
, address_city VARCHAR (100)
, address_state VARCHAR (100)
, address_country VARCHAR (100)
, address_postalcode VARCHAR (20)
, deleted VARCHAR (0)
, portal_only VARCHAR (0)
, show_on_employees VARCHAR (0)
, employee_status VARCHAR (100)
, messenger_id VARCHAR (100)
, messenger_type VARCHAR (100)
, reports_to_id VARCHAR (36)
, is_group VARCHAR (0)
, factor_auth VARCHAR (0)
);
/* Id: 5010584 Name: users_feeds */
create table users_feeds (
user_id VARCHAR (36)
, feed_id VARCHAR (36)
, rank INT
, date_modified TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010586 Name: users_last_import */
create table users_last_import (
id VARCHAR (36)
, assigned_user_id VARCHAR (36)
, import_module VARCHAR (36)
, bean_type VARCHAR (36)
, bean_id VARCHAR (36)
, deleted VARCHAR (0)
);
/* Id: 5010588 Name: users_password_link */
create table users_password_link (
id VARCHAR (36)
, keyhash VARCHAR (255)
, user_id VARCHAR (36)
, username VARCHAR (36)
, date_generated TIMESTAMP
, deleted VARCHAR (0)
);
/* Id: 5010590 Name: users_signatures */
create table users_signatures (
id VARCHAR (36)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, deleted VARCHAR (0)
, user_id VARCHAR (36)
, name VARCHAR (255)
, signature MEDIUMTEXT
, signature_html MEDIUMTEXT
);
/* Id: 5010592 Name: vcals */
create table vcals (
id VARCHAR (36)
, deleted VARCHAR (0)
, date_entered TIMESTAMP
, date_modified TIMESTAMP
, user_id VARCHAR (36)
, type VARCHAR (100)
, source VARCHAR (100)
, content MEDIUMTEXT
);