[web2py] Re: Asking support for MySQL create/alter column "AFTER" keyword

2021-07-22 Thread Alfonso Serra
Hi Massimo I have created standalone functions that reorders table fields and support for indexing regular fields by adding "indexed" to the Field signature at objects.py Before trying the script please add indexed=False to the Field signature and self.indexed = indexed in objects.py, or

[web2py] Re: Asking support for MySQL create/alter column "AFTER" keyword

2018-01-23 Thread Alfonso Serra
This works only on newly created fields over MySQL. Moving fields around on your model wont reorder them. Version 2.15.3-stable+timestamp.2017.08.07.12.51.45 migrator.py line 364 field_position = sql_fields[key]['sortable'] after = "FIRST"

[web2py] Re: Asking support for MySQL create/alter column "AFTER" keyword

2017-12-24 Thread Massimo Di Pierro
look in web2py/gluon/packages/dal/pydal and search for "ALTER" in all files there and subfolders. It wiil give you and idea of how the logic is implemented. On Monday, 18 December 2017 03:59:52 UTC-6, Alfonso Serra wrote: > > I would love to, have some time in December to spend in personal

[web2py] Re: Asking support for MySQL create/alter column "AFTER" keyword

2017-12-18 Thread Alfonso Serra
I would love to, have some time in December to spend in personal projects. Any directions or shall i start researching the source code? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Asking support for MySQL create/alter column "AFTER" keyword

2017-12-16 Thread Massimo Di Pierro
I would support to change. Can you help make it happen? On Thursday, 7 December 2017 10:18:35 UTC-6, Alfonso Serra wrote: > > Hi everybody. > > I would like to ask for support for the create column "AFTER" another > column keyword so whenever we change something in our models the order of > the