Missed an Upgrade....

Posted: Tue Sep 01, 2009 8:53 pm

I seem to have missed an upgrade somewhere along the line....

I know how to edit this table by hand....but htere MUST be a better way...HELP!

I would like to make #1 turn into #2

I have over 100 Pages....How is this going to effect those pages when I make the change?

Code:

#1


CREATE TABLE nuke_pages (


  pid int(10) NOT NULL auto_increment,


  cid int(10) NOT NULL default '0',


  title varchar(255) NOT NULL default '',


  subtitle varchar(255) NOT NULL default '',


  active int(1) NOT NULL default '0',


  page_header text NOT NULL,


  `text` text NOT NULL,


  page_footer text NOT NULL,


  signature text NOT NULL,


  `date` datetime NOT NULL default '0000-00-00 00:00:00',


  counter int(10) NOT NULL default '0',


  clanguage varchar(30) NOT NULL default '',


  PRIMARY KEY  (pid),


  KEY cid (cid)


) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=latin1;


#2


CREATE TABLE nuke_pages (


  pid int(10) NOT NULL auto_increment,


  cid int(10) NOT NULL default '0',


  title varchar(255) NOT NULL default '',


  subtitle varchar(255) NOT NULL default '',


  tags varchar(255) NOT NULL,


  active int(1) NOT NULL default '0',


  page_header text NOT NULL,


  `text` text NOT NULL,


  page_footer text NOT NULL,


  signature text NOT NULL,


  `date` datetime NOT NULL default '0000-00-00 00:00:00',


  counter int(10) NOT NULL default '0',


  clanguage varchar(30) NOT NULL default '',


  uname varchar(40) NOT NULL default '',


  PRIMARY KEY  (pid),


  KEY cid (cid)


) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;





#1


CREATE TABLE nuke_pages_categories (


  cid int(10) NOT NULL auto_increment,


  title varchar(255) NOT NULL default '',


  description text NOT NULL,


  PRIMARY KEY  (cid)


) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;





#2


CREATE TABLE nuke_pages_categories (


  cid int(10) NOT NULL auto_increment,


  cimg varchar(255) NOT NULL,


  title varchar(255) NOT NULL default '',


  description text NOT NULL,


  PRIMARY KEY  (cid)


) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

Thank You for your time!!

Dawg

Involved Joined: Sep 15, 2008 Posts: 352

If you change the mysql table you must also have to update your files or you will see fatal mysql errors.