phpBB.nl

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 10 Dec 2004 om 18:28
-- Server versie: 3.23.49
-- PHP Versie: 4.1.2
--
-- Database: `chatterke`
--

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `phpbb_users`
--

CREATE TABLE `phpbb_users` (
`user_id` mediumint(8) NOT NULL default '0',
`user_active` tinyint(1) default '1',
`username` varchar(25) NOT NULL default '',
`user_password` varchar(32) NOT NULL default '',
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_lastvisit` int(11) NOT NULL default '0',
`user_regdate` int(11) NOT NULL default '0',
`user_level` tinyint(4) default '0',
`user_posts` mediumint(8) unsigned NOT NULL default '0',
`user_timezone` decimal(5,2) NOT NULL default '0.00',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) default NULL,
`user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_viewemail` tinyint(1) default NULL,
`user_attachsig` tinyint(1) default NULL,
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(1) NOT NULL default '1',
`user_notify_pm` tinyint(1) NOT NULL default '0',
`user_popup_pm` tinyint(1) NOT NULL default '0',
`user_rank` int(11) default '0',
`user_avatar` varchar(100) default NULL,
`user_avatar_type` tinyint(4) NOT NULL default '0',
`user_email` varchar(255) default NULL,
`user_icq` varchar(15) default NULL,
`user_website` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_sig` text,
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_aim` varchar(255) default NULL,
`user_yim` varchar(255) default NULL,
`user_msnm` varchar(255) default NULL,
`user_occ` varchar(100) default NULL,
`user_interests` varchar(255) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`user_photo` varchar(100) default NULL,
`user_photo_type` tinyint(4) NOT NULL default '0',
`user_birthday` int(11) NOT NULL default '999999',
`user_next_birthday_greeting` int(11) NOT NULL default '0',
`user_calendar_perm` tinyint(1) unsigned NOT NULL default '0',
karma_plus mediumint DEFAULT '0' NOT NULL,
karma_minus mediumint DEFAULT '0' NOT NULL,
karma_time bigint DEFAULT '0' NOT NULL,
PRIMARY KEY (user_id),
KEY user_session_time (user_session_time)
) TYPE=MyISAM;

--
-- Gegevens worden uitgevoerd voor tabel `phpbb_users`
--

INSERT INTO `phpbb_users` VALUES (-1, 0, 'Anonymous', '', 0, 0, 0, 1102514054, 0, 0, 0.00, NULL, '', '', 0, 0, 0, NULL, 0, 0, 0, 1, 1, 1, 0, 1, 0, 1, 0, NULL, '', 0, '', '', '', '', '', NULL, '', '', '', '', '', '', '', NULL, 0, 999999, 0, 0);
INSERT INTO `phpbb_users` VALUES (2, 1, 'Chatterke', 'ca5063808bfe6211108c6918768b9154', 1102699580, 41, 1102697426, 1102514054, 1, 11, 1.00, 3, 'dutch', 'd M Y h:i a', 0, 0, 1102675091, NULL, 1, 0, 0, 1, 1, 1, 1, 1, 0, 1, 1, 1, '', 0, 'chatterke@jow.be', '', 'http://www.jow.be', 'Ergens op de aarde', '', '', '', '', '', 'Student', 'Webdesign', '', '', NULL, 0, 6048, 2005, 0);
INSERT INTO `phpbb_users` VALUES (3, 1, 'nathalieke', '1ffd6a1cc2ae1df2c6eb2040050d5c00', 1102699626, 41, 1102619595, 1102529270, 0, 12, 1.00, 3, 'dutch', 'D M d, Y g:i a', 0, 0, 0, NULL, 0, 1, 0, 1, 1, 1, 1, 1, 0, 1, 1, 0, '', 0, 'nathalieghyselinck@hotmail.com', '', '', 'lochristi', '', '', '', '', 'nathalieghyselinck@hotmail.com', 'student', '', '', NULL, NULL, 0, 7043, 2005, 0);

SQL-query:

INSERT INTO `phpbb_users`
VALUES (

-1, 0, 'Anonymous', '', 0, 0, 0, 1102514054, 0, 0, 0.00, NULL , '', '', 0, 0, 0, NULL , 0, 0, 0, 1, 1, 1, 0, 1, 0, 1, 0, NULL , '', 0, '', '', '', '', '', NULL , '', '', '', '', '', '', '', NULL , 0, 999999, 0, 0
)

MySQL retourneerde:

#1136 - Column count doesn't match value count at row 1