Merge lp:~credativ/openupgrade-addons/7.0 into lp:openupgrade-addons

[Stefan Rijnhart (Opener)]

Please do not merge. This merge proposal is just for reference purposes. This work has been abandoned by its owner, but he offered to share it nevertheless. See https://lists.launchpad.net/openupgrade-drivers/msg00156.html

See also the server part at https://code.launchpad.net/~credativ/openupgrade-server/7.0/+merge/170414

If you are preparing parts of this code for merging into the project series, do not forget to attribute the author and copyright holder.

Unmerged revisions

8140. By mistotebe on 2013-06-19

[IMP] Initial implementation for sale_crm module migration.

8139. By mistotebe on 2013-06-19

[IMP] Initial implementation for event module migration.

8138. By mistotebe on 2013-06-19

[IMP] Initial implementation for project_issue module migration.

8137. By mistotebe on 2013-06-19

[IMP] Initial implementation for delivery module migration.

8136. By mistotebe on 2013-06-19

[IMP] Initial implementation for sale module migration.

8135. By mistotebe on 2013-06-19

[IMP] Initial implementation for hr_holidays module migration.

8134. By mistotebe on 2013-06-19

[IMP] Initial implementation for stock module migration.

8133. By mistotebe on 2013-06-19

[IMP] Initial implementation for crm module migration.

8132. By mistotebe on 2013-06-19

[IMP] Initial implementation for project module migration.

8131. By mistotebe on 2013-06-19

[IMP] Initial implementation for hr module migration.

=== added file 'analytic/migrations/7.0.1.1/post-migration.py'
--- analytic/migrations/7.0.1.1/post-migration.py	1970-01-01 00:00:00 +0000
+++ analytic/migrations/7.0.1.1/post-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,37 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+import pooler
+
+_defaults = {
+    # False results in column value NULL
+    # None value triggers a call to the model's default function
+    'account.analytic.account' : [
+        ('type', 'normal'),
+        ],
+    }
+
[e-mail]()
+def migrate(cr, version):
+    pool = pooler.get_pool(cr.dbname)
+    openupgrade.set_defaults(cr, pool, _defaults)
+    #TODO: move contact_id to manager_id?

=== added file 'base_calendar/migrations/7.0.1.0/post-migration.py'
--- base_calendar/migrations/7.0.1.0/post-migration.py	1970-01-01 00:00:00 +0000
+++ base_calendar/migrations/7.0.1.0/post-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,27 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openupgrade import openupgrade
+from openupgrade.openupgrade70 import partner_address_to_partner
+
[e-mail]()
+def migrate(cr, version):
+    partner_address_to_partner(cr, 'calendar_attendee', 'partner_id')

=== added file 'base_calendar/migrations/7.0.1.0/pre-migration.py'
--- base_calendar/migrations/7.0.1.0/pre-migration.py	1970-01-01 00:00:00 +0000
+++ base_calendar/migrations/7.0.1.0/pre-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,42 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+import logging
+
+renames = {
+    'calendar_attendee': [
+        ('partner_address_id', 'partner_id'),
+        ],
+    'calendar_event': [
+        ('recurrent_id', 'recurrent_id_date'),
+        ('recurrent_uid', 'recurrent_id'),
+        ],
+    'calendar_todo': [
+        ('recurrent_id', 'recurrent_id_date'),
+        ('recurrent_uid', 'recurrent_id'),
+        ],
+    }
+
+
[e-mail]()
+def migrate(cr, version):
+    openupgrade.rename_columns(cr, renames)

=== added file 'crm/migrations/7.0.1.0/post-migration.py'
--- crm/migrations/7.0.1.0/post-migration.py	1970-01-01 00:00:00 +0000
+++ crm/migrations/7.0.1.0/post-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,39 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
+_defaults = {
+    # False results in column value NULL
+    # None value triggers a call to the model's default function
+    'crm.case.stage': [
+        ('state', 'open'),
+        ('type', 'both'),
+        ],
+    }
+
[e-mail]()
+def migrate(cr, version):
+    pool = pooler.get_pool(cr.dbname)
+    openupgrade.set_defaults(cr, pool, _defaults)
+
+    model = pool.get('res.partner')
+    many2one2many2many(cr, model, 'res_partner', 'meeting_ids')

=== added file 'crm/migrations/7.0.1.0/pre-migration.py'
--- crm/migrations/7.0.1.0/pre-migration.py	1970-01-01 00:00:00 +0000
+++ crm/migrations/7.0.1.0/pre-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,33 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
[e-mail]()
+def migrate(cr, version):
+    openupgrade.rename_columns(cr, {
+        'crm_lead': [
+            ('optout', 'opt_out'),
+            ],
+        'res.partner': [
+            ('meeting_ids', openupgrade.get_legacy_name('meeting_ids')),
+            ],
+        })

