Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for db/cide.sql
|
2019-12-07
| ||
| 17:48 | Updated cide user password to use SHA3-256 and a hash secret. Added user.s2 for managing db-side users. file: [ac44ddb3d4] check-in: [bf7fa46f35] user: stephan branch: trunk, size: 2974 | |
|
2019-11-27
| ||
| 13:56 | Renamed db table c_zability to card1, as its scope now encompasses what is informally known as "card type 1." file: [e1469ff251] check-in: [f2edb9a84b] user: stephan branch: trunk, size: 2741 | |
|
2019-11-25
| ||
| 11:02 | Minor schema change in the auth_token table. file: [c78d9bd593] check-in: [628e38b322] user: stephan branch: trunk, size: 2993 | |
|
2019-11-17
| ||
| 12:54 | Added COLLATE NOCASE to c_zability.deck, for consistency with the deck table (and because that just bit me). file: [68126c8ba1] check-in: [e8e8fcd9f0] user: stephan branch: trunk, size: 2912 | |
|
2019-11-13
| ||
| 22:12 | Made deck.uid COLLATE NOCASE to help avoid any accidental dupes. file: [3d5cb61f39] check-in: [c6dd497064] user: stephan branch: trunk, size: 2897 | |
|
2019-11-12
| ||
| 19:53 | Removed deck.abbr, as the distinction between deck.abbr and deck.uid is causing too much Grief in downstream code. file: [ed9b0e3268] check-in: [5d017f09ae] user: stephan branch: trunk, size: 2882 | |
| 18:02 | Schema: set deck.uid=deck.abbr for the time being. We'll likely do away with abbr and use uid, as the discrepancy is causing notable Grief downstream. file: [33438b4557] check-in: [bc5ebe96eb] user: stephan branch: trunk, size: 2948 | |
|
2019-11-11
| ||
| 06:17 | Fixed assignment of uid on new cards which include their own. Added Scratchpad deck. file: [20cc26fe92] check-in: [e0c22efa5b] user: stephan branch: trunk, size: 2714 | |
|
2019-11-10
| ||
| 07:51 | /card and /deck APIs now accept UID values as well as their prior inputs. Minor schema tweaks. Added a script to set c_zability.h_fontsize values because the editor app cannot currently properly detect is-modified if they are calculated client-side :/. file: [194a5c6414] check-in: [486620dd93] user: stephan branch: trunk, size: 2665 | |
|
2019-11-09
| ||
| 11:42 | Added an UPDATE/DELETE cascade. file: [a8d7e06621] check-in: [4aa2439742] user: stephan branch: trunk, size: 2665 | |
| 10:46 | Changed main db tables to WITHOUT ROWID. Because we can. Seems to work. file: [b1a48464d8] check-in: [2bd6aac1fb] user: stephan branch: trunk, size: 2629 | |
| 10:06 | Renamed c_deck to deck. Added c_zability.uid/deck.uid field to allow us to gracefully handle the case of renaming a card or assigning it to a new deck. file: [d452838cec] check-in: [1f02477193] user: stephan branch: trunk, size: 2767 | |
|
2019-11-08
| ||
| 22:42 | Added initial HTTP request dispatching bits. Fetch of cards/decks works, but interface is subject to change. Saving is implemented but untested (so probably doesn't work). file: [4d9ad89ca1] check-in: [85525c2a14] user: stephan branch: trunk, size: 2641 | |
| 20:55 | Added deck-saving support. file: [d04181e261] check-in: [4e6af81c91] user: stephan branch: trunk, size: 2625 | |
| 18:33 | Added initial save support. file: [bc0ad219e7] check-in: [714ac6ee02] user: stephan branch: trunk, size: 2225 | |
| 15:53 | Added: Initial work on cide-zability back-end CGI library. Loading works, normalization/saving is pending. file: [7f19fd5bb0] check-in: [b197ee7d49] user: stephan branch: trunk, size: 2140 | |