· 6 years ago · Jan 13, 2020, 05:00 PM
1CREATE DATABASE socka;
2CREATE TABLE IF NOT EXISTS `players` (
3 `id` int(5) NOT NULL AUTO_INCREMENT,
4 `first_name` varchar(255) NOT NULL,
5 `last_name` varchar(255) NOT NULL,
6 `position` varchar(255) NOT NULL,
7 `number` int(11) NOT NULL,
8 `image` varchar(255) NOT NULL,
9 `user_name` varchar(20) NOT NULL,
10 PRIMARY KEY (`id`)
11) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;