Ticket #9726: mythconverg_diseqc_tree_SCR.sql
| File mythconverg_diseqc_tree_SCR.sql, 366 bytes (added by , 13 years ago) |
|---|
| Line | |
|---|---|
| 1 | ALTER TABLE `mythconverg`.`diseqc_tree` ADD COLUMN `scr_userband` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `address`, |
| 2 | ADD COLUMN `scr_frequency` INTEGER UNSIGNED NOT NULL DEFAULT 1400 AFTER `scr_userband`, |
| 3 | ADD COLUMN `scr_position` VARCHAR(1) NOT NULL DEFAULT 'A' AFTER `scr_frequency`, |
| 4 | ADD COLUMN `scr_pin` INTEGER NOT NULL DEFAULT '-1' AFTER `scr_position`; |
