sql server database setup
Hi,
Question1
The source code was downloaded from : https://github.com/jogetworkflow/jw-community.git (Tried 3.1 & 4.0)
The DB was created using sql downloaded from: http://dev.joget.org/community/download/attachments/5341200/jwdb-mssql.sql?version=4&modificationDate=1359988440000&api=v2
Below errors where thrown when sql script from above mention link are executed, Could you please advise these errors.
Msg 2716, Level 16, State 1, Line 1
Column, parameter, or variable #4: Cannot specify a column width on data type text.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FK7A835713462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK7A835713462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FKE411D54E462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FKE411D54E462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FK5E9247A6462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK5E9247A6462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FK740A62EC462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK740A62EC462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FK45957822462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK45957822462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FKEE346FE9462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FKEE346FE9462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 1
Foreign key 'FK852EA428462EF4C7' references invalid table 'app_app'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK852EA428462EF4C7' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.