Muitas pessoas ja me perguntaram o que é md5!
Então vamos a Respota!
O que é MD5 ?
MD5 é um esquema de encriptação de dados, em que transforma o dado em um codigo.
Para que serve ?
Serve para:
Exemplo: Quando você cria um login e senha, utilizando um programa/site com md5, o programa/site ira converter a senha para um codigo especifico, criptografado, e armazena-lo no seu banco de dados.
Vantagens ?
Os servidores com base na versão 99.6XT utilizam MD5 para aumentar a segurança. isso tambem aumenta a segurança dos sites de Muonline.
Desvantagens ?
Colocar um site em md5 apenas complica um pouco mais o seu desenvolvimento, e a grande maioria dos sites de muonline são sem md5. então pra evitar mais trabalho com o site, alguns desenvolvedores retiram o md5 dos seus servidores, substituindo arquivos, tabelas e procedimentos do banco de dados, diminuindo a segurança geral, tanto do site quanto do servidor.
Dica:
Faça seu Site sem MD5!
Retirando MD5 de seu servido., apenas rode está query
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MANG_INFO]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MANG_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_INFO]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MEMB_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_OUT]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MEMB_OUT]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MembInfoModify]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MembInfoModify]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_CURR_INFO]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_CURR_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_FQNW_INFO]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_FQNW_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_MIDS_INFO]') and
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) COLLATE Polish_CI_AS NOT NULL ,
[mang__pwd] [nvarchar] (15) COLLATE Polish_CI_AS NOT NULL ,
[mang_name] [nvarchar] (20) COLLATE Polish_CI_AS NOT NULL ,
[mail_addr] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,
[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) COLLATE Polish_CI_AS NOT NULL ,
[ctl1_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,
[Group_code] [nvarchar] (2) COLLATE Polish_CI_AS NULL ,
[dep_code] [nvarchar] (4) COLLATE Polish_CI_AS NOT NULL ,
[perm] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MEMB_INFO] (
[memb_guid] [int] IDENTITY (1, 1) NOT NULL ,
[memb___id] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[memb__pwd] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[memb_name] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[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) NOT NULL COLLATE Polish_CI_AS,
[Ctl1_code] [] char (1) NOT NULL COLLATE Polish_CI_AS,
[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) NOT NULL COLLATE Polish_CI_AS,
[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] [int NULL],
[Bill_Value] [int NULL],
[Bill_Hour] [int NULL],
[Surplus_Point] [int NULL],
[Surplus_Minute] datetime [] NULL,
[Increase_Days] [int] NULL
) 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] (NULL 8) Polish_CI_AS COLLATE não,
[Ctl1_code [] nvarchar] (1) NOT NULL COLLATE Polish_CI_AS,
[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] (NULL 8) Polish_CI_AS COLLATE não,
[Chek_code] [nvarchar] (1) NOT NULL COLLATE Polish_CI_AS,
[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
) ON [] PRIMARY] TEXTIMAGE_ON [PRIMARY
GO
ALTER TABLE ALTER COLUMN MEMB_INFO memb__pwd VARCHAR (10) NOT NULL
GO
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MANG_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_INFO]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MEMB_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_OUT]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MEMB_OUT]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MembInfoModify]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MembInfoModify]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_CURR_INFO]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_CURR_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_FQNW_INFO]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VI_FQNW_INFO]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_MIDS_INFO]') and
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) COLLATE Polish_CI_AS NOT NULL ,
[mang__pwd] [nvarchar] (15) COLLATE Polish_CI_AS NOT NULL ,
[mang_name] [nvarchar] (20) COLLATE Polish_CI_AS NOT NULL ,
[mail_addr] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,
[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) COLLATE Polish_CI_AS NOT NULL ,
[ctl1_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,
[Group_code] [nvarchar] (2) COLLATE Polish_CI_AS NULL ,
[dep_code] [nvarchar] (4) COLLATE Polish_CI_AS NOT NULL ,
[perm] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MEMB_INFO] (
[memb_guid] [int] IDENTITY (1, 1) NOT NULL ,
[memb___id] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[memb__pwd] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[memb_name] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,
[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) NOT NULL COLLATE Polish_CI_AS,
[Ctl1_code] [] char (1) NOT NULL COLLATE Polish_CI_AS,
[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) NOT NULL COLLATE Polish_CI_AS,
[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] [int NULL],
[Bill_Value] [int NULL],
[Bill_Hour] [int NULL],
[Surplus_Point] [int NULL],
[Surplus_Minute] datetime [] NULL,
[Increase_Days] [int] NULL
) 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] (NULL 8) Polish_CI_AS COLLATE não,
[Ctl1_code [] nvarchar] (1) NOT NULL COLLATE Polish_CI_AS,
[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] (NULL 8) Polish_CI_AS COLLATE não,
[Chek_code] [nvarchar] (1) NOT NULL COLLATE Polish_CI_AS,
[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
) ON [] PRIMARY] TEXTIMAGE_ON [PRIMARY
GO
ALTER TABLE ALTER COLUMN MEMB_INFO memb__pwd VARCHAR (10) NOT NULL
GO


0 comentários:
Postar um comentário