File: sqlite.sql

package info (click to toggle)
libdbix-class-tree-perl 0.03003-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 244 kB
  • sloc: perl: 1,554; sql: 8; makefile: 8
file content (10 lines) | stat: -rw-r--r-- 168 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
 

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