.separator "\t"


BEGIN TRANSACTION;
SELECT 'CREATING family_info' AS '';
CREATE TABLE family_info(family VARCHAR(10) PRIMARY KEY, short_name VARCHAR(50), long_name VARCHAR(255), num_members INTEGER, num_uniref50_members INTEGER, num_uniref90_members INTEGER);
/*CREATE TABLE family_info(family VARCHAR(10) PRIMARY KEY, short_name VARCHAR(50), long_name VARCHAR(255), num_members INTEGER, num_uniref50_members INTEGER, num_uniref90_members INTEGER, family_type VARCHAR(22), parent VARCHAR(10));*/
CREATE INDEX family_Index ON family_info (family);

SELECT 'LOADING family_info' AS '';
.import 'family_info.tab'  family_info
COMMIT;

BEGIN TRANSACTION;
SELECT 'CREATING PFAM_clans' AS '';
CREATE TABLE PFAM_clans(pfam_id VARCHAR(24), clan_id VARCHAR(24));
CREATE INDEX clan_id_Index ON PFAM_clans (clan_id);

SELECT 'LOADING PFAM_clans' AS '';
.import 'PFAM_clans.tab'  PFAM_clans
COMMIT;

