CREATE TABLE uk_gig_gigs (
  uk_gig_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  uk_gig_date int(10) unsigned NOT NULL default '0',
  uk_gig_time VARCHAR(5) NOT NULL default '00:00',
  uk_gig_name VARCHAR(50) NOT NULL default '',
  uk_gig_venue int(10) unsigned NOT NULL default '0',
  uk_gig_cover_price varchar(25) default NULL,
  uk_gig_concession tinyint(1) unsigned NOT NULL default '0',
  uk_gig_poster varchar(100) default NULL,
  uk_gig_details text,
  uk_gig_approve tinyint(1) unsigned NOT NULL default '0',
  uk_gig_pic varchar(50) NOT NULL default '',
  uk_gig_thumb varchar(50) NOT NULL default '',
  uk_gig_end int(10) unsigned NOT NULL default '0',
  uk_gig_category int(10) unsigned NOT NULL default '0',
  uk_gig_posted int(10) unsigned NOT NULL default '0',
  uk_gig_ticketsfrom varchar(100) default '',
  uk_gig_bandurl varchar(200) NOT NULL default '',
   PRIMARY KEY  (uk_gig_id)
  ) TYPE=MyISAM;

  CREATE TABLE uk_gig_venues (
  uk_gig_venues_id int(10) unsigned NOT NULL auto_increment,
  uk_gig_venues_name VARCHAR(50) default NULL,
  uk_gig_venues_address VARCHAR(150) default NULL,
  uk_gig_venues_postcode VARCHAR(10) default NULL,
  uk_gig_venues_mapurl VARCHAR(250) default NULL,
  uk_gig_venues_phone VARCHAR(25) default NULL,
  uk_gig_venues_access tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (uk_gig_venues_id)
  ) TYPE=MyISAM;

  CREATE TABLE uk_gig_cat (
  uk_gig_cat_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  uk_gig_cat_name VARCHAR(25) default NULL,
  uk_gig_cat_desc TEXT,
  uk_gig_cat_readclass INT(10) UNSIGNED NOT NULL DEFAULT '0',
  uk_gig_cat_logo VARCHAR(50) default null,
  PRIMARY KEY  (uk_gig_cat_id)
  ) TYPE=MyISAM;