# Connection: root@localhost:3306
# Host: localhost
# Saved: 2003-08-07 09:26:27
# 
insert into drupal_test.node(
type, title,
score,votes,
uid,comment,
promote,moderate,
teaser,body,
created,changed)
select 
"story",title, 
0,0,
uid,2,
1,0,
introtext,bodytext,
UNIX_TIMESTAMP(scoop_test.stories.time), UNIX_TIMESTAMP(scoop_test.stories.time)
from scoop_test.stories, scoop_test.users
where scoop_test.stories.aid=scoop_test.users.nickname