4 Commits

Author SHA1 Message Date
FabianK3 6c4e9254b2 Add ashtray persistence & fixes (#21925)
# Summary

This PR adds persistency to ash trays. This in turn fixes cigarettes
butts spawning a round later in locations where non-empty ash trays were
found.

## Changes

- Add persistence to ash trays and prevent (fixes) cigarette butt
persistence if in an ash tray.
- Fixed cigarette butts not being persistent if the cigarette was put
out on purpose and landing on the floor.
- Fixed loss of registered persistence track on item pickup.
- Fixed persistent tracks when item is held by player.
- Removed all ash trays on the Horizon as their existence is now
persistent. One-time job for operations after merge.
- Fixed matter configuration on `/obj/item/material` not being set
during `set_material()`.
- Fixed persistent trash on space turfs.
- Minor adjustments in SQL/Readme.md.

---------

Signed-off-by: FabianK3 <21039694+FabianK3@users.noreply.github.com>
Co-authored-by: VMSolidus <evilexecutive@gmail.com>
2026-03-17 13:12:57 +00:00
FabianK3 31c66983d6 Overhaul SQL Readme (#21920)
# Summary

This PR updates the README for the SQL development. Formatting was
adjusted to GH/MD standards, MySQL references have been removed and
MariaDB set as the default database.

A docker example has been added and additionally the attribution was
removed as it is outdated to the document.

Preview with markdown formatting:
https://github.com/FabianK3/Aurora.3/blob/caae1de818a5568863474a50f35108f747f5b158/SQL/README.md

## Changes

- Update SQL Readme

No changes have been added that require a changelog.
2026-03-01 06:41:28 +00:00
Werner a69a7316ab Condense Database Migrations (#17103)
* Condense Database Migrations

Condenses the Database Migrations into a new initial schema.
Also adds some instructions to the Database Readme for existing setups.

* Update readme/delete changed migrations since pr creation

* Reworks a bit how the previous migrations are handled and updates the instructions accordingly

* Expand the readme with baseline/migrate

---------

Co-authored-by: Werner <Arrow768@users.noreply.github.com>
2023-08-19 22:32:13 +02:00
skull132 b1b4ce00a8 Implement SQL migrations with Flyway (#1661)
Has a readme and everything.

Tables to be dropped with this:

ss13_customitems
ss13_bot_cache
ss13_feedback_archive
ss13_news
ss13_stats_ie
2017-01-29 21:14:58 +02:00