ALTER TABLE `invoice` CHANGE `processorid` `processorid` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
UPDATE `currency` SET `symbol` = CHAR(0xE282B9 USING utf8), `name` = 'Indian Rupee' WHERE `name` = "Indian Rupees";
UPDATE `currency` SET `name` = 'Indonesia Rupiah' WHERE `name` = 'Indonesia Rupiah (Rp)';
UPDATE `currency` SET `name` = 'New Zealand Dollar' WHERE `name` = 'New Zealand Dollars';
UPDATE `currency` SET `symbol` = CHAR(0xE282B1 USING utf8) WHERE `name` = 'Philippine Peso';
UPDATE `currency` SET `symbol` = CHAR(0xEFB7BC USING utf8) WHERE `name` = 'Saudi Riyal';
UPDATE `currency` SET `symbol` = 'kr' WHERE `name` = 'Swedish Krona';
UPDATE `currency` SET `symbol` = CHAR(0xE282BA USING utf8), `abrv` = 'TRY' WHERE `name` = 'Turkish Lira';

ALTER TABLE  `packageaddon_prices` ADD  `openticket` TINYINT NOT NULL DEFAULT  '0';
ALTER TABLE `taxrule`
    CHANGE `vat` `vat` BOOL DEFAULT '0' NOT NULL,
    CHANGE `level` `level` TINYINT(1) DEFAULT '1' NOT NULL,
    CHANGE `compound` `compound` BOOL DEFAULT '0' NOT NULL;
INSERT INTO `setting`(`id`, `name`, `isrequired`, `ishidden`, `issession`, `value`, `type` ) VALUES(null,'sharedpluginsstate',0,1,1, '',-1);
UPDATE `customuserfields` SET `isChangable` = 2 WHERE `type` IN (2, 3, 5 ,7);
ALTER TABLE `domains` ADD INDEX `PARENTID` ( `parentPackageId` );
Delete from user_customuserfields where customid IN (SELECT id FROM `customuserfields` where name = 'HTML Email Format');
DELETE FROM `customuserfields` where name = 'HTML Email Format';
DELETE FROM `setting` WHERE `name` = 'Send Multi-Part MIME Messages';

INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL , 'Nickname', 61, 0, 1, 1, 20, 0, 0, 1, 0, 1, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL , 'ChatStatus', 62, 0, 1, 1, 0, 0, 0, 0, 0, 0, '');

