1 files changed, 13 insertions, 0 deletions

diff --git a/examples/adjacencytree/tables.py b/examples/adjacencytree/tables.py
new file mode 100644
index 000000000..3cfe1e931
--- /dev/null
+++ b/examples/adjacencytree/tables.py
@@ -0,0 +1,13 @@
+from sqlalchemy.schema import *
+import sqlalchemy.engine
+
+engine = sqlalchemy.engine.create_engine('sqlite', ':memory:', {}, echo = True)
+
+trees = Table('treenodes', engine,
+    Column('node_id', Integer, primary_key=True),
+    Column('parent_node_id', Integer, ForeignKey('treenodes.node_id'), nullable=True),
+    Column('root_node_id', Integer, ForeignKey('treenodes.node_id'), nullable=True),
+    Column('node_name', String(50), nullable=False)
+    )
+    
+trees.create()
\ No newline at end of file