#/*
# * 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$
# */

#
# Table structure for table `equip`
#

DROP TABLE IF EXISTS `equip`;
CREATE TABLE `equip` (
  `id` int(11) NOT NULL auto_increment,
  `features` int(11) NOT NULL default '0',
  `name` varchar(16) NOT NULL default '',
  `sn` varchar(64) NOT NULL default '',
  `func` tinyint(1) NOT NULL default '0',
  `note` mediumtext NOT NULL,
  `imagetype` varchar(64) NOT NULL default '',
  `image` longblob NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `equip`
#

# --------------------------------------------------------

#
# Table structure for table `features`
#

DROP TABLE IF EXISTS `features`;
CREATE TABLE `features` (
  `id` int(11) NOT NULL auto_increment,
  `cap` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `features`
#

INSERT INTO `features` (`id`, `cap`) VALUES (1, 'TV & VCR');
INSERT INTO `features` (`id`, `cap`) VALUES (2, 'TV & DVD');
INSERT INTO `features` (`id`, `cap`) VALUES (3, 'Overhead Projector');
INSERT INTO `features` (`id`, `cap`) VALUES (4, 'CD Player');
INSERT INTO `features` (`id`, `cap`) VALUES (5, 'Tape Deck');
INSERT INTO `features` (`id`, `cap`) VALUES (6, 'Slide Projector');
INSERT INTO `features` (`id`, `cap`) VALUES (7, 'CTX');
INSERT INTO `features` (`id`, `cap`) VALUES (8, 'Camcorder');
INSERT INTO `features` (`id`, `cap`) VALUES (9, 'Other');
INSERT INTO `features` (`id`, `cap`) VALUES (10, 'Carousel');
INSERT INTO `features` (`id`, `cap`) VALUES (11, 'Extension Cord');
INSERT INTO `features` (`id`, `cap`) VALUES (12, 'TV & DVD/VCR Combo');
# --------------------------------------------------------

#
# Table structure for table `files`
#

DROP TABLE IF EXISTS `files`;
CREATE TABLE `files` (
  `id` int(11) NOT NULL auto_increment,
  `file` varchar(255) NOT NULL,
  `created` int(11) NOT NULL default '0',
  `destroyed` int(11) NOT NULL default '0',
  `done` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `files`
#

# --------------------------------------------------------

#
# Table structure for table `leases`
#

DROP TABLE IF EXISTS `leases`;
CREATE TABLE `leases` (
  `id` int(11) NOT NULL auto_increment,
  `enumber` int(11) NOT NULL default '0',
  `sdate` int(11) NOT NULL default '0',
  `edate` int(11) NOT NULL default '0',
  `doroom` int(11) NOT NULL default '0',
  `puroom` int(11) NOT NULL default '0',
  `droped` tinyint(1) NOT NULL default '0',
  `picked` tinyint(1) NOT NULL default '0',
  `note` mediumtext NOT NULL,
  `allyear` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `leases`
#

# --------------------------------------------------------

#
# Table structure for table `log`
#

DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(39) NOT NULL default '',
  `sid` varchar(32) NOT NULL default '',
  `edate` varchar(20) NOT NULL default '0',
  `priv` int(11) NOT NULL default '0',
  `mess` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `log`
#

# --------------------------------------------------------

#
# Table structure for table `online`
#

DROP TABLE IF EXISTS `online`;
CREATE TABLE `online` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(39) NOT NULL default '',
  `user` int(11) NOT NULL default '0',
  `uhash` varchar(32) NOT NULL default '',
  `lastac` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `online`
#

# --------------------------------------------------------

#
# Table structure for table `messages`
#

DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
  `id` int(11) NOT NULL auto_increment,
  `fromuser` int(11) NOT NULL default '0',
  `touser` int(11) NOT NULL default '0',
  `datesent` varchar(20) NOT NULL default '',
  `read` tinyint(1) NOT NULL default '0',
  `subject` varchar(128) NOT NULL default '',
  `message` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `messages`
#

# --------------------------------------------------------

#
# Table structure for table `rules`
#

DROP TABLE IF EXISTS `rules`;
CREATE TABLE `rules` (
  `id` int(11) NOT NULL auto_increment,
  `ruleid` int(11) NOT NULL default '0',
  `rule` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `rules`
#

# --------------------------------------------------------

#
# Table structure for table `rooms`
#

DROP TABLE IF EXISTS `rooms`;
CREATE TABLE `rooms` (
  `id` int(11) NOT NULL auto_increment,
  `room` varchar(16) NOT NULL default '',
  `name` varchar(32) NOT NULL default '',
  `note` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `rooms`
#

# --------------------------------------------------------

#
# Table structure for table `settings`
#

DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  `desc` varchar(255) NOT NULL default '',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) TYPE=MyISAM;

#
# Dumping data for table `settings`
#

INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'charset', 'iso-8859-1', 'The character set used by AV Admin');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'showrules', '1', 'Show rule menu block (1=yes, 0=no)');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'timeout', '15', 'Number of minutes of inactivity before a user is automatically logged out (Do NOT set to 0)');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'hardtimeout', '90', 'Number of minutes before an orphaned login record is kept in the database (Do NOT set to 0)');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'filelifespan', '60', 'Number of minutes before a dynamically generated file is deleted (Do NOT set to 0)');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'institution', 'Some Institution', 'The name of the organization');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'location', 'Someplace, NY', 'The location of the organization');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'caution', 'This is the AV Department of <b>$INSTITUTION$</b> in <i>$LOCATION$</i>.<br /><br />If you are not authorized to access this site, disconnect now.', 'The string displayed to all users on the main page');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'name', 'AV Admin', 'The name of this program');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'version', '0.10-pre6', 'Version of AV Admin');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'title', '$NAME$ (v. $VERSION$)', 'The format of the title bar');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'baseurl', '/cgi-bin/av/', 'The part of the URL containing all the dynamic files');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'staticurl', '/AV/', 'The part of the URL containing all the static files');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'basedir', '/home/www$BASEURL$', 'Local filesystem path with all the dynamic files');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'staticdir', '/home/www/html$STATICURL$', 'Local filesystem path with all the static files');
INSERT INTO `settings` (`id`, `name`, `value`, `desc`) VALUES (NULL, 'theme', 'default', 'The name of the system-wide default theme');
# --------------------------------------------------------

