Here was my move from Postnuke to Drupal 4.7.5:

Actions performed:

1- User Migration - Complete

INSERT INTO awnewso_drupal4.users (uid, name, pass, mail, signature, timezone, mode, sort, threshold, status, init, created, access, data) SELECT pn_uid, pn_uname, pn_pass, pn_email, pn_user_sig, 0, 0, 0, 0, 1, pn_email, pn_user_regdate, UNIX_TIMESTAMP('2007-01-01 01:01:01'), "N;" FROM awnewso_awnewsorg.nuke_users WHERE pn_uid!=1;

________


Created Anonymous user in Post Nuke nuke_users. uid=663
ran:

INSERT INTO awnewso_drupal4.users (uid, name, pass, mail, signature, timezone, mode, sort, threshold, status, init, created, access, data) SELECT pn_uid, pn_uname, pn_pass, pn_email, pn_user_sig, 0, 0, 0, 0, 1, pn_email, pn_user_regdate, UNIX_TIMESTAMP('2007-01-01 01:01:01'), "N;" FROM awnewso_awnewsorg.nuke_users WHERE pn_uid=663;

--------

2 - Story Migration - Complete

INSERT INTO awnewso_drupal4.node (nid, vid, type, title, uid, status, created, comment, promote, moderate, changed)
SELECT pn_sid,
pn_sid,
"story",
CASE WHEN NOT strcmp(LEFT(pn_title,3),"_TP") THEN substring(pn_title,4) ELSE pn_title END,
pn_uid,
1,
unix_timestamp(pn_time),
2,
1,
0,
now()
FROM awnewso_awnewsorg.nuke_stories s, awnewso_awnewsorg.nuke_users u
WHERE s.pn_informant=u.pn_uname

---

INSERT INTO awnewso_drupal4.node_revisions (nid, vid, uid, title, teaser, body, log)
SELECT pn_sid,
pn_sid,
pn_uid,
pn_title,
pn_hometext,
pn_bodytext,
""
FROM awnewso_awnewsorg.nuke_stories s, awnewso_awnewsorg.nuke_users u
WHERE s.pn_informant=u.pn_uname

___________

3 - Comment Migration - Complete

INSERT INTO awnewso_drupal4.comments ( cid, pid, nid, uid, subject, comment, hostname, timestamp, homepage)
SELECT c.pn_tid,
c.pn_pid,
c.pn_sid,
IF(strcmp(c.pn_name,""),u.pn_uid, 0) ,
c.pn_subject,
c.pn_comment,
c.pn_host_name,
unix_timestamp(c.pn_date),
""
FROM awnewso_awnewsorg.nuke_comments c, awnewso_awnewsorg.nuke_users u
WHERE c.pn_name=u.pn_uname

___________

4 - Final testing.


SELECT @term_data_tid:=MAX(tid) FROM term_data;
SELECT @comments_cid:=MAX(cid) FROM comments;
SELECT @node_nid:=MAX(nid) FROM node;
SELECT @users_uid:=MAX(uid) FROM users;
SELECT @vocabulary_vid:=MAX(vid) FROM node;

DELETE FROM sequences WHERE name="term_data_tid";
DELETE FROM sequences WHERE name="comments_cid";
DELETE FROM sequences WHERE name="node_nid";
DELETE FROM sequences WHERE name="users_uid";
DELETE FROM sequences WHERE name="vocabulary_vid";

INSERT INTO sequences (name,id) SELECT "term_data_tid", @term_data_tid;
INSERT INTO sequences (name,id) SELECT "comments_cid",@comments_cid;
INSERT INTO sequences (name,id) SELECT "node_nid",@node_nid;
INSERT INTO sequences (name,id) SELECT "users_uid",@users_uid; 
INSERT INTO sequences (name,id) SELECT "vocabulary_vid",@vocabulary_vid;


Comment fix:

INSERT INTO awnewso_drupal4.node_comment_statistics (nid,last_comment_timestamp,last_comment_name,last_comment_uid,comment_count)
SELECT c.pn_sid,
unix_timestamp(c.pn_date),
NULL,
IF(u.pn_uid=-1,0,u.pn_uid),
s.pn_comments
FROM awnewso_awnewsorg.nuke_comments c
LEFT JOIN awnewso_awnewsorg.nuke_users u ON c.pn_name=u.pn_uname
LEFT JOIN awnewso_awnewsorg.nuke_stories s ON c.pn_sid=s.pn_sid
LEFT JOIN awnewso_awnewsorg.nuke_comments d ON c.pn_sid=d.pn_sid AND unix_timestamp(c.pn_date)<unix_timestamp(d.pn_date)
WHERE d.pn_date IS NULL;

ONLY if your user is already in the post-nuke database.
Replace references to user who is to become admin with admin.  (move references of uid to 1)

update node set uid = replace(uid,242,1);
update node_revisions set uid = replace(uid,242,1);
update comments set uid = replace(uid,242,1);