Log In · Register

 
Need help setting up data base, data base and my sql
marynmissouri
post Feb 12 2009, 11:13 PM
Post #1


Marynmissouri
***

Group: Member
Posts: 41
Joined: Jan 2008
Member No: 606,116



I need help with setting up my data base. I watched a video on a link and in the video the person did not explain how to set it up but he explaind how to configure all of my registration files. I'm trying to create a C-Panel log in.

Here is the code that I asuming needs attention, but I'm new to setting up data base.

CODE
CREATE TABLE users (
user_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
first_name VARCHAR(20) NOT NULL,
last_name VARCHAR(40) NOT NULL,
email VARCHAR(80) NOT NULL,
pass CHAR(40) NOT NULL,
user_level TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
active CHAR(32),
registration_date DATETIME NOT NULL,
PRIMARY KEY (user_id),
UNIQUE KEY (email),
INDEX login (email, pass)
);



Also I'm sendin a screen shot of were I'm at with my data base hoping this may help you to help me.

Can someone please guide me in the right direction?

Thanks
Mary


 
 
Start new topic
Replies
Insurmountable
post Feb 14 2009, 10:19 PM
Post #2


Cornflakes :D
*******

Group: Staff Alumni
Posts: 4,541
Joined: Dec 2005
Member No: 322,923



I PMed you.
 

Posts in this topic
marynmissouri   Need help setting up data base   Feb 12 2009, 11:13 PM
Insurmountable   I PMed you.   Feb 14 2009, 10:19 PM


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members: