Denny Huang => YSITD: sed \ -e '/PRAGMA.*;/ d' \ -e '/BEGIN TRANSACTION.*/ d' \ -e '/COMMIT;/ d' \ -e '/.*sqlite_sequence.*;/d' \ -e 's/"/`/g' \ -e 's/CREATE TABLE $`\w\+`$/DROP TABLE IF EXISTS \1;\nCREATE TABLE \1/' \ -e 's/$CREATE TABLE.*$$PRIMARY KEY$ $AUTOINCREMENT$$.*$$);$/\1AUTO_INCREMENT\4, PRIMARY KEY(id)\5/' \ -e "s/'t'/1/g" \ -e "s/'f'/0/g" \ $1 #56c69b89dd580c0b40927fd7

Denny Huang says to YSITD

sed \ -e '/PRAGMA.*;/ d' \ -e '/BEGIN TRANSACTION.*/ d' \ -e '/COMMIT;/ d' \ -e '/.*sqlite_sequence.*;/d' \ -e 's/"/`/g' \ -e 's/CREATE TABLE $`\w\+`$/DROP TABLE IF EXISTS \1;\nCREATE TABLE \1/' \ -e 's/$CREATE TABLE.*$$PRIMARY KEY$ $AUTOINCREMENT$$.*$$);$/\1AUTO_INCREMENT\4, PRIMARY KEY(id)\5/' \ -e "s/'t'/1/g" \ -e "s/'f'/0/g" \ $1

at Fri, Feb 19, 2016 12:35 PM