[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