Command Line Options for Session Creation
I have a folder structure with photos organized by theme/shoot/date and I want to get each one of these folders in a CaptureOne session.
I am trying to create sessions by hand but this is tedious.
Can I use some command line option for the captureone.exe or any other executable to script this task?
0
-
I can't help you with an auto option but just for reference you can create a Session where the existing folder with the images becomes the Capture Folder. I also like any output (round tripping) to be saved to the same folder as the raw files as they are then immediately available for further processing in C1. However, you can mix and match to personal requirements.
All you do is create a session with the location the folder with the raw files and the Capture and Output folder names replaced with two periods. This tip was from another Ian on these forums :-)
An example is shown below:
0 -
I have found a workaround.
As a session, when initialized, is basically four folders in the root folder (Capture, Output, Selects, Trash) and the .cosessiondb file, which is in reality an sqlite3 database, I have created a script that takes as an argument the name of the root folder and populates it with the appropriate files.
For the sqlite3 DB, I created an empty session and compared this initial DB with the DB from another, populated session. The important items to change are:
1) In the ZDOCUMENTCONTENT table, the line has to be initialized with a UUID. I have used the linux util to create one.
2) The ZCAPTUREPILOT and the ZCOLLECTION tables have rows which need the root folder/session name entry.
3) The entries for the four standard subfolders need to be in the ZPATHLOCATION table.
My script is a bash script and is very basic now, but it works.
1 -
Panos, can you share this script? I'm trying to do something like this as well.
0 -
I do not have any problem sharing what I have done, but you have to understand that you need to know bash (linux or mac) scripting, because you will need to adapt it, and understand what you are doing. With that disclaimer out of the way, you will need to create a folder and put two files in it -- the first is a bash script, which you can name however you want -- the second is a template of an SQL file that is going to be used to populate the sqlite3 database. I have named this second file "template.sql". The content of both is as follows:
#!/bin/bash
# I assume that we need to create a session out of ALL the photos
# that exist in one path. The script will create that session, and
# move the photos in the Capture folder of that session.
# The first argument of the script is the path with these photos.
# In my case, all the photo folders are in the format:
# YYYYMMDD - <description>
# or, for example:
# 20200810 - sunset at the beach
# This is important as I pull the info of the date, from the path
# to populate the database
mysourceroot=<some folder> # This is the root folder of all my existing photo folders
# I have organized all my photos according to date taken under this folder, in
# separate folders
mypath=$1 # first argument is the source path of the photos
# This is just a folder name, not a path with slashes. mypath exists
# under mysourceroot
mysessionroot=<some folder> # This is the root folder of all my sessions
# in my case it is something like /data/SESSIONS
# for ease of use, I split my sessions per year
# so the the aforementioned example would become a session at:
# /data/SESSIONS/2020/20200810 - sunset at the beach
myuuid=`uuidgen` # we need a unique id for the session
myyear=`echo $mypath|head -c4` # pulling the year from the path
# check whether session folder already exists
# if it does, do not proceed
if [ -d "$mysessionroot/$myyear/$mypath" ]; then
echo "** Session folder $mysessionroot/$myyear/$mypath already exists"
echo "** Aborting"
else
echo "** Creating standard folders under $mysessionroot/$myyear/$mypath"
mkdir -p "$mysessionroot/$myyear/$mypath"/{Capture,Output,Selects,Trash}
echo "** Preparing SQL database"
sed -e "s/@@@@/$myuuid/g;s/####/$mypath/g" template.sql > "$mysessionroot/$myyear/$mypath/temp.sql"
pushd "$mysessionroot/$myyear/$mypath"
echo "** Creating SQL database"
sqlite3 "${mypath}.cosessiondb" < temp.sql
rm temp.sql
echo "** Move photos from $mysourceroot/$mypath to $mysessionroot/$myyear/$mypath/Capture/"
mv "$mysourceroot/$mypath"/* "$mysessionroot/$myyear/$mypath/Capture/"
echo "** Remove old folder"
rmdir "$mysourceroot/$mypath"
popd
fiPRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE ZDOCUMENTCONTENT ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZDATECREATED FLOAT, ZDATEMODIFIED FLOAT, ZOUTPUTCOUNTER INTEGER, ZOUTPUTCOUNTERINCREMENT INTEGER, ZDOCUMENTTYPE INTEGER NOT NULL, ZDOCUMENTUUID VARCHAR, ZROOTCOLLECTION INTEGER, ZSELECTEDCOLLECTION INTEGER, ZIMPORTCONFLICTCOUNTER INTEGER, ZLASTBACKUPDATE FLOAT, ZLASTBACKUPROOTLOCATION INTEGER, ZLASTBACKUPFOLDERLOCATION INTEGER, ZHOTFOLDERDESTINATIONLOCATION INTEGER );
INSERT INTO ZDOCUMENTCONTENT VALUES(NULL,1,'2020-08-21 01:23:45',2019.999999999999999,0,1,0,'@@@@',1,NULL,0,NULL,NULL,NULL,NULL);
CREATE TABLE ZVERSIONINFO ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZAUTHOR VARCHAR, ZCOMPATIBILITY VARCHAR, ZCOMPATIBLEVERSION INTEGER, ZFORMAT VARCHAR, ZVERSION INTEGER );
INSERT INTO ZVERSIONINFO VALUES(32,1,'13.1.2.35 Pro Win','10.0.0 Mac / 10.0.0 Win',1310,'13.1.2.35 Pro Win',1310);
CREATE TABLE ZENTITIES ( Z_ENT INTEGER PRIMARY KEY, ZNAME VARCHAR );
INSERT INTO ZENTITIES VALUES(1,'Collection');
INSERT INTO ZENTITIES VALUES(2,'AlbumCollection');
INSERT INTO ZENTITIES VALUES(3,'FolderCollection');
INSERT INTO ZENTITIES VALUES(4,'TempFolderCollection');
INSERT INTO ZENTITIES VALUES(5,'SmartCollection');
INSERT INTO ZENTITIES VALUES(6,'VariantCollection');
INSERT INTO ZENTITIES VALUES(7,'ProjectCollection');
INSERT INTO ZENTITIES VALUES(8,'VirtualFolderCollection');
INSERT INTO ZENTITIES VALUES(9,'WCSCollection');
INSERT INTO ZENTITIES VALUES(10,'SlideshowCollection');
INSERT INTO ZENTITIES VALUES(11,'TrashCollection');
INSERT INTO ZENTITIES VALUES(12,'Image');
INSERT INTO ZENTITIES VALUES(13,'VariantMetadata');
INSERT INTO ZENTITIES VALUES(14,'Stack');
INSERT INTO ZENTITIES VALUES(15,'Variant');
INSERT INTO ZENTITIES VALUES(16,'VariantLayer');
INSERT INTO ZENTITIES VALUES(17,'VariantAdjustmentLayer');
INSERT INTO ZENTITIES VALUES(18,'VariantDefaultLayer');
INSERT INTO ZENTITIES VALUES(19,'VariantStyleLayer');
INSERT INTO ZENTITIES VALUES(20,'VariantCombinedLayer');
INSERT INTO ZENTITIES VALUES(21,'ProcessHistory');
INSERT INTO ZENTITIES VALUES(22,'LocalAdjustmentsBaseLayer');
INSERT INTO ZENTITIES VALUES(23,'LocalAdjustmentsLayer');
INSERT INTO ZENTITIES VALUES(24,'LocalAdjustmentsStyleLayer');
INSERT INTO ZENTITIES VALUES(25,'CapturePilot');
INSERT INTO ZENTITIES VALUES(26,'Session');
INSERT INTO ZENTITIES VALUES(27,'Catalog');
INSERT INTO ZENTITIES VALUES(28,'EnabledOutputRecipe');
INSERT INTO ZENTITIES VALUES(29,'Sidecar');
INSERT INTO ZENTITIES VALUES(30,'Keywords');
INSERT INTO ZENTITIES VALUES(31,'VariantKeywords');
INSERT INTO ZENTITIES VALUES(32,'VersionInfo');
INSERT INTO ZENTITIES VALUES(33,'StackImageLink');
INSERT INTO ZENTITIES VALUES(34,'DocumentContent');
INSERT INTO ZENTITIES VALUES(35,'CollectionVariantLink');
INSERT INTO ZENTITIES VALUES(36,'CatalogFolderCollection');
INSERT INTO ZENTITIES VALUES(37,'SelectedVariants');
INSERT INTO ZENTITIES VALUES(38,'PathLocation');
INSERT INTO ZENTITIES VALUES(39,'CatalogInternalImagesCollection');
INSERT INTO ZENTITIES VALUES(40,'CatalogAllImagesCollection');
INSERT INTO ZENTITIES VALUES(41,'ImageInCollectionProperties');
INSERT INTO ZENTITIES VALUES(42,'VariantLayerLocalAdjustmentLink');
INSERT INTO ZENTITIES VALUES(43,'CloneLayer');
INSERT INTO ZENTITIES VALUES(44,'Keyword');
INSERT INTO ZENTITIES VALUES(45,'Synonym');
INSERT INTO ZENTITIES VALUES(46,'DocumentSetting');
CREATE TABLE ZCAPTUREPILOT ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZALLOWCAPTURING BOOLEAN, ZALLOWCOLORTAGGING BOOLEAN, ZALLOWCOLORTAGGINGFORWEB BOOLEAN, ZALLOWIMAGEADJUSTMENTS BOOLEAN, ZALLOWRATING BOOLEAN, ZALLOWRATINGFORWEB BOOLEAN, ZPASSWORD VARCHAR, ZPORTSETBYUSER BOOLEAN, ZPORTSETBYUSERFORWEB BOOLEAN, ZPUBLISHTOAPPS BOOLEAN, ZPUBLISHTOWEB BOOLEAN, ZSERVERNAME VARCHAR, ZSERVERPORT INTEGER, ZSERVERPORTFORWEB INTEGER, ZTHEMENAMEFORWEB VARCHAR );
INSERT INTO ZCAPTUREPILOT VALUES(25,1,1,1,1,1,1,1,'',0,1,1,1,'####',0,80,'Capture Pilot Classic');
CREATE TABLE ZCOLLECTION ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZCAPTURECOUNTER INTEGER, ZCAPTURECOUNTERINCREMENT INTEGER, ZCAPTURENAMINGNAME VARCHAR, ZCAPTURENAMINGTOKENBASEDFORMAT VARCHAR, ZCOLLAPSED BOOLEAN, ZDATECREATED FLOAT, ZDATEMODIFIED FLOAT, ZIMPORTCOUNTER INTEGER, ZIMPORTCOUNTERINCREMENT INTEGER, ZCOLLECTIONINDEX INTEGER, ZNAME VARCHAR, ZOUTPUTCOUNTER INTEGER, ZOUTPUTCOUNTERINCREMENT INTEGER, ZSELECTEDRECIPENAME VARCHAR, ZSERVEDBYCAPTUREPILOT BOOLEAN, ZSORTORDER VARCHAR, ZCAPTURECOLLECTION INTEGER, ZCOMPAREVARIANT INTEGER, ZDOCUMENT INTEGER, ZMOVETOCOLLECTION INTEGER, ZPARENT INTEGER, ZPRIMARYVARIANT INTEGER, ZPROCESSCOLLECTION INTEGER, ZPROJECT INTEGER, ZSELECTEDINDOCUMENT INTEGER, ZTRASHCOLLECTION INTEGER, ZSELECTIONATTRIBUTES VARCHAR, ZCOLLECTIONSEARCHSTATS VARCHAR, ZCAPTUREDESTINATIONLOCATION INTEGER, ZPROCESSDESTINATIONLOCATION INTEGER, ZSELECTSDESTINATIONLOCATION INTEGER, ZTRASHDESTINATIONLOCATION INTEGER, ZCAPTURECOLLECTIONOPTIONS INTEGER, ZPROCESSCOLLECTIONOPTIONS INTEGER, ZALLIMAGESCOLLECTION INTEGER, ZLASTCAPTURESCOLLECTION INTEGER, ZLASTIMPORTSCOLLECTION INTEGER, ZCONTENTMODIFIEDDATE FLOAT, ZLASTCAPTUREDIMAGE INTEGER, ZSEARCHCRITERIA VARCHAR, ZFILTERCRITERIA VARCHAR, ZSMARTCRITERIA VARCHAR, ZFOLDERLOCATION INTEGER, ZOUTPUTLOCATIONTOKENBASEDSUBFOLDER VARCHAR );
INSERT INTO ZCOLLECTION VALUES(7,1,1,1,'####','<TokenName Version="2"><Token Type="5" /><Token Type="3" /></TokenName>',1,'2020-08-21 01:23:45',1598028616.4853589534,1,1,0,'[Collection]',NULL,NULL,'TIFF - Adobe RGB (1998) (8bit)',0,'filename',4,NULL,1,7,-1,NULL,5,-1,NULL,6,NULL,NULL,1,2,4,3,0,0,NULL,NULL,NULL,1598028616.4389750956,NULL,replace(replace('<?xml version="1.0" encoding="utf-8"?>\r\n<MatchOperator Kind="AND" />','\r',char(13)),'\n',char(10)),replace(replace('<?xml version="1.0" encoding="utf-8"?>\r\n<MatchOperator Kind="AND" />','\r',char(13)),'\n',char(10)),NULL,NULL,'');
INSERT INTO ZCOLLECTION VALUES(5,2,NULL,NULL,NULL,NULL,1,1597973026.1521351337,1597973026.2719378471,NULL,NULL,5,'All Images',NULL,NULL,NULL,0,'filename',NULL,NULL,1,NULL,1,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,1597973026.1521351337,NULL,replace(replace('<?xml version="1.0" encoding="utf-8"?>\r\n<MatchOperator Kind="AND" />','\r',char(13)),'\n',char(10)),replace(replace('<?xml version="1.0" encoding="utf-8"?>\r\n<MatchOperator Kind="AND" />','\r',char(13)),'\n',char(10)),replace(replace('<?xml version="1.0" encoding="utf-8"?>\r\n<MatchOperator Kind="AND" />','\r',char(13)),'\n',char(10)),NULL,NULL);
INSERT INTO ZCOLLECTION VALUES(5,3,NULL,NULL,NULL,NULL,1,1597973026.4596538543,1597973026.6891186237,NULL,NULL,6,'Five Stars',NULL,NULL,NULL,0,'filename',NULL,NULL,1,NULL,1,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,1597973026.4596538543,NULL,replace(replace('<?xml version="1.0" encoding="utf-8"?>\r\n<MatchOperator Kind="AND" />','\r',char(13)),'\n',char(10)),replace(replace('<?xml version="1.0" encoding="utf-8"?>\r\n<MatchOperator Kind="AND" />','\r',char(13)),'\n',char(10)),replace(replace('<?xml version="1.0" encoding="utf-8"?>\r\n<MatchOperator Kind="AND">\r\n <MatchOperator Kind="AND">\r\n <Condition Enabled="YES">\r\n <Key>IB_I_BASIC_RATING</Key>\r\n <Operator>0</Operator>\r\n <Criterion>5</Criterion>\r\n </Condition>\r\n </MatchOperator>\r\n</MatchOperator>','\r',char(13)),'\n',char(10)),NULL,NULL);
CREATE TABLE ZENABLEDOUTPUTRECIPE ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZNAME VARCHAR, ZENABLEDINPROJECT INTEGER );
INSERT INTO ZENABLEDOUTPUTRECIPE VALUES(28,1,'TIFF - Adobe RGB (1998) (8bit)',1);
CREATE TABLE ZKEYWORD ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZNAME VARCHAR, ZPARENT INTEGER, ZLEFT INTEGER UNIQUE, ZRIGHT INTEGER UNIQUE,
ZISEXPORTABLE BOOLEAN, ZDESCRIPTION VARCHAR, FOREIGN KEY(ZPARENT) REFERENCES ZKEYWORD(Z_PK), UNIQUE (ZNAME, ZPARENT), CHECK (ZLEFT < ZRIGHT), CHECK( Z_ENT IN (44, 45)) );
CREATE TABLE ZIMAGE ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZAUTHOR VARCHAR, ZIMAGEUUID VARCHAR, ZINDEX INTEGER, ZRAWMETADATAMODIFICATIONDATE FLOAT, ZSETTINGSMODIFICATIONDATE FLOAT, ZVERSION INTEGER, ZXMPMETADATAMODIFICATIONDATE FLOAT, ZIMPORTDATE FLOAT, ZSIDECARPATH VARCHAR, ZBITMAPHASH VARCHAR, ZDISPLAYNAME VARCHAR, ZISINSIDECATALOG BOOLEAN, ZIMAGELOCATION INTEGER, ZIMAGEFILENAME VARCHAR, ZIMAGECLASSIFICATION INTEGER, ZISTRASHED BOOLEAN, ZWIDTH INTEGER, ZHEIGHT INTEGER, ZEXP_DRIVEMODE INTEGER, ZEXP_FOCALLENGTH FLOAT, ZEXP_EXPOSUREPROG INTEGER, ZEXP_FLASHMODE INTEGER, ZEXP_WHITEBALANCE INTEGER, ZEXP_METERINGMODE INTEGER, ZEXP_EXPOSURECOMPENSATION VARCHAR, ZEXP_FORMAT VARCHAR, ZEXP_FLASHCOMPENSATION VARCHAR, ZEXP_COLORSPACE VARCHAR, ZEXP_APERTURE FLOAT, ZEXP_SHUTTERSPEED FLOAT, ZEXP_EXPOSUREMODE INTEGER, ZEXP_DATE FLOAT, ZCAMERA_SOFTWARE VARCHAR, ZCAMERA_SERIAL VARCHAR, ZCAMERA_FIRMWARE VARCHAR, ZCAMERA_MODEL VARCHAR, ZCAMERA_MAKE VARCHAR, ZCAMERA_OWNER VARCHAR, ZCAMERA_LENS VARCHAR, ZFILE_SIZE INTEGER, ZPIXELWIDTH FLOAT, ZPIXELHEIGHT FLOAT, ZCAMERADISPLAYNAME VARCHAR, ZISO INTEGER, ZMULTISHOT_SEQUENCEID VARCHAR, ZMULTISHOT_TYPE INTEGER, ZMULTISHOT_COUNT INTEGER, ZMULTISHOT_TOTAL INTEGER, ZGPSALTITUDE VARCHAR, ZGPSLATITUDE VARCHAR, ZGPSLONGITUDE VARCHAR, ZRAWFILEFULLHASH VARCHAR, ZRAWFILEQUICKHASH VARCHAR, ZRAWFILEHASHDATE FLOAT);
CREATE TABLE ZIMAGEINCOLLECTIONPROPERTIES ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZCOLLECTION INTEGER, ZIMAGE INTEGER, ZCOLLAPSED BOOLEAN, ZMANUALSORTINDEX INTEGER );
CREATE TABLE ZPATHLOCATION ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZWINROOT VARCHAR, ZMACROOT VARCHAR, ZRELATIVEPATH VARCHAR, ZISRELATIVE BOOLEAN, ZVOLUME VARCHAR, ZWINATTRIBUTE VARCHAR );
INSERT INTO ZPATHLOCATION VALUES(38,1,'','','Capture',1,'','');
INSERT INTO ZPATHLOCATION VALUES(38,2,'','','Output',1,'','');
INSERT INTO ZPATHLOCATION VALUES(38,3,'','','Trash',1,'','');
INSERT INTO ZPATHLOCATION VALUES(38,4,'','','Selects',1,'','');
CREATE TABLE ZPROCESSHISTORY ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZDATE FLOAT, ZURL VARCHAR, ZVARIANT INTEGER );
CREATE TABLE ZSELECTEDVARIANTS ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZSELECTEDINCOLLECTIONS INTEGER, ZSELECTEDVARIANTS INTEGER );
CREATE TABLE ZSIDECAR ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZNAME VARCHAR, ZDISPLAYNAME VARCHAR, ZTYPE INTEGER, ZFILEHASH VARCHAR );
CREATE TABLE ZSTACK ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZINDEX INTEGER, ZOUTLINE VARCHAR, ZSORTORDER VARCHAR, ZCOLLECTION INTEGER, ZPICKEDIMAGE INTEGER );
CREATE TABLE ZSTACKIMAGELINK ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZINDEX INTEGER, ZIMAGE INTEGER, ZSTACK INTEGER );
CREATE TABLE ZVARIANT ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZINDEX INTEGER, ZLASTMETADATAMODIFICATIONDATE FLOAT, ZRAWMETADATAMODIFICATIONDATE FLOAT, ZVARIANTUUID VARCHAR, ZXMPMETADATAMODIFICATIONDATE FLOAT, ZADJUSTMENTLAYER INTEGER, ZCOMBINEDSETTINGS INTEGER, ZDEFAULTLAYER INTEGER, ZIMAGE INTEGER,
ZISMODIFIED BOOLEAN, ZCANVASSIZE VARCHAR, ZPROCESSINGENGINE INTEGER, ZHIGHRESPROCESSCOUNTER INTEGER, ZLOWRESPROCESSCOUNTER INTEGER, ZSYNCPROCESSCOUNTER INTEGER, ZPRODUCTID VARCHAR, ZANNOTATION VARCHAR, ZOFFLINEPROPERTIES VARCHAR );
CREATE TABLE ZVARIANTLAYER ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZINDEX INTEGER, ZMETADATA INTEGER, ZVARIANT INTEGER, ZBRIGHTNESS FLOAT, ZBWBLUE FLOAT, ZBWCYAN FLOAT, ZBWDARKTONEHUE FLOAT, ZBWDARKTONESATURATION FLOAT, ZBWENABLED BOOLEAN, ZBWGREEN FLOAT, ZBWLIGHTTONEHUE FLOAT, ZBWLIGHTTONESATURATION FLOAT, ZBWMAGENTA FLOAT, ZBWRED FLOAT, ZBWYELLOW FLOAT, ZCANVASSIZE VARCHAR, ZCLARITY FLOAT, ZCLARITYMETHOD INTEGER, ZCLARITYSTRUCTURE FLOAT, ZCLEANLONGEXPOSUREAMOUNT FLOAT, ZCNRAMOUNT FLOAT, ZCOLORBALANCE VARCHAR, ZCOLORCORRECTIONS VARCHAR, ZCONTRAST FLOAT, ZCORRESPONDINGPOINTS VARCHAR, ZCROP VARCHAR, ZCROPOUTSIDEIMAGE BOOLEAN, ZENABLED BOOLEAN, ZEXPOSURE FLOAT, ZFILMCURVE VARCHAR, ZFINEGRAINAMOUNT FLOAT, ZGEOMETRYCANVASCLIPPING INTEGER, ZGEOMETRYKEYSTONEAMOUNT FLOAT, ZGEOMETRYKEYSTONEASPECT FLOAT, ZGEOMETRYKEYSTONEFOCALLENGTH FLOAT, ZGEOMETRYKEYSTONETILTX FLOAT, ZGEOMETRYKEYSTONETILTY FLOAT, ZGRADATIONCURVE VARCHAR, ZGRADATIONCURVEBLUE VARCHAR, ZGRADATIONCURVEGREEN VARCHAR, ZGRADATIONCURVERED VARCHAR, ZHIGHLIGHTRECOVERY FLOAT, ZIMAGEDIMENSIONS VARCHAR, ZLENSAPERTURE FLOAT, ZLENSCHROMABRENABLED BOOLEAN, ZLENSCHROMABRORIGIN INTEGER, ZLENSCOLORCASTENABLED BOOLEAN, ZLENSCUSTOMCHROMABR VARCHAR, ZLENSCUSTOMCHROMABRNAME VARCHAR, ZLENSDEFAULTCHROMABR VARCHAR, ZLENSDISTORTION VARCHAR, ZLENSDUSTREMOVALENABLED BOOLEAN, ZLENSFOCALLENGTH FLOAT, ZLENSLCCLIGHTFALLOFF BOOLEAN, ZLENSLIGHTFALLOFF VARCHAR, ZLENSLCCLIGHTFALLOFFAMOUNT FLOAT, ZLENSLCCBITMAPHASH VARCHAR, ZLENSOPTICCENTER VARCHAR, ZLENSOPTICCENTERENABLED BOOLEAN, ZLENSIDGUID VARCHAR, ZLENSREVISIONIDGUID VARCHAR, ZLENSPURPLEFRINGINGAMOUNT FLOAT, ZLENSRADIALBLUR VARCHAR, ZLENSSHIFT FLOAT, ZLENSSHIFTDIRECTION FLOAT, ZLENSTILT FLOAT, ZLENSTILTDIRECTION FLOAT, ZLENSVIGNETTING VARCHAR, ZLEVELSHIGHLIGHT VARCHAR, ZLEVELSSHADOW VARCHAR, ZLEVELSTARGETENABLE BOOLEAN, ZLEVELSTARGETHIGHLIGHT VARCHAR, ZLEVELSTARGETSHADOW VARCHAR, ZMASKUUID VARCHAR, ZMIDTONE VARCHAR, ZMOIRE VARCHAR, ZNAME VARCHAR, ZNOISEREDUCTIONAMOUNT FLOAT, ZRELATIVEDUST VARCHAR, ZRELATIVESPOTS VARCHAR, ZROTATION FLOAT, ZSATURATION FLOAT, ZSHADOWRECOVERY FLOAT, ZSPOTS VARCHAR, ZSTYLEMODIFIED BOOLEAN, ZSTYLESOURCE VARCHAR, ZSTYLEUUID VARCHAR, ZSURFACESMOOTHNESSAMOUNT FLOAT, ZUSMAMOUNT FLOAT, ZUSMRADIUS FLOAT, ZUSMTHRESHOLD FLOAT, ZWHITEBALANCE VARCHAR, ZICCPROFILE VARCHAR, ZLENSLCC VARCHAR, ZLENSSHIFTXY VARCHAR, ZLENSCHROMAFRINGING VARCHAR, ZFLIP INTEGER, ZNOISEDETAILSAMOUNT
FLOAT, ZLAYERSELECTPOINT VARCHAR, ZFILMGRAINAMOUNT FLOAT, ZFILMGRAINDENSITY FLOAT, ZFILMGRAINGRANULARITY FLOAT, ZFILMGRAINTYPE INTEGER, ZTECHNICALPROCESSINGMETHOD INTEGER, ZCOLORBALANCESHADOW VARCHAR, ZCOLORBALANCEMIDTONE VARCHAR, ZCOLORBALANCEHIGHLIGHT VARCHAR, ZGRADATIONCURVEY VARCHAR, ZLENSDIFFRACTIONCORRECTIONENABLED BOOLEAN, ZUSMMETHOD INTEGER, ZUSMHALOCONTROL FLOAT, ZOPACITY FLOAT, ZWHITERECOVERY FLOAT, ZBLACKRECOVERY FLOAT );
CREATE TABLE ZVARIANTMETADATA ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZLAYER INTEGER, ZBASIC_RATING INTEGER, ZBASIC_LABEL VARCHAR, ZCONTACT_CREATOR VARCHAR, ZCONTACT_EMAILS VARCHAR, ZCONTACT_PHONES VARCHAR, ZCONTACT_POSTALCODE VARCHAR, ZCONTACT_WEBSITES VARCHAR, ZCONTACT_ADDRESS VARCHAR, ZCONTACT_CITY VARCHAR, ZCONTACT_COUNTRY VARCHAR, ZCONTACT_CREATORSTITLE VARCHAR, ZCONTENT_SUBJECTCODE VARCHAR, ZCONTENT_DESCRIPTIONWRITER VARCHAR, ZCONTENT_HEADLINE VARCHAR, ZCONTENT_DESCRIPTION VARCHAR, ZCONTENT_KEYWORDS VARCHAR, ZCONTACT_STATE_PROVINCE VARCHAR, ZIMAGE_CITY VARCHAR, ZIMAGE_LOCATION VARCHAR, ZIMAGE_INTELLECTUALGENRE VARCHAR,
ZIMAGE_DATECREATED VARCHAR, ZIMAGE_ISOCOUNTRYCODE VARCHAR, ZIMAGE_SCENE VARCHAR, ZIMAGE_STATE VARCHAR, ZSTATUS_SOURCE VARCHAR, ZSTATUS_USAGETERMS VARCHAR, ZSTATUS_JOBIDENTIFIER VARCHAR, ZSTATUS_PROVIDER VARCHAR, ZSTATUS_INSTRUCTIONS VARCHAR, ZSTATUS_COPYRIGHTNOTICE VARCHAR, ZSTATUS_TITLE VARCHAR, ZCOLOR_TAG_INDEX INTEGER,
ZCONTENT_CATEGORY VARCHAR, ZCONTENT_SUPPLEMENTALCATEGORIES VARCHAR, ZIMAGE_COUNTRY VARCHAR, ZGETTY_PARENTMEID VARCHAR, ZGETTY_ORIGINALFILENAME VARCHAR, ZGETTY_PERSONALITY VARCHAR );
CREATE TABLE ZDOCUMENTSETTING ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, ZSETTINGKEY VARCHAR UNIQUE, ZSETTINGVALUE VARCHAR );
CREATE INDEX ZCOLLECTION_ZCOMPAREVARIANT_INDEX ON ZCOLLECTION (ZCOMPAREVARIANT);
CREATE INDEX ZCOLLECTION_ZDOCUMENT_INDEX ON ZCOLLECTION (ZDOCUMENT);
CREATE INDEX ZCOLLECTION_ZPRIMARYVARIANT_INDEX ON ZCOLLECTION (ZPRIMARYVARIANT);
CREATE INDEX ZIMAGEINDEX_ZIMAGE_INDEX ON ZSTACKIMAGELINK (ZIMAGE);
CREATE INDEX ZIMAGEINDEX_ZSTACK_INDEX ON ZSTACKIMAGELINK (ZSTACK);
CREATE INDEX ZIMAGE_ISINSIDECATALOG_INDEX ON ZIMAGE (ZISINSIDECATALOG);
CREATE INDEX ZKEYWORD_ZLEFT_INDEX ON ZKEYWORD (ZLEFT);
CREATE INDEX ZPROCESSHISTORY_VARIANT_INDEX ON ZPROCESSHISTORY (ZVARIANT);
CREATE INDEX ZSELECTEDVARIANTS_ZSELECTEDINCOLLECTIONS_INDEX ON ZSELECTEDVARIANTS (ZSELECTEDINCOLLECTIONS);
CREATE INDEX ZSELECTEDVARIANTS_ZSELECTEDVARIANTS_INDEX ON ZSELECTEDVARIANTS (ZSELECTEDVARIANTS);
CREATE INDEX ZSIDECAR_ZHASH_INDEX ON ZSIDECAR (ZFILEHASH);
CREATE INDEX ZSTACK_ZCOLLECTION_INDEX ON ZSTACK (ZCOLLECTION);
CREATE INDEX ZSTACK_ZPICKEDIMAGE_INDEX ON ZSTACK (ZPICKEDIMAGE);
CREATE INDEX ZVARIANTLAYER_METADATA_INDEX ON ZVARIANTLAYER (ZMETADATA);
CREATE INDEX ZVARIANTLAYER_VARIANT_INDEX ON ZVARIANTLAYER (ZVARIANT);
CREATE INDEX ZVARIANT_ADJUSTMENTSLAYER_INDEX ON ZVARIANT (ZADJUSTMENTLAYER);
CREATE INDEX ZVARIANT_DEFAULTLAYER_INDEX ON ZVARIANT (ZDEFAULTLAYER);
CREATE INDEX ZVARIANT_ZCOMBINEDSETTINGS_INDEX ON ZVARIANT (ZCOMBINEDSETTINGS);
CREATE INDEX ZVARIANT_ZIMAGE_INDEX ON ZVARIANT (ZIMAGE);
CREATE INDEX ZVARIANTMETADATA_ZLAYER_INDEX ON ZVARIANTMETADATA (ZLAYER);
CREATE INDEX ZDOCUMENTSETTING_INDEX ON ZDOCUMENTSETTING (ZSETTINGKEY);0 -
Thanks. I'm a Windows users, so I'll rewrite this with Powershell. But this saves me hours I'm sure.
1 -
@John Stefanko did you ever get to rewrite for windows? I just found this and would save me having to reinvent the wheel if you have and would share :D
Neil
0
投稿コメントは受け付けていません。
コメント
6件のコメント