web/wp-content/plugins/gigs-calendar/tables.sql
branchwordpress
changeset 112 fb7cd02b9848
parent 111 6b96085291d7
child 123 561aa6d282f6
--- a/web/wp-content/plugins/gigs-calendar/tables.sql	Tue Jan 05 09:48:24 2010 +0000
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,60 +0,0 @@
--- 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`)
-);