· 8 years ago · Jan 24, 2018, 01:06 AM
1-- you'll need a users table with corresponding roles for ids 1-6
2
3--
4-- Table structure for table `roles`
5--
6
7DROP TABLE IF EXISTS `roles`;
8/*!40101 SET @saved_cs_client = @@character_set_client */;
9/*!40101 SET character_set_client = utf8 */;
10CREATE TABLE `roles` (
11 `id` int(11) NOT NULL AUTO_INCREMENT,
12 `name` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
13 `authorizable_type` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
14 `authorizable_id` int(11) DEFAULT NULL,
15 `created_at` datetime DEFAULT NULL,
16 `updated_at` datetime DEFAULT NULL,
17 PRIMARY KEY (`id`)
18) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
19/*!40101 SET character_set_client = @saved_cs_client */;
20
21--
22-- Dumping data for table `roles`
23--
24
25LOCK TABLES `roles` WRITE;
26/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
27INSERT INTO `roles` VALUES (1,'site_admin','Basket',1,'2011-08-03 10:58:06','2011-08-03 10:58:06'),(2,'admin','Basket',2,'2011-08-03 10:58:06','2011-08-03 10:58:06'),(3,'admin','Basket',3,'2011-08-03 10:58:06','2011-08-03 10:58:06'),(4,'tech_admin','Basket',1,'2011-08-03 10:58:06','2011-08-03 10:58:06'),(5,'admin','Basket',4,'2011-08-03 10:58:06','2011-08-03 10:58:06'),(6,'member','Basket',1,'2011-08-03 10:58:06','2011-08-03 10:58:06');
28/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
29UNLOCK TABLES;
30
31--
32-- Table structure for table `roles_users`
33--
34
35DROP TABLE IF EXISTS `roles_users`;
36/*!40101 SET @saved_cs_client = @@character_set_client */;
37/*!40101 SET character_set_client = utf8 */;
38CREATE TABLE `roles_users` (
39 `user_id` int(11) DEFAULT NULL,
40 `role_id` int(11) DEFAULT NULL,
41 `created_at` datetime DEFAULT NULL,
42 `updated_at` datetime DEFAULT NULL,
43 KEY `user_id` (`user_id`),
44 KEY `role_id` (`role_id`),
45 CONSTRAINT `roles_users_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
46 CONSTRAINT `roles_users_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
47) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
48/*!40101 SET character_set_client = @saved_cs_client */;
49
50--
51-- Dumping data for table `roles_users`
52--
53
54----WORKING VERSION!!!!
55LOCK TABLES `roles_users` WRITE;
56/*!40000 ALTER TABLE `roles_users` DISABLE KEYS */;
57INSERT INTO `roles_users` VALUES (1,2,'2011-08-03 10:58:06','2011-08-03 10:58:06'),(2,6,'2011-08-03 10:58:06','2011-08-03 10:58:06'),(1,5,'2011-08-03 10:58:06','2011-08-03 10:58:06'),(1,4,'2011-08-03 10:58:06','2011-08-03 10:58:06'),(1,3,'2011-08-03 10:58:06','2011-08-03 10:58:06'),(1,1,'2011-08-03 10:58:06','2011-08-03 10:58:06');
58/*!40000 ALTER TABLE `roles_users` ENABLE KEYS */;
59UNLOCK TABLES;
60----END WORKING VERSION!!!!
61
62----NOT WORKING VERSION!!!!
63LOCK TABLES `roles_users` WRITE;
64/*!40000 ALTER TABLE `roles_users` DISABLE KEYS */;
65INSERT INTO `roles_users` VALUES (1,2,'2011-08-01 22:29:58','2011-08-01 22:29:58'),(2,6,'2011-08-01 22:29:58','2011-08-01 22:29:58'),(1,5,'2011-08-01 22:29:58','2011-08-01 22:29:58'),(1,4,'2011-08-01 22:29:58','2011-08-01 22:\
6629:58'),(1,3,'2011-08-01 22:29:58','2011-08-01 22:29:58'),(1,1,'2011-08-01 22:29:58','2011-08-01 22:29:58');
67/*!40000 ALTER TABLE `roles_users` ENABLE KEYS */;
68UNLOCK TABLES;
69----END NOT WORKING VERSION!!!!