- CREATE TABLE phone_num_table (
- phone_num_id BIGINT NOT NULL AUTO_INCREMENT,
- user_id BIGINT NOT NULL DEFAULT 0,
- phone_number_name TEXT NOT NULL DEFAULT '',
- phone_number TEXT NOT NULL DEFAULT '',
- phone_number_notes TEXT NOT NULL DEFAULT '',
- contact_number INT NOT NULL DEFAULT 0,
- PRIMARY KEY( phone_num_id ),
- INDEX( phone_num_id, user_id )
- )