--- db/upgrade_17.py | 33 +++++++++++++++++++++++++++++++++ 1 file changed, 33 insertions(+) create mode 100644 db/upgrade_17.py
diff --git a/db/upgrade_17.py b/db/upgrade_17.py new file mode 100644 index 0000000..71c6a92 --- /dev/null +++ b/db/upgrade_17.py @@ -0,0 +1,33 @@ +#!/usr/bin/python +# +# Copyright (c) 2009 Peter Palfrader +# +# Permission is hereby granted, free of charge, to any person obtaining a copy +# of this software and associated documentation files (the "Software"), to deal +# in the Software without restriction, including without limitation the rights +# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell +# copies of the Software, and to permit persons to whom the Software is +# furnished to do so, subject to the following conditions: +# +# The above copyright notice and this permission notice shall be included in +# all copies or substantial portions of the Software. +# +# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR +# IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, +# FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE +# AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER +# LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, +# OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE +# SOFTWARE. + +def upgrade(db): + """We have now files >= 2gb in the archive: adapt dirtree_result also.""" + db.execute(""" + ALTER TYPE dirtree_result ALTER ATTRIBUTE size TYPE BIGINT; + """) + + db.execute("UPDATE config SET value='17' WHERE name='db_revision' AND value='16'") + +# vim:set et: +# vim:set ts=4: +# vim:set shiftwidth=4: -- 2.1.4