· 8 years ago · Aug 28, 2018, 11:38 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(11) NOT NULL auto_increment,
3 `imie` varchar(255) collate utf8_polish_ci NOT NULL,
4 `nazwisko` varchar(255) collate utf8_polish_ci NOT NULL,
5 `rok` varchar(255) collate utf8_polish_ci NOT NULL,
6 `zachowanie` varchar(255) collate utf8_polish_ci NOT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=3 ;
9
10
11
12CREATE TABLE IF NOT EXISTS `logins` (
13 `id` int(11) NOT NULL auto_increment,
14 `username` varchar(128) collate utf8_polish_ci NOT NULL,
15 `password` varchar(128) collate utf8_polish_ci NOT NULL,
16 `salt` varchar(128) collate utf8_polish_ci NOT NULL default '12',
17 `email` varchar(128) collate utf8_polish_ci NOT NULL,
18 PRIMARY KEY (`id`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=5 ;