# MySQL-Front Dump 2.4
#
# Host: localhost   Database: PSMYSQL
#--------------------------------------------------------
# Server version 3.23.39-nt

USE PSMYSQL;


#
# Table structure for table 'appnames'
#

DROP TABLE IF EXISTS appnames;
CREATE TABLE `appnames` (
  `AppID` int(11) NOT NULL auto_increment,
  `AppName` char(35) NOT NULL default '',
  PRIMARY KEY  (`AppID`),
  UNIQUE KEY `KEY_AppName` (`AppName`),
  KEY `KEY_AppID` (`AppID`)
) TYPE=MyISAM;



#
# Table structure for table 'category'
#

DROP TABLE IF EXISTS category;
CREATE TABLE `category` (
  `CatID` int(11) NOT NULL auto_increment,
  `Category` char(35) NOT NULL default '',
  PRIMARY KEY  (`CatID`),
  UNIQUE KEY `KEY_Category` (`Category`),
  KEY `KEY_CatID` (`CatID`)
) TYPE=MyISAM;



#
# Table structure for table 'computers'
#

DROP TABLE IF EXISTS computers;
CREATE TABLE `computers` (
  `AutoPcID` int(11) NOT NULL auto_increment,
  `Assigned` varchar(25) default NULL,
  `Location` varchar(22) default '',
  `Dept` varchar(22) default '',
  `Assetid` varchar(15) default NULL,
  `Serialnumber` varchar(32) default NULL,
  `Mfg` varchar(22) default '',
  `Model` varchar(30) default '',
  `OperSys` varchar(22) default '',
  `OsVer` varchar(15) default '',
  `CPU` varchar(15) default '',
  `CpuSpeed` int(11) default NULL,
  `Ram` int(11) default NULL,
  `HardDisk` int(11) default NULL,
  `CdRom` varchar(22) default '',
  `BiosDate` date default NULL,
  `Vendor` varchar(30) default '',
  `PurchType` varchar(20) default '',
  `Cost` int(12) default NULL,
  `AcqDate` date default NULL,
  `PurchOrder` varchar(25) default '',
  `Invoice` varchar(20) default '',
  `UnderWarranty` char(3) default 'N',
  `WarrantyID` varchar(35) default NULL,
  `WarExpDate` date default NULL,
  `NIC` varchar(25) default NULL,
  `NicAddr` varchar(22) default '',
  `TcpIp` varchar(18) default '',
  `Hub` varchar(15) default '',
  `Port` varchar(10) default '',
  `SuptPhone` varchar(25) default NULL,
  `SuptWebsite` varchar(65) default NULL,
  `Notes` text,
  PRIMARY KEY  (`AutoPcID`)
) TYPE=MyISAM;



#
# Table structure for table 'departments'
#

DROP TABLE IF EXISTS departments;
CREATE TABLE `departments` (
  `DeptID` int(11) NOT NULL auto_increment,
  `Department` char(25) default NULL,
  PRIMARY KEY  (`DeptID`),
  UNIQUE KEY `Department` (`Department`)
) TYPE=MyISAM;



#
# Table structure for table 'kbase'
#

DROP TABLE IF EXISTS kbase;
CREATE TABLE `kbase` (
  `AutoID` int(11) NOT NULL auto_increment,
  `Topic` varchar(25) default NULL,
  `SubTopic` varchar(50) default NULL,
  `Title` varchar(50) default '',
  `Item_` text,
  PRIMARY KEY  (`AutoID`),
  KEY `KEY_AutoID` (`AutoID`),
  KEY `KEY_SubTopic` (`SubTopic`),
  KEY `KEY_Topic` (`Topic`)
) TYPE=MyISAM;



#
# Table structure for table 'locations'
#

DROP TABLE IF EXISTS locations;
CREATE TABLE `locations` (
  `LocID` int(11) NOT NULL auto_increment,
  `Location` char(22) default '',
  PRIMARY KEY  (`LocID`),
  UNIQUE KEY `Location` (`Location`)
) TYPE=MyISAM;



#
# Table structure for table 'mfgs'
#

DROP TABLE IF EXISTS mfgs;
CREATE TABLE `mfgs` (
  `MFGID` int(11) NOT NULL auto_increment,
  `Mfg` varchar(22) NOT NULL default '',
  `WebSite` varchar(65) default '',
  `Phone` varchar(25) default '',
  `Email` varchar(65) default '',
  `Fax` varchar(25) default '',
  `Address_` varchar(50) default '',
  `City` varchar(25) default '',
  `St` varchar(12) default '',
  `Zip` varchar(12) default '',
  `Contact` varchar(22) default '',
  `Notes` text,
  PRIMARY KEY  (`MFGID`),
  UNIQUE KEY `MfgName` (`Mfg`),
  KEY `KEY_MFGID` (`MFGID`)
) TYPE=MyISAM;