=== added file 'delivery/migrations/7.0.1.0/post-migration.py'
--- delivery/migrations/7.0.1.0/post-migration.py	1970-01-01 00:00:00 +0000
+++ delivery/migrations/7.0.1.0/post-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,38 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
+_defaults = {
+    # False results in column value NULL
+    # None value triggers a call to the model's default function
+    'stock.move': [
+        ('weight_uom_id', None),
+        ],
+    'stock.picking': [
+        ('weight_uom_id', None),
+        ],
+    }
+
[e-mail]()
+def migrate(cr, version):
+    pool = pooler.get_pool(cr.dbname)
+    openupgrade.set_defaults(cr, pool, _defaults)

=== added file 'document_ftp/migrations/7.0.1.99/pre-migration.py'
--- document_ftp/migrations/7.0.1.99/pre-migration.py	1970-01-01 00:00:00 +0000
+++ document_ftp/migrations/7.0.1.99/pre-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,29 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
+def change_model(cr, xml_id, new_model):
+    cr.execute("UPDATE ir_model_data SET model = %s WHERE name = %s", (new_model, xml_id))
+
[e-mail]()
+def migrate(cr, version):
+    change_model(cr, 'action_document_browse', 'ir.actions.act_url')

=== added file 'event/migrations/7.0.0.1/post-migration.py'
--- event/migrations/7.0.0.1/post-migration.py	1970-01-01 00:00:00 +0000
+++ event/migrations/7.0.0.1/post-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,31 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openupgrade import openupgrade
+from openupgrade.openupgrade70 import partner_address_to_partner
+
[e-mail]()
+def migrate(cr, version):
+    partner_address_to_partner(cr, 'event_event', 'address_id')
+    cr.execute('UPDATE report_event_registration '\
+            'SET event_state = state, '\
+            'event_date = %s' % openupgrade.get_legacy_name('date'))
+    #TODO: moving the mail data to mail.message and linking it here

=== added file 'event/migrations/7.0.0.1/pre-migration.py'
--- event/migrations/7.0.0.1/pre-migration.py	1970-01-01 00:00:00 +0000
+++ event/migrations/7.0.0.1/pre-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,32 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
[e-mail]()
+def migrate(cr, version):
+    openupgrade.rename_columns(cr, {
+        'report_event_registration': [
+            ('state', 'registration_state'),
+            ('type', 'event_type'),
+            ('date', openupgrade.get_legacy_name('date'))
+            ],
+        })

=== added file 'hr/migrations/7.0.1.1/post-migration.py'
--- hr/migrations/7.0.1.1/post-migration.py	1970-01-01 00:00:00 +0000
+++ hr/migrations/7.0.1.1/post-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,28 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openupgrade import openupgrade
+from openupgrade.openupgrade70 import partner_address_to_partner
+
[e-mail]()
+def migrate(cr, version):
+    partner_address_to_partner(cr, 'hr_employee', 'address_id')
+    partner_address_to_partner(cr, 'hr_employee', 'address_home_id')

=== added file 'hr/migrations/7.0.1.1/pre-migration.py'
--- hr/migrations/7.0.1.1/pre-migration.py	1970-01-01 00:00:00 +0000
+++ hr/migrations/7.0.1.1/pre-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,39 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
+def hr_job_state(cr):
+    cr.execute(
+        "UPDATE hr_job "\
+        "SET state = 'open' "\
+        "WHERE state = 'old'"
+        )
+
[e-mail]()
+def migrate(cr, version):
+    openupgrade.rename_columns(cr, {
+            'hr_employee': [
+                ('photo', 'image'),
+                ],
+            })
+    #TODO: what about the state=='old'?
+    #hr_job_state(cr)

=== added file 'hr_holidays/migrations/7.0.1.5/pre-migration.py'
--- hr_holidays/migrations/7.0.1.5/pre-migration.py	1970-01-01 00:00:00 +0000
+++ hr_holidays/migrations/7.0.1.5/pre-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,30 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
[e-mail]()
+def migrate(cr, version):
+    openupgrade.rename_columns(cr, {
+        'hr_holidays': [
+            ('case_id', 'meeting_id'),
+            ],
+        })

