KtCDDPT9

1--
2
3CREATE TABLE IF NOT EXISTS `users` (
4  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
5  `uname` varchar(100) NOT NULL,
6  `phone` varchar(100) NOT NULL,
7  `email` varchar(100) NOT NULL,
8  `pwd` varchar(250) NOT NULL,
9  `cpname` varchar(100) NOT NULL,
10  `designation` varchar(50) NOT NULL,
11  `address` varchar(255) NOT NULL,
12  `state` varchar(20) NOT NULL,
13  `district` varchar(20) NOT NULL,
14  `town` varchar(30) NOT NULL,
15  `website` varchar(100) NOT NULL,
16  `courses` varchar(255) NOT NULL,
17  `majorcourse` varchar(100) NOT NULL,
18  `othrcourses` varchar(100) NOT NULL,
19  `ey` varchar(20) NOT NULL,
20  `nos` varchar(10) NOT NULL,
21  `noc` varchar(20) NOT NULL,
22  `nost` varchar(10) NOT NULL,
23  `lcd` varchar(10) NOT NULL,
24  `investment` varchar(20) NOT NULL,
25  `turnover` varchar(100) NOT NULL,
26  `logo` varchar(255) NOT NULL,
27  `description` text NOT NULL,
28  `keyword` varchar(100) NOT NULL,
29  `img1` varchar(255) NOT NULL,
30  `img2` varchar(255) NOT NULL,
31  `video1` varchar(255) NOT NULL,
32  `video2` varchar(255) NOT NULL,
33  `extraphone` varchar(20) NOT NULL,
34  PRIMARY KEY (`id`)
35) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5933 ;
36
37--
38-- Dumping data for table `users`
39--
40
41(1, 'Engineers Cadd  Centre (P) Ltd', '9866131068', 'training@eccindia.org', '426ca3c0f3343b185bec62d48e184caf', 'Faheem Mohammed', 'Director (Training)', 'F-9/10/11/12,   Eureka Court,   \r\nBeside Bata Showroom,   \r\nNear Image Hospitals,   \r\nAmeerpet,   Hyderabad-500073', 'TELANGANA', 'Hyderabad', 'Hyderabad', 'www.eccindia.org', 'Autocad', 'CADD', '', '1994', '1001487', '98', '40', '3', '700 ', 'above 1 crore', 'ecc_logo.jpg', 'ECC is the Premier CAD CAE & Project Management Training Centre established at Ameerpet in Hyderabad in India. CALL US on 9866131068 for courses and projects', 'Autocad Training', '', '', '', '', ''),
42
43--