Difference between 6.5b5 and 6.5b6 & Upgrade Script
Date: Thursday, January 23 @ 23:51:21 CET
Topic: PHP-Nuke


The following tables are no longer in the nuke.sql generation script for PHP-Nuke Beta 6. Bye bye Splatt:
  1. nuke_words
  2. nuke_usersettings
  3. nuke_smiles
  4. nuke_ranks
  5. nuke_posts_text
  6. nuke_posts
  7. nuke_forumtopics
  8. nuke_forums
  9. nuke_forum_notifica
  10. nuke_forum_mods
  11. nuke_disallow
  12. nuke_catagories
  13. nuke_banlist
  14. nuke_access
Just a reminder that these versions are BETA so if you do now understand how to program or use PHP or MySQL then we highly recommend you wait for the production release.

The following tables were changed from (besides the CREATE TABLE lines to show which tables are affected, the only lines includes are the ones that were changed -- all others are the same):
CREATE TABLE nuke_chatusers (
alias char(20) NOT NULL default '',
color char(7) NOT NULL default '',
to
CREATE TABLE nuke_chatusers (
alias varchar(20) NOT NULL default '',
color varchar(7) NOT NULL default '',
From
CREATE TABLE nuke_users (
uid int(11) NOT NULL auto_increment,
uname varchar(25) NOT NULL default '',
email varchar(255) NOT NULL default '',
url varchar(255) NOT NULL default '',
user_intrest varchar(150) default NULL,
pass varchar(40) NOT NULL default '',
PRIMARY KEY (uid),
KEY uid (uid),
KEY uname (uname),
to
CREATE TABLE nuke_users (
user_id int(11) NOT NULL auto_increment,
username varchar(25) NOT NULL default '',
user_email varchar(255) NOT NULL default '',
user_website varchar(255) NOT NULL default '',
user_interests varchar(150) NOT NULL default '',
user_password varchar(40) NOT NULL default '',
PRIMARY KEY (user_id),
KEY uid (user_id),
KEY uname (username),
The following code will correctly "upgrade" your PHP-Nuke 6.5 Beta 5 database to Beta 6 for only the nuke_users and nuke_chatusers tables:
alter table nuke_users drop primary key;
alter table nuke_users change uid user_id INT(11) NOT NULL AUTO_INCREMENT;
alter table nuke_users change uname username VARCHAR(25) NOT NULL default'';
alter table nuke_users change email user_email VARCHAR(255) NOT NULL default'';
alter table nuke_users change url user_website VARCHAR(255) NOT NULL default'';
alter table nuke_users change user_intrest user_interests VARCHAR(150) NOT NULL default'';
alter table nuke_users change pass user_password VARCHAR(40) NOT NULL default'';
alter table nuke_users add primary key (user_id);
alter table nuke_chatusers change alias alias VARCHAR(20) NOT NULL default'';
alter table nuke_chatusers change color color VARCHAR(7) NOT NULL default'';
For those that would like to see the diff on nuke.sql between beta 6 (left arrow) and beta 5 (right arrow) see below:
diff sql/nuke.sql ../65b5/sql/nuke.sql
7a8,29
> -- Table structure for table 'nuke_access'
> --
>
> CREATE TABLE nuke_access (
> access_id int(10) NOT NULL auto_increment,
> access_title varchar(20) default NULL,
> PRIMARY KEY (access_id),
> KEY access_id (access_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_access'
> --
>
>
> INSERT INTO nuke_access VALUES (-1,'Deleted');
> INSERT INTO nuke_access VALUES (1,'User');
> INSERT INTO nuke_access VALUES (2,'Moderator');
> INSERT INTO nuke_access VALUES (3,'Super Moderator');
> INSERT INTO nuke_access VALUES (4,'Administrator');
>
> --
72a95,115
> -- Table structure for table 'nuke_banlist'
> --
>
> CREATE TABLE nuke_banlist (
> ban_id int(10) NOT NULL auto_increment,
> ban_userid int(10) default NULL,
> ban_ip varchar(16) default NULL,
> ban_start int(32) default NULL,
> ban_end int(50) default NULL,
> ban_time_type int(10) default NULL,
> PRIMARY KEY (ban_id),
> KEY ban_id (ban_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_banlist'
> --
>
>
>
> --
905a949,966
> -- Table structure for table 'nuke_catagories'
> --
>
> CREATE TABLE nuke_catagories (
> cat_id int(10) NOT NULL auto_increment,
> cat_title varchar(100) default NULL,
> cat_order varchar(10) default NULL,
> PRIMARY KEY (cat_id),
> KEY cat_id (cat_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_catagories'
> --
>
>
>
> --
1258,1259c1319,1320
< alias varchar(20) NOT NULL default '',
< color varchar(7) NOT NULL default '',
---
> alias char(20) NOT NULL default '',
> color char(7) NOT NULL default '',
1440a1502,1518
> -- Table structure for table 'nuke_disallow'
> --
>
> CREATE TABLE nuke_disallow (
> disallow_id int(10) NOT NULL auto_increment,
> disallow_username varchar(50) default NULL,
> PRIMARY KEY (disallow_id),
> KEY disallow_id (disallow_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_disallow'
> --
>
>
>
> --
1746a1825,1910
> -- Table structure for table 'nuke_forum_mods'
> --
>
> CREATE TABLE nuke_forum_mods (
> forum_id int(10) NOT NULL default '0',
> user_id int(10) NOT NULL default '0',
> KEY forum_id (forum_id),
> KEY user_id (user_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_forum_mods'
> --
>
>
>
> --
> -- Table structure for table 'nuke_forum_notifica'
> --
>
> CREATE TABLE nuke_forum_notifica (
> notifi_id int(11) NOT NULL auto_increment,
> topic_id int(11) NOT NULL default '0',
> username varchar(25) NOT NULL default '',
> PRIMARY KEY (notifi_id),
> KEY topic_id (topic_id,username)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_forum_notifica'
> --
>
>
>
> --
> -- Table structure for table 'nuke_forums'
> --
>
> CREATE TABLE nuke_forums (
> forum_id int(10) NOT NULL auto_increment,
> forum_name varchar(150) NOT NULL default '',
> forum_desc text,
> forum_access int(10) default '1',
> forum_moderator int(10) default NULL,
> cat_id int(10) default NULL,
> forum_type int(10) default '0',
> forum_pass varchar(60) default NULL,
> forum_notify_email varchar(30) default NULL,
> forum_atch int(2) NOT NULL default '0',
> forum_rules text,
> PRIMARY KEY (forum_id),
> KEY forum_id (forum_id),
> KEY forum_name (forum_name)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_forums'
> --
>
>
>
> --
> -- Table structure for table 'nuke_forumtopics'
> --
>
> CREATE TABLE nuke_forumtopics (
> topic_id int(10) NOT NULL auto_increment,
> topic_title varchar(100) default '',
> topic_poster int(10) default '0',
> topic_time varchar(20) default '',
> topic_views int(10) NOT NULL default '0',
> forum_id int(10) NOT NULL default '0',
> topic_status int(10) NOT NULL default '0',
> topic_notify int(2) default '0',
> PRIMARY KEY (topic_id),
> KEY topic_id (topic_id),
> KEY forum_id (forum_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_forumtopics'
> --
>
>
>
> --
2289a2454,2496
> -- Table structure for table 'nuke_posts'
> --
>
> CREATE TABLE nuke_posts (
> post_id int(10) NOT NULL auto_increment,
> image varchar(100) default '',
> topic_id int(10) NOT NULL default '0',
> forum_id int(10) NOT NULL default '0',
> poster_id int(10) NOT NULL default '0',
> post_text text,
> post_time varchar(20) default '',
> poster_ip varchar(16) default '',
> PRIMARY KEY (post_id),
> KEY post_id (post_id),
> KEY topic_id (topic_id),
> KEY forum_id (forum_id),
> KEY poster_id (poster_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_posts'
> --
>
>
>
> --
> -- Table structure for table 'nuke_posts_text'
> --
>
> CREATE TABLE nuke_posts_text (
> post_id int(10) NOT NULL default '0',
> post_text text,
> PRIMARY KEY (post_id),
> KEY post_id (post_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_posts_text'
> --
>
>
>
> --
2377a2585,2606
> -- Table structure for table 'nuke_ranks'
> --
>
> CREATE TABLE nuke_ranks (
> rank_id int(10) NOT NULL auto_increment,
> rank_title varchar(50) NOT NULL default '',
> rank_min int(10) NOT NULL default '0',
> rank_max int(10) NOT NULL default '0',
> rank_special int(2) default '0',
> rank_image varchar(255) default NULL,
> PRIMARY KEY (rank_id),
> KEY rank_min (rank_min),
> KEY rank_max (rank_max)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_ranks'
> --
>
>
>
> --
2564a2794,2844
> -- Table structure for table 'nuke_smiles'
> --
>
> CREATE TABLE nuke_smiles (
> id int(10) NOT NULL auto_increment,
> code varchar(50) default NULL,
> smile_url varchar(100) default NULL,
> emotion varchar(75) default NULL,
> active tinyint(2) default '0',
> PRIMARY KEY (id),
> KEY id (id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_smiles'
> --
>
>
> INSERT INTO nuke_smiles VALUES (1,':D','icon_biggrin.gif','Very Happy',0);
> INSERT INTO nuke_smiles VALUES (2,':-D','icon_biggrin.gif','Very Happy',1);
> INSERT INTO nuke_smiles VALUES (3,':grin:','icon_biggrin.gif','Very Happy',0);
> INSERT INTO nuke_smiles VALUES (4,':)','icon_smile.gif','Smile',0);
> INSERT INTO nuke_smiles VALUES (5,':-)','icon_smile.gif','Smile',1);
> INSERT INTO nuke_smiles VALUES (6,':smile:','icon_smile.gif','Smile',0);
> INSERT INTO nuke_smiles VALUES (7,':(','icon_frown.gif','Sad',0);
> INSERT INTO nuke_smiles VALUES (8,':-(','icon_frown.gif','Sad',1);
> INSERT INTO nuke_smiles VALUES (9,':sad:','icon_frown.gif','Sad',0);
> INSERT INTO nuke_smiles VALUES (10,':o','icon_eek.gif','Surprised',0);
> INSERT INTO nuke_smiles VALUES (11,':-o','icon_eek.gif','Surprised',1);
> INSERT INTO nuke_smiles VALUES (12,':eek:','icon_eek.gif','Suprised',0);
> INSERT INTO nuke_smiles VALUES (13,':-?','icon_confused.gif','Confused',1);
> INSERT INTO nuke_smiles VALUES (14,':???:','icon_confused.gif','Confused',0);
> INSERT INTO nuke_smiles VALUES (15,'8)','icon_cool.gif','Cool',0);
> INSERT INTO nuke_smiles VALUES (16,'8-)','icon_cool.gif','Cool',1);
> INSERT INTO nuke_smiles VALUES (17,':cool:','icon_cool.gif','Cool',0);
> INSERT INTO nuke_smiles VALUES (18,':lol:','icon_lol.gif','Laughing',1);
> INSERT INTO nuke_smiles VALUES (19,':x','icon_mad.gif','Mad',0);
> INSERT INTO nuke_smiles VALUES (20,':-x','icon_mad.gif','Mad',1);
> INSERT INTO nuke_smiles VALUES (21,':mad:','icon_mad.gif','Mad',0);
> INSERT INTO nuke_smiles VALUES (22,':P','icon_razz.gif','Razz',0);
> INSERT INTO nuke_smiles VALUES (23,':-P','icon_razz.gif','Razz',1);
> INSERT INTO nuke_smiles VALUES (24,':razz:','icon_razz.gif','Razz',0);
> INSERT INTO nuke_smiles VALUES (25,':oops:','icon_redface.gif','Embaressed',1);
> INSERT INTO nuke_smiles VALUES (26,':cry:','icon_cry.gif','Crying (very sad)',1);
> INSERT INTO nuke_smiles VALUES (27,':evil:','icon_evil.gif','Evil or Very Mad',1);
> INSERT INTO nuke_smiles VALUES (28,':roll:','icon_rolleyes.gif','Rolling Eyes',1);
> INSERT INTO nuke_smiles VALUES (29,':wink:','icon_wink.gif','Wink',0);
> INSERT INTO nuke_smiles VALUES (30,';)','icon_wink.gif','Wink',0);
> INSERT INTO nuke_smiles VALUES (31,';-)','icon_wink.gif','Wink',1);
>
> --
2709c2989
< user_id int(11) NOT NULL auto_increment,
---
> uid int(11) NOT NULL auto_increment,
2711,2712c2991,2992
< username varchar(25) NOT NULL default '',
< user_email varchar(255) NOT NULL default '',
---
> uname varchar(25) NOT NULL default '',
> email varchar(255) NOT NULL default '',
2714c2994
< user_website varchar(255) NOT NULL default '',
---
> url varchar(255) NOT NULL default '',
2720c3000
< user_interests varchar(150) NOT NULL default '',
---
> user_intrest varchar(150) default NULL,
2727c3007
< user_password varchar(40) NOT NULL default '',
---
> pass varchar(40) NOT NULL default '',
2771,2773c3051,3053
< PRIMARY KEY (user_id),
< KEY uid (user_id),
< KEY uname (username),
---
> PRIMARY KEY (uid),
> KEY uid (uid),
> KEY uname (uname),
2782a3063,3096
>
> --
> -- Table structure for table 'nuke_usersettings'
> --
>
> CREATE TABLE nuke_usersettings (
> user_id bigint(20) unsigned NOT NULL default '0',
> chat_color varchar(7) NOT NULL default '',
> PRIMARY KEY (user_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_usersettings'
> --
>
>
>
> --
> -- Table structure for table 'nuke_words'
> --
>
> CREATE TABLE nuke_words (
> word_id int(10) NOT NULL auto_increment,
> word varchar(100) default NULL,
> replacement varchar(100) default NULL,
> PRIMARY KEY (word_id),
> KEY word_id (word_id)
> ) TYPE=MyISAM;
>
> --
> -- Dumping data for table 'nuke_words'
> --
>
>






This article comes from NukeCops
http://www.nukecops.com

The URL for this story is:
http://www.nukecops.com/modules.php?name=News&file=article&sid=13