root/branches/5.2/upgrade.sql

Revision 352, 4.9 kB (checked in by hannes, 3 years ago)

merging changeset [351] (Jabber) from trunk

Line 
1 -- Run the this script on your Spam Board database to upgrade it from version 5.1 to 5.2.
2 -- For obvious reasons, doing a backup first is strongly recommended.
3 --
4 -- This script assumes there are no custom user groups (i.e. group ID 6 is free and will
5 -- taken by the new group) and that the table prefix is sb_. Modify as required!
6 --
7 -- In addition, you have to replace the script files on the webserver, of course.
8
9 ALTER TABLE sb_usergroups ADD COLUMN status INTEGER NOT NULL DEFAULT 0;
10 INSERT INTO sb_usergroups (name, public, status) VALUES ('Group Leader', 0, 4);
11 UPDATE sb_usergroups SET status = 1 WHERE name = 'Admin';
12 UPDATE sb_usergroups SET status = 2 WHERE name = 'Global Moderator';
13 UPDATE sb_usergroups SET status = 3 WHERE name = 'Moderator';
14 UPDATE sb_usergroups SET status = 5 WHERE name = 'Member';
15 UPDATE sb_usergroups SET status = 6 WHERE name = 'Guest';
16
17 ALTER TABLE sb_members ADD COLUMN banned INTEGER NOT NULL DEFAULT 0;
18 UPDATE sb_members SET banned = 1 WHERE memberstatus = 'Banned';
19 DROP INDEX idx_members_memberstatus;
20 ALTER TABLE sb_members DROP COLUMN memberstatus;
21
22 ALTER TABLE sb_members ADD COLUMN jabber VARCHAR(255) NULL;
23
24 CREATE TABLE sb_groupleaders (
25   usergroup INTEGER NOT NULL,
26   leader INTEGER NOT NULL
27 );
28
29 CREATE TABLE sb_adminlog (
30   member INTEGER NOT NULL,
31   ts DATETIME NOT NULL,
32   input_vars TEXT NOT NULL
33 );
34
35 INSERT INTO sb_rights VALUES('Profile',6,1,0);
36 INSERT INTO sb_rights VALUES('Lostpassword',6,1,1);
37 INSERT INTO sb_rights VALUES('Login',6,1,1);
38 INSERT INTO sb_rights VALUES('Calendar',6,1,1);
39 INSERT INTO sb_rights VALUES('Register',6,1,1);
40 INSERT INTO sb_rights VALUES('Members',6,1,0);
41 INSERT INTO sb_rights VALUES('Search',6,1,1);
42 INSERT INTO sb_rights VALUES('Mail',6,1,1);
43 INSERT INTO sb_rights VALUES('Attachments',6,1,1);
44 INSERT INTO sb_rights VALUES('Markasread',6,1,1);
45 INSERT INTO sb_rights VALUES('Rules',6,1,1);
46 INSERT INTO sb_rights VALUES('Help',6,1,1);
47 INSERT INTO sb_rights VALUES('Pollvote',6,1,1);
48 INSERT INTO sb_rights VALUES('Showip',6,0,0);
49 INSERT INTO sb_rights VALUES('Messenger',6,1,1);
50 INSERT INTO sb_rights VALUES('Postinghelp',6,1,1);
51 INSERT INTO sb_rights VALUES('Preview',6,1,1);
52 INSERT INTO sb_rights VALUES('Edit_Title',6,0,0);
53 INSERT INTO sb_rights VALUES('Lock',6,0,0);
54 INSERT INTO sb_rights VALUES('Unlock',6,0,0);
55 INSERT INTO sb_rights VALUES('Delete_Topic',6,0,0);
56 INSERT INTO sb_rights VALUES('Pin',6,0,0);
57 INSERT INTO sb_rights VALUES('Unpin',6,0,0);
58 INSERT INTO sb_rights VALUES('Move',6,0,0);
59 INSERT INTO sb_rights VALUES('Merge',6,0,0);
60 INSERT INTO sb_rights VALUES('Split',6,0,0);
61 INSERT INTO sb_rights VALUES('Edit_Poll',6,0,0);
62 INSERT INTO sb_rights VALUES('Delete_Poll',6,0,0);
63 INSERT INTO sb_rights VALUES('Delete',6,0,0);
64 INSERT INTO sb_rights VALUES('Deleteattachment',6,0,0);
65 INSERT INTO sb_rights VALUES('Edit',6,0,0);
66 INSERT INTO sb_rights VALUES('Uploadavatar',6,1,1);
67 INSERT INTO sb_rights VALUES('Userpanel',6,1,1);
68 INSERT INTO sb_rights VALUES('Newposts',6,1,1);
69 INSERT INTO sb_rights VALUES('Who_is_online',6,1,1);
70
71 INSERT INTO sb_rights_default VALUES('Profile',6,1,0);
72 INSERT INTO sb_rights_default VALUES('Lostpassword',6,1,1);
73 INSERT INTO sb_rights_default VALUES('Login',6,1,1);
74 INSERT INTO sb_rights_default VALUES('Calendar',6,1,1);
75 INSERT INTO sb_rights_default VALUES('Register',6,1,1);
76 INSERT INTO sb_rights_default VALUES('Members',6,1,0);
77 INSERT INTO sb_rights_default VALUES('Search',6,1,1);
78 INSERT INTO sb_rights_default VALUES('Mail',6,1,1);
79 INSERT INTO sb_rights_default VALUES('Attachments',6,1,1);
80 INSERT INTO sb_rights_default VALUES('Markasread',6,1,1);
81 INSERT INTO sb_rights_default VALUES('Rules',6,1,1);
82 INSERT INTO sb_rights_default VALUES('Help',6,1,1);
83 INSERT INTO sb_rights_default VALUES('Pollvote',6,1,1);
84 INSERT INTO sb_rights_default VALUES('Showip',6,0,0);
85 INSERT INTO sb_rights_default VALUES('Messenger',6,1,1);
86 INSERT INTO sb_rights_default VALUES('Postinghelp',6,1,1);
87 INSERT INTO sb_rights_default VALUES('Preview',6,1,1);
88 INSERT INTO sb_rights_default VALUES('Edit_Title',6,0,0);
89 INSERT INTO sb_rights_default VALUES('Lock',6,0,0);
90 INSERT INTO sb_rights_default VALUES('Unlock',6,0,0);
91 INSERT INTO sb_rights_default VALUES('Delete_Topic',6,0,0);
92 INSERT INTO sb_rights_default VALUES('Pin',6,0,0);
93 INSERT INTO sb_rights_default VALUES('Unpin',6,0,0);
94 INSERT INTO sb_rights_default VALUES('Move',6,0,0);
95 INSERT INTO sb_rights_default VALUES('Merge',6,0,0);
96 INSERT INTO sb_rights_default VALUES('Split',6,0,0);
97 INSERT INTO sb_rights_default VALUES('Edit_Poll',6,0,0);
98 INSERT INTO sb_rights_default VALUES('Delete_Poll',6,0,0);
99 INSERT INTO sb_rights_default VALUES('Delete',6,0,0);
100 INSERT INTO sb_rights_default VALUES('Deleteattachment',6,0,0);
101 INSERT INTO sb_rights_default VALUES('Edit',6,0,0);
102 INSERT INTO sb_rights_default VALUES('Uploadavatar',6,1,1);
103 INSERT INTO sb_rights_default VALUES('Userpanel',6,1,1);
104 INSERT INTO sb_rights_default VALUES('Newposts',6,1,1);
105 INSERT INTO sb_rights_default VALUES('Who_is_online',6,1,1);
Note: See TracBrowser for help on using the browser.