Vous n'êtes pas identifié(e).
L'icône rouge permet de télécharger chaque page du wiki visitée au format PDF et la grise au format ODT →
Ceci est une ancienne révision du document !
apt-get install php5-mysql
apt-get install mysql-server
apt-get install phpmyadmin
./creerMysqlBDDetUser.sh essaiLogin essaiLogin <motDePasse>
#-- fichier : /home/$user/createTableMembreLogin.sql USE essaiLogin; DROP TABLE IF EXISTS `login`; CREATE TABLE IF NOT EXISTS login( login_id INT NOT NULL AUTO_INCREMENT, pseudo VARCHAR(20) NOT NULL, motPasse VARCHAR(100) NOT NULL, PRIMARY KEY (login_id), UNIQUE KEY username (pseudo) )ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `membre`; CREATE TABLE IF NOT EXISTS membre( membre_id INT NOT NULL AUTO_INCREMENT, prenom VARCHAR(50) NOT NULL, nom VARCHAR(50) NOT NULL, mail VARCHAR(100) NOT NULL, isAdmin tinyint(1) NOT NULL DEFAULT 0, dateInscription TIMESTAMP DEFAULT CURRENT_TIMESTAMP(), dateModif TIMESTAMP, idLogin INT NOT NULL, PRIMARY KEY (membre_id), CONSTRAINT FK_login FOREIGN KEY(`idLogin`) REFERENCES login(`login_id`) )ENGINE=InnoDB DEFAULT CHARSET=utf8;
mysql -uessaiLogin -p <createTableMembreLogin.sql
#--fichier : /home/$user/insertTableMembreLogin.sql USE essaiLogin; SET FOREIGN_KEY_CHECKS=0; TRUNCATE `login`; SET FOREIGN_KEY_CHECKS=1; DELETE FROM `login`; INSERT INTO login(pseudo, motPasse) VALUES ('admin', MD5('adminadmin')), ('toto', MD5('totototo')); SET FOREIGN_KEY_CHECKS=0; TRUNCATE `membre`; DELETE FROM `membre`; INSERT INTO membre(prenom, nom, mail, isAdmin, dateInscription, idLogin) VALUES ('admin', 'Admin', 'admin@admin.fr', 1, now(), 1), ('toto', 'toto', 'toto@toto.fr', 0, now(), 2);
mysql -uessaiLogin -p <insertTableMembreLogin.sql
isAdmin tinyint(1)NOT NULL DEFAULT 0,
FALSE
.TRUE
sera 1
.BOOL, BOOLEAN These types are synonyms for TINYINT(1). A value of zero is considered false. Nonzero values are considered true
mysql -uessaiLogin -p essaiLogin -e "select * from login;"
Enter password: +----------+--------+----------------------------------+ | login_id | pseudo | motPasse | +----------+--------+----------------------------------+ | 1 | pseudo | 335368c4ed30a8f0f3b3919a2dfade2a | | 2 | toto | c33ca5e7eae116138d1d1b61158d58f9 | | 3 | admin | f6fdffe48c908deb0f4c3bd36c032e72 | +----------+--------+----------------------------------+
mysql -uessaiLogin -p essaiLogin -e "select * from membre;"
Enter password: +-----------+--------+-------+----------------+---------+---------------------+---------------------+---------+ | membre_id | prenom | nom | mail | isAdmin | dateInscription | dateModif | idLogin | +-----------+--------+-------+----------------+---------+---------------------+---------------------+---------+ | 1 | prenom | nom | mail@mail.fr | 0 | 2016-06-30 10:09:18 | 0000-00-00 00:00:00 | 1 | | 2 | toto | toto | toto@toto.fr | 0 | 2016-06-30 10:09:18 | 0000-00-00 00:00:00 | 2 | | 3 | admin | Admin | admin@admin.fr | 1 | 2016-06-30 10:09:18 | 0000-00-00 00:00:00 | 3 | +-----------+--------+-------+----------------+---------+---------------------+---------------------+---------+
Pour le champ dateModif
, si on avait choisi le type DATE
à la place de TIMESTAMP
CREATE TABLE IF NOT EXISTS membre( <...> dateInscription TIMESTAMP DEFAULT CURRENT_TIMESTAMP, dateModif DATE, <...> )ENGINE=InnoDB DEFAULT CHARSET=utf8;
On aurait pu modifier la date seulement
now()
:UPDATE `membre` SET `dateModif`=NOW() WHERE `pseudo`='admin';
CURRENT_TIMESTAMP()
:UPDATE `membre` SET `dateModif`=CURRENT_TIMESTAMP() WHERE `pseudo`='admin';
select pseudo, dateModif from membre where pseudo='admin';
+-------+------------+ | pseudo | dateModif | +-------+------------+ | admin | 2016-06-24 | +-------+------------+