ACE World 16PY Base v0.7.7

ACE World 16PY Base v0.7.7

The following commit is included in this release:

Change the way triggers are added to World Database (#50)

* Change the way triggers are added to World Database

This sets up the export to use the correct definer user for triggers

• Update WorldTriggers.sql

  automated database build - 2019-03-07T05:38:05Z

ACE World 16PY Base v0.7.6

ACE World 16PY Base v0.7.6

The following commit is included in this release:

Create 2019-03-06-00-Add_Triggers_To_LandblockInstance.sql (#49)

Do not allow guids to exist outside of static range for the landblock_instances table

Co-authored-by: Mag-nus Mag-nus@users.noreply.github.com

automated database build - 2019-03-06T18:07:44Z

ACE World 16PY Base v0.7.5

ACE World 16PY Base v0.7.5

The following commit is included in this release:

Add Deletes to Scripts (#47)

* Add Deletes to Scripts

This is useful mainly for C&P editing

• fix incorrect column

  automated database build - 2019-02-11T03:55:44Z

ACE World 16PY Base v0.7.4

ACE World 16PY Base v0.7.4

The following commit is included in this release:

Update World Export Using Latest Export Tool (#45)

* Rounding changed due to AnyCPU ?

• Found 186 new weenies

mostly template or unfinished stuff but should be included for completion

• Changes to Tables

• Remove FKs to several tables
• Add Last Modified column with auto generating timestamps if one is not provided to base tables

• Delete 2019-02-02-03-Add_LastModified_To_Tables.sql

• delete other scripts

• Create 2019-02-02-03-Add_LastModified_To_Tables.sql

• Create 2019-02-02-00-Drop_FK_On_Landblock_Instance.sql

• Create 2019-02-02-01-Drop_FK_On_POI.sql

• Create 2019-02-02-02-Drop_FK_On_Landblock_Instance_Links.sql

• Update 2019-02-02-02-Drop_FK_On_Landblock_Instance_Links.sql

• Update 2019-02-02-02-Drop_FK_On_Landblock_Instance_Links.sql

• Update 2019-02-02-02-Drop_FK_On_Landblock_Instance_Links.sql

• Update 2019-02-02-02-Drop_FK_On_Landblock_Instance_Links.sql

• Update 2019-02-02-02-Drop_FK_On_Landblock_Instance_Links.sql

• Update 2019-02-02-02-Drop_FK_On_Landblock_Instance_Links.sql

• Rename file

• Added date to base data

Data seems to be around 2/9/05 so blanket applying that date as our base

• Sort Housing a bit

  automated database build - 2019-02-04T03:58:47Z

ACE World 16PY Base v0.7.3

ACE World 16PY Base v0.7.3

The following commit is included in this release:

Updated comments (#44)

* Updating Comments

• Taking a guess on CombatTactic

Thinking it is a shard enum between Targeting, HomesickTargeting and Combat Tactic properties

• Update ArmorType comments

  automated database build - 2019-01-27T01:19:30Z

ACE World 16PY Base v0.7.2

ACE World 16PY Base v0.7.2

The following commit is included in this release:

Add DotDuration to Spell table (#43)

* Add DotDuration to Spell Table, Remove PortalLifetime

• Rename script

• Update 2019-01-20-00-Spell_Table_DotDuration_Add.sql

  automated database build - 2019-01-21T03:34:26Z

ACE World 16PY Base v0.7.1

ACE World 16PY Base v0.7.1

The following commit is included in this release:

Remove Spell Duplicated Data (#42)

* Remove Duplicated Data

Removed data is already present in DAT files

• Remove portal_Lifetime

also found in DAT files

• Update Export for Recipes

• Update Spell Comments

• Update Comments

• Update more comments

• Update CreateList and Generator comments

• Update Emote.Display to be a bool

  automated database build - 2019-01-20T00:23:09Z

ACE World 16PY Base v0.7.0

ACE World 16PY Base v0.7.0

The following commit is included in this release:

Update compile.bat

automated database build - 2018-12-11T17:42:39Z

16PY v0.0.24

16PY v0.0.24

The following commit is included in this release:

Add Town Network (#39)

* Add Town Network

Backporting Town Network to 16PY

• Update POIs and TownNetwork

• Renumber TN patch

• Reorder POI and TN script

• Update 003-InitialPOIs.sql

  automated database build - 2018-12-07T18:49:53Z

16PY v0.0.23

16PY v0.0.23

The following commit is included in this release:

Correct RestrictionEffect (#38)

Off by one, due to post 16PY enum shift of PhysicsScript

automated database build - 2018-11-12T18:44:15Z