clockwerk-opensim-stable – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | vero | 1 | :VERSION 1 # -------------------------- |
2 | |||
3 | BEGIN; |
||
4 | |||
5 | CREATE TABLE `os_groups_groups` ( |
||
6 | `GroupID` char(36) NOT NULL default '', |
||
7 | `Location` varchar(255) NOT NULL default '', |
||
8 | `Name` varchar(255) NOT NULL default '', |
||
9 | `Charter` text NOT NULL, |
||
10 | `InsigniaID` char(36) NOT NULL default '', |
||
11 | `FounderID` char(36) NOT NULL default '', |
||
12 | `MembershipFee` int(11) NOT NULL default '0', |
||
13 | `OpenEnrollment` varchar(255) NOT NULL default '', |
||
14 | `ShowInList` int(4) NOT NULL default '0', |
||
15 | `AllowPublish` int(4) NOT NULL default '0', |
||
16 | `MaturePublish` int(4) NOT NULL default '0', |
||
17 | `OwnerRoleID` char(36) NOT NULL default '', |
||
18 | PRIMARY KEY (`GroupID`), |
||
19 | UNIQUE KEY `Name` (`Name`), |
||
20 | FULLTEXT KEY `Name_2` (`Name`) |
||
21 | ) ENGINE=MyISAM; |
||
22 | |||
23 | |||
24 | CREATE TABLE `os_groups_membership` ( |
||
25 | `GroupID`char(36) NOT NULL default '', |
||
26 | `PrincipalID` VARCHAR(255) NOT NULL default '', |
||
27 | `SelectedRoleID` char(36) NOT NULL default '', |
||
28 | `Contribution` int(11) NOT NULL default '0', |
||
29 | `ListInProfile` int(4) NOT NULL default '1', |
||
30 | `AcceptNotices` int(4) NOT NULL default '1', |
||
31 | `AccessToken` char(36) NOT NULL default '', |
||
32 | PRIMARY KEY (`GroupID`,`PrincipalID`), |
||
33 | KEY `PrincipalID` (`PrincipalID`) |
||
34 | ) ENGINE=MyISAM; |
||
35 | |||
36 | |||
37 | CREATE TABLE `os_groups_roles` ( |
||
38 | `GroupID` char(36) NOT NULL default '', |
||
39 | `RoleID` char(36) NOT NULL default '', |
||
40 | `Name` varchar(255) NOT NULL default '', |
||
41 | `Description` varchar(255) NOT NULL default '', |
||
42 | `Title` varchar(255) NOT NULL default '', |
||
43 | `Powers` bigint(20) unsigned NOT NULL default '0', |
||
44 | PRIMARY KEY (`GroupID`,`RoleID`), |
||
45 | KEY `GroupID` (`GroupID`) |
||
46 | ) ENGINE=MyISAM; |
||
47 | |||
48 | |||
49 | CREATE TABLE `os_groups_rolemembership` ( |
||
50 | `GroupID` char(36) NOT NULL default '', |
||
51 | `RoleID` char(36) NOT NULL default '', |
||
52 | `PrincipalID` VARCHAR(255) NOT NULL default '', |
||
53 | PRIMARY KEY (`GroupID`,`RoleID`,`PrincipalID`), |
||
54 | KEY `PrincipalID` (`PrincipalID`) |
||
55 | ) ENGINE=MyISAM; |
||
56 | |||
57 | |||
58 | CREATE TABLE `os_groups_invites` ( |
||
59 | `InviteID` char(36) NOT NULL default '', |
||
60 | `GroupID` char(36) NOT NULL default '', |
||
61 | `RoleID` char(36) NOT NULL default '', |
||
62 | `PrincipalID` VARCHAR(255) NOT NULL default '', |
||
63 | `TMStamp` timestamp NOT NULL, |
||
64 | PRIMARY KEY (`InviteID`), |
||
65 | UNIQUE KEY `PrincipalGroup` (`GroupID`,`PrincipalID`) |
||
66 | ) ENGINE=MyISAM; |
||
67 | |||
68 | |||
69 | CREATE TABLE `os_groups_notices` ( |
||
70 | `GroupID` char(36) NOT NULL default '', |
||
71 | `NoticeID` char(36) NOT NULL default '', |
||
72 | `TMStamp` int(10) unsigned NOT NULL default '0', |
||
73 | `FromName` varchar(255) NOT NULL default '', |
||
74 | `Subject` varchar(255) NOT NULL default '', |
||
75 | `Message` text NOT NULL, |
||
76 | `HasAttachment` int(4) NOT NULL default '0', |
||
77 | `AttachmentType` int(4) NOT NULL default '0', |
||
78 | `AttachmentName` varchar(128) NOT NULL default '', |
||
79 | `AttachmentItemID` char(36) NOT NULL default '', |
||
80 | `AttachmentOwnerID` varchar(255) NOT NULL default '', |
||
81 | PRIMARY KEY (`NoticeID`), |
||
82 | KEY `GroupID` (`GroupID`), |
||
83 | KEY `TMStamp` (`TMStamp`) |
||
84 | ) ENGINE=MyISAM; |
||
85 | |||
86 | CREATE TABLE `os_groups_principals` ( |
||
87 | `PrincipalID` VARCHAR(255) NOT NULL default '', |
||
88 | `ActiveGroupID` char(36) NOT NULL default '', |
||
89 | PRIMARY KEY (`PrincipalID`) |
||
90 | ) ENGINE=MyISAM; |
||
91 | |||
92 | COMMIT; |
||
93 | |||
94 | :VERSION 2 # -------------------------- |
||
95 | |||
96 | BEGIN; |
||
97 | |||
98 | INSERT INTO `os_groups_groups` SELECT * from `diva_groups_groups`; |
||
99 | DROP TABLE `diva_groups_groups`; |
||
100 | INSERT INTO `os_groups_membership` SELECT * from `diva_groups_membership`; |
||
101 | DROP TABLE `diva_groups_membership`; |
||
102 | INSERT INTO `os_groups_roles` SELECT * from `diva_groups_roles`; |
||
103 | DROP TABLE `diva_groups_roles`; |
||
104 | INSERT INTO `os_groups_rolemembership` SELECT * from `diva_groups_rolemembership`; |
||
105 | DROP TABLE `diva_groups_rolemembership`; |
||
106 | INSERT INTO `os_groups_invites` SELECT * from `diva_groups_invites`; |
||
107 | DROP TABLE `diva_groups_invites`; |
||
108 | INSERT INTO `os_groups_notices` SELECT * from `diva_groups_notices`; |
||
109 | DROP TABLE `diva_groups_notices`; |
||
110 | INSERT INTO `os_groups_principals` SELECT * from `diva_groups_principals`; |
||
111 | DROP TABLE `diva_groups_principals`; |
||
112 | |||
113 | DELETE FROM `migrations` WHERE name='diva_im_Store'; |
||
114 | |||
115 | COMMIT; |