Steam Music Database: Revision history

Jump to: navigation, search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

13 July 2023

  • curprev 18:2518:25, 13 July 2023Flurry talk contribs 2,444 bytes +2,444 Created page with "{{WIP|Literally any information other than the SQL schema}} Found in <code>$STEAM_HOME/music/_database/musicdatabase_XXXX.db</code>. Not sure what determines the <code>XXXX</code> yet, but mine is <code>0016</code>. <syntaxhighlight lang="sql"> CREATE TABLE localartist ( artistid INTEGER PRIMARY KEY, artistname TEXT, artistsortname TEXT, artistinsertname TEXT ); CREATE INDEX artistid_index ON localartist ( artistid ); CREATE INDEX artistname_index ON lo..."