Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Newer
Older
100644 14 lines (9 sloc) 0.365 kB
8e98696 Initial checkin of old 6.0 pastebin code.
Christian Höltje authored
1 Upgrading Pastebin
2 ------------------
3
4 v0.4x to 0.5
5 ------------
6
7 The database has some extra columns, add and initialise them as follows:
8
9 ALTER TABLE pastebin
10 ADD COLUMN expires DATETIME,
11 ADD COLUMN expiry_flag ENUM('d','m', 'f') NOT NULL DEFAULT 'm';
12
13 UPDATE pastebin SET expires=DATE_ADD(posted, INTERVAL 1 MONTH) where expires is null and expiry_flag='m';
Something went wrong with that request. Please try again.