· 7 years ago · Sep 04, 2018, 02:54 AM
1CREATE TABLE IF NOT EXISTS `jukebox_songs_data` (
2 `id` int(10) unsigned NOT NULL,
3 `codename` varchar(255) NOT NULL,
4 `name` varchar(64) NOT NULL,
5 `artist` varchar(32) NOT NULL,
6 `song_data` text NOT NULL,
7 `length` double NOT NULL
8) ENGINE=MyISAM AUTO_INCREMENT=84 DEFAULT CHARSET=utf8;
9
10ALTER TABLE `jukebox_songs_data`
11 ADD PRIMARY KEY (`id`);
12
13ALTER TABLE `jukebox_songs_data`
14 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=84;
15/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
16/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
17/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;