SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
-- Database: `soft_drupal638`
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]access`
CREATE TABLE `[[dbprefix]]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',
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]actions`
CREATE TABLE `[[dbprefix]]actions` (
`aid` varchar(255) NOT NULL DEFAULT '0',
`type` varchar(32) NOT NULL DEFAULT '',
`callback` varchar(255) NOT NULL DEFAULT '',
`parameters` longtext NOT NULL,
`description` varchar(255) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `[[dbprefix]]actions`
INSERT INTO `[[dbprefix]]actions` VALUES
('comment_publish_action', 'comment', 'comment_publish_action', '', 'Publish comment'),
('comment_unpublish_action', 'comment', 'comment_unpublish_action', '', 'Unpublish comment'),
('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_publish_action', 'node', 'node_publish_action', '', 'Publish post'),
('node_save_action', 'node', 'node_save_action', '', 'Save post'),
('node_unpromote_action', 'node', 'node_unpromote_action', '', 'Remove post from front page'),
('node_unpublish_action', 'node', 'node_unpublish_action', '', 'Unpublish post'),
('user_block_ip_action', 'user', 'user_block_ip_action', '', 'Ban IP address of current user'),
('user_block_user_action', 'user', 'user_block_user_action', '', 'Block current user');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]actions_aid`
CREATE TABLE `[[dbprefix]]actions_aid` (
`aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]authmap`
CREATE TABLE `[[dbprefix]]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 '',
UNIQUE KEY `authname` (`authname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]batch`
CREATE TABLE `[[dbprefix]]batch` (
`bid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`token` varchar(64) NOT NULL,
`timestamp` int(11) NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blocks`
CREATE TABLE `[[dbprefix]]blocks` (
`bid` int(11) NOT NULL AUTO_INCREMENT,
`module` varchar(64) NOT NULL DEFAULT '',
`delta` varchar(32) NOT NULL DEFAULT '0',
`theme` varchar(64) NOT NULL DEFAULT '',
`status` tinyint(4) NOT NULL DEFAULT '0',
`weight` tinyint(4) NOT NULL DEFAULT '0',
`region` varchar(64) NOT NULL DEFAULT '',
`custom` tinyint(4) NOT NULL DEFAULT '0',
`throttle` tinyint(4) NOT NULL DEFAULT '0',
`visibility` tinyint(4) NOT NULL DEFAULT '0',
`title` varchar(64) NOT NULL DEFAULT '',
`cache` tinyint(4) NOT NULL DEFAULT '1',
UNIQUE KEY `tmd` (`theme`,`module`,`delta`),
KEY `list` (`theme`,`status`,`region`,`weight`,`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
-- Dumping data for table `[[dbprefix]]blocks`
INSERT INTO `[[dbprefix]]blocks` VALUES
(1, 'user', '0', 'garland', 1, 0, 'left', 0, 0, 0, '', '', -1),
(2, 'user', '1', 'garland', 1, 0, 'left', 0, 0, 0, '', '', -1),
(3, 'system', '0', 'garland', 1, 10, 'footer', 0, 0, 0, '', '', -1);
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blocks_roles`
CREATE TABLE `[[dbprefix]]blocks_roles` (
`module` varchar(64) NOT NULL,
`delta` varchar(32) NOT NULL,
`rid` int(10) unsigned NOT NULL,
PRIMARY KEY (`module`,`delta`,`rid`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]boxes`
CREATE TABLE `[[dbprefix]]boxes` (
`bid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`info` varchar(128) NOT NULL DEFAULT '',
`format` smallint(6) NOT NULL DEFAULT '0',
UNIQUE KEY `info` (`info`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]cache`
CREATE TABLE `[[dbprefix]]cache` (
`cid` varchar(255) NOT NULL DEFAULT '',
`expire` int(11) NOT NULL DEFAULT '0',
`created` int(11) NOT NULL DEFAULT '0',
`serialized` smallint(6) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]cache_block`
CREATE TABLE `[[dbprefix]]cache_block` (
`cid` varchar(255) NOT NULL DEFAULT '',
`expire` int(11) NOT NULL DEFAULT '0',
`created` int(11) NOT NULL DEFAULT '0',
`serialized` smallint(6) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]cache_filter`
CREATE TABLE `[[dbprefix]]cache_filter` (
`cid` varchar(255) NOT NULL DEFAULT '',
`expire` int(11) NOT NULL DEFAULT '0',
`created` int(11) NOT NULL DEFAULT '0',
`serialized` smallint(6) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]cache_form`
CREATE TABLE `[[dbprefix]]cache_form` (
`cid` varchar(255) NOT NULL DEFAULT '',
`expire` int(11) NOT NULL DEFAULT '0',
`created` int(11) NOT NULL DEFAULT '0',
`serialized` smallint(6) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]cache_menu`
CREATE TABLE `[[dbprefix]]cache_menu` (
`cid` varchar(255) NOT NULL DEFAULT '',
`expire` int(11) NOT NULL DEFAULT '0',
`created` int(11) NOT NULL DEFAULT '0',
`serialized` smallint(6) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]cache_page`
CREATE TABLE `[[dbprefix]]cache_page` (
`cid` varchar(255) NOT NULL DEFAULT '',
`expire` int(11) NOT NULL DEFAULT '0',
`created` int(11) NOT NULL DEFAULT '0',
`serialized` smallint(6) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]cache_update`
CREATE TABLE `[[dbprefix]]cache_update` (
`cid` varchar(255) NOT NULL DEFAULT '',
`expire` int(11) NOT NULL DEFAULT '0',
`created` int(11) NOT NULL DEFAULT '0',
`serialized` smallint(6) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]comments`
CREATE TABLE `[[dbprefix]]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',
`status` tinyint(3) unsigned NOT NULL DEFAULT '0',
`format` smallint(6) NOT NULL DEFAULT '0',
`thread` varchar(255) NOT NULL,
`name` varchar(60) DEFAULT NULL,
`mail` varchar(64) DEFAULT NULL,
`homepage` varchar(255) DEFAULT NULL,
KEY `comment_uid` (`uid`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]files`
CREATE TABLE `[[dbprefix]]files` (
`fid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` 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',
`status` int(11) NOT NULL DEFAULT '0',
`timestamp` int(10) unsigned NOT NULL DEFAULT '0',
KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]filters`
CREATE TABLE `[[dbprefix]]filters` (
`fid` int(11) NOT NULL AUTO_INCREMENT,
`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',
UNIQUE KEY `fmd` (`format`,`module`,`delta`),
KEY `list` (`format`,`weight`,`module`,`delta`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
-- Dumping data for table `[[dbprefix]]filters`
INSERT INTO `[[dbprefix]]filters` VALUES
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]filter_formats`
CREATE TABLE `[[dbprefix]]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',
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- Dumping data for table `[[dbprefix]]filter_formats`
INSERT INTO `[[dbprefix]]filter_formats` VALUES
(1, 'Filtered HTML', ',1,2,', 1),
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]flood`
CREATE TABLE `[[dbprefix]]flood` (
`fid` int(11) NOT NULL AUTO_INCREMENT,
`event` varchar(64) NOT NULL DEFAULT '',
`hostname` varchar(128) NOT NULL DEFAULT '',
`timestamp` int(11) NOT NULL DEFAULT '0',
KEY `allow` (`event`,`hostname`,`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]history`
CREATE TABLE `[[dbprefix]]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=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]menu_custom`
CREATE TABLE `[[dbprefix]]menu_custom` (
`menu_name` varchar(32) NOT NULL DEFAULT '',
`title` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`menu_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `[[dbprefix]]menu_custom`
INSERT INTO `[[dbprefix]]menu_custom` VALUES
('navigation', 'Navigation', 'The navigation menu is provided by Drupal and is the main interactive menu for any site. It is usually the only menu that contains personalized links for authenticated users, and is often not even visible to anonymous users.'),
('primary-links', 'Primary links', 'Primary links are often used at the theme layer to show the major sections of a site. A typical representation for primary links would be tabs along the top.'),
('secondary-links', 'Secondary links', 'Secondary links are often used for pages like legal notices, contact details, and other secondary navigation items that play a lesser role than primary links');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]menu_links`
CREATE TABLE `[[dbprefix]]menu_links` (
`menu_name` varchar(32) NOT NULL DEFAULT '',
`mlid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`plid` int(10) unsigned NOT NULL DEFAULT '0',
`link_path` varchar(255) NOT NULL DEFAULT '',
`router_path` varchar(255) NOT NULL DEFAULT '',
`link_title` varchar(255) NOT NULL DEFAULT '',
`module` varchar(255) NOT NULL DEFAULT 'system',
`hidden` smallint(6) NOT NULL DEFAULT '0',
`external` smallint(6) NOT NULL DEFAULT '0',
`has_children` smallint(6) NOT NULL DEFAULT '0',
`expanded` smallint(6) NOT NULL DEFAULT '0',
`weight` int(11) NOT NULL DEFAULT '0',
`depth` smallint(6) NOT NULL DEFAULT '0',
`customized` smallint(6) NOT NULL DEFAULT '0',
`p1` int(10) unsigned NOT NULL DEFAULT '0',
`p2` int(10) unsigned NOT NULL DEFAULT '0',
`p3` int(10) unsigned NOT NULL DEFAULT '0',
`p4` int(10) unsigned NOT NULL DEFAULT '0',
`p5` int(10) unsigned NOT NULL DEFAULT '0',
`p6` int(10) unsigned NOT NULL DEFAULT '0',
`p7` int(10) unsigned NOT NULL DEFAULT '0',
`p8` int(10) unsigned NOT NULL DEFAULT '0',
`p9` int(10) unsigned NOT NULL DEFAULT '0',
`updated` smallint(6) NOT NULL DEFAULT '0',
KEY `path_menu` (`link_path`(128),`menu_name`),
KEY `menu_plid_expand_child` (`menu_name`,`plid`,`expanded`,`has_children`),
KEY `menu_parents` (`menu_name`,`p1`,`p2`,`p3`,`p4`,`p5`,`p6`,`p7`,`p8`,`p9`),
KEY `router_path` (`router_path`(128))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=114 ;
-- Dumping data for table `[[dbprefix]]menu_links`
INSERT INTO `[[dbprefix]]menu_links` VALUES
('navigation', 1, 0, 'batch', 'batch', '', 'a:0:{}', 'system', -1, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 2, 0, 'admin', 'admin', 'Administer', 'a:0:{}', 'system', 0, 0, 1, 0, 9, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 3, 0, 'node', 'node', 'Content', 'a:0:{}', 'system', -1, 0, 0, 0, 0, 1, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 4, 0, 'logout', 'logout', 'Log out', 'a:0:{}', 'system', 0, 0, 0, 0, 10, 1, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 5, 0, 'rss.xml', 'rss.xml', 'RSS feed', 'a:0:{}', 'system', -1, 0, 0, 0, 0, 1, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 6, 0, 'user', 'user', 'User account', 'a:0:{}', 'system', -1, 0, 0, 0, 0, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 7, 0, 'node/%', 'node/%', '', 'a:0:{}', 'system', -1, 0, 0, 0, 0, 1, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 8, 2, 'admin/compact', 'admin/compact', 'Compact mode', 'a:0:{}', 'system', -1, 0, 0, 0, 0, 2, 0, 2, 8, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 9, 0, 'filter/tips', 'filter/tips', 'Compose tips', 'a:0:{}', 'system', 1, 0, 0, 0, 0, 1, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 10, 2, 'admin/content', 'admin/content', 'Content management', 'a:1:{s:10:"attributes";a:1:{s:5:"title";s:27:"Manage your site''s content.";}}', 'system', 0, 0, 1, 0, -10, 2, 0, 2, 10, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 11, 0, 'node/add', 'node/add', 'Create content', 'a:0:{}', 'system', 0, 0, 1, 0, 1, 1, 0, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 12, 0, 'comment/delete', 'comment/delete', 'Delete comment', 'a:0:{}', 'system', -1, 0, 0, 0, 0, 1, 0, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 13, 0, 'comment/edit', 'comment/edit', 'Edit comment', 'a:0:{}', 'system', -1, 0, 0, 0, 0, 1, 0, 13, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 14, 0, 'system/files', 'system/files', 'File download', 'a:0:{}', 'system', -1, 0, 0, 0, 0, 1, 0, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 15, 2, 'admin/help', 'admin/help', 'Help', 'a:0:{}', 'system', 0, 0, 0, 0, 9, 2, 0, 2, 15, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 16, 2, 'admin/reports', 'admin/reports', 'Reports', 'a:1:{s:10:"attributes";a:1:{s:5:"title";s:59:"View reports from system logs and other status information.";}}', 'system', 0, 0, 1, 0, 5, 2, 0, 2, 16, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 17, 2, 'admin/build', 'admin/build', 'Site building', 'a:1:{s:10:"attributes";a:1:{s:5:"title";s:38:"Control how your site looks and feels.";}}', 'system', 0, 0, 1, 0, -10, 2, 0, 2, 17, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 18, 2, 'admin/settings', 'admin/settings', 'Site configuration', 'a:1:{s:10:"attributes";a:1:{s:5:"title";s:40:"Adjust basic site configuration options.";}}', 'system', 0, 0, 1, 0, -5, 2, 0, 2, 18, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 19, 0, 'user/autocomplete', 'user/autocomplete', 'User autocomplete', 'a:0:{}', 'system', -1, 0, 0, 0, 0, 1, 0, 19, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('navigation', 20, 2, 'admin/user', 'admin/user', 'User management', 'a:1:{s:10:"attributes";a:1:{s:5:"title";s:61:"Manage your site''s users, groups and access to site features.";}}', 'system', 0, 0, 1, 0, 0, 2, 0, 2, 20, 0, 0, 0, 0, 0, 0, 0, 0),
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
