Login   Register  
PHP Classes
elePHPant
Icontem

File: error_management.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Nadir Latif  >  Error Management  >  error_management.sql  >  Download  
File: error_management.sql
Role: Auxiliary data
Content type: text/plain
Description: database script
Class: Error Management
Report and manage system error occurences
Author: By
Last change: changed the name of a field
Date: 6 years ago
Size: 2,177 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump
-- version 2.9.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Aug 09, 2007 at 09:43 PM
-- Server version: 5.0.37
-- PHP Version: 5.2.1
-- 
-- Database: `error_management`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `error_description`
-- 

DROP TABLE IF EXISTS `error_description`;
CREATE TABLE `error_description` (
  `id` smallint(6) NOT NULL auto_increment,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `error_description`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `error_reports`
-- 

DROP TABLE IF EXISTS `error_reports`;
CREATE TABLE `error_reports` (
  `id` int(11) NOT NULL auto_increment,
  `domain` varchar(255) default NULL,
  `page_url` text,
  `reported_by` varchar(255) default NULL,
  `reported_on` int(11) default NULL,
  `fixed_by` varchar(255) default NULL,
  `fixed_on` int(11) default NULL,
  `time_taken` varchar(20) default NULL,
  `location` varchar(255) default NULL,
  `category` varchar(255) default NULL,
  `description` varchar(255) default NULL,
  `is_browser` varchar(10) default NULL,
  `cause` text,
  `solution` text,
  `severity` varchar(10) default NULL,
  `incorrect_solution` varchar(10) default NULL,
  `owned_by_us` varchar(10) default NULL,
  `reporter_comments` text,
  `error_details` text,
  `fixer_comments` text,
  `is_fixed` varchar(10) default 'false',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `error_reports`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `staff`
-- 

DROP TABLE IF EXISTS `staff`;
CREATE TABLE `staff` (
  `id` smallint(6) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `staff`
--