· 8 years ago · Dec 23, 2017, 02:34 PM
11ntranet 3xpirum
2
3We are what we are...
4We are good for good...
5We are bad for too good...
6
7COGEL.ORG
8
9____________________________________________________________________________________________
10-- MySQL dump 10.11
11--
12-- Host: localhost Database: cogeladm_drupal610
13-- ------------------------------------------------------
14-- Server version 5.0.92-community
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8 */;
20/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
21/*!40103 SET TIME_ZONE='+00:00' */;
22/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
23/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
24/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
25/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
26
27--
28-- Temporary table structure for view `InstitustionsToEnter`
29--
30
31DROP TABLE IF EXISTS `InstitustionsToEnter`;
32/*!50001 DROP VIEW IF EXISTS `InstitustionsToEnter`*/;
33/*!50001 CREATE TABLE `InstitustionsToEnter` (
34 `fid` int(10) unsigned,
35 `uid` int(10) unsigned,
36 `value` text
37) ENGINE=MyISAM */;
38
39--
40-- Temporary table structure for view `Profiles`
41--
42
43DROP TABLE IF EXISTS `Profiles`;
44/*!50001 DROP VIEW IF EXISTS `Profiles`*/;
45/*!50001 CREATE TABLE `Profiles` (
46 `fid` int(10) unsigned,
47 `uid` int(10) unsigned,
48 `value` text
49) ENGINE=MyISAM */;
50
51--
52-- Temporary table structure for view `Roles`
53--
54
55DROP TABLE IF EXISTS `Roles`;
56/*!50001 DROP VIEW IF EXISTS `Roles`*/;
57/*!50001 CREATE TABLE `Roles` (
58 `uid` int(10) unsigned,
59 `rid` int(10) unsigned
60) ENGINE=MyISAM */;
61
62--
63-- Table structure for table `access`
64--
65
66DROP TABLE IF EXISTS `access`;
67/*!40101 SET @saved_cs_client = @@character_set_client */;
68/*!40101 SET character_set_client = utf8 */;
69CREATE TABLE `access` (
70 `aid` int(11) NOT NULL auto_increment,
71 `mask` varchar(255) NOT NULL default '',
72 `type` varchar(255) NOT NULL default '',
73 `status` tinyint(4) NOT NULL default '0',
74 PRIMARY KEY (`aid`)
75) ENGINE=MyISAM DEFAULT CHARSET=utf8;
76/*!40101 SET character_set_client = @saved_cs_client */;
77
78--
79-- Dumping data for table `access`
80--
81
82LOCK TABLES `access` WRITE;
83/*!40000 ALTER TABLE `access` DISABLE KEYS */;
84/*!40000 ALTER TABLE `access` ENABLE KEYS */;
85UNLOCK TABLES;
86
87--
88-- Table structure for table `accesslog`
89--
90
91DROP TABLE IF EXISTS `accesslog`;
92/*!40101 SET @saved_cs_client = @@character_set_client */;
93/*!40101 SET character_set_client = utf8 */;
94CREATE TABLE `accesslog` (
95 `aid` int(11) NOT NULL auto_increment,
96 `sid` varchar(64) NOT NULL default '',
97 `title` varchar(255) default NULL,
98 `path` varchar(255) default NULL,
99 `url` text,
100 `hostname` varchar(128) default NULL,
101 `uid` int(10) unsigned default '0',
102 `timer` int(10) unsigned NOT NULL default '0',
103 `timestamp` int(10) unsigned NOT NULL default '0',
104 PRIMARY KEY (`aid`),
105 KEY `accesslog_timestamp` (`timestamp`),
106 KEY `uid` (`uid`)
107) ENGINE=MyISAM DEFAULT CHARSET=utf8;
108/*!40101 SET character_set_client = @saved_cs_client */;
109
110--
111-- Dumping data for table `accesslog`
112--
113
114LOCK TABLES `accesslog` WRITE;
115/*!40000 ALTER TABLE `accesslog` DISABLE KEYS */;
116/*!40000 ALTER TABLE `accesslog` ENABLE KEYS */;
117UNLOCK TABLES;
118
119--
120-- Table structure for table `account_reminder`
121--
122
123DROP TABLE IF EXISTS `account_reminder`;
124/*!40101 SET @saved_cs_client = @@character_set_client */;
125/*!40101 SET character_set_client = utf8 */;
126CREATE TABLE `account_reminder` (
127 `uid` int(11) NOT NULL,
128 `last_reminder` int(11) default NULL,
129 `msg_cnt` int(11) default '0',
130 PRIMARY KEY (`uid`)
131) ENGINE=MyISAM DEFAULT CHARSET=utf8;
132/*!40101 SET character_set_client = @saved_cs_client */;
133
134--
135-- Dumping data for table `account_reminder`
136--
137
138LOCK TABLES `account_reminder` WRITE;
139/*!40000 ALTER TABLE `account_reminder` DISABLE KEYS */;
140INSERT INTO `account_reminder` (`uid`, `last_reminder`, `msg_cnt`) VALUES (3,1253733300,3),(332,1253733300,3),(341,1253733300,3),(342,1253733300,3),(371,1253733300,3),(386,1253733300,3),(387,1253733300,3),(390,1253733300,3),(412,1253733300,3),(425,1253733300,3),(439,1253733300,3),(441,1253733300,3),(443,1253733300,3),(452,1253733300,3),(484,1253733300,3),(487,1253733300,3),(495,1253733301,3),(497,1253733301,3),(715,1270131302,3),(718,1269987302,2),(708,1269465302,3),(509,1253733301,3),(510,1253733301,3),(511,1253733301,3),(512,1253733301,3),(513,1253733301,3),(514,1253733301,3),(515,1253733301,3),(516,1253733301,3),(517,1253733301,3),(518,1253733302,3),(531,1253733302,3),(532,1253733302,3),(534,1253733302,3),(535,1253733302,3),(536,1253733302,3),(537,1253733302,3),(678,1260836100,3),(652,1255558500,3),(545,1253736899,3),(546,1253740515,3),(601,1253740518,3),(548,1253740515,3),(549,1253740515,3),(551,1253740516,3),(554,1253740516,3),(719,1270055702,2),(705,1268176502,3),(558,1253740516,3),(560,1253740516,3),(561,1253740516,3),(562,1253740516,3),(563,1253740516,3),(564,1253740516,3),(565,1253740516,3),(566,1253740516,3),(567,1253740516,3),(568,1253740516,3),(569,1253740517,3),(572,1253740517,3),(576,1253740517,3),(577,1253740517,3),(579,1253740517,3),(581,1253740517,3),(582,1253740517,3),(583,1253740517,3),(585,1253740517,3),(660,1257106499,3),(600,1253740518,3),(590,1253740517,3),(591,1253740517,3),(592,1253740517,3),(593,1253740517,3),(594,1253740517,3),(595,1253740517,3),(597,1253740517,3),(661,1257261300,3),(599,1253740518,3),(604,1253740518,3),(717,1269900902,2),(729,1270034102,1),(608,1253740518,3),(611,1253740518,3),(612,1253740518,3),(613,1253740518,3),(616,1253744099,3),(618,1253744099,3),(627,1253744099,3),(699,1266250502,3),(720,1270070102,2);
141/*!40000 ALTER TABLE `account_reminder` ENABLE KEYS */;
142UNLOCK TABLES;
143
144--
145-- Table structure for table `acl`
146--
147
148DROP TABLE IF EXISTS `acl`;
149/*!40101 SET @saved_cs_client = @@character_set_client */;
150/*!40101 SET character_set_client = utf8 */;
151CREATE TABLE `acl` (
152 `acl_id` int(11) NOT NULL auto_increment,
153 `module` varchar(255) NOT NULL,
154 `name` varchar(255) default NULL,
155 PRIMARY KEY (`acl_id`)
156) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
157/*!40101 SET character_set_client = @saved_cs_client */;
158
159--
160-- Dumping data for table `acl`
161--
162
163LOCK TABLES `acl` WRITE;
164/*!40000 ALTER TABLE `acl` DISABLE KEYS */;
165INSERT INTO `acl` (`acl_id`, `module`, `name`) VALUES (1,'forum_access','1'),(2,'forum_access','50'),(3,'forum_access','2'),(4,'forum_access','55'),(5,'forum_access','9'),(6,'forum_access','56'),(7,'forum_access','23'),(8,'forum_access','7'),(9,'forum_access','6'),(10,'forum_access','28'),(11,'forum_access','27'),(12,'forum_access','8');
166/*!40000 ALTER TABLE `acl` ENABLE KEYS */;
167UNLOCK TABLES;
168
169--
170-- Table structure for table `acl_node`
171--
172
173DROP TABLE IF EXISTS `acl_node`;
174/*!40101 SET @saved_cs_client = @@character_set_client */;
175/*!40101 SET character_set_client = utf8 */;
176CREATE TABLE `acl_node` (
177 `acl_id` int(11) NOT NULL default '0',
178 `nid` int(11) NOT NULL default '0',
179 `grant_view` tinyint(3) unsigned NOT NULL default '0',
180 `grant_update` tinyint(3) unsigned NOT NULL default '0',
181 `grant_delete` tinyint(3) unsigned NOT NULL default '0',
182 `priority` smallint(6) NOT NULL default '0',
183 PRIMARY KEY (`acl_id`,`nid`),
184 KEY `nid` (`nid`)
185) ENGINE=MyISAM DEFAULT CHARSET=utf8;
186/*!40101 SET character_set_client = @saved_cs_client */;
187
188--
189-- Dumping data for table `acl_node`
190--
191
192LOCK TABLES `acl_node` WRITE;
193/*!40000 ALTER TABLE `acl_node` DISABLE KEYS */;
194INSERT INTO `acl_node` (`acl_id`, `nid`, `grant_view`, `grant_update`, `grant_delete`, `priority`) VALUES (2,441,1,1,1,0),(2,446,1,1,1,0),(2,461,1,1,1,0),(2,468,1,1,1,0),(2,476,1,1,1,0),(2,487,1,1,1,0),(2,506,1,1,1,0),(2,519,1,1,1,0),(2,529,1,1,1,0),(2,533,1,1,1,0),(2,539,1,1,1,0),(2,559,1,1,1,0),(2,612,1,1,1,0),(2,618,1,1,1,0),(2,664,1,1,1,0),(2,676,1,1,1,0),(2,678,1,1,1,0),(2,693,1,1,1,0),(2,708,1,1,1,0),(2,723,1,1,1,0),(2,729,1,1,1,0),(2,736,1,1,1,0),(2,778,1,1,1,0),(2,799,1,1,1,0),(2,805,1,1,1,0),(2,806,1,1,1,0),(6,816,1,1,1,0),(2,818,1,1,1,0),(2,827,1,1,1,0),(2,837,1,1,1,0),(2,841,1,1,1,0),(2,897,1,1,1,0),(2,909,1,1,1,0),(2,912,1,1,1,0),(2,913,1,1,1,0),(2,931,1,1,1,0),(2,937,1,1,1,0),(2,947,1,1,1,0),(2,948,1,1,1,0),(2,977,1,1,1,0),(3,131,1,1,1,0),(3,132,1,1,1,0),(3,140,1,1,1,0),(3,184,1,1,1,0),(3,185,1,1,1,0),(3,421,1,1,1,0),(3,437,1,1,1,0),(3,448,1,1,1,0),(3,482,1,1,1,0),(3,485,1,1,1,0),(3,548,1,1,1,0),(3,550,1,1,1,0),(3,666,1,1,1,0),(3,742,1,1,1,0),(3,768,1,1,1,0),(3,779,1,1,1,0),(3,813,1,1,1,0),(3,826,1,1,1,0),(3,853,1,1,1,0),(3,882,1,1,1,0),(3,938,1,1,1,0),(3,950,1,1,1,0),(4,753,1,1,1,0),(4,783,1,1,1,0),(4,943,1,1,1,0),(5,116,1,1,1,0),(5,424,1,1,1,0),(5,426,1,1,1,0),(5,429,1,1,1,0),(5,432,1,1,1,0),(5,442,1,1,1,0),(5,471,1,1,1,0),(5,478,1,1,1,0),(5,486,1,1,1,0),(5,510,1,1,1,0),(5,518,1,1,1,0),(5,530,1,1,1,0),(5,544,1,1,1,0),(5,601,1,1,1,0),(5,640,1,1,1,0),(5,701,1,1,1,0),(5,741,1,1,1,0),(5,792,1,1,1,0),(5,833,1,1,1,0),(5,840,1,1,1,0),(5,842,1,1,1,0),(5,847,1,1,1,0),(5,849,1,1,1,0),(5,886,1,1,1,0),(5,887,1,1,1,0),(5,910,1,1,1,0),(5,941,1,1,1,0),(6,703,1,1,1,0),(6,713,1,1,1,0),(7,472,1,1,1,0),(7,480,1,1,1,0),(7,491,1,1,1,0),(7,495,1,1,1,0),(7,553,1,1,1,0),(7,554,1,1,1,0),(7,570,1,1,1,0),(7,630,1,1,1,0),(7,659,1,1,1,0),(7,660,1,1,1,0),(7,679,1,1,1,0),(7,682,1,1,1,0),(7,707,1,1,1,0),(7,807,1,1,1,0),(7,829,1,1,1,0),(7,854,1,1,1,0),(7,855,1,1,1,0),(7,863,1,1,1,0),(7,872,1,1,1,0),(7,895,1,1,1,0),(7,929,1,1,1,0),(7,935,1,1,1,0),(7,940,1,1,1,0),(7,951,1,1,1,0),(8,459,1,1,1,0),(9,112,1,1,1,0),(9,113,1,1,1,0),(9,139,1,1,1,0),(9,143,1,1,1,0),(9,149,1,1,1,0),(9,396,1,1,1,0),(9,400,1,1,1,0),(9,402,1,1,1,0),(9,425,1,1,1,0),(9,438,1,1,1,0),(9,444,1,1,1,0),(9,483,1,1,1,0),(9,484,1,1,1,0),(9,488,1,1,1,0),(9,499,1,1,1,0),(9,525,1,1,1,0),(9,558,1,1,1,0),(9,573,1,1,1,0),(9,607,1,1,1,0),(9,667,1,1,1,0),(9,677,1,1,1,0),(9,680,1,1,1,0),(9,683,1,1,1,0),(9,744,1,1,1,0),(9,771,1,1,1,0),(9,775,1,1,1,0),(9,780,1,1,1,0),(9,784,1,1,1,0),(9,834,1,1,1,0),(9,836,1,1,1,0),(9,846,1,1,1,0),(9,848,1,1,1,0),(9,869,1,1,1,0),(9,875,1,1,1,0),(9,879,1,1,1,0),(9,883,1,1,1,0),(9,896,1,1,1,0),(9,899,1,1,1,0),(9,900,1,1,1,0),(9,904,1,1,1,0),(9,907,1,1,1,0),(9,928,1,1,1,0),(9,936,1,1,1,0),(10,505,1,1,1,0),(10,547,1,1,1,0),(10,611,1,1,1,0),(10,748,1,1,1,0),(11,147,1,1,1,0),(11,781,1,1,1,0),(12,556,1,1,1,0),(12,661,1,1,1,0),(12,663,1,1,1,0),(12,681,1,1,1,0),(12,772,1,1,1,0),(12,773,1,1,1,0),(12,791,1,1,1,0),(12,852,1,1,1,0),(2,983,1,1,1,0),(2,984,1,1,1,0),(5,989,1,1,1,0),(2,991,1,1,1,0),(9,992,1,1,1,0),(2,1010,1,1,1,0),(9,1012,1,1,1,0),(2,1027,1,1,1,0),(2,1032,1,1,1,0),(3,1037,1,1,1,0),(9,1039,1,1,1,0);
195/*!40000 ALTER TABLE `acl_node` ENABLE KEYS */;
196UNLOCK TABLES;
197
198--
199-- Table structure for table `acl_user`
200--
201
202DROP TABLE IF EXISTS `acl_user`;
203/*!40101 SET @saved_cs_client = @@character_set_client */;
204/*!40101 SET character_set_client = utf8 */;
205CREATE TABLE `acl_user` (
206 `acl_id` int(11) NOT NULL default '0',
207 `uid` int(11) NOT NULL default '0',
208 PRIMARY KEY (`acl_id`,`uid`),
209 KEY `uid` (`uid`)
210) ENGINE=MyISAM DEFAULT CHARSET=utf8;
211/*!40101 SET character_set_client = @saved_cs_client */;
212
213--
214-- Dumping data for table `acl_user`
215--
216
217LOCK TABLES `acl_user` WRITE;
218/*!40000 ALTER TABLE `acl_user` DISABLE KEYS */;
219/*!40000 ALTER TABLE `acl_user` ENABLE KEYS */;
220UNLOCK TABLES;
221
222--
223-- Table structure for table `actions`
224--
225
226DROP TABLE IF EXISTS `actions`;
227/*!40101 SET @saved_cs_client = @@character_set_client */;
228/*!40101 SET character_set_client = utf8 */;
229
230
231CREATE TABLE `actions` (
232 `aid` varchar(255) NOT NULL default '0',
233 `type` varchar(32) NOT NULL default '',
234 `callback` varchar(255) NOT NULL default '',
235 `parameters` longtext NOT NULL,
236 `description` varchar(255) NOT NULL default '0',
237 PRIMARY KEY (`aid`)
238) ENGINE=MyISAM DEFAULT CHARSET=utf8;
239/*!40101 SET character_set_client = @saved_cs_client */;
240
241--
242-- Dumping data for table `actions`
243--
244
245LOCK TABLES `actions` WRITE;
246/*!40000 ALTER TABLE `actions` DISABLE KEYS */;
247INSERT INTO `actions` (`aid`, `type`, `callback`, `parameters`, `description`) VALUES ('comment_unpublish_action','comment','comment_unpublish_action','','Unpublish comment'),('node_publish_action','node','node_publish_action','','Publish post'),('node_unpublish_action','node','node_unpublish_action','','Unpublish post'),('node_make_sticky_action','node','node_make_sticky_action','','Make post sticky'),('node_make_unsticky_action','node','node_make_unsticky_action','','Make post unsticky'),('node_promote_action','node','node_promote_action','','Promote post to front page'),('node_unpromote_action','node','node_unpromote_action','','Remove post from front page'),('node_save_action','node','node_save_action','','Save post'),('user_block_user_action','user','user_block_user_action','','Block current user'),('user_block_ip_action','user','user_block_ip_action','','Ban IP address of current user'),('og_remove_groups_action','node','og_remove_groups_action','','Remove post from all groups'),('og_make_public_action','node','og_make_public_action','','Make post publicly visible'),('og_make_private_action','node','og_make_private_action','','Make post private to its groups');
248/*!40000 ALTER TABLE `actions` ENABLE KEYS */;
249UNLOCK TABLES;
250
251--
252-- Table structure for table `actions_aid`
253--
254
255DROP TABLE IF EXISTS `actions_aid`;
256/*!40101 SET @saved_cs_client = @@character_set_client */;
257/*!40101 SET character_set_client = utf8 */;
258CREATE TABLE `actions_aid` (
259 `aid` int(10) unsigned NOT NULL auto_increment,
260 PRIMARY KEY (`aid`)
261) ENGINE=MyISAM DEFAULT CHARSET=utf8;
262/*!40101 SET character_set_client = @saved_cs_client */;
263
264--
265-- Dumping data for table `actions_aid`
266--
267
268LOCK TABLES `actions_aid` WRITE;
269/*!40000 ALTER TABLE `actions_aid` DISABLE KEYS */;
270/*!40000 ALTER TABLE `actions_aid` ENABLE KEYS */;
271UNLOCK TABLES;
272
273--
274-- Table structure for table `authmap`
275--
276
277DROP TABLE IF EXISTS `authmap`;
278/*!40101 SET @saved_cs_client = @@character_set_client */;
279/*!40101 SET character_set_client = utf8 */;
280CREATE TABLE `authmap` (
281 `aid` int(10) unsigned NOT NULL auto_increment,
282 `uid` int(11) NOT NULL default '0',
283 `authname` varchar(128) NOT NULL default '',
284 `module` varchar(128) NOT NULL default '',
285 PRIMARY KEY (`aid`),
286 UNIQUE KEY `authname` (`authname`)
287) ENGINE=MyISAM DEFAULT CHARSET=utf8;
288/*!40101 SET character_set_client = @saved_cs_client */;
289
290--
291-- Dumping data for table `authmap`
292--
293
294LOCK TABLES `authmap` WRITE;
295/*!40000 ALTER TABLE `authmap` DISABLE KEYS */;
296/*!40000 ALTER TABLE `authmap` ENABLE KEYS */;
297UNLOCK TABLES;
298
299--
300-- Table structure for table `autoassignrole`
301--
302
303DROP TABLE IF EXISTS `autoassignrole`;
304/*!40101 SET @saved_cs_client = @@character_set_client */;
305/*!40101 SET character_set_client = utf8 */;
306CREATE TABLE `autoassignrole` (
307 `arid` varchar(38) NOT NULL default '',
308 `value` text,
309 PRIMARY KEY (`arid`)
310) ENGINE=MyISAM DEFAULT CHARSET=utf8;
311/*!40101 SET character_set_client = @saved_cs_client */;
312
313--
314-- Dumping data for table `autoassignrole`
315--
316
317LOCK TABLES `autoassignrole` WRITE;
318/*!40000 ALTER TABLE `autoassignrole` DISABLE KEYS */;
319INSERT INTO `autoassignrole` (`arid`, `value`) VALUES ('auto_roles','a:0:{}'),('auto_active','0'),('user_active','0'),('user_roles','a:0:{}'),('user_required','0'),('user_multiple','0'),('user_description',''),('user_title','Role'),('user_fieldset_title','User Roles'),('user_sort','SORT_ASC'),('user_selection','2'),('page_active','0'),('auto_admin_active','0'),('node_user_register','');
320/*!40000 ALTER TABLE `autoassignrole` ENABLE KEYS */;
321UNLOCK TABLES;
322
323--
324-- Table structure for table `autoassignrole_page`
325--
326
327DROP TABLE IF EXISTS `autoassignrole_page`;
328/*!40101 SET @saved_cs_client = @@character_set_client */;
329/*!40101 SET character_set_client = utf8 */;
330CREATE TABLE `autoassignrole_page` (
331 `rid` int(11) NOT NULL,
332 `display` text NOT NULL,
333 `path` varchar(255) NOT NULL,
334 `title` text NOT NULL,
335 `description` longtext,
336 `format` tinyint(4) default NULL,
337 `weight` tinyint(4) default '0',
338 `menu` varchar(255) default NULL,
339 `registration` tinyint(4) default '0',
340 PRIMARY KEY (`rid`)
341) ENGINE=MyISAM DEFAULT CHARSET=utf8;
342/*!40101 SET character_set_client = @saved_cs_client */;
343
344--
345-- Dumping data for table `autoassignrole_page`
346--
347
348LOCK TABLES `autoassignrole_page` WRITE;
349/*!40000 ALTER TABLE `autoassignrole_page` DISABLE KEYS */;
350/*!40000 ALTER TABLE `autoassignrole_page` ENABLE KEYS */;
351UNLOCK TABLES;
352
353--
354-- Table structure for table `batch`
355--
356
357DROP TABLE IF EXISTS `batch`;
358/*!40101 SET @saved_cs_client = @@character_set_client */;
359/*!40101 SET character_set_client = utf8 */;
360CREATE TABLE `batch` (
361 `bid` int(10) unsigned NOT NULL auto_increment,
362 `token` varchar(64) NOT NULL,
363 `timestamp` int(11) NOT NULL,
364 `batch` longtext,
365 PRIMARY KEY (`bid`),
366 KEY `token` (`token`)
367) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;
368/*!40101 SET character_set_client = @saved_cs_client */;
369
370--
371-- Dumping data for table `batch`
372--
373
374LOCK TABLES `batch` WRITE;
375/*!40000 ALTER TABLE `batch` DISABLE KEYS */;
376/*!40000 ALTER TABLE `batch` ENABLE KEYS */;
377UNLOCK TABLES;
378
379--
380-- Table structure for table `blocks`
381--
382
383DROP TABLE IF EXISTS `blocks`;
384/*!40101 SET @saved_cs_client = @@character_set_client */;
385/*!40101 SET character_set_client = utf8 */;
386CREATE TABLE `blocks` (
387 `bid` int(11) NOT NULL auto_increment,
388 `module` varchar(64) NOT NULL default '',
389 `delta` varchar(32) NOT NULL default '0',
390 `theme` varchar(64) NOT NULL default '',
391 `status` tinyint(4) NOT NULL default '0',
392 `weight` tinyint(4) NOT NULL default '0',
393 `region` varchar(64) NOT NULL default '',
394 `custom` tinyint(4) NOT NULL default '0',
395 `throttle` tinyint(4) NOT NULL default '0',
396 `visibility` tinyint(4) NOT NULL default '0',
397 `pages` text NOT NULL,
398 `title` varchar(64) NOT NULL default '',
399 `cache` tinyint(4) NOT NULL default '1',
400 PRIMARY KEY (`bid`),
401 UNIQUE KEY `tmd` (`theme`,`module`,`delta`),
402 KEY `list` (`theme`,`status`,`region`,`weight`,`module`)
403) ENGINE=MyISAM AUTO_INCREMENT=193 DEFAULT CHARSET=utf8;
404/*!40101 SET character_set_client = @saved_cs_client */;
405
406--
407-- Dumping data for table `blocks`
408--
409
410LOCK TABLES `blocks` WRITE;
411/*!40000 ALTER TABLE `blocks` DISABLE KEYS */;
412INSERT INTO `blocks` (`bid`, `module`, `delta`, `theme`, `status`, `weight`, `region`, `custom`, `throttle`, `visibility`, `pages`, `title`, `cache`) VALUES (1,'user','0','garland',1,-8,'left',0,0,0,'node/16\r\nnode/15','User Information',-1),(2,'user','1','garland',1,-7,'left',0,0,0,'','Account Information',-1),(3,'system','0','garland',0,-6,'',0,0,1,'<front>','',-1),(4,'system','0','amity_island',0,-15,'',0,0,1,'<front>','',-1),(5,'user','0','amity_island',1,-10,'left',0,0,0,'node/16\r\nnode/15','User Information',-1),(6,'user','1','amity_island',1,-16,'left',0,0,0,'','Account Information',-1),(7,'system','0','pushbutton',1,10,'footer',0,0,1,'<front>','',-1),(8,'user','0','pushbutton',1,0,'left',0,0,0,'node/16\r\nnode/15','User Information',-1),(9,'user','1','pushbutton',1,0,'left',0,0,0,'','Account Information',-1),(10,'comment','0','garland',0,-4,'',0,0,1,'forum','',1),(11,'menu','primary-links','garland',0,-5,'',0,0,0,'','',-1),(12,'menu','secondary-links','garland',0,-2,'',0,0,0,'','',-1),(13,'node','0','garland',0,-1,'',0,0,1,'<front>','',-1),(14,'profile','0','garland',0,-5,'',0,0,0,'','',5),(15,'search','0','garland',0,-3,'',0,0,0,'','',-1),(16,'user','2','garland',0,0,'',0,0,1,'<front>','',1),(17,'user','3','garland',0,1,'',0,0,1,'forum','',-1),(18,'comment','0','amity_island',1,-15,'user1',0,0,1,'forum','',1),(19,'menu','primary-links','amity_island',1,-11,'primary',0,0,0,'','',-1),(20,'menu','secondary-links','amity_island',0,-11,'',0,0,0,'','',-1),(21,'node','0','amity_island',0,-10,'',0,0,1,'<front>','',-1),(22,'profile','0','amity_island',0,-14,'',0,0,0,'','',5),(23,'search','0','amity_island',0,-12,'',0,0,0,'','',-1),(24,'user','2','amity_island',0,-15,'',0,0,1,'<front>','',1),(25,'user','3','amity_island',0,-9,'',0,0,1,'forum','',-1),(43,'user','1','bluemarine',0,-10,'left',0,0,0,'','Account Information',-1),(28,'author_pane','0','garland',0,0,'',0,0,0,'','',1),(29,'forum','0','garland',0,0,'',0,0,1,'forum\r\n<front>','',1),(30,'forum','1','garland',1,-5,'left',0,0,1,'forum','',1),(41,'menu','menu-notused','amity_island',0,-6,'',0,0,0,'','',-1),(31,'author_pane','0','amity_island',0,-8,'',0,0,0,'','',1),(32,'uc_cart','0','amity_island',1,-9,'left',0,0,1,'<front>','',-1),(33,'forum','0','amity_island',1,-11,'user3',0,0,1,'forum\r\n<front>','',1),(34,'forum','1','amity_island',1,-10,'user2',0,0,1,'forum','',1),(35,'uc_cart','0','garland',0,0,'',0,0,1,'<front>','',-1),(37,'uc_catalog','0','amity_island',0,-7,'',0,0,0,'','',1),(42,'system','0','bluemarine',0,-11,'left',0,0,1,'<front>','',-1),(39,'block','3','amity_island',1,-11,'user2',0,0,0,'','Why You Should Go To...',-1),(40,'block','4','amity_island',1,-11,'user1',0,0,0,'','Membership Benefits',-1),(44,'user','2','bluemarine',0,-10,'left',0,0,1,'<front>','',1),(45,'comment','0','bluemarine',0,-9,'left',0,0,1,'forum','',1),(46,'profile','0','bluemarine',0,-8,'left',0,0,0,'','',5),(47,'search','0','bluemarine',0,-7,'left',0,0,0,'','',-1),(48,'menu','secondary-links','bluemarine',0,-6,'left',0,0,0,'','',-1),(49,'user','3','bluemarine',0,-5,'left',0,0,1,'forum','',-1),(50,'node','0','bluemarine',0,-4,'left',0,0,1,'<front>','',-1),(51,'author_pane','0','bluemarine',0,-3,'left',0,0,0,'','',1),(52,'uc_catalog','0','bluemarine',0,-2,'left',0,0,0,'','',1),(53,'menu','menu-notused','bluemarine',0,-1,'left',0,0,0,'','',-1),(54,'logintoboggan','0','bluemarine',0,0,'left',0,0,1,'<front>','',-1),(55,'uc_cart','0','bluemarine',0,1,'left',0,0,1,'<front>','',-1),(56,'user','0','bluemarine',1,-9,'left',0,0,0,'node/16\r\nnode/15','User Information',-1),(57,'forum','0','bluemarine',1,-8,'left',0,0,1,'forum\r\n<front>','',1),(58,'forum','1','bluemarine',1,-7,'left',0,0,1,'forum','',1),(59,'menu','primary-links','bluemarine',1,-5,'left',0,0,0,'','',-1),(77,'block','7','bluemarine',0,0,'',0,0,1,'<front>','International Invitation',-1),(61,'block','3','bluemarine',1,0,'left',0,0,0,'','Why You Should Go To...',-1),(62,'block','4','bluemarine',1,0,'left',0,0,0,'','Membership Benefits',-1),(63,'menu','menu-cogeladmin','amity_island',1,-11,'left',0,0,1,'','',-1),(76,'block','7','amity_island',0,0,'',0,0,1,'<front>','International Invitation',-1),(65,'menu','menu-cogeladmin','bluemarine',0,0,'',0,0,1,'','',-1),(78,'notifications_ui','0','amity_island',0,1,'',0,0,0,'','',1),(67,'menu','menu-positions','amity_island',1,0,'right',0,0,1,'<front>','',-1),(185,'block','10','amity_island',1,-15,'left',0,0,1,'<front>','Membership Renewal',-1),(186,'block','10','garland',0,0,'',0,0,1,'<front>','Membership Renewal',-1),(72,'block','5','amity_island',0,-13,'',0,0,0,'<front>','Upcoming Events',-1),(73,'block','5','bluemarine',0,0,'',0,0,0,'<front>','Upcoming Events',-1),(74,'block','6','amity_island',0,-1,'',0,0,1,'ode/add/convention-dec','Reminder',-1),(75,'block','6','bluemarine',0,0,'',0,0,1,'ode/add/convention-dec','Reminder',-1),(79,'block','8','amity_island',1,-15,'contentbottom',0,0,1,'node/add/convention-dec','',-1),(80,'block','8','bluemarine',0,0,'',0,0,1,'node/add/convention-dec','',-1),(81,'block','9','amity_island',1,0,'contentbottom',0,0,1,'node/add/convention-dec','',-1),(82,'block','9','bluemarine',0,0,'',0,0,1,'node/add/convention-dec','',-1),(121,'author_pane','0','rootcandy',0,-8,'admin_left',0,0,0,'','',1),(83,'author_pane','0','marvin',0,-8,'left',0,0,0,'','',1),(84,'block','3','marvin',1,-11,'left',0,0,0,'','Why You Should Go To...',-1),(85,'block','4','marvin',1,-11,'left',0,0,0,'','Membership Benefits',-1),(86,'block','5','marvin',1,-14,'left',0,0,0,'<front>','Upcoming Events',-1),(87,'block','6','marvin',0,-1,'left',0,0,1,'ode/add/convention-dec','',-1),(88,'block','7','marvin',1,0,'left',0,0,1,'<front>','International Invitation',-1),(89,'block','8','marvin',1,-16,'left',0,0,1,'node/add/convention-dec','',-1),(90,'block','9','marvin',1,0,'left',0,0,1,'node/add/convention-dec','',-1),(91,'comment','0','marvin',1,-15,'left',0,0,1,'forum','',1),(92,'forum','0','marvin',1,-11,'left',0,0,1,'forum\r\n<front>','',1),(93,'forum','1','marvin',1,-10,'left',0,0,1,'forum','',1),(94,'logintoboggan','0','marvin',0,-13,'left',0,0,1,'<front>','',-1),(95,'menu','menu-cogeladmin','marvin',1,-9,'left',0,0,1,'','',-1),(96,'menu','menu-notused','marvin',0,-6,'left',0,0,0,'','',-1),(97,'menu','menu-positions','marvin',1,0,'right',0,0,1,'<front>','',-1),(98,'menu','primary-links','marvin',1,-11,'left',0,0,0,'','',-1),(99,'menu','secondary-links','marvin',0,-11,'left',0,0,0,'','',-1),(100,'node','0','marvin',0,-10,'left',0,0,1,'<front>','',-1),(101,'notifications_ui','0','marvin',0,0,'left',0,0,0,'','',1),(102,'profile','0','marvin',0,-14,'left',0,0,0,'','',5),(103,'search','0','marvin',0,-12,'left',0,0,0,'','',-1),(104,'system','0','marvin',0,-16,'left',0,0,1,'<front>','',-1),(105,'uc_cart','0','marvin',1,-8,'left',0,0,1,'<front>','',-1),(106,'uc_catalog','0','marvin',0,-7,'left',0,0,0,'','',1),(107,'user','0','marvin',1,-10,'left',0,0,0,'node/16\r\nnode/15','',-1),(108,'user','1','marvin',1,-11,'left',0,0,0,'','Account Information',-1),(109,'user','2','marvin',0,-15,'left',0,0,1,'<front>','',1),(110,'user','3','marvin',0,-9,'left',0,0,1,'forum','',-1),(111,'views','new_products-block_1','marvin',0,-5,'left',0,0,0,'','',-1),(112,'views','popular_products-block_1','marvin',0,-4,'left',0,0,0,'','',-1),(113,'views','product_pairs_block-block_1','marvin',0,-3,'left',0,0,0,'','',-1),(114,'views','user_products-block_1','marvin',0,-2,'left',0,0,0,'','',-1),(115,'system','0','minnelli',1,10,'footer',0,0,1,'<front>','',-1),(116,'user','0','minnelli',1,0,'left',0,0,0,'node/16\r\nnode/15','',-1),(117,'user','1','minnelli',1,0,'left',0,0,0,'','Account Information',-1),(118,'system','0','chameleon',1,10,'left',0,0,1,'<front>','',-1),(119,'user','0','chameleon',1,0,'left',0,0,0,'node/16\r\nnode/15','',-1),(120,'user','1','chameleon',1,0,'left',0,0,0,'','Account Information',-1),(122,'block','3','rootcandy',1,-11,'admin_left',0,0,0,'','Why You Should Go To...',-1),(123,'block','4','rootcandy',1,-11,'admin_left',0,0,0,'','Membership Benefits',-1),(124,'block','5','rootcandy',1,-14,'admin_left',0,0,0,'<front>','Upcoming Events',-1),(125,'block','6','rootcandy',0,-1,'admin_left',0,0,1,'ode/add/convention-dec','',-1),(126,'block','7','rootcandy',1,0,'admin_left',0,0,1,'<front>','International Invitation',-1),(127,'block','8','rootcandy',1,-16,'admin_left',0,0,1,'node/add/convention-dec','',-1),(128,'block','9','rootcandy',1,0,'admin_left',0,0,1,'node/add/convention-dec','',-1),(129,'comment','0','rootcandy',1,-15,'admin_left',0,0,1,'forum','',1),(130,'forum','0','rootcandy',1,-11,'admin_left',0,0,1,'forum\r\n<front>','',1),(131,'forum','1','rootcandy',1,-10,'admin_left',0,0,1,'forum','',1),(132,'menu','menu-cogeladmin','rootcandy',1,-15,'admin_left',0,0,1,'','',-1),(133,'menu','menu-notused','rootcandy',0,-6,'admin_left',0,0,0,'','',-1),(134,'menu','menu-positions','rootcandy',1,0,'admin_left',0,0,1,'<front>','',-1),(135,'menu','primary-links','rootcandy',1,-11,'admin_left',0,0,0,'','',-1),(136,'menu','secondary-links','rootcandy',0,-11,'admin_left',0,0,0,'','',-1),(137,'node','0','rootcandy',0,-10,'admin_left',0,0,1,'<front>','',-1),(138,'notifications_ui','0','rootcandy',0,0,'admin_left',0,0,0,'','',1),(139,'profile','0','rootcandy',0,-14,'admin_left',0,0,0,'','',5),(140,'search','0','rootcandy',0,-12,'admin_left',0,0,0,'','',-1),(141,'system','0','rootcandy',0,-16,'admin_left',0,0,1,'<front>','',-1),(142,'uc_cart','0','rootcandy',1,-13,'admin_left',0,0,1,'<front>','',-1),(143,'uc_catalog','0','rootcandy',0,-7,'admin_left',0,0,0,'','',1),(144,'user','0','rootcandy',1,-14,'admin_left',0,0,0,'node/16\r\nnode/15','',-1),(145,'user','1','rootcandy',1,-16,'admin_left',0,0,0,'','Account Information',-1),(146,'user','2','rootcandy',0,-15,'admin_left',0,0,1,'<front>','',1),(147,'user','3','rootcandy',0,-9,'admin_left',0,0,1,'forum','',-1),(148,'views','new_products-block_1','rootcandy',0,-5,'admin_left',0,0,0,'','',-1),(149,'views','popular_products-block_1','rootcandy',0,-4,'admin_left',0,0,0,'','',-1),(150,'views','product_pairs_block-block_1','rootcandy',0,-3,'admin_left',0,0,0,'','',-1),(151,'views','user_products-block_1','rootcandy',0,-2,'admin_left',0,0,0,'','',-1),(152,'author_pane','0','amity_island_new',0,-8,'',0,0,0,'','',1),(153,'block','3','amity_island_new',1,-11,'user2',0,0,0,'','Why You Should Go To...',-1),(154,'block','4','amity_island_new',1,-11,'user3',0,0,0,'','Membership Benefits',-1),(155,'block','5','amity_island_new',1,-14,'user1',0,0,0,'<front>','Upcoming Events',-1),(156,'block','6','amity_island_new',0,-1,'',0,0,1,'ode/add/convention-dec','',-1),(157,'block','7','amity_island_new',1,0,'user1',0,0,1,'<front>','International Invitation',-1),(158,'block','8','amity_island_new',1,-16,'contentbottom',0,0,1,'node/add/convention-dec','',-1),(159,'block','9','amity_island_new',1,0,'contentbottom',0,0,1,'node/add/convention-dec','',-1),(160,'comment','0','amity_island_new',1,-15,'user1',0,0,1,'forum','',1),(161,'forum','0','amity_island_new',1,-11,'user3',0,0,1,'forum\r\n<front>','',1),(162,'forum','1','amity_island_new',1,-10,'user2',0,0,1,'forum','',1),(163,'menu','menu-cogeladmin','amity_island_new',1,-15,'left',0,0,1,'','',-1),(164,'menu','menu-notused','amity_island_new',0,-6,'',0,0,0,'','',-1),(165,'menu','menu-positions','amity_island_new',1,0,'right',0,0,1,'<front>','',-1),(166,'menu','primary-links','amity_island_new',1,-11,'primary',0,0,0,'','',-1),(167,'menu','secondary-links','amity_island_new',0,-11,'',0,0,0,'','',-1),(168,'node','0','amity_island_new',0,-10,'',0,0,1,'<front>','',-1),(169,'notifications_ui','0','amity_island_new',0,0,'',0,0,0,'','',1),(170,'profile','0','amity_island_new',0,-14,'',0,0,0,'','',5),(171,'search','0','amity_island_new',0,-12,'',0,0,0,'','',-1),(172,'system','0','amity_island_new',0,-16,'',0,0,1,'<front>','',-1),(173,'uc_cart','0','amity_island_new',1,-13,'left',0,0,1,'<front>','',-1),(174,'uc_catalog','0','amity_island_new',0,-7,'',0,0,0,'','',1),(175,'user','0','amity_island_new',1,-14,'left',0,0,0,'node/16\r\nnode/15','',-1),(176,'user','1','amity_island_new',1,-16,'left',0,0,0,'','Account Information',-1),(177,'user','2','amity_island_new',0,-15,'',0,0,1,'<front>','',1),(178,'user','3','amity_island_new',0,-9,'',0,0,1,'forum','',-1),(179,'views','new_products-block_1','amity_island_new',0,-5,'',0,0,0,'','',-1),(180,'views','popular_products-block_1','amity_island_new',0,-4,'',0,0,0,'','',-1),(181,'views','product_pairs_block-block_1','amity_island_new',0,-3,'',0,0,0,'','',-1),(182,'views','user_products-block_1','amity_island_new',0,-2,'',0,0,0,'','',-1),(183,'logintoboggan','0','amity_island_new',0,0,'',0,0,0,'','',-1),(184,'logintoboggan','0','amity_island',0,0,'',0,0,0,'','',-1),(187,'block','11','amity_island',1,-12,'left',0,0,1,'<front>','Membership Renewal',-1),(188,'block','11','garland',0,0,'',0,0,1,'<front>','Membership Renewal',-1),(189,'block','12','amity_island',1,-14,'left',0,0,1,'<front>','Membership Renewal',-1),(190,'block','12','garland',0,0,'',0,0,1,'<front>','Membership Renewal',-1),(191,'block','13','amity_island',1,-13,'left',0,0,1,'<front>','Membership Renewal',-1),(192,'block','13','garland',0,0,'',0,0,1,'<front>','Membership Renewal',-1);
413/*!40000 ALTER TABLE `blocks` ENABLE KEYS */;
414UNLOCK TABLES;
415
416--
417-- Table structure for table `blocks_roles`
418--
419
420DROP TABLE IF EXISTS `blocks_roles`;
421/*!40101 SET @saved_cs_client = @@character_set_client */;
422/*!40101 SET character_set_client = utf8 */;
423CREATE TABLE `blocks_roles` (
424 `module` varchar(64) NOT NULL,
425 `delta` varchar(32) NOT NULL,
426 `rid` int(10) unsigned NOT NULL,
427 PRIMARY KEY (`module`,`delta`,`rid`),
428 KEY `rid` (`rid`)
429) ENGINE=MyISAM DEFAULT CHARSET=utf8;
430/*!40101 SET character_set_client = @saved_cs_client */;
431
432--
433-- Dumping data for table `blocks_roles`
434--
435
436LOCK TABLES `blocks_roles` WRITE;
437/*!40000 ALTER TABLE `blocks_roles` DISABLE KEYS */;
438INSERT INTO `blocks_roles` (`module`, `delta`, `rid`) VALUES ('block','10',3),('block','10',6),('block','10',10),('block','11',3),('block','11',10),('block','11',11),('block','12',3),('block','12',5),('block','12',10),('block','13',3),('block','13',7),('block','13',10),('block','3',1),('block','3',2),('block','3',3),('block','3',4),('block','3',5),('block','3',6),('block','3',7),('block','3',8),('block','3',9),('block','3',10),('block','3',11),('block','3',12),('block','3',13),('block','4',1),('block','4',2),('block','4',9),('block','4',10),('block','4',13),('block','5',1),('block','5',2),('block','5',10),('block','6',3),('block','6',4),('block','6',5),('block','6',6),('block','6',7),('block','6',8),('block','6',10),('block','7',1),('block','7',2),('block','7',4),('block','7',5),('block','7',6),('block','7',7),('block','7',8),('block','7',11),('block','8',1),('block','9',4),('block','9',5),('block','9',6),('block','9',7),('block','9',8),('block','9',9),('comment','0',3),('comment','0',4),('comment','0',5),('comment','0',6),('comment','0',7),('comment','0',8),('comment','0',10),('comment','0',11),('forum','0',2),('forum','0',3),('forum','0',4),('forum','0',5),('forum','0',6),('forum','0',7),('forum','0',8),('forum','1',3),('forum','1',4),('forum','1',5),('forum','1',6),('forum','1',7),('forum','1',8),('forum','1',10),('forum','1',11),('menu','menu-cogeladmin',3),('menu','menu-cogeladmin',10),('menu','menu-positions',2),('menu','menu-positions',3),('menu','menu-positions',4),('menu','menu-positions',5),('menu','menu-positions',6),('menu','menu-positions',7),('menu','menu-positions',8),('menu','menu-positions',10),('menu','primary-links',1),('menu','primary-links',2),('menu','primary-links',3),('menu','primary-links',4),('menu','primary-links',5),('menu','primary-links',6),('menu','primary-links',7),('menu','primary-links',8),('menu','primary-links',10),('menu','primary-links',11),('menu','primary-links',12),('menu','primary-links',13),('user','1',3),('user','1',4),('user','1',5),('user','1',6),('user','1',7),('user','1',8),('user','1',10),('user','1',11);
439/*!40000 ALTER TABLE `blocks_roles` ENABLE KEYS */;
440UNLOCK TABLES;
441
442--
443-- Table structure for table `boxes`
444--
445
446DROP TABLE IF EXISTS `boxes`;
447/*!40101 SET @saved_cs_client = @@character_set_client */;
448/*!40101 SET character_set_client = utf8 */;
449CREATE TABLE `boxes` (
450 `bid` int(10) unsigned NOT NULL auto_increment,
451 `body` longtext,
452 `info` varchar(128) NOT NULL default '',
453 `format` smallint(6) NOT NULL default '0',
454 PRIMARY KEY (`bid`),
455 UNIQUE KEY `info` (`info`)
456) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
457/*!40101 SET character_set_client = @saved_cs_client */;