[SOLVED] 15a__pre1.2.9-DEV_to_1.3.0.sql - Missing SQL

StudioZ · Post by **StudioZ** » Tue 10. Apr 2007, 23:04

Just upgraded a site from pre1.2.9 to 1.3.0

Here's where I am stuck

When I try to add a newsletter content part...
then... there pops up this error:
error while creating new article content: Unknown column 'acontent_created' in 'field list'

I checked in my upgraded 1.3.0 DB and this field is not there.
I checked in my old 1.2.9 DB and this field is not there.
I checked in the SQL for upgrade 16__1.2.9-DEV_to_1.3.0.sql, and it is not there.

Note: This field IS in the default SQL setup
Question: What would be good way to insert this extra field (via PhpMyAdmin) in my upgraded site, without affecting any data ?

Any help would be greatly appreciated

Cheers,

Yves

StudioZ · Post by **StudioZ** » Wed 11. Apr 2007, 05:42

Solution... below

StudioZ · Post by **StudioZ** » Wed 11. Apr 2007, 15:46

OK.

Here's the complete SQL you should run to upgrade from pre1.2.9 to 1.3.0
I ceated a new SQL file that I named: 15a__pre1.2.9-DEV_to_1.3.0.sql

2007/04-11 - UPDATE 01 Added: phpwcms_sysvalue
2007/04-12 - UPDATE 01 Added: phpwcms_article
2007/04-12 - UPDATE 02 Added: bunch of sql stuff missing (ADD KEY, FULLTEXT KEYs, etc.)

Maybe more to come.... ?

Code: Select all

#####################################################
#
#  PHPWCMS SQL Update
# 
#  Upgrade release pre1.2.9 to 1.3.0
#
#####################################################


