#/*
# * AV Admin - Helps to manage an AV department
# *
# * Copyright (C) 2003, 2004 Josef "Jeff" Sipek
# *
# * This program is free software; you can redistribute it and/or modify
# * it under the terms of the GNU General Public License as published by
# * the Free Software Foundation; either version 2 of the License, or
# * (at your option) any later version.
# *
# * This program is distributed in the hope that it will be useful,
# * but WITHOUT ANY WARRANTY; without even the implied warranty of
# * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# * GNU General Public License for more details.
# *
# * You should have received a copy of the GNU General Public License
# * along with this program; if not, write to the Free Software
# * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
# *
# * $Id$
# */

#
# Add several equipments
#

INSERT INTO `equip` (`id`, `features`, `name`, `sn`, `func`, `note`) VALUES (NULL, 3, "OH-01", "", 1, "");
INSERT INTO `equip` (`id`, `features`, `name`, `sn`, `func`, `note`) VALUES (NULL, 3, "OH-02", "", 1, "");
INSERT INTO `equip` (`id`, `features`, `name`, `sn`, `func`, `note`) VALUES (NULL, 3, "OH-03", "", 0, "");
INSERT INTO `equip` (`id`, `features`, `name`, `sn`, `func`, `note`) VALUES (NULL, 3, "OH-04", "", 1, "");
INSERT INTO `equip` (`id`, `features`, `name`, `sn`, `func`, `note`) VALUES (NULL, 7, "CTX-01", "", 1, "");
INSERT INTO `equip` (`id`, `features`, `name`, `sn`, `func`, `note`) VALUES (NULL, 7, "CTX-02", "", 0, "");
INSERT INTO `equip` (`id`, `features`, `name`, `sn`, `func`, `note`) VALUES (NULL, 12, "TV-24", "", 1, "");
INSERT INTO `equip` (`id`, `features`, `name`, `sn`, `func`, `note`) VALUES (NULL, 12, "TV-25", "", 1, "");
  
#
# Add several rules
#

INSERT INTO `rules` (`id`, `ruleid`, `rule`) VALUES (NULL, 1, 'Keep noise level down');
INSERT INTO `rules` (`id`, `ruleid`, `rule`) VALUES (NULL, 2, 'No physical fighting is allowed');

#
# Add several rooms
#

INSERT INTO `rooms` (`id`, `room`, `name`, `note`) VALUES (NULL, "218", "AV Room", "");
INSERT INTO `rooms` (`id`, `room`, `name`, `note`) VALUES (NULL, "300", "Library", "");
INSERT INTO `rooms` (`id`, `room`, `name`, `note`) VALUES (NULL, "303", "Computer Room", "");
INSERT INTO `rooms` (`id`, `room`, `name`, `note`) VALUES (NULL, "228", "", "");
INSERT INTO `rooms` (`id`, `room`, `name`, `note`) VALUES (NULL, "230", "", "");
INSERT INTO `rooms` (`id`, `room`, `name`, `note`) VALUES (NULL, "232", "", "");
INSERT INTO `rooms` (`id`, `room`, `name`, `note`) VALUES (NULL, "324", "", "");
INSERT INTO `rooms` (`id`, `room`, `name`, `note`) VALUES (NULL, "326", "", "");
INSERT INTO `rooms` (`id`, `room`, `name`, `note`) VALUES (NULL, "120", "", "");
INSERT INTO `rooms` (`id`, `room`, `name`, `note`) VALUES (NULL, "128A", "", "");
INSERT INTO `rooms` (`id`, `room`, `name`, `note`) VALUES (NULL, "128B", "", "");

#
# Add several users
#

INSERT INTO `users` (`id`, `realname`, `name`, `pass`, `active`, `priv_eq`, `priv_eqa`, `priv_eqh`, `priv_eql`, `priv_eqm`, `priv_eqr`, `priv_user`, `priv_userl`, `priv_work`, `priv_worka`, `priv_workh`, `priv_workl`, `priv_workm`, `priv_workr`, `priv_feat`, `priv_rules`, `priv_room`, `priv_lsec`, `priv_lsys`, `priv_settings`, `priv_mess`, `priv_messs`) VALUES (NULL, "Ina C. User", "inacuser", "098f6bcd4621d373cade4e832627b4f6", 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1);
INSERT INTO `users` (`id`, `realname`, `name`, `pass`, `active`, `priv_eq`, `priv_eqa`, `priv_eqh`, `priv_eql`, `priv_eqm`, `priv_eqr`, `priv_user`, `priv_userl`, `priv_work`, `priv_worka`, `priv_workh`, `priv_workl`, `priv_workm`, `priv_workr`, `priv_feat`, `priv_rules`, `priv_room`, `priv_lsec`, `priv_lsys`, `priv_settings`, `priv_mess`, `priv_messs`) VALUES (NULL, "Someone S. Somewhere", "member", "098f6bcd4621d373cade4e832627b4f6", 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0);
INSERT INTO `users` (`id`, `realname`, `name`, `pass`, `active`, `priv_eq`, `priv_eqa`, `priv_eqh`, `priv_eql`, `priv_eqm`, `priv_eqr`, `priv_user`, `priv_userl`, `priv_work`, `priv_worka`, `priv_workh`, `priv_workl`, `priv_workm`, `priv_workr`, `priv_feat`, `priv_rules`, `priv_room`, `priv_lsec`, `priv_lsys`, `priv_settings`, `priv_mess`, `priv_messs`) VALUES (NULL, "Bob R. Someone", "captain", "098f6bcd4621d373cade4e832627b4f6", 1, 1, 1, 1, 0, 1, 1, 0, 0, 1, 1, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 1);
INSERT INTO `users` (`id`, `realname`, `name`, `pass`, `active`, `priv_eq`, `priv_eqa`, `priv_eqh`, `priv_eql`, `priv_eqm`, `priv_eqr`, `priv_user`, `priv_userl`, `priv_work`, `priv_worka`, `priv_workh`, `priv_workl`, `priv_workm`, `priv_workr`, `priv_feat`, `priv_rules`, `priv_room`, `priv_lsec`, `priv_lsys`, `priv_settings`, `priv_mess`, `priv_messs`) VALUES (NULL, "Bill J. Whoknowmes", "advisor", "098f6bcd4621d373cade4e832627b4f6", 1, 1, 1, 1, 0, 1, 1, 1, 0, 1, 1, 1, 0, 1, 1, 1, 1, 1, 0, 0, 0, 1, 1);