android SQLite数据库中创建表时添加主键及外键关联
CREATE TABLE pruview
(
id INTEGER,
module_name VARCHAR (50),
father_id INTEGER,
module_code VARCHAR (10),
pruview VARCHAR (2),
primary key (id),
foreign key (father_id) references pruview(id)
);
CREATE TABLE pruview
(
id INTEGER,
module_name VARCHAR (50),
father_id INTEGER,
module_code VARCHAR (10),
pruview VARCHAR (2),
primary key (id),
foreign key (father_id) references pruview(id)
);