address_table.sql
上传用户:xiao730204
上传日期:2007-01-04
资源大小:141k
文件大小:1k
- CREATE TABLE address_table (
- address_id BIGINT NOT NULL AUTO_INCREMENT,
- user_id BIGINT NOT NULL DEFAULT 0,
- address_name TEXT NOT NULL DEFAULT '',
- address TEXT NOT NULL DEFAULT '',
- city TEXT NOT NULL DEFAULT '',
- state TEXT NOT NULL DEFAULT '',
- zip TEXT NOT NULL DEFAULT '',
- country TEXT NOT NULL DEFAULT '',
- mailing_address INT NOT NULL DEFAULT 0,
- last_update_by BIGINT NOT NULL DEFAULT '',
- last_update DATETIME NOT NULL,
- PRIMARY KEY( address_id ),
- INDEX( address_id, user_id )
- )