bdd - Poupixy/projetsn2 GitHub Wiki

sqlite3 Amplificateur.db

create table Infocapteur (idMesure INT PRIMARY KEY,idDate DATETIME,Courant DOUBLE,Temperature DOUBLE,Tension DOUBLE);

create table Reglage (idDate DATETIME PRIMARY KEY, ReglageAmpli INT);

create table Comptes (Logins TEXT(20),Passwords TEXT(20));

insert into Reglage (idDate,ReglageAmpli) values ("CURRENT_TIMESTAMP","15")

insert into Infocapteur(idMesure,idDate) values (“1”,"CURRENT_TIMESTAMP",)