sql...phpnuke...confusion....help

[shawshank62]

I am trying to install a calander on this site www.gamershdq.com/8ID/index.php

and i have done everything except the following.....my only problem is...what am i supposed to be doing? and where am i supposed to upload this?

2- Create tables via thecalendar.sql file

the below is the sql....am i supposed to upload this somewhere?

# Table structure for table 'nuke_4ncal'
#

CREATE TABLE nuke_4ncal (
eid bigint(20) NOT NULL auto_increment,
aid varchar(30) NOT NULL,
title varchar(150),
time datetime,
hometext blob,
comments int(11) DEFAULT '0',
counter mediumint(8) unsigned,
topic int(3) DEFAULT '1' NOT NULL,
informant varchar(20) NOT NULL,
eventDate date DEFAULT '0000-00-00' NOT NULL,
endDate date DEFAULT '0000-00-00' NOT NULL,
startTime time,
endTime time,
alldayevent int(1) DEFAULT '0' NOT NULL,
barcolor char(1),
PRIMARY KEY (eid)
);

#
# Dumping data for table 'nuke_4ncal'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_4ncal_wait'
#

CREATE TABLE nuke_4ncal_wait (
qid bigint(20) NOT NULL auto_increment,
uid mediumint(9) DEFAULT '0' NOT NULL,
uname varchar(40) NOT NULL,
title varchar(150) NOT NULL,
story blob,
timestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
topic varchar(20) NOT NULL,
eventDate date DEFAULT '0000-00-00' NOT NULL,
endDate date DEFAULT '0000-00-00' NOT NULL,
startTime time,
endTime time,
alldayevent int(1) DEFAULT '0' NOT NULL,
barcolor char(1),
PRIMARY KEY (qid)
);

#
# Dumping data for table 'nuke_4ncal_wait'
#

[crouse]

You have to run this sql command in mysqladmin

This will create the table needed for the database to work correctly

[shawshank62]

ygpm