/* presume database mother pre-existing, create with dbcreate if necessary
execute this with  "F:\Program Files\PostgreSQL\9.0\bin\psql.exe"  -d mother -U postgres
\i E:/com/mindprod/mother/mboards.sql
*/
CREATE TABLE mboards (
/* no cache, no slots */
manufacturer numeric( 2 ) NOT NULL, /* enum */
model        varchar ( 30 ) NOT NULL,
manufacturerPartNo VARCHAR ( 30 ),
revision     varchar ( 8 ),
audioChannels numeric ( 2 ),
formFactor   numeric ( 2 ), /* enum */
heightInCm   numeric ( 3, 1 ),
widthInCm    numeric ( 3, 1 ),
ide          numeric ( 2 ),
maxGig       numeric ( 3 ),
memoryType   numeric ( 2 ), /* enum */
ramSpeedMhz  numeric ( 4 ),
sata2        numeric ( 2 ),
sata3        numeric ( 2 ),
socket       numeric( 2 ), /* enum */
usb2         numeric ( 2 ),
usb2Internal numeric ( 2 ),
usb2Rear     numeric ( 2 ),
usb3         numeric ( 2 ),
usb3Internal numeric ( 2 ),
usb3Rear     numeric ( 2 ),
video        varchar( 40 ),
watts        numeric ( 4 ),
lastUpdated  numeric( 7 ));
CREATE TABLE prices (
seller        numeric ( 2 ) NOT NULL, /* enum */
manufacturer  numeric( 2 ) NOT NULL,
model         varchar ( 30 ) NOT NULL,
sellerPartNo  varchar ( 50 ),
currency      CHAR( 3 ),
price         numeric ( 6, 2 ),
lastUpdated   numeric( 7));
