CREATE TABLE desc (
name VARCHAR(25) PRIMARY KEY,
description VARCHAR(60)
);
;
CREATE INDEX desc_name ON desc(name);

CREATE TABLE pkgs (
category VARCHAR(10),
name VARCHAR(25) PRIMARY KEY,
ver VARCHAR(10),
yn VARCHAR(3),
repo VARCHAR(10),
status VARCHAR(3)
);
;
CREATE INDEX pkgs_name ON pkgs(name);