Create Table

android=> create table testbst
(
id char(4),
parentId char(4),
value int,
primary key(id), foreign key(id) references testbst);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "testbst_pkey" for table "testbst"
CREATE TABLE