CREATE TABLE HistoricoVenda (
	CodPro CHAR(5) NOT NULL,
	Data DATETIME NOT NULL,
	TipoPreco CHAR(1) NOT NULL DEFAULT '1',
	PrecoVen NUMERIC(18,5) DEFAULT 0)
GO
ALTER TABLE HistoricoVenda ADD CONSTRAINT PK_HistoricoVenda PRIMARY KEY (CodPro,Data,TipoPreco)
GO
