public static void create(Statement stmt) {
        String insertTool = "CREATE TRIGGER IF NOT EXISTS InsertTool " +
                "AFTER INSERT ON Tools " +
                "FOR EACH ROW " +
                "BEGIN " +
                    "INSERT INTO ToolLog " +
                    "(ToolID, Type, Description, Date, Division, TeamID, UserName, Condition, Price, Comment) " +
                    "VALUES " +
                    "( new.ToolID, 'New Tool', new.Description, new.DatePurchase," +
                    "  ( SELECT Description FROM Divisions WHERE Code = new.DivisionCode ), " +
                    "  new.TeamID, new.UserName, " +
                    "  ( SELECT Description FROM Conditions WHERE Code = new.ConditionCode ), " +
                    "  new.Price, 'CommentHere' );" +
                "END";
        
        String insertPhoto = "CREATE TRIGGER IF NOT EXISTS InsertPhoto " +
                "AFTER INSERT ON Images " +
                "FOR EACH ROW " +
                "BEGIN " +
                    "INSERT INTO ToolLog " +
                    "(ToolID, Type, Date, Comment) " +
                    "VALUES " +
                    "( new.ToolID, 'New Photo', CURRENT_TIMESTAMP, " +
                    " 'PhotoNo: ' || new.PhotoNo || ' FileName: ' || new.FileName || ' Description: ' || new.Description );" +                   
                "END";

        String deletePhoto = "CREATE TRIGGER IF NOT EXISTS DeletePhoto " +
                "AFTER DELETE ON Images " +
                "FOR EACH ROW " +
                "BEGIN " +
                    "INSERT INTO ToolLog " +
                    "(ToolID, Type, Date, Comment) " +
                    "VALUES " +
                    "( old.ToolID, 'Delete Photo', CURRENT_TIMESTAMP, " +
                    " 'PhotoNo: '|| old.PhotoNo || ' FileName: ' || old.FileName || ' Description: ' || old.Description );" +
                "END";
        
        String updateOwnerAttributes = "CREATE TRIGGER IF NOT EXISTS UpdateOwnerAttributes " +
                "AFTER UPDATE OF DivisionCode, TeamID, UserName ON Tools " +
                "FOR EACH ROW " +
                "WHEN " +
                    "Old.DivisionCode <> New.DivisionCode "+
                    " OR " +
                    "Old.TeamId       <> New.TeamId "+
                    " OR " +
                    "Old.UserName     <> New.UserName "+
                "BEGIN " +
                    "INSERT INTO ToolLog " +
                    "( ToolID, Type, Date, Division, TeamID, UserName ) " +
                    "VALUES " +
                    "( new.ToolID, 'Update Owner Attributes', CURRENT_TIMESTAMP, " +
                    "  ( SELECT Description FROM Divisions WHERE Code = new.DivisionCode ), " +
                    "  new.TeamID, new.UserName );" +
                "END";
        
        String toolCounted;
        
        try {
            stmt.executeUpdate(insertTool);
            stmt.executeUpdate(insertPhoto);
            stmt.executeUpdate(deletePhoto);
            stmt.executeUpdate(updateOwnerAttributes);
            //stmt.executeUpdate(toolCounted);
            
        } catch (SQLException ex) {
            ex.printStackTrace();
        }        
    }