DGWFUi4u

1#denne linjen kan slettes 
2CREATE DATABASE `database` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_danish_ci */;
3
4CREATE TABlE `database`.customer (
5	cID INT(5) auto_increment primary key,
6	firstname varchar(50) NOT null,
7	lastname varchar(50) not null,
8	email varchar(50),
9	adress varchar(50) not null,
10	zipcode int(4) not null,
11	city varchar(50)
12
13);
14
15describe .customer;
16
17INSERT into `database`.customer VALUES (NULL, "Per", "Hansen", "per.hansen@mail.no", "Landgata 88", 4666, "Oslo");
18INSERT into `database`.customer VALUES (NULL, "Jan", "Persen", "jan.persen@mail.no", "Landgata 88", 4666, "Oslo");
19INSERT into `database`.customer VALUES (NULL, "Harald", "Dagmann", "jørn.dagmann@mail.no", "Tullegata 48", 8884, "Lyngdal");
20
21UPDATE customer SET adress = "mordi Veien 5" where cID = 1;
22
23DELETE from `database`.customer WHERE cID=3;
24
25INSERT into `database`.customer VALUES (null, "Brynjar", "Blomvik", "brynjar.blomvik@mail.no", "Tullegata 48", 8884, "Bergen");
26INSERT into `database`.customer VALUES (null, "Kristian", "Vågen", "kristian.vågen@mail.no", "Tullegata 48", 8884, "Bergen");
27
28SELECT firstname, email from `database`.customer;
29
30SELECT * from `database`.customer WHERE firstname like 'Bryn%';
31
32#Sletter alt i databasen. 
33Truncate table `database`.customer;
34
35Drop table `database`.customer;
36
37commit;
38
39
40
41
42
43
44CREATE TABLE IF NOT EXISTS `database`.`Order_Data` (
45  `idOrder_Data` INT NOT NULL,
46  `order_date` DATE NOT NULL,
47  `delivery_adress` VARCHAR(45) NOT NULL,
48  `delivery_date` DATE NOT NULL,
49  `status` VARCHAR(45) NOT NULL,
50  `cID` INT(9) NOT NULL,
51  PRIMARY KEY (`idOrder_Data`),
52  INDEX `cID_idx` (`cID` ASC),
53  CONSTRAINT `cID`
54    FOREIGN KEY (`cID`)
55    REFERENCES `database`.`Customer` (`cID`)
56    ON DELETE NO ACTION
57    ON UPDATE NO ACTION)
58ENGINE = InnoDB