| @@ -207,8 +207,24 @@ | ||
| 207 | 207 | UNIQUE KEY consumer_key (consumer_key), |
| 208 | 208 | KEY user_id (user_id) |
| 209 | 209 | ) $collate; |
| 210 | 210 | ", |
| 211 | + $lp_db->tb_lp_webhooks => " | |
| 212 | + CREATE TABLE IF NOT EXISTS {$lp_db->tb_lp_webhooks} ( | |
| 213 | + webhook_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, | |
| 214 | + user_id bigint(20) unsigned NOT NULL DEFAULT 0, | |
| 215 | + status varchar(20) NOT NULL DEFAULT 'active', | |
| 216 | + name varchar(200) NOT NULL DEFAULT '', | |
| 217 | + delivery_url longtext NOT NULL, | |
| 218 | + secret text NOT NULL, | |
| 219 | + events longtext NOT NULL, | |
| 220 | + created_at datetime NOT NULL, | |
| 221 | + updated_at datetime NULL DEFAULT NULL, | |
| 222 | + PRIMARY KEY (webhook_id), | |
| 223 | + KEY user_id (user_id), | |
| 224 | + KEY status (status) | |
| 225 | + ) $collate; | |
| 226 | + ", | |
| 211 | 227 | $lp_db->tb_thim_cache => " |
| 212 | 228 | CREATE TABLE IF NOT EXISTS {$lp_db->tb_thim_cache} ( |
| 213 | 229 | key_cache VARCHAR (100) NOT NULL UNIQUE, |
| 214 | 230 | value LONGTEXT NOT NULL, |