.dump rules
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE rules ( rule_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT COLLATE NOCASE, provider TEXT COLLATE NOCASE NOT NULL, sequence INTEGER NOT NULL, state INTEGER NOT NULL, level INTEGER, user_flags INTEGER, provider_data BLOB, condition BLOB NOT NULL, actions BLOB NOT NULL, folder_id INTEGER NOT NULL, FOREIGN KEY (folder_id) REFERENCES folders (folder_id) ON DELETE CASCADE ON UPDATE CASCADE);
INSERT INTO rules VALUES(1,'[bheam@xxx]','RuleOrganizer',18,17,0,NULL,X'0100000001000000c1166cc1b003e640',X'03010001001f0037001f0037005b626865616d406f6e6c696e652e6e6f5d00',X'010024000100000000000000000101000015000101000000001d0008000000000000000000000000',13);
INSERT INTO rules VALUES(8,'[bheam@xxx] SPAM','RuleOrganizer',11,17,0,NULL,X'0100000008000000c1166cc1b003e640',X'00020003010001001f0037001f0037005b626865616d406f6e6c696e652e6e6f5d0001020003010001001f0000101f0000104c6f6e6720507261697269652052640003010001001f0000101f000010536f7574682054686972642053747265657400',X'010024000100000000000000000101000015000101000000002e9042000000000000000000000000',13);
COMMIT;