Recent Changes - Search:

CONGO

PmWiki

edit SideBar

V2 /

ConfigVenue

V2.ConfigVenue History

Hide minor edits - Show changes to output

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
Added line 8:
  `venue_website` varchar(50) NOT NULL DEFAULT '',
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 ''
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`)
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 |
Added lines 1-9:
A list of Venues available to hold Events.

!!Schema
[@

@]

!!See Also
* [[V2/Scheduling]] - Scheduling home page
Edit - History - Print - Recent Changes - Search
Page last modified on January 21, 2012, at 04:25 PM