← All changes | config/table/tables-v4.php +81 -2 4.1.7 → 4.4.8 View file →

		@@ -3,9 +3,9 @@
3	3	* List tables for the database
4	4	*
5	5	* @version 4
6	6	* @since 4.1.6.4
7		- * @version 1.0.0
	7	+ * @version 1.0.1
8	8	*/
9	9
10	10	$lp_db = LP_Database::getInstance();
11	11
		@@ -151,6 +151,85 @@
151	151	PRIMARY KEY (id),
152	152	KEY user_item_id (user_item_id)
153	153	) $collate;
154	154	",
	155	+ $lp_db->tb_lp_files => "
	156	+ CREATE TABLE IF NOT EXISTS {$lp_db->tb_lp_files} (
	157	+ file_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	158	+ file_name varchar(191) NOT NULL DEFAULT '',
	159	+ file_type varchar(100) NOT NULL DEFAULT '',
	160	+ item_id bigint(20) unsigned NOT NULL DEFAULT '0',
	161	+ item_type varchar(100) NOT NULL DEFAULT '',
	162	+ method varchar(10) NOT NULL DEFAULT 'upload',
	163	+ file_path varchar(255) NOT NULL DEFAULT '',
	164	+ orders int(4) NOT NULL DEFAULT '0',
	165	+ created_at datetime NULL DEFAULT NULL,
	166	+ PRIMARY KEY (file_id),
	167	+ KEY file_name (file_name),
	168	+ KEY item_id (item_id),
	169	+ KEY item_type (item_type)
	170	+ ) $collate;
	171	+ ",
	172	+ $lp_db->tb_lp_courses => "
	173	+ CREATE TABLE IF NOT EXISTS {$lp_db->tb_lp_courses} (
	174	+ ID bigint(20) unsigned NOT NULL,
	175	+ json LONGTEXT NOT NULL,
	176	+ price_to_sort FLOAT,
	177	+ is_sale int(1) default 0,
	178	+ post_author bigint unsigned,
	179	+ post_date_gmt datetime,
	180	+ post_content LONGTEXT,
	181	+ post_title text not null,
	182	+ post_status varchar(20) default 'publish' not null,
	183	+ post_name varchar(200) default '',
	184	+ menu_order int default 0,
	185	+ lang varchar(20),
	186	+ PRIMARY KEY (ID),
	187	+ KEY post_title (post_title(191)),
	188	+ KEY post_status (post_status),
	189	+ KEY post_name (post_name(191)),
	190	+ KEY id_status (ID, post_status)
	191	+ ) $collate;
	192	+ ",
	193	+ $lp_db->tb_lp_mcp_api_keys => "
	194	+ CREATE TABLE IF NOT EXISTS {$lp_db->tb_lp_mcp_api_keys} (
	195	+ key_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	196	+ user_id bigint(20) unsigned NOT NULL,
	197	+ description varchar(200) NULL DEFAULT NULL,
	198	+ permissions varchar(10) NOT NULL DEFAULT 'read',
	199	+ consumer_key char(64) NOT NULL,
	200	+ consumer_secret char(64) NOT NULL,
	201	+ truncated_key char(7) NOT NULL,
	202	+ last_access datetime NULL DEFAULT NULL,
	203	+ call_count bigint(20) unsigned NOT NULL DEFAULT 0,
	204	+ created_at datetime NOT NULL,
	205	+ updated_at datetime NULL DEFAULT NULL,
	206	+ PRIMARY KEY (key_id),
	207	+ UNIQUE KEY consumer_key (consumer_key),
	208	+ KEY user_id (user_id)
	209	+ ) $collate;
	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	+ ",
	227	+ $lp_db->tb_thim_cache => "
	228	+ CREATE TABLE IF NOT EXISTS {$lp_db->tb_thim_cache} (
	229	+ key_cache VARCHAR (100) NOT NULL UNIQUE,
	230	+ value LONGTEXT NOT NULL,
	231	+ expiration VARCHAR (50),
	232	+ PRIMARY KEY (key_cache)
	233	+ ) $collate;
	234	+ ",
155	235	);
156		-