[ic] Setting up SQL

[interchange-users@icdevgroup.org (Brian Kosick)]

Webmaster wrote:

>What's the quick & dirty configuration settings on running ic with mysql as
>opposed to the default text database?  I had my sys admin create a database
>named "store" and now I'm trying to get sql configured.  I have the server,
>user & password variables and I have the path command (/opt/mysql/bin/mysql
>store)  supposedly to access my database but can't make it work.  Something
>is not clicking here.  Any asssistance would be great!
>
>
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users
>  
>
In catalog.cfg
edit the SQLDSN

ifndef SQLDSN
Variable  SQLDSN dbi:Pg:dbname=databasename@www.databaseserver.com
endif

in variable.txt
add/edit
MYSQL    1    Database
SQLPASS XxXxXx  Database
SQLUSER Username  Database

in CATROOT/dbconf/mysql
make sure that the .mysql columns match up with the product.txt column names
example: products.mysql

Database  products  products.txt __SQLDSN__
ifdef SQLUSER
Database  products  USER         __SQLUSER__
endif
ifdef SQLPASS
Database  products  PASS         __SQLPASS__
endif
Database  products  KEY          sku
Database  products  COLUMN_DEF   "sku=char(64) NOT NULL PRIMARY KEY"
Database  products  COLUMN_DEF   "description=VARCHAR(128) NOT NULL"
Database  products  COLUMN_DEF   "title=VARCHAR(128) DEFAULT '' NOT 
NULL, index(title)"
Database  products  COLUMN_DEF   "template_page=VARCHAR(64)"
Database  products  COLUMN_DEF   "comment=TEXT"
Database  products  COLUMN_DEF   "thumb=VARCHAR(128)"
Database  products  COLUMN_DEF   "image=VARCHAR(64)"
Database  products  COLUMN_DEF   "price=DECIMAL(12,2) NOT NULL, 
index(price)"
Database  products  COLUMN_DEF   "category=VARCHAR(64) NOT NULL DEFAULT 
'', index(category)"
Database  products  COLUMN_DEF   "prod_group=VARCHAR(64) NOT NULL 
DEFAULT '', index(prod_group)"
Database  products  COLUMN_DEF   "nontaxable=CHAR(3)"
Database  products  COLUMN_DEF   "weight=VARCHAR(12) DEFAULT '0' NOT NULL"
Database  products  COLUMN_DEF   "size=VARCHAR(96)"
Database  products  COLUMN_DEF   "color=VARCHAR(96)"
Database  products  COLUMN_DEF   "gift_cert=VARCHAR(3)"
Database  products  COLUMN_DEF   "related=text"
Database  products  COLUMN_DEF   "featured=VARCHAR(32)"
Database  products  NUMERIC      price

Check the products directory for tablename.sql or tablename.autonumber 
if they are there delete or move them.  Make sure that the database is 
created in mysql but not the tables, and restart interchange.  It will 
automagically create the tables, and populate them with the values from 
the products.txt file.  And interchange will recreate the .sql and 
.autonumber files for you.  Bingo you have IC running on MySQL!