[Oscarmcmaster-cvscommit] oscar_mcmaster/database/mysql oscarinit.sql, 1.244, 1.245

[Jackson Bi <yg...@us...>]

Update of /cvsroot/oscarmcmaster/oscar_mcmaster/database/mysql
In directory sfp-cvsdas-4.v30.ch3.sourceforge.com:/tmp/cvs-serv24306

Modified Files:
	oscarinit.sql 
Log Message:
-ID: 3009629
-add queue, queue_provider_link and queue_document_link table.

Index: oscarinit.sql
===================================================================
RCS file: /cvsroot/oscarmcmaster/oscar_mcmaster/database/mysql/oscarinit.sql,v
retrieving revision 1.244
retrieving revision 1.245
diff -C2 -d -r1.244 -r1.245
*** oscarinit.sql	2 Jun 2010 15:24:02 -0000	1.244
--- oscarinit.sql	4 Jun 2010 19:45:50 -0000	1.245
***************
*** 7990,7993 ****
--- 7990,8016 ----
  ) TYPE=MyISAM;
  
+ DROP TABLE IF EXISTS queue;
+ create table queue (
+     id int(10) not null auto_increment,
+     name varchar(40) not null ,
+     primary key(id),unique (name)
+ );
+ 
+ DROP TABLE IF EXISTS queue_provider_link;
+ create table queue_provider_link (
+     id int(10) not null auto_increment,
+     queue_id int(10),
+     provider_id varchar(6),
+     primary key(id)
+ );
+ 
+ DROP TABLE IF EXISTS queue_document_link;
+ create table queue_document_link (
+     id int(10) not null auto_increment,
+     queue_id int(10) not null,
+     document_id int(10) not null,
+     primary key (id)
+ );
+ 
  CREATE TABLE `other_id` (
  	id int NOT NULL AUTO_INCREMENT PRIMARY KEY,