Rainsbrook - rb-projects-access
https://www.rainsbrook.co.uk/wiki/
2026-05-01T01:13:25+00:00Rainsbrook
https://www.rainsbrook.co.uk/wiki/
https://www.rainsbrook.co.uk/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svgtext/html2025-04-25T12:13:38+00:00Anonymous (anonymous@undisclosed.example.com)sqlexamples
https://www.rainsbrook.co.uk/wiki/doku.php?id=rb-projects-access:sqlexamples&rev=1745583218&do=diff
SQL examples
Just useful code snippets, examples not functional code.
Table columns
MariaDB [accesscontrol]> select * from keycards;
+--------+------------+---------------------+---------------------+----------+
| cardID | cardNumber | Created | Deleted | issuedTo |
+--------+------------+---------------------+---------------------+----------+
| 1 | 1234 | 2024-05-07 12:28:20 | 0000-00-00 00:00:00 | 3 |
| 2 | 2345 | 2024-05-07 12:28:32 | 0…text/html2026-04-10T08:54:54+00:00Anonymous (anonymous@undisclosed.example.com)start
https://www.rainsbrook.co.uk/wiki/doku.php?id=rb-projects-access:start&rev=1775811294&do=diff
Access Control
Very much embryonic and alpha project to play with commands which would be required to implement a electronic door lock system.
Key cards with a serial number are issued and each door has a Wiegand or rfid style reader, optionally requiring a PIN as well as card to unlock. Maybe bluetooth instead of PIN?