DELETE from help;
INSERT INTO `help` VALUES(1, 'Welcome Email Tags', '[{"name":"COMPANYNAME","description":"Company name","hostingonly":false},{"name":"COMPANYADDRESS","description":"Company address","hostingonly":false},{"name":"ACCOUNTINFORMATION","description":"Account Information<br/><i style=''font-size:smaller;''>Includes Domain Name, Username, Password, IP</i>","hostingonly":true},{"name":"DOMAINNAME","description":"Domain name without http://www.","hostingonly":false},{"name":"DOMAINUSERNAME","description":"Domain User Name","hostingonly":true},{"name":"DOMAINPASSWORD","description":"Domain Password","hostingonly":true},{"name":"DOMAINIP","description":"IP Address to Domain","hostingonly":true},{"name":"COMPANYURL","description":"URL to your web site","hostingonly":false},{"name":"SUPPORTEMAIL","description":"E-mail to support staff","hostingonly":false},{"name":"CLIENTAPPLICATIONURL","description":"URL to ClientExec.","hostingonly":false},{"name":"FORGOTPASSWORDURL","description":"URL to retrieve forgotten password.","hostingonly":false},{"name":"CLIENTNAME","description":"Client''s first and last name","hostingonly":false},{"name":"FIRSTNAME","description":"Client''s First name","hostingonly":false},{"name":"CLIENTEMAIL","description":"Client''s Email","hostingonly":false},{"name":"ORGANIZATION","description":"Client''s Organization","hostingonly":false},{"name":"PLANNAME","description":"Client''s Plan","hostingonly":false},{"name":"NAMESERVERS","description":"Name Servers<br/><i style=''font-size:smaller;''>lists only hostnames</i>","hostingonly":false},{"name":"NAMESERVERSANDIPS","description":"Name Servers and Ips<br/><i style=''font-size:smaller;''>lists both IPs and hostnames</i>","hostingonly":false},{"name":"SERVERHOSTNAME","description":"Server Host Name<br/><i style=''font-size:smaller;''>i.e. server1.yourdomain.com</i>","hostingonly":true},{"name":"SERVERSHAREDIP","description":"Server''s Shared IP","hostingonly":true},{"name":"CUSTOMPROFILE_xxxx","description":"Custom Profile<br/><i style=''font-size:smaller;''>where xxx is a profile custom field name (i.e. [CUSTOMPROFILE_somename])</i>","hostingonly":false},{"name":"CUSTOMPACKAGE_xxxx","description":"Custom Package Field<br/><i style=''font-size:smaller;''>Where xxx is custom package field name (i.e. [CUSTOMPACKAGE_somename])</i>","hostingonly":true}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(2, 'Notification Email Tags', '[{"name":"BILLINGEMAIL","description":"Email address for billing inquiries","hostingonly":false},{"name":"SUPPORTEMAIL","description":"E-mail to support staff","hostingonly":false},{"name":"COMPANYNAME","description":"Company name","hostingonly":false},{"name":"COMPANYADDRESS","description":"Company address","hostingonly":false},{"name":"COMPANYURL","description":"URL to your web site","hostingonly":false},{"name":"CLIENTAPPLICATIONURL","description":"Url to your ClientExec installation","hostingonly":false},{"name":"CLIENTNAME","description":"Client''s First and Last Name","hostingonly":false},{"name":"FIRSTNAME","description":"Client''s First name","hostingonly":false},{"name":"CLIENTEMAIL","description":"Email Address","hostingonly":false},{"name":"ORGANIZATION","description":"Client''s Organization","hostingonly":false},{"name":"PACKAGEGROUPNAME","description":"Client''s Plan group","hostingonly":false},{"name":"PLANNAME","description":"Client''s Plan","hostingonly":false},{"name":"PACKAGEID","description":"Client''s Plan ID","hostingonly":false},{"name":"NEXTDUEDATE","description":"Client''s Plan next billing date","hostingonly":false},{"name":"FORGOTPASSWORDURL","description":"URL to retrieve forgotten password.","hostingonly":false}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(51, 'Expiring CC Template Tags', '[{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"FIRSTNAME","description":"Client''s First name"},{"name":"CLIENTEMAIL","description":"Email Address"},{"name":"CCLASTFOUR","description":"The last four digits of the customer''s credit card."},{"name":"CCEXPDATE","description":"The expiration date of the customer''s credit card."},{"name":"CLIENTAPPLICATIONURL","description":"Url to your ClientExec installation"},{"name":"FORGOTPASSWORDURL","description":"URL to retrieve forgotten password."},{"name":"COMPANYNAME","description":"Company name"},{"name":"COMPANYADDRESS","description":"Company address"},{"name":"BILLINGEMAIL","description":"Email address for billing inquiries"},{"name":"CUSTOMPROFILE_xxxx","description":"Custom Profile<br/><i style=''font-size:smaller;''>where xxx is a profile custom field name (i.e. [CUSTOMPROFILE_somename])</i>"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(52, 'Domain Reminder Tags', '[{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"FIRSTNAME","description":"Client''s First name"},{"name":"CLIENTEMAIL","description":"Email Address"},{"name":"DOMAIN","description":"The client domain name."},{"name":"EXPDATE","description":"The expiry date of the domain."},{"name":"COMPANYNAME","description":"Company name"},{"name":"COMPANYADDRESS","description":"Company address"},{"name":"FORGOTPASSWORDURL","description":"URL to retrieve forgotten password."},{"name":"BILLINGEMAIL","description":"Email address for billing inquiries"},{"name":"CLIENTAPPLICATIONURL","description":"Url to your ClientExec installation"},{"name":"CUSTOMPROFILE_xxxx","description":"where xxx is a profile custom field name."}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(53, 'Reset Password Tags', '[{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"FIRSTNAME","description":"Client''s First name"},{"name":"CLIENTEMAIL","description":"Email Address"},{"name":"COMPANYNAME","description":"Company name"},{"name":"COMPANYADDRESS","description":"Company address"},{"name":"REQUESTIP","description":"IP of the machine which requested the password change."},{"name":"CONFIRMATION URL","description":"URL that user must press to confirm the password change"},{"name":"CUSTOMPROFILE_xxxx","description":"Custom Profile<br/><i style=''font-size:smaller;''>where xxx is a profile custom field name (i.e. [CUSTOMPROFILE_somename])</i>"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(54, 'Get New Password Tags', '[{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"FIRSTNAME","description":"Client''s First name"},{"name":"CLIENTEMAIL","description":"Email Address"},{"name":"NEWPASSWORD","description":"New Temporary Password"},{"name":"CLIENTEXEC URL","description":"Url to ClientExec"},{"name":"COMPANYNAME","description":"Company name"},{"name":"COMPANYADDRESS","description":"Company address"},{"name":"COMPANYEMAIL","description":"Company Email address"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(55, 'Rejection E-Mail Tags', '[{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"FIRSTNAME","description":"Client''s First name"},{"name":"COMPANYNAME","description":"Company name"},{"name":"COMPANYADDRESS","description":"Company address"},{"name":"COMPANYURL","description":"URL to your web site"},{"name":"SUPPORTEMAIL","description":"E-mail to support staff"},{"name":"CLIENTAPPLICATIONURL","description":"URL to ClientExec."}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(56, 'Team Status Reply E-Mail Tags', '[{"name":"TEAMSTATUS","description":"Team status used to reply"},{"name":"REPLIEDTEAMSTATUSUSERNAME","description":"Name of the user who''s team status was replied"},{"name":"REPLIEDTEAMSTATUSDATE","description":"Date of the team status replied"},{"name":"REPLIEDTEAMSTATUS","description":"Team status replied"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(57, 'Team Status Activity E-Mail Tags', '[{"name":"TEAMSTATUSDYNAMICBLOCK","description":"Team status activity"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(58, 'Team Status Dynamic Block Tags', '[{"name":"TEAMSTATUSUSERNAME","description":"Name of the user who post the team status"},{"name":"TEAMSTATUS","description":"Team status text"},{"name":"TEAMSTATUSDATE","description":"Date of status"},{"name":"TEAMSTATUSREPLYINFO","description":"Reply Info<br/><i style=''font-size:smaller;''>Replied Message"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(59, 'Team Status Activity Reply Tags', '[{"name":"REPLIEDTEAMSTATUSUSERNAME","description":"Name of the user who''s team status was replied"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(60, 'Ticket Template Tags', '[{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"FIRSTNAME","description":"Client''s First name"},{"name":"CLIENTEMAIL","description":"Email Address"},{"name":"TICKETURL","description":"Direct URL to Ticket"},{"name":"TICKETNUMBER","description":"Ticket Number"},{"name":"TICKETSUBJECT","description":"Ticket Subject"},{"name":"DESCRIPTION","description":"Ticket Description"},{"name":"CLIENTAPPLICATIONURL","description":"Url to your ClientExec installation"},{"name":"COMPANYNAME","description":"Company name"},{"name":"COMPANYADDRESS","description":"Company address"},{"name":"CUSTOMPROFILE_xxxx","description":"Custom Profile<br/><i style=''font-size:smaller;''>where xxx is a profile custom field name (i.e. [CUSTOMPROFILE_somename])</i>"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(61, 'Feedback Template Tags', '[{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"FIRSTNAME","description":"Client''s First name"},{"name":"CLIENTEMAIL","description":"Email Address"},{"name":"COMPANYNAME","description":"Company name"},{"name":"COMPANYADDRESS","description":"Company address"},{"name":"RATEEXCELLENTSERVICEURL","description":"URL to rate <b>Excellent</b> feedback"},{"name":"RATEGOODSERVICEURL","description":"URL to rate <b>Good</b> feedback"},{"name":"RATENOTGREATSERVICEURL","description":"URL to rate <b>Average</b> feedback"},{"name":"RATEPOORSERVICEURL","description":"URL to rate <b>Poor</b> feedback"},{"name":"CUSTOMPROFILE_xxxx","description":"Custom Profile<br/><i style=''font-size:smaller;''>where xxx is a profile custom field name (i.e. [CUSTOMPROFILE_somename])</i>"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(62, 'AutoClose Service Template Tags', '[{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"FIRSTNAME","description":"Client''s First name"},{"name":"CLIENTEMAIL","description":"Email Address"},{"name":"COMPANYNAME","description":"Company name"},{"name":"COMPANYADDRESS","description":"Company address"},{"name":"TICKETNUMBER","description":"Ticket Number"},{"name":"CUSTOMPROFILE_xxxx","description":"Custom Profile<br/><i style=''font-size:smaller;''>where xxx is a profile custom field name (i.e. [CUSTOMPROFILE_somename])</i>"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(63, 'Notify Support For New High Priority Ticket Template Tags', '[{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"CLIENTEMAIL","description":"Email Address"},{"name":"COMPANYNAME","description":"Company name"},{"name":"COMPANYADDRESS","description":"Company address"},{"name":"TICKETNUMBER","description":"Ticket Number"},{"name":"TICKETSUBJECT","description":"Ticket Subject"},{"name":"TICKETTYPE","description":"Ticket Type"},{"name":"DESCRIPTION","description":"Ticket Description"},{"name":"CLIENTAPPLICATIONURL","description":"Url to your ClientExec installation"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(64, 'Notify Customer For New Ticket Template Tags', '[{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"TICKETNUMBER","description":"Ticket Number"},{"name":"TICKETSUBJECT","description":"Ticket Subject"},{"name":"TICKETTYPE","description":"Ticket Type"},{"name":"DESCRIPTION","description":"Ticket Description"},{"name":"COMPANYNAME","description":"Company name"},{"name":"COMPANYADDRESS","description":"Company address"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(65, 'Notify Assignee For Ticket Reply Template Tags', '[{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"TICKETNUMBER","description":"Ticket Number"},{"name":"DESCRIPTION","description":"Ticket Description"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(66, 'Notify For New FeedBack Template Tags', '[{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"FIRSTNAME","description":"Client''s First name"},{"name":"TICKETNUMBER","description":"Ticket Number"},{"name":"DESCRIPTION","description":"Ticket Description"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(50, 'Invoice Template Tags', '[{"name":"DATE","description":"Date payment is due."},{"name":"SENTDATE","description":"Date invoice was last sent."},{"name":"CLIENTNAME","description":"Client''s First and Last Name"},{"name":"FIRSTNAME","description":"Client''s First name"},{"name":"CLIENTEMAIL","description":"Email Address"},{"name":"CLIENTNUMBER","description":"User Id"},{"name":"INVOICENUMBER","description":"Invoice Number"},{"name":"SUBSCRIPTION_ID","description":"Subscription Id"},{"name":"DIRECTPAYMENTLINK","description":"Direct Payment Link<br/><i style=''font-size:smaller;''>Add direct link for invoice payment. Only visible when applicable billing plugin that support this method of payment is used</i>"},{"name":"INVOICEHASH","description":"Invoice Hash<br/><i style=''font-size:smaller;''>A hash for the invoice in case you need to send one</i>"},{"name":"INVOICEDESCRIPTION","description":"Invoice Description"},{"name":"TAX","description":"Invoice Tax"},{"name":"AMOUNT_EX_TAX","description":"The total price excluding taxes."},{"name":"AMOUNT","description":"The total price due."},{"name":"PAID","description":"The amount already paid of the invoice."},{"name":"BALANCEDUE","description":"The balance due of the invoice."},{"name":"RAW_AMOUNT","description":"The total price excluding currency symbol."},{"name":"PMTREFERENCE","description":"Payment Reference<br/><i style=''font-size:smaller;''>The value used in the payment reference field of the invoice</i>"},{"name":"PMTTRANSACTIONS","description":"Payment Transactions<br/><i style=''font-size:smaller;''>The transactions applied to the invoice.</i>"},{"name":"CLIENTAPPLICATIONURL","description":"URL to ClientExec."},{"name":"FORGOTPASSWORDURL","description":"URL to retrieve forgotten password."},{"name":"COMPANYNAME","description":"Company name"},{"name":"COMPANYADDRESS","description":"Company address"},{"name":"BILLINGEMAIL","description":"E-mail address for billing inquiries"},{"name":"CUSTOMPROFILE_xxxx","description":"Custom Profile<br/><i style=''font-size:smaller;''>where xxx is a profile custom field name (i.e. [CUSTOMPROFILE_somename])</i>"}]', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES(67, 'Notify For New Order Tags', '[{"name":"ORDERINFO","description":"Complete Order Information"}]', 'Click to view available tags', 240, 320);

ALTER TABLE `invoiceentry` DROP `includenextpayment`;
ALTER TABLE  `users` DROP  `isOrganization` ;

CREATE TABLE `chatlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roomid` varchar(20) NOT NULL,
  `chatterid` varchar(20) NOT NULL,
  `msg` text NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8, ENGINE=MyISAM;
ALTER TABLE chatlog ADD INDEX IRoomId (roomid, id);

CREATE TABLE `chatuser` (
  `chatterid` varchar(20) NOT NULL,
  `fullname` varchar(45) NOT NULL,
  `email` varchar(45) NOT NULL,
  `usertype` tinyint(4) NOT NULL,
  PRIMARY KEY (`chatterid`)
) DEFAULT CHARACTER SET utf8, ENGINE=MyISAM;

CREATE TABLE `chatroom` (
  `id` varchar(20) NOT NULL,
  `chatterid` varchar(20) NOT NULL,
  `title` varchar(45) NOT NULL,
  `time` int(11) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `description` varchar(200) NOT NULL DEFAULT '',
  `ispublic` INT NOT NULL DEFAULT  '0',
  UNIQUE KEY `room_chatter` (`id`,`chatterid`)
) DEFAULT CHARACTER SET utf8, ENGINE=MyISAM;

CREATE TABLE `chattyping` (
  `roomid` varchar(20) NOT NULL,
  `chatterid` varchar(20) NOT NULL,
  `time` int(11) NOT NULL,
  `subtype` int(11) NOT NULL,
  UNIQUE KEY `typing_index` (`roomid`,`chatterid`)
) DEFAULT CHARACTER SET utf8, ENGINE=MyISAM;

CREATE TABLE `chatvisitor` (
  `ip` varchar(20) NOT NULL,
  `lastvisit` int(11) NOT NULL,
  `chatterid` varchar(20) NOT NULL,
  `country` text CHARACTER SET utf8 NOT NULL,
  `lang` varchar(10) NOT NULL,
  `browser_name` varchar(10) NOT NULL,
  `browser_ver` varchar(10) NOT NULL,
  `device` varchar(7) NOT NULL,
  `os` varchar(17) NOT NULL,
  `search_engine` varchar(10) NOT NULL,
  `search_terms` varchar(56) NOT NULL,
  `ref_url` varchar(156) NOT NULL,
  `ref_host` varchar(25) NOT NULL,
  `ref_path` varchar(25) NOT NULL,
  `url` varchar(56) NOT NULL,
  `path` varchar(25) NOT NULL,
  `title` varchar(25) NOT NULL,
  `session` text CHARACTER SET utf8 NOT NULL
) DEFAULT CHARACTER SET utf8, ENGINE=MyISAM;

INSERT INTO `chatuser` VALUES('0', 'System Notification', 'noemail@noemail.com', -1);

DELETE from setting where name = 'Number of Most Popular Articles';
DELETE from setting where name = 'Number of Most Viewed Articles';

ALTER TABLE  `kb_articles` ADD  `categoryid` INT( 11 ) NOT NULL DEFAULT '0';
UPDATE kb_articles a, kb_articles_categories ac SET a.categoryid = ac.categoryid WHERE a.id = ac.articleid;
DROP TABLE IF EXISTS `kb_articles_categories`;

ALTER TABLE  `kb_articles` ADD  `includefaq` TINYINT( 2 ) NOT NULL DEFAULT  '0';
ALTER TABLE  `troubleticket_files` ADD  `troubleticket_log_id` INT NOT NULL DEFAULT  '0';

DELETE FROM `setting` WHERE name='Check Domain Availability';

UPDATE `customuserfields` SET  `InSignup` =  '0' WHERE  `type` = 8;

DELETE FROM `tld_extra_attributes`;
INSERT INTO `tld_extra_attributes` (`tld`, `extra_attributes`) VALUES
('us', 'a:2:{s:8:"us_nexus";a:3:{s:2:"ID";s:1:"1";s:11:"description";s:14:"Nexus Category";s:7:"options";a:5:{s:10:"US Citizen";a:2:{s:11:"description";s:37:"A natural person who is a US Citizen.";s:5:"value";s:3:"C11";}s:18:"Permanent Resident";a:2:{s:11:"description";s:45:"A natural person who is a Permanent Resident.";s:5:"value";s:3:"C12";}s:15:"Business Entity";a:2:{s:11:"description";s:449:"An entity or organization that is (i) incorporated within one of the fifty US states, the District of Columbia, or any of the US possessions or territories, or (ii) organized or otherwise constituted under the laws of a state of the US, the District of Columbia or any of its possessions and territories (including federal, state, or local government of the US, or a political subdivision thereof, and non-commercial organizations based in the US.).";s:5:"value";s:3:"C21";}s:14:"Foreign Entity";a:3:{s:11:"description";s:0:"";s:5:"value";s:3:"C31";s:8:"requires";a:1:{i:0;s:1:"4";}}s:15:"US Based Office";a:3:{s:11:"description";s:0:"";s:5:"value";s:3:"C32";s:8:"requires";a:1:{i:0;s:1:"4";}}}}s:10:"us_purpose";a:3:{s:2:"ID";s:1:"2";s:11:"description";s:19:"Application Purpose";s:7:"options";a:5:{s:10:"For Profit";a:2:{s:11:"description";s:23:"Business use for profit";s:5:"value";s:2:"P1";}s:10:"Non-profit";a:2:{s:11:"description";s:68:"Non-profit business, club, association, religious organization, etc.";s:5:"value";s:2:"P2";}s:8:"Personal";a:2:{s:11:"description";s:12:"Personal use";s:5:"value";s:2:"P3";}s:11:"Educational";a:2:{s:11:"description";s:20:"Educational purposes";s:5:"value";s:2:"P4";}s:10:"Government";a:2:{s:11:"description";s:19:"Government purposes";s:5:"value";s:2:"P5";}}}}'),
('ca', 'a:5:{s:15:"cira_legal_type";a:3:{s:2:"ID";s:1:"5";s:11:"description";s:32:"Legal type of registrant contact";s:7:"options";a:18:{s:11:"Corporation";a:2:{s:11:"description";s:571:"A corporation under the laws of Canada or any province or territory of Canada, Charities, Cooperative, Council.<br/>Requirements: Registrant name must be the full legal name of the corporation and must be followed by the jurisdiction of incorporation (eg. Canada, Ontario, NWT...), unless it is obvious from the corporation''s name. Canadian Internet Registration Authority (Canada). For Charities, the NFP should be included in the organization name. If this is a not-for-profit organization, you are also required to submit the registration number i.e.: 123456789 RR0001";s:5:"value";s:3:"CCO";}s:16:"Canadian Citizen";a:3:{s:11:"description";s:885:"A Canadian citizen of the age of majority under the laws of the province or territory in Canada in which he or she resides or last resided.<br/>Requirements: The Registrant''s name must be the full legal name of the Canadian Citizen who will hold the domain name registration as the name would appear on a passport, driver''s license or other identification document issued by a government. The name can be followed by a space and "o/a xxxx" where "o/a" stands for "Operating As" and "xxxx" can be any alpha-numeric string designated by the applicant and subject to applicable rules and length restrictions (e.g. "John Doe o/a Doe Consulting Group"). The name may also be followed by a space and a degree granted to the registrant (eg. PhD.) Full legal names of individuals may only consist of alphabetic characters and the special characters: single quote mark(''), hyphen(-), period(.).";s:5:"value";s:3:"CCT";s:8:"requires";a:1:{i:0;s:3:"303";}}s:17:"Canadian Resident";a:3:{s:11:"description";s:1534:"A permanent resident as defined in the Immigration and Refugee Protection Act (Canada) S.C. 2001, c.27, as amended from time to time, who is "ordinarily resident" (as defined below) in Canada and of the age of majority under the laws of the province or territory in Canada in which he or she resides or last resided. "Ordinarily resident in Canada" means an individual who resides in Canada for more than 183 days in the twelve month period immediately preceding the date of the applicable request for registration of the .ca domain name or sub-domain name and in each twelve month period thereafter for the duration of the domain name registration.<br/>Requirements: The Registrant''s name must be the full legal name of the Permanent Resident who will hold the domain name registration as the name would appear on a driver''s license or other identification document issued by a government. The full legal name may be followed by a space and "o/a xxxx" where "o/a" stands for "Operating As" and "xxxx" can be any alpha-numeric string designated by the applicant and subject to applicable rules and length restrictions (e.g. "John Doe o/a Doe Consulting Group"). The name may also be followed by a space and a degree granted to the registrant by a recognized degree granting institution or a recognized professional designation which the registrant has the right to use (eg. PhD, MD, DDS.) Full legal names of individuals may only consist of alphabetic characters and the special characters: single quote mark(''), hyphen(-), period(.).";s:5:"value";s:3:"RES";s:8:"requires";a:1:{i:0;s:3:"303";}}s:17:"Government Entity";a:2:{s:11:"description";s:732:"Her Majesty the Queen in right of Canada, a province or a territory; an agent of Her Majesty the Queen in right of Canada, of a province or of a territory; a federal, provincial or territorial Crown corporation, government agency or government entity; or a regional, municipal or local area government.<br />Requirements: The Registrant''s name must be the complete official name of the entity that will hold the domain name registration, without any abbreviations. (A common abbreviation may follow the official name in parentheses). If the Registrant is not a government, the Registrant''s name must be followed by the name of the jurisdiction (eg. Canada, province, territory, municipality, etc) to which the Registrant is related.";s:5:"value";s:3:"GOV";}s:11:"Educational";a:2:{s:11:"description";s:983:"(i) A university or college which is located in Canada and which is authorized or recognized as a university or college under an Act of the legislature of a province or territory of Canada; or<br />(ii) A college, post-secondary school, vocational school, secondary school, pre-school or other school or educational institution which is located in Canada and which is recognized by the educational authorities of a province or territory of Canada or licensed under or maintained by an Act of Parliament of Canada or of the legislature of a province or territory of Canada.<br />Requirements: The Registrant''s name must be the complete official name of the institution that will hold the domain name registration, without any abbreviations. A common abbreviation may follow the official name in parentheses. The Registrant name must be followed by the jurisdiction (e.g. name of province, municipality) in which the institution is accredited if not obvious from the Registrant''s name.";s:5:"value";s:3:"EDU";}s:26:"Unincorporated Association";a:2:{s:11:"description";s:1067:"This Registrant Type is principally intended for religious congregations, social and sports clubs and community groups, council (not registered) or society (not registered) which are based and operating in Canada. An unincorporated organization, association or club:<br />(i) At least 80% of whose members: (A) are ordinarily resident in Canada (if such members are individuals); or (B) meet the requirements of any one of the following Registrant Types: Corporation (Canada or Canadian province or territory), Canadian citizen, Permanent Resident of Canada, Partnership Registered in Canada, Trust established in Canada, Legal Representative of a Canadian Citizen or Permanent Resident; and<br />(ii) At least 80% of whose directors, officers, employees, managers, administrators or other representatives are ordinarily resident in Canada.<br />Requirements: The Registrant''s name must be the complete name of the association that will hold the domain name registration, without any abbreviations. (A common abbreviation may follow the complete name in parentheses).";s:5:"value";s:3:"ASS";}s:8:"Hospital";a:2:{s:11:"description";s:565:"A hospital which is located in Canada and which is licensed, authorized or approved to operate as a hospital under an Act of the legislature of a province or territory of Canada<br />Requirements: The Registrant''s name must be the complete official name of the hospital that will hold the domain name registration, without any abbreviations. (A common abbreviation may follow the complete name in parentheses.) The Registrant''s name must be followed by the jurisdiction (eg. name of province) which accredited the hospital if not obvious from the Registrant''s name.";s:5:"value";s:3:"HOP";}s:11:"Partnership";a:2:{s:11:"description";s:666:"A partnership, more than 66 2/3 per cent of whose partners meet the requirements of one of the following Registrant Types: Corporation (Canada or Canadian province or territory), Canadian citizen, Permanent Resident of Canada, Trust established in Canada or a Legal Representative of a Canadian Citizen or Permanent Resident, which is registered as a partnership under the laws of any province or territory of Canada.<br />Requirements: The Registrant''s name must be the registered name of the partnership that will hold the domain name registration. The Registrant name must be followed by the jurisdiction of registration (eg. Alberta) and the registration number.";s:5:"value";s:3:"PRT";}s:10:"Trade-mark";a:2:{s:11:"description";s:898:"A Person which does not fall under any other registrant type, but which is the owner of a trade-mark which is the subject of a registration under the Trade-marks Act (Canada) R.S.C. 1985, c.T-13 as amended from time to time, but in this case such permission is limited to a request to register a .ca domain name consisting of or including the exact word component of that registered trade-mark.<br />This Registrant Type is only intended for Registrants which do not meet the requirements associated with any other registrant type but which have a trade-mark registered in Canada. (Trade-marks subject of trade-mark applications and trade-marks registered in other jurisdictions, such as the United States, do not qualify.)<br />The domain name to be registered must include the trade-mark. (eg. If the trade-mark is AVEA this type of registrant can register avea.ca or aveaisus.ca but not xyz.ca).";s:5:"value";s:3:"TDM";}s:11:"Trade Union";a:2:{s:11:"description";s:526:"A trade union which is recognized by a labour board under the laws of Canada or any province or territory of Canada and which has its head office in Canada.<br />Requirements: The Registrant''s name must be the complete official name of the trade union that will hold the domain name registration, without abbreviations. (A common abbreviation may follow the official name in parentheses.) The Registrant name must be followed by the jurisdiction in Canada which recognizes it (if it is not obvious from the Registrant''s name.)";s:5:"value";s:3:"TRD";}s:15:"Political Party";a:2:{s:11:"description";s:482:"A political party registered under a relevant electoral law of Canada or any province or territory of Canada<br />Requirements: The Registrant''s name must be the complete official name of the political party holding the domain name registration, without abbreviations. (A common abbreviation may follow the official name in parentheses.) The Registrant name must also by followed by the jurisdiction in Canada in which it is registered (if it is not obvious from the official name).";s:5:"value";s:3:"PLT";}s:26:"Library, Archive or Museum";a:2:{s:11:"description";s:633:"An institution, whether or not incorporated, that:<br />(i) is located in Canada; and<br />(ii) is not established or conducted for profit or does not form part of, or is not administered or directly or indirectly controlled by, a body that is established or conducted for profit in which is held and maintained a collection of documents and other materials that is open to the public or to researchers.<br />Requirements: The Registrant''s name  must be the complete legal name of the institution which will hold the domain name registration without abbreviations. (A common abbreviation may follow the complete name in parentheses.)";s:5:"value";s:3:"LAM";}s:5:"Trust";a:2:{s:11:"description";s:760:"A trust established and subsisting under the laws of a province or territory of Canada, more than 66 2/3 % of whose trustees meet the requirements of one of the following Registrant Types: Corporation (Canada or Canadian province or territory), Canadian citizen, Permanent Resident of Canada, or a Legal Representative of a Canadian Citizen or Permanent Resident.<br />Requirements: The Registrant''s name must be the complete official name of the trust, without any abbreviations. (A common abbreviation may follow the official name in parentheses.) The Registrant name must also indicate the total percentage of the trustees that meet one or more of the following requirements: Canadian citizen, permanent resident, Canadian corporation, legal representative.";s:5:"value";s:3:"TRS";}s:18:"Aboriginal Peoples";a:3:{s:11:"description";s:1346:"Any individual belonging to any Inuit, First Nation, Metis or other people indigenous to Canada.<br />Requirements: The Registrant''s name must be the full legal name of the Aboriginal Person applying for the Registration as it would appear on a driver''s license or other identification document issued by government.<br />The Registrant may enter its full legal name followed by a space and "o/a xxxx" where "o/a" stands for "Operating As" and "xxxx" can be any alpha-numeric string designated by the applicant and subject to applicable rules and length restrictions (e.g. "John Doe o/a Doe Consulting Group"). The name may also be followed by a space and a degree granted to the registrant by a recognized degree granting institution or a recognized professional designation which the registrant has the right to use  (eg. PhD, MD, DDS.)<br />Full legal names of individuals may only consist of alphabetic characters and the special characters: single quote mark(''''), hyphen(-), period(.).<br/>Groups: Any Inuit, First Nation, Metis or other people indigenous to Canada, and any collectivity of such Aboriginal peoples.<br />Requirements: The Registrant''s name must be the complete official name of the indigenous people a collectivity of Aboriginal Persons or, if there is no official name, the name by which the collectivity is commonly known.";s:5:"value";s:3:"ABO";s:8:"requires";a:1:{i:0;s:3:"303";}}s:11:"Indian Band";a:2:{s:11:"description";s:272:"Any Indian band as defined in the Indian Act, R.S.C. 1985, c. I-5, as amended from time to time, and any group of Indian bands;<br />Requirements: The name of Registrant must be the Indian Band Name as registered with the Department of Indian and Northern Affairs, Canada.";s:5:"value";s:3:"INB";}s:20:"Legal Representative";a:3:{s:11:"description";s:865:"An executor, administrator or other legal representative of a Person listed as a Canadian Citizen or Permanent Resident of Canada.<br />Note: This registrant type is only available to a person or entity that has been appointed by legal process to represent an individual who is not competent to represent him or herself. It is not available to anyone who represents a Canadian or foreign corporation  in any capacity.<br />Requirements: The Registrant''s name must be the full legal name of the Canadian Citizen or Permanent Resident of Canada who is being represented as it would appear on a passport, driver''s license or other government identification document. This must be followed by the full legal name and capacity of at least one of the official representatives. The representative should be identified as the administrative contact for these registrations.";s:5:"value";s:3:"LGR";s:8:"requires";a:1:{i:0;s:3:"303";}}s:13:"Official Mark";a:2:{s:11:"description";s:1242:"A Person which does not meet the requirements for any other Registrant Type, but which is a Person intended to be protected by Subsection 9(1) of the Trade-Marks Act (Canada) at whose request the Registrar of Trade-marks has published notice of adoption of any badge, crest, emblem, official mark or other mark pursuant to Subsection 9(1), but in this case such permission is limited to a request to register a .ca domain name consisting of or including the exact word component of such badge, crest, emblem, official mark or other mark in respect of which such Person requested publications.<br />Notes: This registrant type is only intended for Registrants which do not meet the requirements associated with any other registrant type but which have an Official Mark registered in Canada. The domain name must include the official mark (eg. If the official mark is WIPO, the registrant can register wipo.ca but not intellectual-property.ca)<br />Requirements: The Registrant''s name must be the complete official name of the entity holding the domain name registration without any abbreviations. (A common abbreviation may follow the complete name in parentheses.) The registration number of the official mark must follow the Registrant Name.";s:5:"value";s:3:"OMK";}s:9:"The Queen";a:2:{s:11:"description";s:183:"Her Majesty Queen Elizabeth the Second and her successors. Requirements: The Registrant''s name must be that of Her Majesty the Queen or, after a succession, the name of her successor.";s:5:"value";s:3:"MAJ";}}}s:18:"cira_whois_display";a:3:{s:2:"ID";s:3:"303";s:11:"description";s:34:"Hide registrant data in CIRA WHOIS";s:7:"options";a:2:{s:2:"No";a:2:{s:11:"description";s:61:"Do not hide the registrant contact information in CIRA WHOIS.";s:5:"value";s:4:"FULL";}s:3:"Yes";a:2:{s:11:"description";s:86:"Hide the registrant contact information in Cira WHOIS (only available to individuals).";s:5:"value";s:7:"PRIVATE";}}}s:13:"cira_language";a:3:{s:2:"ID";s:3:"180";s:11:"description";s:50:"The contact''s preferred language for communication";s:7:"options";a:2:{s:7:"English";a:2:{s:11:"description";s:52:"Use English for Registry to Registrant communication";s:5:"value";s:2:"en";}s:6:"French";a:2:{s:11:"description";s:51:"Use French for Registry to Registrant communication";s:5:"value";s:2:"fr";}}}s:22:"cira_agreement_version";a:3:{s:2:"ID";s:3:"181";s:11:"description";s:107:"Version of the CIRA Registrant Agreement displayed and agreed to by the Registrant on the Registrar website";s:7:"options";a:1:{s:3:"2.0";a:2:{s:11:"description";s:39:"Current Version of Registrant Agreement";s:5:"value";s:3:"2.0";}}}s:20:"cira_agreement_value";a:3:{s:2:"ID";s:3:"183";s:11:"description";s:52:"Registrant has agreed to CIRA''s Registrant Agreement";s:7:"options";a:2:{s:2:"No";a:2:{s:11:"description";s:875:""You have read, understood and agree to the terms and conditions of the Registrant\nAgreement, and that CIRA may, from time to time and at its discretion, amend any or all of\nthe terms and conditions of the Registrant Agreement, as CIRA deems appropriate, by\nposting a notice of the changes on the CIRA website and by sending a notice of any\nmaterial changes to Registrant.""You meet all the requirements of the Registrant Agreement to be a Registrant, to apply for\nthe registration of a Domain Name Registration, and to hold and maintain a Domain Name\nRegistration, including without limitation CIRA''s Canadian Presence Requirements for\nRegistrants, at: www.cira.ca/assets/Documents/Legal/Registrants/CPR.pdf.""CIRA will collect, use and disclose your personal information, as set out in CIRA''s\nPrivacy Policy, at: www.cira.ca/assets/Documents/Legal/Registrants/privacy.pdf."";s:5:"value";s:1:"N";}s:3:"Yes";a:2:{s:11:"description";s:875:""You have read, understood and agree to the terms and conditions of the Registrant\nAgreement, and that CIRA may, from time to time and at its discretion, amend any or all of\nthe terms and conditions of the Registrant Agreement, as CIRA deems appropriate, by\nposting a notice of the changes on the CIRA website and by sending a notice of any\nmaterial changes to Registrant.""You meet all the requirements of the Registrant Agreement to be a Registrant, to apply for\nthe registration of a Domain Name Registration, and to hold and maintain a Domain Name\nRegistration, including without limitation CIRA''s Canadian Presence Requirements for\nRegistrants, at: www.cira.ca/assets/Documents/Legal/Registrants/CPR.pdf.""CIRA will collect, use and disclose your personal information, as set out in CIRA''s\nPrivacy Policy, at: www.cira.ca/assets/Documents/Legal/Registrants/privacy.pdf."";s:5:"value";s:1:"Y";}}}}'),
('co.uk', 'a:2:{s:12:"uk_reg_co_no";a:3:{s:2:"ID";s:1:"8";s:11:"description";s:29:"Company identification number";s:7:"options";a:0:{}}s:14:"registered_for";a:3:{s:2:"ID";s:2:"15";s:11:"description";s:88:"Company or person domain is registered for (this must be accurate and CANNOT BE CHANGED)";s:7:"options";a:0:{}}}'),
('org.uk', 'a:2:{s:12:"uk_reg_co_no";a:3:{s:2:"ID";s:1:"9";s:11:"description";s:29:"Company identification number";s:7:"options";a:0:{}}s:14:"registered_for";a:3:{s:2:"ID";s:2:"16";s:11:"description";s:88:"Company or person domain is registered for (this must be accurate and CANNOT BE CHANGED)";s:7:"options";a:0:{}}}'),
('law.pro', 'a:1:{s:14:"pro_profession";a:3:{s:2:"ID";s:3:"264";s:11:"description";s:64:"Indicated professional association recognized by government body";s:7:"options";a:0:{}}}'),
('med.pro', 'a:1:{s:14:"pro_profession";a:3:{s:2:"ID";s:3:"265";s:11:"description";s:64:"Indicated professional association recognized by government body";s:7:"options";a:0:{}}}'),
('cpa.pro', 'a:1:{s:14:"pro_profession";a:3:{s:2:"ID";s:3:"266";s:11:"description";s:64:"Indicated professional association recognized by government body";s:7:"options";a:0:{}}}'),
('me.uk', 'a:2:{s:12:"uk_reg_co_no";a:3:{s:2:"ID";s:2:"34";s:11:"description";s:29:"Company identification number";s:7:"options";a:0:{}}s:14:"registered_for";a:3:{s:2:"ID";s:2:"32";s:11:"description";s:88:"Company or person domain is registered for (this must be accurate and CANNOT BE CHANGED)";s:7:"options";a:0:{}}}'),
('eu', 'a:1:{s:14:"eu_whoispolicy";a:3:{s:2:"ID";s:2:"45";s:11:"description";s:29:"Registry Data Transfer Policy";s:7:"options";a:1:{s:7:"I AGREE";a:2:{s:11:"description";s:458:"I hereby agree that the Registry is entitled to transfer the data contained in this application to third parties (i) if ordered to do so by a public authority, carrying out its legitimate tasks; and (ii) upon demand of an ADR Provider as mentioned in section 16 of the Terms and Conditions which are published at www.eurid.eu; and (iii) as provided in Section 2 (WHOIS look-up facility) of the .eu Domain Name WHOIS Policy which is published at www.eurid.eu.";s:5:"value";s:7:"I AGREE";}}}}'),
('it', 'a:7:{s:6:"it_pin";a:3:{s:2:"ID";s:3:"151";s:11:"description";s:342:"Tax ID. If the requester is an Italian natural person it contains his/her Codice Fiscale. \nFor foreigners it can contain a  document number. For associations without VAT number and tax code must be equal to "n.a.". \nIn all the other cases must be equal to VAT number (in the 11 numbers format if Nationality=IT) or the numeric Codice Fiscale.";s:7:"options";a:1:{s:14:"Codice Fiscale";a:2:{s:11:"description";s:334:"If the requester is an Italian natural person it contains his/her Codice Fiscale. \nFor foreigners it can contain a  document number. For associations without VAT number and tax code must be equal to "n.a.". \nIn all the other cases must be equal to VAT number (in the 11 numbers format if Nationality=IT) or the numeric Codice Fiscale.";s:5:"value";s:1:"1";}}}s:14:"it_entity_type";a:3:{s:2:"ID";s:3:"152";s:11:"description";s:25:"Type of Registrant Entity";s:7:"options";a:7:{s:38:"1. Italian and foreign natural persons";a:2:{s:11:"description";s:35:"Italian and foreign natural persons";s:5:"value";s:1:"1";}s:30:"2. Companies/One Man Companies";a:2:{s:11:"description";s:27:"Companies/One Man Companies";s:5:"value";s:1:"2";}s:34:"3. Freelance workers/professionals";a:2:{s:11:"description";s:31:"Freelance workers/professionals";s:5:"value";s:1:"3";}s:27:"4. Non-Profit Organizations";a:2:{s:11:"description";s:24:"Non-Profit Organizations";s:5:"value";s:1:"4";}s:23:"5. Public Organizations";a:2:{s:11:"description";s:20:"Public Organizations";s:5:"value";s:1:"5";}s:17:"6. Other Subjects";a:2:{s:11:"description";s:14:"Other Subjects";s:5:"value";s:1:"6";}s:27:"7. Foreigners who match 2-6";a:2:{s:11:"description";s:24:"Foreigners who match 2-6";s:5:"value";s:1:"7";}}}s:23:"it_consentforpublishing";a:3:{s:2:"ID";s:3:"153";s:11:"description";s:48:"Allow the publication of contact''s personal data";s:7:"options";a:1:{s:17:"Allow Publication";a:2:{s:11:"description";s:17:"Allow Publication";s:5:"value";s:1:"1";}}}s:24:"it_personal_data_for_reg";a:3:{s:2:"ID";s:3:"154";s:11:"description";s:37:"Consent for Processing of Information";s:7:"options";a:1:{s:5:"Agree";a:2:{s:11:"description";s:323:"The interested party, after reading the above disclosure, gives consent to the processing of\ninformation required for registration, as defined in the above disclosure.\nGiving consent is optional, but if no consent is given, it will not be possible to finalize the\nregistration, assignment and management of the domain name.";s:5:"value";s:1:"1";}}}s:19:"it_datafordiffusion";a:3:{s:2:"ID";s:3:"174";s:11:"description";s:60:"Consent for Dissemination and Accessibility via the Internet";s:7:"options";a:1:{s:5:"Agree";a:2:{s:11:"description";s:284:"The interested party, after reading the above disclosure, gives consent to the dissemination\nand accessibility via the Internet, as defined in the disclosure above.\nGiving consent is optional, but absence of consent does not allow the dissemination and\naccessibility of Internet data.";s:5:"value";s:1:"1";}}}s:18:"it_sect3_liability";a:3:{s:2:"ID";s:3:"155";s:11:"description";s:20:"Terms and Conditions";s:7:"options";a:1:{s:5:"Agree";a:2:{s:11:"description";s:1713:"The Registrant of the domain name in question, declares under their own responsibility that\nthey are:<br>\na) in possession of the citizenship or resident in a country belonging to the European\n   Union (in the case of registration for natural persons);<br>\nb) established in a country belonging to the European Union (in the case of registration\n   for other organizations););<br>\nc) aware and accept that the registration and management of a domain name is subject to\n   the "Rules of assignment and management of domain names in ccTLD. it" and"Regulations for the resolution of disputes in the ccTLD.it" and their subsequent\n   amendments;);<br>\nd) entitled to the use and/or legal availability of the domain name applied for, and that\n   they do not prejudice, with the request for registration, the rights of others;);<br>\ne) aware that for the inclusion of personal data in the Database of assigned domain\n   names, and their possible dissemination and accessibility via the Internet, consent\n   must be given explicitly by ticking the appropriate boxes in the information below.\n   See "The policy of the .it Registry in the Whois Database" on the website of the\n   Registry (http://www.nic.it););<br>\nf) aware and agree that in the case of erroneous or false declarations in this request, the\n   Registry shall immediately revoke the domain name, or proceed with other legal\n   actions. In such case the revocation shall not in any way give rise to claims against the\n   Registry;);<br>\ng) release the Registry from any liability resulting from the assignment and use of the\n   domain name by the natural person that has made the request;);<br>\nh) accept Italian jurisdiction and laws of the Italian State.";s:5:"value";s:1:"1";}}}s:22:"it_explicit_acceptance";a:3:{s:2:"ID";s:3:"175";s:11:"description";s:37:"Explicit Acceptance of Registry Terms";s:7:"options";a:1:{s:5:"Agree";a:2:{s:11:"description";s:844:"For explicit acceptance, the interested party declares that they:<br>\nc) are aware and agree that the registration and management of a domain name is subject to\n   the "Rules of assignment and management of domain names in ccTLD.it" and "Regulations\n   for the resolution of disputes in the ccTLD.it "and their subsequent amendments;<br>\nf) are aware and agree that in the case of erroneous or false declarations in this request, the\n   Registry shall immediately revoke the domain name, or proceed with other legal actions. In\n   such case the revocation shall not in any way give rise to claims against the Registry;<br>\ng) release the Registry from any liability resulting from the assignment and use of the\n   domain name by the natural person that has made the request;<br>\nh) accept the Italian jurisdiction and laws of the Italian State.";s:5:"value";s:1:"1";}}}}'),
('pro', 'a:1:{s:14:"pro_profession";a:3:{s:2:"ID";s:3:"190";s:11:"description";s:64:"Indicated professional association recognized by government body";s:7:"options";a:0:{}}}'),
('aaa.pro', 'a:1:{s:14:"pro_profession";a:3:{s:2:"ID";s:3:"267";s:11:"description";s:64:"Indicated professional association recognized by government body";s:7:"options";a:0:{}}}'),
('aca.pro', 'a:1:{s:14:"pro_profession";a:3:{s:2:"ID";s:3:"268";s:11:"description";s:64:"Indicated professional association recognized by government body";s:7:"options";a:0:{}}}'),
('acct.pro', 'a:1:{s:14:"pro_profession";a:3:{s:2:"ID";s:3:"269";s:11:"description";s:64:"Indicated professional association recognized by government body";s:7:"options";a:0:{}}}'),
('eng.pro', 'a:1:{s:14:"pro_profession";a:3:{s:2:"ID";s:3:"270";s:11:"description";s:64:"Indicated professional association recognized by government body";s:7:"options";a:0:{}}}'),
('avocat.pro', 'a:1:{s:14:"pro_profession";a:3:{s:2:"ID";s:3:"271";s:11:"description";s:64:"Indicated professional association recognized by government body";s:7:"options";a:0:{}}}'),
('tel', 'a:4:{s:13:"tel_whoistype";a:3:{s:2:"ID";s:3:"144";s:11:"description";s:23:"Natural or Legal Person";s:7:"options";a:2:{s:14:"Natural Person";a:3:{s:11:"description";s:14:"Natural Person";s:5:"value";s:14:"natural_person";s:8:"requires";a:1:{i:0;s:3:"145";}}s:12:"Legal Person";a:2:{s:11:"description";s:12:"Legal Person";s:5:"value";s:12:"legal_person";}}}s:12:"tel_username";a:3:{s:2:"ID";s:3:"147";s:11:"description";s:8:"Username";s:7:"options";a:0:{}}s:12:"tel_password";a:3:{s:2:"ID";s:3:"148";s:11:"description";s:8:"Password";s:7:"options";a:0:{}}s:16:"tel_emailaddress";a:3:{s:2:"ID";s:3:"150";s:11:"description";s:13:"Email Address";s:7:"options";a:0:{}}}'),
('bar.pro', 'a:1:{s:14:"pro_profession";a:3:{s:2:"ID";s:3:"272";s:11:"description";s:64:"Indicated professional association recognized by government body";s:7:"options";a:0:{}}}'),
('jur.pro', 'a:1:{s:14:"pro_profession";a:3:{s:2:"ID";s:3:"273";s:11:"description";s:64:"Indicated professional association recognized by government body";s:7:"options";a:0:{}}}'),
('recht.pro', 'a:1:{s:14:"pro_profession";a:3:{s:2:"ID";s:3:"274";s:11:"description";s:64:"Indicated professional association recognized by government body";s:7:"options";a:0:{}}}'),
('es', 'a:2:{s:15:"es_registrantid";a:3:{s:2:"ID";s:3:"286";s:11:"description";s:9:"ID number";s:7:"options";a:0:{}}s:19:"es_registrantidtype";a:3:{s:2:"ID";s:3:"290";s:11:"description";s:7:"ID type";s:7:"options";a:3:{s:10:"Generic ID";a:2:{s:11:"description";s:90:"Generic ID document used for passports, company registration numbers and foreign documents";s:5:"value";s:1:"0";}s:6:"VAT ID";a:2:{s:11:"description";s:46:"Spanish personal and company VAT ID card (NIF)";s:5:"value";s:1:"1";}s:17:"Resident alien ID";a:2:{s:11:"description";s:36:"Spanish resident alien ID card (NIE)";s:5:"value";s:1:"3";}}}}'),
('com.es', 'a:2:{s:15:"es_registrantid";a:3:{s:2:"ID";s:3:"287";s:11:"description";s:9:"ID number";s:7:"options";a:0:{}}s:19:"es_registrantidtype";a:3:{s:2:"ID";s:3:"291";s:11:"description";s:7:"ID type";s:7:"options";a:3:{s:10:"Generic ID";a:2:{s:11:"description";s:90:"Generic ID document used for passports, company registration numbers and foreign documents";s:5:"value";s:1:"0";}s:6:"VAT ID";a:2:{s:11:"description";s:46:"Spanish personal and company VAT ID card (NIF)";s:5:"value";s:1:"1";}s:17:"Resident alien ID";a:2:{s:11:"description";s:36:"Spanish resident alien ID card (NIE)";s:5:"value";s:1:"3";}}}}'),
('nom.es', 'a:2:{s:15:"es_registrantid";a:3:{s:2:"ID";s:3:"288";s:11:"description";s:9:"ID number";s:7:"options";a:0:{}}s:19:"es_registrantidtype";a:3:{s:2:"ID";s:3:"292";s:11:"description";s:7:"ID type";s:7:"options";a:3:{s:10:"Generic ID";a:2:{s:11:"description";s:90:"Generic ID document used for passports, company registration numbers and foreign documents";s:5:"value";s:1:"0";}s:6:"VAT ID";a:2:{s:11:"description";s:46:"Spanish personal and company VAT ID card (NIF)";s:5:"value";s:1:"1";}s:17:"Resident alien ID";a:2:{s:11:"description";s:36:"Spanish resident alien ID card (NIE)";s:5:"value";s:1:"3";}}}}'),
('org.es', 'a:2:{s:15:"es_registrantid";a:3:{s:2:"ID";s:3:"289";s:11:"description";s:9:"ID number";s:7:"options";a:0:{}}s:19:"es_registrantidtype";a:3:{s:2:"ID";s:3:"293";s:11:"description";s:7:"ID type";s:7:"options";a:3:{s:10:"Generic ID";a:2:{s:11:"description";s:90:"Generic ID document used for passports, company registration numbers and foreign documents";s:5:"value";s:1:"0";}s:6:"VAT ID";a:2:{s:11:"description";s:46:"Spanish personal and company VAT ID card (NIF)";s:5:"value";s:1:"1";}s:17:"Resident alien ID";a:2:{s:11:"description";s:36:"Spanish resident alien ID card (NIE)";s:5:"value";s:1:"3";}}}}'),
('au', 'a:2:{s:15:"au_registrantid";a:3:{s:2:"ID";s:3:"294";s:11:"description";s:9:"ID number";s:7:"options";a:0:{}}s:19:"au_registrantidtype";a:3:{s:2:"ID";s:3:"298";s:11:"description";s:7:"ID type";s:7:"options";a:4:{s:26:"Australian Business Number";a:2:{s:11:"description";s:26:"Australian Business Number";s:5:"value";s:3:"ABN";}s:25:"Australian Company Number";a:2:{s:11:"description";s:25:"Australian Company Number";s:5:"value";s:3:"ACN";}s:28:"Business Registration Number";a:2:{s:11:"description";s:28:"Business Registration Number";s:5:"value";s:3:"RBN";}s:16:"Trademark Number";a:2:{s:11:"description";s:16:"Trademark Number";s:5:"value";s:2:"TM";}}}}'),
('com.au', 'a:2:{s:15:"au_registrantid";a:3:{s:2:"ID";s:3:"295";s:11:"description";s:9:"ID number";s:7:"options";a:0:{}}s:19:"au_registrantidtype";a:3:{s:2:"ID";s:3:"299";s:11:"description";s:7:"ID type";s:7:"options";a:4:{s:26:"Australian Business Number";a:2:{s:11:"description";s:26:"Australian Business Number";s:5:"value";s:3:"ABN";}s:25:"Australian Company Number";a:2:{s:11:"description";s:25:"Australian Company Number";s:5:"value";s:3:"ACN";}s:28:"Business Registration Number";a:2:{s:11:"description";s:28:"Business Registration Number";s:5:"value";s:3:"RBN";}s:16:"Trademark Number";a:2:{s:11:"description";s:16:"Trademark Number";s:5:"value";s:2:"TM";}}}}'),
('org.au', 'a:2:{s:15:"au_registrantid";a:3:{s:2:"ID";s:3:"297";s:11:"description";s:9:"ID number";s:7:"options";a:0:{}}s:19:"au_registrantidtype";a:3:{s:2:"ID";s:3:"301";s:11:"description";s:7:"ID type";s:7:"options";a:4:{s:26:"Australian Business Number";a:2:{s:11:"description";s:26:"Australian Business Number";s:5:"value";s:3:"ABN";}s:25:"Australian Company Number";a:2:{s:11:"description";s:25:"Australian Company Number";s:5:"value";s:3:"ACN";}s:28:"Business Registration Number";a:2:{s:11:"description";s:28:"Business Registration Number";s:5:"value";s:3:"RBN";}s:16:"Trademark Number";a:2:{s:11:"description";s:16:"Trademark Number";s:5:"value";s:2:"TM";}}}}'),
('net.au', 'a:2:{s:15:"au_registrantid";a:3:{s:2:"ID";s:3:"296";s:11:"description";s:9:"ID number";s:7:"options";a:0:{}}s:19:"au_registrantidtype";a:3:{s:2:"ID";s:3:"300";s:11:"description";s:7:"ID type";s:7:"options";a:4:{s:26:"Australian Business Number";a:2:{s:11:"description";s:26:"Australian Business Number";s:5:"value";s:3:"ABN";}s:25:"Australian Company Number";a:2:{s:11:"description";s:25:"Australian Company Number";s:5:"value";s:3:"ACN";}s:28:"Business Registration Number";a:2:{s:11:"description";s:28:"Business Registration Number";s:5:"value";s:3:"RBN";}s:16:"Trademark Number";a:2:{s:11:"description";s:16:"Trademark Number";s:5:"value";s:2:"TM";}}}}'),
('sg', 'a:1:{s:8:"sg_rcbid";a:3:{s:2:"ID";s:3:"304";s:11:"description";s:121:"For individual: The corresponding ID-Card/Passport\nFor organization: The corresponding company registration or VAT-number";s:7:"options";a:0:{}}}'),
('com.sg', 'a:1:{s:8:"sg_rcbid";a:3:{s:2:"ID";s:3:"305";s:11:"description";s:121:"For individual: The corresponding ID-Card/Passport\nFor organization: The corresponding company registration or VAT-number";s:7:"options";a:0:{}}}'),
('fr', 'a:1:{s:12:"fr_legaltype";a:3:{s:2:"ID";s:3:"306";s:11:"description";s:75:"Depending on the type of registrant, different extensions must be provided.";s:7:"options";a:2:{s:7:"Company";a:2:{s:11:"description";s:73:"Companies having their head office in the territory of the European Union";s:5:"value";s:7:"Company";}s:10:"Individual";a:2:{s:11:"description";s:45:"Individual person responsible for the domain.";s:5:"value";s:10:"Individual";}}}}'),
('lannie', 'a:1:{s:17:"lannie_legal_type";a:3:{s:2:"ID";s:3:"302";s:11:"description";s:37:"Bogus legal type to see if this works";s:7:"options";a:1:{s:11:"Corporation";a:2:{s:11:"description";s:567:"A corporation under the laws of Canada or any province or territory of Canada, Charities, Cooperative, Council.\nRequirements: Registrant name must be the full legal name of the corporation and must be followed by the jurisdiction of incorporation (eg. Canada, Ontario, NWT...), unless it is obvious from the corporation''s name. Canadian Internet Registration Authority (Canada). For Charities, the NFP should be included in the organization name. If this is a not-for-profit organization, you are also required to submit the registration number i.e.: 123456789 RR0001";s:5:"value";s:3:"CCO";}}}}');


INSERT INTO `customField` (`id`, `company_id`, `groupId`, `subGroupId`, `fieldType`, `name`, `isRequired`, `isChangeable`, `isAdminOnly`, `fieldOrder`, `showCustomer`, `showAdmin`, `dropDownOptions`, `inSettings`, `InSignup`, `partofproductidentifier`, `desc`, `isEncrypted`) VALUES (NULL, '0', '2', '0', '0', 'Cancellation Reason', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '', '0');
INSERT INTO `customField` (`id`, `company_id`, `groupId`, `subGroupId`, `fieldType`, `name`, `isRequired`, `isChangeable`, `isAdminOnly`, `fieldOrder`, `showCustomer`, `showAdmin`, `dropDownOptions`, `inSettings`, `InSignup`, `partofproductidentifier`, `desc`, `isEncrypted`) VALUES (NULL, '0', '2', '0', '0', 'Cancellation Type', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '', '0');

DELETE from user_customuserfields where customid IN (SELECT id FROM `customuserfields` where name = 'ticket_details_position');
DELETE FROM `customuserfields` where name = 'ticket_details_position';