-- -- Database: `reacties` -- CREATE DATABASE `reacties` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci; USE `reacties`; -- -------------------------------------------------------- -- -- Table structure for table `personen` -- CREATE TABLE `personen` ( `id` int(11) NOT NULL auto_increment, `naam` varchar(50) collate latin1_general_ci NOT NULL, `email` varchar(100) collate latin1_general_ci default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `reacties` -- CREATE TABLE `reacties` ( `id` int(11) NOT NULL auto_increment, `persoon_id` int(11) NOT NULL, `reactie` text collate latin1_general_ci NOT NULL, `datum` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;