· 8 years ago · Feb 20, 2018, 11:18 AM
1
2CREATE TABLE IF NOT EXISTS `UTENTI` (
3 `idUser` int(10) NOT NULL,
4 `cognome` varchar(20) NOT NULL,
5 `nome` varchar(20) NOT NULL,
6 `username` varchar(20) NOT NULL,
7 `password` varchar(20) NOT NULL,
8 `dataScadenza` date NOT NULL,
9 `idTipoUser` int(3) NOT NULL,
10 PRIMARY KEY (`idUser`)
11) ENGINE=MyISAM DEFAULT CHARSET=latin1;
12
13INSERT INTO `UTENTI` (`idUser`, `cognome`, `nome`, `username`, `password`, `dataScadenza`, `idTipoUser`) VALUES
14(1, 'Gopaul', 'Channy', 'gopcha', 'ciaociao8M', '2027-10-03', 3),
15(2, 'RossieVerdiu', 'Marco', 'rosmar', 'aassdDD22', '2027-10-03', 4),
16(3, 'Verdi', 'Giuseppe', 'admin', 'admin', '2027-06-08', 1),
17(6, 'Pippo', 'Pluto', 'pluppo', 'ciao1234C', '2017-12-23', 4),
18(5, 'Santini', 'Chiara', 'sanchi', 'ciaociao', '2020-08-02', 4),
19(11, 'sdfsdfsdfa', 'sdfsdfa', 'sdfsdfaa', 'ciaoMarta1', '2020-08-02', 3),
20(12, 'Cognome', 'Nome', 'babba', 'Ale12345', '2018-01-01', 2),
21(13, 'AAA', 'BBB', 'CCC', 'ciaociao', '2035-03-03', 2);