Drupal Multisite - SQL Dump

-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 25, 2008 at 02:08 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: ``
--

-- --------------------------------------------------------

--
-- Table structure for table `access`
--

CREATE TABLE `access` (
`aid` int(11) NOT NULL auto_increment,
`mask` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`status` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `access`
--

-- --------------------------------------------------------

--
-- Table structure for table `authmap`
--

CREATE TABLE `authmap` (
`aid` int(10) unsigned NOT NULL auto_increment,
`uid` int(11) NOT NULL default '0',
`authname` varchar(128) NOT NULL default '',
`module` varchar(128) NOT NULL default '',
PRIMARY KEY (`aid`),
UNIQUE KEY `authname` (`authname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `authmap`
--

-- --------------------------------------------------------

--
-- Table structure for table `blocks`
--

CREATE TABLE `blocks` (
`module` varchar(64) NOT NULL default '',
`delta` varchar(32) NOT NULL default '0',
`theme` varchar(255) NOT NULL default '',
`status` tinyint(4) NOT NULL default '0',
`weight` tinyint(4) NOT NULL default '0',
`region` varchar(64) NOT NULL default 'left',
`custom` tinyint(4) NOT NULL default '0',
`throttle` tinyint(4) NOT NULL default '0',
`visibility` tinyint(4) NOT NULL default '0',
`pages` text NOT NULL,
`title` varchar(64) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `blocks`
--

INSERT INTO `blocks` VALUES('user', '0', 'garland', 1, 0, 'left', 0, 0, 0, '', '');
INSERT INTO `blocks` VALUES('user', '1', 'garland', 1, 0, 'left', 0, 0, 0, '', '');

-- --------------------------------------------------------

--
-- Table structure for table `blocks_roles`
--

CREATE TABLE `blocks_roles` (
`module` varchar(64) NOT NULL default '',
`delta` varchar(32) NOT NULL default '',
`rid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`module`,`delta`,`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `blocks_roles`
--

-- --------------------------------------------------------

--
-- Table structure for table `boxes`
--

CREATE TABLE `boxes` (
`bid` int(11) NOT NULL auto_increment,
`body` longtext,
`info` varchar(128) NOT NULL default '',
`format` int(11) NOT NULL default '0',
PRIMARY KEY (`bid`),
UNIQUE KEY `info` (`info`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `boxes`
--

-- --------------------------------------------------------

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
`cid` varchar(255) NOT NULL default '',
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache`
--

-- --------------------------------------------------------

--
-- Table structure for table `cache_filter`
--

CREATE TABLE `cache_filter` (
`cid` varchar(255) NOT NULL default '',
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache_filter`
--

-- --------------------------------------------------------

--
-- Table structure for table `cache_menu`
--

CREATE TABLE `cache_menu` (
`cid` varchar(255) NOT NULL default '',
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache_menu`
--

-- --------------------------------------------------------

--
-- Table structure for table `cache_page`
--

CREATE TABLE `cache_page` (
`cid` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache_page`
--

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
`cid` int(11) NOT NULL auto_increment,
`pid` int(11) NOT NULL default '0',
`nid` int(11) NOT NULL default '0',
`uid` int(11) NOT NULL default '0',
`subject` varchar(64) NOT NULL default '',
`comment` longtext NOT NULL,
`hostname` varchar(128) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
`score` mediumint(9) NOT NULL default '0',
`status` tinyint(3) unsigned NOT NULL default '0',
`format` int(11) NOT NULL default '0',
`thread` varchar(255) NOT NULL default '',
`users` longtext,
`name` varchar(60) default NULL,
`mail` varchar(64) default NULL,
`homepage` varchar(255) default NULL,
PRIMARY KEY (`cid`),
KEY `lid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `comments`
--

-- --------------------------------------------------------

--
-- Table structure for table `files`
--

CREATE TABLE `files` (
`fid` int(10) unsigned NOT NULL default '0',
`nid` int(10) unsigned NOT NULL default '0',
`filename` varchar(255) NOT NULL default '',
`filepath` varchar(255) NOT NULL default '',
`filemime` varchar(255) NOT NULL default '',
`filesize` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`fid`),
KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `files`
--

-- --------------------------------------------------------

--
-- Table structure for table `file_revisions`
--

CREATE TABLE `file_revisions` (
`fid` int(10) unsigned NOT NULL default '0',
`vid` int(10) unsigned NOT NULL default '0',
`description` varchar(255) NOT NULL default '',
`list` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`fid`,`vid`),
KEY `vid` (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `file_revisions`
--

-- --------------------------------------------------------

--
-- Table structure for table `filters`
--

CREATE TABLE `filters` (
`format` int(11) NOT NULL default '0',
`module` varchar(64) NOT NULL default '',
`delta` tinyint(4) NOT NULL default '0',
`weight` tinyint(4) NOT NULL default '0',
KEY `weight` (`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `filters`
--

INSERT INTO `filters` VALUES(1, 'filter', 3, 0);
INSERT INTO `filters` VALUES(1, 'filter', 0, 1);
INSERT INTO `filters` VALUES(1, 'filter', 2, 2);
INSERT INTO `filters` VALUES(2, 'filter', 1, 0);
INSERT INTO `filters` VALUES(3, 'filter', 3, 0);
INSERT INTO `filters` VALUES(3, 'filter', 2, 1);

-- --------------------------------------------------------

--
-- Table structure for table `filter_formats`
--

CREATE TABLE `filter_formats` (
`format` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`roles` varchar(255) NOT NULL default '',
`cache` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`format`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `filter_formats`
--

INSERT INTO `filter_formats` VALUES(1, 'Filtered HTML', ',1,2,', 1);
INSERT INTO `filter_formats` VALUES(2, 'PHP code', '', 0);
INSERT INTO `filter_formats` VALUES(3, 'Full HTML', '', 1);

-- --------------------------------------------------------

--
-- Table structure for table `flood`
--

CREATE TABLE `flood` (
`event` varchar(64) NOT NULL default '',
`hostname` varchar(128) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `flood`
--

-- --------------------------------------------------------

--
-- Table structure for table `history`
--

CREATE TABLE `history` (
`uid` int(11) NOT NULL default '0',
`nid` int(11) NOT NULL default '0',
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`uid`,`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `history`
--

-- --------------------------------------------------------

--
-- Table structure for table `locales_meta`
--

CREATE TABLE `locales_meta` (
`locale` varchar(12) NOT NULL default '',
`name` varchar(64) NOT NULL default '',
`enabled` int(11) NOT NULL default '0',
`isdefault` int(11) NOT NULL default '0',
`plurals` int(11) NOT NULL default '0',
`formula` varchar(128) NOT NULL default '',
PRIMARY KEY (`locale`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `locales_meta`
--

INSERT INTO `locales_meta` VALUES('en', 'English', 1, 1, 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `locales_source`
--

CREATE TABLE `locales_source` (
`lid` int(11) NOT NULL auto_increment,
`location` varchar(255) NOT NULL default '',
`source` blob NOT NULL,
PRIMARY KEY (`lid`),
KEY `source` (`source`(30))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `locales_source`
--

-- --------------------------------------------------------

--
-- Table structure for table `locales_target`
--

CREATE TABLE `locales_target` (
`lid` int(11) NOT NULL default '0',
`translation` blob NOT NULL,
`locale` varchar(12) NOT NULL default '',
`plid` int(11) NOT NULL default '0',
`plural` int(11) NOT NULL default '0',
KEY `lid` (`lid`),
KEY `lang` (`locale`),
KEY `plid` (`plid`),
KEY `plural` (`plural`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `locales_target`
--

-- --------------------------------------------------------

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
`mid` int(10) unsigned NOT NULL default '0',
`pid` int(10) unsigned NOT NULL default '0',
`path` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`weight` tinyint(4) NOT NULL default '0',
`type` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` VALUES(2, 0, '', 'Primary links', '', 0, 115);

-- --------------------------------------------------------

--
-- Table structure for table `node`
--

CREATE TABLE `node` (
`nid` int(10) unsigned NOT NULL auto_increment,
`vid` int(10) unsigned NOT NULL default '0',
`type` varchar(32) NOT NULL default '',
`title` varchar(128) NOT NULL default '',
`uid` int(11) NOT NULL default '0',
`status` int(11) NOT NULL default '1',
`created` int(11) NOT NULL default '0',
`changed` int(11) NOT NULL default '0',
`comment` int(11) NOT NULL default '0',
`promote` int(11) NOT NULL default '0',
`moderate` int(11) NOT NULL default '0',
`sticky` int(11) NOT NULL default '0',
PRIMARY KEY (`nid`,`vid`),
UNIQUE KEY `vid` (`vid`),
KEY `node_type` (`type`(4)),
KEY `node_title_type` (`title`,`type`(4)),
KEY `status` (`status`),
KEY `uid` (`uid`),
KEY `node_moderate` (`moderate`),
KEY `node_promote_status` (`promote`,`status`),
KEY `node_created` (`created`),
KEY `node_changed` (`changed`),
KEY `node_status_type` (`status`,`type`,`nid`),
KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `node`
--

-- --------------------------------------------------------

--
-- Table structure for table `node_access`
--

CREATE TABLE `node_access` (
`nid` int(10) unsigned NOT NULL default '0',
`gid` int(10) unsigned NOT NULL default '0',
`realm` varchar(255) NOT NULL default '',
`grant_view` tinyint(3) unsigned NOT NULL default '0',
`grant_update` tinyint(3) unsigned NOT NULL default '0',
`grant_delete` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`nid`,`gid`,`realm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `node_access`
--

INSERT INTO `node_access` VALUES(0, 0, 'all', 1, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `node_comment_statistics`
--

CREATE TABLE `node_comment_statistics` (
`nid` int(10) unsigned NOT NULL auto_increment,
`last_comment_timestamp` int(11) NOT NULL default '0',
`last_comment_name` varchar(60) default NULL,
`last_comment_uid` int(11) NOT NULL default '0',
`comment_count` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`nid`),
KEY `node_comment_timestamp` (`last_comment_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `node_comment_statistics`
--

-- --------------------------------------------------------

--
-- Table structure for table `node_counter`
--

CREATE TABLE `node_counter` (
`nid` int(11) NOT NULL default '0',
`totalcount` bigint(20) unsigned NOT NULL default '0',
`daycount` mediumint(8) unsigned NOT NULL default '0',
`timestamp` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`nid`),
KEY `totalcount` (`totalcount`),
KEY `daycount` (`daycount`),
KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `node_counter`
--

-- --------------------------------------------------------

--
-- Table structure for table `node_revisions`
--

CREATE TABLE `node_revisions` (
`nid` int(10) unsigned NOT NULL default '0',
`vid` int(10) unsigned NOT NULL default '0',
`uid` int(11) NOT NULL default '0',
`title` varchar(128) NOT NULL default '',
`body` longtext NOT NULL,
`teaser` longtext NOT NULL,
`log` longtext NOT NULL,
`timestamp` int(11) NOT NULL default '0',
`format` int(11) NOT NULL default '0',
PRIMARY KEY (`vid`),
KEY `nid` (`nid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `node_revisions`
--

-- --------------------------------------------------------

--
-- Table structure for table `node_type`
--

CREATE TABLE `node_type` (
`type` varchar(32) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`module` varchar(255) NOT NULL default '',
`description` mediumtext NOT NULL,
`help` mediumtext NOT NULL,
`has_title` tinyint(3) unsigned NOT NULL default '0',
`title_label` varchar(255) NOT NULL default '',
`has_body` tinyint(3) unsigned NOT NULL default '0',
`body_label` varchar(255) NOT NULL default '',
`min_word_count` smallint(5) unsigned NOT NULL default '0',
`custom` tinyint(4) NOT NULL default '0',
`modified` tinyint(4) NOT NULL default '0',
`locked` tinyint(4) NOT NULL default '0',
`orig_type` varchar(255) NOT NULL default '',
PRIMARY KEY (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `node_type`
--

INSERT INTO `node_type` VALUES('page', 'Page', 'node', 'If you want to add a static page, like a contact page or an about page, use a page.', '', 1, 'Title', 1, 'Body', 0, 1, 1, 0, 'page');
INSERT INTO `node_type` VALUES('story', 'Story', 'node', 'Stories are articles in their simplest form: they have a title, a teaser and a body, but can be extended by other modules. The teaser is part of the body too. Stories may be used as a personal blog or for news articles.', '', 1, 'Title', 1, 'Body', 0, 1, 1, 0, 'story');

-- --------------------------------------------------------

--
-- Table structure for table `permission`
--

CREATE TABLE `permission` (
`rid` int(10) unsigned NOT NULL default '0',
`perm` longtext,
`tid` int(10) unsigned NOT NULL default '0',
KEY `rid` (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `permission`
--

INSERT INTO `permission` VALUES(1, 'access content', 0);
INSERT INTO `permission` VALUES(2, 'access comments, access content, post comments, post comments without approval', 0);

-- --------------------------------------------------------

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
`rid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(64) NOT NULL default '',
PRIMARY KEY (`rid`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `role`
--

INSERT INTO `role` VALUES(1, 'anonymous user');
INSERT INTO `role` VALUES(2, 'authenticated user');

-- --------------------------------------------------------

--
-- Table structure for table `sequences`
--

CREATE TABLE `sequences` (
`name` varchar(255) NOT NULL default '',
`id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sequences`
--

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
`uid` int(10) unsigned NOT NULL default '0',
`sid` varchar(64) NOT NULL default '',
`hostname` varchar(128) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
`cache` int(11) NOT NULL default '0',
`session` longtext,
PRIMARY KEY (`sid`),
KEY `uid` (`uid`),
KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sessions`
--

-- --------------------------------------------------------

--
-- Table structure for table `system`
--

CREATE TABLE `system` (
`filename` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`status` int(11) NOT NULL default '0',
`throttle` tinyint(4) NOT NULL default '0',
`bootstrap` int(11) NOT NULL default '0',
`schema_version` smallint(6) NOT NULL default '-1',
`weight` int(11) NOT NULL default '0',
PRIMARY KEY (`filename`),
KEY `weight` (`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `system`
--

INSERT INTO `system` VALUES('themes/engines/phptemplate/phptemplate.engine', 'phptemplate', 'theme_engine', '', 1, 0, 0, 0, 0);
INSERT INTO `system` VALUES('themes/garland/page.tpl.php', 'garland', 'theme', 'themes/engines/phptemplate/phptemplate.engine', 1, 0, 0, 0, 0);
INSERT INTO `system` VALUES('modules/system/system.module', 'system', 'module', 'Handles general site configuration for administrators.', 1, 0, 0, 1022, 0);
INSERT INTO `system` VALUES('modules/aggregator/aggregator.module', 'aggregator', 'module', 'Aggregates syndicated content (RSS, RDF, and Atom feeds).', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/akismet/akismet.module', 'akismet', 'module', 'Use the Akismet Service to protect your site from spam.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/block/block.module', 'block', 'module', 'Controls the boxes that are displayed around the main content.', 1, 0, 0, 0, 0);
INSERT INTO `system` VALUES('modules/blog/blog.module', 'blog', 'module', 'Enables keeping easily and regularly updated user web pages or blogs.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/blogapi/blogapi.module', 'blogapi', 'module', 'Allows users to post content using applications that support XML-RPC blog APIs.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/book/book.module', 'book', 'module', 'Allows users to collaboratively author a book.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/color/color.module', 'color', 'module', 'Allows the user to change the color scheme of certain themes.', 1, 0, 0, 0, 0);
INSERT INTO `system` VALUES('modules/comment/comment.module', 'comment', 'module', 'Allows users to comment on and discuss published content.', 1, 0, 0, 1, 0);
INSERT INTO `system` VALUES('sites/all/modules/computed_field/computed_field.module', 'computed_field', 'module', 'Allows the user to define computed values in custom content types.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/contact/contact.module', 'contact', 'module', 'Enables the use of both personal and site-wide contact forms.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/cck/content.module', 'content', 'module', 'Allows administrators to define new content types.', 0, 0, 1, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/cck/content_copy.module', 'content_copy', 'module', 'Enables ability to import/export field definitions.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/drupal/drupal.module', 'drupal', 'module', 'Lets you register your site with a central server and improve ranking of Drupal projects by posting information on your installed modules and themes', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/excerpt/excerpt.module', 'excerpt', 'module', 'Allows users to manually control the teaser for a node.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/favorite_nodes/favorite_nodes.module', 'favorite_nodes', 'module', 'Allows users to manage a favorite list of nodes.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/fckeditor/fckeditor.module', 'fckeditor', 'module', 'Enables the usage of FCKeditor (WYSIWYG) instead of plain text fields.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/cck/fieldgroup.module', 'fieldgroup', 'module', 'Create field groups for CCK fields.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/filter/filter.module', 'filter', 'module', 'Handles the filtering of content in preparation for display.', 1, 0, 0, 0, 0);
INSERT INTO `system` VALUES('sites/all/modules/fivestar/fivestar.module', 'fivestar', 'module', 'A simple five-star voting widget for nodes.', 0, 0, 1, -1, 0);
INSERT INTO `system` VALUES('modules/forum/forum.module', 'forum', 'module', 'Enables threaded discussions about general topics.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/gsitemap/gsitemap.module', 'gsitemap', 'module', 'Creates a Google Sitemap.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/help/help.module', 'help', 'module', 'Manages the display of online help.', 1, 0, 0, 0, 0);
INSERT INTO `system` VALUES('sites/all/modules/image/image.module', 'image', 'module', 'Allows uploading, resizing and viewing of images.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/image/contrib/image_attach/image_attach.module', 'image_attach', 'module', 'Allows easy attaching of image nodes to other content types.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/image/contrib/image_gallery/image_gallery.module', 'image_gallery', 'module', 'Allows sorting and displaying of image galleries based on categories.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/image/contrib/image_import/image_import.module', 'image_import', 'module', 'Allows batches of images to be imported from a directory on the server.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/imagecache/imagecache.module', 'imagecache', 'module', 'Dynamic image manipulator and cache.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/imce/imce.module', 'imce', 'module', 'An image/file uploader and browser supporting personal directories and user quota.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/legacy/legacy.module', 'legacy', 'module', 'Provides legacy handlers for upgrades from older Drupal installations.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/locale/locale.module', 'locale', 'module', 'Enables the translation of the user interface to languages other than English.', 1, 0, 0, 0, 0);
INSERT INTO `system` VALUES('modules/menu/menu.module', 'menu', 'module', 'Allows administrators to customize the site navigation menu.', 1, 0, 0, 0, 0);
INSERT INTO `system` VALUES('modules/multidomain/multidomain.module', 'multidomain', 'module', 'Allows site administrator to configure which domains content appears on.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/multisite_manager/multisite_manager.module', 'multisite_manager', 'module', 'Allows creation of new drupal sites from a central drupal site without the creator having access to database info. The new site is installed either with a different database prefix or in a newly created database.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/node/node.module', 'node', 'module', 'Allows content to be submitted to the site and displayed on pages.', 1, 0, 0, 0, 0);
INSERT INTO `system` VALUES('sites/all/modules/node_import/node_import.module', 'node_import', 'module', 'Import content from a CSV or TSV file.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/cck/nodereference.module', 'nodereference', 'module', 'Defines a field type for referencing one node from another.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/nodereview/nodereview.module', 'nodereview', 'module', 'Add reviews to arbitrary node types.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/nodewords/nodewords.module', 'nodewords', 'module', 'Allows users to add meta tags, eg keywords or description.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/cck/number.module', 'number', 'module', 'Defines numeric field types.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/cck/optionwidgets.module', 'optionwidgets', 'module', 'Defines selection, check box and radio button widgets for text and numeric fields.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/page_title/page_title.module', 'page_title', 'module', 'Enhanced control over the page title (in the <head> tag).', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/panels/panels.module', 'panels', 'module', 'Create pages that are divided into areas of the page.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/path/path.module', 'path', 'module', 'Allows users to rename URLs.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/pathauto/pathauto.module', 'pathauto', 'module', 'Provides a mechanism for modules to automatically generate aliases for the content they manage.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/ping/ping.module', 'ping', 'module', 'Alerts other sites when your site has been updated.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/poll/poll.module', 'poll', 'module', 'Allows your site to capture votes on different topics in the form of multiple choice questions.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/profile/profile.module', 'profile', 'module', 'Supports configurable user profiles.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/relatedlinks/relatedlinks.module', 'relatedlinks', 'module', 'Displays links related to content.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/search/search.module', 'search', 'module', 'Enables site-wide keyword searching.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/service_links/service_links.module', 'service_links', 'module', 'Add Digg, del.icio.us, reddit, Technorati etc. links to nodes.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/shopwindow/shopwindow.module', 'shopwindow', 'module', 'Allows you to insert a shopwindow affiliate store into your website, either as a complete shop or by inserting listings into nodes and blocks', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/singlesignon/singlesignon.module', 'singlesignon', 'module', 'Enables ''Single Sign-Ons'' between related Drupal sites on one server with a shared databse.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/statistics/statistics.module', 'statistics', 'module', 'Logs access statistics for your site.', 0, 0, 1, -1, 0);
INSERT INTO `system` VALUES('modules/taxonomy/taxonomy.module', 'taxonomy', 'module', 'Enables the categorization of content.', 1, 0, 0, 0, 0);
INSERT INTO `system` VALUES('sites/all/modules/taxonomy_menu/taxonomy_menu.module', 'taxonomy_menu', 'module', 'Adds links to taxonomy terms to the global navigation menu.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/cck/text.module', 'text', 'module', 'Defines simple text field types.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/throttle/throttle.module', 'throttle', 'module', 'Handles the auto-throttling mechanism, to control site congestion.', 0, 0, 1, -1, 0);
INSERT INTO `system` VALUES('modules/tracker/tracker.module', 'tracker', 'module', 'Enables tracking of recent posts for users.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/upload/upload.module', 'upload', 'module', 'Allows users to upload and attach files to content.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/user/user.module', 'user', 'module', 'Manages the user registration and login system.', 1, 0, 0, 0, 0);
INSERT INTO `system` VALUES('sites/all/modules/cck/userreference.module', 'userreference', 'module', 'Defines a field type for referencing a user from a node.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/views/views.module', 'views', 'module', 'The views module creates customized views of node lists.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/views/views_rss.module', 'views_rss', 'module', 'RSS plugin for the views feed selector argument.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/views/views_theme_wizard.module', 'views_theme_wizard', 'module', 'The views theme wizard helps create stub theming for views.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/views/views_ui.module', 'views_ui', 'module', 'The Views UI module allows you to create and edit views.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('sites/all/modules/votingapi/votingapi.module', 'votingapi', 'module', 'Provides a shared voting API for other modules.', 0, 0, 0, -1, 0);
INSERT INTO `system` VALUES('modules/watchdog/watchdog.module', 'watchdog', 'module', 'Logs and records system events.', 1, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `term_data`
--

CREATE TABLE `term_data` (
`tid` int(10) unsigned NOT NULL auto_increment,
`vid` int(10) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`description` longtext,
`weight` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`tid`),
KEY `vid` (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `term_data`
--

-- --------------------------------------------------------

--
-- Table structure for table `term_hierarchy`
--

CREATE TABLE `term_hierarchy` (
`tid` int(10) unsigned NOT NULL default '0',
`parent` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tid`,`parent`),
KEY `tid` (`tid`),
KEY `parent` (`parent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `term_hierarchy`
--

-- --------------------------------------------------------

--
-- Table structure for table `term_node`
--

CREATE TABLE `term_node` (
`nid` int(10) unsigned NOT NULL default '0',
`tid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tid`,`nid`),
KEY `nid` (`nid`),
KEY `tid` (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `term_node`
--

-- --------------------------------------------------------

--
-- Table structure for table `term_relation`
--

CREATE TABLE `term_relation` (
`tid1` int(10) unsigned NOT NULL default '0',
`tid2` int(10) unsigned NOT NULL default '0',
KEY `tid1` (`tid1`),
KEY `tid2` (`tid2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `term_relation`
--

-- --------------------------------------------------------

--
-- Table structure for table `term_synonym`
--

CREATE TABLE `term_synonym` (
`tid` int(10) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
KEY `tid` (`tid`),
KEY `name` (`name`(3))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `term_synonym`
--

-- --------------------------------------------------------

--
-- Table structure for table `url_alias`
--

CREATE TABLE `url_alias` (
`pid` int(10) unsigned NOT NULL auto_increment,
`src` varchar(128) NOT NULL default '',
`dst` varchar(128) NOT NULL default '',
PRIMARY KEY (`pid`),
UNIQUE KEY `dst` (`dst`),
KEY `src` (`src`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `url_alias`
--

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
`uid` int(10) unsigned NOT NULL default '0',
`name` varchar(60) NOT NULL default '',
`pass` varchar(32) NOT NULL default '',
`mail` varchar(64) default '',
`mode` tinyint(4) NOT NULL default '0',
`sort` tinyint(4) default '0',
`threshold` tinyint(4) default '0',
`theme` varchar(255) NOT NULL default '',
`signature` varchar(255) NOT NULL default '',
`created` int(11) NOT NULL default '0',
`access` int(11) NOT NULL default '0',
`login` int(11) NOT NULL default '0',
`status` tinyint(4) NOT NULL default '0',
`timezone` varchar(8) default NULL,
`language` varchar(12) NOT NULL default '',
`picture` varchar(255) NOT NULL default '',
`init` varchar(64) default '',
`data` longtext,
PRIMARY KEY (`uid`),
UNIQUE KEY `name` (`name`),
KEY `created` (`created`),
KEY `access` (`access`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES(0, '', '', '', 0, 0, 0, '', '', 0, 0, 0, 0, NULL, '', '', '', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `users_roles`
--

CREATE TABLE `users_roles` (
`uid` int(10) unsigned NOT NULL default '0',
`rid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`uid`,`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_roles`
--

-- --------------------------------------------------------

--
-- Table structure for table `variable`
--

CREATE TABLE `variable` (
`name` varchar(48) NOT NULL default '',
`value` longtext NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `variable`
--

INSERT INTO `variable` VALUES('theme_default', 's:7:"garland";');
INSERT INTO `variable` VALUES('filter_html_1', 'i:1;');
INSERT INTO `variable` VALUES('node_options_forum', 'a:1:{i:0;s:6:"status";}');
INSERT INTO `variable` VALUES('menu_primary_menu', 'i:2;');
INSERT INTO `variable` VALUES('menu_secondary_menu', 'i:2;');
INSERT INTO `variable` VALUES('install_profile', 's:7:"default";');
INSERT INTO `variable` VALUES('node_options_page', 'a:1:{i:0;s:6:"status";}');
INSERT INTO `variable` VALUES('comment_page', 'i:0;');
INSERT INTO `variable` VALUES('theme_settings', 'a:1:{s:21:"toggle_node_info_page";b:0;}');

-- --------------------------------------------------------

--
-- Table structure for table `vocabulary`
--

CREATE TABLE `vocabulary` (
`vid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` longtext,
`help` varchar(255) NOT NULL default '',
`relations` tinyint(3) unsigned NOT NULL default '0',
`hierarchy` tinyint(3) unsigned NOT NULL default '0',
`multiple` tinyint(3) unsigned NOT NULL default '0',
`required` tinyint(3) unsigned NOT NULL default '0',
`tags` tinyint(3) unsigned NOT NULL default '0',
`module` varchar(255) NOT NULL default '',
`weight` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `vocabulary`
--

-- --------------------------------------------------------

--
-- Table structure for table `vocabulary_node_types`
--

CREATE TABLE `vocabulary_node_types` (
`vid` int(10) unsigned NOT NULL default '0',
`type` varchar(32) NOT NULL default '',
PRIMARY KEY (`vid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vocabulary_node_types`
--

-- --------------------------------------------------------

--
-- Table structure for table `watchdog`
--

CREATE TABLE `watchdog` (
`wid` int(11) NOT NULL auto_increment,
`uid` int(11) NOT NULL default '0',
`type` varchar(16) NOT NULL default '',
`message` longtext NOT NULL,
`severity` tinyint(3) unsigned NOT NULL default '0',
`link` varchar(255) NOT NULL default '',
`location` text NOT NULL,
`referer` varchar(128) NOT NULL default '',
`hostname` varchar(128) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`wid`),
KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `watchdog`
--