[Devel] [ openser-Bugs-1497609 ] dbtext: incorect definition for subscriber table

[SourceForge.net]

Bugs item #1497609, was opened at 2006-05-30 11:14
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1497609&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: tools
Group: ver devel
Status: Open
Resolution: None
Priority: 5
Submitted By: Ovidiu Sas (osas)
Assigned to: Nobody/Anonymous (nobody)
Summary: dbtext: incorect definition for subscriber table

Initial Comment:
The subscriber table definition should allow null
values for datetime_created and datetime_modified fields:

sc.dbtext:
  echo "phplib_id(str) username(str) domain(str)
password(str) first_name(str,null) last_name(str,null)
phone(str,null) email_address(str)
datetime_created(int,null) datetime_modified(int,null)
confirmation(str,null) flag(str,null)
sendnotification(str,null) greeting(str,null) ha1(str)
ha1b(str) allow_find(str) timezone(str,null)
rpid(str,null) domn(int,null) uuid(str,null)" > $SUB_FILE


otherwise, the following errors will pop up:
DBT:dbt_table_check_row: NULL value not allowed - field 8
DBT:dbt_load_file: error at row=1 col=22 c=8
DTB:dbt_db_get_table: subscriber
DBT:dbt_query: table does not exist!

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1497609&group_id=139143