-- Database tables for the Gigs Calendar Plugin v0.2
-- Database version: 2

-- Note: Ignore this file unless your database tables are not created automatically.
-- Replace "[Your database prefix here]" with the appropriate database prefix, for example "wp_".

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `[Your database prefix here]gigs_gig` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `venueID` int(10) unsigned NOT NULL,
  `date` date NOT NULL,
  `notes` text NOT NULL,
  `postID` bigint(20) unsigned NOT NULL,
  `eventName` varchar(255) NOT NULL,
  `tour_id` INT UNSIGNED NULL,
  PRIMARY KEY  (`id`)
);

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `[Your database prefix here]gigs_performance` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `gigID` int(10) unsigned NOT NULL,
  `time` time default NULL,
  `link` varchar(255) NOT NULL,
  `shortNotes` varchar(255) NOT NULL,
  `ages` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
);

-- --------------------------------------------------------

CREATE TABLE `[Your database prefix here]gigs_tour` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  `name` VARCHAR( 255 ) NOT NULL ,
  `notes` MEDIUMTEXT NOT NULL ,
  `pos` INT UNSIGNED NOT NULL
);
-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `[Your database prefix here]gigs_venue` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `postalCode` varchar(255) NOT NULL,
  `contact` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `notes` text NOT NULL,
  `private` tinyint(4) NOT NULL,
  `apiID` int(10) unsigned NOT NULL,
  `deleted` tinyint(4) NOT NULL,
  `customMap` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
);