Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Newer
Older
100644 32 lines (27 sloc) 1.577 kB
6512b33 @kumar303 post in-app payment notification (bug 703083)
kumar303 authored
1 CREATE TABLE `addon_inapp_payment` (
2 `id` int(11) unsigned AUTO_INCREMENT NOT NULL PRIMARY KEY,
3 `created` datetime NOT NULL,
4 `modified` datetime NOT NULL,
5 `config_id` int(11) unsigned NOT NULL,
6 `contribution_id` int(11) unsigned NOT NULL,
7 `name` varchar(100) NOT NULL,
8 `description` varchar(255) NOT NULL,
9 `app_data` varchar(255) NOT NULL,
10 UNIQUE (`config_id`, `contribution_id`)
11 ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
12
13 ALTER TABLE `addon_inapp_payment` ADD CONSTRAINT `config_id_refs_id_7c502d8c` FOREIGN KEY (`config_id`) REFERENCES `addon_inapp` (`id`);
14 ALTER TABLE `addon_inapp_payment` ADD CONSTRAINT `contribution_id_refs_id_5d086f0` FOREIGN KEY (`contribution_id`) REFERENCES `stats_contributions` (`id`);
15 CREATE INDEX `addon_inapp_payment_c41bdac` ON `addon_inapp_payment` (`config_id`);
16 CREATE INDEX `addon_inapp_payment_1b9d2c16` ON `addon_inapp_payment` (`contribution_id`);
17
18
19 CREATE TABLE `addon_inapp_notice` (
20 `id` int(11) unsigned AUTO_INCREMENT NOT NULL PRIMARY KEY,
21 `created` datetime NOT NULL,
22 `modified` datetime NOT NULL,
23 `notice` int(11) unsigned NOT NULL,
24 `url` varchar(255) NOT NULL,
25 `payment_id` int(11) unsigned NOT NULL,
26 `success` bool NOT NULL,
27 `last_error` varchar(255)
28 ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
29
30 ALTER TABLE `addon_inapp_notice` ADD CONSTRAINT `payment_id_refs_id_8a79c182` FOREIGN KEY (`payment_id`) REFERENCES `addon_inapp_payment` (`id`);
31 CREATE INDEX `addon_inapp_notice_842c533d` ON `addon_inapp_notice` (`payment_id`);
Something went wrong with that request. Please try again.