#
# Table structure for table 'models'
#

DROP TABLE IF EXISTS models;
CREATE TABLE `models` (
  `MID` int(11) NOT NULL auto_increment,
  `Model` char(22) NOT NULL default '',
  PRIMARY KEY  (`MID`),
  UNIQUE KEY `KEY_Model` (`Model`)
) TYPE=MyISAM;



#
# Table structure for table 'opersys'
#

DROP TABLE IF EXISTS opersys;
CREATE TABLE `opersys` (
  `OSID` int(11) NOT NULL auto_increment,
  `OperSys` char(25) default '',
  PRIMARY KEY  (`OSID`),
  KEY `KEY_OSID` (`OSID`)
) TYPE=MyISAM;



#
# Table structure for table 'periph'
#

DROP TABLE IF EXISTS periph;
CREATE TABLE `periph` (
  `AutoPerId` int(11) NOT NULL auto_increment,
  `PeripheralType` varchar(22) default NULL,
  `Assigned` varchar(25) default NULL,
  `Location` varchar(22) default '',
  `Dept` varchar(22) default '',
  `AssetID` varchar(15) default NULL,
  `Serialnumber` varchar(32) default NULL,
  `Mfg` varchar(22) default '',
  `Model` varchar(30) default '',
  `Vendor` varchar(30) default '',
  `PurchaseType` varchar(20) default NULL,
  `Cost` int(12) default NULL,
  `AcqDate` date default NULL,
  `PurchOrder` varchar(25) default '',
  `Invoice` varchar(20) default '',
  `UnderWarr` char(1) default 'N',
  `WarrID` varchar(35) default NULL,
  `WarExpDate` date default NULL,
  `SuptPhone` varchar(25) default NULL,
  `SuptWebsite` varchar(65) default NULL,
  `Notes` text,
  PRIMARY KEY  (`AutoPerId`)
) TYPE=MyISAM;



#
# Table structure for table 'priority'
#

DROP TABLE IF EXISTS priority;
CREATE TABLE `priority` (
  `PriorID` int(11) NOT NULL auto_increment,
  `Priority` char(15) NOT NULL default '',
  PRIMARY KEY  (`Priority`),
  UNIQUE KEY `PrimaryKey` (`PriorID`),
  KEY `KEY_PriorID` (`PriorID`)
) TYPE=MyISAM;



#
# Table structure for table 'reqtypes'
#

DROP TABLE IF EXISTS reqtypes;
CREATE TABLE `reqtypes` (
  `PTID` int(11) NOT NULL auto_increment,
  `ProbType` char(25) NOT NULL default '',
  PRIMARY KEY  (`ProbType`),
  UNIQUE KEY `PrimaryKey` (`PTID`),
  KEY `KEY_PTID` (`PTID`)
) TYPE=MyISAM;



#
# Table structure for table 'requests'
#

DROP TABLE IF EXISTS requests;
CREATE TABLE `requests` (
  `REQUESTOR` varchar(33) default NULL,
  `RequestID` int(11) NOT NULL auto_increment,
  `ReqDate` date default NULL,
  `EmailAddr` varchar(65) default '',
  `Phone` varchar(25) default '',
  `Dept` varchar(22) default '',
  `Location` varchar(22) default '',
  `PcSerialNr` varchar(32) default '',
  `ReqType` varchar(25) default '',
  `Category` varchar(30) default '',
  `Details` text,
  `Status` varchar(15) default NULL,
  `Priority` varchar(15) default 'Normal',
  `TakenBy` varchar(15) default '',
  `Assigned` varchar(15) default '',
  `CompBy` varchar(15) default '',
  `DueDate` date default NULL,
  `CompDate` date default NULL,
  `Action` text,
  `Complete` char(3) NOT NULL default 'N',
  `OrderNr` varchar(25) default '',
  `LOGINNAME` varchar(15) default NULL,
  PRIMARY KEY  (`RequestID`)
) TYPE=MyISAM;



#
# Table structure for table 'software'
#

