search

nuodb / migration-tools

Migration tools for NuoDB
http://nuodb.github.com/migration-tools/
BSD 3-Clause "New" or "Revised" License
27 stars 10 forks source link

Schema issues from SilverStripe MySQL database. #6

Closed thebithead closed 11 years ago

thebithead commented 11 years ago

The schema dump from the SilverStripe MySQL database does not load correctly in NuoDB. I attached a MySQL dump of the database I am trying to migrate.

${migration_tools_root}/assembly/target/nuodb-migration/bin/nuodb-migration schema --source.driver=com.mysql.jdbc.Driver --source.url=jdbc:mysql://localhost:3306/SS_mysite --source.username=emergentbird --source.password=xxxxxxxx --source.catalog=SS_mysite --output.path=/tmp/schema.sql

~> ${NUODEVO}/NuoSQL/nuosql test@localhost --user cloud --password user --schema SS_mysite < /tmp/schema.sql | & tee test.log DROP TABLE IF EXISTS Email_BounceRecord CASCADE; DROP SEQUENCE IF EXISTS SEQ615A473E; CREATE SEQUENCE SEQ615A473E START WITH 1; CREATE TABLE Email_BounceRecord (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ615A473E) NOT NULL, ClassName CHAR DEFAULT Email_BounceRecord, Created TIMESTAMP, LastEdited TIMESTAMP, BounceEmail VARCHAR(50), BounceTime TIMESTAMP, BounceMessage VARCHAR(50), MemberID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "EMAIL_BOUNCERECORD" CREATE INDEX MemberID ON Email_BounceRecord (MemberID); can't find table "EMAIL_BOUNCERECORD" CREATE INDEX ClassName ON Email_BounceRecord (ClassName); can't find table "EMAIL_BOUNCERECORD" DROP TABLE IF EXISTS ErrorPage CASCADE; DROP SEQUENCE IF EXISTS SEQE8B30DC3; CREATE SEQUENCE SEQE8B30DC3 START WITH 6; CREATE TABLE ErrorPage (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQE8B30DC3) NOT NULL, ErrorCode INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); DROP TABLE IF EXISTS ErrorPage_Live CASCADE; DROP SEQUENCE IF EXISTS SEQEF724186; CREATE SEQUENCE SEQEF724186 START WITH 6; CREATE TABLE ErrorPage_Live (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQEF724186) NOT NULL, ErrorCode INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); DROP TABLE IF EXISTS ErrorPage_versions CASCADE; DROP SEQUENCE IF EXISTS SEQCFC45D97; CREATE SEQUENCE SEQCFC45D97 START WITH 3; CREATE TABLE ErrorPage_versions (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQCFC45D97) NOT NULL, RecordID INTEGER NOT NULL DEFAULT 0, Version INTEGER NOT NULL DEFAULT 0, ErrorCode INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); CREATE UNIQUE INDEX RecordID_Version ON ErrorPage_versions (RecordID, Version); CREATE INDEX RecordID ON ErrorPage_versions (RecordID); CREATE INDEX Version ON ErrorPage_versions (Version); DROP TABLE IF EXISTS File CASCADE; DROP SEQUENCE IF EXISTS SEQ30424E9E; CREATE SEQUENCE SEQ30424E9E START WITH 4; CREATE TABLE File (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ30424E9E) NOT NULL, ClassName CHAR DEFAULT File, Created TIMESTAMP, LastEdited TIMESTAMP, Name VARCHAR(255), Title VARCHAR(255), Filename CLOB, Content CLOB, ShowInSearch BOOLEAN NOT NULL DEFAULT 1, ParentID INTEGER NOT NULL DEFAULT 0, OwnerID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "FILE" CREATE INDEX ParentID ON File (ParentID); can't find table "FILE" CREATE INDEX OwnerID ON File (OwnerID); can't find table "FILE" CREATE INDEX ClassName ON File (ClassName); can't find table "FILE" DROP TABLE IF EXISTS "Group" CASCADE; DROP SEQUENCE IF EXISTS SEQ2208D6FB; CREATE SEQUENCE SEQ2208D6FB START WITH 3; CREATE TABLE "Group" (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ2208D6FB) NOT NULL, ClassName CHAR DEFAULT Group, Created TIMESTAMP, LastEdited TIMESTAMP, Title VARCHAR(50), Description CLOB, Code VARCHAR(50), Locked BOOLEAN NOT NULL DEFAULT 0, Sort INTEGER NOT NULL DEFAULT 0, HtmlEditorConfig VARCHAR(50), ParentID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "GROUP" CREATE INDEX ParentID ON "Group" (ParentID); can't find table "Group" CREATE INDEX ClassName ON "Group" (ClassName); can't find table "Group" DROP TABLE IF EXISTS Group_Members CASCADE; DROP SEQUENCE IF EXISTS SEQ49BC2C01; CREATE SEQUENCE SEQ49BC2C01 START WITH 2; CREATE TABLE Group_Members (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ49BC2C01) NOT NULL, GroupID INTEGER NOT NULL DEFAULT 0, MemberID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); CREATE INDEX GroupID ON Group_Members (GroupID); CREATE INDEX MemberID ON Group_Members (MemberID); DROP TABLE IF EXISTS Group_Roles CASCADE; DROP SEQUENCE IF EXISTS SEQ16F353DD; CREATE SEQUENCE SEQ16F353DD START WITH 1; CREATE TABLE Group_Roles (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ16F353DD) NOT NULL, GroupID INTEGER NOT NULL DEFAULT 0, PermissionRoleID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); CREATE INDEX GroupID ON Group_Roles (GroupID); index GROUPID already exists on table SS_MYSITE.GROUP_MEMBERS CREATE INDEX PermissionRoleID ON Group_Roles (PermissionRoleID); DROP TABLE IF EXISTS LoginAttempt CASCADE; DROP SEQUENCE IF EXISTS SEQ9C0D9FF6; CREATE SEQUENCE SEQ9C0D9FF6 START WITH 1; CREATE TABLE LoginAttempt (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ9C0D9FF6) NOT NULL, ClassName CHAR DEFAULT LoginAttempt, Created TIMESTAMP, LastEdited TIMESTAMP, Email VARCHAR(255), Status CHAR DEFAULT Success, IP VARCHAR(255), MemberID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "LOGINATTEMPT" CREATE INDEX MemberID ON LoginAttempt (MemberID); can't find table "LOGINATTEMPT" CREATE INDEX ClassName ON LoginAttempt (ClassName); can't find table "LOGINATTEMPT" DROP TABLE IF EXISTS "Member" CASCADE; DROP SEQUENCE IF EXISTS SEQC772C4C0; CREATE SEQUENCE SEQC772C4C0 START WITH 2; CREATE TABLE "Member" (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQC772C4C0) NOT NULL, ClassName CHAR DEFAULT Member, Created TIMESTAMP, LastEdited TIMESTAMP, FirstName VARCHAR(50), Surname VARCHAR(50), Email VARCHAR(256), Password VARCHAR(160), RememberLoginToken VARCHAR(50), NumVisit INTEGER NOT NULL DEFAULT 0, LastVisited TIMESTAMP, Bounced BOOLEAN NOT NULL DEFAULT 0, AutoLoginHash VARCHAR(50), AutoLoginExpired TIMESTAMP, PasswordEncryption VARCHAR(50), Salt VARCHAR(50), PasswordExpiry DATE, LockedOutUntil TIMESTAMP, Locale VARCHAR(6), FailedLoginCount INTEGER NOT NULL DEFAULT 0, DateFormat VARCHAR(30), TimeFormat VARCHAR(30), PRIMARY KEY (ID)); can't resolve field "MEMBER" CREATE INDEX Email ON "Member" (Email); can't find table "Member" CREATE INDEX ClassName ON "Member" (ClassName); can't find table "Member" DROP TABLE IF EXISTS MemberPassword CASCADE; DROP SEQUENCE IF EXISTS SEQ38DA8225; CREATE SEQUENCE SEQ38DA8225 START WITH 2; CREATE TABLE MemberPassword (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ38DA8225) NOT NULL, ClassName CHAR DEFAULT MemberPassword, Created TIMESTAMP, LastEdited TIMESTAMP, Password VARCHAR(160), Salt VARCHAR(50), PasswordEncryption VARCHAR(50), MemberID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "MEMBERPASSWORD" CREATE INDEX MemberID ON MemberPassword (MemberID); can't find table "MEMBERPASSWORD" CREATE INDEX ClassName ON MemberPassword (ClassName); can't find table "MEMBERPASSWORD" DROP TABLE IF EXISTS Permission CASCADE; DROP SEQUENCE IF EXISTS SEQDA46D16B; CREATE SEQUENCE SEQDA46D16B START WITH 6; CREATE TABLE Permission (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQDA46D16B) NOT NULL, ClassName CHAR DEFAULT Permission, Created TIMESTAMP, LastEdited TIMESTAMP, Code VARCHAR(50), Arg INTEGER NOT NULL DEFAULT 0, Type INTEGER NOT NULL DEFAULT 1, GroupID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "PERMISSION" CREATE INDEX GroupID ON Permission (GroupID); can't find table "PERMISSION" CREATE INDEX Code ON Permission (Code); can't find table "PERMISSION" CREATE INDEX ClassName ON Permission (ClassName); can't find table "PERMISSION" DROP TABLE IF EXISTS PermissionRole CASCADE; DROP SEQUENCE IF EXISTS SEQ61E44C95; CREATE SEQUENCE SEQ61E44C95 START WITH 1; CREATE TABLE PermissionRole (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ61E44C95) NOT NULL, ClassName CHAR DEFAULT PermissionRole, Created TIMESTAMP, LastEdited TIMESTAMP, Title VARCHAR(50), OnlyAdminCanApply BOOLEAN NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "PERMISSIONROLE" CREATE INDEX ClassName ON PermissionRole (ClassName); can't find table "PERMISSIONROLE" DROP TABLE IF EXISTS PermissionRoleCode CASCADE; DROP SEQUENCE IF EXISTS SEQ80ADEDE8; CREATE SEQUENCE SEQ80ADEDE8 START WITH 1; CREATE TABLE PermissionRoleCode (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ80ADEDE8) NOT NULL, ClassName CHAR DEFAULT PermissionRoleCode, Created TIMESTAMP, LastEdited TIMESTAMP, Code VARCHAR(50), RoleID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "PERMISSIONROLECODE" CREATE INDEX RoleID ON PermissionRoleCode (RoleID); can't find table "PERMISSIONROLECODE" CREATE INDEX ClassName ON PermissionRoleCode (ClassName); can't find table "PERMISSIONROLECODE" DROP TABLE IF EXISTS RedirectorPage CASCADE; DROP SEQUENCE IF EXISTS SEQD70FE0EC; CREATE SEQUENCE SEQD70FE0EC START WITH 1; CREATE TABLE RedirectorPage (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQD70FE0EC) NOT NULL, RedirectionType CHAR DEFAULT Internal, ExternalURL VARCHAR(2083), LinkToID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "INTERNAL" CREATE INDEX LinkToID ON RedirectorPage (LinkToID); can't find table "REDIRECTORPAGE" DROP TABLE IF EXISTS RedirectorPage_Live CASCADE; DROP SEQUENCE IF EXISTS SEQEF17FFFD; CREATE SEQUENCE SEQEF17FFFD START WITH 1; CREATE TABLE RedirectorPage_Live (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQEF17FFFD) NOT NULL, RedirectionType CHAR DEFAULT Internal, ExternalURL VARCHAR(2083), LinkToID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "INTERNAL" CREATE INDEX LinkToID ON RedirectorPage_Live (LinkToID); can't find table "REDIRECTORPAGE_LIVE" DROP TABLE IF EXISTS RedirectorPage_versions CASCADE; DROP SEQUENCE IF EXISTS SEQF0E8088E; CREATE SEQUENCE SEQF0E8088E START WITH 1; CREATE TABLE RedirectorPage_versions (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQF0E8088E) NOT NULL, RecordID INTEGER NOT NULL DEFAULT 0, Version INTEGER NOT NULL DEFAULT 0, RedirectionType CHAR DEFAULT Internal, ExternalURL VARCHAR(2083), LinkToID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "INTERNAL" CREATE UNIQUE INDEX RecordID_Version ON RedirectorPage_versions (RecordID, Version); can't find table "REDIRECTORPAGE_VERSIONS" CREATE INDEX RecordID ON RedirectorPage_versions (RecordID); can't find table "REDIRECTORPAGE_VERSIONS" CREATE INDEX Version ON RedirectorPage_versions (Version); can't find table "REDIRECTORPAGE_VERSIONS" CREATE INDEX LinkToID ON RedirectorPage_versions (LinkToID); can't find table "REDIRECTORPAGE_VERSIONS" DROP TABLE IF EXISTS SiteConfig CASCADE; DROP SEQUENCE IF EXISTS SEQ9C71BB91; CREATE SEQUENCE SEQ9C71BB91 START WITH 2; CREATE TABLE SiteConfig (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ9C71BB91) NOT NULL, ClassName CHAR DEFAULT SiteConfig, Created TIMESTAMP, LastEdited TIMESTAMP, Title VARCHAR(255), Tagline VARCHAR(255), Theme VARCHAR(255), CanViewType CHAR DEFAULT Anyone, CanEditType CHAR DEFAULT LoggedInUsers, CanCreateTopLevelType CHAR DEFAULT LoggedInUsers, PRIMARY KEY (ID)); can't resolve field "SITECONFIG" CREATE INDEX ClassName ON SiteConfig (ClassName); can't find table "SITECONFIG" DROP TABLE IF EXISTS SiteConfig_CreateTopLevelGroups CASCADE; DROP SEQUENCE IF EXISTS SEQ45434285; CREATE SEQUENCE SEQ45434285 START WITH 1; CREATE TABLE SiteConfig_CreateTopLevelGroups (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ45434285) NOT NULL, SiteConfigID INTEGER NOT NULL DEFAULT 0, GroupID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); CREATE INDEX SiteConfigID ON SiteConfig_CreateTopLevelGroups (SiteConfigID); CREATE INDEX GroupID ON SiteConfig_CreateTopLevelGroups (GroupID); index GROUPID already exists on table SS_MYSITE.GROUP_MEMBERS DROP TABLE IF EXISTS SiteConfig_EditorGroups CASCADE; DROP SEQUENCE IF EXISTS SEQ6F96D1A3; CREATE SEQUENCE SEQ6F96D1A3 START WITH 1; CREATE TABLE SiteConfig_EditorGroups (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ6F96D1A3) NOT NULL, SiteConfigID INTEGER NOT NULL DEFAULT 0, GroupID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); CREATE INDEX SiteConfigID ON SiteConfig_EditorGroups (SiteConfigID); index SITECONFIGID already exists on table SS_MYSITE.SITECONFIG_CREATETOPLEVELGROUPS CREATE INDEX GroupID ON SiteConfig_EditorGroups (GroupID); index GROUPID already exists on table SS_MYSITE.GROUP_MEMBERS DROP TABLE IF EXISTS SiteConfig_ViewerGroups CASCADE; DROP SEQUENCE IF EXISTS SEQ5C97AA9E; CREATE SEQUENCE SEQ5C97AA9E START WITH 1; CREATE TABLE SiteConfig_ViewerGroups (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ5C97AA9E) NOT NULL, SiteConfigID INTEGER NOT NULL DEFAULT 0, GroupID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); CREATE INDEX SiteConfigID ON SiteConfig_ViewerGroups (SiteConfigID); index SITECONFIGID already exists on table SS_MYSITE.SITECONFIG_CREATETOPLEVELGROUPS CREATE INDEX GroupID ON SiteConfig_ViewerGroups (GroupID); index GROUPID already exists on table SS_MYSITE.GROUP_MEMBERS DROP TABLE IF EXISTS SiteTree CASCADE; DROP SEQUENCE IF EXISTS SEQC6F0DFF5; CREATE SEQUENCE SEQC6F0DFF5 START WITH 6; CREATE TABLE SiteTree (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQC6F0DFF5) NOT NULL, ClassName CHAR DEFAULT Page, Created TIMESTAMP, LastEdited TIMESTAMP, URLSegment VARCHAR(255), Title VARCHAR(255), MenuTitle VARCHAR(100), Content CLOB, MetaTitle VARCHAR(255), MetaDescription CLOB, MetaKeywords VARCHAR(255), ExtraMeta CLOB, ShowInMenus BOOLEAN NOT NULL DEFAULT 0, ShowInSearch BOOLEAN NOT NULL DEFAULT 0, Sort INTEGER NOT NULL DEFAULT 0, HasBrokenFile BOOLEAN NOT NULL DEFAULT 0, HasBrokenLink BOOLEAN NOT NULL DEFAULT 0, ReportClass VARCHAR(50), CanViewType CHAR DEFAULT Inherit, CanEditType CHAR DEFAULT Inherit, Version INTEGER NOT NULL DEFAULT 0, ParentID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "PAGE" CREATE INDEX ParentID ON SiteTree (ParentID); can't find table "SITETREE" CREATE INDEX URLSegment ON SiteTree (URLSegment); can't find table "SITETREE" CREATE INDEX ClassName ON SiteTree (ClassName); can't find table "SITETREE" DROP TABLE IF EXISTS SiteTree_EditorGroups CASCADE; DROP SEQUENCE IF EXISTS SEQF674EFBF; CREATE SEQUENCE SEQF674EFBF START WITH 1; CREATE TABLE SiteTree_EditorGroups (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQF674EFBF) NOT NULL, SiteTreeID INTEGER NOT NULL DEFAULT 0, GroupID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); CREATE INDEX SiteTreeID ON SiteTree_EditorGroups (SiteTreeID); CREATE INDEX GroupID ON SiteTree_EditorGroups (GroupID); index GROUPID already exists on table SS_MYSITE.GROUP_MEMBERS DROP TABLE IF EXISTS SiteTree_ImageTracking CASCADE; DROP SEQUENCE IF EXISTS SEQCFDDFCC2; CREATE SEQUENCE SEQCFDDFCC2 START WITH 1; CREATE TABLE SiteTree_ImageTracking (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQCFDDFCC2) NOT NULL, SiteTreeID INTEGER NOT NULL DEFAULT 0, FileID INTEGER NOT NULL DEFAULT 0, FieldName VARCHAR(50), PRIMARY KEY (ID)); CREATE INDEX SiteTreeID ON SiteTree_ImageTracking (SiteTreeID); index SITETREEID already exists on table SS_MYSITE.SITETREE_EDITORGROUPS CREATE INDEX FileID ON SiteTree_ImageTracking (FileID); DROP TABLE IF EXISTS SiteTree_LinkTracking CASCADE; DROP SEQUENCE IF EXISTS SEQ94882A8F; CREATE SEQUENCE SEQ94882A8F START WITH 1; CREATE TABLE SiteTree_LinkTracking (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ94882A8F) NOT NULL, SiteTreeID INTEGER NOT NULL DEFAULT 0, ChildID INTEGER NOT NULL DEFAULT 0, FieldName VARCHAR(50), PRIMARY KEY (ID)); CREATE INDEX SiteTreeID ON SiteTree_LinkTracking (SiteTreeID); index SITETREEID already exists on table SS_MYSITE.SITETREE_EDITORGROUPS CREATE INDEX ChildID ON SiteTree_LinkTracking (ChildID); DROP TABLE IF EXISTS SiteTree_Live CASCADE; DROP SEQUENCE IF EXISTS SEQ1E59FE94; CREATE SEQUENCE SEQ1E59FE94 START WITH 6; CREATE TABLE SiteTree_Live (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ1E59FE94) NOT NULL, ClassName CHAR DEFAULT Page, Created TIMESTAMP, LastEdited TIMESTAMP, URLSegment VARCHAR(255), Title VARCHAR(255), MenuTitle VARCHAR(100), Content CLOB, MetaTitle VARCHAR(255), MetaDescription CLOB, MetaKeywords VARCHAR(255), ExtraMeta CLOB, ShowInMenus BOOLEAN NOT NULL DEFAULT 0, ShowInSearch BOOLEAN NOT NULL DEFAULT 0, Sort INTEGER NOT NULL DEFAULT 0, HasBrokenFile BOOLEAN NOT NULL DEFAULT 0, HasBrokenLink BOOLEAN NOT NULL DEFAULT 0, ReportClass VARCHAR(50), CanViewType CHAR DEFAULT Inherit, CanEditType CHAR DEFAULT Inherit, Version INTEGER NOT NULL DEFAULT 0, ParentID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "PAGE" CREATE INDEX ParentID ON SiteTree_Live (ParentID); can't find table "SITETREE_LIVE" CREATE INDEX URLSegment ON SiteTree_Live (URLSegment); can't find table "SITETREE_LIVE" CREATE INDEX ClassName ON SiteTree_Live (ClassName); can't find table "SITETREE_LIVE" DROP TABLE IF EXISTS SiteTree_ViewerGroups CASCADE; DROP SEQUENCE IF EXISTS SEQE375C8BA; CREATE SEQUENCE SEQE375C8BA START WITH 1; CREATE TABLE SiteTree_ViewerGroups (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQE375C8BA) NOT NULL, SiteTreeID INTEGER NOT NULL DEFAULT 0, GroupID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); CREATE INDEX SiteTreeID ON SiteTree_ViewerGroups (SiteTreeID); index SITETREEID already exists on table SS_MYSITE.SITETREE_EDITORGROUPS CREATE INDEX GroupID ON SiteTree_ViewerGroups (GroupID); index GROUPID already exists on table SS_MYSITE.GROUP_MEMBERS DROP TABLE IF EXISTS SiteTree_versions CASCADE; DROP SEQUENCE IF EXISTS SEQ9B4AE3A5; CREATE SEQUENCE SEQ9B4AE3A5 START WITH 6; CREATE TABLE SiteTree_versions (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ9B4AE3A5) NOT NULL, RecordID INTEGER NOT NULL DEFAULT 0, Version INTEGER NOT NULL DEFAULT 0, WasPublished BOOLEAN NOT NULL DEFAULT 0, AuthorID INTEGER NOT NULL DEFAULT 0, PublisherID INTEGER NOT NULL DEFAULT 0, ClassName CHAR DEFAULT Page, Created TIMESTAMP, LastEdited TIMESTAMP, URLSegment VARCHAR(255), Title VARCHAR(255), MenuTitle VARCHAR(100), Content CLOB, MetaTitle VARCHAR(255), MetaDescription CLOB, MetaKeywords VARCHAR(255), ExtraMeta CLOB, ShowInMenus BOOLEAN NOT NULL DEFAULT 0, ShowInSearch BOOLEAN NOT NULL DEFAULT 0, Sort INTEGER NOT NULL DEFAULT 0, HasBrokenFile BOOLEAN NOT NULL DEFAULT 0, HasBrokenLink BOOLEAN NOT NULL DEFAULT 0, ReportClass VARCHAR(50), CanViewType CHAR DEFAULT Inherit, CanEditType CHAR DEFAULT Inherit, ParentID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); can't resolve field "PAGE" CREATE INDEX RecordID ON SiteTree_versions (RecordID); can't find table "SITETREE_VERSIONS" CREATE INDEX Version ON SiteTree_versions (Version); can't find table "SITETREE_VERSIONS" CREATE INDEX AuthorID ON SiteTree_versions (AuthorID); can't find table "SITETREE_VERSIONS" CREATE INDEX PublisherID ON SiteTree_versions (PublisherID); can't find table "SITETREE_VERSIONS" CREATE INDEX ParentID ON SiteTree_versions (ParentID); can't find table "SITETREE_VERSIONS" CREATE INDEX URLSegment ON SiteTree_versions (URLSegment); can't find table "SITETREE_VERSIONS" CREATE INDEX ClassName ON SiteTree_versions (ClassName); can't find table "SITETREE_VERSIONS" CREATE INDEX RecordID_Version ON SiteTree_versions (RecordID, Version); can't find table "SITETREE_VERSIONS" DROP TABLE IF EXISTS VirtualPage CASCADE; DROP SEQUENCE IF EXISTS SEQ72CD1F60; CREATE SEQUENCE SEQ72CD1F60 START WITH 1; CREATE TABLE VirtualPage (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQ72CD1F60) NOT NULL, VersionID INTEGER NOT NULL DEFAULT 0, CopyContentFromID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); CREATE INDEX CopyContentFromID ON VirtualPage (CopyContentFromID); DROP TABLE IF EXISTS VirtualPage_Live CASCADE; DROP SEQUENCE IF EXISTS SEQB3E3AA09; CREATE SEQUENCE SEQB3E3AA09 START WITH 1; CREATE TABLE VirtualPage_Live (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQB3E3AA09) NOT NULL, VersionID INTEGER NOT NULL DEFAULT 0, CopyContentFromID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); CREATE INDEX CopyContentFromID ON VirtualPage_Live (CopyContentFromID); index COPYCONTENTFROMID already exists on table SS_MYSITE.VIRTUALPAGE DROP TABLE IF EXISTS VirtualPage_versions CASCADE; DROP SEQUENCE IF EXISTS SEQB477CC9A; CREATE SEQUENCE SEQB477CC9A START WITH 1; CREATE TABLE VirtualPage_versions (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(SEQB477CC9A) NOT NULL, RecordID INTEGER NOT NULL DEFAULT 0, Version INTEGER NOT NULL DEFAULT 0, VersionID INTEGER NOT NULL DEFAULT 0, CopyContentFromID INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (ID)); CREATE UNIQUE INDEX RecordID_Version ON VirtualPage_versions (RecordID, Version); index RECORDID_VERSION already exists on table SS_MYSITE.ERRORPAGE_VERSIONS CREATE INDEX RecordID ON VirtualPage_versions (RecordID); index RECORDID already exists on table SS_MYSITE.ERRORPAGE_VERSIONS CREATE INDEX Version ON VirtualPage_versions (Version); index VERSION already exists on table SS_MYSITE.ERRORPAGE_VERSIONS CREATE INDEX CopyContentFromID ON VirtualPage_versions (CopyContentFromID);index COPYCONTENTFROMID already exists on table SS_MYSITE.VIRTUALPAGE ~>

thebithead commented 11 years ago

I don't see a way to attach the database dump file to this issue. Send me an email message if you need a copy.

-tom

tazija commented 11 years ago

Schema generated successfully:

$ bin/nuodb-migration schema --source.driver=com.mysql.jdbc.Driver \ --source.url=jdbc:mysql://localhost:3306/silver-stripe \ --source.username=root --source.password= \ --output.path=/tmp/silver-stripe.sql --identifier.quoting=always