15 lines
622 B
MySQL
15 lines
622 B
MySQL
|
-- PluginManager::boot() runs on every request and requires this table.
|
||
|
|
CREATE TABLE IF NOT EXISTS `sp_plugins` (
|
||
|
|
`plugin_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
|
|
`slug` VARCHAR(191) NOT NULL,
|
||
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
||
|
|
`version` VARCHAR(32) NOT NULL DEFAULT '1.0.0',
|
||
|
|
`description` TEXT NULL,
|
||
|
|
`author` VARCHAR(255) NOT NULL DEFAULT '',
|
||
|
|
`enabled` TINYINT(1) NOT NULL DEFAULT 0,
|
||
|
|
`installed_at` DATETIME NULL,
|
||
|
|
`updated_at` DATETIME NULL,
|
||
|
|
PRIMARY KEY (`plugin_id`),
|
||
|
|
UNIQUE KEY `uq_sp_plugins_slug` (`slug`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|