Move contents of database.sql to dca files.

[discordier]

As we are Contao3+ now, we can move the contents of database.sql to the dca files and get rid of the database.sql file.

List of repositories to apply above tasks to:

• metamodels/core
• metamodels/attribute_alias => Hotfix move contents of database.sql to dca files attribute_alias#24
• metamodels/attribute_checkbox => Hotfix move contents of database.sql to dca files attribute_checkbox#20
• metamodels/attribute_color
• metamodels/attribute_combinedvalues => Hotfix move contents of database.sql to dca files attribute_combinedvalues#19
• metamodels/attribute_country => Hotfix move contents of database.sql to dca files attribute_country#14
• metamodels/attribute_decimal
• metamodels/attribute_file => Hotfix move contents of database.sql to dca files attribute_file#67
• metamodels/attribute_geoprotection is alpha version R.I.P.
• metamodels/attribute_langcode => Hotfix move contents of database.sql to dca files attribute_langcode#8
• metamodels/attribute_longtext
• metamodels/attribute_numeric
• metamodels/attribute_rating => MetaModels/attribute_rating@d8e4224
• metamodels/attribute_select => Hotfix move contents of database.sql to dca files attribute_select#61
• metamodels/attribute_tabletext => MetaModels/attribute_tabletext@96eb107
• metamodels/attribute_tags => MetaModels/attribute_tags@bb60aa3
• metamodels/attribute_text => Hotfix move contents of database.sql to dca files attribute_text#15
• metamodels/attribute_timestamp =>Hotfix move contents of database.sql to dca files attribute_timestamp#30
• metamodels/attribute_url =>Hotfix move contents of database.sql to dca files attribute_url#25
• metamodels/attribute_translatedalias => MetaModels/attribute_translatedalias@b58b1e3
• metamodels/attribute_translatedcheckbox => MetaModels/attribute_translatedcheckbox@60eac05
• metamodels/attribute_translatedcombinedvalues => MetaModels/attribute_translatedcombinedvalues@680b930
• metamodels/attribute_translatedfile => MetaModels/attribute_translatedfile@1b35410
• metamodels/attribute_translatedlongtext => MetaModels/attribute_translatedlongtext@9af29e9
• metamodels/attribute_translatedselect => MetaModels/attribute_translatedselect@7d96b2c
• metamodels/attribute_translatedtabletext => MetaModels/attribute_translatedtabletext@29bc6c9
• metamodels/attribute_translatedtags => MetaModels/attribute_translatedtags@18688b1
• metamodels/attribute_translatedtext => MetaModels/attribute_translatedtext@51f35b9
• metamodels/attribute_translatedurl
• metamodels/filter_checkbox => Hotfix move contents of database.sql to dca files filter_checkbox#12
• metamodels/filter_fromto => Hotfix move contents of database.sql to dca files filter_fromto#21
• metamodels/filter_perimetersearch => MetaModels/filter_perimetersearch@3a801b5
• metamodels/filter_range => Hotfix move contents of database.sql to dca files filter_range#11
• metamodels/filter_register => MetaModels/filter_register@4b23c52
• metamodels/filter_select
• metamodels/filter_tags => Hotfix move contents of database.sql to dca files filter_tags#22
• metamodels/filter_text => Hotfix move contents of database.sql to dca files filter_text#34

e.g.

'sql' => 'char(1) NOT NULL default \'\'',
'sql' => 'char(1) NOT NULL default \'0\'',
'sql' => 'char(5) NOT NULL default \'\'',
'sql' => 'varchar(10) NOT NULL default \'\'',
'sql' => 'varchar(32) NOT NULL default \'\'',
'sql' => 'varchar(255) NOT NULL default \'\'',
'sql' => 'int(10) unsigned NOT NULL default \'0\'',
'sql' => 'blob NULL',
'sql' => 'text NULL',

[richardhj]

Should I go about it?
I ask because some attributes are released as stable version and use the database.sql yet.

[discordier]

Would be nice, we can safely change this in patch level releases as the results are compatible.

[zonky2]

@richardhj we can close this ticket?

[richardhj]

Definitely.
No. The attribute and filter packages are still affected.

[stefanheimes]

+1 for R.I.P for geoprotection ;)

[zonky2]

finish