-- MySQL dump 10.11
--
-- Host: mysql.servage.net    Database: lab_phpaudit
-- ------------------------------------------------------
-- Server version	4.0.26-standard
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `phpaudit_admin`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_admin` (
  `uid` bigint(22) unsigned NOT NULL auto_increment,
  `phpaudit_session` varchar(32) NOT NULL default '',
  `last_logged` int(16) NOT NULL default '0',
  `logged_ip` varchar(25) NOT NULL default '',
  `logged_host` varchar(255) NOT NULL default '',
  `first_name` varchar(255) NOT NULL default '',
  `last_name` varchar(255) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `reset_password` tinyint(1) NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `phone` varchar(25) NOT NULL default '',
  `created` int(16) NOT NULL default '0',
  `status` enum('enabled','disabled') NOT NULL default 'enabled',
  PRIMARY KEY  (`uid`),
  KEY `first_name` (`first_name`),
  KEY `last_name` (`last_name`),
  KEY `email` (`email`),
  KEY `reset_password` (`reset_password`),
  KEY `phpaudit_session` (`phpaudit_session`),
  KEY `password` (`password`),
  KEY `status` (`status`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_admin`
--

INSERT INTO `phpaudit_admin` VALUES (1,'fb9167e0c90fc6135909a26ca527caa9',1147743795,'72.193.9.45','ip72-193-9-45.lv.lv.cox.net','Super','User','aee9684746a784cb2ca2e7e2585e4225',0,'cigmas@mghz.com','',1147736567,'enabled');

--
-- Table structure for table `phpaudit_admin_acl`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_admin_acl` (
  `acl_id` bigint(22) unsigned NOT NULL auto_increment,
  `acl_name` varchar(255) NOT NULL default '',
  `acl` blob NOT NULL,
  `created` int(10) NOT NULL default '0',
  PRIMARY KEY  (`acl_id`),
  KEY `acl_name` (`acl_name`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_admin_acl`
--

INSERT INTO `phpaudit_admin_acl` VALUES (1,'root','a:42:{s:7:"user_id";s:1:"1";s:14:"custom_modules";s:4:"full";s:8:"download";s:4:"full";s:6:"config";s:4:"full";s:20:"config_general_setup";s:4:"full";s:21:"config_order_profiles";s:4:"full";s:19:"config_pay_gateways";s:4:"full";s:20:"config_manage_admins";s:4:"full";s:22:"config_email_templates";s:4:"full";s:15:"config_cron_job";s:4:"full";s:14:"config_backups";s:4:"full";s:22:"config_api_fingerprint";s:4:"full";s:16:"config_quick_sql";s:4:"full";s:21:"config_custom_modules";s:4:"full";s:7:"billing";s:4:"full";s:14:"billing_orders";s:4:"full";s:16:"billing_invoices";s:4:"full";s:9:"licensing";s:4:"full";s:26:"licensing_manage_licensing";s:4:"full";s:25:"licensing_licensing_types";s:4:"full";s:26:"licensing_integration_code";s:4:"full";s:26:"licensing_support_packages";s:4:"full";s:26:"licensing_upgrade_packages";s:4:"full";s:20:"licensing_agreements";s:4:"full";s:8:"products";s:4:"full";s:24:"products_manage_products";s:4:"full";s:22:"products_manage_addons";s:4:"full";s:25:"products_manage_tax_types";s:4:"full";s:23:"products_manage_coupons";s:4:"full";s:23:"products_manage_uploads";s:4:"full";s:25:"products_ioncube_defaults";s:4:"full";s:25:"products_ioncube_projects";s:4:"full";s:7:"clients";s:4:"full";s:21:"clients_client_search";s:4:"full";s:22:"clients_manage_clients";s:4:"full";s:24:"clients_client_area_news";s:4:"full";s:17:"admin_index_stats";s:4:"full";s:25:"admin_index_client_search";s:4:"full";s:19:"admin_index_reports";s:4:"full";s:15:"key_server_logs";s:4:"full";s:8:"acl_name";s:4:"root";s:6:"submit";s:12:"Save Changes";}',1111427054);

--
-- Table structure for table `phpaudit_admin_profile`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_admin_profile` (
  `uid` bigint(22) NOT NULL default '0',
  `profile_key` varchar(255) NOT NULL default '',
  `profile_value` blob NOT NULL,
  KEY `uid` (`uid`),
  KEY `profile_key` (`profile_key`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_admin_profile`
--

INSERT INTO `phpaudit_admin_profile` VALUES (1,'order_add_first_or_last','0');
INSERT INTO `phpaudit_admin_profile` VALUES (1,'max_nav_history','25');
INSERT INTO `phpaudit_admin_profile` VALUES (1,'acl','�~:�G��l*������6��b�ov�XSߍI|u	\0�C�wb��
^��ZT��K���e�x4��u����vY�\n{]�+������#jB��>-�ӛU`�Q��������i�f�UX}����k���ح�o�*��O� Q޺���z��[��H�C���T5����;}�y�$��N�٠K몐�]G��&�|��ۇ��ߒ�W.��.��U�� ���3%��E�^z�\"	.�xN齃O��ွ� ����A)�؏8�MyL<(�_]� O���n�A��j��	U�c#\Z�z�=��SO\rv�H��	�u��q�H&�����$K��8�k�򂽶�:ۑ�[C����K�.�Y�:=�_r�E�1Ҹ��/�2$J���[�a�:m;J5`�c��&���=-犰|�^����f��T�+H���X�fOJs՞žs� ���~oG�}A��R���dCT$+N��W�Cu�ٱ|_M�\0u\0��h�[�٩�}�<��\n�!���}��� O���n�A��j����i�f�iHx�?Z\0���G�Zz
_{&oV6\Z�0�y߲\"�xɬ[[\r��-S�-\'+f�`[@!2�{O&�)����ߪƕ\nj��2����b&�\'cC�e�̨�Zl�>�����W0-*�ksF��CZ�\Z�	�O�.���&�t{���;�\Z�1P��qu�	l*�&��&���=-犰|�^�4��7)@|����l1�a%�_K�N� O���n�A��j���=\0�s�|k�~�Pa~K��&��&�����H�y9�8�}���ֶ��x�\n7��������NR�Sr
kɚa#��Z�G����h=RTDH��L~oG�}A��R���dCT$ij�Oy�k�p#(m�|r�0�m��(|�ɗa� O���n�A��j��dz�8]?Ƃ�d7�9��Fp��Ӑ����缿��e���
��ṢG��`x�mx}^U���Q��\\s�S�,�Q%-ߎM
G���?	��f�x\rqS�@7	���u��Y��mGp�jN� \rOu_�I)>꒫�\r�����zc��Zl�>�����W0�wǛ���Z��u*z�-�b�{鏯�x�6ԹŊ�b�\"���xZ���C;@7	���u��Y��mGp���u�i,g<	�6DQ5d&��ـ���P.�pW�l-�X8�\Z�ut�7@7	���u��Y��mGpxz^=g����g[�`�RQmNM\\��=���Ŀ��ͣ{�{��B����k���ح�o��b�Y���Xʓt�[�1D@�b���~~C3�C�o�t8�����}i�E �iG5�����!Ǡ��]n�,��L��_�y�M]����Rn���r�2�4F�E�Œ�qݻ#�j�{�+������#jB���O��o���2��\"!�H6\Z/E�� D����+\"Y�xK�^�JPz��v򂽶�:ۑ�[C����z�\Z\"wU�v�J/�*휼�.��_��+I�\r%�&���=-犰|�^��U�=��}k���9��	�� �T�D(ݫ�����\r5$T��̓�gd�ǠW(x�\n7��������NR�S8=\0в|��Y�5�8x�s�U��\0�?u��Q�S.��U�� ���3%��EZ��p�{�������A��cS,	��
���]9�\\�7`�g��kG�.��U�� ���3%��E�dHC�pܫ\09Y��cA��cS,	��
��0aX��>wCZ=��c�r�:��BQ,ζ�����^YؗȜ��@���ޟ���]�����3�kS;��Z�;�@ �j`�� O���n�A��j���hdP�]��C\"gk;dR�ʳ�R���,�)�P�~B$1���||,�B��� O���n�A��j���hdP�]��C\"gk;dR�ʳ�R���,�)�P��I�ZRV݁���Y�� O���n�A��j��5�UϘ\Zd+ISN���w�Y��Ը�{H��X���k���ح�o��F�Y$й�򻨫�K>��m���Fb�\0�:$������J�O^_QV�4̮���T5����;}�y�$��N����H�!eD�-i2z��v Gj��F	LP�?�y߲\"�xɬ[[\r��-S���1(�/��G��iՆM�������{e��d�1��H�Ü��k��j{w�e���
��ṢG����i}}͘m�f��,��-m�֥�W���m��/ci���D;|oww\n�f+�&���=-犰|�^�\n|:�1f�*?,\'�)k[lD�����c�� O���n�A��j���hdP�]��C\"gk;dR�ޛ%rGn��5�X������R������ܦ� O���n�A��j��	U�c#\Z�z�=��SO\r�íH���
���xb�Q�q�u�_u��Q�	򂽶�:ۑ�[C���2y�x2#�r�;��(j��I�Kc#��k�v�k+���k���ح�o���L��x��6��v��5�yj��y���V�BS�&���=-犰|�^�Һ�>{��0�b��p���O��r\r0�c��E �iG5�����!Ǡ�ޏ�Bt��\Zw�y���
���F�-R�3�)cO������񎛢��^םۏ�4�WX�-�Y�O���:��D?ԝ���J޴ei\n��\rOn�=�0��se��\Z;���<e�lm�P');
INSERT INTO `phpaudit_admin_profile` VALUES (1,'session_timeout','28800');
INSERT INTO `phpaudit_admin_profile` VALUES (1,'drop_menu_spec','a:53:{i:0;s:21:&quot;clients_client_search&quot;;i:1;s:22:&quot;clients_manage_clients&quot;;i:2;s:14:&quot;add_new_client&quot;;i:3;s:16:&quot;client_area_news&quot;;i:4;s:20:&quot;add_client_area_news&quot;;i:5;s:12:&quot;time_tracker&quot;;i:6;s:28:&quot;time_tracker_add_find_client&quot;;i:7;s:15:&quot;manage_products&quot;;i:8;s:15:&quot;add_new_product&quot;;i:9;s:13:&quot;manage_addons&quot;;i:10;s:13:&quot;add_new_addon&quot;;i:11;s:16:&quot;manage_tax_types&quot;;i:12;s:12:&quot;add_tax_type&quot;;i:13;s:14:&quot;manage_coupons&quot;;i:14;s:14:&quot;add_new_coupon&quot;;i:15;s:14:&quot;manage_uploads&quot;;i:16;s:14:&quot;add_new_upload&quot;;i:17;s:16:&quot;ioncube_defaults&quot;;i:18;s:16:&quot;ioncube_projects&quot;;i:19;s:19:&quot;add_ioncube_project&quot;;i:20;s:16:&quot;manage_licensing&quot;;i:21;s:15:&quot;add_new_license&quot;;i:22;s:21:&quot;manage_licensing_type&quot;;i:23;s:18:&quot;add_licensing_type&quot;;i:24;s:16:&quot;integration_code&quot;;i:25;s:16:&quot;support_packages&quot;;i:26;s:19:&quot;add_support_package&quot;;i:27;s:16:&quot;upgrade_packages&quot;;i:28;s:19:&quot;add_upgrade_package&quot;;i:29;s:17:&quot;manage_agreements&quot;;i:30;s:13:&quot;add_agreement&quot;;i:31;s:13:&quot;manage_orders&quot;;i:32;s:13:&quot;add_new_order&quot;;i:33;s:15:&quot;manage_invoices&quot;;i:34;s:15:&quot;add_new_invoice&quot;;i:35;s:13:&quot;general_setup&quot;;i:36;s:14:&quot;order_profiles&quot;;i:37;s:21:&quot;add_new_order_profile&quot;;i:38;s:12:&quot;pay_gateways&quot;;i:39;s:15:&quot;add_pay_gateway&quot;;i:40;s:16:&quot;pay_gateway_logs&quot;;i:41;s:13:&quot;manage_admins&quot;;i:42;s:13:&quot;add_new_admin&quot;;i:43;s:15:&quot;email_templates&quot;;i:44;s:18:&quot;add_email_template&quot;;i:45;s:25:&quot;configure_email_transport&quot;;i:46;s:11:&quot;manage_cron&quot;;i:47;s:14:&quot;manage_backups&quot;;i:48;s:15:&quot;api_fingerprint&quot;;i:49;s:15:&quot;make_secret_key&quot;;i:50;s:9:&quot;quick_sql&quot;;i:51;s:14:&quot;custom_modules&quot;;i:52;s:17:&quot;add_custom_module&quot;;}');

