Sql fout

Beste mensen,

Ik heb een gratis gpt gedownload en ik wil nu het sql bestand in mijn database zetten, alleen er zit een fout in. Wie wil me helpen
Bestandje:

CREATE TABLE `adminmessage` ( `mid` int(11) NOT NULL auto_increment, `sentdate` date NOT NULL default 0000-00-00, `sentto` varchar(50) NOT NULL default , `subject` varchar(255) NOT NULL default , `content` text NOT NULL, `removed` text NOT NULL, PRIMARY KEY (`mid`) ) ; CREATE TABLE `adorders` ( `aid` int(11) NOT NULL auto_increment, `descr1` varchar(255) NOT NULL default , `descr2` varchar(255) NOT NULL default , `advertiser` varchar(15) NOT NULL default , `is_processed` char(1) binary NOT NULL default 0, PRIMARY KEY (`aid`) ); CREATE TABLE `adpackcategories` ( `apid` int(11) NOT NULL auto_increment, `apname` varchar(255) NOT NULL default , PRIMARY KEY (`apid`) ); CREATE TABLE `adpacks` ( `aid` int(11) NOT NULL auto_increment, `acatid` int(11) NOT NULL default 0, `adescription` varchar(255) NOT NULL default , `acost` float NOT NULL default 0, PRIMARY KEY (`aid`) ); CREATE TABLE `banned` ( `bid` int(11) NOT NULL auto_increment, `bdomain` varchar(200) NOT NULL default , PRIMARY KEY (`bid`) ); CREATE TABLE `banner` ( `banid` int(11) NOT NULL auto_increment, `remain` int(11) NOT NULL default 0, `imageurl` varchar(255) NOT NULL default , `linkurl` varchar(255) NOT NULL default , `advlogin` varchar(50) NOT NULL default , `advpass` varchar(50) NOT NULL default , `clicks` int(11) NOT NULL default 0, PRIMARY KEY (`banid`) ) AUTO_INCREMENT=2 ; INSERT INTO `banner` VALUES (1, 10000, http://altercoder.com/acgbanner.gif, http://altercoder.com, lepunk, , 0); CREATE TABLE `countries` ( `country` varchar(50) default NULL ); INSERT INTO `countries` VALUES (Afghanistan); INSERT INTO `countries` VALUES (Albania); INSERT INTO `countries` VALUES (Algeria); INSERT INTO `countries` VALUES (American Samoa); INSERT INTO `countries` VALUES (Andorra); INSERT INTO `countries` VALUES (Angola); INSERT INTO `countries` VALUES (Anguilla); INSERT INTO `countries` VALUES (Antarctica); INSERT INTO `countries` VALUES (Antigua and Barbuda); INSERT INTO `countries` VALUES (Argentina); INSERT INTO `countries` VALUES (Armenia); INSERT INTO `countries` VALUES (Aruba); INSERT INTO `countries` VALUES (Australia); INSERT INTO `countries` VALUES (Austria); INSERT INTO `countries` VALUES (Azerbaijan); INSERT INTO `countries` VALUES (Bahamas); INSERT INTO `countries` VALUES (Bahrain); INSERT INTO `countries` VALUES (Bangladesh); INSERT INTO `countries` VALUES (Barbados); INSERT INTO `countries` VALUES (Belarus); INSERT INTO `countries` VALUES (Belgium); INSERT INTO `countries` VALUES (Belize); INSERT INTO `countries` VALUES (Benin); INSERT INTO `countries` VALUES (Bermuda); INSERT INTO `countries` VALUES (Bhutan); INSERT INTO `countries` VALUES (Bolivia); INSERT INTO `countries` VALUES (Bosnia and Herzegowina); INSERT INTO `countries` VALUES (Botswana); INSERT INTO `countries` VALUES (Bouvet Island); INSERT INTO `countries` VALUES (Brazil); INSERT INTO `countries` VALUES (British Indian Ocean Territory); INSERT INTO `countries` VALUES (British Virgin Islands); INSERT INTO `countries` VALUES (Brunei Darussalam); INSERT INTO `countries` VALUES (Bulgaria); INSERT INTO `countries` VALUES (Burkina Faso); INSERT INTO `countries` VALUES (Burundi); INSERT INTO `countries` VALUES (Cambodia); INSERT INTO `countries` VALUES (Cameroon); INSERT INTO `countries` VALUES (Canada); INSERT INTO `countries` VALUES (Cape Verde); INSERT INTO `countries` VALUES (Cayman Islands); INSERT INTO `countries` VALUES (Central African Republic); INSERT INTO `countries` VALUES (Chad); INSERT INTO `countries` VALUES (Chile); INSERT INTO `countries` VALUES (China); INSERT INTO `countries` VALUES (Christmas Island); INSERT INTO `countries` VALUES (Cocos (Keeling) Islands); INSERT INTO `countries` VALUES (Colombia); INSERT INTO `countries` VALUES (Comoros); INSERT INTO `countries` VALUES (Congo); INSERT INTO `countries` VALUES (Cook Islands); INSERT INTO `countries` VALUES (Costa Rica); INSERT INTO `countries` VALUES (Cote Divoire); INSERT INTO `countries` VALUES (Croatia); INSERT INTO `countries` VALUES (Cuba); INSERT INTO `countries` VALUES (Cyprus); INSERT INTO `countries` VALUES (Czech Republic); INSERT INTO `countries` VALUES (Czechoslovakia); INSERT INTO `countries` VALUES (Denmark); INSERT INTO `countries` VALUES (Djibouti); INSERT INTO `countries` VALUES (Dominica); INSERT INTO `countries` VALUES (Dominican Republic); INSERT INTO `countries` VALUES (East Timor); INSERT INTO `countries` VALUES (Ecuador); INSERT INTO `countries` VALUES (Egypt); INSERT INTO `countries` VALUES (El Salvador); INSERT INTO `countries` VALUES (Equatorial Guinea); INSERT INTO `countries` VALUES (Eritrea); INSERT INTO `countries` VALUES (Estonia); INSERT INTO `countries` VALUES (Ethiopia); INSERT INTO `countries` VALUES (Falkland Islands (Malvinas)); INSERT INTO `countries` VALUES (Faroe Islands); INSERT INTO `countries` VALUES (Fiji); INSERT INTO `countries` VALUES (Finland); INSERT INTO `countries` VALUES (France); INSERT INTO `countries` VALUES (France, Metropolitan); INSERT INTO `countries` VALUES (French Guiana); INSERT INTO `countries` VALUES (French Polynesia); INSERT INTO `countries` VALUES (French Southern Territories); INSERT INTO `countries` VALUES (Gabon); INSERT INTO `countries` VALUES (Gambia); INSERT INTO `countries` VALUES (Georgia); INSERT INTO `countries` VALUES (Germany); INSERT INTO `countries` VALUES (Ghana); INSERT INTO `countries` VALUES (Gibraltar); INSERT INTO `countries` VALUES (Greece); INSERT INTO `countries` VALUES (Greenland); INSERT INTO `countries` VALUES (Grenada); INSERT INTO `countries` VALUES (Guadeloupe); INSERT INTO `countries` VALUES (Guam); INSERT INTO `countries` VALUES (Guatemala); INSERT INTO `countries` VALUES (Guinea); INSERT INTO `countries` VALUES (Guinea-Bissau); INSERT INTO `countries` VALUES (Guyana); INSERT INTO `countries` VALUES (Haiti); INSERT INTO `countries` VALUES (Heard and McDonald Islands); INSERT INTO `countries` VALUES (Honduras); INSERT INTO `countries` VALUES (Hong Kong); INSERT INTO `countries` VALUES (Hungary); INSERT INTO `countries` VALUES (Iceland); INSERT INTO `countries` VALUES (India); INSERT INTO `countries` VALUES (Indonesia); INSERT INTO `countries` VALUES (Iraq); INSERT INTO `countries` VALUES (Ireland); INSERT INTO `countries` VALUES (Islamic Republic of Iran); INSERT INTO `countries` VALUES (Israel); INSERT INTO `countries` VALUES (Italy); INSERT INTO `countries` VALUES (Jamaica); INSERT INTO `countries` VALUES (Japan); INSERT INTO `countries` VALUES (Jordan); INSERT INTO `countries` VALUES (Kazakhstan); INSERT INTO `countries` VALUES (Kenya); INSERT INTO `countries` VALUES (Kiribati); INSERT INTO `countries` VALUES (Korea, Democratic Peoples Republic of); INSERT INTO `countries` VALUES (Korea, Republic of); INSERT INTO `countries` VALUES (Kuwait); INSERT INTO `countries` VALUES (Kyrgyzstan); INSERT INTO `countries` VALUES (Laos); INSERT INTO `countries` VALUES (Latvia); INSERT INTO `countries` VALUES (Lebanon); INSERT INTO `countries` VALUES (Lesotho); INSERT INTO `countries` VALUES (Liberia); INSERT INTO `countries` VALUES (Libyan Arab Jamahiriya); INSERT INTO `countries` VALUES (Liechtenstein); INSERT INTO `countries` VALUES (Lithuania); INSERT INTO `countries` VALUES (Luxembourg); INSERT INTO `countries` VALUES (Macau); INSERT INTO `countries` VALUES (Macedonia); INSERT INTO `countries` VALUES (Madagascar); INSERT INTO `countries` VALUES (Malawi); INSERT INTO `countries` VALUES (Malaysia); INSERT INTO `countries` VALUES (Maldives); INSERT INTO `countries` VALUES (Mali); INSERT INTO `countries` VALUES (Malta); INSERT INTO `countries` VALUES (Marshall Islands); INSERT INTO `countries` VALUES (Martinique); INSERT INTO `countries` VALUES (Mauritania); INSERT INTO `countries` VALUES (Mauritius); INSERT INTO `countries` VALUES (Mayotte); INSERT INTO `countries` VALUES (Mexico); INSERT INTO `countries` VALUES (Micronesia); INSERT INTO `countries` VALUES (Moldova, Republic of); INSERT INTO `countries` VALUES (Monaco); INSERT INTO `countries` VALUES (Mongolia); INSERT INTO `countries` VALUES (Montserrat); INSERT INTO `countries` VALUES (Morocco); INSERT INTO `countries` VALUES (Mozambique); INSERT INTO `countries` VALUES (Myanmar); INSERT INTO `countries` VALUES (Namibia); INSERT INTO `countries` VALUES (Nauru); INSERT INTO `countries` VALUES (Nepal); INSERT INTO `countries` VALUES (Netherlands); INSERT INTO `countries` VALUES (Netherlands Antilles); INSERT INTO `countries` VALUES (New Caledonia); INSERT INTO `countries` VALUES (New Zealand); INSERT INTO `countries` VALUES (Nicaragua); INSERT INTO `countries` VALUES (Niger); INSERT INTO `countries` VALUES (Nigeria); INSERT INTO `countries` VALUES (Niue); INSERT INTO `countries` VALUES (Norfolk Island); INSERT INTO `countries` VALUES (Northern Mariana Islands); INSERT INTO `countries` VALUES (Norway); INSERT INTO `countries` VALUES (Oman); INSERT INTO `countries` VALUES (Pakistan); INSERT INTO `countries` VALUES (Palau); INSERT INTO `countries` VALUES (Panama); INSERT INTO `countries` VALUES (Papua New Guinea); INSERT INTO `countries` VALUES (Paraguay); INSERT INTO `countries` VALUES (Peru); INSERT INTO `countries` VALUES (Philippines); INSERT INTO `countries` VALUES (Pitcairn); INSERT INTO `countries` VALUES (Poland); INSERT INTO `countries` VALUES (Portugal); INSERT INTO `countries` VALUES (Puerto Rico); INSERT INTO `countries` VALUES (Qatar); INSERT INTO `countries` VALUES (Reunion); INSERT INTO `countries` VALUES (Romania); INSERT INTO `countries` VALUES (Russian Federation); INSERT INTO `countries` VALUES (Rwanda); INSERT INTO `countries` VALUES (Saint Lucia); INSERT INTO `countries` VALUES (Samoa); INSERT INTO `countries` VALUES (San Marino); INSERT INTO `countries` VALUES (Sao Tome and Principe); INSERT INTO `countries` VALUES (Saudi Arabia); INSERT INTO `countries` VALUES (Senegal); INSERT INTO `countries` VALUES (Seychelles); INSERT INTO `countries` VALUES (Sierra Leone); INSERT INTO `countries` VALUES (Singapore); INSERT INTO `countries` VALUES (Slovakia); INSERT INTO `countries` VALUES (Slovenia); INSERT INTO `countries` VALUES (Solomon Islnds); INSERT INTO `countries` VALUES (Somalia); INSERT INTO `countries` VALUES (South Africa); INSERT INTO `countries` VALUES (South Georgia and The South Sandwich Islands); INSERT INTO `countries` VALUES (Spain); INSERT INTO `countries` VALUES (Sri Lanka); INSERT INTO `countries` VALUES (St. Helena); INSERT INTO `countries` VALUES (St. Kitts And Nevis); INSERT INTO `countries` VALUES (St. Pierre and Miquelon); INSERT INTO `countries` VALUES (St. Vincent And The Greadines); INSERT INTO `countries` VALUES (Sudan); INSERT INTO `countries` VALUES (Suriname); INSERT INTO `countries` VALUES (Svalbard and Jan Mayen Islands); INSERT INTO `countries` VALUES (Swaziland); INSERT INTO `countries` VALUES (Sweden); INSERT INTO `countries` VALUES (Switzerland); INSERT INTO `countries` VALUES (Syrian Arab Republic); INSERT INTO `countries` VALUES (Taiwan); INSERT INTO `countries` VALUES (Tajikistan); INSERT INTO `countries` VALUES (Tanzania, United Republic of); INSERT INTO `countries` VALUES (Thailand); INSERT INTO `countries` VALUES (Togo); INSERT INTO `countries` VALUES (Tokelau); INSERT INTO `countries` VALUES (Tonga); INSERT INTO `countries` VALUES (Trinidad and Tobago); INSERT INTO `countries` VALUES (Tunisia); INSERT INTO `countries` VALUES (Turkey); INSERT INTO `countries` VALUES (Turkmenistan); INSERT INTO `countries` VALUES (Turks and Caicos Islands); INSERT INTO `countries` VALUES (Tuvalu); INSERT INTO `countries` VALUES (Uganda); INSERT INTO `countries` VALUES (Ukraine); INSERT INTO `countries` VALUES (United Arab Emirates); INSERT INTO `countries` VALUES (United Kingdom (Great Britain)); INSERT INTO `countries` VALUES (United States); INSERT INTO `countries` VALUES (United States Minor Outlying Islands); INSERT INTO `countries` VALUES (United States Virgin Islands); INSERT INTO `countries` VALUES (Uruguay); INSERT INTO `countries` VALUES (Uzbekistan); INSERT INTO `countries` VALUES (Vanuatu); INSERT INTO `countries` VALUES (Vatican City State); INSERT INTO `countries` VALUES (Venezuela); INSERT INTO `countries` VALUES (Viet Nam); INSERT INTO `countries` VALUES (Wallis And Futuna Islands); INSERT INTO `countries` VALUES (Western Sahara); INSERT INTO `countries` VALUES (Yemen); INSERT INTO `countries` VALUES (Yugoslavia); INSERT INTO `countries` VALUES (Zaire); INSERT INTO `countries` VALUES (Zambia); INSERT INTO `countries` VALUES (Zimbabwe); CREATE TABLE `credits` ( `s_date` date NOT NULL default 0000-00-00, `s_reason` varchar(100) NOT NULL default , `s_amount` float NOT NULL default 0, `s_user` varchar(15) NOT NULL default , `s_type` char(1) binary NOT NULL default  ); CREATE TABLE `debits` ( `s_date` date NOT NULL default 0000-00-00, `s_amount` float NOT NULL default 0, `s_reason` varchar(100) NOT NULL default , `s_user` varchar(50) NOT NULL default , `s_type` char(1) binary NOT NULL default 0 ); CREATE TABLE `exchange_history` ( `eid` int(11) NOT NULL auto_increment, `euser` varchar(15) NOT NULL default , `edate` date NOT NULL default 0000-00-00, `ereturn` float NOT NULL default 0, PRIMARY KEY (`eid`) ); CREATE TABLE `investment_history` ( `iid` int(11) NOT NULL auto_increment, `usrid` varchar(15) default NULL, `amount` float default 0, `descr` varchar(100) default NULL, `is_from` varchar(50) default 0, `processor` varchar(100) default NULL, `adate` date default 0000-00-00, `expired` char(3) default no, `batch` varchar(20) NOT NULL default , PRIMARY KEY (`iid`) ); CREATE TABLE `merchant_codes` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) default NULL, `code` text, PRIMARY KEY (`id`) ); CREATE TABLE `payout_history` ( `pid` int(11) NOT NULL auto_increment, `puser` varchar(15) NOT NULL default , `pamount` float NOT NULL default 0, `pdate` date NOT NULL default 0000-00-00, `pprocessor` varchar(8) NOT NULL default , `ppayto` varchar(50) NOT NULL default , `pstatus` char(1) binary NOT NULL default , PRIMARY KEY (`pid`) ); CREATE TABLE `ptc` ( `pid` int(11) NOT NULL auto_increment, `purl` varchar(255) NOT NULL default , `pbanner` varchar(255) NOT NULL default , `pcost` float NOT NULL default 0, `phits` int(11) NOT NULL default 0, `pviews` int(11) NOT NULL default 0, `padvertiser` varchar(25) NOT NULL default , PRIMARY KEY (`pid`) ); CREATE TABLE `ptcclicks` ( `tid` int(11) NOT NULL default 0, `uid` varchar(50) NOT NULL default 0, `fdate` date NOT NULL default 0000-00-00 ); CREATE TABLE `ptpapproved` ( `url` varchar(255) NOT NULL default , `tothits` int(11) NOT NULL default 0, PRIMARY KEY (`url`) ); CREATE TABLE `ptphits` ( `h_date` date NOT NULL default 0000-00-00, `h_user` varchar(15) NOT NULL default 0, `h_ip` varchar(23) NOT NULL default , `h_referrer` varchar(200) NOT NULL default , `h_site` int(11) NOT NULL default 0 ); CREATE TABLE `ptpsites` ( `siteid` int(11) NOT NULL auto_increment, `url` varchar(255) NOT NULL default , `credits` int(11) NOT NULL default 0, `user` varchar(15) NOT NULL default 0, PRIMARY KEY (`siteid`) ); CREATE TABLE `refpageviews` ( `vid` int(11) NOT NULL auto_increment, `vdate` date NOT NULL default 0000-00-00, `vip` varchar(15) NOT NULL default , `vuser` varchar(25) NOT NULL default , PRIMARY KEY (`vid`) ); CREATE TABLE `reglog` ( `iid` int(11) NOT NULL auto_increment, `ruser` varchar(30) NOT NULL default , `rcomefrom` varchar(255) NOT NULL default , PRIMARY KEY (`iid`) ); CREATE TABLE `setupinfo` ( `siteurl` varchar(255) default NULL, `adminmail` varchar(255) default NULL, `sitetitle` varchar(255) default NULL, `subonus` float default NULL, `rlevels` tinyint(4) default NULL, `refpc1` float default NULL, `refpc2` float default NULL, `refpc3` float default NULL, `refpc4` float default NULL, `refpc5` float default NULL, `refpc6` float default NULL, `refpc7` float default NULL, `refpc8` float default NULL, `refpc9` float default NULL, `refpc10` float default NULL ); INSERT INTO `setupinfo` VALUES (http://acgptc12.uw.hu, admin@altercoder.com, ACG.PTCinvestment 1.2 demo, 0, 1, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0); CREATE TABLE `textlinks` ( `linkid` int(11) NOT NULL auto_increment, `ltitle` varchar(255) default NULL, `lurl` varchar(255) default NULL, `ladvname` varchar(50) default NULL, `ladvpass` varchar(50) default NULL, `lexpire` int(11) default NULL, `lhits` int(11) default NULL, `limpress` int(11) default NULL, PRIMARY KEY (`linkid`) ); CREATE TABLE `trading` ( `tid` int(11) NOT NULL auto_increment, `tseller` varchar(15) NOT NULL default , `tamount` float NOT NULL default 0, `tcost` float NOT NULL default 0, `tstatus` tinyint(4) NOT NULL default 0, `t_selldate` date NOT NULL default 0000-00-00, `tcpp` float NOT NULL default 0, PRIMARY KEY (`tid`) ); CREATE TABLE `users` ( `uid` int(11) NOT NULL auto_increment, `username` varchar(50) default NULL, `email` varchar(100) default NULL, `firstn` varchar(50) default NULL, `lastn` varchar(50) default NULL, `address` varchar(255) default NULL, `city` varchar(100) default NULL, `state` varchar(100) default NULL, `country` varchar(100) default NULL, `ref` varchar(50) default NULL, `password` varchar(50) default NULL, `ip` varchar(20) default NULL, `status` varchar(20) default NULL, `confid` int(11) default NULL, `regdate` date default 0000-00-00, `referrer1` varchar(50) default NULL, `referrer2` varchar(50) default NULL, `referrer3` varchar(50) default NULL, `referrer4` varchar(50) default NULL, `referrer5` varchar(50) default NULL, `referrer6` varchar(50) default NULL, `referrer7` varchar(50) default NULL, `referrer8` varchar(50) default NULL, `referrer9` varchar(50) default NULL, `referrer10` varchar(50) default NULL, `lastlogin` date default 0000-00-00, `earned` float default NULL, `invested` float default NULL, `roi_cash` float default NULL, PRIMARY KEY (`uid`), UNIQUE KEY `username` (`username`) );

Fout:
Fatal error: Allowed memory size of 31457280 bytes exhausted (tried to allocate 3690480 bytes) in /var/www/html/phpMyAdmin-3.1.5-all-languages/navigation.php on line 83

Post het bestandje & de fout dan

Ik zal kijken wat ik erop kan zetten, ik probeer hem er voor 6 uur op te hebben.

Je query is te groot o/

Je host ondersteunt niet zon grote query volgens mij, of je mysql database is al te vol

Deel hem in 2en ofzo.

Zal ik doen! Bedankt voor jullie reacties!

Edit: Hoe deel ik hem in tweeen?

Wat een vervelende Query

CREATE TABLE `adminmessage` ( `mid` int(11) NOT NULL auto_increment, `sentdate` date NOT NULL default 0000-00-00, `sentto` varchar(50) NOT NULL default , `subject` varchar(255) NOT NULL default , `content` text NOT NULL, `removed` text NOT NULL, PRIMARY KEY (`mid`) ) ; CREATE TABLE `adorders` ( `aid` int(11) NOT NULL auto_increment, `descr1` varchar(255) NOT NULL default , `descr2` varchar(255) NOT NULL default , `advertiser` varchar(15) NOT NULL default , `is_processed` char(1) binary NOT NULL default 0, PRIMARY KEY (`aid`) ); CREATE TABLE `adpackcategories` ( `apid` int(11) NOT NULL auto_increment, `apname` varchar(255) NOT NULL default , PRIMARY KEY (`apid`) ); CREATE TABLE `adpacks` ( `aid` int(11) NOT NULL auto_increment, `acatid` int(11) NOT NULL default 0, `adescription` varchar(255) NOT NULL default , `acost` float NOT NULL default 0, PRIMARY KEY (`aid`) ); CREATE TABLE `banned` ( `bid` int(11) NOT NULL auto_increment, `bdomain` varchar(200) NOT NULL default , PRIMARY KEY (`bid`) ); CREATE TABLE `banner` ( `banid` int(11) NOT NULL auto_increment, `remain` int(11) NOT NULL default 0, `imageurl` varchar(255) NOT NULL default , `linkurl` varchar(255) NOT NULL default , `advlogin` varchar(50) NOT NULL default , `advpass` varchar(50) NOT NULL default , `clicks` int(11) NOT NULL default 0, PRIMARY KEY (`banid`) ) AUTO_INCREMENT=2 ; INSERT INTO `banner` VALUES (1, 10000, http://altercoder.com/acgbanner.gif, http://altercoder.com, lepunk, , 0); CREATE TABLE `countries` ( `country` varchar(50) default NULL ); INSERT INTO `countries` VALUES (Afghanistan); INSERT INTO `countries` VALUES (Albania); INSERT INTO `countries` VALUES (Algeria); INSERT INTO `countries` VALUES (American Samoa); INSERT INTO `countries` VALUES (Andorra); INSERT INTO `countries` VALUES (Angola); INSERT INTO `countries` VALUES (Anguilla); INSERT INTO `countries` VALUES (Antarctica); INSERT INTO `countries` VALUES (Antigua and Barbuda); INSERT INTO `countries` VALUES (Argentina); INSERT INTO `countries` VALUES (Armenia); INSERT INTO `countries` VALUES (Aruba); INSERT INTO `countries` VALUES (Australia); INSERT INTO `countries` VALUES (Austria); INSERT INTO `countries` VALUES (Azerbaijan); INSERT INTO `countries` VALUES (Bahamas); INSERT INTO `countries` VALUES (Bahrain); INSERT INTO `countries` VALUES (Bangladesh); INSERT INTO `countries` VALUES (Barbados); INSERT INTO `countries` VALUES (Belarus); INSERT INTO `countries` VALUES (Belgium); INSERT INTO `countries` VALUES (Belize); INSERT INTO `countries` VALUES (Benin); INSERT INTO `countries` VALUES (Bermuda); INSERT INTO `countries` VALUES (Bhutan); INSERT INTO `countries` VALUES (Bolivia); INSERT INTO `countries` VALUES (Bosnia and Herzegowina); INSERT INTO `countries` VALUES (Botswana); INSERT INTO `countries` VALUES (Bouvet Island); INSERT INTO `countries` VALUES (Brazil); INSERT INTO `countries` VALUES (British Indian Ocean Territory); INSERT INTO `countries` VALUES (British Virgin Islands); INSERT INTO `countries` VALUES (Brunei Darussalam); INSERT INTO `countries` VALUES (Bulgaria); INSERT INTO `countries` VALUES (Burkina Faso); INSERT INTO `countries` VALUES (Burundi); INSERT INTO `countries` VALUES (Cambodia); INSERT INTO `countries` VALUES (Cameroon); INSERT INTO `countries` VALUES (Canada); INSERT INTO `countries` VALUES (Cape Verde); INSERT INTO `countries` VALUES (Cayman Islands); INSERT INTO `countries` VALUES (Central African Republic); INSERT INTO `countries` VALUES (Chad); INSERT INTO `countries` VALUES (Chile); INSERT INTO `countries` VALUES (China); INSERT INTO `countries` VALUES (Christmas Island); INSERT INTO `countries` VALUES (Cocos (Keeling) Islands); INSERT INTO `countries` VALUES (Colombia); INSERT INTO `countries` VALUES (Comoros); INSERT INTO `countries` VALUES (Congo); INSERT INTO `countries` VALUES (Cook Islands); INSERT INTO `countries` VALUES (Costa Rica); INSERT INTO `countries` VALUES (Cote Divoire); INSERT INTO `countries` VALUES (Croatia); INSERT INTO `countries` VALUES (Cuba); INSERT INTO `countries` VALUES (Cyprus); INSERT INTO `countries` VALUES (Czech Republic); INSERT INTO `countries` VALUES (Czechoslovakia); INSERT INTO `countries` VALUES (Denmark); INSERT INTO `countries` VALUES (Djibouti); INSERT INTO `countries` VALUES (Dominica); INSERT INTO `countries` VALUES (Dominican Republic); INSERT INTO `countries` VALUES (East Timor); INSERT INTO `countries` VALUES (Ecuador); INSERT INTO `countries` VALUES (Egypt); INSERT INTO `countries` VALUES (El Salvador); INSERT INTO `countries` VALUES (Equatorial Guinea); INSERT INTO `countries` VALUES (Eritrea); INSERT INTO `countries` VALUES (Estonia); INSERT INTO `countries` VALUES (Ethiopia); INSERT INTO `countries` VALUES (Falkland Islands (Malvinas)); INSERT INTO `countries` VALUES (Faroe Islands); INSERT INTO `countries` VALUES (Fiji); INSERT INTO `countries` VALUES (Finland); INSERT INTO `countries` VALUES (France); INSERT INTO `countries` VALUES (France, Metropolitan); INSERT INTO `countries` VALUES (French Guiana); INSERT INTO `countries` VALUES (French Polynesia); INSERT INTO `countries` VALUES (French Southern Territories); INSERT INTO `countries` VALUES (Gabon); INSERT INTO `countries` VALUES (Gambia); INSERT INTO `countries` VALUES (Georgia); INSERT INTO `countries` VALUES (Germany); INSERT INTO `countries` VALUES (Ghana); INSERT INTO `countries` VALUES (Gibraltar); INSERT INTO `countries` VALUES (Greece); INSERT INTO `countries` VALUES (Greenland); INSERT INTO `countries` VALUES (Grenada); INSERT INTO `countries` VALUES (Guadeloupe); INSERT INTO `countries` VALUES (Guam); INSERT INTO `countries` VALUES (Guatemala); INSERT INTO `countries` VALUES (Guinea); INSERT INTO `countries` VALUES (Guinea-Bissau); INSERT INTO `countries` VALUES (Guyana); INSERT INTO `countries` VALUES (Haiti); INSERT INTO `countries` VALUES (Heard and McDonald Islands); INSERT INTO `countries` VALUES (Honduras); INSERT INTO `countries` VALUES (Hong Kong); INSERT INTO `countries` VALUES (Hungary); INSERT INTO `countries` VALUES (Iceland); INSERT INTO `countries` VALUES (India); INSERT INTO `countries` VALUES (Indonesia); INSERT INTO `countries` VALUES (Iraq); INSERT INTO `countries` VALUES (Ireland); INSERT INTO `countries` VALUES (Islamic Republic of Iran); INSERT INTO `countries` VALUES (Israel); INSERT INTO `countries` VALUES (Italy); INSERT INTO `countries` VALUES (Jamaica); INSERT INTO `countries` VALUES (Japan); INSERT INTO `countries` VALUES (Jordan); INSERT INTO `countries` VALUES (Kazakhstan); INSERT INTO `countries` VALUES (Kenya); INSERT INTO `countries` VALUES (Kiribati); INSERT INTO `countries` VALUES (Korea, Democratic Peoples Republic of); INSERT INTO `countries` VALUES (Korea, Republic of); INSERT INTO `countries` VALUES (Kuwait); INSERT INTO `countries` VALUES (Kyrgyzstan); INSERT INTO `countries` VALUES (Laos); INSERT INTO `countries` VALUES (Latvia); INSERT INTO `countries` VALUES (Lebanon); INSERT INTO `countries` VALUES (Lesotho); INSERT INTO `countries` VALUES (Liberia); INSERT INTO `countries` VALUES (Libyan Arab Jamahiriya); INSERT INTO `countries` VALUES (Liechtenstein); INSERT INTO `countries` VALUES (Lithuania); INSERT INTO `countries` VALUES (Luxembourg); INSERT INTO `countries` VALUES (Macau); INSERT INTO `countries` VALUES (Macedonia); INSERT INTO `countries` VALUES (Madagascar); INSERT INTO `countries` VALUES (Malawi); INSERT INTO `countries` VALUES (Malaysia); INSERT INTO `countries` VALUES (Maldives); INSERT INTO `countries` VALUES (Mali); INSERT INTO `countries` VALUES (Malta); INSERT INTO `countries` VALUES (Marshall Islands); INSERT INTO `countries` VALUES (Martinique); INSERT INTO `countries` VALUES (Mauritania); INSERT INTO `countries` VALUES (Mauritius); INSERT INTO `countries` VALUES (Mayotte); INSERT INTO `countries` VALUES (Mexico);

eerst dit, en dan dit:

INSERT INTO `countries` VALUES (Micronesia); INSERT INTO `countries` VALUES (Moldova, Republic of); INSERT INTO `countries` VALUES (Monaco); INSERT INTO `countries` VALUES (Mongolia); INSERT INTO `countries` VALUES (Montserrat); INSERT INTO `countries` VALUES (Morocco); INSERT INTO `countries` VALUES (Mozambique); INSERT INTO `countries` VALUES (Myanmar); INSERT INTO `countries` VALUES (Namibia); INSERT INTO `countries` VALUES (Nauru); INSERT INTO `countries` VALUES (Nepal); INSERT INTO `countries` VALUES (Netherlands); INSERT INTO `countries` VALUES (Netherlands Antilles); INSERT INTO `countries` VALUES (New Caledonia); INSERT INTO `countries` VALUES (New Zealand); INSERT INTO `countries` VALUES (Nicaragua); INSERT INTO `countries` VALUES (Niger); INSERT INTO `countries` VALUES (Nigeria); INSERT INTO `countries` VALUES (Niue); INSERT INTO `countries` VALUES (Norfolk Island); INSERT INTO `countries` VALUES (Northern Mariana Islands); INSERT INTO `countries` VALUES (Norway); INSERT INTO `countries` VALUES (Oman); INSERT INTO `countries` VALUES (Pakistan); INSERT INTO `countries` VALUES (Palau); INSERT INTO `countries` VALUES (Panama); INSERT INTO `countries` VALUES (Papua New Guinea); INSERT INTO `countries` VALUES (Paraguay); INSERT INTO `countries` VALUES (Peru); INSERT INTO `countries` VALUES (Philippines); INSERT INTO `countries` VALUES (Pitcairn); INSERT INTO `countries` VALUES (Poland); INSERT INTO `countries` VALUES (Portugal); INSERT INTO `countries` VALUES (Puerto Rico); INSERT INTO `countries` VALUES (Qatar); INSERT INTO `countries` VALUES (Reunion); INSERT INTO `countries` VALUES (Romania); INSERT INTO `countries` VALUES (Russian Federation); INSERT INTO `countries` VALUES (Rwanda); INSERT INTO `countries` VALUES (Saint Lucia); INSERT INTO `countries` VALUES (Samoa); INSERT INTO `countries` VALUES (San Marino); INSERT INTO `countries` VALUES (Sao Tome and Principe); INSERT INTO `countries` VALUES (Saudi Arabia); INSERT INTO `countries` VALUES (Senegal); INSERT INTO `countries` VALUES (Seychelles); INSERT INTO `countries` VALUES (Sierra Leone); INSERT INTO `countries` VALUES (Singapore); INSERT INTO `countries` VALUES (Slovakia); INSERT INTO `countries` VALUES (Slovenia); INSERT INTO `countries` VALUES (Solomon Islnds); INSERT INTO `countries` VALUES (Somalia); INSERT INTO `countries` VALUES (South Africa); INSERT INTO `countries` VALUES (South Georgia and The South Sandwich Islands); INSERT INTO `countries` VALUES (Spain); INSERT INTO `countries` VALUES (Sri Lanka); INSERT INTO `countries` VALUES (St. Helena); INSERT INTO `countries` VALUES (St. Kitts And Nevis); INSERT INTO `countries` VALUES (St. Pierre and Miquelon); INSERT INTO `countries` VALUES (St. Vincent And The Greadines); INSERT INTO `countries` VALUES (Sudan); INSERT INTO `countries` VALUES (Suriname); INSERT INTO `countries` VALUES (Svalbard and Jan Mayen Islands); INSERT INTO `countries` VALUES (Swaziland); INSERT INTO `countries` VALUES (Sweden); INSERT INTO `countries` VALUES (Switzerland); INSERT INTO `countries` VALUES (Syrian Arab Republic); INSERT INTO `countries` VALUES (Taiwan); INSERT INTO `countries` VALUES (Tajikistan); INSERT INTO `countries` VALUES (Tanzania, United Republic of); INSERT INTO `countries` VALUES (Thailand); INSERT INTO `countries` VALUES (Togo); INSERT INTO `countries` VALUES (Tokelau); INSERT INTO `countries` VALUES (Tonga); INSERT INTO `countries` VALUES (Trinidad and Tobago); INSERT INTO `countries` VALUES (Tunisia); INSERT INTO `countries` VALUES (Turkey); INSERT INTO `countries` VALUES (Turkmenistan); INSERT INTO `countries` VALUES (Turks and Caicos Islands); INSERT INTO `countries` VALUES (Tuvalu); INSERT INTO `countries` VALUES (Uganda); INSERT INTO `countries` VALUES (Ukraine); INSERT INTO `countries` VALUES (United Arab Emirates); INSERT INTO `countries` VALUES (United Kingdom (Great Britain)); INSERT INTO `countries` VALUES (United States); INSERT INTO `countries` VALUES (United States Minor Outlying Islands); INSERT INTO `countries` VALUES (United States Virgin Islands); INSERT INTO `countries` VALUES (Uruguay); INSERT INTO `countries` VALUES (Uzbekistan); INSERT INTO `countries` VALUES (Vanuatu); INSERT INTO `countries` VALUES (Vatican City State); INSERT INTO `countries` VALUES (Venezuela); INSERT INTO `countries` VALUES (Viet Nam); INSERT INTO `countries` VALUES (Wallis And Futuna Islands); INSERT INTO `countries` VALUES (Western Sahara); INSERT INTO `countries` VALUES (Yemen); INSERT INTO `countries` VALUES (Yugoslavia); INSERT INTO `countries` VALUES (Zaire); INSERT INTO `countries` VALUES (Zambia); INSERT INTO `countries` VALUES (Zimbabwe); CREATE TABLE `credits` ( `s_date` date NOT NULL default 0000-00-00, `s_reason` varchar(100) NOT NULL default , `s_amount` float NOT NULL default 0, `s_user` varchar(15) NOT NULL default , `s_type` char(1) binary NOT NULL default  ); CREATE TABLE `debits` ( `s_date` date NOT NULL default 0000-00-00, `s_amount` float NOT NULL default 0, `s_reason` varchar(100) NOT NULL default , `s_user` varchar(50) NOT NULL default , `s_type` char(1) binary NOT NULL default 0 ); CREATE TABLE `exchange_history` ( `eid` int(11) NOT NULL auto_increment, `euser` varchar(15) NOT NULL default , `edate` date NOT NULL default 0000-00-00, `ereturn` float NOT NULL default 0, PRIMARY KEY (`eid`) ); CREATE TABLE `investment_history` ( `iid` int(11) NOT NULL auto_increment, `usrid` varchar(15) default NULL, `amount` float default 0, `descr` varchar(100) default NULL, `is_from` varchar(50) default 0, `processor` varchar(100) default NULL, `adate` date default 0000-00-00, `expired` char(3) default no, `batch` varchar(20) NOT NULL default , PRIMARY KEY (`iid`) ); CREATE TABLE `merchant_codes` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) default NULL, `code` text, PRIMARY KEY (`id`) ); CREATE TABLE `payout_history` ( `pid` int(11) NOT NULL auto_increment, `puser` varchar(15) NOT NULL default , `pamount` float NOT NULL default 0, `pdate` date NOT NULL default 0000-00-00, `pprocessor` varchar(8) NOT NULL default , `ppayto` varchar(50) NOT NULL default , `pstatus` char(1) binary NOT NULL default , PRIMARY KEY (`pid`) ); CREATE TABLE `ptc` ( `pid` int(11) NOT NULL auto_increment, `purl` varchar(255) NOT NULL default , `pbanner` varchar(255) NOT NULL default , `pcost` float NOT NULL default 0, `phits` int(11) NOT NULL default 0, `pviews` int(11) NOT NULL default 0, `padvertiser` varchar(25) NOT NULL default , PRIMARY KEY (`pid`) ); CREATE TABLE `ptcclicks` ( `tid` int(11) NOT NULL default 0, `uid` varchar(50) NOT NULL default 0, `fdate` date NOT NULL default 0000-00-00 ); CREATE TABLE `ptpapproved` ( `url` varchar(255) NOT NULL default , `tothits` int(11) NOT NULL default 0, PRIMARY KEY (`url`) ); CREATE TABLE `ptphits` ( `h_date` date NOT NULL default 0000-00-00, `h_user` varchar(15) NOT NULL default 0, `h_ip` varchar(23) NOT NULL default , `h_referrer` varchar(200) NOT NULL default , `h_site` int(11) NOT NULL default 0 ); CREATE TABLE `ptpsites` ( `siteid` int(11) NOT NULL auto_increment, `url` varchar(255) NOT NULL default , `credits` int(11) NOT NULL default 0, `user` varchar(15) NOT NULL default 0, PRIMARY KEY (`siteid`) ); CREATE TABLE `refpageviews` ( `vid` int(11) NOT NULL auto_increment, `vdate` date NOT NULL default 0000-00-00, `vip` varchar(15) NOT NULL default , `vuser` varchar(25) NOT NULL default , PRIMARY KEY (`vid`) ); CREATE TABLE `reglog` ( `iid` int(11) NOT NULL auto_increment, `ruser` varchar(30) NOT NULL default , `rcomefrom` varchar(255) NOT NULL default , PRIMARY KEY (`iid`) ); CREATE TABLE `setupinfo` ( `siteurl` varchar(255) default NULL, `adminmail` varchar(255) default NULL, `sitetitle` varchar(255) default NULL, `subonus` float default NULL, `rlevels` tinyint(4) default NULL, `refpc1` float default NULL, `refpc2` float default NULL, `refpc3` float default NULL, `refpc4` float default NULL, `refpc5` float default NULL, `refpc6` float default NULL, `refpc7` float default NULL, `refpc8` float default NULL, `refpc9` float default NULL, `refpc10` float default NULL ); INSERT INTO `setupinfo` VALUES (http://acgptc12.uw.hu, admin@altercoder.com, ACG.PTCinvestment 1.2 demo, 0, 1, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0); CREATE TABLE `textlinks` ( `linkid` int(11) NOT NULL auto_increment, `ltitle` varchar(255) default NULL, `lurl` varchar(255) default NULL, `ladvname` varchar(50) default NULL, `ladvpass` varchar(50) default NULL, `lexpire` int(11) default NULL, `lhits` int(11) default NULL, `limpress` int(11) default NULL, PRIMARY KEY (`linkid`) ); CREATE TABLE `trading` ( `tid` int(11) NOT NULL auto_increment, `tseller` varchar(15) NOT NULL default , `tamount` float NOT NULL default 0, `tcost` float NOT NULL default 0, `tstatus` tinyint(4) NOT NULL default 0, `t_selldate` date NOT NULL default 0000-00-00, `tcpp` float NOT NULL default 0, PRIMARY KEY (`tid`) ); CREATE TABLE `users` ( `uid` int(11) NOT NULL auto_increment, `username` varchar(50) default NULL, `email` varchar(100) default NULL, `firstn` varchar(50) default NULL, `lastn` varchar(50) default NULL, `address` varchar(255) default NULL, `city` varchar(100) default NULL, `state` varchar(100) default NULL, `country` varchar(100) default NULL, `ref` varchar(50) default NULL, `password` varchar(50) default NULL, `ip` varchar(20) default NULL, `status` varchar(20) default NULL, `confid` int(11) default NULL, `regdate` date default 0000-00-00, `referrer1` varchar(50) default NULL, `referrer2` varchar(50) default NULL, `referrer3` varchar(50) default NULL, `referrer4` varchar(50) default NULL, `referrer5` varchar(50) default NULL, `referrer6` varchar(50) default NULL, `referrer7` varchar(50) default NULL, `referrer8` varchar(50) default NULL, `referrer9` varchar(50) default NULL, `referrer10` varchar(50) default NULL, `lastlogin` date default 0000-00-00, `earned` float default NULL, `invested` float default NULL, `roi_cash` float default NULL, PRIMARY KEY (`uid`), UNIQUE KEY `username` (`username`) );

lol, waarom al die insert regels apart ?

Dat is niet zo slim

Dat ga je op je teller zien..

Ik heb in notepad (ja, lol) gewoon eventjes in tweeën gekapt, zou toch moeten gaan?

Quote:

CREATE TABLE `adminmessage` ( `midden` int (11) NOT NULL auto_increment, `sentdate` date NOT NULL default 0000-00-00 , `sentto` varchar (50) NOT NULL default, `onderwerp` varchar (255) NOT NULL default, `content` text NOT NULL, `geschrapt` text NOT NULL, PRIMARY KEY ( `midden`)); CREATE TABLE `adorders` ( `steun" int (11) NOT NULL auto_increment, `descr1` varchar (255) NOT NULL default, `descr2` varchar (255) NOT NULL default, `adverteerder` varchar (15) NOT NULL default, `is_processed` char (1) binary NOT NULL default 0 , PRIMARY KEY ( `steun")); CREATE TABLE `adpackcategories` ( `ApID` int (11) NOT NULL auto_increment, `apname` varchar (255) NOT NULL default , NULL PRIMARY KEY ( `ApID`)); CREATE TABLE `adpacks` ( `hulp` int (11) NOT NULL auto_increment, `acatid` int (11) NOT default 0 , `adescription` varchar (255) NOT NULL default, `deenis blanco` float NOT NULL default 0 , PRIMARY KEY ( `steun")); CREATE TABLE `verboden` ( `bid` int (11) NOT NULL auto_increment, `bdomain` varchar (200) NOT NULL default, PRIMARY KEY ( `bid`)); CREATE TABLE `banner` ( `banid` int (11) NOT NULL auto_increment, `nog` int (11) NOT NULL default 0 , `imageurl` varchar (255 ) NOT NULL default, `linkurl` varchar (255) NOT NULL default, `advlogin` varchar (50) NOT NULL default, `advpass` varchar (50) NOT NULL default, `clicks` int (11) NOT NULL default 0 , PRIMARY KEY ( `banid`)) AUTO_INCREMENT = 2; INSERT INTO `banner` VALUES (1, 10000, http://altercoder.com/acgbanner.gif , http: / / altercoder.com , lepunk ,, 0); CREATE TABLE `landen` ( `land` varchar (50) default NULL); INSERT INTO `landen` VALUES ( Afghanistan ); INSERT INTO `landen `VALUES ( Albani); INSERT INTO` landen `VALUES ( Algerije); INSERT INTO` landen `VALUES ( Amerikaans Samoa); INSERT INTO` landen `VALUES ( Andorra); INSERT INTO` landen ` VALUES ( Angola); INSERT INTO `landen` VALUES ( Anguilla); INSERT INTO `landen` VALUES ( Antarctica); INSERT INTO `landen` VALUES ( Antigua en Barbuda); INSERT INTO `landen` VALUES ( Argentini); INSERT INTO `landen` VALUES ( Armeni); INSERT INTO `landen` VALUES ( Aruba); INSERT INTO `landen` VALUES ( Australia); INSERT INTO `landen` VALUES ( Oostenrijk); INSERT INTO `landen` VALUES ( Azerbeidzjan); INSERT INTO `landen` VALUES ( Bahamas); INSERT INTO `landen` VALUES ( Bahrein); INSERT INTO `landen` VALUES ( Bangladesh ); INSERT INTO `landen` VALUES ( Barbados ); INSERT INTO `landen` VALUES ( Belarus ); INSERT INTO `landen` VALUES ( Belgi ); INSERT INTO `landen` VALUES ( Belize ) ; INSERT INTO `landen` VALUES ( Benin); INSERT INTO `landen` VALUES ( Bermuda); INSERT INTO `landen` VALUES ( Bhutan); INSERT INTO `landen` VALUES ( Bolivia); INSERT INTO `landen` VALUES ( Bosni en Herzegovina); INSERT INTO `landen` VALUES ( Botswana); INSERT INTO `landen` VALUES ( Bouvet Island); INSERT INTO `landen` VALUES ( Brazil); INSERT INTO `landen` VALUES ( British Indian Ocean Territory); INSERT INTO `landen` VALUES ( Britse Maagdeneilanden); INSERT INTO `landen` VALUES ( Brunei Darussalam); INSERT INTO `landen` VALUES (  Bulgarije "); INSERT INTO` landen `VALUES ( Burkina Faso); INSERT INTO` landen `VALUES ( Burundi); INSERT INTO` landen `VALUES ( Cambodja); INSERT INTO` landen `VALUES ( Kameroen ); INSERT INTO `landen` VALUES ( "Canada"); INSERT INTO `landen` VALUES ( Cape Verde ); INSERT INTO `landen` VALUES ( Caymaneilanden ); INSERT INTO `landen` VALUES ( Centraal Afrikaanse Republiek ); INSERT INTO `landen" VALUES ( Tsjaad ); INSERT INTO `landen" VALUES ( Chili ); INSERT INTO `landen" VALUES ( China ); INSERT INTO `landen" VALUES ( Christmas Eiland ); INSERT INTO `landen` VALUES ( Cocos (Keeling) Islands ); INSERT INTO `landen` VALUES ( Colombia ); INSERT INTO `landen` VALUES ( Comoren ); INSERT INTO `landen` VALUES ( Congo); INSERT INTO `landen` VALUES ( Cook-eilanden); INSERT INTO `landen` VALUES ( Costa Rica); INSERT INTO `landen` VALUES ( Cote Divoire); INSERT INTO `landen` VALUES ( Kroati); INSERT INTO `landen` VALUES ( Cuba); INSERT INTO `landen` VALUES ( Cyprus); INSERT INTO `landen` VALUES ( Tsjechi); INSERT INTO ` landen `VALUES ( Tsjechoslowakije); INSERT INTO` landen `VALUES ( Denemarken); INSERT INTO` landen `VALUES ( Djibouti); INSERT INTO` landen `VALUES ( Dominica); INSERT INTO` landen ` VALUES ( Dominicaanse Republiek); INSERT INTO `landen` VALUES ( Oost-Timor); INSERT INTO `landen` VALUES ( Ecuador); INSERT INTO `landen` VALUES ( Egypte); INSERT INTO `landen` VALUES ( El Salvador); INSERT INTO `landen` VALUES ( Equatoriaal-Guinea); INSERT INTO `landen` VALUES ( Eritrea); INSERT INTO `landen` VALUES ( Estland); INSERT INTO `landen` VALUES ( Ethiopi); INSERT INTO `landen` VALUES ( Falklandeilanden (Malvinas)); INSERT INTO `landen` VALUES ( Faerer); INSERT INTO `landen` VALUES ( Fiji); INSERT INTO `landen` VALUES ( Finland); INSERT INTO `landen` VALUES ( Frankrijk); INSERT INTO `landen` VALUES ( Frankrijk, Metropolitan); INSERT INTO `landen` VALUES ( Frans-Guyana); INSERT INTO `landen` VALUES ( Frans-Polynesi); INSERT INTO `landen` VALUES ( Franse Zuidelijke Gebieden); INSERT INTO `landen` VALUES ( Gabon); INSERT INTO `landen` VALUES ( Gambia); INSERT INTO `landen` VALUES ( Georgi); INSERT INTO `landen` VALUES ( Duitsland); INSERT INTO `landen` VALUES ( Ghana); INSERT INTO `landen` VALUES ( Gibraltar); INSERT INTO `landen` VALUES ( Griekenland); INSERT INTO `landen` VALUES ( Groenland); INSERT INTO `landen` VALUES ( Grenada); INSERT INTO `landen` VALUES ( Guadeloupe); INSERT INTO `landen `VALUES ( Guam); INSERT INTO` landen `VALUES ( Guatemala); INSERT INTO` landen `VALUES ( Guinee); INSERT INTO` landen `VALUES ( Guinee-Bissau); INSERT INTO` landen `VALUES ( Guyana); INSERT INTO` landen `VALUES ( Hati); INSERT INTO` landen `VALUES ( Heard en McDonald eilanden); INSERT INTO` landen `VALUES ( Honduras); INSERT INTO` landen "VALUES ( Hong Kong); INSERT INTO` landen `VALUES ( Hongarije); INSERT INTO` landen `VALUES ( IJsland); INSERT INTO` landen `VALUES ( India); INSERT INTO` landen `VALUES ( Indonesi); INSERT INTO` landen `VALUES ( Irak); INSERT INTO` landen `VALUES ( Ierland); INSERT INTO` landen `VALUES ( Islamitische Republiek Iran); INSERT INTO` landen `VALUES ( Isral); INSERT INTO` landen `VALUES ( Itali); INSERT INTO` landen `VALUES ( Jamaica); INSERT INTO` landen `VALUES ( Japan); INSERT INTO` landen ` VALUES ( Jordan); INSERT INTO `landen` VALUES ( Kazachstan); INSERT INTO `landen` VALUES ( Kenia); INSERT INTO `landen` VALUES ( Kiribati); INSERT INTO `landen` VALUES ( "Korea, Democratische Volksrepubliek People van ); INSERT INTO` landen `VALUES (" Korea, Republiek); INSERT INTO `landen` VALUES ( Koeweit); INSERT INTO `landen` VALUES ( Kirgizi ); INSERT INTO `landen` VALUES ( Laos); INSERT INTO `landen` VALUES ( Letland); INSERT INTO `landen` VALUES ( Libanon); INSERT INTO `landen` VALUES ( Lesotho); INSERT INTO `landen` VALUES ( Liberia); INSERT INTO `landen` VALUES ( Libyan Arab Jamahiriya); INSERT INTO `landen` VALUES ( Liechtenstein); INSERT INTO `landen` VALUES ( Litouwen); INSERT INTO `landen` VALUES ( Luxemburg); INSERT INTO `landen` VALUES ( Macau); INSERT INTO `landen` VALUES ( Macedoni); INSERT INTO `landen` VALUES ( Madagascar); INSERT INTO `landen` VALUES ( Malawi); INSERT INTO `landen` VALUES ( Maleisi); INSERT INTO `landen` VALUES ( Maldiven); INSERT INTO `landen` VALUES ( Mali); INSERT INTO `landen `VALUES ( Malta); INSERT INTO` landen `VALUES ( Marshall-eilanden); INSERT INTO` landen `VALUES ( Martinique); INSERT INTO` landen `VALUES ( Mauritani); INSERT INTO` landen ` VALUES ( Mauritius); INSERT INTO `landen` VALUES ( Mayotte); INSERT INTO `landen` VALUES ( Mexico);[/ code]


eerst dit, en dan dit:

[code] INSERT INTO `landen` VALUES ( Micronesi); INSERT INTO `landen` VALUES ( Moldavi, Republiek); INSERT INTO `landen` VALUES ( Monaco); INSERT INTO `landen` VALUES (  Mongoli ); INSERT INTO `landen` VALUES ( Montserrat ); INSERT INTO `landen` VALUES ( Marokko ); INSERT INTO `landen` VALUES ( Mozambique ); INSERT INTO `landen` VALUES ( Myanmar  ); INSERT INTO `landen` VALUES ( Namibi); INSERT INTO `landen` VALUES ( Nauru); INSERT INTO `landen` VALUES ( Nepal); INSERT INTO `landen` VALUES ( Nederland); INSERT INTO `landen` VALUES ( Nederlandse Antillen); INSERT INTO `landen` VALUES ( Nieuw-Caledoni); INSERT INTO `landen` VALUES ( Nieuw-Zeeland); INSERT INTO `landen` VALUES ( Nicaragua) ; INSERT INTO `landen` VALUES ( Niger); INSERT INTO `landen` VALUES ( Nigeria); INSERT INTO `landen` VALUES ( Niue); INSERT INTO `landen` VALUES ( Norfolk); INSERT INTO `landen` VALUES ( Noordelijke Marianen); INSERT INTO `landen` VALUES ( Noorwegen); INSERT INTO `landen` VALUES ( Oman); INSERT INTO `landen` VALUES ( Pakistan); INSERT INTO `landen` VALUES ( Palau); INSERT INTO `landen` VALUES ( Panama); INSERT INTO `landen` VALUES ( Papoea-Nieuw-Guinea); INSERT INTO `landen` VALUES ( Paraguay); INSERT INTO `landen` VALUES ( Peru); INSERT INTO `landen` VALUES ( Filippijnen); INSERT INTO `landen` VALUES ( Pitcairn); INSERT INTO `landen` VALUES ( Polen); INSERT INTO `landen` VALUES ( Portugal); INSERT INTO `landen` VALUES ( Puerto Rico); INSERT INTO `landen` VALUES ( Qatar); INSERT INTO `landen` VALUES ( Reunion); INSERT INTO ` landen `VALUES ( Roemeni); INSERT INTO` landen `VALUES ( Russische Federatie); INSERT INTO` landen `VALUES ( Rwanda); INSERT INTO` landen `VALUES ( Saint Lucia); INSERT INTO` landen "VALUES ( Samoa); INSERT INTO` landen `VALUES ( San Marino); INSERT INTO` landen `VALUES ( Sao Tome en Principe); INSERT INTO` landen `VALUES ( Saoedi-Arabi); INSERT INTO `landen` VALUES ( Senegal); INSERT INTO `landen` VALUES ( Seychellen); INSERT INTO `landen` VALUES ( Sierra Leone); INSERT INTO `landen` VALUES ( Singapore); INSERT INTO `landen` VALUES ( Slowakije); INSERT INTO `landen` VALUES ( Sloveni); INSERT INTO `landen` VALUES ( Solomon Islnds); INSERT INTO `landen` VALUES ( Somali); INSERT INTO `landen` VALUES ( "Zuid-Afrika ); INSERT INTO` landen `VALUES (" Zuid-Georgi en de Zuidelijke Sandwicheilanden); INSERT INTO `landen` VALUES ( Spanje); INSERT INTO `landen` VALUES ( Sri Lanka ); INSERT INTO `landen` VALUES ( St. Helena ); INSERT INTO `landen` VALUES ( St. Kitts en Nevis ); INSERT INTO `landen` VALUES ( St. Pierre en Miquelon ); INSERT INTO `landen` VALUES ( St. Vincent en de Greadines); INSERT INTO `landen` VALUES ( Sudan); INSERT INTO `landen` VALUES ( Suriname); INSERT INTO `landen` VALUES ( Svalbard en Jan Mayen-eilanden ); INSERT INTO `landen` VALUES ( Swaziland ); INSERT INTO `landen` VALUES ( Zweden ); INSERT INTO `landen` VALUES ( Zwitserland ); INSERT INTO `landen` VALUES ( Syrische Arabische Republiek); INSERT INTO `landen` VALUES ( Taiwan); INSERT INTO `landen` VALUES ( Tadzjikistan); INSERT INTO `landen` VALUES ( Tanzania, Verenigde Republiek van); INSERT INTO ` landen `VALUES ( Thailand); INSERT INTO` landen `VALUES ( Togo); INSERT INTO` landen `VALUES ( Tokelau-eilanden); INSERT INTO` landen `VALUES ( Tonga); INSERT INTO` landen ` VALUES ( Trinidad en Tobago); INSERT INTO `landen` VALUES ( Tunesi); INSERT INTO `landen` VALUES ( Turkije); INSERT INTO `landen` VALUES ( Turkmenistan); INSERT INTO `landen` VALUES ( Turks-en Caicoseilanden); INSERT INTO `landen` VALUES ( Tuvalu); INSERT INTO `landen` VALUES ( Oeganda); INSERT INTO `landen` VALUES ( Oekrane); INSERT INTO `landen `VALUES (" Verenigde Arabische Emiraten ); INSERT INTO `landen` VALUES ( Verenigd Koninkrijk (Groot-Brittanni) ); INSERT INTO `landen` VALUES ( Verenigde Staten ); INSERT INTO `landen` VALUES ( Verenigde Staten ondergeschikte afgelegen eilanden ); INSERT INTO `landen` VALUES ( Verenigde Staten Virgin Islands ); INSERT INTO `landen` VALUES ( Uruguay ); INSERT INTO `landen` VALUES ( Oezbekistan ); INSERT INTO `landen` VALUES ( Vanuatu); INSERT INTO `landen` VALUES ( Vaticaanstad); INSERT INTO `landen` VALUES ( Venezuela); INSERT INTO `landen` VALUES ( Vietnam); INSERT INTO `landen `VALUES ( Wallis en Futuna); INSERT INTO` landen `VALUES ( Westelijke Sahara); INSERT INTO` landen `VALUES ( Jemen); INSERT INTO` landen `VALUES ( Joegoslavi); INSERT INTO `landen` VALUES ( Zare); INSERT INTO `landen` VALUES ( Zambia); INSERT INTO `landen` VALUES ( Zimbabwe); CREATE TABLE `credits` ( `s_date` date NOT NULL default 0000 - 00-00 , `s_reason` varchar (100) NOT NULL default, `s_amount` float NOT NULL 0, `s_user` varchar (15 standaard) NOT NULL default, `s_type` char (1) binaire NOT NULL default); CREATE TABLE `automatische incasso` ( `s_date` date NOT NULL default 0000-00-00 , `s_amount` float NOT NULL 0, `s_reason` varchar (100 standaard) NOT NULL default  , `s_user` varchar (50) NOT NULL default, `s_type` char (1) binary NOT NULL default 0); CREATE TABLE `exchange_history` ( `eID` int (11) NOT NULL auto_increment, `Euser `varchar (15) NOT NULL default,` EDate `date NOT NULL default 0000-00-00 ,` ereturn `float NOT NULL default 0, PRIMARY KEY (` eID `)); CREATE TABLE` investment_history `(` iid `int (11) NOT NULL auto_increment,` usrid `varchar (15) default NULL,` bedrag `float default 0 ,` descr `varchar (100) default NULL,` is_from `varchar (50) default 0 , `processor` varchar (100) default NULL, `ADatum` date default 0000-00-00, `verstreken` char (3) default nee, `batch` varchar (20) NOT NULL default  , PRIMARY KEY ( `iid`)); CREATE TABLE `merchant_codes` ( `id` int (11) NOT NULL auto_increment, `naam` varchar (100) default NULL, `code` text, PRIMARY KEY ( `id`) ); CREATE TABLE `payout_history` ( `pid` int (11) NOT NULL auto_increment, `puser` varchar (15) NOT NULL default, `pamount` float NOT NULL default 0 , `TAND VAN ZAKEN` date NOT NULL default 0000-00-00 , `pprocessor` varchar (8) NOT NULL default, `ppayto` varchar (50) NOT NULL default, `pstatus` char (1) binary NOT NULL default, PRIMARY KEY ( `pid`)); CREATE TABLE `PTC` ( `pid` int (11) NOT NULL auto_increment, `averecht` varchar (255) NOT NULL default, `pbanner` varchar (255) NOT NULL default, `pcost` float NOT NULL default 0 , `phits` int (11) NOT NULL default 0, `pviews` int (11) NOT NULL default 0 , `padvertiser` varchar (25) NOT NULL default , PRIMARY KEY ( `pid`)); CREATE TABLE `ptcclicks` ( `tid` int (11) NOT NULL default 0, `uid` varchar (50) NOT NULL default 0 , `fdate` date NOT NULL default 0000-00-00 ); CREATE TABLE `ptpapproved` ( `url` varchar (255) NOT NULL default, `tothits` int (11) NOT NULL default 0, PRIMARY KEY ( `url` )); CREATE TABLE `ptphits` ( `h_date` date NOT NULL default 0000-00-00 , `h_user` varchar (15) NOT NULL default 0, `h_ip` varchar (23) NOT NULL default , `h_referrer` varchar (200) NOT NULL default, `h_site` int (11) NOT NULL default 0 ); CREATE TABLE `ptpsites` ( `siteid` int (11) NOT NULL auto_increment, `url` varchar (255) NOT NULL default, `credits` int (11) NOT NULL default 0 , `user` varchar (15) NOT NULL default 0, PRIMARY KEY ( `siteid`)); CREATE TABLE `refpageviews `(` vid `int (11) NOT NULL auto_increment,` vdate `date NOT NULL default 0000-00-00 ,` vip `varchar (15) NOT NULL default,` vuser `varchar (25) NOT NULL default, PRIMARY KEY ( `vid`)); CREATE TABLE `reglog` ( `iid` int (11) NOT NULL auto_increment, `ruser` varchar (30) NOT NULL default, `rcomefrom` varchar (255) NOT NULL default, PRIMARY KEY ( `iid`)); CREATE TABLE `setupinfo` ( `siteurl` varchar (255) default NULL, `adminmail` varchar (255) default NULL, `Sitetitle` varchar (255) default NULL , `subonus` float default NULL, `rlevels` varchar (4) default NULL, `refpc1` float default NULL, `refpc2` float default NULL, `refpc3` float default NULL, `refpc4` float default NULL, `refpc5` float default NULL, `refpc6` float default NULL, `refpc7` float default NULL, `refpc8` float default NULL, `refpc9` float default NULL, `refpc10` float default NULL); INSERT INTO `setupinfo` VALUES ( "http:/ / acgptc12.uw.hu , admin@altercoder.com , ACG.PTCinvestment 1,2 demo , 0, 1, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0); CREATE TABLE `tekstlinks` ( `linkid` int (11) NOT NULL auto_increment, `ltitle` varchar (255) default NULL, `lurl` varchar (255) default NULL, `ladvname` varchar (50) default NULL, `ladvpass` varchar (50) default NULL, `lexpire` int (11) default NULL, `lhits` int (11) default NULL, `limpress` int (11) default NULL, PRIMARY KEY ( `linkid`)); CREATE TABLE `handel` ( `tid` int (11) NOT NULL auto_increment, `tseller` varchar (15) NOT NULL default, `tamount` float NOT NULL default 0 , `tcost` float NOT NULL 0, `standaard` tstatus varchar (4) NOT NULL default 0 , `t_selldate` date NOT NULL default 0000-00-00, `tcpp` float NOT NULL 0 default, PRIMARY KEY ( `tid`)); CREATE TABLE `gebruikers `(` uid `int (11) NOT NULL auto_increment,` username `varchar (50) default NULL,` email `varchar (100) default NULL,` firstn `varchar (50) default NULL,` lastn `varchar (50) default NULL, `adres` varchar (255) default NULL, `city` varchar (100) default NULL, `state` varchar (100) default NULL, `land` varchar (100) default NULL, `ref` varchar (50) default NULL, `wachtwoord` varchar (50) default NULL, `ip` varchar (20) default NULL, `status` varchar (20) default NULL, `confid` int (11) default NULL, `RegDate` date default 0000 -00-00 , `referrer1` varchar (50) default NULL, `referrer2` varchar (50) default NULL, `referrer3` varchar (50) default NULL, `referrer4` varchar (50) default NULL, `referrer5` varchar (50) default NULL, `referrer6` varchar (50) default NULL, `referrer7` varchar (50) default NULL, `referrer8` varchar (50) default NULL, `referrer9` varchar (50) default NULL, `referrer10` varchar (50) default NULL, `lastlogin` date default 0000-00-00 , `verdiend` float default NULL, `genvesteerd` float default NULL, `roi_cash` float default NULL, PRIMARY KEY ( `uid`), UNIQUE KEY `username` ( `username`)); [/ code] [/ quote]

Als ik het eerste deel invoer krijg ik deze fout:

Fout
SQL-query: 

CREATE TABLE `adminmessage` (

`mid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`sentdate` date NOT NULL default 0000-00-00,
`sentto` varchar( 50 ) NOT NULL default ,
`subject` varchar( 255 ) NOT NULL default ,
`content` text NOT NULL ,
`removed` text NOT NULL ,
PRIMARY KEY ( `mid` ) 
);



MySQL retourneerde:  

#1046 - No database selected

Je moet ook een database aanklikken hé