--
-- Host: localhost    Database: radius_099
-- ------------------------------------------------------


--
-- Table structure for table `batch_history`
--

CREATE TABLE `batch_history` (
  `id` int(32) NOT NULL auto_increment,
  `batch_name` varchar(64) default NULL COMMENT 'an identifier name of the batch instance',
  `batch_description` varchar(256) default NULL COMMENT 'general description of the entry',
  `hotspot_id` int(32) default '0' COMMENT 'the hotspot business id associated with this batch instance',
  `batch_status` varchar(128) NOT NULL default 'Pending' COMMENT 'the batch status',
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`),
  KEY `batch_name` (`batch_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `batch_history`
--


--
-- Table structure for table `billing_history`
--

CREATE TABLE `billing_history` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `username` varchar(128) default NULL,
  `planId` int(32) default NULL,
  `billAmount` varchar(200) default NULL,
  `billAction` varchar(128) NOT NULL default 'Unavailable',
  `billPerformer` varchar(200) default NULL,
  `billReason` varchar(200) default NULL,
  `paymentmethod` varchar(200) default NULL,
  `cash` varchar(200) default NULL,
  `creditcardname` varchar(200) default NULL,
  `creditcardnumber` varchar(200) default NULL,
  `creditcardverification` varchar(200) default NULL,
  `creditcardtype` varchar(200) default NULL,
  `creditcardexp` varchar(200) default NULL,
  `coupon` varchar(200) default NULL,
  `discount` varchar(200) default NULL,
  `notes` varchar(200) default NULL,
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`),
  KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `billing_history`
--


--
-- Table structure for table `billing_merchant`
--

CREATE TABLE `billing_merchant` (
  `id` int(8) NOT NULL auto_increment,
  `username` varchar(128) NOT NULL default '',
  `password` varchar(128) NOT NULL default '',
  `mac` varchar(200) NOT NULL default '',
  `pin` varchar(200) NOT NULL default '',
  `txnId` varchar(200) NOT NULL default '',
  `planName` varchar(128) NOT NULL default '',
  `planId` int(32) NOT NULL,
  `quantity` varchar(200) NOT NULL default '',
  `business_email` varchar(200) NOT NULL default '',
  `business_id` varchar(200) NOT NULL default '',
  `txn_type` varchar(200) NOT NULL default '',
  `txn_id` varchar(200) NOT NULL default '',
  `payment_type` varchar(200) NOT NULL default '',
  `payment_tax` varchar(200) NOT NULL default '',
  `payment_cost` varchar(200) NOT NULL default '',
  `payment_fee` varchar(200) NOT NULL default '',
  `payment_total` varchar(200) NOT NULL default '',
  `payment_currency` varchar(200) NOT NULL default '',
  `first_name` varchar(200) NOT NULL default '',
  `last_name` varchar(200) NOT NULL default '',
  `payer_email` varchar(200) NOT NULL default '',
  `payer_address_name` varchar(200) NOT NULL default '',
  `payer_address_street` varchar(200) NOT NULL default '',
  `payer_address_country` varchar(200) NOT NULL default '',
  `payer_address_country_code` varchar(200) NOT NULL default '',
  `payer_address_city` varchar(200) NOT NULL default '',
  `payer_address_state` varchar(200) NOT NULL default '',
  `payer_address_zip` varchar(200) NOT NULL default '',
  `payment_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `payment_status` varchar(200) NOT NULL default '',
  `pending_reason` varchar(200) NOT NULL default '',
  `reason_code` varchar(200) NOT NULL default '',
  `receipt_ID` varchar(200) NOT NULL default '',
  `payment_address_status` varchar(200) NOT NULL default '',
  `vendor_type` varchar(200) NOT NULL default '',
  `payer_status` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `billing_merchant`
--


--
-- Table structure for table `billing_paypal`
--

CREATE TABLE `billing_paypal` (
  `id` int(8) NOT NULL auto_increment,
  `username` varchar(128) default NULL,
  `password` varchar(128) default NULL,
  `mac` varchar(200) default NULL,
  `pin` varchar(200) default NULL,
  `txnId` varchar(200) default NULL,
  `planName` varchar(128) default NULL,
  `planId` varchar(200) default NULL,
  `quantity` varchar(200) default NULL,
  `receiver_email` varchar(200) default NULL,
  `business` varchar(200) default NULL,
  `tax` varchar(200) default NULL,
  `mc_gross` varchar(200) default NULL,
  `mc_fee` varchar(200) default NULL,
  `mc_currency` varchar(200) default NULL,
  `first_name` varchar(200) default NULL,
  `last_name` varchar(200) default NULL,
  `payer_email` varchar(200) default NULL,
  `address_name` varchar(200) default NULL,
  `address_street` varchar(200) default NULL,
  `address_country` varchar(200) default NULL,
  `address_country_code` varchar(200) default NULL,
  `address_city` varchar(200) default NULL,
  `address_state` varchar(200) default NULL,
  `address_zip` varchar(200) default NULL,
  `payment_date` datetime default NULL,
  `payment_status` varchar(200) default NULL,
  `payment_address_status` varchar(200) default NULL,
  `payer_status` varchar(200) default NULL,
  PRIMARY KEY  (`id`),
  KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `billing_paypal`
--


--
-- Table structure for table `billing_plans`
--

CREATE TABLE `billing_plans` (
  `id` int(8) NOT NULL auto_increment,
  `planName` varchar(128) default NULL,
  `planId` varchar(128) default NULL,
  `planType` varchar(128) default NULL,
  `planTimeBank` varchar(128) default NULL,
  `planTimeType` varchar(128) default NULL,
  `planTimeRefillCost` varchar(128) default NULL,
  `planBandwidthUp` varchar(128) default NULL,
  `planBandwidthDown` varchar(128) default NULL,
  `planTrafficTotal` varchar(128) default NULL,
  `planTrafficUp` varchar(128) default NULL,
  `planTrafficDown` varchar(128) default NULL,
  `planTrafficRefillCost` varchar(128) default NULL,
  `planRecurring` varchar(128) default NULL,
  `planRecurringPeriod` varchar(128) default NULL,
  `planRecurringBillingSchedule` varchar(128) NOT NULL default 'Fixed',
  `planCost` varchar(128) default NULL,
  `planSetupCost` varchar(128) default NULL,
  `planTax` varchar(128) default NULL,
  `planCurrency` varchar(128) default NULL,
  `planGroup` varchar(128) default NULL,
  `planActive` varchar(32) NOT NULL default 'yes',
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`),
  KEY `planName` (`planName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `billing_plans`
--


--
-- Table structure for table `billing_plans_profiles`
--

CREATE TABLE `billing_plans_profiles` (
  `id` int(32) NOT NULL auto_increment,
  `plan_name` varchar(128) NOT NULL COMMENT 'the name of the plan',
  `profile_name` varchar(256) default NULL COMMENT 'the profile/group name',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `billing_plans_profiles`
--


--
-- Table structure for table `billing_rates`
--

CREATE TABLE `billing_rates` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `rateName` varchar(128) NOT NULL default '',
  `rateType` varchar(128) NOT NULL default '',
  `rateCost` int(32) NOT NULL default '0',
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`),
  KEY `rateName` (`rateName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `billing_rates`
--


--
-- Table structure for table `dictionary`
--

CREATE TABLE `dictionary` (
  `id` int(10) NOT NULL auto_increment,
  `Type` varchar(30) default NULL,
  `Attribute` varchar(64) default NULL,
  `Value` varchar(64) default NULL,
  `Format` varchar(20) default NULL,
  `Vendor` varchar(32) default NULL,
  `RecommendedOP` varchar(32) default NULL,
  `RecommendedTable` varchar(32) default NULL,
  `RecommendedHelper` varchar(32) default NULL,
  `RecommendedTooltip` varchar(512) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9718 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dictionary`
--



--
-- Table structure for table `hotspots`
--

CREATE TABLE `hotspots` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  `mac` varchar(200) default NULL,
  `geocode` varchar(200) default NULL,
  `owner` varchar(200) default NULL,
  `email_owner` varchar(200) default NULL,
  `manager` varchar(200) default NULL,
  `email_manager` varchar(200) default NULL,
  `address` varchar(200) default NULL,
  `company` varchar(200) default NULL,
  `phone1` varchar(200) default NULL,
  `phone2` varchar(200) default NULL,
  `type` varchar(200) default NULL,
  `companywebsite` varchar(200) default NULL,
  `companyemail` varchar(200) default NULL,
  `companycontact` varchar(200) default NULL,
  `companyphone` varchar(200) default NULL,
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`),
  KEY `name` (`name`),
  KEY `mac` (`mac`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hotspots`
--


--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `id` int(32) NOT NULL auto_increment,
  `user_id` int(32) default NULL COMMENT 'user id of the userbillinfo table',
  `batch_id` int(32) default NULL COMMENT 'batch id of the batch_history table',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `status_id` int(10) NOT NULL default '1' COMMENT 'the status of the invoice from invoice_status',
  `type_id` int(10) NOT NULL default '1' COMMENT 'the type of the invoice from invoice_type',
  `notes` varchar(128) NOT NULL COMMENT 'general notes/description',
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoice`
--


--
-- Table structure for table `invoice_items`
--

CREATE TABLE `invoice_items` (
  `id` int(32) NOT NULL auto_increment,
  `invoice_id` int(32) NOT NULL COMMENT 'invoice id of the invoices table',
  `plan_id` int(32) default NULL COMMENT 'the plan_id of the billing_plans table',
  `amount` decimal(10,2) NOT NULL default '0.00' COMMENT 'the amount cost of an item',
  `tax_amount` decimal(10,2) NOT NULL default '0.00' COMMENT 'the tax amount for an item',
  `total` decimal(10,2) NOT NULL default '0.00' COMMENT 'the total amount',
  `notes` varchar(128) NOT NULL COMMENT 'general notes/description',
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoice_items`
--


--
-- Table structure for table `invoice_status`
--

CREATE TABLE `invoice_status` (
  `id` int(10) NOT NULL auto_increment,
  `value` varchar(32) NOT NULL default '' COMMENT 'status value',
  `notes` varchar(128) NOT NULL COMMENT 'general notes/description',
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoice_status`
--

INSERT INTO `invoice_status` VALUES (1,'open','','2010-05-27 00:00:00','operator','2010-05-27 00:00:00','operator'),(2,'disputed','','2010-05-27 00:00:00','operator','2010-05-27 00:00:00','operator'),(3,'draft','','2010-05-27 00:00:00','operator','2010-05-27 00:00:00','operator'),(4,'sent','','2010-05-27 00:00:00','operator','2010-05-27 00:00:00','operator'),(5,'paid','','2010-05-27 00:00:00','operator','2010-05-27 00:00:00','operator'),(6,'partial','','2010-05-27 00:00:00','operator','2010-05-27 00:00:00','operator');

--
-- Table structure for table `invoice_type`
--

CREATE TABLE `invoice_type` (
  `id` int(10) NOT NULL auto_increment,
  `value` varchar(32) NOT NULL default '' COMMENT 'type value',
  `notes` varchar(128) NOT NULL COMMENT 'general notes/description',
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoice_type`
--

INSERT INTO `invoice_type` VALUES (1,'Plans','','2010-05-27 00:00:00','operator','2010-05-27 00:00:00','operator'),(2,'Services','','2010-05-27 00:00:00','operator','2010-05-27 00:00:00','operator'),(3,'Consulting','','2010-05-27 00:00:00','operator','2010-05-27 00:00:00','operator');

--
-- Table structure for table `nas`
--

CREATE TABLE `nas` (
  `id` int(10) NOT NULL auto_increment,
  `nasname` varchar(128) collate utf8_unicode_ci NOT NULL,
  `shortname` varchar(32) collate utf8_unicode_ci default NULL,
  `type` varchar(30) collate utf8_unicode_ci default 'other',
  `ports` int(5) default NULL,
  `secret` varchar(60) collate utf8_unicode_ci NOT NULL default 'secret',
  `community` varchar(50) collate utf8_unicode_ci default NULL,
  `description` varchar(200) collate utf8_unicode_ci default 'RADIUS Client',
  PRIMARY KEY  (`id`),
  KEY `nasname` (`nasname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `nas`
--


--
-- Table structure for table `node`
--

CREATE TABLE `node` (
  `id` int(11) NOT NULL auto_increment,
  `time` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT 'Time of last checkin',
  `netid` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `latitude` varchar(20) NOT NULL,
  `longitude` varchar(20) NOT NULL,
  `owner_name` varchar(50) NOT NULL COMMENT 'node owner''s name',
  `owner_email` varchar(50) NOT NULL COMMENT 'node owner''s email address',
  `owner_phone` varchar(25) NOT NULL COMMENT 'node owner''s phone number',
  `owner_address` varchar(100) NOT NULL COMMENT 'node owner''s address',
  `approval_status` varchar(1) NOT NULL COMMENT 'approval status: A (accepted), R (rejected), P (pending)',
  `ip` varchar(20) NOT NULL COMMENT 'ROBIN',
  `mac` varchar(20) NOT NULL COMMENT 'ROBIN',
  `uptime` varchar(100) NOT NULL COMMENT 'ROBIN',
  `robin` varchar(20) NOT NULL COMMENT 'ROBIN: robin version',
  `batman` varchar(20) NOT NULL COMMENT 'ROBIN: batman version',
  `memfree` varchar(20) NOT NULL COMMENT 'ROBIN',
  `nbs` mediumtext NOT NULL COMMENT 'ROBIN: neighbor list',
  `gateway` varchar(20) NOT NULL COMMENT 'ROBIN: nearest gateway',
  `gw-qual` varchar(20) NOT NULL COMMENT 'ROBIN: quality of nearest gateway',
  `routes` mediumtext NOT NULL COMMENT 'ROBIN: route to nearest gateway',
  `users` char(3) NOT NULL COMMENT 'ROBIN: current number of users',
  `kbdown` varchar(20) NOT NULL COMMENT 'ROBIN: downloaded kb',
  `kbup` varchar(20) NOT NULL COMMENT 'ROBIN: uploaded kb',
  `hops` varchar(3) NOT NULL COMMENT 'ROBIN: hops to gateway',
  `rank` varchar(3) NOT NULL COMMENT 'ROBIN: ???, not currently used for anything',
  `ssid` varchar(20) NOT NULL COMMENT 'ROBIN: ssid, not currently used for anything',
  `pssid` varchar(20) NOT NULL COMMENT 'ROBIN: pssid, not currently used for anything',
  `gateway_bit` tinyint(1) NOT NULL COMMENT 'ROBIN derivation: is this node a gateway?',
  `memlow` varchar(20) NOT NULL COMMENT 'ROBIN derivation: lowest reported memory on the node',
  `usershi` char(3) NOT NULL COMMENT 'ROBIN derivation: highest number of users',
  `cpu` float NOT NULL default '0',
  `wan_iface` varchar(128) default NULL,
  `wan_ip` varchar(128) default NULL,
  `wan_mac` varchar(128) default NULL,
  `wan_gateway` varchar(128) default NULL,
  `wifi_iface` varchar(128) default NULL,
  `wifi_ip` varchar(128) default NULL,
  `wifi_mac` varchar(128) default NULL,
  `wifi_ssid` varchar(128) default NULL,
  `wifi_key` varchar(128) default NULL,
  `wifi_channel` varchar(128) default NULL,
  `lan_iface` varchar(128) default NULL,
  `lan_mac` varchar(128) default NULL,
  `lan_ip` varchar(128) default NULL,
  `wan_bup` varchar(128) default NULL,
  `wan_bdown` varchar(128) default NULL,
  `firmware` varchar(128) default NULL,
  `firmware_revision` varchar(128) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `mac` (`mac`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='node database';

--
-- Dumping data for table `node`
--


--
-- Table structure for table `operators_acl`
--

CREATE TABLE `operators_acl` (
  `id` int(32) NOT NULL auto_increment,
  `operator_id` int(32) NOT NULL,
  `file` varchar(128) NOT NULL,
  `access` tinyint(8) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=252 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `operators_acl`
--

INSERT INTO `operators_acl` VALUES (114,6,'acct_custom_query',1),(115,6,'acct_active',1),(116,6,'acct_all',1),(117,6,'acct_ipaddress',1),(118,6,'acct_username',1),(119,6,'acct_date',1),(120,6,'acct_nasipaddress',1),(121,6,'acct_hotspot_accounting',1),(122,6,'acct_hotspot_compare',1),(123,6,'acct_maintenance_cleanup',1),(124,6,'acct_maintenance_delete',1),(125,6,'acct_plans_usage',1),(126,6,'bill_history_query',1),(127,6,'bill_merchant_transactions',1),(128,6,'bill_plans_list',1),(129,6,'bill_plans_del',1),(130,6,'bill_plans_edit',1),(131,6,'bill_plans_new',1),(132,6,'bill_pos_del',1),(133,6,'bill_pos_list',1),(134,6,'bill_pos_new',1),(135,6,'bill_pos_edit',1),(136,6,'bill_rates_date',1),(137,6,'bill_rates_new',1),(138,6,'bill_rates_list',1),(139,6,'bill_rates_del',1),(140,6,'bill_rates_edit',1),(141,6,'config_backup_managebackups',1),(142,6,'config_backup_createbackups',1),(143,6,'config_user',1),(144,6,'config_db',1),(145,6,'config_lang',1),(146,6,'config_interface',1),(147,6,'config_logging',1),(148,6,'config_maint_test_user',1),(149,6,'config_maint_disconnect_user',1),(150,6,'config_operators_list',1),(151,6,'config_operators_new',1),(152,6,'config_operators_del',1),(153,6,'config_operators_edit',1),(154,6,'gis_editmap',1),(155,6,'gis_viewmap',1),(156,6,'graphs_alltime_logins',1),(157,6,'graphs_overall_download',1),(158,6,'graphs_overall_logins',1),(159,6,'graphs_alltime_traffic_compare',1),(160,6,'graphs_overall_upload',1),(161,6,'graphs_logged_users',1),(162,6,'mng_rad_attributes_import',1),(163,6,'mng_rad_attributes_list',1),(164,6,'mng_rad_attributes_edit',1),(165,6,'mng_rad_attributes_del',1),(166,6,'mng_rad_attributes_new',1),(167,6,'mng_rad_attributes_search',1),(168,6,'mng_rad_groupcheck_new',1),(169,6,'mng_rad_groupreply_search',1),(170,6,'mng_rad_groupreply_list',1),(171,6,'mng_rad_groupreply_edit',1),(172,6,'mng_rad_groupcheck_search',1),(173,6,'mng_rad_groupcheck_list',1),(174,6,'mng_rad_groupcheck_edit',1),(175,6,'mng_rad_groupreply_del',1),(176,6,'mng_rad_groupreply_new',1),(177,6,'mng_rad_groupcheck_del',1),(178,6,'mng_hs_edit',1),(179,6,'mng_hs_list',1),(180,6,'mng_hs_del',1),(181,6,'mng_hs_new',1),(182,6,'mng_rad_ippool_new',1),(183,6,'mng_rad_ippool_del',1),(184,6,'mng_rad_ippool_list',1),(185,6,'mng_rad_ippool_edit',1),(186,6,'mng_rad_nas_edit',1),(187,6,'mng_rad_nas_list',1),(188,6,'mng_rad_nas_del',1),(189,6,'mng_rad_nas_new',1),(190,6,'mng_rad_profiles_edit',1),(191,6,'mng_rad_profiles_del',1),(192,6,'mng_rad_profiles_new',1),(193,6,'mng_rad_profiles_duplicate',1),(194,6,'mng_rad_profiles_list',1),(195,6,'mng_rad_proxys_new',1),(196,6,'mng_rad_proxys_del',1),(197,6,'mng_rad_proxys_list',1),(198,6,'mng_rad_proxys_edit',1),(199,6,'mng_rad_realms_new',1),(200,6,'mng_rad_realms_del',1),(201,6,'mng_rad_realms_list',1),(202,6,'mng_rad_realms_edit',1),(203,6,'mng_rad_usergroup_edit',1),(204,6,'mng_rad_usergroup_list_user',1),(205,6,'mng_rad_usergroup_del',1),(206,6,'mng_rad_usergroup_new',1),(207,6,'mng_rad_usergroup_list',1),(208,6,'mng_search',1),(209,6,'mng_del',1),(210,6,'mng_new',1),(211,6,'mng_import_users',1),(212,6,'mng_batch',1),(213,6,'mng_edit',1),(214,6,'mng_new_quick',1),(215,6,'mng_list_all',1),(216,6,'rep_lastconnect',1),(217,6,'rep_online',1),(218,6,'rep_history',1),(219,6,'rep_topusers',1),(220,6,'rep_logs_radius',1),(221,6,'rep_logs_boot',1),(222,6,'rep_logs_system',1),(223,6,'rep_logs_daloradius',1),(224,6,'rep_stat_services',1),(225,6,'rep_stat_server',1),(226,6,'mng_rad_hunt_del',1),(227,6,'mng_rad_hunt_edit',1),(228,6,'mng_rad_hunt_list',1),(229,6,'mng_rad_hunt_new',1),(230,6,'config_mail',1),(231,6,'mng_batch_add',1),(232,6,'mng_batch_list',1),(233,6,'mng_batch_del',1),(234,6,'bill_invoice_list',1),(235,6,'bill_invoice_new',1),(236,6,'bill_invoice_edit',1),(237,6,'bill_invoice_del',1),(238,6,'bill_payment_types_new',1),(239,6,'bill_payment_types_edit',1),(240,6,'bill_payment_types_list',1),(241,6,'bill_payment_types_del',1),(242,6,'bill_payments_list',1),(243,6,'bill_payments_edit',1),(244,6,'bill_payments_new',1),(245,6,'bill_payments_del',1),(246,6,'rep_newusers',1),(247,6,'bill_invoice_report',1),(248,6,'config_reports_dashboard',1),(249,6,'rep_stat_ups',1),(250,6,'rep_stat_raid',1),(251,6,'rep_stat_cron',1);

--
-- Table structure for table `operators_acl_files`
--

CREATE TABLE `operators_acl_files` (
  `id` int(32) NOT NULL auto_increment,
  `file` varchar(128) NOT NULL,
  `category` varchar(128) NOT NULL,
  `section` varchar(128) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=140 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `operators_acl_files`
--

INSERT INTO `operators_acl_files` VALUES (2,'mng_search','Management','Users'),(3,'mng_batch','Management','Users'),(4,'mng_del','Management','Users'),(5,'mng_edit','Management','Users'),(6,'mng_new','Management','Users'),(7,'mng_new_quick','Management','Users'),(8,'mng_import_users','Management','Users'),(9,'mng_list_all','Management','Users'),(10,'mng_hs_del','Management','Hotspot'),(11,'mng_hs_edit','Management','Hotspot'),(12,'mng_hs_new','Management','Hotspot'),(13,'mng_hs_list','Management','Hotspot'),(14,'mng_rad_nas_del','Management','NAS'),(15,'mng_rad_nas_edit','Management','NAS'),(16,'mng_rad_nas_new','Management','NAS'),(17,'mng_rad_nas_list','Management','NAS'),(18,'mng_rad_usergroup_del','Management','UserGroup'),(19,'mng_rad_usergroup_edit','Management','UserGroup'),(20,'mng_rad_usergroup_new','Management','UserGroup'),(21,'mng_rad_usergroup_list_user','Management','UserGroup'),(22,'mng_rad_usergroup_list','Management','UserGroup'),(23,'mng_rad_groupcheck_search','Management','Groups'),(24,'mng_rad_groupcheck_del','Management','Groups'),(25,'mng_rad_groupcheck_list','Management','Groups'),(26,'mng_rad_groupcheck_new','Management','Groups'),(27,'mng_rad_groupcheck_edit','Management','Groups'),(28,'mng_rad_groupreply_search','Management','Groups'),(29,'mng_rad_groupreply_del','Management','Groups'),(30,'mng_rad_groupreply_list','Management','Groups'),(31,'mng_rad_groupreply_new','Management','Groups'),(32,'mng_rad_groupreply_edit','Management','Groups'),(33,'mng_rad_profiles_new','Management','Profiles'),(34,'mng_rad_profiles_edit','Management','Profiles'),(35,'mng_rad_profiles_duplicate','Management','Profiles'),(36,'mng_rad_profiles_del','Management','Profiles'),(37,'mng_rad_profiles_list','Management','Profiles'),(38,'mng_rad_attributes_list','Management','Attributes'),(39,'mng_rad_attributes_new','Management','Attributes'),(40,'mng_rad_attributes_edit','Management','Attributes'),(41,'mng_rad_attributes_search','Management','Attributes'),(42,'mng_rad_attributes_del','Management','Attributes'),(43,'mng_rad_attributes_import','Management','Attributes'),(44,'mng_rad_realms_list','Management','Realms'),(45,'mng_rad_realms_new','Management','Realms'),(46,'mng_rad_realms_edit','Management','Realms'),(47,'mng_rad_realms_del','Management','Realms'),(48,'mng_rad_proxys_list','Management','Proxys'),(49,'mng_rad_proxys_new','Management','Proxys'),(50,'mng_rad_proxys_edit','Management','Proxys'),(51,'mng_rad_proxys_del','Management','Proxys'),(52,'mng_rad_ippool_list','Management','IPPool'),(53,'mng_rad_ippool_new','Management','IPPool'),(54,'mng_rad_ippool_edit','Management','IPPool'),(55,'mng_rad_ippool_del','Management','IPPool'),(56,'rep_topusers','Reporting','Core'),(57,'rep_online','Reporting','Core'),(58,'rep_lastconnect','Reporting','Core'),(59,'rep_history','Reporting','Core'),(60,'rep_logs_radius','Reporting','Logs'),(61,'rep_logs_system','Reporting','Logs'),(62,'rep_logs_boot','Reporting','Logs'),(63,'rep_logs_daloradius','Reporting','Logs'),(64,'rep_stat_services','Reporting','Status'),(65,'rep_stat_server','Reporting','Status'),(66,'acct_active','Accounting','General'),(67,'acct_username','Accounting','General'),(68,'acct_all','Accounting','General'),(69,'acct_date','Accounting','General'),(70,'acct_ipaddress','Accounting','General'),(71,'acct_nasipaddress','Accounting','General'),(72,'acct_hotspot_accounting','Accounting','Hotspot'),(73,'acct_hotspot_compare','Accounting','Hotspot'),(74,'acct_custom_query','Accounting','Custom'),(75,'acct_maintenance_cleanup','Accounting','Maintenance'),(76,'acct_maintenance_delete','Accounting','Maintenance'),(77,'bill_pos_del','Billing','POS'),(78,'bill_pos_new','Billing','POS'),(79,'bill_pos_list','Billing','POS'),(80,'bill_pos_edit','Billing','POS'),(81,'bill_rates_date','Billing','Rates'),(82,'bill_rates_del','Billing','Rates'),(83,'bill_rates_new','Billing','Rates'),(84,'bill_rates_edit','Billing','Rates'),(85,'bill_rates_list','Billing','Rates'),(86,'bill_merchant_transactions','Billing','Merchant'),(87,'bill_plans_del','Billing','Plans'),(88,'bill_plans_new','Billing','Plans'),(89,'bill_plans_edit','Billing','Plans'),(90,'bill_plans_list','Billing','Plans'),(91,'bill_history_query','Billing','History'),(92,'gis_editmap','GIS','General'),(93,'gis_viewmap','GIS','General'),(94,'graphs_alltime_logins','Graphs','General'),(95,'graphs_alltime_traffic_compare','Graphs','General'),(96,'graphs_overall_download','Graphs','General'),(97,'graphs_overall_upload','Graphs','General'),(98,'graphs_overall_logins','Graphs','General'),(99,'graphs_logged_users','Graphs','General'),(100,'config_db','Configuration','Core'),(101,'config_interface','Configuration','Core'),(102,'config_lang','Configuration','Core'),(103,'config_logging','Configuration','Core'),(104,'config_maint_test_user','Configuration','Maintenance'),(105,'config_maint_disconnect_user','Configuration','Maintenance'),(106,'config_operators_del','Configuration','Operators'),(107,'config_operators_list','Configuration','Operators'),(108,'config_operators_edit','Configuration','Operators'),(109,'config_operators_new','Configuration','Operators'),(110,'config_backup_createbackups','Configuration','Backup'),(111,'config_backup_managebackups','Configuration','Backup'),(112,'acct_plans_usage','Accounting','Plans'),(113,'config_user','Configuration','Core'),(114,'mng_rad_hunt_del','Management','HuntGroups'),(115,'mng_rad_hunt_edit','Management','HuntGroups'),(116,'mng_rad_hunt_list','Management','HuntGroups'),(117,'mng_rad_hunt_new','Management','HuntGroups'),(118,'config_mail','Configuration','Core'),(119,'mng_batch_add','Management','Batch'),(120,'mng_batch_list','Management','Batch'),(121,'mng_batch_del','Management','Batch'),(122,'bill_invoice_list','Billing','Invoice'),(123,'bill_invoice_new','Billing','Invoice'),(124,'bill_invoice_edit','Billing','Invoice'),(125,'bill_invoice_del','Billing','Invoice'),(126,'bill_payment_types_new','Billing','Payment Types'),(127,'bill_payment_types_edit','Billing','Payment Types'),(128,'bill_payment_types_list','Billing','Payment Types'),(129,'bill_payment_types_del','Billing','Payment Types'),(130,'bill_payments_list','Billing','Payments'),(131,'bill_payments_edit','Billing','Payments'),(132,'bill_payments_new','Billing','Payments'),(133,'bill_payments_del','Billing','Payments'),(134,'rep_newusers','Reporting','Core'),(135,'bill_invoice_report','Billing','Invoice'),(136,'config_reports_dashboard','Configuration','Reporting'),(137,'rep_stat_ups','Reporting','Status'),(138,'rep_stat_raid','Reporting','Status'),(139,'rep_stat_cron','Reporting','Status');

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(32) NOT NULL auto_increment,
  `invoice_id` int(32) NOT NULL COMMENT 'invoice id of the invoices table',
  `amount` decimal(10,2) NOT NULL COMMENT 'the amount paid',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `type_id` int(10) NOT NULL default '1' COMMENT 'the type of the payment from payment_type',
  `notes` varchar(128) NOT NULL COMMENT 'general notes/description',
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment`
--


--
-- Table structure for table `payment_type`
--

CREATE TABLE `payment_type` (
  `id` int(10) NOT NULL auto_increment,
  `value` varchar(32) NOT NULL default '' COMMENT 'type value',
  `notes` varchar(128) NOT NULL COMMENT 'general notes/description',
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_type`
--

INSERT INTO `payment_type` VALUES (1,'Cash','','2010-05-27 00:00:00','operator','2010-05-27 00:00:00','operator'),(2,'Check','','2010-05-27 00:00:00','operator','2010-05-27 00:00:00','operator'),(3,'Bank Transfer','','2010-05-27 00:00:00','operator','2010-05-27 00:00:00','operator');

--
-- Table structure for table `proxys`
--

CREATE TABLE `proxys` (
  `id` bigint(20) NOT NULL auto_increment,
  `proxyname` varchar(128) default NULL,
  `retry_delay` int(8) default NULL,
  `retry_count` int(8) default NULL,
  `dead_time` int(8) default NULL,
  `default_fallback` int(8) default NULL,
  `creationdate` datetime default NULL,
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default NULL,
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `proxys`
--


--
-- Table structure for table `radacct`
--

CREATE TABLE `radacct` (
  `RadAcctId` bigint(21) NOT NULL auto_increment,
  `AcctSessionId` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `AcctUniqueId` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `UserName` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `Realm` varchar(64) collate utf8_unicode_ci default '',
  `NASIPAddress` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `NASPortId` varchar(15) collate utf8_unicode_ci default NULL,
  `NASPortType` varchar(32) collate utf8_unicode_ci default NULL,
  `AcctStartTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `AcctStopTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `AcctSessionTime` int(12) default NULL,
  `AcctAuthentic` varchar(32) collate utf8_unicode_ci default NULL,
  `ConnectInfo_start` varchar(50) collate utf8_unicode_ci default NULL,
  `ConnectInfo_stop` varchar(50) collate utf8_unicode_ci default NULL,
  `AcctInputOctets` bigint(20) default NULL,
  `AcctOutputOctets` bigint(20) default NULL,
  `CalledStationId` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `CallingStationId` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `AcctTerminateCause` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `ServiceType` varchar(32) collate utf8_unicode_ci default NULL,
  `FramedProtocol` varchar(32) collate utf8_unicode_ci default NULL,
  `FramedIPAddress` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `AcctStartDelay` int(12) default NULL,
  `AcctStopDelay` int(12) default NULL,
  `XAscendSessionSvrKey` varchar(10) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`RadAcctId`),
  KEY `UserName` (`UserName`),
  KEY `FramedIPAddress` (`FramedIPAddress`),
  KEY `AcctSessionId` (`AcctSessionId`),
  KEY `AcctUniqueId` (`AcctUniqueId`),
  KEY `AcctStartTime` (`AcctStartTime`),
  KEY `AcctStopTime` (`AcctStopTime`),
  KEY `NASIPAddress` (`NASIPAddress`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `radacct`
--


--
-- Table structure for table `radcheck`
--

CREATE TABLE `radcheck` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `UserName` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `Attribute` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `op` char(2) collate utf8_unicode_ci NOT NULL default '==',
  `Value` varchar(253) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `UserName` (`UserName`(32))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `radcheck`
--


--
-- Table structure for table `radgroupcheck`
--

CREATE TABLE `radgroupcheck` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `GroupName` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `Attribute` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `op` char(2) collate utf8_unicode_ci NOT NULL default '==',
  `Value` varchar(253) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `GroupName` (`GroupName`(32))
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `radgroupcheck`
--

INSERT INTO `radgroupcheck` VALUES (1,'daloRADIUS-Disabled-Users','Auth-Type',':=','Reject');

--
-- Table structure for table `radgroupreply`
--

CREATE TABLE `radgroupreply` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `GroupName` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `Attribute` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `op` char(2) collate utf8_unicode_ci NOT NULL default '=',
  `Value` varchar(253) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `GroupName` (`GroupName`(32))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `radgroupreply`
--


--
-- Table structure for table `radippool`
--

CREATE TABLE `radippool` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `pool_name` varchar(30) collate utf8_unicode_ci NOT NULL,
  `FramedIPAddress` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `NASIPAddress` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `CalledStationId` varchar(30) collate utf8_unicode_ci NOT NULL,
  `CallingStationID` varchar(30) collate utf8_unicode_ci NOT NULL,
  `expiry_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `username` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `pool_key` varchar(30) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `radippool`
--


--
-- Table structure for table `radpostauth`
--

CREATE TABLE `radpostauth` (
  `id` int(11) NOT NULL auto_increment,
  `user` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `pass` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `reply` varchar(32) collate utf8_unicode_ci NOT NULL default '',
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `radpostauth`
--


--
-- Table structure for table `radreply`
--

CREATE TABLE `radreply` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `UserName` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `Attribute` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `op` char(2) collate utf8_unicode_ci NOT NULL default '=',
  `Value` varchar(253) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `UserName` (`UserName`(32))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `radreply`
--


--
-- Table structure for table `realms`
--

CREATE TABLE `realms` (
  `id` bigint(20) NOT NULL auto_increment,
  `realmname` varchar(128) default NULL,
  `type` varchar(32) default NULL,
  `authhost` varchar(256) default NULL,
  `accthost` varchar(256) default NULL,
  `secret` varchar(128) default NULL,
  `ldflag` varchar(64) default NULL,
  `nostrip` int(8) default NULL,
  `hints` int(8) default NULL,
  `notrealm` int(8) default NULL,
  `creationdate` datetime default NULL,
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default NULL,
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `realms`
--


--
-- Table structure for table `userbillinfo`
--

CREATE TABLE `userbillinfo` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `username` varchar(128) default NULL,
  `planName` varchar(128) default NULL,
  `hotspot_id` int(32) default NULL,
  `hotspotlocation` varchar(32) default NULL,
  `contactperson` varchar(200) default NULL,
  `company` varchar(200) default NULL,
  `email` varchar(200) default NULL,
  `phone` varchar(200) default NULL,
  `address` varchar(200) default NULL,
  `city` varchar(200) default NULL,
  `state` varchar(200) default NULL,
  `country` varchar(100) default NULL,
  `zip` varchar(200) default NULL,
  `paymentmethod` varchar(200) default NULL,
  `cash` varchar(200) default NULL,
  `creditcardname` varchar(200) default NULL,
  `creditcardnumber` varchar(200) default NULL,
  `creditcardverification` varchar(200) default NULL,
  `creditcardtype` varchar(200) default NULL,
  `creditcardexp` varchar(200) default NULL,
  `notes` varchar(200) default NULL,
  `changeuserbillinfo` varchar(128) default NULL,
  `lead` varchar(200) default NULL,
  `coupon` varchar(200) default NULL,
  `ordertaker` varchar(200) default NULL,
  `billstatus` varchar(200) default NULL,
  `lastbill` date NOT NULL default '0000-00-00',
  `nextbill` date NOT NULL default '0000-00-00',
  `nextinvoicedue` int(32) default NULL,
  `billdue` int(32) default NULL,
  `postalinvoice` varchar(8) default NULL,
  `faxinvoice` varchar(8) default NULL,
  `emailinvoice` varchar(8) default NULL,
  `batch_id` int(32) default NULL,
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`),
  KEY `username` (`username`),
  KEY `planname` (`planName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userbillinfo`
--


--
-- Table structure for table `usergroup`
--

CREATE TABLE `usergroup` (
  `UserName` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `GroupName` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `priority` int(11) NOT NULL default '0',
  KEY `UserName` (`UserName`(32))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `usergroup`
--


--
-- Table structure for table `userinfo`
--

CREATE TABLE `userinfo` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(128) default NULL,
  `firstname` varchar(200) default NULL,
  `lastname` varchar(200) default NULL,
  `email` varchar(200) default NULL,
  `department` varchar(200) default NULL,
  `company` varchar(200) default NULL,
  `workphone` varchar(200) default NULL,
  `homephone` varchar(200) default NULL,
  `mobilephone` varchar(200) default NULL,
  `address` varchar(200) default NULL,
  `city` varchar(200) default NULL,
  `state` varchar(200) default NULL,
  `country` varchar(100) default NULL,
  `zip` varchar(200) default NULL,
  `notes` varchar(200) default NULL,
  `changeuserinfo` varchar(128) default NULL,
  `portalloginpassword` varchar(128) default '',
  `enableportallogin` int(32) default '0',
  `creationdate` datetime default '0000-00-00 00:00:00',
  `creationby` varchar(128) default NULL,
  `updatedate` datetime default '0000-00-00 00:00:00',
  `updateby` varchar(128) default NULL,
  PRIMARY KEY  (`id`),
  KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userinfo`
--



