View Single Post
  #3  
Old 05-27-2003, 01:56 AM
Mauritius
Sarnak
 
Join Date: Mar 2002
Location: Neriak
Posts: 61
Default comparing db.sql with update44dr1.sql

comparing db.sql with update44dr1.sql i noticed a small difference:

using update44dr1.sql, a field 'notes' is created in table 'tradeskillrecipe' because of this line:
Quote:
ALTER TABLE `tradeskillrecipe` ADD COLUMN `notes` TEXT after `i10`;
using db.sql, that field won't be created:
Quote:
CREATE TABLE tradeskillrecipe (
id int(11) NOT NULL auto_increment,
tradeskill smallint(6) NOT NULL default '0',
skillneeded smallint(6) NOT NULL default '0',
trivial smallint(6) NOT NULL default '0',
product smallint(6) NOT NULL default '0',
product2 smallint(6) NOT NULL default '0',
failproduct smallint(6) NOT NULL default '0',
productcount smallint(6) NOT NULL default '0',
i1 smallint(6) NOT NULL default '0',
i2 smallint(6) NOT NULL default '0',
i3 smallint(6) NOT NULL default '0',
i4 smallint(6) NOT NULL default '0',
i5 smallint(6) NOT NULL default '0',
i6 smallint(6) NOT NULL default '0',
i7 smallint(6) NOT NULL default '0',
i8 smallint(6) NOT NULL default '0',
i9 smallint(6) NOT NULL default '0',
i10 smallint(6) NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY id (id),
UNIQUE KEY name (product)
) TYPE=MyISAM;

My question: is that field required or not?
Reply With Quote