Commit | Line | Data |
---|---|---|
c68a5549 MW |
1 | /* -*-sql-*- |
2 | * | |
3 | * Plain old SQL for setting up the tables for Odin mail redirection. | |
128543b0 MW |
4 | * |
5 | * (c) 2015 Mark Wooding | |
6 | */ | |
7 | ||
8 | /*----- Licensing notice ---------------------------------------------------- | |
9 | * | |
10 | * This file is part of the `odin.gg' service, `odin-cgi'. | |
11 | * | |
12 | * `odin-cgi' is free software; you can redistribute it and/or modify | |
13 | * it under the terms of the GNU Affero General Public License as | |
14 | * published by the Free Software Foundation; either version 3 of the | |
15 | * License, or (at your option) any later version. | |
16 | * | |
17 | * `odin-cgi' is distributed in the hope that it will be useful, | |
18 | * but WITHOUT ANY WARRANTY; without even the implied warranty of | |
19 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | |
20 | * GNU Affero General Public License for more details. | |
21 | * | |
22 | * You should have received a copy of the GNU Affero General Public | |
23 | * License along with `odin-cgi'; if not, see | |
24 | * <http://www.gnu.org/licenses/>. | |
c68a5549 MW |
25 | */ |
26 | ||
27 | begin; | |
28 | alter table odin_mailredir add column creator varchar(64); | |
29 | update odin_mailredir set creator = owner where creator is null; | |
30 | alter table odin_mailredir alter column creator set not null; | |
31 | commit; |