alter table n2Item  drop foreign key FK18406FA09B59280D
alter table n2Item  drop foreign key FK18406FA0BAB0B0D0
alter table n2Detail  drop foreign key FK1D14F83B7ECFB400
alter table n2Detail  drop foreign key FK1D14F83B4F20C9A5
alter table n2Detail  drop foreign key FK1D14F83B2E687F77
alter table n2DetailCollection  drop foreign key FKBE85C49A2E687F77
alter table n2AllowedRole  drop foreign key FKB30F0672E687F77
drop table if exists n2Item
drop table if exists n2Detail
drop table if exists n2DetailCollection
drop table if exists n2AllowedRole
create table n2Item (
  ID INTEGER NOT NULL AUTO_INCREMENT,
   Type VARCHAR(255) not null,
   Updated DATETIME not null,
   Name VARCHAR(255),
   ZoneName VARCHAR(50),
   Title VARCHAR(255),
   Created DATETIME not null,
   Published DATETIME not null,
   Expires DATETIME,
   SortOrder INTEGER not null,
   Visible TINYINT(1) not null,
   SavedBy VARCHAR(50),
   VersionOfID INTEGER,
   ParentID INTEGER,
   primary key (ID)
)
create table n2Detail (
  ID INTEGER NOT NULL AUTO_INCREMENT,
   Type VARCHAR(255) not null,
   ItemID INTEGER not null,
   DetailCollectionID INTEGER,
   Name VARCHAR(50),
   BoolValue TINYINT(1),
   IntValue INTEGER,
   LinkValue INTEGER,
   DoubleValue DOUBLE,
   DateTimeValue DATETIME,
   StringValue LONGTEXT,
   Value LONGBLOB,
   primary key (ID)
)
create table n2DetailCollection (
  ID INTEGER NOT NULL AUTO_INCREMENT,
   ItemID INTEGER,
   Name VARCHAR(50) not null,
   primary key (ID)
)
create table n2AllowedRole (
  ID INTEGER NOT NULL AUTO_INCREMENT,
   ItemID INTEGER not null,
   Role VARCHAR(50) not null,
   primary key (ID)
)
alter table n2Item  add index (ParentID), add constraint FK18406FA09B59280D foreign key (ParentID) references n2Item (ID) 
alter table n2Item  add index (VersionOfID), add constraint FK18406FA0BAB0B0D0 foreign key (VersionOfID) references n2Item (ID) 
alter table n2Detail  add index (LinkValue), add constraint FK1D14F83B7ECFB400 foreign key (LinkValue) references n2Item (ID) 
alter table n2Detail  add index (DetailCollectionID), add constraint FK1D14F83B4F20C9A5 foreign key (DetailCollectionID) references n2DetailCollection (ID) 
alter table n2Detail  add index (ItemID), add constraint FK1D14F83B2E687F77 foreign key (ItemID) references n2Item (ID) 
alter table n2DetailCollection  add index (ItemID), add constraint FKBE85C49A2E687F77 foreign key (ItemID) references n2Item (ID) 
alter table n2AllowedRole  add index (ItemID), add constraint FKB30F0672E687F77 foreign key (ItemID) references n2Item (ID)