--
-- Table structure for table `phpaudit_agreements`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_agreements` (
  `agreement_id` bigint(22) unsigned NOT NULL auto_increment,
  `is_tos` tinyint(1) NOT NULL default '0',
  `agreement_name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `created` int(16) NOT NULL default '0',
  `updated` int(16) NOT NULL default '0',
  PRIMARY KEY  (`agreement_id`),
  KEY `is_tos` (`is_tos`),
  KEY `agreement_name` (`agreement_name`),
  KEY `created` (`created`),
  KEY `updated` (`updated`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_agreements`
--


--
-- Table structure for table `phpaudit_api`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_api` (
  `api_key` varchar(255) NOT NULL default '',
  `api_value` text NOT NULL,
  UNIQUE KEY `api_key` (`api_key`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_api`
--

INSERT INTO `phpaudit_api` VALUES ('fingerprint','f9da4425b5898bb1509354a476f92c19');

--
-- Table structure for table `phpaudit_backups`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_backups` (
  `backup_id` bigint(22) unsigned NOT NULL auto_increment,
  `file` varchar(255) NOT NULL default '',
  `downloaded` int(5) NOT NULL default '0',
  `backup_type` varchar(4) NOT NULL default '',
  `created` int(20) NOT NULL default '0',
  PRIMARY KEY  (`backup_id`),
  KEY `file` (`file`),
  KEY `downloaded` (`downloaded`),
  KEY `backup_type` (`backup_type`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_backups`
--


--
-- Table structure for table `phpaudit_bookmarks`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_bookmarks` (
  `bookmark_id` bigint(22) unsigned NOT NULL auto_increment,
  `uid` bigint(22) NOT NULL default '0',
  `bookmark_name` varchar(22) NOT NULL default '',
  `bookmark_link` text NOT NULL,
  `created` int(16) NOT NULL default '0',
  PRIMARY KEY  (`bookmark_id`),
  KEY `uid` (`uid`),
  KEY `bookmark_name` (`bookmark_name`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_bookmarks`
--


--
-- Table structure for table `phpaudit_category`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_category` (
  `category_id` bigint(22) unsigned NOT NULL auto_increment,
  `category_order` bigint(22) NOT NULL default '0',
  `category_status` enum('public','private') NOT NULL default 'public',
  `profile_id` bigint(22) NOT NULL default '0',
  `product_array` text NOT NULL,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`category_id`),
  KEY `category_status` (`category_status`),
  KEY `profile_id` (`profile_id`),
  KEY `name` (`name`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_category`
--


--
-- Table structure for table `phpaudit_client_news`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_client_news` (
  `news_id` bigint(22) unsigned NOT NULL auto_increment,
  `profile_id` bigint(22) NOT NULL default '0',
  `news_title` varchar(255) NOT NULL default '',
  `news_body` text NOT NULL,
  `created` int(20) NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '1',
  `emailed` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`news_id`),
  KEY `news_title` (`news_title`),
  KEY `created` (`created`),
  KEY `status` (`status`),
  KEY `emailed` (`emailed`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_client_news`
--

INSERT INTO `phpaudit_client_news` VALUES (1,0,'Sample','Just an example!',1094097600,1,1);

--
-- Table structure for table `phpaudit_clients`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_clients` (
  `client_id` bigint(22) unsigned NOT NULL auto_increment,
  `client_session` varchar(32) NOT NULL default '',
  `profile_array` text NOT NULL,
  `credit_card` blob NOT NULL,
  `notes` text NOT NULL,
  `staff_notes` text NOT NULL,
  `first_name` varchar(50) NOT NULL default '',
  `last_name` varchar(50) NOT NULL default '',
  `org` varchar(150) NOT NULL default '',
  `address_1` varchar(100) NOT NULL default '',
  `city` varchar(100) NOT NULL default '',
  `sorp` enum('state','province') NOT NULL default 'state',
  `province` varchar(100) NOT NULL default '',
  `state` varchar(100) NOT NULL default '',
  `zip` varchar(20) NOT NULL default '',
  `country` varchar(100) NOT NULL default '',
  `phone` varchar(30) NOT NULL default '',
  `fax` varchar(30) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `how_found` varchar(255) NOT NULL default '',
  `tos` enum('I do not agree','I Agree') NOT NULL default 'I do not agree',
  `created` int(20) NOT NULL default '0',
  `last_logged` int(16) NOT NULL default '0',
  `logged_ip` varchar(30) NOT NULL default '',
  `logged_host` varchar(255) NOT NULL default '',
  `reset_password` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`client_id`),
  KEY `client_session` (`client_session`),
  KEY `first_name` (`first_name`),
  KEY `last_name` (`last_name`),
  KEY `email` (`email`),
  KEY `created` (`created`),
  KEY `last_logged` (`last_logged`),
  KEY `logged_ip` (`logged_ip`),
  KEY `logged_host` (`logged_host`),
  KEY `reset_password` (`reset_password`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_clients`
--


--
-- Table structure for table `phpaudit_config`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_config` (
  `config_key` varchar(255) NOT NULL default '',
  `config_value` longtext NOT NULL,
  KEY `config_key` (`config_key`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_config`
--

INSERT INTO `phpaudit_config` VALUES ('server_root','/home19a/sub001/sc19426-LGLN');
INSERT INTO `phpaudit_config` VALUES ('phpaudit_deploy','/home19a/sub001/sc19426-LGLN/downloads');
INSERT INTO `phpaudit_config` VALUES ('server_public','/home19a/sub001/sc19426-LGLN/cigmas.com');
INSERT INTO `phpaudit_config` VALUES ('http_web','http://www.cigmas.com/admincp');
INSERT INTO `phpaudit_config` VALUES ('default_email','cigmas@mghz.com');
INSERT INTO `phpaudit_config` VALUES ('http_image','http://www.cigmas.com/admincp/images');
INSERT INTO `phpaudit_config` VALUES ('license','PHPAudit-7e8a67de4f89');
INSERT INTO `phpaudit_config` VALUES ('php_as_cgi','no');
INSERT INTO `phpaudit_config` VALUES ('site_name','Cigmas');
INSERT INTO `phpaudit_config` VALUES ('default_from','Cigmas');
INSERT INTO `phpaudit_config` VALUES ('time_format','h:i:s');
INSERT INTO `phpaudit_config` VALUES ('date_format','m-d-Y');
INSERT INTO `phpaudit_config` VALUES ('ioncube_temp','');
INSERT INTO `phpaudit_config` VALUES ('program_data','/home19a/sub001/sc19426-LGLN/program_data');
INSERT INTO `phpaudit_config` VALUES ('server_backup','/home19a/sub001/sc19426-LGLN/program_data/backup');
INSERT INTO `phpaudit_config` VALUES ('file_server','http://www.cigmas.com/admincp/file_server.php');
INSERT INTO `phpaudit_config` VALUES ('email_transport','php_mail');
INSERT INTO `phpaudit_config` VALUES ('charset','ISO-8859-1');
INSERT INTO `phpaudit_config` VALUES ('smtp_port','25');
INSERT INTO `phpaudit_config` VALUES ('smtp_primary_host','localhost');
INSERT INTO `phpaudit_config` VALUES ('smtp_secondary_host','');
INSERT INTO `phpaudit_config` VALUES ('smtp_username','');
INSERT INTO `phpaudit_config` VALUES ('smtp_password','');
INSERT INTO `phpaudit_config` VALUES ('email_signature','Thanks,\r\nCigmas Management');

--
-- Table structure for table `phpaudit_coupons`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_coupons` (
  `expires_on` int(16) NOT NULL default '0',
  `coupon_type` enum('one_time_fee','recurring_fee','both') NOT NULL default 'one_time_fee',
  `coupon_code` varchar(255) NOT NULL default '',
  `discount` decimal(10,2) NOT NULL default '0.00',
  UNIQUE KEY `coupon_code` (`coupon_code`),
  KEY `expires_on` (`expires_on`),
  KEY `coupon_type` (`coupon_type`),
  KEY `discount` (`discount`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_coupons`
--


--
-- Table structure for table `phpaudit_cron`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_cron` (
  `cron_key` varchar(255) NOT NULL default '',
  `cron_value` longtext NOT NULL,
  `common_name` varchar(255) NOT NULL default '',
  `required` tinyint(1) NOT NULL default '0',
  KEY `cron_key` (`cron_key`),
  KEY `common_name` (`common_name`),
  KEY `required` (`required`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_cron`
--

INSERT INTO `phpaudit_cron` VALUES ('full_backup','daily','Full Backup',1);
INSERT INTO `phpaudit_cron` VALUES ('full_backup_email','you@yourdomain.com','Full Backup E-mail Address',0);
INSERT INTO `phpaudit_cron` VALUES ('auth_cron','0e2d5746bb1d4c6080a3cc432891bfa0','system resource',1);
INSERT INTO `phpaudit_cron` VALUES ('file_backup','daily','File Backup',0);
INSERT INTO `phpaudit_cron` VALUES ('file_backup_email','you@yourdomain.com','File Backup E-mail',0);
INSERT INTO `phpaudit_cron` VALUES ('data_backup','daily','Database Backup',0);
INSERT INTO `phpaudit_cron` VALUES ('data_backup_email','you@yourdomain.com','Database Backup E-mail',0);
INSERT INTO `phpaudit_cron` VALUES ('full_backup_ran','1111377604','Last Run',0);
INSERT INTO `phpaudit_cron` VALUES ('file_backup_ran','1111377605','Last Run',0);
INSERT INTO `phpaudit_cron` VALUES ('data_backup_ran','1111377605','Last Run',0);

--
-- Table structure for table `phpaudit_custom_modules`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_custom_modules` (
  `module_id` bigint(22) unsigned NOT NULL auto_increment,
  `module_name` varchar(255) NOT NULL default '',
  `runtime` varchar(255) NOT NULL default '',
  `profile_array` text NOT NULL,
  `show_in` enum('all','admin_index','client','products','licensing','billing','configuration') NOT NULL default 'all',
  `menu_title` varchar(20) NOT NULL default '',
  `history_label` varchar(20) NOT NULL default '',
  `created` int(10) NOT NULL default '0',
  PRIMARY KEY  (`module_id`),
  KEY `module_name` (`module_name`),
  KEY `runtime` (`runtime`),
  KEY `show_in` (`show_in`),
  KEY `menu_title` (`menu_title`),
  KEY `history_label` (`history_label`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_custom_modules`
--

INSERT INTO `phpaudit_custom_modules` VALUES (4,'Fortune','a:2:{s:5:&quot;admin&quot;;s:5:&quot;admin&quot;;s:6:&quot;client&quot;;s:6:&quot;client&quot;;}','a:1:{i:0;s:1:&quot;4&quot;;}','admin_index','Your Fortune','Your Fortune',1109173279);
INSERT INTO `phpaudit_custom_modules` VALUES (10,'Getting Started','a:1:{s:5:&quot;admin&quot;;s:5:&quot;admin&quot;;}','','all','Getting Started','Getting Started',1122998114);
INSERT INTO `phpaudit_custom_modules` VALUES (16,'I Need Help','a:1:{s:5:&quot;admin&quot;;s:5:&quot;admin&quot;;}','','admin_index','I Need Help','I Need Help',1126804399);

--
-- Table structure for table `phpaudit_downloads`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_downloads` (
  `did` bigint(22) unsigned NOT NULL auto_increment,
  `file_name` varchar(255) NOT NULL default '',
  `file_title` varchar(255) NOT NULL default '',
  `file_description` text NOT NULL,
  `product_type` enum('product','update') NOT NULL default 'product',
  `downloaded` bigint(22) NOT NULL default '0',
  `created` int(20) NOT NULL default '0',
  PRIMARY KEY  (`did`),
  KEY `file_name` (`file_name`),
  KEY `file_title` (`file_title`),
  KEY `product_type` (`product_type`),
  KEY `downloaded` (`downloaded`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_downloads`
--


--
-- Table structure for table `phpaudit_email`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_email` (
  `email_id` bigint(22) unsigned NOT NULL auto_increment,
  `group_id` bigint(22) NOT NULL default '0',
  `event_id` varchar(255) NOT NULL default '',
  `email_name` varchar(255) NOT NULL default '',
  `email_type` tinyint(1) NOT NULL default '0',
  `email_priority` tinyint(1) NOT NULL default '3',
  `email_copy_to` text NOT NULL,
  `email_subject` varchar(255) NOT NULL default '',
  `email_message` longtext NOT NULL,
  `send_expire_email` int(5) NOT NULL default '0',
  `default_email` varchar(255) NOT NULL default '',
  `default_from` varchar(255) NOT NULL default '',
  `send_to` enum('client','client_admin','admin') NOT NULL default 'client',
  `system_locked` enum('no','yes') NOT NULL default 'no',
  PRIMARY KEY  (`email_id`),
  KEY `email_name` (`email_name`),
  KEY `email_type` (`email_type`),
  KEY `email_priority` (`email_priority`),
  KEY `email_subject` (`email_subject`),
  KEY `default_email` (`default_email`),
  KEY `default_from` (`default_from`),
  KEY `system_locked` (`system_locked`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_email`
--

INSERT INTO `phpaudit_email` VALUES (1,1,'admin_resend_password','Admin -&gt; Resend Password',1,3,'','Recent Login Request','Greetings, \r\nSomeone, possibly you, requested the followign login information:\r\n\r\n{admin_login_link}\r\nPassword: {temp_password}\r\n\r\n{email_signature}\r\n\r\n------------------------------------------------------------------------------------------------\r\nThis message was generated on: {generated_on}',0,'you@yourdomain.com','Website Automation','admin','yes');
INSERT INTO `phpaudit_email` VALUES (2,1,'admin_cron_backup','Admin -&gt; Cron Backups',1,1,'','Cron Backup Results','Greetings,\r\nYour backup is attached to this e-mail. Should you wish to stop recieving this e-mail simply:\r\n\r\n1. Log into your PHPAudit Admin Area\r\n2. Click the \\&quot;Configuration\\&quot; tab/button\r\n3. Click \\&quot;Manage Cron Backup\\&quot;\r\n\r\n{email_signature}\r\n\r\n---------------------------------------------------------------------------------\r\nThis e-mail was generated on: {generated_on}',0,'you@yourdomain.com','Website Automation','admin','yes');
INSERT INTO `phpaudit_email` VALUES (5,1,'admin_client_area_news','Admin -&gt; Default Client Area News Template',1,1,'','This will be ignored (this template only)','{client_area_news_body}',0,'you@yourdomain.com','Website Automation','admin','yes');
INSERT INTO `phpaudit_email` VALUES (39,25,'client_resend_password','Client -&gt; Resend Password',1,3,'','Recent Login Request','Greetings, \r\nSomeone, possibly you, requested the followign login information:\r\n\r\n{client_login_link}\r\nPassword: {temp_password}\r\n\r\nThank you,\r\nPHPAudit Automation\r\n\r\n------------------------------------------------------------------------------------------------\r\nThis message was generated on: {generated_on}',0,'you@yourdomain.com','Website Automation','client','yes');
INSERT INTO `phpaudit_email` VALUES (40,25,'client_product_registration_details','Client -&gt; Product Registration Details',1,3,'','[PHPAudit Notify] New Order Cart ID #{cart_id}','Greetings {client_name},\r\nThank you for your purchase. \r\n\r\nBelow is your registration information for Cart ID #{cart_id}:\r\n\r\n{order_registration_summary}\r\n\r\nYou may download your product by following the link below:\r\n{client_login_link}\r\n\r\nAgain, Thank You for your purchase.\r\n\r\n{email_signature}\r\n\r\n------------------------------------------------\r\nThis message was generated on: {generate_date}',0,'you@yourdomain.com','Website Order System','client','yes');
INSERT INTO `phpaudit_email` VALUES (41,25,'client_new_order_confirmation','Client -&gt; New Order Confirmation',1,3,'','Order confirmation for Cart ID #{cart_id} from {site_name}','The following order was placed for {client_first_name} {client_last_name}:\r\n\r\n{site_name} Cart ID: {cart_id}\r\n\r\nTotal - {order_confirmation_total}\r\n\r\nThe order was billed to:\r\n\r\n{client_first_name} {client_last_name}\r\n{client_email}\r\n{client_phone}\r\n{client_address}\r\n{client_city}, {client_state} {client_zip}\r\n{client_country}\r\n\r\nQuestions regarding your order should be directed to:\r\n\r\n{site_name}\r\n{site_link}\r\n{site_email}\r\n\r\nAny problems, questions or comments pertaining to your order can be submitted directly to us.\r\n\r\n{email_signature}',0,'you@yourdomain.com','Website Order System','client','yes');
INSERT INTO `phpaudit_email` VALUES (42,25,'client_e-mail_local_key','Client -&gt; E-mail Local Key',1,1,'','[PHPAudit Notify] Important Licensing Information Attached','Greetings {client_first_name},\r\nYour license key is attached to this e-mail. Please unarchive and upload this file to your installation. \r\n\r\nYou should save this e-mail in a safe location as you might need it again sometime in the future.\r\n\r\nYou may also obtain the attached license key from your client area login located here:\r\n{client_login_link}\r\n\r\nBelow is your registration information:\r\n\r\n{local_key_details}\r\n\r\n{email_signature}\r\n\r\n----------------------------------------------\r\nGenerated on: {generate_date}',0,'you@yourdomain.com','Website Order','client','yes');
INSERT INTO `phpaudit_email` VALUES (43,25,'client_first_license_access','Admin -&gt; First License Access',1,3,'','[PHPAudit Notify] First Access: {license_key}','Greetings,\r\nThe license key \\&quot;{license_key}\\&quot; has just been accessed for the first time. \r\n\r\nPlease review the access details below:\r\n\r\n{license_access_details}\r\n\r\nFor more details please login to your admin area.\r\n\r\n{email_signature}\r\n----------------------------------------------------\r\nGenerated on: {generate_date}',0,'you@yourdomain.com','Website Order','admin','yes');
INSERT INTO `phpaudit_email` VALUES (44,25,'client_license_suspended','Client -&gt; License Suspended',1,3,'','[License Suspended] {license_key}','Greetings,\r\nThe license key \\&quot;{license_key}\\&quot; has just been suspended. \r\n\r\nPlease review the access details below:\r\n\r\n{suspended_license_access_details}\r\n\r\nFor more details please login to your client area or contact support.\r\n\r\n{email_signature}\r\n----------------------------------------------------\r\nGenerated on: {generate_date}',0,'you@yourdomain.com','Website Order','client','yes');
INSERT INTO `phpaudit_email` VALUES (45,25,'client_license_active','Client -&gt; License Active',1,3,'','[License Active] {license_key}','Greetings,\r\nThe license key \\&quot;{license_key}\\&quot; has just been activated. \r\n\r\nRegistered to:\r\n\r\n{active_license_details}\r\n\r\nFor more details please login to your client area or contact support.\r\n\r\n{email_signature}\r\n----------------------------------------------------\r\nGenerated on: {generate_date}',0,'you@yourdomain.com','Website Automation','client','yes');
INSERT INTO `phpaudit_email` VALUES (46,25,'client_license_reissued','Client -&gt; License Reissued',1,3,'','[License Reissued] {license_key}','Greetings,\r\nThe license key \\&quot;{license_key}\\&quot; has just been reissued. Your new valid access details will be locked in the next time you use the software. \r\n\r\nRegistration Summary:\r\n\r\n{reissued_license_details}\r\n\r\nFor more details please login to your client area or contact support.\r\n\r\n{email_signature}\r\n----------------------------------------------------\r\nGenerated on: {generate_date}',0,'you@yourdomain.com','Website Automation','client','yes');
INSERT INTO `phpaudit_email` VALUES (47,25,'admin_license_reissued','Admin -&gt; License Reissued',1,3,'','[License Reissued] {license_key}','Greetings,\r\nThe license key \\&quot;{license_key}\\&quot; has just been reissued.\r\n\r\nRegistration Summary:\r\n\r\n{reissued_license_details_admin}\r\n\r\nFor more details please login to your admin area.\r\n\r\n{email_signature}\r\n----------------------------------------------------\r\nGenerated on: {generate_date}',0,'you@yourdomain.com','Website Automation','admin','yes');
INSERT INTO `phpaudit_email` VALUES (48,25,'client_license_expire','Client -&gt; License Expired / Expiring',1,3,'','[License Expired] {license_key}','Greetings,\r\nThe license key \\&quot;{license_key}\\&quot; has just expired. \r\n\r\nRegistered to:\r\n\r\n{license_details}\r\n\r\nFor more details please login to your client area or contact support.\r\n\r\n{email_signature}\r\n----------------------------------------------------\r\nGenerated on: {generate_date}',0,'you@yourdomain.com','Website Automation','client','yes');
INSERT INTO `phpaudit_email` VALUES (49,25,'admin_free_trial_abuse','Admin -&gt; Free Trial Abuse',1,3,'','[PHPAudit Notify] Free Trial Abuse -&gt; {license_key}','Greetings,\r\nLicense Key {license_key} has been suspended for suspected free trial abuse. \r\n \r\nValid License Key: {license_key} \r\n{valid_for}\r\n\r\nLicense keys matched:\r\n{suspect_keys}\r\n \r\nThis event has also been logged in the global queue. \r\n\r\nPlease login to your administration panel to review this and any other events. \r\n\r\n------------------------------------------------------\r\nThis e-mail was generated on: {generate_date}',0,'you@yourdomain.com','Website Automation','admin','yes');

--
-- Table structure for table `phpaudit_email_events`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_email_events` (
  `event_id` varchar(255) NOT NULL default '',
  `attributes` text NOT NULL,
  UNIQUE KEY `event_id` (`event_id`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_email_events`
--

INSERT INTO `phpaudit_email_events` VALUES ('admin_client_area_news','admin_login_link,temp_password,client_area_news_body,generated_on,email_signature');
INSERT INTO `phpaudit_email_events` VALUES ('admin_cron_backup','generated_on,email_signature');
INSERT INTO `phpaudit_email_events` VALUES ('admin_license_reissued','license_key,reissued_license_details_admin,email_signature,generate_date');
INSERT INTO `phpaudit_email_events` VALUES ('admin_resend_password','admin_login_link,temp_password,generated_on,email_signature');
INSERT INTO `phpaudit_email_events` VALUES ('client_e-mail_local_key','client_first_name,client_login_link,local_key_details,email_signature,generate_date');
INSERT INTO `phpaudit_email_events` VALUES ('client_first_license_access','license_key,license_access_details,email_signature,generate_date');
INSERT INTO `phpaudit_email_events` VALUES ('client_license_active','license_key,active_license_details,email_signature,generate_date');
INSERT INTO `phpaudit_email_events` VALUES ('client_license_expire','license_key,license_details,email_signature,generate_date');
INSERT INTO `phpaudit_email_events` VALUES ('client_license_reissued','license_key,reissued_license_details,email_signature,generate_date');
INSERT INTO `phpaudit_email_events` VALUES ('client_license_suspended','license_key,suspended_license_access_details,email_signature,generate_date');
INSERT INTO `phpaudit_email_events` VALUES ('client_new_order_confirmation','client_first_name,client_last_name,site_name,site_link,site_email,cart_id,order_confirmation_total,client_phone,client_address,client_city,client_state,client_zip,client_country,client_email,email_signature,generated_on');
INSERT INTO `phpaudit_email_events` VALUES ('client_product_registration_details','client_name,client_first_name,client_last_name,cart_id,order_registration_summary,client_login_link,generate_date,email_signature');
INSERT INTO `phpaudit_email_events` VALUES ('client_resend_password','client_login_link,temp_password,generated_on,email_signature');

--
-- Table structure for table `phpaudit_email_groups`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_email_groups` (
  `group_id` bigint(22) unsigned NOT NULL auto_increment,
  `group_name` varchar(255) NOT NULL default '',
  `system_locked` enum('no','yes') NOT NULL default 'no',
  `created` int(10) NOT NULL default '0',
  PRIMARY KEY  (`group_id`),
  KEY `group_name` (`group_name`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_email_groups`
--

INSERT INTO `phpaudit_email_groups` VALUES (1,'Admin System Templates','yes',1116007940);
INSERT INTO `phpaudit_email_groups` VALUES (25,'Order System Templates','yes',1117056609);

--
-- Table structure for table `phpaudit_history`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_history` (
  `history_id` bigint(22) unsigned NOT NULL auto_increment,
  `history_link` text NOT NULL,
  `history_label` varchar(22) NOT NULL default '',
  `uid` bigint(22) NOT NULL default '0',
  `created` int(16) NOT NULL default '0',
  PRIMARY KEY  (`history_id`),
  KEY `history_label` (`history_label`),
  KEY `uid` (`uid`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_history`
--

INSERT INTO `phpaudit_history` VALUES (1,'http://www.cigmas.com/admincp/index2.php','Admin Index',1,1147740930);
INSERT INTO `phpaudit_history` VALUES (2,'http://www.cigmas.com/admincp/secret_key.php','Make Secret Key',1,1147740948);
INSERT INTO `phpaudit_history` VALUES (3,'http://www.cigmas.com/admincp/secret_key.php','Make Secret Key',1,1147740954);
INSERT INTO `phpaudit_history` VALUES (4,'http://www.cigmas.com/admincp/general_setup.php','General Setup',1,1147740979);
INSERT INTO `phpaudit_history` VALUES (5,'http://www.cigmas.com/admincp/profile_main.php','Order Profile Main',1,1147743023);
INSERT INTO `phpaudit_history` VALUES (6,'http://www.cigmas.com/admincp/profile_add.php','Add Order Profile',1,1147743028);
INSERT INTO `phpaudit_history` VALUES (7,'http://www.cigmas.com/admincp/admin_edit_details.php?user_id=1','Admin Edit',1,1147743035);
INSERT INTO `phpaudit_history` VALUES (8,'http://www.cigmas.com/admincp/admin_edit_profile.php?user_id=1','Admin Edit',1,1147743037);
INSERT INTO `phpaudit_history` VALUES (9,'http://www.cigmas.com/admincp/email_configure.php','Configure E-mail',1,1147743044);
INSERT INTO `phpaudit_history` VALUES (10,'http://www.cigmas.com/admincp/email_configure.php?email_transport=php_mail&amp;default_email=cigmas@mghz.com&amp;default_from=Cigmas&amp;email_signature=Thanks,\r\nCigmas Management&amp;submit=Save Changes','Configure E-mail',1,1147743058);
INSERT INTO `phpaudit_history` VALUES (11,'http://www.cigmas.com/admincp/profile_main.php','Order Profile Main',1,1147743796);

--
-- Table structure for table `phpaudit_invoice`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_invoice` (
  `invoice_id` bigint(22) unsigned NOT NULL auto_increment,
  `cart_id` varchar(8) NOT NULL default '0',
  `profile_id` bigint(22) NOT NULL default '0',
  `order_id` bigint(22) NOT NULL default '0',
  `client_id` bigint(22) NOT NULL default '0',
  `log_id` text NOT NULL,
  `first_invoice` tinyint(1) NOT NULL default '0',
  `invoice_array` text NOT NULL,
  `invoice_sub_total` decimal(10,2) NOT NULL default '0.00',
  `invoice_amount` decimal(10,2) NOT NULL default '0.00',
  `created` int(10) NOT NULL default '0',
  `due` int(10) NOT NULL default '0',
  PRIMARY KEY  (`invoice_id`),
  KEY `cart_id` (`cart_id`),
  KEY `profile_id` (`profile_id`),
  KEY `order_id` (`order_id`),
  KEY `client_id` (`client_id`),
  KEY `first_invoice` (`first_invoice`),
  KEY `invoice_sub_total` (`invoice_sub_total`),
  KEY `invoice_amount` (`invoice_amount`),
  KEY `created` (`created`),
  KEY `due` (`due`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_invoice`
--


--
-- Table structure for table `phpaudit_invoice_revisions`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_invoice_revisions` (
  `revision_id` bigint(22) unsigned NOT NULL auto_increment,
  `invoice_id` bigint(22) NOT NULL default '0',
  `cart_id` varchar(8) NOT NULL default '0',
  `profile_id` bigint(22) NOT NULL default '0',
  `order_id` bigint(22) NOT NULL default '0',
  `client_id` bigint(22) NOT NULL default '0',
  `first_invoice` tinyint(1) NOT NULL default '0',
  `invoice_array` text NOT NULL,
  `invoice_sub_total` decimal(10,2) NOT NULL default '0.00',
  `invoice_amount` decimal(10,2) NOT NULL default '0.00',
  `created` int(10) NOT NULL default '0',
  `due` int(10) NOT NULL default '0',
  `changed` int(10) NOT NULL default '0',
  `changed_by` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`revision_id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `cart_id` (`cart_id`),
  KEY `profile_id` (`profile_id`),
  KEY `order_id` (`order_id`),
  KEY `client_id` (`client_id`),
  KEY `first_invoice` (`first_invoice`),
  KEY `invoice_sub_total` (`invoice_sub_total`),
  KEY `invoice_amount` (`invoice_amount`),
  KEY `created` (`created`),
  KEY `due` (`due`),
  KEY `changed` (`changed`),
  KEY `changed_by` (`changed_by`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_invoice_revisions`
--


--
-- Table structure for table `phpaudit_ion`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_ion` (
  `verify_sign` varchar(32) NOT NULL default '',
  `created` int(11) NOT NULL default '0'
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_ion`
--


--
-- Table structure for table `phpaudit_ioncube`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_ioncube` (
  `ioncube_path` varchar(255) NOT NULL default '',
  `comments` text NOT NULL,
  `encoding_format` varchar(6) NOT NULL default 'ascii',
  `always_encode` text NOT NULL,
  `do_not_encode` text NOT NULL,
  `do_not_include` text NOT NULL,
  KEY `ioncube_path` (`ioncube_path`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_ioncube`
--

INSERT INTO `phpaudit_ioncube` VALUES ('/ioncube/ioncube_encoder','&copy;2002-2004 some company. xxx\r\nAll Rights Reserved.','ascii','/admin,/inc,.php','/images,.css,.html','.htaccess');

--
-- Table structure for table `phpaudit_ioncube_project_files`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_ioncube_project_files` (
  `fid` bigint(22) unsigned NOT NULL auto_increment,
  `proid` bigint(22) NOT NULL default '0',
  `path` text NOT NULL,
  `status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`fid`),
  KEY `proid` (`proid`),
  KEY `status` (`status`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_ioncube_project_files`
--


--
-- Table structure for table `phpaudit_ioncube_project_history`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_ioncube_project_history` (
  `hid` bigint(22) unsigned NOT NULL auto_increment,
  `proid` bigint(22) NOT NULL default '0',
  `file_name` varchar(255) NOT NULL default '',
  `downloaded` bigint(22) NOT NULL default '0',
  `compile_string` text NOT NULL,
  `after_encoding` varchar(7) NOT NULL default '',
  `created` int(20) NOT NULL default '0',
  PRIMARY KEY  (`hid`),
  KEY `proid` (`proid`),
  KEY `file_name` (`file_name`),
  KEY `downloaded` (`downloaded`),
  KEY `after_encoding` (`after_encoding`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_ioncube_project_history`
--


--
-- Table structure for table `phpaudit_ioncube_projects`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_ioncube_projects` (
  `proid` bigint(22) unsigned NOT NULL auto_increment,
  `project_name` varchar(255) NOT NULL default '',
  `file_name` varchar(255) NOT NULL default '',
  `file_ext` varchar(4) NOT NULL default '',
  `source_path` varchar(255) NOT NULL default '',
  `after_encoding` varchar(7) NOT NULL default 'public',
  `comments` text NOT NULL,
  `created` int(20) NOT NULL default '0',
  `encoding_format` varchar(6) NOT NULL default '',
  `always_encode` text NOT NULL,
  `do_not_encode` text NOT NULL,
  `do_not_include` text NOT NULL,
  PRIMARY KEY  (`proid`),
  KEY `project_name` (`project_name`),
  KEY `file_name` (`file_name`),
  KEY `file_ext` (`file_ext`),
  KEY `source_path` (`source_path`),
  KEY `after_encoding` (`after_encoding`),
  KEY `created` (`created`),
  KEY `encoding_format` (`encoding_format`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_ioncube_projects`
--


--
-- Table structure for table `phpaudit_license`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_license` (
  `license_id` bigint(22) unsigned NOT NULL auto_increment,
  `licensing_id` bigint(22) NOT NULL default '0',
  `client_id` bigint(22) NOT NULL default '0',
  `cart_id` varchar(8) NOT NULL default '0',
  `order_id` bigint(22) NOT NULL default '0',
  `product_id` bigint(22) NOT NULL default '0',
  `profile_id` bigint(22) NOT NULL default '0',
  `license_array` text NOT NULL,
  `license_key` text NOT NULL,
  `valid_directory` text NOT NULL,
  `valid_host` text NOT NULL,
  `valid_ip` text NOT NULL,
  `valid_mac` text NOT NULL,
  `status` enum('active','suspended','expired','reissued','pending') NOT NULL default 'active',
  `client_reissues` bigint(22) NOT NULL default '0',
  `enable_clustering` enum('no','yes') NOT NULL default 'no',
  `created` int(10) NOT NULL default '0',
  `activated` int(10) NOT NULL default '0',
  `expires` varchar(10) NOT NULL default '0',
  `local_expires` varchar(10) NOT NULL default '0',
  `notes` text NOT NULL,
  PRIMARY KEY  (`license_id`),
  KEY `licensing_id` (`licensing_id`),
  KEY `client_id` (`client_id`),
  KEY `cart_id` (`cart_id`),
  KEY `order_id` (`order_id`),
  KEY `product_id` (`product_id`),
  KEY `profile_id` (`profile_id`),
  KEY `status` (`status`),
  KEY `client_reissues` (`client_reissues`),
  KEY `created` (`created`),
  KEY `activated` (`activated`),
  KEY `expires` (`expires`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_license`
--


--
-- Table structure for table `phpaudit_license_log`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_license_log` (
  `log_id` bigint(22) unsigned NOT NULL auto_increment,
  `license_key` text NOT NULL,
  `license_status` enum('active','suspended','expired','reissued','unknown') NOT NULL default 'unknown',
  `access_directory` varchar(255) NOT NULL default '',
  `access_ip` varchar(255) NOT NULL default '',
  `access_host` varchar(255) NOT NULL default '',
  `access_mac` varchar(17) NOT NULL default '',
  `created` int(10) NOT NULL default '0',
  `flagged` enum('no','yes') NOT NULL default 'no',
  `flagged_reason` text NOT NULL,
  PRIMARY KEY  (`log_id`),
  KEY `license_status` (`license_status`),
  KEY `access_directory` (`access_directory`),
  KEY `access_ip` (`access_ip`),
  KEY `access_host` (`access_host`),
  KEY `access_mac` (`access_mac`),
  KEY `created` (`created`),
  KEY `flagged` (`flagged`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_license_log`
--


--
-- Table structure for table `phpaudit_licensing_types`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_licensing_types` (
  `licensing_id` bigint(22) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `prefix` varchar(255) NOT NULL default '',
  `prefix_seperator` char(1) NOT NULL default '-',
  `license_length` int(2) NOT NULL default '0',
  `term` tinyint(6) NOT NULL default '1',
  `expires` enum('never','minute','hour','day','month','year') NOT NULL default 'never',
  `local_expire_term` int(6) NOT NULL default '0',
  `local_expires` enum('never','minute','hour','day','month','year') NOT NULL default 'never',
  `start_timer` enum('created','activated') NOT NULL default 'created',
  `client_reissues` enum('yes','no') NOT NULL default 'yes',
  `license_type` enum('per_install','per_site','per_server') NOT NULL default 'per_install',
  `license_method` enum('remote_sockets','remote_curl','fopen','remote_local_sockets','remote_local_curl','fopen_local','local') NOT NULL default 'remote_sockets',
  `directory_conflict` enum('yes','no') NOT NULL default 'yes',
  `enable_free_trial` enum('no','yes') NOT NULL default 'no',
  `host_conflict` enum('yes','no') NOT NULL default 'yes',
  `ip_conflict` enum('yes','no') NOT NULL default 'yes',
  `mac_conflict` enum('yes','no') NOT NULL default 'yes',
  `custom_fields` text NOT NULL,
  `created` int(16) NOT NULL default '0',
  PRIMARY KEY  (`licensing_id`),
  KEY `name` (`name`),
  KEY `prefix` (`prefix`),
  KEY `prefix_seperator` (`prefix_seperator`),
  KEY `license_length` (`license_length`),
  KEY `term` (`term`),
  KEY `expires` (`expires`),
  KEY `local_expire_term` (`local_expire_term`),
  KEY `local_expires` (`local_expires`),
  KEY `start_timer` (`start_timer`),
  KEY `client_reissues` (`client_reissues`),
  KEY `license_type` (`license_type`),
  KEY `license_method` (`license_method`),
  KEY `directory_conflict` (`directory_conflict`),
  KEY `host_conflict` (`host_conflict`),
  KEY `ip_conflict` (`ip_conflict`),
  KEY `mac_conflict` (`mac_conflict`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_licensing_types`
--


--
-- Table structure for table `phpaudit_my_notes`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_my_notes` (
  `uid` bigint(22) NOT NULL default '0',
  `notes` text NOT NULL,
  KEY `uid` (`uid`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_my_notes`
--


--
-- Table structure for table `phpaudit_order`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_order` (
  `order_id` bigint(22) unsigned NOT NULL auto_increment,
  `client_id` bigint(22) NOT NULL default '0',
  `cart_id` varchar(8) NOT NULL default '0',
  `product_id` bigint(22) NOT NULL default '0',
  `profile_id` bigint(22) NOT NULL default '0',
  `log_id` text NOT NULL,
  `order_array` text NOT NULL,
  `browse_extras` bigint(22) NOT NULL default '0',
  `status` enum('incomplete','pending','active','suspended','cancelled','refunded','fraud') NOT NULL default 'incomplete',
  `created` int(10) NOT NULL default '0',
  PRIMARY KEY  (`order_id`),
  KEY `client_id` (`client_id`),
  KEY `cart_id` (`cart_id`),
  KEY `product_id` (`product_id`),
  KEY `profile_id` (`profile_id`),
  KEY `status` (`status`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_order`
--


--
-- Table structure for table `phpaudit_order_revisions`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_order_revisions` (
  `revision_id` bigint(22) unsigned NOT NULL auto_increment,
  `order_id` bigint(22) NOT NULL default '0',
  `client_id` bigint(22) NOT NULL default '0',
  `cart_id` varchar(8) NOT NULL default '0',
  `product_id` bigint(22) NOT NULL default '0',
  `profile_id` bigint(22) NOT NULL default '0',
  `order_array` text NOT NULL,
  `status` enum('pending','active','suspended','cancelled','refunded','archived','fraud','deleted') NOT NULL default 'pending',
  `created` int(10) NOT NULL default '0',
  `changed` int(10) NOT NULL default '0',
  `changed_by` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`revision_id`),
  KEY `order_id` (`order_id`),
  KEY `client_id` (`client_id`),
  KEY `cart_id` (`cart_id`),
  KEY `product_id` (`product_id`),
  KEY `profile_id` (`profile_id`),
  KEY `status` (`status`),
  KEY `created` (`created`),
  KEY `changed` (`changed`),
  KEY `changed_by` (`changed_by`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_order_revisions`
--


--
-- Table structure for table `phpaudit_payment_processors`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_payment_processors` (
  `processor_id` bigint(22) unsigned NOT NULL auto_increment,
  `processor_key` varchar(32) NOT NULL default '',
  `processor_name` varchar(255) NOT NULL default '',
  `processor_image` varchar(255) NOT NULL default '',
  `admin_file` varchar(255) NOT NULL default '',
  `processor_file` varchar(255) NOT NULL default '',
  `return_file` varchar(255) NOT NULL default '0',
  `global_queue_file` varchar(255) NOT NULL default '',
  `sql_file` varchar(255) NOT NULL default '',
  `enabled` enum('no','yes') NOT NULL default 'no',
  PRIMARY KEY  (`processor_id`),
  KEY `processor_key` (`processor_key`),
  KEY `processor_name` (`processor_name`),
  KEY `processor_image` (`processor_image`),
  KEY `admin_file` (`admin_file`),
  KEY `processor_file` (`processor_file`),
  KEY `return_file` (`return_file`),
  KEY `sql_file` (`sql_file`),
  KEY `enabled` (`enabled`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_payment_processors`
--

INSERT INTO `phpaudit_payment_processors` VALUES (10,'f9912b7a60c3474e44fd931d067f3a8b','2Checkout','','2co-1.0.0-admin.php','2co-1.0.0-processor.php','2co-1.0.0-return.php','','2co-1.0.0-sql.php','no');
INSERT INTO `phpaudit_payment_processors` VALUES (11,'194636c170d44627a36e35bfa63e6c60','Paypal','','paypal-1.0.0-admin.php','paypal-1.0.0-processor.php','paypal-1.0.0-return.php','','paypal-1.0.0-sql.php','no');
INSERT INTO `phpaudit_payment_processors` VALUES (12,'36c8b5707eb7106ab3acf5c47b20db0d','Authorize.net','','authorize.net-1.0.0-admin.php','authorize.net-1.0.0-processor.php','authorize.net-1.0.0-return.php','','authorize.net-1.0.0-sql.php','no');
INSERT INTO `phpaudit_payment_processors` VALUES (13,'36610268559c63603b520492fc9b8ba9','Stormpay','','stormpay-1.0.0-admin.php','stormpay-1.0.0-processor.php','stormpay-1.0.0-return.php','','stormpay-1.0.0-sql.php','no');
INSERT INTO `phpaudit_payment_processors` VALUES (14,'36c8b5707eb7106ab3acf5c47b20db0d','Bluepay','','bluepay-1.0.0-admin.php','','0','','bluepay-1.0.0-sql.php','no');
INSERT INTO `phpaudit_payment_processors` VALUES (15,'030480dc3540a214a4f9bf5925760c8a','Offline Credit Card','','offline_credit_card-1.0.0-admin.php','','0','','offline_credit_card-1.0.0-sql.php','no');
INSERT INTO `phpaudit_payment_processors` VALUES (16,'454058fa5a8ce335417cc73c3d7d0bd6','Mail-in Payment','','snailmail-1.0.0-admin.php','snailmail-1.0.0-processor.php','','','snailmail-1.0.0-sql.php','no');
INSERT INTO `phpaudit_payment_processors` VALUES (18,'c8da4a3d742cd66a1fc4570a3c9dd839','Worldpay','','worldpay-1.0-admin.php','','0','','worldpay-1.0-sql.php','no');
INSERT INTO `phpaudit_payment_processors` VALUES (19,'c06927889fd574a4eef8a1c9e5025f7f','Linkpoint','','linkpoint-1.0.0-admin.php','linkpoint-1.0.0-processor.php','linkpoint-1.0.0-return.php','','linkpoint-1.0.0-sql.php','no');

--
-- Table structure for table `phpaudit_processor_attributes`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_processor_attributes` (
  `processor_key` varchar(32) NOT NULL default '',
  `attr_key` varchar(255) NOT NULL default '',
  `attr_value` blob NOT NULL,
  `required` enum('yes','no') NOT NULL default 'yes',
  KEY `processor_key` (`processor_key`),
  KEY `attr_key` (`attr_key`),
  KEY `required` (`required`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_processor_attributes`
--

INSERT INTO `phpaudit_processor_attributes` VALUES ('f9912b7a60c3474e44fd931d067f3a8b','currency','&�����T�M%��OH\"�','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('f9912b7a60c3474e44fd931d067f3a8b','_2co_id','��i[�.�����)�UN','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('f9912b7a60c3474e44fd931d067f3a8b','secret_phrase','��M%SH��y㒵��','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('f9912b7a60c3474e44fd931d067f3a8b','test_mode','�І��&GeD]=��','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('f9912b7a60c3474e44fd931d067f3a8b','version','jS[�\0͕��[ZyX`','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','currency','�>6��ƍN\"��4��
�u���4o����=h%\rw�G{gC�l(`#&','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','paypal_id','�BX�%�P�j�-�)=U�?K�+�M�:.��$K','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','logo','`�p��
#�3�\"\0�m','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Canceled_Reversal','�<}��|8%���\r����','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Denied','N5U�ItL��o�cA','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Failed','�<}��|8%���\r����','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Pending_address','=��1Q8�	�U�@�','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Pending_echeck','=��1Q8�	�U�@�','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Pending_intl','=��1Q8�	�U�@�','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Pending_multi_currency','=��1Q8�	�U�@�','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Pending_unilateral','=��1Q8�	�U�@�','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Pending_upgrade','=��1Q8�	�U�@�','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Pending_verify','=��1Q8�	�U�@�','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Pending_other','=��1Q8�	�U�@�','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Refunded_buyer_complaint','�<}��|8%���\r����','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Refunded_chargeback','�<}��|8%���\r����','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Refunded_guarantee','�<}��|8%���\r����','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Refunded_refund','�<}��|8%���\r����','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Refunded_other','�<}��|8%���\r����','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Reversed_buyer_complaint','�<}��|8%���\r����','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Reversed_chargeback','�<}��|8%���\r����','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Reversed_guarantee','�<}��|8%���\r����','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Reversed_refund','�<}��|8%���\r����','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('194636c170d44627a36e35bfa63e6c60','Reversed_other','�<}��|8%���\r����','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('36c8b5707eb7106ab3acf5c47b20db0d','x_login','','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('36c8b5707eb7106ab3acf5c47b20db0d','x_password','','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('36c8b5707eb7106ab3acf5c47b20db0d','x_demo_mode','���ۡy��)��M0�\r�','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('36c8b5707eb7106ab3acf5c47b20db0d','x_gateway','�{􍊅
>�HB���\07Ø�D��V �FqȚ��~���=s^������}�.���l2���r\n�d�\'','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('36c8b5707eb7106ab3acf5c47b20db0d','x_currency','','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('36610268559c63603b520492fc9b8ba9','currency','&�����T�M%��OH\"�','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('36610268559c63603b520492fc9b8ba9','stormpay_id','��u��\0KzR���䇎}\n�s��Rv���7���','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('36610268559c63603b520492fc9b8ba9','secret_code',' ��a���%��H�','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('36610268559c63603b520492fc9b8ba9','test_mode','�І��&GeD]=��','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('36610268559c63603b520492fc9b8ba9','CANCEL','N5U�ItL��o�cA','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('36610268559c63603b520492fc9b8ba9','CHARGEBACK','N5U�ItL��o�cA','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('36610268559c63603b520492fc9b8ba9','REFUND','N5U�ItL��o�cA','no');
INSERT INTO `phpaudit_processor_attributes` VALUES ('030480dc3540a214a4f9bf5925760c8a','status','`ʌ)�e�,�r�^�\\','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('454058fa5a8ce335417cc73c3d7d0bd6','status','`ʌ)�e�,�r�^�\\','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('c8da4a3d742cd66a1fc4570a3c9dd839','currency','�>6��ƍN\"��4��
�u���4o����=h%\rw�G{gC�l(`#&','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('c8da4a3d742cd66a1fc4570a3c9dd839','worldpay_id','^c����U>
/<7','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('c8da4a3d742cd66a1fc4570a3c9dd839','callbackPW','
}�_�-����v�YJ� �`��:���#��b�','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('c8da4a3d742cd66a1fc4570a3c9dd839','callbackresp','J՘хIfL<W!L��=�wM{%�P)!k\\S�`˄(��Ϛ��x��p�Ph�k݆~�gur�%)��I��9�,5H�$��7+�ڇ�/�/2�~g³ؘL��S�AC#�\0��c�x��B\'�8x��Ǚ���3����H��bP��%�u�\0,����X!���y���A*��!��&�	V&U#hgIKЂ��l��{Wbrxc~7q�7�o`Cb9�uˋ����\'������箘�:�a,�mC%R�=	A�>6x���k�S� ��5��E�D�)�y~��>~a�Z�M-�R���G.�\r�$��DͳQ�5���U@d�q�#A��H���<#��)��7��N1ד�����-�g��u�lA��Y=���.�7p�W{�:4�A�2{!��?\0rD�*f��c$���s\Ze�<I4u��]�}�c����|� ~���V~�	���{uB ��\rQ-f�{yJ%��~�gtm��1�|�0y[�,��	sB0�o���*��#w���Ӯ�}�oK!�-3����/C#<2sHun}J','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('c06927889fd574a4eef8a1c9e5025f7f','lp_storeid','','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('c06927889fd574a4eef8a1c9e5025f7f','lp_type','N��KУأb�1','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('c06927889fd574a4eef8a1c9e5025f7f','lp_pemlocation','','yes');
INSERT INTO `phpaudit_processor_attributes` VALUES ('c06927889fd574a4eef8a1c9e5025f7f','lp_debugging',',jퟻ�*�����L\'r','yes');

--
-- Table structure for table `phpaudit_processor_log`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_processor_log` (
  `log_id` bigint(22) unsigned NOT NULL auto_increment,
  `gateway` varchar(255) NOT NULL default '',
  `return_data` text NOT NULL,
  `method` varchar(5) NOT NULL default '',
  `created` int(10) NOT NULL default '0',
  `transaction_id` varchar(255) NOT NULL default '',
  `subscription_id` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`log_id`),
  KEY `method` (`method`),
  KEY `created` (`created`),
  KEY `transaction_id` (`transaction_id`),
  KEY `subscription_id` (`subscription_id`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_processor_log`
--


--
-- Table structure for table `phpaudit_product_addons`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_product_addons` (
  `addon_id` bigint(22) unsigned NOT NULL auto_increment,
  `addon_name` varchar(255) NOT NULL default '',
  `addon_description` text NOT NULL,
  `addon_type` enum('free','one_time','recurring') NOT NULL default 'free',
  `addon_cost` decimal(10,2) NOT NULL default '0.00',
  `created` int(20) NOT NULL default '0',
  `download_array` text NOT NULL,
  PRIMARY KEY  (`addon_id`),
  KEY `addon_name` (`addon_name`),
  KEY `addon_type` (`addon_type`),
  KEY `addon_cost` (`addon_cost`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_product_addons`
--


--
-- Table structure for table `phpaudit_products`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_products` (
  `product_id` bigint(22) unsigned NOT NULL auto_increment,
  `product_status` enum('public','private') NOT NULL default 'public',
  `pricing_array` text NOT NULL,
  `release` enum('instant','approve') NOT NULL default 'instant',
  `min_purchase` int(3) NOT NULL default '1',
  `max_purchase` int(3) NOT NULL default '20',
  `licensing_id` bigint(22) NOT NULL default '0',
  `license_qty` int(3) NOT NULL default '1',
  `secret_key` varchar(32) NOT NULL default '',
  `email_id` bigint(22) NOT NULL default '0',
  `cc_email` text NOT NULL,
  `product_name` varchar(255) NOT NULL default '',
  `product_summary` text NOT NULL,
  `product_description` text NOT NULL,
  `download_array` text NOT NULL,
  `update_array` text NOT NULL,
  `upgrade_array` text NOT NULL,
  `support_array` text NOT NULL,
  `agreement_array` text NOT NULL,
  `addon_array` text NOT NULL,
  `coupon_array` text NOT NULL,
  `created` int(16) NOT NULL default '0',
  PRIMARY KEY  (`product_id`),
  KEY `product_status` (`product_status`),
  KEY `release` (`release`),
  KEY `licensing_id` (`licensing_id`),
  KEY `license_qty` (`license_qty`),
  KEY `secret_key` (`secret_key`),
  KEY `email_id` (`email_id`),
  KEY `product_name` (`product_name`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_products`
--


--
-- Table structure for table `phpaudit_profiles`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_profiles` (
  `profile_id` bigint(22) unsigned NOT NULL auto_increment,
  `group_id` bigint(22) NOT NULL default '0',
  `valid_for` blob NOT NULL,
  `use_tos` bigint(22) NOT NULL default '0',
  `profile_name` varchar(255) NOT NULL default '',
  `php_as_cgi` enum('yes','no') NOT NULL default 'yes',
  `license` varchar(255) NOT NULL default '',
  `http_web` varchar(255) NOT NULL default '',
  `http_images` varchar(255) NOT NULL default '',
  `default_email` varchar(255) NOT NULL default '',
  `site_name` varchar(255) NOT NULL default '',
  `default_from` varchar(255) NOT NULL default '',
  `email_transport` enum('smtp','php_mail') NOT NULL default 'smtp',
  `smtp_port` enum('25','26') NOT NULL default '25',
  `smtp_primary_host` varchar(255) NOT NULL default '',
  `smtp_secondary_host` varchar(255) NOT NULL default '',
  `smtp_username` varchar(255) NOT NULL default '',
  `smtp_password` varchar(255) NOT NULL default '',
  `email_signature` varchar(255) NOT NULL default '',
  `time_format` varchar(50) NOT NULL default '',
  `date_format` varchar(50) NOT NULL default '',
  `base_ops` text NOT NULL,
  `currency` varchar(6) NOT NULL default 'USD',
  `currency_symbol` char(3) NOT NULL default '$',
  `processor_array` text NOT NULL,
  `tax_array` text NOT NULL,
  `ion` text NOT NULL,
  `created` int(16) NOT NULL default '0',
  PRIMARY KEY  (`profile_id`),
  KEY `use_tos` (`use_tos`),
  KEY `profile_name` (`profile_name`),
  KEY `php_as_cgi` (`php_as_cgi`),
  KEY `license` (`license`),
  KEY `http_web` (`http_web`),
  KEY `http_images` (`http_images`),
  KEY `default_email` (`default_email`),
  KEY `site_name` (`site_name`),
  KEY `default_from` (`default_from`),
  KEY `time_format` (`time_format`),
  KEY `date_format` (`date_format`),
  KEY `currency` (`currency`),
  KEY `currency_symbol` (`currency_symbol`),
  KEY `created` (`created`),
  KEY `email_signature` (`email_signature`),
  KEY `email_transport` (`email_transport`),
  KEY `smtp_port` (`smtp_port`),
  KEY `smtp_primary_host` (`smtp_primary_host`),
  KEY `smtp_secondary_host` (`smtp_secondary_host`),
  KEY `smtp_username` (`smtp_username`),
  KEY `smtp_password` (`smtp_password`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_profiles`
--


--
-- Table structure for table `phpaudit_public_config`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_public_config` (
  `config_key_pub` varchar(255) NOT NULL default '',
  `config_value_pub` longtext NOT NULL,
  `common_name` varchar(255) NOT NULL default '',
  `required` tinyint(1) NOT NULL default '0',
  KEY `config_key_pub` (`config_key_pub`),
  KEY `common_name` (`common_name`),
  KEY `required` (`required`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_public_config`
--


--
-- Table structure for table `phpaudit_register`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_register` (
  `register_id` bigint(22) unsigned NOT NULL auto_increment,
  `invoice_id` bigint(22) NOT NULL default '0',
  `profile_id` bigint(22) NOT NULL default '0',
  `client_id` bigint(22) NOT NULL default '0',
  `order_id` bigint(22) NOT NULL default '0',
  `cart_id` varchar(8) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `amount` decimal(10,2) NOT NULL default '0.00',
  `transaction_type` enum('due','paid','credit','reverse') NOT NULL default 'due',
  `subscription_id` varchar(75) NOT NULL default '',
  `transaction_id` varchar(75) NOT NULL default '',
  `processor` varchar(32) NOT NULL default '0',
  `created` int(10) NOT NULL default '0',
  PRIMARY KEY  (`register_id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `profile_id` (`profile_id`),
  KEY `client_id` (`client_id`),
  KEY `order_id` (`order_id`),
  KEY `cart_id` (`cart_id`),
  KEY `description` (`description`),
  KEY `amount` (`amount`),
  KEY `transaction_type` (`transaction_type`),
  KEY `subscription_id` (`subscription_id`),
  KEY `transaction_id` (`transaction_id`),
  KEY `processor` (`processor`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_register`
--


--
-- Table structure for table `phpaudit_register_revisions`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_register_revisions` (
  `revision_id` bigint(22) unsigned NOT NULL auto_increment,
  `register_id` bigint(22) NOT NULL default '0',
  `invoice_id` bigint(22) NOT NULL default '0',
  `profile_id` bigint(22) NOT NULL default '0',
  `client_id` bigint(22) NOT NULL default '0',
  `order_id` bigint(22) NOT NULL default '0',
  `cart_id` varchar(8) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `amount` decimal(10,2) NOT NULL default '0.00',
  `transaction_type` enum('due','paid','credit','reverse') NOT NULL default 'due',
  `subscription_id` varchar(75) NOT NULL default '',
  `transaction_id` varchar(75) NOT NULL default '',
  `processor` varchar(32) NOT NULL default '0',
  `created` int(10) NOT NULL default '0',
  `changed` int(10) NOT NULL default '0',
  `changed_by` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`revision_id`),
  KEY `register_id` (`register_id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `profile_id` (`profile_id`),
  KEY `client_id` (`client_id`),
  KEY `order_id` (`order_id`),
  KEY `cart_id` (`cart_id`),
  KEY `description` (`description`),
  KEY `amount` (`amount`),
  KEY `transaction_type` (`transaction_type`),
  KEY `subscription_id` (`subscription_id`),
  KEY `transaction_id` (`transaction_id`),
  KEY `processor` (`processor`),
  KEY `created` (`created`),
  KEY `changed` (`changed`),
  KEY `changed_by` (`changed_by`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_register_revisions`
--


--
-- Table structure for table `phpaudit_sessions`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_sessions` (
  `session_id` varchar(32) NOT NULL default '',
  `session_data` text NOT NULL,
  `created` int(16) NOT NULL default '0',
  KEY `session_id` (`session_id`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_sessions`
--


--
-- Table structure for table `phpaudit_support_package`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_support_package` (
  `support_id` bigint(22) unsigned NOT NULL auto_increment,
  `support_package_name` varchar(255) NOT NULL default '',
  `support_package_terms` int(10) NOT NULL default '0',
  `support_expires` enum('never','hour','minute','day','month','year') NOT NULL default 'never',
  `support_package_cost` decimal(10,2) NOT NULL default '0.00',
  `checkbox_status` enum('checked','unchecked','forced') NOT NULL default 'unchecked',
  `show_in` enum('all','none','order','extras') NOT NULL default 'all',
  `created` int(16) NOT NULL default '0',
  PRIMARY KEY  (`support_id`),
  KEY `support_package_name` (`support_package_name`),
  KEY `support_package_terms` (`support_package_terms`),
  KEY `support_expires` (`support_expires`),
  KEY `support_package_cost` (`support_package_cost`),
  KEY `checkbox_status` (`checkbox_status`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_support_package`
--


--
-- Table structure for table `phpaudit_taxes`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_taxes` (
  `tax_id` bigint(22) unsigned NOT NULL auto_increment,
  `tax_label` varchar(255) NOT NULL default '',
  `state` char(2) NOT NULL default '',
  `country` char(2) NOT NULL default '',
  `province` varchar(255) NOT NULL default '',
  `city` varchar(255) NOT NULL default '',
  `tax_amount` decimal(3,2) NOT NULL default '0.00',
  PRIMARY KEY  (`tax_id`),
  KEY `tax_label` (`tax_label`),
  KEY `state` (`state`),
  KEY `country` (`country`),
  KEY `province` (`province`),
  KEY `city` (`city`),
  KEY `tax_amount` (`tax_amount`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_taxes`
--


--
-- Table structure for table `phpaudit_upgrade_package`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpaudit_upgrade_package` (
  `upgrade_id` bigint(22) unsigned NOT NULL auto_increment,
  `upgrade_package_name` varchar(255) NOT NULL default '',
  `upgrade_package_terms` int(10) NOT NULL default '0',
  `upgrade_expires` enum('never','hour','minute','day','month','year') NOT NULL default 'never',
  `upgrade_package_cost` decimal(10,2) NOT NULL default '0.00',
  `checkbox_status` enum('checked','unchecked','forced') NOT NULL default 'unchecked',
  `show_in` enum('all','none','order','extras') NOT NULL default 'all',
  `created` int(16) NOT NULL default '0',
  PRIMARY KEY  (`upgrade_id`),
  KEY `upgrade_package_name` (`upgrade_package_name`),
  KEY `upgrade_package_terms` (`upgrade_package_terms`),
  KEY `upgrade_expires` (`upgrade_expires`),
  KEY `upgrade_package_cost` (`upgrade_package_cost`),
  KEY `checkbox_status` (`checkbox_status`),
  KEY `created` (`created`)
) TYPE=InnoDB;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `phpaudit_upgrade_package`
--

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2014-01-01 16:26:51