[mythtv-users] Database problems and I'm a dumb @$$

[Craig Tinson]

Bryan Halter wrote:

>I had the recordedmarkup.MYI problem so I deleted the table thinking I
>could easily recreate it, not realizing that the mc.sql script only
>creates the database and not that tables.  Can someone please post the
>recordedmarkup table structure so I can just run a create table query
>and be back in bussiness.  I know I've lost all the commercial info,
>like I said I'm a dumb@$$.
>
>TIA,
>Bryan
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>

CREATE TABLE `recordedmarkup` (
  `chanid` int(10) unsigned NOT NULL default '0',
  `starttime` timestamp(14) NOT NULL,
  `mark` bigint(20) NOT NULL default '0',
  `offset` varchar(32) default NULL,
  `type` int(11) NOT NULL default '0',
  PRIMARY KEY  (`chanid`,`starttime`,`mark`,`type`)
) TYPE=MyISAM;



hth

Craig