Change the char values in url and description tables

nootkan

Well-Known Member
Oct 25, 2006
170
12
168
Was wondering if someone could help to write a query that would change the char values from 255 to something less in my database tables without changing every single client individually? I want it to be the default so when someone new registers it will automatically use the new value to write the structure.

ats_sites:
url varchar(255)
short_url varchar(255)
title varchar(255)
description varchar(255)
category varchar(255)
banner_url varchar(255)
Edit: I figured it out. I just went into the structure tab in the table and made the change there using phpmyadmin.
 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,261
463
Hello :)

I am happy to see you were able to find a solution. Thank you for updating us with the outcome.