[ic] stock_alert.mysql -- please verify
Joshua M. McClain
interchange-users@icdevgroup.org
Fri May 23 23:35:01 2003
I just performed all the steps from
http://www.icdevgroup.org/pipermail/interchange-users/2002-March/019170.html
... so I created the mysql database:
mysql table named stock_alert:
CREATE TABLE stock_alert (
uid int(11) NOT NULL auto_increment,
sku varchar(20) NOT NULL default '',
price decimal(10,2) NOT NULL default '0.00',
description varchar(255) NOT NULL default '',
author varchar(255) default NULL,
fname varchar(255) default NULL,
lname varchar(255) default NULL,
email varchar(255) NOT NULL default '',
date date NOT NULL default '0000-00-00',
PRIMARY KEY (uid),
UNIQUE KEY uid (uid),
KEY uid_2 (uid)
) TYPE=MyISAM;
Here's what I wanted to verify -- that I created
dbconf/mysql/stock_alert.mysql correctly. I don't need "author", so I
have:
Database stock_alert stock_alert.txt __SQLDSN__
ifdef SQLUSER
Database stock_alert USER __SQLUSER__
endif
ifdef SQLPASS
Database stock_alert PASS __SQLPASS__
endif
Database stock_alert KEY uid
Database stock_alert COLUMN_DEF "uid=int(11) NOT NULL
auto_increment"
Database stock_alert COLUMN_DEF "sku=varchar(20) NOT NULL
default ''"
Database stock_alert COLUMN_DEF "price=decimal(10,2) NOT NULL
default '0.00'"
Database stock_alert COLUMN_DEF "description=varchar(255) NOT
NULL default ''"
Database stock_alert COLUMN_DEF "author=varchar(255) default
NULL"
Database stock_alert COLUMN_DEF "fname=varchar(255) default
NULL"
Database stock_alert COLUMN_DEF "lname=varchar(255) default
NULL"
Database stock_alert COLUMN_DEF "email=varchar(255) NOT NULL
default ''"
Database stock_alert COLUMN_DEF "date=date NOT NULL default
'0000-00-00'"
---
Then I reloaded ic ...
During a few tests, everything seems to be working, but I'd like to know
if there's something more correct that I should have put in this file.
Regards,
Josh
--
Josh McClain
185 Performance
Whiteline, DMS, GoFastBits, Dobinsons, SuperPro, RPS, Aquamist, MRT, Amsoil, SX, PIAA, Cibie, Hella, Defi, Custom Fuel Line/FPR Kits
josh@185performance.com
www.185performance.com