1 -- Database tables for the Gigs Calendar Plugin v0.2

     2 -- Database version: 2

     3 

     4 -- Note: Ignore this file unless your database tables are not created automatically.

     5 -- Replace "[Your database prefix here]" with the appropriate database prefix, for example "wp_".

     6 

     7 -- --------------------------------------------------------

     8 

     9 CREATE TABLE IF NOT EXISTS `[Your database prefix here]gigs_gig` (

    10   `id` int(10) unsigned NOT NULL auto_increment,

    11   `venueID` int(10) unsigned NOT NULL,

    12   `date` date NOT NULL,

    13   `notes` text NOT NULL,

    14   `postID` bigint(20) unsigned NOT NULL,

    15   `eventName` varchar(255) NOT NULL,

    16   `tour_id` INT UNSIGNED NULL,

    17   PRIMARY KEY  (`id`)

    18 );

    19 

    20 -- --------------------------------------------------------

    21 

    22 CREATE TABLE IF NOT EXISTS `[Your database prefix here]gigs_performance` (

    23   `id` int(10) unsigned NOT NULL auto_increment,

    24   `gigID` int(10) unsigned NOT NULL,

    25   `time` time default NULL,

    26   `link` varchar(255) NOT NULL,

    27   `shortNotes` varchar(255) NOT NULL,

    28   `ages` varchar(255) NOT NULL,

    29   PRIMARY KEY  (`id`)

    30 );

    31 

    32 -- --------------------------------------------------------

    33 

    34 CREATE TABLE `[Your database prefix here]gigs_tour` (

    35   `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,

    36   `name` VARCHAR( 255 ) NOT NULL ,

    37   `notes` MEDIUMTEXT NOT NULL ,

    38   `pos` INT UNSIGNED NOT NULL

    39 );

    40 -- --------------------------------------------------------

    41 

    42 CREATE TABLE IF NOT EXISTS `[Your database prefix here]gigs_venue` (

    43   `id` int(10) unsigned NOT NULL auto_increment,

    44   `name` varchar(255) NOT NULL,

    45   `address` text NOT NULL,

    46   `city` varchar(255) NOT NULL,

    47   `state` varchar(255) NOT NULL,

    48   `country` varchar(255) NOT NULL,

    49   `postalCode` varchar(255) NOT NULL,

    50   `contact` varchar(255) NOT NULL,

    51   `phone` varchar(255) NOT NULL,

    52   `email` varchar(255) NOT NULL,

    53   `link` varchar(255) NOT NULL,

    54   `notes` text NOT NULL,

    55   `private` tinyint(4) NOT NULL,

    56   `apiID` int(10) unsigned NOT NULL,

    57   `deleted` tinyint(4) NOT NULL,

    58   `customMap` varchar(255) NOT NULL,

    59   PRIMARY KEY  (`id`)

    60 );