Edit File by line

[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

[10] Fix | Delete

-- Database: `precurio44_`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

-- Table structure for table `activity_effect`

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `activity_effect` (

[20] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`activity_id` int(11) DEFAULT NULL COMMENT 'activity_log',

[22] Fix | Delete

`subject_id` int(11) DEFAULT NULL,

[23] Fix | Delete

`date_created` char(15) DEFAULT NULL,

[24] Fix | Delete

`active` int(11) DEFAULT NULL,

[25] Fix | Delete

PRIMARY KEY (`id`)

[26] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[27] Fix | Delete

[28] Fix | Delete

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

[29] Fix | Delete

[30] Fix | Delete

[31] Fix | Delete

-- Table structure for table `activity_log`

[32] Fix | Delete

[33] Fix | Delete

[34] Fix | Delete

CREATE TABLE `activity_log` (

[35] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[36] Fix | Delete

`appid` varchar(255) DEFAULT NULL,

[37] Fix | Delete

`type` varchar(255) DEFAULT NULL,

[38] Fix | Delete

`item_id` int(11) DEFAULT NULL,

[39] Fix | Delete

`user_id` int(11) DEFAULT NULL COMMENT 'This is the user that is the "actor" in this activity',

[40] Fix | Delete

`group_id` int(11) DEFAULT '0',

[41] Fix | Delete

`session_user_id` int(11) DEFAULT NULL COMMENT 'This is the currently logged in user that triggered the activity .Useful for analytic purpose.',

[42] Fix | Delete

`only_notify_id` int(11) DEFAULT '0' COMMENT 'Restrict notification to only this user_id',

[43] Fix | Delete

`activity_date` varchar(255) DEFAULT NULL COMMENT 'readable version of the date created',

[44] Fix | Delete

`date_created` char(15) DEFAULT NULL,

[45] Fix | Delete

`active` tinyint(3) unsigned DEFAULT NULL,

[46] Fix | Delete

PRIMARY KEY (`id`)

[47] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[48] Fix | Delete

[49] Fix | Delete

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

[50] Fix | Delete

[51] Fix | Delete

[52] Fix | Delete

-- Table structure for table `activity_registry`

[53] Fix | Delete

[54] Fix | Delete

[55] Fix | Delete

CREATE TABLE `activity_registry` (

[56] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[57] Fix | Delete

`title` varchar(255) DEFAULT NULL,

[58] Fix | Delete

`appid` varchar(255) NOT NULL,

[59] Fix | Delete

`type` varchar(255) NOT NULL,

[60] Fix | Delete

`table_name` varchar(255) NOT NULL,

[61] Fix | Delete

`class_path` varchar(255) DEFAULT NULL,

[62] Fix | Delete

`class_name` varchar(255) DEFAULT NULL,

[63] Fix | Delete

`feed_format` text,

[64] Fix | Delete

`mail_format` text,

[65] Fix | Delete

`mail_subject` varchar(255) DEFAULT NULL,

[66] Fix | Delete

`sms_format` text,

[67] Fix | Delete

`feed_enabled` tinyint(1) DEFAULT '1',

[68] Fix | Delete

`mail_enabled` tinyint(1) DEFAULT '1',

[69] Fix | Delete

`sms_enabled` tinyint(1) DEFAULT '1',

[70] Fix | Delete

`date_created` char(15) DEFAULT NULL,

[71] Fix | Delete

`active` tinyint(1) DEFAULT '1',

[72] Fix | Delete

PRIMARY KEY (`id`)

[73] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ;

[74] Fix | Delete

[75] Fix | Delete

[76] Fix | Delete

-- Dumping data for table `activity_registry`

[77] Fix | Delete

[78] Fix | Delete

[79] Fix | Delete

INSERT INTO `activity_registry` VALUES

[80] Fix | Delete

(1, 'NEW TASK', 'task', 'new', 'tasks', 'team/models/vo/TeamTask.php', 'Task', '<a href=''{9}''>{1}</a> created task <a href=''{3}''>{8}</a>. ', '', '{1} created a new task.', 'You have a new task - {8}. From {1}', 1, 1, 1, '1395320628', 1),

[81] Fix | Delete

(2, 'COMPLETE TASK', 'task', 'complete', 'tasks', 'team/models/vo/TeamTask.php', 'Task', '<a href=''{9}''>{1}</a> completed task <a href=''{3}''>{8}</a>.', '', '{1} has completed a task.', '', 1, 1, 1, '1395320628', 1),

[82] Fix | Delete

(3, 'TRANSFER TASK', 'task', 'transfer', 'tasks', 'team/models/vo/TeamTask.php', 'Task', '<a href=''{9}''>{1}</a> re-assigned task <a href=''{3}''>{8}</a>', '', '{1} transferred a task.', '', 1, 1, 1, '1395320628', 1),

[83] Fix | Delete

(4, 'USER ADDED TO TASK', 'task', 'add_user', 'tasks', 'team/models/vo/TeamTask.php', 'Task', '<a href=''{9}''>{1}</a> has been added to task <a href=''{3}''>{8}</a>, and will now be notified of progress and changes.', '', '{1} is now following your task.', '', 1, 1, 1, '1395320628', 1),

[84] Fix | Delete

(5, 'FILE UPLOAD TO TASK', 'task', 'add_file', 'tasks', 'team/models/vo/TeamTask.php', 'Task', '<a href=''{9}''>{1}</a> shared a file on task <a href=''{3}''>{8}</a>', '', '{1} attached a file to your task.', '', 1, 1, 1, '1395320628', 1),

[85] Fix | Delete

(6, 'NEW DISCUSSION', 'discussion', 'new', 'discussions', 'team/models/vo/TeamDiscussion.php', 'Discussion', '<a href=''{9}''>{1}</a> created discussion <a href=''{3}''>{8}</a>.', ' ', '{1} started a discussion with you', ' ', 1, 1, 1, '1395320628', 1),

[86] Fix | Delete

(7, 'USER ADDED TO DISCUSSION', 'discussion', 'add_user', 'discussions', 'team/models/vo/TeamDiscussion.php', 'Discussion', '<a href=''{9}''>{1}</a> has joined discussion <a href=''{3}''>{8}</a>.', '', '{1} has joined discussion {8}.', '', 1, 1, 1, '1395320628', 1),

[87] Fix | Delete

(8, 'COMMENT ON DISCUSSION', 'discussion', 'comment', 'discussions', 'team/models/vo/TeamDiscussion.php', 'Discussion', '<a href=''{9}''>{1}</a> posted a message to discussion <a href=''{3}''>{8}</a>', '', 'New comment on discussion {8}.', '', 1, 1, 1, '1395320628', 1),

[88] Fix | Delete

(9, 'COMMENT ON TASK', 'task', 'comment', 'tasks', 'team/models/vo/TeamTask.php', 'Task', '<a href=''{9}''>{1}</a> posted a comment on task <a href=''{3}''>{8}</a>', '', 'New comment on task.', '', 1, 1, 1, '1395320628', 1),

[89] Fix | Delete

(10, 'VIEW DISCUSSION', 'discussion', 'view', 'discussions', 'team/models/vo/TeamDiscussion.php', 'Discussion', '', '', '', '', 0, 0, 0, '1395320628', 1),

[90] Fix | Delete

(11, 'NEW CONTENT', 'cms', 'new', 'content', 'cms/models/vo/Content.php', 'Content', '<a href=''{9}''>{1}</a> created content <a href=''{3}''>{8}</a>', '', 'New content has been published', '', 1, 1, 1, '1395320628', 1),

[91] Fix | Delete

(12, 'EDIT CONTENT', 'cms', 'edit', 'content', 'cms/models/vo/Content.php', 'Content', '', '', '', '', 0, 0, 0, '1395320628', 1),

[92] Fix | Delete

(13, 'VIEW CONTENT', 'cms', 'view', 'content', 'cms/models/vo/Content.php', 'Content', '', '', '', '', 0, 0, 0, '1395320628', 1),

[93] Fix | Delete

(14, 'NEW DOCUMENT', 'document', 'new', 'documents', 'team/models/vo/TeamDocument.php', 'Document', '<a href=''{9}''>{1}</a> uploaded <a href=''{3}''>{8}</a>', '<a href=''{9}''>{1}</a> uploaded <a href=''{3}''>{8}</a>', '{1} has shared a file with you', '', 1, 1, 1, '1395320628', 1),

[94] Fix | Delete

(15, 'VIEW DOCUMENT', 'document', 'view', 'documents', 'team/models/vo/TeamDocument.php', 'Document', '', '', '', '', 0, 0, 0, '1395320628', 1),

[95] Fix | Delete

(16, 'SHARE DOCUMENT', 'document', 'share', 'documents', 'team/models/vo/TeamDocument.php', 'Document', '<a href=''{9}''>{1}</a> shared <a href=''{3}''>{8}</a>', '', 'A document has been shared with you', '', 1, 1, 1, '1395320628', 1),

[96] Fix | Delete

(17, 'DOWNLOAD DOCUMENT', 'document', 'download', 'documents', 'team/models/vo/TeamDocument.php', 'Document', '', '', '', '', 0, 0, 0, '1395320628', 1),

[97] Fix | Delete

(18, 'SHARE CONTENT', 'cms', 'share', 'content', 'cms/models/vo/Content.php', 'Content', '<a href=''{9}''>{1}</a> shared <a href=''{3}''>{8}</a>', '', 'A content has been shared with you.', '', 1, 1, 1, '1395320628', 1),

[98] Fix | Delete

(19, 'COMMENT ON CONTENT', 'cms', 'comment', 'content', 'cms/models/vo/Content.php', 'Content', '<a href=''{9}''>{1}</a> posted a comment on content <a href=''{3}''>{8}</a>', '', 'New comment on content {8}.', '', 1, 1, 1, '1395320628', 1),

[99] Fix | Delete

(20, 'COMMENT ON DOCUMENT', 'document', 'comment', 'documents', 'team/models/vo/TeamDocument.php', 'Document', '<a href=''{9}''>{1}</a> posted a comment on document <a href=''{3}''>{8}</a>', '', 'New comment on document {8}.', '', 1, 1, 1, '1395320628', 1),

[100] Fix | Delete

(21, 'SHARE DOCUMENT WITH EXTRANET', 'document', 'extranet_share', 'documents', 'team/models/vo/TeamDocument.php', 'Document', '', '{1} has shared the following file with you. \n\n{8}\n \n<a href=''{3}''>Click on this link to view the file.</a>', '{1} has shared a file with you', '', 0, 1, 0, '1395320628', 1),

[101] Fix | Delete

(22, 'CHECKOUT DOCUMENT', 'document', 'checkout', 'documents', 'team/models/vo/TeamDocument.php', 'Document', '<a href=''{9}''>{1}</a> checkout out <a href=''{3}''>{8}</a>   for editing.', '', '', '', 1, 0, 0, '1395320628', 1),

[102] Fix | Delete

(23, 'ADD USER TO TEAM', 'team', 'add_user', 'groups', 'team/models/vo/Team.php', '', '', '<a href=''{9}''>{1}</a> has invited you to collaborate with team "{8}". <a href=''{3}''>Click here to visit the team space</a>.', '{1} has invited you to a team.', '', 0, 1, 0, '1395320628', 1),

[103] Fix | Delete

(24, 'NEW TEAM', 'team', 'new', 'groups', 'team/models/vo/Team.php', '', '', '', '', '', 0, 0, 0, '1395320628', 1),

[104] Fix | Delete

(25, 'NEW DOCUMENT VERSION/CHECK-IN DOCUMENT', 'document', 'new_version', 'documents', 'team/models/vo/TeamDocument.php', 'Document', '<a href=''{9}''>{1}</a> uploaded a new version of <a href=''{3}''>{8}</a>', '', '', '', 1, 0, 0, '1395320628', 1),

[105] Fix | Delete

(26, 'NEW NOTE', 'note', 'new', 'notes', 'team/models/vo/TeamNote.php', 'Note', '<a href=''{9}''>{1}</a> added a new note <a href=''{3}''>{8}</a>', '', 'A new note has been created', '', 1, 1, 0, '1395320628', 1),

[106] Fix | Delete

(27, 'EDIT NOTE', 'note', 'edit', 'notes', 'team/models/vo/TeamNote.php', 'Note', '<a href=''{9}''>{1}</a> edited note <a href=''{3}''>{8}</a>', '', 'Note ''{8}'' has been updated', '', 1, 0, 0, '1395320628', 1),

[107] Fix | Delete

(28, 'VIEW NOTE', 'note', 'view', 'notes', 'team/models/vo/TeamNote.php', 'Note', '', '', '', '', 0, 0, 0, '1395320628', 1),

[108] Fix | Delete

(29, 'COMMENT ON NOTE', 'note', 'comment', 'notes', 'team/models/vo/TeamNote.php', 'Note', '<a href=''{9}''>{1}</a> posted a comment on note <a href=''{3}''>{8}</a>', '', 'New comment on note ''{8}', '', 1, 1, 1, '1395320628', 1),

[109] Fix | Delete

(30, 'INITATE NEW WORKFLOW FORM', 'workflow', 'new', 'user_processes', 'workflow/models/vo/UserProcess.php', 'UserProcess', '<a href=''{9}''>{1}</a> initiated <a href=''{3}''>new workflow request</a>', '', '', '', 0, 0, 0, '1395320628', 1),

[110] Fix | Delete

(31, 'COMMENT ON FORM', 'workflow', 'comment', 'user_processes', 'workflow/models/vo/UserProcess.php', 'UserProcess', '<a href=''{9}''>{1}</a> posted a comment on form <a href=''{3}''>{8}</a>', '', '', '', 1, 0, 0, '1395320628', 1),

[111] Fix | Delete

(32, 'WORKFLOW PENDING APPROVAL', 'workflow', 'pending', 'user_processes', 'workflow/models/vo/UserProcess.php', 'UserProcess', 'Your <a href=''{3}''>workflow request</a> has been received and will be handled by  <a href=''{9}''>{1}</a>.', 'Your <a href="http://localhost:88/precurio4/public/admin/notification/edit/id/{3}">workflow request</a> [{8}]  has been received and will be handled by  <a href="http://localhost:88/precurio4/public/admin/notification/edit/id/{9}">{1}</a>. ', 'Your form is pending approval', '', 1, 1, 0, '1395320628', 1),

[112] Fix | Delete

(33, 'WORKFLOW APPROVED', 'workflow', 'approved', 'user_processes', 'workflow/models/vo/UserProcess.php', 'UserProcess', '<a href=''{9}''>{1}</a> approved <a href=''{3}''>request</a> ', '', 'Form has been approved', '', 1, 1, 0, '1395320628', 1),

[113] Fix | Delete

(34, 'WORKFLOW NOT APPROVED', 'workflow', 'rejected', 'user_processes', 'workflow/models/vo/UserProcess.php', 'UserProcess', '<a href=''{9}''>{1}</a> did NOT approve <a href=''{3}''>request</a> ', '', 'Form has been declined', '', 1, 1, 0, '1395320628', 1),

[114] Fix | Delete

(35, 'WORKFLOW TRANSFERED', 'workflow', 'transfered', 'user_processes', 'workflow/models/vo/UserProcess.php', 'UserProcess', '<a href=''{9}''>{1}</a> transfered <a href=''{3}''>request</a> ', '', '', '', 1, 0, 0, '1395320628', 1),

[115] Fix | Delete

(36, 'WORKFLOW COMPLETE', 'workflow', 'completed', 'user_processes', 'workflow/models/vo/UserProcess.php', 'UserProcess', '<a href=''{3}''>Workflow process</a> is now complete.', '', 'Form approval is now complete.', '', 1, 1, 0, '1395320628', 1),

[116] Fix | Delete

(37, 'NEW USER STATUS', 'user', 'status', 'status_messages', 'user/models/vo/UserStatus.php', 'UserStatus', '<a href=''{7}/user/profile/view/{5}''>{1} </a>: {8}', '', '', '', 1, 0, 0, '1395320628', 1),

[117] Fix | Delete

(38, 'USER CHANGE PROFILE PICTURE', 'user', 'picture', 'user_details', 'user/models/vo/User.php', 'User', '<a href=''{7}/user/profile/view/{5}''>{1} </a> has a new profile picture.', '', '', '', 1, 0, 0, '1395320628', 1),

[118] Fix | Delete

(39, 'USER CHANGE PHONE NUMBER', 'user', 'phone', 'user_details', 'user/models/vo/User.php', 'User', '<a href=''{7}/user/profile/view/{5}''>{1} </a> has updated {2} phone number.', '', '', '', 1, 0, 0, '1395320628', 1),

[119] Fix | Delete

(40, 'USER CHANGE LOCATION', 'user', 'location', 'user_details', 'user/models/vo/User.php', 'User', '<a href=''{7}/user/profile/view/{5}''>{1} </a> has moved to a new location.', '', '', '', 1, 0, 0, '1395320628', 1),

[120] Fix | Delete

(41, 'USER CHANGE JOB TITLE', 'user', 'job', 'user_details', 'user/models/vo/User.php', 'User', '<a href=''{7}/user/profile/view/{5}''>{1} </a> has a new job title.', '', '', '', 1, 0, 0, '1395320628', 1),

[121] Fix | Delete

(42, 'USER CHANGE DEPARTMENT', 'user', 'department', 'user_details', 'user/models/vo/User.php', 'User', '<a href=''{7}/user/profile/view/{5}''>{1} </a> is now in a new department.', '', '', '', 1, 0, 0, '1395320628', 1),

[122] Fix | Delete

(43, 'USER CHANGE PASSWORD', 'user', 'password', 'user_details', 'user/models/vo/User.php', 'User', '', '', '', '', 0, 0, 0, '1395320628', 1),

[123] Fix | Delete

(44, 'INVITE USER TO EVENT', 'event', 'add_user', 'events', 'event/models/vo/Event.php', 'Event', '<a href=''{7}/user/profile/view/{5}''>{1} </a> invited you to event <a href=''{3}''>{8}</a>.', '', 'New Event \\\\"{8}\\\\".', '', 1, 1, 1, '1395320628', 1),

[124] Fix | Delete

(45, 'NEW EVENT', 'event', 'new', 'events', 'event/models/vo/Event.php', 'Event', '<a href=''{7}/user/profile/view/{5}''>{1} </a> has created a new event <a href=''{3}''>{8}</a>.', '', '', '', 1, 0, 0, '1395320628', 1),

[125] Fix | Delete

(46, 'PHOTO ADDED TO EVENT', 'event', 'add_photo', 'events', 'event/models/vo/Event.php', 'Event', '<a href=''{7}/user/profile/view/{5}''>{1} </a> has added a new photo to event <a href=''{3}''>{8}</a>.', '', 'New Event Photo.', '', 1, 1, 1, '1395320628', 1),

[126] Fix | Delete

(47, 'EDIT EVENT', 'event', 'edit', 'events', 'event/models/vo/Event.php', 'Event', '<a href=''{7}/user/profile/view/{5}''>{1} </a> made some changes to event <a href=''{3}''>{8}</a>.', '', '', '', 1, 0, 0, '1395320628', 1),

[127] Fix | Delete

(48, 'FILE ADDED TO EVENT', 'event', 'add_file', 'events', 'event/models/vo/Event.php', 'Event', '<a href=''{7}/user/profile/view/{5}''>{1} </a> has added a new document to event <a href=''{3}''>{8}</a>.', '', 'New Event Document.', '', 1, 1, 1, '1395320628', 1),

[128] Fix | Delete

(49, 'TASK SHARED WITH TEAM', 'task', 'add_group', 'tasks', 'team/models/vo/TeamTask.php', 'Task', '<a href=''{9}''>{1}</a> has been added to task <a href=''{3}''>{8}</a>.', '', '{1} is now following your task', '', 1, 1, 1, '1395320628', 1),

[129] Fix | Delete

(50, 'TEAM ADDED TO DISCUSSION', 'discussion', 'add_group', 'discussions', 'team/models/vo/TeamDiscussion.php', 'Discussion', '<a href=''{9}''>{1}</a> has joined discussion <a href=''{3}''>{8}</a>.', '', '', '', 1, 0, 1, '1395320628', 1),

[130] Fix | Delete

(51, '', 'note', 'add_group', 'notes', 'team/models/vo/TeamNote.php', 'Note', '', '', '', '', 0, 0, 0, '1395320628', 1),

[131] Fix | Delete

(52, 'USER FORGOT PASSWORD', 'user', 'forgot', 'user_details', 'user/models/vo/User.php', 'User', '', '<div>This email is sent to your because you have requested to reset your password. If you didn''t initiate this request, please report this to the administrator. </div><div> </div><div>To continue with your password reset, <a href="{3}">please click here</a>.</div>', 'Reset your password', '', 0, 1, 0, '1395320628', 1),

[132] Fix | Delete

(53, 'NEW USER REGISTERED BY ADMIN', 'user', 'new', 'user_details', 'user/models/vo/User.php', 'User', '', 'You have been registered on the Precurio intranet platform. \n\nBelow is your login information: \n\n{8}\n \n<a href="{3}">Click here to complete your profile on your corporate intranet.</a>', 'You have been registered on the intranet', '', 0, 1, 1, '1395320628', 1),

[133] Fix | Delete

(54, 'FILE ADDED TO DISCUSSION', 'discussion', 'add_file', 'discussions', 'team/models/vo/TeamDiscussion.php', 'Discussion', '<a href=''{7}/user/profile/view/{5}''>{1} </a> has attached a new file to discussion <a href=''{3}''>{8}</a>.', '', 'New File on Discussion', '', 1, 1, 1, '1395320628', 1),

[134] Fix | Delete

(55, 'EMAIL FORM TO APPROVER', 'workflow', 'form_email', 'user_processes', 'workflow/models/vo/UserProcess.php', 'UserProcess', '', 'See <a href="{3}" title="" target="">Workflow request</a>   below {1}', 'A form has been submited', '', 0, 1, 0, '1395320628', 1);

[135] Fix | Delete

[136] Fix | Delete

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

[137] Fix | Delete

[138] Fix | Delete

[139] Fix | Delete

-- Table structure for table `analytics`

[140] Fix | Delete

[141] Fix | Delete

[142] Fix | Delete

CREATE TABLE `analytics` (

[143] Fix | Delete

`id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,

[144] Fix | Delete

`user_id` int(10) unsigned NOT NULL,

[145] Fix | Delete

`session_id` char(30) DEFAULT NULL,

[146] Fix | Delete

`module` varchar(255) DEFAULT NULL,

[147] Fix | Delete

`controller` varchar(255) DEFAULT NULL,

[148] Fix | Delete

`action` varchar(255) DEFAULT NULL,

[149] Fix | Delete

`params` text,

[150] Fix | Delete

`date_created` char(15) NOT NULL,

[151] Fix | Delete

PRIMARY KEY (`id`)

[152] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[153] Fix | Delete

[154] Fix | Delete

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

[155] Fix | Delete

[156] Fix | Delete

[157] Fix | Delete

-- Table structure for table `app_documents`

[158] Fix | Delete

[159] Fix | Delete

[160] Fix | Delete

CREATE TABLE `app_documents` (

[161] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[162] Fix | Delete

`appid` char(10) DEFAULT NULL,

[163] Fix | Delete

`item_id` int(10) NOT NULL,

[164] Fix | Delete

`content_id` int(10) unsigned NOT NULL,

[165] Fix | Delete

`user_id` int(10) unsigned NOT NULL,

[166] Fix | Delete

`date_created` char(15) DEFAULT NULL,

[167] Fix | Delete

`active` tinyint(1) unsigned NOT NULL DEFAULT '1',

[168] Fix | Delete

PRIMARY KEY (`id`)

[169] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[170] Fix | Delete

[171] Fix | Delete

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

[172] Fix | Delete

[173] Fix | Delete

[174] Fix | Delete

-- Table structure for table `app_tags`

[175] Fix | Delete

[176] Fix | Delete

[177] Fix | Delete

CREATE TABLE `app_tags` (

[178] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[179] Fix | Delete

`appid` char(10) DEFAULT NULL,

[180] Fix | Delete

`item_id` int(10) NOT NULL,

[181] Fix | Delete

`tag_id` int(10) unsigned NOT NULL,

[182] Fix | Delete

`user_id` int(10) unsigned NOT NULL,

[183] Fix | Delete

`date_created` char(15) DEFAULT NULL,

[184] Fix | Delete

`active` tinyint(1) unsigned NOT NULL DEFAULT '1',

[185] Fix | Delete

PRIMARY KEY (`id`)

[186] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[187] Fix | Delete

[188] Fix | Delete

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

[189] Fix | Delete

[190] Fix | Delete

[191] Fix | Delete

-- Table structure for table `bugs`

[192] Fix | Delete

[193] Fix | Delete

[194] Fix | Delete

CREATE TABLE `bugs` (

[195] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[196] Fix | Delete

`user_id` int(10) unsigned NOT NULL,

[197] Fix | Delete

`type` char(20) NOT NULL,

[198] Fix | Delete

`component` char(40) NOT NULL,

[199] Fix | Delete

`title` varchar(255) NOT NULL,

[200] Fix | Delete

`description` text NOT NULL,

[201] Fix | Delete

`date_created` char(15) DEFAULT NULL,

[202] Fix | Delete

`active` tinyint(3) unsigned DEFAULT NULL,

[203] Fix | Delete

`sent` tinyint(3) unsigned NOT NULL DEFAULT '0',

[204] Fix | Delete

PRIMARY KEY (`id`)

[205] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[206] Fix | Delete

[207] Fix | Delete

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

[208] Fix | Delete

[209] Fix | Delete

[210] Fix | Delete

-- Table structure for table `categorys`

[211] Fix | Delete

[212] Fix | Delete

[213] Fix | Delete

CREATE TABLE `categorys` (

[214] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[215] Fix | Delete

`user_id` int(10) unsigned NOT NULL COMMENT 'user that created the category',

[216] Fix | Delete

`parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'category id to which it is a sub category of. parent categories have their parent_id as 0',

[217] Fix | Delete

`title` varchar(255) DEFAULT NULL,

[218] Fix | Delete

`description` text,

[219] Fix | Delete

`access_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '-1 for private, 0 for public, 1 for shared',

[220] Fix | Delete

`appid` varchar(30) NOT NULL DEFAULT 'cms' COMMENT 'App that is making use of category feature',

[221] Fix | Delete

`date_created` char(20) DEFAULT NULL,

[222] Fix | Delete

`active` tinyint(3) unsigned NOT NULL DEFAULT '1',

[223] Fix | Delete

`deleted` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'this indicates if a category has been permanently deleted from the recycle bin. A value of 1 means the category has been deleted permanently, while 0 means the category is still in recycle bin',

[224] Fix | Delete

`is_folder` tinyint(1) unsigned NOT NULL DEFAULT '1',

[225] Fix | Delete

`is_photo` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'indicates if it is an album folder',

[226] Fix | Delete

`is_site` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'indicates if it is a site category',

[227] Fix | Delete

`is_locked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'indicates if a folder has been locked',

[228] Fix | Delete

PRIMARY KEY (`id`)

[229] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[230] Fix | Delete

[231] Fix | Delete

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

[232] Fix | Delete

[233] Fix | Delete

[234] Fix | Delete

-- Table structure for table `components`

[235] Fix | Delete

[236] Fix | Delete

[237] Fix | Delete

CREATE TABLE `components` (

[238] Fix | Delete

`componentid` int(11) NOT NULL AUTO_INCREMENT,

[239] Fix | Delete

`componentform` int(11) DEFAULT NULL,

[240] Fix | Delete

`section` int(11) DEFAULT '0',

[241] Fix | Delete

`rowid` int(11) DEFAULT NULL,

[242] Fix | Delete

`componenttype` varchar(10) DEFAULT NULL,

[243] Fix | Delete

`componentlabel` varchar(250) DEFAULT NULL,

[244] Fix | Delete

`componentrequired` int(1) DEFAULT '0',

[245] Fix | Delete

`componentdefaultvalue` varchar(250) DEFAULT NULL,

[246] Fix | Delete

`frm_database` varchar(255) DEFAULT 'self',

[247] Fix | Delete

`frm_table` varchar(255) DEFAULT NULL,

[248] Fix | Delete

`frm_label_field` varchar(255) DEFAULT 'title',

[249] Fix | Delete

`frm_value_field` varchar(255) DEFAULT 'id',

[250] Fix | Delete

`frm_where_clause` text,

[251] Fix | Delete

`lastmodified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

[252] Fix | Delete

PRIMARY KEY (`componentid`)

[253] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=84 ;

[254] Fix | Delete

[255] Fix | Delete

[256] Fix | Delete

-- Dumping data for table `components`

[257] Fix | Delete

[258] Fix | Delete

[259] Fix | Delete

INSERT INTO `components` VALUES

[260] Fix | Delete

(1, 1, 0, 1, 'dropdown', 'Type of Leave', 0, 'Annual', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[261] Fix | Delete

(2, 1, 0, 2, 'number', 'Number of Days', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[262] Fix | Delete

(3, 1, 0, 3, 'date', 'Start Date', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[263] Fix | Delete

(4, 1, 0, 4, 'date', 'End Date', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[264] Fix | Delete

(5, 1, 0, 5, 'text', 'Contact Telephone during leave', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[265] Fix | Delete

(6, 1, 0, 6, 'textarea', 'Contact Address during leave', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[266] Fix | Delete

(7, 1, 0, 7, 'textarea', 'Notes (if any)', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[267] Fix | Delete

(8, 1, 3, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[268] Fix | Delete

(9, 1, 4, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[269] Fix | Delete

(10, 2, 0, 1, 'user', 'Name of Person Travelling', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[270] Fix | Delete

(11, 2, 0, 2, 'department', 'Department', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[271] Fix | Delete

(12, 2, 0, 3, 'dropdown', 'Type of Travel', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[272] Fix | Delete

(13, 2, 0, 4, 'textarea', 'Purpose of Travel', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[273] Fix | Delete

(14, 2, 0, 5, 'text', 'Destination', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[274] Fix | Delete

(15, 2, 0, 6, 'date', 'Departure Date', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[275] Fix | Delete

(16, 2, 0, 7, 'text', 'Departure Time', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[276] Fix | Delete

(17, 2, 0, 8, 'date', 'Arrival Date', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[277] Fix | Delete

(18, 2, 0, 9, 'text', 'Arrival Time', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[278] Fix | Delete

(19, 2, 0, 10, 'dropdown', 'Means of transport', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[279] Fix | Delete

(20, 2, 0, 11, 'check', 'Preferences', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[280] Fix | Delete

(21, 2, 0, 12, 'textarea', 'Notes (if any)', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[281] Fix | Delete

(22, 2, 5, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[282] Fix | Delete

(23, 2, 6, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[283] Fix | Delete

(24, 2, 6, 2, 'price', 'Accommodation Cost', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[284] Fix | Delete

(25, 2, 6, 3, 'price', 'Flight Tickets', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[285] Fix | Delete

(26, 2, 6, 4, 'price', 'Road Transportation', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[286] Fix | Delete

(27, 2, 6, 5, 'price', 'Other Costs', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[287] Fix | Delete

(28, 3, 0, 2, 'text', 'Item', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[288] Fix | Delete

(29, 3, 0, 3, 'textarea', 'Specifications (if any)', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[289] Fix | Delete

(30, 3, 0, 4, 'textarea', 'Purpose', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[290] Fix | Delete

(31, 3, 0, 5, 'number', 'Quantity', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[291] Fix | Delete

(32, 3, 0, 6, 'price', 'Price (if known)', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[292] Fix | Delete

(33, 3, 0, 7, 'date', 'Required Delivery date', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[293] Fix | Delete

(34, 3, 0, 8, 'textarea', 'Suggested Supppliers', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[294] Fix | Delete

(35, 3, 0, 9, 'textarea', 'Notes (if any)', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[295] Fix | Delete

(36, 3, 7, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[296] Fix | Delete

(37, 3, 8, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[297] Fix | Delete

(38, 5, 0, 2, 'text', 'Item Requested', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[298] Fix | Delete

(39, 5, 0, 3, 'textarea', 'Description', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[299] Fix | Delete

(40, 5, 0, 4, 'number', 'Quantity', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[300] Fix | Delete

(41, 5, 9, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[301] Fix | Delete

(42, 5, 10, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[302] Fix | Delete

(43, 5, 10, 2, 'number', 'Quantity Issued', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[303] Fix | Delete

(44, 5, 10, 3, 'date', 'Date Issued', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[304] Fix | Delete

(45, 4, 0, 3, 'price', 'Amount Requested', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[305] Fix | Delete

(46, 4, 0, 2, 'textarea', 'Purpose / Justification', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[306] Fix | Delete

(47, 4, 0, 1, 'date', 'Date needed', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[307] Fix | Delete

(48, 4, 0, 4, 'date', 'Date to be returned', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[308] Fix | Delete

(49, 4, 11, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[309] Fix | Delete

(50, 4, 12, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[310] Fix | Delete

(51, 4, 12, 2, 'price', 'Amount Issued', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[311] Fix | Delete

(52, 4, 12, 3, 'date', 'Date Issued', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[312] Fix | Delete

(53, 6, 0, 1, 'dropdown', 'Room', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[313] Fix | Delete

(54, 6, 0, 2, 'textarea', 'Purpose', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[314] Fix | Delete

(55, 6, 0, 3, 'date', 'Date', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[315] Fix | Delete

(56, 6, 0, 4, 'text', 'Time', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[316] Fix | Delete

(57, 6, 0, 5, 'text', 'Duration (hours)', 0, '1hr', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[317] Fix | Delete

(58, 6, 0, 6, 'dropdown', 'Recurring', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[318] Fix | Delete

(59, 6, 0, 7, 'textarea', 'Additional Equipment Needed', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[319] Fix | Delete

(60, 6, 13, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[320] Fix | Delete

(61, 7, 0, 1, 'price', 'Amount of Reimbursement', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[321] Fix | Delete

(62, 7, 0, 2, 'textarea', 'Description of Expense', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[322] Fix | Delete

(63, 7, 0, 3, 'text', 'Account Number', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[323] Fix | Delete

(64, 7, 14, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[324] Fix | Delete

(65, 7, 15, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[325] Fix | Delete

(66, 7, 15, 2, 'price', 'Amount Approved', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[326] Fix | Delete

(67, 7, 15, 3, 'date', 'Date Approved', 1, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[327] Fix | Delete

(68, 8, 0, 1, 'user', 'Requested By', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[328] Fix | Delete

(69, 8, 0, 2, 'department', 'Department', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[329] Fix | Delete

(70, 8, 0, 3, 'location', 'Location', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[330] Fix | Delete

(71, 8, 16, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[331] Fix | Delete

(72, 8, 16, 2, 'check', 'Signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[332] Fix | Delete

(73, 8, 0, 4, 'file', 'CV', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[333] Fix | Delete

(74, 9, 0, 1, 'text', 'Name of Current', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[334] Fix | Delete

(75, 9, 0, 2, 'date', 'Date of Open', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[335] Fix | Delete

(76, 9, 17, 1, 'text', 'Alternative Name', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[336] Fix | Delete

(77, 9, 18, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[337] Fix | Delete

(78, 9, 19, 1, 'text', 'Finance Personnel', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[338] Fix | Delete

(79, 1, 20, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[339] Fix | Delete

(80, 10, 0, 1, 'text', 'Visitor Name', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[340] Fix | Delete

(81, 10, 0, 2, 'dropdown', 'Visitor Type', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[341] Fix | Delete

(82, 10, 21, 1, 'signature', 'signature', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]'),

[342] Fix | Delete

(83, 10, 0, 3, 'radio', 'Official', 0, '', 'self', NULL, 'title', 'id', NULL, '[[regtime]]');

[343] Fix | Delete

[344] Fix | Delete

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

[345] Fix | Delete

[346] Fix | Delete

[347] Fix | Delete

-- Table structure for table `contacts`

[348] Fix | Delete

[349] Fix | Delete

[350] Fix | Delete

CREATE TABLE `contacts` (

[351] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[352] Fix | Delete

`account_id` int(10) unsigned NOT NULL DEFAULT '0',

[353] Fix | Delete

`user_id` int(10) unsigned DEFAULT NULL,

[354] Fix | Delete

`full_name` varchar(255) DEFAULT NULL,

[355] Fix | Delete

`address` varchar(255) DEFAULT NULL,

[356] Fix | Delete

`company` varchar(255) DEFAULT NULL,

[357] Fix | Delete

`work_phone` varchar(255) DEFAULT NULL,

[358] Fix | Delete

`mobile_phone` varchar(255) DEFAULT NULL,

[359] Fix | Delete

`fax` varchar(255) DEFAULT NULL,

[360] Fix | Delete

`email` varchar(255) DEFAULT NULL,

[361] Fix | Delete

`website` varchar(255) DEFAULT NULL,

[362] Fix | Delete

`job_title` varchar(255) DEFAULT NULL,

[363] Fix | Delete

`twitter` varchar(255) DEFAULT NULL,

[364] Fix | Delete

`shared` tinyint(3) unsigned NOT NULL DEFAULT '1',

[365] Fix | Delete

`date_created` char(15) DEFAULT NULL,

[366] Fix | Delete

`last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

[367] Fix | Delete

`active` tinyint(4) unsigned NOT NULL DEFAULT '1',

[368] Fix | Delete

PRIMARY KEY (`id`)

[369] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[370] Fix | Delete

[371] Fix | Delete

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

[372] Fix | Delete

[373] Fix | Delete

[374] Fix | Delete

-- Table structure for table `content`

[375] Fix | Delete

[376] Fix | Delete

[377] Fix | Delete

CREATE TABLE `content` (

[378] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[379] Fix | Delete

`title` varchar(255) DEFAULT NULL,

[380] Fix | Delete

`image_path` varchar(255) DEFAULT NULL,

[381] Fix | Delete

`summary` text,

[382] Fix | Delete

`body` text,

[383] Fix | Delete

`user_id` int(10) unsigned DEFAULT '0',

[384] Fix | Delete

`poll_id` int(10) unsigned DEFAULT '0',

[385] Fix | Delete

`url` varchar(255) NOT NULL DEFAULT '#',

[386] Fix | Delete

`keyword` varchar(255) DEFAULT '',

[387] Fix | Delete

`is_featured` tinyint(3) unsigned DEFAULT '0',

[388] Fix | Delete

`is_photo` tinyint(3) unsigned DEFAULT '0',

[389] Fix | Delete

`is_document` tinyint(3) unsigned DEFAULT '0',

[390] Fix | Delete

`date_created` char(15) DEFAULT NULL,

[391] Fix | Delete

`last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

[392] Fix | Delete

`active` tinyint(1) unsigned NOT NULL DEFAULT '1',

[393] Fix | Delete

`deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'A value of 1 means the content has been deleted permanently, while 0 means the content is still in recycle bin',

[394] Fix | Delete

`num_of_hits` int(10) unsigned NOT NULL DEFAULT '0',

[395] Fix | Delete

`rating` int(11) NOT NULL DEFAULT '0',

[396] Fix | Delete

`is_public` tinyint(1) unsigned NOT NULL DEFAULT '1',

[397] Fix | Delete

`template` varchar(255) DEFAULT NULL COMMENT 'a default template is handled at code level',

[398] Fix | Delete

`is_page` tinyint(1) unsigned DEFAULT '0',

[399] Fix | Delete

`disable_comments` tinyint(1) unsigned DEFAULT '0',

[400] Fix | Delete

`is_site` tinyint(1) unsigned DEFAULT '0',

[401] Fix | Delete

`confirm_read` tinyint(1) unsigned DEFAULT '0',

[402] Fix | Delete

PRIMARY KEY (`id`)

[403] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[404] Fix | Delete

[405] Fix | Delete

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

[406] Fix | Delete

[407] Fix | Delete

[408] Fix | Delete

-- Table structure for table `content_approval`

[409] Fix | Delete

[410] Fix | Delete

[411] Fix | Delete

CREATE TABLE `content_approval` (

[412] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[413] Fix | Delete

`featured` tinyint(3) unsigned NOT NULL DEFAULT '0',

[414] Fix | Delete

`advert` tinyint(3) unsigned NOT NULL DEFAULT '0',

[415] Fix | Delete

`news` tinyint(3) unsigned NOT NULL DEFAULT '0',

[416] Fix | Delete

`user_id` int(10) unsigned NOT NULL DEFAULT '0',

[417] Fix | Delete

`group_content` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'this is ignored if group_id = 0',

[418] Fix | Delete

`group_id` int(10) unsigned NOT NULL DEFAULT '0',

[419] Fix | Delete

`active` tinyint(3) unsigned NOT NULL DEFAULT '1',

[420] Fix | Delete

`date_created` char(15) NOT NULL,

[421] Fix | Delete

PRIMARY KEY (`id`)

[422] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[423] Fix | Delete

[424] Fix | Delete

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

[425] Fix | Delete

[426] Fix | Delete

[427] Fix | Delete

-- Table structure for table `content_categorys`

[428] Fix | Delete

[429] Fix | Delete

[430] Fix | Delete

CREATE TABLE `content_categorys` (

[431] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[432] Fix | Delete

`category_id` int(11) NOT NULL,

[433] Fix | Delete

`content_id` int(10) unsigned NOT NULL,

[434] Fix | Delete

`user_id` int(10) unsigned NOT NULL COMMENT 'user that assigned the content to the category',

[435] Fix | Delete

`date_created` char(20) DEFAULT NULL,

[436] Fix | Delete

`active` tinyint(4) DEFAULT NULL,

[437] Fix | Delete

PRIMARY KEY (`id`)

[438] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[439] Fix | Delete

[440] Fix | Delete

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

[441] Fix | Delete

[442] Fix | Delete

[443] Fix | Delete

-- Table structure for table `content_lock_history`

[444] Fix | Delete

[445] Fix | Delete

[446] Fix | Delete

CREATE TABLE `content_lock_history` (

[447] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[448] Fix | Delete

`content_id` int(10) unsigned NOT NULL,

[449] Fix | Delete

`user_id` int(10) unsigned NOT NULL,

[450] Fix | Delete

`lock` tinyint(1) unsigned NOT NULL,

[451] Fix | Delete

`active` tinyint(1) unsigned NOT NULL DEFAULT '1',

[452] Fix | Delete

`date_created` char(15) DEFAULT NULL,

[453] Fix | Delete

PRIMARY KEY (`id`)

[454] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[455] Fix | Delete

[456] Fix | Delete

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

[457] Fix | Delete

[458] Fix | Delete

[459] Fix | Delete

-- Table structure for table `content_ratings`

[460] Fix | Delete

[461] Fix | Delete

[462] Fix | Delete

CREATE TABLE `content_ratings` (

[463] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[464] Fix | Delete

`content_id` int(10) unsigned DEFAULT NULL,

[465] Fix | Delete

`user_id` int(10) unsigned DEFAULT NULL,

[466] Fix | Delete

`value` tinyint(4) DEFAULT NULL,

[467] Fix | Delete

`date_created` char(15) DEFAULT NULL,

[468] Fix | Delete

PRIMARY KEY (`id`)

[469] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[470] Fix | Delete

[471] Fix | Delete

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

[472] Fix | Delete

[473] Fix | Delete

[474] Fix | Delete

-- Table structure for table `department`

[475] Fix | Delete

[476] Fix | Delete

[477] Fix | Delete

CREATE TABLE `department` (

[478] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[479] Fix | Delete

`title` varchar(255) DEFAULT NULL,

[480] Fix | Delete

`group_id` int(10) unsigned NOT NULL,

[481] Fix | Delete

`colour_code` varchar(255) DEFAULT NULL,

[482] Fix | Delete

`date_created` char(255) DEFAULT NULL,

[483] Fix | Delete

`active` tinyint(3) unsigned NOT NULL DEFAULT '1',

[484] Fix | Delete

PRIMARY KEY (`id`)

[485] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[486] Fix | Delete

[487] Fix | Delete

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

[488] Fix | Delete

[489] Fix | Delete

[490] Fix | Delete

-- Table structure for table `discussions`

[491] Fix | Delete

[492] Fix | Delete

[493] Fix | Delete

CREATE TABLE `discussions` (

[494] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[495] Fix | Delete

`category_id` int(11) NOT NULL,

[496] Fix | Delete

`title` varchar(255) DEFAULT NULL,

[497] Fix | Delete

`creator_user_id` int(11) DEFAULT NULL,

[498] Fix | Delete

`date_created` char(15) DEFAULT NULL,

[499] Fix | Delete

12 3 4 5 6