PmWiki | V2 / ConfigRoom

V2.ConfigRoom History

Hide minor edits - Show changes to output

January 20, 2012, at 09:16 PM by shevett -

Added line 9:

`room_locationinvenue` varchar(40) DEFAULT NULL,

Restore

January 20, 2012, at 09:04 PM by shevett -

Restore

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

Deleted line 10:

~~`room_tables` smallint(5) DEFAULT NULL,~~

Restore

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

Changed lines 5-17 from:

to:

CREATE TABLE `config_rooms` (
`room_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`room_venue` smallint(5) unsigned NOT NULL,
`room_name` varchar(40) DEFAULT NULL,
`room_width` smallint(5) DEFAULT NULL,
`room_length` smallint(5) DEFAULT NULL,
`room_tables` smallint(5) DEFAULT NULL,
`room_capacity` smallint(5) DEFAULT NULL,
`room_phone` varchar(20) DEFAULT NULL,
PRIMARY KEY (`room_id`),
KEY `room_venue` (`room_venue`),
KEY `room_name` (`room_venue`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

Restore

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

Added lines 1-9:

A list of Rooms at a Venue.

!!Schema
[@

@]

!!See Also
* [[V2/Scheduling]] - Scheduling home page

Restore