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:19:05 UTC
svn commit: r1147215 - in /incubator/airavata/trunk/ws-messaging/messagebroker/src/main/resources/database_scripts: msgBroker-mysql.sql mysqlCreationScript.sql

Author: smarru
Date: Fri Jul 15 16:19:05 2011
New Revision: 1147215

URL: http://svn.apache.org/viewvc?rev=1147215&view=rev
Log:
adding messagebroker mysql script to database_script directory. 

Added:
    incubator/airavata/trunk/ws-messaging/messagebroker/src/main/resources/database_scripts/msgBroker-mysql.sql
      - copied, changed from r1147208, incubator/airavata/trunk/ws-messaging/messagebroker/src/main/resources/database_scripts/mysqlCreationScript.sql
Removed:
    incubator/airavata/trunk/ws-messaging/messagebroker/src/main/resources/database_scripts/mysqlCreationScript.sql

Copied: incubator/airavata/trunk/ws-messaging/messagebroker/src/main/resources/database_scripts/msgBroker-mysql.sql (from r1147208, incubator/airavata/trunk/ws-messaging/messagebroker/src/main/resources/database_scripts/mysqlCreationScript.sql)
URL: http://svn.apache.org/viewvc/incubator/airavata/trunk/ws-messaging/messagebroker/src/main/resources/database_scripts/msgBroker-mysql.sql?p2=incubator/airavata/trunk/ws-messaging/messagebroker/src/main/resources/database_scripts/msgBroker-mysql.sql&p1=incubator/airavata/trunk/ws-messaging/messagebroker/src/main/resources/database_scripts/mysqlCreationScript.sql&r1=1147208&r2=1147215&rev=1147215&view=diff
==============================================================================
--- incubator/airavata/trunk/ws-messaging/messagebroker/src/main/resources/database_scripts/mysqlCreationScript.sql (original)
+++ incubator/airavata/trunk/ws-messaging/messagebroker/src/main/resources/database_scripts/msgBroker-mysql.sql Fri Jul 15 16:19:05 2011
@@ -0,0 +1,40 @@
+##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
+       );
+