cheat database design - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

cheat database design

Author

Topic

emcp
Starting Member

2 Posts

Posted - 2008-06-21 : 13:20:08

hi im new to sql and so im sorry if this is a stupid question

im looking to create a cheat database,(dont worry it wont be another useless cheat website, i have something up my sleeve)

what is required is
Disc Name
Disc ID -- (there will be multiple of these for each Disc Name)

Cheat Name
Cheat Description
Cheat Code

Walkthrough Name
Walkthrough Description
Walkthrough Link

it is a bit fuzzy and im having trouble describing it but this is what i was thinking

have a database called CheatProject
a table called Users (where user account are held)

a table called Games
--KEY, Game Name, Game Disc 1, Game disc 2

a table called Cheats
--KEY, Cheat Name 1, Cheats Description 1, Cheat Code 1, Cheat Name 2, Cheats Description 2, Cheat Code 2

a table called Walkthrough
--KEY, Walkthrough Name 1, Walkthrough Description 1, Walkthrough Link 1, Walkthrough Name 2, Walkthrough Description 2, Cheat Link 2

would this work,
also you can create more columns in php script, if required

sorry for being a noob, at this

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-21 : 14:01:07

Any special reason why you are planning to have CheatName1,CheatName2 .. fields horizontally rather than just having CheatName as a single field and may be giving another field to designate what order/sequence it is in like 1,2,3...

emcp
Starting Member

2 Posts

Posted - 2008-06-21 : 14:53:59

quote:
Originally posted by visakh16

Any special reason why you are planning to have CheatName1,CheatName2 .. fields horizontally rather than just having CheatName as a single field and may be giving another field to designate what order/sequence it is in like 1,2,3...

there will be several cheats for every game id
so the game id would refer to a record and the fields would have the cheatnames

im not sure what your asking, the cheats woud be recorded like so

ill send the game id to the php script, which will lookup the sql database, first of all the game id
if the game id isnt found then ill look for the game name, and insert the new game id into the record
then get the key of the record and look in the cheat table for a the matching key, and echo that data back

it will then be parsed by a system

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources