/*
MySQL Data Transfer
Source Host: 10.100.200.8
Source Database: mmoportal
Target Host: 10.100.200.8
Target Database: mmoportal
Date: 23.05.2011 9:17:03
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for forum_cats
-- ----------------------------
CREATE TABLE `forum_cats` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `sortKey` int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for forum_posts
-- ----------------------------
CREATE TABLE `forum_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `topicId` int(11) DEFAULT NULL,
  `text` text NOT NULL,
  `dateCreate` int(10) NOT NULL DEFAULT '0',
  `dateModify` int(10) NOT NULL DEFAULT '0',
  `userId` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `FK_forum_posts_users` (`userId`),
  KEY `FK_forum_posts_topics` (`topicId`),
  CONSTRAINT `FK_forum_posts_topics` FOREIGN KEY (`topicId`) REFERENCES `forum_topics` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_forum_posts_users` FOREIGN KEY (`userId`) REFERENCES `my_aspnet_users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for forum_topics
-- ----------------------------
CREATE TABLE `forum_topics` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `catId` int(5) DEFAULT NULL,
  `postId` int(11) DEFAULT NULL COMMENT 'id первого поста темы',
  `title` varchar(255) NOT NULL,
  `lastPostId` int(11) DEFAULT NULL COMMENT 'id последнего поста темы',
  `viewCount` int(10) NOT NULL DEFAULT '0',
  `postCount` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `FK_forum_topics_cats` (`catId`),
  KEY `FK_forum_topics_post` (`postId`),
  KEY `FK_forum_topics_lastpost` (`lastPostId`),
  CONSTRAINT `FK_forum_topics_cat` FOREIGN KEY (`catId`) REFERENCES `forum_cats` (`id`),
  CONSTRAINT `FK_forum_topics_lastpost` FOREIGN KEY (`lastPostId`) REFERENCES `forum_posts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_forum_topics_post` FOREIGN KEY (`postId`) REFERENCES `forum_posts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for items
-- ----------------------------
CREATE TABLE `items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(128) NOT NULL,
  `text` text,
  `infoTitle` varchar(32) DEFAULT NULL COMMENT 'справа страницы небольшой блок с инфой',
  `infoText` text,
  `infoImage` varchar(255) DEFAULT NULL COMMENT 'путь к картинке, которая отображается в правом блоке',
  `projectId` int(4) NOT NULL DEFAULT '0',
  `authorId` int(11) NOT NULL DEFAULT '0',
  `editorId` int(11) NOT NULL DEFAULT '0',
  `dateCreate` int(10) NOT NULL DEFAULT '0',
  `dateModify` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `FK_items_projects` (`projectId`),
  KEY `FK_items_users` (`authorId`),
  CONSTRAINT `FK_items_projects` FOREIGN KEY (`projectId`) REFERENCES `projects` (`id`),
  CONSTRAINT `FK_items_users` FOREIGN KEY (`authorId`) REFERENCES `my_aspnet_users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for my_aspnet_applications
-- ----------------------------
CREATE TABLE `my_aspnet_applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) DEFAULT NULL,
  `description` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for my_aspnet_membership
-- ----------------------------
CREATE TABLE `my_aspnet_membership` (
  `userId` int(11) NOT NULL DEFAULT '0',
  `Email` varchar(128) DEFAULT NULL,
  `Comment` varchar(255) DEFAULT NULL,
  `Password` varchar(128) NOT NULL,
  `PasswordKey` char(32) DEFAULT NULL,
  `PasswordFormat` tinyint(4) DEFAULT NULL,
  `PasswordQuestion` varchar(255) DEFAULT NULL,
  `PasswordAnswer` varchar(255) DEFAULT NULL,
  `IsApproved` tinyint(1) DEFAULT NULL,
  `LastActivityDate` datetime DEFAULT NULL,
  `LastLoginDate` datetime DEFAULT NULL,
  `LastPasswordChangedDate` datetime DEFAULT NULL,
  `CreationDate` datetime DEFAULT NULL,
  `IsLockedOut` tinyint(1) DEFAULT NULL,
  `LastLockedOutDate` datetime DEFAULT NULL,
  `FailedPasswordAttemptCount` int(10) unsigned DEFAULT NULL,
  `FailedPasswordAttemptWindowStart` datetime DEFAULT NULL,
  `FailedPasswordAnswerAttemptCount` int(10) unsigned DEFAULT NULL,
  `FailedPasswordAnswerAttemptWindowStart` datetime DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='2';

-- ----------------------------
-- Table structure for my_aspnet_profiles
-- ----------------------------
CREATE TABLE `my_aspnet_profiles` (
  `userId` int(11) NOT NULL,
  `valueindex` longtext,
  `stringdata` longtext,
  `binarydata` longblob,
  `lastUpdatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for my_aspnet_roles
-- ----------------------------
CREATE TABLE `my_aspnet_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `applicationId` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for my_aspnet_schemaversion
-- ----------------------------
CREATE TABLE `my_aspnet_schemaversion` (
  `version` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for my_aspnet_sessioncleanup
-- ----------------------------
CREATE TABLE `my_aspnet_sessioncleanup` (
  `LastRun` datetime NOT NULL,
  `IntervalMinutes` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for my_aspnet_sessions
-- ----------------------------
CREATE TABLE `my_aspnet_sessions` (
  `SessionId` varchar(255) NOT NULL,
  `ApplicationId` int(11) NOT NULL,
  `Created` datetime NOT NULL,
  `Expires` datetime NOT NULL,
  `LockDate` datetime NOT NULL,
  `LockId` int(11) NOT NULL,
  `Timeout` int(11) NOT NULL,
  `Locked` tinyint(1) NOT NULL,
  `SessionItems` longblob,
  `Flags` int(11) NOT NULL,
  PRIMARY KEY (`SessionId`,`ApplicationId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for my_aspnet_users
-- ----------------------------
CREATE TABLE `my_aspnet_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `applicationId` int(11) NOT NULL,
  `name` varchar(256) NOT NULL,
  `isAnonymous` tinyint(1) NOT NULL DEFAULT '1',
  `lastActivityDate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`(255))
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for my_aspnet_usersinroles
-- ----------------------------
CREATE TABLE `my_aspnet_usersinroles` (
  `userId` int(11) NOT NULL DEFAULT '0',
  `roleId` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userId`,`roleId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for projects
-- ----------------------------
CREATE TABLE `projects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) NOT NULL,
  `itemId` int(11) NOT NULL DEFAULT '0' COMMENT 'ID статьи, отображаемой в качестве описания проекта',
  `isProject` tinyint(1) NOT NULL DEFAULT '1',
  `sortKey` int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `my_aspnet_applications` VALUES ('1', '/', 'Roles');
INSERT INTO `my_aspnet_roles` VALUES ('1', '1', 'Admin');
INSERT INTO `my_aspnet_roles` VALUES ('2', '1', 'Banned');
INSERT INTO `my_aspnet_schemaversion` VALUES ('6');
INSERT INTO `my_aspnet_sessioncleanup` VALUES ('2011-05-23 06:52:03', '10');
INSERT INTO `my_aspnet_usersinroles` VALUES ('1', '1');