[interchange-cvs] interchange - racke modified 38 files
interchange-cvs at icdevgroup.org
interchange-cvs at icdevgroup.org
Wed Oct 1 18:28:57 UTC 2008
User: racke
Date: 2008-10-01 18:28:57 GMT
Modified: . MANIFEST WHATSNEW-5.7
Modified: debian control interchange-cat-standard.config
Modified: interchange-cat-standard.postinst
Modified: dist/standard catalog.cfg
Modified: dist/standard/products variable.txt
Added: dist/standard/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
Added: pay_cert_lock.lite pay_cert_redeem.lite
Added: pay_certs.lite pricing.lite products.lite
Added: sqlite.cfg state.lite survey.dbm transactions.lite
Added: tree.lite userdb.lite variable.dbm variants.lite
Log:
SQLite support added for standard demo
Revision Changes Path
2.231 interchange/MANIFEST
rev 2.231, prev_rev 2.230
Index: MANIFEST
===================================================================
RCS file: /var/cvs/interchange/MANIFEST,v
retrieving revision 2.230
retrieving revision 2.231
diff -u -r2.230 -r2.231
--- MANIFEST 9 Jul 2008 13:54:20 -0000 2.230
+++ MANIFEST 1 Oct 2008 18:28:57 -0000 2.231
@@ -695,6 +695,30 @@
dist/standard/dbconf/pgsql/userdb.pgsql
dist/standard/dbconf/pgsql/variable.dbm
dist/standard/dbconf/pgsql/variants.pgsql
+dist/standard/dbconf/sqlite/access.dbm
+dist/standard/dbconf/sqlite/affiliate.lite
+dist/standard/dbconf/sqlite/country.lite
+dist/standard/dbconf/sqlite/forum.lite
+dist/standard/dbconf/sqlite/inventory.lite
+dist/standard/dbconf/sqlite/locale.dbm
+dist/standard/dbconf/sqlite/merchandising.lite
+dist/standard/dbconf/sqlite/mv_metadata.dbm
+dist/standard/dbconf/sqlite/options.lite
+dist/standard/dbconf/sqlite/order_returns.lite
+dist/standard/dbconf/sqlite/orderline.lite
+dist/standard/dbconf/sqlite/pay_cert_lock.lite
+dist/standard/dbconf/sqlite/pay_cert_redeem.lite
+dist/standard/dbconf/sqlite/pay_certs.lite
+dist/standard/dbconf/sqlite/sqlite.cfg
+dist/standard/dbconf/sqlite/pricing.lite
+dist/standard/dbconf/sqlite/products.lite
+dist/standard/dbconf/sqlite/state.lite
+dist/standard/dbconf/sqlite/survey.dbm
+dist/standard/dbconf/sqlite/transactions.lite
+dist/standard/dbconf/sqlite/tree.lite
+dist/standard/dbconf/sqlite/userdb.lite
+dist/standard/dbconf/sqlite/variable.dbm
+dist/standard/dbconf/sqlite/variants.lite
dist/standard/etc/log_transaction
dist/standard/etc/mail_receipt
dist/standard/etc/order.number
2.15 interchange/WHATSNEW-5.7
rev 2.15, prev_rev 2.14
Index: WHATSNEW-5.7
===================================================================
RCS file: /var/cvs/interchange/WHATSNEW-5.7,v
retrieving revision 2.14
retrieving revision 2.15
diff -u -r2.14 -r2.15
--- WHATSNEW-5.7 1 Oct 2008 09:21:45 -0000 2.14
+++ WHATSNEW-5.7 1 Oct 2008 18:28:57 -0000 2.15
@@ -64,4 +64,9 @@
* prevent whitespace leaking into CREDIT_CARDS_ACCEPTED variable (#209)
+Standard demo
+-------------
+
+* SQLite support
+
(end)
2.29 interchange/debian/control
rev 2.29, prev_rev 2.28
Index: control
===================================================================
RCS file: /var/cvs/interchange/debian/control,v
retrieving revision 2.28
retrieving revision 2.29
diff -u -r2.28 -r2.29
--- control 2 Jun 2008 10:36:37 -0000 2.28
+++ control 1 Oct 2008 18:28:57 -0000 2.29
@@ -7,7 +7,7 @@
Package: interchange-cat-standard
Architecture: all
-Depends: libwww-perl, debconf | debconf-2.0, interchange (>=5.3.0), interchange-ui (>=5.3.0), libdbd-mysql-perl | libdbd-pg-perl, dbconfig-common
+Depends: libwww-perl, debconf | debconf-2.0, interchange (>=5.3.0), interchange-ui (>=5.3.0), libdbd-sqlite | libdbd-mysql-perl | libdbd-pg-perl, dbconfig-common
Description: Standard store, a sample Interchange catalog
The Standard store is a demo catalog which you can use to
build your Interchange applications from. While the Standard store
2.8 interchange/debian/interchange-cat-standard.config
rev 2.8, prev_rev 2.7
Index: interchange-cat-standard.config
===================================================================
RCS file: /var/cvs/interchange/debian/interchange-cat-standard.config,v
retrieving revision 2.7
retrieving revision 2.8
diff -u -r2.7 -r2.8
--- interchange-cat-standard.config 15 Feb 2008 21:25:29 -0000 2.7
+++ interchange-cat-standard.config 1 Oct 2008 18:28:57 -0000 2.8
@@ -21,7 +21,7 @@
. /usr/share/debconf/confmodule
# Set defaults for dbconfig-common
-dbc_dbtypes="mysql, pgsql"
+dbc_dbtypes="sqlite, mysql, pgsql"
dbc_dbname=interchange_standard
dbc_dbuser=interchange
2.10 interchange/debian/interchange-cat-standard.postinst
rev 2.10, prev_rev 2.9
Index: interchange-cat-standard.postinst
===================================================================
RCS file: /var/cvs/interchange/debian/interchange-cat-standard.postinst,v
retrieving revision 2.9
retrieving revision 2.10
diff -u -r2.9 -r2.10
--- interchange-cat-standard.postinst 1 Oct 2008 10:23:47 -0000 2.9
+++ interchange-cat-standard.postinst 1 Oct 2008 18:28:57 -0000 2.10
@@ -83,6 +83,7 @@
# determine database parameters
MYSQL=0
PGSQL=0
+ SQLITE=0
SQLDSN=
db_get interchange-cat-standard/dbtype
if [ "$dbc_dbtype" = "mysql" ]; then
@@ -91,10 +92,13 @@
elif [ "$dbc_dbtype" = "pgsql" ]; then
PGSQL=1
SQLDSN="dbi:Pg:dbname=$dbc_dbname"
+ elif [ "$dbc_dbtype" = "sqlite" ]; then
+ SQLITE=1
+ SQLDSN="dbi:SQLite:dbname=$dbc_dbname"
fi
-
+
SERVERNAME=`hostname --fqdn 2>/dev/null || echo localhost`
- MVC_ENABLESECURE=1 MVC_UISECURE=1 MVC_SUPERUSER="$UI_SUPERUSER" MVC_CRYPTPW="$UI_PASSWORD" MVC_LOCALES="$LOCALES" MVC_DEFAULTLOCALE="$DEFAULTLOCALE" MVC_SKIP_ADD_GLOBAL_USERTAG=1 MVC_MYSQL=$MYSQL MVC_PGSQL=$PGSQL /usr/bin/makecat \
+ MVC_ENABLESECURE=1 MVC_UISECURE=1 MVC_SUPERUSER="$UI_SUPERUSER" MVC_CRYPTPW="$UI_PASSWORD" MVC_LOCALES="$LOCALES" MVC_DEFAULTLOCALE="$DEFAULTLOCALE" MVC_SKIP_ADD_GLOBAL_USERTAG=1 MVC_SQLITE=1 MVC_MYSQL=$MYSQL MVC_PGSQL=$PGSQL /usr/bin/makecat \
-F \
-l /var/log/interchange/makecat.log \
--demotype=$CATALOG \
1.24 interchange/dist/standard/catalog.cfg
rev 1.24, prev_rev 1.23
Index: catalog.cfg
===================================================================
RCS file: /var/cvs/interchange/dist/standard/catalog.cfg,v
retrieving revision 1.23
retrieving revision 1.24
diff -u -r1.23 -r1.24
--- catalog.cfg 6 May 2008 20:42:59 -0000 1.23
+++ catalog.cfg 1 Oct 2008 18:28:57 -0000 1.24
@@ -82,6 +82,11 @@
include dbconf/pgsql/pgsql.cfg
endif
+ifdef SQLITE
+DatabaseDefault NO_ASCII_INDEX 1
+include dbconf/sqlite/sqlite.cfg
+endif
+
# Default DBM if nothing else defined
ifndef SOME_DATABASE
Require We_need_a_database "%s, must have either MySQL or Postgres"
1.1 interchange/dist/standard/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/standard/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/standard/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/standard/dbconf/sqlite/access.dbm
rev 1.1, prev_rev 1.0
Index: access.dbm
===================================================================
Database access access.asc TAB
1.1 interchange/dist/standard/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
Database affiliate AUTO_NUMBER A00000
1.1 interchange/dist/standard/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/standard/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/standard/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/standard/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/standard/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/standard/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/standard/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/standard/dbconf/sqlite/locale.dbm
rev 1.1, prev_rev 1.0
Index: locale.dbm
===================================================================
Database locale locale.txt TAB
1.1 interchange/dist/standard/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/standard/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/standard/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 AUTO_NUMBER 100001
Database options NO_SEARCH 1
Database options ChopBlanks 1
Database options COLUMN_DEF "code=varchar(64) primary key NOT NULL"
Database options COLUMN_DEF "sku=varchar(64) NOT NULL DEFAULT ''"
Database options COLUMN_DEF "o_group=varchar(64) NOT NULL DEFAULT ''"
Database options COLUMN_DEF "o_sort=varchar(16) NOT NULL DEFAULT ''"
Database options COLUMN_DEF "o_default=varchar(128)"
Database options COLUMN_DEF "o_height=integer"
Database options COLUMN_DEF "o_width=integer"
Database options COLUMN_DEF "price=varchar(250)"
Database options COLUMN_DEF "wholesale=varchar(250)"
Database options COLUMN_DEF "o_simple=varchar(1)"
Database options PREFER_NULL o_height o_width
Database options NUMERIC o_height o_width
Database options INDEX sku o_group o_sort
1.1 interchange/dist/standard/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/standard/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 COLUMN_DEF "separate_address=text"
Database orderline INDEX store_id order_number
1.1 interchange/dist/standard/dbconf/sqlite/pay_cert_lock.lite
rev 1.1, prev_rev 1.0
Index: pay_cert_lock.lite
===================================================================
Database pay_cert_lock pay_cert_lock.txt __SQLDSN__
Database pay_cert_lock COLUMN_DEF "code=varchar(32) NOT NULL PRIMARY KEY"
Database pay_cert_lock COLUMN_DEF "pid=varchar(16) NOT NULL"
Database pay_cert_lock COLUMN_DEF "ip_addr=varchar(64) NOT NULL"
1.1 interchange/dist/standard/dbconf/sqlite/pay_cert_redeem.lite
rev 1.1, prev_rev 1.0
Index: pay_cert_redeem.lite
===================================================================
Database pay_cert_redeem pay_cert_redeem.txt __SQLDSN__
Database pay_cert_redeem AUTO_NUMBER 100000000
Database pay_cert_redeem COLUMN_DEF "code=varchar(32) NOT NULL PRIMARY KEY"
Database pay_cert_redeem COLUMN_DEF "pay_id=varchar(32) NOT NULL"
Database pay_cert_redeem COLUMN_DEF "link_tid=varchar(32) NOT NULL"
Database pay_cert_redeem COLUMN_DEF "ip_addr=varchar(64) NOT NULL"
Database pay_cert_redeem COLUMN_DEF "trans_type=varchar(64) NOT NULL"
Database pay_cert_redeem COLUMN_DEF "voided=int DEFAULT 0"
Database pay_cert_redeem COLUMN_DEF "captured=int DEFAULT 0"
Database pay_cert_redeem COLUMN_DEF "username=varchar(64)"
Database pay_cert_redeem COLUMN_DEF "amount=decimal(12,2) NOT NULL"
Database pay_cert_redeem COLUMN_DEF "items=text"
Database pay_cert_redeem INDEX pay_id
1.1 interchange/dist/standard/dbconf/sqlite/pay_certs.lite
rev 1.1, prev_rev 1.0
Index: pay_certs.lite
===================================================================
Database pay_certs pay_certs.txt __SQLDSN__
Database pay_certs COLUMN_DEF "code=varchar(32) NOT NULL PRIMARY KEY"
Database pay_certs COLUMN_DEF "date_issued=varchar(32) NOT NULL"
Database pay_certs COLUMN_DEF "check_value=varchar(8) NOT NULL"
Database pay_certs COLUMN_DEF "order_number=varchar(64) NOT NULL"
Database pay_certs COLUMN_DEF "amount=decimal(12,2) NOT NULL"
Database pay_certs COLUMN_DEF "orig_amount=decimal(12,2) NOT NULL"
Database pay_certs COLUMN_DEF "ip_addr=varchar(32) NOT NULL"
Database pay_certs COLUMN_DEF "process_flag=varchar(1) default '' NOT NULL"
1.1 interchange/dist/standard/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/standard/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 HIDE_FIELD inactive
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/standard/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__
DatabaseDefault DEFAULT_TYPE varchar(255)
# 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/standard/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/standard/dbconf/sqlite/survey.dbm
rev 1.1, prev_rev 1.0
Index: survey.dbm
===================================================================
Database survey survey.txt TAB
1.1 interchange/dist/standard/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/standard/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/standard/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(128)"
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 "credit_balance=decimal(12,2)"
Database userdb COLUMN_DEF "feedback=BLOB"
1.1 interchange/dist/standard/dbconf/sqlite/variable.dbm
rev 1.1, prev_rev 1.0
Index: variable.dbm
===================================================================
Database variable variable.txt TAB
1.1 interchange/dist/standard/dbconf/sqlite/variants.lite
rev 1.1, prev_rev 1.0
Index: variants.lite
===================================================================
Database variants variants.txt __SQLDSN__
Database variants DEFAULT_TYPE varchar(255)
Database variants COLUMN_DEF "code=varchar(64) NOT NULL PRIMARY KEY"
Database variants COLUMN_DEF "sku=varchar(64)"
Database variants COLUMN_DEF "description=varchar(128)"
Database variants COLUMN_DEF "comment=text"
Database variants COLUMN_DEF "thumb=varchar(128)"
Database variants COLUMN_DEF "image=varchar(128)"
Database variants COLUMN_DEF "price=varchar(12)"
Database variants COLUMN_DEF "weight=varchar(12)"
Database variants COLUMN_DEF "inactive=varchar(1) default ''"
Database variants NO_ASCII_INDEX 1
Database variants INDEX description price inactive sku
1.11 interchange/dist/standard/products/variable.txt
rev 1.11, prev_rev 1.10
Index: variable.txt
===================================================================
RCS file: /var/cvs/interchange/dist/standard/products/variable.txt,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- variable.txt 5 Jun 2008 17:47:46 -0000 1.10
+++ variable.txt 1 Oct 2008 18:28:57 -0000 1.11
@@ -76,6 +76,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
TAXAREA IN Tax
More information about the interchange-cvs
mailing list