-- FAnalysis.PRICING.lastprice definition

-- Drop table

-- DROP TABLE FAnalysis.PRICING.lastprice;

CREATE TABLE pricing.lastprice (
	customer    varchar(255)    COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	mold        varchar(255)    COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	part_stats  nvarchar(MAX)   COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
);

CREATE UNIQUE NONCLUSTERED INDEX lastprice_cust_mold ON FAnalysis.PRICING.lastprice (customer ASC, mold ASC)  ;