Hi All!
What I'd like to do is reposition some of my columns to organize and create a better work flow when administering links in my directory. Best Example:
By default I was using the <%Title%> column to display, The Title - And the title description goes here! With the addition of new features I decided it would be better to create a <%Title_Description%> column to display the title description separately. Adding this about 70 columns down from the Title Column throws off the work flow a bit. I'd like to have the Title_Description right under the Title Column to keep things tight.
For an answer I went search through the GT forums.
I found the topic below in the MySQLMan forum where Alex explains:
-----------------------------------------------------------------------------------------------------------------------------------------------
http://gossamer-threads.com/...earch_string;#132556
Hi,
Your best bet is to SQL Dump your database making sure you have extended insert selected. Then edit the file and change the order in the CREATE TABLE statement. Then run the file and it will be updated.
Cheers,
Alex
--
Gossamer Threads Inc.
-----------------------------------------------------------------------------------------------------------------------------------------------
Because this topic was in the MySQLMan forum I wanted to check with you guys to make sure this method of rearranging columns would work in Links SQL 2.1.1. The simple copy/paste editing and import of a SQL Dump just seems to easy. I'm just hoping it is though
! I just don't want to go making these changes to later realize the columns rely on other dependencies in Links SQL causing this not to work.
Many thanks for any info on this! I'm sure this info would be valuable to those with messy tables.
Ryan Jonze
What I'd like to do is reposition some of my columns to organize and create a better work flow when administering links in my directory. Best Example:
By default I was using the <%Title%> column to display, The Title - And the title description goes here! With the addition of new features I decided it would be better to create a <%Title_Description%> column to display the title description separately. Adding this about 70 columns down from the Title Column throws off the work flow a bit. I'd like to have the Title_Description right under the Title Column to keep things tight.
For an answer I went search through the GT forums.
I found the topic below in the MySQLMan forum where Alex explains:
-----------------------------------------------------------------------------------------------------------------------------------------------
http://gossamer-threads.com/...earch_string;#132556
Hi,
Your best bet is to SQL Dump your database making sure you have extended insert selected. Then edit the file and change the order in the CREATE TABLE statement. Then run the file and it will be updated.
Cheers,
Alex
--
Gossamer Threads Inc.
-----------------------------------------------------------------------------------------------------------------------------------------------
Because this topic was in the MySQLMan forum I wanted to check with you guys to make sure this method of rearranging columns would work in Links SQL 2.1.1. The simple copy/paste editing and import of a SQL Dump just seems to easy. I'm just hoping it is though
! I just don't want to go making these changes to later realize the columns rely on other dependencies in Links SQL causing this not to work. Many thanks for any info on this! I'm sure this info would be valuable to those with messy tables.
Ryan Jonze
Changing Field Order in Links SQL???