[AppDB] link bugs patch 1 of 6

[Tony Lambregts]

This is the first of the patches that gives better integration of 
bugzilla with the AppDB. They are submitted in the order that they 
should be applied. If you want to test them out you should download the 
tarball for bugzilla from ftp://ftp.winehq.org/pub/wine/ (Thanks Jeremy...)

Change Log: SQL to create buglinks table.

New files: tables/buglinks.sql

-------------- next part --------------
--- /dev/null	2005-06-26 13:54:45.811553416 -0600
+++ tables/buglinks.sql	2005-07-07 20:33:19.000000000 -0600
@@ -0,0 +1,18 @@
+use apidb;
+
+drop table if exists buglinks;
+
+/*
+ * link a bug to a version of an application
+ */
+create table buglinks (
+        linkId          int not null auto_increment,
+	bug_id          int not null,
+	versionId       int not null,
+	submitTime	timestamp(14) NOT NULL,
+	submitterId	int(11) NOT NULL default '0',
+	queued		enum('true','false') NOT NULL default 'false',
+        key(linkId),
+	index(bug_id),
+	index(versionId)
+);