HYTOS

CREATE TABLE IF NOT EXISTS Components (

    UID          TEXT NOT NULL,

    Drawings_UID TEXT NOT NULL,

    Symbols_UID  TEXT NOT NULL,

    Name         TEXT,

    X            REAL NOT NULL,

    Y            REAL NOT NULL,

    Rotation     REAL NOT NULL

                      DEFAULT 0,

    Scale        REAL NOT NULL

                      DEFAULT 1,

    CONSTRAINT PK_Components PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Drawings_UID FOREIGN KEY (

        Drawings_UID

    )

    REFERENCES Drawings (UID),

    CONSTRAINT FK_Symbols_UID FOREIGN KEY (

        Symbols_UID

    )

    REFERENCES Symbols (UID) 

);

CREATE TABLE IF NOT EXISTS Configuration (

    UID     TEXT NOT NULL,

    Section TEXT NOT NULL,

    [Key]   TEXT NOT NULL,

    Value   TEXT NOT NULL,

    CONSTRAINT PK_Configuration PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_Configuration UNIQUE (

        Section,

        [Key]

    )

);

CREATE TABLE IF NOT EXISTS DisplayNames (

    UID          TEXT NOT NULL,

    TABLE_NAME   TEXT NOT NULL,

    COLUMN_NAME  TEXT NOT NULL,

    DISPLAY_NAME TEXT,

    CONSTRAINT PK_DisplayNames PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_DisplayNames UNIQUE (

        TABLE_NAME,

        COLUMN_NAME

    )

);

CREATE TABLE IF NOT EXISTS Drawings (

    UID      TEXT NOT NULL,

    NAME     TEXT NOT NULL,

    DATETIME TEXT NOT NULL,

    CONSTRAINT PK_Drawings PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_Drawings UNIQUE (

        NAME

    )

);

CREATE TABLE IF NOT EXISTS DrawingsUnits (

    UID          TEXT NOT NULL,

    Drawings_UID TEXT NOT NULL,

    Table_Name   TEXT NOT NULL,

    Column_Name  TEXT NOT NULL,

    Units_UID    TEXT NOT NULL,

    CONSTRAINT PK_DrawingsUnits PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Drawings_UID FOREIGN KEY (

        Drawings_UID

    )

    REFERENCES Drawings (UID),

    CONSTRAINT FK_Units_UID FOREIGN KEY (

        Units_UID

    )

    REFERENCES Units (UID) 

);

CREATE TABLE IF NOT EXISTS Fittings_2K (

    UID                                    TEXT    NOT NULL,

    Components_UID                         TEXT    NOT NULL,

    [90_Elbow_Standard_Screw]              INTEGER,

    [90_Elbow_Standard_Flange_Weld]        INTEGER,

    [90_Elbow_Long_Radius_All]             INTEGER,

    [90_Elbow_1_Weld]                      INTEGER,

    [90_Elbow_2_Weld]                      INTEGER,

    [90_Elbow_3_Weld]                      INTEGER,

    [90_Elbow_4_Weld]                      INTEGER,

    [90_Elbow_5_Weld]                      INTEGER,

    [45_Elbow_Standard_All]                INTEGER,

    [45_Elbow_Long_Radius_All]             INTEGER,

    [45_Elbow_1_Weld]                      INTEGER,

    [45_Elbow_2_Weld]                      INTEGER,

    [180_Elbow_Standard_Screw]             INTEGER,

    [180_Elbow_Standard_Flange_Weld]       INTEGER,

    [180_Elbow_Long_Radius_All]            INTEGER,

    Tee_Elbow_Standard_Screw               INTEGER,

    Tee_Elbow_Long_Radius_Screw            INTEGER,

    Tee_Elbow_Standard_Flange_Weld         INTEGER,

    Tee_Elbow_Stub_In_Branch               INTEGER,

    Tee_Through_Screw                      INTEGER,

    Tee_Through_Flange_Weld                INTEGER,

    Tee_Through_Stub_In_Branch             INTEGER,

    Gate_Ball_Plug_Valve_Full              INTEGER,

    [Gate_Ball_Plug_Valve_Reduce_Trim_0.9] INTEGER,

    [Gate_Ball_Plug_Valve_Reduce_Trim_0.8] INTEGER,

    Globe_Valve_Standard                   INTEGER,

    Globe_Valve_Angle_YType                INTEGER,

    Diaphragm_Dam_Valve                    INTEGER,

    Butterfly_Valve                        INTEGER,

    Check_Valve_Lift                       INTEGER,

    Check_Valve_Swing                      INTEGER,

    Check_Valve_Tilting                    INTEGER,

    Pipe_Entrance_Normal                   INTEGER,

    Pipe_Entrance_Borda_Count              INTEGER,

    Pipe_Exit                              INTEGER,

    Resistance_Coefficiency                REAL,

    Calculated_Fitting                     REAL,

    CONSTRAINT PK_Fittings_2K PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) 

);

CREATE TABLE IF NOT EXISTS Fittings_CraneK (

    UID                              TEXT    NOT NULL,

    Components_UID                   TEXT    NOT NULL,

    [90_Elbow_Standard_Screw]        INTEGER,

    [90_Elbow_Long_Radius_1]         INTEGER,

    [90_Elbow_Long_Radius_1.5]       INTEGER,

    [90_Elbow_Long_Radius_2]         INTEGER,

    [90_Elbow_Long_Radius_3]         INTEGER,

    [90_Elbow_Long_Radius_4]         INTEGER,

    [90_Elbow_Long_Radius_6]         INTEGER,

    [90_Elbow_Long_Radius_8]         INTEGER,

    [90_Elbow_Long_Radius_10]        INTEGER,

    [90_Elbow_Long_Radius_12]        INTEGER,

    [90_Elbow_Long_Radius_14]        INTEGER,

    [90_Elbow_Long_Radius_16]        INTEGER,

    [90_Elbow_Long_Radius_20]        INTEGER,

    [90_Elbow_1_Weld]                INTEGER,

    [90_Elbow_2_Weld]                INTEGER,

    [90_Elbow_3_Weld]                INTEGER,

    [90_Elbow_6_Weld]                INTEGER,

    [45_Elbow_Standard_Screw]        INTEGER,

    [45_Elbow_1_Weld]                INTEGER,

    [45_Elbow_3_Weld]                INTEGER,

    [180_Elbow_Standard_Screw]       INTEGER,

    [180_Elbow_Long_Radius_1]        INTEGER,

    [180_Elbow_Long_Radius_1.5]      INTEGER,

    [180_Elbow_Long_Radius_2]        INTEGER,

    [180_Elbow_Long_Radius_3]        INTEGER,

    [180_Elbow_Long_Radius_4]        INTEGER,

    [180_Elbow_Long_Radius_6]        INTEGER,

    [180_Elbow_Long_Radius_8]        INTEGER,

    [180_Elbow_Long_Radius_10]       INTEGER,

    [180_Elbow_Long_Radius_12]       INTEGER,

    [180_Elbow_Long_Radius_14]       INTEGER,

    [180_Elbow_Long_Radius_16]       INTEGER,

    [180_Elbow_Long_Radius_20]       INTEGER,

    [180_Elbow_2_Weld]               INTEGER,

    [180_Elbow_3_Weld]               INTEGER,

    [180_Elbow_4_Weld]               INTEGER,

    [180_Elbow_6_Weld]               INTEGER,

    [180_Elbow_12_Weld]              INTEGER,

    Tee_Through                      INTEGER,

    Tee_Elbow                        INTEGER,

    Expander                         INTEGER,

    Reducer                          INTEGER,

    Globe_Valve_Standard             INTEGER,

    Globe_Valve_45_Angle             INTEGER,

    Globe_Valve_90_Angle             INTEGER,

    Plug_Valve_1_Way                 INTEGER,

    Plug_Valve_3_Way_Through         INTEGER,

    Plug_Valve_3_Way_Elbow           INTEGER,

    Foot_Valve_Poppet_Disc           INTEGER,

    Foot_Valve_Hinged_Disc           INTEGER,

    Gate_Valve                       INTEGER,

    Ball_Valve                       INTEGER,

    Butterfly_Valve                  INTEGER,

    Pipe_Enterance_Projecting        INTEGER,

    [Pipe_Enterance_Flush_0.00]      INTEGER,

    [Pipe_Enterance_Flush_0.02]      INTEGER,

    [Pipe_Enterance_Flush_0.04]      INTEGER,

    [Pipe_Enterance_Flush_0.06]      INTEGER,

    [Pipe_Enterance_Flush_0.10]      INTEGER,

    [Pipe_Enterance_Flush_0.15]      INTEGER,

    Pipe_Exit_Projecting             INTEGER,

    Pipe_Exit_Sharp_Edged            INTEGER,

    Pipe_Exit_Rounded                INTEGER,

    Check_Valve_Swing_Vertical       INTEGER,

    Check_Valve_Swing_Angled         INTEGER,

    Check_Valve_Lift_Straight        INTEGER,

    Check_Valve_Lift_Angled          INTEGER,

    [Check_Valve_Tilting_Alpha_5]    INTEGER,

    [Check_Valve_Tilting_Alpha_15]   INTEGER,

    Check_Valve_Globe_Stop           INTEGER,

    Check_Valve_Globe_Stop_45_Angle  INTEGER,

    Check_Valve_Globe_Stop_Inline    INTEGER,

    Check_Valve_Angled_Stop          INTEGER,

    Check_Valve_Angled_Stop_45_Angle INTEGER,

    Check_Valve_Angled_Stop_Inline   INTEGER,

    User_Input                       INTEGER,

    Resistance_Coefficiency          REAL,

    Calculated_Fitting               REAL,

    CONSTRAINT PK_Fittings_CraneK PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) 

);

