#10 Toplevel cases appear as orphans on fresh system

[Keith Tyler]

Apparently there needs to be a TCID 0 in order for
toplevels to not be considered orphans. Toplevels have
parent of 0, which doesn't theoretically exist.

Live site apparently has a "root TC" of TCID 0:

+------+-----+----------------+-------+---------+----------+--------+--------+--
-----------+
| tcid | pid | descr | level | details |
block_by | parent | author | a
ssigned_to |
+------+-----+----------------+-------+---------+----------+--------+--------+--
-----------+
| 0 | 0 | Root test case | 1 | |
NULL | NULL | 0 |
NULL |
+------+-----+----------------+-------+---------+----------+--------+--------+--
-----------+

This should be added to tcw.schema.

This only affects the "Check for orphans" tool on the
admin page, which is only a cruft-removal tool and not
entirely necessary (unless you accumulate tons of such
cruft). Actually it's really just a workaround for a
difficult functional problem (should we delete childen
of deleted parents automatically?).

Hopefully no one will delete such cases from the orphan
view, recognizing their importance. The orphan tool is
not meant for someone who knows nothing about what's in
the test suites.

[Nobody/Anonymous]

Logged In: NO

The quickfix is to open mysql client and run the sql:

insert into test (tcid,pid,descr,level) values (0,0,"Root test case",1);
update test set tcid=0 where tcid=last_insert_id();