[SCM] Interchange branch, master, updated. 7782df5e3fee9172cac0e923ce731fafb6a89eb5
Stefan Hornburg <[email protected]>
| Newsgroups | gmane.comp.web.interchange.cvs |
|---|---|
| Message-ID | <[email protected]> |
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) <[email protected]>
Date: Thu Aug 27 20:29:56 2009 +0200
change column settings analogous to Postgres ones (#307)
commit 79031f3b1725e1e9fbc603d8de8ddf8d664c025a
Author: Stefan Hornburg (Racke) <[email protected]>
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