· 8 years ago · Mar 11, 2018, 09:50 AM
1CREATE TABLE IF NOT EXISTS `functie` (
2 `id` varchar(23) COLLATE latin1_general_ci NOT NULL,
3 `functionname` varchar(100) COLLATE latin1_general_ci NOT NULL,
4 `desc` varchar(2000) COLLATE latin1_general_ci NOT NULL,
5 `customercode` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
6 PRIMARY KEY (`id`),
7 UNIQUE KEY `functionname` (`functionname`)
8) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;