-- phpMyAdmin SQL Dump -- version 4.8.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jun 26, 2019 at 12:21 AM -- Server version: 5.6.43-cll-lve -- PHP Version: 7.2.7 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: `pcm_offbit` -- -- -------------------------------------------------------- -- -- Table structure for table `pcm_brands` -- CREATE TABLE `pcm_brands` ( `brand_id` int(11) NOT NULL, `client_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `description` longtext NOT NULL, `deletestatus` enum('N','Y') NOT NULL, `status` enum('Y','N') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_brands` -- INSERT INTO `pcm_brands` (`brand_id`, `client_id`, `name`, `description`, `deletestatus`, `status`) VALUES (1, 2, 'asia paints11', 'e erteter e trett t444', 'Y', 'Y'), (2, 2, 'erwr', 'ytryryr', 'Y', 'Y'), (3, 0, 'fhfs', 'asdad', 'Y', 'Y'), (4, 3, 'wewr11', 'wrwer11', 'Y', 'Y'), (5, 5, 'Rin', 'Dress bright, get career ready, shine in your interview and career.', 'N', 'Y'), (6, 6, 'Smart Care', '', 'N', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `pcm_categories` -- CREATE TABLE `pcm_categories` ( `category_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `description` longtext NOT NULL, `deletestatus` enum('N','Y') NOT NULL, `status` enum('Y','N') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_categories` -- INSERT INTO `pcm_categories` (`category_id`, `name`, `description`, `deletestatus`, `status`) VALUES (4, 'VENUE RELATED', 'VENUE RELATED', 'N', 'Y'), (5, 'MATERIAL PURCHASE', 'MATERIAL PURCHASE', 'N', 'Y'), (6, 'EQUIPMENT HIRE', 'EQUIPMENT HIRE', 'N', 'Y'), (7, 'LOCAL TRAVEL', 'LOCAL TRAVEL', 'N', 'Y'), (8, 'MANPOWER UTILISED', 'MANPOWER UTILISED', 'N', 'Y'), (9, 'TEAM TRAVEL,FOOD & ACCOMMODATION', 'TEAM TRAVEL,FOOD & ACCOMMODATION', 'N', 'Y'), (10, 'INTER CITY / TOWN TRANSPORTATION', 'INTER CITY / TOWN TRANSPORTATION', 'N', 'Y'), (11, 'STAGE / STALL SETUP', 'STAGE / STALL SETUP', 'N', 'Y'), (12, 'MISC.', 'MISC.', 'N', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `pcm_clients` -- CREATE TABLE `pcm_clients` ( `client_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `mobile` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `address` longtext NOT NULL, `city` varchar(255) NOT NULL, `state` varchar(255) NOT NULL, `zip` varchar(255) NOT NULL, `deletestatus` enum('N','Y') NOT NULL, `status` enum('Y','N') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_clients` -- INSERT INTO `pcm_clients` (`client_id`, `name`, `mobile`, `email`, `address`, `city`, `state`, `zip`, `deletestatus`, `status`) VALUES (1, 'sda1111', '2424444444', 'rr@jfj.com', 'sfssfs34', '', '', '', 'Y', 'Y'), (2, 'wer', '34534543', 'ertre@jf.com', 'sdfsdfsdf', '', '', '', 'Y', 'Y'), (3, 'hghee2233', '2222222221133', 'we3q@jdjd.com', 'dsgetewww33', '', '', '', 'Y', 'Y'), (4, 'ghjh44', '3453456', 'dert@jjdj.com57', 'ijiyrryury rtyrty575', '', '', '', 'Y', 'Y'), (5, 'Hindustan Unilever', '9330817140', 'manish.keshari45@gmail.com', '129 Mahamaya Twins, Boral, Kolkata - 700154', '', '', '', 'N', 'Y'), (6, 'Asian Paints Limited', '', '', 'Mumbai', '', '', '', 'N', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `pcm_estimates` -- CREATE TABLE `pcm_estimates` ( `estimate_id` int(11) NOT NULL, `project_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `subcategory_id` int(11) NOT NULL, `estimateamount` float NOT NULL, `limitamount` float NOT NULL, `deletestatus` enum('N','Y') NOT NULL, `status` enum('Y','N') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_estimates` -- INSERT INTO `pcm_estimates` (`estimate_id`, `project_id`, `category_id`, `subcategory_id`, `estimateamount`, `limitamount`, `deletestatus`, `status`) VALUES (12, 6, 5, 13, 2000, 1800, 'N', 'Y'), (13, 6, 5, 14, 5000, 4000, 'N', 'Y'), (14, 6, 4, 8, 10000, 9000, 'N', 'Y'), (15, 7, 4, 8, 357530, 357530, 'N', 'Y'), (16, 7, 8, 26, 9600, 9600, 'N', 'Y'), (17, 8, 4, 8, 168700, 168700, 'N', 'Y'), (18, 8, 8, 26, 4800, 4800, 'N', 'Y'), (19, 8, 8, 25, 3300, 3300, 'N', 'Y'), (20, 8, 6, 16, 6000, 6000, 'N', 'Y'), (21, 8, 6, 17, 9000, 9000, 'N', 'Y'), (22, 8, 8, 31, 2500, 2500, 'N', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `pcm_funcalloweds` -- CREATE TABLE `pcm_funcalloweds` ( `funcallowed_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `modfunc_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_funcalloweds` -- INSERT INTO `pcm_funcalloweds` (`funcallowed_id`, `user_id`, `modfunc_id`) VALUES (1, 1, 1), (2, 1, 2); -- -------------------------------------------------------- -- -- Table structure for table `pcm_invoices` -- CREATE TABLE `pcm_invoices` ( `invoice_id` int(11) NOT NULL, `project_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `subcategory_id` int(11) NOT NULL, `baseamount` float NOT NULL, `tax` float NOT NULL, `totalamount` float NOT NULL, `invoicetype` varchar(255) NOT NULL, `invoiceno` int(11) NOT NULL, `invoicecopy` varchar(255) NOT NULL, `login_id` int(11) NOT NULL, `invoicedate` date NOT NULL, `createddate` date NOT NULL, `deletestatus` enum('N','Y') NOT NULL, `status` enum('Y','N') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_invoices` -- INSERT INTO `pcm_invoices` (`invoice_id`, `project_id`, `category_id`, `subcategory_id`, `baseamount`, `tax`, `totalamount`, `invoicetype`, `invoiceno`, `invoicecopy`, `login_id`, `invoicedate`, `createddate`, `deletestatus`, `status`) VALUES (1, 2, 3, 4, 2, 2, 4, '0', 25, 'http://localhost/pcm/codes/uploads/1553606206_2Hounds Design.jpg', 0, '2019-03-26', '0000-00-00', 'N', 'Y'), (2, 2, 2, 5, 1, 1, 1, '0', 3, '2Hounds Design.jpg', 0, '2019-03-26', '0000-00-00', 'Y', 'Y'), (3, 2, 2, 5, 2, 2, 2, '0', 34, '2Hounds Design.jpg', 0, '2019-03-26', '0000-00-00', 'N', 'Y'), (4, 2, 2, 5, 1, 1, 1, '0', 1, '2Hounds Design.jpg', 0, '2019-03-26', '0000-00-00', 'Y', 'Y'), (5, 0, 0, 0, 0, 0, 0, '', 0, '1553603251_2Hounds Design.jpg', 0, '0000-00-00', '0000-00-00', 'N', 'Y'), (6, 0, 0, 0, 0, 0, 0, '', 0, 'D:\\xampp\\htdocs\\pcm\\codes\\app\\webroot\\uploads/1553603524_2Hounds Design.jpg', 0, '0000-00-00', '0000-00-00', 'N', 'Y'), (7, 0, 0, 0, 0, 0, 0, '', 0, 'http://localhost/pcm/codes/uploads/1553603621_2Hounds Design.jpg', 0, '0000-00-00', '0000-00-00', 'N', 'Y'), (8, 0, 0, 0, 0, 0, 0, '', 0, 'http://localhost/pcm/codes/uploads/1553603758_2Hounds Design.jpg', 0, '0000-00-00', '0000-00-00', 'N', 'Y'), (9, 2, 2, 5, 1, 1, 1, '0', 1, '2Hounds Design.jpg', 0, '2019-03-26', '0000-00-00', 'N', 'Y'), (10, 0, 0, 0, 0, 0, 0, '', 0, 'http://localhost/pcm/codes/uploads/1553604441_2Hounds Design.jpg', 0, '0000-00-00', '0000-00-00', 'N', 'Y'), (11, 0, 0, 0, 0, 0, 0, '', 0, 'http://localhost/pcm/codes/uploads/1553604587_2Hounds Design.jpg', 0, '0000-00-00', '0000-00-00', 'N', 'Y'), (12, 2, 0, 0, 0, 0, 0, '', 0, 'http://localhost/pcm/codes/uploads/1553604616_2Hounds Design.jpg', 0, '0000-00-00', '0000-00-00', 'Y', 'Y'), (13, 2, 2, 5, 1, 1, 2, '0', 3, 'http://localhost/pcm/codes/uploads/1553604846_2Hounds Design.jpg', 0, '2019-03-26', '0000-00-00', 'N', 'Y'), (14, 2, 3, 4, 2, 1, 3, '2', 123, 'http://localhost/pcm/codes/uploads/1553604880_bill.jpg', 0, '2019-03-26', '0000-00-00', 'N', 'Y'), (15, 6, 5, 12, 100, 10, 110, '0', 12345, 'http://localhost/pcm/codes/uploads/1553950180_2Hounds Design.jpg', 0, '2019-03-30', '0000-00-00', 'N', 'Y'), (16, 6, 4, 8, 200, 20, 220, '0', 111, 'http://custcare.in/pcm/codes/uploads/1554125954_11.png', 0, '2019-04-01', '0000-00-00', 'N', 'Y'), (17, 6, 4, 8, 300, 30, 330, '0', 345, 'http://custcare.in/pcm/codes/uploads/1554125983_2Hounds Design.jpg', 0, '2019-04-01', '0000-00-00', 'N', 'Y'), (18, 6, 4, 7, 90, 10, 100, '0', 98, 'http://custcare.in/pcm/codes/uploads/1554180143_2Hounds Design.jpg', 0, '2019-04-02', '0000-00-00', 'N', 'Y'), (19, 7, 4, 8, 100, 20, 120, '0', 1, 'http://custcare.in/pcm/codes/uploads/1561461150_addengraving.jpg', 0, '2019-06-25', '0000-00-00', 'N', 'Y'), (20, 8, 4, 8, 23000, 1150, 24150, '0', 3542, '', 0, '2019-06-25', '0000-00-00', 'N', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `pcm_jobtypes` -- CREATE TABLE `pcm_jobtypes` ( `jobtype_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `deletestatus` enum('N','Y') NOT NULL, `status` enum('Y','N') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `pcm_logins` -- CREATE TABLE `pcm_logins` ( `login_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `designation` varchar(255) NOT NULL, `mobile` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `usertype` varchar(255) NOT NULL, `deletestatus` enum('N','Y') NOT NULL, `status` enum('Y','N') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_logins` -- INSERT INTO `pcm_logins` (`login_id`, `name`, `designation`, `mobile`, `username`, `password`, `usertype`, `deletestatus`, `status`) VALUES (1, 'Manish', 'Admin', '9330817140', 'admin@pcm.in', 'e10adc3949ba59abbe56e057f20f883e', 'admin', 'N', 'Y'), (6, 'Ashish Kumar', 'Project Manager', '1234567890', 'ashish@pcm.com', '123456', 'Project Manager', 'N', 'Y'), (7, 'Krish Nayar', 'Project Executive', '9876543212', 'krish@pcm.com', '123456', 'Project Executive', 'N', 'Y'), (8, 'Subrata Mondal', 'Project Executive', '9874645280', 'subra_mond109@yahoo.co.in', '***', 'Project Executive', 'N', 'Y'), (9, 'Jay Acharjee', 'Project Executive', '9748292716', 'jayacharjee 497@gmail.com', '***', 'Project Executive', 'N', 'Y'), (10, 'Arijit Chakraborty', 'Project Manager', '9874229889', 'arijit@offbitmktg.com', '***', 'Project Manager', 'N', 'Y'), (11, 'Prakhar Singhania', 'Project Manager', '9953107017', 'prakhar.s@offbitmktg.com', '***', 'Project Manager', 'N', 'Y'), (12, 'Suresh Verma', 'Project Manager', '9899981638', 'vermasureshk@gmail.com', '***', 'Project Manager', 'N', 'Y'), (13, 'Mriganka Chatterjee', 'Project Executive', '9831611315', 'mriganka.oms@gmail.com', '***', 'Project Executive', 'N', 'Y'), (14, 'Krishnendu Dey', 'Project Executive', '98317603213', 'krishnendu.d@offbitmktg.com', '***', 'Project Executive', 'N', 'Y'), (15, 'Dipankar Mondal', 'Project Executive', '8240199236', 'dipankar.oms17@gmail.com', '***', 'Project Executive', 'N', 'Y'), (16, 'Dilip Mondal', '', '', '', 'dilip1971', 'admin', 'N', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `pcm_modfuncs` -- CREATE TABLE `pcm_modfuncs` ( `modfunc_id` int(11) NOT NULL, `modulename` varchar(255) NOT NULL, `controllername` varchar(255) NOT NULL, `functionname` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_modfuncs` -- INSERT INTO `pcm_modfuncs` (`modfunc_id`, `modulename`, `controllername`, `functionname`) VALUES (1, 'User Management', 'users', 'admin_add'), (2, 'User Management', 'users', 'admin_edit'); -- -------------------------------------------------------- -- -- Table structure for table `pcm_projects` -- CREATE TABLE `pcm_projects` ( `project_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `estimateno` varchar(255) NOT NULL, `pono` varchar(255) NOT NULL, `podate` datetime NOT NULL, `eventstartdate` datetime NOT NULL, `eventenddate` datetime NOT NULL, `eventlocation` varchar(255) NOT NULL, `client_id` int(11) NOT NULL, `brand_id` int(11) NOT NULL, `jobcode` varchar(255) NOT NULL, `zone_id` int(11) NOT NULL, `createddate` datetime NOT NULL, `deletestatus` enum('N','Y') NOT NULL, `status` enum('Y','N') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_projects` -- INSERT INTO `pcm_projects` (`project_id`, `name`, `estimateno`, `pono`, `podate`, `eventstartdate`, `eventenddate`, `eventlocation`, `client_id`, `brand_id`, `jobcode`, `zone_id`, `createddate`, `deletestatus`, `status`) VALUES (6, 'Rin Soap', '123', '456', '2019-03-30 13:41:00', '2019-04-05 13:41:00', '2019-05-30 13:41:00', 'Kolkata', 5, 5, 'Rin001', 2, '0000-00-00 00:00:00', 'N', 'Y'), (7, 'Smart Care Meet Bihar', '001', '123456', '2019-06-25 10:58:00', '2019-05-25 10:58:00', '2019-06-25 10:58:00', 'Bihar', 6, 6, 'Contmeet001', 1, '0000-00-00 00:00:00', 'N', 'Y'), (8, 'Smart Care Contractor Meet at Jharkhand', 'AJ-01', '25172660', '2019-06-25 11:19:00', '2019-06-25 11:19:00', '2019-06-25 11:19:00', 'Jharkhand', 6, 6, '01', 1, '0000-00-00 00:00:00', 'N', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `pcm_projectusers` -- CREATE TABLE `pcm_projectusers` ( `projectuser_id` int(11) NOT NULL, `project_id` int(11) NOT NULL, `login_id` int(11) NOT NULL, `usertype` varchar(255) NOT NULL, `deletestatus` enum('N','Y') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_projectusers` -- INSERT INTO `pcm_projectusers` (`projectuser_id`, `project_id`, `login_id`, `usertype`, `deletestatus`) VALUES (1, 2, 5, 'Manager', 'Y'), (4, 2, 1, 'Project Manager', 'N'), (5, 6, 1, 'admin', 'N'), (6, 6, 6, 'Project Manager', 'N'), (7, 6, 7, 'Project Executive', 'N'), (8, 7, 16, 'admin', 'N'), (9, 8, 16, 'admin', 'N'), (10, 8, 13, 'Project Executive', 'N'), (11, 8, 8, 'Project Executive', 'N'), (12, 8, 10, 'Project Manager', 'N'), (13, 8, 10, 'Operator', 'N'); -- -------------------------------------------------------- -- -- Table structure for table `pcm_subcategories` -- CREATE TABLE `pcm_subcategories` ( `subcategory_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `description` longtext NOT NULL, `deletestatus` enum('N','Y') NOT NULL, `status` enum('Y','N') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_subcategories` -- INSERT INTO `pcm_subcategories` (`subcategory_id`, `category_id`, `name`, `description`, `deletestatus`, `status`) VALUES (7, 4, 'Venue Rental', 'Venue Rental', 'N', 'Y'), (8, 4, 'Venue Food', 'Venue Food', 'N', 'Y'), (9, 4, 'Venue Beverage', 'Venue Beverage', 'N', 'Y'), (10, 4, 'Venue Equipment Hire', 'Venue Equipment Hire', 'N', 'Y'), (11, 4, 'Tips etc.', 'Tips etc.', 'N', 'Y'), (12, 5, 'Ply /Board/ Paper, etc. Purchase', 'Ply /Board/ Paper, etc. Purchase', 'N', 'Y'), (13, 5, 'Paint, Brush, Putty, etc. Purchase', 'Paint, Brush, Putty, etc. Purchase', 'N', 'Y'), (14, 5, 'Others', 'Others', 'N', 'Y'), (15, 6, 'Laptop', 'Laptop', 'N', 'Y'), (16, 6, 'Projector/Screen', 'Projector/Screen', 'N', 'Y'), (17, 6, 'Sound System / Mixture', 'Sound System / Mixture', 'N', 'Y'), (18, 6, 'Light, etc.', 'Light, etc.', 'N', 'Y'), (19, 6, '3rd Party Light & Sound Setup', '3rd Party Light & Sound Setup', 'N', 'Y'), (20, 6, 'Other', 'Other', 'N', 'Y'), (21, 7, 'Local team travel', 'Local team travel', 'N', 'Y'), (22, 7, 'Local Transportation (If any)', 'Local Transportation (If any)', 'N', 'Y'), (25, 8, 'Promoter Amount', 'Promoter Amount', 'N', 'Y'), (26, 8, 'Supervisor Amount', 'Supervisor Amount', 'N', 'Y'), (27, 8, 'Project Co-ordinator Amount', 'Project Co-ordinator Amount', 'N', 'Y'), (28, 8, 'Painter Amount', 'Painter Amount', 'N', 'Y'), (29, 8, 'MR Executive Amount', 'MR Executive Amount', 'N', 'Y'), (30, 8, 'MIS Executive Amount', 'MIS Executive Amount', 'N', 'Y'), (31, 8, 'Telecaller Amount', 'Telecaller Amount', 'N', 'Y'), (32, 9, 'Food Charges', 'Food Charges', 'N', 'Y'), (33, 9, 'Accommodation charges', 'Accommodation charges', 'N', 'Y'), (34, 9, 'Team Travel', 'Team Travel', 'N', 'Y'), (35, 10, 'Van Amount', 'Van Amount', 'N', 'Y'), (36, 10, 'Toll Charges', 'Toll Charges', 'N', 'Y'), (37, 10, 'Fuel Charges (If any)', 'Fuel Charges (If any)', 'N', 'Y'), (38, 10, 'Courier /Hand Delivery Charges', 'Courier /Hand Delivery Charges', 'N', 'Y'), (39, 10, 'Others', 'Others', 'N', 'Y'), (40, 11, 'Flex / Vinyl/ Cutout / Standee etc. ( 3rd . Party Billing)', 'Flex / Vinyl/ Cutout / Standee etc. ( 3rd . Party Billing)', 'N', 'Y'), (41, 11, 'Stage / Platform hire', 'Stage / Platform hire', 'N', 'Y'), (42, 11, 'Others', 'Others', 'N', 'Y'), (43, 12, 'Misc.', 'Misc.', 'N', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `pcm_teams` -- CREATE TABLE `pcm_teams` ( `team_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `designation` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `mobile` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `deletestatus` enum('N','Y') NOT NULL, `status` enum('Y','N') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_teams` -- INSERT INTO `pcm_teams` (`team_id`, `name`, `designation`, `email`, `mobile`, `address`, `deletestatus`, `status`) VALUES (1, 'sfs', 'sdfs', 'ds13@shakteeman.in', '2423', 'rterterte11', 'Y', 'Y'), (2, 'asdas', 'yiyuiyi', 'sdfs@kdkj.com', '4234', 'sfsdfsdf', 'Y', 'Y'), (3, 'rtyry11', 'rtyrtyr33', 'sdfs@nh.com', '3453534', 'dgddgdf', 'Y', 'Y'), (4, 'erwr', 'hdf', 'sd@ndhd.com', '353453', 'dgdfg', 'N', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `pcm_zones` -- CREATE TABLE `pcm_zones` ( `zone_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `deletestatus` enum('N','Y') NOT NULL, `status` enum('Y','N') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pcm_zones` -- INSERT INTO `pcm_zones` (`zone_id`, `name`, `deletestatus`, `status`) VALUES (1, 'Kolkata', 'N', 'Y'), (2, 'Delhi', 'N', 'Y'), (3, 'Bangalore', 'N', 'Y'), (4, 'Hyderabad', 'N', 'Y'), (5, 'mumbai', 'N', 'Y'); -- -- Indexes for dumped tables -- -- -- Indexes for table `pcm_brands` -- ALTER TABLE `pcm_brands` ADD PRIMARY KEY (`brand_id`); -- -- Indexes for table `pcm_categories` -- ALTER TABLE `pcm_categories` ADD PRIMARY KEY (`category_id`); -- -- Indexes for table `pcm_clients` -- ALTER TABLE `pcm_clients` ADD PRIMARY KEY (`client_id`); -- -- Indexes for table `pcm_estimates` -- ALTER TABLE `pcm_estimates` ADD PRIMARY KEY (`estimate_id`); -- -- Indexes for table `pcm_funcalloweds` -- ALTER TABLE `pcm_funcalloweds` ADD PRIMARY KEY (`funcallowed_id`); -- -- Indexes for table `pcm_invoices` -- ALTER TABLE `pcm_invoices` ADD PRIMARY KEY (`invoice_id`); -- -- Indexes for table `pcm_jobtypes` -- ALTER TABLE `pcm_jobtypes` ADD PRIMARY KEY (`jobtype_id`); -- -- Indexes for table `pcm_logins` -- ALTER TABLE `pcm_logins` ADD PRIMARY KEY (`login_id`); -- -- Indexes for table `pcm_modfuncs` -- ALTER TABLE `pcm_modfuncs` ADD PRIMARY KEY (`modfunc_id`); -- -- Indexes for table `pcm_projects` -- ALTER TABLE `pcm_projects` ADD PRIMARY KEY (`project_id`); -- -- Indexes for table `pcm_projectusers` -- ALTER TABLE `pcm_projectusers` ADD PRIMARY KEY (`projectuser_id`); -- -- Indexes for table `pcm_subcategories` -- ALTER TABLE `pcm_subcategories` ADD PRIMARY KEY (`subcategory_id`); -- -- Indexes for table `pcm_teams` -- ALTER TABLE `pcm_teams` ADD PRIMARY KEY (`team_id`); -- -- Indexes for table `pcm_zones` -- ALTER TABLE `pcm_zones` ADD PRIMARY KEY (`zone_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `pcm_brands` -- ALTER TABLE `pcm_brands` MODIFY `brand_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `pcm_categories` -- ALTER TABLE `pcm_categories` MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `pcm_clients` -- ALTER TABLE `pcm_clients` MODIFY `client_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `pcm_estimates` -- ALTER TABLE `pcm_estimates` MODIFY `estimate_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `pcm_funcalloweds` -- ALTER TABLE `pcm_funcalloweds` MODIFY `funcallowed_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `pcm_invoices` -- ALTER TABLE `pcm_invoices` MODIFY `invoice_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT for table `pcm_jobtypes` -- ALTER TABLE `pcm_jobtypes` MODIFY `jobtype_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pcm_logins` -- ALTER TABLE `pcm_logins` MODIFY `login_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `pcm_modfuncs` -- ALTER TABLE `pcm_modfuncs` MODIFY `modfunc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `pcm_projects` -- ALTER TABLE `pcm_projects` MODIFY `project_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `pcm_projectusers` -- ALTER TABLE `pcm_projectusers` MODIFY `projectuser_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `pcm_subcategories` -- ALTER TABLE `pcm_subcategories` MODIFY `subcategory_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44; -- -- AUTO_INCREMENT for table `pcm_teams` -- ALTER TABLE `pcm_teams` MODIFY `team_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `pcm_zones` -- ALTER TABLE `pcm_zones` MODIFY `zone_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; 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 */;