API tools faq
paste
View difference between Paste ID: kzwgHmnT and DDq2Yied
SHOW: | | - or go back to the newest paste.
1
--
2
-- Table structure for table `accounts`
3
--
4
5
DROP TABLE IF EXISTS `accounts`;

6
CREATE TABLE IF NOT EXISTS `accounts` (

7
  `id` int(11) NOT NULL AUTO_INCREMENT,

8
  `company_name` varchar(255) NOT NULL,

9
  `website` varchar(100) NOT NULL,

10
  `phone` varchar(100) NOT NULL,

11
  `email_txt` varchar(100) NOT NULL,

12
  `city` varchar(255) NOT NULL,

13
  `section_id` int(11) NOT NULL,

14
  `comments` text NOT NULL,

15
  `created` datetime NOT NULL,

16
  `modified` datetime NOT NULL,

17
  PRIMARY KEY (`id`)

18
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

19
20
--

21
-- Dumping data for table `accounts`

22
--

23
24
INSERT INTO `accounts` (`id`, `company_name`, `website`, `phone`, `email_txt`, `city`, `section_id`, `comments`, `created`, `modified`) VALUES

25
(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'),

26
(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'),

27
(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'),

28
(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'),

29
(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');

30
31
-- --------------------------------------------------------

32
33
--

34
-- Table structure for table `activities`

35
--

36
37
DROP TABLE IF EXISTS `activities`;

38
CREATE TABLE IF NOT EXISTS `activities` (

39
  `id` int(11) NOT NULL AUTO_INCREMENT,

40
  `content` text NOT NULL,

41
  `contact_person_id` int(11) NOT NULL,

42
  `account_id` int(11) NOT NULL,

43
  `format` int(11) NOT NULL,

44
  `action_date` date NOT NULL,

45
  `action_time` time NOT NULL,

46
  `product_type` tinyint(2) NOT NULL,

47
  `amount` int(11) NOT NULL,

48
  `activity_type` int(11) NOT NULL COMMENT '1->Note,2->Callback,3->Proposal,4->Deal,5->Not Interested',

49
  `user_id` int(11) NOT NULL,

50
  `project_id` int(11) NOT NULL,

51
  `created` datetime NOT NULL,

52
  `modified` datetime NOT NULL,

53
  PRIMARY KEY (`id`),

54
  KEY `contact_person_id` (`contact_person_id`),

55
  KEY `activity_type` (`activity_type`)

56
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

57
58
--

59
-- Dumping data for table `activities`

60
--

61
62
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

63
(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'),

64
(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'),

65
(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'),

66
(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'),

67
(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'),

68
(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'),

69
(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'),

70
(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'),

71
(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'),

72
(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'),

73
(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'),

74
(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');

75-
(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');
75+
76
77
78
--

79
-- Table structure for table `accounts_projects`

80
--

81
82
DROP TABLE IF EXISTS `accounts_projects`;

83
CREATE TABLE IF NOT EXISTS `accounts_projects` (

84
  `id` int(11) NOT NULL AUTO_INCREMENT,

85
  `account_id` int(11) NOT NULL,

86
  `project_id` int(11) NOT NULL,

87
  `created` datetime NOT NULL,

88
  `modified` datetime NOT NULL,

89
  PRIMARY KEY (`id`)

90
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

91
92
--

93
-- Dumping data for table `accounts_projects`

94
--

95
96
INSERT INTO `accounts_projects` (`id`, `account_id`, `project_id`, `created`, `modified`) VALUES

97
(1, 9, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),

98
(2, 10, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),

99
(3, 10, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),

100
(4, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),

101
(5, 1, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),

102
(6, 1, 8, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),

103
(7, 9, 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),

104
(8, 10, 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),

105
(9, 11, 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

106
107
-- --------------------------------------------------------

108
109
--

110
-- Table structure for table `projects`

111
--

112
113
DROP TABLE IF EXISTS `projects`;

114
CREATE TABLE IF NOT EXISTS `projects` (

115
  `id` int(11) NOT NULL AUTO_INCREMENT,

116
  `project_name` varchar(255) NOT NULL,

117
  `production_date` date NOT NULL,

118
  `publication_date` date NOT NULL,

119
  `target` int(11) NOT NULL,

120
  `created` datetime NOT NULL,

121
  `modified` datetime NOT NULL,

122
  PRIMARY KEY (`id`)

123
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

124
125
--

126
-- Dumping data for table `projects`

127
--

128
129
INSERT INTO `projects` (`id`, `project_name`, `production_date`, `publication_date`, `target`, `created`, `modified`) VALUES

130
(1, 'project test 1', '2014-07-24', '2014-07-31', 33333, '2014-06-27 10:28:16', '2014-07-16 09:51:46'),

131
(2, 'project test 2', '2014-06-10', '2014-06-25', 2000, '2014-06-30 07:33:45', '2014-06-30 07:33:45'),

132
(8, 'ECS', '2014-07-02', '2014-07-31', 34334, '2014-07-18 08:14:12', '2014-07-18 08:14:12'),

133
(10, 'wine and dine', '2014-07-02', '2014-07-23', 3333333, '2014-07-18 12:52:03', '2014-07-18 12:52:03');
        

    


            


                                


        

            



                
    

        Public Pastes
    

    
            

    

                    

        

    





    


    
    
    
    
    
    
    
    




    


    



                

            We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.             OK, I Understand
        

    
                

            

                
                    
                
            

            

                Not a member of Pastebin yet?

                Sign Up, it unlocks many cool features!