ATTACH "old.cdb" AS old;
INSERT INTO datas SELECT old.datas.id,old.datas.ot,old.datas.alias,old.datas.setcode,old.datas.type,old.datas.atk,old.datas.def,old.datas.level,old.datas.race,old.datas.attribute,old.datas.category FROM old.datas LEFT JOIN datas ON main.datas.id=old.datas.id WHERE main.datas.id IS NULL;
INSERT INTO texts SELECT old.texts.id,old.texts.name,old.texts.desc,old.texts.str1,old.texts.str2,old.texts.str3,old.texts.str4,old.texts.str5,old.texts.str6,old.texts.str7,old.texts.str8,old.texts.str9,old.texts.str10,old.texts.str11,old.texts.str12,old.texts.str13,old.texts.str14,old.texts.str15,old.texts.str16 FROM old.texts LEFT JOIN texts ON main.texts.id=old.texts.id WHERE main.texts.id IS NULL;
First, when you get a new ygopro version, rename your old card.cdb file to "old.cdb"
Then save the above query to a file called "insert.sql", and save it to your ygopro folder, then create another file called "addcards.bat" with the following contents and save it to your ygopro folder.
sqlite3 cards.cdb ".read insert.sql"
and place the file in your ygopro folder.
Finally, move the new ygopro files into the folder, then run addcards.bat.