airavata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sma...@apache.org
Subject svn commit: r1147207 - in /incubator/airavata/trunk/ws-messaging/messagebox: resources/msgbox_tables.sql src/main/resources/msgbox_tables.sql
Date Fri, 15 Jul 2011 16:03:32 GMT
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
+       );
+
+



Mime
View raw message