16 lines
399 B
SQL
16 lines
399 B
SQL
-- PHP versions available for sites
|
|
|
|
CREATE TABLE php_versions (
|
|
version VARCHAR(16) PRIMARY KEY,
|
|
is_active BOOLEAN NOT NULL DEFAULT true,
|
|
sort_order INT NOT NULL DEFAULT 0
|
|
);
|
|
|
|
INSERT INTO php_versions (version, is_active, sort_order) VALUES
|
|
('7.4', false, 1),
|
|
('8.0', false, 2),
|
|
('8.1', true, 3),
|
|
('8.2', true, 4),
|
|
('8.3', true, 5),
|
|
('8.4', true, 6);
|