MySQL Tabele.txt

(0 KB) Pobierz
use test;
create table HardwareInfo1 (COMP_NAME  varchar(50),id int auto_increment not null primary key, czas timestamp, T_GPU int, T_HDD int, T_COM int, T_CPU int, 12V int, 5V int, 33V int, Fan int, HDD_FREE int, PROC_USAGE int, MEM_USAGE int, SMART5 int, SMART1 int, SMART198 int);
create table ComputerList1 (COMP_NAME  varchar(50));
create table AlarmLimits (id int auto_increment not null primary key, T_CPU int, T_COM int, CPU_Ussage int, RAM_Ussage int, Min12V int, Max12V int, MinVCore int, MaxVCore int, Min33V int, Max33V int, HddFree int, FanSpeed int );
insert into AlarmLimits (T_CPU, T_COM, CPU_Ussage, RAM_Ussage, Min12V, Max12V, MinVCore, MaxVCore, Min33V, Max33V,HddFree, FanSpeed) values (75, 75, 90, 90, 1130, 1270, 100, 200, 310, 350, 3, 1000); 
Zgłoś jeśli naruszono regulamin