[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