# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 127.0.0.1
# Database:             prime
# Server version:       5.0.41-community-nt
# Server OS:            Win32
# Target-Compatibility: Standard ANSI SQL
# HeidiSQL version:     3.2 Revision: 1129
# --------------------------------------------------------

/*!40100 SET CHARACTER SET latin1;*/
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/


#
# Database structure for database 'prime'
#

CREATE DATABASE /*!32312 IF NOT EXISTS*/ "prime" /*!40100 DEFAULT CHARACTER SET latin1 */;

USE "prime";


#
# Table structure for table 'call_group'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "call_group" (
  "cod_call_group" bigint(20) NOT NULL auto_increment,
  "codigo" varchar(255) default NULL,
  "nome" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "cod_site" bigint(20) default NULL,
  PRIMARY KEY  ("cod_call_group"),
  KEY "FK7272155E6F4A362D" ("cod_site"),
  CONSTRAINT "FK7272155E6F4A362D" FOREIGN KEY ("cod_site") REFERENCES "site" ("cod_site")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'call_group'
#

LOCK TABLES "call_group" WRITE;
/*!40000 ALTER TABLE "call_group" DISABLE KEYS;*/
REPLACE INTO "call_group" ("cod_call_group", "codigo", "nome", "descricao", "cod_site") VALUES
	('2','marcas_parceiros','Marcas Parceiros',NULL,'1');
REPLACE INTO "call_group" ("cod_call_group", "codigo", "nome", "descricao", "cod_site") VALUES
	('3','banner_parceiros','Capa / Banner 1',NULL,'1');
REPLACE INTO "call_group" ("cod_call_group", "codigo", "nome", "descricao", "cod_site") VALUES
	('4','banner_capa','Capa / Banner Destaque',NULL,'1');
/*!40000 ALTER TABLE "call_group" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'category'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "category" (
  "cod_category" bigint(20) NOT NULL auto_increment,
  "codigo" varchar(255) default NULL,
  "nome" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "cod_site" bigint(20) default NULL,
  PRIMARY KEY  ("cod_category"),
  KEY "FK302BCFE6F4A362D" ("cod_site"),
  CONSTRAINT "FK302BCFE6F4A362D" FOREIGN KEY ("cod_site") REFERENCES "site" ("cod_site")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'category'
#

LOCK TABLES "category" WRITE;
/*!40000 ALTER TABLE "category" DISABLE KEYS;*/
REPLACE INTO "category" ("cod_category", "codigo", "nome", "descricao", "cod_site") VALUES
	('2','a_prime','O que é a MMA',NULL,'1');
REPLACE INTO "category" ("cod_category", "codigo", "nome", "descricao", "cod_site") VALUES
	('3','noticias','Notícias',NULL,'1');
REPLACE INTO "category" ("cod_category", "codigo", "nome", "descricao", "cod_site") VALUES
	('4','patrocinio','Opções de Patrocínio',NULL,'1');
REPLACE INTO "category" ("cod_category", "codigo", "nome", "descricao", "cod_site") VALUES
	('5','galerias_foto','Galerias / Fotos',NULL,'1');
REPLACE INTO "category" ("cod_category", "codigo", "nome", "descricao", "cod_site") VALUES
	('8','capa_card','Capa / Card',NULL,'1');
REPLACE INTO "category" ("cod_category", "codigo", "nome", "descricao", "cod_site") VALUES
	('9','lutadores','Lutadores',NULL,'1');
/*!40000 ALTER TABLE "category" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'category_product'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "category_product" (
  "cod_category_product" bigint(20) NOT NULL auto_increment,
  "nome" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "publicar" bit(1) default NULL,
  "vitrine" bit(1) default NULL,
  "codigo" varchar(255) default NULL,
  "cod_categoria_pai" bigint(20) default NULL,
  PRIMARY KEY  ("cod_category_product"),
  KEY "FKB88A52AE93D978CA" ("cod_categoria_pai"),
  CONSTRAINT "FKB88A52AE93D978CA" FOREIGN KEY ("cod_categoria_pai") REFERENCES "category_product" ("cod_category_product")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'category_product'
#

# (No data found.)



#
# Table structure for table 'category_user'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "category_user" (
  "cod_category_user" bigint(20) NOT NULL auto_increment,
  "codigo" varchar(255) default NULL,
  "nome" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "cod_site" bigint(20) default NULL,
  PRIMARY KEY  ("cod_category_user"),
  KEY "FK1433566C6F4A362D" ("cod_site"),
  CONSTRAINT "FK1433566C6F4A362D" FOREIGN KEY ("cod_site") REFERENCES "site" ("cod_site")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'category_user'
#

# (No data found.)



#
# Table structure for table 'chamada'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "chamada" (
  "cod_default_content" bigint(20) NOT NULL,
  "path_imagem_chamada" varchar(255) default NULL,
  "cod_call_group" bigint(20) default NULL,
  PRIMARY KEY  ("cod_default_content"),
  KEY "FK2C0AD7AD2B5951E4" ("cod_default_content"),
  KEY "FK2C0AD7ADBFFEE554" ("cod_call_group"),
  CONSTRAINT "FK2C0AD7AD2B5951E4" FOREIGN KEY ("cod_default_content") REFERENCES "default_content" ("cod_default_content"),
  CONSTRAINT "FK2C0AD7ADBFFEE554" FOREIGN KEY ("cod_call_group") REFERENCES "call_group" ("cod_call_group")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'chamada'
#

LOCK TABLES "chamada" WRITE;
/*!40000 ALTER TABLE "chamada" DISABLE KEYS;*/
REPLACE INTO "chamada" ("cod_default_content", "path_imagem_chamada", "cod_call_group") VALUES
	('2','banner2.jpg','2');
REPLACE INTO "chamada" ("cod_default_content", "path_imagem_chamada", "cod_call_group") VALUES
	('3','banner3.jpg','2');
REPLACE INTO "chamada" ("cod_default_content", "path_imagem_chamada", "cod_call_group") VALUES
	('5','banner4.jpg','2');
REPLACE INTO "chamada" ("cod_default_content", "path_imagem_chamada", "cod_call_group") VALUES
	('6','banner5.jpg','2');
REPLACE INTO "chamada" ("cod_default_content", "path_imagem_chamada", "cod_call_group") VALUES
	('7','banner6.jpg','2');
REPLACE INTO "chamada" ("cod_default_content", "path_imagem_chamada", "cod_call_group") VALUES
	('11','premier_banner.jpg','3');
REPLACE INTO "chamada" ("cod_default_content", "path_imagem_chamada", "cod_call_group") VALUES
	('15','banner_capa.jpg','4');
/*!40000 ALTER TABLE "chamada" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'city'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "city" (
  "cod_cidade" bigint(20) NOT NULL auto_increment,
  "nome" varchar(255) default NULL,
  "cod_estado" bigint(20) default NULL,
  PRIMARY KEY  ("cod_cidade"),
  KEY "FK2E996B310300A" ("cod_estado"),
  CONSTRAINT "FK2E996B310300A" FOREIGN KEY ("cod_estado") REFERENCES "estado" ("cod_estado")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'city'
#

# (No data found.)



#
# Table structure for table 'clicked_link'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "clicked_link" (
  "cod_clicked_link" bigint(20) NOT NULL auto_increment,
  "url_original" text,
  "url_modificada" text,
  "quantidade_click" int(11) default NULL,
  "click_id" varchar(255) default NULL,
  "cod_news_letter" bigint(20) default NULL,
  PRIMARY KEY  ("cod_clicked_link"),
  KEY "FK4CC9D9122261669B" ("cod_news_letter"),
  CONSTRAINT "FK4CC9D9122261669B" FOREIGN KEY ("cod_news_letter") REFERENCES "news_letter" ("cod_news_letter")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'clicked_link'
#

# (No data found.)



#
# Table structure for table 'compra'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "compra" (
  "cod_compra" bigint(20) NOT NULL auto_increment,
  "tipo_compra" varchar(2) NOT NULL,
  "situacao" int(11) default NULL,
  "ip_comprador" varchar(255) default NULL,
  "codigo" varchar(255) default NULL,
  "hora_data_compra" varchar(255) default NULL,
  "data_compra" varchar(255) default NULL,
  "data_finalizacao" varchar(255) default NULL,
  "cod_payment_form" bigint(20) default NULL,
  "cod_user" bigint(20) default NULL,
  PRIMARY KEY  ("cod_compra"),
  KEY "FKAF3F357EA0E1B461" ("cod_payment_form"),
  KEY "FKAF3F357E6367EE2B" ("cod_user"),
  CONSTRAINT "FKAF3F357E6367EE2B" FOREIGN KEY ("cod_user") REFERENCES "simple_user" ("cod_user"),
  CONSTRAINT "FKAF3F357EA0E1B461" FOREIGN KEY ("cod_payment_form") REFERENCES "payment_form" ("cod_payment_form")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'compra'
#

# (No data found.)



#
# Table structure for table 'condicao_pagamento'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "condicao_pagamento" (
  "cod_condicao_pagamento" bigint(20) NOT NULL auto_increment,
  "numero_vezes" int(11) default NULL,
  "juros" decimal(19,2) default NULL,
  "descricao" varchar(255) default NULL,
  "dias_para_pagar" int(11) default NULL,
  "valor_minimo" decimal(19,2) default NULL,
  "publicar" bit(1) default NULL,
  "cod_payment_form" bigint(20) default NULL,
  PRIMARY KEY  ("cod_condicao_pagamento"),
  KEY "FK346BFA1180216D03" ("cod_payment_form"),
  KEY "FK346BFA11A0E1B461" ("cod_payment_form"),
  CONSTRAINT "FK346BFA1180216D03" FOREIGN KEY ("cod_payment_form") REFERENCES "payment_form" ("cod_payment_form"),
  CONSTRAINT "FK346BFA11A0E1B461" FOREIGN KEY ("cod_payment_form") REFERENCES "payment_form" ("cod_payment_form")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'condicao_pagamento'
#

# (No data found.)



#
# Table structure for table 'cupom'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "cupom" (
  "cod_cupom" bigint(20) NOT NULL auto_increment,
  "tipo_cupom" varchar(3) NOT NULL,
  "codigo" varchar(255) default NULL,
  "titulo" varchar(255) default NULL,
  "data_publicacao" varchar(255) default NULL,
  "data_saida" varchar(255) default NULL,
  "desconto_bruto" decimal(19,2) default NULL,
  "valor_percentual" decimal(19,2) default NULL,
  PRIMARY KEY  ("cod_cupom")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'cupom'
#

# (No data found.)



#
# Table structure for table 'dado_financeiro_compra'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "dado_financeiro_compra" (
  "cod_dado_financeiro" bigint(20) NOT NULL auto_increment,
  "valor_condicao" decimal(19,2) default NULL,
  "situacao" int(11) default NULL,
  "data_limite_pagamento" varchar(255) default NULL,
  "cod_payment_data" bigint(20) default NULL,
  PRIMARY KEY  ("cod_dado_financeiro"),
  KEY "FK8E65381A5D1B2343" ("cod_payment_data"),
  CONSTRAINT "FK8E65381A5D1B2343" FOREIGN KEY ("cod_payment_data") REFERENCES "payment_data" ("cod_payment_data")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'dado_financeiro_compra'
#

# (No data found.)



#
# Table structure for table 'default_content'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "default_content" (
  "cod_default_content" bigint(20) NOT NULL auto_increment,
  "titulo" text,
  "chamada" text,
  "corpo" text,
  "content_id" varchar(255) default NULL,
  "data_saida" varchar(255) default NULL,
  "data_publicacao" varchar(255) default NULL,
  "publicar" bit(1) default NULL,
  "link" varchar(255) default NULL,
  "indice" int(11) default NULL,
  "tipo_link_target" int(11) default NULL,
  PRIMARY KEY  ("cod_default_content")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'default_content'
#

LOCK TABLES "default_content" WRITE;
/*!40000 ALTER TABLE "default_content" DISABLE KEYS;*/
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('1','O QUE É A MMA?','','<p>Quisque vel metus in magna fermentum molestie. Nunc nulla sem, ultrices a, suscipit vitae, gravida tristique, dui. Morbi at justo rhoncus arcu consequat porta. Maecenas feugiat erat nec ante elementum pharetra. Proin ultricies luctus dolor. Integer tellus. Pellentesque aliquam bibendum dui. Fusce vitae purus. Nullam in ante eu elit placerat consectetuer. Aenean arcu. Aenean suscipit. Etiam ut arcu sit amet elit mattis sodales. Etiam a nunc.<br /><br />Nam aliquam metus at dui. Nullam mattis, orci eget condimentum egestas, dui nunc ullamcorper urna, eget elementum quam justo at elit. In aliquam ornare mi. Pellentesque sit amet quam nec mi pulvinar faucibus. Phasellus molestie. Donec purus neque, tempor vel, laoreet nec, aliquet rutrum, nisi. Nullam ut est eu enim mattis lobortis. Praesent pulvinar vulputate risus. Vestibulum in dui. Phasellus lectus. Sed nonummy. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec ipsum purus, bibendum non, sollicitudin vitae, accumsan viverra, erat. Praesent pellentesque massa non turpis. Integer eu nunc. Sed dignissim. Aenean pulvinar fringilla nulla. Praesent porttitor, sapien sit amet rhoncus laoreet, augue tortor scelerisque orci, tristique aliquet massa nisi vitae turpis. Nunc vitae lectus nec metus aliquet ultrices. Nulla posuere purus id nulla.<br /><br />Praesent dignissim hendrerit mauris. Phasellus nisi lectus, feugiat in, porttitor nec, posuere ut, quam. Nullam imperdiet pharetra sapien. Pellentesque mattis. Nunc nec enim eu urna ornare pulvinar. Mauris vulputate lacus in dolor. Integer sit amet augue a ligula pretium pharetra. Nam vel massa eget odio porttitor facilisis. Nunc mi dolor, auctor vel, dictum quis, bibendum non, lacus. Etiam tellus eros, accumsan sed, tempor non, iaculis nec, nulla.</p>','1197489648619',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('2','Marca 1','',NULL,'1197489971742',NULL,NULL,'
','http://',0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('3','Marca 2','',NULL,'1197491383523',NULL,NULL,'
','http://',0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('5','Marca 3','',NULL,'1197491502273',NULL,NULL,'
','http://',0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('6','Marca 4','',NULL,'1197491549960',NULL,NULL,'
','http://',0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('7','Marca 5','',NULL,'1197491569616',NULL,NULL,'
','http://',0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('8','Noticias 1','<p>Duis consequat suscipit nisl. Ut vulputate.</p>','<p>Morbi tortor nisl, mollis vel, lobortis quis, congue non, dolor. Morbi placerat aliquam mi. Suspendisse potenti. Donec enim. Mauris neque diam, gravida vitae, posuere eu, varius sit amet, quam. Suspendisse aliquam nisi ut odio. Etiam sit amet diam. Donec sollicitudin arcu et tortor. Cras ipsum nulla, molestie eget, porta vitae, adipiscing sit amet, leo. Donec lectus nisl, congue laoreet, tincidunt ac, viverra non, massa. Sed laoreet, sapien eu nonummy iaculis, nulla erat posuere nisl, ut scelerisque turpis neque in lectus. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Maecenas vitae metus. Donec at mauris. Etiam eleifend mollis elit. Duis accumsan interdum velit. Donec mi eros, luctus sed, bibendum condimentum, sodales nec, justo. Donec metus massa, bibendum vitae, tempus vel, rhoncus a, dui.</p>','1197492020131',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('9','PMC Revolution','<p>Clique aqui para baixar o PDF</p>','','1197492744849',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('10','PMC Revolution 2','<p>Clique aqui para baixar o PDF</p>','','1197493131005',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('11','Banner 1','',NULL,'1197493285443',NULL,NULL,'
','http://',0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('13','PMC Revolution','<p>Data: 01/12/2007</p>','','1197554497713',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('14','Apresentação','','<p>Local: <span class="texto_cinza">Ginasio Antonio Balbino - Balbininho (reformado)</span></p>   <p>Dia: <span class="texto_cinza">01 de dezembro de 2007 (s&aacute;bado)</span><br />     &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="texto_cinza">Port&otilde;es abertos &agrave;s 17:00 hrs</span><br />     &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="texto_cinza">Primeiro Gongo &aacute;s 18:00 hrs</span></p>   <p>Ingressos: <span class="texto_cinza">Balc&otilde;es PIDA, os ingressos do PRIME MMA CHAMPIONSHIPS est&atilde;o a venda nos balc&otilde;es Pida, Iguatemi, Piedade e Lapa</span></p>   <p>&nbsp;</p><p>Arquibancada - <span class="texto_cinza">R$15,00 + 1kg de alimento nao perecivel</span></p>   <p>Cadeira Especial - <span class="texto_cinza">R$30,00</span></p>   <p>&Aacute;rea Vip - <span class="texto_cinza">R$50,00</span></p>   <p>Mesa VIP: <span class="texto_cinza">R$400,00 [04 lugares + garrafa de wisky] </span></p>   <p>Informa&ccedil;&otilde;es: <span class="texto_cinza">71.3347.3594</span></p>','1197556256156',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('15','Banner','',NULL,'1197557947956',NULL,NULL,'
','http://',0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('19','Luta 1','<p>Alex</p>','<p>Tiago Celestino</p>','1197563296916',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('20','Luta 2','<p>Tiago Celestino</p>','<p>Setweb Interna</p>','1197563379871',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('21','Luta 3','<p>Velaminho</p>','<p>Felipe</p>','1197563778799',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('22','Luta 5','<p>Indio</p>','<p>Edilson Teixeira</p>','1197563894647',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('23','Luta 4','<p>Rafael Figueredo</p>','<p>Layola</p>','1197563944056',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('24','Luta 6','<p>Bolivia</p>','<p>Jurandir</p>','1197563967697',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('25','Luta 7','<p>Renato Velame</p>','<p>Rafael Sobral</p>','1197564049748',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('26','Luta 8','<p>Minotaurinho</p>','<p>Arivaldo</p>','1197564097031',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('27','Luta 9','<p>Vandame</p>','<p>Kleber Samurai</p>','1197564117375',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('28','Luta 10','<p>Sinho</p>','<p>Jairo Soares</p>','1197564139485',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('29','Luta 11','<p>Renato Castro</p>','<p>Paulo Roberto</p>','1197564163908',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('30','Luta 12','<p>Marcos Araujo</p>','<p>Eric Parrudo</p>','1197564190034',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('31','Luta 13','<p>Nuno</p>','<p>Bruno Carioca</p>','1197564213002',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('32','Luta 14','<p>Leleco</p>','<p>Lula Molusco</p>','1197564244829',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('33','Luta 15','<p>Jadir</p>','<p>Andre Velame</p>','1197564267516',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('34','Nome do Lutador','<p><strong>Origem: </strong>Salvador</p><p><strong>Academia:</strong> Champion</p><p><strong>Peso: </strong>13Kg</p><p><strong>Idade:</strong> 20</p><p><strong>Recorde:</strong> 3 nocautes</p>','<p>Proin at lacus non enim accumsan sodales. Suspendisse sit amet nisl. Integer id velit a pede pellentesque consequat. Donec velit ipsum, fermentum vitae, varius eu, rhoncus sed, justo. Sed eu nisi consequat lectus consectetuer semper. In hac habitasse platea dictumst. Vivamus orci sem, rutrum quis, hendrerit sagittis, porttitor sed, leo. Proin sem turpis, facilisis id, ultrices a, tincidunt id, turpis. Suspendisse potenti. Nullam cursus. Phasellus sit amet augue. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.</p>','1197900563213',NULL,NULL,'
',NULL,0,1);
REPLACE INTO "default_content" ("cod_default_content", "titulo", "chamada", "corpo", "content_id", "data_saida", "data_publicacao", "publicar", "link", "indice", "tipo_link_target") VALUES
	('35','Nome do lutador 1','<p><strong>Origem:</strong> Salvador</p><p><strong>Academia:</strong> TCF Fight</p><p><strong>Peso:</strong> 1t</p><p><strong>Idade:</strong> 19</p><p><strong>Recorde:</strong> 20 nocautes</p>','<p>Phasellus sagittis mollis tellus. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Aenean eget dui. Phasellus nunc. Nullam ac massa ac metus nonummy lacinia. Fusce ornare, dui non porttitor iaculis, dolor risus aliquet ante, aliquet venenatis urna orci ut tellus. Donec lectus justo, nonummy in, iaculis ultricies, dignissim sit amet, mauris. Curabitur eu lorem nec diam eleifend fringilla. Cras eget dui ac leo ullamcorper egestas. Suspendisse tortor lorem, sollicitudin quis, malesuada vel, porttitor eget, quam. Quisque nulla sapien, hendrerit quis, interdum eget, pretium non, pede. Nunc et erat id metus placerat vehicula. Cras tincidunt, dolor auctor mattis venenatis, turpis lorem vestibulum neque, eu varius arcu odio nec sapien.<br /><br />Suspendisse ornare lorem ullamcorper massa. Cras magna nunc, dictum et, blandit id, pharetra in, libero. Sed diam. Duis feugiat odio in risus. Aliquam nibh odio, placerat id, dictum in, scelerisque at, enim. Fusce sed arcu. Pellentesque convallis vehicula augue. Phasellus dapibus nunc vitae libero. Aenean molestie. Nunc non ipsum vel erat ultricies dapibus. Cras placerat. Etiam facilisis lorem eget dolor. Phasellus vulputate. Praesent at nibh ac leo blandit vestibulum. Cras vestibulum dictum augue. Ut euismod tortor accumsan mauris. Suspendisse potenti.</p>','1197901400259',NULL,NULL,'
',NULL,0,1);
/*!40000 ALTER TABLE "default_content" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'easycm_file'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "easycm_file" (
  "cod_file" bigint(20) NOT NULL auto_increment,
  "tipo_arquivo" varchar(4) NOT NULL,
  "nome" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "cod_file_category" bigint(20) default NULL,
  "alt" varchar(255) default NULL,
  "codigo" varchar(255) default NULL,
  "discriminador_grupo" varchar(255) default NULL,
  "nome_arquivo" varchar(255) default NULL,
  "identificador_conteudo" bigint(20) default NULL,
  PRIMARY KEY  ("cod_file"),
  KEY "FK36AE49EF66184348" ("cod_file_category"),
  CONSTRAINT "FK36AE49EF66184348" FOREIGN KEY ("cod_file_category") REFERENCES "file_category" ("cod_file_category")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'easycm_file'
#

LOCK TABLES "easycm_file" WRITE;
/*!40000 ALTER TABLE "easycm_file" DISABLE KEYS;*/
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('1','CF',NULL,NULL,'1','','aad84438-b26f-4c7b-a8d9-56bb516e262f','NO','12_12_2007_17_21_47_gal1.jpg','1');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('2','CF',NULL,NULL,'1','','91dcd62e-f27b-4116-b121-192836e37f4e','NO','12_12_2007_17_33_41_banner2.gif','1');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('3','CF',NULL,NULL,'1','','79229ce0-0182-4615-815e-05d342b24ac1','NO','12_12_2007_17_47_32_banner_1big.jpg','8');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('4','CF',NULL,NULL,'2','','134a8100-a042-475f-8e8f-09fb8711b7bb','NO','12_12_2007_17_56_16_book_online_indd.pdf','9');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('5','CF',NULL,NULL,'2','','b66a5e4f-32b6-417a-97a5-7409156054c3','NO','12_12_2007_17_59_04_book_online_indd.pdf','10');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('6','CF',NULL,NULL,'1','','f823fb96-a043-4bd2-bfb7-bd2fc0cb97a8','NO','13_12_2007_10_56_51_01.jpg','12');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('7','CF',NULL,NULL,'1','','destaque_f823fb96-a043-4bd2-bfb7-bd2fc0cb97a8','NO','13_12_2007_10_56_51_02.jpg','12');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('8','CF',NULL,NULL,'1','','d751a908-f5d2-4e18-bf4d-1ac007cf7ae3','NO','13_12_2007_10_56_52_03.jpg','12');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('9','CF',NULL,NULL,'1','','destaque_d751a908-f5d2-4e18-bf4d-1ac007cf7ae3','NO','13_12_2007_10_56_52_04.jpg','12');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('10','CF',NULL,NULL,'1','','12ec5376-49d5-4e45-9b99-8ebb6752c368','NO','13_12_2007_10_56_52_05.jpg','12');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('11','CF',NULL,NULL,'1','','destaque_12ec5376-49d5-4e45-9b99-8ebb6752c368','NO','13_12_2007_10_56_52_06.jpg','12');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('12','CF',NULL,NULL,'1','','c956f532-587a-49c4-ad42-bead7fa37d39','NO','13_12_2007_10_59_25_08.jpg','12');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('13','CF',NULL,NULL,'1','','b0bc0e8f-82d6-4bb1-8255-2526088807fb','NO','13_12_2007_11_02_10_01.jpg','13');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('14','CF',NULL,NULL,'1','','87a063a4-f86a-4d2f-ab38-6f3dddc9d47a','NO','13_12_2007_11_02_10_02.jpg','13');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('15','CF',NULL,NULL,'1','','ab48bc24-b735-422f-9a22-ad15cf45e334','NO','13_12_2007_11_02_10_03.jpg','13');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('16','CF',NULL,NULL,'1','','b0b5d473-5536-48a2-9a6b-eef143999209','NO','13_12_2007_11_02_34_04.jpg','13');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('17','CF',NULL,NULL,'1','','destaque_b0b5d473-5536-48a2-9a6b-eef143999209','NO','13_12_2007_11_02_34_05.jpg','13');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('18','CF',NULL,NULL,'1','','b3260da8-ee66-4bf8-9cb8-e665f1cbb482','NO','13_12_2007_11_03_07_05.jpg','13');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('19','CF',NULL,NULL,'1','','8e44cce6-7e01-4241-97d9-b177e25f013d','NO','13_12_2007_11_03_07_06.jpg','13');
REPLACE INTO "easycm_file" ("cod_file", "tipo_arquivo", "nome", "descricao", "cod_file_category", "alt", "codigo", "discriminador_grupo", "nome_arquivo", "identificador_conteudo") VALUES
	('20','CF',NULL,NULL,'1','','7b4ac54b-4f69-42cf-a4c4-a4636bdbe74b','NO','13_12_2007_11_03_07_07.jpg','13');
/*!40000 ALTER TABLE "easycm_file" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'endereco'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "endereco" (
  "cod_endereco" bigint(20) NOT NULL auto_increment,
  "bairro" varchar(255) default NULL,
  "cep" varchar(255) default NULL,
  "complemento" varchar(255) default NULL,
  "endereco" varchar(255) default NULL,
  "telefone" varchar(255) default NULL,
  "nome_cidade" varchar(255) default NULL,
  "endereco_principal" bit(1) default NULL,
  "cod_cidade" bigint(20) default NULL,
  "cod_user" bigint(20) default NULL,
  PRIMARY KEY  ("cod_endereco"),
  KEY "FK672D67C9FB146B86" ("cod_cidade"),
  KEY "FK672D67C96367EE2B" ("cod_user"),
  CONSTRAINT "FK672D67C96367EE2B" FOREIGN KEY ("cod_user") REFERENCES "simple_user" ("cod_user"),
  CONSTRAINT "FK672D67C9FB146B86" FOREIGN KEY ("cod_cidade") REFERENCES "city" ("cod_cidade")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'endereco'
#

# (No data found.)



#
# Table structure for table 'enquete'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "enquete" (
  "cod_enquete" bigint(20) NOT NULL auto_increment,
  "codigo" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "titulo" varchar(255) default NULL,
  "publicar" bit(1) default NULL,
  "dataSaida" varchar(255) default NULL,
  "dataPublicacao" varchar(255) default NULL,
  "total_votos" int(11) default NULL,
  "cod_site" bigint(20) default NULL,
  PRIMARY KEY  ("cod_enquete"),
  KEY "FKA0F98DE96F4A362D" ("cod_site"),
  CONSTRAINT "FKA0F98DE96F4A362D" FOREIGN KEY ("cod_site") REFERENCES "site" ("cod_site")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'enquete'
#

# (No data found.)



#
# Table structure for table 'estado'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "estado" (
  "cod_estado" bigint(20) NOT NULL auto_increment,
  "nome" varchar(255) default NULL,
  "sigla" varchar(255) default NULL,
  "cod_pais" bigint(20) default NULL,
  PRIMARY KEY  ("cod_estado"),
  KEY "FKB2E43966525ABA74" ("cod_pais"),
  CONSTRAINT "FKB2E43966525ABA74" FOREIGN KEY ("cod_pais") REFERENCES "pais" ("cod_pais")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'estado'
#

LOCK TABLES "estado" WRITE;
/*!40000 ALTER TABLE "estado" DISABLE KEYS;*/
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('1','AC','Acre','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('2','AL','Alagoas','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('3','AP','Amapá','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('4','AM','Amazonas','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('5','BA','Bahia','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('6','CE','Ceará','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('7','DF','Distrito Federal','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('8','GO','Goiás','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('9','ES','Espírito Santo','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('10','MA','Maranhão','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('11','MT','Mato Grosso','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('12','MS','Mato Grosso do Sul','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('13','MG','Minas Gerais','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('14','PA','Pará','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('15','PB','Paraiba','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('16','PR','Paraná','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('17','PE','Pernambuco','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('18','PI','Piauí','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('19','RJ','Rio de Janeiro','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('20','RN','Rio Grande do Norte','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('21','RS','Rio Grande do Sul','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('22','RO','Rondônia','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('23','RR','Rorâima','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('24','SP','São Paulo','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('25','SC','Santa Catarina','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('26','SE','Sergipe','6');
REPLACE INTO "estado" ("cod_estado", "nome", "sigla", "cod_pais") VALUES
	('27','TO','Tocantins','6');
/*!40000 ALTER TABLE "estado" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'file_category'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "file_category" (
  "cod_file_category" bigint(20) NOT NULL auto_increment,
  "codigo" varchar(255) default NULL,
  "nome" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "path_icone" varchar(255) default NULL,
  "cod_site" bigint(20) default NULL,
  PRIMARY KEY  ("cod_file_category"),
  KEY "FK69EE64616F4A362D" ("cod_site"),
  CONSTRAINT "FK69EE64616F4A362D" FOREIGN KEY ("cod_site") REFERENCES "site" ("cod_site")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'file_category'
#

LOCK TABLES "file_category" WRITE;
/*!40000 ALTER TABLE "file_category" DISABLE KEYS;*/
REPLACE INTO "file_category" ("cod_file_category", "codigo", "nome", "descricao", "path_icone", "cod_site") VALUES
	('1','galeria_fotos','Galeria de Fotos',NULL,NULL,'1');
REPLACE INTO "file_category" ("cod_file_category", "codigo", "nome", "descricao", "path_icone", "cod_site") VALUES
	('2','arquivos_pdf','Arquivos PDF',NULL,NULL,'1');
/*!40000 ALTER TABLE "file_category" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'gallery'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "gallery" (
  "cod_gallery" bigint(20) NOT NULL auto_increment,
  "codigo" varchar(255) default NULL,
  "nome" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "publicar" bit(1) default NULL,
  "data_publicacao" varchar(255) default NULL,
  "data_saida" varchar(255) default NULL,
  "pasta_imagem" varchar(255) default NULL,
  "thumb_automatico" bit(1) default NULL,
  "cod_site" bigint(20) default NULL,
  PRIMARY KEY  ("cod_gallery"),
  KEY "FKF44C77526F4A362D" ("cod_site"),
  CONSTRAINT "FKF44C77526F4A362D" FOREIGN KEY ("cod_site") REFERENCES "site" ("cod_site")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'gallery'
#

LOCK TABLES "gallery" WRITE;
/*!40000 ALTER TABLE "gallery" DISABLE KEYS;*/
REPLACE INTO "gallery" ("cod_gallery", "codigo", "nome", "descricao", "publicar", "data_publicacao", "data_saida", "pasta_imagem", "thumb_automatico", "cod_site") VALUES
	('2','folder','Folder Destaques',NULL,'
',NULL,NULL,NULL,'','1');
/*!40000 ALTER TABLE "gallery" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'gallery_image'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "gallery_image" (
  "cod_gallery_image" bigint(20) NOT NULL auto_increment,
  "nome_arquivo" varchar(255) default NULL,
  "nome_arquivo_thumb" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "alt" varchar(255) default NULL,
  "credito" varchar(255) default NULL,
  "cod_gallery" bigint(20) default NULL,
  PRIMARY KEY  ("cod_gallery_image"),
  KEY "FK2AAD3E2E1D7D1423" ("cod_gallery"),
  CONSTRAINT "FK2AAD3E2E1D7D1423" FOREIGN KEY ("cod_gallery") REFERENCES "gallery" ("cod_gallery")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'gallery_image'
#

LOCK TABLES "gallery_image" WRITE;
/*!40000 ALTER TABLE "gallery_image" DISABLE KEYS;*/
REPLACE INTO "gallery_image" ("cod_gallery_image", "nome_arquivo", "nome_arquivo_thumb", "descricao", "alt", "credito", "cod_gallery") VALUES
	('2','12_12_2007_17_37_38_banner_1big.jpg','12_12_2007_17_37_38banner1.jpg','','','','2');
/*!40000 ALTER TABLE "gallery_image" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'generic_content'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "generic_content" (
  "cod_default_content" bigint(20) NOT NULL,
  "autor" text,
  "path_imagem_pequena" varchar(255) default NULL,
  "path_imagem_grande" varchar(255) default NULL,
  "cod_section" bigint(20) default NULL,
  PRIMARY KEY  ("cod_default_content"),
  KEY "FK64E01E112B5951E4" ("cod_default_content"),
  KEY "FK64E01E119B43C075" ("cod_section"),
  CONSTRAINT "FK64E01E112B5951E4" FOREIGN KEY ("cod_default_content") REFERENCES "default_content" ("cod_default_content"),
  CONSTRAINT "FK64E01E119B43C075" FOREIGN KEY ("cod_section") REFERENCES "section" ("cod_section")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'generic_content'
#

LOCK TABLES "generic_content" WRITE;
/*!40000 ALTER TABLE "generic_content" DISABLE KEYS;*/
REPLACE INTO "generic_content" ("cod_default_content", "autor", "path_imagem_pequena", "path_imagem_grande", "cod_section") VALUES
	('14',NULL,'','','1');
/*!40000 ALTER TABLE "generic_content" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'global_content'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "global_content" (
  "cod_default_content" bigint(20) NOT NULL,
  "autor" text,
  "data_criacao" varchar(255) default NULL,
  "path_imagem_pequena" varchar(255) default NULL,
  "path_imagem_grande" varchar(255) default NULL,
  "capa" bit(1) default NULL,
  "cod_category" bigint(20) default NULL,
  "cod_gallery" bigint(20) default NULL,
  PRIMARY KEY  ("cod_default_content"),
  KEY "FKB70F8BDD2B5951E4" ("cod_default_content"),
  KEY "FKB70F8BDDF0302316" ("cod_category"),
  KEY "FKB70F8BDD1D7D1423" ("cod_gallery"),
  CONSTRAINT "FKB70F8BDD1D7D1423" FOREIGN KEY ("cod_gallery") REFERENCES "gallery" ("cod_gallery"),
  CONSTRAINT "FKB70F8BDD2B5951E4" FOREIGN KEY ("cod_default_content") REFERENCES "default_content" ("cod_default_content"),
  CONSTRAINT "FKB70F8BDDF0302316" FOREIGN KEY ("cod_category") REFERENCES "category" ("cod_category")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'global_content'
#

LOCK TABLES "global_content" WRITE;
/*!40000 ALTER TABLE "global_content" DISABLE KEYS;*/
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('1','',NULL,'','','','2',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('8','','20071212','gal1.jpg','','','3',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('9','',NULL,'gal1.jpg','','','4',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('10','',NULL,'patro1.jpg','','','4',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('13','',NULL,'gal1.jpg','','','5',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('19','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('20','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('21','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('22','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('23','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('24','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('25','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('26','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('27','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('28','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('29','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('30','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('31','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('32','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('33','',NULL,'','','','8',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('34','',NULL,'lutador1.jpg','','','9',NULL);
REPLACE INTO "global_content" ("cod_default_content", "autor", "data_criacao", "path_imagem_pequena", "path_imagem_grande", "capa", "cod_category", "cod_gallery") VALUES
	('35','',NULL,'lutador1.jpg','','','9',NULL);
/*!40000 ALTER TABLE "global_content" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'mensagem_usuario'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "mensagem_usuario" (
  "cod_message" bigint(20) NOT NULL auto_increment,
  "mensagem" varchar(255) default NULL,
  "cod_user" bigint(20) default NULL,
  PRIMARY KEY  ("cod_message"),
  KEY "FK89EA051A6367EE2B" ("cod_user"),
  CONSTRAINT "FK89EA051A6367EE2B" FOREIGN KEY ("cod_user") REFERENCES "simple_user" ("cod_user")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'mensagem_usuario'
#

# (No data found.)



#
# Table structure for table 'news_letter'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "news_letter" (
  "cod_news_letter" bigint(20) NOT NULL auto_increment,
  "dataCriacao" varchar(255) default NULL,
  "email_criador" varchar(255) default NULL,
  "assunto" varchar(255) default NULL,
  "tipo_destinatario" int(11) default NULL,
  "link_descadastro" bit(1) default NULL,
  "corpo_html" text,
  "path_arquivo" varchar(255) default NULL,
  "link" varchar(255) default NULL,
  "porcentagem_enviada" decimal(19,2) default NULL,
  "quantidade_enviada" int(11) default NULL,
  "data_envio" varchar(255) default NULL,
  "corpo_alterado" text,
  PRIMARY KEY  ("cod_news_letter")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'news_letter'
#

# (No data found.)



#
# Table structure for table 'opcao_enquete'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "opcao_enquete" (
  "cod_option" bigint(20) NOT NULL auto_increment,
  "titulo" varchar(255) default NULL,
  "votos" int(11) default NULL,
  "publicar" bit(1) default NULL,
  "cod_enquete" bigint(20) default NULL,
  PRIMARY KEY  ("cod_option"),
  KEY "FK64027EFA6A364681" ("cod_enquete"),
  CONSTRAINT "FK64027EFA6A364681" FOREIGN KEY ("cod_enquete") REFERENCES "enquete" ("cod_enquete")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'opcao_enquete'
#

# (No data found.)



#
# Table structure for table 'pais'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "pais" (
  "cod_pais" bigint(20) NOT NULL auto_increment,
  "nome" varchar(255) default NULL,
  PRIMARY KEY  ("cod_pais")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'pais'
#

LOCK TABLES "pais" WRITE;
/*!40000 ALTER TABLE "pais" DISABLE KEYS;*/
REPLACE INTO "pais" ("cod_pais", "nome") VALUES
	('1','Afeganistão');
REPLACE INTO "pais" ("cod_pais", "nome") VALUES
	('2','Africa do Sul');
REPLACE INTO "pais" ("cod_pais", "nome") VALUES
	('3','Albânia');
REPLACE INTO "pais" ("cod_pais", "nome") VALUES
	('4','Alemanha');
REPLACE INTO "pais" ("cod_pais", "nome") VALUES
	('5','Andorra');
REPLACE INTO "pais" ("cod_pais", "nome") VALUES
	('6','Brasil');
/*!40000 ALTER TABLE "pais" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'payment_data'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "payment_data" (
  "cod_payment_data" bigint(20) NOT NULL,
  "tipo_dado_pagamento" varchar(6) NOT NULL,
  "cod_condicao_pagamento" bigint(20) default NULL,
  "lr" varchar(255) default NULL,
  "order_id" varchar(255) default NULL,
  "tid" varchar(255) default NULL,
  "arp" varchar(255) default NULL,
  "lr_captura" varchar(255) default NULL,
  "ars" varchar(255) default NULL,
  "ref_tran" varchar(255) default NULL,
  PRIMARY KEY  ("cod_payment_data"),
  KEY "FKE259CA432E8B1460" ("cod_condicao_pagamento"),
  KEY "FKE259CA43669E16F4" ("cod_payment_data"),
  CONSTRAINT "FKE259CA432E8B1460" FOREIGN KEY ("cod_condicao_pagamento") REFERENCES "condicao_pagamento" ("cod_condicao_pagamento"),
  CONSTRAINT "FKE259CA43669E16F4" FOREIGN KEY ("cod_payment_data") REFERENCES "compra" ("cod_compra")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'payment_data'
#

# (No data found.)



#
# Table structure for table 'payment_form'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "payment_form" (
  "cod_payment_form" bigint(20) NOT NULL auto_increment,
  "tipo_pagamento" varchar(4) NOT NULL,
  "indice" int(11) default NULL,
  "nome" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "publicar" bit(1) default NULL,
  "url_processa_operacao" varchar(255) default NULL,
  "url_retorno_pos_operacao" varchar(255) default NULL,
  "cancel_url" varchar(255) default NULL,
  "path_imagem_pequena" varchar(255) default NULL,
  "path_imagem_grande" varchar(255) default NULL,
  "id_conv" varchar(255) default NULL,
  "ref_tran" varchar(255) default NULL,
  "url_informa" varchar(255) default NULL,
  "url_sonda" varchar(255) default NULL,
  "url_retorno_cliente" varchar(255) default NULL,
  "url_retorno_visa" varchar(255) default NULL,
  "merchant_name" varchar(255) default NULL,
  "merchant_id" varchar(255) default NULL,
  "jurosCartao" decimal(19,2) default NULL,
  "business_id" varchar(255) default NULL,
  "currency_code" varchar(255) default NULL,
  "cancel_return_url" varchar(255) default NULL,
  "return_url" varchar(255) default NULL,
  "conta" varchar(255) default NULL,
  PRIMARY KEY  ("cod_payment_form")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'payment_form'
#

# (No data found.)



#
# Table structure for table 'pedido'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "pedido" (
  "cod_pedido" bigint(20) NOT NULL auto_increment,
  "quantidade_itens" int(11) default NULL,
  "valor_total" decimal(19,2) default NULL,
  "situacao" int(11) default NULL,
  "data_pedido" varchar(255) default NULL,
  "data_conclusao" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "cod_user" bigint(20) default NULL,
  PRIMARY KEY  ("cod_pedido"),
  KEY "FKC4DD17456367EE2B" ("cod_user"),
  KEY "cod_compra" ("cod_pedido"),
  CONSTRAINT "cod_compra" FOREIGN KEY ("cod_pedido") REFERENCES "compra" ("cod_compra"),
  CONSTRAINT "FKC4DD17456367EE2B" FOREIGN KEY ("cod_user") REFERENCES "simple_user" ("cod_user")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'pedido'
#

# (No data found.)



#
# Table structure for table 'product'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "product" (
  "cod_product" bigint(20) NOT NULL auto_increment,
  "nome" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "codigo_loja" varchar(255) default NULL,
  "preco" decimal(19,2) default NULL,
  "quantidade" int(11) default NULL,
  "quantidade_em_espera" int(11) default NULL,
  "publicar" bit(1) default NULL,
  "descricao_especifica" varchar(255) default NULL,
  "recomendado" bit(1) default NULL,
  "vitrine" bit(1) default NULL,
  "peso" double default NULL,
  "nome_imagem_pequena" varchar(255) default NULL,
  "nome_imagem_grande" varchar(255) default NULL,
  "data_publicacao_promocao" varchar(255) default NULL,
  "data_saida_promocao" varchar(255) default NULL,
  "desconto_promocao" float default NULL,
  "indice" int(11) default NULL,
  PRIMARY KEY  ("cod_product")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'product'
#

# (No data found.)



#
# Table structure for table 'produto_categoria'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "produto_categoria" (
  "cod_category_product" bigint(20) NOT NULL,
  "cod_product" bigint(20) NOT NULL,
  PRIMARY KEY  ("cod_product","cod_category_product"),
  KEY "FK2C076DB35A37CB" ("cod_product"),
  KEY "FK2C076DE0F47A5A" ("cod_category_product"),
  CONSTRAINT "FK2C076DB35A37CB" FOREIGN KEY ("cod_product") REFERENCES "product" ("cod_product"),
  CONSTRAINT "FK2C076DE0F47A5A" FOREIGN KEY ("cod_category_product") REFERENCES "category_product" ("cod_category_product")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'produto_categoria'
#

# (No data found.)



#
# Table structure for table 'produto_cupom'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "produto_cupom" (
  "cod_cupom" bigint(20) NOT NULL,
  "cod_produto" bigint(20) NOT NULL,
  PRIMARY KEY  ("cod_cupom","cod_produto"),
  KEY "FK2F314BD6B35A39D5" ("cod_produto"),
  KEY "FK2F314BD6CFFBB793" ("cod_cupom"),
  CONSTRAINT "FK2F314BD6B35A39D5" FOREIGN KEY ("cod_produto") REFERENCES "product" ("cod_product"),
  CONSTRAINT "FK2F314BD6CFFBB793" FOREIGN KEY ("cod_cupom") REFERENCES "cupom" ("cod_cupom")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'produto_cupom'
#

# (No data found.)



#
# Table structure for table 'ranking_product'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "ranking_product" (
  "cod_ranking_product" bigint(20) NOT NULL auto_increment,
  "quantidade_visita" int(11) default NULL,
  PRIMARY KEY  ("cod_ranking_product")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'ranking_product'
#

# (No data found.)



#
# Table structure for table 'section'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "section" (
  "cod_section" bigint(20) NOT NULL auto_increment,
  "codigo" varchar(255) default NULL,
  "nome" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "cod_site" bigint(20) default NULL,
  PRIMARY KEY  ("cod_section"),
  KEY "FK756F7EE56F4A362D" ("cod_site"),
  CONSTRAINT "FK756F7EE56F4A362D" FOREIGN KEY ("cod_site") REFERENCES "site" ("cod_site")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'section'
#

LOCK TABLES "section" WRITE;
/*!40000 ALTER TABLE "section" DISABLE KEYS;*/
REPLACE INTO "section" ("cod_section", "codigo", "nome", "descricao", "cod_site") VALUES
	('1','capa_texto','Capa / Apresentação',NULL,'1');
/*!40000 ALTER TABLE "section" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'shopping_car_item'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "shopping_car_item" (
  "cod_shopping_car_item" bigint(20) NOT NULL auto_increment,
  "quantidade_solicitado" int(11) default NULL,
  "preco_momento" decimal(19,2) default NULL,
  "cod_product" bigint(20) default NULL,
  "cod_pedido" bigint(20) default NULL,
  PRIMARY KEY  ("cod_shopping_car_item"),
  KEY "FK7067CD95B35A37CB" ("cod_product"),
  KEY "FK7067CD9562AE3786" ("cod_pedido"),
  CONSTRAINT "FK7067CD9562AE3786" FOREIGN KEY ("cod_pedido") REFERENCES "pedido" ("cod_pedido"),
  CONSTRAINT "FK7067CD95B35A37CB" FOREIGN KEY ("cod_product") REFERENCES "product" ("cod_product")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'shopping_car_item'
#

# (No data found.)



#
# Table structure for table 'simple_user'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "simple_user" (
  "cod_user" bigint(20) NOT NULL auto_increment,
  "tipo_pessoa" varchar(2) NOT NULL,
  "nome" varchar(255) default NULL,
  "celular" varchar(255) default NULL,
  "email" varchar(255) default NULL,
  "empresa" varchar(255) default NULL,
  "login" varchar(255) default NULL,
  "msn" varchar(255) default NULL,
  "papel" int(11) default NULL,
  "segmento" varchar(255) default NULL,
  "senha" varchar(255) default NULL,
  "telefone" varchar(255) default NULL,
  "newsLetter" bit(1) default NULL,
  "data_cadastro" varchar(255) default NULL,
  "liberacao_acesso" bit(1) default NULL,
  "ddd" varchar(255) default NULL,
  "sobre_nome" varchar(255) default NULL,
  "cod_estado" bigint(20) default NULL,
  "cod_pais" bigint(20) default NULL,
  "cod_category_user" bigint(20) default NULL,
  "contato" varchar(255) default NULL,
  "cnpj" varchar(255) default NULL,
  "cargo" varchar(255) default NULL,
  "cpf" varchar(255) default NULL,
  "dataNascimento" varchar(255) default NULL,
  "rg" varchar(255) default NULL,
  "sexo" varchar(255) default NULL,
  PRIMARY KEY  ("cod_user"),
  KEY "FKAB6EB238310300A" ("cod_estado"),
  KEY "FKAB6EB238FF41CAB3" ("cod_category_user"),
  KEY "FKAB6EB238525ABA74" ("cod_pais"),
  CONSTRAINT "FKAB6EB238310300A" FOREIGN KEY ("cod_estado") REFERENCES "estado" ("cod_estado"),
  CONSTRAINT "FKAB6EB238525ABA74" FOREIGN KEY ("cod_pais") REFERENCES "pais" ("cod_pais"),
  CONSTRAINT "FKAB6EB238FF41CAB3" FOREIGN KEY ("cod_category_user") REFERENCES "category_user" ("cod_category_user")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'simple_user'
#

LOCK TABLES "simple_user" WRITE;
/*!40000 ALTER TABLE "simple_user" DISABLE KEYS;*/
REPLACE INTO "simple_user" ("cod_user", "tipo_pessoa", "nome", "celular", "email", "empresa", "login", "msn", "papel", "segmento", "senha", "telefone", "newsLetter", "data_cadastro", "liberacao_acesso", "ddd", "sobre_nome", "cod_estado", "cod_pais", "cod_category_user", "contato", "cnpj", "cargo", "cpf", "dataNascimento", "rg", "sexo") VALUES
	('1','PF','Administrador',NULL,'admin@easycm.com.br',NULL,'administrador',NULL,3,NULL,'e10adc3949ba59abbe56e057f20f883e',NULL,'
',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE "simple_user" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'site'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "site" (
  "cod_site" bigint(20) NOT NULL auto_increment,
  "nome" varchar(255) default NULL,
  "descricao" varchar(255) default NULL,
  "codigo" varchar(255) default NULL,
  "publicar" bit(1) default NULL,
  PRIMARY KEY  ("cod_site")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'site'
#

LOCK TABLES "site" WRITE;
/*!40000 ALTER TABLE "site" DISABLE KEYS;*/
REPLACE INTO "site" ("cod_site", "nome", "descricao", "codigo", "publicar") VALUES
	('1','Prime MMA',NULL,'site_prime','
');
/*!40000 ALTER TABLE "site" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'system_configuration'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "system_configuration" (
  "cod_sys_configuration" bigint(20) NOT NULL auto_increment,
  "smtp_server" varchar(255) default NULL,
  "smtp_login" varchar(255) default NULL,
  "smtp_password" varchar(255) default NULL,
  "site_context_path" varchar(255) default NULL,
  "db_login" varchar(255) default NULL,
  "db_password" varchar(255) default NULL,
  "db_url" varchar(255) default NULL,
  "db_name" varchar(255) default NULL,
  "db_driver" varchar(255) default NULL,
  "db_dialect" varchar(255) default NULL,
  "db_pool" varchar(255) default NULL,
  "instalado" bit(1) default NULL,
  "context_name" varchar(255) default NULL,
  "url_site" varchar(255) default NULL,
  PRIMARY KEY  ("cod_sys_configuration")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'system_configuration'
#

LOCK TABLES "system_configuration" WRITE;
/*!40000 ALTER TABLE "system_configuration" DISABLE KEYS;*/
REPLACE INTO "system_configuration" ("cod_sys_configuration", "smtp_server", "smtp_login", "smtp_password", "site_context_path", "db_login", "db_password", "db_url", "db_name", "db_driver", "db_dialect", "db_pool", "instalado", "context_name", "url_site") VALUES
	('1','','','','C:\sites\jakarta-tomcat-5.5.9\webapps\prime',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'/prime','http://localhost');
/*!40000 ALTER TABLE "system_configuration" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'user_click_news'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "user_click_news" (
  "cod_user_click_news" bigint(20) NOT NULL auto_increment,
  "diferenca" int(11) default NULL,
  "quantidade" int(11) default NULL,
  "cod_news_letter" bigint(20) default NULL,
  PRIMARY KEY  ("cod_user_click_news"),
  KEY "FK2143601E2261669B" ("cod_news_letter"),
  CONSTRAINT "FK2143601E2261669B" FOREIGN KEY ("cod_news_letter") REFERENCES "news_letter" ("cod_news_letter")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'user_click_news'
#

# (No data found.)



#
# Table structure for table 'user_news'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "user_news" (
  "cod_user_news" bigint(20) NOT NULL auto_increment,
  "identificador_news" bigint(20) default NULL,
  "identificador_user" bigint(20) default NULL,
  PRIMARY KEY  ("cod_user_news")
) /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'user_news'
#

# (No data found.)

/*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/