INSERT INTO `announcement` VALUES (NULL, 'Welcome', 'Welcome to our new billing and support application, ClientExec!  From within, you can easily view and pay your invoices, request assistance with any problems you may encounter, maintain your billing information, resend your welcome E-mail and so much more!', 'Welcome to our new billing and support application, ClientExec!&nbsp; From within, you can easily view and pay your invoices, request assistance with any problems you may encounter, maintain your billing information, resend your welcome E-mail and so much more!', '2007-06-01 20:23:00', '1', '100', '0');

INSERT INTO `billingtype` VALUES (1, 'Hosting', 'New Domain Hosting', 'domain.com (/month) x  = $');
INSERT INTO `billingtype` VALUES (2, 'Maintenance', 'Maintenance', 'Default maintenance detail');
INSERT INTO `billingtype` VALUES (3, 'Development', 'Development', 'Default development detail');
INSERT INTO `billingtype` VALUES (4, 'Installation', 'Installation', 'Default installation detail');
INSERT INTO `billingtype` VALUES (5, 'Misc.', 'Misc.', 'Default Misc. description');
INSERT INTO `billingtype` VALUES (6, 'Overusage', 'Overusage', 'Default overusage detail');
INSERT INTO `billingtype` VALUES('-2', 'Domain Name', 'Domain Name Registration', 'Default name registration detail');
INSERT INTO `billingtype` VALUES ('-3', 'Discount', 'Discount', 'Discount generated by a discount coupon entered at signup');
INSERT INTO `billingtype` VALUES ('-4', 'Package add-on', 'Package add-on', 'Package add-on fee');

INSERT INTO `cache` VALUES ('ADMINSUMMARY', '2003-02-14 22:29:43', '');

INSERT INTO `currency` VALUES (1, 'Slovenia Tolar', 'SIT', 'SIT', 'left', 2);
INSERT INTO `currency` VALUES (2, 'Swiss Franc', 'CHF', 'CHF', 'left', 2);
INSERT INTO `currency` VALUES (3, 'Malaysian Ringgit', 'MYR', 'MYR', 'left', 2);
INSERT INTO `currency` VALUES (4, 'Australian Dollar', '$', 'AUD', 'left', 2);
INSERT INTO `currency` VALUES (5, 'US Dollar', '$', 'USD', 'left', 2);
INSERT INTO `currency` VALUES (6, 'Canadian Dollar', '$', 'CAD', 'left', 2);
INSERT INTO `currency` VALUES (7, 'New Zealand Dollars', 'NZ$', 'NZD', 'left', 2);
INSERT INTO `currency` VALUES (8, 'Saudi Riyal', 'SR', 'SAR', 'left', 2);
INSERT INTO `currency` VALUES (9, 'Turkish Lira', 'TRL', 'TRL', 'left', 2);
INSERT INTO `currency` VALUES (10, 'Swedish Krona', 'Sk', 'SEK', 'left', 2);
INSERT INTO `currency` VALUES (11, 'Singapore Dollar', '$', 'SGD', 'left', 2);
INSERT INTO `currency` VALUES (12, 'Euro', '€', 'EUR', 'left', 2);
INSERT INTO `currency` VALUES (13, 'Indian Rupees', 'Rs.', 'INR', 'left', 2);
INSERT INTO `currency` VALUES (14, 'Philippine Peso', 'PHP', 'PHP', 'left', 2);
INSERT INTO `currency` VALUES (15, 'Yen', '¥', 'JPY', 'left', 2);
INSERT INTO `currency` VALUES (16, 'Pound Sterling (GBP)', '£', 'GBP', 'left', 2);
INSERT INTO `currency` VALUES (17, 'Indonesia Rupiah (Rp)', 'Rp', 'IDR', 'left', 2);

INSERT INTO `customdomainfields` VALUES (1, 'IP Address', 0, 1, 0, 0, 30, 0, 0, 0, '', 0, 0);

INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `description`) VALUES(1, 'Customer', 0, 0, 'All customers belong to this group. You can\'t erase this group.');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `description`) VALUES(2, 'Super Admin', 1, 1, 'Main administrator. He has all permissions in the system and is the only one with permissions to modify staff groups and permissions.');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `description`) VALUES(3, 'Support Staff', 1, 0, 'Has limited permissions on the support module.');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `description`) VALUES(4, 'Billing', 1, 0, 'By default, he has all the permissions in the billing module.');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `description`) VALUES(5, 'Support Manager', 1, 0, 'By default, he has all the permissions in the Support module.');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `description`) VALUES(6, 'Priority Customers', 0, 0, '');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `description`) VALUES(8, 'Big Accounts', 0, 0, '');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `description`) VALUES(7, 'Business Partners', 0, 0, '');
INSERT INTO `groups` (`id`, `name`, `isadmin`, `issuperadmin`, `description`) VALUES(9, 'Personal acquaintances', 0, 0, '');

