VvebOIDC/install/sql/mysqli/schema/subscription/subscription_status.sql

9 lines
330 B
SQL

DROP TABLE IF EXISTS `subscription_status`;
CREATE TABLE `subscription_status` (
`subscription_status_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`language_id` INT UNSIGNED NOT NULL,
`name` varchar(32) NOT NULL,
PRIMARY KEY (`subscription_status_id`,`language_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;