clockwerk-www – Blame information for rev 5

Subversion Repositories:
Rev:
Rev Author Line No. Line
5 vero 1 -- phpMyAdmin SQL Dump
2 -- version 2.6.4-pl3
3 -- http://www.phpmyadmin.net
4 --
5 -- Host: db819.perfora.net
6 -- Generation Time: Apr 18, 2009 at 05:56 PM
7 -- Server version: 4.0.27
8 -- PHP Version: 4.3.10-200.schlund.1
9 --
10 -- Database: `db281670270`
11 --
12  
13 -- --------------------------------------------------------
14  
15 --
16 -- Table structure for table `osagent`
17 --
18  
19 CREATE TABLE `osagent` (
20 `AgentID` varchar(128) NOT NULL default '',
21 `ActiveGroupID` varchar(128) NOT NULL default '',
22 PRIMARY KEY (`AgentID`)
23 ) TYPE=MyISAM;
24  
25 -- --------------------------------------------------------
26  
27 --
28 -- Table structure for table `osgroup`
29 --
30  
31 CREATE TABLE `osgroup` (
32 `GroupID` varchar(128) NOT NULL default '',
33 `Name` varchar(255) NOT NULL default '',
34 `Charter` text NOT NULL,
35 `InsigniaID` varchar(128) NOT NULL default '',
36 `FounderID` varchar(128) NOT NULL default '',
37 `MembershipFee` int(11) NOT NULL default '0',
38 `OpenEnrollment` varchar(255) NOT NULL default '',
39 `ShowInList` tinyint(1) NOT NULL default '0',
40 `AllowPublish` tinyint(1) NOT NULL default '0',
41 `MaturePublish` tinyint(1) NOT NULL default '0',
42 `OwnerRoleID` varchar(128) NOT NULL default '',
43 PRIMARY KEY (`GroupID`),
44 UNIQUE KEY `Name` (`Name`),
45 FULLTEXT KEY `Name_2` (`Name`)
46 ) TYPE=MyISAM;
47  
48 -- --------------------------------------------------------
49  
50 --
51 -- Table structure for table `osgroupinvite`
52 --
53  
54 CREATE TABLE `osgroupinvite` (
55 `InviteID` varchar(128) NOT NULL default '',
56 `GroupID` varchar(128) NOT NULL default '',
57 `RoleID` varchar(128) NOT NULL default '',
58 `AgentID` varchar(128) NOT NULL default '',
59 `TMStamp` timestamp(14) NOT NULL,
60 PRIMARY KEY (`InviteID`),
61 UNIQUE KEY `GroupID` (`GroupID`,`RoleID`,`AgentID`)
62 ) TYPE=MyISAM;
63  
64 -- --------------------------------------------------------
65  
66 --
67 -- Table structure for table `osgroupmembership`
68 --
69  
70 CREATE TABLE `osgroupmembership` (
71 `GroupID` varchar(128) NOT NULL default '',
72 `AgentID` varchar(128) NOT NULL default '',
73 `SelectedRoleID` varchar(128) NOT NULL default '',
74 `Contribution` int(11) NOT NULL default '0',
75 `ListInProfile` int(11) NOT NULL default '1',
76 `AcceptNotices` int(11) NOT NULL default '1',
77 PRIMARY KEY (`GroupID`,`AgentID`)
78 ) TYPE=MyISAM;
79  
80 -- --------------------------------------------------------
81  
82 --
83 -- Table structure for table `osgroupnotice`
84 --
85  
86 CREATE TABLE `osgroupnotice` (
87 `GroupID` varchar(128) NOT NULL default '',
88 `NoticeID` varchar(128) NOT NULL default '',
89 `Timestamp` int(10) unsigned NOT NULL default '0',
90 `FromName` varchar(255) NOT NULL default '',
91 `Subject` varchar(255) NOT NULL default '',
92 `Message` text NOT NULL,
93 `BinaryBucket` text NOT NULL,
94 PRIMARY KEY (`GroupID`,`NoticeID`),
95 KEY `Timestamp` (`Timestamp`)
96 ) TYPE=MyISAM;
97  
98 -- --------------------------------------------------------
99  
100 --
101 -- Table structure for table `osgrouprolemembership`
102 --
103  
104 CREATE TABLE `osgrouprolemembership` (
105 `GroupID` varchar(128) NOT NULL default '',
106 `RoleID` varchar(128) NOT NULL default '',
107 `AgentID` varchar(128) NOT NULL default '',
108 PRIMARY KEY (`GroupID`,`RoleID`,`AgentID`)
109 ) TYPE=MyISAM;
110  
111 -- --------------------------------------------------------
112  
113 --
114 -- Table structure for table `osrole`
115 --
116  
117 CREATE TABLE `osrole` (
118 `GroupID` varchar(128) NOT NULL default '',
119 `RoleID` varchar(128) NOT NULL default '',
120 `Name` varchar(255) NOT NULL default '',
121 `Description` varchar(255) NOT NULL default '',
122 `Title` varchar(255) NOT NULL default '',
123 `Powers` bigint(20) unsigned NOT NULL default '0',
124 PRIMARY KEY (`GroupID`,`RoleID`)
125 ) TYPE=MyISAM;