Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.7.0
- -- https://www.phpmyadmin.net/
- --
- -- Host: 127.0.0.1
- -- Generation Time: Sep 06, 2017 at 01:25 PM
- -- Server version: 10.1.10-MariaDB
- -- PHP Version: 7.0.21
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- START TRANSACTION;
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8mb4 */;
- --
- -- Database: `crm_db2`
- --
- DELIMITER $$
- --
- -- Procedures
- --
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_campaign_insert` (IN `name` VARCHAR(100), IN `description` TEXT, IN `start_date` DATE, IN `end_date` DATE, IN `status` ENUM('0','1'), IN `number` INT, IN `percentage_response` DOUBLE, IN `budget_cost_currency` ENUM('1','2'), IN `budget_cost` DOUBLE, IN `actual_cost_currency` ENUM('1','2'), IN `actual_cost` DOUBLE, IN `expected_revenue_currency` ENUM('1','2'), IN `expected_revenue` DOUBLE, IN `u_created` VARCHAR(100), IN `date_created` DATETIME, OUT `c_id` INT, OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT product_id AS p_id FROM crm_products where product_id in(', product_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- INSERT INTO `crm_campaigns`(`campaign_name`, `campaign_description`, `campaign_start_date`, `campaign_end_date`, `campaign_status`, `campaign_number`, `campaign_percentage_response`, `campaign_budget_cost_currency`, `campaign_budget_cost`, `campaign_actual_cost_currency`, `campaign_actual_cost`, `campaign_expected_revenue_currency`, `campaign_expected_revenue`, `user_created`, `user_created_date`) VALUES (name, description, start_date, end_date, status, number, percentage_response, budget_cost_currency, budget_cost, actual_cost_currency, actual_cost, expected_revenue_currency, expected_revenue, u_created, date_created);
- SET c_id = LAST_INSERT_ID();
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_company_insert` (IN `code` VARCHAR(50), IN `name` VARCHAR(200), IN `parent` INT, IN `office_phone` VARCHAR(30), IN `industry` INT, IN `email` VARCHAR(100), IN `fax` VARCHAR(30), IN `employee` INT, IN `revenue` DOUBLE, IN `website` VARCHAR(100), IN `address1` VARCHAR(255), IN `address2` VARCHAR(255), IN `city` VARCHAR(100), IN `state` VARCHAR(100), IN `zip_code` VARCHAR(10), IN `country` VARCHAR(50), IN `billing_address1` VARCHAR(255), IN `billing_address2` VARCHAR(255), IN `billing_city` VARCHAR(100), IN `billing_state` VARCHAR(100), IN `billing_zip_code` VARCHAR(10), IN `billing_country` VARCHAR(50), IN `right_permission` ENUM('1','2','3'), IN `u_created` VARCHAR(100), IN `date_created` DATETIME, IN `groups` INT, IN `customer` ENUM('0','1'), IN `user_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id AS u_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- INSERT INTO `crm_companies`(`customer_code`, `company_name`, `company_parent`, `company_office_phone`, `company_industry`, `company_email`, `company_fax`, `company_employee`, `company_revenue`, `company_website`, `company_address1`, `company_address2`, `company_city`, `company_state`, `company_zip_code`, `company_country`, `company_billing_address1`, `company_billing_address2`, `company_billing_city`, `company_billing_state`, `company_billing_zip_code`, `company_billing_country`, `company_right_permission`, `user_created`, `user_created_date`, `company_groups`, `company_customer`) VALUES
- (code, name, parent, office_phone, industry, email, fax, employee, revenue, website, address1, address2, city, state, zip_code, country, billing_address1, billing_address2, billing_city, billing_state, billing_zip_code, billing_country, right_permission, u_created, date_created, groups, customer);
- SET @l_id = LAST_INSERT_ID();
- INSERT INTO `crm_users_companies`(`company_id`,`user_id`)
- SELECT @l_id,u_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_company_meeting_delete` (IN `meet_id` INT, OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- START TRANSACTION;
- DELETE FROM company_meeting_users WHERE company_meeting_id = meet_id;
- DELETE FROM company_meeting WHERE company_meeting_id = meet_id;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_company_meeting_insert` (IN `l_id` INT, IN `name` VARCHAR(100), IN `location` VARCHAR(255), IN `start_date` DATETIME, IN `end_date` DATETIME, IN `description` TEXT, IN `date` DATETIME, IN `user` VARCHAR(100), IN `user_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- INSERT INTO `company_meeting`(`company_id`, `company_meeting_name`, `company_meeting_location`, `company_meeting_start_date`, `company_meeting_end_date`, `company_meeting_description`, `company_meeting_date`, `company_meeting_user`) VALUES (l_id,name,location,start_date,end_date,description,date,user);
- SET @meet_id = LAST_INSERT_ID();
- INSERT INTO `company_meeting_users`(`company_meeting_id`,`company_user_id`)
- SELECT @meet_id,user_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- set sukses=1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_company_meeting_update` (IN `meet_id` INT, IN `l_id` INT, IN `name` VARCHAR(100), IN `location` VARCHAR(255), IN `start_date` DATETIME, IN `end_date` DATETIME, IN `description` TEXT, IN `date` DATETIME, IN `user` VARCHAR(100), IN `user_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- UPDATE `company_meeting` SET
- `company_meeting_name`=name,
- `company_meeting_location`=location,
- `company_meeting_start_date`=start_date,
- `company_meeting_end_date`=end_date,
- `company_meeting_description`=description,
- `company_meeting_date`=date,
- `company_meeting_user`=user,
- `company_id`=l_id
- WHERE `company_meeting_id`=meet_id;
- delete from company_meeting_users where company_meeting_id=meet_id;
- REPLACE INTO `company_meeting_users`(`company_meeting_id`,`company_user_id`)
- SELECT meet_id,user_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- set sukses=1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_company_update` (IN `c_id` INT, IN `code` VARCHAR(50), IN `name` VARCHAR(200), IN `parent` INT, IN `office_phone` VARCHAR(30), IN `industry` INT, IN `email` VARCHAR(100), IN `fax` VARCHAR(30), IN `employee` INT, IN `revenue` DOUBLE, IN `website` VARCHAR(100), IN `address1` VARCHAR(255), IN `address2` VARCHAR(255), IN `city` VARCHAR(100), IN `state` VARCHAR(100), IN `zip_code` VARCHAR(10), IN `country` VARCHAR(50), IN `billing_address1` VARCHAR(255), IN `billing_address2` VARCHAR(255), IN `billing_city` VARCHAR(100), IN `billing_state` VARCHAR(100), IN `billing_zip_code` VARCHAR(10), IN `billing_country` VARCHAR(50), IN `right_permission` ENUM('1','2','3'), IN `groups` INT, IN `customer` ENUM('0','1'), IN `u_modified` VARCHAR(100), IN `date_modified` DATETIME, IN `user_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id AS u_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- UPDATE `crm_companies` SET
- `customer_code`=code,
- `company_name`=name,
- `company_parent`=parent,
- `company_office_phone`=office_phone,
- `company_industry`=industry,
- `company_email`=email,
- `company_fax`=fax,
- `company_employee`=employee,
- `company_revenue`=revenue,
- `company_website`=website,
- `company_address1`=address1,
- `company_address2`=address2,
- `company_city`=city,
- `company_state`=state,
- `company_zip_code`=zip_code,
- `company_country`=country,
- `company_billing_address1`=billing_address1,
- `company_billing_address2`=billing_address2,
- `company_billing_city`=billing_city,
- `company_billing_state`=billing_state,
- `company_billing_zip_code`=billing_zip_code,
- `company_billing_country`=billing_country,
- `company_right_permission`=right_permission,
- `user_modified`=u_modified,
- `user_modified_date`=date_modified,
- `company_groups`=groups,
- `company_customer`=customer
- WHERE `company_id`=c_id;
- delete from crm_users_companies where company_id=c_id;
- REPLACE INTO `crm_users_companies`(`company_id`,`user_id`)
- SELECT c_id,u_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_contact_insert` (IN `salutation` ENUM('1','2','3'), IN `first_name` VARCHAR(100), IN `last_name` VARCHAR(100), IN `job_title` VARCHAR(100), IN `company` VARCHAR(100), IN `department` VARCHAR(100), IN `email` VARCHAR(100), IN `office_phone` VARCHAR(30), IN `mobile_phone` VARCHAR(30), IN `industry` INT, IN `address1` VARCHAR(255), IN `address2` VARCHAR(255), IN `city` VARCHAR(100), IN `state` VARCHAR(100), IN `zip_code` VARCHAR(10), IN `country` VARCHAR(50), IN `sources` INT, IN `photo` VARCHAR(100), IN `comp_id` INT, IN `right_permission` ENUM('1','2','3'), IN `groups` INT, IN `user_list` VARCHAR(300), OUT `sukses` INT, OUT `contact_id` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id AS u_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- INSERT INTO `crm_peoples`(`people_salutation`, `people_first_name`, `people_last_name`, `people_job_title`, `people_company`, `people_department`, `people_email`, `people_office_phone`, `people_mobile_phone`, `people_industry`, `people_address1`, `people_address2`, `people_city`, `people_state`, `people_zip_code`, `people_country`, `people_source`, `people_photo`, `people_status`) VALUES (salutation, first_name, last_name, job_title, company, department, email, office_phone, mobile_phone, industry, address1, address2, city, state, zip_code, country, sources, photo, '2');
- SET @p_id = LAST_INSERT_ID();
- INSERT INTO `crm_contacts`(`people_id`, `contact_right_permission`, `contact_groups`, `company_id`) VALUES (@p_id, right_permission, groups, comp_id);
- SET @l_id = LAST_INSERT_ID();
- INSERT INTO `crm_users_contacts`(`contact_id`,`user_id`)
- SELECT @l_id,u_id from temp_cursor_table;
- SET contact_id = @l_id;
- drop temporary table if exists temp_cursor_table;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_contact_meeting_delete` (IN `meet_id` INT, OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- START TRANSACTION;
- DELETE FROM contact_meeting_users WHERE contact_meeting_id = meet_id;
- DELETE FROM contact_meeting WHERE contact_meeting_id = meet_id;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_contact_meeting_insert` (IN `l_id` INT, IN `name` VARCHAR(100), IN `location` VARCHAR(255), IN `start_date` DATETIME, IN `end_date` DATETIME, IN `description` TEXT, IN `date` DATETIME, IN `user` VARCHAR(100), IN `user_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- INSERT INTO `contact_meeting`(`contact_id`, `contact_meeting_name`, `contact_meeting_location`, `contact_meeting_start_date`, `contact_meeting_end_date`, `contact_meeting_description`, `contact_meeting_date`, `contact_meeting_user`) VALUES (l_id,name,location,start_date,end_date,description,date,user);
- SET @meet_id = LAST_INSERT_ID();
- INSERT INTO `contact_meeting_users`(`contact_meeting_id`,`contact_user_id`)
- SELECT @meet_id,user_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- set sukses=1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_contact_meeting_update` (IN `meet_id` INT, IN `l_id` INT, IN `name` VARCHAR(100), IN `location` VARCHAR(255), IN `start_date` DATETIME, IN `end_date` DATETIME, IN `description` TEXT, IN `date` DATETIME, IN `user` VARCHAR(100), IN `user_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- UPDATE `contact_meeting` SET
- `contact_meeting_name`=name,
- `contact_meeting_location`=location,
- `contact_meeting_start_date`=start_date,
- `contact_meeting_end_date`=end_date,
- `contact_meeting_description`=description,
- `contact_meeting_date`=date,
- `contact_meeting_user`=user,
- `contact_id`=l_id
- WHERE `contact_meeting_id`=meet_id;
- delete from contact_meeting_users where contact_meeting_id=meet_id;
- REPLACE INTO `contact_meeting_users`(`contact_meeting_id`,`contact_user_id`)
- SELECT meet_id,user_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- set sukses=1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_contact_update` (IN `l_id` INT, IN `salutation` ENUM('1','2','3'), IN `first_name` VARCHAR(100), IN `last_name` VARCHAR(100), IN `job_title` VARCHAR(100), IN `company` VARCHAR(100), IN `department` VARCHAR(100), IN `email` VARCHAR(100), IN `office_phone` VARCHAR(30), IN `mobile_phone` VARCHAR(30), IN `industry` INT, IN `address1` VARCHAR(255), IN `address2` VARCHAR(255), IN `city` VARCHAR(100), IN `state` VARCHAR(100), IN `zip_code` VARCHAR(10), IN `country` VARCHAR(50), IN `sources` INT, IN `photo` VARCHAR(100), IN `comp_id` INT, IN `right_permission` ENUM('1','2','3'), IN `groups` INT, IN `user_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id AS u_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- UPDATE `crm_peoples` a JOIN crm_contacts b ON a.people_id=b.people_id
- SET
- a.people_salutation=salutation,
- a.people_first_name=first_name,
- a.people_last_name=last_name,
- a.people_job_title=job_title,
- a.people_company=company,
- a.people_department=department,
- a.people_email=email,
- a.people_office_phone=office_phone,
- a.people_mobile_phone=mobile_phone,
- a.people_industry=industry,
- a.people_address1=address1,
- a.people_address2=address2,
- a.people_city=city,
- a.people_state=state,
- a.people_zip_code=zip_code,
- a.people_country=country,
- a.people_source=sources,
- a.people_photo=photo,
- b.contact_right_permission=right_permission,
- b.contact_groups=groups,
- b.company_id=comp_id
- WHERE b.contact_id = l_id;
- delete from crm_users_contacts where contact_id = l_id;
- REPLACE INTO `crm_users_contacts`(`contact_id`,`user_id`)
- SELECT l_id,u_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_convert_lead` (IN `l_id` INT, IN `comp_id` INT, IN `skip` ENUM('0','1'), IN `c_code` VARCHAR(50), IN `c_parent` INT, IN `c_office_phone` VARCHAR(30), IN `c_industry` INT, IN `c_email` VARCHAR(100), IN `c_fax` VARCHAR(30), IN `c_employee` INT, IN `c_revenue` DOUBLE, IN `c_website` VARCHAR(100), IN `c_address1` VARCHAR(255), IN `c_address2` VARCHAR(255), IN `c_city` VARCHAR(100), IN `c_state` VARCHAR(100), IN `c_zip_code` VARCHAR(10), IN `c_country` VARCHAR(50), IN `c_billing_address1` VARCHAR(255), IN `c_billing_address2` VARCHAR(255), IN `c_billing_city` VARCHAR(100), IN `c_billing_state` VARCHAR(100), IN `c_billing_zip_code` VARCHAR(10), IN `c_billing_country` VARCHAR(50), IN `c_right_permission` ENUM('1','2','3'), IN `c_u_created` VARCHAR(100), IN `c_date_created` DATETIME, IN `c_groups` INT, IN `c_customer` ENUM('0','1'), IN `o_code` VARCHAR(100), IN `o_name` VARCHAR(45), IN `o_stage_id` INT, IN `o_amount` DOUBLE, IN `o_closing_date` DATETIME, IN `o_service` ENUM('1','2'), IN `o_campaign_id` INT, IN `product_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE continue handler for not found set sukses = 0;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- SELECT a.lead_status,b.people_company into @l_status, @company from crm_leads a JOIN crm_peoples b ON a.people_id=b.people_id WHERE a.lead_id=l_id;
- IF comp_id is null THEN
- SET @comp_id = null;
- ELSE
- SET @comp_id = comp_id;
- END IF;
- IF @l_status= 1 THEN
- IF @comp_id IS null THEN
- INSERT INTO `crm_companies`(`customer_code`, `company_name`, `company_parent`, `company_office_phone`, `company_industry`,`company_email`, `company_fax`, `company_employee`, `company_revenue`, `company_website`, `company_address1`, `company_address2`, `company_city`, `company_state`, `company_zip_code`, `company_country`, `company_billing_address1`, `company_billing_address2`, `company_billing_city`, `company_billing_state`, `company_billing_zip_code`, `company_billing_country`, `company_right_permission`, `user_created`, `user_created_date`, `company_groups`, `company_customer`) VALUES
- (c_code, @company, c_parent, c_office_phone, c_industry, c_email, c_fax, c_employee, c_revenue, c_website, c_address1, c_address2, c_city, c_state, c_zip_code, c_country, c_billing_address1, c_billing_address2, c_billing_city, c_billing_state, c_billing_zip_code, c_billing_country, c_right_permission, c_u_created, c_date_created, c_groups, c_customer);
- set @comp_id = LAST_INSERT_ID();
- insert into crm_users_companies(company_id, user_id)
- SELECT @comp_id, user_id from crm_users_leads
- where lead_id = l_id;
- END IF;
- insert into crm_contacts(company_id,people_id,contact_right_permission,contact_groups)
- SELECT @comp_id,people_id,lead_right_permission,lead_groups from crm_leads where lead_id = l_id;
- set @c_id = LAST_INSERT_ID();
- UPDATE crm_leads set lead_status = '2'
- where lead_id = l_id;
- insert into crm_users_contacts(contact_id, user_id)
- SELECT @c_id, user_id from crm_users_leads
- where lead_id = l_id;
- IF skip='0' THEN
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT product_id AS p_id FROM crm_products where product_id in(', product_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- INSERT INTO `crm_opportunities`(`opportunity_code`,`opportunity_name`, `opportunity_stage_id`, `company_id`, `opportunity_amount`, `opportunity_closing_date`, `opportunity_service`, `opportunity_campaign_id`) VALUES (o_code, o_name, o_stage_id, @comp_id, o_amount, o_closing_date, o_service, o_campaign_id);
- SET @o_id = LAST_INSERT_ID();
- INSERT INTO crm_opportunities_contacts(opportunity_id,contact_id) VALUES (@o_id,@c_id);
- INSERT INTO `crm_opportunities_products`(`opportunity_id`, `product_id`)
- SELECT @o_id,p_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- END IF;
- END if;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_lead_delete` (IN `l_id` INT, OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- delete from crm_users_leads where lead_id = l_id;
- DELETE crm_peoples, crm_leads
- FROM crm_peoples
- INNER JOIN crm_leads ON crm_peoples.people_id=crm_leads.people_id
- WHERE crm_leads.lead_id=l_id;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_lead_insert` (IN `salutation` ENUM('1','2','3'), IN `first_name` VARCHAR(100), IN `last_name` VARCHAR(100), IN `job_title` VARCHAR(100), IN `company` VARCHAR(100), IN `department` VARCHAR(100), IN `email` VARCHAR(100), IN `office_phone` VARCHAR(30), IN `mobile_phone` VARCHAR(30), IN `industry` INT, IN `address1` VARCHAR(255), IN `address2` VARCHAR(255), IN `city` VARCHAR(100), IN `state` VARCHAR(100), IN `zip_code` VARCHAR(10), IN `country` VARCHAR(50), IN `sources` INT, IN `photo` VARCHAR(100), IN `stat` ENUM('1','2'), IN `label` INT, IN `right_permission` ENUM('1','2','3'), IN `groups` INT, IN `u_created` VARCHAR(100), IN `date_created` DATETIME, IN `user_list` VARCHAR(300), OUT `sukses` INT, OUT `l_id` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id AS u_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- INSERT INTO `crm_peoples`(`people_salutation`, `people_first_name`, `people_last_name`, `people_job_title`, `people_company`, `people_department`, `people_email`, `people_office_phone`, `people_mobile_phone`, `people_industry`, `people_address1`, `people_address2`, `people_city`, `people_state`, `people_zip_code`, `people_country`, `people_source`, `people_photo`, `people_status`) VALUES (salutation, first_name, last_name, job_title, company, department, email, office_phone, mobile_phone, industry, address1, address2, city, state, zip_code, country, sources, photo, stat);
- SET @p_id = LAST_INSERT_ID();
- INSERT INTO `crm_leads`(`lead_label`, `people_id`, `lead_right_permission`, `lead_groups`, `user_created`, `user_created_date`) VALUES (label, @p_id, right_permission, groups, u_created, date_created);
- SET l_id = LAST_INSERT_ID();
- INSERT INTO `crm_users_leads`(`lead_id`,`user_id`)
- SELECT l_id,u_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_lead_meeting_delete` (IN `meet_id` INT, OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- START TRANSACTION;
- DELETE FROM lead_meeting_users WHERE lead_meeting_id = meet_id;
- DELETE FROM lead_meeting WHERE lead_meeting_id = meet_id;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_lead_meeting_insert` (IN `l_id` INT, IN `name` VARCHAR(100), IN `location` VARCHAR(255), IN `start_date` DATETIME, IN `end_date` DATETIME, IN `description` TEXT, IN `date` DATETIME, IN `user` VARCHAR(100), IN `user_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- INSERT INTO `lead_meeting`(`lead_id`, `lead_meeting_name`, `lead_meeting_location`, `lead_meeting_start_date`, `lead_meeting_end_date`, `lead_meeting_description`, `lead_meeting_date`, `lead_meeting_user`) VALUES (l_id,name,location,start_date,end_date,description,date,user);
- SET @meet_id = LAST_INSERT_ID();
- INSERT INTO `lead_meeting_users`(`lead_meeting_id`,`lead_user_id`)
- SELECT @meet_id,user_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- set sukses=1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_lead_meeting_update` (IN `meet_id` INT, IN `l_id` INT, IN `name` VARCHAR(100), IN `location` VARCHAR(255), IN `start_date` DATETIME, IN `end_date` DATETIME, IN `description` TEXT, IN `date` DATETIME, IN `user` VARCHAR(100), IN `user_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- UPDATE `lead_meeting` SET
- `lead_meeting_name`=name,
- `lead_meeting_location`=location,
- `lead_meeting_start_date`=start_date,
- `lead_meeting_end_date`=end_date,
- `lead_meeting_description`=description,
- `lead_meeting_date`=date,
- `lead_meeting_user`=user,
- `lead_id`=l_id
- WHERE `lead_meeting_id`=meet_id;
- delete from lead_meeting_users where lead_meeting_id=meet_id;
- REPLACE INTO `lead_meeting_users`(`lead_meeting_id`,`lead_user_id`)
- SELECT meet_id,user_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- set sukses=1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_lead_update` (IN `l_id` INT, IN `salutation` ENUM('1','2','3'), IN `first_name` VARCHAR(100), IN `last_name` VARCHAR(100), IN `job_title` VARCHAR(100), IN `company` VARCHAR(100), IN `department` VARCHAR(100), IN `email` VARCHAR(100), IN `office_phone` VARCHAR(30), IN `mobile_phone` VARCHAR(30), IN `industry` INT, IN `address1` VARCHAR(255), IN `address2` VARCHAR(255), IN `city` VARCHAR(100), IN `state` VARCHAR(100), IN `zip_code` VARCHAR(10), IN `country` VARCHAR(50), IN `sources` INT, IN `photo` VARCHAR(100), IN `status_p` ENUM('1','2'), IN `status_l` ENUM('1','2','3'), IN `label` INT, IN `right_permission` ENUM('1','2','3'), IN `groups` INT, IN `u_modified` VARCHAR(100), IN `date_modified` DATETIME, IN `user_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id AS u_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- UPDATE `crm_peoples` a JOIN crm_leads b ON a.people_id=b.people_id
- SET
- a.people_salutation=salutation,
- a.people_first_name=first_name,
- a.people_last_name=last_name,
- a.people_job_title=job_title,
- a.people_company=company,
- a.people_department=department,
- a.people_email=email,
- a.people_office_phone=office_phone,
- a.people_mobile_phone=mobile_phone,
- a.people_industry=industry,
- a.people_address1=address1,
- a.people_address2=address2,
- a.people_city=city,
- a.people_state=state,
- a.people_zip_code=zip_code,
- a.people_country=country,
- a.people_source=sources,
- a.people_photo=photo,
- a.people_status = status_p,
- b.lead_label=label,
- b.lead_right_permission=right_permission,
- b.lead_groups=groups,
- b.lead_status=status_l,
- b.user_modified=u_modified,
- b.user_modified_date=date_modified
- WHERE b.lead_id = l_id;
- delete from crm_users_leads where lead_id = l_id;
- REPLACE INTO `crm_users_leads`(`lead_id`,`user_id`)
- SELECT l_id,u_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_opportunity_insert` (IN `code` VARCHAR(100), IN `name` VARCHAR(45), IN `stage_id` INT, IN `comp_id` INT, IN `amount` DOUBLE, IN `closing_date` DATETIME, IN `service` ENUM('1','2'), IN `campaign_id` INT, IN `product_list` VARCHAR(300), IN `contact_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT product_id AS p_id FROM crm_products where product_id in(', product_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- drop temporary table if exists temp_contact;
- set @temp1 = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_contact AS (SELECT contact_id AS c_id FROM crm_contacts where contact_id in(', contact_list ,') )');
- prepare pst from @temp1;
- execute pst;
- drop prepare pst;
- INSERT INTO `crm_opportunities`(`opportunity_code`, `opportunity_name`, `opportunity_stage_id`, `company_id`, `opportunity_amount`, `opportunity_closing_date`, `opportunity_service`, `opportunity_campaign_id`) VALUES (code, name, stage_id, comp_id, amount, closing_date, service, campaign_id);
- SET @o_id = LAST_INSERT_ID();
- INSERT INTO crm_opportunities_contacts(opportunity_id,contact_id)
- SELECT @o_id,c_id from temp_contact;
- INSERT INTO `crm_opportunities_products`(`opportunity_id`, `product_id`)
- SELECT @o_id,p_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- drop temporary table if exists temp_contact;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_opportunity_meeting_delete` (IN `meet_id` INT, OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- START TRANSACTION;
- DELETE FROM opportunity_meeting_users WHERE opportunity_meeting_id = meet_id;
- DELETE FROM opportunity_meeting WHERE opportunity_meeting_id = meet_id;
- SET sukses = 1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_opportunity_meeting_insert` (IN `o_id` INT, IN `name` VARCHAR(100), IN `location` VARCHAR(255), IN `start_date` DATETIME, IN `end_date` DATETIME, IN `description` TEXT, IN `date` DATETIME, IN `user` VARCHAR(100), IN `user_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- INSERT INTO `opportunity_meeting`(`opportunity_id`, `opportunity_meeting_name`, `opportunity_meeting_location`, `opportunity_meeting_start_date`, `opportunity_meeting_end_date`, `opportunity_meeting_description`, `opportunity_meeting_date`, `opportunity_meeting_user`) VALUES (o_id,name,location,start_date,end_date,description,date,user);
- SET @meet_id = LAST_INSERT_ID();
- INSERT INTO `opportunity_meeting_users`(`opportunity_meeting_id`,`opportunity_user_id`)
- SELECT @meet_id,user_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- set sukses=1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_opportunity_meeting_update` (IN `meet_id` INT, IN `o_id` INT, IN `name` VARCHAR(100), IN `location` VARCHAR(255), IN `start_date` DATETIME, IN `end_date` DATETIME, IN `description` TEXT, IN `date` DATETIME, IN `user` VARCHAR(100), IN `user_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT user_id FROM crm_users where user_id in(', user_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- UPDATE `opportunity_meeting` SET
- `opportunity_meeting_name`=name,
- `opportunity_meeting_location`=location,
- `opportunity_meeting_start_date`=start_date,
- `opportunity_meeting_end_date`=end_date,
- `opportunity_meeting_description`=description,
- `opportunity_meeting_date`=date,
- `opportunity_meeting_user`=user,
- `opportunity_id`=o_id
- WHERE `opportunity_meeting_id`=meet_id;
- delete from opportunity_meeting_users where opportunity_meeting_id=meet_id;
- REPLACE INTO `opportunity_meeting_users`(`opportunity_meeting_id`,`opportunity_user_id`)
- SELECT meet_id,user_id from temp_cursor_table;
- drop temporary table if exists temp_cursor_table;
- set sukses=1;
- COMMIT;
- END$$
- CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_opportunity_update` (IN `o_id` INT, IN `name` VARCHAR(45), IN `stage_id` INT, IN `comp_id` INT, IN `amount` DOUBLE, IN `closing_date` DATETIME, IN `service` ENUM('1','2'), IN `campaign_id` INT, IN `product_list` VARCHAR(300), IN `contact_list` VARCHAR(300), OUT `sukses` INT) NO SQL
- BEGIN
- DECLARE exit handler for sqlexception
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("ERROR ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- DECLARE exit handler for sqlwarning
- BEGIN
- GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
- @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
- SET @full_error = CONCAT("Warning ", @errno, " (", @sqlstate, "): ", @text);
- SELECT @full_error;
- SET sukses=0;
- ROLLBACK;
- END;
- drop temporary table if exists temp_cursor_table;
- set @temp = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_cursor_table AS (SELECT product_id AS p_id FROM crm_products where product_id in(', product_list ,') )');
- prepare pst from @temp;
- execute pst;
- drop prepare pst;
- drop temporary table if exists temp_contact;
- set @temp1 = concat('CREATE TEMPORARY TABLE IF NOT EXISTS temp_contact AS (SELECT contact_id AS c_id FROM crm_contacts where contact_id in(', contact_list ,') )');
- prepare pst from @temp1;
- execute pst;
- drop prepare pst;
- UPDATE `crm_opportunities` SET
- `opportunity_name`=name,
- `opportunity_stage_id`=stage_id,
- `company_id`=comp_id,
- `opportunity_amount`=amount,
- `opportunity_closing_date`=closing_date,
- `opportunity_service`=service,
- `opportunity_campaign_id`=campaign_id
- WHERE `opportunity_id`=o_id;
- delete from crm_opportunities_products where opportunity_id = o_id;
- REPLACE INTO `crm_opportunities_products`(`opportunity_id`, `product_id`)
- SELECT o_id,p_id from temp_cursor_table;
- REPLACE INTO crm_opportunities_contacts(opportunity_id,contact_id)
- SELECT o_id,c_id from temp_contact;
- drop temporary table if exists temp_cursor_table;
- drop temporary table if exists temp_contact;
- SET sukses = 1;
- COMMIT;
- END$$
- DELIMITER ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `company_calls`
- --
- CREATE TABLE `company_calls` (
- `company_call_id` int(11) NOT NULL,
- `company_call_title` varchar(100) DEFAULT NULL,
- `company_call_duration` int(11) DEFAULT NULL,
- `company_call_time` enum('1','2','3') DEFAULT '1' COMMENT '1= Second\n2= Minutes\n3=Hour\n',
- `company_call_notes` text,
- `company_call_date` datetime NOT NULL,
- `company_call_user` varchar(100) NOT NULL,
- `company_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `company_calls`
- --
- INSERT INTO `company_calls` (`company_call_id`, `company_call_title`, `company_call_duration`, `company_call_time`, `company_call_notes`, `company_call_date`, `company_call_user`, `company_id`) VALUES
- (1, 'eqw', 33, '1', 'qwe', '2017-08-23 20:27:09', 'ulala', 24);
- -- --------------------------------------------------------
- --
- -- Table structure for table `company_files`
- --
- CREATE TABLE `company_files` (
- `company_files_id` int(11) NOT NULL,
- `company_file_subject` varchar(100) DEFAULT NULL,
- `company_file_to` varchar(100) NOT NULL,
- `company_file_cc` varchar(100) DEFAULT NULL,
- `company_file_description` text,
- `company_file_name` varchar(100) NOT NULL,
- `company_file_date` datetime NOT NULL,
- `company_file_user` varchar(100) NOT NULL,
- `company_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `company_meeting`
- --
- CREATE TABLE `company_meeting` (
- `company_meeting_id` int(11) NOT NULL,
- `company_meeting_name` varchar(100) DEFAULT NULL,
- `company_meeting_location` varchar(255) DEFAULT NULL,
- `company_meeting_start_date` datetime DEFAULT NULL,
- `company_meeting_end_date` datetime DEFAULT NULL,
- `company_meeting_description` text,
- `company_meeting_date` datetime NOT NULL,
- `company_meeting_user` varchar(100) NOT NULL,
- `company_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `company_meeting`
- --
- INSERT INTO `company_meeting` (`company_meeting_id`, `company_meeting_name`, `company_meeting_location`, `company_meeting_start_date`, `company_meeting_end_date`, `company_meeting_description`, `company_meeting_date`, `company_meeting_user`, `company_id`) VALUES
- (2, 'qwe', 'qwe', '2017-08-01 00:00:00', '2017-08-02 00:00:00', 'qwe', '2017-08-23 20:26:57', 'ulala', 24),
- (3, 'asd', 'asd', '2017-08-01 00:00:00', '2017-08-02 00:00:00', 'asdasd', '2017-08-25 12:57:23', 'ulala', 24);
- -- --------------------------------------------------------
- --
- -- Table structure for table `company_meeting_users`
- --
- CREATE TABLE `company_meeting_users` (
- `company_meeting_id` int(11) NOT NULL,
- `company_user_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `company_meeting_users`
- --
- INSERT INTO `company_meeting_users` (`company_meeting_id`, `company_user_id`) VALUES
- (2, 9),
- (3, 15);
- -- --------------------------------------------------------
- --
- -- Table structure for table `company_notes`
- --
- CREATE TABLE `company_notes` (
- `company_note_id` int(11) NOT NULL,
- `company_note_name` varchar(100) NOT NULL,
- `company_note_description` text,
- `company_note_date` datetime DEFAULT NULL,
- `company_note_user` varchar(100) DEFAULT NULL,
- `company_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `company_notes`
- --
- INSERT INTO `company_notes` (`company_note_id`, `company_note_name`, `company_note_description`, `company_note_date`, `company_note_user`, `company_id`) VALUES
- (1, 'ssssss', '<p>ssssss</p>', '2017-08-23 20:26:27', 'ulala', 24);
- -- --------------------------------------------------------
- --
- -- Table structure for table `company_tasks`
- --
- CREATE TABLE `company_tasks` (
- `company_task_id` int(11) NOT NULL,
- `company_task_name` varchar(100) NOT NULL,
- `company_task_description` varchar(45) DEFAULT NULL,
- `company_task_status` int(11) DEFAULT NULL,
- `company_task_due_date` datetime DEFAULT NULL,
- `company_task_date` datetime NOT NULL,
- `company_task_user` varchar(100) NOT NULL,
- `company_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `company_tasks`
- --
- INSERT INTO `company_tasks` (`company_task_id`, `company_task_name`, `company_task_description`, `company_task_status`, `company_task_due_date`, `company_task_date`, `company_task_user`, `company_id`) VALUES
- (1, 'aas', 'aas', 44, '2017-08-23 00:00:00', '2017-08-23 20:26:10', 'ulala', 24);
- -- --------------------------------------------------------
- --
- -- Table structure for table `contact_calls`
- --
- CREATE TABLE `contact_calls` (
- `contact_call_id` int(11) NOT NULL,
- `contact_call_title` varchar(100) DEFAULT NULL,
- `contact_call_duration` int(11) DEFAULT NULL,
- `contact_call_time` enum('1','2','3') DEFAULT '1' COMMENT '1= Second\n2= Minutes\n3=Hour\n',
- `contact_call_notes` text,
- `contact_call_date` datetime NOT NULL,
- `contact_call_user` varchar(100) NOT NULL,
- `contact_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `contact_calls`
- --
- INSERT INTO `contact_calls` (`contact_call_id`, `contact_call_title`, `contact_call_duration`, `contact_call_time`, `contact_call_notes`, `contact_call_date`, `contact_call_user`, `contact_id`) VALUES
- (2, 'string', 10, '1', 'string', '2017-08-29 04:21:27', 'string', 30);
- -- --------------------------------------------------------
- --
- -- Table structure for table `contact_files`
- --
- CREATE TABLE `contact_files` (
- `contact_files_id` int(11) NOT NULL,
- `contact_file_subject` varchar(100) DEFAULT NULL,
- `contact_file_to` varchar(100) NOT NULL,
- `contact_file_cc` varchar(100) DEFAULT NULL,
- `contact_file_description` text,
- `contact_file_name` varchar(100) NOT NULL,
- `contact_file_date` datetime NOT NULL,
- `contact_file_user` varchar(100) NOT NULL,
- `contact_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `contact_files`
- --
- INSERT INTO `contact_files` (`contact_files_id`, `contact_file_subject`, `contact_file_to`, `contact_file_cc`, `contact_file_description`, `contact_file_name`, `contact_file_date`, `contact_file_user`, `contact_id`) VALUES
- (1, 'string', 'string', 'string', 'string', '8996123e-a073-451d-bde5-f70ac9c01226.jpg', '2017-08-29 04:27:05', '5', 30);
- -- --------------------------------------------------------
- --
- -- Table structure for table `contact_meeting`
- --
- CREATE TABLE `contact_meeting` (
- `contact_meeting_id` int(11) NOT NULL,
- `contact_meeting_name` varchar(100) DEFAULT NULL,
- `contact_meeting_location` varchar(255) DEFAULT NULL,
- `contact_meeting_start_date` datetime DEFAULT NULL,
- `contact_meeting_end_date` datetime DEFAULT NULL,
- `contact_meeting_description` text,
- `contact_meeting_date` datetime NOT NULL,
- `contact_meeting_user` varchar(100) NOT NULL,
- `contact_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `contact_meeting`
- --
- INSERT INTO `contact_meeting` (`contact_meeting_id`, `contact_meeting_name`, `contact_meeting_location`, `contact_meeting_start_date`, `contact_meeting_end_date`, `contact_meeting_description`, `contact_meeting_date`, `contact_meeting_user`, `contact_id`) VALUES
- (1, 'asd', 'asd', '2017-08-12 00:00:00', '2017-08-12 00:00:00', 'asd', '2017-08-23 20:31:21', 'ulala', 30);
- -- --------------------------------------------------------
- --
- -- Table structure for table `contact_meeting_users`
- --
- CREATE TABLE `contact_meeting_users` (
- `contact_meeting_id` int(11) NOT NULL,
- `contact_user_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `contact_meeting_users`
- --
- INSERT INTO `contact_meeting_users` (`contact_meeting_id`, `contact_user_id`) VALUES
- (1, 15);
- -- --------------------------------------------------------
- --
- -- Table structure for table `contact_notes`
- --
- CREATE TABLE `contact_notes` (
- `contact_note_id` int(11) NOT NULL,
- `contact_note_name` varchar(100) NOT NULL,
- `contact_note_description` text,
- `contact_note_date` datetime DEFAULT NULL,
- `contact_note_user` varchar(100) DEFAULT NULL,
- `contact_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `contact_tasks`
- --
- CREATE TABLE `contact_tasks` (
- `contact_task_id` int(11) NOT NULL,
- `contact_task_name` varchar(100) NOT NULL,
- `contact_task_description` varchar(45) DEFAULT NULL,
- `contact_task_status` int(11) DEFAULT NULL,
- `contact_task_due_date` datetime DEFAULT NULL,
- `contact_task_date` datetime NOT NULL,
- `contact_task_user` varchar(100) NOT NULL,
- `contact_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `contact_tasks`
- --
- INSERT INTO `contact_tasks` (`contact_task_id`, `contact_task_name`, `contact_task_description`, `contact_task_status`, `contact_task_due_date`, `contact_task_date`, `contact_task_user`, `contact_id`) VALUES
- (1, 'asd', 'qwe', 22, '2017-08-29 00:00:00', '2017-08-29 03:30:34', 'ulala', 31);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_campaigns`
- --
- CREATE TABLE `crm_campaigns` (
- `campaign_id` int(11) NOT NULL,
- `campaign_name` varchar(100) NOT NULL,
- `campaign_description` text,
- `campaign_start_date` date DEFAULT NULL,
- `campaign_end_date` date DEFAULT NULL,
- `campaign_status` enum('0','1') DEFAULT '0' COMMENT '0=Non aktif\n1= Aktif\n\n',
- `campaign_number` int(11) DEFAULT NULL,
- `campaign_percentage_response` double DEFAULT NULL,
- `campaign_budget_cost_currency` enum('1','2') DEFAULT NULL COMMENT '1= USD\n2 = IDR ',
- `campaign_budget_cost` double DEFAULT NULL,
- `campaign_actual_cost_currency` enum('1','2') DEFAULT NULL COMMENT '1= USD\n2 = IDR ',
- `campaign_actual_cost` double DEFAULT NULL,
- `campaign_expected_revenue_currency` enum('1','2') DEFAULT NULL COMMENT '1= USD\n2 = IDR ',
- `campaign_expected_revenue` double DEFAULT NULL,
- `user_created` varchar(100) DEFAULT NULL,
- `user_created_date` datetime DEFAULT NULL,
- `user_modified` varchar(100) DEFAULT NULL,
- `user_modified_date` datetime DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_campaigns`
- --
- INSERT INTO `crm_campaigns` (`campaign_id`, `campaign_name`, `campaign_description`, `campaign_start_date`, `campaign_end_date`, `campaign_status`, `campaign_number`, `campaign_percentage_response`, `campaign_budget_cost_currency`, `campaign_budget_cost`, `campaign_actual_cost_currency`, `campaign_actual_cost`, `campaign_expected_revenue_currency`, `campaign_expected_revenue`, `user_created`, `user_created_date`, `user_modified`, `user_modified_date`) VALUES
- (9, 'asd', 'asd', '2017-08-07', '2017-09-30', '1', 1, 2, '1', 5000, '2', 5000, '1', 5000, 'Admin', '2017-08-23 20:19:04', NULL, NULL),
- (10, 'asd', 'asd', '2017-08-07', '2017-08-07', '1', 1, 2, '1', 5000, '2', 5000, '1', 5000, 'Admin', '2017-08-26 07:25:12', NULL, NULL),
- (11, 'asd', 'asd', '2017-09-04', '2017-09-04', '1', 1, 5, '1', 5000, '1', 5000, '1', 5000, 'Admin', '2017-08-26 09:19:42', NULL, '2017-08-29 03:03:01');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_companies`
- --
- CREATE TABLE `crm_companies` (
- `company_id` int(11) NOT NULL,
- `customer_code` varchar(50) DEFAULT NULL,
- `company_name` varchar(200) DEFAULT NULL,
- `company_parent` int(11) DEFAULT NULL,
- `company_office_phone` varchar(30) DEFAULT NULL,
- `company_industry` int(11) NOT NULL,
- `company_email` varchar(100) DEFAULT NULL,
- `company_fax` varchar(30) DEFAULT NULL,
- `company_employee` int(11) DEFAULT NULL,
- `company_revenue` double DEFAULT NULL,
- `company_website` varchar(100) DEFAULT NULL,
- `company_address1` varchar(255) DEFAULT NULL,
- `company_address2` varchar(255) DEFAULT NULL,
- `company_city` varchar(100) DEFAULT NULL,
- `company_state` varchar(100) DEFAULT NULL,
- `company_zip_code` varchar(10) DEFAULT NULL,
- `company_country` varchar(50) DEFAULT NULL,
- `company_billing_address1` varchar(255) DEFAULT NULL,
- `company_billing_address2` varchar(255) DEFAULT NULL,
- `company_billing_city` varchar(100) DEFAULT NULL,
- `company_billing_state` varchar(100) DEFAULT NULL,
- `company_billing_zip_code` varchar(10) DEFAULT NULL,
- `company_billing_country` varchar(50) DEFAULT NULL,
- `company_right_permission` enum('1','2','3') DEFAULT '1' COMMENT '1=owner2=group23=everyone',
- `user_created` varchar(100) DEFAULT NULL,
- `user_created_date` datetime DEFAULT NULL,
- `user_modified` varchar(100) DEFAULT NULL,
- `user_modified_date` datetime DEFAULT NULL,
- `company_groups` int(11) DEFAULT NULL,
- `company_customer` enum('0','1') DEFAULT '0' COMMENT '0=Not Customer\n1=Customer\n'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_companies`
- --
- INSERT INTO `crm_companies` (`company_id`, `customer_code`, `company_name`, `company_parent`, `company_office_phone`, `company_industry`, `company_email`, `company_fax`, `company_employee`, `company_revenue`, `company_website`, `company_address1`, `company_address2`, `company_city`, `company_state`, `company_zip_code`, `company_country`, `company_billing_address1`, `company_billing_address2`, `company_billing_city`, `company_billing_state`, `company_billing_zip_code`, `company_billing_country`, `company_right_permission`, `user_created`, `user_created_date`, `user_modified`, `user_modified_date`, `company_groups`, `company_customer`) VALUES
- (24, NULL, 'Koding Next', NULL, '123', 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, 'asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (25, NULL, 'KN', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (26, NULL, 'jhg', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (27, NULL, 'ulala', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (28, NULL, 'Contoh', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (29, NULL, 'Contoh 2', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (30, NULL, 'Contoh 3', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (31, NULL, 'Contoh 4', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (32, NULL, 'lenovo', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (33, NULL, 'Contoh 2', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (34, NULL, 'asus', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (35, NULL, 'msi', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (36, NULL, 'ASUS ROG', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (37, NULL, 'LG', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (38, NULL, 'asdasd', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (39, NULL, 'Noval Corp', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (40, NULL, 'asdasd5', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (41, NULL, 'asd baru', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (42, NULL, 'asd baru lagi', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (43, NULL, 'lalallalalalalalala pusing', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (44, NULL, 'ulala houp comp', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (45, NULL, 'asd baru lagi nih hahaha', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (46, NULL, 'hahahahahaha', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0'),
- (47, NULL, 'company coba skip', NULL, NULL, 2, 'asd@asd.asd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_contacts`
- --
- CREATE TABLE `crm_contacts` (
- `contact_id` int(11) NOT NULL,
- `company_id` int(11) NOT NULL,
- `people_id` int(11) NOT NULL,
- `contact_right_permission` enum('1','2','3') DEFAULT NULL,
- `contact_groups` int(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_contacts`
- --
- INSERT INTO `crm_contacts` (`contact_id`, `company_id`, `people_id`, `contact_right_permission`, `contact_groups`) VALUES
- (30, 24, 10, '2', NULL),
- (31, 25, 43, '1', NULL),
- (32, 26, 44, '1', NULL),
- (33, 27, 45, '1', NULL),
- (37, 28, 50, '1', NULL),
- (44, 29, 49, '1', NULL),
- (45, 30, 48, '1', NULL),
- (46, 31, 46, '1', NULL),
- (63, 32, 52, '1', NULL),
- (64, 33, 51, '1', NULL),
- (66, 34, 53, '1', NULL),
- (73, 35, 54, '1', NULL),
- (74, 36, 55, '1', NULL),
- (75, 37, 56, '1', NULL),
- (76, 38, 63, '1', NULL),
- (77, 39, 64, '1', NULL),
- (78, 40, 68, '1', NULL),
- (79, 41, 70, '1', NULL),
- (80, 42, 71, '1', NULL),
- (81, 43, 72, '1', NULL),
- (82, 44, 73, '1', NULL),
- (83, 45, 74, '1', NULL),
- (84, 46, 75, '1', NULL),
- (85, 46, 69, '1', NULL),
- (86, 46, 77, '1', NULL),
- (87, 41, 78, '1', NULL),
- (88, 41, 79, '1', NULL),
- (89, 41, 76, '1', NULL),
- (90, 41, 81, '1', NULL),
- (91, 41, 82, '1', NULL),
- (92, 24, 80, '1', NULL),
- (93, 45, 84, '1', NULL),
- (94, 45, 85, '1', NULL),
- (95, 45, 86, '1', NULL),
- (96, 45, 87, '1', NULL),
- (97, 41, 88, '1', NULL),
- (98, 47, 89, '1', NULL);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_groups`
- --
- CREATE TABLE `crm_groups` (
- `group_id` int(11) NOT NULL,
- `group_name` varchar(100) NOT NULL,
- `group_status` enum('0','1') DEFAULT '1' COMMENT '0= Non Aktif\n1= Aktif\n',
- `user_created` varchar(100) DEFAULT NULL,
- `user_created_date` datetime DEFAULT NULL,
- `user_modified` varchar(45) DEFAULT NULL,
- `user_modified_date` datetime DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_groups`
- --
- INSERT INTO `crm_groups` (`group_id`, `group_name`, `group_status`, `user_created`, `user_created_date`, `user_modified`, `user_modified_date`) VALUES
- (1, 'Dev', '1', 'Admin', '2017-08-11 15:58:52', 'Admin', '2017-08-18 10:49:43'),
- (3, 'Dev', '1', 'Admin', '2017-08-11 15:58:52', 'Admin', '2017-08-18 10:49:43');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_industry`
- --
- CREATE TABLE `crm_industry` (
- `industry_id` int(11) NOT NULL,
- `industry_name` varchar(100) NOT NULL,
- `user_created` varchar(100) DEFAULT NULL,
- `user_created_date` datetime DEFAULT NULL,
- `user_modified` varchar(100) DEFAULT NULL,
- `user_modified_date` datetime DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_industry`
- --
- INSERT INTO `crm_industry` (`industry_id`, `industry_name`, `user_created`, `user_created_date`, `user_modified`, `user_modified_date`) VALUES
- (2, 'Edukasi', 'Admin', '2017-08-11 16:04:17', 'Admin', '2017-08-18 10:51:53');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_invoices`
- --
- CREATE TABLE `crm_invoices` (
- `invoice_id` int(11) NOT NULL,
- `company_id` int(11) NOT NULL,
- `invoice_ref` varchar(45) DEFAULT NULL,
- `invoice_profile` varchar(100) DEFAULT NULL,
- `invoice_type` enum('1','2') NOT NULL COMMENT '1=One Time\n2=Recurring\n',
- `invoice_start_date` datetime DEFAULT NULL,
- `invoice_end_date` datetime DEFAULT NULL COMMENT ' ',
- `invoice_repeat_value` int(11) DEFAULT NULL,
- `invoice_repeat_type` enum('1','2','3') DEFAULT NULL COMMENT '1 =Day\n2= week\n3=Month\n',
- `invoice_expired` enum('0','1') DEFAULT NULL COMMENT '0=expired\n1=never expired\n',
- `term_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_invoices`
- --
- INSERT INTO `crm_invoices` (`invoice_id`, `company_id`, `invoice_ref`, `invoice_profile`, `invoice_type`, `invoice_start_date`, `invoice_end_date`, `invoice_repeat_value`, `invoice_repeat_type`, `invoice_expired`, `term_id`) VALUES
- (29, 24, 'asd123', '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (30, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (31, 41, 'OPR-081700002', '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (32, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (33, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (34, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (35, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (36, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (37, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (38, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (39, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (40, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (41, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (42, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (43, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (44, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (45, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (46, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (47, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (48, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (49, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (50, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (51, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (52, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (53, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (54, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1),
- (55, 24, NULL, '-', '1', NULL, NULL, NULL, '1', '1', 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_invoices_products`
- --
- CREATE TABLE `crm_invoices_products` (
- `invoice_detail_id` int(11) NOT NULL,
- `product_id` int(11) NOT NULL,
- `qty` int(11) DEFAULT NULL,
- `price` double DEFAULT NULL,
- `is_campaign` enum('0','1') NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_invoices_products`
- --
- INSERT INTO `crm_invoices_products` (`invoice_detail_id`, `product_id`, `qty`, `price`, `is_campaign`) VALUES
- (16, 2, 12, 123123, '0'),
- (17, 5, 123, 123123, '0'),
- (18, 2, 1, 1000, '1'),
- (18, 5, 1, 1000, '1'),
- (19, 5, 1, 1000, '0'),
- (20, 5, 1, 1000, '0'),
- (21, 5, 1, 1000, '0'),
- (22, 5, 1, 1000, '0'),
- (23, 5, 1, 1000, '0'),
- (24, 5, 1, 1000, '0'),
- (25, 5, 1, 1000, '0'),
- (26, 5, 1, 1000, '0'),
- (27, 5, 1, 1000, '0'),
- (28, 5, 1, 1000, '0'),
- (29, 5, 1, 1000, '0'),
- (30, 5, 1, 1000, '0'),
- (31, 5, 1, 1000, '0'),
- (32, 5, 1, 1000, '0'),
- (33, 5, 1, 1000, '0'),
- (34, 5, 1, 1000, '0'),
- (35, 5, 1, 1000, '0'),
- (36, 5, 1, 1000, '0'),
- (37, 5, 1, 1000, '0'),
- (38, 5, 1, 1000, '0'),
- (39, 5, 1, 1000, '0'),
- (40, 5, 1, 1000, '0'),
- (41, 5, 1, 1000, '0'),
- (42, 5, 1, 1000, '0');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_invoice_details`
- --
- CREATE TABLE `crm_invoice_details` (
- `invoice_detail_id` int(11) NOT NULL,
- `invoice_code` varchar(50) NOT NULL,
- `invoice_id` int(11) NOT NULL,
- `invoice_date` datetime NOT NULL,
- `invoice_due_date` datetime DEFAULT NULL,
- `invoice_discount_type` enum('1','2') DEFAULT '1' COMMENT '1=Percentage2=Value',
- `invoice_discount_value` double DEFAULT NULL,
- `invoice_tax_percentage` double DEFAULT NULL,
- `invoice_adjustment` double DEFAULT NULL,
- `invoice_type` enum('1','2') DEFAULT NULL COMMENT '1=One time\n2=recurring\n',
- `invoice_cycle` int(11) NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_invoice_details`
- --
- INSERT INTO `crm_invoice_details` (`invoice_detail_id`, `invoice_code`, `invoice_id`, `invoice_date`, `invoice_due_date`, `invoice_discount_type`, `invoice_discount_value`, `invoice_tax_percentage`, `invoice_adjustment`, `invoice_type`, `invoice_cycle`) VALUES
- (16, 'INV-081700001', 29, '2017-08-29 05:59:06', '2017-09-13 00:00:00', '1', 14, 11, 100, '1', 1),
- (17, 'INV-081700002', 30, '2017-08-29 06:02:32', '2017-09-13 00:00:00', '1', 151, 11, 11, '1', 1),
- (18, 'INV-081700003', 31, '2017-08-29 06:05:06', '2017-09-13 00:00:00', '2', 11, 1, 1, '1', 1),
- (19, 'INV-091700004', 32, '2017-09-06 09:19:34', '2017-09-21 00:00:00', '1', 110, 1, 111, '1', 1),
- (20, 'INV-091700005', 33, '2017-09-06 09:27:45', '2017-09-21 00:00:00', '1', 10, 1, 1, '1', 1),
- (21, 'INV-091700006', 34, '2017-09-06 09:28:27', '2017-09-21 00:00:00', '1', 10, 1, 1, '1', 1),
- (22, 'INV-091700007', 35, '2017-09-06 09:59:12', '2017-09-21 00:00:00', '1', 10, 1, 1, '1', 1),
- (23, 'INV-091700008', 36, '2017-09-06 10:06:58', '2017-09-21 00:00:00', '1', 10, 1, 1, '1', 1),
- (24, 'INV-091700009', 37, '2017-09-06 10:07:07', '2017-09-21 00:00:00', '1', 10, 1, 1, '1', 1),
- (25, 'INV-091700010', 38, '2017-09-06 10:08:23', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (26, 'INV-091700011', 39, '2017-09-06 10:08:44', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (27, 'INV-091700012', 40, '2017-09-06 10:09:09', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (28, 'INV-091700013', 41, '2017-09-06 10:10:45', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (29, 'INV-091700014', 42, '2017-09-06 10:11:09', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (30, 'INV-091700015', 43, '2017-09-06 10:13:08', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (31, 'INV-091700016', 44, '2017-09-06 10:13:45', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (32, 'INV-091700017', 45, '2017-09-06 10:14:35', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (33, 'INV-091700018', 46, '2017-09-06 10:15:03', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (34, 'INV-091700019', 47, '2017-09-06 10:16:16', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (35, 'INV-091700020', 48, '2017-09-06 10:18:15', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (36, 'INV-091700021', 49, '2017-09-06 10:19:35', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (37, 'INV-091700022', 50, '2017-09-06 10:20:07', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (38, 'INV-091700023', 51, '2017-09-06 10:24:37', '2017-09-21 00:00:00', '1', 100, 10, 100, '1', 1),
- (39, 'INV-091700024', 52, '2017-09-06 10:32:28', '2017-09-21 00:00:00', '1', 120, 12, 1000, '1', 1),
- (40, 'INV-091700025', 53, '2017-09-06 10:33:10', '2017-09-21 00:00:00', '1', 120, 12, 1000, '1', 1),
- (41, 'INV-091700026', 54, '2017-09-06 10:34:30', '2017-09-21 00:00:00', '1', 120, 12, 1000, '1', 1),
- (42, 'INV-091700027', 55, '2017-09-06 10:34:56', '2017-09-21 00:00:00', '1', 120, 12, 1000, '1', 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_leads`
- --
- CREATE TABLE `crm_leads` (
- `lead_id` int(11) NOT NULL,
- `lead_label` int(11) NOT NULL,
- `people_id` int(11) NOT NULL,
- `lead_right_permission` enum('1','2','3') DEFAULT NULL COMMENT '1=owner\n2=group2\n3=everyone\n\n',
- `lead_groups` int(11) DEFAULT NULL,
- `lead_status` enum('1','2','3') NOT NULL DEFAULT '1' COMMENT '1= Lead\n2 = Convert\n3 =Junk\n',
- `user_created` varchar(100) DEFAULT NULL,
- `user_created_date` datetime DEFAULT NULL,
- `user_modified` varchar(100) DEFAULT NULL,
- `user_modified_date` datetime DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_leads`
- --
- INSERT INTO `crm_leads` (`lead_id`, `lead_label`, `people_id`, `lead_right_permission`, `lead_groups`, `lead_status`, `user_created`, `user_created_date`, `user_modified`, `user_modified_date`) VALUES
- (5, 3, 10, '2', NULL, '2', 'Admin', '2017-08-11 17:36:47', 'Admin', '2017-08-19 10:03:25'),
- (38, 3, 43, '1', NULL, '2', 'ulala', '2017-08-23 19:50:08', NULL, NULL),
- (39, 3, 44, '1', NULL, '2', 'ulala', '2017-08-23 19:55:36', NULL, NULL),
- (40, 3, 45, '1', NULL, '2', 'ulala', '2017-08-23 19:58:10', NULL, NULL),
- (41, 3, 46, '1', NULL, '2', 'ulala', '2017-08-24 03:23:39', NULL, NULL),
- (42, 3, 47, '1', NULL, '3', 'ulala', '2017-08-24 03:24:42', NULL, NULL),
- (43, 3, 48, '1', NULL, '2', 'ulala', '2017-08-24 03:32:59', NULL, NULL),
- (44, 3, 49, '1', NULL, '2', 'ulala', '2017-08-24 03:34:48', NULL, NULL),
- (45, 3, 50, '1', NULL, '2', 'ulala', '2017-08-24 03:36:58', NULL, NULL),
- (46, 3, 51, '1', NULL, '2', 'ulala', '2017-08-24 03:55:19', NULL, NULL),
- (47, 3, 52, '1', NULL, '2', 'ulala', '2017-08-24 04:23:39', NULL, NULL),
- (48, 3, 53, '1', NULL, '2', 'ulala', '2017-08-24 04:42:03', NULL, NULL),
- (49, 3, 54, '1', NULL, '2', 'ulala', '2017-08-24 04:43:47', NULL, NULL),
- (50, 3, 55, '1', NULL, '2', 'ulala', '2017-08-24 07:01:19', NULL, NULL),
- (51, 3, 56, '1', NULL, '2', 'ulala', '2017-08-24 08:32:45', NULL, NULL),
- (53, 3, 61, '1', 3, '1', 'admin', '2017-08-24 15:36:47', NULL, NULL),
- (54, 3, 63, '1', NULL, '2', 'ulala', '2017-08-24 15:39:47', NULL, NULL),
- (55, 3, 64, '1', NULL, '2', 'ulala', '2017-08-24 15:46:49', NULL, NULL),
- (56, 3, 68, '1', NULL, '2', 'ulala', '2017-08-24 16:13:02', NULL, NULL),
- (57, 3, 69, '1', NULL, '2', 'ulala', '2017-08-24 16:16:40', NULL, NULL),
- (58, 3, 70, '1', NULL, '2', 'ulala', '2017-08-24 16:17:16', NULL, NULL),
- (59, 3, 71, '1', NULL, '2', 'ulala', '2017-08-24 16:22:11', NULL, NULL),
- (60, 3, 72, '1', NULL, '2', 'ulala', '2017-08-24 16:29:54', NULL, NULL),
- (61, 3, 73, '1', NULL, '2', 'ulala', '2017-08-24 16:43:35', NULL, NULL),
- (62, 3, 74, '1', NULL, '2', 'ulala', '2017-08-24 16:51:22', NULL, NULL),
- (63, 3, 75, '1', NULL, '2', 'ulala', '2017-08-24 16:55:43', NULL, NULL),
- (64, 3, 76, '1', NULL, '2', 'ulala', '2017-08-26 03:32:52', NULL, NULL),
- (65, 3, 77, '1', NULL, '2', 'ulala', '2017-08-26 03:33:18', NULL, NULL),
- (66, 3, 78, '1', NULL, '2', 'ulala', '2017-08-26 03:43:50', NULL, NULL),
- (67, 3, 79, '1', NULL, '2', 'ulala', '2017-08-26 03:50:15', NULL, NULL),
- (68, 3, 80, '1', NULL, '2', 'ulala', '2017-08-26 04:15:28', NULL, NULL),
- (69, 3, 81, '1', NULL, '3', 'ulala', '2017-08-26 04:15:59', 'ulala', '2017-08-26 04:24:33'),
- (70, 3, 82, '1', NULL, '2', 'ulala', '2017-08-26 05:04:52', NULL, NULL),
- (71, 3, 83, '1', NULL, '1', 'ulala', '2017-08-26 07:08:14', NULL, NULL),
- (72, 3, 84, '1', NULL, '2', 'ulala', '2017-08-26 08:48:30', NULL, NULL),
- (73, 3, 85, '1', NULL, '2', 'ulala', '2017-08-26 08:55:39', NULL, NULL),
- (74, 3, 86, '1', NULL, '2', 'ulala', '2017-08-26 09:07:23', NULL, NULL),
- (75, 3, 87, '1', NULL, '2', 'ulala', '2017-08-27 19:18:16', NULL, NULL),
- (76, 3, 88, '1', NULL, '2', 'ulala', '2017-08-27 19:19:47', NULL, NULL),
- (77, 3, 89, '1', NULL, '2', 'ulala', '2017-08-28 11:50:28', 'ulala', '2017-08-28 11:51:25');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_lead_label`
- --
- CREATE TABLE `crm_lead_label` (
- `lead_label_id` int(11) NOT NULL,
- `lead_label_name` varchar(100) NOT NULL,
- `lead_label_status_score` int(11) NOT NULL COMMENT '0-100'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_lead_label`
- --
- INSERT INTO `crm_lead_label` (`lead_label_id`, `lead_label_name`, `lead_label_status_score`) VALUES
- (3, 'Hahaha', 50);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_modules`
- --
- CREATE TABLE `crm_modules` (
- `module_id` int(11) NOT NULL,
- `module_name` varchar(100) NOT NULL,
- `module_route` varchar(225) NOT NULL,
- `module_order` int(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_modules`
- --
- INSERT INTO `crm_modules` (`module_id`, `module_name`, `module_route`, `module_order`) VALUES
- (2, 'leads', 'leads', NULL),
- (3, 'opportunities', 'opportunities', NULL),
- (4, 'companies', 'companies', NULL),
- (5, 'contacts', 'contacts', NULL),
- (6, 'products', 'products', NULL),
- (7, 'campaigns', 'campaigns', NULL);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_opportunities`
- --
- CREATE TABLE `crm_opportunities` (
- `opportunity_id` int(11) NOT NULL,
- `opportunity_code` varchar(100) DEFAULT NULL,
- `opportunity_name` varchar(45) DEFAULT NULL,
- `opportunity_stage_id` int(11) NOT NULL,
- `company_id` int(11) NOT NULL,
- `opportunity_amount` double DEFAULT NULL,
- `opportunity_closing_date` datetime DEFAULT NULL,
- `opportunity_service` enum('1','2') DEFAULT NULL COMMENT '1= Product\n2=Campaign\n',
- `opportunity_campaign_id` int(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_opportunities`
- --
- INSERT INTO `crm_opportunities` (`opportunity_id`, `opportunity_code`, `opportunity_name`, `opportunity_stage_id`, `company_id`, `opportunity_amount`, `opportunity_closing_date`, `opportunity_service`, `opportunity_campaign_id`) VALUES
- (5, NULL, 'test', 2, 24, 9900, '2017-08-07 06:03:31', '1', NULL),
- (6, NULL, 'test', 2, 25, 9900, '2017-08-07 06:03:31', '1', NULL),
- (7, NULL, 'test', 2, 26, 9900, '2017-08-07 06:03:31', '1', NULL),
- (8, NULL, 'test', 2, 27, 9900, '2017-08-07 06:03:31', '1', NULL),
- (9, NULL, 'test', 2, 28, 9900, '2017-08-07 06:03:31', '1', NULL),
- (10, NULL, 'test', 2, 29, 9900, '2017-08-07 06:03:31', '1', NULL),
- (11, NULL, 'test', 2, 30, 9900, '2017-08-07 06:03:31', '1', NULL),
- (12, NULL, 'test', 2, 31, 9900, '2017-08-07 06:03:31', '1', NULL),
- (13, NULL, 'test', 2, 32, 9900, '2017-08-07 06:03:31', '1', NULL),
- (14, NULL, 'test', 2, 33, 9900, '2017-08-07 06:03:31', '1', NULL),
- (15, NULL, 'test', 2, 34, 9900, '2017-08-07 06:03:31', '1', NULL),
- (16, NULL, 'asd asd', 2, 35, 1234, '2017-08-21 00:00:00', '1', 9),
- (17, NULL, 'penawaran asus rog', 2, 36, 555, '2017-08-29 00:00:00', '2', 9),
- (18, NULL, 'penawaran yusuf', 2, 37, 50000, '2017-08-29 00:00:00', '1', 9),
- (19, NULL, 'git merge error', 2, 38, 123456, '2017-08-30 00:00:00', '1', 9),
- (20, NULL, 'Penawaran Laptop', 2, 39, 300000, '2017-08-23 00:00:00', '1', 9),
- (21, NULL, 'qwer', 2, 40, 99988, '2017-08-29 00:00:00', '1', 9),
- (22, NULL, 'apalah kamu ini', 2, 41, 444, '2017-08-29 00:00:00', '1', 9),
- (23, NULL, 'gfds', 2, 42, 555, '2017-08-29 00:00:00', '1', 9),
- (24, NULL, 'huuuuuuuuuuuuuuuuuuuu', 2, 43, 444, '2017-08-29 00:00:00', '1', 9),
- (25, NULL, 'ulala', 2, 44, 999, '2017-08-29 00:00:00', '1', 9),
- (27, NULL, 'cek', 2, 46, 2147483647, '2017-08-30 00:00:00', '1', 9),
- (29, NULL, 'test', 2, 46, 9900, '2017-08-07 06:03:31', '1', NULL),
- (35, NULL, 'test', 2, 24, 9900, '2017-08-07 06:03:31', '1', NULL),
- (37, NULL, 'test ke 200', 2, 45, 12345, '2017-08-23 00:00:00', '1', NULL),
- (38, NULL, 'test ke 201', 2, 45, 1234, '2017-08-29 00:00:00', '1', NULL),
- (39, 'OPR-081700001', 'test hiphop', 2, 45, 1000, '2017-08-29 00:00:00', '1', 11),
- (40, 'OPR-081700002', '205', 2, 41, 2000, '2017-08-30 00:00:00', '1', 11);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_opportunities_contacts`
- --
- CREATE TABLE `crm_opportunities_contacts` (
- `opportunity_id` int(11) NOT NULL,
- `contact_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_opportunities_contacts`
- --
- INSERT INTO `crm_opportunities_contacts` (`opportunity_id`, `contact_id`) VALUES
- (5, 30),
- (6, 31),
- (7, 32),
- (8, 33),
- (9, 37),
- (10, 44),
- (11, 45),
- (12, 46),
- (13, 63),
- (14, 64),
- (15, 66),
- (16, 73),
- (17, 74),
- (18, 75),
- (19, 76),
- (20, 77),
- (21, 78),
- (22, 79),
- (23, 80),
- (24, 81),
- (25, 82),
- (27, 84),
- (29, 86),
- (35, 92),
- (37, 94),
- (38, 95),
- (39, 96),
- (40, 97);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_opportunities_products`
- --
- CREATE TABLE `crm_opportunities_products` (
- `opportunity_id` int(11) NOT NULL,
- `product_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_opportunities_products`
- --
- INSERT INTO `crm_opportunities_products` (`opportunity_id`, `product_id`) VALUES
- (5, 5),
- (6, 5),
- (7, 5),
- (8, 5),
- (9, 5),
- (10, 5),
- (11, 5),
- (12, 5),
- (13, 5),
- (14, 5),
- (15, 5),
- (16, 2),
- (17, 5),
- (18, 2),
- (19, 2),
- (20, 5),
- (21, 2),
- (22, 5),
- (23, 2),
- (24, 5),
- (25, 2),
- (27, 2),
- (29, 5),
- (35, 5),
- (37, 2),
- (38, 2),
- (39, 5),
- (40, 2),
- (40, 5);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_opportunity_stage`
- --
- CREATE TABLE `crm_opportunity_stage` (
- `opportunity_stage_id` int(11) NOT NULL,
- `opportunity_stage_name` varchar(100) DEFAULT NULL,
- `opportunity_stage_status_score` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_opportunity_stage`
- --
- INSERT INTO `crm_opportunity_stage` (`opportunity_stage_id`, `opportunity_stage_name`, `opportunity_stage_status_score`) VALUES
- (2, 'Hahaha', 50),
- (3, 'Finish', 100),
- (4, 'snwed', 45);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_peoples`
- --
- CREATE TABLE `crm_peoples` (
- `people_id` int(11) NOT NULL,
- `people_salutation` enum('1','2','3') DEFAULT NULL,
- `people_first_name` varchar(100) NOT NULL,
- `people_last_name` varchar(100) DEFAULT NULL,
- `people_job_title` varchar(100) DEFAULT NULL,
- `people_company` varchar(100) DEFAULT NULL,
- `people_department` varchar(100) DEFAULT NULL,
- `people_email` varchar(100) DEFAULT NULL,
- `people_office_phone` varchar(30) DEFAULT NULL,
- `people_mobile_phone` varchar(30) DEFAULT NULL,
- `people_industry` int(11) DEFAULT NULL,
- `people_address1` varchar(255) DEFAULT NULL,
- `people_address2` varchar(255) DEFAULT NULL,
- `people_city` varchar(100) DEFAULT NULL,
- `people_state` varchar(100) DEFAULT NULL,
- `people_zip_code` varchar(10) DEFAULT NULL,
- `people_country` varchar(50) DEFAULT NULL,
- `people_source` int(11) NOT NULL,
- `people_photo` varchar(100) DEFAULT NULL,
- `people_status` enum('1','2') NOT NULL COMMENT '1=Lead\n2=Customer\n'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_peoples`
- --
- INSERT INTO `crm_peoples` (`people_id`, `people_salutation`, `people_first_name`, `people_last_name`, `people_job_title`, `people_company`, `people_department`, `people_email`, `people_office_phone`, `people_mobile_phone`, `people_industry`, `people_address1`, `people_address2`, `people_city`, `people_state`, `people_zip_code`, `people_country`, `people_source`, `people_photo`, `people_status`) VALUES
- (10, '1', 'Noval', 'Parinussa', 'Dev', 'Koding Next', 'Alalala', 'novalparinussa@gmail.com', '098773281', '08932719', 2, 'Kelapa gading', 'Puyuh Raya', 'Jakarta Utara', 'Jakarta', '123345', 'Indonesia', 2, NULL, '1'),
- (43, '2', 'hg', 'hg', 'as', 'KN', NULL, 'a@a.a', NULL, '123', 2, 'hghjk', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (44, '2', 'jhg', 'jhg', 'jhg', 'jhg', NULL, 'a@a.a', '123', '123', 2, 'jkl', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (45, '2', 'kj', 'lk', 'kj', 'ulala', NULL, 'a@a.a', NULL, '999', 2, 'jalan', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (46, '2', 'adi', 'putra', NULL, 'Contoh 4', NULL, 'asd@asd.asd', '132', '123', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (47, '1', 'fais', 'fais', NULL, 'Contoh', NULL, 'fais@fais.com', '132', '123', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (48, '1', 'qwerty', '123', NULL, 'Contoh 3', NULL, 'qwe@qwe.qwe', '132', '123', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (49, '1', 'qwerty', '123', NULL, 'Contoh 2', NULL, 'qwe@qwe.qwe', '132', '123', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (50, '1', 'qwerty', '123', NULL, 'Contoh', NULL, 'qwe@qwe.qwe', '132', '123', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (51, '1', 'fais', '2', NULL, 'Contoh 2', NULL, 'fais@fais.com', '132', '123', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (52, '1', 'noval', 'aja', NULL, 'lenovo', NULL, 'qwe@qwe.qwe', '132', '123', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (53, '1', 'adi', 'ida', NULL, 'asus', NULL, 'adi@asus.com', '132', '123', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (54, '1', 'asd', 'asd', NULL, 'msi', NULL, 'asd@asd.asd', '132', '123', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (55, '2', 'ali', 'baba', NULL, 'ASUS ROG', NULL, 'ali@baba.com', '222', '222', 2, 'qwerty', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (56, '2', 'yusuf', 'b', NULL, 'LG', NULL, 'yusuf@asd.asd', NULL, '999', 2, 'qwee', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (60, '1', 'asd', 'asd', 'asd', 'asd', 'asd', 'asd@asd.asd', '123', '123', 2, 'asd', 'asd', 'asd', 'asd', '123', 'asd', 2, NULL, '1'),
- (61, '1', 'asd', 'asd', 'asd', 'asd', 'asd', 'asd@asd.asd', '123', '123', 2, 'asd', 'asd', 'asd', 'asd', '123', 'asd', 2, NULL, '1'),
- (63, '2', 'qwe', 'qwe', NULL, 'asdasd', NULL, 'asd@asd.asd', NULL, '123', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (64, '2', 'Noval', 'Parinussa', NULL, 'Noval Corp', NULL, 'noval@bc.com', NULL, '085678765676', 2, 'Kelapa Puyuh', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (68, '2', 'asd', 'asd', NULL, 'asdasd5', NULL, 'asd@asd.asd', NULL, '123', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (69, '2', 'asd', 'asd', NULL, 'hahahahahaha', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asdasd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (70, '1', 'lalala', 'luluu', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asdasd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (71, '1', 'asd', 'asd', NULL, 'asd baru lagi', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asdasd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (72, '2', 'asd', 'asd', NULL, 'lalallalalalalalala pusing', NULL, 'asd@asd.asd', NULL, '23', 2, 'asadsd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (73, '1', 'ulala', 'houp', NULL, 'ulala houp comp', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asdasd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (74, '1', 'asdasd', 'asdasd', NULL, 'asd baru lagi nih hahaha', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asdasd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (75, '1', 'asdasd', 'asdasd', NULL, 'hahahahahaha', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asdasd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (76, '2', 'qwerty', '123', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asdasd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (77, '1', 'lalala', 'ulala', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asdasd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (78, '1', 'test', 'aja', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asdasd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (79, '1', 'test', '200', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asdasd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (80, '2', 'ardi', 'asd', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (81, '1', 'ardi', 'hairul', 'Gay Manager', 'Gay Property', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (82, '1', 'lllllllllllllllllllllllllllll', 'llllllllllllllllllllllll', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (83, '1', 'hip', 'hop', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (84, '1', '12345678', '91011', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (85, '1', 'test ke 200', 'bener', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (86, '1', 'test ke 201', 'bener', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (87, '1', 'ulala', 'hiphop', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (88, '1', 'test ke 205', 'lala', NULL, 'asd baru', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1'),
- (89, '1', 'coba', 'skip', NULL, 'company coba skip', NULL, 'asd@asd.asd', NULL, '1234', 2, 'asd', NULL, NULL, NULL, NULL, NULL, 2, NULL, '1');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_products`
- --
- CREATE TABLE `crm_products` (
- `product_id` int(11) NOT NULL,
- `product_name` varchar(100) DEFAULT NULL,
- `product_category_id` int(11) DEFAULT NULL,
- `product_description` text,
- `product_type` enum('1','2','3') NOT NULL COMMENT '1=Product\n2=Services\n3=Subscription\n',
- `product_price_frequency` enum('1','2','3') DEFAULT NULL COMMENT '1=One Time\n2=Monthly\n3=Annually ',
- `product_price` double NOT NULL DEFAULT '0',
- `product_status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '0=Non Aktif\n1=Aktif\n',
- `user_created` varchar(100) DEFAULT NULL,
- `user_created_date` datetime DEFAULT NULL,
- `user_modified` varchar(100) DEFAULT NULL,
- `user_modified_date` datetime DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_products`
- --
- INSERT INTO `crm_products` (`product_id`, `product_name`, `product_category_id`, `product_description`, `product_type`, `product_price_frequency`, `product_price`, `product_status`, `user_created`, `user_created_date`, `user_modified`, `user_modified_date`) VALUES
- (2, 'Edukasiku', 1, 'Lorem ipsum doler sit amet', '1', '1', 1000, '1', 'Admin', '2017-08-11 17:01:27', 'Admin', '2017-08-11 17:05:53'),
- (5, 'Macbook Pro 2015', 1, 'Lorem ipsum doler sit amet', '1', '1', 1000, '1', 'Admin', '2017-08-18 10:54:07', 'Admin', '2017-08-18 10:54:18');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_products_campaigns`
- --
- CREATE TABLE `crm_products_campaigns` (
- `product_id` int(11) NOT NULL,
- `campaign_id` int(11) NOT NULL,
- `discount_type` enum('1','2') DEFAULT NULL COMMENT '1=Percentage\n2=Fixed',
- `amount` double DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_products_campaigns`
- --
- INSERT INTO `crm_products_campaigns` (`product_id`, `campaign_id`, `discount_type`, `amount`) VALUES
- (2, 9, '1', 10),
- (2, 11, '2', 80000),
- (5, 9, '2', 500),
- (5, 11, '2', 9000);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_product_categories`
- --
- CREATE TABLE `crm_product_categories` (
- `category_id` int(11) NOT NULL,
- `category_name` varchar(100) NOT NULL,
- `category_status` enum('0','1') DEFAULT '1' COMMENT '0=non aktif\n1=aktif',
- `user_created` varchar(100) DEFAULT NULL,
- `user_created_date` datetime DEFAULT NULL,
- `user_modified` varchar(100) DEFAULT NULL,
- `user_modified_date` datetime DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_product_categories`
- --
- INSERT INTO `crm_product_categories` (`category_id`, `category_name`, `category_status`, `user_created`, `user_created_date`, `user_modified`, `user_modified_date`) VALUES
- (1, 'Category example', '1', 'Admin', '2017-08-11 17:01:15', 'Admin', '2017-08-11 17:10:26');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_roles`
- --
- CREATE TABLE `crm_roles` (
- `role_id` int(11) NOT NULL COMMENT 'User Administrator Hard Code All access module',
- `role_name` varchar(100) DEFAULT NULL,
- `status` enum('0','1') DEFAULT NULL,
- `user_created` varchar(100) DEFAULT NULL,
- `user_created_date` datetime DEFAULT NULL,
- `user_modified` varchar(100) DEFAULT NULL,
- `user_modified_date` datetime DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_roles`
- --
- INSERT INTO `crm_roles` (`role_id`, `role_name`, `status`, `user_created`, `user_created_date`, `user_modified`, `user_modified_date`) VALUES
- (1, 'Admin', '1', 'Admin', '2017-08-11 15:59:08', 'Admin', '2017-08-18 10:49:37'),
- (3, 'Marketing', '1', 'Admin', '2017-08-11 15:59:08', 'Admin', '2017-08-18 10:49:37');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_roles_modules`
- --
- CREATE TABLE `crm_roles_modules` (
- `crm_roles_role_id` int(11) NOT NULL,
- `crm_modules_module_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_roles_modules`
- --
- INSERT INTO `crm_roles_modules` (`crm_roles_role_id`, `crm_modules_module_id`) VALUES
- (1, 2),
- (1, 3),
- (1, 4),
- (1, 5),
- (1, 6),
- (1, 7);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_setup_company`
- --
- CREATE TABLE `crm_setup_company` (
- `company_id` int(11) NOT NULL,
- `company_name` varchar(225) NOT NULL,
- `company_email` varchar(225) DEFAULT NULL,
- `company_address1` varchar(225) NOT NULL,
- `company_address2` varchar(100) DEFAULT NULL,
- `company_city` varchar(225) NOT NULL,
- `company_state` varchar(225) NOT NULL,
- `company_zip_code` varchar(50) NOT NULL,
- `company_country` varchar(225) NOT NULL,
- `company_phone` varchar(50) DEFAULT NULL,
- `company_logo` varchar(100) DEFAULT NULL,
- `company_fax` varchar(50) DEFAULT NULL,
- `company_website` varchar(100) DEFAULT NULL,
- `company_initial_setting` enum('0','1') DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_setup_company`
- --
- INSERT INTO `crm_setup_company` (`company_id`, `company_name`, `company_email`, `company_address1`, `company_address2`, `company_city`, `company_state`, `company_zip_code`, `company_country`, `company_phone`, `company_logo`, `company_fax`, `company_website`, `company_initial_setting`) VALUES
- (1, 'Bangsa Cerdas', 'company@example.com', 'Puyuh raya', 'Kelapa Gading', 'Jakarta Utara', 'Indonesia', '142945', '', '087814043123', NULL, 'Fax example', 'www.example.com', '1');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_source`
- --
- CREATE TABLE `crm_source` (
- `source_id` int(11) NOT NULL,
- `source_name` varchar(100) NOT NULL,
- `user_created` varchar(100) DEFAULT NULL,
- `user_created_date` datetime DEFAULT NULL,
- `user_modified` varchar(100) DEFAULT NULL,
- `user_modified_date` datetime DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_source`
- --
- INSERT INTO `crm_source` (`source_id`, `source_name`, `user_created`, `user_created_date`, `user_modified`, `user_modified_date`) VALUES
- (2, 'Example source', 'Admin', '2017-08-11 16:00:13', NULL, NULL);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_terms`
- --
- CREATE TABLE `crm_terms` (
- `term_id` int(11) NOT NULL,
- `term_description` varchar(100) NOT NULL,
- `term_day` int(11) NOT NULL,
- `term_default` enum('0','1') DEFAULT '0' COMMENT '0=Not Default\n1=Default'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_terms`
- --
- INSERT INTO `crm_terms` (`term_id`, `term_description`, `term_day`, `term_default`) VALUES
- (1, 'D 10', 10, '1'),
- (2, 'D 15', 15, '0');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_users`
- --
- CREATE TABLE `crm_users` (
- `user_id` int(11) NOT NULL,
- `user_first_name` varchar(100) NOT NULL,
- `user_last_name` varchar(100) DEFAULT NULL,
- `user_job_title` varchar(50) DEFAULT NULL,
- `user_password` varchar(100) NOT NULL,
- `user_mobile` varchar(30) NOT NULL,
- `user_username` varchar(100) NOT NULL,
- `user_department` varchar(100) DEFAULT NULL,
- `user_email` varchar(100) NOT NULL,
- `user_photo` varchar(100) DEFAULT NULL,
- `user_status` enum('0','1') DEFAULT '1' COMMENT '0=Non-Aktif 1=Aktif',
- `user_group_id` int(11) NOT NULL,
- `user_manager_id` int(11) DEFAULT NULL,
- `user_role_id` int(11) NOT NULL,
- `user_created` varchar(100) DEFAULT NULL,
- `user_created_date` datetime DEFAULT NULL,
- `user_modified` varchar(100) DEFAULT NULL,
- `user_modified_date` datetime DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_users`
- --
- INSERT INTO `crm_users` (`user_id`, `user_first_name`, `user_last_name`, `user_job_title`, `user_password`, `user_mobile`, `user_username`, `user_department`, `user_email`, `user_photo`, `user_status`, `user_group_id`, `user_manager_id`, `user_role_id`, `user_created`, `user_created_date`, `user_modified`, `user_modified_date`) VALUES
- (9, 'Ulala', 'Houp', 'Dev', '$2a$10$SEgnnfD.6OQuEJWDpIqfo.tM64kwMJE7U3pbcq4aGRegV8UlGIHK6', '087813492348', 'ulala', 'Front End Dev', 'ualal@gmail.com', 'd96a4ddf-5530-40b0-a7c0-88fe6964b72c.jpeg', '1', 1, NULL, 1, 'Admin', '2017-08-11 17:18:36', 'Admin', '2017-08-19 01:59:52'),
- (15, 'Peter', 'Parker', 'Web Dev', '$2a$10$ZbvKmpBFDwMUNRoT8Er.jujs/kqjDZ3PZQrcvzxpTYIvgssCUYAwW', '087813499867', 'parker', 'Front End Dev', 'peter@par.com', '0ec55e78-a814-4760-b77a-9fd796473992.jpeg', '1', 3, NULL, 3, 'Admin', '2017-08-16 15:28:07', NULL, NULL),
- (17, 'ulala', 'Parker', 'Web Dev', '$2a$10$ZbvKmpBFDwMUNRoT8Er.jujs/kqjDZ3PZQrcvzxpTYIvgssCUYAwW', '087813499867', 'surali', 'Front End Dev', 'surali@par.com', '0ec55e78-a814-4760-b77a-9fd796473992.jpeg', '1', 3, NULL, 3, 'Admin', '2017-08-16 15:28:07', NULL, NULL);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_users_companies`
- --
- CREATE TABLE `crm_users_companies` (
- `company_id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_users_companies`
- --
- INSERT INTO `crm_users_companies` (`company_id`, `user_id`) VALUES
- (25, 9),
- (26, 9),
- (27, 9),
- (28, 9),
- (29, 9),
- (30, 9),
- (31, 9),
- (31, 15),
- (32, 9),
- (33, 9),
- (34, 9),
- (35, 9),
- (36, 9),
- (37, 9),
- (38, 9),
- (39, 9),
- (40, 9),
- (41, 9),
- (42, 9),
- (43, 9),
- (44, 9),
- (45, 9),
- (46, 9),
- (47, 9);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_users_contacts`
- --
- CREATE TABLE `crm_users_contacts` (
- `contact_id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_users_contacts`
- --
- INSERT INTO `crm_users_contacts` (`contact_id`, `user_id`) VALUES
- (31, 9),
- (32, 9),
- (33, 9),
- (37, 9),
- (44, 9),
- (45, 9),
- (46, 9),
- (46, 15),
- (63, 9),
- (64, 9),
- (66, 9),
- (73, 9),
- (74, 9),
- (75, 9),
- (76, 9),
- (77, 9),
- (78, 9),
- (79, 9),
- (80, 9),
- (81, 9),
- (82, 9),
- (83, 9),
- (84, 9),
- (85, 9),
- (86, 9),
- (87, 9),
- (88, 9),
- (89, 9),
- (90, 9),
- (91, 9),
- (92, 9),
- (93, 9),
- (94, 9),
- (95, 9),
- (96, 9),
- (97, 9),
- (98, 9);
- -- --------------------------------------------------------
- --
- -- Table structure for table `crm_users_leads`
- --
- CREATE TABLE `crm_users_leads` (
- `lead_id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `crm_users_leads`
- --
- INSERT INTO `crm_users_leads` (`lead_id`, `user_id`) VALUES
- (38, 9),
- (39, 9),
- (40, 9),
- (41, 9),
- (41, 15),
- (42, 9),
- (43, 9),
- (44, 9),
- (45, 9),
- (46, 9),
- (47, 9),
- (48, 9),
- (49, 9),
- (50, 9),
- (51, 9),
- (54, 9),
- (55, 9),
- (56, 9),
- (57, 9),
- (58, 9),
- (59, 9),
- (60, 9),
- (61, 9),
- (62, 9),
- (63, 9),
- (64, 9),
- (65, 9),
- (66, 9),
- (67, 9),
- (68, 9),
- (69, 9),
- (70, 9),
- (71, 9),
- (72, 9),
- (73, 9),
- (74, 9),
- (75, 9),
- (76, 9),
- (77, 9);
- -- --------------------------------------------------------
- --
- -- Table structure for table `lead_calls`
- --
- CREATE TABLE `lead_calls` (
- `lead_call_id` int(11) NOT NULL,
- `lead_call_title` varchar(100) DEFAULT NULL,
- `lead_call_duration` int(11) DEFAULT NULL,
- `lead_call_time` enum('1','2','3') DEFAULT '1' COMMENT '1= Second\n2= Minutes\n3=Hour\n',
- `lead_call_notes` text,
- `lead_call_date` datetime NOT NULL,
- `lead_call_user` varchar(100) NOT NULL,
- `lead_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `lead_files`
- --
- CREATE TABLE `lead_files` (
- `lead_files_id` int(11) NOT NULL,
- `lead_file_subject` varchar(100) DEFAULT NULL,
- `lead_file_to` varchar(100) NOT NULL,
- `lead_file_cc` varchar(100) DEFAULT NULL,
- `lead_file_description` text,
- `lead_file_name` varchar(100) NOT NULL,
- `lead_file_date` datetime NOT NULL,
- `lead_file_user` varchar(100) NOT NULL,
- `lead_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `lead_files`
- --
- INSERT INTO `lead_files` (`lead_files_id`, `lead_file_subject`, `lead_file_to`, `lead_file_cc`, `lead_file_description`, `lead_file_name`, `lead_file_date`, `lead_file_user`, `lead_id`) VALUES
- (18, 'asd', 'asd@asd.asd', 'ualal@gmail.com,peter@par.com', 'asd', 'ae087fa4-b62d-48f1-be23-d686828c49cb.jpg', '2017-08-25 03:54:23', 'ulala', 57),
- (19, 'asddd', 'asd@asd.asd', 'ualal@gmail.com', 'asddd', '675d1853-7689-462b-968e-a5dc586945b1.jpg', '2017-08-25 12:24:16', 'ulala', 57);
- -- --------------------------------------------------------
- --
- -- Table structure for table `lead_meeting`
- --
- CREATE TABLE `lead_meeting` (
- `lead_meeting_id` int(11) NOT NULL,
- `lead_meeting_name` varchar(100) DEFAULT NULL,
- `lead_meeting_location` varchar(255) DEFAULT NULL,
- `lead_meeting_start_date` datetime DEFAULT NULL,
- `lead_meeting_end_date` datetime DEFAULT NULL,
- `lead_meeting_description` text,
- `lead_meeting_date` datetime NOT NULL,
- `lead_meeting_user` varchar(100) NOT NULL,
- `lead_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `lead_meeting`
- --
- INSERT INTO `lead_meeting` (`lead_meeting_id`, `lead_meeting_name`, `lead_meeting_location`, `lead_meeting_start_date`, `lead_meeting_end_date`, `lead_meeting_description`, `lead_meeting_date`, `lead_meeting_user`, `lead_id`) VALUES
- (15, '2', '2', '2017-08-01 00:00:00', '2017-08-02 00:00:00', '222', '2017-08-23 20:20:52', 'ulala', 40),
- (16, 'qwerty', 'asdf', '2017-08-01 00:00:00', '2017-08-02 00:00:00', 'asdfg', '2017-08-24 10:26:42', 'ulala', 51),
- (17, 'lllgg', 'lllgg', '2017-08-25 00:00:00', '2017-08-10 00:00:00', 'ulalagg', '2017-08-25 09:44:07', 'ulala', 57),
- (18, 'asd', 'asd', '2017-08-10 00:00:00', '2017-08-10 00:00:00', 'asd', '2017-08-25 08:56:17', 'ulala', 57),
- (19, 'ulala coek', 'ulala', '2017-08-13 00:00:00', '2017-08-13 00:00:00', 'asd', '2017-08-25 09:16:59', 'ulala', 57),
- (20, 'asd', 'asd', '2017-08-29 00:00:00', '2017-08-29 00:00:00', 'asd', '2017-08-29 04:40:09', 'ulala', 71);
- -- --------------------------------------------------------
- --
- -- Table structure for table `lead_meeting_users`
- --
- CREATE TABLE `lead_meeting_users` (
- `lead_meeting_id` int(11) NOT NULL,
- `lead_user_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `lead_meeting_users`
- --
- INSERT INTO `lead_meeting_users` (`lead_meeting_id`, `lead_user_id`) VALUES
- (15, 15),
- (16, 15),
- (17, 15),
- (18, 9),
- (19, 15),
- (20, 15),
- (20, 17);
- -- --------------------------------------------------------
- --
- -- Table structure for table `lead_notes`
- --
- CREATE TABLE `lead_notes` (
- `lead_note_id` int(11) NOT NULL,
- `lead_note_name` varchar(100) NOT NULL,
- `lead_note_description` text,
- `lead_note_date` datetime NOT NULL,
- `lead_note_user` varchar(100) NOT NULL,
- `lead_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `lead_tasks`
- --
- CREATE TABLE `lead_tasks` (
- `lead_task_id` int(11) NOT NULL,
- `lead_task_name` varchar(100) NOT NULL,
- `lead_task_description` varchar(45) DEFAULT NULL,
- `lead_task_status` int(11) DEFAULT NULL,
- `lead_task_due_date` datetime DEFAULT NULL,
- `lead_task_date` datetime NOT NULL,
- `lead_task_user` varchar(100) NOT NULL,
- `lead_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `opportunity_calls`
- --
- CREATE TABLE `opportunity_calls` (
- `opportunity_call_id` int(11) NOT NULL,
- `opportunity_call_title` varchar(100) DEFAULT NULL,
- `opportunity_call_duration` int(11) DEFAULT NULL,
- `opportunity_call_time` enum('1','2','3') DEFAULT '1' COMMENT '1= Second\n2= Minutes\n3=Hour\n',
- `opportunity_call_notes` text,
- `opportunity_call_date` datetime NOT NULL,
- `opportunity_call_user` varchar(100) NOT NULL,
- `opportunity_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Table structure for table `opportunity_files`
- --
- CREATE TABLE `opportunity_files` (
- `opportunity_files_id` int(11) NOT NULL,
- `opportunity_file_subject` varchar(100) DEFAULT NULL,
- `opportunity_file_to` varchar(100) NOT NULL,
- `opportunity_file_cc` varchar(100) DEFAULT NULL,
- `opportunity_file_description` text,
- `opportunity_file_name` varchar(100) NOT NULL,
- `opportunity_file_date` datetime NOT NULL,
- `opportunity_file_user` varchar(100) NOT NULL,
- `opportunity_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `opportunity_files`
- --
- INSERT INTO `opportunity_files` (`opportunity_files_id`, `opportunity_file_subject`, `opportunity_file_to`, `opportunity_file_cc`, `opportunity_file_description`, `opportunity_file_name`, `opportunity_file_date`, `opportunity_file_user`, `opportunity_id`) VALUES
- (4, 'asdasd', 'novalparinussa@gmail.com,', 'ualal@gmail.com', 'asdasd', 'a5e6957a-768b-48db-8f9b-fd9e6b680b07.jpg', '2017-08-25 15:30:55', 'ulala', 5);
- -- --------------------------------------------------------
- --
- -- Table structure for table `opportunity_meeting`
- --
- CREATE TABLE `opportunity_meeting` (
- `opportunity_meeting_id` int(11) NOT NULL,
- `opportunity_meeting_name` varchar(100) DEFAULT NULL,
- `opportunity_meeting_location` varchar(255) DEFAULT NULL,
- `opportunity_meeting_start_date` datetime DEFAULT NULL,
- `opportunity_meeting_end_date` datetime DEFAULT NULL,
- `opportunity_meeting_description` text,
- `opportunity_meeting_date` datetime NOT NULL,
- `opportunity_meeting_user` varchar(100) NOT NULL,
- `opportunity_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `opportunity_meeting`
- --
- INSERT INTO `opportunity_meeting` (`opportunity_meeting_id`, `opportunity_meeting_name`, `opportunity_meeting_location`, `opportunity_meeting_start_date`, `opportunity_meeting_end_date`, `opportunity_meeting_description`, `opportunity_meeting_date`, `opportunity_meeting_user`, `opportunity_id`) VALUES
- (8, 'asdasd', 'asdasd', '2017-08-01 00:00:00', '2017-08-02 00:00:00', 'asdasd', '2017-08-25 09:59:28', 'ulala', 5);
- -- --------------------------------------------------------
- --
- -- Table structure for table `opportunity_meeting_users`
- --
- CREATE TABLE `opportunity_meeting_users` (
- `opportunity_meeting_id` int(11) NOT NULL,
- `opportunity_user_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `opportunity_meeting_users`
- --
- INSERT INTO `opportunity_meeting_users` (`opportunity_meeting_id`, `opportunity_user_id`) VALUES
- (8, 15);
- -- --------------------------------------------------------
- --
- -- Table structure for table `opportunity_notes`
- --
- CREATE TABLE `opportunity_notes` (
- `opportunity_note_id` int(11) NOT NULL,
- `opportunity_note_name` varchar(100) NOT NULL,
- `opportunity_note_description` text,
- `opportunity_note_date` datetime DEFAULT NULL,
- `opportunity_note_user` varchar(100) DEFAULT NULL,
- `opportunity_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `opportunity_notes`
- --
- INSERT INTO `opportunity_notes` (`opportunity_note_id`, `opportunity_note_name`, `opportunity_note_description`, `opportunity_note_date`, `opportunity_note_user`, `opportunity_id`) VALUES
- (3, 'ads', '<p>asd</p>', '2017-08-24 06:58:41', 'ulala', 5);
- -- --------------------------------------------------------
- --
- -- Table structure for table `opportunity_tasks`
- --
- CREATE TABLE `opportunity_tasks` (
- `opportunity_task_id` int(11) NOT NULL,
- `opportunity_task_name` varchar(100) NOT NULL,
- `opportunity_task_description` varchar(45) DEFAULT NULL,
- `opportunity_task_status` int(11) DEFAULT NULL,
- `opportunity_task_due_date` datetime DEFAULT NULL,
- `opportunity_task_date` datetime NOT NULL,
- `opportunity_task_user` varchar(100) NOT NULL,
- `opportunity_id` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `company_calls`
- --
- ALTER TABLE `company_calls`
- ADD PRIMARY KEY (`company_call_id`),
- ADD KEY `fk_company_calls_crm_company1_idx` (`company_id`);
- --
- -- Indexes for table `company_files`
- --
- ALTER TABLE `company_files`
- ADD PRIMARY KEY (`company_files_id`),
- ADD KEY `fk_company_files_crm_company1_idx` (`company_id`);
- --
- -- Indexes for table `company_meeting`
- --
- ALTER TABLE `company_meeting`
- ADD PRIMARY KEY (`company_meeting_id`),
- ADD KEY `fk_company_meeting_crm_company1_idx` (`company_id`);
- --
- -- Indexes for table `company_meeting_users`
- --
- ALTER TABLE `company_meeting_users`
- ADD PRIMARY KEY (`company_meeting_id`,`company_user_id`),
- ADD KEY `fk_company_meeting_has_crm_users_crm_users1_idx` (`company_user_id`),
- ADD KEY `fk_company_meeting_has_crm_users_company_meeting1_idx` (`company_meeting_id`);
- --
- -- Indexes for table `company_notes`
- --
- ALTER TABLE `company_notes`
- ADD PRIMARY KEY (`company_note_id`),
- ADD KEY `fk_company_notes_crm_company1_idx` (`company_id`);
- --
- -- Indexes for table `company_tasks`
- --
- ALTER TABLE `company_tasks`
- ADD PRIMARY KEY (`company_task_id`),
- ADD KEY `fk_company_tasks_crm_company1_idx` (`company_id`);
- --
- -- Indexes for table `contact_calls`
- --
- ALTER TABLE `contact_calls`
- ADD PRIMARY KEY (`contact_call_id`),
- ADD KEY `fk_customer_calls_crm_customers1_idx` (`contact_id`);
- --
- -- Indexes for table `contact_files`
- --
- ALTER TABLE `contact_files`
- ADD PRIMARY KEY (`contact_files_id`),
- ADD KEY `fk_customer_files_copy1_crm_customers1_idx` (`contact_id`);
- --
- -- Indexes for table `contact_meeting`
- --
- ALTER TABLE `contact_meeting`
- ADD PRIMARY KEY (`contact_meeting_id`),
- ADD KEY `fk_customer_meeting_crm_customers1_idx` (`contact_id`);
- --
- -- Indexes for table `contact_meeting_users`
- --
- ALTER TABLE `contact_meeting_users`
- ADD PRIMARY KEY (`contact_meeting_id`,`contact_user_id`),
- ADD KEY `fk_contact_meeting_has_crm_users_crm_users1_idx` (`contact_user_id`),
- ADD KEY `fk_contact_meeting_has_crm_users_contact_meeting1_idx` (`contact_meeting_id`);
- --
- -- Indexes for table `contact_notes`
- --
- ALTER TABLE `contact_notes`
- ADD PRIMARY KEY (`contact_note_id`),
- ADD KEY `fk_customer_notes_crm_customers1_idx` (`contact_id`);
- --
- -- Indexes for table `contact_tasks`
- --
- ALTER TABLE `contact_tasks`
- ADD PRIMARY KEY (`contact_task_id`),
- ADD KEY `fk_customer_tasks_crm_customers1_idx` (`contact_id`);
- --
- -- Indexes for table `crm_campaigns`
- --
- ALTER TABLE `crm_campaigns`
- ADD PRIMARY KEY (`campaign_id`);
- --
- -- Indexes for table `crm_companies`
- --
- ALTER TABLE `crm_companies`
- ADD PRIMARY KEY (`company_id`),
- ADD KEY `fk_crm_company_crm_industry1_idx` (`company_industry`),
- ADD KEY `fk_crm_company_crm_groups1_idx` (`company_groups`),
- ADD KEY `fk_crm_companies_crm_companies1_idx` (`company_parent`);
- --
- -- Indexes for table `crm_contacts`
- --
- ALTER TABLE `crm_contacts`
- ADD PRIMARY KEY (`contact_id`),
- ADD KEY `fk_crm_customer_crm_company1_idx` (`company_id`),
- ADD KEY `fk_crm_customer_crm_groups1_idx` (`contact_groups`),
- ADD KEY `fk_crm_customer_peoples1_idx` (`contact_id`),
- ADD KEY `fk_crm_contacts_crm_peoples1_idx` (`people_id`);
- --
- -- Indexes for table `crm_groups`
- --
- ALTER TABLE `crm_groups`
- ADD PRIMARY KEY (`group_id`);
- --
- -- Indexes for table `crm_industry`
- --
- ALTER TABLE `crm_industry`
- ADD PRIMARY KEY (`industry_id`);
- --
- -- Indexes for table `crm_invoices`
- --
- ALTER TABLE `crm_invoices`
- ADD PRIMARY KEY (`invoice_id`),
- ADD KEY `fk_crm_invoices_crm_terms1_idx` (`term_id`),
- ADD KEY `fk_crm_invoices_crm_companies1_idx` (`company_id`);
- --
- -- Indexes for table `crm_invoices_products`
- --
- ALTER TABLE `crm_invoices_products`
- ADD PRIMARY KEY (`invoice_detail_id`,`product_id`),
- ADD KEY `fk_crm_invoice_details_has_crm_products_crm_products1_idx` (`product_id`),
- ADD KEY `fk_crm_invoice_details_has_crm_products_crm_invoice_details_idx` (`invoice_detail_id`);
- --
- -- Indexes for table `crm_invoice_details`
- --
- ALTER TABLE `crm_invoice_details`
- ADD PRIMARY KEY (`invoice_detail_id`),
- ADD KEY `fk_crm_invoice_details_crm_invoices1_idx` (`invoice_id`);
- --
- -- Indexes for table `crm_leads`
- --
- ALTER TABLE `crm_leads`
- ADD PRIMARY KEY (`lead_id`),
- ADD KEY `fk_crm_leads_crm_lead_status1_idx` (`lead_label`),
- ADD KEY `fk_crm_leads_crm_groups1_idx` (`lead_groups`),
- ADD KEY `fk_crm_leads_crm_peoples1_idx` (`people_id`);
- --
- -- Indexes for table `crm_lead_label`
- --
- ALTER TABLE `crm_lead_label`
- ADD PRIMARY KEY (`lead_label_id`);
- --
- -- Indexes for table `crm_modules`
- --
- ALTER TABLE `crm_modules`
- ADD PRIMARY KEY (`module_id`);
- --
- -- Indexes for table `crm_opportunities`
- --
- ALTER TABLE `crm_opportunities`
- ADD PRIMARY KEY (`opportunity_id`),
- ADD KEY `fk_crm_opportunities_crm_opportunity_stage1_idx` (`opportunity_stage_id`),
- ADD KEY `fk_crm_opportunities_crm_companies1_idx` (`company_id`),
- ADD KEY `fk_crm_opportunities_crm_campaigns1_idx` (`opportunity_campaign_id`);
- --
- -- Indexes for table `crm_opportunities_contacts`
- --
- ALTER TABLE `crm_opportunities_contacts`
- ADD PRIMARY KEY (`opportunity_id`,`contact_id`),
- ADD KEY `fk_crm_opportunities_has_crm_contacts_crm_contacts1_idx` (`contact_id`),
- ADD KEY `fk_crm_opportunities_has_crm_contacts_crm_opportunities1_idx` (`opportunity_id`);
- --
- -- Indexes for table `crm_opportunities_products`
- --
- ALTER TABLE `crm_opportunities_products`
- ADD PRIMARY KEY (`opportunity_id`,`product_id`),
- ADD KEY `fk_crm_opportunities_has_crm_products_crm_products1_idx` (`product_id`),
- ADD KEY `fk_crm_opportunities_has_crm_products_crm_opportunities1_idx` (`opportunity_id`);
- --
- -- Indexes for table `crm_opportunity_stage`
- --
- ALTER TABLE `crm_opportunity_stage`
- ADD PRIMARY KEY (`opportunity_stage_id`);
- --
- -- Indexes for table `crm_peoples`
- --
- ALTER TABLE `crm_peoples`
- ADD PRIMARY KEY (`people_id`),
- ADD KEY `fk_peoples_crm_industry1_idx` (`people_industry`),
- ADD KEY `fk_peoples_crm_source1_idx` (`people_source`);
- --
- -- Indexes for table `crm_products`
- --
- ALTER TABLE `crm_products`
- ADD PRIMARY KEY (`product_id`),
- ADD KEY `crm_products_crm_product_categories_category_id_fk` (`product_category_id`);
- --
- -- Indexes for table `crm_products_campaigns`
- --
- ALTER TABLE `crm_products_campaigns`
- ADD PRIMARY KEY (`product_id`,`campaign_id`),
- ADD KEY `fk_crm_products_has_crm_campaigns_crm_campaigns1_idx` (`campaign_id`),
- ADD KEY `fk_crm_products_has_crm_campaigns_crm_products1_idx` (`product_id`);
- --
- -- Indexes for table `crm_product_categories`
- --
- ALTER TABLE `crm_product_categories`
- ADD PRIMARY KEY (`category_id`);
- --
- -- Indexes for table `crm_roles`
- --
- ALTER TABLE `crm_roles`
- ADD PRIMARY KEY (`role_id`);
- --
- -- Indexes for table `crm_roles_modules`
- --
- ALTER TABLE `crm_roles_modules`
- ADD PRIMARY KEY (`crm_roles_role_id`,`crm_modules_module_id`),
- ADD KEY `fk_crm_roles_has_crm_modules_crm_modules1_idx` (`crm_modules_module_id`),
- ADD KEY `fk_crm_roles_has_crm_modules_crm_roles1_idx` (`crm_roles_role_id`);
- --
- -- Indexes for table `crm_setup_company`
- --
- ALTER TABLE `crm_setup_company`
- ADD PRIMARY KEY (`company_id`);
- --
- -- Indexes for table `crm_source`
- --
- ALTER TABLE `crm_source`
- ADD PRIMARY KEY (`source_id`);
- --
- -- Indexes for table `crm_terms`
- --
- ALTER TABLE `crm_terms`
- ADD PRIMARY KEY (`term_id`);
- --
- -- Indexes for table `crm_users`
- --
- ALTER TABLE `crm_users`
- ADD PRIMARY KEY (`user_id`),
- ADD UNIQUE KEY `crm_users_user_email_uindex` (`user_email`),
- ADD KEY `crm_users_crm_groups_group_id_fk` (`user_group_id`),
- ADD KEY `fk_crm_users_crm_users1_idx` (`user_manager_id`),
- ADD KEY `fk_crm_users_crm_roles1_idx` (`user_role_id`);
- --
- -- Indexes for table `crm_users_companies`
- --
- ALTER TABLE `crm_users_companies`
- ADD PRIMARY KEY (`company_id`,`user_id`),
- ADD KEY `fk_crm_company_has_crm_users_crm_users1_idx` (`user_id`),
- ADD KEY `fk_crm_company_has_crm_users_crm_company1_idx` (`company_id`);
- --
- -- Indexes for table `crm_users_contacts`
- --
- ALTER TABLE `crm_users_contacts`
- ADD PRIMARY KEY (`contact_id`,`user_id`),
- ADD KEY `fk_crm_users_has_crm_customer_crm_customer1_idx` (`contact_id`),
- ADD KEY `fk_crm_users_has_crm_customer_crm_users1_idx` (`user_id`);
- --
- -- Indexes for table `crm_users_leads`
- --
- ALTER TABLE `crm_users_leads`
- ADD PRIMARY KEY (`lead_id`,`user_id`),
- ADD KEY `fk_crm_users_has_crm_leads_crm_leads1_idx` (`lead_id`),
- ADD KEY `fk_crm_users_has_crm_leads_crm_users1_idx` (`user_id`);
- --
- -- Indexes for table `lead_calls`
- --
- ALTER TABLE `lead_calls`
- ADD PRIMARY KEY (`lead_call_id`),
- ADD KEY `fk_lead_calls_crm_leads1_idx` (`lead_id`);
- --
- -- Indexes for table `lead_files`
- --
- ALTER TABLE `lead_files`
- ADD PRIMARY KEY (`lead_files_id`),
- ADD KEY `fk_lead_files_crm_leads1_idx` (`lead_id`);
- --
- -- Indexes for table `lead_meeting`
- --
- ALTER TABLE `lead_meeting`
- ADD PRIMARY KEY (`lead_meeting_id`),
- ADD KEY `fk_lead_meeting_crm_leads1_idx` (`lead_id`);
- --
- -- Indexes for table `lead_meeting_users`
- --
- ALTER TABLE `lead_meeting_users`
- ADD PRIMARY KEY (`lead_meeting_id`,`lead_user_id`),
- ADD KEY `fk_lead_meeting_has_crm_users_crm_users1_idx` (`lead_user_id`),
- ADD KEY `fk_lead_meeting_has_crm_users_lead_meeting1_idx` (`lead_meeting_id`);
- --
- -- Indexes for table `lead_notes`
- --
- ALTER TABLE `lead_notes`
- ADD PRIMARY KEY (`lead_note_id`),
- ADD KEY `fk_lead_notes_crm_leads1_idx` (`lead_id`);
- --
- -- Indexes for table `lead_tasks`
- --
- ALTER TABLE `lead_tasks`
- ADD PRIMARY KEY (`lead_task_id`),
- ADD KEY `fk_lead_task_crm_leads1_idx` (`lead_id`);
- --
- -- Indexes for table `opportunity_calls`
- --
- ALTER TABLE `opportunity_calls`
- ADD PRIMARY KEY (`opportunity_call_id`),
- ADD KEY `fk_opportunity_calls_crm_opportunities1_idx` (`opportunity_id`);
- --
- -- Indexes for table `opportunity_files`
- --
- ALTER TABLE `opportunity_files`
- ADD PRIMARY KEY (`opportunity_files_id`),
- ADD KEY `fk_opportunity_files_crm_opportunities1_idx` (`opportunity_id`);
- --
- -- Indexes for table `opportunity_meeting`
- --
- ALTER TABLE `opportunity_meeting`
- ADD PRIMARY KEY (`opportunity_meeting_id`),
- ADD KEY `fk_opportunity_meeting_crm_opportunities1_idx` (`opportunity_id`);
- --
- -- Indexes for table `opportunity_meeting_users`
- --
- ALTER TABLE `opportunity_meeting_users`
- ADD PRIMARY KEY (`opportunity_meeting_id`,`opportunity_user_id`),
- ADD KEY `fk_opportunity_meeting_has_crm_users_crm_users1_idx` (`opportunity_user_id`),
- ADD KEY `fk_opportunity_meeting_has_crm_users_opportunity_meeting1_idx` (`opportunity_meeting_id`);
- --
- -- Indexes for table `opportunity_notes`
- --
- ALTER TABLE `opportunity_notes`
- ADD PRIMARY KEY (`opportunity_note_id`),
- ADD KEY `fk_opportunity_notes_crm_opportunities1_idx` (`opportunity_id`);
- --
- -- Indexes for table `opportunity_tasks`
- --
- ALTER TABLE `opportunity_tasks`
- ADD PRIMARY KEY (`opportunity_task_id`),
- ADD KEY `fk_opportunity_tasks_crm_opportunities1_idx` (`opportunity_id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `company_calls`
- --
- ALTER TABLE `company_calls`
- MODIFY `company_call_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `company_files`
- --
- ALTER TABLE `company_files`
- MODIFY `company_files_id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `company_meeting`
- --
- ALTER TABLE `company_meeting`
- MODIFY `company_meeting_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
- --
- -- AUTO_INCREMENT for table `company_notes`
- --
- ALTER TABLE `company_notes`
- MODIFY `company_note_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `company_tasks`
- --
- ALTER TABLE `company_tasks`
- MODIFY `company_task_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `contact_calls`
- --
- ALTER TABLE `contact_calls`
- MODIFY `contact_call_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
- --
- -- AUTO_INCREMENT for table `contact_files`
- --
- ALTER TABLE `contact_files`
- MODIFY `contact_files_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `contact_meeting`
- --
- ALTER TABLE `contact_meeting`
- MODIFY `contact_meeting_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `contact_notes`
- --
- ALTER TABLE `contact_notes`
- MODIFY `contact_note_id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `contact_tasks`
- --
- ALTER TABLE `contact_tasks`
- MODIFY `contact_task_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `crm_campaigns`
- --
- ALTER TABLE `crm_campaigns`
- MODIFY `campaign_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
- --
- -- AUTO_INCREMENT for table `crm_companies`
- --
- ALTER TABLE `crm_companies`
- MODIFY `company_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;
- --
- -- AUTO_INCREMENT for table `crm_contacts`
- --
- ALTER TABLE `crm_contacts`
- MODIFY `contact_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99;
- --
- -- AUTO_INCREMENT for table `crm_groups`
- --
- ALTER TABLE `crm_groups`
- MODIFY `group_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
- --
- -- AUTO_INCREMENT for table `crm_industry`
- --
- ALTER TABLE `crm_industry`
- MODIFY `industry_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
- --
- -- AUTO_INCREMENT for table `crm_invoices`
- --
- ALTER TABLE `crm_invoices`
- MODIFY `invoice_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;
- --
- -- AUTO_INCREMENT for table `crm_invoice_details`
- --
- ALTER TABLE `crm_invoice_details`
- MODIFY `invoice_detail_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
- --
- -- AUTO_INCREMENT for table `crm_leads`
- --
- ALTER TABLE `crm_leads`
- MODIFY `lead_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;
- --
- -- AUTO_INCREMENT for table `crm_lead_label`
- --
- ALTER TABLE `crm_lead_label`
- MODIFY `lead_label_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
- --
- -- AUTO_INCREMENT for table `crm_modules`
- --
- ALTER TABLE `crm_modules`
- MODIFY `module_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
- --
- -- AUTO_INCREMENT for table `crm_opportunities`
- --
- ALTER TABLE `crm_opportunities`
- MODIFY `opportunity_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
- --
- -- AUTO_INCREMENT for table `crm_opportunity_stage`
- --
- ALTER TABLE `crm_opportunity_stage`
- MODIFY `opportunity_stage_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- --
- -- AUTO_INCREMENT for table `crm_peoples`
- --
- ALTER TABLE `crm_peoples`
- MODIFY `people_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90;
- --
- -- AUTO_INCREMENT for table `crm_products`
- --
- ALTER TABLE `crm_products`
- MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
- --
- -- AUTO_INCREMENT for table `crm_product_categories`
- --
- ALTER TABLE `crm_product_categories`
- MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `crm_roles`
- --
- ALTER TABLE `crm_roles`
- MODIFY `role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'User Administrator Hard Code All access module', AUTO_INCREMENT=4;
- --
- -- AUTO_INCREMENT for table `crm_setup_company`
- --
- ALTER TABLE `crm_setup_company`
- MODIFY `company_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `crm_source`
- --
- ALTER TABLE `crm_source`
- MODIFY `source_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
- --
- -- AUTO_INCREMENT for table `crm_terms`
- --
- ALTER TABLE `crm_terms`
- MODIFY `term_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
- --
- -- AUTO_INCREMENT for table `crm_users`
- --
- ALTER TABLE `crm_users`
- MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
- --
- -- AUTO_INCREMENT for table `lead_calls`
- --
- ALTER TABLE `lead_calls`
- MODIFY `lead_call_id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `lead_files`
- --
- ALTER TABLE `lead_files`
- MODIFY `lead_files_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
- --
- -- AUTO_INCREMENT for table `lead_meeting`
- --
- ALTER TABLE `lead_meeting`
- MODIFY `lead_meeting_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
- --
- -- AUTO_INCREMENT for table `lead_notes`
- --
- ALTER TABLE `lead_notes`
- MODIFY `lead_note_id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `lead_tasks`
- --
- ALTER TABLE `lead_tasks`
- MODIFY `lead_task_id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `opportunity_calls`
- --
- ALTER TABLE `opportunity_calls`
- MODIFY `opportunity_call_id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `opportunity_files`
- --
- ALTER TABLE `opportunity_files`
- MODIFY `opportunity_files_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- --
- -- AUTO_INCREMENT for table `opportunity_meeting`
- --
- ALTER TABLE `opportunity_meeting`
- MODIFY `opportunity_meeting_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
- --
- -- AUTO_INCREMENT for table `opportunity_notes`
- --
- ALTER TABLE `opportunity_notes`
- MODIFY `opportunity_note_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
- --
- -- AUTO_INCREMENT for table `opportunity_tasks`
- --
- ALTER TABLE `opportunity_tasks`
- MODIFY `opportunity_task_id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- Constraints for dumped tables
- --
- --
- -- Constraints for table `company_calls`
- --
- ALTER TABLE `company_calls`
- ADD CONSTRAINT `fk_company_calls_crm_company1` FOREIGN KEY (`company_id`) REFERENCES `crm_companies` (`company_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `company_files`
- --
- ALTER TABLE `company_files`
- ADD CONSTRAINT `fk_company_files_crm_company1` FOREIGN KEY (`company_id`) REFERENCES `crm_companies` (`company_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `company_meeting`
- --
- ALTER TABLE `company_meeting`
- ADD CONSTRAINT `fk_company_meeting_crm_company1` FOREIGN KEY (`company_id`) REFERENCES `crm_companies` (`company_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `company_meeting_users`
- --
- ALTER TABLE `company_meeting_users`
- ADD CONSTRAINT `fk_company_meeting_has_crm_users_company_meeting1` FOREIGN KEY (`company_meeting_id`) REFERENCES `company_meeting` (`company_meeting_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_company_meeting_has_crm_users_crm_users1` FOREIGN KEY (`company_user_id`) REFERENCES `crm_users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `company_notes`
- --
- ALTER TABLE `company_notes`
- ADD CONSTRAINT `fk_company_notes_crm_company1` FOREIGN KEY (`company_id`) REFERENCES `crm_companies` (`company_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `company_tasks`
- --
- ALTER TABLE `company_tasks`
- ADD CONSTRAINT `fk_company_tasks_crm_company1` FOREIGN KEY (`company_id`) REFERENCES `crm_companies` (`company_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `contact_calls`
- --
- ALTER TABLE `contact_calls`
- ADD CONSTRAINT `fk_customer_calls_crm_customers1` FOREIGN KEY (`contact_id`) REFERENCES `crm_contacts` (`contact_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `contact_files`
- --
- ALTER TABLE `contact_files`
- ADD CONSTRAINT `fk_customer_files_copy1_crm_customers1` FOREIGN KEY (`contact_id`) REFERENCES `crm_contacts` (`contact_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `contact_meeting`
- --
- ALTER TABLE `contact_meeting`
- ADD CONSTRAINT `fk_customer_meeting_crm_customers1` FOREIGN KEY (`contact_id`) REFERENCES `crm_contacts` (`contact_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `contact_meeting_users`
- --
- ALTER TABLE `contact_meeting_users`
- ADD CONSTRAINT `fk_contact_meeting_has_crm_users_contact_meeting1` FOREIGN KEY (`contact_meeting_id`) REFERENCES `contact_meeting` (`contact_meeting_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_contact_meeting_has_crm_users_crm_users1` FOREIGN KEY (`contact_user_id`) REFERENCES `crm_users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `contact_notes`
- --
- ALTER TABLE `contact_notes`
- ADD CONSTRAINT `fk_customer_notes_crm_customers1` FOREIGN KEY (`contact_id`) REFERENCES `crm_contacts` (`contact_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `contact_tasks`
- --
- ALTER TABLE `contact_tasks`
- ADD CONSTRAINT `fk_customer_tasks_crm_customers1` FOREIGN KEY (`contact_id`) REFERENCES `crm_contacts` (`contact_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_companies`
- --
- ALTER TABLE `crm_companies`
- ADD CONSTRAINT `fk_crm_companies_crm_companies1` FOREIGN KEY (`company_parent`) REFERENCES `crm_companies` (`company_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_company_crm_groups1` FOREIGN KEY (`company_groups`) REFERENCES `crm_groups` (`group_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_company_crm_industry1` FOREIGN KEY (`company_industry`) REFERENCES `crm_industry` (`industry_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_contacts`
- --
- ALTER TABLE `crm_contacts`
- ADD CONSTRAINT `fk_crm_contacts_crm_peoples1` FOREIGN KEY (`people_id`) REFERENCES `crm_peoples` (`people_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_customer_crm_company1` FOREIGN KEY (`company_id`) REFERENCES `crm_companies` (`company_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_customer_crm_groups1` FOREIGN KEY (`contact_groups`) REFERENCES `crm_groups` (`group_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_invoices`
- --
- ALTER TABLE `crm_invoices`
- ADD CONSTRAINT `fk_crm_invoices_crm_companies1` FOREIGN KEY (`company_id`) REFERENCES `crm_companies` (`company_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_invoices_crm_terms1` FOREIGN KEY (`term_id`) REFERENCES `crm_terms` (`term_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_invoices_products`
- --
- ALTER TABLE `crm_invoices_products`
- ADD CONSTRAINT `fk_crm_invoice_details_has_crm_products_crm_invoice_details1` FOREIGN KEY (`invoice_detail_id`) REFERENCES `crm_invoice_details` (`invoice_detail_id`),
- ADD CONSTRAINT `fk_crm_invoice_details_has_crm_products_crm_products1` FOREIGN KEY (`product_id`) REFERENCES `crm_products` (`product_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_invoice_details`
- --
- ALTER TABLE `crm_invoice_details`
- ADD CONSTRAINT `fk_crm_invoice_details_crm_invoices1` FOREIGN KEY (`invoice_id`) REFERENCES `crm_invoices` (`invoice_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_leads`
- --
- ALTER TABLE `crm_leads`
- ADD CONSTRAINT `fk_crm_leads_crm_groups1` FOREIGN KEY (`lead_groups`) REFERENCES `crm_groups` (`group_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_leads_crm_lead_status1` FOREIGN KEY (`lead_label`) REFERENCES `crm_lead_label` (`lead_label_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_leads_crm_peoples1` FOREIGN KEY (`people_id`) REFERENCES `crm_peoples` (`people_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_opportunities`
- --
- ALTER TABLE `crm_opportunities`
- ADD CONSTRAINT `fk_crm_opportunities_crm_campaigns1` FOREIGN KEY (`opportunity_campaign_id`) REFERENCES `crm_campaigns` (`campaign_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_opportunities_crm_companies1` FOREIGN KEY (`company_id`) REFERENCES `crm_companies` (`company_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_opportunities_crm_opportunity_stage1` FOREIGN KEY (`opportunity_stage_id`) REFERENCES `crm_opportunity_stage` (`opportunity_stage_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_opportunities_contacts`
- --
- ALTER TABLE `crm_opportunities_contacts`
- ADD CONSTRAINT `fk_crm_opportunities_has_crm_contacts_crm_contacts1` FOREIGN KEY (`contact_id`) REFERENCES `crm_contacts` (`contact_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_opportunities_has_crm_contacts_crm_opportunities1` FOREIGN KEY (`opportunity_id`) REFERENCES `crm_opportunities` (`opportunity_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_opportunities_products`
- --
- ALTER TABLE `crm_opportunities_products`
- ADD CONSTRAINT `fk_crm_opportunities_has_crm_products_crm_opportunities1` FOREIGN KEY (`opportunity_id`) REFERENCES `crm_opportunities` (`opportunity_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_opportunities_has_crm_products_crm_products1` FOREIGN KEY (`product_id`) REFERENCES `crm_products` (`product_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_peoples`
- --
- ALTER TABLE `crm_peoples`
- ADD CONSTRAINT `fk_peoples_crm_industry1` FOREIGN KEY (`people_industry`) REFERENCES `crm_industry` (`industry_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_peoples_crm_source1` FOREIGN KEY (`people_source`) REFERENCES `crm_source` (`source_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_products`
- --
- ALTER TABLE `crm_products`
- ADD CONSTRAINT `crm_products_crm_product_categories_category_id_fk` FOREIGN KEY (`product_category_id`) REFERENCES `crm_product_categories` (`category_id`);
- --
- -- Constraints for table `crm_products_campaigns`
- --
- ALTER TABLE `crm_products_campaigns`
- ADD CONSTRAINT `fk_crm_products_has_crm_campaigns_crm_campaigns1` FOREIGN KEY (`campaign_id`) REFERENCES `crm_campaigns` (`campaign_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_products_has_crm_campaigns_crm_products1` FOREIGN KEY (`product_id`) REFERENCES `crm_products` (`product_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_roles_modules`
- --
- ALTER TABLE `crm_roles_modules`
- ADD CONSTRAINT `fk_crm_roles_has_crm_modules_crm_modules1` FOREIGN KEY (`crm_modules_module_id`) REFERENCES `crm_modules` (`module_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_roles_has_crm_modules_crm_roles1` FOREIGN KEY (`crm_roles_role_id`) REFERENCES `crm_roles` (`role_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_users`
- --
- ALTER TABLE `crm_users`
- ADD CONSTRAINT `crm_users_crm_groups_group_id_fk` FOREIGN KEY (`user_group_id`) REFERENCES `crm_groups` (`group_id`),
- ADD CONSTRAINT `fk_crm_users_crm_roles1` FOREIGN KEY (`user_role_id`) REFERENCES `crm_roles` (`role_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_users_crm_users1` FOREIGN KEY (`user_manager_id`) REFERENCES `crm_users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_users_companies`
- --
- ALTER TABLE `crm_users_companies`
- ADD CONSTRAINT `fk_crm_company_has_crm_users_crm_company1` FOREIGN KEY (`company_id`) REFERENCES `crm_companies` (`company_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_company_has_crm_users_crm_users1` FOREIGN KEY (`user_id`) REFERENCES `crm_users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_users_contacts`
- --
- ALTER TABLE `crm_users_contacts`
- ADD CONSTRAINT `fk_crm_users_has_crm_customer_crm_customer1` FOREIGN KEY (`contact_id`) REFERENCES `crm_contacts` (`contact_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_users_has_crm_customer_crm_users1` FOREIGN KEY (`user_id`) REFERENCES `crm_users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `crm_users_leads`
- --
- ALTER TABLE `crm_users_leads`
- ADD CONSTRAINT `fk_crm_users_has_crm_leads_crm_leads1` FOREIGN KEY (`lead_id`) REFERENCES `crm_leads` (`lead_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_crm_users_has_crm_leads_crm_users1` FOREIGN KEY (`user_id`) REFERENCES `crm_users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `lead_calls`
- --
- ALTER TABLE `lead_calls`
- ADD CONSTRAINT `fk_lead_calls_crm_leads1` FOREIGN KEY (`lead_id`) REFERENCES `crm_leads` (`lead_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `lead_files`
- --
- ALTER TABLE `lead_files`
- ADD CONSTRAINT `fk_lead_files_crm_leads1` FOREIGN KEY (`lead_id`) REFERENCES `crm_leads` (`lead_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `lead_meeting`
- --
- ALTER TABLE `lead_meeting`
- ADD CONSTRAINT `fk_lead_meeting_crm_leads1` FOREIGN KEY (`lead_id`) REFERENCES `crm_leads` (`lead_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `lead_meeting_users`
- --
- ALTER TABLE `lead_meeting_users`
- ADD CONSTRAINT `fk_lead_meeting_has_crm_users_crm_users1` FOREIGN KEY (`lead_user_id`) REFERENCES `crm_users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_lead_meeting_has_crm_users_lead_meeting1` FOREIGN KEY (`lead_meeting_id`) REFERENCES `lead_meeting` (`lead_meeting_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `lead_notes`
- --
- ALTER TABLE `lead_notes`
- ADD CONSTRAINT `fk_lead_notes_crm_leads1` FOREIGN KEY (`lead_id`) REFERENCES `crm_leads` (`lead_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `lead_tasks`
- --
- ALTER TABLE `lead_tasks`
- ADD CONSTRAINT `fk_lead_task_crm_leads1` FOREIGN KEY (`lead_id`) REFERENCES `crm_leads` (`lead_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `opportunity_calls`
- --
- ALTER TABLE `opportunity_calls`
- ADD CONSTRAINT `fk_opportunity_calls_crm_opportunities1` FOREIGN KEY (`opportunity_id`) REFERENCES `crm_opportunities` (`opportunity_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `opportunity_files`
- --
- ALTER TABLE `opportunity_files`
- ADD CONSTRAINT `fk_opportunity_files_crm_opportunities1` FOREIGN KEY (`opportunity_id`) REFERENCES `crm_opportunities` (`opportunity_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `opportunity_meeting`
- --
- ALTER TABLE `opportunity_meeting`
- ADD CONSTRAINT `fk_opportunity_meeting_crm_opportunities1` FOREIGN KEY (`opportunity_id`) REFERENCES `crm_opportunities` (`opportunity_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `opportunity_meeting_users`
- --
- ALTER TABLE `opportunity_meeting_users`
- ADD CONSTRAINT `fk_opportunity_meeting_has_crm_users_crm_users1` FOREIGN KEY (`opportunity_user_id`) REFERENCES `crm_users` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- ADD CONSTRAINT `fk_opportunity_meeting_has_crm_users_opportunity_meeting1` FOREIGN KEY (`opportunity_meeting_id`) REFERENCES `opportunity_meeting` (`opportunity_meeting_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `opportunity_notes`
- --
- ALTER TABLE `opportunity_notes`
- ADD CONSTRAINT `fk_opportunity_notes_crm_opportunities1` FOREIGN KEY (`opportunity_id`) REFERENCES `crm_opportunities` (`opportunity_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- --
- -- Constraints for table `opportunity_tasks`
- --
- ALTER TABLE `opportunity_tasks`
- ADD CONSTRAINT `fk_opportunity_tasks_crm_opportunities1` FOREIGN KEY (`opportunity_id`) REFERENCES `crm_opportunities` (`opportunity_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
- COMMIT;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement