markk at kc
Nov 27, 2009, 11:22 AM
Post #2 of 2
(792 views)
Permalink
|
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
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
_______________________________________________
mythtvnz mailing list
mythtvnz [at] lists
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
|
