Changing Table Properties

[moose6589]

Hi,

 

I am currently using Coppermine for my image gallery, and right now I'm trying to install a hack that will allow me to sort pictures by the date the picture was taken on rather than on the upload date.

 

The hack itself can be found at http://coppermine.sourceforge.net/board/in...hp?topic=9360.0

 

However, the first step of the hack is really confusing me. It says to alter the picture table and add a ptime after ctime that is an int. Then, there is a box of code...but then it doesn't look a lot like code in a way.

>ALTER TABLE `{$CONFIG['TABLE_PICTURES']}` ADD `ptime` INT NOT NULL AFTER `ctime`;

I tried to go into phpMyAdmin to change things. I have found the ctime value under the properties of the picture table cpg132_pictures. So, how do I add a ptime under it? What am I supposed to do? I am utterly confused by phpMyAdmin and this person's instructions.

 

Thanks for reading.

[carbonize]

>ALTER TABLE `cpg132_pictures` ADD `ptime` INT NOT NULL AFTER `ctime`

Edited April 2, 2005 by carbonize

[TCH-Dick]

[moose6589]

Thanks for the clear instructions! Everything's working fine now.