ls -Ao  --time-style=long-iso 2003-*/*.jpg > updpix.sql
ls -Ao  --time-style=long-iso 2003-*/*.JPG >> updpix.sql
ls -Ao  --time-style=long-iso 2003-*/*.gif >> updpix.sql
ls -Ao  --time-style=long-iso 2003-*/*.GIF >> updpix.sql
ls -Ao  --time-style=long-iso 2003-*/*.avi >> updpix.sql
ls -Ao  --time-style=long-iso 2003-*/*.AVI >> updpix.sql
Replace "\/" "\"@AND@fnam=\"" updpix.sql
Replace "\." "\"@AND@ftyp=\"" updpix.sql
Replace "jpg" "jpg\"\;" updpix.sql
Replace "JPG" "JPG\"\;" updpix.sql
Replace "gif" "gif\"\;" updpix.sql
Replace "GIF" "GIF\"\;" updpix.sql
Replace "avi" "avi\"\;" updpix.sql
Replace "AVI" "AVI\"\;" updpix.sql
Replace "-rw-rw-r--    1 jess    " "\[" updpix.sql
Replace "-rw-r--r--    1 jess    " "\[" updpix.sql
Replace "-rw-r--r--    1 root    " "\[" updpix.sql
Replace "    " " " updpix.sql
Replace "   " " " updpix.sql
Replace "  " " " updpix.sql
Replace "\[ " "\[" updpix.sql
Replace " " "|" updpix.sql
Replace "|00:" " 00:" updpix.sql
Replace "|01:" " 01:" updpix.sql
Replace "|02:" " 02:" updpix.sql
Replace "|03:" " 03:" updpix.sql
Replace "|04:" " 04:" updpix.sql
Replace "|05:" " 05:" updpix.sql
Replace "|06:" " 06:" updpix.sql
Replace "|07:" " 07:" updpix.sql
Replace "|08:" " 08:" updpix.sql
Replace "|09:" " 09:" updpix.sql
Replace "|10:" " 10:" updpix.sql
Replace "|11:" " 11:" updpix.sql
Replace "|12:" " 12:" updpix.sql
Replace "|13:" " 13:" updpix.sql
Replace "|14:" " 14:" updpix.sql
Replace "|15:" " 15:" updpix.sql
Replace "|16:" " 16:" updpix.sql
Replace "|17:" " 17:" updpix.sql
Replace "|18:" " 18:" updpix.sql
Replace "|19:" " 19:" updpix.sql
Replace "|20:" " 20:" updpix.sql
Replace "|21:" " 21:" updpix.sql
Replace "|22:" " 22:" updpix.sql
Replace "|23:" " 23:" updpix.sql
Replace "\[" "UPDATE imgdb SET fsize=" updpix.sql
Replace "@" " " updpix.sql
echo " "
echo "   Now manually replace the FIRST '|' in each line with ',tmade=\"'"
echo "      and then replace the SECOND '|' in each line with '\" WHERE rURL=\"pix\/camera\/\"'"
echo "         and finally edit in any other stuff you want."
echo " "