IP : 3.145.202.158Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
mt/
../
ops/
../
phpbb/
../
luxcal/
../
vision/
vision.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `avis_contract_poorders` --
CREATE TABLE `avis_contract_poorders` ( `po_id` int(15) NOT NULL AUTO_INCREMENT, `po_no` int(15) NOT NULL, `po_name` varchar(255) NOT NULL, `po_date` int(15) NOT NULL, `invoice_no` varchar(15) NOT NULL, `invoice_date` int(15) NOT NULL, `po_description` varchar(255) NOT NULL, `contract_id` int(15) NOT NULL, `entry_date` int(15) NOT NULL, `staff_id` int(15) NOT NULL, `license_count` int(15) NOT NULL, `cost` int(15) NOT NULL, `total_cost` int(15) NOT NULL, `attach_ci` varchar(255) NOT NULL, PRIMARY KEY (`po_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Dumping data for table `avis_emailtemplate` --
INSERT INTO `avis_emailtemplate` VALUES (1, 'Client registration', 'Client registration details', 'Hello {username},<br>Thank you for registering with us.<br><br>Your account has been setup and you can now login to our client portal . <br>Client portal url : <a href="{link}">{link}</a><br>Email: {useremail}<br><br> Please reset your password by using following link <br><a href="{resetlink}">{resetlink}<span></span></a><br>Using client portal you can track your existing incidents, submit new incidents and update your profile.<br>', 0, 1, 1, 0, 1, 0, 1), (2, 'Auto responder', '[{ticket_hash}]: {subject}', 'Hello {username},<br> A request for assistance has been received. Our system has created a incident for your issue.<br><br><strong>Following are incident details -</strong><br>Incident ID: {ticket_hash}<br>Subject: {subject}<br>Department: {department}<br>Incident type: {ticket_type}<br>Priority: {priority}<br>Status: {status}<br>Our staff will assist you shortly.<br>You can update or reply your incident online at :<br><a href="{link}">{link}</a><br><br>Login URL as below:<br><span class="nodeLabelBox repTarget "><span class="nodeAttr editGroup "><span class="nodeValue editable "><a href="{login_url}">{login_url}</a></span></span></span>', 0, 1, 2, 0, 1, 0, 1), (3, 'Staff reply', '[{ticket_hash}]: {subject}', ' {reply_message}<br><br><strong>Incident details - </strong><br>Incident ID: {ticket_hash}<br>Subject: {subject}<br>Department: {department}<br>Incident type: {ticket_type}<br>Priority: {priority}<br>Status: {status}<br></br>You can update or reply your incident online at : <br><a href="{link}">{link}</a><br><br>Login to client portal using following link: <br><a href="{login_url}">{login_url}</a><br>', 0, 1, 3, 0, 1, 0, 1), (4, 'Restricted client', 'Restricted client', 'Hello,<br>\r\n<br>\r\nThe email address that you have used to submit incident is not registered in our client portal. While sending email please make sure you use the same email address that you have used while registering with us.<br>\r\n<br>\r\nIf you have not registered to our client portal, we request you to register it and then submit incidents.<br>\r\n<br>\r\nYou can register to our client portal here - <br>\r\n<a href="{link}">{link}</a><br>', 0, 1, 4, 0, 1, 0, 1), (5, 'Reset password', 'Reset password', 'Hello {username}<br> As per your password reset request, Please click on following link to reset your password <br><a href="{resetlink}"> {resetlink}</a>', 0, 1, 5, 0, 1, 0, 1), (6, 'Client approval pending', 'Registration pending for approval', 'Hello {username},<br />\r\n<br />\r\nThank you for registering to our client portal.<br />\r\nYour account is currently being reviewed and once its active you will receive email with login details for our client portal ', 0, 1, 6, 0, 1, 0, 1), (7, 'Incident auto close', 'Incident Auto close', 'This is an automatically generated email alert by our helpdesk system.<br>\r\n<br>\r\nBelow mentioned incident has not been updated in the last 24 hours and will be automatically closed by the system.<br>\r\nIf your issue is already resolved please ignore this email otherwise update your incident with further details so that our staff can assist you.<br>\r\n<br>\r\nIncident Id: {ticket_hash}<br>\r\nSubject: {subject}<br>\r\nDepartment: {department}<br>\r\nIncident type: {ticket_type}<br>\r\nPriority: {priority}<br>\r\nStatus: {status}<br>', 0, 1, 7, 0, 1, 0, 1), (8, 'Alert template', '{alert}[{ticket_hash}]: {subject}', '{ticket_reply}<br>\r\n<br><strong>Incident details :</strong><br>Incident Id: {ticket_hash}<br>Subject: {subject}<br>\r\nDepartment: {department}<br>Incident type: {ticket_type}<br>Priority: {priority}<br>Status: {status}<br>Last replier: {last_replier}<br>', 0, 1, 8, 0, 1, 0, 1), (9, 'Invoice created', 'Invoice created', 'Dear {username},<br> This is a notice that an invoice has been generated on {invoice_date}.<br><br>Invoice #{invoice_hash}<br>Amount Due: {currency_symbol}<span></span>{invoice_amount} {currency}<span></span><br>Due Date: {invoice_duedate}<br><br><strong>Invoice Items</strong><br>{description}<br>Total: {currency_symbol}<span></span>{invoice_amount} {currency}<span></span><br>------------------------------------------------------<br><strong>Sub Total</strong>: {currency_symbol}<span></span>{invoice_amount} {currency}<span></span><br><strong>Total:</strong> {currency_symbol}<span></span>{invoice_amount} {currency} <span></span><br>------------------------------------------------------<br>Check invoice details using following link : <br>{invoice_link}<br>', 0, 1, 9, 0, 1, 0, 1), (10, 'Send email', '[{ticket_hash}]: {subject}', '<strong></strong> {message}', 0, 1, 10, 0, 1, 0, 1), (11, 'Incident forward', '[{ticket_hash}]: {subject}', '{reply_message}', 0, 1, 11, 0, 1, 0, 1), (12, 'No balance', 'Insufficient balance', 'Hello,<br>\r\n<br> \r\n You have opted to open incident for a paid department but your account do not have sufficient funds. Please add funds to your account and then re-open the incident.', 0, 1, 12, 0, 1, 0, 1), (13, 'Staff registration', 'Staff registration details', 'Hello {staff_name},<br>\r\n<div>\r\n Welcome to our help desk staff portal.\r\n<br><br>Your account has been setup and you can now login to staff portal using details below.<br><div>\r\nStaff Portal URL: <a href="{manage_portal_link}">{manage_portal_link} </a><br>\r\nUserName: {user_name}<br>\r\n Please reset your password by using following link<br>\r\n <a href="{resetlink}">{resetlink}</a><br>\r\n<br>\r\nPlease feel free to update your profile, signature and other help desk related settings.<br></div></div>', 0, 1, 13, 0, 1, 0, 1), (14, 'Parser failed', 'Email not parsed for {mail_queue}: {subject}', '<p>Sender : {from_email}<br> To : {mail_queue}<span></span></p><p>Actual message :<br> {message}</p>', 0, 1, 14, 0, 1, 0, 1), (15, 'New blab', 'New blab added', 'Hello {first_name} {last_name},<br> New blab added by {staff_name}. <br><strong>Blab content : </strong><br>{message}<br>{company}<br>{view_blab_link}', 0, 1, 15, 0, 1, 0, 1), (16, 'Client registration verification email', 'Verify email', 'Hello {username},<br> Thank you for registering to our client portal. Please click on following link to verify your email. <br><a href="{verification_link}">{verification_link}</a><br>', 0, 1, 16, 0, 1, 0, 1), (17, 'Change approval', 'Approval request for change', 'Hello {first_name} {last_name},<br><br>Approval request for change {changes_hash} {changes_name} is waiting for your approval. <br> Please visit <a href="{changes_details_link}">{changes_details_link}</a> and confirm your approval.<span></span><br>', 0, 1, 17, 1, 1, 0, 1), (18, 'Contract approval', 'Request for contract approval', 'Hello {first_name} {last_name},<br><br>A new contract {contract_name}(#{contract_number}) is waiting for your approval.<br> Please visit <a href="{contract_approval_link}">{contract_approval_link}</a> and confirm your approval.<br><br>', 0, 1, 18, 0, 1, 0, 1), (19, 'Release approval', 'Approval request for release ', 'Hello {first_name} {last_name},<br><br>Approval request for release {release_hash} {releases_name} is waiting for your approval. <br>Please visit <a href="{releases_approval_link}">{releases_approval_link}</a> and confirm your approval.', 0, 1, 19, 1, 1, 0, 1), (20, 'Alert ITIL template', '{alert} [{problem_hash}{change_hash}{release_hash}]: {subject}', 'Alert : {alert}<br>Hash: {problem_hash}{change_hash}{release_hash} <br><br><strong>Properties :</strong><br>Subject: {subject}<br> Domain: {domain}<br> Priority: {priority}<br> Status: {status}<br>Impact : {impact}<br>Risk : {risk}<br>Type : {type}<br><br>', 0, 1, 20, 1, 1, 0, 1), (21, 'Contract expiry reminder', 'Contract expiry reminder', 'Hello,<br>{contract_name}(#{contract_number})<span></span> is due for renewal and will be expired in next {contract_days} days. <br>Please visit below contract link to view more details<br><a href="{contract_link}">{contract_link}</a><br>', 0, 1, 21, 0, 1, 0, 1), (22, 'Client feedback', 'Please give us your valuable feedback on incident: {ticket_hash}', 'Hello {username},<br><br>We have resolved your incident, Below are details for your request.<br><br>Incident Id: {ticket_hash}<br>Subject: {subject}<br>Department: {department}<br>Incident type: {ticket_type}<br>Priority: {priority}<br>Status: {status}<br>Please give us your feedback on how was your overall experience with our team while resolving your issue.<br>{link}index.php?/feedback/{useremail}/{salt}/{ticket_id}<br><br>Your feedback will help us improve our customer service.<br>', 0, 1, 22, 0, 1, 0, 1), (23, 'New task assigned', 'New task assigned', 'Hello {first_name} {last_name}<br>New task has been assigned to you by {staff_name}<br><br><strong><strong>Following are task details :</strong><strong></strong> </strong><br>Title: {title}<br>Description: {description}<br>Status: {status}<br>Priority: {priority}<br>Start date: {start date}<br>End date: {end date}<br><br>Please click on following link to see task details :<br>{view_task_link}<br><br>', 0, 1, 23, 0, 1, 0, 1), (24, 'New comment added to task', 'New comment added to task : {title}', 'Hello {first_name} {last_name},<br> New comment added to task by {staff_name}<br><br><strong>Task comment details : </strong><br>Title: {title}<br>Comment: {comment}<br><br>Please click on following link to see task details :<br>{view_task_link}<br><br>', 0, 1, 24, 0, 1, 0, 1), (25, 'New forum topic', 'New forum topic added :{topic_title}', 'Hello {username},<br><br>New forum topic added <strong>{topic_title} </strong>in [{domain} > {forum_category} > {forum_title}]<br><strong>Created by</strong> : {poster_name}<br><strong>Details </strong>:<br>{details}<strong><br></strong><strong>Please follow below link </strong>:<br>{topic_link}', 0, 1, 25, 0, 1, 0, 1), (26, 'New reply for forum topic', 'New forum topic comment added : {topic_title}', 'Hello {username},<br><br>New forum topic added <strong>{topic_title}</strong> in [{domain} > {forum_category} > {forum_title}]<br><strong>Created by</strong> : {poster_name}<br><strong>Details</strong>:<br>{details}<br><br>Please follow below link<br>{topic_link}', 0, 1, 26, 0, 1, 0, 1), (27, 'Forum topic approved', 'Forum topic approved :{topic_title}', '<p>Hello {username},</p><p><br>Forum topic <strong>{topic_title} </strong>in [{domain} > {forum_category} > {forum_title}] is approved<br><strong>Created by</strong> : {poster_name}<br><strong>Details </strong>:<br>{details}<strong><br></strong><strong>Please visit below link </strong>:<br>{topic_link}</p>', 0, 1, 27, 0, 1, 0, 1), (28, 'Topic comment approved', 'Forum topic comment approved', '<p>Hello {username},</p><p><br>Forum topic <strong>{topic_title} </strong>in [{domain} > {forum_category} > {forum_title}] comment is approved<br><strong>Created by</strong> : {poster_name}<br><strong>Details </strong>:<br>{details}<strong><br></strong><strong>Please visit below link </strong>:<br>{topic_link}</p>', 0, 1, 28, 0, 1, 0, 1), (29, 'Report download', ' Helpdesk report - {report_title}', '<p>Report available for download .<br><a href="{download_report_link}">{download_report_link}</a><br><br></p>', 0, 1, 29, 0, 1, 0, 1), (30, 'Task overdue reminder', 'Task overdue reminder', 'Hello,<br>Task created by you or assigned to you will be overdue in next 24 hour.<br><br><strong><strong>Task details :</strong><strong></strong> </strong><br>Task title: {title}<br>Task Description: {description}<br>Task Status: {status}<br>Task Priority: {priority}<br>Start date: {start date}<br>End date: {end date}<br><br>Please visit below link to view more details<br>{view_task_link}<br><br><br>', 0, 1, 30, 0, 1, 0, 1), (31, 'Task overdue', 'Task overdue', 'Hello,<br>Task created by you or assigned to you is overdue today.<br><br><strong><strong>Overdue task details :</strong><strong></strong> </strong><br>Task title: {title}<br>Task description: {description}<br>Task status: {status}<br>Task priority: {priority}<br>Start date: {start date}<br>End date: {end date}<br><br>Please visit below link to view more details<br>{view_task_link}<br><br>', 0, 1, 31, 0, 1, 0, 1), (32, 'Task status changed', 'Task status changed', 'Hello {first_name} {last_name},<br>Task status changed by {staff_name}<br><br>Following are task details : <br>Title: {title}<br>Description: {description}<br>Status: {status}<br>Priority: {priority}<br>Start date: {start date}<br>End date: {end date}<br><br>Please click on following link to see task details :<br>{view_task_link}<br><br>', 0, 1, 32, 0, 1, 0, 1), (33, 'Incident approval', 'Approval request for incident ', 'Hello {first_name} {last_name},<br><br>Approval request for incident {ticket_hash} {subject} is waiting for your approval. <br>Please visit <a href="{ticket_approval_link}">{ticket_approval_link}</a> and confirm your approval.', 0, 1, 33, 0, 1, 0, 1), (34, 'staff_devices', 'Staff_devices_information', '<p>Hello {first_name} {last_name},<br>New sign_in from {browser} on {os} <br>Device: {device}<br><br>Os: {os}<br><br>Browser: {browser}<br><br>IP: {ip}</p>', 0, 1, 34, 0, 1, 0, 1), (35, 'ITIL automation template for problem', '[{problem_hash}]: {subject}', 'Alert : {alert}<br>Hash: {problem_hash}<br><br><strong>Properties :</strong><br>Subject: {subject}<br> Domain: {domain}<br> Priority: {priority}<br> Status: {status}<br>Impact : {impact}<br>', 0, 1, 35, 1, 1, 0, 1), (36, 'ITIL automation template for change', '[{changes_hash}]: {subject}', 'Alert : {alert}<br>Hash: {changes_hash}<br><br><strong>Properties :</strong><br>Subject: {subject}<br> Domain: {domain}<br> Priority: {priority}<br> Status: {status}<br>Impact : {impact}<br>Risk : {risk}<br>Type : {change_type}<br><br>', 0, 1, 36, 1, 1, 0, 1), (37, 'ITIL automation template for release', '[{release_hash}]: {subject}', 'Alert : {alert}<br>Hash: {release_hash}<br><br><strong>Properties :</strong><br>Subject: {subject}<br> Domain: {domain}<br> Priority: {priority}<br> Status: {status}<br>Type : {release_type}<br><br>', 0, 1, 37, 1, 1, 0, 1), (38, 'Incident approval accept', 'Approval request accept', 'Hello {first_name} {last_name},<br><br>Approval request accepted ', 0, 1, 38, 0, 1, 0, 1), (39, 'Incident approval rejected', 'Approval request rejected', 'Hello {first_name} {last_name},<br><br>Requested by : {requested_by}<br><br>Rejected by : {rejected_by}<br><br>Reason for rejection : {rejected_comment}<br><br>Your request for approval has been rejected ', 0, 1, 39, 0, 1, 0, 1), (40, 'Asset expired', '[{name}]: expired', '<p>Asset {name} expired on {expiry_date}.</p>\r\n<p><br><strong>Asset details :</strong><br>Name: {name}<br>Type : {ci_type}<br>Domain: {domain}<br>Expiry date: {expiry_date}<br>Impact : {impact}<br>Location: {location}<br>Managed by : {managed_by}<br>Used by : {used_by}<br><br>For more details <a href="{asset_link}">click here</a></p>', 0, 1, 40, 0, 1, 0, 1), (41, 'Asset added/updated', '{subject}', '<p>{subject}</p>\r\n<p><br><strong>Asset details :</strong><br>Name: {name}<br>Type : {ci_type}<br>Domain: {domain}<br>Expiry date: {expiry_date}<br>Impact : {impact}<br>Location: {location}<br>Managed by : {managed_by}<br>Used by : {used_by}<br><br>For more details <a href="{asset_link}">click here</a></p>', 0, 1, 41, 0, 1, 0, 1), (42, 'Asset tracking registration key and setup', 'Asset tracking registration key and setup', 'Hello ,<br><br>please find below registration key for your asset tracking software.<br>Registration key : {registration_key}<br><br>Below are links for downloading Asset discovery tools \r\n<br>Discovery agents :<br>{agent_links}<br><br>Asset Discovery Probe :<br>{probe_links}', 0, 1, 42, 0, 1, 0, 1), (43, 'Data wiping requested', '[{name}]: Data wiping requested ', '<p>Asset {name} data wiping requested.</p>\r\n<p><br><strong>Asset details :</strong><br>Name: {name}<br>Type : {ci_type}<br>Domain: {domain}<br>Expiry date: {expiry_date}<br>Impact : {impact}<br>Location: {location}<br>Managed by : {managed_by}<br>Used by : {used_by}<br><br>For more details <a href="{asset_link}">click here</a></p>', 0, 1, 43, 0, 1, 0, 0), (44, 'Data wiping completed', '[{name}]: Data wiping completed ', '<p>Asset {name} data wiping completed.</p>\r\n<p><br><strong>Asset details :</strong><br>Name: {name}<br>Type : {ci_type}<br>Domain: {domain}<br>Expiry date: {expiry_date}<br>Impact : {impact}<br>Location: {location}<br>Managed by : {managed_by}<br>Used by : {used_by}<br><br>For more details <a href="{asset_link}">click here</a></p>', 0, 1, 44, 0, 1, 0, 0), (45, 'Contract renewed', 'Contract Renewed', 'Hello,<br>{contract_name}(#{contract_number}) is renewed and will be expired on {contract_expiry}.</p>\r\n<p>Total cost - {contract_cost}</p>\r\n<p>Attached CI - {contract_assets}</p>\r\n<p>Please visit below contract link to view more details<br><a href="{contract_link}">{contract_link}</a><br>', 0, 1, 45, 0, 1, 0, 1), (46, 'Client Verification OTP', 'Client email verification', '<p>Hello,<br><br>This email is used for connecting to our live chat. Please verify your email address with the OTP: {emailotp}.<br><br><br></p>', 0, 1, 46, 0, 1, 0, 0), (47, 'Asset acknowledgement', 'Asset acknowledgement [{ticket_hash}]', '<p>Hello {username},</p><p>you have assigned asset named {assetname} by our team on {assigned_date}.</p><p>please reply with acknowledgement document to this email.</p>\r\n<p>Best Regards,<br><br><br></p>', 0, 1, 47, 0, 1, 0, 0);
-- -- Table structure for table `avis_itil_report` --
CREATE TABLE `avis_itil_report` ( `report_id` int(15) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `filter` text NOT NULL, `is_report` tinyint(2) NOT NULL, `staff_id` int(15) NOT NULL, `created_date` varchar(255) NOT NULL, `from_date` varchar(255) NOT NULL, `to_date` varchar(255) NOT NULL, `status` varchar(255) NOT NULL, `priority` varchar(255) NOT NULL, `impact` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `subcategory` varchar(255) NOT NULL, `item` varchar(255) NOT NULL, `changetype` varchar(255) NOT NULL, `risk` varchar(255) NOT NULL, `urgency` int(255) NOT NULL, `releasetype` int(255) NOT NULL, `location` varchar(255) NOT NULL, `filter_id` int(15) NOT NULL, `vis_main_search` int(15) NOT NULL, `domain_id` int(15) NOT NULL, `knownerror` varchar(255) NOT NULL, PRIMARY KEY (`report_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- -- Table structure for table `avis_lc_msg_template` --
CREATE TABLE `avis_lc_msg_template` ( `msg_id` int(15) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `display_order` int(11) NOT NULL, `language` int(11) NOT NULL, `subject` varchar(255) DEFAULT NULL, `message` text, `parent_id` tinyint(1) DEFAULT '0', `is_enabled` tinyint(1) DEFAULT '0', `is_custom` int(11) NOT NULL, PRIMARY KEY (`msg_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
-- -- Dumping data for table `avis_lc_msg_template` --
INSERT INTO `avis_lc_msg_template` VALUES (1, 'Greeting message', 0, 1, 'Greeting message', 'Welcome! How may I help you Today?', 1, 1, 0), (2, 'Offline message', 0, 1, 'Offline message', 'Sorry! We are currently offline.. Leave us a message and we will get back to you.', 2, 1, 0), (3, 'Page visit message', 0, 1, 'Page visit message', 'Hi, Good to have you here! Pls feel free to talk to our live chat agent.', 3, 1, 0), (4, 'Closing message', 0, 1, 'Closing message', 'Thank you for contacting us! We hope we have answered your all questions.', 4, 1, 0), (5, 'client has left the chat', 0, 1, 'client has left the chat', 'client has left the chat', 1, 1, 0), (6, 'staff had left the chat', 0, 1, 'staff had left the chat', 'staff had left the chat', 1, 1, 0), (7, 'staff not available', 0, 1, 'staff not available', 'staff not available', 1, 1, 0), (8, 'Queue message', 0, 1, 'Queue message', 'One of our representative will be with you shortly. You are number {queue_number} in the queue. Thank you for your patience.', 1, 1, 0);
CREATE TABLE `avis_ledgers` ( `legder_id` int(15) NOT NULL AUTO_INCREMENT, `expensetype` int(15) NOT NULL, `cost_model` varchar(255) NOT NULL, `description` text NOT NULL, `acc_no` varchar(255) NOT NULL, `acc_name` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `location_id` int(15) NOT NULL, `entry_date` int(15) NOT NULL, `staff_id` int(15) NOT NULL, PRIMARY KEY (`legder_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
INSERT INTO `avis_rating` VALUES (1, 'Star Rating', 1, 'By using this setting client can rate the incident in the format of star rating.', 0), (2, 'smiley icon', 2, 'By using this setting client can rate the incident in the format of smiley icon.', 1);
-- -- Table structure for table `avis_va_agent` --
CREATE TABLE `avis_va_agent` ( `va_id` int(15) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `domain_id` int(15) NOT NULL, `language_id` int(15) NOT NULL, `startup_text` text NOT NULL, `ticket_creation_text` varchar(255) NOT NULL, `welcome_msg` text NOT NULL, `closing_msg` text NOT NULL, `avatar_name` varchar(255) NOT NULL, `avatar_img` varchar(255) NOT NULL, `is_enable` tinyint(1) NOT NULL, `not_found_text` text NOT NULL, `va_position` int(15) NOT NULL, `connect_livechat` tinyint(1) NOT NULL DEFAULT '0', `theme_color` varchar(255) NOT NULL, PRIMARY KEY (`va_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `avis_va_topicflow` --
CREATE TABLE `avis_va_topicflow` ( `tf_id` int(15) NOT NULL AUTO_INCREMENT, `topic_id` int(15) NOT NULL, `step` int(15) NOT NULL, `type` int(5) NOT NULL, `text` text NOT NULL, `jumpto` int(15) NOT NULL, `jumpfrom` int(15) NOT NULL, `parent` int(15) NOT NULL, `field1` int(15) NOT NULL, `field2` int(15) NOT NULL, `field3` varchar(255) NOT NULL, `map_to` varchar(500) NOT NULL DEFAULT '0', PRIMARY KEY (`tf_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `avis_va_topics` --
CREATE TABLE `avis_va_topics` ( `topic_id` int(15) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `keywords` text NOT NULL, `va_id` int(15) NOT NULL, `active` tinyint(2) NOT NULL, `domain_access` varchar(255) NOT NULL, `description` text NOT NULL, `field1` int(15) NOT NULL, `field2` int(15) NOT NULL, `field3` varchar(255) NOT NULL, PRIMARY KEY (`topic_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `avis_xml_log` ( `log_id` int(15) NOT NULL AUTO_INCREMENT, `filename` varchar(255) NOT NULL, `modified_date` int(15) NOT NULL, `user_id` int(15) NOT NULL, `user_type` int(2) NOT NULL COMMENT '1-client 2-staff', `filedata` longtext NOT NULL, PRIMARY KEY (`log_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;