=== added file 'mail/migrations/7.0.1.0/post-migration.py'
--- mail/migrations/7.0.1.0/post-migration.py	1970-01-01 00:00:00 +0000
+++ mail/migrations/7.0.1.0/post-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,64 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from osv import osv
+import pooler, logging
+from openerp.openupgrade import openupgrade
+from openerp.tools.mail import html_sanitize, plaintext2html
+
+from openerp import SUPERUSER_ID
+
+me = __file__
+_logger = logging.getLogger(__name__)
+
+subtype_mapping = {
+    'plain': (openupgrade.get_legacy_name('body_text'), plaintext2html),
+    'html': (openupgrade.get_legacy_name('body_html'), html_sanitize),
+    }
+
+def convert_mail_bodies(cr, pool):
+    msg_obj = pool.get('mail.message')
+    _logger.info("%s: converting HTML messages", me)
+    for subtype in subtype_mapping.keys():
+        field, func = subtype_mapping[subtype]
+        _logger.info("%s: converting %s messages", me, subtype)
+        cr.execute("SELECT id, %(field)s FROM mail_message " \
+                "WHERE %(msg_subtype)s = '%(subtype)s'" %
+                {
+                    'msg_subtype': openupgrade.get_legacy_name('subtype'),
+                    'field': field,
+                    'subtype': subtype,
+                })
+        for row in cr.fetchall():
+            _logger.info("%s: message %s", me, row[0])
+            body = func(row[1])
+            cr.execute("UPDATE mail_message SET body = %s WHERE id = %s", body, row[0])
+
+
+#@openupgrade.migrate()
+def migrate(cr, version):
+    try:
+        #import ipdb; ipdb.set_trace()
+        pool = pooler.get_pool(cr.dbname)
+        convert_mail_bodies(cr, pool)
+        #TODO: what about moving the messages to mail.mail and linking them?
+    except Exception, e:
+        raise osv.except_osv("OpenUpgrade", '%s: %s' % (me, e))

=== added file 'mail/migrations/7.0.1.0/pre-migration.py'
--- mail/migrations/7.0.1.0/pre-migration.py	1970-01-01 00:00:00 +0000
+++ mail/migrations/7.0.1.0/pre-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,50 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+import logging
+
+renames = {
+    'mail_message': [
+        ('subtype', openupgrade.get_legacy_name('subtype')),
+        ('body_html', openupgrade.get_legacy_name('body_html')),
+        ('body_text', openupgrade.get_legacy_name('body_text')),
+        ]
+    }
+
+# there is a cyclic dependency in the module that cannot be handled without
+# creating these columns first
+def add_column(cr, column_spec):
+    for table in column_spec.keys():
+        for (name, typ) in column_spec[table]:
+            cr.execute('ALTER TABLE "%s" ADD COLUMN "%s" %s' % (table, name, typ))
+
[e-mail]()
+def migrate(cr, version):
+    openupgrade.rename_columns(cr, renames)
+    add_column(cr, {
+        'res_users': [
+            ('alias_id', 'INTEGER'),
+            ],
+        'res_partner': [
+            ('notification_email_send', 'char'),
+            ],
+        })

=== added file 'product/migrations/7.0.1.1/pre-migration.py'
--- product/migrations/7.0.1.1/pre-migration.py	1970-01-01 00:00:00 +0000
+++ product/migrations/7.0.1.1/pre-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,31 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
[e-mail]()
+def migrate(cr, version):
+    openupgrade.rename_columns(cr, {
+            'product_product': [
+                ('product_image', 'image'),
+                ],
+            })
+    #TODO: what about moving selection = 'product'?

=== added file 'project/migrations/7.0.1.1/post-migration.py'
--- project/migrations/7.0.1.1/post-migration.py	1970-01-01 00:00:00 +0000
+++ project/migrations/7.0.1.1/post-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,57 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
+from openerp import SUPERUSER_ID
+from openerp.addons.project.project import short_name
+
+_defaults = {
+    # False results in column value NULL
+    # None value triggers a call to the model's default function
+    'project.project': [
+        ('name', 'unknown'),
+        ('alias_model', 'project.task'),
+        ('privacy_visibility', 'public'),
+        ('state', 'open'),
+        ],
+    'project.task.type': [
+        ('state', 'open'),
+        ],
+    }
+
+def assign_mail_alias(cr, pool):
+    mail_alias = pool.get('mail.alias')
+
+    projects = pool.get("project.project")
+    project_ids = projects.search(cr, SUPERUSER_ID, [])
+
+    for project in projects.browse(cr, SUPERUSER_ID, project_ids):
+        alias_id = mail_alias.create_unique_alias(cr, SUPERUSER_ID,
+            {'alias_name': "project+project" + short_name(project.name)},
+            model_name=project.alias_model)
+        projects.write(cr, SUPERUSER_ID, [project['id']], {'alias_id': alias_id})
+
[e-mail]()
+def migrate(cr, version):
+    pool = pooler.get_pool(cr.dbname)
+    openupgrade.set_defaults(cr, pool, _defaults)
+    assign_mail_alias(cr, pool)

