<div dir="ltr">Hi !<br><br><div>I'm currently trying to migrate an old geonode install (2.4) to the current version.</div><div>I managed to get the migrations to run after some tweaks (details below), but the database is not consistent with the models.</div><div><br></div><div>Is this expected ? Or is there something wrong with the previous install ? (it's old and I have no details about how it was installed). I searched a bit about migrating old geonodes, but didn't find any details past migrating with --fake-initial.</div><div><br></div><div>I can fix the schema with sqldiff (from django-extensions) but would like to know if this is supposed to happen or not.</div><div><br></div><div>Thanks !!</div><div><br></div><div>Olivier<br></div><div><br></div><div><br></div><div><br></div><div>Here are the steps I did :<br></div><div><br></div>1) Run migrations with --fake-initial. This fails at :<br><div><br><div><span style="font-family:monospace,monospace">Applying layers.0029_layer_service...</span></div><div><span style="font-family:monospace,monospace">...<br></span></div><span style="font-family:monospace,monospace">django.db.utils.ProgrammingError: column "service_id" of relation "layers_layer" already exists<br></span><div><br></div><div>2) Manually fix this :</div><div><span style="font-family:monospace,monospace">ALTER TABLE public.layers_layer DROP COLUMN service_id;</span></div><div><br></div><div>3) Run the migrations (they complete)</div><div><br></div><div>4) Check the consistency with python manage.py sqldiff -ae (from django-extensions). There are inconsistencies, some of which will cause problems (NOT NULL constraints, missing columns, etc.). Using this, I can fix the schema (need to drop tables with no models).<br></div><div><br></div>
<div style="color:rgb(248,248,242);background-color:rgb(39,40,34);font-family:Consolas,"Courier New",monospace;font-weight:normal;font-size:14px;line-height:19px;white-space:pre"><div><span style="color:rgb(249,38,114)">BEGIN</span><span style="color:rgb(248,248,242)">;</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: account_accountdeletion</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: account_account</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: account_signupcoderesult</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: account_signupcode</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: celery_taskmeta</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: celery_tasksetmeta</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: djcelery_intervalschedule</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: djcelery_crontabschedule</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: djcelery_periodictasks</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: djcelery_workerstate</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: account_signupcodeextended</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: djcelery_periodictask</span></div><div><span style="color:rgb(117,113,94)">-- Model missing for table: djcelery_taskstate</span></div><div><span style="color:rgb(117,113,94)">-- Application: actstream</span></div><div><span style="color:rgb(117,113,94)">-- Model: Follow</span></div><div><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> INDEX </span><span style="color:rgb(230,219,116)">"actstream_follow_object_id"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_follow"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"object_id"</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">INDEX</span><span style="color:rgb(248,248,242)"> "</span><span style="color:rgb(166,226,46)">actstream_follow_object_id_like</span><span style="color:rgb(248,248,242)">"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_follow"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"object_id"</span><span style="color:rgb(248,248,242)"> varchar_pattern_ops);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">INDEX</span><span style="color:rgb(248,248,242)"> "</span><span style="color:rgb(166,226,46)">actstream_follow_started</span><span style="color:rgb(248,248,242)">"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_follow"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"started"</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(117,113,94)">-- Model: Action</span></div><div><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> INDEX </span><span style="color:rgb(230,219,116)">"actstream_action_actor_object_id"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_action"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"actor_object_id"</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">INDEX</span><span style="color:rgb(248,248,242)"> "</span><span style="color:rgb(166,226,46)">actstream_action_actor_object_id_like</span><span style="color:rgb(248,248,242)">"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_action"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"actor_object_id"</span><span style="color:rgb(248,248,242)"> varchar_pattern_ops);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">INDEX</span><span style="color:rgb(248,248,242)"> "</span><span style="color:rgb(166,226,46)">actstream_action_verb</span><span style="color:rgb(248,248,242)">"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_action"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"verb"</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">INDEX</span><span style="color:rgb(248,248,242)"> "</span><span style="color:rgb(166,226,46)">actstream_action_verb_like</span><span style="color:rgb(248,248,242)">"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_action"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"verb"</span><span style="color:rgb(248,248,242)"> varchar_pattern_ops);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">INDEX</span><span style="color:rgb(248,248,242)"> "</span><span style="color:rgb(166,226,46)">actstream_action_target_object_id</span><span style="color:rgb(248,248,242)">"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_action"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"target_object_id"</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">INDEX</span><span style="color:rgb(248,248,242)"> "</span><span style="color:rgb(166,226,46)">actstream_action_target_object_id_like</span><span style="color:rgb(248,248,242)">"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_action"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"target_object_id"</span><span style="color:rgb(248,248,242)"> varchar_pattern_ops);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">INDEX</span><span style="color:rgb(248,248,242)"> "</span><span style="color:rgb(166,226,46)">actstream_action_action_object_object_id</span><span style="color:rgb(248,248,242)">"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_action"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"action_object_object_id"</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">INDEX</span><span style="color:rgb(248,248,242)"> "</span><span style="color:rgb(166,226,46)">actstream_action_action_object_object_id_like</span><span style="color:rgb(248,248,242)">"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_action"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"action_object_object_id"</span><span style="color:rgb(248,248,242)"> varchar_pattern_ops);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">INDEX</span><span style="color:rgb(248,248,242)"> "</span><span style="color:rgb(166,226,46)">actstream_action_timestamp</span><span style="color:rgb(248,248,242)">"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_action"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"timestamp"</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">CREATE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">INDEX</span><span style="color:rgb(248,248,242)"> "</span><span style="color:rgb(166,226,46)">actstream_action_public</span><span style="color:rgb(248,248,242)">"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ON</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_action"</span><span style="color:rgb(248,248,242)"> (</span><span style="color:rgb(230,219,116)">"public"</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"actstream_action"</span></div><div><span style="color:rgb(248,248,242)"> ALTER </span><span style="color:rgb(230,219,116)">"data"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TYPE</span><span style="color:rgb(248,248,242)"> jsonb;</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(117,113,94)">-- Application: tastypie</span></div><div><span style="color:rgb(117,113,94)">-- Model: ApiKey</span></div><div><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"tastypie_apikey"</span></div><div><span style="color:rgb(248,248,242)"> ALTER </span><span style="color:rgb(230,219,116)">"key"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TYPE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">varchar</span><span style="color:rgb(248,248,242)">(</span><span style="color:rgb(174,129,255)">128</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(117,113,94)">-- Application: base</span></div><div><span style="color:rgb(117,113,94)">-- Model: ContactRole</span></div><div><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"base_contactrole"</span></div><div><span style="color:rgb(248,248,242)"> ALTER COLUMN </span><span style="color:rgb(230,219,116)">"resource_id"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">DROP</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">NOT</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">NULL</span><span style="color:rgb(248,248,242)">;</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(117,113,94)">-- Model: ResourceBase</span></div><div><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"base_resourcebase"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">DROP</span><span style="color:rgb(248,248,242)"> COLUMN </span><span style="color:rgb(230,219,116)">"distribution_url"</span><span style="color:rgb(248,248,242)">;</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"base_resourcebase"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">DROP</span><span style="color:rgb(248,248,242)"> COLUMN </span><span style="color:rgb(230,219,116)">"distribution_description"</span><span style="color:rgb(248,248,242)">;</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(117,113,94)">-- Model: Link</span></div><div><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"base_link"</span></div><div><span style="color:rgb(248,248,242)"> ALTER COLUMN </span><span style="color:rgb(230,219,116)">"resource_id"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">DROP</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">NOT</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">NULL</span><span style="color:rgb(248,248,242)">;</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(117,113,94)">-- Application: layers</span></div><div><span style="color:rgb(117,113,94)">-- Model: Layer</span></div><div><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"layers_layer"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">DROP</span><span style="color:rgb(248,248,242)"> COLUMN </span><span style="color:rgb(230,219,116)">"distribution_description_en"</span><span style="color:rgb(248,248,242)">;</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(117,113,94)">-- Application: maps</span></div><div><span style="color:rgb(117,113,94)">-- Model: Map</span></div><div><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"maps_map"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">DROP</span><span style="color:rgb(248,248,242)"> COLUMN </span><span style="color:rgb(230,219,116)">"distribution_description_en"</span><span style="color:rgb(248,248,242)">;</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(117,113,94)">-- Application: documents</span></div><div><span style="color:rgb(117,113,94)">-- Model: Document</span></div><div><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"documents_document"</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">DROP</span><span style="color:rgb(248,248,242)"> COLUMN </span><span style="color:rgb(230,219,116)">"distribution_description_en"</span><span style="color:rgb(248,248,242)">;</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"documents_document"</span></div><div><span style="color:rgb(248,248,242)"> ALTER </span><span style="color:rgb(230,219,116)">"doc_file"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TYPE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">varchar</span><span style="color:rgb(248,248,242)">(</span><span style="color:rgb(174,129,255)">255</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"documents_document"</span></div><div><span style="color:rgb(248,248,242)"> ALTER </span><span style="color:rgb(230,219,116)">"doc_url"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TYPE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">varchar</span><span style="color:rgb(248,248,242)">(</span><span style="color:rgb(174,129,255)">255</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(117,113,94)">-- Application: people</span></div><div><span style="color:rgb(117,113,94)">-- Model: Profile</span></div><div><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"people_profile"</span></div><div><span style="color:rgb(248,248,242)"> ALTER </span><span style="color:rgb(230,219,116)">"email"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TYPE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">varchar</span><span style="color:rgb(248,248,242)">(</span><span style="color:rgb(174,129,255)">254</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"people_profile"</span></div><div><span style="color:rgb(248,248,242)"> ALTER COLUMN </span><span style="color:rgb(230,219,116)">"last_login"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">DROP</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">NOT</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">NULL</span><span style="color:rgb(248,248,242)">;</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(117,113,94)">-- Application: groups</span></div><div><span style="color:rgb(117,113,94)">-- Model: GroupProfile</span></div><div><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"groups_groupprofile"</span></div><div><span style="color:rgb(248,248,242)"> ALTER </span><span style="color:rgb(230,219,116)">"email"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TYPE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">varchar</span><span style="color:rgb(248,248,242)">(</span><span style="color:rgb(174,129,255)">254</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(117,113,94)">-- Application: upload</span></div><div><span style="color:rgb(117,113,94)">-- Model: Upload</span></div><div><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"upload_upload"</span></div><div><span style="color:rgb(248,248,242)"> ADD COLUMN </span><span style="color:rgb(230,219,116)">"mosaic_time_value"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">varchar</span><span style="color:rgb(248,248,242)">(</span><span style="color:rgb(174,129,255)">128</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"upload_upload"</span></div><div><span style="color:rgb(248,248,242)"> ADD COLUMN </span><span style="color:rgb(230,219,116)">"mosaic_time_regex"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">varchar</span><span style="color:rgb(248,248,242)">(</span><span style="color:rgb(174,129,255)">128</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"upload_upload"</span></div><div><span style="color:rgb(248,248,242)"> ADD COLUMN </span><span style="color:rgb(230,219,116)">"mosaic_elev_regex"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">varchar</span><span style="color:rgb(248,248,242)">(</span><span style="color:rgb(174,129,255)">128</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">ALTER</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">TABLE</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(230,219,116)">"upload_upload"</span></div><div><span style="color:rgb(248,248,242)"> ADD COLUMN </span><span style="color:rgb(230,219,116)">"mosaic_elev_value"</span><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">varchar</span><span style="color:rgb(248,248,242)">(</span><span style="color:rgb(174,129,255)">128</span><span style="color:rgb(248,248,242)">);</span></div><div><span style="color:rgb(248,248,242)"> </span><span style="color:rgb(249,38,114)">COMMIT</span><span style="color:rgb(248,248,242)">;</span></div></div>
</div></div>