Difference between revisions of "LinkFerret/sql/link"
< LinkFerret | sql
Jump to navigation
Jump to search
(I wrote this many days ago. Firefox didn't lose it. Yay!) |
m (syntax highlighting) |
||
| Line 2: | Line 2: | ||
* '''Purpose''': for posting a link | * '''Purpose''': for posting a link | ||
==SQL== | ==SQL== | ||
| + | <mysql> | ||
CREATE TABLE `post` ( | CREATE TABLE `post` ( | ||
`ID_Post` INT NOT NULL COMMENT "ID of post to which this link is attached", | `ID_Post` INT NOT NULL COMMENT "ID of post to which this link is attached", | ||
| Line 10: | Line 11: | ||
) | ) | ||
ENGINE = MYISAM; | ENGINE = MYISAM; | ||
| + | </mysql> | ||
Revision as of 01:26, 25 March 2013
About
- Purpose: for posting a link
SQL
<mysql> CREATE TABLE `post` (
`ID_Post` INT NOT NULL COMMENT "ID of post to which this link is attached", `ID_User` INT NOT NULL COMMENT "ID of user who owns this post", `URL` VARCHAR(255) DEFAULT NULL COMMENT "site-relative URI for more information", PRIMARY KEY(`ID_Post`), UNIQUE KEY `content` (`URL`) ) ENGINE = MYISAM;
</mysql>