[mythtv-users] the mysql database have not all the tables in the mythTV

[szj]

Hi, All;

  MythTV is a greate project! Thanks for all the people contributing
to it.I have just downloaded the mythtv from cvs and compiled
succesefully. I use the mysql database. When I start the
mythfrontend, it reports:

 >2005-02-01 10:42:31.482 Upgrading to schema version 1014
 >DB Error (Performing database upgrade):
 >Query was:
 >ALTER TABLE record CHANGE rank recpriority INT(10) DEFAULT '0' NOT NULL;
 >Driver error was [2/1054]:
 >QMYSQL3: Unable to execute query
 >Database error was:
 >Unknown column 'rank' in 'record'
  If I start mythfilldatabase, it reports>

 >DB Error (loading channel sources):
 >Query was:
 >SELECT sourceid,name,xmltvgrabber,userid,password,lineupid FROM 
videosource ORDER BY sourceid;
 >Driver error was [2/1054]:
 >QMYSQL3: Unable to execute query
 >Database error was:
 >Unknown column 'password' in 'field list'
 So I grep all the sql files, there is no corresponding field in the sql.
it doesn't create channel table, and lost some fields in relative tables 
as indicated
above.
 
  where can I find the correct sql clause to create proper mysql database.

  Thanks for your kind instructions
  Best Regards.

  Sun Zongjun