1 CREATE TABLE IF NOT EXISTS `form_brief_aan_verwijzer` (
2 `id` bigint(20) unsigned NOT NULL auto_increment,
3 `date` datetime default NULL,
4 `pid` bigint(20) default NULL,
5 `user` varchar(255) character set latin1 default NULL,
6 `groupname` varchar(255) character set latin1 default NULL,
7 `authorized` tinyint(4) default NULL,
8 `activity` tinyint(4) default NULL,
9 `introductie` longtext character set latin1,
10 `reden_van_aanmelding` longtext character set latin1,
11 `anamnese` longtext character set latin1,
12 `psychiatrisch_onderzoek` longtext character set latin1,
13 `beschrijvend_conclusie` longtext character set latin1,
14 `advies_beleid` longtext character set latin1,
15 `autosave_flag` tinyint(4) default 1,
16 `autosave_datetime` datetime default NULL,
18 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;