My database schema, was Re: Retro computer collection...

Path	csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!1.eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From	D Finnigan <dog_cow@macgui.com>
Newsgroups	comp.sys.apple2
Subject	My database schema, was Re: Retro computer collection...
Date	Sat, 25 Jul 2015 17:01:09 +0000 (UTC)
Organization	Mac GUI
Lines	23
Message-ID	<dog_cow-1437843759@macgui.com> (permalink)
References	<1195163374458993638.983494europlus-mcnamaras.id.au@news.sunsite.dk> <thej-1437317683@macgui.com> <dog_cow-1437523007@macgui.com> <thej-1437594987@macgui.com> <dog_cow-1437693349@macgui.com>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
Injection-Date	Sat, 25 Jul 2015 17:01:09 +0000 (UTC)
Injection-Info	mx02.eternal-september.org; posting-host="ac9e0e4d7dd3957fb97803ee6801bab8"; logging-data="788"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/3lC68WJ/irV/Atf3ZzD+s"
User-Agent	Mac GUI Usenet
In-Reply-To	<dog_cow-1437693349@macgui.com>
Cancel-Lock	sha1:us/7J4usAGZ+W4mdFiNY09WSWbs=
Xref	csiph.com comp.sys.apple2:25421

Show key headers only | View raw

This is really spartan, but it gets the job done for me. I am willing to
improve it, but contact me near the end of August because I'm too busy now
to devote time to it.

CREATE TABLE IF NOT EXISTS `items` (
  `item_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `obtained_from` varchar(255) NOT NULL DEFAULT '',
  `obtained_date` varchar(255) NOT NULL DEFAULT '',
  `price` varchar(50) NOT NULL DEFAULT '',
  `serial_no` varchar(255) NOT NULL DEFAULT '',
  `part_no` varchar(255) NOT NULL DEFAULT '',
  `notes` text NOT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;



-- 
]DF$
The Marina IP stack for Apple II--
http://marina.a2hq.com/

Thread

Retro computer collection management database recommendations sought europlus <europlus@mcnamaras.id.au> - 2015-07-19 10:39 +0000
  Re: Retro computer collection management database recommendations sought TheJ <thej@shaw.ca> - 2015-07-19 14:53 +0000
    Re: Retro computer collection management database recommendations sought D Finnigan <dog_cow@macgui.com> - 2015-07-21 23:55 +0000
      Re: Retro computer collection management database recommendations sought TheJ <thej@shaw.ca> - 2015-07-22 19:54 +0000
        Re: Retro computer collection management database recommendations sought a2retro <a2retrosystems@gmail.com> - 2015-07-22 21:20 -0700
          Re: Retro computer collection management database recommendations sought Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-23 18:21 +1200
            Re: Retro computer collection management database recommendations sought a2retro <a2retrosystems@gmail.com> - 2015-07-23 15:25 -0700
              Re: Retro computer collection management database recommendations sought Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-24 18:18 +1200
        Re: Retro computer collection management database recommendations sought D Finnigan <dog_cow@macgui.com> - 2015-07-23 23:14 +0000
          My database schema, was Re: Retro computer collection... D Finnigan <dog_cow@macgui.com> - 2015-07-25 17:01 +0000
            Re: My database schema, was Re: Retro computer collection... Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-26 10:42 +1200
  Re: Retro computer collection management database recommendations sought Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-20 13:57 +1200
    Re: Retro computer collection management database recommendations sought europlus <europlus@mcnamaras.id.au> - 2015-07-30 07:24 +1000
      Re: Retro computer collection management database recommendations sought Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-30 14:09 +1200
        Re: Retro computer collection management database recommendations sought europlus <europlus@mcnamaras.id.au> - 2015-07-30 15:57 +1000

csiph-web