#!/bin/sh
echo Removing Palm Profile contacts...

cat >/tmp/tmpDelete.sql <<EOF
.load /usr/lib/sqlite3_palm_extension.so
delete from com_palm_pim_Person where id in (select com_palm_pim_Person_id from com_palm_pim_Contact where syncSource='local');
delete from com_palm_pim_Contact where syncSource='local';
.quit
EOF

sqlite3 /var/luna/data/dbdata/PalmDatabase.db3 </tmp/tmpDelete.sql
rm /tmp/tmpDelete.sql

echo Done!