· 8 years ago · Dec 28, 2017, 07:56 PM
1CREATE TABLE IF NOT EXISTS `donations` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `status` tinyint(1) NOT NULL,
4 `date` timestamp NOT NULL,
5 `char_name` varchar(45) NOT NULL,
6 `custom` varchar(45) NOT NULL,
7 `gross` decimal(10,0) NOT NULL,
8 `fee` decimal(10,0) NOT NULL,
9 `claimed` tinyint(1) NOT NULL,
10 PRIMARY KEY (`id`)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;