sc3QAE7H

1DROP DATABASE IF EXISTS temperaturedb;
2
3-- ---
4-- Database 'temperaturedb'
5-- ---
6
7CREATE DATABASE temperaturedb;
8USE temperaturedb;
9
10-- ---
11-- Table 'temps'
12-- 
13-- ---
14
15DROP TABLE IF EXISTS temps;
16    
17CREATE TABLE temps (
18  temp_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
19  temp DECIMAL(5,2) NULL DEFAULT NULL,
20  light INTEGER UNSIGNED NULL DEFAULT NULL,
21  time_taken DATETIME NULL DEFAULT NULL,
22  PRIMARY KEY (temp_id)
23)ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
24
25-- Procedure to add a new temp 
26CREATE PROCEDURE addTemp(new_temp DECIMAL(5,2), new_light INTEGER UNSIGNED, new_time_taken DATETIME)
27  INSERT INTO temps (temp, light, time_taken) VALUES (new_temp, new_light, new_time_taken);
28  
29  
30  
31
32select * from temps;