Skip to content

Instantly share code, notes, and snippets.

@Nek-
Created May 12, 2012 16:14
Show Gist options
  • Save Nek-/2667390 to your computer and use it in GitHub Desktop.
Save Nek-/2667390 to your computer and use it in GitHub Desktop.
CREATE TABLE `Article` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`title` varchar(255) NOT NULL,
`subTitle` varchar(255) DEFAULT NULL,
`content` longtext NOT NULL,
`slug` varchar(255) NOT NULL,
`lang` varchar(10) NOT NULL,
`createdAt` datetime NOT NULL,
`updatedAt` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_CD8737FAA76ED395` (`user_id`),
CONSTRAINT `FK_CD8737FAA76ED395` FOREIGN KEY (`user_id`) REFERENCES `User` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment