1
-- MySQL dump 10.13 Distrib 5.1.37, for debian-linux-gnu (x86_64)
3
-- Host: localhost Database: Agasti2_0
4
-- ------------------------------------------------------
5
-- Server version 5.1.37-1ubuntu5.4
7
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10
/*!40101 SET NAMES utf8 */;
11
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12
/*!40103 SET TIME_ZONE='+00:00' */;
13
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
-- Table structure for table `sf_guard_group`
22
DROP TABLE IF EXISTS `sf_guard_group`;
23
/*!40101 SET @saved_cs_client = @@character_set_client */;
24
/*!40101 SET character_set_client = utf8 */;
25
CREATE TABLE `sf_guard_group` (
26
`id` int(11) NOT NULL AUTO_INCREMENT,
27
`name` varchar(255) DEFAULT NULL,
29
`created_at` datetime NOT NULL,
30
`updated_at` datetime NOT NULL,
32
UNIQUE KEY `name` (`name`)
33
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
/*!40101 SET character_set_client = @saved_cs_client */;
37
-- Table structure for table `sf_guard_group_permission`
40
DROP TABLE IF EXISTS `sf_guard_group_permission`;
41
/*!40101 SET @saved_cs_client = @@character_set_client */;
42
/*!40101 SET character_set_client = utf8 */;
43
CREATE TABLE `sf_guard_group_permission` (
44
`group_id` int(11) NOT NULL DEFAULT '0',
45
`permission_id` int(11) NOT NULL DEFAULT '0',
46
`created_at` datetime NOT NULL,
47
`updated_at` datetime NOT NULL,
48
PRIMARY KEY (`group_id`,`permission_id`),
49
KEY `sf_guard_group_permission_permission_id_sf_guard_permission_id` (`permission_id`),
50
CONSTRAINT `sf_guard_group_permission_group_id_sf_guard_group_id` FOREIGN KEY (`group_id`) REFERENCES `sf_guard_group` (`id`) ON DELETE CASCADE,
51
CONSTRAINT `sf_guard_group_permission_permission_id_sf_guard_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `sf_guard_permission` (`id`) ON DELETE CASCADE
52
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
53
/*!40101 SET character_set_client = @saved_cs_client */;
56
-- Table structure for table `sf_guard_permission`
59
DROP TABLE IF EXISTS `sf_guard_permission`;
60
/*!40101 SET @saved_cs_client = @@character_set_client */;
61
/*!40101 SET character_set_client = utf8 */;
62
CREATE TABLE `sf_guard_permission` (
63
`id` int(11) NOT NULL AUTO_INCREMENT,
64
`name` varchar(255) DEFAULT NULL,
66
`created_at` datetime NOT NULL,
67
`updated_at` datetime NOT NULL,
69
UNIQUE KEY `name` (`name`)
70
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
71
/*!40101 SET character_set_client = @saved_cs_client */;
74
-- Table structure for table `sf_guard_remember_key`
77
DROP TABLE IF EXISTS `sf_guard_remember_key`;
78
/*!40101 SET @saved_cs_client = @@character_set_client */;
79
/*!40101 SET character_set_client = utf8 */;
80
CREATE TABLE `sf_guard_remember_key` (
81
`id` int(11) NOT NULL AUTO_INCREMENT,
82
`user_id` int(11) DEFAULT NULL,
83
`remember_key` varchar(32) DEFAULT NULL,
84
`ip_address` varchar(50) NOT NULL DEFAULT '',
85
`created_at` datetime NOT NULL,
86
`updated_at` datetime NOT NULL,
87
PRIMARY KEY (`id`,`ip_address`),
88
KEY `user_id_idx` (`user_id`),
89
CONSTRAINT `sf_guard_remember_key_user_id_sf_guard_user_id` FOREIGN KEY (`user_id`) REFERENCES `sf_guard_user` (`id`) ON DELETE CASCADE
90
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
91
/*!40101 SET character_set_client = @saved_cs_client */;
94
-- Table structure for table `sf_guard_user`
97
DROP TABLE IF EXISTS `sf_guard_user`;
98
/*!40101 SET @saved_cs_client = @@character_set_client */;
99
/*!40101 SET character_set_client = utf8 */;
100
CREATE TABLE `sf_guard_user` (
101
`id` int(11) NOT NULL AUTO_INCREMENT,
102
`username` varchar(128) NOT NULL,
103
`algorithm` varchar(128) NOT NULL DEFAULT 'sha1',
104
`salt` varchar(128) DEFAULT NULL,
105
`password` varchar(128) DEFAULT NULL,
106
`is_active` tinyint(1) DEFAULT '1',
107
`is_super_admin` tinyint(1) DEFAULT '0',
108
`last_login` datetime DEFAULT NULL,
109
`created_at` datetime NOT NULL,
110
`updated_at` datetime NOT NULL,
112
UNIQUE KEY `username` (`username`),
113
KEY `is_active_idx_idx` (`is_active`)
114
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
115
/*!40101 SET character_set_client = @saved_cs_client */;
118
-- Table structure for table `sf_guard_user_group`
121
DROP TABLE IF EXISTS `sf_guard_user_group`;
122
/*!40101 SET @saved_cs_client = @@character_set_client */;
123
/*!40101 SET character_set_client = utf8 */;
124
CREATE TABLE `sf_guard_user_group` (
125
`user_id` int(11) NOT NULL DEFAULT '0',
126
`group_id` int(11) NOT NULL DEFAULT '0',
127
`created_at` datetime NOT NULL,
128
`updated_at` datetime NOT NULL,
129
PRIMARY KEY (`user_id`,`group_id`),
130
KEY `sf_guard_user_group_group_id_sf_guard_group_id` (`group_id`),
131
CONSTRAINT `sf_guard_user_group_group_id_sf_guard_group_id` FOREIGN KEY (`group_id`) REFERENCES `sf_guard_group` (`id`) ON DELETE CASCADE,
132
CONSTRAINT `sf_guard_user_group_user_id_sf_guard_user_id` FOREIGN KEY (`user_id`) REFERENCES `sf_guard_user` (`id`) ON DELETE CASCADE
133
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
134
/*!40101 SET character_set_client = @saved_cs_client */;
137
-- Table structure for table `sf_guard_user_permission`
140
DROP TABLE IF EXISTS `sf_guard_user_permission`;
141
/*!40101 SET @saved_cs_client = @@character_set_client */;
142
/*!40101 SET character_set_client = utf8 */;
143
CREATE TABLE `sf_guard_user_permission` (
144
`user_id` int(11) NOT NULL DEFAULT '0',
145
`permission_id` int(11) NOT NULL DEFAULT '0',
146
`created_at` datetime NOT NULL,
147
`updated_at` datetime NOT NULL,
148
PRIMARY KEY (`user_id`,`permission_id`),
149
KEY `sf_guard_user_permission_permission_id_sf_guard_permission_id` (`permission_id`),
150
CONSTRAINT `sf_guard_user_permission_permission_id_sf_guard_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `sf_guard_permission` (`id`) ON DELETE CASCADE,
151
CONSTRAINT `sf_guard_user_permission_user_id_sf_guard_user_id` FOREIGN KEY (`user_id`) REFERENCES `sf_guard_user` (`id`) ON DELETE CASCADE
152
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
153
/*!40101 SET character_set_client = @saved_cs_client */;
154
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
156
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
157
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
158
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
159
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
160
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
161
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
162
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
164
-- Dump completed on 2010-07-06 11:22:55