1
jdlonewolf
'CREATE TABLE xoops_banner' Issues
  • 2006/3/2 4:21

  • jdlonewolf

  • Just popping in

  • Posts: 11

  • Since: 2005/11/18


Here is my problem. I installed XOOPS with PHP5 and I got an issue where it wouldn't install the xoops_banner table right. So I manually added the data. Well somewhere it got messed up so I deleted xoops_banner without being smart enough to get all the data that was in it to recreate it. SO my question is, what do I need to include in the mysql> CREATE TABLE xoops_banner command? Any help would be great

2
smdcom
Re: CREATE TABLE xoops_banner Issues

this is the correct sql command:

CREATE TABLE banner (
  
bid smallint(5unsigned NOT NULL auto_increment,
  
cid tinyint(3unsigned NOT NULL default '0',
  
imptotal mediumint(8unsigned NOT NULL default '0',
  
impmade mediumint(8unsigned NOT NULL default '0',
  
clicks mediumint(8unsigned NOT NULL default '0',
  
imageurl varchar(255NOT NULL default '',
  
clickurl varchar(255NOT NULL default '',
  
date int(10NOT NULL default '0',
  
htmlbanner tinyint(1NOT NULL default '0',
  
htmlcode text NOT NULL,
  
PRIMARY KEY  (bid),
  
KEY idxbannercid (cid),
  
KEY idxbannerbidcid (bid,cid)
TYPE=MyISAM;

Login

Who's Online

50 user(s) are online (26 user(s) are browsing Support Forums)


Members: 0


Guests: 50


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits