REPLACE INTO `hb_language_locales` (`language_id`,`section`,`keyword`,`value`)
SELECT id, 'clientarea', 'afteraddingzone','After adding new zone you will be able to add/edit its contents\" class=\"vtip_description' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'newdomainzoneclone','New domain zone will contain entries cloned from domain you already own' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'usepremadednstemplatetooltip','Use one of available, pre-configured DNS templates' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'ttlfeqdescription','TTL settings define the frequency of website content updates.' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'prioritysettingdesc','Priority settings for mail exchanger record, the lower preference number is the higher priority.' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'aresurewishremovethisdomain','Are you sure you wish to remove this domain?' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'suretoremovedomain','Are you sure you wish to remove this domain?' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'applytemplate','Apply Template' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddesca','IP Address, as a decimal dotted quad string, for example' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescns1','Target nameserver hostname' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescans2','Delegate this domain to use given nameserver' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescaaaa','IPv6 address. An example' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddesccname','Specifies the canonical name of a record. An example' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'text','Text' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnssubtype','Subtype' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddeschinfo','Hardware info' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddeschinfo2','Software info' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescnsec','Next Domain Name' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescnsec2','Type Bit Maps' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescptr','Reverse pointer, used to specify the host name belonging to an IP or IPv6 address. An example' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddesctxt','The TXT field can be used to attach textual data to a domain' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescspf','Used to store Sender Permitted From details' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescmx','Specifies a mail exchanger host for a domain.' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescrp','Email address with no at sign' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescrp2','TXT pointer for more info' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddesca6','Prefix len.' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddesca62','Prefix name' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescsshfp','Fp-Type' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'fingerprint','Fingerprint' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'primaryns','Primary NS' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescsoaeml','Use dot instead of @ sign' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'serialnumber','Serial number' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescsoa2','Indicates the time in seconds, when the slave will try to refresh the zone from the master' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescsoa3','Defines the time in seconds between retries if the slave (secondary) fails to contact the master when refresh (above) has expired.' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'expiry','Expiry' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescsoa4','Indicates when the zone data is no longer authoritative in seconds.' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'flags','Flags' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'publickey','Public Key' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'keytag','Key tag' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'digesttype','Digest Type' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'digest','Digest' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'weight','Weight' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'latitude','Latitude' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'longitude','Longitude' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'altitude','Altitude' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'locsize','Size' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'horizontalprecision','Horizontal Precision' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'verticalprecision','Vertical Precision' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescnaptrorder','Order' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescnaptrpref','Preferences' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescnaptrservice','Service' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescnaptrregex','Regex' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescrsig','Type Covered' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescrsiglabels','Labels' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'originalttl','Original TTL' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescrrsig2','Signature Expiration' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescrrsig3','Signature Inception' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'dnsrecorddescrrsig4','Signer\\\'s Name' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'signature','Signature' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'convertbackup','Convert Backup' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'suretoresetrootpassword','Are you sure you wish to reset root password' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'notethatwillrebooted','Note that VM will be rebooted' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'suretodisableautobackup','Disable autobackup?' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'suretoenableautobackup','Enable autobackup?' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'selectinterfacefirst','Select interface first' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'selectwhichnetworkinterfacethisaddr','Select which network interface this IP address should be assigned to.' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'private','private' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'forcereboot','Force reboot' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'requiredstartup','Required startup' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'payselectedinvoices','Pay selected invoices' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'itemscart','Items in cart' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'certificationperiods','Certification Periods' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'webserver','Web Server' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'validationemail','Validation Email' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'goto','Go To' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'supplierorderid','Supplier Order ID' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'resendapproveemail','Resend Approve Email' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'synchronize','Synchronize' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'trusthistorynotes','Trust History and Notes' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'downloadbundle','Download CA Bundle' FROM hb_language WHERE target='user'
UNION SELECT id, 'clientarea', 'resendcertificateemail','Resend Certificate Email' FROM hb_language WHERE target='user';
##########
ALTER TABLE `hb_security_rules`
ADD COLUMN `options` TINYINT NOT NULL DEFAULT '0' AFTER `target_id`;