From xt:Commerce 技術文件

資料結構   搜尋   語言 : 正體中文

	Contents 1 版本 2 說明 2.1 customer 資料表 2.2 版本異動說明 [edit] 版本 xt:Commerce 3.04 sp2.2 [edit] 說明 [edit] customer 資料表 customers_id int NOT NULL auto_increment customers_cid varchar(32) customers_vat_id varchar (20) customers_vat_id_status int(2) DEFAULT '0' NOT NULL customers_warning varchar(32) customers_status int(5) DEFAULT '1' NOT NULL customers_gender char(1) NOT NULL customers_firstname varchar(32) NOT NULL customers_lastname varchar(32) NOT NULL customers_dob datetime DEFAULT '0000-00-00 00:00:00' NOT NULL customers_email_address varchar(96) NOT NULL customers_default_address_id int NOT NULL customers_telephone varchar(32) NOT NULL customers_fax varchar(32) customers_password varchar(40) NOT NULL customers_newsletter char(1) customers_newsletter_mode char( 1 ) DEFAULT '0' NOT NULL member_flag char(1) DEFAULT '0' NOT NULL delete_user char(1) DEFAULT '1' NOT NULL account_type int(1) NOT NULL default '0' password_request_key varchar(32) NOT NULL payment_unallowed varchar(255) NOT NULL shipping_unallowed varchar(255) NOT NULL refferers_id int(5) DEFAULT '0' NOT NULL customers_date_added datetime DEFAULT '0000-00-00 00:00:00' customers_last_modified datetime DEFAULT '0000-00-00 00:00:00' [edit] 版本異動說明 資料結構 customers_basket