dnl Copyright (C) 2012 The Meme Factory, Inc., http://www.meme.com/
dnl
dnl    This file is part of Gombe-MI.
dnl
dnl    Gombe-MI is free software; you can redistribute it and/or modify
dnl    it under the terms of the GNU General Public License as published by
dnl    the Free Software Foundation; either version 3 of the License, or
dnl    (at your option) any later version.
dnl
dnl    This program is distributed in the hope that it will be useful,
dnl    but WITHOUT ANY WARRANTY; without even the implied warranty of
dnl    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
dnl    GNU General Public License for more details.
dnl
dnl    You should have received a copy of the GNU General Public License
dnl    along with Gombe-MI.  If not, see <http://www.gnu.org/licenses/>.
dnl
dnl Karl O. Pinc <kop@meme.com>
dnl
dnl m4 includes.
include(`copyright.m4')
include(`constants.m4')

dnl The defaults for views.
dnl
dnl This exists so that SERIAL columns that are exposed in views
dnl are indeed SERIAL.

-- -- foo
-- SELECT 'foo';
-- ALTER TABLE foo
--   ALTER COLUMN fooid
--     SET DEFAULT nextval('foo_fooid_seq'::regclass);

-- biography
SELECT 'biography';
ALTER TABLE biography
  ALTER COLUMN import_datetime
    SET DEFAULT LOCALTIMESTAMP(0);