====== Ticket Booking ======

====== Web front end ======



====== Database ======

  mysql> show tables;
  +-------------------------+
  | Tables_in_TICKETBOOKING |
  +-------------------------+
  | EVENTS                  |
  | PERFORMANCE             |
  | VENUE                   |
  +-------------------------+
  3 rows in set (0.00 sec)
  
  
  mysql> describe VENUE;
  +-----------+--------------+------+-----+-------------------+----------------+
  | Field     | Type         | Null | Key | Default           | Extra          |
  +-----------+--------------+------+-----+-------------------+----------------+
  | venueid   | int(11)      | NO   | PRI | NULL              | auto_increment |
  | venuename | varchar(100) | YES  |     | NULL              |                |
  | created   | timestamp    | NO   |     | CURRENT_TIMESTAMP |                |
  +-----------+--------------+------+-----+-------------------+----------------+
  3 rows in set (0.00 sec)
  
  
  mysql> insert into VENUE(venuename) values("Village 4");
  Query OK, 1 row affected (0.00 sec)
  
  mysql> select * from VENUE;
  +---------+--------------------------+---------------------+
  | venueid | venuename                | created             |
  +---------+--------------------------+---------------------+
  |       1 | location1                | 2013-04-01 21:33:51 |
  |       2 | location2                | 2013-04-01 21:33:55 |
  |       3 | Salem Longford Hall      | 2013-04-01 21:34:08 |
  |       4 | Alderman's Green FM Hall | 2013-04-01 21:34:24 |
  |       5 | Village 1                | 2013-04-01 21:34:41 |
  |       6 | Village 2                | 2013-04-01 21:34:43 |
  |       7 | Village 3                | 2013-04-01 21:34:46 |
  |       8 | Village 4                | 2013-04-01 21:34:48 |
  +---------+--------------------------+---------------------+
  8 rows in set (0.00 sec)
  
  mysql>