-- MySQL dump 10.13  Distrib 5.5.54, for Linux (i686)
--
-- Host: localhost    Database: usawide
-- ------------------------------------------------------
-- Server version	5.5.54

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!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 `billing`
--

DROP TABLE IF EXISTS `billing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `billing` (
  `address1` varchar(400) NOT NULL,
  `address2` varchar(400) NOT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(40) NOT NULL,
  `zip` varchar(40) NOT NULL,
  `tel` varchar(30) NOT NULL,
  `id` int(11) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `billing`
--

LOCK TABLES `billing` WRITE;
/*!40000 ALTER TABLE `billing` DISABLE KEYS */;
INSERT INTO `billing` VALUES ('5755 magnolia ave','','rialto','CA','92376','9098770187',259),('21175 MAINSAIL CIRCLE, E11','','AVENTURA','FL','33180','3054090602',335),('29340 No Le Hace','','Fair Oaks','Texas','29340','8309814691',423),('test','','test','KS','test','test',424),('13831 SW 59 Street, Suite 203','','Miami ','FL','33183','305-408-6250',425),('test','','test','FL','test','test',426),('13831 SW 59 STREET, Suite 203','','Miami ','FL','33183','305-408-6250',431),('test','','test','FL','test','test',432),('13831 SW 59 Street, Suite 203','','Miami','FL','33183','305-408-6250',433),('34 strEET','','LOSANGLE','CA','90863','0980987843',436);
/*!40000 ALTER TABLE `billing` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cart`
--

DROP TABLE IF EXISTS `cart`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cart` (
  `state` varchar(50) NOT NULL,
  `type` varchar(30) NOT NULL,
  `statefee` int(11) NOT NULL,
  `package` int(11) NOT NULL,
  `bylaws` int(11) NOT NULL,
  `stockCertificates` int(11) NOT NULL,
  `corporateKitAndSeal` int(11) NOT NULL,
  `scorpapp` int(11) NOT NULL,
  `ein` int(11) NOT NULL,
  `cd` int(11) NOT NULL,
  `fedex` int(11) NOT NULL,
  `regagent` int(11) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=437 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cart`
--

