Starting database setup
Checking table: perm_group_to_resource
Checking table: perm_resources
Table (perm_resources) column resource_name have different types(nvarchar(256) != varchar(256))
Table (perm_resources) column resource_description have different types(nvarchar(512) NULL != varchar(512) NULL)
Checking table: perm_roles_to_resource
Checking table: perm_roles
Table (perm_roles) column role_name have different types(nvarchar(256) NULL != varchar(256) NULL)
Table (perm_roles) column starting_page have different types(nvarchar(256) NULL != varchar(256) NULL)
Checking table: perm_user_to_resource
Checking table: perm_user_to_role
Checking table: tbl_Assessment
Table (tbl_Assessment) column SetID have different types(int NULL != int)
Table tbl_Assessment contains more fields than its model.(ValidFrom,ValidTo)
Checking table: tbl_AssessmentHistory
Table tbl_AssessmentHistory contains more fields than its model.(ValidFrom,ValidTo)
Checking table: tbl_AssessmentType
Checking table: tbl_Client
Checking table: tbl_ClientLocations
Checking table: tbl_Company
Checking table: tbl_Contact
Table (tbl_Contact) column CompanyID have different types(int NULL != int)
Checking table: tbl_ContactGroups
Checking table: tbl_ContactInGroup
Checking table: tbl_Location
Checking table: tbl_Operant
Checking table: tbl_Quiz
Checking table: tbl_Report
Table (tbl_Report) column SetID have different types(int != int NULL)
Checking table: tbl_ReportDocument
Checking table: tbl_ReportGroup
Checking table: tbl_SetQuestions
Checking table: tbl_Sets
Checking table: tbl_Subscription
Adding constraints...
Constraint errorSQLSTATE[HY000]: General error: 20018 Could not drop constraint. See previous errors. [20018] (severity 16) [ALTER TABLE tbl_AssessmentHistory DROP CONSTRAINT FK_SetID]
Constraint errorSQLSTATE[HY000]: General error: 20018 Could not create constraint or index. See previous errors. [20018] (severity 16) [ALTER TABLE tbl_AssessmentHistory ADD CONSTRAINT FK_SetID FOREIGN KEY (SetID) REFERENCES tbl_Sets(SetID)]
Constraint errorSQLSTATE[HY000]: General error: 20018 Could not drop constraint. See previous errors. [20018] (severity 16) [ALTER TABLE tbl_ContactInGroup DROP CONSTRAINT FK_ContactID]
Constraint errorSQLSTATE[HY000]: General error: 20018 Could not create constraint or index. See previous errors. [20018] (severity 16) [ALTER TABLE tbl_ContactInGroup ADD CONSTRAINT FK_ContactID FOREIGN KEY (ContactID) REFERENCES tbl_Contact(ContactID)]
Constraint errorSQLSTATE[HY000]: General error: 20018 Could not drop constraint. See previous errors. [20018] (severity 16) [ALTER TABLE tbl_ReportDocument DROP CONSTRAINT FK_ClientID]
Constraint errorSQLSTATE[HY000]: General error: 20018 Could not create constraint or index. See previous errors. [20018] (severity 16) [ALTER TABLE tbl_ReportDocument ADD CONSTRAINT FK_ClientID FOREIGN KEY (ClientID) REFERENCES tbl_Client(ClientID)]
Constraint errorSQLSTATE[HY000]: General error: 20018 Could not drop constraint. See previous errors. [20018] (severity 16) [ALTER TABLE tbl_ReportGroup DROP CONSTRAINT FK_ClientID]
Constraint errorSQLSTATE[HY000]: General error: 20018 Could not create constraint or index. See previous errors. [20018] (severity 16) [ALTER TABLE tbl_ReportGroup ADD CONSTRAINT FK_ClientID FOREIGN KEY (ClientID) REFERENCES tbl_Client(ClientID)]
Constraint errorSQLSTATE[HY000]: General error: 20018 Could not drop constraint. See previous errors. [20018] (severity 16) [ALTER TABLE tbl_SetQuestions DROP CONSTRAINT FK_SetID]
Constraint errorSQLSTATE[HY000]: General error: 20018 Could not create constraint or index. See previous errors. [20018] (severity 16) [ALTER TABLE tbl_SetQuestions ADD CONSTRAINT FK_SetID FOREIGN KEY (SetID) REFERENCES tbl_Sets(SetID)]
Constraint errorSQLSTATE[HY000]: General error: 20018 Could not drop constraint. See previous errors. [20018] (severity 16) [ALTER TABLE tbl_Subscription DROP CONSTRAINT FK_CompanyID]
Constraint errorSQLSTATE[HY000]: General error: 20018 Could not create constraint or index. See previous errors. [20018] (severity 16) [ALTER TABLE tbl_Subscription ADD CONSTRAINT FK_CompanyID FOREIGN KEY (CompanyID) REFERENCES tbl_Company(CompanyID)]
Constraint errorSQLSTATE[HY000]: General error: 20018 Cannot find the object "tbl_Contacts" because it does not exist or you do not have permissions. [20018] (severity 16) [ALTER TABLE tbl_Contacts DROP CONSTRAINT FK_UserID]
Constraint errorSQLSTATE[HY000]: General error: 20018 Cannot find the object "tbl_Contacts" because it does not exist or you do not have permissions. [20018] (severity 16) [ALTER TABLE tbl_Contacts ADD CONSTRAINT FK_UserID FOREIGN KEY (UserID) REFERENCES oauth_users(user_id)]
Setup done
Total Execution Time: 0.23630905151367 Sec