CREATE TABLE IF NOT EXISTS Fittings_EquivalentLength (

    UID                  TEXT    NOT NULL,

    Components_UID       TEXT    NOT NULL,

    Gate_Ball_Plug_Valve INTEGER,

    Globe_Valve          INTEGER,

    Butterfly_Valve      INTEGER,

    Check_Valve          INTEGER,

    [90_Elbow]           INTEGER,

    [45_Elbo]            INTEGER,

    Tee_Branch           INTEGER,

    Tee_Through          INTEGER,

    Milter               INTEGER,

    Milter_Degree        INTEGER,

    Nozzle_In_YN         BOOLEAN,

    Nozzle_Out_YN        BOOLEAN,

    Calculated_Fitting   REAL,

    CONSTRAINT PK_Fittings_EquivalentLength PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) 

);

CREATE TABLE IF NOT EXISTS HMB (

	UID                      TEXT    NOT NULL,

    Components_UID           TEXT    NOT NULL,

    Stream_No                INTEGER NOT NULL,

    Flowrate_Mass            REAL,

    Flowrate_Volume          REAL,

    Density                  REAL,

    Viscosity                REAL,

    Temperature              REAL,

    Molecular_Weight         REAL,

    Specific_Heat_Ratio      REAL,

    Compress_Factor          REAL,

    Nominal_Pipe_Size        REAL,

    Inside_Pipe_Size         REAL,

    Schedul_No               TEXT,

    Straight_Length          REAL,

    Equivalent_Length        REAL,

    Roughness                REAL,

    Limitation_Velocity      REAL,

    Limitation_Pressure_Drop REAL,

    Velocity                 REAL,

    Reynolds                 REAL,

    Friction_Factor          REAL,

    Pressure_Drop            REAL,

    Pressure_Drop_Friction   REAL,

    Pressure_Drop_Static     REAL,

    Pressure_Pipe_End_Point  REAL,

    Power                    REAL,

    CONSTRAINT PK_HMB PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID),

    CONSTRAINT UQ_HMB UNIQUE (

        Components_UID,

        Stream_No

    )

);

CREATE TABLE IF NOT EXISTS Loops (

    UID              TEXT    NOT NULL,

    Name             TEXT    NOT NULL,

    From_Nozzles_UID TEXT    NOT NULL,

    Stream_No        INTEGER NOT NULL,

    To_Nozzles_UID   TEXT    NOT NULL,

    CONSTRAINT PK_Loops PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_From_Nozzles_UID FOREIGN KEY (

        From_Nozzles_UID

    )

    REFERENCES Nozzles (UID),

    CONSTRAINT FK_Stream_No FOREIGN KEY (

        Stream_No

    )

    REFERENCES HMB (Stream_No),

    CONSTRAINT FK_To_Nozzles_UID FOREIGN KEY (

        To_Nozzles_UID

    )

    REFERENCES Nozzles (UID) 

);

CREATE TABLE IF NOT EXISTS NominalDiameter (

    UID                TEXT NOT NULL,

    Code               TEXT NOT NULL,

    Metric             REAL,

    Inch               REAL,

    MetricStr          TEXT,

    InchStr            TEXT,

    AllowableMetricStr TEXT,

    AllowableInchStr   TEXT,

    CONSTRAINT PK_NominalDiameter PRIMARY KEY (

        UID

    )

);

CREATE TABLE IF NOT EXISTS Nozzles (

    UID                          TEXT NOT NULL,

    Points_UID                   TEXT NOT NULL,

    Pressure                     REAL,

    Pressure_Drop                REAL,

    Elevation                    REAL,

    Over_Design_CV               REAL,

    CV_Type                      TEXT,

    Total_Discharge_Loss         REAL,

    Total_Suction_Loass          REAL,

    Total_Loss                   REAL,

    Discharge_Device_Loss        REAL,

    Suction_Device_Loss          REAL,

    Total_Device_Loss            REAL,

    Discharge_Line_Friction_Loss REAL,

    Suction_Line_Friction_Loss   REAL,

    Line_Total_Frictoin_Loss     REAL,

    CONSTRAINT PK_Nozzles PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Points_UID FOREIGN KEY (

        Points_UID

    )

    REFERENCES Points (UID) 

);

CREATE TABLE IF NOT EXISTS Points (

    UID            TEXT    NOT NULL,

    Components_UID TEXT    NOT NULL,

    [Index]        INTEGER NOT NULL,

    X              REAL    NOT NULL,

    Y              REAL    NOT NULL,

    CONSTRAINT PK_Points PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) 

);

CREATE TABLE IF NOT EXISTS Roughness (

    UID       TEXT NOT NULL,

    Material  TEXT NOT NULL,

    Roughness REAL NOT NULL,

    CONSTRAINT PK_Roughness PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_Roughness UNIQUE (

        Material

    )

);

CREATE TABLE IF NOT EXISTS Symbols (

    UID             TEXT NOT NULL,

    Name            TEXT NOT NULL,

    SymbolType_UID  TEXT NOT NULL,

    OriginalPoint   TEXT NOT NULL,

    ConnectionPoint TEXT,

    CONSTRAINT PK_Symbols PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_SymbolType_UID FOREIGN KEY (

        SymbolType_UID

    )

    REFERENCES SymbolType (UID) 

);

CREATE TABLE IF NOT EXISTS SymbolType(

    UID      TEXT NOT NULL,

    Category TEXT NOT NULL,

    Type     TEXT NOT NULL,

    CONSTRAINT PK_SymbolType PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_SymbolType UNIQUE (

        Category,

        Type

    )

);

CREATE TABLE IF NOT EXISTS Units (

    UID         TEXT NOT NULL,

    TABLE_NAME  TEXT NOT NULL,

    COLUMN_NAME TEXT NOT NULL,

    UNIT        TEXT NOT NULL,

    CONSTRAINT PK_Units PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_Units UNIQUE (

        TABLE_NAME,

        COLUMN_NAME,

        UNIT

    )

);

