-- phpMyAdmin SQL Dump
-- version 3.1.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 04, 2009 at 11:40 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.6

SET FOREIGN_KEY_CHECKS=0;

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT=0;
START TRANSACTION;

--
-- Database: `bugs`
--

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

--
-- Table structure for table `bug_severity`
--
-- Creation: Feb 04, 2009 at 11:28 AM
--

DROP TABLE IF EXISTS `bug_severity`;
CREATE TABLE IF NOT EXISTS `bug_severity` (
  `id` smallint(6) NOT NULL auto_increment,
  `value` varchar(64) NOT NULL,
  `sortkey` smallint(6) NOT NULL default '0',
  `isactive` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `bug_severity_value_idx` (`value`),
  KEY `bug_severity_sortkey_idx` (`sortkey`,`value`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `bug_severity`
--

INSERT INTO `bug_severity` (`id`, `value`, `sortkey`, `isactive`) VALUES
(2, 'S1 Critical', 200, 1),
(3, 'S2 High', 300, 1),
(4, 'S3 Medium', 400, 1),
(5, 'S4 Low', 500, 1),
(7, 'SE Enh', 700, 1);

SET FOREIGN_KEY_CHECKS=1;

COMMIT;