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: `oxwall1841`
-- --------------------------------------------------------
-- Table structure for table `ow_base_attachment`
CREATE TABLE `ow_base_attachment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NOT NULL,
`addStamp` int(11) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0',
`fileName` varchar(100) DEFAULT NULL,
`origFileName` varchar(100) DEFAULT NULL,
`size` int(11) NOT NULL DEFAULT '0',
`bundle` varchar(128) DEFAULT NULL,
`pluginKey` varchar(100) DEFAULT NULL,
KEY `pluginKey` (`pluginKey`),
KEY `userId_2` (`userId`),
KEY `bundle_2` (`bundle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `ow_base_authorization_action`
CREATE TABLE `ow_base_authorization_action` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`groupId` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`availableForGuest` tinyint(1) NOT NULL DEFAULT '1',
UNIQUE KEY `groupId` (`groupId`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=231 ;
-- Dumping data for table `ow_base_authorization_action`
INSERT INTO `ow_base_authorization_action` VALUES
(11, 6, 'add_comment', 0),
(67, 6, 'search_users', 1),
(171, 6, 'view_profile', 1),
(216, 22, 'add_comment', 0),
(217, 22, 'allow_status_update', 0),
(220, 23, 'add_comment', 0),
(223, 24, 'add_comment', 0),
(224, 25, 'add_friend', 0),
(225, 26, 'read_message', 0),
(226, 26, 'send_message', 0),
(227, 26, 'reply_to_message', 0),
(228, 26, 'read_chat_message', 0),
(229, 26, 'send_chat_message', 0),
(230, 26, 'reply_to_chat_message', 0);
-- --------------------------------------------------------
-- Table structure for table `ow_base_authorization_group`
CREATE TABLE `ow_base_authorization_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`moderated` tinyint(1) NOT NULL DEFAULT '1',
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;
-- Dumping data for table `ow_base_authorization_group`
INSERT INTO `ow_base_authorization_group` VALUES
-- --------------------------------------------------------
-- Table structure for table `ow_base_authorization_moderator`
CREATE TABLE `ow_base_authorization_moderator` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NOT NULL,
UNIQUE KEY `userId` (`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- Dumping data for table `ow_base_authorization_moderator`
INSERT INTO `ow_base_authorization_moderator` VALUES
-- --------------------------------------------------------
-- Table structure for table `ow_base_authorization_moderator_permission`
CREATE TABLE `ow_base_authorization_moderator_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`moderatorId` int(11) NOT NULL,
`groupId` int(11) NOT NULL,
KEY `moderatorId` (`moderatorId`),
KEY `groupId` (`groupId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- Dumping data for table `ow_base_authorization_moderator_permission`
INSERT INTO `ow_base_authorization_moderator_permission` VALUES
-- --------------------------------------------------------
-- Table structure for table `ow_base_authorization_permission`
CREATE TABLE `ow_base_authorization_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`actionId` int(11) NOT NULL,
`roleId` int(11) NOT NULL,
UNIQUE KEY `actionId` (`actionId`,`roleId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=128 ;
-- Dumping data for table `ow_base_authorization_permission`
INSERT INTO `ow_base_authorization_permission` VALUES
-- --------------------------------------------------------
-- Table structure for table `ow_base_authorization_role`
CREATE TABLE `ow_base_authorization_role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`sortOrder` int(11) NOT NULL,
`displayLabel` tinyint(1) DEFAULT '0',
`custom` varchar(255) DEFAULT NULL,
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
-- Dumping data for table `ow_base_authorization_role`
INSERT INTO `ow_base_authorization_role` VALUES
(1, 'guest', 0, 0, NULL),
(12, 'wqewq', 1, 0, NULL);
-- --------------------------------------------------------
-- Table structure for table `ow_base_authorization_user_role`
CREATE TABLE `ow_base_authorization_user_role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NOT NULL,
`roleId` int(11) NOT NULL,
UNIQUE KEY `user2role` (`userId`,`roleId`),
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- Dumping data for table `ow_base_authorization_user_role`
INSERT INTO `ow_base_authorization_user_role` VALUES
-- --------------------------------------------------------
-- Table structure for table `ow_base_avatar`
CREATE TABLE `ow_base_avatar` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NOT NULL,
`hash` int(11) NOT NULL DEFAULT '0',
`status` varchar(32) NOT NULL DEFAULT 'active',
UNIQUE KEY `userId` (`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='utf8_general_ci' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `ow_base_billing_gateway`
CREATE TABLE `ow_base_billing_gateway` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`gatewayKey` varchar(50) NOT NULL,
`adapterClassName` varchar(100) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '0',
`mobile` tinyint(1) NOT NULL DEFAULT '0',
`recurring` tinyint(1) NOT NULL DEFAULT '0',
`dynamic` tinyint(1) DEFAULT '1',
`hidden` tinyint(1) NOT NULL DEFAULT '0',
`currencies` varchar(255) NOT NULL,
UNIQUE KEY `gatewayKey` (`gatewayKey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `ow_base_billing_gateway_config`
CREATE TABLE `ow_base_billing_gateway_config` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`gatewayId` int(10) NOT NULL,
`name` varchar(50) NOT NULL,
`value` varchar(255) DEFAULT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `ow_base_billing_gateway_product`
CREATE TABLE `ow_base_billing_gateway_product` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`gatewayId` int(10) NOT NULL,
`pluginKey` varchar(255) NOT NULL,
`entityType` varchar(50) NOT NULL,
`entityId` int(10) NOT NULL,
`productId` varchar(255) DEFAULT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `ow_base_billing_product`
CREATE TABLE `ow_base_billing_product` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`productKey` varchar(255) NOT NULL,
`adapterClassName` varchar(100) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '0',
UNIQUE KEY `productKey` (`productKey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `ow_base_billing_sale`
CREATE TABLE `ow_base_billing_sale` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`hash` varchar(32) NOT NULL,
`pluginKey` varchar(255) DEFAULT NULL,
`entityKey` varchar(50) NOT NULL,
`entityId` int(10) DEFAULT NULL,
`entityDescription` varchar(255) DEFAULT NULL,
`gatewayId` int(11) NOT NULL,
`userId` int(11) DEFAULT NULL,
`transactionUid` varchar(32) DEFAULT NULL,
`price` float(9,3) NOT NULL,
`period` int(10) DEFAULT NULL,
`quantity` int(10) NOT NULL,
`totalAmount` float(9,3) NOT NULL DEFAULT '0.000',
`currency` varchar(3) NOT NULL,
`recurring` tinyint(1) NOT NULL DEFAULT '0',
`status` enum('init','prepared','verified','delivered','processing','error') NOT NULL DEFAULT 'init',
`timeStamp` int(10) NOT NULL DEFAULT '0',
`periodUnits` varchar(20) DEFAULT NULL,
KEY `entityKey` (`entityKey`),
KEY `entityId` (`entityId`),
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `ow_base_cache`
CREATE TABLE `ow_base_cache` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` varchar(255) NOT NULL,
`content` longtext NOT NULL,
`expireTimestamp` int(11) NOT NULL,
`instantLoad` tinyint(1) NOT NULL DEFAULT '0',
KEY `expire_index` (`expireTimestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `ow_base_cache_tag`
CREATE TABLE `ow_base_cache_tag` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag` varchar(255) NOT NULL,
`cacheId` int(11) NOT NULL,
KEY `cacheId_index` (`cacheId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `ow_base_comment`
CREATE TABLE `ow_base_comment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NOT NULL,
`commentEntityId` int(11) NOT NULL,
`createStamp` int(11) NOT NULL,
KEY `commentEntityId` (`commentEntityId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `ow_base_comment_entity`
CREATE TABLE `ow_base_comment_entity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entityType` varchar(255) NOT NULL,
`entityId` int(11) NOT NULL,
`pluginKey` varchar(100) NOT NULL,
`active` tinyint(4) NOT NULL DEFAULT '1',
UNIQUE KEY `entityType` (`entityType`,`entityId`),
KEY `pluginKey` (`pluginKey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `ow_base_component`
CREATE TABLE `ow_base_component` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`className` varchar(50) NOT NULL,
`clonable` tinyint(1) NOT NULL DEFAULT '0',
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=818 ;
-- Dumping data for table `ow_base_component`
INSERT INTO `ow_base_component` VALUES
(70, 'BASE_CMP_AboutMeWidget', 0),
(69, 'BASE_CMP_RssWidget', 1),
(68, 'BASE_CMP_UserViewWidget', 0),
(67, 'BASE_CMP_JoinNowWidget', 0),
(66, 'BASE_CMP_ProfileWallWidget', 0),
(65, 'BASE_CMP_UserAvatarWidget', 0),
(64, 'BASE_CMP_IndexWallWidget', 0),
(61, 'BASE_CMP_AddNewContent', 0),
(62, 'BASE_CMP_CustomHtmlWidget', 1),
(63, 'BASE_CMP_UserListWidget', 0),
(207, 'BASE_CMP_MyAvatarWidget', 0),
(761, 'BASE_CMP_QuickLinksWidget', 0),
(762, 'BASE_MCMP_CustomHtmlWidget', 1),
(763, 'BASE_MCMP_RssWidget', 1),
(764, 'BASE_MCMP_UserListWidget', 0),
(765, 'BASE_CMP_ModerationToolsWidget', 0),
(766, 'BASE_CMP_WelcomeWidget', 0),
(767, 'BASE_MCMP_JoinNowWidget', 0),
(768, 'ADMIN_CMP_FinanceStatisticWidget', 0),
(769, 'ADMIN_CMP_UserStatisticWidget', 0),
(770, 'ADMIN_CMP_ContentStatisticWidget', 0),
(794, 'GROUPS_CMP_InviteWidget', 0),
(808, 'NEWSFEED_CMP_MyFeedWidget', 0),
(809, 'NEWSFEED_CMP_UserFeedWidget', 0),
(810, 'NEWSFEED_CMP_SiteFeedWidget', 0),
(811, 'SLIDESHOW_CMP_SlideshowWidget', 1),
(812, 'PHOTO_CMP_PhotoListWidget', 0),
(813, 'PHOTO_CMP_UserPhotoAlbumsWidget', 0),
(814, 'PHOTO_MCMP_PhotoListWidget', 0),
(815, 'VIDEO_CMP_VideoListWidget', 0),
(816, 'VIDEO_CMP_UserVideoListWidget', 0),
(817, 'FRIENDS_CMP_UserWidget', 0);
-- --------------------------------------------------------
-- Table structure for table `ow_base_component_entity_place`
CREATE TABLE `ow_base_component_entity_place` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`componentId` int(11) NOT NULL,
`placeId` int(11) NOT NULL,
`clone` tinyint(4) NOT NULL DEFAULT '0',
`entityId` int(11) NOT NULL,
`uniqName` varchar(50) NOT NULL,
UNIQUE KEY `userId` (`entityId`,`uniqName`),
KEY `componentId` (`componentId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='utf8_general_ci' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
