3t2ZFmfR

1Group categories
2CREATE TABLE IF NOT EXISTS `vk_categorieen` (
3  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4  `parent_id` int(10) unsigned DEFAULT NULL,
5  `title` varchar(255) NOT NULL,
6  `type` varchar(255) NOT NULL,
7  `language` enum('nl','fr','en','de') NOT NULL DEFAULT 'nl',
8  `user_creation_id` int(10) unsigned NOT NULL,
9  `user_update_id` int(10) unsigned DEFAULT NULL,
10  `creation_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
11  `update_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
12  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
13  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
14  PRIMARY KEY (`id`),
15  UNIQUE KEY `title` (`title`(25),`type`(25),`language`)
16) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;