Skip to content

Instantly share code, notes, and snippets.

View dbersan's full-sized avatar
🖖
octocat

D Bersan dbersan

🖖
octocat
View GitHub Profile
CREATE TABLE IF NOT EXISTS `transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`transactiontoken` varchar(200) NOT NULL,
`invoiceid` varchar(20) NOT NULL,
`itemname` varchar(100) NOT NULL,
`itemdesc` varchar(100) NOT NULL,
`itemamount` int(10) NOT NULL,
`applicationfee` varchar(11) NOT NULL,
`buyeremail` varchar(300) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,