-- DisplayNames

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('5457c6aa-b622-4f50-b326-3e19797055d1', 'HMB', 'UID', 'UID');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('c4deaf60-483b-4385-b034-1e41b6b83d3f', 'HMB', 'Components_UID', 'Components_UID');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('2c73d94e-1fb1-49e7-9eb3-7e05f5d925dc', 'HMB', 'Stream_No', 'Stream No.');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('fd749994-95d3-40ae-98d3-6cf050646868', 'HMB', 'Flowrate_Mass', 'Flowrate (Mass)');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('4e3837b5-0d93-466e-a00f-5be0a5a17a2b', 'HMB', 'Flowrate_Volume', 'Flowrate (Volume)');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('f17d7a86-bb29-41d7-8c6b-401f0d1bce7a', 'HMB', 'Density', 'Density');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('9e60de3e-95eb-46d5-b66a-fa9955e2c0f5', 'HMB', 'Viscosity', 'Viscosity');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('5ba88856-1c83-4fe2-b7fa-371256cab217', 'HMB', 'Temperature', 'Temperature');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('70a04a4c-d393-438f-8a5f-a156192debb7', 'HMB', 'Molecular_Weight', 'Molecular Weight');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('5376f061-5588-4348-abd8-cbe757007534', 'HMB', 'Specific_Heat_Ratio', 'Specific heat ratio (Cp/Cv)');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('3fbde097-cdd0-490b-8e91-1ffe5a508a19', 'HMB', 'Compress_Factor', 'Compress. Factor (Z)');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('06599f97-7940-475b-840c-d876660acae7', 'HMB', 'Nominal_Pipe_Size', 'Pipe Nominal Diameter');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('0c9ceb14-0f21-4eba-8b83-3f63ca958f9f', 'HMB', 'Inside_Pipe_Size', 'Pipe Inside Diameter');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('8965a13c-a27d-4fa8-882a-8343f634e293', 'HMB', 'Schedul_No', 'Sch. No.');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('345c92bd-7fba-49ff-9a3b-654ab4c0a102', 'HMB', 'Straight_Length', 'Straight Length');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('1a2f69f0-3961-4236-8782-ddbbea8ba50e', 'HMB', 'Equivalent_Length', 'Equivalent Length');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('1a122a93-79b5-484c-b0a6-804a723068f1', 'HMB', 'Roughness', 'Roughness');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('7b2301e2-345e-49eb-b2e3-0642e718adfa', 'HMB', 'Limitation_Velocity', 'Limitation of Velocity');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('f28ce2e0-330c-445a-bb89-30be8a3e3760', 'HMB', 'Limitation_Pressure_Drop', 'Limitation of Pressure Drop');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('face50fe-546f-4ed1-87a3-18734bb5c644', 'HMB', 'Velocity', 'Velocity');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('922f3431-e339-4ee9-a6f8-02344b838032', 'HMB', 'Reynolds', 'Mach No.');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('91f2a3e5-91d7-4ddf-9a87-8e733a3a48b7', 'HMB', 'Friction_Factor', 'Friction Factor');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('c5a7b8c3-9360-40ce-84a4-0d0e2af1394b', 'HMB', 'Pressure_Drop', 'Pressure Drop');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('3ffd7be4-cd37-4d80-8c37-45e0bb214b6a', 'HMB', 'Pressure_Drop_Friction', 'Pressure Drop (Friction)');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('23c9d872-09c8-4e9f-a835-61a80fbb7c0e', 'HMB', 'Pressure_Drop_Static', 'Pressure Drop (Static)');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('c9ed3327-ea90-4120-a471-d57edcd5eae7', 'HMB', 'Pressure_Pipe_End_Point', 'Pressure @ Pipe end point');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('2055e991-c7f2-4436-87fb-5b01993c923b', 'HMB', 'Power', 'Power');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('17692962-e6db-4247-a513-54d21df29ab7', 'Nozzles', 'UID', 'UID');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('ad1d13f9-29bc-4015-8cc2-f5dd19c59dda', 'Nozzles', 'Points_UID', 'Points_UID');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('a38b4759-656c-458a-8033-784d671f856d', 'Nozzles', 'Pressure', 'Pressure');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('02fc05ea-ec79-4dda-8f78-1622bbd2619b', 'Nozzles', 'Pressure_Drop', 'Pressure Drop');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('05d85742-f37d-456c-acc2-844bed4ad3bb', 'Nozzles', 'Elevation', 'Elevation');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('9f17f500-98f3-4c77-9d32-bb1e27d4eae5', 'Nozzles', 'Over_Design_CV', 'Over_Design_CV');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('c70efa69-8ff7-4cb9-90b4-f89e6da1ac1c', 'Nozzles', 'CV_Type', 'CV_Type');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('f9b21ecc-6aab-414b-9479-706310fddcaa', 'Nozzles', 'Total_Discharge_Loss', 'Total_Discharge_Loss');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('5d9c471c-4929-4979-920a-4063945f06f6', 'Nozzles', 'Total_Suction_Loass', 'Total_Suction_Loass');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('d51474fa-6355-48e9-9ba7-8855b953ed37', 'Nozzles', 'Total_Loss', 'Total_Loss');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('4e67ab73-9ca2-4e11-8f58-8e520d916731', 'Nozzles', 'Discharge_Device_Loss', 'Discharge_Device_Loss');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('8b1a96ff-ef68-4ea1-ad2e-05681c2af372', 'Nozzles', 'Suction_Device_Loss', 'Suction_Device_Loss');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('1159a010-84dc-42f5-9ae6-c73bb417a7ee', 'Nozzles', 'Total_Device_Loss', 'Total_Device_Loss');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('63897149-bcf1-4533-9a20-5bc904d019a2', 'Nozzles', 'Discharge_Line_Friction_Loss', 'Discharge_Line_Friction_Loss');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('ad8408af-47fc-4d8e-ae60-8db1f6e08c50', 'Nozzles', 'Suction_Line_Friction_Loss', 'Suction_Line_Friction_Loss');

INSERT INTO DisplayNames (UID, TABLE_NAME, COLUMN_NAME, DISPLAY_NAME) VALUES ('4d3f65f5-29bb-4e7b-a43a-2e44cd51ce3d', 'Nozzles', 'Line_Total_Frictoin_Loss', 'Line_Total_Frictoin_Loss');

