worldfirst_pdf_receipts
source link: https://gist.github.com/amr-rubix/490533de86aff57a334d7bacf04ecd6f
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
worldfirst_pdf_receipts · GitHub
Instantly share code, notes, and snippets.
DROP TABLE IF EXISTS `worldfirst_pdf_receipts`; CREATE TABLE `worldfirst_pdf_receipts` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `transaction_id` varchar(256) NOT NULL, `transaction_data` json DEFAULT NULL, `status` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pending', `company` varchar(256) NOT NULL, `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `date_updated` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `unq_user_id_transaction_id` (`user_id`,`transaction_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK