# Connection: root@localhost:3306
# Host: localhost
# Saved: 2003-08-07 09:51:04
# 
# Connection: root@localhost:3306
# Host: localhost
# Saved: 2003-08-07 09:45:43
# 
create table drupal_test.sid_nid_map
(jb_sid varchar(20), 
jb_nid int(10) unsigned AUTO_INCREMENT,
PRIMARY KEY (jb_nid) );
insert into drupal_test.sid_nid_map(jb_sid)
select sid
from scoop_test.stories;

insert into drupal_test.comments(
pid, nid,
uid,subject,
comment,timestamp,
score,status)
select 
0,jb_nid, 
uid,subject,
comment,UNIX_TIMESTAMP(date),
0,0
from scoop_test.comments, drupal_test.sid_nid_map
where scoop_test.comments.sid=drupal_test.sid_nid_map.jb_sid;

drop table drupal_test.sid_nid_map;