Game Database Schema - Revision history

Tschak909 at 20:29, 4 June 2017

2017-06-04T20:29:43Z

@@ Line 24: / Line 24: @@
      Description VARCHAR(128),
      Define VARCHAR(128),
-     PRIMARY KEY(Attribute)
+     PRIMARY KEY(PK_Attribute)
 );
 </pre>

Tschak909 at 20:20, 4 June 2017

2017-06-04T20:20:14Z

←Older revision		Revision as of 20:20, 4 June 2017
Line 14:		Line 14:

	The Database is comprised of the following tables:		The Database is comprised of the following tables:

			=== Attribute ===

			This stores the type of attributes to keep for media metadata.

			<pre>
			CREATE TABLE Attribute (
			PK_Attribute INTEGER AUTO_INCREMENT NOT NULL,
			Description VARCHAR(128),
			Define VARCHAR(128),
			PRIMARY KEY(Attribute)
			);
			</pre>

	=== File ===		=== File ===
Line 23:		Line 36:
	PK_File INTEGER AUTO_INCREMENT NOT NULL,		PK_File INTEGER AUTO_INCREMENT NOT NULL,
	Description VARCHAR(1024),		Description VARCHAR(1024),
	SHA1_Hash CHAR(40)		SHA1_Hash UNIQUE CHAR(40),
			PRIMARY_KEY(PK_File),
			KEY(SHA1_Hash)
	);		);
	</pre>		</pre>

Tschak909: /* GameSystem */

2017-06-04T05:11:15Z

GameSystem

←Older revision		Revision as of 05:11, 4 June 2017
Line 28:		Line 28:

	=== GameSystem ===		=== GameSystem ===

			A Game System is a particular system that can play a given game. Examples, Arcade, Atari 2600, NES, Sega Master System, etc.

			<pre>
			CREATE TABLE GameSystem (
			PK_GameSystem INTEGER AUTO_INCREMENT NOT NULL,
			Description VARCHAR(128),
			PRIMARY KEY(PK_GameSystem)
			);
			</pre>

Tschak909: Initial content.

2017-06-04T03:55:12Z

Initial content.

New page

This is the proposed schema for the lmce_game database. As the first version was used as is between the first two Game Player versions, the new version of the schema will be called v2.

As was before, this database is used to reconcile the possible metadata for game media found on a LinuxMCE system.

== Goals ==

The goals with this particular database schema are:

* Deal with the differences between "Software List" based collections that are baked collections for a given emulator (e.g. MAME soft list), and loose ROMs.
* Try to consolidate media metadata to cleaned sanitized titles utilizing hashes made from normalized strings
* Consolidate and Handle multiple game systems

== Tables ==

The Database is comprised of the following tables:

=== File ===

This table is the entry point for a file, usually a ROM.

<pre>
CREATE TABLE File (
PK_File INTEGER AUTO_INCREMENT NOT NULL,
Description VARCHAR(1024),
SHA1_Hash CHAR(40)
);
</pre>

=== GameSystem ===