| 1 |
-- Run the this script on your Spam Board database to upgrade it from version 5.0 to 5.1. |
|---|
| 2 |
-- For obvious reasons, doing a backup first is strongly recommended. |
|---|
| 3 |
-- |
|---|
| 4 |
-- In addition, you have to replace the script files on the webserver, of course. |
|---|
| 5 |
-- Make sure you add the new variables from settings.tmpl to your settings.php as well. |
|---|
| 6 |
|
|---|
| 7 |
ALTER TABLE sb_members ADD attachments INTEGER NOT NULL DEFAULT 0; |
|---|
| 8 |
ALTER TABLE sb_members ADD timezone VARCHAR(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL; |
|---|
| 9 |
ALTER TABLE sb_members ADD encoffset INTEGER NULL; |
|---|
| 10 |
|
|---|
| 11 |
UPDATE sb_members SET encoffset = offset; |
|---|
| 12 |
|
|---|
| 13 |
INSERT INTO sb_rights VALUES('Newposts',1,1,1); |
|---|
| 14 |
INSERT INTO sb_rights VALUES('Newposts',2,1,1); |
|---|
| 15 |
INSERT INTO sb_rights VALUES('Newposts',3,1,1); |
|---|
| 16 |
INSERT INTO sb_rights VALUES('Newposts',4,1,1); |
|---|
| 17 |
INSERT INTO sb_rights VALUES('Newposts',5,0,0); |
|---|
| 18 |
INSERT INTO sb_rights_default VALUES('Newposts',1,1,1); |
|---|
| 19 |
INSERT INTO sb_rights_default VALUES('Newposts',2,1,1); |
|---|
| 20 |
INSERT INTO sb_rights_default VALUES('Newposts',3,1,1); |
|---|
| 21 |
INSERT INTO sb_rights_default VALUES('Newposts',4,1,1); |
|---|
| 22 |
INSERT INTO sb_rights_default VALUES('Newposts',5,0,0); |
|---|
| 23 |
|
|---|
| 24 |
INSERT INTO sb_rights VALUES('Who_is_online',1,1,1); |
|---|
| 25 |
INSERT INTO sb_rights VALUES('Who_is_online',2,1,1); |
|---|
| 26 |
INSERT INTO sb_rights VALUES('Who_is_online',3,1,1); |
|---|
| 27 |
INSERT INTO sb_rights VALUES('Who_is_online',4,1,1); |
|---|
| 28 |
INSERT INTO sb_rights VALUES('Who_is_online',5,0,0); |
|---|
| 29 |
INSERT INTO sb_rights_default VALUES('Who_is_online',1,1,1); |
|---|
| 30 |
INSERT INTO sb_rights_default VALUES('Who_is_online',2,1,1); |
|---|
| 31 |
INSERT INTO sb_rights_default VALUES('Who_is_online',3,1,1); |
|---|
| 32 |
INSERT INTO sb_rights_default VALUES('Who_is_online',4,1,1); |
|---|
| 33 |
INSERT INTO sb_rights_default VALUES('Who_is_online',5,0,0); |
|---|
| 34 |
|
|---|
| 35 |
INSERT INTO sb_rights VALUES('Edit_Poll',5,0,0); |
|---|
| 36 |
INSERT INTO sb_rights VALUES('Edit_Poll',4,0,0); |
|---|
| 37 |
INSERT INTO sb_rights VALUES('Edit_Poll',3,0,0); |
|---|
| 38 |
INSERT INTO sb_rights VALUES('Edit_Poll',2,1,1); |
|---|
| 39 |
INSERT INTO sb_rights VALUES('Edit_Poll',1,1,1); |
|---|
| 40 |
INSERT INTO sb_rights VALUES('Delete_Poll',5,0,0); |
|---|
| 41 |
INSERT INTO sb_rights VALUES('Delete_Poll',4,0,0); |
|---|
| 42 |
INSERT INTO sb_rights VALUES('Delete_Poll',3,0,0); |
|---|
| 43 |
INSERT INTO sb_rights VALUES('Delete_Poll',2,1,1); |
|---|
| 44 |
INSERT INTO sb_rights VALUES('Delete_Poll',1,1,1); |
|---|
| 45 |
INSERT INTO sb_rights_default VALUES('Edit_Poll',5,0,0); |
|---|
| 46 |
INSERT INTO sb_rights_default VALUES('Edit_Poll',4,0,0); |
|---|
| 47 |
INSERT INTO sb_rights_default VALUES('Edit_Poll',3,0,0); |
|---|
| 48 |
INSERT INTO sb_rights_default VALUES('Edit_Poll',2,1,1); |
|---|
| 49 |
INSERT INTO sb_rights_default VALUES('Edit_Poll',1,1,1); |
|---|
| 50 |
INSERT INTO sb_rights_default VALUES('Delete_Poll',5,0,0); |
|---|
| 51 |
INSERT INTO sb_rights_default VALUES('Delete_Poll',4,0,0); |
|---|
| 52 |
INSERT INTO sb_rights_default VALUES('Delete_Poll',3,0,0); |
|---|
| 53 |
INSERT INTO sb_rights_default VALUES('Delete_Poll',2,1,1); |
|---|
| 54 |
INSERT INTO sb_rights_default VALUES('Delete_Poll',1,1,1); |
|---|
| 55 |
|
|---|
| 56 |
INSERT INTO sb_rights VALUES('Deleteattachment',1,1,1); |
|---|
| 57 |
INSERT INTO sb_rights VALUES('Deleteattachment',2,1,1); |
|---|
| 58 |
INSERT INTO sb_rights VALUES('Deleteattachment',3,0,0); |
|---|
| 59 |
INSERT INTO sb_rights VALUES('Deleteattachment',4,0,0); |
|---|
| 60 |
INSERT INTO sb_rights VALUES('Deleteattachment',5,0,0); |
|---|
| 61 |
INSERT INTO sb_rights_default VALUES('Deleteattachment',1,1,1); |
|---|
| 62 |
INSERT INTO sb_rights_default VALUES('Deleteattachment',2,1,1); |
|---|
| 63 |
INSERT INTO sb_rights_default VALUES('Deleteattachment',3,0,0); |
|---|
| 64 |
INSERT INTO sb_rights_default VALUES('Deleteattachment',4,0,0); |
|---|
| 65 |
INSERT INTO sb_rights_default VALUES('Deleteattachment',5,0,0); |
|---|
