Hoard: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==About== All the things I need to track tie together in various ways. This is the database that ties them together. It also has a number of ''ad hoc'' uses. ==Schemae== ===Extern=== This tracks external data repositories. <syntaxhighlight lang=SQL> CREATE TABLE `extern` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `WhenNew` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'when this record was added', `SID_Type` varchar(255) DEFAULT NULL C...") |
(No difference)
|
Revision as of 13:51, 5 July 2024
About
All the things I need to track tie together in various ways. This is the database that ties them together. It also has a number of ad hoc uses.
Schemae
Extern
This tracks external data repositories.
CREATE TABLE
`extern` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`WhenNew` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'when this record was added',
`SID_Type` varchar(255) DEFAULT NULL COMMENT 'slug for thing-type (matches coded external data)',
`Name` varchar(255) DEFAULT NULL COMMENT 'single line for lists',
PRIMARY KEY (`ID`)
) ENGINE = InnoDB