- CREATE TABLE customer_notes (
- customer_note_id BIGINT NOT NULL AUTO_INCREMENT,
- user_id BIGINT NOT NULL DEFAULT 0,
- note TEXT NOT NULL DEFAULT '',
- last_update_by BIGINT NOT NULL DEFAULT 0,
- last_update DATETIME NOT NULL,
- PRIMARY KEY( customer_note_id ),
- INDEX( customer_note_id, user_id )
- )