Hmm ok I hope this works right:
1. Open up mysqlman and next to "Tables:" click "Create"
2. Enter the table name, something like: Related_Links
3 Enter 2 for the number of columns.
4. On the next page you'll see a lot of form fields... don't panic!!
5. Enter the following info:
Row1:
Field: LinkID
Type: INT
Length: 8 (to be safe)
Attributes: Leave blank
Null: Select NOT NULL
Default: Leave blank
Extra: Leave unselected
Row2:
Field: RelatedID
Type: INT
Length: 8 (to be safe)
Attributes: Leave blank
Null: Select NOT NULL
Default: Leave blank
Extra: Leave unselected
I think I have that right.
That should work ok. Let me know how you get on.
The only bummer with this is that you can't really administer this from the admin panel...eg when adding/verifying links you can't select related links as Links SQL won't recognise this new table. So it will need to be done using mysqlman or a custom script (which is pretty easy), that unless Im totally forgetting something.
1. Open up mysqlman and next to "Tables:" click "Create"
2. Enter the table name, something like: Related_Links
3 Enter 2 for the number of columns.
4. On the next page you'll see a lot of form fields... don't panic!!
5. Enter the following info:
Row1:
Field: LinkID
Type: INT
Length: 8 (to be safe)
Attributes: Leave blank
Null: Select NOT NULL
Default: Leave blank
Extra: Leave unselected
Row2:
Field: RelatedID
Type: INT
Length: 8 (to be safe)
Attributes: Leave blank
Null: Select NOT NULL
Default: Leave blank
Extra: Leave unselected
I think I have that right.
That should work ok. Let me know how you get on.
The only bummer with this is that you can't really administer this from the admin panel...eg when adding/verifying links you can't select related links as Links SQL won't recognise this new table. So it will need to be done using mysqlman or a custom script (which is pretty easy), that unless Im totally forgetting something.