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

[Flo]

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
--
bhalter at armyofpenguins.com
PGP KeyID: 0xE7AA5295

This is from cvs, don´t know if ist the same for 0.15.1

Flo
-------------- next part --------------
# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jul 19, 2004 at 01:39 AM
# Server version: 4.0.20
# PHP Version: 4.3.3RC3
# 
# Database : `mythconverg`
# 

# --------------------------------------------------------

#
# Table structure for table `recordedmarkup`
#

CREATE TABLE `recordedmarkup` (
  `chanid` int(10) unsigned NOT NULL default '0',
  `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
  `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;