07.03.2014, 12:16
Code:
CREATE TABLE geolocation ( locId INTEGER PRIMARY KEY, city TEXT, time_zone TEXT ); CREATE TABLE [blocks] ( [locId] INTEGER REFERENCES [geolocation]([locId]), [latitude] CHAR(30), [longitude] CHAR(30), [is_anonymous_proxy] NUMERIC, [startIpNum] NUMERIC, [endIpNum] NUMERIC, idx INTEGER); CREATE INDEX geoidx ON geoblocks(idx);
anyway, you don't really have to worry about it if you don't want to, as I said it works fine if I don't use your include.