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????