MY SQL

[Guest]

please bare with me ,ive never created a table in My sql

 

im trying to create a table products_availability with the info following this but how do i know what numbers i put in the Length/Values1 collum and the Field collum when creating the table?

 

"#

# Table structure for table `products_availability`

#

# v v 1.03 2003/11/09

#

 

DROP TABLE IF EXISTS `products_availability`;

CREATE TABLE `products_availability` (

`products_availability_id` int(11) NOT NULL auto_increment,

`language_id` int(11) NOT NULL default '1',

`products_availability_name` varchar(255) NOT NULL default '',

`date_added` datetime default NULL,

`last_modified` datetime default NULL,

PRIMARY KEY (`products_availability_id`,`language_id`),

KEY `IDX_PRODUCTS_AVAILABILITY_NAME` (`products_availability_name`)

) TYPE=MyISAM AUTO_INCREMENT=14 ;

 

#

# Dumping data for table `products_availability`

#

 

INSERT INTO `products_availability` VALUES (1, 1, 'Usually ships in 24 hours', now(), NULL);

INSERT INTO `products_availability` VALUES (4, 1, 'Usually ships in 1-2 business days', now(), NULL);

INSERT INTO `products_availability` VALUES (5, 1, 'Usually ships in 2-7 business days', now(), NULL);

INSERT INTO `products_availability` VALUES (6, 1, 'Usually ships in 1 to 2 weeks', now(), NULL);

INSERT INTO `products_availability` VALUES (7, 1, 'Usually ships in 2 to 3 weeks', now(), NULL);

INSERT INTO `products_availability` VALUES (8, 1, '<i>Limited Availability.</i> Call for Details.', now(), NULL);

INSERT INTO `products_availability` VALUES (9, 1, 'This item is not stocked. Call for Availability.', now(), NULL);

INSERT INTO `products_availability` VALUES (10, 1, 'This item has been discontinued.', now(), NULL);

INSERT INTO `products_availability` VALUES (11, 1, '<font color="#FF0000">This item is currently <b>SOLD OUT</b></foNT>', now(), NULL);

INSERT INTO `products_availability` VALUES (12, 1, '<b>Not yet released</b>', now(), NULL);

INSERT INTO `products_availability` VALUES (13, 1, 'Available for immediate download', now(), NULL);

 

 

ALTER TABLE `products` ADD `products_availability_id` VARCHAR( 255 ) ;

 

INSERT INTO `configuration` VALUES ('', 'Product Availability List', 'MAX_DISPLAY_PRODUCTS_AVAILABILITY_IN_A_LIST', '1', 'Used in Product Availability; when the number of Product Availability options exceeds this number, a drop-down list will be displayed instead of the default list', 7, 97, NULL, now(), NULL, NULL);

INSERT INTO `configuration` VALUES ('', 'Product Availability Select Size', 'MAX_PRODUCTS_AVAILABILITY_LIST', '1', 'Used in Product Availability; when this value is \'1\' the classic drop-down list will be used for Product Availability. Otherwise, a list-box with the specified number of rows will be displayed.', 7, 98, NULL, now(), NULL, NULL);

INSERT INTO `configuration` VALUES ('', 'Display Product Availability', 'PRODUCT_LIST_PRODUCTS_AVAILABILITY', '1', 'Do you want to display Product Availability?', 8, 99, NULL, now(), NULL, NULL);

 

"

[kgt]

With your database selected, click the SQL tab. Copy and paste all of this code into the text area, and click go.

 

That's all you need to do - no need to manually create and insert the tables.