· 6 years ago · Sep 18, 2019, 08:22 AM
1 $p1 = "CREATE TABLE IF NOT EXISTS `user`(
2 ID int(5) NOT NULL AUTO_INCREMENT,
3 Login varchar(20) COLLATE utf8_polish_ci NOT NULL,
4 Password varchar(20) COLLATE utf8_polish_ci NOT NULL,
5 Lastname varchar(100) COLLATE utf8_polish_ci NOT NULL,
6 Name varchar(100) COLLATE utf8_polish_ci NOT NULL,
7 Data date DEFAULT NULL,
8 Uprawnienia int(3) NOT NULL DEFAULT '0',
9 PRIMARY KEY ID (ID)
10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=1 ";