echo "Depending on the size of your database,"
echo "this script may take several minutes to run."
echo " "
echo "Depending on the size of your database,"
echo "this script may take several minutes to run."
echo " "
ALTER TABLE media ADD COLUMN DeviceId integer;
UPDATE media SET DeviceId=0;
ALTER TABLE media ADD COLUMN MediaTypeId integer;
ALTER TABLE media ADD COLUMN DeviceId integer;
UPDATE media SET DeviceId=0;
ALTER TABLE media ADD COLUMN MediaTypeId integer;