INSERT INTO `help` VALUES (1, 'Welcome Email Tags', /*T*/'[<font class=bodyhighlight>COMPANYNAME</font>] <br> Company name<br>[<font class=bodyhighlight>COMPANYADDRESS</font>] <br> Company address<br>[<font class=bodyhighlight>ACCOUNTINFORMATION</font>]<br> Includes Domain Name, Username, Password, IP<br>[<font class=bodyhighlight>DOMAINNAME</font>]<br> domain name without http://www.<br>[<font class=bodyhighlight>DOMAINUSERNAME</font>]<br> Domain User Name<br>[<font class=bodyhighlight>DOMAINPASSWORD</font>]<br> Domain Password<br>[<font class=bodyhighlight>DOMAINIP</font>]<br> IP Address to Domain<br>[<font class=bodyhighlight>COMPANYURL</font>]<br> URL to your web site<br>[<font class=bodyhighlight>SUPPORTEMAIL</font>]<br> E-mail to support staff<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>]<br> URL to ClientExec.<br>[<font class=bodyhighlight>FORGOTPASSWORDURL</font>] URL to retrieve forgotten password.<br>[<font class=bodyhighlight>CLIENTNAME</font>]<br>Both first and last name<br>[<font class=bodyhighlight>CLIENTEMAIL</font>]<br>[<font class=bodyhighlight>ORGANIZATION</font>] <br> Client\'s Organization<br>[<font class=bodyhighlight>PLANNAME</font>] <br> Client\'s Plan<br>[<font class=bodyhighlight>NAMESERVERS</font>]<br>lists only hostnames<br>[<font class=bodyhighlight>NAMESERVERSANDIPS</font>]<br>lists both IPs and hostnames<br>[<font class=bodyhighlight>SERVERHOSTNAME</font>]<br>example server1.yourdomain.com<br>[<font class=bodyhighlight>SERVERSHAREDIP</font>]<br>shared IP for server<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is custom profile field name<br>[<font class=bodyhighlight>CUSTOMPACKAGE_xxxx</font>]<br>where xxx is custom package field name'/*~T*/, 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES (6, 'Ticket Template Tags', /*T*/'[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>TICKETNUMBER</font>]<br>[<font class=bodyhighlight>DESCRIPTION</font>]<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>] URL to ClientExec.<BR>[<font class=bodyhighlight>COMPANYNAME</font>] <br>[<font class=bodyhighlight>COMPANYADDRESS</font>] <br>[<font class=bodyhighlight>CUSTOM_xxxx</font>]<br>where xxx is custom field name'/*~T*/, 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES (8, 'Run schedule format', /*T*/'In the Run Schedule fields you can enter any format accepted by the Cron utility. For example for the field Minute: <ul> <li>* : every minute <li>Number: e.g. 4 will make it run at :04 <li>Range: e.g. 1-3 will make it run at :01, :02, :03 <li>List: e.g. 1,3,7 will make it run at :01, :03, :07 <li>Step: e.g. */3 will make it run every third minute <li>Range and step: 0-30/2 will make it run every other minute till :30 </ul> In Day of the Week you can enter a number in the range 0-6 (0 for Sunday) or a 3 letter shortcut (e.g. sun).'/*~T*/, 'Click to view schedule format', 240, 420);
INSERT INTO `help` VALUES (9, 'Batch Invoice Notifier Tags', /*T*/'[<font class=bodyhighlight>DATE</font>] Date payment is due.<br>[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>AMOUNT</font>] The total price due.<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>] URL to ClientExec.<br>[<font class=bodyhighlight>FORGOTPASSWORDURL</font>] URL to retrieve forgotten password.<BR>[<font class=bodyhighlight>COMPANYNAME</font>] <BR>[<font class=bodyhighlight>COMPANYADDRESS</font>] <BR>[<font class=bodyhighlight>BILLINGEMAIL</font>] E-mail address for billing inquiries<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is custom profile field name'/*~T*/, 'Click to view available tags', '240', '320');
INSERT INTO `help` VALUES (11, 'Announcement Tags', /*T*/'[<font class=bodyhighlight>CLIENTNAME</font>]<br> Includes name and last name<br>[<font class=bodyhighlight>FIRSTNAME</font>]<br> First name of the client<br>[<font class=bodyhighlight>LASTNAME</font>]<br> Last name of the client<br>[<font class=bodyhighlight>ORGANIZATION</font>]<br> Client\'s Organization<br>[<font class=bodyhighlight>DATE</font>]<br> Actual Date<br>[<font class=bodyhighlight>COMPANYNAME</font>] <br> Company name<br>[<font class=bodyhighlight>COMPANYADDRESS</font>] <br> Company address'/*~T*/, 'Click to view available tags', 240, 320);

INSERT INTO `package` VALUES (1, 'Basic', 'Plan Features:<br>\r\n1Gig Bandwidth<br>\r\n75MB Diskspace<br>\r\n...', 5, '9.95', 1, '29.85', '59.7', '119.4', '238.8', 1, 1, 1, 1, 1, '0', 1, 'Here is the information for your web hosting account.\r\n\r\n[ACCOUNTINFORMATION]\r\n\r\nFTP Username and password\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]\r\nFTP Password:[DOMAINPASSWORD]\r\n\r\nYou can log in by FTP using either the domain name or the IP address.\r\n\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.\r\n\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:\r\n\r\n[NAMESERVERS]\r\n\r\nFor those who wish to use CGI scripts, the Perl path is:\r\n  /usr/bin/perl\r\nIf you need to use sendmail, it can be found in:\r\n  /usr/sbin/sendmail\r\nYou absolute server path for cgi-bin directory is:\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin\r\nand for the browsable html dir:\r\n  /home/virtual/[DOMAINNAME]/var/www/html\r\n\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.\r\n\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL\r\n\r\n  http://[DOMAINIP]/admin\r\n\r\nOnce your domain name resolves to the new server, you can use the URL\r\n\r\n  http://[DOMAINNAME]/admin\r\n\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin \r\ndirectory located one level up the browsable html dir. \r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.\r\n\r\nYou must back up one directory to see the /cgi-bin and the /html directory. \r\n\r\n/mainwebsite_html dir and /html dir \r\n\r\nTo access your MYSQL database you need the following information:\r\nmysql host: localhost\r\nmysql username: [DOMAINUSERNAME]\r\nmysql password: must be set in your control panel\r\nmysql database name: domainname_ext\r\n(example: yahoo.com -> yahoo_com for db name)\r\n\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:\r\nhttp://[DOMAINIP]/MyAdmin/index.php\r\nLogin with your mysql username and password.\r\n\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.\r\n\r\nThanks for choosing our company.', 'Here is the information for your web hosting account.<br />\r\n<br />\r\n[ACCOUNTINFORMATION]<br />\r\n<br />\r\nFTP Username and password<br />\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]<br />\r\nFTP Password:[DOMAINPASSWORD]<br />\r\n<br />\r\nYou can log in by FTP using either the domain name or the IP address.<br />\r\n<br />\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.<br />\r\n<br />\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:<br />\r\n<br />\r\n[NAMESERVERS]<br />\r\n<br />\r\nFor those who wish to use CGI scripts, the Perl path is:<br />\r\n  /usr/bin/perl<br />\r\nIf you need to use sendmail, it can be found in:<br />\r\n  /usr/sbin/sendmail<br />\r\nYou absolute server path for cgi-bin directory is:<br />\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin<br />\r\nand for the browsable html dir:<br />\r\n  /home/virtual/[DOMAINNAME]/var/www/html<br />\r\n<br />\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.<br />\r\n<br />\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL<br />\r\n<br />\r\n  http://[DOMAINIP]/admin<br />\r\n<br />\r\nOnce your domain name resolves to the new server, you can use the URL<br />\r\n<br />\r\n  http://[DOMAINNAME]/admin<br />\r\n<br />\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin <br />\r\ndirectory located one level up the browsable html dir. <br />\r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.<br />\r\n<br />\r\nYou must back up one directory to see the /cgi-bin and the /html directory. <br />\r\n<br />\r\n/mainwebsite_html dir and /html dir <br />\r\n<br />\r\nTo access your MYSQL database you need the following information:<br />\r\nmysql host: localhost<br />\r\nmysql username: [DOMAINUSERNAME]<br />\r\nmysql password: must be set in your control panel<br />\r\nmysql database name: domainname_ext<br />\r\n(example: yahoo.com -> yahoo_com for db name)<br />\r\n<br />\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:<br />\r\nhttp://[DOMAINIP]/MyAdmin/index.php<br />\r\nLogin with your mysql username and password.<br />\r\n<br />\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.<br />\r\n<br />\r\nThanks for choosing our company.', '', 0, DEFAULT, DEFAULT);
INSERT INTO `package` VALUES (2, 'Standard', 'Plan Features:<br>\r\n3Gig Bandwidth<br> \r\n150MB Diskspace<br>\r\n...', 5, '17.95', 1, '53.85', '107.7', '215.4', '430.8', 1, 1, 1, 1, 1, '0', 1, 'Here is the information for your web hosting account.\r\n\r\n[ACCOUNTINFORMATION]\r\n\r\nFTP Username and password\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]\r\nFTP Password:[DOMAINPASSWORD]\r\n\r\nYou can log in by FTP using either the domain name or the IP address.\r\n\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.\r\n\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:\r\n\r\n[NAMESERVERS]\r\n\r\nFor those who wish to use CGI scripts, the Perl path is:\r\n  /usr/bin/perl\r\nIf you need to use sendmail, it can be found in:\r\n  /usr/sbin/sendmail\r\nYou absolute server path for cgi-bin directory is:\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin\r\nand for the browsable html dir:\r\n  /home/virtual/[DOMAINNAME]/var/www/html\r\n\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.\r\n\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL\r\n\r\n  http://[DOMAINIP]/admin\r\n\r\nOnce your domain name resolves to the new server, you can use the URL\r\n\r\n  http://[DOMAINNAME]/admin\r\n\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin \r\ndirectory located one level up the browsable html dir. \r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.\r\n\r\nYou must back up one directory to see the /cgi-bin and the /html directory. \r\n\r\n/mainwebsite_html dir and /html dir \r\n\r\nTo access your MYSQL database you need the following information:\r\nmysql host: localhost\r\nmysql username: [DOMAINUSERNAME]\r\nmysql password: must be set in your control panel\r\nmysql database name: domainname_ext\r\n(example: yahoo.com -> yahoo_com for db name)\r\n\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:\r\nhttp://[DOMAINIP]/MyAdmin/index.php\r\nLogin with your mysql username and password.\r\n\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.\r\n\r\nThanks for choosing our company.', 'Here is the information for your web hosting account.<br />\r\n<br />\r\n[ACCOUNTINFORMATION]<br />\r\n<br />\r\nFTP Username and password<br />\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]<br />\r\nFTP Password:[DOMAINPASSWORD]<br />\r\n<br />\r\nYou can log in by FTP using either the domain name or the IP address.<br />\r\n<br />\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.<br />\r\n<br />\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:<br />\r\n<br />\r\n[NAMESERVERS]<br />\r\n<br />\r\nFor those who wish to use CGI scripts, the Perl path is:<br />\r\n  /usr/bin/perl<br />\r\nIf you need to use sendmail, it can be found in:<br />\r\n  /usr/sbin/sendmail<br />\r\nYou absolute server path for cgi-bin directory is:<br />\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin<br />\r\nand for the browsable html dir:<br />\r\n  /home/virtual/[DOMAINNAME]/var/www/html<br />\r\n<br />\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.<br />\r\n<br />\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL<br />\r\n<br />\r\n  http://[DOMAINIP]/admin<br />\r\n<br />\r\nOnce your domain name resolves to the new server, you can use the URL<br />\r\n<br />\r\n  http://[DOMAINNAME]/admin<br />\r\n<br />\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin <br />\r\ndirectory located one level up the browsable html dir. <br />\r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.<br />\r\n<br />\r\nYou must back up one directory to see the /cgi-bin and the /html directory. <br />\r\n<br />\r\n/mainwebsite_html dir and /html dir <br />\r\n<br />\r\nTo access your MYSQL database you need the following information:<br />\r\nmysql host: localhost<br />\r\nmysql username: [DOMAINUSERNAME]<br />\r\nmysql password: must be set in your control panel<br />\r\nmysql database name: domainname_ext<br />\r\n(example: yahoo.com -> yahoo_com for db name)<br />\r\n<br />\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:<br />\r\nhttp://[DOMAINIP]/MyAdmin/index.php<br />\r\nLogin with your mysql username and password.<br />\r\n<br />\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.<br />\r\n<br />\r\nThanks for choosing our company.', '', 0, DEFAULT, DEFAULT);
INSERT INTO `package` VALUES (3, 'Charity', 'Only for charity sites with low bandwidth and diskspace<br><br>\r\nPlan Features:<br>\r\n500Gig Bandwidth<br> \r\n10MB Diskspace<br>\r\n...', 5, '3', 1, '9', '18', '36', '72', 1, 1, 1, 1, 1, '0', 1, 'Here is the information for your web hosting account.\r\n\r\n[ACCOUNTINFORMATION]\r\n\r\nFTP Username and password\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]\r\nFTP Password:[DOMAINPASSWORD]\r\n\r\nYou can log in by FTP using either the domain name or the IP address.\r\n\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.\r\n\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:\r\n\r\n[NAMESERVERS]\r\n\r\nFor those who wish to use CGI scripts, the Perl path is:\r\n  /usr/bin/perl\r\nIf you need to use sendmail, it can be found in:\r\n  /usr/sbin/sendmail\r\nYou absolute server path for cgi-bin directory is:\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin\r\nand for the browsable html dir:\r\n  /home/virtual/[DOMAINNAME]/var/www/html\r\n\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.\r\n\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL\r\n\r\n  http://[DOMAINIP]/admin\r\n\r\nOnce your domain name resolves to the new server, you can use the URL\r\n\r\n  http://[DOMAINNAME]/admin\r\n\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin \r\ndirectory located one level up the browsable html dir. \r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.\r\n\r\nYou must back up one directory to see the /cgi-bin and the /html directory. \r\n\r\n/mainwebsite_html dir and /html dir \r\n\r\nTo access your MYSQL database you need the following information:\r\nmysql host: localhost\r\nmysql username: [DOMAINUSERNAME]\r\nmysql password: must be set in your control panel\r\nmysql database name: domainname_ext\r\n(example: yahoo.com -> yahoo_com for db name)\r\n\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:\r\nhttp://[DOMAINIP]/MyAdmin/index.php\r\nLogin with your mysql username and password.\r\n\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.\r\n\r\nThanks for choosing our company.', 'Here is the information for your web hosting account.<br />\r\n<br />\r\n[ACCOUNTINFORMATION]<br />\r\n<br />\r\nFTP Username and password<br />\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]<br />\r\nFTP Password:[DOMAINPASSWORD]<br />\r\n<br />\r\nYou can log in by FTP using either the domain name or the IP address.<br />\r\n<br />\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.<br />\r\n<br />\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:<br />\r\n<br />\r\n[NAMESERVERS]<br />\r\n<br />\r\nFor those who wish to use CGI scripts, the Perl path is:<br />\r\n  /usr/bin/perl<br />\r\nIf you need to use sendmail, it can be found in:<br />\r\n  /usr/sbin/sendmail<br />\r\nYou absolute server path for cgi-bin directory is:<br />\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin<br />\r\nand for the browsable html dir:<br />\r\n  /home/virtual/[DOMAINNAME]/var/www/html<br />\r\n<br />\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.<br />\r\n<br />\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL<br />\r\n<br />\r\n  http://[DOMAINIP]/admin<br />\r\n<br />\r\nOnce your domain name resolves to the new server, you can use the URL<br />\r\n<br />\r\n  http://[DOMAINNAME]/admin<br />\r\n<br />\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin <br />\r\ndirectory located one level up the browsable html dir. <br />\r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.<br />\r\n<br />\r\nYou must back up one directory to see the /cgi-bin and the /html directory. <br />\r\n<br />\r\n/mainwebsite_html dir and /html dir <br />\r\n<br />\r\nTo access your MYSQL database you need the following information:<br />\r\nmysql host: localhost<br />\r\nmysql username: [DOMAINUSERNAME]<br />\r\nmysql password: must be set in your control panel<br />\r\nmysql database name: domainname_ext<br />\r\n(example: yahoo.com -> yahoo_com for db name)<br />\r\n<br />\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:<br />\r\nhttp://[DOMAINIP]/MyAdmin/index.php<br />\r\nLogin with your mysql username and password.<br />\r\n<br />\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.<br />\r\n<br />\r\nThanks for choosing our company.', '', 0, DEFAULT, DEFAULT);
INSERT INTO `package` VALUES (13, 'Free', 'Plan Features:<br>\r\n1Gig Bandwidth<br> \r\n75MB Diskspace<br>\r\n...', 5, '0', 1, '0', '0', '0', '0', 1, 1, 1, 1, 1, '0', 1, 'Here is the information for your web hosting account.\r\n\r\n[ACCOUNTINFORMATION]\r\n\r\nFTP Username and password\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]\r\nFTP Password:[DOMAINPASSWORD]\r\n\r\nYou can log in by FTP using either the domain name or the IP address.\r\n\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.\r\n\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:\r\n\r\n[NAMESERVERS]\r\n\r\nFor those who wish to use CGI scripts, the Perl path is:\r\n  /usr/bin/perl\r\nIf you need to use sendmail, it can be found in:\r\n  /usr/sbin/sendmail\r\nYou absolute server path for cgi-bin directory is:\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin\r\nand for the browsable html dir:\r\n  /home/virtual/[DOMAINNAME]/var/www/html\r\n\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.\r\n\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL\r\n\r\n  http://[DOMAINIP]/admin\r\n\r\nOnce your domain name resolves to the new server, you can use the URL\r\n\r\n  http://[DOMAINNAME]/admin\r\n\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin \r\ndirectory located one level up the browsable html dir. \r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.\r\n\r\nYou must back up one directory to see the /cgi-bin and the /html directory. \r\n\r\n/mainwebsite_html dir and /html dir \r\n\r\nTo access your MYSQL database you need the following information:\r\nmysql host: localhost\r\nmysql username: [DOMAINUSERNAME]\r\nmysql password: must be set in your control panel\r\nmysql database name: domainname_ext\r\n(example: yahoo.com -> yahoo_com for db name)\r\n\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:\r\nhttp://[DOMAINIP]/MyAdmin/index.php\r\nLogin with your mysql username and password.\r\n\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.\r\n\r\nThanks for choosing our company.', 'Here is the information for your web hosting account.<br />\r\n<br />\r\n[ACCOUNTINFORMATION]<br />\r\n<br />\r\nFTP Username and password<br />\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]<br />\r\nFTP Password:[DOMAINPASSWORD]<br />\r\n<br />\r\nYou can log in by FTP using either the domain name or the IP address.<br />\r\n<br />\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.<br />\r\n<br />\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:<br />\r\n<br />\r\n[NAMESERVERS]<br />\r\n<br />\r\nFor those who wish to use CGI scripts, the Perl path is:<br />\r\n  /usr/bin/perl<br />\r\nIf you need to use sendmail, it can be found in:<br />\r\n  /usr/sbin/sendmail<br />\r\nYou absolute server path for cgi-bin directory is:<br />\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin<br />\r\nand for the browsable html dir:<br />\r\n  /home/virtual/[DOMAINNAME]/var/www/html<br />\r\n<br />\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.<br />\r\n<br />\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL<br />\r\n<br />\r\n  http://[DOMAINIP]/admin<br />\r\n<br />\r\nOnce your domain name resolves to the new server, you can use the URL<br />\r\n<br />\r\n  http://[DOMAINNAME]/admin<br />\r\n<br />\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin <br />\r\ndirectory located one level up the browsable html dir. <br />\r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.<br />\r\n<br />\r\nYou must back up one directory to see the /cgi-bin and the /html directory. <br />\r\n<br />\r\n/mainwebsite_html dir and /html dir <br />\r\n<br />\r\nTo access your MYSQL database you need the following information:<br />\r\nmysql host: localhost<br />\r\nmysql username: [DOMAINUSERNAME]<br />\r\nmysql password: must be set in your control panel<br />\r\nmysql database name: domainname_ext<br />\r\n(example: yahoo.com -> yahoo_com for db name)<br />\r\n<br />\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:<br />\r\nhttp://[DOMAINIP]/MyAdmin/index.php<br />\r\nLogin with your mysql username and password.<br />\r\n<br />\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.<br />\r\n<br />\r\nThanks for choosing our company.', '', 0, DEFAULT, DEFAULT);

INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'admin_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'admin_view_services_status', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'admin_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'admin_view_services_status', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'admin_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'admin_view_services_status', 0);

INSERT INTO `promotion` VALUES (5, 'NORMAL', 'This client type is used for everyone signing up for our services through our advertised rates on our website, normal clients. (non promotions)', 1, 1, 'Here is the information for your web hosting account.\r\n\r\n[ACCOUNTINFORMATION]\r\n\r\nFTP Username and password\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]\r\nFTP Password:[DOMAINPASSWORD]\r\n\r\nYou can log in by FTP using either the domain name or the IP address.\r\n\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.\r\n\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:\r\n\r\n[NAMESERVERS]\r\n\r\nFor those who wish to use CGI scripts, the Perl path is:\r\n  /usr/bin/perl\r\nIf you need to use sendmail, it can be found in:\r\n  /usr/sbin/sendmail\r\nYou absolute server path for cgi-bin directory is:\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin\r\nand for the browsable html dir:\r\n  /home/virtual/[DOMAINNAME]/var/www/html\r\n\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.\r\n\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL\r\n\r\n  http://[DOMAINIP]/admin\r\n\r\nOnce your domain name resolves to the new server, you can use the URL\r\n\r\n  http://[DOMAINNAME]/admin\r\n\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin \r\ndirectory located one level up the browsable html dir. \r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.\r\n\r\nYou must back up one directory to see the /cgi-bin and the /html directory. \r\n\r\n/mainwebsite_html dir and /html dir \r\n\r\nTo access your MYSQL database you need the following information:\r\nmysql host: localhost\r\nmysql username: [DOMAINUSERNAME]\r\nmysql password: must be set in your control panel\r\nmysql database name: domainname_ext\r\n(example: yahoo.com -> yahoo_com for db name)\r\n\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:\r\nhttp://[DOMAINIP]/MyAdmin/index.php\r\nLogin with your mysql username and password.\r\n\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.\r\n\r\nThanks for choosing our company.', 'Here is the information for your web hosting account.<br />\r\n<br />\r\n[ACCOUNTINFORMATION]<br />\r\n<br />\r\nFTP Username and password<br />\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]<br />\r\nFTP Password:[DOMAINPASSWORD]<br />\r\n<br />\r\nYou can log in by FTP using either the domain name or the IP address.<br />\r\n<br />\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.<br />\r\n<br />\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:<br />\r\n<br />\r\n[NAMESERVERS]<br />\r\n<br />\r\nFor those who wish to use CGI scripts, the Perl path is:<br />\r\n  /usr/bin/perl<br />\r\nIf you need to use sendmail, it can be found in:<br />\r\n  /usr/sbin/sendmail<br />\r\nYou absolute server path for cgi-bin directory is:<br />\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin<br />\r\nand for the browsable html dir:<br />\r\n  /home/virtual/[DOMAINNAME]/var/www/html<br />\r\n<br />\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.<br />\r\n<br />\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL<br />\r\n<br />\r\n  http://[DOMAINIP]/admin<br />\r\n<br />\r\nOnce your domain name resolves to the new server, you can use the URL<br />\r\n<br />\r\n  http://[DOMAINNAME]/admin<br />\r\n<br />\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin <br />\r\ndirectory located one level up the browsable html dir. <br />\r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.<br />\r\n<br />\r\nYou must back up one directory to see the /cgi-bin and the /html directory. <br />\r\n<br />\r\n/mainwebsite_html dir and /html dir <br />\r\n<br />\r\nTo access your MYSQL database you need the following information:<br />\r\nmysql host: localhost<br />\r\nmysql username: [DOMAINUSERNAME]<br />\r\nmysql password: must be set in your control panel<br />\r\nmysql database name: domainname_ext<br />\r\n(example: yahoo.com -> yahoo_com for db name)<br />\r\n<br />\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:<br />\r\nhttp://[DOMAINIP]/MyAdmin/index.php<br />\r\nLogin with your mysql username and password.<br />\r\n<br />\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.<br />\r\n<br />\r\nThanks for choosing our company.', '', 1, 'Shared Web Hosting', 1, 0, 'yourdomain.com', 1, 0, 1, 1);

INSERT INTO `registrars` VALUES ('enom', 'us', 'a:2:{s:8:"us_nexus";a:3:{s:2:"ID";s:1:"9";s:11:"description";s:14:"Nexus Category";s:7:"options";a:5:{s:10:"US Citizen";a:2:{s:11:"description";s:36:"A natural person who is a US Citizen";s:5:"value";s:3:"C11";}s:18:"Permanent Resident";a:2:{s:11:"description";s:44:"A natural person who is a Permanent Resident";s:5:"value";s:3:"C12";}s:15:"Business Entity";a:2:{s:11:"description";s:100:"An entity or organization that is (i) incorporated within one of the fifty US states, the District o";s:5:"value";s:3:"C21";}s:14:"Foreign Entity";a:3:{s:11:"description";s:100:"A foreign organization that regularly engages in lawful activities (sales of goods or services or ot";s:5:"value";s:3:"C31";s:8:"requires";a:1:{i:0;s:2:"14";}}s:15:"US Based Office";a:3:{s:11:"description";s:100:"An organization has an office or other facility in the U.S., where CC equals to the county code of t";s:5:"value";s:3:"C32";s:8:"requires";a:1:{i:0;s:2:"14";}}}}s:10:"us_purpose";a:3:{s:2:"ID";s:2:"10";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";}}}}');
INSERT INTO `registrars` VALUES ('enom', 'ca', 'a:4:{s:15:"cira_legal_type";a:3:{s:2:"ID";s:1:"1";s:11:"description";s:32:"Legal type of registrant contact";s:7:"options";a:18:{s:11:"Corporation";a:3:{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:8:"requires";a:1:{i:0;s:2:"42";}}s:16:"Canadian Citizen";a:2:{s:11:"description";s:886:"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:17:"Canadian Resident";a:2:{s:11:"description";s:1536:"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 andegree 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: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:3:{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:"requires";a:1:{i:0;s:2:"42";}}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:3:{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:8:"requires";a:1:{i:0;s:2:"42";}}s:10:"Trade-mark";a:3:{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:8:"requires";a:1:{i:0;s:2:"41";}}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:2:{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: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:2:{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: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:182:"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:15:"cira-registrant";a:3:{s:2:"ID";s:2:"39";s:11:"description";s:51:"Registrant of domain (individual or company''s name)";s:7:"options";a:0:{}}s:17:"cira-trademark-no";a:3:{s:2:"ID";s:2:"41";s:11:"description";s:16:"Trademark Number";s:7:"options";a:0:{}}s:22:"cira-org-registered-in";a:3:{s:2:"ID";s:2:"42";s:11:"description";s:32:"Organization registered location";s:7:"options";a:0:{}}}');
INSERT INTO `registrars` VALUES ('enom', 'co.uk', 'a:3:{s:14:"registered_for";a:3:{s:2:"ID";s:2:"15";s:11:"description";s:95:"Company or person domain is registered for (this must be accurate and cannot be changed easily)";s:7:"options";a:0:{}}s:13:"uk_legal_type";a:3:{s:2:"ID";s:1:"2";s:11:"description";s:32:"Legal type of registrant contact";s:7:"options";a:16:{s:13:"UK Individual";a:2:{s:11:"description";s:33:"UK Individual (our default value)";s:5:"value";s:3:"IND";}s:37:"Non-UK Individual (representing self)";a:2:{s:11:"description";s:37:"Non-UK Individual (representing self)";s:5:"value";s:6:"Non-UK";}s:18:"UK Limited Company";a:3:{s:11:"description";s:18:"UK Limited Company";s:5:"value";s:3:"LTD";s:8:"requires";a:1:{i:0;s:1:"4";}}s:25:"UK Public Limited Company";a:3:{s:11:"description";s:25:"UK Public Limited Company";s:5:"value";s:3:"PLC";s:8:"requires";a:1:{i:0;s:1:"4";}}s:14:"UK Partnership";a:2:{s:11:"description";s:14:"UK Partnership";s:5:"value";s:4:"PTNR";}s:6:"UK LLP";a:3:{s:11:"description";s:32:"UK Limited Liability Partnership";s:5:"value";s:3:"LLP";s:8:"requires";a:1:{i:0;s:1:"4";}}s:14:"UK Sole Trader";a:2:{s:11:"description";s:14:"UK Sole Trader";s:5:"value";s:4:"STRA";}s:21:"UK Registered Charity";a:2:{s:11:"description";s:21:"UK Registered Charity";s:5:"value";s:5:"RCHAR";}s:42:"UK Industrial/Provident Registered Company";a:2:{s:11:"description";s:42:"UK Industrial/Provident Registered Company";s:5:"value";s:2:"ip";}s:9:"UK School";a:2:{s:11:"description";s:9:"UK School";s:5:"value";s:3:"SCH";}s:18:"UK Government Body";a:2:{s:11:"description";s:18:"UK Government Body";s:5:"value";s:3:"GOV";}s:31:"UK Corporation by Royal Charter";a:2:{s:11:"description";s:31:"UK Corporation by Royal Charter";s:5:"value";s:3:"CRC";}s:22:"UK Statutory Body FIND";a:2:{s:11:"description";s:22:"UK Statutory Body FIND";s:5:"value";s:4:"STAT";}s:17:"UK Entity (other)";a:2:{s:11:"description";s:17:"UK Entity (other)";s:5:"value";s:5:"OTHER";}s:18:"Non-UK Corporation";a:2:{s:11:"description";s:18:"Non-UK Corporation";s:5:"value";s:5:"FCORP";}s:27:"Non-UK Organization (other)";a:2:{s:11:"description";s:19:"Non-UK Organization";s:5:"value";s:6:"FOTHER";}}}s:12:"uk_reg_co_no";a:3:{s:2:"ID";s:1:"4";s:11:"description";s:32:"UK company identification number";s:7:"options";a:0:{}}}');
INSERT INTO `registrars` VALUES ('enom', 'org.uk', 'a:3:{s:14:"registered_for";a:3:{s:2:"ID";s:2:"16";s:11:"description";s:95:"Company or person domain is registered for (this must be accurate and cannot be changed easily)";s:7:"options";a:0:{}}s:13:"uk_legal_type";a:3:{s:2:"ID";s:1:"3";s:11:"description";s:32:"Legal type of registrant contact";s:7:"options";a:16:{s:13:"UK Individual";a:2:{s:11:"description";s:33:"UK Individual (our default value)";s:5:"value";s:3:"IND";}s:37:"Non-UK Individual (representing self)";a:2:{s:11:"description";s:37:"Non-UK Individual (representing self)";s:5:"value";s:6:"Non-UK";}s:18:"UK Limited Company";a:3:{s:11:"description";s:18:"UK Limited Company";s:5:"value";s:3:"LTD";s:8:"requires";a:1:{i:0;s:1:"5";}}s:25:"UK Public Limited Company";a:3:{s:11:"description";s:25:"UK Public Limited Company";s:5:"value";s:3:"PLC";s:8:"requires";a:1:{i:0;s:1:"5";}}s:14:"UK Partnership";a:2:{s:11:"description";s:14:"UK Partnership";s:5:"value";s:4:"PTNR";}s:6:"UK LLP";a:3:{s:11:"description";s:32:"UK Limited Liability Partnership";s:5:"value";s:3:"LLP";s:8:"requires";a:1:{i:0;s:1:"5";}}s:14:"UK Sole Trader";a:2:{s:11:"description";s:14:"UK Sole Trader";s:5:"value";s:4:"STRA";}s:21:"UK Registered Charity";a:2:{s:11:"description";s:21:"UK Registered Charity";s:5:"value";s:5:"RCHAR";}s:42:"UK Industrial/Provident Registered Company";a:2:{s:11:"description";s:42:"UK Industrial/Provident Registered Company";s:5:"value";s:2:"ip";}s:9:"UK School";a:2:{s:11:"description";s:9:"UK School";s:5:"value";s:3:"SCH";}s:18:"UK Government Body";a:2:{s:11:"description";s:18:"UK Government Body";s:5:"value";s:3:"GOV";}s:31:"UK Corporation by Royal Charter";a:2:{s:11:"description";s:31:"UK Corporation by Royal Charter";s:5:"value";s:3:"CRC";}s:22:"UK Statutory Body FIND";a:2:{s:11:"description";s:22:"UK Statutory Body FIND";s:5:"value";s:4:"STAT";}s:17:"UK Entity (other)";a:2:{s:11:"description";s:17:"UK Entity (other)";s:5:"value";s:5:"OTHER";}s:18:"Non-UK Corporation";a:2:{s:11:"description";s:18:"Non-UK Corporation";s:5:"value";s:5:"FCORP";}s:27:"Non-UK Organization (other)";a:2:{s:11:"description";s:19:"Non-UK Organization";s:5:"value";s:6:"FOTHER";}}}s:12:"uk_reg_co_no";a:3:{s:2:"ID";s:1:"5";s:11:"description";s:32:"UK company identification number";s:7:"options";a:0:{}}}');
INSERT INTO `registrars` VALUES ('enom', 'de', 'a:1:{s:14:"confirmaddress";a:3:{s:2:"ID";s:2:"26";s:11:"description";s:23:"Confirmation of address";s:7:"options";a:1:{s:47:"I confirm the below Admin contact is in Germany";a:2:{s:11:"description";s:68:"I confirm the Administrative address below is a valid German address";s:5:"value";s:2:"DE";}}}}');
INSERT INTO `registrars` VALUES ('enom', 'kids.us', 'a:2:{s:8:"us_nexus";a:3:{s:2:"ID";s:2:"18";s:11:"description";s:14:"Nexus Category";s:7:"options";a:5:{s:10:"US Citizen";a:2:{s:11:"description";s:36:"A natural person who is a US Citizen";s:5:"value";s:3:"C11";}s:18:"Permanent Resident";a:2:{s:11:"description";s:44:"A natural person who is a Permanent Resident";s:5:"value";s:3:"C12";}s:15:"Business Entity";a:2:{s:11:"description";s:100:"An entity or organization that is (i) incorporated within one of the fifty US states, the District o";s:5:"value";s:3:"C21";}s:14:"Foreign Entity";a:3:{s:11:"description";s:100:"A foreign organization that regularly engages in lawful activities (sales of goods or services or ot";s:5:"value";s:3:"C31";s:8:"requires";a:1:{i:0;s:2:"19";}}s:15:"US Based Office";a:3:{s:11:"description";s:100:"An organization has an office or other facility in the U.S., where CC equals to the county code of t";s:5:"value";s:3:"C32";s:8:"requires";a:1:{i:0;s:2:"19";}}}}s:10:"us_purpose";a:3:{s:2:"ID";s:2:"20";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";}}}}');
INSERT INTO `registrars` VALUES ('directi', 'us', 'a:2:{s:8:"us_nexus";a:3:{s:2:"ID";s:1:"9";s:11:"description";s:14:"Nexus Category";s:7:"options";a:5:{s:10:"US Citizen";a:2:{s:11:"description";s:36:"A natural person who is a US Citizen";s:5:"value";s:3:"C11";}s:18:"Permanent Resident";a:2:{s:11:"description";s:44:"A natural person who is a Permanent Resident";s:5:"value";s:3:"C12";}s:15:"Business Entity";a:2:{s:11:"description";s:100:"An entity or organization that is (i) incorporated within one of the fifty US states, the District o";s:5:"value";s:3:"C21";}s:14:"Foreign Entity";a:3:{s:11:"description";s:100:"A foreign organization that regularly engages in lawful activities (sales of goods or services or ot";s:5:"value";s:3:"C31";s:8:"requires";a:1:{i:0;s:2:"14";}}s:15:"US Based Office";a:3:{s:11:"description";s:100:"An organization has an office or other facility in the U.S., where CC equals to the county code of t";s:5:"value";s:3:"C32";s:8:"requires";a:1:{i:0;s:2:"14";}}}}s:10:"us_purpose";a:3:{s:2:"ID";s:2:"10";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";}}}}');
INSERT INTO `registrars` VALUES ('opensrs', 'us', 'a:2:{s:8:"us_nexus";a:3:{s:2:"ID";s:1:"9";s:11:"description";s:14:"Nexus Category";s:7:"options";a:5:{s:10:"US Citizen";a:2:{s:11:"description";s:36:"A natural person who is a US Citizen";s:5:"value";s:3:"C11";}s:18:"Permanent Resident";a:2:{s:11:"description";s:44:"A natural person who is a Permanent Resident";s:5:"value";s:3:"C12";}s:15:"Business Entity";a:2:{s:11:"description";s:100:"An entity or organization that is (i) incorporated within one of the fifty US states, the District o";s:5:"value";s:3:"C21";}s:14:"Foreign Entity";a:3:{s:11:"description";s:100:"A foreign organization that regularly engages in lawful activities (sales of goods or services or ot";s:5:"value";s:3:"C31";s:8:"requires";a:1:{i:0;s:2:"14";}}s:15:"US Based Office";a:3:{s:11:"description";s:100:"An organization has an office or other facility in the U.S., where CC equals to the county code of t";s:5:"value";s:3:"C32";s:8:"requires";a:1:{i:0;s:2:"14";}}}}s:10:"us_purpose";a:3:{s:2:"ID";s:2:"10";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";}}}}');
INSERT INTO `registrars` VALUES ('opensrs', 'ca', 'a:2:{s:15:"cira_legal_type";a:3:{s:2:"ID";i:1;s:11:"description";s:32:"Legal type of registrant contact";s:7:"options";a:18:{s:11:"Corporation";a:3:{s:11:"description";s:567:"A corporation under the laws of Canada or any province or territory of Canada, Charities, Cooperative, Council. 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:8:"requires";a:1:{i:0;i:42;}}s:16:"Canadian Citizen";a:2:{s:11:"description";s:883:"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.  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:17:"Canadian Resident";a:2:{s:11:"description";s:1532:"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. 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 andegree 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:17:"Government Entity";a:2:{s:11:"description";s:728:"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.  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:973:"(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 (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. 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:3:{s:11:"description";s:1052:"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: (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 (ii) At least 80% of whose directors, officers, employees, managers, administrators or other representatives are ordinarily resident in Canada. 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:"requires";a:1:{i:0;i:42;}}s:8:"Hospital";a:2:{s:11:"description";s:561:"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\r\nRequirements: 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:3:{s:11:"description";s:662:"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.\r\nRequirements: 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:8:"requires";a:1:{i:0;i:42;}}s:10:"Trade-mark";a:3:{s:11:"description";s:890:"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.\r\nThis 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.)\r\nThe 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:8:"requires";a:1:{i:0;i:41;}}s:11:"Trade Union";a:2:{s:11:"description";s:522:"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.\r\nRequirements: 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:478:"A political party registered under a relevant electoral law of Canada or any province or territory of Canada\r\nRequirements: 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:621:"An institution, whether or not incorporated, that:\r\n(i) is located in Canada; and\r\n(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.\r\nRequirements: 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:756:"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.\r\nRequirements: 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:2:{s:11:"description";s:1327:"Any individual belonging to any Inuit, First Nation, Metis or other people indigenous to Canada.\r\nRequirements: 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.\r\nThe 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.)\r\nFull legal names of individuals may only consist of alphabetic characters and the special characters: single quote mark(''''), hyphen(-), period(.).\r\nGroups: Any Inuit, First Nation, Metis or other people indigenous to Canada, and any collectivity of such Aboriginal peoples.\r\nRequirements: 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:11:"Indian Band";a:2:{s:11:"description";s:268:"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;\r\nRequirements: 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:2:{s:11:"description";s:857:"An executor, administrator or other legal representative of a Person listed as a Canadian Citizen or Permanent Resident of Canada.\r\nNote: 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.\r\nRequirements: 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:13:"Official Mark";a:2:{s:11:"description";s:1234:"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.\r\nNotes: 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)\r\nRequirements: 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:182:"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-isa-trademark";a:3:{s:2:"ID";i:2;s:11:"description";s:14:"Is a trademark";s:7:"options";a:2:{s:3:"Yes";a:2:{s:11:"description";s:3:"Yes";s:5:"value";i:1;}s:2:"No";a:2:{s:11:"description";s:2:"No";s:5:"value";i:0;}}}}');
INSERT INTO `registrars` VALUES ('planetdomain', 'com.au', 'a:8:{s:11:"au_org_type";a:3:{s:2:"ID";i:201;s:11:"description";s:28:"Registrant Organization Type";s:7:"options";a:10:{s:35:"Australian Incorporated Association";a:3:{s:11:"description";s:51:"Australian Incorporated Association (default value)";s:5:"value";s:8:"INCASSOC";s:8:"requires";a:1:{i:0;i:202;}}s:29:"Australian Registered Company";a:3:{s:11:"description";s:29:"Australian Registered Company";s:5:"value";s:7:"COMPANY";s:8:"requires";a:1:{i:0;i:203;}}s:41:"Trading under an Australian Business Name";a:3:{s:11:"description";s:41:"Trading under an Australian Business Name";s:5:"value";s:7:"TRADING";s:8:"requires";a:1:{i:0;i:204;}}s:22:"Australian Partnership";a:3:{s:11:"description";s:22:"Australian Partnership";s:5:"value";s:11:"PARTNERSHIP";s:8:"requires";a:1:{i:0;i:205;}}s:22:"Australian Sole Trader";a:3:{s:11:"description";s:22:"Australian Sole Trader";s:5:"value";s:10:"SOLETRADER";s:8:"requires";a:1:{i:0;i:205;}}s:46:"Foreign Company Licensed to trade in Australia";a:3:{s:11:"description";s:46:"Foreign Company Licensed to trade in Australia";s:5:"value";s:7:"FOREIGN";s:8:"requires";a:1:{i:0;i:204;}}s:37:"Australian Registered Trademark owner";a:3:{s:11:"description";s:37:"Australian Registered Trademark owner";s:5:"value";s:10:"TMARKOWNER";s:8:"requires";a:3:{i:0;i:206;i:1;i:207;i:2;i:203;}}s:41:"Australian Registered Trademark applicant";a:3:{s:11:"description";s:41:"Australian Registered Trademark applicant";s:5:"value";s:11:"TMARKAPPLIC";s:8:"requires";a:3:{i:0;i:206;i:1;i:207;i:2;i:203;}}s:36:"Australian Commercial Statutory Body";a:3:{s:11:"description";s:36:"Australian Commercial Statutory Body";s:5:"value";s:9:"STATUTORY";s:8:"requires";a:1:{i:0;i:208;}}s:5:"Other";a:3:{s:11:"description";s:5:"Other";s:5:"value";s:5:"OTHER";s:8:"requires";a:1:{i:0;i:205;}}}}s:12:"au_assoc_num";a:3:{s:2:"ID";i:202;s:11:"description";s:18:"Association number";s:7:"options";a:0:{}}s:3:"acn";a:3:{s:2:"ID";i:203;s:11:"description";s:25:"Australian Company Number";s:7:"options";a:0:{}}s:3:"rbn";a:3:{s:2:"ID";i:204;s:11:"description";s:26:"Registered Business Number";s:7:"options";a:0:{}}s:3:"abn";a:3:{s:2:"ID";i:205;s:11:"description";s:26:"Australian Business Number";s:7:"options";a:0:{}}s:17:"au_trademark_name";a:3:{s:2:"ID";i:206;s:11:"description";s:14:"Trademark Name";s:7:"options";a:0:{}}s:19:"au_trademark_number";a:3:{s:2:"ID";i:207;s:11:"description";s:16:"Trademark Number";s:7:"options";a:0:{}}s:17:"au_parliament_act";a:3:{s:2:"ID";i:208;s:11:"description";s:14:"Parliament Act";s:7:"options";a:0:{}}}');
INSERT INTO `registrars` VALUES ('planetdomain', 'org.au', 'a:5:{s:11:"au_org_type";a:3:{s:2:"ID";i:201;s:11:"description";s:28:"Registrant Organization Type";s:7:"options";a:7:{s:35:"Australian Incorporated Association";a:3:{s:11:"description";s:51:"Australian Incorporated Association (default value)";s:5:"value";s:8:"INCASSOC";s:8:"requires";a:1:{i:0;i:202;}}s:45:"Australian Sporting or Personal Interest Club";a:3:{s:11:"description";s:45:"Australian Sporting or Personal Interest Club";s:5:"value";s:4:"CLUB";s:8:"requires";a:1:{i:0;i:205;}}s:29:"Australian Registered Company";a:3:{s:11:"description";s:29:"Australian Registered Company";s:5:"value";s:7:"COMPANY";s:8:"requires";a:1:{i:0;i:203;}}s:41:"Trading under an Australian Business Name";a:3:{s:11:"description";s:41:"Trading under an Australian Business Name";s:5:"value";s:7:"TRADING";s:8:"requires";a:1:{i:0;i:204;}}s:30:"Charity operating in Australia";a:3:{s:11:"description";s:30:"Charity operating in Australia";s:5:"value";s:7:"CHARITY";s:8:"requires";a:1:{i:0;i:205;}}s:46:"Non-Profit Organisation Operating in Australia";a:3:{s:11:"description";s:47:"Non-Profit Organisation Operating in Australia ";s:5:"value";s:9:"NONPROFIT";s:8:"requires";a:1:{i:0;i:205;}}s:5:"Other";a:3:{s:11:"description";s:5:"Other";s:5:"value";s:5:"OTHER";s:8:"requires";a:1:{i:0;i:205;}}}}s:12:"au_assoc_num";a:3:{s:2:"ID";i:202;s:11:"description";s:18:"Association number";s:7:"options";a:0:{}}s:3:"acn";a:3:{s:2:"ID";i:203;s:11:"description";s:25:"Australian Company Number";s:7:"options";a:0:{}}s:3:"rbn";a:3:{s:2:"ID";i:204;s:11:"description";s:26:"Registered Business Number";s:7:"options";a:0:{}}s:3:"abn";a:3:{s:2:"ID";i:205;s:11:"description";s:26:"Australian Business Number";s:7:"options";a:0:{}}}');
INSERT INTO `registrars` VALUES ('planetdomain', 'net.au', 'a:8:{s:11:"au_org_type";a:3:{s:2:"ID";i:201;s:11:"description";s:28:"Registrant Organization Type";s:7:"options";a:10:{s:35:"Australian Incorporated Association";a:3:{s:11:"description";s:51:"Australian Incorporated Association (default value)";s:5:"value";s:8:"INCASSOC";s:8:"requires";a:1:{i:0;i:202;}}s:29:"Australian Registered Company";a:3:{s:11:"description";s:29:"Australian Registered Company";s:5:"value";s:7:"COMPANY";s:8:"requires";a:1:{i:0;i:203;}}s:41:"Trading under an Australian Business Name";a:3:{s:11:"description";s:41:"Trading under an Australian Business Name";s:5:"value";s:7:"TRADING";s:8:"requires";a:1:{i:0;i:204;}}s:22:"Australian Partnership";a:3:{s:11:"description";s:22:"Australian Partnership";s:5:"value";s:11:"PARTNERSHIP";s:8:"requires";a:1:{i:0;i:205;}}s:22:"Australian Sole Trader";a:3:{s:11:"description";s:22:"Australian Sole Trader";s:5:"value";s:10:"SOLETRADER";s:8:"requires";a:1:{i:0;i:205;}}s:46:"Foreign Company Licensed to trade in Australia";a:3:{s:11:"description";s:46:"Foreign Company Licensed to trade in Australia";s:5:"value";s:7:"FOREIGN";s:8:"requires";a:1:{i:0;i:204;}}s:37:"Australian Registered Trademark owner";a:3:{s:11:"description";s:37:"Australian Registered Trademark owner";s:5:"value";s:10:"TMARKOWNER";s:8:"requires";a:3:{i:0;i:206;i:1;i:207;i:2;i:203;}}s:41:"Australian Registered Trademark applicant";a:3:{s:11:"description";s:41:"Australian Registered Trademark applicant";s:5:"value";s:11:"TMARKAPPLIC";s:8:"requires";a:3:{i:0;i:206;i:1;i:207;i:2;i:203;}}s:36:"Australian Commercial Statutory Body";a:3:{s:11:"description";s:36:"Australian Commercial Statutory Body";s:5:"value";s:9:"STATUTORY";s:8:"requires";a:1:{i:0;i:208;}}s:5:"Other";a:3:{s:11:"description";s:5:"Other";s:5:"value";s:5:"OTHER";s:8:"requires";a:1:{i:0;i:205;}}}}s:12:"au_assoc_num";a:3:{s:2:"ID";i:202;s:11:"description";s:18:"Association number";s:7:"options";a:0:{}}s:3:"acn";a:3:{s:2:"ID";i:203;s:11:"description";s:25:"Australian Company Number";s:7:"options";a:0:{}}s:3:"rbn";a:3:{s:2:"ID";i:204;s:11:"description";s:26:"Registered Business Number";s:7:"options";a:0:{}}s:3:"abn";a:3:{s:2:"ID";i:205;s:11:"description";s:26:"Australian Business Number";s:7:"options";a:0:{}}s:17:"au_trademark_name";a:3:{s:2:"ID";i:206;s:11:"description";s:14:"Trademark Name";s:7:"options";a:0:{}}s:19:"au_trademark_number";a:3:{s:2:"ID";i:207;s:11:"description";s:16:"Trademark Number";s:7:"options";a:0:{}}s:17:"au_parliament_act";a:3:{s:2:"ID";i:208;s:11:"description";s:14:"Parliament Act";s:7:"options";a:0:{}}}');
INSERT INTO `registrars` VALUES ('planetdomain', 'asn.au', 'a:4:{s:11:"au_org_type";a:3:{s:2:"ID";i:201;s:11:"description";s:28:"Registrant Organization Type";s:7:"options";a:6:{s:35:"Australian Incorporated Association";a:3:{s:11:"description";s:51:"Australian Incorporated Association (default value)";s:5:"value";s:8:"INCASSOC";s:8:"requires";a:1:{i:0;i:202;}}s:26:"Australian Political Party";a:2:{s:11:"description";s:26:"Australian Political Party";s:5:"value";s:7:"POLITIC";}s:22:"Australian Trade Union";a:3:{s:11:"description";s:22:"Australian Trade Union";s:5:"value";s:5:"UNION";s:8:"requires";a:1:{i:0;i:210;}}s:24:"Australian Industry Body";a:3:{s:11:"description";s:24:"Australian Industry Body";s:5:"value";s:8:"INDUSTRY";s:8:"requires";a:1:{i:0;i:210;}}s:45:"Australian Sporting or Personal Interest Club";a:3:{s:11:"description";s:45:"Australian Sporting or Personal Interest Club";s:5:"value";s:4:"CLUB";s:8:"requires";a:1:{i:0;i:205;}}s:5:"Other";a:3:{s:11:"description";s:5:"Other";s:5:"value";s:5:"OTHER";s:8:"requires";a:1:{i:0;i:205;}}}}s:12:"au_assoc_num";a:3:{s:2:"ID";i:202;s:11:"description";s:18:"Association number";s:7:"options";a:0:{}}s:3:"abn";a:3:{s:2:"ID";i:205;s:11:"description";s:26:"Australian Business Number";s:7:"options";a:0:{}}s:13:"au_org_number";a:3:{s:2:"ID";i:210;s:11:"description";s:19:"Organisation Number";s:7:"options";a:0:{}}}');

INSERT INTO `report` VALUES ('Monthly_Signup_Rate_And_Percentage-Account_&_packages.php', '1', '0', '1');
INSERT INTO `report` VALUES ('Support_Tickets_Opened-Support.php', '1', '0', '1');
INSERT INTO `report` VALUES ('Support_Tickets_Closed-Support.php', '1', '0', '1');

INSERT INTO `server` VALUES (1, 'server1', 'server1.yourserver.com', '00.00.00.00', 1, '', '0000-00-00 00:00:00', 0, '', 0);

INSERT INTO `setting` VALUES (NULL, 'ClientExec Version', '', '', 'Version of ClientExec', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'Default Country Currency2', '', '', 'Default Currency Used In ClientExec.', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'Default Country Name', '', '', '', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'Default Gateway', 'paypal', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'Default Currency', 'USD', '', 'Select the default currency you would like ClientExec to use for your customers. This will also be the currency used during customer signup', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'Integrate Control Panel', '1', '', 'Select YES if you want to integrate with a specific hosting control panel. NOTE: You must provide the required information for the control panel you select.', 9, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'Cpanel Port', '2082', '', 'List the port number used in your installation of the Cpanel Control Panel. NOTE: This is usually set to 2082 as the default setting', 9, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'Show All Settings', '0', '', 'This setting allows you to view all settings for a given type at once.', 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'Document Root', '', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'Default Country Currency', '', '', 'Default Currency Used In ClientExec.', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'LastDateGenerateInvoices', '', '', '', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'LastDateRunBatch', '', '', '', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'license', '', '', '', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (NULL, 'Email Piping In Use', 0, '', 'If E-mail piping is in use set this to true so the reply above this line can be added to support ticket E-mails.', 8, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `setting` VALUES (NULL, 'E-mail Piping Last Five', '', '', 'Stores a serialized array of the last five E-mails addresses that have piped a reply into the system and the time that they were processed.', 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `setting` VALUES (NULL, 'Domains Taxable', '0', NULL , 'Charge tax for domain fees', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `setting` VALUES (NULL, 'Default TLD', 'com', NULL , 'Select the TLD that should be preselected in the sign up form.', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1);

INSERT INTO `tld` (`id`, `name`, `period`, `price`, `renewal`, `transferprice`, `package`, `billingcycle`, `plugin`) VALUES (1, 'net', 1, '9.95', '9.95', '0', 0, 0, '');
INSERT INTO `tld` (`id`, `name`, `period`, `price`, `renewal`, `transferprice`, `package`, `billingcycle`, `plugin`) VALUES (2, 'com', 1, '9.95', '9.95', '0', 0, 0, '');
INSERT INTO `tld` (`id`, `name`, `period`, `price`, `renewal`, `transferprice`, `package`, `billingcycle`, `plugin`) VALUES (3, 'org', 1, '9.95', '9.95', '0', 0, 0, '');

INSERT INTO `users` VALUES (100, 0, '2checkout', 0, 2, '43e9a4ab75570f5b', '0000-00-00', 'admin@domain.com\r\nReinventing Support!', 'admin@domain.com<br />\r\nReinventing Support!', '2003-02-14 22:29:45', 0, 1, 1, 'USD', '', 0, '0', '0', '', '', '', 0, 0, 0, 1, 'Admin', 'User', 'admin@domain.com', '', '', '', 0, 0);
