[interchange-cvs] [SCM] Interchange branch, master, updated. 7782df5e3fee9172cac0e923ce731fafb6a89eb5

Stefan Hornburg interchange-cvs at icdevgroup.org
Thu Aug 27 18:31:24 UTC 2009


This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Interchange".

The branch, master has been updated
       via  7782df5e3fee9172cac0e923ce731fafb6a89eb5 (commit)
       via  79031f3b1725e1e9fbc603d8de8ddf8d664c025a (commit)
      from  e138fd2e4e35b633a56bf307fb51465be7a71053 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 7782df5e3fee9172cac0e923ce731fafb6a89eb5
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Thu Aug 27 20:29:56 2009 +0200

    change column settings analogous to Postgres ones (#307)

commit 79031f3b1725e1e9fbc603d8de8ddf8d664c025a
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Thu Aug 27 20:29:20 2009 +0200

    include strip_html filter into distribution

-----------------------------------------------------------------------

Summary of changes and diff:
 MANIFEST                                |    1 +
 dist/standard/dbconf/sqlite/userdb.lite |   98 +++++++++++++++----------------
 2 files changed, 49 insertions(+), 50 deletions(-)

diff --git a/MANIFEST b/MANIFEST
index bc3cf4b..fdfb3f9 100644
--- a/MANIFEST
+++ b/MANIFEST
@@ -73,6 +73,7 @@ code/Filter/sql.filter
 code/Filter/strftime.filter
 code/Filter/strikeout.filter
 code/Filter/strip.filter
+code/Filter/strip_html.filter
 code/Filter/tabbed.filter
 code/Filter/text2html.filter
 code/Filter/textarea_get.filter
diff --git a/dist/standard/dbconf/sqlite/userdb.lite b/dist/standard/dbconf/sqlite/userdb.lite
index 3565c96..4c96f26 100644
--- a/dist/standard/dbconf/sqlite/userdb.lite
+++ b/dist/standard/dbconf/sqlite/userdb.lite
@@ -1,54 +1,52 @@
 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  DEFAULT_TYPE  varchar(255)
+
+Database  userdb  COLUMN_DEF   "username=varchar(64) NOT NULL PRIMARY KEY"
+Database  userdb  COLUMN_DEF   "password=varchar(64)"
+Database  userdb  COLUMN_DEF   "accounts=text"
 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   "address1=varchar(64)"
+Database  userdb  COLUMN_DEF   "address2=varchar(64)"
+Database  userdb  COLUMN_DEF   "address3=varchar(64)"
+Database  userdb  COLUMN_DEF   "address_book=text"
+Database  userdb  COLUMN_DEF   "b_address1=varchar(64)"
+Database  userdb  COLUMN_DEF   "b_address2=varchar(64)"
+Database  userdb  COLUMN_DEF   "b_address3=varchar(64)"
+Database  userdb  COLUMN_DEF   "b_city=varchar(30)"
+Database  userdb  COLUMN_DEF   "b_company=varchar(64)"
+Database  userdb  COLUMN_DEF   "b_country=varchar(10)"
+Database  userdb  COLUMN_DEF   "b_fname=varchar(30)"
+Database  userdb  COLUMN_DEF   "b_lname=varchar(30)"
 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   "b_phone=varchar(30)"
+Database  userdb  COLUMN_DEF   "b_state=varchar(10)"
+Database  userdb  COLUMN_DEF   "b_zip=varchar(10)"
+Database  userdb  COLUMN_DEF   "carts=text"
+Database  userdb  COLUMN_DEF   "city=varchar(30)"
+Database  userdb  COLUMN_DEF   "created=varchar(32)"
+Database  userdb  COLUMN_DEF   "company=varchar(64)"
+Database  userdb  COLUMN_DEF   "country=varchar(10)"
+Database  userdb  COLUMN_DEF   "credit_limit=varchar(16)"
+Database  userdb  COLUMN_DEF   "db_acl=text"
+Database  userdb  COLUMN_DEF   "dealer=varchar(32)"
+Database  userdb  COLUMN_DEF   "email=varchar(42)"
+Database  userdb  COLUMN_DEF   "fax=varchar(30)"
+Database  userdb  COLUMN_DEF   "file_acl=text"
+Database  userdb  COLUMN_DEF   "fname=varchar(30)"
+Database  userdb  COLUMN_DEF   "inactive=varchar(8)"
+Database  userdb  COLUMN_DEF   "lname=varchar(30)"
+Database  userdb  COLUMN_DEF   "mail_list=text"
+Database  userdb  COLUMN_DEF   "mod_time=varchar(20)"
+Database  userdb  COLUMN_DEF   "mv_shipmode=varchar(255)"
+Database  userdb  COLUMN_DEF   "owner=varchar(20)"
 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"
+Database  userdb  COLUMN_DEF   "phone_day=varchar(30)"
+Database  userdb  COLUMN_DEF   "phone_night=varchar(30)"
+Database  userdb  COLUMN_DEF   "price_level=varchar(30)"
+Database  userdb  COLUMN_DEF   "preferences=text"
+Database  userdb  COLUMN_DEF   "s_nickname=text"
+Database  userdb  COLUMN_DEF   "state=varchar(20)"
+Database  userdb  COLUMN_DEF   "updated=varchar(32)"
+Database  userdb  COLUMN_DEF   "zip=varchar(10)"
+Database  userdb  DEFAULT      "inactive=''"
+


hooks/post-receive
-- 
Interchange



More information about the interchange-cvs mailing list