1 CREATE TABLE IF NOT EXISTS form_specialist_notes (
2 id bigint(20) NOT NULL auto_increment,
3 activity tinyint(1) NOT NULL DEFAULT 1, -- 0 if deleted
5 notes text NOT NULL DEFAULT '',
7 followup_required tinyint(1) NOT NULL DEFAULT 0, -- checkbox
8 followup_timing varchar(255) NOT NULL DEFAULT '',
9 followup_location varchar(255) NOT NULL DEFAULT '',