# Conflicts:
#	SpigotCore_Main/src/de/steamwar/sql/Schematic.java

@@ -32,16 +32,14 @@ import java.util.logging.Level;
 
 public class CheckedSchematic {

@@ -34,3 +34,2 @@
 
-    private final String schemName;
-    private final int schemOwner;
+    private final int node;

@@ -33,1 +33,3 @@
-    public static String getLink(Schematic schem){
+    public static String getLink(SchematicNode schem){
+        if(schem.isDir())
+            throw new SecurityException("Can not Download Directorys");

@@ -35,35 +35,18 @@ import java.util.UUID;
 
 public class Schematic {

@@ -16,3 +1,1 @@
-    You should have received a copy of the GNU Affero General Public License
-    along with this program.  If not, see <https://www.gnu.org/licenses/>.
-*/
+/*

@@ -26,3 +25,4 @@
 import java.util.UUID;
+import java.util.stream.Collectors;
 
 public class SchematicMember {

@@ -0,0 +33,4 @@
+
+public class SchematicNode {
+
+    private static final String DIR_TYPE = "directory";

@@ -0,0 +25,4 @@
+import java.util.UUID;
+
+
+public class CheckedNode {

@@ -0,0 +59,4 @@
+        SchematicNode sNode = SchematicNode.getSchematicNode(node);
+        String nodeName = sNode.getName();
+        int nodeOwner = sNode.getOwner();
+        SQL.update("INSERT INTO CheckedSchematic" +

@@ -0,0 +96,4 @@
+    }
+
+    public void remove() {
+        SQL.update("DELETE FROM CheckedSchematic WHERE NodeId", node);

@@ -0,0 +24,4 @@
+import java.util.HashSet;
+import java.util.Set;
+
+public class NodeMember {

@@ -0,0 +412,4 @@
+    }
+
+    private void updateDB() {
+        SQL.update("UPDATE SchematicNode SET NodeName = ?, NodeOwner = ?, ParentNode = ?, NodeItem = ?, NodeType = ?, NodeRank = ? WHERE NodeId = ?",

@@ -0,0 +422,4 @@
+        if (isDir()) {
+            getSchematicNodeInNode(getId()).forEach(SchematicNode::delete);
+        }
+        SQL.update("DELETE FROM SchematicNode WHERE NodeId = ?", id);

@@ -0,0 +426,4 @@
+    }
+
+    public InputStream schemData() throws IOException {
+        ResultSet rs = SQL.select("SELECT NodeData FROM SchematicNode WHERE NodeId = ?", id);

@@ -0,0 +469,4 @@
+    }
+
+    private void updateDatabase(InputStream blob, boolean newFormat) {
+        SQL.update("UPDATE SchematicNode SET NodeData = ?, NodeFormat = ? WHERE NodeId = ?", blob, newFormat, id);