DROP TABLE IF EXISTS software;
CREATE TABLE `software` (
  `AutoSwID` int(11) NOT NULL auto_increment,
  `InstOnPC` int(11) default NULL,
  `Programname` varchar(35) default NULL,
  `Version` varchar(15) default NULL,
  `Vendor` varchar(25) default '',
  `Assigned` varchar(25) default '',
  `Mfg` varchar(25) default '',
  `PuchType` varchar(22) default '',
  `AcqDate` date default NULL,
  `Cost` int(12) default NULL,
  `LicType` varchar(22) default '',
  `SerialNr` varchar(38) default '',
  `CdKey` varchar(35) NOT NULL default '',
  `PurchOrd` varchar(22) default '',
  `Invoice` varchar(22) default '',
  `Contract` char(3) default 'N',
  `ContrID` varchar(25) default NULL,
  `ExpDate` date default NULL,
  `Notes` text,
  PRIMARY KEY  (`AutoSwID`)
) TYPE=MyISAM;



#
# Table structure for table 'status'
#

DROP TABLE IF EXISTS status;
CREATE TABLE `status` (
  `StatID` int(11) NOT NULL auto_increment,
  `Status` char(15) default NULL,
  PRIMARY KEY  (`StatID`)
) TYPE=MyISAM;



#
# Table structure for table 'subtopic'
#

DROP TABLE IF EXISTS subtopic;
CREATE TABLE `subtopic` (
  `SUBTID` int(11) NOT NULL auto_increment,
  `SubTopic` char(50) default NULL,
  PRIMARY KEY  (`SUBTID`)
) TYPE=MyISAM;



#
# Table structure for table 'techs'
#

DROP TABLE IF EXISTS techs;
CREATE TABLE `techs` (
  `TID` int(11) NOT NULL auto_increment,
  `Tech` varchar(15) default '',
  `Firstname` varchar(12) default NULL,
  `Lastname` varchar(35) default NULL,
  `Status` varchar(15) default NULL,
  `Email` varchar(65) default '',
  `Phone` varchar(25) default '',
  `Pager` varchar(25) default '',
  `Cell` varchar(25) default '',
  `Address` varchar(40) default NULL,
  `City` varchar(30) default '',
  `St` varchar(10) default '',
  `Zip` varchar(12) default '',
  `Notes` text,
  PRIMARY KEY  (`TID`),
  KEY `KEY_TID` (`TID`)
) TYPE=MyISAM;



#
# Table structure for table 'topics'
#

DROP TABLE IF EXISTS topics;
CREATE TABLE `topics` (
  `TopicID` int(11) NOT NULL auto_increment,
  `Topic` char(22) default NULL,
  PRIMARY KEY  (`TopicID`)
) TYPE=MyISAM;



#
# Table structure for table 'userinfo'
#

DROP TABLE IF EXISTS userinfo;
CREATE TABLE `userinfo` (
  `usr_id` int(11) unsigned NOT NULL auto_increment,
  `Password` varchar(15) default NULL,
  `Login` varchar(15) default NULL,
  `SecLevel` tinyint(1) unsigned default '1',
  `username` varchar(32) default NULL,
  `Location` varchar(22) default NULL,
  `Department` varchar(25) default NULL,
  `email` varchar(65) default NULL,
  `phone_home` varchar(22) default NULL,
  `phone_work` varchar(25) default NULL,
  `phone_cell` varchar(22) default NULL,
  `fax` varchar(22) default NULL,
  `address` varchar(50) default NULL,
  `City` varchar(30) default NULL,
  `StProv` varchar(22) default NULL,
  `ZipPostal` varchar(15) default NULL,
  `Notes` text,
  PRIMARY KEY  (`usr_id`),
  UNIQUE KEY `Login` (`Login`)
) TYPE=MyISAM;



#
# Table structure for table 'vendors'
#

DROP TABLE IF EXISTS vendors;
CREATE TABLE `vendors` (
  `VID` int(11) unsigned NOT NULL auto_increment,
  `Vendor` varchar(30) NOT NULL default '',
  `Address` varchar(45) default NULL,
  `City` varchar(25) default '',
  `St` varchar(10) default '',
  `Zip` varchar(10) default '',
  `Phone` varchar(25) default '',
  `Fax` varchar(25) default '',
  `Email` varchar(65) default '',
  `WebSite` varchar(65) default '',
  `Contact` varchar(25) default '',
  `Notes` text,
  PRIMARY KEY  (`VID`),
  UNIQUE KEY `KEY_Vendor` (`Vendor`)
) TYPE=MyISAM;

