[odin-cgi] / sql / update-mail-v2.sql

/* -*-sql-*-
 *
 * Plain old SQL for setting up the tables for Odin mail redirection.
 */

begin;
alter table odin_mailredir add column creator varchar(64);
update odin_mailredir set creator = owner where creator is null;
alter table odin_mailredir alter column creator set not null;
commit;
Commit	Line	Data
c68a5549 MW	1	/* --sql--
	2	*
	3	* Plain old SQL for setting up the tables for Odin mail redirection.
	4	*/
	5
	6	begin;
	7	alter table odin_mailredir add column creator varchar(64);
	8	update odin_mailredir set creator = owner where creator is null;
	9	alter table odin_mailredir alter column creator set not null;
	10	commit;