LinkFerret/sql/link - Revision history

Woozle: changes

2013-06-29T19:57:59Z

changes

Woozle: syntax highlighting

2013-03-25T01:26:20Z

syntax highlighting

Woozle: I wrote this many days ago. Firefox didn't lose it. Yay!

2013-03-23T18:25:50Z

I wrote this many days ago. Firefox didn't lose it. Yay!

New page

==About==
* '''Purpose''': for posting a link
==SQL==
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;

@@ Line 1: / Line 1: @@
 ==About==
 * '''Purpose''': for posting a link
 ==SQL==
 <mysql>
-CREATE TABLE `post` (
+CREATE TABLE `link` (
     `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 "the link being stored",
     PRIMARY KEY(`ID_Post`),
     UNIQUE KEY `content` (`URL`)