agnes/mourningdove
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions 3
mourningdove/bin/upgrading/base-data.sql
aggie 929b0e3cf7 first!
2026-05-24 01:03:05 +00:00

401 lines
53 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

# This file is no longer automatically generated by $LJHOME/bin/dumpsql.pl
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#000000', 'Black', '210', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#0000FF', 'Blue, Bright', '150', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#00025C', 'Blue, Midnight', '140', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#002400', 'Green, Pine', '85', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#00EEC4', 'Green, Mint', '110', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#00FF00', 'Green, Bright', '100', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#00FFFF', 'Blue, Sky', '130', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#01059D', 'Blue, Navy', '145', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#015B01', 'Green, Dark', '90', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#019501', 'Green', '95', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#019997', 'Blue, Ocean', '125', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#066D98', 'Blue, Steel', '120', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#330000', ' Brown, Dark', '30', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#520155', 'Purple, Wine', '185', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#5B0101', 'Red, Darkest', '5', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#6569FF', 'Blue, Medium', '155', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#676767', 'Gray, Dark', '215', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#696A0A', 'Olive', '65', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#88FEE9', 'Green, Aqua', '115', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#8E01D7', 'Violet, Dark', '170', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#993300', ' Brown', '35', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#9E0000', 'Red, Dark', '10', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#A501A7', 'Purple', '190', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#ADB1FF', 'Blue, Light', '160', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#B0B200', 'Yellow, Dark', '70', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#B3FFB3', 'Green, Light', '105', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#BBFFFE', 'Blue, Light Sky', '135', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#BC5D00', 'Orange, Brown', '45', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#C0C0C0', 'Gray, Light', '220', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#CA65FF', 'Violet', '175', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#CC9966', ' Brown, Tan', '40', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#E3E5FF', 'Blue, Powder', '165', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#EFCFFF', 'Violet, Light', '180', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#F999FF', 'Purple, Pink', '200', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#FCDDFF', 'Pink, Ice', '205', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#FEFFBB', 'Yellow, Light', '80', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#FF0000', 'Red', '15', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#FF00FF', 'Purple, Fuchsia', '195', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#FF6600', 'Orange, Bright', '50', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#FF8B8B', 'Red, Light', '20', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#FFB22B', 'Orange', '55', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#FFCBCB', 'Red, Pink', '25', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#FFE2A3', 'Orange, Light', '60', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#FFFF00', 'Yellow', '75', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('#FFFFFF', 'White', '225', 'color');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('0', 'None', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('0', 'none', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('01', 'Агинский Бурятский автономный округ', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('02', 'Адыгея Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('03', 'Алтай Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('04', 'Алтайский край', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('05', 'Амурская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('06', 'Архангельская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('07', 'Астраханская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('08', 'Башкортостан Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('09', 'Белгородская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('1', 'Western European (Windows)', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('1', 'windows-1252', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('10', 'Western European (ISO)', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('10', 'iso-8859-1', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('10', 'Брянская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('11', 'CP949', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('11', 'Korean (Windows)', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('11', 'Бурятия Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('12', 'Chinese (Simplified)', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('12', 'GB2312', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('12', 'Владимирская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('13', 'Волгоградская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('14', 'Вологодская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('15', 'Воронежская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('16', 'Дагестан Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('17', 'Еврейская автономная область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('18', 'Ивановская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('19', 'Ингушская Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('2', 'UTF-8', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('2', 'Unicode (UTF-8)', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('20', 'Иркутская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('21', 'Кабардино-Балкарская Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('22', 'Калининградская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('23', 'Калмыкия Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('24', 'Калужская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('25', 'Камчатский край', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('26', 'Карачаево-Черкесская Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('27', 'Карелия Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('28', 'Кемеровская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('29', 'Кировская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('3', 'Cyrillic (Windows)', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('3', 'windows-1251', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('30', 'Коми Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('31', 'Костромская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('32', 'Краснодарский край', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('33', 'Красноярский край', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('34', 'Курганская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('35', 'Курская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('36', 'Ленинградская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('37', 'Липецкая область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('38', 'Магаданская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('39', 'Марий Эл Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('4', 'Hebrew (ISO)', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('4', 'hebrew', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('40', 'Мордовия Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('41', 'Москва', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('42', 'Московская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('43', 'Мурманская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('44', 'Ненецкий автономный округ', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('45', 'Нижегородская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('46', 'Новгородская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('47', 'Новосибирская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('48', 'Омская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('49', 'Оренбургская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('5', 'Greek', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('5', 'windows-1253', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('50', 'Орловская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('51', 'Пензенская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('52', 'Пермский край', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('53', 'Приморский край', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('54', 'Псковская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('55', 'Ростовская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('56', 'Рязанская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('57', 'Самарская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('58', 'Санкт-Петербург', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('59', 'Саратовская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('6', 'Cyrillic (KOI8)', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('6', 'KOI8-R', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('60', 'Саха (Якутия) Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('61', 'Сахалинская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('62', 'Свердловская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('63', 'Северная Осетия - Алания Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('64', 'Смоленская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('65', 'Ставропольский край', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('66', 'Тамбовская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('67', 'Татарстан Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('68', 'Тверская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('69', 'Томская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('7', 'Japanese (SHIFT-JIS)', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('7', 'sjis', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('70', 'Тульская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('71', 'Тыва Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('72', 'Тюменская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('73', 'Удмуртская Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('74', 'Ульяновская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('75', 'Усть-Ордынский Бурятский автономный округ', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('76', 'Хабаровский край', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('77', 'Хакасия Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('78', 'Ханты-Мансийский автономный округ - Югра', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('79', 'Челябинская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('8', 'Japanese (EUC)', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('8', 'euc-jp', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('80', 'Чеченская Республика', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('81', 'Читинская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('82', 'Чувашская Республика - Чувашия', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('83', 'Чукотский автономный округ', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('84', 'Ямало-Ненецкий автономный округ', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('85', 'Ярославская область', '0', 'stateru');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('9', 'BIG5', '0', 'encoding');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('9', 'Chinese Traditional (Big5)', '0', 'encname');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('AA', 'Armed Forces Americas', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('AE', 'Armed Forces Other (AE)', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('AK', 'Alaska', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('AL', 'Alabama', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('AP', 'Armed Forces Pacific', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('AR', 'Arkansas', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('AS', 'American Samoa', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('AZ', 'Arizona', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('CA', 'California', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('CO', 'Colorado', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('CT', 'Connecticut', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('DC', 'Dist. of Columbia', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('DE', 'Delaware', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('DE', 'Deutsch', '1', 'lang');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('EN', 'English', '1', 'lang');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('ES', 'Espanol', '1', 'lang');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('FL', 'Florida', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('FM', 'Federated States of Micronesia', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('FR', 'Francais', '1', 'lang');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('GA', 'Georgia', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('GU', 'Guam', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('HI', 'Hawaii', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('IA', 'Iowa', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('ID', 'Idaho', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('IL', 'Illinois', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('IN', 'Indiana', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('KS', 'Kansas', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('KY', 'Kentucky', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('LA', 'Louisiana', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('MA', 'Massachusetts', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('MD', 'Maryland', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('ME', 'Maine', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('MH', 'Marshall Islands', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('MI', 'Michigan', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('MN', 'Minnesota', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('MO', 'Missouri', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('MP', 'Northern Mariana Islands', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('MS', 'Mississippi', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('MT', 'Montana', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('NC', 'North Carolina', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('ND', 'North Dakota', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('NE', 'Nebraska', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('NH', 'New Hampshire', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('NJ', 'New Jersey', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('NM', 'New Mexico', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('NV', 'Nevada', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('NY', 'New York', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('OH', 'Ohio', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('OK', 'Oklahoma', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('OR', 'Oregon', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('PA', 'Pennsylvania', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('PR', 'Puerto Rico', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('RI', 'Rhode Island', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('RU', 'Russian', '1', 'lang');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('SC', 'South Carolina', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('SD', 'South Dakota', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('TN', 'Tennessee', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('TX', 'Texas', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('UT', 'Utah', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('VA', 'Virginia', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('VI', 'Virgin Islands', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('VT', 'Vermont', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('WA', 'Washington', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('WI', 'Wisconsin', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('WV', 'West Virginia', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('WY', 'Wyoming', '0', 'state');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('act', 'Australian Capital Territory', '0', 'stateau');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('al', 'Alberta', '0', 'stateca');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('bc', 'British Columbia', '0', 'stateca');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('be', 'Berlin', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('bm', 'Bremen', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('br', 'Brandenburg', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('bw', 'Baden-Wuerttemberg', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('by', 'Bayern', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('ha', 'Hamburg', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('hs', 'Hessen', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('ma', 'Manitoba', '0', 'stateca');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('mv', 'Mecklenburg-Vorpommern', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('nb', 'New Brunswick', '0', 'stateca');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('nf', 'Newfoundland', '0', 'stateca');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('ni', 'Niedersachsen', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('ns', 'Nova Scotia', '0', 'stateca');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('nsw', 'New South Wales', '0', 'stateau');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('nt', 'Northern Territory', '0', 'stateau');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('nu', 'Nunavut', '0', 'stateca');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('nw', 'Nordrhein-Westfalen', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('nw', 'Northwest Territories', '0', 'stateca');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('on', 'Ontario', '0', 'stateca');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('pe', 'Prince Edward Island', '0', 'stateca');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('ql', 'Queensland', '0', 'stateau');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('qu', 'Quebec', '0', 'stateca');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('rp', 'Rheinland-Pfalz', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('sa', 'Sachsen-Anhalt', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('sa', 'Saskatchewan', '0', 'stateca');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('sa', 'South Australia', '0', 'stateau');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('sc', 'Sachsen', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('sh', 'Schleswig-Holstein', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('sl', 'Saarland', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('ta', 'Tasmania', '0', 'stateau');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('th', 'Thueringen', '0', 'statede');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('vi', 'Victoria', '0', 'stateau');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('wa', 'Western Australia', '0', 'stateau');
REPLACE INTO codes (code, item, sortorder, type) VALUES ('yt', 'Yukon Territory', '0', 'stateca');
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to grant or revoke privileges to/from other users. arg=Unique privcode that the user has access to grant/deny for, or \"*\" for all privileges.', '0', 'admin', 'Administer privileges', 'general');
UPDATE priv_list SET des='Allows a user to grant or revoke privileges to/from other users. arg=Unique privcode that the user has access to grant/deny for, or \"*\" for all privileges.',is_public='0',privname='Administer privileges',scope='general' WHERE privcode='admin';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to view information that isn\'t otherwise available. All use is logged. arg=Arg=\"*\": can view everything, Arg=\"suspended\": can view public posts in a suspended journal, Arg=\"userlog\": can see userlog data.', '0', 'canview', 'View All Entries', 'general');
UPDATE priv_list SET des='Allows a user to view information that isn\'t otherwise available. All use is logged. arg=Arg=\"*\": can view everything, Arg=\"suspended\": can view public posts in a suspended journal, Arg=\"userlog\": can see userlog data.',is_public='0',privname='View All Entries',scope='general' WHERE privcode='canview';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to change another user\'s journal type.', '1', 'changejournaltype', 'Change Journal Type', 'general');
UPDATE priv_list SET des='Allows a user to change another user\'s journal type.',is_public='1',privname='Change Journal Type',scope='general' WHERE privcode='changejournaltype';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to change the maintainer of a community.', '1', 'communityxfer', 'Community Maintainer Transfer', 'general');
UPDATE priv_list SET des='Allows a user to change the maintainer of a community.',is_public='1',privname='Community Maintainer Transfer',scope='general' WHERE privcode='communityxfer';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to delete comments or entries from other journals. Only used in rare cases.', '0', 'deletetalk', 'Delete Comments or Entries', 'general');
UPDATE priv_list SET des='Allows a user to delete comments or entries from other journals. Only used in rare cases.',is_public='0',privname='Delete Comments or Entries',scope='general' WHERE privcode='deletetalk';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to add documents to the Frequently Asked Questions. arg=Unique faq category code that the privilege is applicable for, or \"*\" for all faq categories.', '1', 'faqadd', 'FAQ - Add', 'general');
UPDATE priv_list SET des='Allows a user to add documents to the Frequently Asked Questions. arg=Unique faq category code that the privilege is applicable for, or \"*\" for all faq categories.',is_public='1',privname='FAQ - Add',scope='general' WHERE privcode='faqadd';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to modify FAQ categories.', '1', 'faqcat', 'FAQ - Edit Categories', 'general');
UPDATE priv_list SET des='Allows a user to modify FAQ categories.',is_public='1',privname='FAQ - Edit Categories',scope='general' WHERE privcode='faqcat';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to edit documents in the Frequently Asked Questions. arg=Unique FAQ category code that the privilege is applicable for, or \"*\" for all faq categories', '1', 'faqedit', 'FAQ - Edit', 'general');
UPDATE priv_list SET des='Allows a user to edit documents in the Frequently Asked Questions. arg=Unique FAQ category code that the privilege is applicable for, or \"*\" for all faq categories',is_public='1',privname='FAQ - Edit',scope='general' WHERE privcode='faqedit';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to edit a static file in the main site\'s document include tree. arg=Unique file identifier, or \"*\" for all files', '1', 'fileedit', 'File Editing', 'general');
UPDATE priv_list SET des='Allows a user to edit a static file in the main site\'s document include tree. arg=Unique file identifier, or \"*\" for all files',is_public='1',privname='File Editing',scope='general' WHERE privcode='fileedit';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to find other users by different criteria. arg=Optional \"codetrace\", which allows the user to see someone\'s use of account codes.', '1', 'finduser', 'Find a user', 'general');
UPDATE priv_list SET des='Allows a user to find other users by different criteria. arg=Optional \"codetrace\", which allows the user to see someone\'s use of account codes.',is_public='1',privname='Find a user',scope='general' WHERE privcode='finduser';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to view data in the \"statushistory\" table for all users. arg=Type of \"statushistory\" entries user can see, or no argument to see everything.', '1', 'historyview', 'View statushistory info', 'general');
UPDATE priv_list SET des='Allows a user to view data in the \"statushistory\" table for all users. arg=Type of \"statushistory\" entries user can see, or no argument to see everything.',is_public='1',privname='View statushistory info',scope='general' WHERE privcode='historyview';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to edit mood themes and make themes public.', '1', 'moodthememanager', 'Mood Themes - Manager', 'general');
UPDATE priv_list SET des='Allows a user to edit mood themes and make themes public.',is_public='1',privname='Mood Themes - Manager',scope='general' WHERE privcode='moodthememanager';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allow viewing of payment data, setting of account type, etc.', '0', 'payments', 'Administer Payments', 'general');
UPDATE priv_list SET des='Allow viewing of payment data, setting of account type, etc.',is_public='0',privname='Administer Payments',scope='general' WHERE privcode='payments';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to delete all email addresses from an account.', '1', 'reset_email', 'Reset User Email Address', 'general');
UPDATE priv_list SET des='Allows a user to delete all email addresses from an account.',is_public='1',privname='Reset User Email Address',scope='general' WHERE privcode='reset_email';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to reset the password to an account', '1', 'reset_password', 'Reset User Password', 'general');
UPDATE priv_list SET des='Allows a user to reset the password to an account',is_public='1',privname='Reset User Password',scope='general' WHERE privcode='reset_password';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to view/adjust certain critical site settings. arg=Unique keyword that user has access to view', '1', 'siteadmin', 'Administer Site', 'general');
UPDATE priv_list SET des='Allows a user to view/adjust certain critical site settings. arg=Unique keyword that user has access to view',is_public='1',privname='Administer Site',scope='general' WHERE privcode='siteadmin';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to change the summary on support requests. arg=Unique support category', '1', 'supportchangesummary', 'Support - Change Summaries', 'general');
UPDATE priv_list SET des='Allows a user to change the summary on support requests. arg=Unique support category',is_public='1',privname='Support - Change Summaries',scope='general' WHERE privcode='supportchangesummary';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to close old support requests that other users haven\'t closed themselves. arg=Unique support category that the user has permission to close in.', '1', 'supportclose', 'Support - Close Requests', 'general');
UPDATE priv_list SET des='Allows a user to close old support requests that other users haven\'t closed themselves. arg=Unique support category that the user has permission to close in.',is_public='1',privname='Support - Close Requests',scope='general' WHERE privcode='supportclose';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to approve screened responses, change request summaries and answer and comment unscreened. arg=Unique Support Category', '1', 'supporthelp', 'Support - Manage Requests', 'general');
UPDATE priv_list SET des='Allows a user to approve screened responses, change request summaries and answer and comment unscreened. arg=Unique Support Category',is_public='1',privname='Support - Manage Requests',scope='general' WHERE privcode='supporthelp';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to make internal comments on support requests. arg=Unique support category', '1', 'supportmakeinternal', 'Support - Make Internal Comments', 'general');
UPDATE priv_list SET des='Allows a user to make internal comments on support requests. arg=Unique support category',is_public='1',privname='Support - Make Internal Comments',scope='general' WHERE privcode='supportmakeinternal';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to move support requests to different categories and to mark requests as still needing help. The supportmakeinternal privilege is required. arg=Unique support category', '1', 'supportmovetouch', 'Support - Move and Touch Requests', 'general');
UPDATE priv_list SET des='Allows a user to move support requests to different categories and to mark requests as still needing help. The supportmakeinternal privilege is required. arg=Unique support category',is_public='1',privname='Support - Move and Touch Requests',scope='general' WHERE privcode='supportmovetouch';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to read support requests in private categories. arg=Unique support category', '1', 'supportread', 'Support - Read Requests', 'general');
UPDATE priv_list SET des='Allows a user to read support requests in private categories. arg=Unique support category',is_public='1',privname='Support - Read Requests',scope='general' WHERE privcode='supportread';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to view internal comments on support requests. arg=Unique support category', '1', 'supportviewinternal', 'Support - View Internal Comments', 'general');
UPDATE priv_list SET des='Allows a user to view internal comments on support requests. arg=Unique support category',is_public='1',privname='Support - View Internal Comments',scope='general' WHERE privcode='supportviewinternal';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to read screened responses on support requests. arg=Unique support category', '1', 'supportviewscreened', 'Support - See Screened Responses', 'general');
UPDATE priv_list SET des='Allows a user to read screened responses on support requests. arg=Unique support category',is_public='1',privname='Support - See Screened Responses',scope='general' WHERE privcode='supportviewscreened';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to make use of the stock answers in a support category. arg=Unique support category', '1', 'supportviewstocks', 'View stock answers', 'general');
UPDATE priv_list SET des='Allows a user to make use of the stock answers in a support category. arg=Unique support category',is_public='1',privname='View stock answers',scope='general' WHERE privcode='supportviewstocks';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to suspend or unsuspend user accounts. Used by the Abuse Team.', '0', 'suspend', 'Suspend accounts', 'general');
UPDATE priv_list SET des='Allows a user to suspend or unsuspend user accounts. Used by the Abuse Team.',is_public='0',privname='Suspend accounts',scope='general' WHERE privcode='suspend';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows editing settings of syndicated journal that shouldn\'t be editable by users.', '0', 'syn_edit', 'Edit Syndicated Settings', 'general');
UPDATE priv_list SET des='Allows editing settings of syndicated journal that shouldn\'t be editable by users.',is_public='0',privname='Edit Syndicated Settings',scope='general' WHERE privcode='syn_edit';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to modify bans with the sysban mechanism. arg=A specific ban type the user can modify, or \"*\" for all ban type.', '0', 'sysban', 'Modify System Bans', 'general');
UPDATE priv_list SET des='Allows a user to modify bans with the sysban mechanism. arg=A specific ban type the user can modify, or \"*\" for all ban type.',is_public='0',privname='Modify System Bans',scope='general' WHERE privcode='sysban';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to edit site text in a given language. arg=Unique language code, optionally appended by |domainid.domaincode', '1', 'translate', 'Translate/Update Text', 'general');
UPDATE priv_list SET des='Allows a user to edit site text in a given language. arg=Unique language code, optionally appended by |domainid.domaincode',is_public='1',privname='Translate/Update Text',scope='general' WHERE privcode='translate';
INSERT IGNORE INTO priv_list (des, is_public, privcode, privname, scope) VALUES ('Allows a user to add/edit vgifts. arg=Tag in case restricting priv to a particular category is needed, or "*" for all tags.', '1', 'vgifts', 'Virtual Gifts', 'general');
UPDATE priv_list SET des='Allows a user to add/edit vgifts. arg=Tag in case restricting priv to a particular category is needed, or "*" for all tags.',is_public='1',privname='Virtual Gifts',scope='general' WHERE privcode='vgifts';
INSERT IGNORE INTO ratelist (des, name) VALUES ('Logged when a user adds someone to their Friends list', 'addfriend');
UPDATE ratelist SET des='Logged when a user adds someone to their Friends list' WHERE name='addfriend';
INSERT IGNORE INTO ratelist (des, name) VALUES ('Logged when a user creates a community.', 'commcreate');
UPDATE ratelist SET des='Logged when a user creates a community.' WHERE name='commcreate';
INSERT IGNORE INTO ratelist (des, name) VALUES ('Logged when wrong username/password is used.', 'failed_login');
UPDATE ratelist SET des='Logged when wrong username/password is used.' WHERE name='failed_login';
INSERT IGNORE INTO ratelist (des, name) VALUES ('Logged when a user sends a friend invite', 'invitefriend');
UPDATE ratelist SET des='Logged when a user sends a friend invite' WHERE name='invitefriend';
INSERT IGNORE INTO ratelist (des, name) VALUES ('Logged when a forgotten password or username e-mail is requested', 'lostinfo');
UPDATE ratelist SET des='Logged when a forgotten password or username e-mail is requested' WHERE name='lostinfo';
INSERT IGNORE INTO ratelist (des, name) VALUES ('Logged whenever user posts (to any journal)', 'post');
UPDATE ratelist SET des='Logged whenever user posts (to any journal)' WHERE name='post';
INSERT IGNORE INTO ratelist (des, name) VALUES ('Logged when a users sends a message via Tell A Friend', 'tellafriend');
UPDATE ratelist SET des='Logged when a users sends a message via Tell A Friend' WHERE name='tellafriend';
INSERT IGNORE INTO ratelist (des, name) VALUES ('Logged when a users sends a message to another user', 'usermessage');
UPDATE ratelist SET des='Logged when a users sends a message to another user' WHERE name='usermessage';
INSERT IGNORE INTO supportcat (allow_screened, basepoints, catkey, catname, hide_helpers, is_selectable, no_autoreply, public_help, public_read, replyaddress, scope, sortorder, user_closeable) VALUES ('1', '1', 'general', 'General/Unknown', '0', '1', '0', '0', '1', NULL, 'general', '2', '1');
UPDATE supportcat SET allow_screened='1',basepoints='1',catname='General/Unknown',hide_helpers='0',is_selectable='1',no_autoreply='0',public_help='0',public_read='1',replyaddress=NULL,scope='general',sortorder='2',user_closeable='1' WHERE catkey='general';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('ao3', 'ao3', 'ao3.png', 'profile.service.ao3', '//archiveofourown.org/users/%s', 40);
UPDATE profile_services SET userprop='ao3', imgfile='ao3.png', title_ml='profile.service.ao3', url_format='//archiveofourown.org/users/%s', maxlen=40 WHERE name='ao3';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('deviantart', 'deviantart', 'deviantart.png', 'profile.service.deviantart', '//%s.deviantart.com', 20);
UPDATE profile_services SET userprop='deviantart', imgfile='deviantart.png', title_ml='profile.service.deviantart', url_format='//%s.deviantart.com', maxlen=20 WHERE name='deviantart';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('diigo', 'diigo', 'diigo.png', 'profile.service.diigo', '//www.diigo.com/user/%s', 16);
UPDATE profile_services SET userprop='diigo', imgfile='diigo.png', title_ml='profile.service.diigo', url_format='//www.diigo.com/user/%s', maxlen=16 WHERE name='diigo';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('discord', 'discord', 'discord.png', 'profile.service.discord', NULL, 40);
UPDATE profile_services SET userprop='discord', imgfile='discord.png', title_ml='profile.service.discord', url_format=NULL, maxlen=40 WHERE name='discord';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('etsy', 'etsy', 'etsy.png', 'profile.service.etsy', '//www.etsy.com/people/%s', 20);
UPDATE profile_services SET userprop='etsy', imgfile='etsy.png', title_ml='profile.service.etsy', url_format='//www.etsy.com/people/%s', maxlen=20 WHERE name='etsy';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('ffnet', 'ffnet', 'ffnet.png', 'profile.service.ffnet', '//www.fanfiction.net/~%s', 30);
UPDATE profile_services SET userprop='ffnet', imgfile='ffnet.png', title_ml='profile.service.ffnet', url_format='//www.fanfiction.net/~%s', maxlen=30 WHERE name='ffnet';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('github', 'github', 'github.png', 'profile.service.github', '//github.com/%s', 39);
UPDATE profile_services SET userprop='github', imgfile='github.png', title_ml='profile.service.github', url_format='//github.com/%s', maxlen=39 WHERE name='github';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('google_chat', 'google_talk', 'google_hangouts.png', 'profile.service.hangouts', NULL, 60);
UPDATE profile_services SET userprop='google_talk', imgfile='google_hangouts.png', title_ml='profile.service.hangouts', url_format=NULL, maxlen=60 WHERE name='google_chat';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('icq', 'icq', 'icq.gif', 'profile.service.icq', '//wwp.icq.com/%s', 12);
UPDATE profile_services SET userprop='icq', imgfile='icq.gif', title_ml='profile.service.icq', url_format='//wwp.icq.com/%s', maxlen=12 WHERE name='icq';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('insanejournal', 'insanejournal', 'insanejournal.png', 'profile.service.insanejournal', '//%s.insanejournal.com', 15);
UPDATE profile_services SET userprop='insanejournal', imgfile='insanejournal.png', title_ml='profile.service.insanejournal', url_format='//%s.insanejournal.com', maxlen=15 WHERE name='insanejournal';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('instagram', 'instagram', 'instagram.png', 'profile.service.instagram', '//www.instagram.com/%s', 30);
UPDATE profile_services SET userprop='instagram', imgfile='instagram.png', title_ml='profile.service.instagram', url_format='//www.instagram.com/%s', maxlen=30 WHERE name='instagram';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('jabber', 'jabber', 'jabber.gif', 'profile.service.jabber', NULL, 60);
UPDATE profile_services SET userprop='jabber', imgfile='jabber.gif', title_ml='profile.service.jabber', url_format=NULL, maxlen=60 WHERE name='jabber';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('lastfm', 'last_fm_user', 'lastfm.gif', 'profile.service.lastfm', '//www.last.fm/user/%s', 255);
UPDATE profile_services SET userprop='last_fm_user', imgfile='lastfm.gif', title_ml='profile.service.lastfm', url_format='//www.last.fm/user/%s', maxlen=255 WHERE name='lastfm';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('livejournal', 'livejournal', 'livejournal.gif', 'profile.service.livejournal', '//%s.livejournal.com', 30);
UPDATE profile_services SET userprop='livejournal', imgfile='livejournal.gif', title_ml='profile.service.livejournal', url_format='//%s.livejournal.com', maxlen=30 WHERE name='livejournal';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('medium', 'medium', 'medium.png', 'profile.service.medium', '//medium.com/@%s/latest', 25);
UPDATE profile_services SET userprop='medium', imgfile='medium.png', title_ml='profile.service.medium', url_format='//medium.com/@%s/latest', maxlen=25 WHERE name='medium';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('patreon', 'patreon', 'patreon.png', 'profile.service.patreon', '//www.patreon.com/%s', 255);
UPDATE profile_services SET userprop='patreon', imgfile='patreon.png', title_ml='profile.service.patreon', url_format='//www.patreon.com/%s', maxlen=255 WHERE name='patreon';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('pillowfort', 'pillowfort', 'pillowfort.png', 'profile.service.pillowfort', '//www.pillowfort.social/%s', 255);
UPDATE profile_services SET userprop='pillowfort', imgfile='pillowfort.png', title_ml='profile.service.pillowfort', url_format='//www.pillowfort.social/%s', maxlen=255 WHERE name='pillowfort';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('pinboard', 'pinboard', 'pinboard.png', 'profile.service.pinboard', '//pinboard.in/u:%s', 30);
UPDATE profile_services SET userprop='pinboard', imgfile='pinboard.png', title_ml='profile.service.pinboard', url_format='//pinboard.in/u:%s', maxlen=30 WHERE name='pinboard';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('pinterest', 'pinterest', 'pinterest.png', 'profile.service.pinterest', '//www.pinterest.com/%s', 30);
UPDATE profile_services SET userprop='pinterest', imgfile='pinterest.png', title_ml='profile.service.pinterest', url_format='//www.pinterest.com/%s', maxlen=30 WHERE name='pinterest';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('plurk', 'plurk', 'plurk.png', 'profile.service.plurk', '//www.plurk.com/%s', 255);
UPDATE profile_services SET userprop='plurk', imgfile='plurk.png', title_ml='profile.service.plurk', url_format='//www.plurk.com/%s', maxlen=255 WHERE name='plurk';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('ravelry', 'ravelry', 'ravelry.png', 'profile.service.ravelry', '//www.ravelry.com/people/%s', 40);
UPDATE profile_services SET userprop='ravelry', imgfile='ravelry.png', title_ml='profile.service.ravelry', url_format='//www.ravelry.com/people/%s', maxlen=40 WHERE name='ravelry';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('reddit', 'reddit', 'reddit.png', 'profile.service.reddit', '//www.reddit.com/user/%s', 20);
UPDATE profile_services SET userprop='reddit', imgfile='reddit.png', title_ml='profile.service.reddit', url_format='//www.reddit.com/user/%s', maxlen=20 WHERE name='reddit';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('skype', 'skype', 'skype.gif', 'profile.service.skype', NULL, 40);
UPDATE profile_services SET userprop='skype', imgfile='skype.gif', title_ml='profile.service.skype', url_format=NULL, maxlen=40 WHERE name='skype';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('tumblr', 'tumblr', 'tumblr.png', 'profile.service.tumblr', '//%s.tumblr.com', 255);
UPDATE profile_services SET userprop='tumblr', imgfile='tumblr.png', title_ml='profile.service.tumblr', url_format='//%s.tumblr.com', maxlen=255 WHERE name='tumblr';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('twitter', 'twitter', 'twitter_bird.png', 'profile.service.twitter', '//www.twitter.com/%s', 40);
UPDATE profile_services SET userprop='twitter', imgfile='twitter_bird.png', title_ml='profile.service.twitter', url_format='//www.twitter.com/%s', maxlen=40 WHERE name='twitter';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('wattpad', 'wattpad', 'wattpad.png', 'profile.service.wattpad', '//www.wattpad.com/user/%s', 20);
UPDATE profile_services SET userprop='wattpad', imgfile='wattpad.png', title_ml='profile.service.wattpad', url_format='//www.wattpad.com/user/%s', maxlen=20 WHERE name='wattpad';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('steam', NULL, 'steam.png', 'profile.service.steam', '//steamcommunity.com/id/%s/', 32);
UPDATE profile_services SET userprop=NULL, imgfile='steam.png', title_ml='profile.service.steam', url_format='//steamcommunity.com/id/%s/', maxlen=32 WHERE name='steam';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('spotify', NULL, 'spotify.png', 'profile.service.spotify', '//open.spotify.com/user/%s', 32);
UPDATE profile_services SET userprop=NULL, imgfile='spotify.png', title_ml='profile.service.spotify', url_format='//open.spotify.com/user/%s', maxlen=32 WHERE name='spotify';
INSERT IGNORE INTO profile_services (name, userprop, imgfile, title_ml, url_format, maxlen) VALUES ('squidgeworld', NULL, 'squidgeworld.png', 'profile.service.squidgeworld', '//squidgeworld.org/users/%s', 40);
UPDATE profile_services SET userprop=NULL, imgfile='squidgeworld.png', title_ml='profile.service.squidgeworld', url_format='//squidgeworld.org/users/%s', maxlen=40 WHERE name='squidgeworld';
Reference in a new issue View git blame Copy permalink