[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