About code posted in this journal
Unless otherwise noted, all code posted in this journal is copyright Inksome, LLC, and licensed under the GNU GPL v2. All text, including descriptions of system implementations, is licensed under the GNU GPL v2.
We welcome people of any gender identity or expression, race, ethnicity, size, nationality, sexual orientation, ability level, religion, culture, subculture, and political opinion.
....
We think accessibility for people with disabilities is a priority, not an afterthought. We think neurodiversity is a feature, not a bug. We believe in being inclusive, welcoming, and supportive of anyone who comes to us with good faith and the desire to build a community.
ALTER TABLE user ENGINE=InnoDB;
CREATE TABLE `transaction_history` (
`txn_id` varchar(255) NOT NULL,
`txn_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`email` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`txn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `payment_history` (
`userid` int(10) unsigned NOT NULL,
`txn_id` varchar(255) NOT NULL,
PRIMARY KEY (`txn_id`),
KEY `payment_history_fk_user_userid` (`userid`),
CONSTRAINT `payment_history_fk_transaction_history_txn_id` FOREIGN KEY (`txn_id`) REFERENCES `transaction_history` (`txn_id`) ON DELETE CASCADE,
CONSTRAINT `payment_history_fk_user_userid` FOREIGN KEY (`userid`) REFERENCES `user` (`userid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;