vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Creating the user table again, any ideas? (https://vborg.vbsupport.ru/showthread.php?t=54936)

Xelation 07-01-2003 11:46 PM
Creating the user table again, any ideas?
 
I was playing around with the sql database and purposly deleted the user table.... I need to add it again... here is what Im adding..

CREATE TABLE user (
userid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
usergroupid smallint(5) unsigned DEFAULT '0' NOT NULL,
username varchar(50) NOT NULL,
password varchar(50) NOT NULL,
email varchar(50) NOT NULL,
styleid smallint(5) unsigned DEFAULT '0' NOT NULL,
parentemail varchar(50) NOT NULL,
coppauser smallint(6) DEFAULT '0' NOT NULL,
homepage varchar(100) NOT NULL,
icq varchar(20) NOT NULL,
aim varchar(20) NOT NULL,
yahoo varchar(20) NOT NULL,
signature mediumtext NOT NULL,
adminemail smallint(6) DEFAULT '0' NOT NULL,
showemail smallint(6) DEFAULT '0' NOT NULL,
invisible smallint(6) DEFAULT '0' NOT NULL,
usertitle varchar(250) NOT NULL,
customtitle smallint(6) DEFAULT '0' NOT NULL,
joindate int(10) unsigned DEFAULT '0' NOT NULL,
cookieuser smallint(6) DEFAULT '0' NOT NULL,
daysprune smallint(6) DEFAULT '0' NOT NULL,
lastvisit int(10) unsigned DEFAULT '0' NOT NULL,
lastactivity int(10) unsigned DEFAULT '0' NOT NULL,
lastpost int(10) unsigned DEFAULT '0' NOT NULL,
posts smallint(5) unsigned DEFAULT '0' NOT NULL,
timezoneoffset varchar(4) NOT NULL,
emailnotification smallint(6) DEFAULT '0' NOT NULL,
buddylist mediumtext NOT NULL,
ignorelist mediumtext NOT NULL,
pmfolders mediumtext NOT NULL,
receivepm smallint(6) DEFAULT '0' NOT NULL,
emailonpm smallint(6) DEFAULT '0' NOT NULL,
pmpopup smallint(6) DEFAULT '0' NOT NULL,
avatarid smallint(6) DEFAULT '0' NOT NULL,
options smallint(6) DEFAULT '15' NOT NULL,
birthday date DEFAULT '0000-00-00' NOT NULL,
maxposts smallint(6) DEFAULT '-1' NOT NULL,
startofweek smallint(6) DEFAULT '1' NOT NULL,
ipaddress varchar(20) NOT NULL,
referrerid int(10) unsigned DEFAULT '0' NOT NULL,
nosessionhash smallint(6) DEFAULT '0' NOT NULL,
inforum SMALLINT UNSIGNED DEFAULT '0' not null,
PRIMARY KEY (userid),
KEY usergroupid (usergroupid),
KEY username (username),
INDEX (inforum));

but it keeps saying...

MySQL said:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user( userid int( 10 ) unsigned DEFAULT '1' NOT NULL auto_in

whats wrong?

Giveit2u43 07-02-2003 12:16 AM
Try this query instead:

Code:
CREATE TABLE user (
'userid' int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
'usergroupid' smallint(5) unsigned DEFAULT '0' NOT NULL,
'username' varchar(50) NOT NULL,
'password' varchar(50) NOT NULL,
'email' varchar(50) NOT NULL,
'styleid' smallint(5) unsigned DEFAULT '0' NOT NULL,
'parentemail' varchar(50) NOT NULL,
'coppauser' smallint(6) DEFAULT '0' NOT NULL,
'homepage' varchar(100) NOT NULL,
'icq' varchar(20) NOT NULL,
'aim' varchar(20) NOT NULL,
'yahoo' varchar(20) NOT NULL,
'signature' mediumtext NOT NULL,
'adminemail' smallint(6) DEFAULT '0' NOT NULL,
'showemail' smallint(6) DEFAULT '0' NOT NULL,
'invisible' smallint(6) DEFAULT '0' NOT NULL,
'usertitle' varchar(250) NOT NULL,
'customtitle' smallint(6) DEFAULT '0' NOT NULL,
'joindate' int(10) unsigned DEFAULT '0' NOT NULL,
'cookieuser' smallint(6) DEFAULT '0' NOT NULL,
'daysprune' smallint(6) DEFAULT '0' NOT NULL,
'lastvisit' int(10) unsigned DEFAULT '0' NOT NULL,
'lastactivity' int(10) unsigned DEFAULT '0' NOT NULL,
'lastpost' int(10) unsigned DEFAULT '0' NOT NULL,
'posts' smallint(5) unsigned DEFAULT '0' NOT NULL,
'timezoneoffset' varchar(4) NOT NULL,
'emailnotification' smallint(6) DEFAULT '0' NOT NULL,
'buddylist' mediumtext NOT NULL,
'ignorelist' mediumtext NOT NULL,
'pmfolders' mediumtext NOT NULL,
'receivepm' smallint(6) DEFAULT '0' NOT NULL,
'emailonpm' smallint(6) DEFAULT '0' NOT NULL,
'pmpopup' smallint(6) DEFAULT '0' NOT NULL,
'avatarid' smallint(6) DEFAULT '0' NOT NULL,
'options' smallint(6) DEFAULT '15' NOT NULL,
'birthday' date DEFAULT '0000-00-00' NOT NULL,
'maxposts' smallint(6) DEFAULT '-1' NOT NULL,
'startofweek' smallint(6) DEFAULT '1' NOT NULL,
'ipaddress' varchar(20) NOT NULL,
'referrerid' int(10) unsigned DEFAULT '0' NOT NULL,
'nosessionhash' smallint(6) DEFAULT '0' NOT NULL,
'inforum' SMALLINT UNSIGNED DEFAULT '0' not null,
PRIMARY KEY ('userid'),
KEY 'usergroupid' ('usergroupid'),
KEY 'username' ('username'),
KEY `inforum` (`inforum`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
I often find SQL doesn`t like it when the names aren`t in quotes :)


All times are GMT. The time now is 01:33 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01054 seconds
  • Memory Usage 1,723KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete