ÿþif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_PERFIL_LOTACAO_FORNECEDOR]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[PERFIL] DROP CONSTRAINT FK_PERFIL_LOTACAO_FORNECEDOR

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ARQUIVO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[ARQUIVO]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ARQUIVO_EXTENSAO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[ARQUIVO_EXTENSAO]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BANNER]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[BANNER]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CAMINHO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[CAMINHO]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CONTATO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[CONTATO]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CONTEUDO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[CONTEUDO]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CONTROLE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[CONTROLE]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ENQUETE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[ENQUETE]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FAQ]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[FAQ]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FORUM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[FORUM]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LOTACAO_FORNECEDOR]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[LOTACAO_FORNECEDOR]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PERFIL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[PERFIL]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RH_CARGO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[RH_CARGO]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RH_CURSO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[RH_CURSO]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RH_EXPERIENCIA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[RH_EXPERIENCIA]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RH_FORMACAO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[RH_FORMACAO]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RH_IDIOMA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[RH_IDIOMA]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RH_INFORMATICA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[RH_INFORMATICA]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RH_REFERENCIA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[RH_REFERENCIA]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RH_USUARIO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[RH_USUARIO]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SESSAO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[SESSAO]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TEMA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[TEMA]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[USUARIO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[USUARIO]

GO



CREATE TABLE [dbo].[ARQUIVO] (

	[COD_ARQUIVO] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[CODIGO] [numeric](18, 0) NULL ,

	[CONTROLE_TABELA_BD] [numeric](18, 0) NULL ,

	[DESC_IMAGEM] [varchar] (100) COLLATE Latin1_General_CI_AS NOT NULL ,

	[CAMINHO_ARQUIVO] [varchar] (1000) COLLATE Latin1_General_CI_AS NULL ,

	[ARQUIVO_PRINCIPAL] [int] NULL ,

	[COD_EXTENSAO] [numeric](10, 0) NULL ,

	[LEGENDA] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,

	[NOME_ARQUIVO] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

	[COD_USUARIO] [numeric](18, 0) NULL ,

	[ATIVO] [numeric](18, 0) NULL ,

	[CONTROLE_IDIOMA] [numeric](18, 0) NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[ARQUIVO_EXTENSAO] (

	[COD_EXTENSAO] [numeric](18, 0) NOT NULL ,

	[NOME_EXTENSAO] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,

	[CONTROLE_ARQUIVO] [numeric](18, 0) NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[BANNER] (

	[COD_BANNER] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_BANNER_LOG] [numeric](18, 0) NOT NULL ,

	[NOME_BANNER] [varchar] (100) COLLATE Latin1_General_CI_AS NOT NULL ,

	[CAMINHO_BANNER] [varchar] (2000) COLLATE Latin1_General_CI_AS NOT NULL ,

	[COD_USUARIO] [numeric](18, 0) NOT NULL ,

	[CONTROLE_VERSAO] [numeric](18, 0) NOT NULL ,

	[CONTROLE_TAMANHO] [numeric](18, 0) NOT NULL ,

	[APARECER_PORTAL] [numeric](18, 0) NOT NULL ,

	[CONTROLE_LOG] [numeric](18, 0) NOT NULL ,

	[DATA_LOG] [datetime] NOT NULL ,

	[LINK_BANNER] [varchar] (2000) COLLATE Latin1_General_CI_AS NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[CAMINHO] (

	[COD_CAMINHO] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[CONTROLE_CONTEUDO] [numeric](10, 0) NULL ,

	[CAMINHO] [varchar] (5000) COLLATE Latin1_General_CI_AS NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[CONTATO] (

	[COD_CONTATO] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_CONTATO_LOG] [numeric](18, 0) NOT NULL ,

	[CONTROLE_CONTATO] [numeric](10, 0) NOT NULL ,

	[COD_USU_CONTATO] [numeric](18, 0) NOT NULL ,

	[CONTEUDO_CONTATO] [text] COLLATE Latin1_General_CI_AS NOT NULL ,

	[CONTROLE_TEMA] [numeric](10, 0) NOT NULL ,

	[CONTEUDO_RESPOSTA] [text] COLLATE Latin1_General_CI_AS NULL ,

	[DATA_CONTATO_LOG] [datetime] NOT NULL ,

	[COD_USU_RESPOSTA] [numeric](18, 0) NULL ,

	[CONTROLE_LOG_CONTATO] [numeric](18, 0) NOT NULL ,

	[CONTROLE_VERSAO] [numeric](18, 0) NOT NULL 

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[CONTEUDO] (

	[COD_CONTEUDO] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_CONTEUDO_LOG] [numeric](18, 0) NULL ,

	[CONTROLE_CONTEUDO] [numeric](10, 0) NULL ,

	[CONTROLE_IDIOMA] [numeric](10, 0) NULL ,

	[COD_TEMA] [numeric](18, 0) NULL ,

	[TITULO_CONTEUDO] [varchar] (60) COLLATE Latin1_General_CI_AS NULL ,

	[DESCRICAO_CONTEUDO] [varchar] (500) COLLATE Latin1_General_CI_AS NULL ,

	[CONTEUDO_TEXTO] [text] COLLATE Latin1_General_CI_AS NULL ,

	[FONTE_CONTEUDO] [varchar] (60) COLLATE Latin1_General_CI_AS NULL ,

	[DT_CONTEUDO] [datetime] NULL ,

	[LOCAL_AGENDA] [varchar] (200) COLLATE Latin1_General_CI_AS NULL ,

	[DT_H_AGENDA_INICIO] [datetime] NULL ,

	[DT_H_AGENDA_FIM] [datetime] NULL ,

	[COD_USU_CONTEUDO] [numeric](18, 0) NULL ,

	[NOME_AUTOR] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

	[DESTAQUE] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[DESTAQUE_ADM] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[DT_DESTAQUE_INICIO] [datetime] NULL ,

	[DT_DESTAQUE_FIM] [datetime] NULL ,

	[CONTROLE_DESTAQUE] [numeric](18, 0) NULL ,

	[CONTROLE_APROVA] [numeric](18, 0) NULL ,

	[CONTROLE_VERSAO] [numeric](18, 0) NULL ,

	[CONTROLE_LOG] [numeric](18, 0) NULL ,

	[DT_LOG_CONTEUDO] [datetime] NULL ,

	[JUSTIFICA_CONTEUDO] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

	[DT_AGENDA_INICIO_DIVULGA] [datetime] NULL ,

	[ANO_BIBLIOTECA] [varchar] (4) COLLATE Latin1_General_CI_AS NULL 

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[CONTROLE] (

	[COD_CONTROLE] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[ID_CONTROLE] [numeric](18, 0) NOT NULL ,

	[GRUPO_CONTROLE] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,

	[NOME_CONTROLE] [varchar] (500) COLLATE Latin1_General_CI_AS NOT NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[ENQUETE] (

	[COD_ENQUETE] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_ENQUETE_LOG] [numeric](18, 0) NULL ,

	[CONTROLE_IDIOMA] [numeric](18, 0) NULL ,

	[COD_USUARIO] [numeric](18, 0) NULL ,

	[PERGUNTA] [text] COLLATE Latin1_General_CI_AS NOT NULL ,

	[RESPOSTA1] [text] COLLATE Latin1_General_CI_AS NOT NULL ,

	[RESPOSTA2] [text] COLLATE Latin1_General_CI_AS NOT NULL ,

	[RESPOSTA3] [text] COLLATE Latin1_General_CI_AS NULL ,

	[DATA_INICIO] [datetime] NULL ,

	[DATA_FIM] [datetime] NULL ,

	[APROVA] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[TOTAL_RESPOSTA1] [numeric](18, 0) NULL ,

	[TOTAL_RESPOSTA2] [numeric](18, 0) NULL ,

	[TOTAL_RESPOSTA3] [numeric](18, 0) NULL ,

	[CONTROLE_VERSAO] [numeric](18, 0) NULL ,

	[CONTROLE_LOG] [numeric](18, 0) NULL ,

	[DT_LOG_ENQUETE] [datetime] NULL ,

	[JUSTIFICA_ENQUETE] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

	[CONTROLE_APROVA] [numeric](18, 0) NULL 

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[FAQ] (

	[COD_FAQ] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_FAQ_LOG] [numeric](18, 0) NULL ,

	[PERGUNTA] [varchar] (2000) COLLATE Latin1_General_CI_AS NOT NULL ,

	[RESPOSTA] [varchar] (2000) COLLATE Latin1_General_CI_AS NOT NULL ,

	[COD_USUARIO] [numeric](18, 0) NOT NULL ,

	[CONTROLE_TEMA] [numeric](10, 0) NOT NULL ,

	[CONTROLE_LOG] [numeric](18, 0) NOT NULL ,

	[APROVA] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[DATA_LOG_FAQ] [datetime] NOT NULL ,

	[CONTROLE_VERSAO] [numeric](18, 0) NOT NULL ,

	[CONTROLE_IDIOMA] [numeric](18, 0) NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[FORUM] (

	[COD_FORUM] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_FORUM_LOG] [numeric](18, 0) NULL ,

	[TEMA_FORUM] [varchar] (800) COLLATE Latin1_General_CI_AS NOT NULL ,

	[DESC_FORUM] [text] COLLATE Latin1_General_CI_AS NULL ,

	[DATA_INICIO_FORUM] [datetime] NOT NULL ,

	[DATA_FIM_FORUM] [datetime] NOT NULL ,

	[COD_USU_FORUM] [numeric](18, 0) NULL ,

	[CONTROLE_TEMA] [numeric](10, 0) NOT NULL ,

	[APROVA] [char] (1) COLLATE Latin1_General_CI_AS NOT NULL ,

	[COD_USU_APROVA] [numeric](18, 0) NULL ,

	[COD_USU_MODERADOR] [numeric](18, 0) NOT NULL ,

	[FORUM_MODERADO] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[DATA_LOG_FORUM] [datetime] NOT NULL ,

	[CONTROLE_LOG] [numeric](18, 0) NOT NULL ,

	[FORUM_INTERNO] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[CONTROLE_VERSAO] [char] (1) COLLATE Latin1_General_CI_AS NOT NULL 

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[LOTACAO_FORNECEDOR] (

	[COD_LOTACAO] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[NOME_LOTACAO] [varchar] (200) COLLATE Latin1_General_CI_AS NOT NULL ,

	[FORNECEDOR] [char] (1) COLLATE Latin1_General_CI_AS NOT NULL ,

	[ENDERECO] [varchar] (200) COLLATE Latin1_General_CI_AS NULL ,

	[CNPJ] [varchar] (18) COLLATE Latin1_General_CI_AS NULL ,

	[CONTROLE_FORNECEDOR] [numeric](10, 0) NULL ,

	[ATIVO] [char] (1) COLLATE Latin1_General_CI_AS NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[PERFIL] (

	[COD_PERFIL] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_LOTACAO] [numeric](18, 0) NULL ,

	[COD_USUARIO] [numeric](18, 0) NULL ,

	[CONTROLE_CONTEUDO] [numeric](10, 0) NULL ,

	[INSERIR] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[ALTERAR] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[EXCLUIR] [char] (1) COLLATE Latin1_General_CI_AS NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[RH_CARGO] (

	[COD_CARGO] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[NOME_CARGO] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,

	[DESCRICAO_CARGO] [varchar] (2000) COLLATE Latin1_General_CI_AS NULL ,

	[ATIVO] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[FUNCIONARIO_BB] [char] (1) COLLATE Latin1_General_CI_AS NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[RH_CURSO] (

	[COD_CURSO] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_USUARIO] [numeric](18, 0) NOT NULL ,

	[NOME_CURSO] [varchar] (200) COLLATE Latin1_General_CI_AS NOT NULL ,

	[INSTITUICAO] [varchar] (200) COLLATE Latin1_General_CI_AS NOT NULL ,

	[CONTROLE_SITUACAO_CURSO] [numeric](18, 0) NOT NULL ,

	[MES_ANO_INICIO] [char] (7) COLLATE Latin1_General_CI_AS NULL ,

	[MES_ANO_FIM] [char] (7) COLLATE Latin1_General_CI_AS NULL ,

	[CARGA_HORARIA] [numeric](18, 0) NOT NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[RH_EXPERIENCIA] (

	[COD_EXPERIENCIA] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_USUARIO] [numeric](18, 0) NULL ,

	[EMPRESA] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

	[ATUAL] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[MES_ANO_INICIO] [varchar] (7) COLLATE Latin1_General_CI_AS NULL ,

	[MES_ANO_FIM] [varchar] (7) COLLATE Latin1_General_CI_AS NULL ,

	[CARGO] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,

	[ATIVIDADE] [text] COLLATE Latin1_General_CI_AS NULL ,

	[CONTROLE_TIPO_EXPERIENCIA] [numeric](18, 0) NULL 

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[RH_FORMACAO] (

	[COD_FORMACAO] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_USUARIO] [numeric](18, 0) NULL ,

	[INSTITUICAO] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

	[CONTROLE_SITUACAO] [numeric](18, 0) NULL ,

	[CONTROLE_CURSO] [numeric](18, 0) NULL ,

	[CONTROLE_FORMACAO] [numeric](18, 0) NULL ,

	[ANO_CONCLUSAO] [char] (4) COLLATE Latin1_General_CI_AS NULL ,

	[MES_ANO_INICIO] [varchar] (7) COLLATE Latin1_General_CI_AS NULL ,

	[MES_ANO_FIM] [varchar] (7) COLLATE Latin1_General_CI_AS NULL ,

	[SEMESTRE] [varchar] (4) COLLATE Latin1_General_CI_AS NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[RH_IDIOMA] (

	[COD_IDIOMA] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_USUARIO] [char] (10) COLLATE Latin1_General_CI_AS NULL ,

	[CONTROLE_IDIOMA] [numeric](18, 0) NULL ,

	[CONTROLE_ESCRITA_IDIOMA] [numeric](18, 0) NULL ,

	[CONTROLE_LEITURA_IDIOMA] [numeric](18, 0) NULL ,

	[CONTROLE_CONVERSACAO_IDIOMA] [numeric](18, 0) NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[RH_INFORMATICA] (

	[COD_INFORMATICA] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_USUARIO] [numeric](18, 0) NOT NULL ,

	[COD_CURSO] [numeric](18, 0) NULL ,

	[NOME_CURSO] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

	[CONTROLE_CONHECIMENTO] [numeric](18, 0) NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[RH_REFERENCIA] (

	[COD_REFERENCIA] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[EMPRESA_REFERENCIA] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,

	[CONTATO_REFERENCIA] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,

	[TELEFONE_REFERENCIA] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,

	[COD_USUARIO] [numeric](18, 0) NOT NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[RH_USUARIO] (

	[COD_USUARIO_RH] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[NOME_USU_RH] [varchar] (100) COLLATE Latin1_General_CI_AS NOT NULL ,

	[SEXO_RH] [numeric](18, 0) NOT NULL ,

	[DT_NACIMENTO] [datetime] NOT NULL ,

	[ESTADO_CIVIL] [numeric](18, 0) NOT NULL ,

	[NACIONALIDADE] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,

	[EMPREGADO] [char] (1) COLLATE Latin1_General_CI_AS NOT NULL ,

	[CPF_RH] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,

	[ENDERECO_RH] [varchar] (200) COLLATE Latin1_General_CI_AS NOT NULL ,

	[NUMERO_ENDERECO] [varchar] (8) COLLATE Latin1_General_CI_AS NULL ,

	[COMPLEMENTO] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,

	[BAIRRO] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,

	[CIDADE] [varchar] (80) COLLATE Latin1_General_CI_AS NOT NULL ,

	[UF] [numeric](18, 0) NOT NULL ,

	[CEP] [varchar] (8) COLLATE Latin1_General_CI_AS NULL ,

	[NOME_RECADO] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

	[TELEFONE] [varchar] (10) COLLATE Latin1_General_CI_AS NULL ,

	[CELULAR] [varchar] (10) COLLATE Latin1_General_CI_AS NULL ,

	[EMAIL] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

	[FUNCIONARIO_BB] [char] (1) COLLATE Latin1_General_CI_AS NOT NULL ,

	[VOLUNTARIO] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[CONTROLE_AREA_INTERESSE] [numeric](18, 0) NULL ,

	[ATIVIDADE_VOLUNTARIO] [varchar] (3000) COLLATE Latin1_General_CI_AS NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[SESSAO] (

	[COD_SESSAO] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_SESSAO_LOG] [numeric](18, 0) NULL ,

	[NOME_SESSAO] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,

	[CONTROLE_IDIOMA] [numeric](18, 0) NULL ,

	[COR_SESSAO] [varchar] (50) COLLATE Latin1_General_CI_AS NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[TEMA] (

	[COD_TEMA] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_TEMA_LOG] [numeric](18, 0) NOT NULL ,

	[NOME_TEMA] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,

	[DESCRICAO_TEMA] [text] COLLATE Latin1_General_CI_AS NOT NULL ,

	[LINK] [varchar] (2000) COLLATE Latin1_General_CI_AS NULL ,

	[COD_SESSAO] [numeric](18, 0) NOT NULL ,

	[COD_USUARIO] [numeric](18, 0) NOT NULL ,

	[CONTROLE_LOG] [numeric](18, 0) NOT NULL ,

	[APROVA] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[DATA_LOG_TEMA] [datetime] NOT NULL ,

	[CONTROLE_VERSAO] [numeric](18, 0) NOT NULL ,

	[CONTROLE_IDIOMA] [numeric](18, 0) NOT NULL ,

	[COD_TEMA_PAI] [numeric](18, 0) NULL 

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO



CREATE TABLE [dbo].[USUARIO] (

	[COD_USUARIO] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

	[COD_LOTACAO] [numeric](18, 0) NOT NULL ,

	[NOME_USUARIO] [varchar] (80) COLLATE Latin1_General_CI_AS NOT NULL ,

	[TELEFONE_USUARIO] [varchar] (12) COLLATE Latin1_General_CI_AS NULL ,

	[EMAIL_USUARIO] [varchar] (800) COLLATE Latin1_General_CI_AS NULL ,

	[LOGIN] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,

	[SENHA] [varchar] (10) COLLATE Latin1_General_CI_AS NULL ,

	[INTERNAUTA] [char] (1) COLLATE Latin1_General_CI_AS NOT NULL ,

	[CIDADE] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,

	[CONTROLE_PAIS] [numeric](18, 0) NULL ,

	[ENDERECO] [varchar] (500) COLLATE Latin1_General_CI_AS NULL ,

	[MALA_DIRETA] [char] (1) COLLATE Latin1_General_CI_AS NULL ,

	[ADMINISTRADOR] [char] (1) COLLATE Latin1_General_CI_AS NOT NULL ,

	[ATIVO] [char] (1) COLLATE Latin1_General_CI_AS NOT NULL ,

	[DATA_INICIO_USU] [datetime] NULL ,

	[DATA_FIM_USU] [datetime] NULL ,

	[CEP_USU] [varchar] (10) COLLATE Latin1_General_CI_AS NULL ,

	[CONTROLE_UF] [numeric](18, 0) NULL 

) ON [PRIMARY]

GO