BEGIN TRANSACTION;
CREATE TABLE _SqliteDatabaseProperties (key TEXT, value TEXT, UNIQUE(key));
INSERT INTO "_SqliteDatabaseProperties" VALUES('_ClientVersion','2');
CREATE TABLE message (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, address TEXT, date INTEGER, text TEXT, flags INTEGER, replace INTEGER, svc_center TEXT);
INSERT INTO "message" VALUES(1,'16302175872',1231024001,'Hey',2,0,NULL);
INSERT INTO "message" VALUES(2,'16302175872',1231024076,'Reply: Hey',3,0,NULL);
INSERT INTO "message" VALUES(3,'16302175872',1231024111,'Third message tests how punctuation impacts the parsing of a message with a phone number 5123725891, URL wap.yahoo.com, and email bill.rosenberg@cingular.com.',3,0,NULL);
INSERT INTO "message" VALUES(4,'16302175872',1231024151,'This is a GSM SMS message with embedded phone numbers (512)372-5891 and a URL http://wap.yahoo.com with +15126741000 too.',3,0,NULL);
INSERT INTO "message" VALUES(5,'16302175872',1231024946,'Second test with some LF characters added before the number
5123725891 and after the URL wap.google.com
with +1(512)674-1000 and wap.yahoo.com also',3,0,NULL);
INSERT INTO "message" VALUES(6,'16302175872',1231024951,'Fourth is another punctuation test with an embedded phone number (5126741000), URL <http://wap.yahoo.com>, and email <bill.rosenberg@cingular.com> again.',3,0,NULL);
INSERT INTO "message" VALUES(7,'16302175872',1231024954,'Apple was founded on April 1, 1976 by Steve Jobs, Steve Wozniak and Ronald Wayne to sell the Apple I personal computer. They were hand-built in the garage of Jobs'' parents, and the Apple I was first shown to the public at the Homebrew Computer Club. The Apple I was sold as a motherboard, not what is today considered a complete personal compute. The user was required to provide two different AC input voltages (the manual recommended specific transformers), wire an ASCII keyboard (not provided with the computer) to a DIP connector (providing logic inverter and alpha lock chips in some cases), and to wire the video output pins to a monitor or to an RF modulator if a TV set was used. Their website is www.apple.com. Random email address: abc123@abc123.com.',3,0,NULL);
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('message',7);
COMMIT;
