Skip to content

Instantly share code, notes, and snippets.

@heroic
Created February 5, 2011 10:09
Show Gist options
  • Save heroic/812345 to your computer and use it in GitHub Desktop.
Save heroic/812345 to your computer and use it in GitHub Desktop.
node-mysql issue table schema
CREATE TABLE IF NOT EXISTS `friends` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`to_id` int(11) NOT NULL,
`relation_id` text,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_friends_on_user_id` (`user_id`),
KEY `index_friends_on_to_id` (`to_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `friends`
--
INSERT INTO `friends` (`id`, `user_id`, `to_id`, `relation_id`, `created_at`, `updated_at`) VALUES
(1, 1, 2, '0', NULL, NULL),
(2, 2, 1, '0', NULL, NULL),
(6, 1, 3, '0', NULL, NULL),
(7, 3, 1, '0', NULL, NULL);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment