[mythtvnz] Schema downgrade

[Mark]

After a quick look it looks like it was simply a matter of the following
to revert the schema

connect to database and

ALTER TABLE cardinput ADD COLUMN freetoaironly TINYINT(1) DEFAULT 1;
ALTER TABLE cardinput ADD COLUMN radioservices TINYINT(1) DEFAULT 1;

ALTER TABLE capturecard ADD COLUMN dbox2_port INT UNSIGNED NOT NULL
DEFAULT 31338;
ALTER TABLE capturecard ADD COLUMN dbox2_httpport INT UNSIGNED NOT NULL
DEFAULT 80;
ALTER TABLE capturecard ADD COLUMN dbox2_host varchar(32) NULL;

update settings set data=1244 where value='DBSchemaVer';


On Sat, 2009-11-28 at 06:38 +1300, Mark wrote:
> Doh!
> 
> After investigating some recent problems I've just discovered that I've
> been running trunk from JYA's repositories instead of 0.22.  I
> downgraded the packages on the off chance that the databases happened to
> be the same but 0.22 is wanting schema 1244 and mine is 1246.
> 
> Does anyone know if it will be simple to work out what will be required
> to 'revert' database changes?  Guess it looks like I'll finally be
> downloading the mythtv source.
> 
> Mark
> 
> 
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/