PmWiki | V2 / ConfigVenue

January 21, 2012, at 04:25 PM by shevett -

Changed lines 4-5 from:

[@ CREATE TABLE `config_venues` (

to:

[@CREATE TABLE `config_venues` (

Changed lines 12-15 from:

  `venue_rooms` smallint(5) NOT NULL DEFAULT '',
  `venue_footage` int(8) NOT NULL DEFAULT ''
  PRIMARY KEY (`venue_id`),

) ENGINE=InnoDB ? DEFAULT CHARSET=latin1 |

to:

  `venue_rooms` smallint(5) NOT NULL,
  `venue_footage` int(8) NOT NULL DEFAULT 0,
  PRIMARY KEY (`venue_id`)

) ENGINE=InnoDB ? DEFAULT CHARSET=latin1

January 20, 2012, at 03:25 PM by shevett -

Added line 8:

  `venue_website` varchar(50) NOT NULL DEFAULT '',

January 20, 2012, at 03:24 PM by shevett -

Changed lines 9-10 from:

  `venue_phone` varchar(50) NOT NULL DEFAULT '',

to:

  `venue_notes` text NOT NULL DEFAULT '',
  `venue_phone` varchar(20) NOT NULL DEFAULT '',

Changed lines 12-13 from:

  `venue_rooms` varchar(50) NOT NULL DEFAULT '',
  `venue_footage` varchar(50) NOT NULL DEFAULT ''

to:

  `venue_rooms` smallint(5) NOT NULL DEFAULT '',
  `venue_footage` int(8) NOT NULL DEFAULT ''

January 20, 2012, at 03:23 PM by shevett -

Changed lines 7-12 from:

  `venue_rid` varchar(50) NOT NULL DEFAULT '',

to:

  `venue_name` varchar(50) NOT NULL DEFAULT '',
  `venue_location` varchar(50) NOT NULL DEFAULT '',
  `venue_phone` varchar(50) NOT NULL DEFAULT '',
  `venue_contact` varchar(50) NOT NULL DEFAULT '',
  `venue_rooms` varchar(50) NOT NULL DEFAULT '',
  `venue_footage` varchar(50) NOT NULL DEFAULT ''

Deleted line 13:

  KEY `venue_rid` (`venue_rid`)

January 20, 2012, at 03:13 PM by shevett -

Changed lines 5-10 from:

to:

CREATE TABLE `config_venues` (

  `venue_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `venue_rid` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`venue_id`),
  KEY `venue_rid` (`venue_rid`)

) ENGINE=InnoDB ? DEFAULT CHARSET=latin1 |

January 20, 2012, at 03:08 PM by shevett -

Added lines 1-9:

A list of Venues available to hold Events.

ConfigVenue

V2.ConfigVenue History

Schema

See Also