You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by sm...@apache.org on 2011/07/15 18:03:32 UTC
svn commit: r1147207 - in /incubator/airavata/trunk/ws-messaging/messagebox:
resources/msgbox_tables.sql src/main/resources/msgbox_tables.sql
Author: smarru
Date: Fri Jul 15 16:03:32 2011
New Revision: 1147207
URL: http://svn.apache.org/viewvc?rev=1147207&view=rev
Log:
adding mysql mesage box scripts. We need to retain support for mysql although derby will be used by defualt
Added:
incubator/airavata/trunk/ws-messaging/messagebox/src/main/resources/msgbox_tables.sql
- copied, changed from r1147203, incubator/airavata/trunk/ws-messaging/messagebox/resources/msgbox_tables.sql
Removed:
incubator/airavata/trunk/ws-messaging/messagebox/resources/msgbox_tables.sql
Copied: incubator/airavata/trunk/ws-messaging/messagebox/src/main/resources/msgbox_tables.sql (from r1147203, incubator/airavata/trunk/ws-messaging/messagebox/resources/msgbox_tables.sql)
URL: http://svn.apache.org/viewvc/incubator/airavata/trunk/ws-messaging/messagebox/src/main/resources/msgbox_tables.sql?p2=incubator/airavata/trunk/ws-messaging/messagebox/src/main/resources/msgbox_tables.sql&p1=incubator/airavata/trunk/ws-messaging/messagebox/resources/msgbox_tables.sql&r1=1147203&r2=1147207&rev=1147207&view=diff
==============================================================================
--- incubator/airavata/trunk/ws-messaging/messagebox/resources/msgbox_tables.sql (original)
+++ incubator/airavata/trunk/ws-messaging/messagebox/src/main/resources/msgbox_tables.sql Fri Jul 15 16:03:32 2011
@@ -0,0 +1,41 @@
+##Used for mySQL database
+CREATE TABLE `subscription` (
+ `SubscriptionId` varchar(200) NOT NULL default '',
+ `Topics` varchar(255) default '',
+ `XPath` varchar(200) default '',
+ `ConsumerAddress` varchar(100) default '',
+ `ReferenceProperties` blob,
+ `content` blob,
+ `wsrm` tinyint(1) NOT NULL default '0',
+ `CreationTime` datetime NOT NULL default '0000-00-00 00:00:00'
+ );
+CREATE TABLE `specialSubscription` (
+ `SubscriptionId` varchar(200) NOT NULL default '',
+ `Topics` varchar(255) default '',
+ `XPath` varchar(200) default '',
+ `ConsumerAddress` varchar(100) default '',
+ `ReferenceProperties` blob,
+ `content` blob,
+ `wsrm` tinyint(1) NOT NULL default '0',
+ `CreationTime` datetime NOT NULL default '0000-00-00 00:00:00'
+ );
+
+
+CREATE TABLE `disQ` (
+ `id` bigint(11) NOT NULL auto_increment,
+ `trackId` varchar(100) default NULL,
+ `message` longblob,
+ `status` int(11) default NULL,
+ `topic` varchar(255) default '',
+ PRIMARY KEY (`id`)
+ );
+
+CREATE TABLE MaxIDTable(
+ maxID integer
+ );
+
+CREATE TABLE MinIDTable(
+ minID integer
+ );
+
+