33 lines
1.5 KiB
SQL
33 lines
1.5 KiB
SQL
-- DVB-C: symbol rate i modulacja; unikalność częstotliwości w obrębie medium (naziemne / kablowe).
|
|
-- Tabela muxes jest przebudowywana. Ponieważ migracja działa w transakcji (PRAGMA foreign_keys
|
|
-- nie działa wewnątrz transakcji), usługi i powiązania kanałów są zachowywane w kopiach.
|
|
CREATE TABLE _services_bak AS SELECT * FROM services;
|
|
CREATE TABLE _channel_map AS SELECT id, service_id FROM channels;
|
|
|
|
CREATE TABLE muxes_new (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
delsys TEXT NOT NULL,
|
|
medium TEXT NOT NULL DEFAULT 'terrestrial',
|
|
frequency_hz INTEGER NOT NULL,
|
|
bandwidth_hz INTEGER NOT NULL DEFAULT 8000000,
|
|
plp_id INTEGER,
|
|
symbol_rate INTEGER,
|
|
modulation TEXT,
|
|
onid INTEGER,
|
|
ts_id INTEGER,
|
|
network_name TEXT NOT NULL DEFAULT '',
|
|
enabled INTEGER NOT NULL DEFAULT 1,
|
|
last_scan INTEGER,
|
|
last_epg INTEGER,
|
|
UNIQUE (medium, frequency_hz)
|
|
);
|
|
INSERT INTO muxes_new (id, delsys, medium, frequency_hz, bandwidth_hz, plp_id, onid, ts_id, network_name, enabled, last_scan, last_epg)
|
|
SELECT id, delsys, 'terrestrial', frequency_hz, bandwidth_hz, plp_id, onid, ts_id, network_name, enabled, last_scan, last_epg FROM muxes;
|
|
DROP TABLE muxes;
|
|
ALTER TABLE muxes_new RENAME TO muxes;
|
|
|
|
INSERT INTO services SELECT * FROM _services_bak;
|
|
UPDATE channels SET service_id = (SELECT m.service_id FROM _channel_map m WHERE m.id = channels.id);
|
|
DROP TABLE _services_bak;
|
|
DROP TABLE _channel_map;
|