1 CREATE TABLE IF NOT EXISTS `form_md_assessment` (
2 `id` bigint(20) NOT NULL auto_increment,
3 `date` datetime DEFAULT NULL,
4 `pid` bigint(20) NOT NULL DEFAULT 0,
5 `user` varchar(255) DEFAULT NULL,
6 `groupname` varchar(255) DEFAULT NULL,
7 `authorized` tinyint(4) NOT NULL DEFAULT 0,
8 `activity` tinyint(4) NOT NULL DEFAULT 0,
9 `assessment` varchar(255) NOT NULL DEFAULT '',
10 `plan` varchar(255) NOT NULL DEFAULT '',