DUNCM0sf

1/*
2 Navicat Premium Data Transfer
3
4 Source Server         : localhost
5 Source Server Type    : MySQL
6 Source Server Version : 50149
7 Source Host           : localhost
8 Source Database       : bobvilacms_dev
9
10 Target Server Type    : MySQL
11 Target Server Version : 50149
12 File Encoding         : utf-8
13
14 Date: 05/23/2011 13:37:05 PM
15*/
16
17SET NAMES utf8;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21--  Table structure for `images`
22-- ----------------------------
23DROP TABLE IF EXISTS `images`;
24CREATE TABLE `images` (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `image_mime_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
27  `image_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
28  `image_size` int(11) DEFAULT NULL,
29  `image_width` int(11) DEFAULT NULL,
30  `image_height` int(11) DEFAULT NULL,
31  `created_at` datetime DEFAULT NULL,
32  `updated_at` datetime DEFAULT NULL,
33  `image_uid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
34  `image_ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
35  PRIMARY KEY (`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
37
38-- ----------------------------
39--  Table structure for `page_part_translations`
40-- ----------------------------
41DROP TABLE IF EXISTS `page_part_translations`;
42CREATE TABLE `page_part_translations` (
43  `id` int(11) NOT NULL AUTO_INCREMENT,
44  `page_part_id` int(11) DEFAULT NULL,
45  `locale` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
46  `body` text COLLATE utf8_unicode_ci,
47  `created_at` datetime DEFAULT NULL,
48  `updated_at` datetime DEFAULT NULL,
49  PRIMARY KEY (`id`),
50  KEY `index_page_part_translations_on_page_part_id` (`page_part_id`)
51) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
52
53-- ----------------------------
54--  Table structure for `page_parts`
55-- ----------------------------
56DROP TABLE IF EXISTS `page_parts`;
57CREATE TABLE `page_parts` (
58  `id` int(11) NOT NULL AUTO_INCREMENT,
59  `page_id` int(11) DEFAULT NULL,
60  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
61  `body` text COLLATE utf8_unicode_ci,
62  `position` int(11) DEFAULT NULL,
63  `created_at` datetime DEFAULT NULL,
64  `updated_at` datetime DEFAULT NULL,
65  PRIMARY KEY (`id`),
66  KEY `index_page_parts_on_id` (`id`),
67  KEY `index_page_parts_on_page_id` (`page_id`)
68) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
69
70-- ----------------------------
71--  Table structure for `page_translations`
72-- ----------------------------
73DROP TABLE IF EXISTS `page_translations`;
74CREATE TABLE `page_translations` (
75  `id` int(11) NOT NULL AUTO_INCREMENT,
76  `page_id` int(11) DEFAULT NULL,
77  `locale` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
78  `custom_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
79  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
80  `created_at` datetime DEFAULT NULL,
81  `updated_at` datetime DEFAULT NULL,
82  PRIMARY KEY (`id`),
83  KEY `index_page_translations_on_page_id` (`page_id`)
84) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
85
86-- ----------------------------
87--  Table structure for `pages`
88-- ----------------------------
89DROP TABLE IF EXISTS `pages`;
90CREATE TABLE `pages` (
91  `id` int(11) NOT NULL AUTO_INCREMENT,
92  `parent_id` int(11) DEFAULT NULL,
93  `position` int(11) DEFAULT NULL,
94  `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
95  `created_at` datetime DEFAULT NULL,
96  `updated_at` datetime DEFAULT NULL,
97  `show_in_menu` tinyint(1) DEFAULT '1',
98  `link_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
99  `menu_match` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
100  `deletable` tinyint(1) DEFAULT '1',
101  `custom_title_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'none',
102  `draft` tinyint(1) DEFAULT '0',
103  `skip_to_first_child` tinyint(1) DEFAULT '0',
104  `lft` int(11) DEFAULT NULL,
105  `rgt` int(11) DEFAULT NULL,
106  `depth` int(11) DEFAULT NULL,
107  PRIMARY KEY (`id`),
108  KEY `index_pages_on_depth` (`depth`),
109  KEY `index_pages_on_id` (`id`),
110  KEY `index_pages_on_lft` (`lft`),
111  KEY `index_pages_on_parent_id` (`parent_id`),
112  KEY `index_pages_on_rgt` (`rgt`)
113) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
114
115-- ----------------------------
116--  Table structure for `refinery_settings`
117-- ----------------------------
118DROP TABLE IF EXISTS `refinery_settings`;
119CREATE TABLE `refinery_settings` (
120  `id` int(11) NOT NULL AUTO_INCREMENT,
121  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
122  `value` text COLLATE utf8_unicode_ci,
123  `destroyable` tinyint(1) DEFAULT '1',
124  `created_at` datetime DEFAULT NULL,
125  `updated_at` datetime DEFAULT NULL,
126  `scoping` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
127  `restricted` tinyint(1) DEFAULT '0',
128  `callback_proc_as_string` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
129  `form_value_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
130  PRIMARY KEY (`id`),
131  KEY `index_refinery_settings_on_name` (`name`)
132) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
133
134-- ----------------------------
135--  Table structure for `resources`
136-- ----------------------------
137DROP TABLE IF EXISTS `resources`;
138CREATE TABLE `resources` (
139  `id` int(11) NOT NULL AUTO_INCREMENT,
140  `file_mime_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
141  `file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
142  `file_size` int(11) DEFAULT NULL,
143  `created_at` datetime DEFAULT NULL,
144  `updated_at` datetime DEFAULT NULL,
145  `file_uid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
146  `file_ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
147  PRIMARY KEY (`id`)
148) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
149
150-- ----------------------------
151--  Table structure for `roles`
152-- ----------------------------
153DROP TABLE IF EXISTS `roles`;
154CREATE TABLE `roles` (
155  `id` int(11) NOT NULL AUTO_INCREMENT,
156  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
157  PRIMARY KEY (`id`)
158) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
159
160-- ----------------------------
161--  Table structure for `roles_users`
162-- ----------------------------
163DROP TABLE IF EXISTS `roles_users`;
164CREATE TABLE `roles_users` (
165  `user_id` int(11) DEFAULT NULL,
166  `role_id` int(11) DEFAULT NULL,
167  KEY `index_roles_users_on_role_id_and_user_id` (`role_id`,`user_id`),
168  KEY `index_roles_users_on_user_id_and_role_id` (`user_id`,`role_id`)
169) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
170
171-- ----------------------------
172--  Table structure for `schema_migrations`
173-- ----------------------------
174DROP TABLE IF EXISTS `schema_migrations`;
175CREATE TABLE `schema_migrations` (
176  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
177  UNIQUE KEY `unique_schema_migrations` (`version`)
178) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
179
180-- ----------------------------
181--  Table structure for `seo_meta`
182-- ----------------------------
183DROP TABLE IF EXISTS `seo_meta`;
184CREATE TABLE `seo_meta` (
185  `id` int(11) NOT NULL AUTO_INCREMENT,
186  `seo_meta_id` int(11) DEFAULT NULL,
187  `seo_meta_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
188  `browser_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
189  `meta_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
190  `meta_description` text COLLATE utf8_unicode_ci,
191  `created_at` datetime DEFAULT NULL,
192  `updated_at` datetime DEFAULT NULL,
193  PRIMARY KEY (`id`),
194  KEY `index_seo_meta_on_id` (`id`),
195  KEY `index_seo_meta_on_seo_meta_id_and_seo_meta_type` (`seo_meta_id`,`seo_meta_type`)
196) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
197
198-- ----------------------------
199--  Table structure for `slugs`
200-- ----------------------------
201DROP TABLE IF EXISTS `slugs`;
202CREATE TABLE `slugs` (
203  `id` int(11) NOT NULL AUTO_INCREMENT,
204  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
205  `sluggable_id` int(11) DEFAULT NULL,
206  `sequence` int(11) NOT NULL DEFAULT '1',
207  `sluggable_type` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
208  `scope` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
209  `created_at` datetime DEFAULT NULL,
210  `locale` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
211  PRIMARY KEY (`id`),
212  UNIQUE KEY `index_slugs_on_n_s_s_and_s` (`name`,`sluggable_type`,`scope`,`sequence`),
213  KEY `index_slugs_on_sluggable_id` (`sluggable_id`),
214  KEY `index_slugs_on_locale` (`locale`)
215) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
216
217-- ----------------------------
218--  Table structure for `user_plugins`
219-- ----------------------------
220DROP TABLE IF EXISTS `user_plugins`;
221CREATE TABLE `user_plugins` (
222  `id` int(11) NOT NULL AUTO_INCREMENT,
223  `user_id` int(11) DEFAULT NULL,
224  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
225  `position` int(11) DEFAULT NULL,
226  PRIMARY KEY (`id`),
227  UNIQUE KEY `index_unique_user_plugins` (`user_id`,`name`),
228  KEY `index_user_plugins_on_title` (`name`)
229) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
230
231-- ----------------------------
232--  Table structure for `users`
233-- ----------------------------
234DROP TABLE IF EXISTS `users`;
235CREATE TABLE `users` (
236  `id` int(11) NOT NULL AUTO_INCREMENT,
237  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
238  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
239  `encrypted_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
240  `persistence_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
241  `created_at` datetime DEFAULT NULL,
242  `updated_at` datetime DEFAULT NULL,
243  `perishable_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
244  `current_sign_in_at` datetime DEFAULT NULL,
245  `last_sign_in_at` datetime DEFAULT NULL,
246  `current_sign_in_ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
247  `last_sign_in_ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
248  `sign_in_count` int(11) DEFAULT NULL,
249  `remember_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
250  `reset_password_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
251  `remember_created_at` datetime DEFAULT NULL,
252  PRIMARY KEY (`id`),
253  KEY `index_users_on_id` (`id`)
254) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
255
256SET FOREIGN_KEY_CHECKS = 1;