|
From: adam <ad...@xs...> - 2002-06-08 11:58:04
|
I added two fields : codec varchar(20) NOT NULL default 'unknown', and bitrate varchar(15) NOT NULL default '56k', the final programs table should look like this: CREATE TABLE programs ( ID bigint(20) NOT NULL auto_increment, name varchar(80) default NULL, url text, description text, length varchar(50) default NULL, ownerID int(11) default NULL, genreID int(11) default NULL, category varchar(80) default NULL, format text, codec varchar(20) NOT NULL default 'unknown', permissions varchar(10) NOT NULL default 'owner', bitrate varchar(15) NOT NULL default '56k', PRIMARY KEY (ID), KEY ID_2 (ID) ) TYPE=MyISAM; adam |