aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/sql/groups.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/groups.sql')
-rw-r--r--sql/groups.sql111
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 @@
1--
2-- Table structure for table `osagent`
3--
4
5CREATE TABLE `osagent` (
6 `AgentID` char(36) NOT NULL default '',
7 `ActiveGroupID` char(36) NOT NULL default '',
8 PRIMARY KEY (`AgentID`)
9) ENGINE=MyISAM;
10
11-- --------------------------------------------------------
12
13--
14-- Table structure for table `osgroup`
15--
16
17CREATE TABLE `osgroup` (
18 `GroupID` char(36) NOT NULL default '',
19 `Name` varchar(255) NOT NULL default '',
20 `Charter` text NOT NULL,
21 `InsigniaID` char(36) NOT NULL default '',
22 `FounderID` char(36) NOT NULL default '',
23 `MembershipFee` int(11) NOT NULL default '0',
24 `OpenEnrollment` varchar(255) NOT NULL default '',
25 `ShowInList` tinyint(1) NOT NULL default '0',
26 `AllowPublish` tinyint(1) NOT NULL default '0',
27 `MaturePublish` tinyint(1) NOT NULL default '0',
28 `OwnerRoleID` char(36) NOT NULL default '',
29 PRIMARY KEY (`GroupID`),
30 UNIQUE KEY `Name` (`Name`),
31 FULLTEXT KEY `Name_2` (`Name`)
32) ENGINE=MyISAM;
33
34-- --------------------------------------------------------
35
36--
37-- Table structure for table `osgroupinvite`
38--
39
40CREATE TABLE `osgroupinvite` (
41 `InviteID` char(36) NOT NULL default '',
42 `GroupID` char(36) NOT NULL default '',
43 `RoleID` char(36) NOT NULL default '',
44 `AgentID` char(36) NOT NULL default '',
45 `TMStamp` timestamp NOT NULL,
46 PRIMARY KEY (`InviteID`),
47 UNIQUE KEY `GroupID` (`GroupID`,`RoleID`,`AgentID`)
48) ENGINE=MyISAM;
49
50-- --------------------------------------------------------
51
52--
53-- Table structure for table `osgroupmembership`
54--
55
56CREATE TABLE `osgroupmembership` (
57 `GroupID`char(36) NOT NULL default '',
58 `AgentID` char(36) NOT NULL default '',
59 `SelectedRoleID` char(36) NOT NULL default '',
60 `Contribution` int(11) NOT NULL default '0',
61 `ListInProfile` int(11) NOT NULL default '1',
62 `AcceptNotices` int(11) NOT NULL default '1',
63 PRIMARY KEY (`GroupID`,`AgentID`)
64) ENGINE=MyISAM;
65
66-- --------------------------------------------------------
67
68--
69-- Table structure for table `osgroupnotice`
70--
71
72CREATE TABLE `osgroupnotice` (
73 `GroupID` char(36) NOT NULL default '',
74 `NoticeID` char(36) NOT NULL default '',
75 `Timestamp` int(10) unsigned NOT NULL default '0',
76 `FromName` varchar(255) NOT NULL default '',
77 `Subject` varchar(255) NOT NULL default '',
78 `Message` text NOT NULL,
79 `BinaryBucket` text NOT NULL,
80 PRIMARY KEY (`GroupID`,`NoticeID`),
81 KEY `Timestamp` (`Timestamp`)
82) ENGINE=MyISAM;
83
84-- --------------------------------------------------------
85
86--
87-- Table structure for table `osgrouprolemembership`
88--
89
90CREATE TABLE `osgrouprolemembership` (
91 `GroupID` char(36) NOT NULL default '',
92 `RoleID` char(36) NOT NULL default '',
93 `AgentID` char(36) NOT NULL default '',
94 PRIMARY KEY (`GroupID`,`RoleID`,`AgentID`)
95) ENGINE=MyISAM;
96
97-- --------------------------------------------------------
98
99--
100-- Table structure for table `osrole`
101--
102
103CREATE TABLE `osrole` (
104 `GroupID` char(36) NOT NULL default '',
105 `RoleID` char(36) NOT NULL default '',
106 `Name` varchar(255) NOT NULL default '',
107 `Description` varchar(255) NOT NULL default '',
108 `Title` varchar(255) NOT NULL default '',
109 `Powers` bigint(20) unsigned NOT NULL default '0',
110 PRIMARY KEY (`GroupID`,`RoleID`)
111) ENGINE=MyISAM;