See my comments about creating additional tables in http://www.sfu.ca/biology/facilities/computer/calendar/tables.my.sql.txt so you can have different administrators and different websites. 1: science_fraser% mysql -u mysql_username -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8092531 to server version: 4.0.20-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use mysql_database; Database changed mysql> SELECT * from mrbs_repeat -> ; +----+------------+------------+----------+------------+---------+---------+----------------+-----------+-----------------+------+-------------+---------------+---------+ | id | start_time | end_time | rep_type | end_date | rep_opt | room_id | timestamp | create_by | name | type | description | rep_num_weeks | private | +----+------------+------------+----------+------------+---------+---------+----------------+-----------+-----------------+------+-------------+---------------+---------+ | 1 | 1170946800 | 1170990000 | 2 | 1199088000 | 0000110 | 1 | 20070208162035 | dsandher | No appointments | I | NULL | NULL | 0 | | 8 | 1243292400 | 1243294200 | 2 | 1261785600 | 0011100 | 1 | 20090520121422 | carmean | end of Day | I | NULL | NULL | 1 | | 9 | 1243018800 | 1243022400 | 2 | 1261684800 | 0011100 | 1 | 20090520165852 | carmean | Lunchtime | I | NULL | NULL | 1 | +----+------------+------------+----------+------------+---------+---------+----------------+-----------+-----------------+------+-------------+---------------+---------+ 3 rows in set (0.22 sec) mysql> alter table mrbs_repeat add column student_id int; Query OK, 3 rows affected (0.78 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql> SELECT * from mrbs_repeat; +----+------------+------------+----------+------------+---------+---------+----------------+-----------+-----------------+------+-------------+---------------+---------+------------+ | id | start_time | end_time | rep_type | end_date | rep_opt | room_id | timestamp | create_by | name | type | description | rep_num_weeks | private | student_id | +----+------------+------------+----------+------------+---------+---------+----------------+-----------+-----------------+------+-------------+---------------+---------+------------+ | 1 | 1170946800 | 1170990000 | 2 | 1199088000 | 0000110 | 1 | 20070208162035 | dsandher | No appointments | I | NULL | NULL | 0 | NULL | | 8 | 1243292400 | 1243294200 | 2 | 1261785600 | 0011100 | 1 | 20090520121422 | carmean | end of Day | I | NULL | NULL | 1 | NULL | | 9 | 1243018800 | 1243022400 | 2 | 1261684800 | 0011100 | 1 | 20090520165852 | carmean | Lunchtime | I | NULL | NULL | 1 | NULL | +----+------------+------------+----------+------------+---------+---------+----------------+-----------+-----------------+------+-------------+---------------+---------+------------+ 3 rows in set (0.01 sec)