Tests for adjacency list as well as a bunch of fixes.

[dbsrgits/DBIx-Class-Tree.git] / t / lib / sqlite.sql

diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql
new file mode 100644 (file)
index 0000000..b66dac1
--- /dev/null
+++ b/t/lib/sqlite.sql
@@ -0,0 +1,10 @@
+
+CREATE TABLE nodes (
+    node_id INTEGER PRIMARY KEY AUTOINCREMENT,
+    name STRING,
+    parent_id INTEGER,
+    position INTEGER,
+    lft INTEGER,
+    rgt INTEGER
+);
+