happypenguin.com 2013 data dump for SQLite3: Artifact [ab40a200dd]

Artifact ab40a200ddf1f0b57d2b0423fdcdc8a0997ee1a3:

Wiki page [happypenguin.com 2013 data dump for SQLite3] by dbohdan 2015-02-10 19:19:01.

D 2015-02-10T19:19:01.916
L happypenguin.com\s2013\sdata\sdump\sfor\sSQLite3
P 2eb1ce73b7e4e3fbd1c266ee9d52e67c8cb057fc
U dbohdan
W 1060
This is the database content from the [https://archive.org/details/happypenguin_xml_dump_2013|The Linux Dome Game Tome (happypenguin.com) 2013 data dump] converted from the MySQL SQL dump format to the respective format for SQLite3.

<h2>How to use</h2>

The data for each table is stored in its own separate <tt>.sql</tt> file. The name of the table matches the filename. Note that each SQL file contains instructions to drop and recreate the matching table first.

To create an SQLite3 database file containing the data from all five tables run <tt>import.sh</tt>. You will need the command line interface for SQLite version 3 installed (<tt>sqlite3</tt>). The database file will be named <tt>hp.sqlite3db</tt>.

<h2>Download</h2>

Download the latest version as a <a href="https://chiselapp.com/user/dbohdan/repository/happypenguin_dump/tarball/happypenguin_dump_sqlite3-latest.tar.gz?uuid=tip">tarball</a> or <a href="https://chiselapp.com/user/dbohdan/repository/happypenguin_dump/zip/happypenguin_dump_sqlite3-latest.zip?uuid=tip">ZIP file</a>.
Z c0c4c7219dd9c398b3019498818dc438