-- makes the QESTLab client/project lists available in the QESTMix database.
--
-- NOTE: Before running this script, please ensure that 'QESTLab' in the string
--       ' QESTLab.dbo...' is replaced with the actual name of your QESTLab database



CREATE VIEW QESTLab_ListClient AS (SELECT * FROM QESTLab.dbo.ListClient)
GO
--CREATE VIEW QESTLab_INTERFACE_List_Client AS (SELECT * FROM QESTLab.dbo.INTERFACE_List_Client)
--GO
CREATE VIEW QESTLab_ListProject AS (SELECT * FROM QESTLab.dbo.ListProject)
GO
--CREATE VIEW QESTLab_INTERFACE_List_Project AS (SELECT * FROM QESTLab.dbo.INTERFACE_List_Project)
--GO




--add appropriate custom fields...
ALTER TABLE DesignProductRelation ADD INTERFACE_UniqueID int NULL
GO
ALTER TABLE ProductMixes ADD INTERFACE_UniqueID int NULL
GO