PRAGMA USER_VERSION=101;
PRAGMA JOURNAL_MODE=WAL;

DROP TABLE SQLT;

CREATE TABLE SQLT (SQLTID TEXT COLLATE NOCASE UNIQUE,
                   SQLTQUERY TEXT,
                   DATEADDED TEXT DEFAULT (DATETIME('NOW')));

INSERT INTO SQLT (SQLTID,SQLTQUERY)
 VALUES ('TLDS','SELECT TLDSID, DATEADDED FROM TLDS %WHERE1 ORDER BY TLDSID;');

DROP VIEW TLDS;
DROP TABLE TLDSUTC;

BEGIN IMMEDIATE TRANSACTION;

CREATE TABLE TLDSUTC (TLDSID TEXT COLLATE NOCASE UNIQUE,
                      DATEADDED TEXT DEFAULT (DATETIME('NOW')));

INSERT INTO TLDSUTC (TLDSID) VALUES ('ABOGADO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ACADEMY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ACCOUNTANTS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ACTIVE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ACTOR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ADULT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AERO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AF');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AGENCY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AIRFORCE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ALLFINANZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ALSACE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ANDROID');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AQ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AQUARELLE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ARCHI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ARMY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ARPA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ASIA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ASSOCIATES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ATTORNEY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AUCTION');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AUDIO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AUTOS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AX');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AXA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('AZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BAND');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BAR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BARGAINS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BAYERN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BB');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BEER');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BERLIN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BEST');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BF');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BID');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BIKE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BIO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BIZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BJ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BLACK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BLACKFRIDAY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BLOOMBERG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BLUE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BMW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BNPPARIBAS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BOO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BOUTIQUE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BRUSSELS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BUDAPEST');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BUILD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BUILDERS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BUSINESS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BUZZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BV');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('BZH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CAB');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CAL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CAMERA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CAMP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CANCERRESEARCH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CAPETOWN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CAPITAL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CARAVAN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CARDS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CARE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CAREER');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CAREERS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CARTIER');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CASA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CASH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CAT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CATERING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CENTER');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CEO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CERN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CF');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CHANNEL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CHEAP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CHRISTMAS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CHROME');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CHURCH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CITIC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CITY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CLAIMS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CLEANING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CLICK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CLINIC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CLOTHING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CLUB');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('COACH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CODES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('COFFEE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('COLLEGE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('COLOGNE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('COM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('COMMUNITY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('COMPANY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('COMPUTER');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CONDOS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CONSTRUCTION');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CONSULTING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CONTRACTORS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('COOKING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('COOL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('COOP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('COUNTRY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CREDIT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CREDITCARD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CRICKET');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CRS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CRUISES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CUISINELLA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CV');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CX');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CYMRU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('CZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DAD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DANCE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DATING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DAY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DEALS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DEGREE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DELIVERY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DEMOCRAT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DENTAL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DENTIST');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DESI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DEV');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DIAMONDS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DIET');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DIGITAL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DIRECT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DIRECTORY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DISCOUNT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DJ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DNP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DOCS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DOMAINS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DOOSAN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DURBAN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DVAG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('DZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EAT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EDU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EDUCATION');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EMAIL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EMERCK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ENERGY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ENGINEER');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ENGINEERING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ENTERPRISES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EQUIPMENT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ER');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ESQ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ESTATE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ET');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EUROVISION');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EUS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EVENTS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EVERBANK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EXCHANGE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EXPERT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('EXPOSED');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FAIL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FARM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FASHION');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FEEDBACK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FINANCE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FINANCIAL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FIRMDALE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FISH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FISHING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FITNESS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FJ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FLIGHTS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FLORIST');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FLSMIDTH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FLY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FOO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FORSALE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FOUNDATION');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FRL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FROGANS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FUND');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FURNITURE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('FUTBOL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GAL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GALLERY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GARDEN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GB');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GBIZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GENT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GF');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GIFT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GIFTS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GIVES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GLASS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GLE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GLOBAL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GLOBO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GMAIL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GMO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GMX');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GOOGLE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GOP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GOV');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GQ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GRAPHICS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GRATIS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GREEN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GRIPE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GUIDE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GUITARS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GURU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('GY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HAMBURG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HAUS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HEALTHCARE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HELP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HERE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HIPHOP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HIV');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HOLDINGS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HOLIDAY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HOMES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HORSE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HOST');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HOSTING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HOUSE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HOW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('HU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IBM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ID');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IMMO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IMMOBILIEN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('INDUSTRIES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('INFO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('INK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('INSTITUTE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('INSURE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('INT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('INTERNATIONAL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('INVESTMENTS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IQ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IRISH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('IWC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('JE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('JETZT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('JM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('JO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('JOBS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('JOBURG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('JP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('JUEGOS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KAUFEN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KIM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KITCHEN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KIWI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KOELN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KRD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KRED');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('KZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LACAIXA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LAND');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LATROBE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LAWYER');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LB');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LDS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LEASE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LEGAL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LGBT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LIDL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LIFE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LIGHTING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LIMITED');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LIMO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LINK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LOANS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LONDON');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LOTTO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LTDA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LUXE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LUXURY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LV');
INSERT INTO TLDSUTC (TLDSID) VALUES ('LY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MADRID');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MAISON');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MANAGEMENT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MANGO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MARKET');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MARKETING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ME');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MEDIA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MEET');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MELBOURNE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MEME');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MEMORIAL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MENU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MIAMI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MIL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MINI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ML');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MOBI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MODA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MOE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MONASH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MONEY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MORMON');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MORTGAGE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MOSCOW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MOTORCYCLES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MOV');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MQ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MUSEUM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MV');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MX');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('MZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NAGOYA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NAME');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NAVY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NET');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NETWORK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NEUSTAR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NEW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NEXUS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NF');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NGO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NHK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NINJA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NRA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NRW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NYC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('NZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('OKINAWA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('OM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ONG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ONL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('OOO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ORG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ORGANIC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('OSAKA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('OTSUKA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('OVH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PARIS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PARTNERS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PARTS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PARTY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PF');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PHARMACY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PHOTO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PHOTOGRAPHY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PHOTOS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PHYSIO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PICS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PICTURES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PINK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PIZZA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PLACE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PLUMBING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('POHL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('POKER');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PORN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('POST');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PRAXI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PRESS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PRO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PROD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PRODUCTIONS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PROF');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PROPERTIES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PROPERTY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PUB');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('PY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('QA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('QPON');
INSERT INTO TLDSUTC (TLDSID) VALUES ('QUEBEC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('REALTOR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RECIPES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RED');
INSERT INTO TLDSUTC (TLDSID) VALUES ('REHAB');
INSERT INTO TLDSUTC (TLDSID) VALUES ('REISE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('REISEN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('REIT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('REN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RENTALS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('REPAIR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('REPORT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('REPUBLICAN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('REST');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RESTAURANT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('REVIEWS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RICH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RIO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RIP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ROCKS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RODEO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RSVP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RUHR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('RYUKYU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SAARLAND');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SAMSUNG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SARL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SB');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SCA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SCB');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SCHMIDT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SCHULE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SCHWARZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SCIENCE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SCOT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SERVICES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SEW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SEXY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SHIKSHA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SHOES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SINGLES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SJ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SKY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SOCIAL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SOFTWARE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SOHU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SOLAR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SOLUTIONS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SOY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SPACE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SPIEGEL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ST');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SUPPLIES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SUPPLY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SUPPORT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SURF');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SURGERY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SUZUKI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SV');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SX');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SYDNEY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SYSTEMS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('SZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TAIPEI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TATAR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TATTOO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TAX');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TECHNOLOGY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TEL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TF');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TIENDA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TIPS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TIRES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TIROL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TJ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TODAY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TOKYO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TOOLS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TOP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TOWN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TOYS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TR');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TRADE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TRAINING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TRAVEL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TRUST');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TUI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TV');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TW');
INSERT INTO TLDSUTC (TLDSID) VALUES ('TZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('UA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('UG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('UK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('UNIVERSITY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('UNO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('UOL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('US');
INSERT INTO TLDSUTC (TLDSID) VALUES ('UY');
INSERT INTO TLDSUTC (TLDSID) VALUES ('UZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VACATIONS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VEGAS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VENTURES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VERSICHERUNG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VET');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VIAJES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VILLAS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VISION');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VLAANDEREN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VODKA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VOTE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VOTING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VOTO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VOYAGE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('VU');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WALES');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WANG');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WATCH');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WEBCAM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WEBSITE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WED');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WEDDING');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WF');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WHOSWHO');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WIEN');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WIKI');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WILLIAMHILL');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WME');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WORK');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WORKS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WORLD');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WTC');
INSERT INTO TLDSUTC (TLDSID) VALUES ('WTF');
INSERT INTO TLDSUTC (TLDSID) VALUES ('XXX');
INSERT INTO TLDSUTC (TLDSID) VALUES ('XYZ');
INSERT INTO TLDSUTC (TLDSID) VALUES ('YACHTS');
INSERT INTO TLDSUTC (TLDSID) VALUES ('YANDEX');
INSERT INTO TLDSUTC (TLDSID) VALUES ('YE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('YOGA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('YOKOHAMA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('YOUTUBE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('YT');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ZA');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ZIP');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ZM');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ZONE');
INSERT INTO TLDSUTC (TLDSID) VALUES ('ZW');


CREATE INDEX TLDSUTC_TLDSID_INDEX ON TLDSUTC (TLDSID);

CREATE VIEW TLDS AS

SELECT TLDSID, DATETIME(DATEADDED,'localtime') AS DATEADDED FROM TLDSUTC; 

COMMIT;

ANALYZE;

VACUUM;




