diff -r 6b96085291d7 -r fb7cd02b9848 web/wp-content/plugins/gigs-calendar/tables.sql --- 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`) -);