clockwerk-www – Blame information for rev
?pathlinks?
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; |