src/packages/create_ebuild.sql

DROP TABLE IF EXISTS ebuild;
CREATE TABLE ebuild
(
        category VARCHAR(30),
        name VARCHAR(45),
        version VARCHAR(30) NOT NULL,
        when_found TIMESTAMP,
        arch VARCHAR(160),
        changelog MEDIUMTEXT,
    prevarch VARCHAR(160),
    is_masked TINYINT(4),
        PRIMARY KEY (category,name,version)
)
1	marduk	1.2.4.1	DROP TABLE IF EXISTS ebuild;
2	marduk	1.1	CREATE TABLE ebuild
3			(
4			category VARCHAR(30),
5			name VARCHAR(45),
6			version VARCHAR(30) NOT NULL,
7			when_found TIMESTAMP,
8	marduk	1.2	arch VARCHAR(160),
9	marduk	1.1	changelog MEDIUMTEXT,
10	marduk	1.2.4.1	prevarch VARCHAR(160),
11			is_masked TINYINT(4),
12	marduk	1.1	PRIMARY KEY (category,name,version)
13			)