[interchange-cvs] interchange - heins modified 30 files
interchange-core@icdevgroup.org
interchange-core@icdevgroup.org
Sat Jan 25 16:25:00 2003
User: heins
Date: 2003-01-25 21:24:18 GMT
Modified: dist/foundation catalog.cfg
Modified: dist/foundation/config additional_fields
Modified: dist/foundation/products variable.txt
Added: dist/foundation/dbconf/sqlite 2ndDayAir.dbm Ground.dbm
Added: NextDayAir.dbm access.dbm affiliate.lite area.lite
Added: cat.lite component.dbm country.lite forum.lite
Added: gift_certs.lite inventory.lite locale.dbm
Added: merchandising.lite mv_metadata.dbm options.lite
Added: order_returns.lite orderline.lite pricing.lite
Added: products.lite sqlite.cfg state.lite survey.dbm
Added: transactions.lite tree.lite userdb.lite
Added: variable.dbm
Log:
* Add support for SQLite in foundation. See www.sqlite.org for info.
* Pretty much a copy of MySQL config, except that no AUTO_SEQUENCE
for tree database.
* Seems to work fine, though there will be bugs no doubt.
Revision Changes Path
2.15 +5 -0 interchange/dist/foundation/catalog.cfg
rev 2.15, prev_rev 2.14
Index: catalog.cfg
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/catalog.cfg,v
retrieving revision 2.14
retrieving revision 2.15
diff -u -r2.14 -r2.15
--- catalog.cfg 30 Dec 2002 01:01:04 -0000 2.14
+++ catalog.cfg 25 Jan 2003 21:24:16 -0000 2.15
@@ -81,6 +81,11 @@
include dbconf/oracle/oracle.cfg
endif
+ifdef SQLITE
+DatabaseDefault NO_ASCII_INDEX 1
+include dbconf/sqlite/sqlite.cfg
+endif
+
# Default DBM if nothing else defined
ifndef SOME_DATABASE
include dbconf/default_db/default_db.cfg
2.4 +10 -18 interchange/dist/foundation/config/additional_fields
rev 2.4, prev_rev 2.3
Index: additional_fields
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/config/additional_fields,v
retrieving revision 2.3
retrieving revision 2.4
diff -u -r2.3 -r2.4
--- additional_fields 17 Oct 2002 04:46:23 -0000 2.3
+++ additional_fields 25 Jan 2003 21:24:16 -0000 2.4
@@ -11,7 +11,7 @@
tools reports none
SOMESQL
-Set to 1 if you want to use MySQL, PostgreSQL, Oracle, or DB2
+Set to 1 if you want to use MySQL, PostgreSQL, Oracle, or SQLite
1 0
{SOMESQL}MYSQL
@@ -68,7 +68,7 @@
{SOMESQL and ! '__MVC_MYSQL__' and ! '__MVC_PGSQL__'}ORACLE
Set to 1 if you want to use Oracle
-1 0
+0 1
{ORACLE}SQLDSN
DBI DSN to use
@@ -90,25 +90,17 @@
Field name suffix for Oracle
_field
-{SOMESQL and ! '__MVC_MYSQL__' and ! '__MVC_PGSQL__' and ! '__MVC_ORACLE__'}DB2
-Set to 1 if you want to use DB2
- 1 0
+{SOMESQL and ! '__MVC_MYSQL__' and ! '__MVC_PGSQL__' and ! '__MVC_ORACLE__'}SQLITE
+Set to 1 if you want to use SQLite
+1 0
-{DB2}SQLDB
-Database to use (will be created)
-test___MVC_CATALOGNAME__ interch
+{SQLITE}SQLDB
+Database file to use (will be created)
+__MVC_CATROOT__/products/sqlite.db
-{DB2}SQLDSN
+{SQLITE}SQLDSN
DBI DSN to use
-dbi:DB2:__MVC_SQLDB__
-
-{DB2}SQLUSER
-Username for DB2 (if any)
- __MVC_CATALOGNAME__ __MVC_CATUSER__ interch
-
-{DB2}SQLPASS
-Password for DB2 (if any)
- pass
+dbi:SQLite:__MVC_SQLDB__
SUPERUSER
Account name that will control this catalog
1.1 interchange/dist/foundation/dbconf/sqlite/2ndDayAir.dbm
rev 1.1, prev_rev 1.0
Index: 2ndDayAir.dbm
===================================================================
Database 2ndDayAir 2ndDayAir.csv CSV
Database 2ndDayAir GUESS_NUMERIC 1
1.1 interchange/dist/foundation/dbconf/sqlite/Ground.dbm
rev 1.1, prev_rev 1.0
Index: Ground.dbm
===================================================================
Database Ground Ground.csv CSV
Database Ground GUESS_NUMERIC 1
1.1 interchange/dist/foundation/dbconf/sqlite/NextDayAir.dbm
rev 1.1, prev_rev 1.0
Index: NextDayAir.dbm
===================================================================
Database NextDayAir NextDayAir.csv CSV
Database NextDayAir GUESS_NUMERIC 1
1.1 interchange/dist/foundation/dbconf/sqlite/access.dbm
rev 1.1, prev_rev 1.0
Index: access.dbm
===================================================================
Database access access.asc TAB
1.1 interchange/dist/foundation/dbconf/sqlite/affiliate.lite
rev 1.1, prev_rev 1.0
Index: affiliate.lite
===================================================================
Database affiliate affiliate.txt __SQLDSN__
Database affiliate COLUMN_DEF "code=char(12) NOT NULL PRIMARY KEY"
Database affiliate DEFAULT_TYPE text
1.1 interchange/dist/foundation/dbconf/sqlite/area.lite
rev 1.1, prev_rev 1.0
Index: area.lite
===================================================================
Database area area.txt __SQLDSN__
Database area DEFAULT_TYPE text
Database area COLUMN_DEF "code=char(8) NOT NULL PRIMARY KEY"
Database area COLUMN_DEF "name=char(128) DEFAULT '' NOT NULL"
Database area COLUMN_DEF "sort=char(3) DEFAULT '00' NOT NULL"
Database area INDEX name sort
1.1 interchange/dist/foundation/dbconf/sqlite/cat.lite
rev 1.1, prev_rev 1.0
Index: cat.lite
===================================================================
Database cat cat.txt __SQLDSN__
Database cat DEFAULT_TYPE text
Database cat COLUMN_DEF "code=char(20) NOT NULL PRIMARY KEY"
Database cat COLUMN_DEF "sel=CHAR(64) DEFAULT '' NOT NULL"
Database cat COLUMN_DEF "name=CHAR(64) DEFAULT '' NOT NULL"
Database cat COLUMN_DEF "sort=CHAR(4) DEFAULT 'ZZ' NOT NULL"
Database cat INDEX sel name sort
1.1 interchange/dist/foundation/dbconf/sqlite/component.dbm
rev 1.1, prev_rev 1.0
Index: component.dbm
===================================================================
Database component component.txt TAB
Database component AUTO_NUMBER 00001
1.1 interchange/dist/foundation/dbconf/sqlite/country.lite
rev 1.1, prev_rev 1.0
Index: country.lite
===================================================================
Database country country.txt __SQLDSN__
Database country COLUMN_DEF "code=CHAR(3) NOT NULL PRIMARY KEY"
Database country COLUMN_DEF "selector=CHAR(3)"
Database country COLUMN_DEF "shipmodes=VARCHAR(255)"
Database country COLUMN_DEF "iso=CHAR(3) DEFAULT '' NOT NULL"
Database country COLUMN_DEF "isonum=CHAR(3) DEFAULT '' NOT NULL"
Database country COLUMN_DEF "name=VARCHAR(32) DEFAULT '' NOT NULL"
Database country INDEX name
1.1 interchange/dist/foundation/dbconf/sqlite/forum.lite
rev 1.1, prev_rev 1.0
Index: forum.lite
===================================================================
Database forum forum.txt __SQLDSN__
Database forum AUTO_NUMBER 100000
Database forum COLUMN_DEF "code=varchar(20) NOT NULL PRIMARY KEY"
Database forum COLUMN_DEF "parent=varchar(20)"
Database forum COLUMN_DEF "artid=varchar(20)"
Database forum COLUMN_DEF "mod_time=timestamp"
Database forum COLUMN_DEF "created=varchar(20)"
Database forum COLUMN_DEF "username=varchar(64)"
Database forum COLUMN_DEF "email=varchar(255)"
Database forum COLUMN_DEF "name=varchar(64)",
Database forum COLUMN_DEF "host=varchar(255)"
Database forum COLUMN_DEF "score=int"
Database forum COLUMN_DEF "lastscore=int"
Database forum COLUMN_DEF "reason=varchar(255)"
Database forum COLUMN_DEF "anon=int"
Database forum COLUMN_DEF "extended=text"
Database forum COLUMN_DEF "subject=character varying(255)"
Database forum COLUMN_DEF "comment=text"
Database forum COLUMN_DEF "additional=text"
Database forum INDEX parent
Database forum INDEX artid
Database forum INDEX created
1.1 interchange/dist/foundation/dbconf/sqlite/gift_certs.lite
rev 1.1, prev_rev 1.0
Index: gift_certs.lite
===================================================================
Database gift_certs gift_certs.txt __SQLDSN__
Database gift_certs COLUMN_DEF "code=char(14) NOT NULL PRIMARY KEY"
Database gift_certs COLUMN_DEF "username=CHAR(20) default '' NOT NULL"
Database gift_certs COLUMN_DEF "order_date=varchar(32) NOT NULL"
Database gift_certs COLUMN_DEF "original_amount=float(4) NOT NULL"
Database gift_certs COLUMN_DEF "redeemed_amount=float(4) NOT NULL"
Database gift_certs COLUMN_DEF "available_amount=float(4) NOT NULL"
Database gift_certs COLUMN_DEF "passcode=CHAR(20) NOT NULL"
Database gift_certs COLUMN_DEF "active=CHAR(3)"
Database gift_certs COLUMN_DEF "redeemed=CHAR(3)"
Database gift_certs COLUMN_DEF "update_date=timestamp"
1.1 interchange/dist/foundation/dbconf/sqlite/inventory.lite
rev 1.1, prev_rev 1.0
Index: inventory.lite
===================================================================
Database inventory inventory.txt __SQLDSN__
Database inventory COLUMN_DEF "sku=char(64) NOT NULL PRIMARY KEY"
Database inventory COLUMN_DEF "quantity=INT"
Database inventory COLUMN_DEF "stock_msg=char(64)"
Database inventory COLUMN_DEF "account=char(64)"
Database inventory COLUMN_DEF "cogs_account=char(64)"
Database inventory NUMERIC quantity
1.1 interchange/dist/foundation/dbconf/sqlite/locale.dbm
rev 1.1, prev_rev 1.0
Index: locale.dbm
===================================================================
Database locale locale.txt TAB
1.1 interchange/dist/foundation/dbconf/sqlite/merchandising.lite
rev 1.1, prev_rev 1.0
Index: merchandising.lite
===================================================================
Database merchandising merchandising.txt __SQLDSN__
Database merchandising DEFAULT_TYPE text
Database merchandising COLUMN_DEF "sku=char(64) NOT NULL PRIMARY KEY"
Database merchandising COLUMN_DEF "featured=CHAR(32) NOT NULL DEFAULT ''"
Database merchandising COLUMN_DEF "start_date=CHAR(24) NOT NULL DEFAULT ''"
Database merchandising COLUMN_DEF "finish_date=CHAR(24) NOT NULL DEFAULT ''"
Database merchandising COLUMN_DEF "cross_category=CHAR(64) NOT NULL DEFAULT ''"
Database merchandising INDEX featured start_date finish_date cross_category
1.1 interchange/dist/foundation/dbconf/sqlite/mv_metadata.dbm
rev 1.1, prev_rev 1.0
Index: mv_metadata.dbm
===================================================================
Database mv_metadata mv_metadata.asc TAB
1.1 interchange/dist/foundation/dbconf/sqlite/options.lite
rev 1.1, prev_rev 1.0
Index: options.lite
===================================================================
Database options options.txt __SQLDSN__
Database options DEFAULT_TYPE text
#Database options NUMERIC price wholesale
Database options AUTO_NUMBER 100001
Database options NO_SEARCH 1
Database options COLUMN_DEF "code=char(64) primary key NOT NULL"
Database options COLUMN_DEF "o_matrix=char(1)"
Database options COLUMN_DEF "o_modular=char(1)"
Database options COLUMN_DEF "o_master=char(64) NOT NULL DEFAULT ''"
Database options COLUMN_DEF "sku=char(64) NOT NULL DEFAULT ''"
Database options COLUMN_DEF "o_group=char(20) NOT NULL DEFAULT ''"
Database options COLUMN_DEF "o_sort=char(16) NOT NULL DEFAULT ''"
Database options COLUMN_DEF "o_enable=char(1) NOT NULL DEFAULT ''"
Database options COLUMN_DEF "o_default=char(64)"
Database options COLUMN_DEF "phantom=char(1)"
Database options COLUMN_DEF "price=varchar(20)"
Database options COLUMN_DEF "wholesale=varchar(20)"
Database options COLUMN_DEF "volume=varchar(20)"
Database options COLUMN_DEF "weight=varchar(20)"
Database options COLUMN_DEF "mv_shipmode=varchar(255)"
Database options COLUMN_DEF "o_height=int"
Database options COLUMN_DEF "o_width=int"
# These are set to type text by DEFAULT_TYPE
#Database options COLUMN_DEF "description=text"
#Database options COLUMN_DEF "differential=text"
#Database options COLUMN_DEF "o_label=text"
#Database options COLUMN_DEF "o_value=text"
Database options INDEX o_master sku o_group o_sort o_enable
1.1 interchange/dist/foundation/dbconf/sqlite/order_returns.lite
rev 1.1, prev_rev 1.0
Index: order_returns.lite
===================================================================
Database order_returns order_returns.txt __SQLDSN__
Database order_returns COLUMN_DEF "code=char(14) NOT NULL PRIMARY KEY"
Database order_returns COLUMN_DEF "order_number=CHAR(14) NOT NULL"
Database order_returns COLUMN_DEF "session=CHAR(32) NOT NULL"
Database order_returns COLUMN_DEF "username=CHAR(20) default '' NOT NULL"
Database order_returns COLUMN_DEF "rma_number=CHAR(32) NOT NULL"
Database order_returns COLUMN_DEF "nitems=CHAR(9) NOT NULL"
Database order_returns COLUMN_DEF "total=CHAR(12) NOT NULL"
Database order_returns COLUMN_DEF "return_date=varchar(32) NOT NULL"
Database order_returns COLUMN_DEF "update_date=timestamp"
Database order_returns INDEX order_number
1.1 interchange/dist/foundation/dbconf/sqlite/orderline.lite
rev 1.1, prev_rev 1.0
Index: orderline.lite
===================================================================
Database orderline orderline.txt __SQLDSN__
Database orderline DEFAULT_TYPE varchar(128)
Database orderline COLUMN_DEF "code=char(14) NOT NULL PRIMARY KEY"
Database orderline COLUMN_DEF "store_id=varchar(9) DEFAULT '' NOT NULL"
Database orderline COLUMN_DEF "order_number=varchar(14) NOT NULL"
Database orderline COLUMN_DEF "session=varchar(32) NOT NULL"
Database orderline COLUMN_DEF "username=varchar(20) default '' NOT NULL"
Database orderline COLUMN_DEF "shipmode=varchar(255) default '' NOT NULL"
Database orderline COLUMN_DEF "sku=varchar(64) NOT NULL"
Database orderline COLUMN_DEF "quantity=varchar(9) NOT NULL"
Database orderline COLUMN_DEF "price=varchar(12) NOT NULL"
Database orderline COLUMN_DEF "subtotal=varchar(12) NOT NULL"
Database orderline COLUMN_DEF "shipping=varchar(12)"
Database orderline COLUMN_DEF "taxable=varchar(3)"
Database orderline COLUMN_DEF "mv_mi=varchar(64)"
Database orderline COLUMN_DEF "mv_si=varchar(3)"
Database orderline COLUMN_DEF "mv_mp=varchar(3)"
Database orderline COLUMN_DEF "options=varchar(255)"
Database orderline COLUMN_DEF "order_date=varchar(32) NOT NULL"
Database orderline COLUMN_DEF "update_date=timestamp"
Database orderline COLUMN_DEF "status=varchar(32)"
Database orderline COLUMN_DEF "parent=varchar(9)"
Database orderline INDEX store_id order_number
1.1 interchange/dist/foundation/dbconf/sqlite/pricing.lite
rev 1.1, prev_rev 1.0
Index: pricing.lite
===================================================================
Database pricing pricing.txt __SQLDSN__
Database pricing KEY sku
Database pricing COLUMN_DEF "price_group=CHAR(12) DEFAULT '' NOT NULL"
Database pricing INDEX price_group
Database pricing COLUMN_DEF "sku=char(64) NOT NULL PRIMARY KEY"
Database pricing COLUMN_DEF "q2=char(12)"
Database pricing COLUMN_DEF "q5=char(12)"
Database pricing COLUMN_DEF "q10=char(12)"
Database pricing COLUMN_DEF "q25=char(12)"
Database pricing COLUMN_DEF "q100=char(12)"
Database pricing COLUMN_DEF "w2=char(12)"
Database pricing COLUMN_DEF "w5=char(12)"
Database pricing COLUMN_DEF "w10=char(12)"
Database pricing COLUMN_DEF "w25=char(12)"
Database pricing COLUMN_DEF "w100=char(12)"
1.1 interchange/dist/foundation/dbconf/sqlite/products.lite
rev 1.1, prev_rev 1.0
Index: products.lite
===================================================================
Database products products.txt __SQLDSN__
Database products KEY sku
Database products COLUMN_DEF "sku=char(64) NOT NULL PRIMARY KEY"
Database products COLUMN_DEF "category=VARCHAR(64) NOT NULL DEFAULT ''"
Database products COLUMN_DEF "color=VARCHAR(96)"
Database products COLUMN_DEF "comment=TEXT"
Database products COLUMN_DEF "description=VARCHAR(128) NOT NULL"
Database products COLUMN_DEF "featured=VARCHAR(32)"
Database products COLUMN_DEF "gift_cert=VARCHAR(3)"
Database products COLUMN_DEF "image=VARCHAR(64)"
Database products COLUMN_DEF "nontaxable=CHAR(3)"
Database products COLUMN_DEF "price=DECIMAL(12,2) NOT NULL"
Database products COLUMN_DEF "prod_group=VARCHAR(64) NOT NULL DEFAULT ''"
Database products COLUMN_DEF "related=text"
Database products COLUMN_DEF "size=VARCHAR(96)"
Database products COLUMN_DEF "template_page=VARCHAR(64)"
Database products COLUMN_DEF "thumb=VARCHAR(128)"
Database products COLUMN_DEF "title=VARCHAR(128) DEFAULT '' NOT NULL"
Database products COLUMN_DEF "weight=VARCHAR(12) DEFAULT '0' NOT NULL"
Database products INDEX category price prod_group title
Database products NUMERIC price
1.1 interchange/dist/foundation/dbconf/sqlite/sqlite.cfg
rev 1.1, prev_rev 1.0
Index: sqlite.cfg
===================================================================
Require module DBI
Require module DBD::SQLite
Message -i -n Using SQLite, DSN=__SQLDSN__...
DatabaseDefault USER __SQLUSER__
DatabaseDefault PASS __SQLPASS__
# Include each table definition from its separate file.
include dbconf/sqlite/*.lite
# We still use DBM for certain small tables.
include dbconf/sqlite/*.dbm
# Tell the default DBM we are using something else.
Variable SOME_DATABASE 1
1.1 interchange/dist/foundation/dbconf/sqlite/state.lite
rev 1.1, prev_rev 1.0
Index: state.lite
===================================================================
Database state state.txt __SQLDSN__
Database state AUTO_NUMBER 00001
Database state COLUMN_DEF "code=CHAR(8) NOT NULL PRIMARY KEY"
Database state COLUMN_DEF "country=CHAR(20) DEFAULT '' NOT NULL"
Database state INDEX country
Database state COLUMN_DEF "state=CHAR(20) DEFAULT '' NOT NULL"
Database state INDEX state
Database state COLUMN_DEF "postcode=CHAR(20) DEFAULT '' NOT NULL"
Database state INDEX postcode
Database state COLUMN_DEF "tax=text"
Database state COLUMN_DEF "name=CHAR(64) DEFAULT '' NOT NULL"
Database state INDEX name
1.1 interchange/dist/foundation/dbconf/sqlite/survey.dbm
rev 1.1, prev_rev 1.0
Index: survey.dbm
===================================================================
Database survey survey.txt TAB
1.1 interchange/dist/foundation/dbconf/sqlite/transactions.lite
rev 1.1, prev_rev 1.0
Index: transactions.lite
===================================================================
Database transactions transactions.txt __SQLDSN__
Database transactions DEFAULT_TYPE varchar(128)
Database transactions COLUMN_DEF "code=char(14) NOT NULL PRIMARY KEY"
Database transactions COLUMN_DEF "store_id=varchar(9) DEFAULT '' NOT NULL"
Database transactions INDEX store_id
Database transactions COLUMN_DEF "order_number=varchar(14) NOT NULL"
Database transactions INDEX order_number
Database transactions COLUMN_DEF "session=varchar(32) NOT NULL"
Database transactions COLUMN_DEF "username=varchar(20) default '' NOT NULL"
Database transactions COLUMN_DEF "shipmode=varchar(255) NOT NULL"
Database transactions COLUMN_DEF "nitems=varchar(9) NOT NULL"
Database transactions COLUMN_DEF "subtotal=varchar(12) NOT NULL"
Database transactions COLUMN_DEF "shipping=varchar(12) NOT NULL"
Database transactions COLUMN_DEF "handling=varchar(12)"
Database transactions COLUMN_DEF "salestax=varchar(12)"
Database transactions COLUMN_DEF "total_cost=varchar(16) NOT NULL"
Database transactions COLUMN_DEF "fname=varchar(30)"
Database transactions COLUMN_DEF "lname=varchar(30)"
Database transactions COLUMN_DEF "company=varchar(30)"
Database transactions COLUMN_DEF "address1=varchar(64)"
Database transactions COLUMN_DEF "address2=varchar(64)"
Database transactions COLUMN_DEF "city=varchar(30) NOT NULL"
Database transactions COLUMN_DEF "state=varchar(10)"
Database transactions COLUMN_DEF "zip=varchar(10) DEFAULT '00000' NOT NULL"
Database transactions COLUMN_DEF "country=varchar(10) DEFAULT '' NOT NULL"
Database transactions COLUMN_DEF "phone_day=varchar(20)"
Database transactions COLUMN_DEF "phone_night=varchar(20)"
Database transactions COLUMN_DEF "fax=varchar(20)"
Database transactions COLUMN_DEF "email=varchar(42)"
Database transactions COLUMN_DEF "b_fname=varchar(30)"
Database transactions COLUMN_DEF "b_lname=varchar(30)"
Database transactions COLUMN_DEF "b_company=varchar(30)"
Database transactions COLUMN_DEF "b_address1=varchar(64)"
Database transactions COLUMN_DEF "b_address2=varchar(64)"
Database transactions COLUMN_DEF "b_city=varchar(30)"
Database transactions COLUMN_DEF "b_state=varchar(10)"
Database transactions COLUMN_DEF "b_zip=varchar(10) DEFAULT '00000' NOT NULL"
Database transactions COLUMN_DEF "b_country=varchar(10) DEFAULT '' NOT NULL"
Database transactions COLUMN_DEF "b_phone=varchar(20)"
Database transactions COLUMN_DEF "payment_method=varchar(128)"
Database transactions COLUMN_DEF "avs=varchar(32)"
Database transactions COLUMN_DEF "order_date=varchar(32) NOT NULL"
Database transactions COLUMN_DEF "update_date=timestamp"
Database transactions COLUMN_DEF "order_id=varchar(32)"
Database transactions COLUMN_DEF "auth_code=varchar(32)"
Database transactions COLUMN_DEF "tracking_number=varchar(64)"
Database transactions COLUMN_DEF "status=varchar(32)"
Database transactions COLUMN_DEF "parent=varchar(9)"
Database transactions COLUMN_DEF "archived=varchar(1) DEFAULT ''"
Database transactions COLUMN_DEF "deleted=varchar(1) DEFAULT ''"
Database transactions COLUMN_DEF "complete=varchar(1) DEFAULT ''"
Database transactions COLUMN_DEF "comments=text"
Database transactions COLUMN_DEF "currency_locale=varchar(32)"
1.1 interchange/dist/foundation/dbconf/sqlite/tree.lite
rev 1.1, prev_rev 1.0
Index: tree.lite
===================================================================
Database tree tree.txt __SQLDSN__
Database tree DEFAULT_TYPE varchar(255)
Database tree AUTO_NUMBER 0000001
Database tree KEY code
Database tree COLUMN_DEF "parent_fld=varchar(20)"
Database tree COLUMN_DEF "msort=varchar(8)"
Database tree COLUMN_DEF "extended=text"
Database tree COLUMN_DEF "inactive=int not null default 0"
Database tree COLUMN_DEF "member=varchar(1)"
Database tree INDEX parent_fld
Database tree INDEX mgroup
Database tree INDEX msort
Database tree NO_ASCII_INDEX 1
Database tree HIDE_FIELD inactive
1.1 interchange/dist/foundation/dbconf/sqlite/userdb.lite
rev 1.1, prev_rev 1.0
Index: userdb.lite
===================================================================
Database userdb userdb.txt __SQLDSN__
Database userdb COLUMN_DEF "code=char(20) NOT NULL PRIMARY KEY"
Database userdb COLUMN_DEF "password=CHAR(20) NOT NULL"
Database userdb COLUMN_DEF "acl=text"
Database userdb COLUMN_DEF "mod_time=timestamp"
Database userdb COLUMN_DEF "s_nickname=text"
Database userdb COLUMN_DEF "company=CHAR(30)"
Database userdb COLUMN_DEF "fname=CHAR(30)"
Database userdb COLUMN_DEF "lname=CHAR(30)"
Database userdb COLUMN_DEF "address1=CHAR(64)"
Database userdb COLUMN_DEF "address2=CHAR(64)"
Database userdb COLUMN_DEF "address3=CHAR(64)"
Database userdb COLUMN_DEF "city=CHAR(30)"
Database userdb COLUMN_DEF "state=CHAR(10)"
Database userdb COLUMN_DEF "zip=CHAR(10)"
Database userdb COLUMN_DEF "country=CHAR(10)"
Database userdb COLUMN_DEF "phone_day=CHAR(20)"
Database userdb COLUMN_DEF "mv_shipmode=CHAR(255)"
Database userdb COLUMN_DEF "b_nickname=text"
Database userdb COLUMN_DEF "b_fname=CHAR(30)"
Database userdb COLUMN_DEF "b_lname=CHAR(30)"
Database userdb COLUMN_DEF "b_address1=CHAR(64)"
Database userdb COLUMN_DEF "b_address2=CHAR(64)"
Database userdb COLUMN_DEF "b_address3=CHAR(64)"
Database userdb COLUMN_DEF "b_city=CHAR(30)"
Database userdb COLUMN_DEF "b_state=CHAR(10)"
Database userdb COLUMN_DEF "b_zip=CHAR(10)"
Database userdb COLUMN_DEF "b_country=CHAR(10)"
Database userdb COLUMN_DEF "b_phone=CHAR(20)"
Database userdb COLUMN_DEF "mv_credit_card_type=CHAR(16)"
Database userdb COLUMN_DEF "mv_credit_card_exp_month=CHAR(2)"
Database userdb COLUMN_DEF "mv_credit_card_exp_year=CHAR(4)"
Database userdb COLUMN_DEF "p_nickname=text"
Database userdb COLUMN_DEF "email=VARCHAR(42)"
Database userdb COLUMN_DEF "fax=CHAR(20)"
Database userdb COLUMN_DEF "phone_night=CHAR(20)"
Database userdb COLUMN_DEF "fax_order=CHAR(2)"
Database userdb COLUMN_DEF "address_book=BLOB"
Database userdb COLUMN_DEF "accounts=BLOB"
Database userdb COLUMN_DEF "preferences=BLOB"
Database userdb COLUMN_DEF "carts=BLOB"
Database userdb COLUMN_DEF "owner=char(20)"
Database userdb COLUMN_DEF "file_acl=BLOB"
Database userdb COLUMN_DEF "db_acl=BLOB"
Database userdb COLUMN_DEF "order_numbers=TEXT"
Database userdb COLUMN_DEF "email_copy=char(1)"
Database userdb COLUMN_DEF "mail_list=varchar(64)"
Database userdb COLUMN_DEF "project_id=char(20)"
Database userdb COLUMN_DEF "account_id=char(20)"
Database userdb COLUMN_DEF "order_dest=char(32)"
Database userdb COLUMN_DEF "payment_method=char(32)"
Database userdb COLUMN_DEF "dealer=char(32)"
Database userdb COLUMN_DEF "feedback=BLOB"
1.1 interchange/dist/foundation/dbconf/sqlite/variable.dbm
rev 1.1, prev_rev 1.0
Index: variable.dbm
===================================================================
Database variable variable.txt TAB
2.21 +1 -0 interchange/dist/foundation/products/variable.txt
rev 2.21, prev_rev 2.20
Index: variable.txt
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/products/variable.txt,v
retrieving revision 2.20
retrieving revision 2.21
diff -u -r2.20 -r2.21
--- variable.txt 14 Jan 2003 02:25:50 -0000 2.20
+++ variable.txt 25 Jan 2003 21:24:18 -0000 2.21
@@ -93,6 +93,7 @@
SHIP_FLAT_DOM_RATE 5 Shipping
SHIP_FLAT_INTL_RATE 10 Shipping
SQLDSN __MVC_SQLDSN__ Database
+SQLITE __MVC_SQLITE__ Database
SQLPASS __MVC_SQLPASS__ Database
SQLUSER __MVC_SQLUSER__ Database
STYLE __MVC_STYLE__ Template