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	marduk	1.1.1.1.4.1	DROP TABLE IF EXISTS package;
2	marduk	1.1	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	marduk	1.1.1.1.4.1	new TINYINT(4),
10	marduk	1.1	PRIMARY KEY (category,name)
11			)