· 8 years ago · Dec 07, 2017, 12:30 AM
1DROP TABLE IF EXISTS `tbladminusers`;
2SET @saved_cs_client = @@character_set_client;
3SET character_set_client = utf8;
4CREATE TABLE `tbladminusers` (
5 `id` int(4) NOT NULL auto_increment,
6 `user_id` varchar(15) NOT NULL default '',
7 `password` varchar(255) NOT NULL,
8 `user_name` varchar(255) NOT NULL default '',
9 `user_type` enum('A','E','C','publisher','editor','approver','user_creator') NOT NULL,
10 `email` varchar(255) NOT NULL default '',
11 `is_active` enum('Y','N') NOT NULL default 'Y',
12 `added_date` datetime NOT NULL default '0000-00-00 00:00:00',
13 `rights` text,
14 PRIMARY KEY (`user_id`),
15 UNIQUE KEY `sno` (`id`),
16 KEY `user_id` (`user_id`)
17) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
18SET character_set_client = @saved_cs_client;
19
20--
21-- Dumping data for table `tbladminusers`
22--
23
24LOCK TABLES `tbladminusers` WRITE;
25/*!40000 ALTER TABLE `tbladminusers` DISABLE KEYS */;
26INSERT INTO `tbladminusers` VALUES (1,'adminlocal','$#%ae249lx0kal;949@#$%9503','admin214','user_creator','info@zengatv.com','Y','2011-04-05 22:40:26','Users Management,Media Queries,Main Menu Page Management,For Information,Video Management,Feedback,News Management(Main Panel),Advertise with us,Now Management,Manage Accreditation Form,News (News Management),Send Invites,Featues (News Management),Announcements (News Management),Columns (News Management),Interviews (News Management),Article Keyword Management,InvitesStatuss,Celebrity Stories Management,Update LKM Invites,Sort Home Feature Stories,LKM Invites Status,Sort Home Interview Stories,Newsletter Status,Photo Gallery Management,Friend & Relative Invite,Video Gallery Management,Manage Players Profile,Home Gallery Management,Manage Players Stats,Upload Files to IPLT20.com,Manage Venues,Background Image for IPLT20.com,Manage Teams,Dug Out Management,Manage Subscribed Users,Trivia Management,Manage Wallpapers,Polls Management,Manage Camera Fan,Manage Governing Body,Advertising Management,Manage Associate Players,'),(41,'ipltwenty20','classic1020','iplt20','user_creator','gaurav@zengamail.com','N','2011-03-26 03:29:23','Media Queries,Main Menu Page Management,For Information,Video Management,Feedback,News Management(Main Panel),Advertise with us,Now Management,Manage Accreditation Form,News (News Management),Send Invites,Featues (News Management),Announcements (News Management),Columns (News Management),Interviews (News Management),Article Keyword Management,InvitesStatuss,Celebrity Stories Management,Update LKM Invites,Sort Home Feature Stories,LKM Invites Status,Sort Home Interview Stories,Newsletter Status,Photo Gallery Management,Friend & Relative Invite,Video Gallery Management,Manage Players Profile,Home Gallery Management,Manage Players Stats,Upload Files to IPLT20.com,Manage Venues,Background Image for IPLT20.com,Manage Teams,Dug Out Management,Manage Subscribed Users,Trivia Management,Manage Wallpapers,Polls Management,Manage Camera Fan,Manage Governing Body,'),(44,'iplcmsteam','c@rt00nnetw0rk2011','','user_creator','shabir@zengamail.com','Y','2011-04-06 22:12:22','Media Queries,Main Menu Page Management,For Information,Video Management,Feedback,News Management(Main Panel),Advertise with us,Now Management,Manage Accreditation Form,News (News Management),Send Invites,Featues (News Management),Announcements (News Management),Columns (News Management),Interviews (News Management),Article Keyword Management,Celebrity Stories Management,Update LKM Invites,Sort Home Feature Stories,LKM Invites Status,Sort Home Interview Stories,Newsletter Status,Photo Gallery Management,Friend & Relative Invite,Video Gallery Management,Manage Players Profile,Home Gallery Management,Manage Players Stats,Upload Files to IPLT20.com,Manage Venues,Background Image for IPLT20.com,Manage Teams,Dug Out Management,Manage Subscribed Users,Trivia Management,Manage Wallpapers,Polls Management,Manage Camera Fan,Manage Governing Body,'),(45,'Vivek','vivekath','','editor','vivek@zengamail.com','Y','2011-04-06 22:20:33','Users Management,Media Queries,Main Menu Page Management,For Information,Video Management,Feedback,News Management(Main Panel),Advertise with us,Now Management,Manage Accreditation Form,News (News Management),Send Invites,Featues (News Management),Announcements (News Management),Columns (News Management),Interviews (News Management),Article Keyword Management,Invites Status,Celebrity Stories Management,Update LKM Invites,Sort Home Feature Stories,LKM Invites Status,Sort Home Interview Stories,Newsletter Status,Photo Gallery Management,Friend & Relative Invite,Video Gallery Management,Manage Players Profile,Home Gallery Management,Manage Players Stats,Upload Files to IPLT20.com,Manage Venues,Background Image for IPLT20.com,Manage Teams,Dug Out Management,Manage Subscribed Users,Trivia Management,Manage Wallpapers,Polls Management,Manage Camera Fan,Manage Governing Body,Advertising Management,Manage Associate Players,');
27/*!40000 ALTER TABLE `tbladminusers` ENABLE KEYS */;