=== added file 'project/migrations/7.0.1.1/pre-migration.py'
--- project/migrations/7.0.1.1/pre-migration.py	1970-01-01 00:00:00 +0000
+++ project/migrations/7.0.1.1/pre-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,33 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
[e-mail]()
+def migrate(cr, version):
+    openupgrade.rename_columns(cr, {
+        'project_task': [
+            ('type_id', 'stage_id'),
+            ],
+        'project_task_type': [
+            ('project_default', 'case_default'),
+            ],
+        })

=== added file 'project_issue/migrations/7.0.1.0/post-migration.py'
--- project_issue/migrations/7.0.1.0/post-migration.py	1970-01-01 00:00:00 +0000
+++ project_issue/migrations/7.0.1.0/post-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,27 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
[e-mail]()
+def migrate(cr, version):
+    model = pool.get('sale.order')
+    many2one2many2many(cr, model, 'project_issue', 'categ_ids', openupgrade.get_legacy_name('categ_id'))

=== added file 'project_issue/migrations/7.0.1.0/pre-migration.py'
--- project_issue/migrations/7.0.1.0/pre-migration.py	1970-01-01 00:00:00 +0000
+++ project_issue/migrations/7.0.1.0/pre-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,34 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
[e-mail]()
+def migrate(cr, version):
+    openupgrade.rename_columns(cr, {
+        'project_issue': [
+            ('categ_id', openupgrade.get_legacy_name('categ_id')),
+            ('type_id', 'stage_id'),
+            ],
+        'project_issue': [
+            ('type_id', 'stage_id'),
+            ],
+        })

=== added file 'sale/migrations/7.0.1.0/post-migration.py'
--- sale/migrations/7.0.1.0/post-migration.py	1970-01-01 00:00:00 +0000
+++ sale/migrations/7.0.1.0/post-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,29 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openupgrade import openupgrade
+from openupgrade.openupgrade70 import partner_address_to_partner
+
[e-mail]()
+def migrate(cr, version):
+    partner_address_to_partner(cr, 'sale_order', 'partner_invoice_id')
+    partner_address_to_partner(cr, 'sale_order', 'partner_shipping_id')
+    partner_address_to_partner(cr, 'sale_order_line', 'address_allotment_id')

=== added file 'sale_crm/migrations/7.0.1.0/post-migration.py'
--- sale_crm/migrations/7.0.1.0/post-migration.py	1970-01-01 00:00:00 +0000
+++ sale_crm/migrations/7.0.1.0/post-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,27 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
[e-mail]()
+def migrate(cr, version):
+    model = pool.get('sale.order')
+    many2one2many2many(cr, model, 'sale_order', 'categ_ids', openupgrade.get_legacy_name('categ_id'))

=== added file 'sale_crm/migrations/7.0.1.0/pre-migration.py'
--- sale_crm/migrations/7.0.1.0/pre-migration.py	1970-01-01 00:00:00 +0000
+++ sale_crm/migrations/7.0.1.0/pre-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,30 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
[e-mail]()
+def migrate(cr, version):
+    openupgrade.rename_columns(cr, {
+        'sale_order': [
+            ('categ_id', openupgrade.get_legacy_name('categ_id')),
+            ],
+        })

=== added file 'stock/migrations/7.0.1.1/post-migration.py'
--- stock/migrations/7.0.1.1/post-migration.py	1970-01-01 00:00:00 +0000
+++ stock/migrations/7.0.1.1/post-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,37 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openupgrade import openupgrade
+from openupgrade.openupgrade70 import partner_address_to_partner
+
+_tables_with_address = [
+    'report_stock_inventory',
+    'report_stock_move',
+    'stock_location',
+    'stock_move',
+    'stock_picking',
+    'stock_warehouse',
+    ]
+
[e-mail]()
+def migrate(cr, version):
+    for table in _tables_with_address:
+        partner_address_to_partner(cr, table, 'partner_id')

=== added file 'stock/migrations/7.0.1.1/pre-migration.py'
--- stock/migrations/7.0.1.1/pre-migration.py	1970-01-01 00:00:00 +0000
+++ stock/migrations/7.0.1.1/pre-migration.py	2013-06-19 17:53:32 +0000
@@ -0,0 +1,30 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2013 credativ Ltd (<http://credativ.co.uk>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from openerp.openupgrade import openupgrade
+
[e-mail]()
+def migrate(cr, version):
+    openupgrade.rename_columns(cr, {
+            'stock_location': [('address_id', 'partner_id')],
+            'stock_move': [('address_id', 'partner_id')],
+            'stock_picking': [('address_id', 'partner_id')],
+            })