-- test data for dbtree
DELETE FROM dbtree;
BEGIN;
INSERT INTO dbtree VALUES( 1000, NULL, '001', NULL, '', 4, 3, NULL, TRUE );
INSERT INTO dbtree VALUES( 1001, 1000, '001-001', NULL, '', 3, 2, NULL, TRUE );
INSERT INTO dbtree VALUES( 1002, 1001, '001-001-001', NULL, '', 1, 1, NULL, TRUE );
INSERT INTO dbtree VALUES( 1003, 1002, 'A', NULL, '', 0, 0, NULL, TRUE );
INSERT INTO dbtree VALUES( 1004, 1002, 'B', NULL, '', 0, 0, NULL, TRUE );
INSERT INTO dbtree VALUES( 1007, 1001, '001-001-002', NULL, '', 2, 2, NULL, TRUE );
INSERT INTO dbtree VALUES( 1008, 1007, '001-001-002-001', NULL, '', 1, 1, NULL, TRUE );
INSERT INTO dbtree VALUES( 1009, 1008, 'A', NULL, '', 0, 0, NULL, TRUE );
INSERT INTO dbtree VALUES( 1010, 1007, '001-001-002-002', NULL, '', 1, 1, NULL, TRUE );
INSERT INTO dbtree VALUES( 1011, 1010, 'A', NULL, '', 0, 0, NULL, TRUE );
INSERT INTO dbtree VALUES( 1012, 1010, 'B', NULL, '', 0, 0, NULL, TRUE );
INSERT INTO dbtree VALUES( 1013, 1010, 'C', NULL, '', 0, 0, NULL, TRUE );
INSERT INTO dbtree VALUES( 1014, 1001, '001-001-003', NULL, '', 2, 2, NULL, TRUE );
INSERT INTO dbtree VALUES( 1015, 1014, '001-001-003-001', NULL, '', 1, 1, NULL, TRUE );
INSERT INTO dbtree VALUES( 1016, 1015, 'A', NULL, '', 0, 0, NULL, TRUE );
INSERT INTO dbtree VALUES( 1017, 1014, '001-001-003-002', NULL, '', 1, 1, NULL, TRUE );
INSERT INTO dbtree VALUES( 1018, 1017, 'A', NULL, '', 0, 0, NULL, TRUE );
INSERT INTO dbtree VALUES( 1019, 1017, 'B', NULL, '', 0, 0, NULL, TRUE );
COMMIT;

Test data for the dbtree
Test data for the dbtree
