03-create-table-notes.sql (271B)
1 CREATE TABLE IF NOT EXISTS `huge`.`notes` ( 2 `note_id` int(11) unsigned NOT NULL AUTO_INCREMENT, 3 `note_text` text NOT NULL, 4 `user_id` int(11) unsigned NOT NULL, 5 PRIMARY KEY (`note_id`) 6 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='user notes';