CreateSubscriptionTables.php
77 lines
| 1 | <?php |
| 2 | |
| 3 | namespace Give\Subscriptions\Migrations; |
| 4 | |
| 5 | use Give\Framework\Database\DB; |
| 6 | use Give\Framework\Database\Exceptions\DatabaseQueryException; |
| 7 | use Give\Framework\Migrations\Contracts\Migration; |
| 8 | use Give\Framework\Migrations\Exceptions\DatabaseMigrationException; |
| 9 | |
| 10 | class CreateSubscriptionTables extends Migration |
| 11 | { |
| 12 | public static function id() |
| 13 | { |
| 14 | return 'create_subscription_tables'; |
| 15 | } |
| 16 | |
| 17 | public function run() |
| 18 | { |
| 19 | global $wpdb; |
| 20 | |
| 21 | $charset_collate = $wpdb->get_charset_collate(); |
| 22 | $subscriptionTableName = "{$wpdb->prefix}give_subscriptions"; |
| 23 | $metaTableName = "{$wpdb->prefix}give_subscriptionmeta"; |
| 24 | |
| 25 | try { |
| 26 | DB::delta( |
| 27 | " |
| 28 | CREATE TABLE `$subscriptionTableName` ( |
| 29 | `id` bigint(20) NOT NULL AUTO_INCREMENT, |
| 30 | `customer_id` bigint(20) NOT NULL, |
| 31 | `period` varchar(20) NOT NULL, |
| 32 | `frequency` bigint(20) NOT NULL DEFAULT '1', |
| 33 | `initial_amount` decimal(18,10) NOT NULL, |
| 34 | `recurring_amount` decimal(18,10) NOT NULL, |
| 35 | `recurring_fee_amount` decimal(18,10) NOT NULL, |
| 36 | `bill_times` bigint(20) NOT NULL, |
| 37 | `transaction_id` varchar(60) NOT NULL, |
| 38 | `parent_payment_id` bigint(20) NOT NULL, |
| 39 | `product_id` bigint(20) NOT NULL, |
| 40 | `created` datetime NOT NULL, |
| 41 | `expiration` datetime NOT NULL, |
| 42 | `status` varchar(20) NOT NULL, |
| 43 | `profile_id` varchar(60) NOT NULL, |
| 44 | `notes` longtext NOT NULL, |
| 45 | PRIMARY KEY (`id`), |
| 46 | KEY `profile_id` (`profile_id`), |
| 47 | KEY `customer` (`customer_id`), |
| 48 | KEY `transaction` (`transaction_id`), |
| 49 | KEY `customer_and_status` (`customer_id`,`status`) |
| 50 | ) $charset_collate; |
| 51 | " |
| 52 | ); |
| 53 | |
| 54 | DB::delta( |
| 55 | " |
| 56 | CREATE TABLE `$metaTableName` ( |
| 57 | `meta_id` bigint(20) NOT NULL AUTO_INCREMENT, |
| 58 | `subscription_id` bigint(20) NOT NULL, |
| 59 | `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, |
| 60 | `meta_value` longtext COLLATE utf8mb4_unicode_520_ci, |
| 61 | PRIMARY KEY (`meta_id`), |
| 62 | KEY `subscription_id` (`subscription_id`), |
| 63 | KEY `meta_key` (`meta_key`(191)) |
| 64 | ) $charset_collate; |
| 65 | " |
| 66 | ); |
| 67 | } catch (DatabaseQueryException $exception) { |
| 68 | throw new DatabaseMigrationException('An error occurred creating the subscription tables', 0, $exception); |
| 69 | } |
| 70 | } |
| 71 | |
| 72 | public static function timestamp() |
| 73 | { |
| 74 | return strtotime('2022-03-30'); |
| 75 | } |
| 76 | } |
| 77 |