Greenguy's Board


Go Back   Greenguy's Board > Programming & Scripting
Register FAQ Calendar Search Today's Posts Mark Forums Read

 
 
Thread Tools Search this Thread Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 2010-02-26, 01:38 PM   #9
DIVAD3
I'm going to the backseat of my car with the woman I love, and I won't be back for TEN MINUTES
 
DIVAD3's Avatar
 
Join Date: Aug 2009
Location: Up-Sate NY !
Posts: 79
Send a message via ICQ to DIVAD3
Inserting Table Question???

This post seems fitting to a question I have on inserting a table!
I am inserting this table into a godaddy database:
Quote:
CREATE TABLE IF NOT EXISTS `users` (
`id` bigint(20) NOT NULL auto_increment,
`md5_id` varchar(200) collate latin1_general_ci NOT NULL default '',
`full_name_company_name` tinytext collate latin1_general_ci NOT NULL,
`dealer_tax_id` tinytext collate latin1_general_ci NOT NULL,
`assigned_state_dealer_id` tinytext collate latin1_general_ci NOT NULL,
`street_address` tinytext collate latin1_general_ci NOT NULL,
`state` tinytext collate latin1_general_ci NOT NULL,
`zip_code` tinytext collate latin1_general_ci NOT NULL,
`phone` tinytext collate latin1_general_ci NOT NULL,
`fax` tinytext collate latin1_general_ci NOT NULL,
`website` tinytext collate latin1_general_ci NOT NULL,
`user_name` varchar(200) collate latin1_general_ci NOT NULL default '',
`user_email` varchar(220) collate latin1_general_ci NOT NULL default '',
`pwd` varchar(200) collate latin1_general_ci NOT NULL default '',
`address` text collate latin1_general_ci NOT NULL,
`state` varchar(200) collate latin1_general_ci NOT NULL default '',
`tel` varchar(200) collate latin1_general_ci NOT NULL default '',
`fax` varchar(200) collate latin1_general_ci NOT NULL default '',
`website` text collate latin1_general_ci NOT NULL,
`date` date NOT NULL default '0000-00-00',
`users_ip` varchar(200) collate latin1_general_ci NOT NULL default '',
`approved` int(1) NOT NULL default '0',
`activation_code` int(10) NOT NULL default '0',
`banned` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `user_email` (`user_email`),
FULLTEXT KEY `idx_search` (`full_name`,`address`,`user_email`,`user_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=50 ;
HERE IS A PHOTO SIMILIAR To Go Daddys database:


At the bottom of the database it has only this remaining which is cut off from the diagram which you see: Note: l BOX l = is referring to a box to insert info.
Quote:
TABLE COMMENTS STORAGE COLLATION
l BOX l l BOX l ENGINE
l MYISAM l=drop down l BOX l
BOX
Then it has these notatations as follows:

1 If field type is "enum" or "set", please enter the values using this format: 'a','b','c'...
If you ever need to put a backslash ("\") or a single quote ("'") amongst those values, precede

it with a backslash (for example '\\xyz' or 'a\'b').

2 For default values, please enter just a single value, without backslash escaping or quotes,

using this format: a
-------------------------------------------------------------------------

So my question being this. Where do I enter this bottom portion of the table that starts with:

PRIMARY KEY (`id`),
UNIQUE KEY `user_email` (`user_email`),
FULLTEXT KEY `idx_search` (`full_name`,`address`,`user_email`,`user_name`)
-------------------------------------------------------------------
FROM HERE DOWN It has a place to enter this info:
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=50 ;
------------------------------------------------------------------------
Can anyone tell me where do I insert the bottom portion of this table????

Last edited by DIVAD3; 2010-02-26 at 01:41 PM..
DIVAD3 is offline   Reply With Quote
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:20 AM.


Mark Read
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
© Greenguy Marketing Inc