Add the SQL update scripts.

1 files changed, 111 insertions, 0 deletions

diff --git a/sql/groups.sql b/sql/groups.sql
new file mode 100644
index 0000000..1815203
--- /dev/null
+++ b/sql/groups.sql
@@ -0,0 +1,111 @@
+-- 
+-- Table structure for table `osagent`
+-- 
+
+CREATE TABLE `osagent` (
+  `AgentID` char(36) NOT NULL default '',
+  `ActiveGroupID` char(36) NOT NULL default '',
+  PRIMARY KEY  (`AgentID`)
+) ENGINE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `osgroup`
+-- 
+
+CREATE TABLE `osgroup` (
+  `GroupID` char(36) NOT NULL default '',
+  `Name` varchar(255) NOT NULL default '',
+  `Charter` text NOT NULL,
+  `InsigniaID` char(36) NOT NULL default '',
+  `FounderID` char(36) NOT NULL default '',
+  `MembershipFee` int(11) NOT NULL default '0',
+  `OpenEnrollment` varchar(255) NOT NULL default '',
+  `ShowInList` tinyint(1) NOT NULL default '0',
+  `AllowPublish` tinyint(1) NOT NULL default '0',
+  `MaturePublish` tinyint(1) NOT NULL default '0',
+  `OwnerRoleID` char(36) NOT NULL default '',
+  PRIMARY KEY  (`GroupID`),
+  UNIQUE KEY `Name` (`Name`),
+  FULLTEXT KEY `Name_2` (`Name`)
+) ENGINE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `osgroupinvite`
+-- 
+
+CREATE TABLE `osgroupinvite` (
+  `InviteID` char(36) NOT NULL default '',
+  `GroupID` char(36) NOT NULL default '',
+  `RoleID` char(36) NOT NULL default '',
+  `AgentID` char(36) NOT NULL default '',
+  `TMStamp` timestamp NOT NULL,
+  PRIMARY KEY  (`InviteID`),
+  UNIQUE KEY `GroupID` (`GroupID`,`RoleID`,`AgentID`)
+) ENGINE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `osgroupmembership`
+-- 
+
+CREATE TABLE `osgroupmembership` (
+  `GroupID`char(36) NOT NULL default '',
+  `AgentID` char(36) NOT NULL default '',
+  `SelectedRoleID` char(36) NOT NULL default '',
+  `Contribution` int(11) NOT NULL default '0',
+  `ListInProfile` int(11) NOT NULL default '1',
+  `AcceptNotices` int(11) NOT NULL default '1',
+  PRIMARY KEY  (`GroupID`,`AgentID`)
+) ENGINE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `osgroupnotice`
+-- 
+
+CREATE TABLE `osgroupnotice` (
+  `GroupID` char(36) NOT NULL default '',
+  `NoticeID` char(36) NOT NULL default '',
+  `Timestamp` int(10) unsigned NOT NULL default '0',
+  `FromName` varchar(255) NOT NULL default '',
+  `Subject` varchar(255) NOT NULL default '',
+  `Message` text NOT NULL,
+  `BinaryBucket` text NOT NULL,
+  PRIMARY KEY  (`GroupID`,`NoticeID`),
+  KEY `Timestamp` (`Timestamp`)
+) ENGINE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `osgrouprolemembership`
+-- 
+
+CREATE TABLE `osgrouprolemembership` (
+  `GroupID` char(36) NOT NULL default '',
+  `RoleID` char(36) NOT NULL default '',
+  `AgentID` char(36) NOT NULL default '',
+  PRIMARY KEY  (`GroupID`,`RoleID`,`AgentID`)
+) ENGINE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `osrole`
+-- 
+
+CREATE TABLE `osrole` (
+  `GroupID` char(36) NOT NULL default '',
+  `RoleID` char(36) NOT NULL default '',
+  `Name` varchar(255) NOT NULL default '',
+  `Description` varchar(255) NOT NULL default '',
+  `Title` varchar(255) NOT NULL default '',
+  `Powers` bigint(20) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`GroupID`,`RoleID`)
+) ENGINE=MyISAM;