#
# Table structure for table `users`
#

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `realname` varchar(128) NOT NULL default '',
  `name` varchar(16) NOT NULL default '',
  `pass` varchar(32) NOT NULL default '',
  `active` tinyint(1) NOT NULL default '0',
  `priv_eq` tinyint(1) NOT NULL default '0',
  `priv_eqa` tinyint(1) NOT NULL default '0',
  `priv_eqh` tinyint(1) NOT NULL default '0',
  `priv_eql` tinyint(1) NOT NULL default '0',
  `priv_eqm` tinyint(1) NOT NULL default '0',
  `priv_eqr` tinyint(1) NOT NULL default '0',
  `priv_user` tinyint(1) NOT NULL default '0',
  `priv_userl` tinyint(1) NOT NULL default '0',
  `priv_work` tinyint(1) NOT NULL default '0',
  `priv_worka` tinyint(1) NOT NULL default '0',
  `priv_workh` tinyint(1) NOT NULL default '0',
  `priv_workl` tinyint(1) NOT NULL default '0',
  `priv_workm` tinyint(1) NOT NULL default '0',
  `priv_workr` tinyint(1) NOT NULL default '0',
  `priv_feat` tinyint(1) NOT NULL default '0',
  `priv_rules` tinyint(1) NOT NULL default '0',
  `priv_room` tinyint(1) NOT NULL default '0',
  `priv_lsec` tinyint(1) NOT NULL default '0',
  `priv_lsys` tinyint(1) NOT NULL default '0',
  `priv_settings` tinyint(1) NOT NULL default '0',
  `priv_mess` tinyint(1) NOT NULL default '0',
  `priv_messs` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `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_room`, `priv_lsec`, `priv_lsys`, `priv_mess`, `priv_messs`) VALUES (NULL, '', 'deity', '098f6bcd4621d373cade4e832627b4f6', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);