-- NominalDiameter

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('D440223B36524F32944D1DEBF2AA3F5E', '0', 1.0, 1.0, '', '', '', '');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('3917AA4706A24FF8A6E279031E94EFA9', '1', 500.0, 20.0, '500', '20"', '', '20''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('F8CF9BAFA8C14993812C7BB9F89B7F85', '1A', 2150.0, 86.0, '2150', '86"', '', '86''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('051DB37DC65249A5A6724A504B6681B2', '1B', 2200.0, 88.0, '2200', '88"', '', '88''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('5FF45DE1D9E7445193A80FFCE266DFB5', '1C', 2250.0, 90.0, '2250', '90"', '', '90''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('28FD280A20584F6CAF53DCE2F6348240', '1D', 2300.0, 92.0, '2300', '92"', '', '92''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('0A677F0CB2594948848B79275A62D726', '1F', 2350.0, 94.0, '2350', '94"', '', '94''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('8C7548C8FDBC465DAF016F58E844CD91', '1G', 2400.0, 96.0, '2400', '96"', '', '96''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('24AEF41A7733412D93FAA889B0A5BE93', '1H', 2450.0, 98.0, '2450', '98"', '', '98''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('401B20C205D44072AA7BCE6EB76D7A29', '1I', 2500.0, 100.0, '2500', '100"', '', '100''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('42A5881B811E434AAD5F92C3FB2B36E3', '2', 550.0, 22.0, '550', '22"', '', '22''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('6F576C25F4984880BFAE3EF0D582D50E', '3', 600.0, 24.0, '600', '24"', '', '24''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('0864755DDE784621B93826069F3466BC', '4', 650.0, 26.0, '650', '26"', '', '26''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('FD5E893607814F63990B441B1298A8E0', '5', 700.0, 28.0, '700', '28"', '', '28''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('B928777F29244EA4BE7BF57F6A4E83D3', '6', 750.0, 30.0, '750', '30"', '', '30''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('128E2F9AFE58450AB990A11A52AE30C7', '7', 800.0, 32.0, '800', '32"', '', '32''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('E1BD1B4861FD4392B0219761E6789A36', '8', 850.0, 34.0, '850', '34"', '', '34''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('48E1BC54BBA14142B0C6F88860BEA646', '9', 900.0, 36.0, '900', '36"', '', '36''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('41E075B5CE9747D3BD18ABB512077294', 'A', 6.0, 0.125, '6', '1/8"', '', '1/4''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('0A64999E840341F39A29B050797D2A0D', 'B', 8.0, 0.25, '8', '1/4"', '', '1/4''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('69CC473F3401414DBDC934E1509B9D27', 'C', 10.0, 0.375, '10', '3/8"', '', '3/8''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('E67D141EDA9845748DBF8003DB8A0637', 'D', 15.0, 0.5, '15', '1/2"', '', '1/2''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('6AF50ACD98DB4A2C9C0BFCCE26A03E5E', 'E', 20.0, 0.75, '20', '3/4"', '', '3/4''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('B1CC4F1BC6924BBF9B643B8884A06B01', 'F', 25.0, 1.0, '25', '1"', '', '1''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('BFDB0A3934064B12A97E80D659C926E2', 'G', 32.0, 1.25, '32', '1-1/4"', '', '1-1/4''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('D4A173D3164D4B1C9BC444586A4B9892', 'H', 40.0, 1.5, '40', '1-1/2"', '', '1-1/2''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('B8E802B3803846C3976CC184836B6904', 'J', 50.0, 2.0, '50', '2"', '', '2''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('FBE3D342CF3747A5A95F619C37494712', 'K', 65.0, 2.5, '65', '2-1/2"', '', '2-1/2''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('36BFB145CF894D60B55CA98C9C840A19', 'L', 80.0, 3.0, '80', '3"', '', '3''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('3CDAEDF299E14810AB0AD040965C539F', 'M', 90.0, 3.5, '90', '3-1/2"', '', '3-1/2''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('E5C483792D6E4D3F89531F2B0E0410E4', 'N', 100.0, 4.0, '100', '4"', '', '4''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('FB4723DEA32945CAB5ACE38D7A8A254C', 'P', 125.0, 5.0, '125', '5"', '', '5''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('ADE8B2667A4148B68DDDBEFB3D8F300F', 'Q', '', '', '', '', '', '');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('1F1BD70096B64B01A6EEC6BCCFD4C3AB', 'R', 150.0, 6.0, '150', '6"', '', '6''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('40DACEA22DB54FF4BA87FEA0C1AE7141', 'S', '', '', '', '', '', '');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('0DF9A1D3506B4C91A772F33A1548DF55', 'T', 200.0, 8.0, '200', '8"', '', '8''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('08D389AA15014393A5B2715F861EDB0D', 'U', '', '', '', '', '', '');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('F9562E890E324011B2CF41AF9E81236B', 'V', 250.0, 10.0, '250', '10"', '', '1/4''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('535492EFF73E46EA8731E597A7E31BD9', 'W', 300.0, 12.0, '300', '12"', '', '12''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('2A3A4128500E43F892B16E59275C2152', 'X', 350.0, 14.0, '350', '14"', '', '14''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('636ED46022DB4E28A393F088889E8CF7', 'Y', 400.0, 16.0, '400', '16"', '', '16''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('1FCCFD67474D4C669D3A28F24C251917', 'Z', 450.0, 18.0, '450', '18"', '', '18''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('5BACD9ED602044B2831975875F1C25B8', 'a', 950.0, 38.0, '950', '38"', '', '38''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('7BB39074F245488C9D2575D6D0FB593A', 'b', 1000.0, 40.0, '1000', '40"', '', '40''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('62970647E3D344CF96DA5971C999350A', 'c', 1050.0, 42.0, '1050', '42"', '', '42''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('01EEC899BA0041C19406E8DAEBB37469', 'd', 1100.0, 44.0, '1100', '44"', '', '44''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('152F630AA86341FC98BA566275FD172A', 'f', 1200.0, 48.0, '1200', '48"', '', '48''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('5A9A78192EE14D8A99AA97DA2B6F95A5', 'g', 1250.0, 50.0, '1250', '50"', '', '50''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('2D750B26C1F44B11AB6DA4E209356801', 'h', 1300.0, 52.0, '1300', '52"', '', '52''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('308023969224443C9E24D47765C48D72', 'j', 1350.0, 54.0, '1350', '54"', '', '54''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('6027C5655B3C4381B3EF89EA4009FB90', 'k', 1400.0, 56.0, '1400', '56"', '', '56''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('2C60D5D268804E0FB2EA8F6184AD55AB', 'm', 1450.0, 58.0, '1450', '58"', '', '58''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('1E0BA7D8B37C40C8822525D00BBCFC72', 'n', 1500.0, 60.0, '1500', '60"', '', '60''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('C2657B622A1D473E991DBE9DBC89E96B', 'o', 1550.0, 62.0, '1550', '62"', '', '62''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('B0CA4046F595464196F8561E3FC96BE3', 'p', 1600.0, 64.0, '1600', '64"', '', '64''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('5DD7BE3C00AE4DA3A45F32B4C8203C2F', 'q', 1650.0, 66.0, '1650', '66"', '', '66''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('4BA5194C484F4DFC90B4320EA10D26DD', 'r', 1700.0, 68.0, '1700', '68"', '', '68''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('0A5FC2CED0314AC1999DB2E6ECC94404', 's', 1750.0, 70.0, '1750', '70"', '', '70''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('7FD570562A0F44F8965763E844E559E1', 't', 1800.0, 72.0, '1800', '72"', '', '72''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('5FC2F33B7C554A0095AFBA7E1ECF907D', 'u', 1850.0, 74.0, '1850', '74"', '', '74''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('1A64860CC8484384914B60509F79B617', 'v', 1900.0, 76.0, '1900', '76"', '', '76''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('0AF73D8D6BF64791B2F1197E324659BD', 'w', 1950.0, 78.0, '1950', '78"', '', '78''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('F1537B77E8704323B0D80F55F830654C', 'x', 2000.0, 80.0, '2000', '80"', '', '80''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('86F2EC475309473F9F3BFA43AF0F9D82', 'y', 2050.0, 82.0, '2050', '82"', '', '82''');

INSERT INTO NominalDiameter (UID, Code, Metric, Inch, MetricStr, InchStr, AllowableMetricStr, AllowableInchStr) VALUES ('BA9CA6CD37D343E5AB6B4CBE6B2BA149', 'z', 2100.0, 84.0, '2100', '84"', '', '84''');

-- Roughness

INSERT INTO Roughness (UID, Material, Roughness) VALUES ('cb11e760-bf73-438c-8a7f-e5ef81f863f2', 'Carbon Steel', 0.0001524);

INSERT INTO Roughness (UID, Material, Roughness) VALUES ('56e8405c-4dce-4ccf-97e3-f26cb3345916', 'Stainless Steel', 0.000046);

INSERT INTO Roughness (UID, Material, Roughness) VALUES ('6d2556e9-477b-4765-92ec-bd45fdb8e825', 'Cast Iron - Asphalt Dipped', 0.00012192);

INSERT INTO Roughness (UID, Material, Roughness) VALUES ('c35c4149-93ec-4bb0-84bf-c9b7600ea9ac', 'Cast Iron - Uncoated', 0.00025908);

INSERT INTO Roughness (UID, Material, Roughness) VALUES ('03e5098a-d8f7-4f22-b800-5f19673af2ee', 'Wood Stave', 0.00009144);

INSERT INTO Roughness (UID, Material, Roughness) VALUES ('9c258941-3af0-4266-aaab-2ad49d576846', 'Concrete', 0.003048);

INSERT INTO Roughness (UID, Material, Roughness) VALUES ('c09f1f7e-f61c-44f5-9b69-3c79f911011c', 'Riveted Steel', 0.009144);

-- Drawings

INSERT INTO Drawings (UID, NAME, DATETIME) VALUES ('00000000-0000-0000-0000-000000000000', 'Template', '0000-00-00 00:00:00');

-- Units

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('07078fac-390b-4b9d-9c27-90199aaf181b', 'HMB', 'Flowrate_Mass', 'kg/h');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('6b3c0391-6205-476f-b146-4688b164b4af', 'HMB', 'Flowrate_Mass', 'g/min');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('87728b43-6eaa-48d2-9d42-bd826867eb6e', 'HMB', 'Flowrate_Mass', 'lb/h');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('36aaa6b2-6014-4688-99c2-998488c798eb', 'HMB', 'Flowrate_Mass', 't/h');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('3fb8d2de-edab-4112-a5bd-59394c1a66c1', 'HMB', 'Flowrate_Volume', 'm3/h');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('338b7e7a-c479-434e-8486-04249833732f', 'HMB', 'Flowrate_Volume', 'l/min');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('2979591f-90f6-42d1-a674-1c95c01959fe', 'HMB', 'Flowrate_Volume', 'Usgpm');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('49a13745-3538-45c5-91d0-6f6aea8a4c4b', 'HMB', 'Flowrate_Volume', 'BPSD');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('44eb178d-ed62-4c8e-84d6-e547e4573ea3', 'HMB', 'Density', 'kg/m3');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('14e3aa68-5941-42c9-88e1-03ffd6203415', 'HMB', 'Density', 'lb/ft3');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('123cf7a9-ddc7-47d3-acaa-895f124b57cf', 'HMB', 'Viscosity', 'cP');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('dacfb92f-0d16-43f7-abf1-46121839a96f', 'HMB', 'Viscosity', 'kg/m.sec');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('0a2d60f9-47d8-4f01-985c-ca45e7185928', 'HMB', 'Viscosity', 'kg/m.h');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('3a27bd88-f617-4917-b6aa-018acdcdb5c4', 'HMB', 'Viscosity', 'lb/ft.sec');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('d9d5653a-95a0-46fd-ace3-932de09ef652', 'HMB', 'Temperature', '℃');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('5ead82c0-d338-4b38-82b5-e333ba25cf12', 'HMB', 'Temperature', '℉');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('f703790d-f5f6-4c46-a550-65c9379238d9', 'HMB', 'Pressure', 'kg/cm2');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('722f8273-5ffd-4a03-8dd1-18947fe49a3d', 'HMB', 'Pressure', 'psi');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('e089e70f-567b-4172-b65d-b42d084d2bf4', 'HMB', 'Pressure', 'atm');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('a83c7921-a667-4656-8e34-120e9e4726b0', 'HMB', 'Pressure', 'bar');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('40a69119-8543-4bc4-8a1c-864c636e4e7f', 'HMB', 'Pressure', 'mmHg');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('d7ef6940-fddb-450d-ae4f-cd2c18d0cd4d', 'HMB', 'Pressure', 'kPa');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('3e1c4cbe-e7d8-443e-ba1a-2c42353e70d1', 'HMB', 'Pressure', 'Mpa');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('70f64cbf-4be8-4bd2-8664-e5eab6cc3780', 'HMB', 'Velocity', 'm/s');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('bbca2bba-75a4-47fb-96b9-63d3b94beea5', 'HMB', 'Velocity', 'ft/s');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('d08f26f2-ff32-423c-a3c1-68b592cd8866', 'HMB', 'Pipe Diameter', 'in');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('a6f5db5b-b30e-450d-939d-d51dcf7470e8', 'HMB', 'Pipe Diameter', 'mm');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('0433487a-09ca-461d-98d5-00118a2321c6', 'HMB', 'Length', 'in');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('c1309b5c-666c-43e1-a27d-e47e4178ff3a', 'HMB', 'Length', 'm');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('460225f6-7910-41be-99ef-49baccf07a3e', 'HMB', 'Length', 'ft');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('1552b7f5-c450-411d-9a1e-dbde1c189093', 'HMB', 'Length', 'yd');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('38d892be-b61c-4795-8931-9d74871bdf80', 'HMB', 'Length', 'mile');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('3e69d687-dff8-4ecd-907c-aa65f199d192', 'HMB', 'Length', 'mm');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('82260ab7-2f7d-4edb-8d0c-01984faa60bb', 'HMB', 'Roughness', 'in');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('befe5832-138f-47e5-b7c3-a41e6cb9a491', 'HMB', 'Roughness', 'm');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('d2c6f04f-266d-4793-af66-a5fa9412e901', 'HMB', 'Roughness', 'ft');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('ca3f09b0-dc23-456b-8248-2e182025f2ec', 'HMB', 'Roughness', 'mm');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('9350369e-a419-43fa-a1eb-2cf0c12e7fe8', 'HMB', 'Power', 'kW');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('db7dd3f3-2b79-4655-baac-6e66ac3a1133', 'HMB', 'Power', 'kcal/h');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('359c786b-a87d-4975-b5f5-6ab3eb77698f', 'HMB', 'Power', 'btu/h');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('645a152d-3189-4f0c-8b6f-ff46e1b262e8', 'HMB', 'Power', 'Hp');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('96dda1ec-35f0-407a-b488-4501fd4c4d90', 'HMB', 'Power', 'kg.m/sec');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('f9b123b1-c837-4110-92ab-229657aeaa65', 'HMB', 'Power', 'ft.lb/sec');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('c5747d95-f3c1-477f-b849-01962fb2c386', 'Nozzle', 'Pressure', 'kg/cm2');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('30eced29-e6eb-4bc6-95b5-a614553b4598', 'Nozzle', 'Pressure', 'psi');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('55f3abd7-e5f6-41a5-9503-d284f6ea5d21', 'Nozzle', 'Pressure', 'atm');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('061e2d15-f7f2-43fd-afaa-658485030950', 'Nozzle', 'Pressure', 'bar');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('68f3678b-c108-41dc-846f-2fa895d3f284', 'Nozzle', 'Pressure', 'mmHg');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('536841fc-c21b-4620-9ef7-e13a8a29106c', 'Nozzle', 'Pressure', 'kPa');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('1fcea7d8-6636-4ca7-a3e4-95feec71de14', 'Nozzle', 'Pressure', 'Mpa');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('0abc6107-c339-4d38-a2c3-9e9a9348ce7a', 'Nozzle', 'Elevation', 'in');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('53ce4c36-cedb-40d9-8cea-51182e0b4fd9', 'Nozzle', 'Elevation', 'm');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('7f8151c5-f195-47f8-8a58-91237131da63', 'Nozzle', 'Elevation', 'ft');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('2d50747e-1bc0-4fb8-a3c5-0220da9061cf', 'Nozzle', 'Elevation', 'yd');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('1c27f8b7-9862-421f-aaaa-ae0c77a8ccc7', 'Nozzle', 'Elevation', 'mile');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('cd745f8b-1cbc-4196-9286-8f2e99e5018f', 'Nozzle', 'Elevation', 'mm');

INSERT INTO Units (UID, TABLE_NAME, COLUMN_NAME, UNIT) VALUES ('1ea01ecc-e03a-4e7c-93db-2628c07b0a92', 'Nozzle', 'Over_Design_CV', '%');

-- DrawingsUnits

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('2d550387-7f2f-4fb9-ba1f-aa37ce960342', '00000000-0000-0000-0000-000000000000', 'HMB', 'Flowrate_Mass', '07078fac-390b-4b9d-9c27-90199aaf181b');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('b073f4c5-1c59-468a-8c9f-cd36d3fd7915', '00000000-0000-0000-0000-000000000000', 'HMB', 'Flowrate_Volume', '3fb8d2de-edab-4112-a5bd-59394c1a66c1');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('be686341-f31d-47c0-8817-fe771dd55c7d', '00000000-0000-0000-0000-000000000000', 'HMB', 'Density', '44eb178d-ed62-4c8e-84d6-e547e4573ea3');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('91e92695-74e7-440b-abe1-140d4393d956', '00000000-0000-0000-0000-000000000000', 'HMB', 'Viscosity', '123cf7a9-ddc7-47d3-acaa-895f124b57cf');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('a60acb8a-6fb4-49bc-b403-f9f0d8478609', '00000000-0000-0000-0000-000000000000', 'HMB', 'Temperature', 'd9d5653a-95a0-46fd-ace3-932de09ef652');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('66d21f0e-fe8a-4388-b495-b7c6f029be8f', '00000000-0000-0000-0000-000000000000', 'HMB', 'Nominal_Pipe_Size', 'd08f26f2-ff32-423c-a3c1-68b592cd8866');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('d5106f97-6a41-4ede-a411-98d83b5ecd3e', '00000000-0000-0000-0000-000000000000', 'HMB', 'Inside_Pipe_Size', 'd08f26f2-ff32-423c-a3c1-68b592cd8866');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('ce608301-2d60-44a3-a504-64003307edaf', '00000000-0000-0000-0000-000000000000', 'HMB', 'Straight_Length', 'c1309b5c-666c-43e1-a27d-e47e4178ff3a');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('0cc39fd6-8bbe-4c37-acef-75fb07fb422d', '00000000-0000-0000-0000-000000000000', 'HMB', 'Equivalent_Length', 'c1309b5c-666c-43e1-a27d-e47e4178ff3a');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('abdbbf9d-f049-43f9-bdb7-0cf498f8528b', '00000000-0000-0000-0000-000000000000', 'HMB', 'Roughness_Unit_UID', 'befe5832-138f-47e5-b7c3-a41e6cb9a491');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('8ef2dd09-3fa3-4565-b47b-aadbe4f01c01', '00000000-0000-0000-0000-000000000000', 'HMB', 'Limitation_Velocity_Unit_UID', '70f64cbf-4be8-4bd2-8664-e5eab6cc3780');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('a62e4f3e-f523-43d9-bbbd-9b41dc9691dc', '00000000-0000-0000-0000-000000000000', 'HMB', 'Limitation_Pressure_Drop', 'f703790d-f5f6-4c46-a550-65c9379238d9');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('a3fa68d7-7273-40b0-b2e2-e66fb7a5b049', '00000000-0000-0000-0000-000000000000', 'HMB', 'Velocity', '70f64cbf-4be8-4bd2-8664-e5eab6cc3780');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('f449bc24-60aa-416d-b342-922b9b1b42af', '00000000-0000-0000-0000-000000000000', 'HMB', 'Pressure_Drop', 'f703790d-f5f6-4c46-a550-65c9379238d9');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('4be8c028-fe64-4d82-a49a-c6353661243a', '00000000-0000-0000-0000-000000000000', 'HMB', 'Pressure_Drop_Friction', 'f703790d-f5f6-4c46-a550-65c9379238d9');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('562ef23a-7021-4a26-9a88-639009309c94', '00000000-0000-0000-0000-000000000000', 'HMB', 'Pressure_Drop_Static', 'f703790d-f5f6-4c46-a550-65c9379238d9');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('d3c042bb-3b92-4793-ba03-ad89adb7b401', '00000000-0000-0000-0000-000000000000', 'HMB', 'Pressure_Pipe_End_Point', 'f703790d-f5f6-4c46-a550-65c9379238d9');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('046537bf-d8cf-4cd2-8e9c-f9cc71c38d3f', '00000000-0000-0000-0000-000000000000', 'HMB', 'Power', '9350369e-a419-43fa-a1eb-2cf0c12e7fe8');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('40555a89-947d-48d8-9a28-c7f6f137317c', '00000000-0000-0000-0000-000000000000', 'Nozzle', 'Pressure', 'c5747d95-f3c1-477f-b849-01962fb2c386');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('375a8af7-c464-4d7f-9545-4823a15e88bb', '00000000-0000-0000-0000-000000000000', 'Nozzle', 'Pressure_Drop', 'c5747d95-f3c1-477f-b849-01962fb2c386');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('1d12bbb1-f756-462d-8790-4de8a0042c36', '00000000-0000-0000-0000-000000000000', 'Nozzle', 'Elevation', '53ce4c36-cedb-40d9-8cea-51182e0b4fd9');

INSERT INTO DrawingsUnits (UID, Drawings_UID, Table_Name, Column_Name, Units_UID) VALUES ('6a23cf77-fae8-42f1-b187-a7c9dc396b8d', '00000000-0000-0000-0000-000000000000', 'Nozzle', 'Over_Design_CV', '1ea01ecc-e03a-4e7c-93db-2628c07b0a92');

-- SymbolType

INSERT INTO SymbolType (UID, Category, Type) VALUES ('ae1ab002-db64-4806-9b63-3c5d4e82a039', 'Equipment - [ Pressurized ]', 'Drum');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('6dcf31af-83a0-4edc-84a8-fa0ab932a15f', 'Equipment - [ Pressurized ]', 'Column');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('c4e77a50-9714-46e6-b171-b68259ad65a2', 'Equipment - [ Pressurized ]', 'Miscellaneous');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('59ef6cc9-b520-4448-8e9b-7f5288d00c88', 'Equipment - [ Pressurized ]', 'Battery Limit');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('96897a46-fffe-494b-bb3f-b977ca8d9041', 'Equipment - [ Pressurized ]', 'Tank');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('c9188464-2ed0-46d4-a66f-f88517de3ca0', 'Equipment - [ Pressure Drop ]', 'Heat Exchanger');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('d57e6b85-491c-4bff-99ee-84671d7c23f4', 'Equipment - [ Pressure Drop ]', 'Air Fin Cooler');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('0bb39779-4eb0-45d8-ba78-016a46b0f471', 'Equipment - [ Pressure Drop ]', 'Filter');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('0cd5cd00-af1a-4e72-800e-a31946880749', 'Equipment - [ Pressure Drop ]', 'Strainer');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('392f08bf-ed9f-4775-850a-d6bdeb03202f', 'Equipment - [ Pressure Drop ]', 'Miscellaneous DP Equipment');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('38a4df37-a6ab-450a-9af4-ace894432f14', 'Equipment - [ Rotating ]', 'Pump');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('d634c101-e3f6-4e9f-9697-1b3203823441', 'Equipment - [ Rotating ]', 'Compressor');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('0212df4f-3c44-491e-bb87-958d224a4e47', 'Instrument', 'Valve');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('049476cf-4417-4507-8368-f83381b6a9d1', 'Instrument', 'Line Splitter');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('65e844b0-67af-4185-92b5-8944177a8441', 'Instrument', 'Flowmeter');

INSERT INTO SymbolType (UID, Category, Type) VALUES ('4e2085b8-a3c3-4df4-b918-a9f996547b5b', 'Instrument', 'Reducer');

-- Symbols

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('421e40ae-6cdd-48ab-94c5-534aa585b2a4', 'Battery Limit Downward', '59ef6cc9-b520-4448-8e9b-7f5288d00c88', '8.0,23.0', '');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('76286107-b635-44bf-9a56-2fb5906c2e0a', 'Battery Limit Left', '59ef6cc9-b520-4448-8e9b-7f5288d00c88', '25.0,6.0', '');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('20640fa8-8cee-408a-b8e6-a3b48b950270', 'Battery Limit Right', '59ef6cc9-b520-4448-8e9b-7f5288d00c88', '26.0,7.0', '');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('4fac902e-d256-4f05-bb60-4a7395424323', 'Battery Limit Upward', '59ef6cc9-b520-4448-8e9b-7f5288d00c88', '6.0,21.0', '');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('d126fb04-4c5d-4829-893e-4fd2b4f6afea', 'Column with Tray', '6dcf31af-83a0-4edc-84a8-fa0ab932a15f', '16.0,59.0', 'AUTO,16.0,1.0,0/AUTO,5.0,4.0,0/AUTO,1.0,25.0,0/AUTO,0.0,59.0,0/AUTO,0.0,95.0,0/AUTO,5.0,115.0,0/AUTO,16.0,118.0,0/AUTO,26.0,114.0,0/AUTO,31.0,95.0,0/AUTO,31.0,59.0,0/AUTO,31.0,24.0,0/AUTO,26.0,4.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('9d2f98f2-7288-48c1-9e6d-e20c96f74f47', 'Packing Column', '6dcf31af-83a0-4edc-84a8-fa0ab932a15f', '17.0,60.0', 'AUTO,17.0,0.0,0/AUTO,4.0,6.0,0/AUTO,1.0,33.0,0/AUTO,1.0,91.0,0/AUTO,5.0,116.0,0/AUTO,17.0,119.0,0/AUTO,28.0,116.0,0/AUTO,32.0,91.0,0/AUTO,32.0,33.0,0/AUTO,29.0,6.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('6a6fb62a-f748-4f05-85db-28a163f44e0c', 'Horizontal Drum', 'ae1ab002-db64-4806-9b63-3c5d4e82a039', '46.0,19.0', 'AUTO,46.0,1.0,0/AUTO,25.0,0.0,0/AUTO,4.0,8.0,0/AUTO,4.0,31.0,0/AUTO,25.0,37.0,0/AUTO,46.0,37.0,0/AUTO,68.0,37.0,0/AUTO,90.0,30.0,0/AUTO,88.0,7.0,0/AUTO,68.0,0.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('8a51c79b-0a4e-4ec0-af56-84863cb0585b', 'Vertical Drum', 'ae1ab002-db64-4806-9b63-3c5d4e82a039', '18.0,46.0', 'AUTO,18.0,0.0,0/AUTO,5.0,7.0,0/AUTO,0.0,24.0,0/AUTO,0.0,46.0,0/AUTO,0.0,71.0,0/AUTO,5.0,88.0,0/AUTO,18.0,93.0,0/AUTO,31.0,88.0,0/AUTO,37.0,71.0,0/AUTO,37.0,46.0,0/AUTO,37.0,24.0,0/AUTO,31.0,6.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('9a4d206f-8fb9-4a63-ab66-09c6c648024b', 'Miscellaneous Equipment', 'c4e77a50-9714-46e6-b171-b68259ad65a2', '35.0,29.0', 'AUTO,27.0,0.0,0/AUTO,13.0,0.0,0/AUTO,1.0,9.0,0/AUTO,0.0,23.0,0/AUTO,0.0,35.0,0/AUTO,12.0,51.0,0/AUTO,27.0,58.0,0/AUTO,44.0,58.0,0/AUTO,69.0,35.0,0/AUTO,70.0,23.0,0/AUTO,59.0,9.0,0/AUTO,43.0,1.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('5fadefd3-e3ad-450f-9b20-fd37ea68ab2a', 'Ball Tank', '96897a46-fffe-494b-bb3f-b977ca8d9041', '31.0,29.0', 'AUTO,31.0,1.0,0/AUTO,7.0,11.0,0/AUTO,0.0,29.0,0/AUTO,11.0,50.0,0/AUTO,31.0,58.0,0/AUTO,50.0,49.0,0/AUTO,59.0,29.0,0/AUTO,50.0,10.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('2e09e3d3-a679-4aff-ac80-27805a798053', 'Cone Roof Tank', '96897a46-fffe-494b-bb3f-b977ca8d9041', '43.0,33.0', 'AUTO,43.0,1.0,0/AUTO,19.0,12.0,0/AUTO,0.0,24.0,0/AUTO,0.0,43.0,0/AUTO,0.0,58.0,0/AUTO,86.0,58.0,0/AUTO,86.0,41.0,0/AUTO,86.0,23.0,0/AUTO,63.0,11.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('976b3320-7644-439b-9348-85e83d813344', 'Dome Roof Tank', '96897a46-fffe-494b-bb3f-b977ca8d9041', '45.0,34.0', 'AUTO,45.0,0.0,0/AUTO,12.0,7.0,0/AUTO,0.0,25.0,0/AUTO,1.0,43.0,0/AUTO,1.0,59.0,0/AUTO,90.0,59.0,0/AUTO,90.0,42.0,0/AUTO,90.0,24.0,0/AUTO,71.0,5.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('239836be-e8a8-4c0c-9c89-bd929c200560', 'Air Fin Cooler', 'd57e6b85-491c-4bff-99ee-84671d7c23f4', '22.0,10.0', 'AUTO,0.0,10.0,0/AUTO,40.0,10.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('6b0d5cfe-91c2-47d6-9222-6c01b62d0831', 'Horizontal Filter', '0bb39779-4eb0-45d8-ba78-016a46b0f471', '10.0,14.0', 'AUTO,2.0,14.0,0/AUTO,18.0,14.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('77aa897c-87b0-4e12-9333-cd86a4c2cc90', 'Vertical Filter', '0bb39779-4eb0-45d8-ba78-016a46b0f471', '15.0,11.0', 'AUTO,15.0,2.0,0/AUTO,15.0,19.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('aaa714f4-dd84-4ec9-b2bb-bf9fea75a1e5', 'Miscellaneous Coil', '392f08bf-ed9f-4775-850a-d6bdeb03202f', '24.0,10.0', 'AUTO,0.0,10.0,0/AUTO,49.0,11.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('c64345a6-69d7-4962-b759-060b7c034463', 'Miscellaneous DP Equipment', '392f08bf-ed9f-4775-850a-d6bdeb03202f', '14.0,12.0', 'AUTO,14.0,0.0,0/AUTO,0.0,12.0,0/AUTO,14.0,24.0,0/AUTO,29.0,12.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('ed0e2efa-a3fd-4551-9531-056bcea53b88', 'Miscellaneous Reactor', '392f08bf-ed9f-4775-850a-d6bdeb03202f', '10.0,26.0', 'AUTO,10.0,0.0,0/AUTO,0.0,16.0,0/AUTO,0.0,39.0,0/AUTO,10.0,52.0,0/AUTO,21.0,39.0,0/AUTO,21.0,16.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('daaf742f-2812-42a1-946f-f5b4e15f9c11', 'Horizontal T Strainer', '0cd5cd00-af1a-4e72-800e-a31946880749', '10.0,8.0', 'AUTO,0.0,5.0,0/AUTO,21.0,5.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('dec49151-d729-403c-93ee-de463ea22eca', 'Horizontal Y Strainer', '0cd5cd00-af1a-4e72-800e-a31946880749', '10.0,8.0', 'AUTO,0.0,5.0,0/AUTO,20.0,5.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('c8054384-a997-4a06-a7cd-5d61a110a290', 'Vertical T Strainer', '0cd5cd00-af1a-4e72-800e-a31946880749', '9.0,12.0', 'AUTO,6.0,0.0,0/AUTO,6.0,24.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('e7fc0b00-f2ab-453c-946d-bad8fee59510', 'Vertical Y Strainer', '0cd5cd00-af1a-4e72-800e-a31946880749', '10.0,12.0', 'AUTO,6.0,0.0,0/AUTO,6.0,25.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('b8c50ea8-12a1-420f-bce4-a5746c01b662', 'Double Pipe Heat Exchanger', 'c9188464-2ed0-46d4-a66f-f88517de3ca0', '24.0,19.0', 'AUTO,0.0,12.0,0/AUTO,8.0,6.0,0/AUTO,0.0,26.0,0/AUTO,8.0,32.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('cdab06ad-76ab-4be0-a743-dc258feac23f', 'Horizontal Heat Exchanger', 'c9188464-2ed0-46d4-a66f-f88517de3ca0', '31.0,10.0', 'AUTO,24.0,1.0,0/AUTO,0.0,10.0,0/AUTO,40.0,18.0,0/AUTO,62.0,10.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('0abef000-15ff-457d-bb66-c4e5b745f0a1', 'Kettle Heat Exchanger', 'c9188464-2ed0-46d4-a66f-f88517de3ca0', '32.0,14.0', 'AUTO,11.0,13.0,0/AUTO,44.0,1.0,0/AUTO,11.0,27.0,0/AUTO,44.0,27.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('f95f3a23-1210-43fb-8211-0b43a6a7e793', 'Plate Heat Exchanger', 'c9188464-2ed0-46d4-a66f-f88517de3ca0', '16.0,14.0', 'AUTO,0.0,7.0,0/AUTO,0.0,20.0,0/AUTO,31.0,20.0,0/AUTO,31.0,7.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('0539a779-137b-4ffa-b2f6-f08b7ba1e051', 'Vertical Heat Exchanger', 'c9188464-2ed0-46d4-a66f-f88517de3ca0', '12.0,30.0', 'AUTO,12.0,0.0,0/AUTO,4.0,40.0,0/AUTO,12.0,60.0,0/AUTO,21.0,22.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('c72c3fd8-ad62-44b0-8e4b-9afb1a91a008', 'Compressor Left', 'd634c101-e3f6-4e9f-9697-1b3203823441', '50.0,15.0', '');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('7acbec09-f78c-40f1-84a1-54a784fff455', 'Compressor Right', 'd634c101-e3f6-4e9f-9697-1b3203823441', '48.0,14.0', '');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('eb4cdd9e-4f1a-4d47-be8c-0a67076086f0', 'Horizontal Pump Left', '38a4df37-a6ab-450a-9af4-ace894432f14', '28.0,14.0', '');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('6c18a55d-1cef-4eab-9d1f-924e7c0cb508', 'Horizontal Pump Right', '38a4df37-a6ab-450a-9af4-ace894432f14', '28.0,14.0', '');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('c5343a5c-1251-4f1a-841b-2b8e7e76daf7', 'Vertical Pump', '38a4df37-a6ab-450a-9af4-ace894432f14', '9.0,29.0', 'AUTO,0.0,53.0,0/AUTO,18.0,53.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('c8fc24b5-a035-462c-aeb0-b7df2d848025', 'Horizontal Flowmeter Orifice', '65e844b0-67af-4185-92b5-8944177a8441', '8.0,16.0', 'AUTO,0.0,22.0,0/AUTO,16.0,22.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('6d251863-c372-4f88-bade-1d39dd604cbc', 'Horizontal Flowmeter Others', '65e844b0-67af-4185-92b5-8944177a8441', '8.0,20.0', 'AUTO,0.0,31.0,0/AUTO,16.0,31.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('6bfaf7f9-d99f-40f1-9e68-e4ad7e1aa0bf', 'Horizontal Flowmeter Venturi', '65e844b0-67af-4185-92b5-8944177a8441', '27.0,10.0', 'AUTO,0.0,10.0,0/AUTO,54.0,10.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('4672b15e-1622-4723-9d8e-6fb7f6f65555', 'Vertical Flowmeter Orifice', '65e844b0-67af-4185-92b5-8944177a8441', '17.0,8.0', 'AUTO,11.0,0.0,0/AUTO,11.0,16.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('d49b243d-5ec5-48a9-a850-e9eb93259fb7', 'Vertical Flowmeter Others', '65e844b0-67af-4185-92b5-8944177a8441', '20.0,8.0', 'AUTO,10.0,0.0,0/AUTO,10.0,15.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('f240dad4-0682-4d04-aa1c-b09af06dedc6', 'Vertical Flowmeter Venturi', '65e844b0-67af-4185-92b5-8944177a8441', '10.0,28.0', 'AUTO,10.0,0.0,0/AUTO,10.0,56.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('4d7e16da-b512-4a3d-9940-501aa60da7db', 'Line Splitter', '049476cf-4417-4507-8368-f83381b6a9d1', '8.0,8.0', 'AUTO,8.0,0.0,0/AUTO,0.0,8.0,0/AUTO,8.0,17.0,0/AUTO,17.0,8.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('7a30c86a-07cc-4892-b755-c6f344fa0adb', 'Reducer Downward', '4e2085b8-a3c3-4df4-b918-a9f996547b5b', '8.0,7.0', 'AUTO,8.0,0.0,0/AUTO,8.0,14.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('0cc910ca-0e33-41db-888e-bea208e74835', 'Reducer Left', '4e2085b8-a3c3-4df4-b918-a9f996547b5b', '7.0,8.0', 'AUTO,0.0,8.0,0/AUTO,14.0,8.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('5bfd862c-c650-4382-b9da-25a33713d8ef', 'Reducer Right', '4e2085b8-a3c3-4df4-b918-a9f996547b5b', '7.0,8.0', 'AUTO,0.0,8.0,0/AUTO,14.0,8.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('ea0521a2-f89b-4c7d-b364-120c12222d4e', 'Reducer Upward', '4e2085b8-a3c3-4df4-b918-a9f996547b5b', '8.0,8.0', 'AUTO,8.0,0.0,0/AUTO,8.0,16.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('004f2a18-3490-4f90-bcc6-ee1db823d5df', 'Horizontal Control Valve', '0212df4f-3c44-491e-bb87-958d224a4e47', '14.0,13.0', 'AUTO,0.0,19.0,0/AUTO,25.0,19.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('ac8ef088-52c5-4e77-8151-dcf707f30eeb', 'Horizontal Manual Valve', '0212df4f-3c44-491e-bb87-958d224a4e47', '12.0,14.0', 'AUTO,0.0,21.0,0/AUTO,23.0,21.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('a8ada92b-b940-47c4-982a-42a35879930b', 'Vertical Control Valve', '0212df4f-3c44-491e-bb87-958d224a4e47', '13.0,12.0', 'AUTO,6.0,0.0,0/AUTO,6.0,23.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('55c9a80e-4a98-4cc9-846b-571b2e84f75c', 'Vertical Manual Valve', '0212df4f-3c44-491e-bb87-958d224a4e47', '14.0,12.0', 'AUTO,6.0,0.0,0/AUTO,6.0,23.0,0');

INSERT INTO Symbols (UID, Name, SymbolType_UID, OriginalPoint, ConnectionPoint) VALUES ('9f2ada04-a63a-4032-845a-3b8087637b4d', 'Dual Packing Column', '6dcf31af-83a0-4edc-84a8-fa0ab932a15f', '16.0,59.0', 'AUTO,16.0,0.0,0/AUTO,5.0,4.0,0/AUTO,0.0,23.0,0/AUTO,0.0,59.0,0/AUTO,0.0,101.0,0/AUTO,6.0,115.0,0/AUTO,16.0,118.0,0/AUTO,26.0,115.0,0/AUTO,31.0,101.0,0/AUTO,31.0,59.0,0/AUTO,31.0,23.0,0/AUTO,26.0,4.0,0');