LLMS_REST_Install::get_schema( string $schema, string $collate )

Adds REST API Keys table to the LifterLMS DB Table Schema


Description Description

See also See also


Top ↑

Parameters Parameters

$schema

(string) (Required) String of DB table creation statements.

$collate

(string) (Required) Collation string.


Top ↑

Return Return

(string)


Top ↑

Source Source

File: libraries/lifterlms-rest/includes/class-llms-rest-install.php

	public static function get_schema( $schema, $collate ) {

		global $wpdb;

		$schema .= "
CREATE TABLE `{$wpdb->prefix}lifterlms_api_keys` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `description` varchar(200) DEFAULT NULL,
  `permissions` varchar(10) NOT NULL,
  `consumer_key` char(64) NOT NULL,
  `consumer_secret` char(43) NOT NULL,
  `truncated_key` char(7) NOT NULL,
  `last_access` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `consumer_key` (`consumer_key`),
  KEY `consumer_secret` (`consumer_secret`)
) $collate;
CREATE TABLE `{$wpdb->prefix}lifterlms_webhooks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(20) NOT NULL,
  `name` text NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `delivery_url` text NOT NULL,
  `secret` text NOT NULL,
  `topic` varchar(255) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `failure_count` smallint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) $collate;

		";

		return $schema;

	}

Top ↑

Changelog Changelog

Changelog
Version Description
1.0.0-beta.17 Remove unused 'pending_delivery' column.
1.0.0-beta.1 Introduced.

Top ↑

User Contributed Notes User Contributed Notes

You must log in before being able to contribute a note or feedback.