
DROP TABLE public.palm_soilmois_6;

CREATE TABLE public.palm_soilmois_6
(
    id serial , 
    mositure numeric(10,2),
    date date,
    "time" time without time zone,
    hour numeric(10,2),
    minute numeric(10,2),
    second numeric(10,2)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.palm_soilmois_6
    OWNER to postgres;
	
insert into palm_soilmois_6(mositure,date,time) values (21,current_date,current_timestamp );
insert into palm_soilmois_6(mositure,date,time) values (11,current_date,current_timestamp );
insert into palm_soilmois_6(mositure,date,time) values (15,current_date,current_timestamp );
insert into palm_soilmois_6(mositure,date,time) values (18,current_date,current_timestamp );
insert into palm_soilmois_6(mositure,date,time) values (20,current_date,current_timestamp );
insert into palm_soilmois_6(mositure,date,time) values (4,current_date,current_timestamp );
insert into palm_soilmois_6(mositure,date,time) values (16,current_date,current_timestamp );
insert into palm_soilmois_6(mositure,date,time) values (19,current_date,current_timestamp );
insert into palm_soilmois_6(mositure,date,time) values (17,current_date,current_timestamp );
insert into palm_soilmois_6(mositure,date,time) values (20,current_date,current_timestamp );
select *  from palm_soilmois_6
order by id desc;