Tijden veranderen
mysql en php newbie vraag
Dumping data for table 'authuser'
en dit snap ik ook niet:
KEY teamname (teamname, teamlead)
dit is een stukje van het script:
#
# AUTHUSER
#
CREATE TABLE authuser (
id int(11) NOT NULL auto_increment,
uname varchar(25) NOT NULL default '',
passwd varchar(25) NOT NULL default '',
team varchar(25) NOT NULL default '',
level int(4) NOT NULL default '0',
status varchar(10) NOT NULL default '',
lastlogin datetime default NULL,
logincount int(11) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# Dumping data for table 'authuser'
#
INSERT INTO authuser VALUES ( '1', 'sa', '', 'Admin', '1', 'active', '', 0);
INSERT INTO authuser VALUES ( '2', 'admin', '', 'Admin', '1', 'active', '', 0);
INSERT INTO authuser VALUES ( '3', 'test', 'test', 'Temporary', '999', 'active', '', 0);
#
# AUTHTEAM
#
CREATE TABLE authteam (
id int(4) NOT NULL auto_increment,
teamname varchar(25) NOT NULL,
teamlead varchar(25) NOT NULL,
status varchar(10) NOT NULL,
PRIMARY KEY (id),
KEY teamname (teamname, teamlead)
);
Gewijzigd op 30/08/2004 19:23:00 door Mikaz