Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By MrBT on
I'm beginning the process of converting from Slashcode to Drupal. There's a very old slash2drual script out there, and I'm h aving some troubles understanding the Nodes tables. The Slashcode tables seem to be a little less complicated.
There are only 2 tables in Slashcode that hold the stories, can anyone help me map these into Drupal? Everything depends on the stoid field. Other fields that I think need to come over include uid (user id), time, discussion (used by the comments table), and tid (topic ID). From the story_text I think we just need title, introtext and bodytext.
Which nodes tables do I need to drop these things into?
mysql> describe stories;
+---------------+-----------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-----------------------+------+-----+---------------------+----------------+
| stoid | mediumint(8) unsigned | | PRI | NULL | auto_increment |
| sid | varchar(16) | | UNI | | |
| uid | mediumint(8) unsigned | | MUL | 0 | |
| dept | varchar(100) | YES | | NULL | |
| time | datetime | | MUL | 0000-00-00 00:00:00 | |
| hits | mediumint(8) unsigned | | | 0 | |
| discussion | mediumint(8) unsigned | YES | MUL | NULL | |
| primaryskid | smallint(5) unsigned | YES | MUL | NULL | |
| tid | smallint(5) unsigned | YES | | NULL | |
| submitter | mediumint(8) unsigned | | MUL | 0 | |
| commentcount | smallint(5) unsigned | | | 0 | |
| hitparade | varchar(64) | | | 0,0,0,0,0,0,0 | |
| is_archived | enum('no','yes') | | MUL | no | |
| in_trash | enum('no','yes') | | | no | |
| day_published | date | | MUL | 0000-00-00 | |
| qid | mediumint(8) unsigned | YES | | NULL | |
| last_update | timestamp | YES | | CURRENT_TIMESTAMP | |
| body_length | mediumint(8) unsigned | | | 0 | |
| word_count | mediumint(8) unsigned | | | 0 | |
+---------------+-----------------------+------+-----+---------------------+----------------+
19 rows in set (0.01 sec)
mysql> describe story_text;
+-------------+-----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------------------+------+-----+---------+-------+
| stoid | mediumint(8) unsigned | | PRI | 0 | |
| title | varchar(100) | | MUL | | |
| introtext | text | YES | MUL | NULL | |
| bodytext | text | YES | | NULL | |
| relatedtext | text | YES | | NULL | |
| rendered | text | YES | | NULL | |
+-------------+-----------------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
