--
-- Table structure for table `accounts`
--

DROP TABLE IF EXISTS `accounts`;
CREATE TABLE IF NOT EXISTS `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) NOT NULL,
  `website` varchar(100) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `email_txt` varchar(100) NOT NULL,
  `city` varchar(255) NOT NULL,
  `section_id` int(11) NOT NULL,
  `comments` text NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`id`, `company_name`, `website`, `phone`, `email_txt`, `city`, `section_id`, `comments`, `created`, `modified`) VALUES
(1, 'test company 1', 'google.com', '5526574', 'bamat.ya@gmail.com', 'lalitpur', 2, 'dfsdfd', '2014-06-30 12:22:35', '2014-07-18 09:10:40'),
(2, 'test company sanepa', 'googlea.com', '234234324', 'ba.matya@gmail.com', 'kathmandu', 3, 'Tfdsasdfsdfdsf', '2014-06-30 12:57:22', '2014-06-30 12:57:22'),
(9, 'tes company 2', 'google.com.com', '234324324', 'b.am.atya@gmail.com', 'lalitpur', 4, 'asdfsdf', '2014-07-01 07:31:46', '2014-07-01 07:31:46'),
(10, 'account new edit', 'newacc.com.np edit', '234324324 edit', 'bama.tya@gmail.com', 'lalitpur', 3, 'tsfdfdsfsdfdsfdsfdsf', '2014-07-01 08:18:52', '2014-07-01 08:28:31'),
(11, 'food for living', 'foodforliving.com', '234234234', 'bamatya@gmail.com', 'lalitpur', 3, 'test', '2014-07-22 05:52:47', '2014-07-22 05:52:47');

-- --------------------------------------------------------

--
-- Table structure for table `activities`
--

DROP TABLE IF EXISTS `activities`;
CREATE TABLE IF NOT EXISTS `activities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `contact_person_id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `format` int(11) NOT NULL,
  `action_date` date NOT NULL,
  `action_time` time NOT NULL,
  `product_type` tinyint(2) NOT NULL,
  `amount` int(11) NOT NULL,
  `activity_type` int(11) NOT NULL COMMENT '1->Note,2->Callback,3->Proposal,4->Deal,5->Not Interested',
  `user_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `contact_person_id` (`contact_person_id`),
  KEY `activity_type` (`activity_type`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `activities`
--

INSERT INTO `activities` (`id`, `content`, `contact_person_id`, `account_id`, `format`, `action_date`, `action_time`, `product_type`, `amount`, `activity_type`, `user_id`, `project_id`, `created`, `modified`) VALUES
(1, 'This is deal for wine and dine', 17, 10, 2, '0000-00-00', '00:00:00', 2, 1000, 4, 3, 10, '2014-07-21 08:29:41', '2014-07-21 08:29:41'),
(2, 'This is second deal for wine an dine', 16, 10, 4, '0000-00-00', '00:00:00', 1, 1000, 4, 3, 10, '2014-07-21 08:30:03', '2014-07-21 08:30:03'),
(3, 'Just another deal for ECS', 1, 1, 1, '0000-00-00', '00:00:00', 1, 1000, 4, 4, 8, '2014-07-21 09:16:02', '2014-07-21 09:16:02'),
(4, 'this is first callback message', 17, 10, 1, '2014-07-02', '01:02:00', 0, 0, 2, 3, 10, '2014-07-21 13:11:07', '2014-07-21 13:11:07'),
(5, 'this is note', 14, 9, 1, '0000-00-00', '00:00:00', 0, 0, 1, 2, 10, '2014-07-22 05:51:07', '2014-07-22 05:51:07'),
(6, 'this is callback', 14, 9, 3, '2014-07-02', '14:00:00', 0, 0, 2, 2, 10, '2014-07-22 05:51:22', '2014-07-22 05:51:22'),
(7, 'this is proposal tes company 2', 15, 9, 1, '0000-00-00', '00:00:00', 0, 0, 3, 2, 10, '2014-07-22 05:53:35', '2014-07-22 05:51:35'),
(8, 'This is deal for tes comapny', 14, 9, 1, '0000-00-00', '00:00:00', 1, 2000, 4, 2, 10, '2014-07-22 05:51:47', '2014-07-22 05:51:47'),
(9, 'not interested', 15, 9, 3, '0000-00-00', '00:00:00', 0, 0, 5, 2, 10, '2014-07-22 05:51:58', '2014-07-22 05:51:58'),
(10, 'This i second deal', 14, 9, 1, '0000-00-00', '00:00:00', 1, 10000, 4, 2, 10, '2014-07-22 05:53:23', '2014-07-22 05:53:23'),
(11, 'This is third deal', 14, 9, 2, '0000-00-00', '00:00:00', 1, 2000, 4, 2, 10, '2014-07-22 05:54:23', '2014-07-22 05:54:23'),
(12, 'this is fourth deal', 14, 9, 1, '0000-00-00', '00:00:00', 1, 2000, 4, 2, 10, '2014-07-22 06:08:53', '2014-07-22 06:08:53');



--
-- Table structure for table `accounts_projects`
--

DROP TABLE IF EXISTS `accounts_projects`;
CREATE TABLE IF NOT EXISTS `accounts_projects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `accounts_projects`
--

INSERT INTO `accounts_projects` (`id`, `account_id`, `project_id`, `created`, `modified`) VALUES
(1, 9, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 10, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 10, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 1, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 1, 8, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 9, 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 10, 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 11, 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `projects`
--

DROP TABLE IF EXISTS `projects`;
CREATE TABLE IF NOT EXISTS `projects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_name` varchar(255) NOT NULL,
  `production_date` date NOT NULL,
  `publication_date` date NOT NULL,
  `target` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `project_name`, `production_date`, `publication_date`, `target`, `created`, `modified`) VALUES
(1, 'project test 1', '2014-07-24', '2014-07-31', 33333, '2014-06-27 10:28:16', '2014-07-16 09:51:46'),
(2, 'project test 2', '2014-06-10', '2014-06-25', 2000, '2014-06-30 07:33:45', '2014-06-30 07:33:45'),
(8, 'ECS', '2014-07-02', '2014-07-31', 34334, '2014-07-18 08:14:12', '2014-07-18 08:14:12'),
(10, 'wine and dine', '2014-07-02', '2014-07-23', 3333333, '2014-07-18 12:52:03', '2014-07-18 12:52:03');