ALTER TABLE `phpwcms_address` ADD `address_iddetail` INT( 11 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `phpwcms_address` ADD `address_url1` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_address` ADD `address_url2` VARCHAR( 255 ) NOT NULL ;

ALTER TABLE `phpwcms_article` DROP INDEX `article_keyword` ;
ALTER TABLE `phpwcms_article` ADD INDEX ( `article_aktiv` ) ;
ALTER TABLE `phpwcms_article` ADD INDEX ( `article_public` ) ;
ALTER TABLE `phpwcms_article` ADD INDEX ( `article_deleted` ) ;
ALTER TABLE `phpwcms_article` ADD INDEX ( `article_nosearch` ) ;
ALTER TABLE `phpwcms_article` ADD INDEX ( `article_begin` ) ;
ALTER TABLE `phpwcms_article` ADD INDEX ( `article_end` ) ;
ALTER TABLE `phpwcms_article` ADD INDEX ( `article_cid` ) ;
ALTER TABLE `phpwcms_article` ADD INDEX ( `article_tstamp` ) ;

ALTER TABLE `phpwcms_articlecat` ADD KEY ( `acat_struct` ) ;
ALTER TABLE `phpwcms_articlecat` ADD KEY ( `acat_sort` ) ;
ALTER TABLE `phpwcms_articlecat` ADD FULLTEXT KEY ( `acat_alias` ) ;

ALTER TABLE `phpwcms_articlecontent` ADD `acontent_tid` INT( 11 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `phpwcms_articlecontent` ADD `acontent_livedate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ;
ALTER TABLE `phpwcms_articlecontent` ADD `acontent_killdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `phpwcms_articlecontent` ADD `acontent_created` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `acontent_uid` ;
ALTER TABLE `phpwcms_articlecontent` ADD `acontent_module` VARCHAR( 255 ) NOT NULL ;

ALTER TABLE `phpwcms_articlecontent` DROP INDEX `acontent_livedate` ;
ALTER TABLE `phpwcms_articlecontent` ADD KEY ( `acontent_aid` ) ;
ALTER TABLE `phpwcms_articlecontent` ADD KEY ( `acontent_sorting` ) ;
ALTER TABLE `phpwcms_articlecontent` ADD KEY ( `acontent_type` ) ;
ALTER TABLE `phpwcms_articlecontent` ADD INDEX ( `acontent_livedate` , `acontent_killdate` ) ;

TRUNCATE TABLE `phpwcms_country` ;
ALTER TABLE `phpwcms_country` ADD `country_name_de` VARCHAR( 255 ) NOT NULL ;
INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (1, 'AF', 'Afghanistan', 'Afghanistan');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (2, 'AL', 'Albania', 'Albanien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (3, 'DZ', 'Algeria', 'Algerien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (4, 'AS', 'American Samoa', 'Amerikanisch Samoa');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (5, 'AD', 'Andorra', 'Andorra');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (6, 'AO', 'Angola', 'Angola');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (7, 'AI', 'Anguilla', 'Anguilla');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (8, 'AQ', 'Antarctica', 'Antarktis');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (9, 'AG', 'Antigua and Barbuda', 'Antigua und Barbuda');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (10, 'AR', 'Argentina', 'Argentinien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (11, 'AM', 'Armenia', 'Armenien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (12, 'AW', 'Aruba', 'Aruba');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (13, 'AU', 'Australia', 'Australien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (14, 'AT', 'Austria', '÷sterreich');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (15, 'AZ', 'Azerbaijan', 'Aserbaidschan');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (16, 'BS', 'Bahamas', 'Bahamas');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (17, 'BH', 'Bahrain', 'Bahrain');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (18, 'BD', 'Bangladesh', 'Bangladesch');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (19, 'BB', 'Barbados', 'Barbados');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (20, 'BY', 'Belarus', 'Belarus');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (21, 'BE', 'Belgium', 'Belgien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (22, 'BZ', 'Belize', 'Belize');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (23, 'BJ', 'Benin', 'Benin');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (24, 'BM', 'Bermuda', 'Bermuda');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (25, 'BT', 'Bhutan', 'Bhutan');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (26, 'BO', 'Bolivia', 'Bolivien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (27, 'BA', 'Bosnia and Herzegovina', 'Bosnien und Herzegowina');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (28, 'BW', 'Botswana', 'Botsuana');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (29, 'BV', 'Bouvet Island', 'Bouvet-Insel');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (30, 'BR', 'Brazil', 'Brasilien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (31, 'IO', 'British Indian Ocean Territory', 'Britisches Territorium Im Indischen Ozean');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (32, 'BN', 'Brunei Darussalam', 'Brunei Darussalam');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (33, 'BG', 'Bulgaria', 'Bulgarien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (34, 'BF', 'Burkina Faso', 'Burkina Faso');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (35, 'BI', 'Burundi', 'Burundi');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (36, 'KH', 'Cambodia', 'Kambodscha');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (37, 'CM', 'Cameroon', 'Kamerun');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (38, 'CA', 'Canada', 'Kanada');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (39, 'CV', 'Cape Verde', 'Kap Verde');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (40, 'KY', 'Cayman Islands', 'Kaimaninseln');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (41, 'CF', 'Central African Republic', 'Zentralafrikanische Republik');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (42, 'TD', 'Chad', 'Tschad');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (43, 'CL', 'Chile', 'Chile');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (44, 'CN', 'China', 'China');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (45, 'CX', 'Christmas Island', 'Weihnachtsinsel');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (46, 'CC', 'Cocos (Keeling) Islands', 'Kokosinseln (Keelingsinseln)');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (47, 'CO', 'Colombia', 'Kolumbien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (48, 'KM', 'Comoros', 'Komoren');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (49, 'CG', 'Congo', 'Kongo');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (50, 'CD', 'Congo, The Democratic Republic Of The', 'Kongo, Demokratische Republik');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (51, 'CK', 'Cook Islands', 'Cook-Inseln');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (52, 'CR', 'Costa Rica', 'Costa Rica');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (53, 'CI', 'CÙte D''Ivoire', 'CÙte D''Ivoire');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (54, 'HR', 'Croatia', 'Kroatien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (55, 'CU', 'Cuba', 'Kuba');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (56, 'CY', 'Cyprus', 'Zypern');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (57, 'CZ', 'Czech Republic', 'Tschechische Republik');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (58, 'DK', 'Denmark', 'D‰nemark');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (59, 'DJ', 'Djibouti', 'Dschibuti');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (60, 'DM', 'Dominica', 'Dominica');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (61, 'DO', 'Dominican Republic', 'Dominikanische Republik');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (62, 'TP', 'East Timor', 'Ost-Timor');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (63, 'EC', 'Ecuador', 'Ecuador');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (64, 'EG', 'Egypt', 'ƒgypten');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (65, 'SV', 'El Salvador', 'El Salvador');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (66, 'GQ', 'Equatorial Guinea', 'ƒquatorialguinea');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (67, 'ER', 'Eritrea', 'Eritrea');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (68, 'EE', 'Estonia', 'Estland');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (69, 'ET', 'Ethiopia', 'ƒthiopien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (70, 'FK', 'Falkland Islands (Malvinas)', 'Falkland-Inseln (Malvinen)');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (71, 'FO', 'Faroe Islands', 'F‰rˆer');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (72, 'FJ', 'Fiji', 'Fidschi');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (73, 'FI', 'Finland', 'Finnland');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (74, 'FR', 'France', 'Frankreich');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (75, 'GF', 'French Guiana', 'Franzˆsisch Guayana');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (76, 'PF', 'French Polynesia', 'Franzˆsisch Polynesien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (77, 'TF', 'French Southern Territories', 'Franzˆsische S¸dgebiete');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (78, 'GA', 'Gabon', 'Gabun');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (79, 'GM', 'Gambia', 'Gambia');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (80, 'GE', 'Georgia', 'Georgien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (81, 'DE', 'Germany', 'Deutschland');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (82, 'GH', 'Ghana', 'Ghana');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (83, 'GI', 'Gibraltar', 'Gibraltar');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (84, 'GR', 'Greece', 'Griechenland');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (85, 'GL', 'Greenland', 'Grˆnland');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (86, 'GD', 'Grenada', 'Grenada');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (87, 'GP', 'Guadeloupe', 'Guadeloupe');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (88, 'GU', 'Guam', 'Guam');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (89, 'GT', 'Guatemala', 'Guatemala');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (90, 'GN', 'Guinea', 'Guinea');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (91, 'GW', 'Guinea-Bissau', 'Guinea-Bissau');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (92, 'GY', 'Guyana', 'Guyana');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (93, 'HT', 'Haiti', 'Haiti');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (94, 'HM', 'Heard Island and McDonald Islands', 'Heard und McDonald');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (95, 'VA', 'Holy See (Vatican City State)', 'Vatikanstadt, Staat (Heiliger Stuhl)');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (96, 'HN', 'Honduras', 'Honduras');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (97, 'HK', 'Hong Kong', 'Hongkong');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (98, 'HU', 'Hungary', 'Ungarn');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (99, 'IS', 'Iceland', 'Island');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (100, 'IN', 'India', 'Indien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (101, 'ID', 'Indonesia', 'Indonesien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (102, 'IR', 'Iran, Islamic Republic Of', 'Iran (Islamische Republik)');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (103, 'IQ', 'Iraq', 'Irak');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (104, 'IE', 'Ireland', 'Irland');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (105, 'IL', 'Israel', 'Israel');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (106, 'IT', 'Italy', 'Italien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (107, 'JM', 'Jamaica', 'Jamaika');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (108, 'JP', 'Japan', 'Japan');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (109, 'JO', 'Jordan', 'Jordanien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (110, 'KZ', 'Kazakhstan', 'Kasachstan');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (111, 'KE', 'Kenya', 'Kenia');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (112, 'KI', 'Kiribati', 'Kiribati');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (113, 'KP', 'Korea, Democratic People''s Republic Of', 'Korea, Demokratische Volksrepublik');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (114, 'KR', 'Korea, Republic Of', 'Korea, Republik');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (115, 'KW', 'Kuwait', 'Kuwait');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (116, 'KG', 'Kyrgyzstan', 'Kirgisistan');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (117, 'LA', 'Lao People''s Democratic Republic', 'Laos, Demokratische Volksrepublik');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (118, 'LV', 'Latvia', 'Lettland');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (119, 'LB', 'Lebanon', 'Libanon');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (120, 'LS', 'Lesotho', 'Lesotho');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (121, 'LR', 'Liberia', 'Liberia');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (122, 'LY', 'Libyan Arab Jamahiriya', 'Libysch-Arabische Dschamahirija');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (123, 'LI', 'Liechtenstein', 'Liechtenstein');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (124, 'LT', 'Lithuania', 'Litauen');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (125, 'LU', 'Luxembourg', 'Luxembourg');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (126, 'MO', 'Macao', 'Macau');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (127, 'MK', 'Macedonia, The Former Yugoslav Republic Of', 'Mazedonien, Ehemalige Jugoslawische Republik');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (128, 'MG', 'Madagascar', 'Madagaskar');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (129, 'MW', 'Malawi', 'Malawi');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (130, 'MY', 'Malaysia', 'Malaysia');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (131, 'MV', 'Maldives', 'Malediven');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (132, 'ML', 'Mali', 'Mali');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (133, 'MT', 'Malta', 'Malta');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (134, 'MH', 'Marshall Islands', 'Marshallinseln');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (135, 'MQ', 'Martinique', 'Martinique');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (136, 'MR', 'Mauritania', 'Mauretanien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (137, 'MU', 'Mauritius', 'Mauritius');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (138, 'YT', 'Mayotte', 'Mayotte');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (139, 'MX', 'Mexico', 'Mexiko');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (140, 'FM', 'Micronesia, Federated States Of', 'Mikronesien, Fˆderierte Staaten Von');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (141, 'MD', 'Moldova, Republic Of', 'Moldau, Republik');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (142, 'MC', 'Monaco', 'Monaco');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (143, 'MN', 'Mongolia', 'Mongolei');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (144, 'MS', 'Montserrat', 'Montserrat');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (145, 'MA', 'Morocco', 'Marokko');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (146, 'MZ', 'Mozambique', 'Mosambik');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (147, 'MM', 'Myanmar', 'Myanmar');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (148, 'NA', 'Namibia', 'Namibia');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (149, 'NR', 'Nauru', 'Nauru');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (150, 'NP', 'Nepal', 'Nepal');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (151, 'NL', 'Netherlands', 'Niederlande');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (152, 'AN', 'Netherlands Antilles', 'Niederl‰ndische Antillen');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (153, 'NC', 'New Caledonia', 'Neukaledonien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (154, 'NZ', 'New Zealand', 'Neuseeland');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (155, 'NI', 'Nicaragua', 'Nicaragua');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (156, 'NE', 'Niger', 'Niger');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (157, 'NG', 'Nigeria', 'Nigeria');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (158, 'NU', 'Niue', 'Niue');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (159, 'NF', 'Norfolk Island', 'Norfolk-Insel');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (160, 'MP', 'Northern Mariana Islands', 'Nˆrdliche Marianen');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (161, 'NO', 'Norway', 'Norwegen');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (162, 'OM', 'Oman', 'Oman');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (163, 'PK', 'Pakistan', 'Pakistan');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (164, 'PW', 'Palau', 'Palau');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (165, 'PS', 'Palestinian Territory, Occupied', 'Pal‰stina');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (166, 'PA', 'Panama', 'Panama');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (167, 'PG', 'Papua New Guinea', 'Papua-Neuguinea');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (168, 'PY', 'Paraguay', 'Paraguay');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (169, 'PE', 'Peru', 'Peru');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (170, 'PH', 'Philippines', 'Philippinen');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (171, 'PN', 'Pitcairn', 'Pitcairn');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (172, 'PL', 'Poland', 'Polen');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (173, 'PT', 'Portugal', 'Portugal');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (174, 'PR', 'Puerto Rico', 'Puerto Rico');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (175, 'QA', 'Qatar', 'Katar');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (176, 'RE', 'RÈunion', 'RÈunion');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (177, 'RO', 'Romania', 'Rum‰nien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (178, 'RU', 'Russian Federation', 'Russische Fˆderation');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (179, 'RW', 'Rwanda', 'Ruanda');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (180, 'SH', 'Saint Helena', 'St. Helena');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (181, 'KN', 'Saint Kitts and Nevis', 'Saint Kitts und Nevis');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (182, 'LC', 'Saint Lucia', 'Santa Lucia');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (183, 'PM', 'Saint Pierre and Miquelon', 'Saint-Pierre und Miquelon');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (184, 'VC', 'Saint Vincent and The Grenadines', 'Saint Vincent und die Grenadinen');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (185, 'WS', 'Samoa', 'Samoa');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (186, 'SM', 'San Marino', 'San Marino');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (187, 'ST', 'Sao Tome and Principe', 'S„o TomÈ und PrÌncipe');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (188, 'SA', 'Saudi Arabia', 'Saudi-Arabien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (189, 'SN', 'Senegal', 'Senegal');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (190, 'SC', 'Seychelles', 'Seychellen');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (191, 'SL', 'Sierra Leone', 'Sierra Leone');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (192, 'SG', 'Singapore', 'Singapur');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (193, 'SK', 'Slovakia', 'Slowakei (Slowakische Republik)');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (194, 'SI', 'Slovenia', 'Slowenien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (195, 'SB', 'Solomon Islands', 'Salomonen');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (196, 'SO', 'Somalia', 'Somalia');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (197, 'ZA', 'South Africa', 'S¸dafrika');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (198, 'GS', 'South Georgia and The South Sandwich Islands', 'S¸dgeorgien und S¸dliche Sandwichinseln');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (199, 'ES', 'Spain', 'Spanien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (200, 'LK', 'Sri Lanka', 'Sri Lanka');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (201, 'SD', 'Sudan', 'Sudan');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (202, 'SR', 'Suriname', 'Suriname');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (203, 'SJ', 'Svalbard and Jan Mayen', 'Svalbard und Jan Mayen');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (204, 'SZ', 'Swaziland', 'Swasiland');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (205, 'SE', 'Sweden', 'Schweden');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (206, 'CH', 'Switzerland', 'Schweiz');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (207, 'SY', 'Syrian Arab Republic', 'Syrien, Arabische Republik');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (208, 'TW', 'Taiwan, Province Of China', 'Taiwan (China)');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (209, 'TJ', 'Tajikistan', 'Tadschikistan');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (210, 'TZ', 'Tanzania, United Republic Of', 'Tansania, Vereinigte Republik');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (211, 'TH', 'Thailand', 'Thailand');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (212, 'TG', 'Togo', 'Togo');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (213, 'TK', 'Tokelau', 'Tokelau');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (214, 'TO', 'Tonga', 'Tonga');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (215, 'TT', 'Trinidad and Tobago', 'Trinidad und Tobago');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (216, 'TN', 'Tunisia', 'Tunesien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (217, 'TR', 'Turkey', 'T¸rkei');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (218, 'TM', 'Turkmenistan', 'Turkmenistan');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (219, 'TC', 'Turks Aand Caicos Islands', 'Turks- und Caicosinseln');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (220, 'TV', 'Tuvalu', 'Tuvalu');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (221, 'UG', 'Uganda', 'Uganda');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (222, 'UA', 'Ukraine', 'Ukraine');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (223, 'AE', 'United Arab Emirates', 'Vereinigte Arabische Emirate');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (224, 'GB', 'United Kingdom', 'United Kingdom');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (225, 'US', 'United States', 'Vereinigte Staaten');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (226, 'UM', 'United States Minor Outlying Islands', 'Kleinere entlegene Inseln der Vereinigten Staaten');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (227, 'UY', 'Uruguay', 'Uruguay');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (228, 'UZ', 'Uzbekistan', 'Usbekistan');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (229, 'VU', 'Vanuatu', 'Vanuatu');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (230, 'VE', 'Venezuela', 'Venezuela');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (231, 'VN', 'Viet Nam', 'Vietnam');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (232, 'VG', 'Virgin Islands, British', 'Jungferninseln (Britische)');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (233, 'VI', 'Virgin Islands, U.S.', 'Jungferninseln (Amerikanische)');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (234, 'WF', 'Wallis and Futuna', 'Wallis und Futuna');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (235, 'EH', 'Western Sahara', 'Westsahara');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (236, 'YE', 'Yemen', 'Jemen');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (237, 'YU', 'Yugoslavia', 'Jugoslawien');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (238, 'ZM', 'Zambia', 'Sambia');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (239, 'ZW', 'Zimbabwe', 'Simbabwe');

INSERT INTO `phpwcms_country` (`country_id`, `country_iso`, `country_name`, `country_name_de`) VALUES (240, 'AX', '≈land Islands', '≈land Inseln');

ALTER TABLE `phpwcms_country` ADD INDEX ( `country_iso` ) ;
ALTER TABLE `phpwcms_country` ADD INDEX ( `country_name` ) ;

CREATE TABLE `phpwcms_language` (

  `lang_id` varchar(255) NOT NULL default '',

  `lang_html` int(1) NOT NULL default '1',

  `lang_type` int(1) NOT NULL default '0',

  `EN` text NOT NULL,

  `DE` text NOT NULL,

  `BG` text NOT NULL,

  `CA` text NOT NULL,

  `CZ` text NOT NULL,

  `DA` text NOT NULL,

  `EE` text NOT NULL,

  `ES` text NOT NULL,

  `FI` text NOT NULL,

  `FR` text NOT NULL,

  `GR` text NOT NULL,

  `HU` text NOT NULL,

  `IT` text NOT NULL,

  `LT` text NOT NULL,

  `NL` text NOT NULL,

  `NO` text NOT NULL,

  `PL` text NOT NULL,

  `PT` text NOT NULL,

  `RO` text NOT NULL,

  `SE` text NOT NULL,

  `SK` text NOT NULL,

  `VN` text NOT NULL,

  PRIMARY KEY  (`lang_id`)

) ENGINE=MyISAM;



ALTER TABLE `phpwcms_newsletter` ADD `newsletter_created` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ;
ALTER TABLE `phpwcms_newsletter` ADD `newsletter_lastsending` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ;
ALTER TABLE `phpwcms_newsletter` ADD `newsletter_active` INT( 1 ) DEFAULT '0' NOT NULL ;

CREATE TABLE `phpwcms_newsletterqueue` (
  `queue_id` int(11) NOT NULL auto_increment,
  `queue_created` timestamp NOT NULL default '0000-00-00 00:00:00',
  `queue_changed` timestamp NOT NULL default '0000-00-00 00:00:00',
  `queue_status` int(11) NOT NULL default '0',
  `queue_pid` int(11) NOT NULL default '0',
  `queue_rid` int(11) NOT NULL default '0',
  `queue_errormsg` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`queue_id`),
  KEY `nlqueue` (`queue_pid`,`queue_status`)
) ENGINE=MyISAM;

TRUNCATE TABLE `phpwcms_profession` ;
INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (1, 'architect');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (2, 'geologist');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (3, 'designer, graphic');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (4, 'designer, web');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (5, 'designer, industrial');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (6, 'designer, interieur');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (7, 'student');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (8, 'architect, landscape');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (9, 'teacher');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (10, 'writer');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (11, 'designer, interface');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (12, 'designer, screen');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (13, 'administrator');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (14, 'webmaster');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (15, 'geographer');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (16, 'artist');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (17, 'system operator');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (18, 'academic');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (19, 'theorist');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (20, 'critic');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (21, 'journalist');

INSERT INTO `phpwcms_profession` (`prof_id`, `prof_name`) VALUES (22, ' n/a');

ALTER TABLE `phpwcms_template` ADD `template_type` INT( 11 ) NOT NULL DEFAULT '0' AFTER `template_id` ;

ALTER TABLE `phpwcms_userdetail` CHANGE `detail_newsletter` `detail_newsletter` INT( 11 ) NOT NULL DEFAULT '0' ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_website` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_userimage` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_varchar1` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_varchar2` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_varchar3` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_varchar4` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_varchar5` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_text1` TEXT NOT NULL ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_text2` TEXT NOT NULL ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_text3` TEXT NOT NULL ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_formid` INT( 11 ) NOT NULL DEFAULT '0' AFTER `detail_pid` ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_gender` VARCHAR( 255 ) NOT NULL AFTER `detail_userimage` ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_birthday` DATE NOT NULL DEFAULT '0000-00-00' AFTER `detail_gender` ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_email` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` ADD `detail_password` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` ADD INDEX ( `detail_formid` ) ;
ALTER TABLE `phpwcms_userdetail` ADD INDEX ( `detail_pid` ) ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_title` `detail_title` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_firstname` `detail_firstname` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_lastname` `detail_lastname` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_company` `detail_company` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_street` `detail_street` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_add` `detail_add` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_city` `detail_city` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_zip` `detail_zip` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_region` `detail_region` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_country` `detail_country` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_fon` `detail_fon` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_fax` `detail_fax` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_mobile` `detail_mobile` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_fax` `detail_fax` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `phpwcms_userdetail` CHANGE `detail_prof` `detail_prof` VARCHAR( 255 ) NOT NULL ;


DROP TABLE `phpwcms_sysvalue` ;

CREATE TABLE `phpwcms_sysvalue` (
  `sysvalue_key` varchar(255) NOT NULL default '',
  `sysvalue_tstamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `sysvalue_type` varchar(255) NOT NULL default '',
  `sysvalue_value` mediumblob NOT NULL,
  `sysvalue_status` int(1) NOT NULL default '0',
  PRIMARY KEY  (`sysvalue_key`)
) ENGINE=MyISAM;

