Файловый менеджер - Редактировать - /var/www/html/administrator/components/com_jssupportticket/sql/install.mysql.sql
Ðазад
CREATE TABLE IF NOT EXISTS `#__js_ticket_acl_permissions` (`id` int(11) NOT NULL, `permission` varchar(45) DEFAULT NULL, `permissiongroup` int(11) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8; INSERT INTO `#__js_ticket_acl_permissions` (`id`, `permission`, `permissiongroup`, `status`) VALUES (1, 'ADD_TICKET', 1, 1), (2, 'EDIT_TICKET', 1, 1), (3, 'CLOSE_TICKET', 1, 1), (4, 'REOPEN_TICKET', 1, 1), (5, 'REPLY_TICKET', 1, 1), (6, 'ASSIGN_TICKET_TO_STAFF', 1, 1), (7, 'TICKET_DEPARTMENT_TRANSFER', 1, 1), (8, 'MARK_OVERDUE', 1, 1), (9, 'MARK_INPROGRESS', 1, 1), (10, 'CHANGE_TICKET_PERORITY', 1, 1), (11, 'UNBAN_EMAIL', 1, 1), (12, 'DELETE_TICKET', 1, 1), (13, 'BAN_EMAIL_AND_CLOSE_TICKET', 1, 1), (14, 'LOCK_TICKET', 1, 1), (15, 'ATTACHMENT', 1, 1), (16, 'POST_INTERNAL_NOTE', 1, 1), (17, 'ADD_ROLE', 2, 1), (18, 'ASSIGN_ROLE_PERMISSIONS', 2, 1), (19, 'EDIT_ROLE', 2, 1), (20, 'ASSIGN_ROLE_TO_USER', 2, 1), (21, 'ADD_USER', 2, 1), (22, 'EDIT_USER', 2, 1), (23, 'ASSIGN_USER_PERMISSIONS', 2, 1), (24, 'ADD_DEPARTMENT', 2, 1), (25, 'EDIT_DEPARTMENT', 2, 1), (26, 'DELETE_DEPARTMENT', 2, 1), (27, 'VIEW_DEPARTMENT', 2, 1), (28, 'DELETE_ROLE', 2, 1), (29, 'DELETE_USER', 2, 1), (30, 'MAIL_TO_STAFF', 2, 1), (31, 'ADD_KB_CATEGORY', 3, 1), (32, 'ADD_KB_ARTICLE', 3, 1), (33, 'EDIT_KB_CATEGORY', 3, 1), (34, 'EDIT_KB_ARTICLE', 3, 1), (35, 'VIEW_KB_CATEGORY', 3, 1), (36, 'VIEW_KB_ARTICLE', 3, 1), (37, 'DELETE_KB_CATEGORY', 3, 1), (38, 'DELETE_KB_ARTICLE', 3, 1), (39, 'ADD_FAQ', 4, 1), (40, 'EDIT_FAQ', 4, 1), (41, 'VIEW_FAQ', 4, 1), (42, 'DELETE_FAQ', 4, 1), (43, 'ADD_DOWNLOAD', 5, 1), (44, 'EDIT_DOWNLOAD', 5, 1), (45, 'VIEW_DOWNLOAD', 5, 1), (46, 'DELETE_DOWNLOAD', 5, 1), (47, 'ADD_ANNOUNCEMENT', 6, 1), (48, 'EDIT_ANNOUNCEMENT', 6, 1), (49, 'VIEW_ANNOUNCEMENT', 6, 1), (50, 'DELETE_ANNOUNCEMENT', 6, 1), (51, 'VIEW_ROLE', 2, 1), (52, 'VIEW_USER', 2, 1), (53, 'DUEDATE_TICKET', 1, 1), (54, 'VIEW_TICKET', 1, 1), (55, 'SHOW_ONLY_ASSIGN_TICKETS', 1, 1), (56, 'SHOW_ALL_TICKETS', 1, 1), (58, 'RELEASE_TICKET', 1, 1), (59, 'ALLOW_MAIL_SYSTEM', 7, 1); CREATE TABLE IF NOT EXISTS `#__js_ticket_acl_roles` (`id` int(11) NOT NULL, `name` varchar(255) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `parentid` int(11) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; INSERT INTO `#__js_ticket_acl_roles` (`id`, `name`, `status`, `parentid`, `created`) VALUES (1, 'Manager', 1, NULL, '2015-03-30 06:03:07'); CREATE TABLE IF NOT EXISTS `#__js_ticket_acl_role_access_departments` (`id` int(11) NOT NULL, `roleid` int(11) DEFAULT NULL, `departmentid` int(11) DEFAULT NULL, `status` tinyint(4) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8; INSERT INTO `#__js_ticket_acl_role_access_departments` (`roleid`, `departmentid`, `status`, `created`) VALUES (1, 1, 1, '2015-05-29 14:39:21'); CREATE TABLE IF NOT EXISTS `#__js_ticket_acl_role_permissions` (`id` int(11) NOT NULL, `roleid` int(11) DEFAULT NULL, `permissionid` int(11) DEFAULT NULL, `grant` tinyint(4) DEFAULT NULL, `status` tinyint(4) DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=826 DEFAULT CHARSET=utf8; INSERT INTO `#__js_ticket_acl_role_permissions` (`roleid`, `permissionid`, `grant`, `status`) VALUES (1, 50, 1, 1), (1, 49, 1, 1), (1, 48, 1, 1), (1, 47, 1, 1), (1, 46, 1, 1), (1, 45, 1, 1), (1, 44, 1, 1), (1, 43, 1, 1), (1, 42, 1, 1), (1, 41, 1, 1), (1, 40, 1, 1), (1, 39, 1, 1), (1, 38, 1, 1), (1, 37, 1, 1), (1, 36, 1, 1), (1, 35, 1, 1), (1, 34, 1, 1), (1, 33, 1, 1), (1, 32, 1, 1), (1, 31, 1, 1), (1, 52, 1, 1), (1, 51, 1, 1), (1, 30, 1, 1), (1, 29, 1, 1), (1, 28, 1, 1), (1, 27, 1, 1), (1, 26, 1, 1), (1, 25, 1, 1), (1, 24, 1, 1), (1, 23, 1, 1), (1, 22, 1, 1), (1, 21, 1, 1), (1, 20, 1, 1), (1, 19, 1, 1), (1, 18, 1, 1), (1, 17, 1, 1), (1, 58, 1, 1), (1, 56, 1, 1), (1, 55, 1, 1), (1, 54, 1, 1), (1, 53, 1, 1), (1, 16, 1, 1), (1, 15, 1, 1), (1, 14, 1, 1), (1, 13, 1, 1), (1, 12, 1, 1), (1, 5, 1, 1), (1, 4, 1, 1), (1, 3, 1, 1), (1, 6, 1, 1), (1, 2, 1, 1), (1, 1, 1, 1), (1, 11, 1, 1), (1, 10, 1, 1), (1, 9, 1, 1), (1, 8, 1, 1), (1, 7, 1, 1); CREATE TABLE IF NOT EXISTS `#__js_ticket_acl_user_access_departments` (`id` int(11) NOT NULL, `uid` int(11) DEFAULT NULL, `roleid` int(11) DEFAULT NULL, `staffid` int(11) DEFAULT NULL, `departmentid` int(11) DEFAULT NULL, `status` tinyint(4) DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=77 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_acl_user_permissions` (`id` int(11) NOT NULL, `uid` int(11) DEFAULT NULL, `roleid` int(11) DEFAULT NULL, `staffid` int(11) DEFAULT NULL, `permissionid` int(11) DEFAULT NULL, `grant` tinyint(4) DEFAULT NULL, `status` tinyint(4) DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=1391 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_activity_log` (`id` int(11) NOT NULL, `uid` int(11) DEFAULT NULL, `referenceid` int(11) DEFAULT NULL, `level` int(2) DEFAULT NULL, `eventfor` int(2) DEFAULT NULL, `event` varchar(255) DEFAULT NULL, `eventtype` varchar(255) DEFAULT NULL, `message` text, `messagetype` varchar(255) DEFAULT NULL, `datetime` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=348 DEFAULT CHARSET=utf8 COMMENT='utf8_general_ci'; CREATE TABLE IF NOT EXISTS `#__js_ticket_announcements` (`id` int(11) NOT NULL, `categoryid` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `description` text, `staffid` int(11) DEFAULT NULL, `type` tinyint(3) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=115 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_articles` (`id` int(11) NOT NULL, `categoryid` int(11) DEFAULT NULL, `staffid` int(11) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `content` text, `views` int(11) DEFAULT NULL, `type` tinyint(4) DEFAULT NULL, `ordering` tinyint(4) DEFAULT NULL, `metadesc` varchar(60) DEFAULT NULL, `metakey` varchar(60) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_articles_attachments` (`id` int(11) NOT NULL, `articleid` int(11) DEFAULT NULL, `filename` varchar(45) DEFAULT NULL, `filesize` varchar(45) DEFAULT NULL, `filetype` varchar(45) DEFAULT NULL, `staffid` int(11) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_attachments` (`id` int(11) NOT NULL, `ticketid` int(11) DEFAULT NULL, `replyattachmentid` int(11) DEFAULT NULL, `filesize` varchar(32) DEFAULT NULL, `filename` varchar(128) DEFAULT NULL, `filekey` varchar(128) DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_banlist_log` (`id` int(11) NOT NULL, `loggeremail` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `log` text, `logger` varchar(64) DEFAULT NULL, `ipaddress` varchar(16) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_categories` (`id` int(11) NOT NULL, `name` varchar(45) DEFAULT NULL, `parentid` int(11) DEFAULT NULL, `totalarticles` smallint(6) DEFAULT NULL, `hits` int(11) DEFAULT NULL, `metadesc` varchar(60) DEFAULT NULL, `metakey` varchar(60) DEFAULT NULL, `logo` varchar(45) DEFAULT NULL, `downloads` tinyint(4) DEFAULT NULL, `announcement` tinyint(4) DEFAULT NULL, `faqs` tinyint(4) DEFAULT NULL, `kb` tinyint(4) DEFAULT NULL, `staffid` int(11) DEFAULT NULL, `ordering` tinyint(4) DEFAULT NULL, `type` tinyint(4) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_config` (`configname` varchar(100) NOT NULL DEFAULT '', `configvalue` varchar(255) NOT NULL DEFAULT '', `configfor` varchar(50) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `#__js_ticket_config` (`configname`, `configvalue`, `configfor`) VALUES ('priority', '3', 'default'), ('ticket_per_email', '10', 'ticket'), ('cplink_myticket_staff', '1', 'cplink'), ('reopened_ticket_auto_assign', '1', 'ticket'), ('assigned_ticket_open_queue', '1', 'ticket'), ('answered_ticket_open_queue', '1', 'ticket'), ('alert_email', '1', 'email'), ('sys_email', 'shoaibrehmat@burujsolutions.com', 'email'), ('admin_email', '1', 'email'), ('ticket_department_transfer_admin', '1', 'email'), ('ticket_ban_email_admin', '1', 'email'), ('ticket_ban_email_user', '1', 'email'), ('new_ticket_admin', '1', 'email'), ('new_ticket_staff', '1', 'email'), ('new_staff_admin', '1', 'email'), ('new_group_admin', '1', 'email'), ('new_depatment_admin', '1', 'email'), ('new_help_topic_admin', '1', 'email'), ('theme', 'golden/css/jsticketsgolden.css', 'default'), ('title', 'System Offline', 'default'), ('data_directory', 'jsticketdata', 'default'), ('fr_cr_txsh', '1', 'default'), ('fr_cr_txb', '<br>©Copyright 2008 - 2010, <a href="http://www.burujsolutions.com" target="_blank">Buruj Solutions </a> ', 'default'), ('backuponuninstall', '1', 'default'), ('offline', '0', 'default'), ('offline_text', 'system down please come back as soon as possible.', 'default'), ('ticket_lock_admin', '1', 'email'), ('payment_method', 'paypal', 'payment'), ('payment_shopingurl', '', 'payment'), ('payment_successefulurl', '', 'payment'), ('payment_cancelurl', '', 'payment'), ('payment_paypalaccount', '', 'payment'), ('payment_showdescription', '1', 'payment'), ('payment_description', 'Description', 'payment'), ('payment_showfooter', '1', 'payment'), ('payment_currency', 'USD', 'payment'), ('payment_authtoken', '', 'payment'), ('payment_test_mode', '1', 'payment'), ('date_format', 'Y-m-d', 'default'), ('ticket_unbanemail_staff', '1', 'email'), ('ticket_unbanemail_user', '1', 'email'), ('ticket_unbanemail_admin', '1', 'email'), ('ticket_ban_and_close_staff', '1', 'email'), ('ticket_ban_and_close_user', '1', 'email'), ('ticket_ban_and_close_admin', '1', 'email'), ('mailfromname', 'JS Tickets', 'email'), ('ticket_response_staff_user', '1', 'email'), ('ticket_response_staff_staff', '1', 'email'), ('ticket_response_staff_admin', '1', 'email'), ('ticket_reply_user_admin', '1', 'email'), ('ticket_department_transfer_user', '1', 'email'), ('ticket_reassign_admin', '1', 'email'), ('ticket_reassign_staff', '1', 'email'), ('ticket_reassign_user', '1', 'email'), ('ticket_close_admin', '1', 'email'), ('ticket_close_staff', '1', 'email'), ('ticket_close_user', '1', 'email'), ('ticket_delete_admin', '1', 'email'), ('ticket_delete_staff', '1', 'email'), ('ticket_delete_user', '1', 'email'), ('ticket_overdue_admin', '1', 'email'), ('ticket_overdue_staff', '1', 'email'), ('ticket_overdue_user', '1', 'email'), ('system_email', '1', 'email'), ('cur_location', '0', 'default'), ('fr_cr_txa', '<img src="components/com_jsjobs/images/jsjobs_logo_small.png" width="65"> Powered by <a href="https://www.joomsky.com" target="_blank">Joom Sky</a>', 'default'), ('api_primary', 'a2d09c7d76fced01f8be4b1f4cce8bec', 'api'), ('api_secondary', '', 'api'), ('filesize', '1024', 'default'), ('fileextension', 'doc,pdf,jpg,jpeg,txt,gif,png', 'default'), ('ticket_department_transfer_staff', '1', 'email'), ('ticket_ban_email_staff', '1', 'email'), ('ticket_reply_user_staff', '1', 'email'), ('staff_knowledgebase_articles', '1', 'knowledgebase'), ('staff_knowledgebase_category', '1', 'knowledgebase'), ('knowledgebase_articles_per_row', '2', 'knowledgebase'), ('banemail_new_ticket_admin', '1', 'email'), ('noofattachment', '5', 'default'), ('can_append_message', '1', 'email'), ('visitor_can_create_ticket', '0', 'default'), ('ticket_reopen_within_days', '2', 'ticket'), ('show_captcha_visitor_form_ticket', '0', 'default'), ('defaultalert', '0', 'default'), ('tvalue', '0', 'version'), ('version', '1.1.3', 'version'), ('versioncode', '113', 'version'), ('versiontype', 'business', 'version'), ('ticket_overdue_indays', '2', 'default'), ('knowledgebase_enable', '1', 'default'), ('ticket_auto_close_indays', '2', 'default'), ('cplink_openticket_staff', '1', 'cplink'), ('ticket_reply_user_user', '1', 'email'), ('ticket_lock_user', '1', 'email'), ('ticket_lock_staff', '1', 'email'), ('cplink_addrole_staff', '1', 'cplink'), ('cplink_roles_staff', '1', 'cplink'), ('cplink_addstaff_staff', '1', 'cplink'), ('cplink_staff_staff', '1', 'cplink'), ('cplink_adddepartment_staff', '1', 'cplink'), ('cplink_department_staff', '1', 'cplink'), ('cplink_addcategory_staff', '1', 'cplink'), ('cplink_category_staff', '1', 'cplink'), ('cplink_addkb_staff', '1', 'cplink'), ('cplink_kb_staff', '1', 'cplink'), ('cplink_adddownload_staff', '1', 'cplink'), ('cplink_download_staff', '1', 'cplink'), ('cplink_addannouncement_staff', '1', 'cplink'), ('cplink_announcement_staff', '1', 'cplink'), ('cplink_addfaq_staff', '1', 'cplink'), ('cplink_faq_staff', '1', 'cplink'), ('cplink_mail_staff', '1', 'cplink'), ('cplink_profile_staff', '1', 'cplink'), ('tplink_home_staff', '1', 'tplink'), ('tplink_ticket_staff', '1', 'tplink'), ('tplink_kb_staff', '1', 'tplink'), ('tplink_announcement_staff', '1', 'tplink'), ('tplink_download_staff', '1', 'tplink'), ('tplink_faq_staff', '1', 'tplink'), ('cplink_openticket_user', '1', 'cplink'), ('cplink_myticket_user', '1', 'cplink'), ('cplink_checkstatus_user', '1', 'cplink'), ('cplink_download_user', '1', 'cplink'), ('cplink_announcement_user', '1', 'cplink'), ('cplink_faq_user', '1', 'cplink'), ('cplink_kb_user', '1', 'cplink'), ('tplink_home_user', '1', 'tplink'), ('tplink_ticket_user', '1', 'tplink'), ('tplink_kb_user', '1', 'tplink'), ('tplink_announcement_user', '1', 'tplink'), ('tplink_download_user', '1', 'tplink'), ('tplink_faq_user', '1', 'tplink'), ('show_count_tickets', '1', 'default'), ('maximum_ticket', '10', 'default'),('cplink_userdata_user', '1', 'cplink'),('cplink_userdata_staff', '1', 'cplink'),('erase_data_request_user', '1', 'email'),('erase_data_request_admin', '1', 'email'),('delete_user_data', '1', 'email'); CREATE TABLE IF NOT EXISTS `#__js_ticket_departments` (`id` int(11) NOT NULL, `emailtemplateid` int(11) DEFAULT NULL, `emailid` int(11) DEFAULT NULL, `autoresponceemailid` int(11) DEFAULT NULL, `managerid` int(11) DEFAULT NULL, `departmentname` varchar(32) DEFAULT NULL, `departmentsignature` text, `ispublic` tinyint(1) DEFAULT NULL, `ticketautoresponce` tinyint(1) DEFAULT NULL, `messageautoresponce` tinyint(1) DEFAULT NULL, `canappendsignature` tinyint(1) DEFAULT NULL, `update` datetime DEFAULT NULL, `created` datetime DEFAULT NULL, `status` tinyint(1) DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; INSERT INTO `#__js_ticket_departments` (`emailid`, `departmentname`, `departmentsignature`, `ispublic`, `ticketautoresponce`, `messageautoresponce`, `canappendsignature`, `update`, `created`, `status`) VALUES (1, 'Support', '--Support Signature--', 0, 0, 0, 0, '2015-04-25 11:24:08', '0000-00-00 00:00:00', 1); CREATE TABLE IF NOT EXISTS `#__js_ticket_department_message_premade` (`id` int(11) NOT NULL, `departmentid` varchar(45) DEFAULT NULL, `isenabled` tinyint(1) DEFAULT NULL, `title` varchar(125) DEFAULT NULL, `answer` text, `created` datetime DEFAULT NULL, `update` datetime DEFAULT NULL, `status` tinyint(1) DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_downloads` (`id` int(11) NOT NULL, `categoryid` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `description` text, `staffid` int(11) DEFAULT NULL, `ordering` tinyint(4) DEFAULT NULL, `downloads` int(11) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_downloads_attachments` (`id` int(11) NOT NULL, `downloadid` int(11) DEFAULT NULL, `filename` varchar(45) DEFAULT NULL, `filesize` varchar(45) DEFAULT NULL, `filetype` varchar(45) DEFAULT NULL, `staffid` int(11) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_email` (`id` int(11) NOT NULL, `autoresponce` tinyint(1) DEFAULT NULL, `priorityid` int(11) DEFAULT NULL, `departmentid` int(11) DEFAULT NULL, `email` varchar(125) DEFAULT NULL, `name` varchar(32) DEFAULT NULL, `uid` int(11) DEFAULT NULL, `password` varchar(125) DEFAULT NULL COMMENT ' ', `status` tinyint(1) DEFAULT NULL, `mailhost` varchar(125) DEFAULT NULL, `mailprotocol` enum('pop','map') DEFAULT NULL, `mailencryption` enum('NONE','SSL') DEFAULT NULL, `mailport` smallint(6) DEFAULT NULL, `mailfetchfrequency` tinyint(3) DEFAULT NULL, `mailfetchmaximum` tinyint(4) DEFAULT NULL, `maildeleted` tinyint(1) DEFAULT NULL, `mailerrors` tinyint(3) DEFAULT NULL, `maillasterror` datetime DEFAULT NULL, `maillastfetch` datetime DEFAULT NULL, `smtpactive` tinyint(1) DEFAULT NULL, `smtphost` varchar(125) DEFAULT NULL, `smtpport` smallint(6) DEFAULT NULL, `smtpsecure` tinyint(1) DEFAULT NULL, `smtpauthencation` tinyint(1) DEFAULT NULL, `created` datetime DEFAULT NULL, `update` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_emailtemplates` (`id` int(11) NOT NULL, `templatefor` varchar(50) DEFAULT NULL, `title` varchar(50) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `body` text, `created` datetime DEFAULT NULL, `status` tinyint(1) DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8; INSERT INTO `#__js_ticket_emailtemplates` (`id`, `templatefor`, `title`, `subject`, `body`, `created`, `status`) VALUES (1, 'ticket-new', '', 'JS Tickets: New Ticket Received', '<p>Dear {USERNAME},<br /><br />Your support ticket <strong>{SUBJECT}</strong> has been submitted. We try to reply to all tickets as soon as possible, usually within 24 hours.<br /><br />Your tracking ID: {TRACKINGID}</p>\r\n<p>Your Email ID: {EMAIL}</p>\r\n<p>Ticket message: {MESSAGE}</p>\r\n<p><br />You can view the status of your ticket here:<br /> {TICKETURL}<br /><br />You will receive an e-mail notification when our staff replies to your ticket.<br /><br /><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-21 11:09:00', 1), (6, 'reassign-tk', NULL, 'JS Tickets: Reassign Tickets', '<p>Sucess: Ticket Reassign</p>\r\n<p>Your ticket has been successfully Reassign! Ticket ID:{TRACKINGID} is Reassign to Staff Member:{STAFF_MEMBER_TITLE}</p>\r\n<p>You can manage this ticket here</p>\r\n<p>{TICKETURL}</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL********</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:17:43', NULL), (7, 'close-tk', NULL, 'JS Tickets: Close Tickets', '<p>Ticket Close</p>\r\n<p>Ticket ID:{TRACKINGID} is Closed.</p>\r\n<p>You can manage this ticket here</p>\r\n<p>{TICKETURL}</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL********</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:17:54', NULL), (8, 'delete-tk', NULL, 'JS Tickets: Delete Tickets', '<p>Ticket Deleted</p>\r\n<p>Ticket ID:{TRACKINGID} is Deleted.</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL**********</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:05', NULL), (9, 'moverdue-tk', NULL, 'JS Tickets: Markoverdue Tickets', '<p>Ticket Markoverdue</p>\r\n<p>Ticket ID:{TRACKINGID} is Markoverdue.</p>\r\n<p>You can manage this ticket here</p>\r\n<p>{TICKETURL}</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL****************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:12', NULL), (10, 'banemail-tk', '', 'JS Tickets: Email Banedd', '<p>Email Baned</p>\r\n<p>This email {EMAIL_ADDRESS} is Baned.</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL****************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:20', NULL), (11, 'deptrans-tk', NULL, 'JS Tickets: Tickets Transfer to Department{DEPARTMENT_TITLE', '<p>Ticket transfer to department</p>\r\n<p>Ticket ID: {TRACKINGID} is transfer to department{DEPARTMENT_TITLE}.</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL***************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:29', NULL), (12, 'banemailcloseticket-tk', NULL, 'JS Tickets: Email Baned and ticket close', '<p>Email Baned and ticket close</p>\r\n<p>This email {EMAIL_ADDRESS} is Baned and ticket ID:{TICKETID} is closed.</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:37', NULL), (13, 'unbanemail-tk', NULL, 'JS Tickets: Email Unbaneded', '<p>Email Unbaned</p>\r\n<p>This email {EMAIL_ADDRESS} is Unbaned</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*******************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:44', NULL), (14, 'reply-tk', NULL, 'JS Tickets: Ticket Reploies', '<p>Hello,<br /><br />A new reply of ticket <strong>{SUBJECT}</strong>has been submitted.</p>\r\n<p>User Name: {USERNAME}</p>\r\n<p>Tracking ID: {TRACKINGID}</p>\r\n<p>Email: {EMAIL}</p>\r\n<p>Message: {MESSAGE}</p>\r\n<p><br />You can manage this ticket here:<br /> {TICKETURL}<br /><br /><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL***************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:19:08', NULL), (15, 'responce-tk', NULL, 'JS Tickets: Ticket Responces', '<p>Hello,<br /><br />Staff just reply of your ticket <strong>{SUBJECT}</strong>.</p>\r\n<p>User Name: {USERNAME}</p>\r\n<p>Tracking ID: {TRACKINGID}</p>\r\n<p>Email: {EMAIL}</p>\r\n<p>Message: {MESSAGE}</p>\r\n<p><br />You can manage this ticket here:<br /> {TICKETURL}<br /><br /><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL***************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:52', NULL), (16, 'ticket-staff', '', 'JS Tickets: New Tickets', '<p>Sucess: Ticket Submitted</p>\r\n<p>New ticket <strong>{SUBJECT}</strong> has been submitted with the following details.<br /><br />Tracking ID: {TRACKINGID}</p>\r\n<p>Email ID: {EMAIL}s</p>\r\n<p>Ticket message: {MESSAGE}</p>\r\n<p>Help Topic: {HELP_TOPIC}</p>\r\n<p><br />You can view the status of your ticket here:<br /> {TICKETURL}<br /><br />You will receive an e-mail notification when our staff replies to your ticket.<br /><br /><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 06:43:31', NULL), (17, 'banemail-trtk', NULL, 'JS Tickets: Banemaild try new ticket', '<p>Hello Admin ,</p>\r\n<p>This email {EMAIL_ADDRESS} is baned and try open new ticket .</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL**************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:19:19', NULL), (18, 'ticket-new-admin', '', 'JS Tickets: New Tickets Received', '<p>Hello,<br /><br />A new support ticket <strong>{SUBJECT}</strong> has been submitted. Ticket details.<br /><br />Tracking ID: {TRACKINGID}</p>\r\n<p>Email ID: {EMAIL}</p>\r\n<p>Ticket message: {MESSAGE}</p>\r\n<p><br />You can manage this ticket here:<br /> {TICKETURL}<br /><br /><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*****************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-21 11:08:28', 1), (2, 'department-new', NULL, 'JS Ticket : New Department {DEPARTMENT_TITLE} has beed received', '<p>Hello Admin ,,,,,</p>\r\n<p>We receive new department.</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:15:12', NULL), (3, 'group-new', NULL, 'JS Tickets : New Group {GROUP_TITLE} has beed received', '<p>Hello Admin ,</p>\r\n<p>We receive new group.</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:17:17', NULL), (4, 'staff-new', NULL, 'JS Tickets: New Staff Member {STAFF_MEMBER_TITLE} has beed received', '<p>Hello Admin,</p>\r\n<p>We receive new staff member.</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL*</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:17:26', NULL), (5, 'helptopic-new', NULL, 'JS Tickets : New Help Topic {HELPTOPIC_TITLE} has beed received', '<p>Hello Admin ,</p>\r\n<p>We receive new help topic {HELPTOPIC_TITLE} of department {DEPARTMENT_TITLE}.</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL******</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:17:34', NULL), (19, 'lock-tk', NULL, 'JS Tickets: Lock Ticket', '<p>Ticket Lock</p>\r\n<p>Ticket ID:{TRACKINGID} is Lock.</p>\r\n<p>You can manage this ticket here</p>\r\n<p>{TICKETURL}</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL****************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:12', NULL), (20, 'unlock-tk', NULL, 'JS Tickets: Unlock Ticket', '<p>Ticket unLock</p>\r\n<p>Ticket ID:{TRACKINGID} is unlock.</p>\r\n<p>You can manage this ticket here</p>\r\n<p>{TICKETURL}</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL****************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:12', NULL), (21, 'markprgs-tk', NULL, 'JS Tickets: Mark in progress Ticket', '<p>Ticket unLock</p>\r\n<p>Ticket ID:{TRACKINGID} is mark in progress ticket.</p>\r\n<p>You can manage this ticket here</p>\r\n<p>{TICKETURL}</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL****************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:12', NULL), (22, 'pchnge-tk', NULL, 'JS Tickets: Priority change Ticket', '<p>Ticket priority changed</p>\r\n<p>Ticket ID:{TRACKINGID} is priority changed.</p>\r\n<p>You can manage this ticket here</p>\r\n<p>{TICKETURL}</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL****************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:12', NULL), (23, 'mlnew-tk', NULL, 'JS Tickets: New mail', '<p>Internal Mail</p>\r\n<p>New internal mail received.</p>\r\n<p>You can manage this mail here</p>\r\n<p>{TICKETURL}</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL****************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:12', NULL), (24, 'mlrep-tk', NULL, 'JS Tickets: New mail reply', '<p>Internal Mail Reply</p>\r\n<p>New internal mail reply received.</p>\r\n<p>You can manage this mail here</p>\r\n<p>{TICKETURL}</p>\r\n<p><span style="color: red;"><strong>*DO NOT REPLY TO THIS E-MAIL****************</strong></span><br />This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2012-07-22 07:18:12', NULL), (25, 'delete-user-data', '', '{SITETITLE}: Delete User Data', '<p><span style="font-size: 12.16px;"><strong>{SITETITLE}: Data Delete request</strong></span></p><p>Your data delete request has been received.</p><p><span style="color: red;"> <strong>*DO NOT REPLY TO THIS E-MAIL*</strong> </span> <br /> This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2017-04-03 11:09:00', '1'), (26, 'delete-user-data-admin', '', '{SITETITLE}: User erase data request', '<p><span style="font-size: 12.16px;"><strong>{SITETITLE}: User erase data request</strong></span></p> <p>{USERNAME} has been submitted a request for erasing data.</p> <p><span style="color: red;"> <strong>*DO NOT REPLY TO THIS E-MAIL*</strong> </span> <br /> This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2017-04-03 11:09:00', '1'), (27, 'user-data-deleted', '', '{SITETITLE}: Data deleted successfully', '<p>Your data has been deleted successfully</p> <p><span style="color: red;"> <strong>*DO NOT REPLY TO THIS E-MAIL*</strong> </span> <br /> This is an automated e-mail message sent from our support system. Do not reply to this e-mail as we wonot receive your reply!</p>', '2017-04-03 11:09:00', '1'); CREATE TABLE IF NOT EXISTS `#__js_ticket_email_banlist` (`id` int(11) NOT NULL, `email` varchar(255) DEFAULT NULL, `submitter` varchar(126) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_faqs` (`id` int(11) NOT NULL, `categoryid` int(11) DEFAULT NULL, `staffid` int(11) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `content` text, `views` tinyint(4) DEFAULT NULL, `created` datetime DEFAULT NULL, `status` tinyint(1) DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=233 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_fieldsordering` (`id` int(11) NOT NULL, `field` varchar(50) NOT NULL, `fieldtitle` varchar(50) DEFAULT NULL, `ordering` int(11) DEFAULT NULL, `section` varchar(20) DEFAULT NULL, `fieldfor` tinyint(2) DEFAULT NULL, `published` tinyint(1) DEFAULT NULL, `sys` tinyint(1) NOT NULL, `cannotunpublish` tinyint(1) NOT NULL, `required` tinyint(1) NOT NULL DEFAULT '0') ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; INSERT INTO `#__js_ticket_fieldsordering` (`id`, `field`, `fieldtitle`, `ordering`, `section`, `fieldfor`, `published`, `sys`, `cannotunpublish`, `required`) VALUES (1, 'emailaddress', 'Email Address', 1, '10', 1, 0, 0, 1, 1), (2, 'fullname', 'Full Name', 3, '10', 1, 1, 0, 1, 1), (3, 'phone', 'Phone', 4, '10', 1, 1, 0, 0, 1), (4, 'department', 'Department', 5, '10', 1, 1, 0, 1, 1), (5, 'helptopic', 'Help Topic', 6, '10', 1, 1, 0, 1, 1), (6, 'priority', 'Priority', 2, '10', 1, 1, 0, 1, 1), (7, 'subject', 'Subject', 8, '10', 1, 1, 0, 1, 1), (8, 'premade', 'Premade', 7, '10', 1, 1, 0, 0, 1), (9, 'issuesummary', 'Issue Summary', 10, '10', 1, 1, 0, 1, 1), (10, 'attachments', 'Attachments', 9, '10', 1, 1, 0, 0, 1), (11, 'internalnotetitle', 'Internal Note Title', 11, '10', 1, 1, 0, 0, 1), (12, 'assignto', 'Assign To', 14, '10', 1, 1, 0, 0, 1), (13, 'duedate', 'Due Date', 12, '10', 1, 1, 0, 0, 1), (14, 'status', 'Status', 13, '10', 1, 1, 0, 0, 1), (15, 'users', 'User', 13, '10', 1, 1, 0, 0, 1); CREATE TABLE IF NOT EXISTS `#__js_ticket_help_topics` (`id` int(11) NOT NULL, `isactive` tinyint(1) DEFAULT NULL, `autoresponce` tinyint(1) DEFAULT NULL, `departmentid` int(11) DEFAULT NULL, `priorityid` int(11) DEFAULT NULL, `topic` varchar(32) DEFAULT NULL, `created` datetime DEFAULT NULL, `update` datetime DEFAULT NULL, `status` tinyint(1) DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_notes` (`id` int(11) NOT NULL, `ticketid` int(11) DEFAULT NULL, `staffid` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `note` text, `status` tinyint(1) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_priorities` (`id` int(11) NOT NULL, `priority` varchar(60) DEFAULT NULL, `prioritycolour` varchar(7) DEFAULT NULL, `priorityurgency` int(1) DEFAULT NULL, `ispublic` varchar(45) DEFAULT NULL, `isdefault` tinyint(1) DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT '0') ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; INSERT INTO `#__js_ticket_priorities` (`id`, `priority`, `prioritycolour`, `priorityurgency`, `ispublic`, `isdefault`, `status`) VALUES (1, 'High', '#ee1d24', NULL, '1', 0, 0), (2, 'low', '#00aeef', NULL, '1', 0, 0), (3, 'Normal', '#00a650', NULL, '1', 1, 0); CREATE TABLE IF NOT EXISTS `#__js_ticket_replies` (`id` int(11) NOT NULL, `ticketid` int(11) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `message` text, `staffid` int(11) DEFAULT NULL, `rating` enum('1','5') DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `created` datetime DEFAULT NULL, `ticketviaemail` tinyint(1) NOT NULL ) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_staff` (`id` int(11) NOT NULL, `uid` int(11) DEFAULT NULL, `groupid` int(11) DEFAULT NULL, `roleid` int(11) DEFAULT NULL, `departmentid` int(11) DEFAULT NULL, `firstname` varchar(128) DEFAULT NULL, `lastname` varchar(128) DEFAULT NULL, `username` varchar(45) DEFAULT NULL, `email` varchar(128) DEFAULT NULL, `phone` varchar(24) DEFAULT NULL, `phoneext` varchar(6) DEFAULT NULL, `mobile` varchar(24) DEFAULT NULL, `signature` text, `isadmin` tinyint(1) DEFAULT NULL, `isvisible` tinyint(1) DEFAULT NULL, `onvocation` tinyint(1) DEFAULT NULL, `appendsignature` tinyint(1) DEFAULT NULL, `autorefreshrate` tinyint(1) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `created` datetime DEFAULT NULL, `lastlogin` datetime DEFAULT NULL, `update` datetime DEFAULT NULL, `photo` varchar(150) NOT NULL ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_staff_mail` (`id` int(11) NOT NULL, `from` int(11) DEFAULT NULL, `to` int(11) DEFAULT NULL, `message` text, `subject` varchar(255) DEFAULT NULL, `isread` tinyint(1) DEFAULT '0', `replytoid` int(11) DEFAULT NULL, `deletedby` int(11) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_system_errors` (`id` int(11) NOT NULL, `uid` int(11) DEFAULT NULL, `error` text, `isview` tinyint(1) DEFAULT '0', `created` datetime DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_tickets` (`id` int(11) NOT NULL, `uid` int(11) DEFAULT NULL, `ticketid` varchar(11) DEFAULT NULL, `departmentid` int(11) DEFAULT NULL, `priorityid` int(11) DEFAULT NULL, `staffid` int(11) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `message` text, `helptopicid` int(11) DEFAULT NULL, `phone` varchar(16) DEFAULT NULL, `phoneext` varchar(8) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `isoverdue` tinyint(1) DEFAULT NULL, `isanswered` tinyint(1) NOT NULL DEFAULT '0', `duedate` datetime DEFAULT NULL, `reopened` datetime DEFAULT NULL, `closed` datetime DEFAULT NULL, `lastreply` datetime DEFAULT NULL, `created` datetime DEFAULT NULL, `update` datetime DEFAULT NULL, `lock` tinyint(4) NOT NULL DEFAULT '0', `ticketviaemail` tinyint(1) NOT NULL ) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_userfields` (`id` int(11) NOT NULL, `name` varchar(50) NOT NULL DEFAULT '', `title` varchar(255) NOT NULL, `description` mediumtext, `type` varchar(50) NOT NULL DEFAULT '', `maxlength` int(11) DEFAULT NULL, `size` int(11) DEFAULT NULL, `required` tinyint(4) DEFAULT '0', `ordering` int(11) DEFAULT NULL, `cols` int(11) DEFAULT NULL, `rows` int(11) DEFAULT NULL, `value` varchar(50) DEFAULT NULL, `default` int(11) DEFAULT NULL, `published` tinyint(1) NOT NULL DEFAULT '1', `fieldfor` tinyint(2) NOT NULL DEFAULT '0', `readonly` tinyint(1) NOT NULL DEFAULT '0', `calculated` tinyint(1) NOT NULL DEFAULT '0', `sys` tinyint(4) NOT NULL DEFAULT '0', `params` mediumtext ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_userfieldvalues` (`id` int(11) NOT NULL, `field` int(11) NOT NULL DEFAULT '0', `fieldtitle` varchar(255) NOT NULL DEFAULT '', `fieldvalue` varchar(255) NOT NULL, `ordering` int(11) NOT NULL DEFAULT '0', `sys` tinyint(4) NOT NULL DEFAULT '0') ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_userfield_data` (`id` int(10) unsigned NOT NULL, `referenceid` int(11) NOT NULL, `field` int(10) unsigned DEFAULT NULL, `data` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_userrole` (`id` int(11) NOT NULL, `uid` int(11) DEFAULT '0', `roleid` int(11) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `update` datetime DEFAULT NULL, `created` datetime DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__js_ticket_erasedatarequests` (`id` int(11) NOT NULL AUTO_INCREMENT,`uid` int(11) NOT NULL,`subject` varchar(250) NOT NULL,`message` text NOT NULL,`status` int(11) NOT NULL,`created` datetime NOT NULL,PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
| ver. 1.1 | |
.
| PHP 8.4.18 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка