A tech joke is never too far away, perhaps the person that coded this was pretty pissed at the time …
Seen in the wild
Warning: SQLiteDatabase::queryExec(): near “FUCKYOU”: syntax error in /opt/strac/debug_test.php on line 666
Creating this table is not allowed
CREATE TABLE Event_Staging_all (
record_id INTEGER PRIMARY KEY,
com_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
gps_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
imei BIGINT(20) NOT NULL,
switch UNSIGNED INT(3) NOT NULL,
event_id UNSIGNED INT(5) NOT NULL,
latitude UNSIGNED INT(10) NOT NULL,
longitude UNSIGNED INT(10) NOT NULL,
IO UNSIGNED INT(3) NOT NULL,
raw_data BLOB NOT NULL,
sys_parsed INT(3) DEFAULT NULL,
UNIQUE (imei,raw_data) ON CONFLICT FUCKYOU
);
record_id INTEGER PRIMARY KEY,
com_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
gps_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
imei BIGINT(20) NOT NULL,
switch UNSIGNED INT(3) NOT NULL,
event_id UNSIGNED INT(5) NOT NULL,
latitude UNSIGNED INT(10) NOT NULL,
longitude UNSIGNED INT(10) NOT NULL,
IO UNSIGNED INT(3) NOT NULL,
raw_data BLOB NOT NULL,
sys_parsed INT(3) DEFAULT NULL,
UNIQUE (imei,raw_data) ON CONFLICT FUCKYOU
);
I tried to IGNORE this from now on instead. Much better now. Zen.