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

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

CREATE TABLE nodes (
    node_id INTEGER PRIMARY KEY AUTOINCREMENT,
    name STRING,
    parent_id INTEGER,
    position INTEGER,
    lft INTEGER,
    rgt INTEGER
);