8MjVPFzf

1
2CREATE TABLE IF NOT EXISTS `advert` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `banner_file` varchar(100) NOT NULL,
5  `units` enum('days','weeks','months') NOT NULL,
6  `amount` int(11) NOT NULL,
7  `price` decimal(6,2) NOT NULL,
8  `total` decimal(6,2) NOT NULL,
9  `expires` int(11) NOT NULL,
10  `account` varchar(10) DEFAULT NULL,
11  `reference` varchar(16) DEFAULT NULL,
12  `created` int(11) NOT NULL,
13  PRIMARY KEY (`id`)
14) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;