1 2CREATE TABLE IF NOT EXISTS `tiki_payment_requests` ( 3 `paymentRequestId` INT NOT NULL AUTO_INCREMENT, 4 `amount` DECIMAL(7,2) NOT NULL, 5 `amount_paid` DECIMAL(7,2) NOT NULL DEFAULT 0.0, 6 `currency` CHAR(3) NOT NULL, 7 `request_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 8 `due_date` TIMESTAMP NULL, 9 `cancel_date` TIMESTAMP NULL, 10 `description` VARCHAR(100) NOT NULL, 11 `actions` TEXT, 12 PRIMARY KEY( `paymentRequestId` ) 13) ENGINE=MyISAM; 14 15CREATE TABLE IF NOT EXISTS `tiki_payment_received` ( 16 `paymentReceivedId` INT NOT NULL AUTO_INCREMENT, 17 `paymentRequestId` INT NOT NULL, 18 `payment_date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 19 `amount` DECIMAL(7,2), 20 `type` VARCHAR(15), 21 `details` TEXT, 22 PRIMARY KEY(`paymentReceivedId`), 23 KEY `payment_request_ix` (`paymentRequestId`) 24) ENGINE=MyISAM; 25 26INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_admin', 'Can administer payments', 'admin', 'payment', 'y', 'payment_feature'); 27INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_view', 'Can view payment requests and details', 'admin', 'payment', NULL, 'payment_feature'); 28INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_manual', 'Can enter manual payments', 'admin', 'payment', NULL, 'payment_feature'); 29INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_request', 'Can request a payment', 'admin', 'payment', NULL, 'payment_feature'); 30 31