-- phpMyAdmin SQL Dump -- version 2.6.0-alpha1 -- http://www.phpmyadmin.net -- -- Host: 192.168.1.19 -- Generation Time: Jun 11, 2004 at 01:55 PM -- Server version: 4.1.1 -- PHP Version: 4.3.6 -- -- Database : `leads` -- -- -------------------------------------------------------- -- -- Table structure for table `salesperson` -- CREATE TABLE `salesperson` ( `email` varchar(60) NOT NULL default '', `phone` varchar(15) NOT NULL default '', `fax` varchar(15) default NULL, `website` varchar(30) default NULL, `contact_last_name` varchar(30) default NULL, `balance` double NOT NULL default '0', `address2` varchar(100) default NULL, `city` varchar(20) default NULL, `state` char(3) default NULL, `zip` varchar(10) default NULL, `country` varchar(20) default NULL, `address1` varchar(100) default NULL, `contact_first_name` varchar(30) default NULL, `other_phone` varchar(15) default NULL, `id` bigint(20) default NULL, `aff_percentage` decimal(10,0) NOT NULL default '0', `lead_percentage` decimal(10,0) default '0', `register_credit` double default '0', `buylead_credit` double default '0', `member_registers` double NOT NULL default '0', `member_buy_lead` double NOT NULL default '0', `member_percentage` decimal(10,0) NOT NULL default '0', `sales_registers` double NOT NULL default '0', `sales_percentage` decimal(10,0) NOT NULL default '0', `login` varchar(10) NOT NULL default '', `password` varchar(10) NOT NULL default '', `valid` tinyint(4) NOT NULL default '0', `default_prices` tinyint(4) default '1', `salesman_id` bigint(20) NOT NULL default '0', UNIQUE KEY `id_affiliate_ukey` (`id`), KEY `id_affiliate_key` (`id`) ) TYPE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `salesperson` -- INSERT INTO `salesperson` VALUES ('email@mail2.com', '111-222-3333', '', 'dev', 'MENUEL', 367.2235, 'addr2', 'city', 'AK', '12345', 'USA', 'addr1', 'olivier', '222-222-2222', 2277, 10, 0, 0, 0, 0, 0, 10, 0, 10, 'olivier1', 'olivier1', 1, 1, 2285); INSERT INTO `salesperson` VALUES ('email@mail.com', '111-111-1111', '', 'dev', 'last2', 1.462, '', 'city', 'AK', '11111', 'USA', 'address', 'first2', '', 2281, 10, 0, 0, 0, 0, 0, 10, 12, 10, 'olivier2', 'olivier2', 0, 0, 0); INSERT INTO `salesperson` VALUES ('sales@man.com', '', '', 'dev', 'LastSalesMan', 0.195, 'addr2', 'city', 'FL', '12345', 'USA', 'addr1', 'firstSalesman', '', 2285, 10, 0, 0, 0, 0, 0, 10, 0, 10, 'olivier3', 'olivier3', 1, 1, 0); INSERT INTO `salesperson` VALUES ('sales@man2.com', '', '', 'dev', 'LastSalesMan2', 0, 'addr2', 'city', 'FL', '12345', 'USA', 'addr1', 'firstSalesman2', '', 2289, 10, 0, 0, 0, 0, 0, 10, 0, 10, 'olivier4', 'olivier4', 0, 1, 0); INSERT INTO `salesperson` VALUES ('olivierm3@silesky.com', '222-222-2222', '', 'dev', 'last', 0, '', 'city', 'AL', '11111', 'USA', 'adr', 'first', '', 2943, 10, 0, 0, 0, 0, 0, 10, 0, 10, 'olivier', 'Y3a4ADeQ', 0, 1, 0); INSERT INTO `salesperson` VALUES ('olivierm@silesky.com', '111-111-1111', '', 'dev', 'last', 0, '', 'city', 'AZ', '11111', 'USA', 'adr1', 'first2', '', 2955, 10, 0, 0, 0, 0, 0, 10, 0, 10, 'olivier41', 'putUPedy', 1, 1, 0); INSERT INTO `salesperson` VALUES ('ol@wqrq.fsd', '111-222-3333', '', 'dev', 'vier', 0, '', 'city', 'AL', '11111', 'USA', '132', 'oli', '', 2961, 10, 0, 0, 0, 0, 0, 10, 0, 10, 'oli123', 'ruTUgety', 0, 1, 0); INSERT INTO `salesperson` VALUES ('test@test.com', '111-222-3333', '', 'dev', 'men', 0, '', 'city', 'AZ', '11111', 'USA', 'address', 'oli', '', 2967, 10, 0, 0, 0, 0, 0, 10, 0, 10, 'testtest', 'qaMaVuGE', 1, 1, 0); INSERT INTO `salesperson` VALUES ('ol@in.com2', '111-222-3333', '', 'dev', 'm!', 243, '', 'city', 'DC', '12345', 'USA', 'address', 'olivier!!!', '', 2973, 10, 0, 15, 0, 40, 0, 0, 5, 10, 'olivier31', 'olivier31', 1, 0, 2979); INSERT INTO `salesperson` VALUES ('oli@test.test', '111-222-3333', '', 'dev', 'last', 24.25, '', 'city', 'SC', '11111', 'USA', 'address', 'first', '', 2979, 10, 0, 0, 0, 0, 0, 10, 0, 10, 'olivier32', 'olivier32', 1, 1, 2277); INSERT INTO `salesperson` VALUES ('ff@ff.ff', '111-222-3333', '', 'dev', 'menuel', 0, '', 'city', 'GA', '11111', 'USA', 'adr', 'oli', '', 2985, 10, 0, 0, 0, 0, 0, 10, 0, 10, 'olivier512', '9URuHYhY', 1, 1, 2973); -- -------------------------------------------------------- -- -- Table structure for table `trans_salesperson` -- CREATE TABLE `trans_salesperson` ( `id` int(11) NOT NULL auto_increment, `date` timestamp NOT NULL, `amount` double NOT NULL default '0', `comment` varchar(70) default NULL, `rate` double default NULL, `percentage` char(1) default NULL, `affiliate_id` bigint(20) NOT NULL default '0', `salesman_id` bigint(20) NOT NULL default '0', `user_id` bigint(20) default NULL, `user_type` varchar(20) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=132 ; -- -- Dumping data for table `trans_salesperson` -- INSERT INTO `trans_salesperson` VALUES (131, 2004-06-11 12:21:46, 0.04, 'Salesperson (2277) earned $ 0.4', 10, '%', 0, 2285, 2277, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (128, 2004-06-11 12:21:46, 40, 'Member subscribed : first last (2351342)', 40, '$', 0, 2973, 2351342, 'member'); INSERT INTO `trans_salesperson` VALUES (127, 2004-06-11 12:21:21, 0.04, 'Salesperson (2277) earned $ 0.4', 10, '%', 0, 2285, 2277, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (126, 2004-06-11 12:21:21, 0.4, 'Salesperson (2979) earned $ 4', 10, '%', 0, 2277, 2979, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (125, 2004-06-11 12:21:21, 4, 'Salesperson (2973) earned $ 40', 10, '%', 0, 2979, 2973, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (124, 2004-06-11 12:21:21, 40, 'Member subscribed : first last (2351342)', 40, '$', 0, 2973, 2351342, 'member'); INSERT INTO `trans_salesperson` VALUES (123, 2004-06-11 12:21:04, 0.04, 'Salesperson (2277) earned $ 0.4', 10, '%', 0, 2285, 2277, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (122, 2004-06-11 12:21:04, 0.4, 'Salesperson (2979) earned $ 4', 10, '%', 0, 2277, 2979, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (121, 2004-06-11 12:21:04, 4, 'Salesperson (2973) earned $ 40', 10, '%', 0, 2979, 2973, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (120, 2004-06-11 12:21:04, 40, 'Member subscribed : first last (2351342)', 40, '$', 0, 2973, 2351342, 'member'); INSERT INTO `trans_salesperson` VALUES (130, 2004-06-11 12:21:46, 0.4, 'Salesperson (2979) earned $ 4', 10, '%', 0, 2277, 2979, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (129, 2004-06-11 12:21:46, 4, 'Salesperson (2973) earned $ 40', 10, '%', 0, 2979, 2973, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (119, 2004-06-11 12:20:21, 0.04, 'Salesperson (2277) earned $ 0.4', 10, '%', 0, 2285, 2277, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (118, 2004-06-11 12:20:21, 0.4, 'Salesperson (2979) earned $ 4', 10, '%', 0, 2277, 2979, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (117, 2004-06-11 12:20:21, 4, 'Salesperson (2973) earned $ 40', 10, '%', 0, 2979, 2973, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (116, 2004-06-11 12:20:21, 40, 'Member subscribed : first last (2351342)', 40, '$', 0, 2973, 2351342, 'member'); INSERT INTO `trans_salesperson` VALUES (115, 2004-06-11 11:13:20, 0.015, 'Salesperson (2277) earned $ 0.15', 10, '%', 0, 2285, 2277, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (114, 2004-06-11 11:13:20, 0.15, 'Salesperson (2979) earned $ 1.5', 10, '%', 0, 2277, 2979, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (113, 2004-06-11 11:13:20, 1.5, 'Salesperson (2973) earned $ 15', 10, '%', 0, 2979, 2973, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (111, 2004-06-11 10:27:00, 0.02, 'Salesperson (2277) earned $ 0.2', 10, '%', 0, 2285, 2277, 'salesperson'); INSERT INTO `trans_salesperson` VALUES (110, 2004-06-11 10:27:00, 0.2, '1 lead(s) submitted by 29867 (upload)', 10, '%', 0, 2277, 29867, 'affiliate'); INSERT INTO `trans_salesperson` VALUES (108, 2004-06-11 10:22:28, 10, '', NULL, NULL, 0, 2277, NULL, NULL); INSERT INTO `trans_salesperson` VALUES (112, 2004-06-11 11:13:20, 15, 'Affiliate subscribed : oli menuel (1121298)', 15, '$', 0, 2973, 1121298, 'affiliate');