SkyWin download library
Installation packages
| Language | Package | Description |
|---|---|---|
 |
SkyWin_EN_install_2031 | Full installation of SkyWin® (English) version 20.3.1 — for Windows |
 |
SkyWin_SE_install_2031 | Full installation of SkyWin® (Swedish) version 20.3.1 — for Windows |
| All | skywin.war
(ver 20.2.0.202005240330) |
Web services (the API) for SkyWin®, a.k.a. SkyWin One. This component also includes some user interfaces that will be extended over time.
Installation instructions for SkyWin One. |
Database upgrade files
The files below are for advanced users connecting to an ADO database
| Database manager | File | Description |
|---|---|---|
MySQL |
MySQL.Update2020.sql | Execute before upgrade to SkyWin® 20.2.0 or later |
SQLServer |
SQLServer.Update2020.sql | Execute before upgrade to SkyWin® 20.2.0 or later |
| MySQL |
MySQL.Update1820.sql | Execute before upgrade to SkyWin® 18.2.0 or later |
| SQLServer |
SQLServer.Update1820.sql | Execute before upgrade to SkyWin® 18.2.0 or later |
| MySQL |
MySQL.Update1810.sql | Execute before upgrade to SkyWin® 18.1.0 or later |
| SQLServer |
SQLServer.Update1810.sql | Execute before upgrade to SkyWin® 18.1.0 or later |
| MySQL |
MySQL.Update1740.sql | Execute before upgrade to SkyWin® 17.4.0 or later |
| SQLServer |
SQLServer.Update1740.sql | Execute before upgrade to SkyWin® 17.4.0 or later |
| MySQL |
MySQL.Update1711.sql | Execute before upgrade to SkyWin® 17.1.1 or later |
| SQLServer |
SQLServer.Update1711.sql | Execute before upgrade to SkyWin® 17.1.1 or later |
Database scripts
The files below are for advanced users connecting to an ADO database
| Database manager | File | Description |
|---|---|---|
| MySQL |
MySQL.191.rename_all_tables | Rename all tables from lower case ("intdbinfo") to correct cases ("intDbinfo"), is required after restore and if your database manager has case sensistivity set. |
| MySQL |
UpdateToMemberTypePAX | Update relevant members to member type PAX |
| MySQL |
InsertAFFTandemJump | Insert a new jump for AFF student plan, as the first jump in the plan. Also updates old jumps by adding 1 to the sequence number. |
Database installation files
The files below are for advanced users connecting to an ADO database
| Database manager | File | Description |
|---|---|---|
| MySQL |
MySQL.ddl.create_database.sql | Create an empty SkyWin® database |
| MySQL |
MySQL.203.ddl.table_create.sql | Create all tables in a SkyWin® database |
| MySQL |
MySQL.203.ddl.fk_create.sql | Create all relations in a SkyWin® database |
| MySQL |
MySQL.203.EN.isrt_init.sql |
Initial insert (English) |
| MySQL |
MySQL.203.SE.isrt_init.sql |
Initial insert (Swedish) |
| SQLServer |
SQLServer.ddl.create_database.sql | Create an empty SkyWin® database |
| SQLServer |
SQLServer.203.ddl.table_create.sql | Create all tables in a SkyWin® database |
| SQLServer |
SQLServer.203.ddl.fk_create.sql | Create all relations in a SkyWin® database |
| SQLServer |
SQLServer.203.EN.isrt_init.sql
|
Initial insert (English) |
| SQLServer |
SQLServer.203.SE.isrt_init.sql
|
Initial insert (Swedish) |
