quarta-feira, 23 de fevereiro de 2011

MD5?

• O Que e MD5?
Muitas PESSOAS ja me perguntaram o Que e md5!
Entao vamos a Respota!
O Que e MD5?
MD5 e Um Esquema de encriptação de Dados, in Que transformações dado o codigo eh em.
Que Pará servir?
Sirva parágrafo:
Exemplo: Quando VOCÊ CRIA UM login e senha, Programa hum utilizando com site / md5, o Programa / conversor ira site Nova senha parágrafo Específico codigo eh, criptografado, e armazena-lo sem Seu Banco de Dados.
Vantagens?
Os Servidores com base nd version 99.6XT utilizam parágrafo MD5 Aumentar a Segurança. aumenta tambem ISSO Segurança um dos sites de Muonline.
Desvantagens?

Colocar in site eh md5 apenas complica UM POUCO Mais o Seu Desenvolvimento, eA grande maioria dos sites de MEV São muonline md5. entao pra evitar Mais Trabalho com o site, alguns desenvolvedores retiram o md5 dos Servidores SEUS, Arquivos Substituindo, Procedimentos e Tabelas do Banco de Dados, diminuindo uma Segurança Geral, Tanto faz QUANTO site do Servidor.
Dica:
Faca SEM MD5 Seu Site!
Retirando MD5 servido de Seu., Apenas andava estabele consulta
Se existe (SELECT * FROM dbo.sysobjects where id = object_id (N '[dbo]. [MANG_INFO]') e 
OBJECTPROPERTY (id, N'IsUserTable ') = 1)
drop table [dbo]. [MANG_INFO]
GO

Se existe (SELECT * FROM dbo.sysobjects where id = object_id (N '[dbo]. [MEMB_INFO]') e 
OBJECTPROPERTY (id, N'IsUserTable ') = 1)
drop table [dbo]. [MEMB_INFO]
GO

Se existe (SELECT * FROM dbo.sysobjects where id = object_id (N '[dbo]. [MEMB_OUT]') e 
OBJECTPROPERTY (id, N'IsUserTable ') = 1)
DROP TABLE [dbo]. [MEMB_OUT]
GO

Se existe (SELECT * FROM dbo.sysobjects where id = object_id (N '[dbo]. [MembInfoModify]') e 
OBJECTPROPERTY (id, N'IsUserTable ') = 1)
DROP TABLE [dbo]. [MembInfoModify]
GO

Se existe (SELECT * FROM dbo.sysobjects where id = object_id (N '[dbo]. [VI_CURR_INFO]') e 
OBJECTPROPERTY (id, N'IsUserTable ') = 1)
drop table [dbo]. [VI_CURR_INFO]
GO

Se existe (SELECT * FROM dbo.sysobjects where id = object_id (N '[dbo]. [VI_FQNW_INFO]') e 
OBJECTPROPERTY (id, N'IsUserTable ') = 1)
drop table [dbo]. [VI_FQNW_INFO]
GO

Se existe (SELECT * FROM dbo.sysobjects where id = object_id (N '[dbo]. [VI_MIDS_INFO]') e 
OBJECTPROPERTY (id, N'IsUserTable ') = 1)
drop table [dbo]. [VI_MIDS_INFO]
GO

