--- 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`)
-);