default.sql in pt_BR for ClinicCases 7.1.3/_INSTALL

-- phpMyAdmin SQL Dump
-- version 3.4.5deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 19, 2012 at 11:40 AM
-- Server version: 5.1.63
-- PHP Version: 5.3.6-13ubuntu3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `default`
--

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

--
-- Table structure for table `cm`
--

CREATE TABLE IF NOT EXISTS `cm` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `clinic_id` VARCHAR(255) NOT NULL,
  `first_name` VARCHAR(100) NOT NULL DEFAULT '',
  `middle_name` VARCHAR(100) NOT NULL DEFAULT '',
  `last_name` VARCHAR(100) NOT NULL DEFAULT '',
  `organization` VARCHAR(250) NOT NULL,
  `date_open` VARCHAR(100) NOT NULL DEFAULT '',
  `date_close` VARCHAR(100) NOT NULL DEFAULT '',
  `case_type` VARCHAR(100) NOT NULL DEFAULT '',
  `clinic_type` VARCHAR(200) NOT NULL,
  `professor` VARCHAR(100) NOT NULL DEFAULT '',
  `address1` VARCHAR(200) NOT NULL DEFAULT '',
  `address2` VARCHAR(200) NOT NULL DEFAULT '',
  `city` VARCHAR(100) NOT NULL DEFAULT '',
  `state` VARCHAR(100) NOT NULL DEFAULT '',
  `zip` VARCHAR(10) NOT NULL DEFAULT '',
  `phone` text NOT NULL,
  `email` text NOT NULL,
  `ssn` VARCHAR(15) NOT NULL DEFAULT '',
  `dob` VARCHAR(15) NOT NULL DEFAULT '',
  `age` VARCHAR(10) NOT NULL DEFAULT '',
  `gender` VARCHAR(10) NOT NULL DEFAULT '',
  `race` VARCHAR(10) NOT NULL DEFAULT '',
  `income` INT(50) DEFAULT NULL,
  `per` VARCHAR(15) NOT NULL,
  `judge` VARCHAR(200) NOT NULL DEFAULT '',
  `pl_or_def` VARCHAR(100) NOT NULL DEFAULT '',
  `court` VARCHAR(200) NOT NULL DEFAULT '',
  `section` VARCHAR(100) NOT NULL DEFAULT '',
  `ct_case_no` VARCHAR(100) NOT NULL DEFAULT '',
  `case_name` VARCHAR(250) NOT NULL DEFAULT '',
  `adverse_parties` text NOT NULL,
  `notes` text NOT NULL,
  `dispo` VARCHAR(100) NOT NULL DEFAULT '',
  `close_notes` text NOT NULL,
  `referral` VARCHAR(100) NOT NULL DEFAULT '',
  `assigned_users` text NOT NULL,
  `opened_by` VARCHAR(50) NOT NULL,
  `time_opened` datetime NOT NULL,
  `closed_by` VARCHAR(50) NOT NULL,
  `time_closed` datetime NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `professor` (`professor`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;


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

--
-- Table structure for table `cm_adverse_parties`
--

CREATE TABLE IF NOT EXISTS `cm_adverse_parties` (
  `id` INT(7) NOT NULL AUTO_INCREMENT,
  `case_id` VARCHAR(100) NOT NULL DEFAULT '',
  `name` VARCHAR(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='used to check for conflicts' AUTO_INCREMENT=1 ;

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

--


--
-- Table structure for table `cm_case_assignees`
--

CREATE TABLE IF NOT EXISTS `cm_case_assignees` (
  `id` INT(100) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(100) NOT NULL DEFAULT '',
  `case_id` VARCHAR(100) NOT NULL DEFAULT '',
  `status` VARCHAR(50) NOT NULL DEFAULT '',
  `date_assigned` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_removed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Determine which students assigned to a case' AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `cm_case_notes`
--

CREATE TABLE IF NOT EXISTS `cm_case_notes` (
  `id` INT(90) NOT NULL AUTO_INCREMENT,
  `case_id` VARCHAR(100) NOT NULL DEFAULT '',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `time` FLOAT NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `username` VARCHAR(100) NOT NULL DEFAULT '',
  `prof` VARCHAR(100) NOT NULL DEFAULT '',
  `datestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `cm_case_types`
--

CREATE TABLE IF NOT EXISTS `cm_case_types` (
  `id` INT(7) NOT NULL AUTO_INCREMENT,
  `type` VARCHAR(200) NOT NULL DEFAULT '',
  `case_type_code` VARCHAR(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `cm_case_types`
--

INSERT INTO `cm_case_types` (`id`, `type`, `case_type_code`) VALUES
(1, 'Criminal', 'CRM'),
(2, 'Personalidade', 'PRS'),
(3, 'Indenizacao', 'IND'),
(4, 'Divorcio', 'DIV');

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

--
-- Table structure for table `cm_clinic_type`
--

CREATE TABLE IF NOT EXISTS `cm_clinic_type` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `clinic_name` text NOT NULL,
  `clinic_code` VARCHAR(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `cm_clinic_type`
--

INSERT INTO `cm_clinic_type` (`id`, `clinic_name`, `clinic_code`) VALUES
(1, 'Familia', 'FAM'),
(2, 'Consumidor', 'CON'),
(3, 'Saude', 'SDE'),
(4, 'Criminal', 'CRM');

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

--
-- Table structure for table `cm_columns`
--

CREATE TABLE IF NOT EXISTS `cm_columns` (
  `id` INT(7) NOT NULL AUTO_INCREMENT,
  `db_name` VARCHAR(50) NOT NULL,
  `display_name` VARCHAR(50) NOT NULL,
  `include_in_case_table` VARCHAR(10) NOT NULL COMMENT 'Should this column be included into the data sent to the main case table?',
  `input_type` VARCHAR(10) NOT NULL,
  `select_options` text NOT NULL,
  `display_by_default` VARCHAR(10) NOT NULL COMMENT 'Should this column be displayed to the case table user by default?',
  `required` INT(11) NOT NULL DEFAULT '0' COMMENT 'ClinicCases cannot function without this field',
  `display_order` INT(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Defines the columns to be used in ClinicCases cases table' AUTO_INCREMENT=45 ;

--
-- Dumping data for table `cm_columns`
--

INSERT INTO `cm_columns` (`id`, `db_name`, `display_name`, `include_in_case_table`, `input_type`, `select_options`, `display_by_default`, `required`, `display_order`) VALUES
(2, 'id', 'Id', 'true', 'text', '', 'false', 1, 2),
(3, 'clinic_id', 'Caso numero', 'true', 'text', '', 'false', 1, 3),
(4, 'first_name', 'Primeiro nome', 'true', 'text', '', 'true', 1, 4),
(5, 'middle_name', 'Nome do meio', 'true', 'text', '', 'false', 1, 5),
(6, 'last_name', 'Sobrenome', 'true', 'text', '', 'true', 1, 6),
(7, 'organization', 'Organizacao', 'true', 'text', '', 'false', 1, 7),
(8, 'date_open', 'Data de abertura', 'true', 'date', '', 'true', 1, 8),
(9, 'date_close', 'Data de encerramento', 'true', 'date', '', 'true', 1, 41),
(10, 'case_type', 'Tipo do caso', 'true', 'text', '', 'true', 1, 10),
(44, 'assigned_users', 'Usuarios', 'true', 'text', '', 'false', 0, 41),
(41, 'adverse_parties', 'Parte adversa', 'true', 'multi-text', '', 'false', 1, 33),
(11, 'clinic_type', 'Tipo do caso', 'true', 'text', '', 'false', 0, 11),
(12, 'address1', 'Endereco 1', 'false', 'text', '', 'false', 0, 12),
(13, 'address2', 'Endereco 2', 'false', 'text', '', 'false', 0, 13),
(14, 'city', 'Cidade', 'false', 'text', '', 'false', 0, 14),
(15, 'state', 'Estado', 'false', 'text', '', 'false', 0, 15),
(16, 'zip', 'CEP', 'false', 'text', '', 'false', 0, 16),
(17, 'phone', 'Telefone', 'true', 'dual', 'a:5:{s:4:"home";s:4:"Casa";s:4:"work";s:8:"Trabalho";s:6:"mobile";s:7:"Celular";s:3:"fax";s:3:"Fax";s:5:"other";s:5:"Outro";}', 'false', 1, 17),
(19, 'email', 'E-mail', 'true', 'dual', 'a:3:{s:4:"Home";s:4:"Casa";s:4:"Work";s:8:"Trabalho";s:5:"Other";s:5:"Other";}', 'false', 1, 19),
(20, 'ssn', 'PIS', 'true', 'text', '', 'false', 0, 20),
(21, 'dob', 'Nascimento', 'true', 'text', '', 'false', 0, 21),
(22, 'age', 'Idade', 'true', 'text', '', 'false', 0, 22),
(23, 'gender', 'Genero', 'true', 'select', 'a:2:{s:1:"M";s:5:"Homem";s:1:"F";s:6:"Mulher";}', 'false', 0, 23),
(24, 'race', 'Etnia', 'true', 'select', 'a:4:{s:2:"NE";s:5:"Negro";s:1:"B";s:9:"Caucasiano";s:1:"A";s:8:"Asiatico";s:1:"O";s:5:"Outro";}', 'false', 0, 24),
(25, 'income', 'Renda', 'false', 'text', '', 'false', 0, 25),
(26, 'per', 'Por', 'false', 'select', 'a:4:{s:3:"day";s:3:"Dia";s:4:"week";s:6:"Semana";s:5:"month";s:3:"Mes";s:4:"year";s:3:"Ano";}', 'false', 0, 26),
(27, 'judge', 'Julgador', 'false', 'text', '', 'false', 0, 27),
(28, 'pl_or_def', 'Autor ou Reu', 'false', 'select', 'a:3:{s:9:"plaintiff";s:5:"Autor";s:9:"defendant";s:3:"Reu";s:5:"other";s:5:"Outro";}', 'false', 0, 28),
(29, 'court', 'Juizo', 'true', 'text', '', 'false', 0, 29),
(30, 'section', 'Vara/Camara', 'false', 'text', '', 'false', 0, 30),
(31, 'ct_case_no', 'Numero dos autos', 'false', 'text', '', 'false', 0, 31),
(32, 'case_name', 'Nome do caso', 'false', 'text', '', 'false', 0, 32),
(33, 'notes', 'Anotacoes', 'false', 'textarea', '', 'false', 0, 33),
(36, 'Como acabou', 'Disposition', 'true', 'text', '', 'true', 0, 42),
(38, 'close_notes', 'Anotacoes de encerramento', 'false', 'textarea', '', 'false', 0, 44),
(39, 'referral', 'Veio a nos por', 'true', 'text', '', 'false', 0, 39),
(40, 'opened_by', 'Atendido por', 'true', 'text', '', 'true', 1, 40);

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

--
-- Table structure for table `cm_contacts`
--

CREATE TABLE IF NOT EXISTS `cm_contacts` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `first_name` VARCHAR(100) NOT NULL DEFAULT '',
  `last_name` VARCHAR(100) NOT NULL DEFAULT '',
  `organization` VARCHAR(200) NOT NULL,
  `type` VARCHAR(50) NOT NULL DEFAULT '',
  `address` text NOT NULL,
  `city` VARCHAR(100) NOT NULL DEFAULT '',
  `state` CHAR(2) NOT NULL DEFAULT '',
  `zip` VARCHAR(10) NOT NULL DEFAULT '',
  `phone` text NOT NULL,
  `email` text NOT NULL,
  `url` text NOT NULL,
  `notes` text NOT NULL,
  `assoc_case` VARCHAR(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `cm_contacts_types`
--

CREATE TABLE IF NOT EXISTS `cm_contacts_types` (
  `id` INT(7) NOT NULL AUTO_INCREMENT,
  `type` VARCHAR(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `cm_contacts_types`
--

INSERT INTO `cm_contacts_types` (`id`, `type`) VALUES
(1, 'Testemunha'),
(2, 'Advogado da parte adversa'),
(3, 'Parte adversa'),
(4, 'Parente ou amigo do cliente'),
(5, 'Perito'),
(6, 'Outro');

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

--
-- Table structure for table `cm_courts`
--

CREATE TABLE IF NOT EXISTS `cm_courts` (
  `id` INT(7) NOT NULL AUTO_INCREMENT,
  `court` VARCHAR(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `cm_courts`
--

INSERT INTO `cm_courts` (`id`, `court`) VALUES
(1, 'Justica Comum'),
(2, 'Juizado Especial ');

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

--
-- Table structure for table `cm_dispos`
--

CREATE TABLE IF NOT EXISTS `cm_dispos` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `dispo` VARCHAR(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `cm_dispos`
--

INSERT INTO `cm_dispos` (`id`, `dispo`) VALUES
(1, 'Apenas aconselhamento'),
(2, 'Julgado'),
(3, 'Exito'),
(4, 'Reves'),
(5, 'Cliente desistiu');

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

--
-- Table structure for table `cm_documents`
--

CREATE TABLE IF NOT EXISTS `cm_documents` (
  `id` INT(100) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(200) NOT NULL DEFAULT '',
  `local_file_name` VARCHAR(200) NOT NULL DEFAULT '',
  `extension` VARCHAR(10) NOT NULL,
  `folder` VARCHAR(100) NOT NULL DEFAULT '',
  `containing_folder` VARCHAR(100) NOT NULL,
  `text` text NOT NULL,
  `write_permission` VARCHAR(500) NOT NULL,
  `username` VARCHAR(100) NOT NULL DEFAULT '',
  `case_id` VARCHAR(100) NOT NULL DEFAULT '',
  `date_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `cm_events`
--

CREATE TABLE IF NOT EXISTS `cm_events` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `case_id` VARCHAR(100) NOT NULL DEFAULT '',
  `set_by` VARCHAR(100) NOT NULL DEFAULT '',
  `task` VARCHAR(225) NOT NULL DEFAULT '',
  `date_set` DATE NOT NULL DEFAULT '0000-00-00',
  `start` datetime NOT NULL,
  `start_text` VARCHAR(200) NOT NULL,
  `end_text` VARCHAR(200) NOT NULL,
  `end` datetime DEFAULT NULL,
  `all_day` tinyint(1) NOT NULL,
  `status` VARCHAR(100) NOT NULL DEFAULT '',
  `notes` text NOT NULL,
  `location` text NOT NULL,
  `prof` VARCHAR(200) NOT NULL DEFAULT '',
  `archived` VARCHAR(10) NOT NULL DEFAULT 'n',
  `time_added` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `cm_events_responsibles`
--

CREATE TABLE IF NOT EXISTS `cm_events_responsibles` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `event_id` VARCHAR(100) NOT NULL DEFAULT '',
  `username` VARCHAR(100) NOT NULL DEFAULT '',
  `time_added` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Linked to cm_events; who is responsible for each event' AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `cm_groups`
--

CREATE TABLE IF NOT EXISTS `cm_groups` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `group_name` VARCHAR(50) NOT NULL,
  `group_title` VARCHAR(100) NOT NULL,
  `group_description` text NOT NULL,
  `allowed_tabs` VARCHAR(500) NOT NULL COMMENT 'An object which controls which tabs the user is allowed to see.',
  `add_cases` INT(2) NOT NULL,
  `delete_cases` INT(2) NOT NULL,
  `edit_cases` INT(2) NOT NULL,
  `close_cases` INT(2) NOT NULL,
  `view_all_cases` INT(2) NOT NULL COMMENT 'User can view all cases or only cases to which they are assigned',
  `assign_cases` INT(2) NOT NULL COMMENT 'Can the user assign cases to users?',
  `view_users` INT(2) NOT NULL,
  `add_users` INT(2) NOT NULL,
  `delete_users` INT(2) NOT NULL,
  `edit_users` INT(2) NOT NULL,
  `activate_users` INT(2) NOT NULL,
  `add_case_notes` INT(2) NOT NULL,
  `edit_case_notes` INT(2) NOT NULL,
  `delete_case_notes` INT(2) NOT NULL,
  `documents_upload` INT(2) NOT NULL,
  `documents_modify` INT(2) NOT NULL,
  `add_events` INT(2) NOT NULL,
  `edit_events` INT(2) NOT NULL,
  `delete_events` INT(2) NOT NULL,
  `add_contacts` INT(2) NOT NULL,
  `edit_contacts` INT(2) NOT NULL,
  `delete_contacts` INT(2) NOT NULL,
  `post_in_board` INT(2) NOT NULL,
  `view_board` INT(2) NOT NULL,
  `edit_posts` INT(2) NOT NULL,
  `reads_journals` INT(2) NOT NULL,
  `writes_journals` INT(2) NOT NULL,
  `change_permissions` INT(2) NOT NULL,
  `can_configure` INT(2) NOT NULL,
  `supervises` INT(2) NOT NULL COMMENT 'The user has other users under him who he supervises, e.g, students, associates',
  `is_supervised` INT(2) NOT NULL COMMENT 'This user works on cases,but is supervised by another user',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Allows admin to create user groups and set definitions' AUTO_INCREMENT=5 ;

--
-- Dumping data for table `cm_groups`
--

INSERT INTO `cm_groups` (`id`, `group_name`, `group_title`, `group_description`, `allowed_tabs`, `add_cases`, `delete_cases`, `edit_cases`, `close_cases`, `view_all_cases`, `assign_cases`, `view_users`, `add_users`, `delete_users`, `edit_users`, `activate_users`, `add_case_notes`, `edit_case_notes`, `delete_case_notes`, `documents_upload`, `documents_modify`, `add_events`, `edit_events`, `delete_events`, `add_contacts`, `edit_contacts`, `delete_contacts`, `post_in_board`, `view_board`, `edit_posts`, `reads_journals`, `writes_journals`, `change_permissions`, `can_configure`, `supervises`, `is_supervised`) VALUES
(1, 'super', 'Super User', 'The super user can access all ClinicCases functions and add, edit, and delete all data.  Most importantly, only the super user can change permissions for all users.\r\nSuper User access should be restricted to a limited number of users.', 'a:8:{i:0;s:4:"Home";i:1;s:5:"Cases";i:2;s:5:"Group";i:3;s:5:"Users";i:4;s:8:"Journals";i:5;s:5:"Board";i:6;s:9:"Utilities";i:7;s:8:"Messages";}', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0),
(2, 'admin', 'Administrador', 'The administrator can access all ClinicCases functions and view,edit, and delete all data.  By default, the administrator is the only user who can add new files or authorize new users.\r\n\r\nThe administrator cannot change group permissions.', 'a:6:{i:0;s:4:"Home";i:1;s:5:"Cases";i:2;s:5:"Users";i:3;s:5:"Board";i:4;s:9:"Utilities";i:5;s:8:"Messages";}', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 1, 0, 0),
(3, 'student', 'Aluno', 'Students can only access the cases to which they have been assigned by a professor.', 'a:6:{i:0;s:4:"Home";i:1;s:5:"Cases";i:2;s:8:"Journals";i:3;s:5:"Board";i:4;s:9:"Utilities";i:5;s:8:"Messages";}', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 1),
(4, 'prof', 'Professor', 'Professors supervise students.  By default, they can assign students to cases and view, edit, and delete all data in cases to which they are assigned.', 'a:7:{i:0;s:4:"Home";i:1;s:5:"Cases";i:2;s:5:"Group";i:3;s:8:"Journals";i:4;s:5:"Board";i:5;s:9:"Utilities";i:6;s:8:"Messages";}', 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 1, 0);

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

--
-- Table structure for table `cm_journals`
--

CREATE TABLE IF NOT EXISTS `cm_journals` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(100) NOT NULL DEFAULT '',
  `reader` text NOT NULL,
  `text` text NOT NULL,
  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `archived` text NOT NULL,
  `read` text NOT NULL,
  `commented` VARCHAR(10) NOT NULL DEFAULT '',
  `comments` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `cm_logs`
--

CREATE TABLE IF NOT EXISTS `cm_logs` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(100) NOT NULL DEFAULT '',
  `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` VARCHAR(20) NOT NULL DEFAULT '',
  `session_id` VARCHAR(200) NOT NULL DEFAULT '',
  `type` VARCHAR(200) NOT NULL DEFAULT '',
  `last_msg_check` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `cm_messages`
--

CREATE TABLE IF NOT EXISTS `cm_messages` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `thread_id` VARCHAR(100) NOT NULL DEFAULT '',
  `to` text NOT NULL,
  `from` VARCHAR(100) NOT NULL DEFAULT '',
  `ccs` text,
  `subject` VARCHAR(100) NOT NULL DEFAULT '',
  `body` text NOT NULL,
  `assoc_case` VARCHAR(100) NOT NULL DEFAULT '',
  `time_sent` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `read` text NOT NULL,
  `archive` text NOT NULL,
  `starred` text NOT NULL,
  `to_text` text NOT NULL,
  `cc_text` text NOT NULL,
  `assoc_case_text` text NOT NULL,
  `time_sent_text` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `cm_referral`
--

CREATE TABLE IF NOT EXISTS `cm_referral` (
  `id` INT(7) NOT NULL AUTO_INCREMENT,
  `referral` VARCHAR(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4;

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

--
-- Table structure for table `cm_users`
--

CREATE TABLE IF NOT EXISTS `cm_users` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `first_name` VARCHAR(100) NOT NULL DEFAULT '',
  `last_name` VARCHAR(100) NOT NULL DEFAULT '',
  `email` VARCHAR(100) NOT NULL DEFAULT '',
  `mobile_phone` VARCHAR(15) NOT NULL DEFAULT '',
  `office_phone` VARCHAR(25) NOT NULL DEFAULT '',
  `home_phone` VARCHAR(15) NOT NULL DEFAULT '',
  `grp` VARCHAR(20) NOT NULL DEFAULT '',
  `username` VARCHAR(25) NOT NULL DEFAULT '',
  `password` VARCHAR(100) NOT NULL DEFAULT '',
  `supervisors` text NOT NULL,
  `picture_url` VARCHAR(200) NOT NULL DEFAULT 'people/no_picture.png',
  `timezone_offset` VARCHAR(5) NOT NULL DEFAULT '1',
  `status` VARCHAR(100) NOT NULL DEFAULT 'inactive',
  `new` VARCHAR(20) NOT NULL DEFAULT '',
  `date_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pref_case` VARCHAR(10) NOT NULL DEFAULT 'on',
  `pref_journal` VARCHAR(10) NOT NULL DEFAULT '',
  `pref_case_prof` VARCHAR(10) NOT NULL DEFAULT 'on' COMMENT 'does professor work on cases',
  `evals` text NOT NULL,
  `private_key` VARCHAR(50) NOT NULL DEFAULT '',
  `force_new_password` INT(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `cm_users`
--

INSERT INTO `cm_users` (`id`, `first_name`, `last_name`, `email`, `mobile_phone`, `office_phone`, `home_phone`, `grp`, `username`, `password`, `supervisors`, `picture_url`, `timezone_offset`, `status`, `new`, `date_created`, `pref_case`, `pref_journal`, `pref_case_prof`, `evals`, `private_key`, `force_new_password`) VALUES
(1, 'Temp', 'Admin', '', '', '', '', 'admin', 'admin', '21232f297a57a5a743894a0e4a801fc3', '', 'people/no_picture.png', '1', 'active', '', '2012-07-02 14:57:44', 'on', '', 'on', '', '', 1);

--
-- Table structure for table `cm_board`
--

CREATE TABLE IF NOT EXISTS `cm_board` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(500) NOT NULL,
  `body` text NOT NULL,
  `color` VARCHAR(50) NOT NULL,
  `author` VARCHAR(250) NOT NULL,
  `time_added` datetime NOT NULL,
  `time_edited` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `cm_board_attachments`
--

CREATE TABLE IF NOT EXISTS `cm_board_attachments` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(500) NOT NULL,
  `local_file_name` VARCHAR(200) NOT NULL,
  `extension` VARCHAR(10) NOT NULL,
  `username` VARCHAR(200) NOT NULL,
  `post_id` INT(11) NOT NULL,
  `time_added` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `cm_board_viewers` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `post_id` INT(11) NOT NULL,
  `viewer` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;