mysql.sql

不错的东西

  `bandwidth` int(11) NOT NULL default '0',
  `theme` tinyint(4) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `invisible` enum('0','1') NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `paypal_ipn` (
  `id` int(11) NOT NULL default '0',
  `invoice_id` int(11) unsigned zerofill NOT NULL auto_increment,
  `date` datetime default NULL,
  `item_name` varchar(130) NOT NULL default 'joi',
  `receiver_email` varchar(125) default NULL,
  `item_number` varchar(130) NOT NULL default '0',
  `quantity` smallint(6) NOT NULL default '0',
  `invoice` varchar(25) NOT NULL default '0',
  `custom` varchar(60) default NULL,
  `payment_status` set('Completed','Pending','Failed','Denied') NOT NULL default 'Failed',
  `pending_reason` set('echeck','intl','verify','address','upgrade','unilateral','other') NOT NULL default 'other',
  `payment_gross` float NOT NULL default '0',
  `payment_fee` float NOT NULL default '0',
  `payment_type` set('echeck','instant') NOT NULL default 'instant',
  `payment_date` varchar(50) NOT NULL default '0',
  `txn_id` varchar(20) NOT NULL default '0',
  `payer_email` varchar(125) default NULL,
  `payer_status` set('verified','unverified','intl_verified') NOT NULL default 'unverified',
  `txn_type` set('web_accept','cart','send_money','subscr_signup','subscr_cancel','subscr_failed','subscr_payment','subscr_eot') NOT NULL default 'subscr_payment',
  `first_name` varchar(35) default NULL,
  `last_name` varchar(60) default NULL,
  `address_city` varchar(60) default NULL,
  `address_street` varchar(60) default NULL,
  `address_state` varchar(60) default NULL,
  `address_zip` varchar(15) default NULL,
  `address_country` varchar(60) default NULL,
  `address_status` set('confirmed','unconfirmed') NOT NULL default 'unconfirmed',
  `subscr_date` varchar(50) NOT NULL default '0',
  `period1` varchar(20) NOT NULL default 'UNK',
  `period2` varchar(20) NOT NULL default 'UNK',
  `period3` varchar(20) NOT NULL default 'UNK',
  `amount1` float NOT NULL default '0',
  `amount2` float NOT NULL default '0',
  `amount3` float NOT NULL default '0',
  `recurring` tinyint(4) NOT NULL default '1',
  `reattempt` tinyint(4) NOT NULL default '0',
  `retry_at` varchar(50) default NULL,
  `recur_times` smallint(6) NOT NULL default '0',
  `subscr_id` varchar(20) default NULL,
  `paypal_verified` set('VERIFIED','INVALID') NOT NULL default 'INVALID',
  `verify_sign` varchar(125) default NULL,
  PRIMARY KEY  (`invoice_id`),
  KEY `txn_type` (`txn_type`),
  KEY `payment_status` (`payment_status`),
  KEY `pending_reason` (`pending_reason`),
  KEY `payer_status` (`payer_status`),
  KEY `payment_type` (`payment_type`),
  KEY `retry_at` (`retry_at`),
  KEY `receiver_email` (`receiver_email`),
  KEY `date` (`date`)
) TYPE=MyISAM COMMENT='Recieve posts FROM paypal servers' AUTO_INCREMENT=1 ;

