Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for db/morbad.sql
|
2020-06-11
| ||
| 03:40 | Added several indexes to the db schema. file: [ed905e6458] check-in: [eba2a3ae72] user: stephan branch: trunk, size: 8433 | |
|
2020-03-20
| ||
| 03:30 | Added FFS (free-form standard-sized) cards, which are identical to FFMs in all but name. file: [d5fad5c9c5] check-in: [7c83ff0ac9] user: stephan branch: trunk, size: 7851 | |
|
2020-03-19
| ||
| 06:02 | Corrected SQL definition of as-yet-unused user_data table. file: [4cd1b7e9b4] check-in: [002d2863e8] user: stephan branch: trunk, size: 7187 | |
| 05:56 | Added user.level and user_data table, for potential new features. file: [00e7393dba] check-in: [7d08e35a31] user: stephan branch: trunk, size: 7170 | |
|
2020-03-15
| ||
| 12:15 | Moved the card log into a separate db file, and attach it on demand, to keep the main db file size/backups from exploding (the log is currently almost 5x the rest of the db size). file: [1e425f0051] check-in: [2ddaa20b2f] user: stephan branch: trunk, size: 6603 | |
|
2020-03-14
| ||
| 18:15 | Only set isGoblinko on outbound cards if it's true, else leave it undefined. Renamed clog.card to clog.json. file: [1e59acfcc3] check-in: [ddb8861e5c] user: stephan branch: trunk, size: 7458 | |
|
2020-03-13
| ||
| 22:50 | Removed NOT NULL language constraint from c_encounter and c_ffm tables and default it to NULL. file: [704b01fe39] check-in: [3f191d7a94] user: stephan branch: trunk, size: 7458 | |
|
2020-03-12
| ||
| 17:56 | Initial FFM CRUD bits are in place. file: [b7140115e7] check-in: [34ce630b15] user: stephan branch: trunk, size: 7481 | |
|
2020-03-05
| ||
| 09:24 | Added clog (card log) table to the schema and now place a copy of each card's JSON there when it is saved or deleted. importCards.s2 now retains card mtimes by default (and corrected lib-level handling of that). Switched from JS regex to POSIX regex for regex-using validation due to numerous regex mismatch bugs found in the upstream regex impl (didn't affect this case, but just to be safe). file: [ad0e764f71] check-in: [8ee67180cf] user: stephan branch: trunk, size: 6480 | |
|
2020-02-17
| ||
| 23:12 | Removed obsolete fields from db schema. Added 'locked' field to all card types for future use (not yet implemented). file: [ff8e493d25] check-in: [46ce560d1b] user: stephan branch: trunk, size: 5624 | |
|
2020-02-15
| ||
| 03:35 | The last(?) of the v2 JSON format changes for skill/weakness/triumph. Encounter cards can wait. file: [fe1e794b2e] check-in: [d125289dd1] user: stephan branch: configurable-text-sizes, size: 5617 | |
|
2020-02-14
| ||
| 16:43 | Minor schema doc touchups. file: [a2c96e39b2] check-in: [ad1812cae9] user: stephan branch: trunk, size: 5571 | |
| 02:25 | Reverted weakness.type and triumph.type to a plain string, as practical layout considerations keep us from making that particular field's font size configurable. file: [624ea99583] check-in: [17152f3948] user: stephan branch: trunk, size: 5419 | |
|
2019-12-27
| ||
| 02:31 | Added more font-size-related db fields to support a potential upcoming TODO (adjustable font sizes for card names, requirements, and type label). file: [566fa7f7ae] check-in: [84b5f270d3] user: stephan branch: trunk, size: 5305 | |
|
2019-12-07
| ||
| 18:17 | Updated morbad user password to use SHA3-256 and a hash secret. Added user.s2 for managing db-side users. file: [229538ca3f] check-in: [b4e30fe4da] user: stephan branch: trunk, size: 5041 | |
|
2019-11-08
| ||
| 17:58 | Changed UNIQUE constraint handlers from ROLLBACK to ABORT because of a mis-interaction with the former discovered in another source tree today. file: [be576e48ac] check-in: [b222ca0f76] user: stephan branch: trunk, size: 4728 | |
|
2019-08-18
| ||
| 23:43 | Started sketching out the c_deck table (part of the Encounter card infrastructure). Changed c_encounter.deck validation to be more restrictive (lower-case CSS-style names w/ alphanumeric and '-' only). file: [1c3da80a93] check-in: [64924f0ba6] user: stephan branch: trunk, size: 4752 | |
|
2019-08-16
| ||
| 09:33 | Removed some unused bits from c_encounter. file: [33ba1c59cc] check-in: [589be06ad9] user: stephan branch: trunk, size: 4024 | |
|
2019-08-14
| ||
| 21:37 | Simplified how Encounter cards are stored - no more separate sector/banner/miscstate fields. file: [75a603bd55] check-in: [b45316decc] user: stephan branch: trunk, size: 4250 | |
| 09:47 | Added miscState pseudo-member to encounter card records. file: [341a21836e] check-in: [3c31643922] user: stephan branch: trunk, size: 4204 | |
|
2019-08-13
| ||
| 02:53 | Corrected dbCardToObj() impl for encounter cards. file: [94c5ed2962] check-in: [cfb22ae007] user: stephan branch: trunk, size: 4108 | |
|
2019-08-12
| ||
| 18:15 | Initial impl. of encounter cards. file: [36d138fea4] check-in: [40e3c686db] user: stephan branch: trunk, size: 4102 | |
|
2019-07-23
| ||
| 20:49 | Implemented basic /admin functionality for logging in/out and deleting individual cards. file: [6574730edb] check-in: [f5ebd3c289] user: stephan branch: trunk, size: 3206 | |
| 13:53 | Added basic infrastructure for potentially supporting multiple languages of cards. file: [8d218343ce] check-in: [51d454e09e] user: stephan branch: trunk, size: 2749 | |
|
2019-07-18
| ||
| 18:47 | Added support for triumph cards but saving is untested so far. file: [b3bd100d65] check-in: [ab9d1e0606] user: stephan branch: trunk, size: 2456 | |
|
2019-07-17
| ||
| 18:16 | Removed now-unused (json) db table from the schema SQL and the scripts which used to import/export to/from that table. file: [4c54a01b21] check-in: [658e6ab59f] user: stephan branch: trunk, size: 2067 | |
| 11:16 | Migrated the schema to something more conventionally databasey, rather than just stuffing the whole JSON object in a single field (which was turning out to be problematic with regards to constraint management). file: [5bf2d7e8bc] check-in: [65b0b16b4c] user: stephan branch: trunk, size: 2634 | |
|
2019-07-16
| ||
| 20:21 | Removed ON REPLACE clause so that users can no longer override cards by name (as opposed to CID). file: [3efbea81ad] check-in: [27d65a42d7] user: stephan branch: trunk, size: 1401 | |
| 19:51 | Added basic support for making cards as "official" so that the AJAX layer can keep users from saving over those. file: [399f9d60ee] check-in: [cb410bf7c8] user: stephan branch: trunk, size: 1400 | |
|
2019-07-14
| ||
| 08:25 | Replaced an object ID which was bugging me. file: [fdc1d50f8a] check-in: [4fde7696ee] user: stephan branch: trunk, size: 3848 | |
| 03:23 | Sigh. file: [c27d247c96] check-in: [9a520bf3cd] user: stephan branch: trunk, size: 3848 | |
| 03:22 | Typo, changed some card IDs. file: [7ae7d18c73] check-in: [8bc3412fc6] user: stephan branch: trunk, size: 3848 | |
| 03:14 | typo fix. file: [ef5ba506b6] check-in: [f78e672d90] user: stephan branch: trunk, size: 3950 | |
| 03:07 | Renamed db field json.jid to json.cid. file: [5d7ffd4f4b] check-in: [b9bf675ee0] user: stephan branch: trunk, size: 3953 | |
|
2019-07-13
| ||
| 19:43 | Implemented saving of skills/weaknesses. file: [864be8f753] check-in: [00cf6c638d] user: stephan branch: trunk, size: 3961 | |
| 09:22 | Got the skill/weakness getters implemented. file: [ecbc606038] check-in: [8438c7ad04] user: stephan branch: trunk, size: 3922 | |
| 06:09 | Added: Initial draft. Can respond to GET /skill?id=x and GET /skills. file: [2b2ddfc01c] check-in: [8e19cf7439] user: stephan branch: trunk, size: 2398 | |