----------------------
Product Availability - SQL Changelog
----------------------
$Id: SQL_changelog.txt,v 1.03 2003/11/09

v1.02 > v1.02

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);


v1.0 > v1.01

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