This repository has been archived on 2025-01-04. You can view files and clone it, but cannot push or open issues or pull requests.
lwb6/legacyworlds-server-data/db-structure/parts/040-functions
Emmanuel BENOîT d246f221f0 Event database access
Added tables that store event access interfaces and event states per
interface, as well as functions which allow events to be retrieved:
 * events.interfaces lists access interfaces,
 * events.unprocessed_events lists events which haven't been processed
for each type of interface, with a "pre-processed" flag
 * events.ep_read() is a set of function variants which will read events
 * events.ep_access() is a set of function variants which read events
then update their states.
2012-07-03 10:32:15 +02:00
..
000-defs.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
002-sys.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
003-updates.sql Game updates improvements 2012-02-03 16:25:03 +01:00
005-logs.sql SQL logging fixes 2012-01-07 11:14:17 +01:00
010-constants.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
020-naming.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
025-resources.sql In-game resources views 2012-02-04 10:43:12 +01:00
026-technology-dependencies.sql Technology dependencies view 2012-02-29 11:50:04 +01:00
030-tech.sql Renamed technology tables and views 2012-04-09 15:01:04 +02:00
035-users.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
040-empire.sql Renamed technology tables and views 2012-04-09 15:01:04 +02:00
043-computation.sql Research update 2012-04-02 13:29:43 +02:00
045-empire-research.sql Renamed technology tables and views 2012-04-09 15:01:04 +02:00
053-generator-basics.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
055-generator-resources.sql SQL logging fixes 2012-01-07 11:14:17 +01:00
060-universe.sql Game updates improvements 2012-02-03 16:25:03 +01:00
070-users.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
075-session.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
080-buildings.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
100-status.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
110-prefs.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
120-map.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
140-planets.sql Renamed technology tables and views 2012-04-09 15:01:04 +02:00
145-resource-providers.sql Extracted quantities update as soon as possible 2012-02-09 10:54:00 +01:00
147-empire-mining.sql Extracted quantities update as soon as possible 2012-02-09 10:54:00 +01:00
150-battle.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
160-battle-views.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
163-alliance.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
165-fleets.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
167-planet-list.sql Resources information on planet list 2012-02-15 14:45:43 +01:00
170-event-definitions.sql Events storage procedure 2012-07-01 14:12:22 +02:00
170-events.sql Event-related functions split 2012-07-01 01:04:26 +02:00
171-event-priorities.sql Event-related functions split 2012-07-01 01:04:26 +02:00
172-event-storage.sql Events storage procedure 2012-07-01 14:12:22 +02:00
173-event-access.sql Event database access 2012-07-03 10:32:15 +02:00
180-messages.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
190-admin.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00
200-bugs.sql Renamed technology tables and views 2012-04-09 15:01:04 +02:00
210-admin-overview.sql Database definition & tests organisation 2012-01-06 11:19:19 +01:00