Description field not large enough

[Martijn Zeedijk]

I have about 10 milestones that I want to show with a ticketQuery in the description of the project. At some point saving will result in an error, although it doesn't show one. It will just show an empty project list instead.

My guess it that I went over 255 chars which is the maximum of the varchar field in the database. This field should be of type text instead.

I changed this myself with

 ALTER TABLE smp_project ALTER COLUMN description TYPE text;

and it seems to work.

[Ryan J Ollos]

For portability we should eliminate all uses of varchar in the tables. An environment upgrade step will be needed to migrate the schema.

[Cinc-th]

In 17810:

SimpleMultiProjectPlugin: implemented new permission system, new admin page, unit tests and more.

• The new permission system uses Trac permissions instead of a private user list
• Admin page for projects rewritten to use the new permissions and for license reasons
• Changed field types in SMP database tables from varchar(255) to text (see #13510 for info)
• Unit tests for new features
• removal of obsolete code

Refs #13850
closes #13510