CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPPMHis ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPPManageHis ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassAcr ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassAll ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassAma ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassAmaPA ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassAmav ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassAsh ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassBay ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassBro ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassCaliber ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassCas ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassCen ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassChe ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassCit ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassCiticore ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassCon ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassConEll ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassConPA ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassConQC ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassCos ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassCre ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassCrown ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassDHi ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassDLo ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassDaw ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassDel ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassDloBackup ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassDoy ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassDun ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassEdenOakHomes ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassElitemd ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassEsq ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassFul ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGol ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGol10mar20 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGre ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGre2 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGreatGulf ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGreatGulf1 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGreatGulfRemove ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGreencity ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGreenland ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGreus ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGreus20Jan21 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGui ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassGyh ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassHaven ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassHer ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassHer03Dec21 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassHig ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassHis ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassHus ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassKin ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterra ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove1 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove10 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove11 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove12 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove13 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove14 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove15 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove16 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove17 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove18 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove19 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove2 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove3 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove4 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove5 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove6 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove7 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove8 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLanterraRemove9 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLiv ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLor ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassLuv ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassMarshall ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassMarz ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassMil ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassMilAuth ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassMilAuth_dev ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassMilTO01Nov20 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassMon ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassMultiarea ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassNor ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassPace ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassPho ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassPin ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassPlazaCorp ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassPra ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassPre ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassPri ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassPro ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassPro2 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassPro3 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassQue ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassRW ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassReg ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassRosehaven ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassRoy ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassSam ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassSen ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassSignature ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassSil ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassSol ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassSpa ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassSta ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassStaNew ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassStaOld ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassTam ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassTam10Mar22 ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassTar ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassTeg ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassTob ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassTow ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassTre ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassTri ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassTrinity ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassValecraft ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassValery ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassWil ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; use bstapps_DBPassZan ; CREATE TABLE IF NOT EXISTS `tb_OptGroup` ( `col_OptGroupID` int(11) NOT NULL AUTO_INCREMENT, `col_OptGroup` varchar(40) NOT NULL, `col_Markup` decimal(10,6) DEFAULT NULL, `col_MinimumSellingPrice` decimal(18,2) DEFAULT NULL, `col_Order` int DEFAULT NULL, PRIMARY KEY (`col_OptGroupID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 ; alter table tb_ListRoom add col_DestinationField varchar(65); alter table tb_ListRoom add col_Model varchar(100); alter table tb_ListRoom add col_Order int; alter table UPGRADE add col_ActiveYN varchar (10); alter table UPGRADE add col_AvailableOnWebYN varchar (10); alter table UPGRADE add col_LockRetailPriceYN varchar (10); CREATE TABLE tb_ProductDetail( col_ProductDetailID int(11) NOT NULL AUTO_INCREMENT, col_Description varchar(250) NOT NULL, opt_Group varchar(100) NOT NULL, col_Category varchar(100) NOT NULL, col_Level varchar(40) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date DEFAULT NULL, col_LastEditDate date NULL, PRIMARY KEY (`col_ProductDetailID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; alter table tb_TakeOff add col_Model varchar(100) NOT NULL; alter table tb_TakeOff add col_Room varchar(100) NOT NULL; alter table tb_TakeOff add col_Category varchar(100) NOT NULL; alter table tb_TakeOff add col_MeasurementType varchar(25) NULL; alter table tb_TakeOff add col_Size numeric(20, 2) NULL; CREATE TABLE tb_Product( col_ProductID int(11) NOT NULL AUTO_INCREMENT, col_OptionDescriptionPre varchar(100) NULL, col_OptionDescriptionPost varchar(100) NULL, opt_group varchar(100) NOT NULL, col_CostPer decimal(20, 2) NULL, col_ListPer decimal(20, 2) NULL, col_Category varchar(100) NOT NULL, col_Centre varchar(40) NOT NULL, col_Phase varchar(10) NOT NULL, col_Supplier varchar(100) NULL, col_InsertDate date NULL, col_LastEditDate date NULL, col_Disclaimer varchar(250) NULL, col_Level varchar(40) NULL, col_AvailableOnWebYN varchar(10) NULL, PRIMARY KEY (col_ProductID) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;