What is wrong?

Just skip the DEFAULT '0' at the id field when you are creating the tables.

So the correct SQL would be:

# --------------------------------------------------------
#
# Table structure for table 'banneradmin'
#

CREATE TABLE banneradmin (
id int(11) NOT NULL auto_increment,
adminuser varchar(15) NOT NULL,
adminpass varchar(15) NOT NULL,
PRIMARY KEY (id),
UNIQUE id (id, adminuser)
);

INSERT INTO banneradmin (id, adminuser, adminpass) VALUES (1, 'admin', 'pass');

# --------------------------------------------------------
#
# Table structure for table 'bannerurls'
#

CREATE TABLE bannerurls (
id int(11) NOT NULL auto_increment,
bannerurl varchar(200) NOT NULL,
uid int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
UNIQUE id (id)
);

# --------------------------------------------------------
#
# Table structure for table 'banneruser'
#

CREATE TABLE banneruser (
id int(11) NOT NULL auto_increment,
login varchar(20) NOT NULL,
pass varchar(20) NOT NULL,
name varchar(200) NOT NULL,
email varchar(100) NOT NULL,
url varchar(200) NOT NULL,
exposures int(11) DEFAULT '0' NOT NULL,
credits int(11) DEFAULT '0' NOT NULL,
clicks int(11) DEFAULT '0' NOT NULL,
siteclicks int(11) DEFAULT '0' NOT NULL,
approved tinyint(4) DEFAULT '0' NOT NULL,
defaultacct tinyint(4) DEFAULT '0' NOT NULL,
raw blob,
lastip text NOT NULL,
PRIMARY KEY (id),
UNIQUE id (id, login)
);
Click to expand...

Log in or Sign up

What is wrong?

Alois Guest

Daudulus Member

Log in or Sign up

What is wrong?

Alois Guest

Daudulus Member

Useful Searches