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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | 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 ); |
I tried to IGNORE this from now on instead. Much better now. Zen.