[ic] userdb confusion

DB DB at M-and-D.com
Thu Jul 26 19:48:43 EDT 2007


I'm running 5.3 using mysql and a modified foundation store. Below is my
.../dbconf/mysql/userdb.mysql.

I'm confused because the primary key column appears to be labeled
'username', however I see no such column defined below. I see no column
labeled 'code' in my actual database, but one labeled 'username' exists.

Everything seems to be working, but I don't like mysteries. Can anyone
shed light on this for me?

========================

Database  userdb  userdb.txt   __SQLDSN__

ifdef MYSQL_TRANSACTIONS
Database  userdb  HAS_TRANSACTIONS  1
Database  userdb  TABLE_TYPE   InnoDB
endif
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"

============================


More information about the interchange-users mailing list