Forums

http://wip.smspower.org/tests/db/

- Some fields renaming.
- Now the 'game' table contains 'rom_size', 'ram_size' and 'continue' fields, the 'bbram' boolean was removed.

Continue hold weither the game can be continued using PASSWORD or BATTERY SAVE (this same information was also present on some box).

This system allow distinguish embedded RAM (eg: The Flash, Desert Speedtrap, The Castle, etc...) with embedded battery backed RAM (eg: Phantasy Star, Penguin Land).

Storing the password information also seemed interesting.

- I also added a 'rating' field that will be left empty for the moment but in the future could be computed based on user rating (assuming was can setup a rating system and dictate a strict rating policy to obtain good results).

- Added a 'game_name' table which is automatically filled by the building scripts with merged game names.

Author	Message
Bock Site Admin Joined: 08 Jul 2001 Posts: 8649 Location: Paris, France	DB Model 09 Posted: Thu Mar 25, 2004 2:19 pm
	http://wip.smspower.org/tests/db/ - Some fields renaming. - Now the 'game' table contains 'rom_size', 'ram_size' and 'continue' fields, the 'bbram' boolean was removed. Continue hold weither the game can be continued using PASSWORD or BATTERY SAVE (this same information was also present on some box). This system allow distinguish embedded RAM (eg: The Flash, Desert Speedtrap, The Castle, etc...) with embedded battery backed RAM (eg: Phantasy Star, Penguin Land). Storing the password information also seemed interesting. - I also added a 'rating' field that will be left empty for the moment but in the future could be computed based on user rating (assuming was can setup a rating system and dictate a strict rating policy to obtain good results). - Added a 'game_name' table which is automatically filled by the building scripts with merged game names.

Forums

View topic - DB Model 09