LOCK TABLES `cart` WRITE;
/*!40000 ALTER TABLE `cart` DISABLE KEYS */;
INSERT INTO `cart` VALUES ('CT','LLC',120,239,0,0,0,0,0,0,0,0,255),('AL','LLC',175,239,0,0,0,0,0,0,0,0,256),('AL','LLC',175,239,0,0,0,0,0,0,0,0,257),('DE','LLC',90,239,0,0,0,0,0,0,0,0,258),('IL','LLC',500,339,69,29,99,45,77,69,25,0,259),('DE','LLC',90,99,0,0,0,0,0,0,0,0,260),('NY','LLC',200,0,0,0,0,0,0,0,0,0,261),('DE','LLC',90,339,0,0,0,0,0,0,0,0,262),('AZ','LLC',50,99,0,0,0,0,0,0,0,0,263),('LA','LLC',100,0,0,0,0,0,0,0,0,0,264),('CA','LLC',70,0,0,0,0,0,0,0,0,0,265),('CA','ccorp',100,0,0,0,0,0,0,0,0,0,266),('AK','nonprofit',50,99,0,0,0,0,0,0,0,0,267),('AL','LLC',175,239,0,0,0,0,77,0,0,0,268),('DE','LLC',90,339,0,0,0,0,0,0,0,0,269),('FL','LLC',125,0,0,0,0,0,0,0,0,0,270),('FL','LLC',125,0,0,0,0,0,0,0,0,0,271),('CA','LLC',70,239,0,0,0,0,0,0,0,0,272),('DE','LLC',90,99,0,0,0,0,0,0,0,0,273),('DE','LLC',90,0,0,0,0,0,0,0,0,0,274),('DE','LLC',90,0,0,0,0,0,0,0,0,0,275),('VA','LLC',100,0,0,0,0,0,0,0,0,0,276),('DE','LLC',90,339,0,0,0,0,0,0,0,0,277),('CA','ccorp',100,239,0,0,0,0,0,0,0,0,278),('DE','LLC',90,239,0,0,0,0,0,0,0,0,279),('WY','LLC',100,0,0,0,0,0,0,0,0,0,280),('FL','LLC',125,239,0,0,0,0,0,0,0,0,281),('NV','LLC',75,0,0,0,0,0,0,0,0,0,282),('FL','LLC',125,339,0,0,0,0,0,0,0,0,283),('TX','LLC',325,239,0,0,0,0,0,0,0,0,284),('CA','LLC',70,339,0,0,0,0,0,0,0,0,285),('CA','nonprofit',30,239,0,0,0,0,0,0,0,0,286),('CA','LLC',70,339,0,0,0,0,0,0,0,0,287),('NM','LLC',50,99,0,0,0,0,0,0,0,0,288),('FL','LLC',125,0,0,0,0,0,0,0,0,0,289),('DE','LLC',90,339,0,0,0,0,0,0,0,0,290),('DE','LLC',90,239,0,0,0,0,77,69,25,0,291),('FL','LLC',125,0,0,0,0,0,0,0,0,0,292),('CA','LLC',70,239,0,0,0,0,77,0,25,0,293),('FL','scorp',70,0,0,0,0,0,0,0,0,0,294),('NY','LLC',200,239,0,0,0,0,0,0,0,0,295),('AK','LLC',250,0,0,0,0,0,0,0,0,0,296),('NY','LLC',200,239,0,0,0,0,0,0,0,0,297),('NY','LLC',200,0,0,0,0,0,0,0,0,0,298),('FL','LLC',125,239,0,0,0,0,0,0,0,0,299),('WY','LLC',100,0,0,0,0,0,0,0,0,0,300),('CA','scorp',100,339,0,0,0,0,0,0,0,0,301),('CA','ccorp',100,0,0,0,0,0,0,0,0,0,302),('CA','LLC',70,239,0,0,0,0,0,0,0,0,303),('NJ','LLC',125,0,0,0,0,0,0,0,0,0,304),('DE','LLC',90,239,0,0,0,0,0,0,0,0,305),('NV','LLC',75,0,0,0,0,0,0,0,0,0,306),('LA','LLC',100,0,0,0,0,0,0,0,0,0,307),('NV','scorp',75,0,0,0,0,0,0,0,0,0,308),('NV','ccorp',75,0,0,0,0,0,0,0,0,0,309),('NV','nonprofit',50,0,0,0,0,0,0,0,0,0,310),('IA','ccorp',50,0,0,0,0,0,0,0,0,0,311),('CA','LLC',70,0,0,0,0,0,0,0,0,0,312),('NV','LLC',75,239,0,0,99,0,0,0,25,0,313),('NV','LLC',75,239,0,0,0,0,0,0,0,0,314),('CO','LLC',50,0,0,0,0,0,0,0,0,0,315),('NY','LLC',200,239,0,0,0,0,0,0,0,0,316),('AK','LLC',250,339,0,0,0,0,0,0,0,0,317),('NY','LLC',200,239,0,0,0,0,0,0,0,0,318),('FL','ccorp',70,0,0,0,0,0,0,0,0,0,319),('MS','LLC',50,239,0,0,0,0,0,0,0,0,320),('CA','LLC',70,99,0,0,0,0,77,0,0,0,321),('CA','LLC',70,239,0,0,0,0,0,0,0,0,322),('DE','LLC',90,99,0,0,0,0,0,0,0,0,323),('TN','LLC',300,239,0,0,0,0,0,0,0,0,324),('FL','LLC',125,339,0,0,0,0,0,0,0,0,325),('DE','LLC',90,339,0,0,0,0,0,0,0,0,326),('CA','LLC',70,0,0,0,0,0,0,0,0,0,327),('DE','LLC',90,339,0,0,0,0,0,0,0,0,328),('AZ','LLC',50,239,0,0,0,0,0,0,0,0,329),('CA','LLC',70,0,0,0,0,0,0,0,0,0,330),('FL','LLC',125,0,0,0,0,0,0,0,0,0,331),('DE','nonprofit',89,239,0,0,0,0,0,0,0,0,332),('NY','LLC',200,239,69,0,0,0,77,0,0,0,333),('TX','LLC',325,339,0,0,0,0,0,0,0,0,334),('FL','LLC',125,339,0,0,0,0,77,0,0,0,335),('TX','LLC',325,0,0,0,0,0,0,0,0,0,336),('FL','LLC',125,239,0,0,0,0,0,0,0,0,337),('TX','LLC',325,339,0,0,0,0,0,0,0,0,338),('FL','LLC',125,239,0,0,0,0,0,0,0,0,339),('DE','LLC',90,0,0,0,0,0,0,0,0,0,340),('AK','scorp',250,339,0,0,0,0,0,0,0,0,341),('TN','LLC',300,239,0,0,0,0,0,0,0,0,342),('CO','ccorp',50,0,0,0,0,0,0,0,0,0,343),('CO','LLC',50,239,0,0,0,0,0,0,0,0,344),('UT','LLC',70,0,0,0,0,0,0,0,0,0,345),('PA','LLC',125,239,0,0,0,0,0,0,0,0,346),('IL','LLC',500,99,0,0,0,0,0,0,0,0,347),('WY','LLC',100,339,0,0,0,0,0,0,0,0,348),('AR','ccorp',50,239,0,0,0,0,0,0,0,0,349),('CA','LLC',70,99,0,0,0,0,0,0,0,0,350),('DE','LLC',90,0,0,0,0,0,0,0,0,0,351),('AZ','ccorp',60,239,0,29,0,45,77,69,25,0,352),('CA','scorp',100,0,0,0,0,0,0,0,0,0,353),('CA','scorp',100,0,0,0,0,0,0,0,0,0,354),('FL','ccorp',70,0,0,0,0,0,0,0,0,0,355),('TX','LLC',325,339,0,0,0,0,0,0,0,0,356),('WY','LLC',100,339,69,29,99,0,77,69,25,0,357),('MO','LLC',105,239,0,0,0,0,0,0,0,0,358),('WY','LLC',100,0,0,0,0,0,0,0,0,0,359),('FL','LLC',125,0,0,0,0,0,0,0,0,0,360),('FL','ccorp',70,0,0,0,0,0,0,0,0,0,361),('IL','LLC',500,0,0,0,0,0,0,0,0,0,362),('DE','LLC',90,0,0,0,0,0,0,0,0,0,363),('WY','LLC',100,239,0,0,0,0,77,69,25,0,364),('IL','LLC',500,239,0,0,0,0,0,0,0,0,365),('DE','LLC',90,339,0,0,0,0,0,0,0,0,366),('CA','scorp',100,339,0,0,0,0,0,0,0,0,367),('TX','ccorp',325,0,0,0,0,0,0,0,0,0,368),('TX','nonprofit',50,239,0,0,0,0,0,0,0,0,369),('TX','nonprofit',50,239,0,0,0,0,0,0,0,0,370),('TX','nonprofit',50,0,0,0,0,0,0,0,0,0,371),('DE','LLC',90,239,0,0,0,0,0,0,0,0,372),('TX','LLC',325,0,0,0,0,0,0,0,0,0,373),('CA','LLC',70,239,0,0,0,0,0,0,0,0,374),('CA','LLC',70,99,0,0,0,0,0,0,0,0,375),('CO','LLC',50,0,0,0,0,0,0,0,0,0,376),('AL','LLC',175,0,0,0,0,0,0,0,0,0,377),('DE','LLC',90,239,0,0,0,0,0,0,0,0,378),('NY','LLC',200,0,0,0,0,0,0,0,0,0,379),('NY','LLC',200,339,0,0,0,0,0,0,0,0,380),('FL','LLC',125,239,0,0,0,0,0,0,0,0,381),('FL','nonprofit',70,99,0,0,0,0,0,0,0,0,382),('DE','LLC',90,0,0,0,0,0,0,0,0,0,383),('TX','nonprofit',50,239,0,0,0,0,0,0,0,0,384),('CA','LLC',70,239,0,0,0,0,0,0,0,0,385),('TX','LLC',325,0,0,0,0,0,0,0,0,0,386),('WY','LLC',100,0,0,0,0,0,0,0,0,0,387),('TX','LLC',325,239,0,0,0,0,0,0,0,0,388),('TX','LLC',325,0,0,0,0,0,0,0,0,0,389),('CO','scorp',50,339,0,0,0,0,0,0,0,0,390),('WY','LLC',100,339,0,0,0,0,0,0,0,0,391),('CA','LLC',70,0,0,0,0,0,0,0,0,0,392),('CA','LLC',70,0,0,0,0,0,0,0,0,0,393),('DE','LLC',90,0,0,0,0,0,0,0,0,0,394),('IN','LLC',90,0,0,0,0,0,0,0,0,0,395),('NJ','scorp',125,339,0,0,0,0,0,0,0,0,396),('CA','LLC',70,339,0,0,0,0,0,0,0,0,397),('WY','LLC',100,339,0,0,0,0,0,0,0,0,398),('CA','scorp',100,339,0,0,0,0,0,0,0,0,399),('NY','LLC',200,339,0,0,0,0,0,0,0,0,400),('IA','LLC',50,0,0,0,0,0,0,0,0,0,401),('FL','LLC',125,239,0,0,0,0,0,0,0,0,402),('CA','scorp',100,339,0,0,0,0,0,0,0,0,403),('CA','ccorp',100,339,0,0,0,0,0,0,0,0,404),('CA','ccorp',100,239,0,29,99,45,0,0,0,0,405),('GA','LLC',100,0,0,0,0,0,0,0,0,0,406),('WI','nonprofit',35,339,0,0,0,0,0,0,0,0,407),('MN','LLC',155,0,0,0,0,0,0,0,0,0,408),('MN','LLC',155,0,0,0,0,0,0,0,0,0,409),('DE','LLC',90,99,0,0,0,0,0,0,0,0,410),('CA','LLC',70,339,0,0,0,0,0,0,0,0,411),('NV','LLC',75,339,0,0,0,0,0,0,0,0,412),('CA','scorp',100,0,0,0,0,0,0,0,0,0,413),('TX','LLC',325,99,0,0,0,0,0,0,0,0,414),('DE','LLC',90,0,0,0,0,0,0,0,0,0,415),('DE','LLC',90,99,0,0,0,0,0,0,0,0,416),('HI','nonprofit',50,339,0,0,0,0,0,0,0,0,417),('DE','ccorp',98,0,0,0,0,0,0,0,0,0,418),('DE','ccorp',98,0,0,0,0,0,0,0,0,0,419),('DE','ccorp',98,0,0,0,0,0,0,0,0,0,420),('DE','ccorp',98,0,0,0,0,0,0,0,0,0,421),('DE','ccorp',98,0,0,0,0,0,0,0,0,0,422),('TX','LLC',325,99,0,0,0,0,77,0,25,0,423),('AL','LLC',175,239,0,0,0,0,0,0,0,0,424),('FL','nonprofit',70,99,0,0,0,0,0,0,0,0,425),('AZ','nonprofit',40,239,0,0,0,0,0,0,0,0,426),('FL','LLC',125,239,0,0,0,0,0,0,0,0,427),('FL','nonprofit',70,239,0,0,0,0,0,0,0,0,428),('MO','nonprofit',25,99,0,0,0,0,0,0,0,0,429),('MO','nonprofit',25,99,0,0,0,0,0,0,0,0,430),('MO','nonprofit',25,99,0,0,0,0,0,0,0,0,431),('FL','nonprofit',70,99,0,0,0,0,0,0,0,0,432),('MO','nonprofit',25,99,0,0,0,0,0,0,0,0,433),('FL','ccorp',70,0,0,0,0,0,0,0,0,0,434),('CA','LLC',70,0,0,0,0,0,0,0,0,0,435),('AZ','LLC',50,239,0,0,99,0,0,0,0,0,436);
/*!40000 ALTER TABLE `cart` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contact`
--

DROP TABLE IF EXISTS `contact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contact` (
  `fullName` varchar(300) NOT NULL,
  `address1` varchar(300) NOT NULL,
  `address2` varchar(300) NOT NULL,
  `city` varchar(300) NOT NULL,
  `state` varchar(50) NOT NULL,
  `zip` varchar(20) NOT NULL,
  `tel` varchar(50) NOT NULL,
  `fax` varchar(50) NOT NULL,
  `email` varchar(200) NOT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contact`
--

LOCK TABLES `contact` WRITE;
/*!40000 ALTER TABLE `contact` DISABLE KEYS */;
INSERT INTO `contact` VALUES ('test name','test add1','','test city','FL','testzip','333','','GSANTASR@MINDSPRING.COM',258),('bryant penigar','5755 magnolia ave','','rialto','CA','92376','9098770187','no','bryantp@007yahoo.com',259),('Kimberly D. Dyer','2241 N.W. 27 street','','Ft. Lauderdale','FL','33311','772 293 9637','','Dolldiamond93@gmail.com',281),('Jueyan Guan','1626 Broadway','','Alameda','CA','94501','5104808813','','chloekwan1203@gmail.com',285),('Robert Olszewski','Melisy 11','','Warsaw','DE','05-077','+48533123495','','robertzmelisy@gmail.com',291),('Yoel Bacallao','101 Copper ln','','Richland','MS','39218','6018509740','7692337904','yoelbacallao@yahoo.com',320),('perry Harter','3421 California trail','','Frazier Park','CA','93225','804 592 0962','','Perryh@thepipedrafter.com',321),('Anna Vila','21175 MAINSAIL CIRCLE, E11','','AVENTURA','FL','33180','3054090602','','avila@summaone.com',335),('Arieh Bimblich','17061 NW 22 St','','Pembroke Pines','FL','33028','7868387500','','arieh@detodopromo.com',381),('Joerg-Peter Theissen','7816 Adelaide Drive','','Austin','TX','78739','817-874-3868','','jp.theissen@me.com',423),('test','test','','test','KS','test','test','','test@test.com',424),('George M Santamarina','13831 SW 59 Street, Suite 203','','Miami ','FL','33183','305-408-6250','','gsantasr@MINDSPRING.COM',425),('test','test','','test','FL','test','test','','javi@backroompr.com',426),('test','test','test','test','FL','33333','80000000500','','javi@backroompr.com',427),('George M Santamarina','13831 SW 59 Street, Suite 203','','Miami','FL','33183','305-408-6250','305-408-6252','gsantasr@mindspring.com',429),('George M Santamarina','13831 SW 59 Street, Suite 203','','Miami','MO','33183','305-408-6250','305-408-6252','gsantasr@mindspring.com',430),('GEORGE M SANTAMARINA','13831 SW 59 Street, Suite 203','','MIAMI ','MO','33183','305-408-6250','','GSANTASR@MINDSPRING.COM',431),('Test','test','','test','FL','test','test','','test@carrollton.org',432),('George M Santamarina','13831 SW 59 Street, Suite 203','','Miami','MO','33183','305-408-6250','','gsantasr@mindspring.com',433),('samlu gam','34 strEET','','LOSANGLE','CA','90863','0980987843','','goldenfloristindia3433@gmail.com',436);
/*!40000 ALTER TABLE `contact` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `corpaddress`
--

DROP TABLE IF EXISTS `corpaddress`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `corpaddress` (
  `address1` varchar(300) NOT NULL,
  `address2` varchar(300) NOT NULL,
  `city` varchar(300) NOT NULL,
  `county` varchar(300) NOT NULL,
  `state` varchar(50) NOT NULL,
  `zip` varchar(20) NOT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `corpaddress`
--

LOCK TABLES `corpaddress` WRITE;
/*!40000 ALTER TABLE `corpaddress` DISABLE KEYS */;
INSERT INTO `corpaddress` VALUES ('test add1','','test city','test county','FL','testzip',258),('5755 magnolia ave','','rialto','us','CA','92376',259),('2241 N.W. 27 street','','Ft. Laudedale','Broward','FL','33311',281),('1626 Broadway','','Alameda','US','CA','94501',285),('Melisy 11','','Warsaw','Poland','DE','05-077',291),('101 Copper ln','','Richland','Rankin','MS','39218',320),('3421 California trail','','Frazier Park','kern','CA','93225',321),('21175 MAINSAIL CIRCLE, E11','','AVENTURA','DADE','FL','33180',335),('17061 NW 22 St','','Pembroke Pines','usa','FL','33028',381),('7816 Adelaide Drive','','Austin','Travis County','TX','78739',423),('test','','test','test','KS','test',424),('13831 SW 59 Street, Suite 203','','Miami ','Miami-Dade','FL','33183',425),('test','','test','test','FL','test',426),('test','test','test','test','FL','33333',427),('13831 SW 59 Street, Suite 203','','Miami','Miami-Dade','FL','33183',429),('13831 SW 59 Street, Suite 203','','Miami','Miami-Dade','MO','33183',430),('13831 SW 59 Street, Suite 203','','MIAMI ','MIAMI-DADE','MO','33183',431),('test','','test','tset','FL','test',432),('13831 SW 59 Street, Suite 203','','Miami','Miami-Dade','MO','33183',433),('23 lod str','','losangle','usa','CA','90874',436);
/*!40000 ALTER TABLE `corpaddress` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `corpinfo`
--

DROP TABLE IF EXISTS `corpinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `corpinfo` (
  `name` varchar(300) NOT NULL,
  `altname1` varchar(300) NOT NULL,
  `altname2` varchar(300) NOT NULL,
  `addon` varchar(50) NOT NULL,
  `purpose` varchar(500) NOT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `corpinfo`
--

LOCK TABLES `corpinfo` WRITE;
/*!40000 ALTER TABLE `corpinfo` DISABLE KEYS */;
INSERT INTO `corpinfo` VALUES ('test company name','test alt1','test alt2','','test purpose',258),('llcebaybrokerwholesalepartnershipsuperbusinesscareerstoremanufacteds','bryant penigar','bryant penigar','','wholesalescareerebayllcbusinesspartnershipaffiliatesprogram',259),('B.O.G DarkSide Ent....','Blackout Gang Take over!!&#128064;','DarkSide lifestyle B.O.G Ent...','','Promotion company',281),('sampai lighting company ltd','sampaii','sanpai','','Led lighting company',285),('Norbert Trust','Norbert Management','Dela Trust','','trade and provide services',291),('Bacallao Granite And Marble','Yoel bacallao','Oneyda Gomez','','intalacion de granite ,marble',320),('The Pipe Drafter','3D drafters','Bim Drafters','','Designing mechanical piping systems.',321),('Summa One','Summa One','Summa One','','Construction, Real Estate',335),('De Todo Products','De Todo Pet','De Todo Sale','','Sale product online',381),('Varius Marketing','Varius Trading','Varius Mercatura','','Import & export of consumer goods, especially office furniture',423),('test','test','test','','test',424),('Love Foundation ','Americare ','Loving Care Foundation','Corp.','Charitable, religious and educational purposes',425),('test','test','test','Inc.','test',426),('test','tes2','test2','','test',427),('First Try','Try First','Try Again','Corp.','To try our luck',429),('Try First','Try Second','Try Third','Corp.','To try my luck',430),('TRY MY LUCK','TRY TWO','TRY THREE','Corp.','TEST MY LUCK',431),('test','test','test','Corp.','teset',432),('firts test','second test','third test','Corp.','To cultivate brotherhood',433),('SAMLUGAM','samlugam','43 street','','samlugam',436);
/*!40000 ALTER TABLE `corpinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `county`
--

DROP TABLE IF EXISTS `county`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `county` (
  `county` varchar(300) NOT NULL,
  `id` int(11) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `county`
--

LOCK TABLES `county` WRITE;
/*!40000 ALTER TABLE `county` DISABLE KEYS */;
INSERT INTO `county` VALUES ('test county',258),('us',259),('Broward',281),('US',285),('Poland',291),('Rankin',320),('kern',321),('DADE',335),('usa',381),('Travis County',423),('test',424),('Miami-Dade',425),('test',426),('test',427),('Miami-Dade',429),('Miami-Dade',430),('MIAMI-DADE',431),('tset',432),('Miami-Dade',433),('USA',436);
/*!40000 ALTER TABLE `county` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `directors`
--

DROP TABLE IF EXISTS `directors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `directors` (
  `dir1` varchar(300) NOT NULL,
  `dir2` varchar(300) NOT NULL,
  `dir3` varchar(300) NOT NULL,
  `dir4` varchar(300) NOT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `directors`
--

LOCK TABLES `directors` WRITE;
/*!40000 ALTER TABLE `directors` DISABLE KEYS */;
INSERT INTO `directors` VALUES ('test mgr','','','',258),('bryant penigar','','','',259),('Kimberly Dyer','Cedrick Jones','Dennis Jones ','Tedgric m',281),('','','','',285),('','','','',291),('Yoel Bacallao','','','',320),('Perry Harter','John Harter','','',321),('Anna Vila','Marc Vila','','',335),('Maximo BImblich','Arieh Bimblich','','',381),('','','','',423),('','','','',424),('George M Santamarina','Sonnia Santamarina','George F Santamarina','',425),('test','test','test','',426),('testy mctesterson','','','',427),('First Director','Second Director','Third Director','',429),('Director One','Director Two','Director Three','',430),('ONE','TWO','THREE','',431),('test','test','test','',432),('one','two','three','',433),('','','','',436);
/*!40000 ALTER TABLE `directors` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ein`
--

DROP TABLE IF EXISTS `ein`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ein` (
  `bestfit` varchar(100) NOT NULL,
  `otherbestfit` varchar(250) NOT NULL,
  `description` varchar(350) NOT NULL,
  `einreason` varchar(350) NOT NULL,
  `reasontype` varchar(100) NOT NULL,
  `bankingpurpose` varchar(350) NOT NULL,
  `changedtype` varchar(100) NOT NULL,
  `typeoftrust` varchar(100) NOT NULL,
  `typeofpension` varchar(100) NOT NULL,
  `agempl` int(11) NOT NULL,
  `houseempl` int(11) NOT NULL,
  `industryempl` int(11) NOT NULL,
  `firstdatewages` varchar(75) NOT NULL,
  `datestarted` varchar(75) NOT NULL,
  `closingmonth` varchar(30) NOT NULL,
  `einname` varchar(200) NOT NULL,
  `einssn` varchar(30) NOT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ein`
--

LOCK TABLES `ein` WRITE;
/*!40000 ALTER TABLE `ein` DISABLE KEYS */;
INSERT INTO `ein` VALUES ('Wholesale-other','100','100','Started new business','100','1','wholesalellcebaysuperstorecareerbusiness','100','100',100,100,100,'10/29/2015','10/30/2015','12','llc','622689506',259),('Finance and insurance','','','Started new business','LLC','','','','',0,0,0,'','12/01/2015','12','Managing director','Managing director',291),('Construction','','Mechanical Drafting','Banking purposes','On Line Drafting company','Open a new business account','','','',0,0,0,'','','12','Perry Harter','249973488',321),('Other','Construction, Real Estate','','Started new business','Construction, Real Estate','','','','',0,0,0,'','','12','Anna Vila','00 61 139 53',335),('Wholesale-other','Office Furniture & other consumer goods','Office Furniture','Started new business','Wholesale of Office Furniture and other consumer goods','','','','',0,0,0,'','','12','Jorg-Peter Theissen','230-67-6397',423);
/*!40000 ALTER TABLE `ein` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fechas`
--

DROP TABLE IF EXISTS `fechas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fechas` (
  `created` date NOT NULL,
  `sent` date NOT NULL,
  `received` date NOT NULL,
  `finalized` date NOT NULL,
  `id` int(11) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fechas`
--

LOCK TABLES `fechas` WRITE;
/*!40000 ALTER TABLE `fechas` DISABLE KEYS */;
INSERT INTO `fechas` VALUES ('2015-10-28','0000-00-00','0000-00-00','0000-00-00',258),('2015-10-29','0000-00-00','0000-00-00','0000-00-00',259),('2015-11-04','0000-00-00','0000-00-00','0000-00-00',291),('2015-11-07','0000-00-00','0000-00-00','0000-00-00',320),('2015-11-07','0000-00-00','0000-00-00','0000-00-00',321),('2015-11-10','0000-00-00','0000-00-00','0000-00-00',335),('2016-01-07','0000-00-00','0000-00-00','0000-00-00',423),('2016-01-08','0000-00-00','0000-00-00','0000-00-00',424),('2016-01-08','0000-00-00','0000-00-00','0000-00-00',425),('2016-01-13','0000-00-00','0000-00-00','0000-00-00',426),('2016-01-13','0000-00-00','0000-00-00','0000-00-00',427),('2016-01-15','0000-00-00','0000-00-00','0000-00-00',429),('2016-01-15','0000-00-00','0000-00-00','0000-00-00',430),('2016-01-15','0000-00-00','0000-00-00','0000-00-00',431),('2016-01-20','0000-00-00','0000-00-00','0000-00-00',432),('2016-01-20','0000-00-00','0000-00-00','0000-00-00',433),('2017-06-21','0000-00-00','0000-00-00','0000-00-00',436);
/*!40000 ALTER TABLE `fechas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `llcowners`
--

DROP TABLE IF EXISTS `llcowners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `llcowners` (
  `number` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `llcowners`
--

LOCK TABLES `llcowners` WRITE;
/*!40000 ALTER TABLE `llcowners` DISABLE KEYS */;
INSERT INTO `llcowners` VALUES (2,258),(100,259),(4,281),(6,285),(1,291),(1,320),(2,321),(2,335),(2,381),(1,423),(23,424),(0,425),(0,426),(2,427),(0,429),(0,430),(0,431),(0,432),(0,433),(897,436);
/*!40000 ALTER TABLE `llcowners` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `nonprofitexempt`
--

DROP TABLE IF EXISTS `nonprofitexempt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nonprofitexempt` (
  `npex` varchar(10) NOT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `nonprofitexempt`
--

LOCK TABLES `nonprofitexempt` WRITE;
/*!40000 ALTER TABLE `nonprofitexempt` DISABLE KEYS */;
INSERT INTO `nonprofitexempt` VALUES ('yes',425),('yes',426),('no',429),('no',430),('no',431),('yes',432),('no',433);
/*!40000 ALTER TABLE `nonprofitexempt` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `nonprofitmembers`
--

DROP TABLE IF EXISTS `nonprofitmembers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nonprofitmembers` (
  `npmemb` varchar(10) NOT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `nonprofitmembers`
--

LOCK TABLES `nonprofitmembers` WRITE;
/*!40000 ALTER TABLE `nonprofitmembers` DISABLE KEYS */;
INSERT INTO `nonprofitmembers` VALUES ('no',425),('no',426),('no',429),('no',430),('no',431),('no',432),('no',433);
/*!40000 ALTER TABLE `nonprofitmembers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `officers`
--

DROP TABLE IF EXISTS `officers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `officers` (
  `president` varchar(300) NOT NULL,
  `vice` varchar(300) NOT NULL,
  `treasurer` varchar(300) NOT NULL,
  `secretary` varchar(300) NOT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `officers`
--

LOCK TABLES `officers` WRITE;
/*!40000 ALTER TABLE `officers` DISABLE KEYS */;
INSERT INTO `officers` VALUES ('George M Santamarina','','','',425),('','','','',426),('','','','',429),('','','','',430),('','','','',431),('','','','',432),('','','','',433);
/*!40000 ALTER TABLE `officers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `paid`
--

DROP TABLE IF EXISTS `paid`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paid` (
  `paid` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `paid`
--

LOCK TABLES `paid` WRITE;
/*!40000 ALTER TABLE `paid` DISABLE KEYS */;
/*!40000 ALTER TABLE `paid` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `regagent`
--

DROP TABLE IF EXISTS `regagent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `regagent` (
  `raselect` int(11) NOT NULL,
  `name` varchar(300) NOT NULL,
  `address1` varchar(300) NOT NULL,
  `address2` varchar(300) NOT NULL,
  `city` varchar(300) NOT NULL,
  `state` varchar(50) NOT NULL,
  `zip` varchar(20) NOT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `regagent`
--

LOCK TABLES `regagent` WRITE;
/*!40000 ALTER TABLE `regagent` DISABLE KEYS */;
INSERT INTO `regagent` VALUES (1,'','','','','','',258),(1,'','','','','','',259),(1,'','','','','','',281),(1,'','','','','','',285),(1,'','','','','','',291),(0,'Yoel Bacallao','101 Copper ln','','Richland','MS','39218',320),(0,'perry Harter','3421 California trail','','Frazier Park','CA','93225',321),(1,'','','','','','',335),(1,'','','','','','',381),(0,'Joerg-Peter Theissen','7816 Adelaide Drive','','Austin','TX','78739',423),(1,'','','','','','',424),(0,'George M Santamarina','13831 SW 59 Street, Suite 203','','Miami ','FL','33183',425),(1,'','','','','','',426),(1,'','','','','','',427),(1,'','','','','','',429),(0,'George M Santamarina','13831 SW 59 Street, Suite 203','','Miami','MO','33183',430),(0,'GEORGE M SANTAMARINA','13831 SW 59 Street, Suite 203','','MIAMI ','MO','33183',431),(1,'','','','','','',432),(0,'George M Santamarina','13831 SW 59 Street, Suite 203','','Miami','MO','33183',433),(1,'','','','','','',436);
/*!40000 ALTER TABLE `regagent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sequence`
--

DROP TABLE IF EXISTS `sequence`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sequence` (
  `sequence` int(11) NOT NULL AUTO_INCREMENT,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`sequence`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sequence`
--

LOCK TABLES `sequence` WRITE;
/*!40000 ALTER TABLE `sequence` DISABLE KEYS */;
INSERT INTO `sequence` VALUES (1,433);
/*!40000 ALTER TABLE `sequence` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shares`
--

DROP TABLE IF EXISTS `shares`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shares` (
  `number` int(11) NOT NULL,
  `parValue` float NOT NULL,
  `nopar` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shares`
--

LOCK TABLES `shares` WRITE;
/*!40000 ALTER TABLE `shares` DISABLE KEYS */;
INSERT INTO `shares` VALUES (1000,0.01,0,425),(1000,0.01,0,426),(1000,0.01,0,429),(1000,0.01,0,430),(1000,0.01,0,431),(1000,0.01,0,432),(1000,0.01,0,433);
/*!40000 ALTER TABLE `shares` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `statefees`
--

DROP TABLE IF EXISTS `statefees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `statefees` (
  `state` varchar(50) NOT NULL,
  `corp` int(11) NOT NULL,
  `llc` int(11) NOT NULL,
  `np` int(11) NOT NULL,
  PRIMARY KEY (`state`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `statefees`
--

LOCK TABLES `statefees` WRITE;
/*!40000 ALTER TABLE `statefees` DISABLE KEYS */;
INSERT INTO `statefees` VALUES ('AK',250,250,50),('AL',175,175,125),('AR',50,50,50),('AZ',60,50,40),('CA',100,70,30),('CO',50,50,50),('CT',250,120,50),('DE',98,90,89),('FL',70,125,70),('GA',100,100,100),('HI',50,50,50),('IA',50,50,20),('ID',100,100,30),('IL',175,500,50),('IN',90,90,30),('KS',90,165,20),('KY',50,40,8),('LA',75,100,75),('MA',275,500,40),('MD',175,155,225),('ME',145,175,40),('MI',60,60,30),('MN',155,155,90),('MO',58,105,25),('MS',50,50,50),('MT',90,90,40),('NC',125,125,60),('ND',100,135,40),('NE',70,110,20),('NH',100,100,75),('NJ',125,125,75),('NM',100,50,25),('NV',75,75,50),('NY',125,200,75),('OH',125,125,125),('OK',50,100,25),('OR',100,100,50),('PA',125,125,125),('RI',230,150,35),('SC',135,110,25),('SD',150,150,30),('TN',100,300,100),('TX',325,325,50),('UT',70,70,30),('VA',75,100,75),('VT',125,125,125),('WA',180,180,30),('WI',100,170,35),('WV',50,100,25),('WY',100,100,25);
/*!40000 ALTER TABLE `statefees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `status`
--

DROP TABLE IF EXISTS `status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `status` (
  `status` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `status`
--

LOCK TABLES `status` WRITE;
/*!40000 ALTER TABLE `status` DISABLE KEYS */;
INSERT INTO `status` VALUES (1,433);
/*!40000 ALTER TABLE `status` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'usawide'
--

--
-- Dumping routines for database 'usawide'
--
/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-02-04 11:00:53
