db.sql

基于PHP和MYSQL的计算机辅助设备维修管理系统

# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# Generation Time: Aug 22, 2004 at 09:57 PM
# Server version: 4.0.20
# PHP Version: 4.3.8
# 
# 

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

#
# Table structure for table `site_cats`
#

CREATE TABLE `site_cats` (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_name` varchar(200) NOT NULL default '',
  `cat_parent` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;

#
# Dumping data for table `site_cats`
#

INSERT INTO `site_cats` VALUES (1, 'Dallas Storage Warehouse', 0);
INSERT INTO `site_cats` VALUES (2, 'Power Tools', 1);
INSERT INTO `site_cats` VALUES (4, 'Houston Truck Plant', 0);
INSERT INTO `site_cats` VALUES (5, 'Vehicles', 1);
INSERT INTO `site_cats` VALUES (6, 'Fabrication Department', 4);
INSERT INTO `site_cats` VALUES (7, 'Operations Management', 4);

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

#
# Table structure for table `site_products`
#

CREATE TABLE `site_products` (
  `product_id` int(11) NOT NULL auto_increment,
  `product_cat` int(11) NOT NULL default '0',
  `product_vendors` text NOT NULL,
  `product_name` varchar(200) NOT NULL default '',
  `product_description` text NOT NULL,
  PRIMARY KEY  (`product_id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

#
# Dumping data for table `site_products`
#

INSERT INTO `site_products` VALUES (1, 2, '1,2', 'Utility Equipment', '');
INSERT INTO `site_products` VALUES (2, 2, '2', 'Air Hammer', 'XYZ Air Hammmer, purchased 5/02');
INSERT INTO `site_products` VALUES (3, 5, '8', '1991 Dodge Ram 2500', '');
INSERT INTO `site_products` VALUES (4, 2, '3,4,6', 'Drill Press', 'Drill press located in the SW corner of the plant.');
INSERT INTO `site_products` VALUES (5, 6, '5', 'Injection Mold Model 12', 'Injection Mold Model 12\r\n800 AMP\r\n15 KSG Rating\r\n1987');
INSERT INTO `site_products` VALUES (7, 2, '3,4', 'Sawz All', 'Milwaulee');
INSERT INTO `site_products` VALUES (8, 5, '8', '1999 GM Dump Truck Heavy Duty', 'Diesel Truck');
INSERT INTO `site_products` VALUES (9, 5, '8', '1995 Ford Tow Truck', '');
INSERT INTO `site_products` VALUES (10, 1, '7', 'Front Entry System', '');

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

#
# Table structure for table `site_task_types`
#

CREATE TABLE `site_task_types` (
  `type_id` int(11) NOT NULL auto_increment,
  `type_name` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`type_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

#
# Dumping data for table `site_task_types`
#

INSERT INTO `site_task_types` VALUES (1, 'Preventative');
INSERT INTO `site_task_types` VALUES (2, 'Emergency');
INSERT INTO `site_task_types` VALUES (3, 'High Priority');
INSERT INTO `site_task_types` VALUES (4, 'Warranty');

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

#
# Table structure for table `site_tasks`
#

CREATE TABLE `site_tasks` (
  `task_id` int(11) NOT NULL auto_increment,
  `task_product` int(11) NOT NULL default '0',
  `task_name` varchar(200) NOT NULL default '',
  `task_description` text NOT NULL,
  `task_date` int(11) NOT NULL default '0',
  `date_enter` int(11) NOT NULL default '0',
  `date_completed` int(11) NOT NULL default '0',
  `task_type` int(11) NOT NULL default '0',
  `task_comments` text NOT NULL,
  `task_vendor` int(11) NOT NULL default '0',
  `task_user` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`task_id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

#
# Dumping data for table `site_tasks`
#

INSERT INTO `site_tasks` VALUES (1, 1, 'Test Task', 'bla bla lba', 1092776400, 0, 0, 1, 'asdfasf', 1, '');
INSERT INTO `site_tasks` VALUES (3, 1, 'last task', '', 1092776400, 0, 0, 1, '', 2, '1');
INSERT INTO `site_tasks` VALUES (4, 2, 'Oil Change', 'Please change the oil', 1092110400, 1092801600, 1092801600, 2, 'OK', 3, '1');
INSERT INTO `site_tasks` VALUES (5, 2, 'Yearly Inspection', 'Inspection by state supervisor', 1092801600, 0, 0, 2, 'Must be completed.', 2, '1');
INSERT INTO `site_tasks` VALUES (6, 2, 'Washing', 'Wash the vehicle.', 1092974400, 1092888000, -1, 1, 'Use wax 4', 6, '1');
INSERT INTO `site_tasks` VALUES (7, 3, 'Oil Change', '', 1093147200, 1092888000, -1, 1, '', 4, '1');
INSERT INTO `site_tasks` VALUES (8, 5, 'Yearly Inespection', 'Yearly inspection by the state SAI worker.', 1093406400, 1092888000, -1, 1, '', 5, '1');
INSERT INTO `site_tasks` VALUES (9, 7, 'Blades Replaced', 'Replace the blades.', 1095566400, 1092888000, -1, 1, '', 3, '1');
INSERT INTO `site_tasks` VALUES (10, 7, 'Cleaning', 'Clean unit.', 1102222800, 1092888000, -1, 1, 'use cloth and ase solution.', 1, '1');
INSERT INTO `site_tasks` VALUES (11, 1, 'Monthly Check', '', 1092974400, 1092888000, -1, 1, '', 3, '1');

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

#
# Table structure for table `site_users`
#

CREATE TABLE `site_users` (
  `user_id` int(11) NOT NULL auto_increment,
  `user_name` varchar(100) NOT NULL default '',
  `user_login` varchar(100) NOT NULL default '',
  `user_password` varchar(100) NOT NULL default '',
  `user_level` int(1) NOT NULL default '0',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `site_users`
#

INSERT INTO `site_users` VALUES (1, 'Jon Doe', 'admin', 'test', 0);
INSERT INTO `site_users` VALUES (2, 'Regular User', 'test', 'test', 1);

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

#
# Table structure for table `site_vars`
#

CREATE TABLE `site_vars` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

#
# Dumping data for table `site_vars`
#

INSERT INTO `site_vars` VALUES (2, 'home', '1');
INSERT INTO `site_vars` VALUES (3, 'title', 'Test Site');

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

#
# Table structure for table `site_vendors`
#

CREATE TABLE `site_vendors` (
  `vendor_id` int(11) NOT NULL auto_increment,
  `vendor_name` varchar(200) NOT NULL default '',
  `vendor_address` text NOT NULL,
  `vendor_phone` varchar(50) NOT NULL default '',
  `vendor_contact` varchar(200) NOT NULL default '',
  `vendor_site` varchar(200) NOT NULL default '',
  `vendor_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vendor_id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

#
# Dumping data for table `site_vendors`
#

INSERT INTO `site_vendors` VALUES (1, 'Test Vendor', '', '', '', '', 1092776400);
INSERT INTO `site_vendors` VALUES (2, 'Another Vendor', '', '', '', '', 1092776400);
INSERT INTO `site_vendors` VALUES (3, 'Joes Equipment', '123 Joe Way', '555-1212', 'Joe', 'www.example.com', 1092801600);
INSERT INTO `site_vendors` VALUES (4, 'ABC Hardware', '', '', '', '', 1092801600);
INSERT INTO `site_vendors` VALUES (5, 'Fabrication Co', '', '', '', '', 1092801600);
INSERT INTO `site_vendors` VALUES (6, 'Acme Mechanic', '', '', '', '', 1092801600);
INSERT INTO `site_vendors` VALUES (7, 'FRJ Works', '', '', '', '', 1092801600);
INSERT INTO `site_vendors` VALUES (8, 'Tulane Auto Sales', '', '1212', '', '', 1092888000);