V2 /
ConfigVenueV2.ConfigVenue HistoryHide 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 to:
`venue_rooms` smallint(5) NOT NULL, `venue_footage` int(8) NOT NULL DEFAULT 0, PRIMARY KEY (`venue_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Changed lines 9-10 from:
`venue_ to:
`venue_notes` text NOT NULL DEFAULT '', `venue_phone` varchar(20) NOT NULL DEFAULT '', Changed lines 12-13 from:
`venue_rooms` `venue_footage` to:
`venue_rooms` smallint(5) NOT NULL DEFAULT '', `venue_footage` int(8) NOT NULL DEFAULT '' Changed lines 7-12 from:
`venue_ 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:
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 |