- CREATE TABLE ccard_table (
- ccard_id BIGINT NOT NULL AUTO_INCREMENT,
- user_id BIGINT NOT NULL DEFAULT 0,
- cc_type TEXT NOT NULL DEFAULT '',
- cc_number TEXT NOT NULL DEFAULT '',
- cc_expiration_date TEXT NOT NULL DEFAULT '',
- last_update_by BIGINT NOT NULL DEFAULT '',
- last_update DATETIME NOT NULL,
- PRIMARY KEY( ccard_id ),
- INDEX( ccard_id, user_id )
- )