From: Sean <se...@ca...> - 2002-06-22 00:57:36
|
db_generate is currently broken in CVS. `mantis_news_table` is missing the `announcement` column. Should it be? # # Table structure for table `mantis_news_table` # CREATE TABLE mantis_news_table ( id int(7) unsigned zerofill NOT NULL auto_increment, project_id int(7) unsigned zerofill NOT NULL default '0000000', announcement int(7) unsigned zerofill NOT NULL default '0000000', poster_id int(7) unsigned zerofill NOT NULL default '0000000', date_posted datetime NOT NULL default '1970-01-01 00:00:01', last_modified datetime NOT NULL default '1970-01-01 00:00:01', headline varchar(64) NOT NULL default '', body text NOT NULL, PRIMARY KEY (id), KEY id (id), KEY date_posted (date_posted) ); # -------------------------------------------------------- S |
From: Sean C. <sea...@hi...> - 2002-06-22 01:52:55
|
Ignore me. (-: Found my answer.. "Additionally you'll need to upgrade parts of the database to match the current schema: ALTER TABLE mantis_bug_history_table ADD type INT(2) NOT NULL ALTER TABLE mantis_project_category_table ADD user_id INT(7) NOT NULL ALTER TABLE mantis_news_table ADD view_state INT(2) DEFAULT '10' NOT NULL AFTER last_modified; ALTER TABLE mantis_news_table ADD announcement INT(1) NOT NULL AFTER view_state; ALTER TABLE mantis_bug_relationship_table ADD id INT(7) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST; " S At 08:58 PM 6/21/2002 -0400, you wrote: >db_generate is currently broken in CVS. > >`mantis_news_table` is missing the `announcement` column. > >Should it be? > ># ># Table structure for table `mantis_news_table` ># > >CREATE TABLE mantis_news_table ( > id int(7) unsigned zerofill NOT NULL auto_increment, > project_id int(7) unsigned zerofill NOT NULL default '0000000', > announcement int(7) unsigned zerofill NOT NULL default '0000000', > poster_id int(7) unsigned zerofill NOT NULL default '0000000', > date_posted datetime NOT NULL default '1970-01-01 00:00:01', > last_modified datetime NOT NULL default '1970-01-01 00:00:01', > headline varchar(64) NOT NULL default '', > body text NOT NULL, > PRIMARY KEY (id), > KEY id (id), > KEY date_posted (date_posted) >); ># -------------------------------------------------------- > > >S > > > >------------------------------------------------------- >Sponsored by: >ThinkGeek at http://www.ThinkGeek.com/ >_______________________________________________ >Mantisbt-dev mailing list >Man...@li... >https://lists.sourceforge.net/lists/listinfo/mantisbt-dev |