3 -- http://www.phpmyadmin.net
6 -- Generation Time: Apr 24, 2010 at 07:11 PM
7 -- Server version: 5.1.37
8 -- PHP Version: 5.2.10-2ubuntu6.4
10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
13 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16 /*!40101 SET NAMES utf8 */;
19 -- Database: `dev_install`
22 -- --------------------------------------------------------
25 -- Table structure for table `blocks`
28 CREATE TABLE IF NOT EXISTS `blocks` (
29 `bid` smallint(6) NOT NULL AUTO_INCREMENT,
30 `title` varchar(50) DEFAULT NULL,
32 `owner` varchar(50) NOT NULL,
33 `format` tinyint(4) NOT NULL DEFAULT '1',
36 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
39 -- Dumping data for table `blocks`
42 INSERT INTO `blocks` (`bid`, `title`, `body`, `owner`, `format`, `form`) VALUES
43 (2, 'My account', 'global $block_settings;\r\ncore_load(''menu'');\r\necho menu_load(3, $block_settings[''menu_type'']);', 'menu', 3, 'a:1:{s:9:"menu_type";a:6:{s:4:"type";s:6:"select";s:4:"text";s:9:"Menu Type";s:7:"options";a:2:{s:1:"v";s:8:"Vertical";s:1:"h";s:10:"Horizontal";}s:8:"use_keys";b:1;s:5:"value";s:1:"v";s:8:"required";b:1;}}'),
44 (3, 'Debug Info', 'global $user, $time;\r\necho ''<hr/>'';\r\nprintf("Memory: %s / %s Mb ", number_format(memory_get_usage()/1000000, 2), number_format(memory_get_peak_usage(TRUE)/1000000, 2));\r\necho ''in: '' . round(microtime_float() - $time, 2) . " Seconds";\r\necho " With " . db_query(''DEBUG'') . " queries";\r\n?><pre><?php\r\nprint_r($settings);\r\nprint_r($user);\r\necho $x;\r\necho $xx;\r\necho ''Session name: '' . session_name();echo ''<br>'';\r\necho ''Session Id: '' . session_id();\r\n$loaded_files = core_load(''PRINT_FOR_DEBUG'');\r\nprint_r($loaded_files);\r\n?></pre>', 'system', 3, NULL),
45 (13, 'Footer', '<a href="http://estigi.org">esTigi</a> is (will) be a true CMS option specially designed for usability, stability and performance.\r\nCurrently using a modification of the <a href="http://drupal.org/project/bluebreeze">Bluebreeze</a> Theme with the logo of <a href="http://drupal.org/project/tendu">Tendu</a> (Looking for a maintainer by the way)\r\nYou can always get the latest development version with: git clone git://repo.or.cz/estigi.git\r\nor view the public repository at <a href="http://repo.or.cz/w/estigi.git">http://repo.or.cz/w/estigi.git</a>', '1', 1, NULL),
46 (1, 'esTigi', 'global $block_settings;\r\ncore_load(''menu'');\r\necho menu_load(1, $block_settings[''menu_type'']);', 'menu', 3, ' $tmp_form[''menu_type''] = array(\r\n ''type'' => ''select'',\r\n ''text'' => ''Menu Type'',\r\n ''options'' => array(''v'' => ''Vertical'', ''h'' => ''Horizontal''),\r\n ''use_keys'' => TRUE,\r\n ''value'' => ''v'',\r\n ''required'' => TRUE\r\n );'),
47 (19, 'Login', 'echo path_link(''user'', ''Login'', ''Login to your account'');\r\necho ''<br>'';\r\necho path_link(''user/register'', ''Register'', ''Register a new account'');', '1', 3, NULL);
49 -- --------------------------------------------------------
52 -- Table structure for table `blocks_regions`
55 CREATE TABLE IF NOT EXISTS `blocks_regions` (
56 `rid` smallint(6) NOT NULL AUTO_INCREMENT,
57 `bid` smallint(6) NOT NULL,
58 `region` varchar(50) DEFAULT NULL,
59 `skin` varchar(50) DEFAULT NULL,
60 `title_ov` varchar(255) DEFAULT NULL,
61 `def_view` varchar(4) DEFAULT 'av',
62 `roles` varchar(255) DEFAULT NULL,
63 `pages_type` tinyint(4) NOT NULL DEFAULT '0',
65 `status` tinyint(4) NOT NULL DEFAULT '0',
67 `pos` tinyint(4) NOT NULL DEFAULT '0',
69 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=61 ;
72 -- Dumping data for table `blocks_regions`
75 INSERT INTO `blocks_regions` (`rid`, `bid`, `region`, `skin`, `title_ov`, `def_view`, `roles`, `pages_type`, `pages`, `status`, `settings`, `pos`) VALUES
76 (1, 1, 'left', 'bluebreeze', '', '', '', 0, '', 1, '', -10),
77 (2, 2, 'left', 'bluebreeze', '', '', '3', 0, '', 1, 'a:1:{s:9:"menu_type";s:1:"h";}', 0),
78 (10, 3, 'bottom', 'bluebreeze', 'Debug Info', '', '3', 0, '', 1, '', 0),
79 (52, 13, 'footer', 'bluebreeze', '<none>', '', '', 0, '', 1, '', -10),
80 (59, 19, 'left', 'bluebreeze', '', '', '2', 0, '', 1, '', 0),
81 (42, 2, 'primary', 'bluebreeze', '<none>', '', '3', 0, '', 1, 'a:1:{s:9:"menu_type";s:1:"h";}', 0);
83 -- --------------------------------------------------------
86 -- Table structure for table `cache`
89 CREATE TABLE IF NOT EXISTS `cache` (
90 `cid` varchar(255) NOT NULL DEFAULT '',
92 `expire` int(11) NOT NULL DEFAULT '0',
93 `created` int(11) NOT NULL DEFAULT '0',
94 `serialized` smallint(6) NOT NULL DEFAULT '0',
96 KEY `expire` (`expire`)
97 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
100 -- Dumping data for table `cache`
103 INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES
104 ('3e93afc959c26e46bb3c827b7978503d', 0x613a313a7b733a31323a2273797374656d5f61646d696e223b613a393a7b733a393a22736974655f6e616d65223b613a343a7b733a343a2274797065223b733a343a2274657874223b733a343a2274657874223b733a393a2253697465204e616d65223b733a353a2276616c7565223b733a32373a22657354696769202d20444556454c4f504d454e542043454e544552223b733a343a2273697a65223b693a35303b7d733a31313a22736974655f736c6f67616e223b613a343a7b733a343a2274797065223b733a343a2274657874223b733a343a2274657874223b733a363a22536c6f67616e223b733a353a2276616c7565223b733a32323a2254686520434d532076302e31207072652d616c706861223b733a343a2273697a65223b693a35303b7d733a393a22736974655f6d61696c223b613a343a7b733a343a2274797065223b733a343a2274657874223b733a343a2274657874223b733a31333a2244656661756c7420656d61696c223b733a353a2276616c7565223b733a31353a22696e666f4065737469672e6f636f6d223b733a343a2273697a65223b693a35303b7d733a393a22616e6f6e5f6e616d65223b613a343a7b733a343a2274797065223b733a343a2274657874223b733a343a2274657874223b733a31343a22416e6f6e796d6f7573206e616d65223b733a353a2276616c7565223b733a393a22416e6f6e796d6f7573223b733a343a2273697a65223b693a35303b7d733a31343a22736974655f66726f6e7470616765223b613a353a7b733a343a2274797065223b733a343a2274657874223b733a343a2274657874223b733a33313a2246726f6e74207061676520687474703a2f2f6c6f63616c686f73742f692f65223b733a343a2268656c70223b733a32303a224c6561766520626c616e6b20666f72206e6f6465223b733a353a2276616c7565223b733a343a226e6f6465223b733a343a2273697a65223b693a35303b7d733a393a22636c65616e5f75726c223b613a353a7b733a343a2274797065223b733a363a2273656c656374223b733a343a2274657874223b733a31353a2255736520636c65616e207061746873223b733a343a2268656c70223b733a3234333a2241766f696420273f783d2720696e207468652061646472657373206261722e204341524546554c4c2c20796f75206d6179206e6f742062652061626c6520746f2073656520616e797468696e6720696620796f75722073657276657220646f6573206e6f742063757272656e746c7920737570706f7274207468697320666561747572652e20496620796f752072756e20696e746f20616e792074726f75626c65207573652074686973206164647265737320746f207265636f6e66696775726520746869733a20687474703a2f2f6c6f63616c686f73742f692f3f783d73797374656d2f61646d696e2f73657474696e6773223b733a353a2276616c7565223b733a323a224e6f223b733a373a226f7074696f6e73223b613a323a7b693a303b733a323a224e6f223b693a313b733a333a22596573223b7d7d733a31303a2264656275675f696e666f223b613a353a7b733a343a2274797065223b733a363a2273656c656374223b733a343a2274657874223b733a31383a22446973706c617920446562756720696e666f223b733a343a2268656c70223b733a36313a22596f752073686f756c6420616c736f20656e61626c652074686520426c6f636b206173736f746961746564207769746820746869732066656174757265223b733a353a2276616c7565223b733a333a22596573223b733a373a226f7074696f6e73223b613a323a7b693a303b733a323a224e6f223b693a313b733a333a22596573223b7d7d733a393a2264625f6572726f7273223b613a353a7b733a343a2274797065223b733a363a2273656c656374223b733a343a2274657874223b733a32333a22446973706c6179204461746162617365206572726f7273223b733a353a2276616c7565223b733a31313a2253637265656e204f6e6c79223b733a373a226f7074696f6e73223b613a343a7b693a303b733a31313a2253637265656e204f6e6c79223b693a313b733a31393a2253637265656e20616e64204461746162617365223b693a323b733a31333a224461746162617365204f6e6c79223b693a333b733a31343a22446f206e6f7420446973706c6179223b7d733a343a2268656c70223b733a33383a22546869732077696c6c20626520646973706c6179656420666f7220616c6c2061636f756e7473223b7d733a363a227375626d6974223b613a323a7b733a343a2274797065223b733a363a227375626d6974223b733a353a2276616c7565223b733a363a225375626d6974223b7d7d7d, 1272157847, 1272157837, 1);
106 -- --------------------------------------------------------
109 -- Table structure for table `menu`
112 CREATE TABLE IF NOT EXISTS `menu` (
113 `mid` smallint(6) NOT NULL AUTO_INCREMENT,
114 `name` varchar(255) NOT NULL,
115 `parent` smallint(6) NOT NULL,
116 `url` varchar(255) NOT NULL,
117 `active` tinyint(1) NOT NULL,
118 `expand` tinyint(4) NOT NULL,
119 `pos` smallint(6) NOT NULL DEFAULT '0',
120 `target` varchar(50) NOT NULL,
121 `details` varchar(255) NOT NULL,
122 `owner` varchar(50) NOT NULL,
124 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
127 -- Dumping data for table `menu`
130 INSERT INTO `menu` (`mid`, `name`, `parent`, `url`, `active`, `expand`, `pos`, `target`, `details`, `owner`) VALUES
131 (1, 'Main', 0, '', 1, 1, 0, '', '', 'system'),
132 (2, 'Home', 1, '<front>', 1, 0, -10, '_parent', 'Go back to the home page', 'system'),
133 (3, 'User Panel', 0, '', 0, 0, 1, '_parent', '', 'user'),
134 (4, 'My Account', 3, 'user', 1, 0, 0, '_parent', 'View my account', 'user'),
135 (5, 'Log Out', 3, 'user/logout', 1, 0, 10, '', 'Log out of your account', 'user'),
136 (6, 'Control Center', 3, 'admin', 1, 1, -8, '_parent', 'Administer my account and/or this website', 'system');
138 -- --------------------------------------------------------
141 -- Table structure for table `node`
144 CREATE TABLE IF NOT EXISTS `node` (
145 `nid` int(10) unsigned NOT NULL AUTO_INCREMENT,
146 `type` varchar(32) NOT NULL DEFAULT '',
147 `language` varchar(12) NOT NULL DEFAULT '',
148 `title` varchar(255) NOT NULL DEFAULT '',
149 `uid` int(11) NOT NULL DEFAULT '0',
150 `status` int(11) NOT NULL DEFAULT '1',
151 `created` int(11) NOT NULL DEFAULT '0',
152 `changed` int(11) NOT NULL DEFAULT '0',
153 `comment` int(11) NOT NULL DEFAULT '0',
154 `promote` int(11) NOT NULL DEFAULT '0',
155 `moderate` int(11) NOT NULL DEFAULT '0',
156 `sticky` int(11) NOT NULL DEFAULT '0',
157 `tnid` int(10) unsigned NOT NULL DEFAULT '0',
158 `translate` int(11) NOT NULL DEFAULT '0',
160 KEY `node_changed` (`changed`),
161 KEY `node_created` (`created`),
162 KEY `node_moderate` (`moderate`),
163 KEY `node_promote_status` (`promote`,`status`),
164 KEY `node_status_type` (`status`,`type`,`nid`),
165 KEY `node_title_type` (`title`,`type`(4)),
166 KEY `node_type` (`type`(4)),
169 KEY `translate` (`translate`)
170 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
173 -- Dumping data for table `node`
176 INSERT INTO `node` (`nid`, `type`, `language`, `title`, `uid`, `status`, `created`, `changed`, `comment`, `promote`, `moderate`, `sticky`, `tnid`, `translate`) VALUES
177 (1, 'blog', '', 'First Announcement', 1, 1, 1248722835, 1248722835, 0, 1, 0, 0, 0, 0);
179 -- --------------------------------------------------------
182 -- Table structure for table `node_revisions`
185 CREATE TABLE IF NOT EXISTS `node_revisions` (
186 `nid` int(10) unsigned NOT NULL DEFAULT '0',
187 `uid` int(11) NOT NULL DEFAULT '0',
188 `title` varchar(255) NOT NULL DEFAULT '',
189 `body` longtext NOT NULL,
190 `teaser_full` tinyint(4) NOT NULL DEFAULT '0',
191 `log` longtext NOT NULL,
192 `timestamp` int(11) NOT NULL DEFAULT '0',
193 `format` int(11) NOT NULL DEFAULT '0',
194 `current` tinyint(4) NOT NULL DEFAULT '0',
195 `revision` int(11) NOT NULL,
198 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
201 -- Dumping data for table `node_revisions`
204 INSERT INTO `node_revisions` (`nid`, `uid`, `title`, `body`, `teaser_full`, `log`, `timestamp`, `format`, `current`, `revision`) VALUES
205 (1, 1, 'Welcome', 'Welcome to your new installation of esTigi.\r\n\r\nThis is a first pre-alpha version.\r\n\r\nYou may login using\r\nUser: root\r\nPassword: 123\r\n\r\nNot really much to do now, but many features coming soon....\r\n\r\nRegards.', 0, '', 1248722835, 1, 1, 2);
207 -- --------------------------------------------------------
210 -- Table structure for table `node_type`
213 CREATE TABLE IF NOT EXISTS `node_type` (
214 `type` varchar(32) NOT NULL,
215 `name` varchar(255) NOT NULL DEFAULT '',
216 `module` varchar(255) NOT NULL,
217 `description` mediumtext NOT NULL,
218 `title_label` varchar(255) NOT NULL DEFAULT '',
219 `body_label` varchar(255) NOT NULL DEFAULT '',
220 `min_word_count` smallint(5) unsigned NOT NULL,
221 `sticky` tinyint(4) NOT NULL DEFAULT '0',
222 `published` tinyint(4) NOT NULL DEFAULT '0',
223 `promoted` tinyint(4) NOT NULL DEFAULT '0',
225 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
228 -- Dumping data for table `node_type`
231 INSERT INTO `node_type` (`type`, `name`, `module`, `description`, `title_label`, `body_label`, `min_word_count`, `sticky`, `published`, `promoted`) VALUES
232 ('page', 'Page', 'node', 'this is the description', 'Title', 'Body', 0, 0, 0, 0),
233 ('blog', 'Blog entry', 'blog', 'this is the description', 'Blog Title', 'Blog', 0, 0, 0, 0),
234 ('forum', 'Forum', '', 'This is just a place holder while I develop the real module', 'Title', 'Body', 5, 0, 1, 0);
236 -- --------------------------------------------------------
239 -- Table structure for table `permission`
242 CREATE TABLE IF NOT EXISTS `permission` (
243 `pid` int(11) NOT NULL AUTO_INCREMENT,
244 `rid` int(10) unsigned NOT NULL DEFAULT '0',
246 `tid` int(10) unsigned NOT NULL DEFAULT '0',
249 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
252 -- Dumping data for table `permission`
255 INSERT INTO `permission` (`pid`, `rid`, `perm`, `tid`) VALUES
256 (1, 1, 'access content', 0),
257 (2, 2, 'access comments, access content, post comments, post comments without approval, post new blog', 0),
258 (3, 3, 'access comments, access content, post comments, post comments without approval, post new blog', 0);
260 -- --------------------------------------------------------
263 -- Table structure for table `role`
266 CREATE TABLE IF NOT EXISTS `role` (
267 `rid` int(10) unsigned NOT NULL AUTO_INCREMENT,
268 `name` varchar(64) NOT NULL DEFAULT '',
270 UNIQUE KEY `name` (`name`)
271 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
274 -- Dumping data for table `role`
277 INSERT INTO `role` (`rid`, `name`) VALUES
278 (1, 'Dungeon Master'),
282 -- --------------------------------------------------------
285 -- Table structure for table `sessions`
288 CREATE TABLE IF NOT EXISTS `sessions` (
289 `uid` int(10) unsigned NOT NULL,
290 `sid` varchar(64) NOT NULL DEFAULT '',
291 `hostname` varchar(128) NOT NULL DEFAULT '',
292 `timestamp` int(11) NOT NULL DEFAULT '0',
293 `cache` int(11) NOT NULL DEFAULT '0',
296 KEY `timestamp` (`timestamp`),
298 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
301 -- Dumping data for table `sessions`
304 INSERT INTO `sessions` (`uid`, `sid`, `hostname`, `timestamp`, `cache`, `session`) VALUES
305 (1, '2d813b4836e5742af6fa391b5010bc92', '::1', 1272157837, 0, '');
307 -- --------------------------------------------------------
310 -- Table structure for table `stats`
313 CREATE TABLE IF NOT EXISTS `stats` (
314 `nid` int(11) NOT NULL DEFAULT '0',
315 `totalcount` bigint(20) unsigned NOT NULL DEFAULT '0',
316 `daycount` mediumint(8) unsigned NOT NULL DEFAULT '0',
317 `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
319 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
322 -- Dumping data for table `stats`
326 -- --------------------------------------------------------
329 -- Table structure for table `system`
332 CREATE TABLE IF NOT EXISTS `system` (
333 `filename` varchar(255) NOT NULL DEFAULT '',
334 `name` varchar(255) NOT NULL DEFAULT '',
335 `type` varchar(255) NOT NULL DEFAULT '',
336 `status` int(11) NOT NULL DEFAULT '0',
339 PRIMARY KEY (`filename`),
340 KEY `modules` (`type`(12),`status`,`filename`),
341 KEY `bootstrap` (`type`(12),`status`,`filename`)
342 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
345 -- Dumping data for table `system`
348 INSERT INTO `system` (`filename`, `name`, `type`, `status`, `info`, `hooks`) VALUES
349 ('core/menu/menu.module', 'menu', 'module', 1, 'a:5:{s:4:"name";s:4:"Menu";s:7:"version";s:3:"0.1";s:12:"machine_name";s:4:"menu";s:11:"description";s:16:"Core Menu module";s:5:"group";s:4:"core";}', 'admin_page'),
350 ('core/system/system.module', 'system', 'module', 1, 'a:5:{s:4:"name";s:13:"esTigi System";s:7:"version";s:3:"0.1";s:12:"machine_name";s:6:"system";s:11:"description";s:50:"Basic esTigi system with administration functions.";s:5:"group";s:4:"core";}', 'boot::exit'),
351 ('core/block/block.module', 'block', 'module', 1, 'a:6:{s:4:"name";s:5:"Block";s:7:"version";s:3:"0.1";s:12:"machine_name";s:5:"block";s:11:"description";s:19:"Core Blocks module.";s:5:"group";s:4:"core";s:7:"website";s:25:"http://localhost/dev/core";}', 'boot::admin_page'),
352 ('core/text/text.module', 'text', 'module', 1, 'a:5:{s:4:"name";s:4:"Text";s:7:"version";s:3:"0.1";s:12:"machine_name";s:4:"text";s:11:"description";s:40:"Core text module with filtering features";s:5:"group";s:4:"core";}', ''),
353 ('core/node/node.module', 'node', 'module', 1, 'a:5:{s:4:"name";s:4:"Node";s:7:"version";s:3:"0.1";s:12:"machine_name";s:4:"node";s:11:"description";s:17:"Core Node module.";s:5:"group";s:4:"core";}', 'links::admin_page'),
354 ('core/skin/skin.module', 'skin', 'module', 1, 'a:5:{s:4:"name";s:4:"Skin";s:7:"version";s:3:"0.1";s:12:"machine_name";s:4:"skin";s:11:"description";s:48:"Core Skin module, this makes your site look good";s:5:"group";s:4:"core";}', ''),
355 ('core/user/user.module', 'user', 'module', 1, 'a:5:{s:4:"name";s:4:"User";s:7:"version";s:3:"0.1";s:12:"machine_name";s:4:"user";s:11:"description";s:44:"Core user module with profile implementation";s:5:"group";s:4:"core";}', 'admin_page::node_display'),
356 ('skins/bluebreeze/bluebreeze.module', 'bluebreeze', 'theme', 1, NULL, NULL),
357 ('core/form/form.module', 'form', 'module', 1, 'a:5:{s:4:"name";s:4:"Form";s:7:"version";s:3:"0.1";s:12:"machine_name";s:4:"form";s:11:"description";s:16:"Core Form module";s:5:"group";s:4:"core";}', '');
359 -- --------------------------------------------------------
362 -- Table structure for table `url_alias`
365 CREATE TABLE IF NOT EXISTS `url_alias` (
366 `pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
367 `src` varchar(128) NOT NULL DEFAULT '',
368 `dst` varchar(128) NOT NULL DEFAULT '',
369 `language` varchar(12) NOT NULL DEFAULT '',
371 UNIQUE KEY `dst_language` (`dst`,`language`),
372 KEY `src_language` (`src`,`language`)
373 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
376 -- Dumping data for table `url_alias`
379 INSERT INTO `url_alias` (`pid`, `src`, `dst`, `language`) VALUES
380 (1, 'node/rss.xml', 'rss.xml', ''),
381 (2, 'system/admin', 'admin', ''),
382 (3, 'user/register', 'register', ''),
383 (4, 'user/login', 'login', ''),
384 (5, 'node/new/%', 'new/%', '');
386 -- --------------------------------------------------------
389 -- Table structure for table `users`
392 CREATE TABLE IF NOT EXISTS `users` (
393 `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
394 `name` varchar(60) NOT NULL DEFAULT '',
395 `pass` varchar(32) NOT NULL DEFAULT '',
396 `mail` varchar(64) NOT NULL DEFAULT '@',
397 `theme` varchar(255) DEFAULT NULL,
398 `signature` tinytext,
399 `signature_format` smallint(6) DEFAULT '1',
400 `created` int(11) NOT NULL DEFAULT '0',
401 `access` int(11) NOT NULL DEFAULT '0',
402 `login` int(11) NOT NULL DEFAULT '0',
403 `status` tinyint(4) NOT NULL DEFAULT '0',
404 `timezone` varchar(8) DEFAULT NULL,
405 `language` varchar(12) DEFAULT NULL,
406 `picture` varchar(255) DEFAULT NULL,
409 UNIQUE KEY `name` (`name`),
410 KEY `access` (`access`),
411 KEY `created` (`created`),
413 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
416 -- Dumping data for table `users`
419 INSERT INTO `users` (`uid`, `name`, `pass`, `mail`, `theme`, `signature`, `signature_format`, `created`, `access`, `login`, `status`, `timezone`, `language`, `picture`, `data`) VALUES
420 (0, 'estigi', '', '', '', '', 0, 0, 1249759237, 1249759237, 0, NULL, '', '', NULL),
421 (1, 'root', '202cb962ac59075b964b07152d234b70', 'root@estigi.org', '', 'Be the change that you want to see in the world\r\n--\r\nMahatma Gandhi', 1, 1248672765, 1272157681, 1272157681, 1, '-21600', '', 'files/def/avatars/uid_1.jpg', 'a:4:{s:18:"admin_compact_mode";b:1;s:13:"form_build_id";s:37:"form-50179f2ecfda5fc54a3e5f13690a5d3f";s:14:"picture_delete";s:0:"";s:14:"picture_upload";s:0:"";}');
423 -- --------------------------------------------------------
426 -- Table structure for table `users_roles`
429 CREATE TABLE IF NOT EXISTS `users_roles` (
430 `uid` int(10) unsigned NOT NULL DEFAULT '0',
431 `rid` int(10) unsigned NOT NULL DEFAULT '0',
432 PRIMARY KEY (`uid`,`rid`),
434 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
437 -- Dumping data for table `users_roles`
440 INSERT INTO `users_roles` (`uid`, `rid`) VALUES
443 -- --------------------------------------------------------
446 -- Table structure for table `variable`
449 CREATE TABLE IF NOT EXISTS `variable` (
450 `name` varchar(128) NOT NULL DEFAULT '',
451 `value` longtext NOT NULL,
452 `owner` varchar(255) NOT NULL,
454 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
457 -- Dumping data for table `variable`
460 INSERT INTO `variable` (`name`, `value`, `owner`) VALUES
461 ('site_slogan', 's:22:"The CMS v0.1 pre-alpha";', 'system'),
462 ('site_name', 's:27:"esTigi - DEVELOPMENT CENTER";', 'system'),
463 ('site_mail', 's:15:"info@estig.ocom";', 'system'),
464 ('front_page', 'i:5;', 'node'),
465 ('db_errors', 's:11:"Screen Only";', 'system'),
466 ('debug_info', 's:3:"Yes";', 'system'),
467 ('anon_name', 's:9:"Anonymous";', 'system'),
468 ('display_logo', 'i:1;', 'bluebreeze'),
469 ('logo', 's:8:"logo.png";', 'bluebreeze'),
470 ('site_frontpage', 's:4:"node";', 'system'),
471 ('user_register', 'N;', 'user'),
472 ('user_login', 's:7:"<front>";', 'user'),
473 ('user_logout', 's:0:"";', 'user');