-- phpMyAdmin SQL Dump -- version 2.11.6 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Oct 12, 2009 at 05:17 AM -- Server version: 5.0.51 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `getkidscoach` -- -- -------------------------------------------------------- -- -- Table structure for table `admin_master` -- CREATE TABLE `admin_master` ( `admin_master_id` int(10) NOT NULL auto_increment, `user_type` enum('1','2','3') NOT NULL, `admin_dt` datetime NOT NULL, `admin_nickname` varchar(50) NOT NULL, `admin_password` varchar(50) NOT NULL, `admin_first_name` varchar(50) NOT NULL, `admin_last_name` varchar(50) NOT NULL, `admin_email` varchar(100) NOT NULL, `admin_company` varchar(100) NOT NULL, `admin_image` varchar(150) NOT NULL, `admin_add` varchar(200) NOT NULL, `admin_city` varchar(50) NOT NULL, `admin_state` varchar(50) NOT NULL, `admin_zip` varchar(10) NOT NULL, `admin_country` varchar(50) NOT NULL, `admin_website` varchar(100) NOT NULL, `admin_bio` varchar(250) NOT NULL, `campaign_number` varchar(200) NOT NULL, `admin_contact_per` varchar(100) NOT NULL, `admin_contact_phone` varchar(100) NOT NULL, `allow_to_log_in_to_site` enum('N','Y') NOT NULL, `is_deleted_admin_profile` enum('N','Y') NOT NULL, `is_modification_approved` enum('N','Y') NOT NULL, `admin_contact_email` varchar(100) NOT NULL, `email_verified` enum('N','Y') NOT NULL, `admin_last_log` datetime NOT NULL, `admin_no_of_log` varchar(10) NOT NULL, PRIMARY KEY (`admin_master_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `admin_master` -- INSERT INTO `admin_master` (`admin_master_id`, `user_type`, `admin_dt`, `admin_nickname`, `admin_password`, `admin_first_name`, `admin_last_name`, `admin_email`, `admin_company`, `admin_image`, `admin_add`, `admin_city`, `admin_state`, `admin_zip`, `admin_country`, `admin_website`, `admin_bio`, `campaign_number`, `admin_contact_per`, `admin_contact_phone`, `allow_to_log_in_to_site`, `is_deleted_admin_profile`, `is_modification_approved`, `admin_contact_email`, `email_verified`, `admin_last_log`, `admin_no_of_log`) VALUES (1, '1', '2009-10-10 17:09:57', 'pinal', 'pinal', 'pinal', 'patel', 'pinalpatel1087@yahoo.com', 'CP Infosys', '', 'Bapunagar', 'Ahmedabad', 'Gujarat', '6787878', 'India', 'cpinfosys.com', 'jkhkjhk', '7888979', '98797', '9426409309', 'Y', 'N', 'Y', 'admin@cpinfosys.com', 'Y', '2009-10-10 00:00:00', ''); -- -------------------------------------------------------- -- -- Table structure for table `master_password` -- CREATE TABLE `master_password` ( `password` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `master_password` -- -- -------------------------------------------------------- -- -- Table structure for table `user_login_log` -- CREATE TABLE `user_login_log` ( `user_master_id` varchar(50) NOT NULL, `log_dt_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `log_ip` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `user_login_log` -- -- -------------------------------------------------------- -- -- Table structure for table `user_master` -- CREATE TABLE `user_master` ( `user_master_id` int(10) NOT NULL auto_increment, `user_dt` datetime NOT NULL, `user_nickname` varchar(50) NOT NULL, `user_password` varchar(50) NOT NULL, `user_first_name` varchar(50) NOT NULL, `user_last_name` varchar(50) NOT NULL, `user_email` varchar(100) NOT NULL, `user_company` varchar(100) NOT NULL, `user_image` varchar(150) NOT NULL, `user_add` varchar(200) NOT NULL, `user_city` varchar(50) NOT NULL, `user_state` varchar(50) NOT NULL, `user_zip` varchar(10) NOT NULL, `user_country` varchar(50) NOT NULL, `user_website` varchar(100) NOT NULL, `user_phone` varchar(100) NOT NULL, `company_bio` varchar(250) NOT NULL, `campaign_number` varchar(200) NOT NULL, `user_contact_per` varchar(100) NOT NULL, `user_contact_phone` varchar(100) NOT NULL, `allow_to_log_in_to_site` enum('N','Y') NOT NULL, `is_deleted_user_profile` enum('N','Y') NOT NULL, `is_modification_approved` enum('N','Y') NOT NULL, `user_online` enum('N','Y') NOT NULL, `user_contact_email` varchar(100) NOT NULL, `email_verified` enum('N','Y') NOT NULL, `user_last_log` datetime NOT NULL, `user_no_of_log` varchar(10) NOT NULL, PRIMARY KEY (`user_master_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ; -- -- Dumping data for table `user_master` -- INSERT INTO `user_master` (`user_master_id`, `user_dt`, `user_nickname`, `user_password`, `user_first_name`, `user_last_name`, `user_email`, `user_company`, `user_image`, `user_add`, `user_city`, `user_state`, `user_zip`, `user_country`, `user_website`, `user_phone`, `company_bio`, `campaign_number`, `user_contact_per`, `user_contact_phone`, `allow_to_log_in_to_site`, `is_deleted_user_profile`, `is_modification_approved`, `user_online`, `user_contact_email`, `email_verified`, `user_last_log`, `user_no_of_log`) VALUES (1, '2009-10-06 13:29:26', 'santanu', 'santanu', 'santanu', 'sabata', 'santanu@gmail.com', 'santanu technologies', 'upload/profile_image/allbusiness.jpeg', 'vastral', 'washington', 'USA', '382418', 'India', 'santanutechno.com', '', '', '', '98989899', 'santanu', 'Y', 'Y', 'N', 'N', '', 'Y', '0000-00-00 00:00:00', ''), (2, '0000-00-00 00:00:00', 'om', 'om', 'Om', 'sabata', 'om@yahoo.com', 'omtechnologies', 'upload/profile_image/ecobizNyc.jpeg', 'vastrapur', 'Jhuji', 'China', '382413', 'India', 'omtechno.com', '', '', '', '9898985896', '', '', '', 'N', 'N', '', '', '0000-00-00 00:00:00', ''), (3, '0000-00-00 00:00:00', 'rajesh', 'rajesh', 'Rajesh', 'Sahja', 'om@yahoo.com', 'Rajesh Enterprise', 'fitness.jpeg', '68-jesaus building', 'Sonakita', 'Soudi', '382414', 'India', 'omtechno.com', '', '', '', '9898985896', '', 'N', 'N', 'N', 'N', '', 'Y', '2009-10-10 19:33:32', ''), (4, '0000-00-00 00:00:00', 'Nipa', 'Nipa', 'Nipa', 'Sonat', 'om@yahoo.com', 'Nipa Textile', 'upload/profile_image/grebusiness.jpeg', '123/48/25 Jankardtu Building', 'Sanghai', 'China', '382415', 'India', 'omtechno.com', '', '', '', '9898985896', '', '', '', 'N', 'N', '', '', '0000-00-00 00:00:00', ''), (5, '0000-00-00 00:00:00', 'Kem', 'Kem', 'Kem', 'Sonat', 'om@yahoo.com', 'Kem financial Services', '', '32/5-Sonakudi', 'Sanghai', 'China', '382416', 'India', 'omtechno.com', '', '', '', '9898985896', '', '', '', 'N', 'N', '', '', '0000-00-00 00:00:00', ''), (6, '0000-00-00 00:00:00', 'somu', 'spnu', 'sonu', 'soham', 'sonuket@gmail.com', 'Somu Corporation', '', 'vastrapur', 'Singhania', 'USA', '382417', 'India', 'omtechno.com', '', '', '', '9898985896', '', '', '', 'N', 'N', '', '', '0000-00-00 00:00:00', ''), (22, '2009-10-12 10:07:42', 'soham', 'soham', 'soham', 'sabata', 'soham@yah.com', 'soham international', '2_business_logo_0f373943832f9c561bb19055d085b334.jpg', 'dsafdasfdsa', 'sadfdsasdf', 'adsfdsa', '1223345', '', 'soham.com', '1212112', '121212121\r\n121\r\n212\r\n12\r\n12', '', '', '', 'Y', 'N', 'N', 'N', '', 'N', '0000-00-00 00:00:00', ''), (23, '2009-10-12 10:07:42', 'kartik', 'sukhana', 'kartik', 'sukhana', 'sokula@yah.com', 'dsfdsafds', '1_business_logo_cec457653e3989381d90c5e2a3038864.jpg', 'sdfdas', 'sadfdsasadfdsa', 'sadfdsafda', '11111111', '', 'kartik.com', '11111111111111', '111111111111\n111111111111111\n11111111111111111\n11111111111111111111\n111111111111', '', '', '', 'Y', 'N', 'N', 'N', '', 'N', '0000-00-00 00:00:00', ''), (24, '2009-10-12 10:07:42', 'ronak', 'ronak', 'ronak', 'ledraf', 'cxZcxzcxz@yah.com', 'raonalk international', '1_business_logo_96c37617c14c253d944d0683c4e42ae7.jpg', 'czxcxz', 'cxzc', 'xzcxz', '2222222222', '', 'ronak.com', '22222222222', 'asssssssssss\nasas\na\nsa\ns\nasa', '', '', '', 'Y', 'N', 'N', 'N', '', 'N', '0000-00-00 00:00:00', ''); -- -------------------------------------------------------- -- -- Table structure for table `user_master_hist` -- CREATE TABLE `user_master_hist` ( `user_master_hist_id` int(10) NOT NULL auto_increment, `user_master_id` int(10) NOT NULL, `user_dt` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `user_nickname` varchar(50) NOT NULL, `user_password` varchar(50) NOT NULL, `user_first_name` varchar(50) NOT NULL, `user_last_name` varchar(50) NOT NULL, `user_email` varchar(100) NOT NULL, `user_company` varchar(100) NOT NULL, `user_image` varchar(150) NOT NULL, `user_add` varchar(200) NOT NULL, `user_city` varchar(50) NOT NULL, `user_state` varchar(50) NOT NULL, `user_zip` varchar(10) NOT NULL, `user_country` varchar(50) NOT NULL, `user_website` varchar(100) NOT NULL, `campaign_number` varchar(200) NOT NULL, `user_contact_per` varchar(100) NOT NULL, `user_contact_phone` varchar(100) NOT NULL, `allow_to_log_in_to_site` enum('N','Y') NOT NULL, `is_deleted_user_profile` enum('N','Y') NOT NULL, `user_contact_email` varchar(100) NOT NULL, `email_verified` enum('N','Y') NOT NULL, `user_last_log` datetime NOT NULL, `user_no_of_log` varchar(10) NOT NULL, `user_phone` varchar(50) NOT NULL, `company_bio` varchar(250) NOT NULL, `is_new_user` enum('Y','N') NOT NULL, PRIMARY KEY (`user_master_hist_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ; -- -- Dumping data for table `user_master_hist` -- INSERT INTO `user_master_hist` (`user_master_hist_id`, `user_master_id`, `user_dt`, `user_nickname`, `user_password`, `user_first_name`, `user_last_name`, `user_email`, `user_company`, `user_image`, `user_add`, `user_city`, `user_state`, `user_zip`, `user_country`, `user_website`, `campaign_number`, `user_contact_per`, `user_contact_phone`, `allow_to_log_in_to_site`, `is_deleted_user_profile`, `user_contact_email`, `email_verified`, `user_last_log`, `user_no_of_log`, `user_phone`, `company_bio`, `is_new_user`) VALUES (4, 0, '2009-10-12 00:49:15', '', '', 'palian', 'karik', 'karik@yah.com', 'palin soft', '4_business_logo_ff24d05345032e7f832c260055479c2a.jpg', 'afddasfddf', 'fddfd', 'fdfdd', '2222222222', '', 'palin.com', '', '', '', 'N', 'N', '', 'N', '0000-00-00 00:00:00', '', '33333333333333', '33333333333\r\n333333333333333333333\r\n33333333333333333\r\n33333333333333\r\n3333333333333\r\n3\r\n3', 'Y'), (5, 0, '2009-10-12 00:43:07', '', '', 'asew', 'wew', 'wewew@cks.xom', 'asdsadsa', '5_business_logo_705fb686151d529d8c7cb5e74f98a06f.jpg', 'sdafds', 'sdfadsf', 'dsfdsadsa', '8888888888', '', 'ssss.com', '', '', '', 'N', 'N', '', 'N', '0000-00-00 00:00:00', '', '8888888888', '8888888888888\r\n88888888888888', 'Y');