Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Modifying MySQL OUTSITE of CPG - Schema questions and any cautions requested  (Read 3687 times)

0 Members and 1 Guest are viewing this topic.

picturechasers

  • Coppermine newbie
  • Offline Offline
  • Posts: 5

Hi all,

thanks for your continuing great work, and I hope this post is in the right place.

I need to regularly upload hundreds of files with detailed keywords( currently over 5,000 stock images), titles & descriptions directly to MySQL from my Filemaker Pro DB.  Got that part licked.  Though I have a few questions about how cpg uses MySQL.

1) What is difference between fields "filesize" and "total_filesize"?  Is this necessary info?  My uploaded files are simple web sized jpegs, all same pixel dimensions (except for horizontal vs vertical), but different file sizes.  This is not important to me, unless it will cause a problem I may leave this field empty.

2) In the MySQL table "pictures" there is a field called "ctime", could someone please identify what this field does?


Anyone tried this?  Anything I have to watch for to avoid future meltdown?

Thanks in advance!

Darren Sweet
http://www.picturechasers.com/Stock/
Logged

Nibbler

  • Guest

filesize is the size of the actual file, total_filesize is the size of the pic + resized version + thumbnail. I think these are only used for display and quota purposes. There is a way to fill in this info in admin tools automatically in the next version of coppermine.

ctime is the date/time the picture was added into the database.
Logged

picturechasers

  • Coppermine newbie
  • Offline Offline
  • Posts: 5

thanks Nibbler,

you're pretty helpful for a guy who's missing...

Darren Sweet
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 20 queries.