-- MySQL dump 9.11
--
-- Host: localhost    Database: bugdb
-- ------------------------------------------------------
-- Server version	4.0.24_Debian-10-log

--
-- Table structure for table `Clients`
--

CREATE TABLE `Clients` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `shortcode` varchar(8) default '',
  `is_active` int(1) default '1',
  `color` varchar(8) default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `UserProjects`
--

CREATE TABLE `UserProjects` (
  `id` int(11) NOT NULL auto_increment,
  `project_id` int(11) default '0',
  `user_id` int(11) default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `bugdb`
--

CREATE TABLE `bugdb` (
  `id` int(8) NOT NULL auto_increment,
  `bug_type` varchar(32) default NULL,
  `email` varchar(40) NOT NULL default '',
  `sdesc` varchar(80) NOT NULL default '',
  `ldesc` text NOT NULL,
  `php_version` varchar(100) default NULL,
  `php_os` varchar(32) default NULL,
  `status` varchar(16) default NULL,
  `ts1` datetime default NULL,
  `ts2` datetime default NULL,
  `assign` varchar(40) default NULL,
  `passwd` varchar(20) default NULL,
  `is_public` int(1) default '0',
  `project_id` int(11) default '0',
  PRIMARY KEY  (`id`),
  KEY `php_version` (`php_version`(1)),
  FULLTEXT KEY `email` (`email`,`sdesc`,`ldesc`)
) TYPE=MyISAM;

--
-- Table structure for table `bugdb_autoauth`
--

CREATE TABLE `bugdb_autoauth` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  `user_id` int(11) NOT NULL default '0',
  `ts` datetime default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `bugdb_comments`
--

CREATE TABLE `bugdb_comments` (
  `id` int(8) NOT NULL auto_increment,
  `bug` int(8) NOT NULL default '0',
  `email` varchar(40) NOT NULL default '',
  `ts` datetime NOT NULL default '0000-00-00 00:00:00',
  `comment` text NOT NULL,
  `filename` varchar(255) NOT NULL default '',
  `mimetype` varchar(64) NOT NULL default '',
  `width` int(11) NOT NULL default '0',
  `height` int(11) NOT NULL default '0',
  `filesize` int(11) NOT NULL default '0',
  `is_public` int(1) default '0',
  `user_id` int(11) default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `comment` (`comment`)
) TYPE=MyISAM;

--
-- Table structure for table `bugdb_developers`
--

CREATE TABLE `bugdb_developers` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `group_id` int(11) NOT NULL default '0',
  `is_active` int(1) default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `bugdb_message`
--

CREATE TABLE `bugdb_message` (
  `id` int(11) NOT NULL auto_increment,
  `subject` varchar(255) default NULL,
  `from_address` varchar(255) default NULL,
  `headers` text,
  `body` text,
  `arrived` datetime default NULL,
  `deleted` int(1) default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `bugdb_message_attachment`
--

CREATE TABLE `bugdb_message_attachment` (
  `id` int(11) NOT NULL auto_increment,
  `message_id` int(11) default NULL,
  `mimetype` varchar(64) default NULL,
  `name` varchar(64) default NULL,
  `stored_filename` varchar(128) default NULL,
  PRIMARY KEY  (`id`),
  KEY `mid` (`message_id`)
) TYPE=MyISAM;

--
-- Table structure for table `bugdb_projects`
--

CREATE TABLE `bugdb_projects` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `client` int(11) default '0',
  `date_open` date default NULL,
  `date_close` date default NULL,
  `notes` text,
  `is_active` int(1) default '1',
  `status` varchar(32) default NULL,
  `color` varchar(8) default NULL,
  `releases` text,
  `email` varchar(40) default '',
  `is_public` int(1) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `bugdb_quickfixes`
--

CREATE TABLE `bugdb_quickfixes` (
  `id` int(11) NOT NULL auto_increment,
  `description` varchar(80) NOT NULL default '',
  `to_status` varchar(12) default '',
  `message` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `bugdb_types`
--

CREATE TABLE `bugdb_types` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `is_active` int(1) default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `bugdb_votes`
--

CREATE TABLE `bugdb_votes` (
  `bug` int(8) NOT NULL default '0',
  `ts` timestamp(14) NOT NULL,
  `ip` int(10) unsigned NOT NULL default '0',
  `score` int(3) NOT NULL default '0',
  `reproduced` int(1) NOT NULL default '0',
  `tried` int(1) NOT NULL default '0',
  `sameos` int(1) default NULL,
  `samever` int(1) default NULL
) TYPE=MyISAM;

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `user_name` varchar(32) default '',
  `hashid` varchar(64) default '',
  `title` varchar(128) default '',
  `description` text,
  `location` varchar(128) default '',
  `categories` varchar(255) default '',
  `time_start` datetime default NULL,
  `time_end` datetime default NULL,
  `created_by` int(11) default '0',
  `last_modified` datetime default NULL,
  `color` varchar(8) default '#ffcccc',
  `is_todo` int(11) default '0',
  `project_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;