· 7 years ago · Oct 22, 2018, 01:46 PM
1CREATE TABLE IF NOT EXISTS `payments` (
2 `id_payment` int(11) NOT NULL AUTO_INCREMENT,
3 `fk_user` int(11) NOT NULL,
4 `amount` decimal(10,2) NOT NULL,
5 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
6 PRIMARY KEY (`id_payment`),
7 KEY `fk_user` (`fk_user`),
8 KEY `id_payment` (`id_payment`)
9) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;