Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #Erstellen der Tabelle 'Räume'
- DROP TABLE IF EXISTS `E2IT1_10_SAE`.`Räume`;
- CREATE TABLE IF NOT EXISTS `E2IT1_10_SAE`.`Räume`(
- idRäume INT NOT NULL AUTO_INCREMENT,
- Raumbezeichnung VARCHAR(45),
- idAbteilungen INT,
- PRIMARY KEY(idRäume),
- FOREIGN KEY(idAbteilungen) REFERENCES Abteilungen(idAbteilungen)
- );
- DROP TABLE IF EXISTS `E2IT1_10_SAE`.`Räume_has_Assets`;
- CREATE TABLE IF NOT EXISTS `E2IT1_10_SAE`.`Räume_has_Assets`(
- idRäume INT NOT NULL,
- idAssets INT NOT NULL,
- PRIMARY KEY (idRäume, idAssets),
- FOREIGN KEY (idRäume) REFERENCES `E2IT1_10_SAE`.`Räume`(`idRäume`),
- FOREIGN KEY (idRäume) REFERENCES `E2IT1_10_SAE`.`Assets`(`idAssets`)
- );
- #ERSTELLEN DER TABELLE 'ASSETS'
- DROP TABLE IF EXISTS `E2IT1_10_SAE`.`Assets`;
- CREATE TABLE IF NOT EXISTS `E2IT1_10_SAE`.`Assets`(
- idAssets INT NOT NULL AUTO_INCREMENT,
- PCs INT,
- Laptops INT,
- Telefone INT,
- Drucker INT,
- `Switches` INT,
- `Access-Points` INT,
- `RFID-Reader` INT,
- `RFID-Karten` INT,
- PRIMARY KEY(idAssets)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement