CREATE DATABASE IF NOT EXISTS `ACA_DB` DEFAULT CHARSET utf8 COLLATE UTF8_GENERAL_CI; USE `ACA_DB`; CREATE TABLE IF NOT EXISTS `DoorObject` ( `ID` INT UNSIGNED AUTO_INCREMENT, `DWGNAME` VARCHAR(255), `Handle` VARCHAR(255), `DoorTest` VARCHAR(255), `Width` DOUBLE, PRIMARY KEY (`ID`) )ENGINE=InnoDB DEFAULT CHARSET=UTF8; CREATE TABLE IF NOT EXISTS `DoorStyles` ( `ID` INT UNSIGNED AUTO_INCREMENT, `DWGNAME` VARCHAR(255), `Handle` VARCHAR(255), `Description` VARCHAR(255), `Material` VARCHAR(255), `Thickness` VARCHAR(255), `DoorSize` VARCHAR(255), `HardwareGroup` VARCHAR(255), `Remarks` VARCHAR(255), `Style` VARCHAR(255), PRIMARY KEY (`ID`) )ENGINE=InnoDB DEFAULT CHARSET=UTF8; CREATE TABLE IF NOT EXISTS `JTBW_Files` ( `DWGNAME` VARCHAR(255), PRIMARY KEY (`DWGNAME`) )ENGINE=InnoDB DEFAULT CHARSET=UTF8; CREATE TABLE IF NOT EXISTS `JTBW_Properties` ( `ID` INT UNSIGNED AUTO_INCREMENT, `Property Name` VARCHAR(255) NOT NULL, `Property Set Name` VARCHAR(255) NOT NULL, `Description` TEXT NOT NULL, `DBConnection` VARCHAR(255) NOT NULL, `IsDimensionInNumericFormat` TINYINT, `IsNumeric` TINYINT, PRIMARY KEY (`ID`) )ENGINE=InnoDB DEFAULT CHARSET=UTF8; CREATE TABLE IF NOT EXISTS `JTBW_PropertySets` ( `Property Set Name` VARCHAR(64) NOT NULL, `Description` VARCHAR(255) NOT NULL, PRIMARY KEY (`Property Set Name`) )ENGINE=InnoDB DEFAULT CHARSET=UTF8; CREATE TABLE IF NOT EXISTS `tblSpaceObjects` ( `DBID` INT UNSIGNED AUTO_INCREMENT, `DWGNAME` TEXT NOT NULL, `HANDLE` VARCHAR(255), `BldgCode` VARCHAR(255), `CalculatedArea` VARCHAR(255), `DataCableNo` VARCHAR(255), `Department` VARCHAR(255), `Floor` VARCHAR(255), `Number` INT, `OccupantName` VARCHAR(255), `PhoneNo` VARCHAR(255), `RespCode` VARCHAR(255), `RoomName` VARCHAR(255), `SiteCode` VARCHAR(255), `SpaceType` VARCHAR(255), `Sub-Department01` VARCHAR(255), `Sub-Department02` VARCHAR(255), PRIMARY KEY (`DBID`) )ENGINE=InnoDB DEFAULT CHARSET=UTF8; CREATE TABLE IF NOT EXISTS `WallObj` ( `DBID` INT UNSIGNED AUTO_INCREMENT, `DWGNAME` TEXT NOT NULL, `HANDLE` VARCHAR(255), `Length2Formula` VARCHAR(255), `Length` VARCHAR(255), `Location` VARCHAR(255), `ManualProp` VARCHAR(255), PRIMARY KEY (`DBID`) )ENGINE=InnoDB DEFAULT CHARSET=UTF8; INSERT INTO JTBW_Files ( `DWGNAME`) VALUES ("C:\ACA_db\ACA_db_samples_2010.dwg"); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (1,"BldgCode","SpaceObjects","BldgCode","aca_db!tblSpaceObjects!BldgCode",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (2,"CalculatedArea","SpaceObjects","Calculated Area","aca_db!tblSpaceObjects!CalculatedArea",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (3,"DataCableNo","SpaceObjects","DataCableNo","aca_db!tblSpaceObjects!DataCableNo",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (4,"Department","SpaceObjects","Department","aca_db!tblSpaceObjects!Department",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (5,"Floor","SpaceObjects","Floor","aca_db!tblSpaceObjects!Floor",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (6,"Number","SpaceObjects","Number","aca_db!tblSpaceObjects!Number",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (7,"OccupantName","SpaceObjects","OccupantName - Last, First","aca_db!tblSpaceObjects!OccupantName",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (8,"PhoneNo","SpaceObjects","PhoneNo","aca_db!tblSpaceObjects!PhoneNo",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (9,"RespCode","SpaceObjects","RespCode","aca_db!tblSpaceObjects!RespCode",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (10,"RoomName","SpaceObjects","RoomName","aca_db!tblSpaceObjects!RoomName",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (11,"SiteCode","SpaceObjects","SiteCode","aca_db!tblSpaceObjects!SiteCode",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (12,"SpaceType","SpaceObjects","SpaceType","aca_db!tblSpaceObjects!SpaceType",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (13,"Sub-Department01","SpaceObjects","Sub-Department01","aca_db!tblSpaceObjects!Sub-Department01",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (14,"Sub-Department02","SpaceObjects","Sub-Department02","aca_db!tblSpaceObjects!Sub-Department02",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (30,"Length2Formula","WallObjects","Len","aca_db!WallObj!Length2Formula",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (31,"Length","WallObjects","Len","aca_db!WallObj!Length",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (32,"Location","WallObjects","Loc","aca_db!WallObj!Location",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (33,"ManualProp","WallObjects","ManProp","aca_db!WallObj!ManualProp",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (34,"Description","DoorStyles","ManProp","aca_db!DoorStyles!Description",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (35,"DoorSize","DoorStyles","AutoProp","aca_db!DoorStyles!DoorSize",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (36,"HardwareGroup","DoorStyles","ManProp","aca_db!DoorStyles!HardwareGroup",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (37,"Material","DoorStyles","ManProp","aca_db!DoorStyles!Material",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (38,"Remarks","DoorStyles","ManProp","aca_db!DoorStyles!Remarks",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (39,"Style","DoorStyles","ManProp","aca_db!DoorStyles!Style",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (40,"Thickness","DoorStyles","AutoProp","aca_db!DoorStyles!Thickness",0,0); INSERT INTO JTBW_Properties (`ID`, `Property Name`, `Property Set Name`, `Description`,`DBConnection`, `IsDimensionInNumericFormat`, `IsNumeric`) VALUES (43,"DoorTest","DoorObject","ManProp","aca_db!DoorObject!DoorTest",0,0); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("DoorObject","DoorObject"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("DoorStyles","Style-based Door schedule properties"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("Elec","Electrical Property Set"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("Elect","Electrical Property Set"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("Elect (E1_E2)","Electrical Property Set"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("FixedShelf","Fixed Shelf Proprerty Set"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("Fixtures","Fixture Extraction Property Set"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("FrameStyles","Style-based Door and Window frame schedule properties"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("ManufacturerStyles","Style-based Manufacturer related schedule properties"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("Panel","Fixture Extraction Property Set"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("PCG","Fixture Extraction Property Set"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("Plg","Plumbing Fixture Property Set"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("RollingShelf","Rolling Shelves Property Set"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("SpaceObjects","Add desc"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("SpaceStyles","Style-based Space schedule properties"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("WallObjects","Wall obj"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("WallStyles","Style-based Wall schedule properties"); INSERT INTO JTBW_PropertySets (`Property Set Name`, `Description`) VALUES ("WindowStyles","Style-based Window and Window Assembly schedule properties"); INSERT INTO `tblSpaceObjects` (`DBID`, `DWGNAME`, `HANDLE`, `BldgCode`, `CalculatedArea`, `DataCableNo`, `Department`, `Floor`, `Number`, `OccupantName`, `PhoneNo`, `RespCode`, `RoomName`, `SiteCode`, `SpaceType`, `Sub-Department01`, `Sub-Department02`) VALUES (34,"C:\ACA_db\ACA_db_samples_2010.dwg","CE","","3 3/4""","--","--","",102,"--","xxx-xxx-xxxx","--","--","0000","06-WkSt - 42 SF","--","--"); INSERT INTO `tblSpaceObjects` (`DBID`, `DWGNAME`, `HANDLE`, `BldgCode`, `CalculatedArea`, `DataCableNo`, `Department`, `Floor`, `Number`, `OccupantName`, `PhoneNo`, `RespCode`, `RoomName`, `SiteCode`, `SpaceType`, `Sub-Department01`, `Sub-Department02`) VALUES (35,"C:\ACA_db\ACA_db_samples_2010.dwg","CA","","9 1/4""","--","--","",103,"--","xxx-xxx-xxxx","--","--","0000","06-WkSt - 42 SF","--","--"); INSERT INTO `tblSpaceObjects` (`DBID`, `DWGNAME`, `HANDLE`, `BldgCode`, `CalculatedArea`, `DataCableNo`, `Department`, `Floor`, `Number`, `OccupantName`, `PhoneNo`, `RespCode`, `RoomName`, `SiteCode`, `SpaceType`, `Sub-Department01`, `Sub-Department02`) VALUES (36,"C:\ACA_db\ACA_db_samples_2010.dwg","AB","","31 1/2""","--","--","",101,"--","xxx-xxx-xxxx","--","--","0000","06-WkSt - 42 SF","--","--"); INSERT INTO `WallObj` (`DBID`, `DWGNAME`, `HANDLE`, `Length2Formula`, `Length`, `Location`, `ManualProp`) VALUES (67,"C:\ACA_db\ACA_db_samples_2010.dwg","A5","1050 1/4""","3151","*Space not found*",""); INSERT INTO `WallObj` (`DBID`, `DWGNAME`, `HANDLE`, `Length2Formula`, `Length`, `Location`, `ManualProp`) VALUES (68,"C:\ACA_db\ACA_db_samples_2010.dwg","A1","1666 3/4""","5000","*Space not found*",""); INSERT INTO `WallObj` (`DBID`, `DWGNAME`, `HANDLE`, `Length2Formula`, `Length`, `Location`, `ManualProp`) VALUES (69,"C:\ACA_db\ACA_db_samples_2010.dwg","72","1666 3/4""","5000","*Space not found*",""); INSERT INTO `WallObj` (`DBID`, `DWGNAME`, `HANDLE`, `Length2Formula`, `Length`, `Location`, `ManualProp`) VALUES (70,"C:\ACA_db\ACA_db_samples_2010.dwg","6E","3333 1/4""","10000","*Space not found*",""); INSERT INTO `WallObj` (`DBID`, `DWGNAME`, `HANDLE`, `Length2Formula`, `Length`, `Location`, `ManualProp`) VALUES (71,"C:\ACA_db\ACA_db_samples_2010.dwg","6A","1666 3/4""","5000","*Space not found*",""); INSERT INTO `WallObj` (`DBID`, `DWGNAME`, `HANDLE`, `Length2Formula`, `Length`, `Location`, `ManualProp`) VALUES (72,"C:\ACA_db\ACA_db_samples_2010.dwg","10","3333 1/4""","10000","*Space not found*","");