-- http://www.phpmyadmin.net
--




--
-- Database: `help_to_care`
--

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

--
-- Table structure for table `calendar`
--

CREATE TABLE IF NOT EXISTS `calendar` (
  `calendarid` int(11) NOT NULL AUTO_INCREMENT,
  `calendar_name` varchar(60) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`calendarid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `calendar`
--

INSERT INTO `calendar` (`calendarid`, `calendar_name`, `created`, `userid_created`, `updated`, `userid_updated`, `rec_status`) VALUES
(21, 'Calendar', '2013-06-14 12:15:03', 7, '0000-00-00 00:00:00', 0, 1),
(22, 'Calendar', '2013-06-14 12:16:59', 8, '0000-00-00 00:00:00', 0, 1),
(23, 'Calendar', '2013-06-14 13:05:23', 8, '0000-00-00 00:00:00', 0, 1),
(24, 'Calendar', '2013-06-14 18:54:05', 7, '0000-00-00 00:00:00', 0, 1);

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

--
-- Table structure for table `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `contactid` int(11) NOT NULL AUTO_INCREMENT,
  `contact_name` varchar(50) DEFAULT NULL,
  `business_name` varchar(100) DEFAULT NULL,
  `contact_category` varchar(50) DEFAULT NULL,
  `email_address1` varchar(50) DEFAULT NULL,
  `mobile_number` varchar(50) DEFAULT NULL,
  `work_number` varchar(50) DEFAULT NULL,
  `work_city` varchar(255) DEFAULT NULL,
  `work_state` varchar(255) DEFAULT NULL,
  `work_zip` varchar(255) DEFAULT NULL,
  `work_address` varchar(255) DEFAULT NULL,
  `home_address` varchar(255) DEFAULT NULL,
  `home_city` varchar(255) DEFAULT NULL,
  `home_state` varchar(255) DEFAULT NULL,
  `home_zip` varchar(255) DEFAULT NULL,
  `home_page` varchar(100) DEFAULT NULL,
  `contact_notes` text,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` int(1) DEFAULT '1',
  PRIMARY KEY (`contactid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `contact_group`
--

CREATE TABLE IF NOT EXISTS `contact_group` (
  `contact_groupid` int(11) NOT NULL AUTO_INCREMENT,
  `contact_group_name` varchar(60) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`contact_groupid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `contact_group`
--

INSERT INTO `contact_group` (`contact_groupid`, `contact_group_name`, `created`, `userid_created`, `updated`, `userid_updated`, `rec_status`) VALUES
(21, 'Contacts', '2013-06-14 12:15:03', 7, '0000-00-00 00:00:00', 0, 1),
(22, 'Contacts', '2013-06-14 12:16:59', 8, '0000-00-00 00:00:00', 0, 1),
(23, 'Contacts', '2013-06-14 13:05:24', 8, '0000-00-00 00:00:00', 0, 1),
(24, 'Contacts', '2013-06-14 18:54:06', 7, '0000-00-00 00:00:00', 0, 1);

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

--
-- Table structure for table `document`
--

CREATE TABLE IF NOT EXISTS `document` (
  `documentid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT 'It stores the name of document entered by user',
  `file_name` varchar(255) DEFAULT NULL COMMENT 'It sotres the file name in server.',
  `document_description` varchar(100) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` int(1) DEFAULT '1',
  PRIMARY KEY (`documentid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `document`
--

INSERT INTO `document` (`documentid`, `name`, `file_name`, `document_description`, `created`, `userid_created`, `updated`, `userid_updated`, `rec_status`) VALUES
(12, 'Raaphat', '8_1371214077.png', 'Thi is idnoif', '2013-06-14 12:47:57', 8, '0000-00-00 00:00:00', 0, 1),
(15, 'Raaphat', '8_1371483765.txt', 'Desc doc24', '2013-06-17 13:57:29', 8, '2013-06-17 15:42:45', 8, 1),
(16, 'doc22345', '8_1371483797.pdf', 'Thi is idnoi', '2013-06-17 13:58:51', 8, '2013-06-17 15:44:13', 8, 1);

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

--
-- Table structure for table `document_group`
--

CREATE TABLE IF NOT EXISTS `document_group` (
  `document_groupid` int(11) NOT NULL AUTO_INCREMENT,
  `document_group_name` varchar(60) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` int(1) DEFAULT '1',
  PRIMARY KEY (`document_groupid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `document_group`
--

INSERT INTO `document_group` (`document_groupid`, `document_group_name`, `created`, `userid_created`, `updated`, `userid_updated`, `rec_status`) VALUES
(8, 'Documents2', '2013-06-14 12:15:03', 7, '2013-06-14 12:22:18', 0, 1),
(9, 'Documents2', '2013-06-14 12:17:00', 8, '2013-06-14 14:10:45', 0, 1),
(10, 'Documents', '2013-06-14 13:05:24', 8, '0000-00-00 00:00:00', 0, 1),
(11, 'Documents', '2013-06-14 18:54:06', 7, '0000-00-00 00:00:00', 0, 1);

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

--
-- Table structure for table `events`
--

CREATE TABLE IF NOT EXISTS `events` (
  `eventid` int(11) NOT NULL AUTO_INCREMENT,
  `event_name` varchar(255) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `where` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `color` varchar(7) NOT NULL,
  `is_all_day` tinyint(4) NOT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`eventid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `folders`
--

CREATE TABLE IF NOT EXISTS `folders` (
  `folderid` int(11) NOT NULL AUTO_INCREMENT,
  `folder_name` varchar(255) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`folderid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `folders`
--

INSERT INTO `folders` (`folderid`, `folder_name`, `created`, `userid_created`, `updated`, `userid_updated`, `rec_status`) VALUES
(7, 'Profiles', '2013-06-14 12:15:03', 7, '0000-00-00 00:00:00', 0, 1),
(8, 'Profiles', '2013-06-14 12:16:59', 8, '0000-00-00 00:00:00', 0, 1);

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

--
-- Table structure for table `medication`
--

CREATE TABLE IF NOT EXISTS `medication` (
  `medicationid` int(11) NOT NULL AUTO_INCREMENT,
  `med_name` varchar(100) DEFAULT NULL,
  `generic_name` varchar(100) DEFAULT NULL,
  `dosage` varchar(100) DEFAULT NULL,
  `dosage_frequency` varchar(100) DEFAULT NULL,
  `med_notes` text,
  `physician` varchar(100) DEFAULT NULL,
  `date_prescribed` date DEFAULT NULL,
  `pharmacy` varchar(100) DEFAULT NULL,
  `symptoms_address` text,
  `side_effects` text,
  `drug_interactions` text,
  `physical_desc` varchar(255) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` int(1) DEFAULT '1',
  PRIMARY KEY (`medicationid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `medication_group`
--

CREATE TABLE IF NOT EXISTS `medication_group` (
  `medication_groupid` int(11) NOT NULL AUTO_INCREMENT,
  `medication_group_name` varchar(60) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` int(1) DEFAULT '1',
  PRIMARY KEY (`medication_groupid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `medication_group`
--

INSERT INTO `medication_group` (`medication_groupid`, `medication_group_name`, `created`, `userid_created`, `updated`, `userid_updated`, `rec_status`) VALUES
(20, 'Medications', '2013-06-14 12:15:03', 7, '0000-00-00 00:00:00', 0, 1),
(21, 'Medications', '2013-06-14 12:16:59', 8, '0000-00-00 00:00:00', 0, 1),
(22, 'Medications', '2013-06-14 13:05:23', 8, '0000-00-00 00:00:00', 0, 1),
(23, 'Medications', '2013-06-14 18:54:06', 7, '0000-00-00 00:00:00', 0, 1);

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

--
-- Table structure for table `person`
--

CREATE TABLE IF NOT EXISTS `person` (
  `personid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_userid` int(11) DEFAULT '0',
  `first_name` varchar(128) CHARACTER SET latin1 DEFAULT NULL,
  `last_name` varchar(128) CHARACTER SET latin1 DEFAULT NULL,
  `phone_main` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `phone_mobile` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `phone_emergency` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `address1` varchar(60) CHARACTER SET latin1 DEFAULT NULL,
  `address2` varchar(60) CHARACTER SET latin1 DEFAULT NULL,
  `city` varchar(60) CHARACTER SET latin1 DEFAULT NULL,
  `state` varchar(2) CHARACTER SET latin1 DEFAULT NULL,
  `zipcode` varchar(16) CHARACTER SET latin1 DEFAULT NULL,
  `email_primary` varchar(128) CHARACTER SET latin1 DEFAULT NULL,
  `email_secondary` varchar(128) CHARACTER SET latin1 DEFAULT NULL,
  `notes` text CHARACTER SET latin1,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`personid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `person`
--

INSERT INTO `person` (`personid`, `fk_userid`, `first_name`, `last_name`, `phone_main`, `phone_mobile`, `phone_emergency`, `address1`, `address2`, `city`, `state`, `zipcode`, `email_primary`, `email_secondary`, `notes`, `created`, `userid_created`, `updated`, `userid_updated`, `rec_status`) VALUES
(20, 7, 'mindfire', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2013-06-14 12:15:03', 7, '0000-00-00 00:00:00', 0, 1),
(21, 8, 'mindfre', '2', '', '', '', '', '', '', '', '', '', '', '', '2013-06-14 12:16:59', 8, '2013-06-14 12:49:15', 8, 1),
(22, 0, 'Person', '1', '', '', '', '', '', '', '', '', '', '', '', '2013-06-14 13:05:23', 8, '0000-00-00 00:00:00', 0, 1),
(23, 0, 'Mark', 'Boucher', '', '', '', '', '', '', '', '', '', '', '', '2013-06-14 18:54:05', 7, '0000-00-00 00:00:00', 0, 1);

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

--
-- Table structure for table `post`
--

CREATE TABLE IF NOT EXISTS `post` (
  `postid` int(11) NOT NULL AUTO_INCREMENT,
  `post` text,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(2) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(2) DEFAULT '0',
  `rec_status` int(1) DEFAULT '1',
  PRIMARY KEY (`postid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `post`
--

INSERT INTO `post` (`postid`, `post`, `created`, `userid_created`, `updated`, `userid_updated`, `rec_status`) VALUES
(9, 'test1', '2013-06-14 14:30:51', 8, '0000-00-00 00:00:00', 0, 1),
(10, 'Test2', '2013-06-14 14:30:58', 8, '0000-00-00 00:00:00', 0, 1),
(11, 'Test3', '2013-06-14 14:31:06', 8, '0000-00-00 00:00:00', 0, 1),
(12, 'test4', '2013-06-14 14:31:16', 8, '0000-00-00 00:00:00', 0, 1);

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

--
-- Table structure for table `provider`
--

CREATE TABLE IF NOT EXISTS `provider` (
  `providerid` int(11) NOT NULL AUTO_INCREMENT,
  `provider_name` varchar(128) DEFAULT NULL,
  `fk_userid` int(11) DEFAULT '0',
  `provider_descr` varchar(128) DEFAULT NULL,
  `phone_main` varchar(30) DEFAULT NULL,
  `phone_mobile` varchar(30) DEFAULT NULL,
  `phone_emergency` varchar(30) DEFAULT NULL,
  `address1` varchar(72) DEFAULT NULL,
  `address2` varchar(72) DEFAULT NULL,
  `city` varchar(60) DEFAULT NULL,
  `state` varchar(30) DEFAULT NULL,
  `zipcode` varchar(16) DEFAULT NULL,
  `email_primary` varchar(60) DEFAULT NULL,
  `email_secondary` varchar(60) DEFAULT NULL,
  `notes` text,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`providerid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `resource`
--

CREATE TABLE IF NOT EXISTS `resource` (
  `resourceid` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `fk_type_recid` int(11) DEFAULT NULL,
  `fk_userid_owner` int(11) DEFAULT NULL,
  `fk_resourceid_parent` int(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`resourceid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=170 ;

--
-- Dumping data for table `resource`
--

INSERT INTO `resource` (`resourceid`, `type`, `description`, `fk_type_recid`, `fk_userid_owner`, `fk_resourceid_parent`, `created`, `userid_created`, `updated`, `userid_updated`, `rec_status`) VALUES
(138, 'folder', 'Profiles', 7, 7, 0, '2013-06-14 12:15:03', 7, '2013-06-14 12:15:03', 0, 1),
(139, 'person', 'mindfire 1', 20, 7, 138, '2013-06-14 12:15:03', 7, '2013-06-14 12:15:03', 0, 1),
(140, 'calendar', 'Calendar', 21, 7, 139, '2013-06-14 12:15:03', 7, '2013-06-14 12:15:03', 0, 1),
(141, 'medication_group', 'Medications', 20, 7, 139, '2013-06-14 12:15:03', 7, '2013-06-14 12:15:03', 0, 1),
(142, 'contact_group', 'Contacts', 21, 7, 139, '2013-06-14 12:15:03', 7, '2013-06-14 12:15:03', 0, 1),
(143, 'task_group', 'Tasks', 39, 7, 139, '2013-06-14 12:15:03', 7, '2013-06-14 12:15:03', 0, 1),
(144, 'document_group', 'Documents2', 8, 7, 139, '2013-06-14 12:15:03', 7, '2013-06-14 14:11:03', 0, 1),
(145, 'folder', 'Profiles', 8, 8, 0, '2013-06-14 12:16:59', 8, '2013-06-14 12:16:59', 0, 1),
(146, 'person', 'mindfre 2', 21, 8, 145, '2013-06-14 12:16:59', 8, '2013-06-14 12:49:15', 0, 1),
(147, 'calendar', 'Calendar', 22, 8, 146, '2013-06-14 12:16:59', 8, '2013-06-14 12:16:59', 0, 1),
(148, 'medication_group', 'Medications', 21, 8, 146, '2013-06-14 12:16:59', 8, '2013-06-14 12:16:59', 0, 1),
(149, 'contact_group', 'Contacts', 22, 8, 146, '2013-06-14 12:16:59', 8, '2013-06-14 12:16:59', 0, 1),
(150, 'task_group', 'Tasks', 40, 8, 146, '2013-06-14 12:17:00', 8, '2013-06-14 12:17:00', 0, 1),
(151, 'document_group', 'Documents2', 9, 8, 146, '2013-06-14 12:17:00', 8, '2013-06-14 14:10:45', 0, 1),
(152, 'document', 'Thi is idnoif', 12, 8, 144, '2013-06-14 12:47:57', 8, '2013-06-14 12:47:57', 0, 1),
(153, 'person', 'Person 1', 22, 8, 145, '2013-06-14 13:05:23', 8, '2013-06-14 13:05:23', 0, 1),
(154, 'calendar', 'Calendar', 23, 8, 153, '2013-06-14 13:05:23', 8, '2013-06-14 13:05:23', 0, 1),
(155, 'medication_group', 'Medications', 22, 8, 153, '2013-06-14 13:05:23', 8, '2013-06-14 13:05:23', 0, 1),
(156, 'contact_group', 'Contacts', 23, 8, 153, '2013-06-14 13:05:24', 8, '2013-06-14 13:05:24', 0, 1),
(157, 'task_group', 'Tasks', 41, 8, 153, '2013-06-14 13:05:24', 8, '2013-06-14 13:05:24', 0, 1),
(158, 'document_group', 'Documents', 10, 8, 153, '2013-06-14 13:05:24', 8, '2013-06-14 13:05:24', 0, 1),
(161, 'person', 'Mark Boucher', 23, 7, 138, '2013-06-14 18:54:05', 7, '2013-06-14 18:54:05', 0, 1),
(162, 'calendar', 'Calendar', 24, 7, 161, '2013-06-14 18:54:05', 7, '2013-06-14 18:54:05', 0, 1),
(163, 'medication_group', 'Medications', 23, 7, 161, '2013-06-14 18:54:06', 7, '2013-06-14 18:54:06', 0, 1),
(164, 'contact_group', 'Contacts', 24, 7, 161, '2013-06-14 18:54:06', 7, '2013-06-14 18:54:06', 0, 1),
(165, 'task_group', 'Tasks', 42, 7, 161, '2013-06-14 18:54:06', 7, '2013-06-14 18:54:06', 0, 1),
(166, 'document_group', 'Documents', 11, 7, 161, '2013-06-14 18:54:06', 7, '2013-06-14 18:54:06', 0, 1),
(168, 'document', 'Desc doc24', 15, 8, 151, '2013-06-17 13:57:29', 8, '2013-06-17 15:42:45', 0, 1),
(169, 'document', 'Thi is idnoi', 16, 8, 151, '2013-06-17 13:58:51', 8, '2013-06-17 15:44:13', 0, 1);

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

--
-- Table structure for table `task`
--

CREATE TABLE IF NOT EXISTS `task` (
  `taskid` int(11) NOT NULL AUTO_INCREMENT,
  `task_description` varchar(100) DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `priority` varchar(24) DEFAULT NULL,
  `person_responsibile` varchar(100) DEFAULT NULL,
  `task_notes` text,
  `is_completed` varchar(5) NOT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` int(1) DEFAULT '1',
  PRIMARY KEY (`taskid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `task_group`
--

CREATE TABLE IF NOT EXISTS `task_group` (
  `task_groupid` int(11) NOT NULL AUTO_INCREMENT,
  `task_group_name` varchar(60) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`task_groupid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

--
-- Dumping data for table `task_group`
--

INSERT INTO `task_group` (`task_groupid`, `task_group_name`, `created`, `userid_created`, `updated`, `userid_updated`, `rec_status`) VALUES
(39, 'Tasks', '2013-06-14 12:15:03', 7, '0000-00-00 00:00:00', 0, 1),
(40, 'Tasks', '2013-06-14 12:16:59', 8, '0000-00-00 00:00:00', 0, 1),
(41, 'Tasks', '2013-06-14 13:05:24', 8, '0000-00-00 00:00:00', 0, 1),
(42, 'Tasks', '2013-06-14 18:54:06', 7, '0000-00-00 00:00:00', 0, 1);

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

--
-- Table structure for table `users_perm_temp`
--

CREATE TABLE IF NOT EXISTS `users_perm_temp` (
  `users_permisson_tempid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_userid` int(11) DEFAULT NULL,
  `fk_resourceid` int(11) DEFAULT NULL,
  `fk_email_login` varchar(255) DEFAULT NULL,
  `perm_type` varchar(255) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` int(1) DEFAULT '1',
  PRIMARY KEY (`users_permisson_tempid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `user_resource`
--

CREATE TABLE IF NOT EXISTS `user_resource` (
  `user_resourceid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_userid` int(11) DEFAULT NULL,
  `fk_resourceid` int(11) DEFAULT NULL,
  `perm_type` varchar(20) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userid_created` int(11) DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `userid_updated` int(11) DEFAULT '0',
  `rec_status` int(1) DEFAULT '1',
  PRIMARY KEY (`user_resourceid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `user_resource`
--

INSERT INTO `user_resource` (`user_resourceid`, `fk_userid`, `fk_resourceid`, `perm_type`, `created`, `userid_created`, `updated`, `userid_updated`, `rec_status`) VALUES
(13, 8, 144, 'can_edit', '2013-06-14 12:18:49', 0, '0000-00-00 00:00:00', 0, 1),
(14, 8, 161, 'can_edit', '2013-06-14 18:54:26', 0, '0000-00-00 00:00:00', 0, 1);

