orchard-安装
2016-04-02 16：24 - 2016-04-03 11:39:40
一、前言
好久没有写博客了，因为觉得没什么好写的（实际没有学什么东西。。。），现在准备从头看Orchard，号称.Net第一开源论坛，从github上下载源码（国内网速好慢），然后编译（vs2015 professional），因为有nuget要下载很多东西，中间还把一个盘给占满了，没办法换了一个磁盘。
源码：https://github.com/OrchardCMS/Orchard master分支
开发IDE：visual studio professional
操作系统：windows7 中文旗舰版 service pack 1 x64
硬件环境：120固态硬盘+500G机械硬盘+4G内存+i5-2450M 2.50GHz
二、运行
总结：
下面文字太多了，很多都是解决问题的过程，简单总结下（可以只看下面这段，其他不用看）：
- 只是用于用mysql的，mssql的没试过，所以如果是mssql，这篇文章可以不用看；
- 安装mysql 5.7.9及以上版本，设置latin2字符集【只能保存英文，如果其他用途需要再研究，本文只学习用】；
- 更改代码，直接跳到本文：类：Orchard\src\Orchard\Data\Migration\Interpreters\DefaultDataMigrationInterpreter.cs，向下看即可；
- 重新编译，本文截止到：运行安装ok。
1、配置mysql
下载了mysql 5.6.24 windows x64，因为oracle官网好慢，百度下载的。
创建db：orchard-CREATE DATABASE `orchard` /*!40100 DEFAULT CHARACTER SET utf8 */
2、编译运行orchard 解决方案
设置orchard.web项目 web服务器为本地iis，路径：http://localhost/Orchard。
chorme 打开：http://localhost/Orchard
输入网站名、密码及mysql连接串：data source=127.0.0.1;database=orchard;user id=root;password=
结果，运行报错：Setup failed: Error while running migration version 0 for Orchard.Autoroute.
查看报错日志（Orchard\src\Orchard.Web\App_Data\Logs\orchard-error-2016.04.02.log）：
2016-04-02 16:07:19,658 [44] Orchard.Data.Migration.DataMigrationManager - Default - Error while running migration version 0 for Orchard.Autoroute. [http://localhost/Orchard] System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> MySql.Data.MySqlClient.MySqlException: BLOB/TEXT column 'DisplayAlias' used in key specification without a key length at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at Orchard.Data.Migration.Interpreters.DefaultDataMigrationInterpreter.RunPendingStatements()
百度查了下，发现是mysql要求的索引字段长度必须指定长度，而orchard反射生成的sql是“BLOB/TEXT DisplayAlias”，没有规定长度，所以报错了。
参考（没细看）：https://techjourney.net/mysql-error-1170-42000-blobtext-column-used-in-key-specification-without-a-key-length/
http://stackoverflow.com/questions/13710170/blob-text-column-bestilling-used-in-key-specification-without-a-key-length
orchard在codeplex的网站上有人说到mysql的问题，但是没有人回复：http://orchard.codeplex.com/discussions/569295。
事情总要解决，调试代码把类型改掉吧，本来想运行起来后再看代码。
3、调试代码
因为第一遍运行已经有很多表了，第二次运行就报错了，故先drop所有的表，然后再finish setup。
找到了报错的语句：
报错语句：create index `IDX_AutoroutePartRecord_DisplayAlias` on `Orchard_Autoroute_AutoroutePartRecord` (DisplayAlias)
该表sql如下：
CREATE TABLE `orchard_autoroute_autoroutepartrecord` ( `Id` int(11) NOT NULL, `ContentItemRecord_id` int(11) DEFAULT NULL, `CustomPattern` text, `UseCustomPattern` tinyint(1) DEFAULT '0', `UseCulturePattern` tinyint(1) DEFAULT '0', `DisplayAlias` text, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
全局搜索代码，发现有个表构建类，写明了长度，但是不知道为何mysql没有指定长度：
public class Migrations : DataMigrationImpl { public int Create() { SchemaBuilder.CreateTable("AutoroutePartRecord", table => table .ContentPartVersionRecord() .Column<string>("CustomPattern", c => c.WithLength(2048)) .Column<bool>("UseCustomPattern", c => c.WithDefault(false)) .Column<bool>("UseCulturePattern", c => c.WithDefault(false)) .Column<string>("DisplayAlias", c => c.WithLength(2048))); ContentDefinitionManager.AlterPartDefinition("AutoroutePart", part => part .Attachable() .WithDescription("Adds advanced url configuration options to your content type to completely customize the url pattern for a content item.")); SchemaBuilder.AlterTable("AutoroutePartRecord", table => table .CreateIndex("IDX_AutoroutePartRecord_DisplayAlias", "DisplayAlias") ); return 4; }
应该是写入sql时没有指定长度，重新调试（清表）：在上面构建类的Create方法设置断点，再次运行程序竟然没有进入，直接走到了原来的错误，很奇怪！
再次调试还是没有进入，但是从bug发生代码向上追溯调用，发现是反射调用的，因此没有进入断点：
类地址：Orchard\src\Orchard\Data\Migration\DataMigrationManager.cs
private static MethodInfo GetCreateMethod(IDataMigration dataMigration) { var methodInfo = dataMigration.GetType().GetMethod("Create", BindingFlags.Public | BindingFlags.Instance); if (methodInfo != null && methodInfo.ReturnType == typeof(int)) { return methodInfo; } return null; }
所以应该是Orchard.Autoroute这个项目的dll被主项目加载到内存中，但通过反射来调用方法的。
orchard用的是NHibernate，其如果这样写：
.Column<string>("DisplayAlias", c => c.WithLength(2048)))
则会实际在mysql中生成Text类型，且没有长度，经过一番调试找到生成类型的语句：
类：Orchard\src\Orchard\Data\Migration\Interpreters\DefaultDataMigrationInterpreter.cs
dialect.GetTypeName(new SqlType(dbType, length.Value))
其中DisplayAlias的dbType为：String，length.Value为2048，上面代码代码运行时的NHibernate方言dialect是：NHibernate.Dialect.MySQLDialect（NHibernate.4.0.1.4000），
结果获取的是Text类型，如果把长度改成255刚好可以获取到VARCHAR(255)，所以应该是映射的问题。
本地mysql试了下index索引字段长度只能是767，否则报错：
ERROR 1071: Specified key was too long; max key length is 767 bytes
全局搜索了下，发现有很多超过255的列类型，也有一些设置了Index索引，故想是否可以更改db设置。
http://stackoverflow.com/questions/10873870/mysql-error-1071-specified-key-was-too-long-max-key-length-is-1000-bytes-in-s
http://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes/
第二个链接问题和我遇到的问题一样，看到回答：SET @@global.innodb_large_prefix = 1; 转到mysql官方文档：
http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_large_prefix
Enable this option to allow index key prefixes longer than 767 bytes (up to 3072 bytes), for InnoDB tables that use the DYNAMIC and COMPRESSED row formats. (Creating such tables also requires the option values innodb_file_format=barracuda and innodb_file_per_table=true.) See Section 14.9.7, “Limits on InnoDB Tables” for the relevant maximums associated with index key prefixes under various settings.
然后转到http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html InnoDB Tables限制，的确默认是767字节：
By default, an index key for a single-column index can be up to 767 bytes. The same length limit applies to any index key prefix. See Section 13.1.13, “CREATE INDEX Syntax”. For example, you might hit this limit with a column prefix index of more than 255 characters on a TEXT or VARCHAR column, assuming a UTF-8 character set and the maximum of 3 bytes for each character. When the innodb_large_prefix configuration option is enabled, this length limit is raised to 3072 bytes, for InnoDB tables that use the DYNAMIC and COMPRESSED row formats.
然后，说可以改成最大3072字节，但需要表本身支持：use the DYNAMIC andCOMPRESSED row formats。
然后本地sql测试可以：
1、把表的format该掉
ALTER TABLE `test`.`new_table` ROW_FORMAT = DYNAMIC ;
2、把全局innodb_file_format(原来：Antelope)改成Barracuda
set global innodb_file_format=Barracuda; set global innodb_file_per_table = ON;
3、把全局innodb_large_prefix打开
set global innodb_large_prefix=ON;
附上查询sql：
show variables; show variables like 'innodb_large_prefix'; show variables like '%innodb_file_%';
因为上面设置是内存设置，mysql服务器重启后就失效了，故需要放置到配置文件中(my.ini)：
innodb_file_format=Barracuda innodb_file_per_table = ON innodb_large_prefix=ON
关于表的row_format全局设置，搜到了一个：http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_default_row_format
但只是针对5.7.9的有效，我用的是5.6.24，直接查不出innodb_default_row_format属性，从mysql官网下载了5.7.11windows64社区版。
mysql5.7.11版本和5.6不一样，下载下载mysqld.exe总是失败，找了好久终于找到一个正确的方法：http://bbs.csdn.net/topics/391919221?page=1 10楼，
因为5.7.11版本需要先创建用户初始化数据，然后有了系统数据后才能启动，
1、更改my-default.ini为my.ini，增加如下内容
basedir="【你的具体路径】/mysql-5.7.11-winx64" datadir="【你的具体路径】/mysql-5.7.11-winx64/data" port=3306 default-storage-engine=InnoDB
2、运行参数（管理员模式）
C:\Windows\system32>G:\programe\tools\mysql-5.7.11-winx64\bin\mysqld --initializ e-insecure C:\Windows\system32>G:\programe\tools\mysql-5.7.11-winx64\bin\mysqld
启动后，查看原来的系统参数发现都打开了，且新建表key索引也可以支持3702字节了。
而varchar最大支持 21845字节，故还是需要改程序的，更改c#类型映射到db类型，当是string类型且长度小于等于 21845时，用varchar，其他情况用text：
类：Orchard\src\Orchard\Data\Migration\Interpreters\DefaultDataMigrationInterpreter.cs
原来：
public static string GetTypeName(Dialect dialect, DbType dbType, int? length, byte precision, byte scale) { return precision > 0 ? dialect.GetTypeName(new SqlType(dbType, precision, scale)) : length.HasValue ? dialect.GetTypeName(new SqlType(dbType, length.Value)) : dialect.GetTypeName(new SqlType(dbType)); }
现在（所有情况只处理mysql方言和string类型映射的）：
public static string GetTypeName(Dialect dialect, DbType dbType, int? length, byte precision, byte scale) { return precision > 0 ? dialect.GetTypeName(new SqlType(dbType, precision, scale)) : GetDBTypeNameWithLength(dialect, dbType, length); } private static string GetDBTypeNameWithLength(Dialect dialect, DbType dbType, int? length){ if(dialect.GetType() == typeof(NHibernate.Dialect.MySQLDialect) && dbType == DbType.String){ if (!length.HasValue) { return dialect.GetTypeName(new SqlType(dbType)); } if (length.HasValue && length.Value <= 21845){ return string.Format("VARCHAR({0})", length.Value.ToString()); } } return length.HasValue ? dialect.GetTypeName(new SqlType(dbType, length.Value)) : dialect.GetTypeName(new SqlType(dbType)); }
然后运行还是报错，因为我orchard db默认选择的是utf-8***，默认每个char 3个字节，当有索引的字段2048×3=6144远大于规定的3072字节，故删掉db，重新创建了一个
latin2-latin2_general_ci字符集（虽无法保存中文，但运行的目的是为了学习，所以无所谓）的orchard db，然后再次运行，终于ok了。
三、安装成功
待配置界面：
安装成功界面：
一共78个表，使用dump命令保存sql：
C:\Users\×××>×××\mysql-5.7.11-winx64\bin\mysqldump.exe -u root -p orchard >orchard.sql Enter password:
生成的orchar.sql默认位置是：%user%目录下：
-- MySQL dump 10.13 Distrib 5.7.11, for Win64 (x86_64) -- -- Host: localhost Database: orchard -- ------------------------------------------------------ -- Server version 5.7.11 /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `common_bodypartrecord` -- DROP TABLE IF EXISTS `common_bodypartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `common_bodypartrecord` ( `Id` int(11) NOT NULL, `ContentItemRecord_id` int(11) DEFAULT NULL, `Text` varchar(10000) DEFAULT NULL, `Format` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `common_bodypartrecord` -- LOCK TABLES `common_bodypartrecord` WRITE; /*!40000 ALTER TABLE `common_bodypartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `common_bodypartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `common_commonpartrecord` -- DROP TABLE IF EXISTS `common_commonpartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `common_commonpartrecord` ( `Id` int(11) NOT NULL, `OwnerId` int(11) DEFAULT NULL, `CreatedUtc` datetime DEFAULT NULL, `PublishedUtc` datetime DEFAULT NULL, `ModifiedUtc` datetime DEFAULT NULL, `Container_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `common_commonpartrecord` -- LOCK TABLES `common_commonpartrecord` WRITE; /*!40000 ALTER TABLE `common_commonpartrecord` DISABLE KEYS */; INSERT INTO `common_commonpartrecord` VALUES (3,2,'2016-04-03 03:01:09','2016-04-03 03:01:09','2016-04-03 03:01:09',NULL),(4,2,'2016-04-03 03:01:10','2016-04-03 03:01:10','2016-04-03 03:01:10',NULL),(5,2,'2016-04-03 03:01:10','2016-04-03 03:01:10','2016-04-03 03:01:10',NULL),(6,2,'2016-04-03 03:01:10','2016-04-03 03:01:10','2016-04-03 03:01:10',NULL),(7,2,'2016-04-03 03:01:10','2016-04-03 03:01:10','2016-04-03 03:01:10',NULL),(8,0,'2016-04-03 03:01:10','2016-04-03 03:01:10','2016-04-03 03:01:10',NULL),(9,2,'2016-04-03 03:01:10','2016-04-03 03:01:10','2016-04-03 03:01:10',NULL),(10,2,'2016-04-03 03:01:11','2016-04-03 03:01:11','2016-04-03 03:01:11',NULL),(11,2,'2016-04-03 03:01:11','2016-04-03 03:01:11','2016-04-03 03:01:11',3); /*!40000 ALTER TABLE `common_commonpartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `common_commonpartversionrecord` -- DROP TABLE IF EXISTS `common_commonpartversionrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `common_commonpartversionrecord` ( `Id` int(11) NOT NULL, `ContentItemRecord_id` int(11) DEFAULT NULL, `CreatedUtc` datetime DEFAULT NULL, `PublishedUtc` datetime DEFAULT NULL, `ModifiedUtc` datetime DEFAULT NULL, `ModifiedBy` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `common_commonpartversionrecord` -- LOCK TABLES `common_commonpartversionrecord` WRITE; /*!40000 ALTER TABLE `common_commonpartversionrecord` DISABLE KEYS */; INSERT INTO `common_commonpartversionrecord` VALUES (3,3,'2016-04-03 03:01:09','2016-04-03 03:01:09','2016-04-03 03:01:09',''),(4,4,'2016-04-03 03:01:10','2016-04-03 03:01:10','2016-04-03 03:01:10',''),(5,5,'2016-04-03 03:01:10','2016-04-03 03:01:10','2016-04-03 03:01:10',''),(6,6,'2016-04-03 03:01:10','2016-04-03 03:01:10','2016-04-03 03:01:10',''),(7,7,'2016-04-03 03:01:10','2016-04-03 03:01:10','2016-04-03 03:01:10',''),(8,8,'2016-04-03 03:01:10','2016-04-03 03:01:10','2016-04-03 03:01:10',''),(9,9,'2016-04-03 03:01:10','2016-04-03 03:01:10','2016-04-03 03:01:10','admin'),(10,10,'2016-04-03 03:01:11','2016-04-03 03:01:11','2016-04-03 03:01:11','admin'),(11,11,'2016-04-03 03:01:11','2016-04-03 03:01:11','2016-04-03 03:01:11','admin'); /*!40000 ALTER TABLE `common_commonpartversionrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `common_identitypartrecord` -- DROP TABLE IF EXISTS `common_identitypartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `common_identitypartrecord` ( `Id` int(11) NOT NULL, `Identifier` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `common_identitypartrecord` -- LOCK TABLES `common_identitypartrecord` WRITE; /*!40000 ALTER TABLE `common_identitypartrecord` DISABLE KEYS */; INSERT INTO `common_identitypartrecord` VALUES (8,'06ffcda4a7b44c7281e265e914dd36d3'),(10,'7746d11d15f34e9b80555d5f84c9092d'),(11,'MenuWidget1'); /*!40000 ALTER TABLE `common_identitypartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `containers_containablepartrecord` -- DROP TABLE IF EXISTS `containers_containablepartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `containers_containablepartrecord` ( `Id` int(11) NOT NULL, `Position` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `containers_containablepartrecord` -- LOCK TABLES `containers_containablepartrecord` WRITE; /*!40000 ALTER TABLE `containers_containablepartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `containers_containablepartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `containers_containerpartrecord` -- DROP TABLE IF EXISTS `containers_containerpartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `containers_containerpartrecord` ( `Id` int(11) NOT NULL, `Paginated` tinyint(1) DEFAULT NULL, `PageSize` int(11) DEFAULT NULL, `ItemContentTypes` varchar(255) DEFAULT NULL, `ItemsShown` tinyint(1) NOT NULL, `ShowOnAdminMenu` tinyint(1) NOT NULL, `AdminMenuText` varchar(50) DEFAULT NULL, `AdminMenuPosition` varchar(50) DEFAULT NULL, `AdminMenuImageSet` varchar(50) DEFAULT NULL, `EnablePositioning` tinyint(1) DEFAULT NULL, `AdminListViewName` varchar(50) DEFAULT NULL, `ItemCount` int(11) NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `containers_containerpartrecord` -- LOCK TABLES `containers_containerpartrecord` WRITE; /*!40000 ALTER TABLE `containers_containerpartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `containers_containerpartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `containers_containerwidgetpartrecord` -- DROP TABLE IF EXISTS `containers_containerwidgetpartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `containers_containerwidgetpartrecord` ( `Id` int(11) NOT NULL, `ContainerId` int(11) DEFAULT NULL, `PageSize` int(11) DEFAULT NULL, `OrderByProperty` varchar(64) DEFAULT NULL, `OrderByDirection` int(11) DEFAULT NULL, `ApplyFilter` tinyint(1) DEFAULT NULL, `FilterByProperty` varchar(64) DEFAULT NULL, `FilterByOperator` varchar(4) DEFAULT NULL, `FilterByValue` varchar(128) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `containers_containerwidgetpartrecord` -- LOCK TABLES `containers_containerwidgetpartrecord` WRITE; /*!40000 ALTER TABLE `containers_containerwidgetpartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `containers_containerwidgetpartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `navigation_adminmenupartrecord` -- DROP TABLE IF EXISTS `navigation_adminmenupartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `navigation_adminmenupartrecord` ( `Id` int(11) NOT NULL, `AdminMenuText` varchar(255) DEFAULT NULL, `AdminMenuPosition` varchar(255) DEFAULT NULL, `OnAdminMenu` tinyint(1) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `navigation_adminmenupartrecord` -- LOCK TABLES `navigation_adminmenupartrecord` WRITE; /*!40000 ALTER TABLE `navigation_adminmenupartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `navigation_adminmenupartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `navigation_menupartrecord` -- DROP TABLE IF EXISTS `navigation_menupartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `navigation_menupartrecord` ( `Id` int(11) NOT NULL, `MenuText` varchar(255) DEFAULT NULL, `MenuPosition` varchar(255) DEFAULT NULL, `MenuId` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `navigation_menupartrecord` -- LOCK TABLES `navigation_menupartrecord` WRITE; /*!40000 ALTER TABLE `navigation_menupartrecord` DISABLE KEYS */; INSERT INTO `navigation_menupartrecord` VALUES (9,'',NULL,0),(10,'Home','0',8); /*!40000 ALTER TABLE `navigation_menupartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_alias_actionrecord` -- DROP TABLE IF EXISTS `orchard_alias_actionrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_alias_actionrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Area` varchar(255) DEFAULT NULL, `Controller` varchar(255) DEFAULT NULL, `Action` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_alias_actionrecord` -- LOCK TABLES `orchard_alias_actionrecord` WRITE; /*!40000 ALTER TABLE `orchard_alias_actionrecord` DISABLE KEYS */; INSERT INTO `orchard_alias_actionrecord` VALUES (1,'Contents','Item','Display'); /*!40000 ALTER TABLE `orchard_alias_actionrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_alias_aliasrecord` -- DROP TABLE IF EXISTS `orchard_alias_aliasrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_alias_aliasrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Path` varchar(2048) DEFAULT NULL, `Action_id` int(11) DEFAULT NULL, `RouteValues` varchar(10000) DEFAULT NULL, `Source` varchar(256) DEFAULT NULL, `IsManaged` tinyint(1) DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_alias_aliasrecord` -- LOCK TABLES `orchard_alias_aliasrecord` WRITE; /*!40000 ALTER TABLE `orchard_alias_aliasrecord` DISABLE KEYS */; INSERT INTO `orchard_alias_aliasrecord` VALUES (1,'',1,'<v Id=\"9\" />','Autoroute:Home',0),(2,'welcome-to-orchard',1,'<v Id=\"9\" />','Autoroute:View',1); /*!40000 ALTER TABLE `orchard_alias_aliasrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_autoroute_autoroutepartrecord` -- DROP TABLE IF EXISTS `orchard_autoroute_autoroutepartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_autoroute_autoroutepartrecord` ( `Id` int(11) NOT NULL, `ContentItemRecord_id` int(11) DEFAULT NULL, `CustomPattern` varchar(2048) DEFAULT NULL, `UseCustomPattern` tinyint(1) DEFAULT '0', `UseCulturePattern` tinyint(1) DEFAULT '0', `DisplayAlias` varchar(2048) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `IDX_AutoroutePartRecord_DisplayAlias` (`DisplayAlias`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_autoroute_autoroutepartrecord` -- LOCK TABLES `orchard_autoroute_autoroutepartrecord` WRITE; /*!40000 ALTER TABLE `orchard_autoroute_autoroutepartrecord` DISABLE KEYS */; INSERT INTO `orchard_autoroute_autoroutepartrecord` VALUES (9,9,NULL,0,0,'welcome-to-orchard'); /*!40000 ALTER TABLE `orchard_autoroute_autoroutepartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_blogs_blogarchivespartrecord` -- DROP TABLE IF EXISTS `orchard_blogs_blogarchivespartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_blogs_blogarchivespartrecord` ( `Id` int(11) NOT NULL, `BlogId` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_blogs_blogarchivespartrecord` -- LOCK TABLES `orchard_blogs_blogarchivespartrecord` WRITE; /*!40000 ALTER TABLE `orchard_blogs_blogarchivespartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_blogs_blogarchivespartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_blogs_blogpartarchiverecord` -- DROP TABLE IF EXISTS `orchard_blogs_blogpartarchiverecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_blogs_blogpartarchiverecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Year` int(11) DEFAULT NULL, `Month` int(11) DEFAULT NULL, `PostCount` int(11) DEFAULT NULL, `BlogPart_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_blogs_blogpartarchiverecord` -- LOCK TABLES `orchard_blogs_blogpartarchiverecord` WRITE; /*!40000 ALTER TABLE `orchard_blogs_blogpartarchiverecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_blogs_blogpartarchiverecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_blogs_recentblogpostspartrecord` -- DROP TABLE IF EXISTS `orchard_blogs_recentblogpostspartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_blogs_recentblogpostspartrecord` ( `Id` int(11) NOT NULL, `BlogId` int(11) DEFAULT NULL, `Count` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_blogs_recentblogpostspartrecord` -- LOCK TABLES `orchard_blogs_recentblogpostspartrecord` WRITE; /*!40000 ALTER TABLE `orchard_blogs_recentblogpostspartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_blogs_recentblogpostspartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_comments_commentpartrecord` -- DROP TABLE IF EXISTS `orchard_comments_commentpartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_comments_commentpartrecord` ( `Id` int(11) NOT NULL, `Author` varchar(255) DEFAULT NULL, `SiteName` varchar(255) DEFAULT NULL, `UserName` varchar(255) DEFAULT NULL, `Email` varchar(255) DEFAULT NULL, `Status` varchar(255) DEFAULT NULL, `CommentDateUtc` datetime DEFAULT NULL, `CommentText` varchar(10000) DEFAULT NULL, `CommentedOn` int(11) DEFAULT NULL, `CommentedOnContainer` int(11) DEFAULT NULL, `RepliedOn` int(11) DEFAULT NULL, `Position` decimal(19,5) DEFAULT NULL, `CommentsPartRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `IDX_CommentedOn` (`CommentedOn`), KEY `IDX_CommentedOnContainer` (`CommentedOnContainer`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_comments_commentpartrecord` -- LOCK TABLES `orchard_comments_commentpartrecord` WRITE; /*!40000 ALTER TABLE `orchard_comments_commentpartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_comments_commentpartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_comments_commentspartrecord` -- DROP TABLE IF EXISTS `orchard_comments_commentspartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_comments_commentspartrecord` ( `Id` int(11) NOT NULL, `CommentsShown` tinyint(1) DEFAULT NULL, `CommentsActive` tinyint(1) DEFAULT NULL, `ThreadedComments` tinyint(1) DEFAULT NULL, `CommentsCount` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_comments_commentspartrecord` -- LOCK TABLES `orchard_comments_commentspartrecord` WRITE; /*!40000 ALTER TABLE `orchard_comments_commentspartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_comments_commentspartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_contentpicker_contentmenuitempartrecord` -- DROP TABLE IF EXISTS `orchard_contentpicker_contentmenuitempartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_contentpicker_contentmenuitempartrecord` ( `Id` int(11) NOT NULL, `ContentMenuItemRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_contentpicker_contentmenuitempartrecord` -- LOCK TABLES `orchard_contentpicker_contentmenuitempartrecord` WRITE; /*!40000 ALTER TABLE `orchard_contentpicker_contentmenuitempartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_contentpicker_contentmenuitempartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_framework_contentitemrecord` -- DROP TABLE IF EXISTS `orchard_framework_contentitemrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_framework_contentitemrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Data` varchar(10000) DEFAULT NULL, `ContentType_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `IDX_ContentType_id` (`ContentType_id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_framework_contentitemrecord` -- LOCK TABLES `orchard_framework_contentitemrecord` WRITE; /*!40000 ALTER TABLE `orchard_framework_contentitemrecord` DISABLE KEYS */; INSERT INTO `orchard_framework_contentitemrecord` VALUES (1,'<Data><SiteSettingsPart SiteSalt=\"1879dd60a368411eb6c432f76e83d52d\" SiteName=\"mysite\" PageTitleSeparator=\" - \" SiteTimeZone=\"China Standard Time\" SuperUser=\"admin\" SiteCulture=\"en-US\" BaseUrl=\"http://localhost/Orchard\" /><ThemeSiteSettingsPart CurrentThemeName=\"TheThemeMachine\" /></Data>',2),(2,'<Data><UserPart UserName=\"admin\" Email=\"\" NormalizedUserName=\"admin\" HashAlgorithm=\"PBKDF2\" CreatedUtc=\"2016-04-03T03:01:00.4589247Z\" PasswordFormat=\"Hashed\" Password=\"AHOmHpvpilemRrGnAt0jcMbHiJqjJnGvvQl/l2gFnfxvHYoZMULP4kqa9DNzypjZqQ==\" PasswordSalt=\"86pRw9itYuqoM53BpROWjw==\" RegistrationStatus=\"Approved\" EmailStatus=\"Approved\" LastLogoutUtc=\"null\" /></Data>',3),(3,'<Data><CommonPart CreatedUtc=\"2016-04-03T03:01:09.8864639Z\" ModifiedUtc=\"2016-04-03T03:01:09.8864639Z\" PublishedUtc=\"2016-04-03T03:01:09.99347Z\" /><LayerPart Name=\"Default\" LayerRule=\"true\" Description=\"The widgets in this layer are displayed on all pages\" /></Data>',4),(4,'<Data><CommonPart CreatedUtc=\"2016-04-03T03:01:10.0674743Z\" ModifiedUtc=\"2016-04-03T03:01:10.0674743Z\" PublishedUtc=\"2016-04-03T03:01:10.0894755Z\" /><LayerPart Name=\"Authenticated\" LayerRule=\"authenticated\" Description=\"The widgets in this layer are displayed when the user is authenticated\" /></Data>',4),(5,'<Data><CommonPart CreatedUtc=\"2016-04-03T03:01:10.1254776Z\" ModifiedUtc=\"2016-04-03T03:01:10.1254776Z\" PublishedUtc=\"2016-04-03T03:01:10.1404784Z\" /><LayerPart Name=\"Anonymous\" LayerRule=\"not authenticated\" Description=\"The widgets in this layer are displayed when the user is anonymous\" /></Data>',4),(6,'<Data><CommonPart CreatedUtc=\"2016-04-03T03:01:10.16748Z\" ModifiedUtc=\"2016-04-03T03:01:10.16748Z\" PublishedUtc=\"2016-04-03T03:01:10.1894812Z\" /><LayerPart Name=\"Disabled\" LayerRule=\"false\" Description=\"The widgets in this layer are never displayed\" /></Data>',4),(7,'<Data><CommonPart CreatedUtc=\"2016-04-03T03:01:10.2224831Z\" ModifiedUtc=\"2016-04-03T03:01:10.2224831Z\" PublishedUtc=\"2016-04-03T03:01:10.2414842Z\" /><LayerPart Name=\"TheHomepage\" LayerRule=\"url \'~/\'\" Description=\"The widgets in this layer are displayed on the home page\" /></Data>',4),(8,'<Data><IdentityPart Identifier=\"06ffcda4a7b44c7281e265e914dd36d3\" /><CommonPart CreatedUtc=\"2016-04-03T03:01:10.2874869Z\" ModifiedUtc=\"2016-04-03T03:01:10.2874869Z\" PublishedUtc=\"2016-04-03T03:01:10.3064879Z\" /></Data>',1),(9,'<Data><CommonPart CreatedUtc=\"2016-04-03T03:01:10.5435015Z\" ModifiedUtc=\"2016-04-03T03:01:10.3524906Z\" PublishedUtc=\"2016-04-03T03:01:10.5435015Z\" /></Data>',5),(10,'<Data><IdentityPart Identifier=\"7746d11d15f34e9b80555d5f84c9092d\" /><CommonPart CreatedUtc=\"2016-04-03T03:01:11.3305465Z\" ModifiedUtc=\"2016-04-03T03:01:11.3305465Z\" PublishedUtc=\"2016-04-03T03:01:11.3555479Z\" /><MenuItemPart Url=\"~/\" /></Data>',6),(11,'<Data><IdentityPart Identifier=\"MenuWidget1\" /><CommonPart CreatedUtc=\"2016-04-03T03:01:11.4355525Z\" ModifiedUtc=\"2016-04-03T03:01:11.4355525Z\" PublishedUtc=\"2016-04-03T03:01:11.4845553Z\" /><WidgetPart RenderTitle=\"false\" Title=\"Main Menu\" Position=\"1\" Zone=\"Navigation\" Name=\"\" /><MenuWidgetPart StartLevel=\"1\" MenuContentItemId=\"8\" /></Data>',7); /*!40000 ALTER TABLE `orchard_framework_contentitemrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_framework_contentitemversionrecord` -- DROP TABLE IF EXISTS `orchard_framework_contentitemversionrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_framework_contentitemversionrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Number` int(11) DEFAULT NULL, `Published` tinyint(1) DEFAULT NULL, `Latest` tinyint(1) DEFAULT NULL, `Data` varchar(10000) DEFAULT NULL, `ContentItemRecord_id` int(11) NOT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `UC_CIVR_CIRId_Number` (`ContentItemRecord_id`,`Number`), KEY `IDX_ContentItemRecord_id` (`ContentItemRecord_id`), KEY `IDX_ContentItemVersionRecord_Published_Latest` (`Published`,`Latest`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_framework_contentitemversionrecord` -- LOCK TABLES `orchard_framework_contentitemversionrecord` WRITE; /*!40000 ALTER TABLE `orchard_framework_contentitemversionrecord` DISABLE KEYS */; INSERT INTO `orchard_framework_contentitemversionrecord` VALUES (1,1,1,1,NULL,1),(2,1,1,1,NULL,2),(3,1,1,1,NULL,3),(4,1,1,1,NULL,4),(5,1,1,1,NULL,5),(6,1,1,1,NULL,6),(7,1,1,1,NULL,7),(8,1,1,1,'<Data><TitlePart Title=\"Main Menu\" /></Data>',8),(9,1,1,1,'<Data><TitlePart Title=\"Welcome to Orchard!\" /><AutoroutePart DisplayAlias=\"welcome-to-orchard\" UseCustomPattern=\"false\" /><LayoutPart LayoutData=\"{"elements": [{"typeName": "Orchard.Layouts.Elements.Canvas","elements": [{"typeName": "Orchard.Layouts.Elements.Grid","elements": [{"typeName": "Orchard.Layouts.Elements.Row","elements": [{"typeName": "Orchard.Layouts.Elements.Column","data": "Width=12","elements": [{"typeName": "Orchard.Layouts.Elements.Html","data": "Content=%3cp%3eYou%27ve+successfully+setup+your+Orchard+Site+and+this+is+the+homepage+of+your+new+site.%0d%0aHere+are+a+few+things+you+can+look+at+to+get+familiar+with+the+application.%0d%0aOnce+you+feel+confident+you+don%27t+need+this+anymore%2c+you+can%0d%0a%3ca+href%3d%22Admin%2fContents%2fEdit%2f9%22%3eremove+it+by+going+into+editing+mode%3c%2fa%3e%0d%0aand+replacing+it+with+whatever+you+want.%3c%2fp%3e%0d%0a%3cp%3eFirst+things+first+-+You%27ll+probably+want+to+%3ca+href%3d%22Admin%2fSettings%22%3emanage+your+settings%3c%2fa%3e%0d%0aand+configure+Orchard+to+your+liking.+After+that%2c+you+can+head+over+to%0d%0a%3ca+href%3d%22Admin%2fThemes%22%3emanage+themes+to+change+or+install+new+themes%3c%2fa%3e%0d%0aand+really+make+it+your+own.+Once+you%27re+happy+with+a+look+and+feel%2c+it%27s+time+for+some+content.%0d%0aYou+can+start+creating+new+custom+content+types+or+start+from+the+built-in+ones+by%0d%0a%3ca+href%3d%22Admin%2fContents%2fCreate%2fPage%22%3eadding+a+page%3c%2fa%3e%2c+or+%3ca+href%3d%22Admin%2fNavigation%22%3emanaging+your+menus.%3c%2fa%3e%3c%2fp%3e%0d%0a%3cp%3eFinally%2c+Orchard+has+been+designed+to+be+extended.+It+comes+with+a+few+built-in%0d%0amodules+such+as+pages+and+blogs+or+themes.+If+you%27re+looking+to+add+additional+functionality%2c%0d%0ayou+can+do+so+by+creating+your+own+module+or+by+installing+one+that+somebody+else+built.%0d%0aModules+are+created+by+other+users+of+Orchard+just+like+you+so+if+you+feel+up+to+it%2c%0d%0a%3ca+href%3d%22http%3a%2f%2forchardproject.net%2fcontribution%22%3eplease+consider+participating%3c%2fa%3e.%3c%2fp%3e%0d%0a%3cp%3eThanks+for+using+Orchard+%e2%80%93+The+Orchard+Team+%3c%2fp%3e"}]}]},{"typeName": "Orchard.Layouts.Elements.Row","elements": [{"typeName": "Orchard.Layouts.Elements.Column","data": "Width=4","elements": [{"typeName": "Orchard.Layouts.Elements.Html","data": "Content=%3ch2%3eFirst+Leader+Aside%3c%2fh2%3e%0d%0a%3cp%3eLorem+ipsum+dolor+sit+amet%2c+consectetur+adipiscing+elit.+Curabitur+a+nibh+ut+tortor+dapibus+vestibulum.%0d%0aAliquam+vel+sem+nibh.+Suspendisse+vel+condimentum+tellus.%3c%2fp%3e"}]},{"typeName": "Orchard.Layouts.Elements.Column","data": "Width=4","elements": [{"typeName": "Orchard.Layouts.Elements.Html","data": "Content=%3ch2%3eSecond+Leader+Aside%3c%2fh2%3e%0d%0a%3cp%3eLorem+ipsum+dolor+sit+amet%2c+consectetur+adipiscing+elit.+Curabitur+a+nibh+ut+tortor+dapibus+vestibulum.%0d%0aAliquam+vel+sem+nibh.+Suspendisse+vel+condimentum+tellus.%3c%2fp%3e"}]},{"typeName": "Orchard.Layouts.Elements.Column","data": "Width=4","elements": [{"typeName": "Orchard.Layouts.Elements.Html","data": "Content=%3ch2%3eThird+Leader+Aside%3c%2fh2%3e%0d%0a%3cp%3eLorem+ipsum+dolor+sit+amet%2c+consectetur+adipiscing+elit.+Curabitur+a+nibh+ut+tortor+dapibus+vestibulum.%0d%0aAliquam+vel+sem+nibh.+Suspendisse+vel+condimentum+tellus.%3c%2fp%3e"}]}]}]}]}]}\" /></Data>',9),(10,1,1,1,NULL,10),(11,1,1,1,NULL,11); /*!40000 ALTER TABLE `orchard_framework_contentitemversionrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_framework_contenttyperecord` -- DROP TABLE IF EXISTS `orchard_framework_contenttyperecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_framework_contenttyperecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `UC_CTR_Name` (`Name`), KEY `IDX_ContentType_Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_framework_contenttyperecord` -- LOCK TABLES `orchard_framework_contenttyperecord` WRITE; /*!40000 ALTER TABLE `orchard_framework_contenttyperecord` DISABLE KEYS */; INSERT INTO `orchard_framework_contenttyperecord` VALUES (4,'Layer'),(1,'Menu'),(6,'MenuItem'),(7,'MenuWidget'),(5,'Page'),(2,'Site'),(3,'User'); /*!40000 ALTER TABLE `orchard_framework_contenttyperecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_framework_culturerecord` -- DROP TABLE IF EXISTS `orchard_framework_culturerecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_framework_culturerecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Culture` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `UC_CR_Name` (`Culture`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_framework_culturerecord` -- LOCK TABLES `orchard_framework_culturerecord` WRITE; /*!40000 ALTER TABLE `orchard_framework_culturerecord` DISABLE KEYS */; INSERT INTO `orchard_framework_culturerecord` VALUES (1,'en-US'); /*!40000 ALTER TABLE `orchard_framework_culturerecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_framework_datamigrationrecord` -- DROP TABLE IF EXISTS `orchard_framework_datamigrationrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_framework_datamigrationrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `DataMigrationClass` varchar(255) DEFAULT NULL, `Version` int(11) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `UC_DMR_DataMigrationClass_Version` (`DataMigrationClass`,`Version`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_framework_datamigrationrecord` -- LOCK TABLES `orchard_framework_datamigrationrecord` WRITE; /*!40000 ALTER TABLE `orchard_framework_datamigrationrecord` DISABLE KEYS */; INSERT INTO `orchard_framework_datamigrationrecord` VALUES (9,'Orchard.Alias.Migrations',2),(10,'Orchard.Autoroute.Migrations',4),(23,'Orchard.Blogs.Migrations',7),(24,'Orchard.Comments.Migrations',6),(2,'Orchard.ContentManagement.DataMigrations.FrameworkDataMigration',4),(8,'Orchard.ContentPicker.Migrations',1),(17,'Orchard.ContentTypes.Migrations',1),(3,'Orchard.Core.Common.Migrations',5),(4,'Orchard.Core.Containers.Migrations',7),(6,'Orchard.Core.Navigation.Migrations',6),(7,'Orchard.Core.Scheduling.Migrations',1),(1,'Orchard.Core.Settings.Migrations',5),(5,'Orchard.Core.Title.Migrations',2),(26,'Orchard.Layouts.Migrations',3),(20,'Orchard.MediaLibrary.MediaDataMigration',7),(19,'Orchard.MediaProcessing.Migrations',1),(18,'Orchard.OutputCache.Migrations',7),(15,'Orchard.Packaging.Migrations',1),(11,'Orchard.Pages.Migrations',3),(28,'Orchard.Projections.Migrations',4),(21,'Orchard.PublishLater.Migrations',2),(16,'Orchard.Recipes.Migrations',1),(14,'Orchard.Roles.RolesDataMigration',2),(29,'Orchard.Tags.TagsDataMigration',2),(27,'Orchard.Taxonomies.Migrations',4),(12,'Orchard.Themes.ThemesDataMigration',2),(13,'Orchard.Users.UsersDataMigration',4),(22,'Orchard.Widgets.WidgetsDataMigration',5),(25,'Orchard.Workflows.Migrations',1); /*!40000 ALTER TABLE `orchard_framework_datamigrationrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_framework_distributedlockrecord` -- DROP TABLE IF EXISTS `orchard_framework_distributedlockrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_framework_distributedlockrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(512) NOT NULL, `MachineName` varchar(256) DEFAULT NULL, `CreatedUtc` datetime DEFAULT NULL, `ValidUntilUtc` datetime DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `Name` (`Name`), KEY `IDX_DistributedLockRecord_Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_framework_distributedlockrecord` -- LOCK TABLES `orchard_framework_distributedlockrecord` WRITE; /*!40000 ALTER TABLE `orchard_framework_distributedlockrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_framework_distributedlockrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_layouts_elementblueprint` -- DROP TABLE IF EXISTS `orchard_layouts_elementblueprint`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_layouts_elementblueprint` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `BaseElementTypeName` varchar(256) DEFAULT NULL, `ElementTypeName` varchar(256) DEFAULT NULL, `ElementDisplayName` varchar(256) DEFAULT NULL, `ElementDescription` varchar(2048) DEFAULT NULL, `ElementCategory` varchar(256) DEFAULT NULL, `BaseElementState` varchar(10000) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_layouts_elementblueprint` -- LOCK TABLES `orchard_layouts_elementblueprint` WRITE; /*!40000 ALTER TABLE `orchard_layouts_elementblueprint` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_layouts_elementblueprint` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_layouts_layoutpartrecord` -- DROP TABLE IF EXISTS `orchard_layouts_layoutpartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_layouts_layoutpartrecord` ( `Id` int(11) NOT NULL, `ContentItemRecord_id` int(11) DEFAULT NULL, `TemplateId` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_layouts_layoutpartrecord` -- LOCK TABLES `orchard_layouts_layoutpartrecord` WRITE; /*!40000 ALTER TABLE `orchard_layouts_layoutpartrecord` DISABLE KEYS */; INSERT INTO `orchard_layouts_layoutpartrecord` VALUES (9,9,NULL); /*!40000 ALTER TABLE `orchard_layouts_layoutpartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_medialibrary_mediapartrecord` -- DROP TABLE IF EXISTS `orchard_medialibrary_mediapartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_medialibrary_mediapartrecord` ( `Id` int(11) NOT NULL, `MimeType` varchar(255) DEFAULT NULL, `Caption` varchar(10000) DEFAULT NULL, `AlternateText` varchar(10000) DEFAULT NULL, `FolderPath` varchar(2048) DEFAULT NULL, `FileName` varchar(2048) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `IDX_MediaPartRecord_FolderPath` (`FolderPath`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_medialibrary_mediapartrecord` -- LOCK TABLES `orchard_medialibrary_mediapartrecord` WRITE; /*!40000 ALTER TABLE `orchard_medialibrary_mediapartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_medialibrary_mediapartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_mediaprocessing_filenamerecord` -- DROP TABLE IF EXISTS `orchard_mediaprocessing_filenamerecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_mediaprocessing_filenamerecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Path` varchar(10000) DEFAULT NULL, `FileName` varchar(10000) DEFAULT NULL, `ImageProfilePartRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_mediaprocessing_filenamerecord` -- LOCK TABLES `orchard_mediaprocessing_filenamerecord` WRITE; /*!40000 ALTER TABLE `orchard_mediaprocessing_filenamerecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_mediaprocessing_filenamerecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_mediaprocessing_filterrecord` -- DROP TABLE IF EXISTS `orchard_mediaprocessing_filterrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_mediaprocessing_filterrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Category` varchar(64) DEFAULT NULL, `Type` varchar(64) DEFAULT NULL, `Description` varchar(255) DEFAULT NULL, `State` varchar(10000) DEFAULT NULL, `Position` int(11) DEFAULT NULL, `ImageProfilePartRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_mediaprocessing_filterrecord` -- LOCK TABLES `orchard_mediaprocessing_filterrecord` WRITE; /*!40000 ALTER TABLE `orchard_mediaprocessing_filterrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_mediaprocessing_filterrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_mediaprocessing_imageprofilepartrecord` -- DROP TABLE IF EXISTS `orchard_mediaprocessing_imageprofilepartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_mediaprocessing_imageprofilepartrecord` ( `Name` varchar(255) DEFAULT NULL, `Id` int(11) NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_mediaprocessing_imageprofilepartrecord` -- LOCK TABLES `orchard_mediaprocessing_imageprofilepartrecord` WRITE; /*!40000 ALTER TABLE `orchard_mediaprocessing_imageprofilepartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_mediaprocessing_imageprofilepartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_outputcache_cacheparameterrecord` -- DROP TABLE IF EXISTS `orchard_outputcache_cacheparameterrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_outputcache_cacheparameterrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Duration` int(11) DEFAULT NULL, `GraceTime` int(11) DEFAULT NULL, `RouteKey` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_outputcache_cacheparameterrecord` -- LOCK TABLES `orchard_outputcache_cacheparameterrecord` WRITE; /*!40000 ALTER TABLE `orchard_outputcache_cacheparameterrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_outputcache_cacheparameterrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_packaging_packagingsource` -- DROP TABLE IF EXISTS `orchard_packaging_packagingsource`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_packaging_packagingsource` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `FeedTitle` varchar(255) DEFAULT NULL, `FeedUrl` varchar(2048) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_packaging_packagingsource` -- LOCK TABLES `orchard_packaging_packagingsource` WRITE; /*!40000 ALTER TABLE `orchard_packaging_packagingsource` DISABLE KEYS */; INSERT INTO `orchard_packaging_packagingsource` VALUES (1,'Orchard Gallery','https://gallery.orchardproject.net/api/FeedService'); /*!40000 ALTER TABLE `orchard_packaging_packagingsource` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_decimalfieldindexrecord` -- DROP TABLE IF EXISTS `orchard_projections_decimalfieldindexrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_decimalfieldindexrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `PropertyName` varchar(255) DEFAULT NULL, `Value` decimal(19,5) DEFAULT NULL, `FieldIndexPartRecord_Id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_decimalfieldindexrecord` -- LOCK TABLES `orchard_projections_decimalfieldindexrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_decimalfieldindexrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_decimalfieldindexrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_doublefieldindexrecord` -- DROP TABLE IF EXISTS `orchard_projections_doublefieldindexrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_doublefieldindexrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `PropertyName` varchar(255) DEFAULT NULL, `Value` double DEFAULT NULL, `FieldIndexPartRecord_Id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_doublefieldindexrecord` -- LOCK TABLES `orchard_projections_doublefieldindexrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_doublefieldindexrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_doublefieldindexrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_fieldindexpartrecord` -- DROP TABLE IF EXISTS `orchard_projections_fieldindexpartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_fieldindexpartrecord` ( `Id` int(11) NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_fieldindexpartrecord` -- LOCK TABLES `orchard_projections_fieldindexpartrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_fieldindexpartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_fieldindexpartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_filtergrouprecord` -- DROP TABLE IF EXISTS `orchard_projections_filtergrouprecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_filtergrouprecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `QueryPartRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_filtergrouprecord` -- LOCK TABLES `orchard_projections_filtergrouprecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_filtergrouprecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_filtergrouprecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_filterrecord` -- DROP TABLE IF EXISTS `orchard_projections_filterrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_filterrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Category` varchar(64) DEFAULT NULL, `Type` varchar(64) DEFAULT NULL, `Description` varchar(255) DEFAULT NULL, `State` varchar(10000) DEFAULT NULL, `Position` int(11) DEFAULT NULL, `FilterGroupRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_filterrecord` -- LOCK TABLES `orchard_projections_filterrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_filterrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_filterrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_integerfieldindexrecord` -- DROP TABLE IF EXISTS `orchard_projections_integerfieldindexrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_integerfieldindexrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `PropertyName` varchar(255) DEFAULT NULL, `Value` bigint(20) DEFAULT NULL, `FieldIndexPartRecord_Id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_integerfieldindexrecord` -- LOCK TABLES `orchard_projections_integerfieldindexrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_integerfieldindexrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_integerfieldindexrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_layoutrecord` -- DROP TABLE IF EXISTS `orchard_projections_layoutrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_layoutrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Category` varchar(64) DEFAULT NULL, `Type` varchar(64) DEFAULT NULL, `Description` varchar(255) DEFAULT NULL, `State` varchar(10000) DEFAULT NULL, `DisplayType` varchar(64) DEFAULT NULL, `Display` int(11) DEFAULT NULL, `QueryPartRecord_id` int(11) DEFAULT NULL, `GroupProperty_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_layoutrecord` -- LOCK TABLES `orchard_projections_layoutrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_layoutrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_layoutrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_memberbindingrecord` -- DROP TABLE IF EXISTS `orchard_projections_memberbindingrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_memberbindingrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Type` varchar(255) DEFAULT NULL, `Member` varchar(64) DEFAULT NULL, `Description` varchar(500) DEFAULT NULL, `DisplayName` varchar(64) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_memberbindingrecord` -- LOCK TABLES `orchard_projections_memberbindingrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_memberbindingrecord` DISABLE KEYS */; INSERT INTO `orchard_projections_memberbindingrecord` VALUES (1,'Orchard.Core.Common.Models.CommonPartRecord','CreatedUtc','When the content item was created','Creation date'),(2,'Orchard.Core.Common.Models.CommonPartRecord','ModifiedUtc','When the content item was modified','Modification date'),(3,'Orchard.Core.Common.Models.CommonPartRecord','PublishedUtc','When the content item was published','Publication date'),(4,'Orchard.Core.Title.Models.TitlePartRecord','Title','The title assigned using the Title part','Title Part Title'),(5,'Orchard.Core.Common.Models.BodyPartRecord','Text','The text from the Body part','Body Part Text'); /*!40000 ALTER TABLE `orchard_projections_memberbindingrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_navigationquerypartrecord` -- DROP TABLE IF EXISTS `orchard_projections_navigationquerypartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_navigationquerypartrecord` ( `Id` int(11) NOT NULL, `Items` int(11) DEFAULT NULL, `Skip` int(11) DEFAULT NULL, `QueryPartRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_navigationquerypartrecord` -- LOCK TABLES `orchard_projections_navigationquerypartrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_navigationquerypartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_navigationquerypartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_projectionpartrecord` -- DROP TABLE IF EXISTS `orchard_projections_projectionpartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_projectionpartrecord` ( `Id` int(11) NOT NULL, `Items` int(11) DEFAULT NULL, `ItemsPerPage` int(11) DEFAULT NULL, `Skip` int(11) DEFAULT NULL, `PagerSuffix` varchar(255) DEFAULT NULL, `MaxItems` int(11) DEFAULT NULL, `DisplayPager` tinyint(1) DEFAULT NULL, `QueryPartRecord_id` int(11) DEFAULT NULL, `LayoutRecord_Id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_projectionpartrecord` -- LOCK TABLES `orchard_projections_projectionpartrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_projectionpartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_projectionpartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_propertyrecord` -- DROP TABLE IF EXISTS `orchard_projections_propertyrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_propertyrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Category` varchar(64) DEFAULT NULL, `Type` varchar(64) DEFAULT NULL, `Description` varchar(255) DEFAULT NULL, `State` varchar(10000) DEFAULT NULL, `Position` int(11) DEFAULT NULL, `LayoutRecord_id` int(11) DEFAULT NULL, `ExcludeFromDisplay` tinyint(1) DEFAULT NULL, `CreateLabel` tinyint(1) DEFAULT NULL, `Label` varchar(255) DEFAULT NULL, `LinkToContent` tinyint(1) DEFAULT NULL, `CustomizePropertyHtml` tinyint(1) DEFAULT NULL, `CustomPropertyTag` varchar(64) DEFAULT NULL, `CustomPropertyCss` varchar(64) DEFAULT NULL, `CustomizeLabelHtml` tinyint(1) DEFAULT NULL, `CustomLabelTag` varchar(64) DEFAULT NULL, `CustomLabelCss` varchar(64) DEFAULT NULL, `CustomizeWrapperHtml` tinyint(1) DEFAULT NULL, `CustomWrapperTag` varchar(64) DEFAULT NULL, `CustomWrapperCss` varchar(64) DEFAULT NULL, `NoResultText` varchar(10000) DEFAULT NULL, `ZeroIsEmpty` tinyint(1) DEFAULT NULL, `HideEmpty` tinyint(1) DEFAULT NULL, `RewriteOutput` tinyint(1) DEFAULT NULL, `RewriteText` varchar(10000) DEFAULT NULL, `StripHtmlTags` tinyint(1) DEFAULT NULL, `TrimLength` tinyint(1) DEFAULT NULL, `AddEllipsis` tinyint(1) DEFAULT NULL, `MaxLength` int(11) DEFAULT NULL, `TrimOnWordBoundary` tinyint(1) DEFAULT NULL, `PreserveLines` tinyint(1) DEFAULT NULL, `TrimWhiteSpace` tinyint(1) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_propertyrecord` -- LOCK TABLES `orchard_projections_propertyrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_propertyrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_propertyrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_querypartrecord` -- DROP TABLE IF EXISTS `orchard_projections_querypartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_querypartrecord` ( `Id` int(11) NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_querypartrecord` -- LOCK TABLES `orchard_projections_querypartrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_querypartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_querypartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_sortcriterionrecord` -- DROP TABLE IF EXISTS `orchard_projections_sortcriterionrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_sortcriterionrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Category` varchar(64) DEFAULT NULL, `Type` varchar(64) DEFAULT NULL, `Description` varchar(255) DEFAULT NULL, `State` varchar(10000) DEFAULT NULL, `Position` int(11) DEFAULT NULL, `QueryPartRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_sortcriterionrecord` -- LOCK TABLES `orchard_projections_sortcriterionrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_sortcriterionrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_sortcriterionrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_projections_stringfieldindexrecord` -- DROP TABLE IF EXISTS `orchard_projections_stringfieldindexrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_projections_stringfieldindexrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `PropertyName` varchar(255) DEFAULT NULL, `Value` varchar(4000) DEFAULT NULL, `FieldIndexPartRecord_Id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_projections_stringfieldindexrecord` -- LOCK TABLES `orchard_projections_stringfieldindexrecord` WRITE; /*!40000 ALTER TABLE `orchard_projections_stringfieldindexrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_projections_stringfieldindexrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_recipes_recipestepresultrecord` -- DROP TABLE IF EXISTS `orchard_recipes_recipestepresultrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_recipes_recipestepresultrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `ExecutionId` varchar(128) NOT NULL, `RecipeName` varchar(256) DEFAULT NULL, `StepId` varchar(32) NOT NULL, `StepName` varchar(256) NOT NULL, `IsCompleted` tinyint(1) NOT NULL, `IsSuccessful` tinyint(1) NOT NULL, `ErrorMessage` varchar(10000) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `IDX_RecipeStepResultRecord_ExecutionId` (`ExecutionId`), KEY `IDX_RecipeStepResultRecord_ExecutionId_StepName` (`ExecutionId`,`StepName`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_recipes_recipestepresultrecord` -- LOCK TABLES `orchard_recipes_recipestepresultrecord` WRITE; /*!40000 ALTER TABLE `orchard_recipes_recipestepresultrecord` DISABLE KEYS */; INSERT INTO `orchard_recipes_recipestepresultrecord` VALUES (1,'5953185e33934bb6950f7a76eaf2807c','Default','1','Feature',1,1,NULL),(2,'5953185e33934bb6950f7a76eaf2807c','Default','2','ContentDefinition',1,1,NULL),(3,'5953185e33934bb6950f7a76eaf2807c','Default','3','Settings',1,1,NULL),(4,'5953185e33934bb6950f7a76eaf2807c','Default','4','Migration',1,1,NULL),(5,'5953185e33934bb6950f7a76eaf2807c','Default','5','Command',1,1,NULL),(6,'5953185e33934bb6950f7a76eaf2807c','Default','a7ea9407dea0499c9ba1dd85c919d5bf','ActivateShell',1,1,NULL); /*!40000 ALTER TABLE `orchard_recipes_recipestepresultrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_roles_permissionrecord` -- DROP TABLE IF EXISTS `orchard_roles_permissionrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_roles_permissionrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) DEFAULT NULL, `FeatureName` varchar(255) DEFAULT NULL, `Description` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_roles_permissionrecord` -- LOCK TABLES `orchard_roles_permissionrecord` WRITE; /*!40000 ALTER TABLE `orchard_roles_permissionrecord` DISABLE KEYS */; INSERT INTO `orchard_roles_permissionrecord` VALUES (1,'ManageSettings','Settings','Manage Settings'),(2,'ManageUsers','Orchard.Users','Managing Users'),(3,'ManageRoles','Orchard.Roles','Managing Roles'),(4,'AssignRoles','Orchard.Roles','Assign Roles'),(5,'PublishContent','Contents','Publish or unpublish content for others'),(6,'EditContent','Contents','Edit content for others'),(7,'DeleteContent','Contents','Delete content for others'),(8,'PreviewContent','Contents','Preview content'),(9,'PublishOwnContent','Contents','Publish or unpublish own content'),(10,'EditOwnContent','Contents','Edit own content'),(11,'DeleteOwnContent','Contents','Delete own content'),(12,'PreviewOwnContent','Contents','Preview own content'),(13,'ViewContent','Contents','View all content'),(14,'SetHomePage','Orchard.Autoroute','Set Home Page'),(15,'ApplyTheme','Orchard.Themes','Apply a Theme'),(16,'ManageMenus','Navigation','Manage all menus'),(17,'ManageFeatures','Orchard.Modules','Manage Features'),(18,'SiteOwner','Orchard.Framework','Site Owners Permission'),(19,'AccessAdminPanel','Orchard.Framework','Access admin panel'),(20,'AccessFrontEnd','Orchard.Framework','Access site front-end'),(21,'ViewContentTypes','Orchard.ContentTypes','View content types.'),(22,'EditContentTypes','Orchard.ContentTypes','Edit content types.'),(23,'ManageMediaContent','Orchard.MediaLibrary','Manage Media'),(24,'ManageOwnMedia','Orchard.MediaLibrary','Manage Own Media'),(25,'ManageWidgets','Orchard.Widgets','Managing Widgets'),(26,'ManageBlogs','Orchard.Blogs','Manage blogs for others'),(27,'PublishBlogPost','Orchard.Blogs','Publish or unpublish blog post for others'),(28,'EditBlogPost','Orchard.Blogs','Edit blog posts for others'),(29,'DeleteBlogPost','Orchard.Blogs','Delete blog post for others'),(30,'ManageOwnBlogs','Orchard.Blogs','Manage own blogs'),(31,'EditOwnBlogPost','Orchard.Blogs','Edit own blog posts'),(32,'ManageComments','Orchard.Comments','Manage comments'),(33,'AddComment','Orchard.Comments','Add comment'),(34,'ManageLayouts','Orchard.Layouts','Managing Layouts'),(35,'ManageTaxonomies','Orchard.Taxonomies','Manage taxonomies'),(36,'CreateTaxonomy','Orchard.Taxonomies','Create taxonomy'),(37,'ManageQueries','Orchard.Projections','Manage queries'),(38,'ManageTags','Orchard.Tags','Manage tags'); /*!40000 ALTER TABLE `orchard_roles_permissionrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_roles_rolerecord` -- DROP TABLE IF EXISTS `orchard_roles_rolerecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_roles_rolerecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_roles_rolerecord` -- LOCK TABLES `orchard_roles_rolerecord` WRITE; /*!40000 ALTER TABLE `orchard_roles_rolerecord` DISABLE KEYS */; INSERT INTO `orchard_roles_rolerecord` VALUES (1,'Administrator'),(2,'Editor'),(3,'Moderator'),(4,'Author'),(5,'Contributor'),(6,'Authenticated'),(7,'Anonymous'); /*!40000 ALTER TABLE `orchard_roles_rolerecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_roles_rolespermissionsrecord` -- DROP TABLE IF EXISTS `orchard_roles_rolespermissionsrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_roles_rolespermissionsrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Role_id` int(11) DEFAULT NULL, `Permission_id` int(11) DEFAULT NULL, `RoleRecord_Id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_roles_rolespermissionsrecord` -- LOCK TABLES `orchard_roles_rolespermissionsrecord` WRITE; /*!40000 ALTER TABLE `orchard_roles_rolespermissionsrecord` DISABLE KEYS */; INSERT INTO `orchard_roles_rolespermissionsrecord` VALUES (1,1,1,1),(2,1,2,1),(3,1,3,1),(4,1,4,1),(5,1,5,1),(6,1,6,1),(7,1,7,1),(8,1,8,1),(9,2,5,2),(10,2,6,2),(11,2,7,2),(12,2,8,2),(13,4,9,4),(14,4,10,4),(15,4,11,4),(16,4,12,4),(17,5,10,5),(18,5,12,5),(19,6,13,6),(20,7,13,7),(21,1,14,1),(22,2,14,2),(23,1,15,1),(24,1,16,1),(25,1,17,1),(26,1,18,1),(27,1,19,1),(28,7,20,7),(29,6,20,6),(30,2,19,2),(31,3,19,3),(32,4,19,4),(33,5,19,5),(34,1,21,1),(35,1,22,1),(36,1,23,1),(37,2,23,2),(38,4,24,4),(39,5,24,5),(40,1,25,1),(41,1,26,1),(42,2,27,2),(43,2,28,2),(44,2,29,2),(45,4,30,4),(46,5,31,5),(47,1,32,1),(48,1,33,1),(49,7,33,7),(50,6,33,6),(51,2,33,2),(52,3,32,3),(53,3,33,3),(54,4,33,4),(55,5,33,5),(56,1,34,1),(57,2,34,2),(58,1,35,1),(59,2,35,2),(60,3,35,3),(61,4,36,4),(62,1,37,1),(63,2,37,2),(64,1,38,1),(65,2,38,2),(66,3,38,3); /*!40000 ALTER TABLE `orchard_roles_rolespermissionsrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_roles_userrolespartrecord` -- DROP TABLE IF EXISTS `orchard_roles_userrolespartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_roles_userrolespartrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `UserId` int(11) DEFAULT NULL, `Role_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_roles_userrolespartrecord` -- LOCK TABLES `orchard_roles_userrolespartrecord` WRITE; /*!40000 ALTER TABLE `orchard_roles_userrolespartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_roles_userrolespartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_tags_contenttagrecord` -- DROP TABLE IF EXISTS `orchard_tags_contenttagrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_tags_contenttagrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `TagRecord_Id` int(11) DEFAULT NULL, `TagsPartRecord_Id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_tags_contenttagrecord` -- LOCK TABLES `orchard_tags_contenttagrecord` WRITE; /*!40000 ALTER TABLE `orchard_tags_contenttagrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_tags_contenttagrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_tags_tagrecord` -- DROP TABLE IF EXISTS `orchard_tags_tagrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_tags_tagrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `TagName` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_tags_tagrecord` -- LOCK TABLES `orchard_tags_tagrecord` WRITE; /*!40000 ALTER TABLE `orchard_tags_tagrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_tags_tagrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_tags_tagspartrecord` -- DROP TABLE IF EXISTS `orchard_tags_tagspartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_tags_tagspartrecord` ( `Id` int(11) NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_tags_tagspartrecord` -- LOCK TABLES `orchard_tags_tagspartrecord` WRITE; /*!40000 ALTER TABLE `orchard_tags_tagspartrecord` DISABLE KEYS */; INSERT INTO `orchard_tags_tagspartrecord` VALUES (9); /*!40000 ALTER TABLE `orchard_tags_tagspartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_taxonomies_taxonomypartrecord` -- DROP TABLE IF EXISTS `orchard_taxonomies_taxonomypartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_taxonomies_taxonomypartrecord` ( `Id` int(11) NOT NULL, `TermTypeName` varchar(255) DEFAULT NULL, `IsInternal` tinyint(1) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_taxonomies_taxonomypartrecord` -- LOCK TABLES `orchard_taxonomies_taxonomypartrecord` WRITE; /*!40000 ALTER TABLE `orchard_taxonomies_taxonomypartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_taxonomies_taxonomypartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_taxonomies_termcontentitem` -- DROP TABLE IF EXISTS `orchard_taxonomies_termcontentitem`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_taxonomies_termcontentitem` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Field` varchar(50) DEFAULT NULL, `TermRecord_id` int(11) DEFAULT NULL, `TermsPartRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_taxonomies_termcontentitem` -- LOCK TABLES `orchard_taxonomies_termcontentitem` WRITE; /*!40000 ALTER TABLE `orchard_taxonomies_termcontentitem` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_taxonomies_termcontentitem` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_taxonomies_termpartrecord` -- DROP TABLE IF EXISTS `orchard_taxonomies_termpartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_taxonomies_termpartrecord` ( `Id` int(11) NOT NULL, `Path` varchar(255) DEFAULT NULL, `TaxonomyId` int(11) DEFAULT NULL, `Count` int(11) DEFAULT NULL, `Weight` int(11) DEFAULT NULL, `Selectable` tinyint(1) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `IDX_Path` (`Path`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_taxonomies_termpartrecord` -- LOCK TABLES `orchard_taxonomies_termpartrecord` WRITE; /*!40000 ALTER TABLE `orchard_taxonomies_termpartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_taxonomies_termpartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_taxonomies_termspartrecord` -- DROP TABLE IF EXISTS `orchard_taxonomies_termspartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_taxonomies_termspartrecord` ( `Id` int(11) NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_taxonomies_termspartrecord` -- LOCK TABLES `orchard_taxonomies_termspartrecord` WRITE; /*!40000 ALTER TABLE `orchard_taxonomies_termspartrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_taxonomies_termspartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_users_userpartrecord` -- DROP TABLE IF EXISTS `orchard_users_userpartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_users_userpartrecord` ( `Id` int(11) NOT NULL, `UserName` varchar(255) DEFAULT NULL, `Email` varchar(255) DEFAULT NULL, `NormalizedUserName` varchar(255) DEFAULT NULL, `Password` varchar(255) DEFAULT NULL, `PasswordFormat` varchar(255) DEFAULT NULL, `HashAlgorithm` varchar(255) DEFAULT NULL, `PasswordSalt` varchar(255) DEFAULT NULL, `RegistrationStatus` varchar(255) DEFAULT 'Approved', `EmailStatus` varchar(255) DEFAULT 'Approved', `EmailChallengeToken` varchar(255) DEFAULT NULL, `CreatedUtc` datetime DEFAULT NULL, `LastLoginUtc` datetime DEFAULT NULL, `LastLogoutUtc` datetime DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_users_userpartrecord` -- LOCK TABLES `orchard_users_userpartrecord` WRITE; /*!40000 ALTER TABLE `orchard_users_userpartrecord` DISABLE KEYS */; INSERT INTO `orchard_users_userpartrecord` VALUES (2,'admin','','admin','AHOmHpvpilemRrGnAt0jcMbHiJqjJnGvvQl/l2gFnfxvHYoZMULP4kqa9DNzypjZqQ==','Hashed','PBKDF2','86pRw9itYuqoM53BpROWjw==','Approved','Approved',NULL,'2016-04-03 03:01:00',NULL,NULL); /*!40000 ALTER TABLE `orchard_users_userpartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_widgets_layerpartrecord` -- DROP TABLE IF EXISTS `orchard_widgets_layerpartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_widgets_layerpartrecord` ( `Id` int(11) NOT NULL, `Name` varchar(255) DEFAULT NULL, `Description` varchar(10000) DEFAULT NULL, `LayerRule` varchar(10000) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_widgets_layerpartrecord` -- LOCK TABLES `orchard_widgets_layerpartrecord` WRITE; /*!40000 ALTER TABLE `orchard_widgets_layerpartrecord` DISABLE KEYS */; INSERT INTO `orchard_widgets_layerpartrecord` VALUES (3,'Default','The widgets in this layer are displayed on all pages','true'),(4,'Authenticated','The widgets in this layer are displayed when the user is authenticated','authenticated'),(5,'Anonymous','The widgets in this layer are displayed when the user is anonymous','not authenticated'),(6,'Disabled','The widgets in this layer are never displayed','false'),(7,'TheHomepage','The widgets in this layer are displayed on the home page','url \'~/\''); /*!40000 ALTER TABLE `orchard_widgets_layerpartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_widgets_widgetpartrecord` -- DROP TABLE IF EXISTS `orchard_widgets_widgetpartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_widgets_widgetpartrecord` ( `Id` int(11) NOT NULL, `Title` varchar(255) DEFAULT NULL, `Position` varchar(255) DEFAULT NULL, `Zone` varchar(255) DEFAULT NULL, `RenderTitle` tinyint(1) DEFAULT '1', `Name` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_widgets_widgetpartrecord` -- LOCK TABLES `orchard_widgets_widgetpartrecord` WRITE; /*!40000 ALTER TABLE `orchard_widgets_widgetpartrecord` DISABLE KEYS */; INSERT INTO `orchard_widgets_widgetpartrecord` VALUES (11,'Main Menu','1','Navigation',0,NULL); /*!40000 ALTER TABLE `orchard_widgets_widgetpartrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_workflows_activityrecord` -- DROP TABLE IF EXISTS `orchard_workflows_activityrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_workflows_activityrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) DEFAULT NULL, `X` int(11) DEFAULT NULL, `Y` int(11) DEFAULT NULL, `State` varchar(10000) DEFAULT NULL, `Start` tinyint(1) DEFAULT NULL, `WorkflowDefinitionRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_workflows_activityrecord` -- LOCK TABLES `orchard_workflows_activityrecord` WRITE; /*!40000 ALTER TABLE `orchard_workflows_activityrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_workflows_activityrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_workflows_awaitingactivityrecord` -- DROP TABLE IF EXISTS `orchard_workflows_awaitingactivityrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_workflows_awaitingactivityrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `ActivityRecord_id` int(11) DEFAULT NULL, `WorkflowRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_workflows_awaitingactivityrecord` -- LOCK TABLES `orchard_workflows_awaitingactivityrecord` WRITE; /*!40000 ALTER TABLE `orchard_workflows_awaitingactivityrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_workflows_awaitingactivityrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_workflows_transitionrecord` -- DROP TABLE IF EXISTS `orchard_workflows_transitionrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_workflows_transitionrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `SourceEndpoint` varchar(255) DEFAULT NULL, `DestinationEndpoint` varchar(255) DEFAULT NULL, `SourceActivityRecord_id` int(11) DEFAULT NULL, `DestinationActivityRecord_id` int(11) DEFAULT NULL, `WorkflowDefinitionRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_workflows_transitionrecord` -- LOCK TABLES `orchard_workflows_transitionrecord` WRITE; /*!40000 ALTER TABLE `orchard_workflows_transitionrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_workflows_transitionrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_workflows_workflowdefinitionrecord` -- DROP TABLE IF EXISTS `orchard_workflows_workflowdefinitionrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_workflows_workflowdefinitionrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Enabled` tinyint(1) DEFAULT NULL, `Name` varchar(1024) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_workflows_workflowdefinitionrecord` -- LOCK TABLES `orchard_workflows_workflowdefinitionrecord` WRITE; /*!40000 ALTER TABLE `orchard_workflows_workflowdefinitionrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_workflows_workflowdefinitionrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orchard_workflows_workflowrecord` -- DROP TABLE IF EXISTS `orchard_workflows_workflowrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orchard_workflows_workflowrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `State` varchar(10000) DEFAULT NULL, `WorkflowDefinitionRecord_id` int(11) DEFAULT NULL, `ContentItemRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orchard_workflows_workflowrecord` -- LOCK TABLES `orchard_workflows_workflowrecord` WRITE; /*!40000 ALTER TABLE `orchard_workflows_workflowrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `orchard_workflows_workflowrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `scheduling_scheduledtaskrecord` -- DROP TABLE IF EXISTS `scheduling_scheduledtaskrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scheduling_scheduledtaskrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `TaskType` varchar(255) DEFAULT NULL, `ScheduledUtc` datetime DEFAULT NULL, `ContentItemVersionRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `scheduling_scheduledtaskrecord` -- LOCK TABLES `scheduling_scheduledtaskrecord` WRITE; /*!40000 ALTER TABLE `scheduling_scheduledtaskrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `scheduling_scheduledtaskrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings_contentfielddefinitionrecord` -- DROP TABLE IF EXISTS `settings_contentfielddefinitionrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings_contentfielddefinitionrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `UC_CFDR_Name` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings_contentfielddefinitionrecord` -- LOCK TABLES `settings_contentfielddefinitionrecord` WRITE; /*!40000 ALTER TABLE `settings_contentfielddefinitionrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `settings_contentfielddefinitionrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings_contentpartdefinitionrecord` -- DROP TABLE IF EXISTS `settings_contentpartdefinitionrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings_contentpartdefinitionrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) DEFAULT NULL, `Hidden` tinyint(1) DEFAULT NULL, `Settings` varchar(10000) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `UC_CPDR_Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings_contentpartdefinitionrecord` -- LOCK TABLES `settings_contentpartdefinitionrecord` WRITE; /*!40000 ALTER TABLE `settings_contentpartdefinitionrecord` DISABLE KEYS */; INSERT INTO `settings_contentpartdefinitionrecord` VALUES (1,'BodyPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Allows the editing of text using an editor provided by the configured flavor (e.g. html, text, markdown).\" ContentPartLayoutSettings.Placeable=\"True\" BodyPartSettings.FlavorDefault=\"html\" />'),(2,'CommonPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Provides common information about a content item, such as Owner, Date Created, Date Published and Date Modified.\" ContentPartLayoutSettings.Placeable=\"True\" />'),(3,'IdentityPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Automatically generates a unique identity for the content item, which is required in import/export scenarios where one content item references another.\" />'),(4,'WidgetPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Turns a content type into a Widget. Note: you need to set the stereotype to "Widget" as well.\" />'),(5,'ContainerWidgetPart',0,NULL),(6,'ContainerPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Turns your content item into a container that is capable of containing content items that have the ContainablePart attached.\" />'),(7,'ContainablePart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Allows your content item to be contained by a content item that has the ContainerPart attached.\" />'),(8,'TitlePart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Provides a Title for your content item.\" ContentPartLayoutSettings.Placeable=\"True\" />'),(9,'MenuPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Provides an easy way to create a ContentMenuItem from the content editor.\" />'),(10,'MenuWidgetPart',0,NULL),(11,'AdminMenuPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Adds a menu item to the Admin menu that links to this content item.\" />'),(12,'ShapeMenuItemPart',0,NULL),(13,'ContentMenuItemPart',0,NULL),(14,'NavigationPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Allows the management of Content Menu Items associated with a Content Item.\" />'),(15,'AutoroutePart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Adds advanced url configuration options to your content type to completely customize the url pattern for a content item.\" />'),(16,'PublishLaterPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Adds the ability to delay the publication of a content item to a later date and time.\" />'),(17,'LayoutPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Adds a layout designer to your content type.\" />'),(18,'DisableThemePart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"When attached to a content type, disables the theme when a content item of this type is displayed.\" />'),(19,'ImageProfilePart',0,NULL),(20,'MediaPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Turns a content type into a Media. Note: you need to set the stereotype to "Media" as well.\" />'),(21,'ImagePart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Provides common metadata for an Image Media.\" />'),(22,'VectorImagePart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Provides common metadata for a Vector Image Media.\" />'),(23,'VideoPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Provides common metadata for a Video Media.\" />'),(24,'AudioPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Provides common metadata for an Audio Media.\" />'),(25,'DocumentPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Provides common metadata for a Document Media.\" />'),(26,'OEmbedPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Provides common metadata for an OEmbed Media.\" />'),(27,'LayerPart',0,NULL),(28,'BlogPart',0,'<settings ContentPartSettings.Description=\"Turns content types into a Blog.\" />'),(29,'BlogPostPart',0,'<settings ContentPartSettings.Description=\"Turns content types into a BlogPost.\" />'),(30,'RecentBlogPostsPart',0,'<settings ContentPartSettings.Description=\"Renders a list of recent blog posts.\" />'),(31,'BlogArchivesPart',0,'<settings ContentPartSettings.Description=\"Renders an archive of posts for a blog.\" />'),(32,'CommentPart',0,'<settings ContentPartSettings.Description=\"Used by the Comment content type.\" />'),(33,'CommentsContainerPart',0,'<settings ContentPartSettings.Description=\"Adds support to a content type to contain comments.\" />'),(34,'CommentsPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Allows content items to be commented on.\" />'),(35,'TagsPart',0,'<settings ContentPartLayoutSettings.Placeable=\"True\" ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Allows to describe your content using non-hierarchical keywords.\" />'),(36,'ElementWrapperPart',0,'<settings ContentPartSettings.Attachable=\"True\" ContentPartSettings.Description=\"Turns elements into content items.\" />'),(37,'TaxonomyPart',0,NULL),(38,'TaxonomyNavigationPart',0,NULL),(39,'QueryPart',0,NULL),(40,'ProjectionPart',0,NULL),(41,'NavigationQueryPart',0,NULL),(42,'LocalizationPart',0,NULL); /*!40000 ALTER TABLE `settings_contentpartdefinitionrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings_contentpartfielddefinitionrecord` -- DROP TABLE IF EXISTS `settings_contentpartfielddefinitionrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings_contentpartfielddefinitionrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) DEFAULT NULL, `Settings` varchar(10000) DEFAULT NULL, `ContentFieldDefinitionRecord_id` int(11) DEFAULT NULL, `ContentPartDefinitionRecord_Id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `UC_CPFDR_CPDRId_Name` (`ContentPartDefinitionRecord_Id`,`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings_contentpartfielddefinitionrecord` -- LOCK TABLES `settings_contentpartfielddefinitionrecord` WRITE; /*!40000 ALTER TABLE `settings_contentpartfielddefinitionrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `settings_contentpartfielddefinitionrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings_contenttypedefinitionrecord` -- DROP TABLE IF EXISTS `settings_contenttypedefinitionrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings_contenttypedefinitionrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) DEFAULT NULL, `DisplayName` varchar(255) DEFAULT NULL, `Hidden` tinyint(1) DEFAULT NULL, `Settings` varchar(10000) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `UC_CTDR_CPDRId` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings_contenttypedefinitionrecord` -- LOCK TABLES `settings_contenttypedefinitionrecord` WRITE; /*!40000 ALTER TABLE `settings_contenttypedefinitionrecord` DISABLE KEYS */; INSERT INTO `settings_contenttypedefinitionrecord` VALUES (1,'Site','Site',0,'<settings />'),(2,'ContainerWidget','Container Widget',0,'<settings Stereotype=\"Widget\" />'),(3,'MenuItem','Custom Link',0,'<settings Description=\"Represents a simple custom link with a text and an url.\" Stereotype=\"MenuItem\" />'),(4,'Menu','Menu',0,'<settings />'),(5,'MenuWidget','Menu Widget',0,'<settings Stereotype=\"Widget\" />'),(6,'HtmlMenuItem','Html Menu Item',0,'<settings Description=\"Renders some custom HTML in the menu.\" BodyPartSettings.FlavorDefault=\"html\" Stereotype=\"MenuItem\" />'),(7,'ShapeMenuItem','Shape Link',0,'<settings Description=\"Injects menu items from a Shape\" Stereotype=\"MenuItem\" />'),(8,'ContentMenuItem','Content Menu Item',0,'<settings Description=\"Adds a Content Item to the menu.\" Stereotype=\"MenuItem\" />'),(9,'Page','Page',0,'<settings ContentTypeSettings.Creatable=\"True\" ContentTypeSettings.Listable=\"True\" ContentTypeSettings.Securable=\"True\" ContentTypeSettings.Draftable=\"True\" TypeIndexing.Indexes=\"Search\" />'),(10,'User','User',0,'<settings ContentTypeSettings.Creatable=\"False\" />'),(11,'ImageProfile','Image Profile',0,'<settings />'),(12,'Image','Image',0,'<settings MediaFileNameEditorSettings.ShowFileNameEditor=\"True\" Stereotype=\"Media\" />'),(13,'VectorImage','Vector Image',0,'<settings MediaFileNameEditorSettings.ShowFileNameEditor=\"True\" Stereotype=\"Media\" />'),(14,'Video','Video',0,'<settings MediaFileNameEditorSettings.ShowFileNameEditor=\"True\" Stereotype=\"Media\" />'),(15,'Audio','Audio',0,'<settings MediaFileNameEditorSettings.ShowFileNameEditor=\"True\" Stereotype=\"Media\" />'),(16,'Document','Document',0,'<settings MediaFileNameEditorSettings.ShowFileNameEditor=\"True\" Stereotype=\"Media\" />'),(17,'OEmbed','External Media',0,'<settings Stereotype=\"Media\" />'),(18,'Layer','Layer',0,'<settings />'),(19,'HtmlWidget','Html Widget',0,'<settings Stereotype=\"Widget\" />'),(20,'Blog','Blog',0,'<settings />'),(21,'BlogPost','Blog Post',0,'<settings ContentTypeSettings.Draftable=\"True\" TypeIndexing.Indexes=\"Search\" />'),(22,'RecentBlogPosts','Recent Blog Posts',0,'<settings Stereotype=\"Widget\" />'),(23,'BlogArchives','Blog Archives',0,'<settings Stereotype=\"Widget\" />'),(24,'Comment','Comment',0,'<settings />'),(25,'Layout','Layout',0,'<settings ContentTypeSettings.Draftable=\"True\" />'),(26,'LayoutWidget','Layout Widget',0,'<settings Stereotype=\"Widget\" />'),(27,'TextWidget','Text Widget',0,'<settings Stereotype=\"Widget\" />'),(28,'MediaWidget','Media Widget',0,'<settings Stereotype=\"Widget\" />'),(29,'ContentWidget','Content Widget',0,'<settings Stereotype=\"Widget\" />'),(30,'Taxonomy','Taxonomy',0,'<settings />'),(31,'TaxonomyNavigationMenuItem','Taxonomy Link',0,'<settings Description=\"Injects menu items from a Taxonomy\" Stereotype=\"MenuItem\" />'),(32,'Query','Query',0,'<settings />'),(33,'ProjectionWidget','Projection Widget',0,'<settings Stereotype=\"Widget\" />'),(34,'ProjectionPage','Projection',0,'<settings ContentTypeSettings.Creatable=\"True\" ContentTypeSettings.Listable=\"True\" />'),(35,'NavigationQueryMenuItem','Query Link',0,'<settings Description=\"Injects menu items from a Query\" Stereotype=\"MenuItem\" />'); /*!40000 ALTER TABLE `settings_contenttypedefinitionrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings_contenttypepartdefinitionrecord` -- DROP TABLE IF EXISTS `settings_contenttypepartdefinitionrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings_contenttypepartdefinitionrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Settings` varchar(10000) DEFAULT NULL, `ContentPartDefinitionRecord_id` int(11) DEFAULT NULL, `ContentTypeDefinitionRecord_Id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `UC_CTPDR_CPDRId_CTDRId` (`ContentPartDefinitionRecord_id`,`ContentTypeDefinitionRecord_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings_contenttypepartdefinitionrecord` -- LOCK TABLES `settings_contenttypepartdefinitionrecord` WRITE; /*!40000 ALTER TABLE `settings_contenttypepartdefinitionrecord` DISABLE KEYS */; INSERT INTO `settings_contenttypepartdefinitionrecord` VALUES (1,'<settings />',2,2),(2,'<settings />',4,2),(3,'<settings />',5,2),(4,'<settings />',3,2),(5,'<settings />',9,3),(6,'<settings />',3,3),(7,'<settings />',2,3),(8,'<settings OwnerEditorSettings.ShowOwnerEditor=\"false\" />',2,4),(9,'<settings />',8,4),(10,'<settings />',2,5),(11,'<settings />',3,5),(12,'<settings />',4,5),(13,'<settings />',10,5),(14,'<settings />',9,6),(15,'<settings />',1,6),(16,'<settings />',2,6),(17,'<settings />',3,6),(18,'<settings />',12,7),(19,'<settings />',9,7),(20,'<settings />',2,7),(21,'<settings />',3,4),(22,'<settings />',9,8),(23,'<settings />',2,8),(24,'<settings />',3,8),(25,'<settings />',13,8),(26,'<settings DateEditorSettings.ShowDateEditor=\"True\" />',2,9),(27,'<settings />',16,9),(28,'<settings />',8,9),(29,'<settings AutorouteSettings.AllowCustomPattern=\"True\" AutorouteSettings.AutomaticAdjustmentOnEdit=\"False\" AutorouteSettings.PatternDefinitions=\"[{"Name":"Title","Pattern":"{Content.Slug}","Description":"my-page"}]\" />',15,9),(30,'<settings LayoutTypePartSettings.IsTemplate=\"False\" />',17,9),(31,'<settings />',19,11),(32,'<settings OwnerEditorSettings.ShowOwnerEditor=\"false\" />',2,11),(33,'<settings />',3,11),(34,'<settings />',2,12),(35,'<settings />',20,12),(36,'<settings />',8,12),(37,'<settings />',21,12),(38,'<settings />',3,12),(39,'<settings />',2,13),(40,'<settings />',20,13),(41,'<settings />',8,13),(42,'<settings />',22,13),(43,'<settings />',3,13),(44,'<settings />',2,14),(45,'<settings />',20,14),(46,'<settings />',8,14),(47,'<settings />',23,14),(48,'<settings />',3,14),(49,'<settings />',2,15),(50,'<settings />',20,15),(51,'<settings />',8,15),(52,'<settings />',24,15),(53,'<settings />',3,15),(54,'<settings />',2,16),(55,'<settings />',20,16),(56,'<settings />',8,16),(57,'<settings />',25,16),(58,'<settings />',3,16),(59,'<settings />',3,17),(60,'<settings />',2,17),(61,'<settings />',20,17),(62,'<settings />',26,17),(63,'<settings />',8,17),(64,'<settings />',27,18),(65,'<settings OwnerEditorSettings.ShowOwnerEditor=\"false\" />',2,18),(66,'<settings />',1,19),(67,'<settings />',2,19),(68,'<settings />',4,19),(69,'<settings />',3,19),(70,'<settings />',28,20),(71,'<settings />',2,20),(72,'<settings />',8,20),(73,'<settings AutorouteSettings.AllowCustomPattern=\"True\" AutorouteSettings.AutomaticAdjustmentOnEdit=\"False\" AutorouteSettings.PatternDefinitions=\"[{"Name":"Title","Pattern":"{Content.Slug}","Description":"my-blog"}]\" />',15,20),(74,'<settings />',9,20),(75,'<settings AdminMenuPartTypeSettings.DefaultPosition=\"2\" />',11,20),(76,'<settings />',29,21),(77,'<settings DateEditorSettings.ShowDateEditor=\"True\" />',2,21),(78,'<settings />',16,21),(79,'<settings />',8,21),(80,'<settings AutorouteSettings.AllowCustomPattern=\"True\" AutorouteSettings.AutomaticAdjustmentOnEdit=\"False\" AutorouteSettings.PatternDefinitions=\"[{"Name":"Blog and Title","Pattern":"{Content.Container.Path}/{Content.Slug}","Description":"my-blog/my-post"}]\" />',15,21),(81,'<settings />',1,21),(82,'<settings />',30,22),(83,'<settings />',2,22),(84,'<settings />',4,22),(85,'<settings />',3,22),(86,'<settings />',31,23),(87,'<settings />',2,23),(88,'<settings />',4,23),(89,'<settings />',3,23),(90,'<settings />',32,24),(91,'<settings OwnerEditorSettings.ShowOwnerEditor=\"false\" DateEditorSettings.ShowDateEditor=\"false\" />',2,24),(92,'<settings />',3,24),(93,'<settings />',33,20),(94,'<settings OwnerEditorSettings.ShowOwnerEditor=\"false\" DateEditorSettings.ShowDateEditor=\"false\" />',2,25),(95,'<settings />',8,25),(96,'<settings />',3,25),(97,'<settings LayoutTypePartSettings.IsTemplate=\"True\" />',17,25),(98,'<settings OwnerEditorSettings.ShowOwnerEditor=\"false\" DateEditorSettings.ShowDateEditor=\"false\" />',2,26),(99,'<settings />',3,26),(100,'<settings />',4,26),(101,'<settings />',17,26),(102,'<settings OwnerEditorSettings.ShowOwnerEditor=\"false\" DateEditorSettings.ShowDateEditor=\"false\" />',2,27),(103,'<settings />',4,27),(104,'<settings />',3,27),(105,'<settings ElementWrapperPartSettings.ElementTypeName=\"Orchard.Layouts.Elements.Text\" />',36,27),(106,'<settings OwnerEditorSettings.ShowOwnerEditor=\"false\" DateEditorSettings.ShowDateEditor=\"false\" />',2,28),(107,'<settings />',4,28),(108,'<settings />',3,28),(109,'<settings ElementWrapperPartSettings.ElementTypeName=\"Orchard.Layouts.Elements.MediaItem\" />',36,28),(110,'<settings OwnerEditorSettings.ShowOwnerEditor=\"false\" DateEditorSettings.ShowDateEditor=\"false\" />',2,29),(111,'<settings />',4,29),(112,'<settings />',3,29),(113,'<settings ElementWrapperPartSettings.ElementTypeName=\"Orchard.Layouts.Elements.ContentItem\" />',36,29),(114,'<settings />',37,30),(115,'<settings />',2,30),(116,'<settings />',8,30),(117,'<settings AutorouteSettings.AllowCustomPattern=\"True\" AutorouteSettings.AutomaticAdjustmentOnEdit=\"False\" AutorouteSettings.PatternDefinitions=\"[{"Name":"Title","Pattern":"{Content.Slug}","Description":"my-taxonomy"}]\" />',15,30),(118,'<settings />',38,31),(119,'<settings />',9,31),(120,'<settings />',2,31),(121,'<settings />',39,32),(122,'<settings />',8,32),(123,'<settings />',3,32),(124,'<settings />',4,33),(125,'<settings />',2,33),(126,'<settings />',3,33),(127,'<settings />',40,33),(128,'<settings />',2,34),(129,'<settings />',8,34),(130,'<settings AutorouteSettings.AllowCustomPattern=\"True\" AutorouteSettings.AutomaticAdjustmentOnEdit=\"False\" AutorouteSettings.PatternDefinitions=\"[{"Name":"Title","Pattern":"{Content.Slug}","Description":"my-projections"}]\" />',15,34),(131,'<settings />',9,34),(132,'<settings />',40,34),(133,'<settings AdminMenuPartTypeSettings.DefaultPosition=\"5\" />',11,34),(134,'<settings />',41,35),(135,'<settings />',9,35),(136,'<settings />',2,35),(137,'<settings />',3,35),(138,'<settings />',35,9),(139,'<settings />',42,9),(140,'<settings />',9,9),(141,'<settings />',34,21),(142,'<settings />',35,21),(143,'<settings />',42,21); /*!40000 ALTER TABLE `settings_contenttypepartdefinitionrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings_shelldescriptorrecord` -- DROP TABLE IF EXISTS `settings_shelldescriptorrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings_shelldescriptorrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `SerialNumber` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings_shelldescriptorrecord` -- LOCK TABLES `settings_shelldescriptorrecord` WRITE; /*!40000 ALTER TABLE `settings_shelldescriptorrecord` DISABLE KEYS */; INSERT INTO `settings_shelldescriptorrecord` VALUES (1,2); /*!40000 ALTER TABLE `settings_shelldescriptorrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings_shellfeaturerecord` -- DROP TABLE IF EXISTS `settings_shellfeaturerecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings_shellfeaturerecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) DEFAULT NULL, `ShellDescriptorRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings_shellfeaturerecord` -- LOCK TABLES `settings_shellfeaturerecord` WRITE; /*!40000 ALTER TABLE `settings_shellfeaturerecord` DISABLE KEYS */; INSERT INTO `settings_shellfeaturerecord` VALUES (26,'Orchard.Framework',1),(27,'Common',1),(28,'Containers',1),(29,'Contents',1),(30,'Dashboard',1),(31,'Feeds',1),(32,'Navigation',1),(33,'Scheduling',1),(34,'Settings',1),(35,'Shapes',1),(36,'Title',1),(37,'Orchard.Pages',1),(38,'Orchard.ContentPicker',1),(39,'Orchard.Themes',1),(40,'Orchard.Users',1),(41,'Orchard.Roles',1),(42,'Orchard.Modules',1),(43,'PackagingServices',1),(44,'Orchard.Packaging',1),(45,'Gallery',1),(46,'Orchard.Recipes',1),(47,'Orchard.Alias',1),(48,'Orchard.Tokens',1),(49,'Orchard.Autoroute',1),(50,'Orchard.Resources',1),(51,'Orchard.Blogs',1),(52,'Orchard.Widgets',1),(53,'Orchard.PublishLater',1),(54,'Orchard.Conditions',1),(55,'Orchard.Scripting',1),(56,'Orchard.Comments',1),(57,'Orchard.Tags',1),(58,'Orchard.Alias',1),(59,'Orchard.Autoroute',1),(60,'TinyMce',1),(61,'Orchard.MediaLibrary',1),(62,'Orchard.MediaProcessing',1),(63,'Orchard.Forms',1),(64,'Orchard.ContentPicker',1),(65,'Orchard.Resources',1),(66,'Orchard.ContentTypes',1),(67,'Orchard.Scripting.Lightweight',1),(68,'PackagingServices',1),(69,'Orchard.Packaging',1),(70,'Orchard.Projections',1),(71,'Orchard.Fields',1),(72,'Orchard.OutputCache',1),(73,'Orchard.Taxonomies',1),(74,'Orchard.Workflows',1),(75,'Orchard.Layouts',1),(76,'Orchard.Layouts.Tokens',1),(77,'TheThemeMachine',1); /*!40000 ALTER TABLE `settings_shellfeaturerecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings_shellfeaturestaterecord` -- DROP TABLE IF EXISTS `settings_shellfeaturestaterecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings_shellfeaturestaterecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) DEFAULT NULL, `InstallState` varchar(255) DEFAULT NULL, `EnableState` varchar(255) DEFAULT NULL, `ShellStateRecord_Id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `UC_SFSR_SSRId_Name` (`ShellStateRecord_Id`,`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings_shellfeaturestaterecord` -- LOCK TABLES `settings_shellfeaturestaterecord` WRITE; /*!40000 ALTER TABLE `settings_shellfeaturestaterecord` DISABLE KEYS */; INSERT INTO `settings_shellfeaturestaterecord` VALUES (1,'Orchard.Framework','Up','Up',1),(2,'Common','Up','Up',1),(3,'Containers','Up','Up',1),(4,'Contents','Up','Up',1),(5,'Dashboard','Up','Up',1),(6,'Feeds','Up','Up',1),(7,'Navigation','Up','Up',1),(8,'Scheduling','Up','Up',1),(9,'Settings','Up','Up',1),(10,'Shapes','Up','Up',1),(11,'Title','Up','Up',1),(12,'Orchard.Pages','Up','Up',1),(13,'Orchard.ContentPicker','Up','Up',1),(14,'Orchard.Themes','Up','Up',1),(15,'Orchard.Users','Up','Up',1),(16,'Orchard.Roles','Up','Up',1),(17,'Orchard.Modules','Up','Up',1),(18,'PackagingServices','Up','Up',1),(19,'Orchard.Packaging','Up','Up',1),(20,'Gallery','Up','Up',1),(21,'Orchard.Recipes','Up','Up',1),(22,'Orchard.Alias','Up','Up',1),(23,'Orchard.Tokens','Up','Up',1),(24,'Orchard.Autoroute','Up','Up',1),(25,'Orchard.Resources','Up','Up',1),(26,'Orchard.Blogs','Up','Up',1),(27,'Orchard.Widgets','Up','Up',1),(28,'Orchard.PublishLater','Up','Up',1),(29,'Orchard.Conditions','Up','Up',1),(30,'Orchard.Scripting','Up','Up',1),(31,'Orchard.Comments','Up','Up',1),(32,'Orchard.Tags','Up','Up',1),(33,'TinyMce','Up','Up',1),(34,'Orchard.MediaLibrary','Up','Up',1),(35,'Orchard.MediaProcessing','Up','Up',1),(36,'Orchard.Forms','Up','Up',1),(37,'Orchard.ContentTypes','Up','Up',1),(38,'Orchard.Scripting.Lightweight','Up','Up',1),(39,'Orchard.Projections','Up','Up',1),(40,'Orchard.Fields','Up','Up',1),(41,'Orchard.OutputCache','Up','Up',1),(42,'Orchard.Taxonomies','Up','Up',1),(43,'Orchard.Workflows','Up','Up',1),(44,'Orchard.Layouts','Up','Up',1),(45,'Orchard.Layouts.Tokens','Up','Up',1),(46,'TheThemeMachine','Up','Up',1); /*!40000 ALTER TABLE `settings_shellfeaturestaterecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings_shellparameterrecord` -- DROP TABLE IF EXISTS `settings_shellparameterrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings_shellparameterrecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Component` varchar(255) DEFAULT NULL, `Name` varchar(255) DEFAULT NULL, `Value` varchar(255) DEFAULT NULL, `ShellDescriptorRecord_id` int(11) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `UC_SPR_SDRId_Component_Name` (`ShellDescriptorRecord_id`,`Component`,`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings_shellparameterrecord` -- LOCK TABLES `settings_shellparameterrecord` WRITE; /*!40000 ALTER TABLE `settings_shellparameterrecord` DISABLE KEYS */; /*!40000 ALTER TABLE `settings_shellparameterrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings_shellstaterecord` -- DROP TABLE IF EXISTS `settings_shellstaterecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings_shellstaterecord` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Unused` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings_shellstaterecord` -- LOCK TABLES `settings_shellstaterecord` WRITE; /*!40000 ALTER TABLE `settings_shellstaterecord` DISABLE KEYS */; INSERT INTO `settings_shellstaterecord` VALUES (1,NULL); /*!40000 ALTER TABLE `settings_shellstaterecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `title_titlepartrecord` -- DROP TABLE IF EXISTS `title_titlepartrecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `title_titlepartrecord` ( `Id` int(11) NOT NULL, `ContentItemRecord_id` int(11) DEFAULT NULL, `Title` varchar(1024) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `title_titlepartrecord` -- LOCK TABLES `title_titlepartrecord` WRITE; /*!40000 ALTER TABLE `title_titlepartrecord` DISABLE KEYS */; INSERT INTO `title_titlepartrecord` VALUES (8,8,'Main Menu'),(9,9,'Welcome to Orchard!'); /*!40000 ALTER TABLE `title_titlepartrecord` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-04-03 11:21:47
db创建语句：
CREATE DATABASE `orchard` /*!40100 DEFAULT CHARACTER SET latin2 */
至此ok了。
浙公网安备 33010602011771号