INSERT INTO `{PREFIX}rstickets_departments` (`DepartmentId`, `DepartmentName`, `DepartmentPrefix`, `TicketAssignmentType`, `TicketGenerationRule`, `NextTicketNumber`, `UserEmailTicket`, `StaffEmailTicket`, `FileUpload`, `NotifyNewTicketEmails`, `FileUploadExtensions`, `DepartmentPriority`, `DepartmentOrder`) VALUES (1, 'Billing', 'BILLING', 'static', 'random', 9, '1', '0', 'yes', '', 'zip', 'normal', 1),(2, 'Licensing', 'LICENSE', 'static', 'random', 1, '1', '0', 'yes', '', 'zip', 'normal', 2),(3, 'Tech Support', 'TECH', 'static', 'random', 1, '1', '0', 'yes', '', 'zip', 'high', 3)
INSERT INTO `{PREFIX}rstickets_groups` (`GroupId`, `GroupName`, `CanAddTicket`, `CanAddTicketUsers`, `CanAddTicketStaff`, `CanUpdateTicket`, `CanDeleteTicket`, `CanAnswerTicket`, `CanDeleteTicketReplies`, `CanUpdateTicketReplies`, `CanAssignTickets`, `CanChangeTicketStatus`, `CanSeeUnallocatedTickets`, `CanSeeOtherTickets`, `CanMoveTicket`) VALUES (1, 'Staff', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1')
INSERT INTO `{PREFIX}rstickets_settings` (`setting`, `value`) VALUES ('Email_Server', 'pop.email.com'),('Email_Server_Port', '995'),('Email_Address', 'your@email.com'),('Email_Address_Account', 'your@email.com'),('Email_Address_Password', 'yourpassword'),('Email_Cron_Type', 'cron'),('Email_Cron_Interval', '1'),('Email_Cron_Lastcheck', '1216322510'),('Email_Address_Fullname', 'Customer Support'),('Frontend_TicketTime', '1'),('Frontend_TicketCode', '1'),('Frontend_TicketSubject', '1'),('Frontend_StaffFullname', '1'),('Frontend_CustomerFullname', '1'),('Frontend_TicketPriority', '1'),('Frontend_TicketStatus', '1'),('Backend_TicketTime', '1'),('Backend_TicketCode', '1'),('Backend_TicketSubject', '1'),('Backend_StaffFullname', '1'),('Backend_CustomerFullname', '1'),('Backend_TicketPriority', '1'),('Backend_TicketStatus', '1'),('Date_Format', 'd/m/Y'),('Date_Format_JS', 'dd/mm/yyyy'),('License_Code', ''),('Autoclose_Cron_Interval', '120'),('Autoclose_Cron_Lastcheck', '1216320710'),('Autoclose_Interval', '1'),('Autoclose_Email_Interval', '3'),('Email_Server_Protocol', '/pop3'),('Email_Server_Security', '/ssl'),('Email_Accept_New_Tickets', 'no'),('Email_Reply_Above', '____________________________________________________________'),('RStickets_Link', '1'),('RStickets_Show_Menu', '1'),('Captcha_Enabled','1'),('Captcha_Characters','5'),('Captcha_Dots','1'),('Captcha_Lines','1'),('Captcha_Case_Sensitive','1'),('Email_Default_Department','0'),('Date_Timezone',''),('RStickets_Add_Tickets','yes'),('RStickets_MySQL_UTF8','1'),('RStickets_Custom_User_Link',''),('Staff_Can_Add_Tickets','all'),('Captcha_Enabled_For','unregistered,users,staff,')
INSERT INTO `{PREFIX}rstickets_plugins` (`PluginId`, `PluginName`, `PluginDescription`, `PluginLink`, `PluginInstalled`) VALUES ('cron', 'E-mail cron', 'LBL_BUY_PLUGIN_CRON', 'http://www.rsjoomla.com/index.php/component/option,com_rshelp/task,payment.redirect/cid,12/custom_sess,{custom_sess}/', '0');