gistfile1.sql

--
-- Table structure for table `charges`
--

DROP TABLE IF EXISTS `charges`;
CREATE TABLE IF NOT EXISTS `charges` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `record_id` int(11) NOT NULL DEFAULT '0',
  `w_no` varchar(15) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `j_no` varchar(15) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `court_id` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `case_no` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `code` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT '' COMMENT 'Charge Type/Code',
  `description` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `status` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `record_id` (`record_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `courts`
--

DROP TABLE IF EXISTS `courts`;
CREATE TABLE IF NOT EXISTS `courts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(5) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `name` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `slug` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `code` (`code`,`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `filters`
--

DROP TABLE IF EXISTS `filters`;
CREATE TABLE IF NOT EXISTS `filters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `human_name` varchar(255) CHARACTER SET latin1 NOT NULL,
  `slug` varchar(255) CHARACTER SET latin1 NOT NULL,
  `options` text CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `records`
--

DROP TABLE IF EXISTS `records`;
CREATE TABLE IF NOT EXISTS `records` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `booking_no` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `causes` enum('probation','warrant','other','') CHARACTER SET latin1 NOT NULL DEFAULT '',
  `first_name` varchar(50) CHARACTER SET latin1 NOT NULL,
  `last_name` varchar(50) CHARACTER SET latin1 NOT NULL,
  `race` varchar(10) CHARACTER SET latin1 NOT NULL,
  `sex` enum('M','F','O') CHARACTER SET latin1 NOT NULL DEFAULT 'O' COMMENT 'Male, Female, Other',
  `date_of_birth` date NOT NULL DEFAULT '0000-00-00',
  `address` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `city` varchar(255) CHARACTER SET latin1 NOT NULL,
  `state` char(2) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `zipcode` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `attorney` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `booking_no` (`booking_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;