src/packages/create_package.sql

DROP TABLE IF EXISTS package;
CREATE TABLE package
(
        category VARCHAR(30),
        name VARCHAR(40),
        homepage VARCHAR(100),
        description VARCHAR(180),
        license VARCHAR(30),
    new TINYINT(4),
        PRIMARY KEY (category,name)
)
1	DROP TABLE IF EXISTS package;
2	CREATE TABLE package
3	(
4	category VARCHAR(30),
5	name VARCHAR(40),
6	homepage VARCHAR(100),
7	description VARCHAR(180),
8	license VARCHAR(30),
9	new TINYINT(4),
10	PRIMARY KEY (category,name)
11	)