· 8 years ago · May 29, 2018, 02:26 AM
1CREATE TABLE IF NOT EXISTS `donations` (
2 `id` int(10) unsigned NOT NULL auto_increment,
3 `first_name` varchar(128) collate latin1_general_ci NOT NULL,
4 `last_name` varchar(128) collate latin1_general_ci NOT NULL,
5 `email` varchar(128) collate latin1_general_ci NOT NULL,
6 `amount` int(10) unsigned NOT NULL,
7 PRIMARY KEY (`id`)
8) ;
9
10CREATE TABLE IF NOT EXISTS `newsletter_subscribers` (
11 `id` int(10) unsigned NOT NULL auto_increment,
12 `email` varchar(255) collate latin1_general_ci NOT NULL,
13 `first_name` varchar(255) collate latin1_general_ci NOT NULL,
14 `last_name` varchar(255) collate latin1_general_ci NOT NULL,
15 `created_at` timestamp NOT NULL default CURRENT_TIMESTAMP,
16 PRIMARY KEY (`id`)
17) ;