Re: Schema reorganization for package_notes table

2014-09-19 Thread Holger Levsen
Hi, On Sonntag, 2. Februar 2014, Florian Weimer wrote: > The package_notes table currently looks like this: > > CREATE TABLE package_notes > (id INTEGER NOT NULL PRIMARY KEY, > bug_name TEXT NOT NULL, > package TEXT NOT NULL, > fixed_version TEXT >

Re: Schema reorganization for package_notes table

2014-02-05 Thread Moritz Mühlenhoff
On Sun, Feb 02, 2014 at 10:15:42PM +0100, Florian Weimer wrote: > The package_notes table currently looks like this: > > CREATE TABLE package_notes > (id INTEGER NOT NULL PRIMARY KEY, > bug_name TEXT NOT NULL, > package TEXT NOT NULL, > fixed_version TEXT >

Schema reorganization for package_notes table

2014-02-02 Thread Florian Weimer
The package_notes table currently looks like this: CREATE TABLE package_notes (id INTEGER NOT NULL PRIMARY KEY, bug_name TEXT NOT NULL, package TEXT NOT NULL, fixed_version TEXT CHECK (fixed_version IS NULL OR fixed_version <> ''), fixed_ver