CREATE TABLE `servers` (
  `id` int(11) NOT NULL auto_increment,
  `hostname` varchar(255) NOT NULL default '',
  `inet` varchar(11) NOT NULL default '',
  `username` varchar(8) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `ns1` varchar(255) NOT NULL default '',
  `ns2` varchar(255) NOT NULL default '',
  `access_key` blob NOT NULL,
  `usessl` int(11) NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `services` (
  `id` int(11) NOT NULL auto_increment,
  `service` varchar(255) NOT NULL default '',
  `port` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `settings` (
  `email` varchar(255) NOT NULL default '',
  `email_paypal` varchar(255) NOT NULL default '',
  `company` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `http_path` varchar(255) NOT NULL default '',
  `header_path` varchar(255) NOT NULL default '',
  `footer_path` varchar(255) NOT NULL default '',
  `layout_merge` int(1) NOT NULL default '0',
  `req_order_aprv` int(1) NOT NULL default '0',
  `allow_same_ip_order` int(1) NOT NULL default '1',
  `subdomain_only` int(1) NOT NULL default '0',
  `auto_aprv_free` int(1) NOT NULL default '0',
  `paypal_return_url` varchar(255) NOT NULL default '',
  `check_to` varchar(255) NOT NULL default '',
  `check_address` varchar(255) NOT NULL default '',
  `check_city` varchar(255) NOT NULL default '',
  `check_state` int(1) NOT NULL default '0',
  `check_zip` int(5) NOT NULL default '0',
  `check_country` int(1) NOT NULL default '0',
  `use_localhost` enum('0','1') NOT NULL default '0',
  `waiting_list` int(11) NOT NULL default '0'
) TYPE=MyISAM ;

CREATE TABLE `status` (
  `id` int(11) NOT NULL auto_increment,
  `status_array` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `subdomains` (
  `id` int(11) NOT NULL auto_increment,
  `sid` int(11) NOT NULL default '0',
  `domain` varchar(255) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `text` (
  `terms` longtext NOT NULL,
  `signup_email` longtext NOT NULL,
  `cancel_email` longtext NOT NULL,
  `verify_email` longtext NOT NULL,
  `approval_email` longtext NOT NULL,
  `payment_failure_email` longtext NOT NULL,
  `payment_success_email` longtext NOT NULL,
  `payment_endterm_email` longtext NOT NULL
) TYPE=MyISAM ;

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL default '0',
  `tid` int(11) NOT NULL auto_increment,
  `level` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `hostname` int(11) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `subject` text NOT NULL,
  KEY `tid` (`tid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

INSERT INTO `services` (service, port) VALUES ('HTTP', '80'), ('FTP', '21'), ('MySQL', '3306'), ('SMTP', '25'), ('POP3', '110'), ('DNS', '53');
INSERT INTO `text` (terms, signup_email, cancel_email, verify_email,approval_email,payment_failure_email,payment_success_email,payment_endterm_email) VALUES ( '<p align=\\\\\\"center\\\\\\"><b>Terms of Service</b></p>\r\n\r\nWelcome to [company]! All we ask in return is that you follow a few simple \r\nrules. So \r\n    please be sure you have read, and understood, these Terms and Conditions. \r\n    Members who do not follow rules and regulations could find their entire web \r\n    site removed and/or deleted, possibly without prior notice. The \r\n   interpretation of these guidelines is at the sole discretion of [company]:\r\n    <br>\r\n    <br>\r\n\r\n    <ol style=\\\\\\"MARGIN: 0px 27px; LIST-STYLE-TYPE: decimal\\\\\\">\r\n      <li>[company] is capable of giving away 100MB of free web space thanks to \r\n      the sponsorship of our advertisers. In return, each page that you create \r\n      will have an advertising banner automatically inserted into it (one banner \r\n      per page at the top of the viewable browser window). You may not remove, \r\n      resize so as to render invisible or unreadable, or otherwise block any of \r\n      the banners that [company] inserts onto your web pages; Our banner is \r\n      depicted below:\r\n\r\n      </li>\r\n      <li>You must provide a valid email address; </li>\r\n      <li>[company] is not responsible for the content of any personal home \r\n      page, nor do the opinions or ideas expressed in user-generated web pages \r\n      necessarily reflect those of [company]. The contents of user-generated \r\n      web pages are not reviewed or censored in any way before they appear on \r\n      [company];</li>\r\n      <li>You may not set up a \\"gateway\\" site on the [company] server. A \r\n      \\"gateway\\" site is one which serves only as an entrance to the actual site \r\n      located on a non-[company] server;</li>\r\n\r\n      <li>Your page should be in English;</li>\r\n      <li>Your page should be active - that is, it is either receiving \\\\\\\'\'hits\\\\\\\'\' or \r\n      is being updated/posted to. Sites that either receive no hits or are not \r\n      updated over a period of 60 days will be considered \\\\\\\'\'inactive\\\\\\\'\' and may be \r\n      removed by [company] to make room for other users;</li>\r\n      <li>You may not use your web space to provide material, or links to \r\n      material, that is grossly offensive to the Web community. This includes:\r\n      <ul style=\\\\\\"MARGIN: 0px 27px; LIST-STYLE-TYPE: lower-alpha\\\\\\">\r\n        <li>Blatant expressions of bigotry, racism, hatred, or profanity;</li>\r\n        <li>Promotion or display of instructional information supporting illegal \r\n        activities; this includes, but is not limited to, instructions for the \r\n        building or use of weapons, propagation of \\"spam\\" email and/or computer \r\n        viruses, or any material that infringes the intellectual property rights \r\n        of third parties;</li>\r\n\r\n        <li>Promotion of physical harm or injury against any group or \r\n        individual;</li>\r\n      </ul>\r\n      </li>\r\n      <li>You may not password protect any link provided on any of your pages \r\n      located on the [company] server;</li>\r\n      <li>Your Web Pages may not contain, nor contain links to, any of the \r\n      following:\r\n      <ul style=\\\\\\"MARGIN: 0px 27px; LIST-STYLE-TYPE: lower-alpha\\\\\\">\r\n        <li>Child pornography, obscene material, bestiality and pictures that \r\n        you don\\\\\\\'\'t have the right to publish.</li>\r\n        <li>Hate propaganda;</li>\r\n\r\n        <li>Anything illegal including, but not limited to, illegal software, \r\n        warez or hacked software, serial numbers, mail fraud, or pyramid \r\n        schemes;</li>\r\n        <li>Material insulting, or that could be considered defamatory or \r\n        libelous, to other persons, institutions or companies;</li>\r\n        <li>Material that exploits children;</li>\r\n        <li>Material which attempts to collect personal information about users;</li>\r\n        <li>Materials infringing the intellectual property rights of third \r\n        parties (including, but not limited to, trademarks, domain names, \r\n        personality rights, names of individuals, publicity rights, logos, \r\n        graphics, designs, films, and music), those which allow the \r\n        circumvention of revenue rightfully due to a manufacturer for the sale \r\n        of a product or the disabling of installed copy protected devices, and \r\n        all other forms of cracker utilities, are strictly forbidden;</li>\r\n      </ul>\r\n\r\n      </li>\r\n      <li>You may not use your web space for \\\\\\\'\'data warehousing\\\\\\\'\' ; that is, using \r\n      our space as storage for large files which are only linked from other \r\n      sites;\r\n      </li>\r\n      <li>You may not use unsolicited email to promote your site; </li>\r\n      <li>[company] reserves the right to block or delete any site due to \r\n      inappropriate behavior by the webmaster towards [company], its staff or \r\n      its users, which has been validated on public or private forums; </li>\r\n      <li>You may not copy or reproduce any page, image or other content without \r\n      the express prior consent of the original copyright owner of that content;</li>\r\n      <li>By joining [company] you automatically receive our [company] \r\n      E-News newsletter and occasional special promotions. You can unsubscribe \r\n      from the newsletter by following the given instructions within the \r\n      newsletter.</li>\r\n\r\n      <li>By submitting a web page to [company] or any other web page hosting \r\n      service on The [company] Network, you grant [company] a royalty-free, \r\n      nonexclusive, worldwide, unrestricted license to use, copy, transmit, \r\n      publicly display, publicly perform, create compilations including, and \r\n      distribute such web page, and any associated Content, for the limited \r\n      purposes of publishing and promoting the user\\\\\\\'\'s web page in connection \r\n      with the particular service with which the user has chosen to have the web \r\n      page hosted and for publishing and promoting such web page elsewhere \r\n      within the [company] Network. Such license shall apply with respect to \r\n      any form, media, or technology now known or later developed. This term \r\n      will extend only for the duration of the user\\\\\\\'\'s membership with the \r\n      particular [company] service. In the event that such membership is \r\n      terminated, [company] will relinquish all rights to the user\\\\\\\'\'s Content \r\n      following the duration of any applicable promotional activities ongoing at \r\n      the time the membership is terminated.</li>\r\n      <li>If you are 18 years of age or under you may not become a member of \r\n      [company]! The protection of children\\\\\\\'\'s online privacy is very important \r\n      to The [company] Network. For that reason, it is our policy not to \r\n      collect or maintain information at our web sites from those we actually \r\n      know are under 13 and no part of our web sites is structured to attract \r\n      anyone under 13.</li>\r\n    </ol>\r\n    <p style=\\\\\\"FONT-WEIGHT: bold\\\\\\">LEGAL TERMS</p>\r\n    <p style=\\\\\\"FONT-WEIGHT: normal\\\\\\">You, as the author of your pages, take full \r\n    responsibility for its contents. As the author you state your page contains \r\n    nothing illegal, obscene, pornographic, degrading or abusive to another \r\n    person, including pages that promote hate group propaganda and child \r\n    pornography. As the author, you also state that nothing on your page is \r\n    copyrighted material and that any links to other servers have been approved \r\n    by that organization. As the author, you also state that nothing on your \r\n    page infringes on the intellectual property rights of any third party. You \r\n    agree that [company] has the right to remove any page it determines, in \r\n    its sole discretion, has violated these rules to cancel your membersship and \r\n    take against you whatever measures will be deemed appropriate including \r\n    legal action and disclosing information about you to law enforcement \r\n    authorities and other interested third parties. Members who are in breach of \r\n    these rules agree to indemnify and hold harmless [company] for any \r\n    loss, claim, damage and expenses (including reasonable attorneys\\\\\\\'\' fees) \r\n    arising from or in connection with the contents of any personal home pages \r\n    or of any chat or messages on a bulletin board found to be infringing or \r\n    illegal. By submitting your pages, you agree to all the above terms. </p>\r\n    <p style=\\\\\\"FONT-WEIGHT: normal\\\\\\">[company] makes no guarantee as to \r\n    availability of service. To the fullest extent permissible by law, \r\n    [company] excludes all liability with respect to accuracy, content or \r\n    availability of information on its web site. The materials in this site are \r\n    provided \\"as is\\" and without warranties of any kind, either express or \r\n    implied. [company] does not warrant that the function contained in the \r\n    materials available on this web site will be uninterrupted or error free, \r\n    that defects will be corrected, or that this site or the servers that make \r\n    them available are free of viruses or other harmful components. Any \r\n    merchandise products or services available to users or members from links \r\n    from this web site are provided by third parties who are not necessarily \r\n    affiliated or connected with [company]. To the fullest extent permissible by \r\n    law, [company] excludes all liability under any circumstances \r\n    (including negligence) for any special or consequential damages that result \r\n    from the use of, or the inability to use, the materials on this site. \r\n    Applicable laws may not apply to all those who access the web site. </p>\r\n\r\n    <p style=\\\\\\"FONT-WEIGHT: bold\\\\\\">By becoming a Member, you agree to all the \r\n    above terms.\r\n    <br>\r\n     </p>	', 'Hello [username],\r\n\r\n    Thank you for registering with [company], your account information is as follows below:\r\n\r\nUsername: [username]\r\nEmail Address: [email]\r\nPackage: [package]\r\nDomain Name: [domain]\r\nSignup Date: [signup_date]\r\n\r\nTo login to your cpanel account follow either one of these links:\r\n[http_login]\r\nor\r\n[https_login]\r\n\r\nIf you signed up with an existing domain you will need to change your nameserver to point to our server. This change can take upto 48 hours to take effect. Our nameservers are:\r\n[ns1]\r\n[ns2]\r\n\r\n[http_path]', 'Hello [username]\r\n\r\nYour hosting account has been canceled with [company].\r\n\r\nif you feel this is incorrect or a mistake please notify the support department immediatly\r\n\r\nThank You,\r\n[company]', 'Hello [username],\r\n\r\n    Thank you for registering with [company], please verify and activate your account by going to the following: [http_path].', 'Hello [username],\r\n\r\n    Thank you for registering with [company], please verify and activate your account by going to the following: [http_path].  After you have verified your account, please allow up to 48 hours for your account to be created.  You will recieve a welcome email with all of your information!', 'Hello [username],\r\n\r\nYour web hosting subscription to [company] has failed, billing will be reattempted 3 days after failure date, and then again 5 days later, a third failure will lead to automatic cancellation of your subscription.\r\n\r\nThank You,\r\n[company]t ', 'Hello [username],\r\n\r\nYour payment to [company] has been successful!\r\n\r\nYou may log into our client control panel at any time to view your account details\r\n\r\nUsername: [username]\r\nEmail Address: [email]\r\nPackage: [package]\r\nDomain Name: [domain]\r\nSignup Date: [signup_date]\r\n\r\nTo login to your cpanel account follow either one of these links:\r\n[http_login]\r\nor\r\n[https_login]\r\n\r\nIf you signed up with an existing domain you will need to change your nameserver to point to our server. This change can take upto 48 hours to take effect. Our nameservers are:\r\n[ns1]\r\n[ns2]\r\n\r\n[http_path]\r\n\r\nThank You,\r\n[company]\r\n', 'Account End of Term Email');
INSERT INTO `merchant` VALUES (1, 'PayPal', '', '', '', '', 0, 0);
INSERT INTO `merchant` VALUES (2, '2Checkout', '', '', '', '', 0, 0);
INSERT INTO `merchant` VALUES (3, 'Authorize.net', '', '', '', '', 0, 0);
INSERT INTO `merchant` VALUES (4, 'LinkPoint', '', '', '', '', 0, 0);
INSERT INTO `merchant` VALUES (5, 'StormPay', '', '', '', '', 0, 0);
INSERT INTO `merchant` VALUES (6, 'Check/Money Order', '', '', '', '', 0, 0);