CREATE TABLE [dbo]. [MANG_INFO] (
[Mang_guid] [int] NOT NULL,
[Mang___id] [nvarchar] (15) NOT NULL COLLATE Polish_CI_AS,
[Mang__pwd] [nvarchar] (15) NOT NULL COLLATE Polish_CI_AS,
[Mang_name] [nvarchar] (20) NOT NULL COLLATE Polish_CI_AS,
[Mail_addr] [nvarchar] (50) NOT NULL COLLATE Polish_CI_AS,
[Levl_name] [nvarchar] (30) COLLATE Polish_CI_AS NULL,
[Part_name] [nvarchar] (30) COLLATE Polish_CI_AS NULL,
[Auth_code] [nvarchar] (30) COLLATE Polish_CI_AS NULL,
[Appl_days] [nvarchar] (8) NOT NULL COLLATE Polish_CI_AS,
[Ctl1_code] [nvarchar] (1) Polish_CI_AS COLLATE NOT NULL,
[Group_code] [nvarchar] (2) COLLATE Polish_CI_AS NULL,
[Dep_code] [nvarchar] (4) NOT NULL COLLATE Polish_CI_AS,
[Perm] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo]. [MEMB_INFO] (
[Memb_guid] [int] IDENTITY (1, 1) NOT NULL,
[Memb___id] [varchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Memb__pwd] [varchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Memb_name] [varchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Sno__numb] [char] (13) NOT NULL COLLATE Polish_CI_AS,
[Post_code] [char] (6) COLLATE Polish_CI_AS NULL,
[Addr_info] [varchar] (50) COLLATE Polish_CI_AS NULL,
[Addr_deta] [varchar] (50) COLLATE Polish_CI_AS NULL,
[Tel__numb] [varchar] (20) COLLATE Polish_CI_AS NULL,
[Phon_numb] [varchar] (15) COLLATE Polish_CI_AS NULL,
[Mail_addr] [varchar] (50) COLLATE Polish_CI_AS NULL,
[Fpas_ques] [varchar] (50) COLLATE Polish_CI_AS NULL,
[Fpas_answ] [varchar] (50) COLLATE Polish_CI_AS NULL,
[Job__code] [char] (2) COLLATE Polish_CI_AS NULL,
[Appl_days] [datetime] NULL,
[Modi_days] [datetime] NULL,
[Out__days] [datetime] NULL,
[True_days] [datetime] NULL,
[Mail_chek] [char] (1) COLLATE Polish_CI_AS NULL,
[Bloc_code] [char] (1) Polish_CI_AS COLLATE NOT NULL,
[Ctl1_code] [char] (1) Polish_CI_AS COLLATE NOT NULL,
[Adminaccess] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo]. [MEMB_OUT] (
[Out__guid] [int] NOT NULL,
[Memb_guid] [int] NOT NULL,
[Sno__numb] [nvarchar] (7) COLLATE Polish_CI_AS NULL,
[Memb_name] [nvarchar] (15) COLLATE Polish_CI_AS NULL,
[Appl_days] [smalldatetime] NULL,
[Ctl1_code] [nvarchar] (1) COLLATE Polish_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo]. [MembInfoModify] (
[Número] [int] NOT NULL,
[Memb___id] [nvarchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Memb__pwd] [nvarchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Memb_name] [nvarchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Sno__numb] [nvarchar] (13) NOT NULL COLLATE Polish_CI_AS,
[Tel__numb] [nvarchar] (20) COLLATE Polish_CI_AS NULL,
[Phon_numb] [nvarchar] (15) COLLATE Polish_CI_AS NULL,
[Mail_addr] [nvarchar] (50) COLLATE Polish_CI_AS NULL,
[Fpas_ques] [nvarchar] (50) COLLATE Polish_CI_AS NULL,
[Fpas_answ] [nvarchar] (50) COLLATE Polish_CI_AS NULL,
[Bloc_code] [nvarchar] (1) COLLATE Polish_CI_AS NULL
) ON [PRIMARY]

GO

CREATE TABLE [dbo]. [VI_CURR_INFO] (
[Ends_days] [nvarchar] (8) COLLATE Polish_CI_AS NULL,
[Chek_code] [nvarchar] (1) Polish_CI_AS COLLATE NOT NULL,
[Used_time] [int] NULL,
[Memb___id] [nvarchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Memb_name] [nvarchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Memb_guid] [int] NOT NULL,
[Sno__numb] [nvarchar] (18) NOT NULL COLLATE Polish_CI_AS,
[Bill_Section] NULL int [],
[Bill_Value] NULL int [],
[Bill_Hour] [int] NULL,
[Surplus_Point] NULL int [],
[Surplus_Minute] [datetime] NULL,
[Increase_Days] NULL int []
) ON [PRIMARY]
GO

CREATE TABLE [dbo]. [VI_FQNW_INFO] (
[Appl_code] [nvarchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Ctrl_text] [nvarchar] (50) COLLATE Polish_CI_AS NULL,
[Fpas_ques] [nvarchar] (50) NOT NULL COLLATE Polish_CI_AS,
[Fpas_answ] [nvarchar] (50) NOT NULL COLLATE Polish_CI_AS,
[Appl_days] [nvarchar] (8) NOT NULL COLLATE Polish_CI_AS,
[Ctl1_code] [nvarchar] (1) Polish_CI_AS COLLATE NOT NULL,
[Memb_name] [nvarchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Memb_guid] [int] NOT NULL,
[Fanw_guid] [int] NOT NULL,
[Memb___id] [nvarchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Sno__numb] [nvarchar] (18) NOT NULL COLLATE Polish_CI_AS
) ON [PRIMARY]
GO

CREATE TABLE [dbo]. [VI_MIDS_INFO] (
[Memb___id] [nvarchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Memb_name] [nvarchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Sno__numb] [nvarchar] (18) NOT NULL COLLATE Polish_CI_AS,
[Appl_days] [nvarchar] (8) NOT NULL COLLATE Polish_CI_AS,
[Chek_code] [nvarchar] (1) Polish_CI_AS COLLATE NOT NULL,
[Prev_info] [nvarchar] (50) NOT NULL COLLATE Polish_CI_AS,
[Modi_info] [nvarchar] (10) NOT NULL COLLATE Polish_CI_AS,
[Cont_text] [ntext] Polish_CI_AS COLLATE NOT NULL,
[Mids_guid] [int] NOT NULL,
[Admin_name] [nvarchar] (10) COLLATE Polish_CI_AS NULL
) TEXTIMAGE_ON ON [PRIMARY] [principal]
GO

ALTER TABLE ALTER COLUMN MEMB_INFO memb__pwd VARCHAR (10) NOT NULL
GO

0 comentários:

Postar um comentário