14 lines
470 B
SQL
14 lines
470 B
SQL
-- 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) ;
|