Cheers,

Yves

Post by **Oliver Georgi** » Thu 12. Apr 2007, 06:53

sysvalue is still unused.

Oliver

StudioZ · Post by **StudioZ** » Thu 12. Apr 2007, 15:14

Oliver Georgi wrote:sysvalue is still unused.

Oliver

Oh ! OK

Thanks for confirming

Cheers,

Yves

Post by **juergen** » Sun 29. Apr 2007, 17:35

Hey @all

While updating from pre1.2.9 ->1.3.2.1 this happend to me....

So I took StudioZ's sql to my database... the fields are here now, there is a Standart "0000-00-00 00:00:00" Entries..., but when making new content part :error while creating new article content: Unknown column 'acontent_created' in 'field list'

Anything else working extra super fine

Checked collation and all the things... WHERE AM I STUPID ?

Jürgen
p.s.: Didn't try to make a new article at all... will do this later

DeXXus · Post by **DeXXus** » Sun 29. Apr 2007, 20:21

StudioZ wrote:OK.

Here's the complete SQL you should run to upgrade from pre1.2.9 to 1.3.0
I ceated a new SQL file that I named: 15a__pre1.2.9-DEV_to_1.3.0.sql
Code: Select all
-SNIP-

ALTER TABLE `phpwcms_articlecontent` ADD `acontent_created` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `acontent_uid` ;

-SNIP-
Cheers,

Yves

Hmm, he has it listed...
Did you confirm that it is NOT existing in the dB?

Post by **juergen** » Sun 29. Apr 2007, 20:45

Hi Dexxus

it is inside, I just took Yves complete package direct via mysqladmin....
Just reproduced this with deleting this single entry.... and redoing your quoted snip..

Afterwards I redid all the upgrades 1.2.9->1.3.0 and ->1.3.2

same ...

Post by **juergen** » Tue 1. May 2007, 21:24

using database1 and screwing in database2 might not get best results

S * O * L * V * E * D

TAOG · Post by **TAOG** » Fri 7. Dec 2007, 12:28

DeXXus wrote:
StudioZ wrote:OK.

Here's the complete SQL you should run to upgrade from pre1.2.9 to 1.3.0
I ceated a new SQL file that I named: 15a__pre1.2.9-DEV_to_1.3.0.sql
Code: Select all
-SNIP-

ALTER TABLE `phpwcms_articlecontent` ADD `acontent_created` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `acontent_uid` ;

-SNIP-
Cheers,

Yves
Hmm, he has it listed...
Did you confirm that it is NOT existing in the dB?

the code snipe, solved my problem. tnx