logo.jpg

Formats

See also loaders.

Database format

Main table

id               int                       ID of game
uniq_id          int                       Uniq ID across c64 sites
same             int                       Number that bind together same game, but different loader,
                                           format, publisher
cover_title      varchar(255)              Title on the cover/inlay. This is the title displayed
                                           as title
label_title      varchar(255)              Title on cassette/cassette label
game_title       varchar(255)              Title when game completely loaded
genre            indexes genre 
create_date      date                      When record was first created
update_date      date                      When record was last updated
languages        bigint                    Bitfield of languages
compilation      index compilation         If game part of compilation
scanned_by       index preservers          Who did the scanning
screenshots_by   index preservers          Who did the screenshots
owned_by         indexes preservers        Who own this game
developer_names  indexes people_companies
publisher_name   index people_companies
publisher_year   index year                The year THIS particular game was IN the STORES
coded_by         indexes people_companies
music_by         indexes people_companies
gfx_by           indexes people_companies
others_by        indexes people_companies  All other people involved (designer, producer, manual
                                           writer, cover designer
other_info       blob                      Lots of info (can also be info about owners of this game)
filename         varchar(255)              path+filename of game
raw              varchar(255)              path+filename of raw dump(s)
sid              varchar(255)              path+filename of sid(s)
docs             varchar(255)              path+filename of docs
box_format       index box                 what kind of box is game contained in
barcode          varchar(255)              barcode number on packaging
tape_num_tapes   byte                      Number of tapes
tape_num_sides   byte                      Number of tape sides
tape_multiload   int                       Number of parts
tape_modified    index yesno               Manually modified?
tape_loader      index loader              Loader used
tape_notes       blob                      Lots of info (report from FT and other)
tape_cbmrcrc32   varchar(9)                CRC32 of CBM ROM block
clean_software   index clean               What software and version was used to clean tap(s)
magic_crc32      varchar(64)               CRC32 of entire TAP (1 line for each TAP)

btw: pictures does not have a field in the db. They are called id_[l|s|g|o]_num.
[l|s|g|o] = l - loader, s - start, g - game, o - other. num = number of picture.
Example: 163_l_1 = the first loader picture of game no. 163.

Same thing for scans. They are called id_[f|if|ib|tf|tb|box]_num
[f|if|ib|tf|tb|df|db|cf|cb|box]
f = front of cassette cover or box
if = inlay front
ib = inlay back
tf = cassette front
tb = cassette back
box = scan of all sides of a box

Remember that games part of a compilation will use the compilation scans.

Other tables

languages
  id
  name       varchar(32)               Name of country
  short      varchar(2)                Short version of name (en = england, de = germany, no = norway)

loader
  id
  name        varchar(48)              Loader name
  threshold   varchar(4)               Threshold (TAP byte) $xx
  threshold2  varchar(5)               Threshold (Clock cyles) $xxxx
  endianess   index endianess          MSbF or LSbF
  pilot       varchar(255)             Pilot
  sync        varchar(255)             Sync
  bit0_pulse  varchar(4)               $xx
  bit1_pulse  varchar(4)               $xx
  notes       blob                     Description of loader
  disassembly blob                     Disassembly of loader

year
  id
  name       varchar(4)

endiannes
  id
  name       varchar(5)

people_companies
  id
  name       varchar(128)              Name of person/company, not uniq
  company    index yesno               Is this a company? (or a person)
  notes      blob                      Info about company/person

preservers
  id
  name       varchar(64)               Name of owner/dumper/scanner, not uniq

genre
  id
  name

compilation
  id
  name       varchar(255)              Full name of compilation
  publisher  index people_comanies     Name of publisher
  num_games  byte                      Number of games
  notes      blob

box
  id
  name       varchar(32)               Box types/names

yesno
  id
  name       varchar(3)                yes or no

owner
  id
  preserver  index preservers          The owner of this game/comment
  comments   tinyblob                  The comment
  game_id    index main                The game we want to comment

clean
  id
  name       varchar(32)               software name and version

index = int
indexes = varchar(255), containing numbers separated by spaces


Personal Tools