https://github.com/d630/playground-php/tree/master/corg2/sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env bash | |
declare -A Pack | |
function callback { | |
Pack[$2]= | |
} | |
mapfile -t -c 1 -C callback < "${1?error: file missing}" | |
suite=${2?error: chroot of suite missing} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
adduser | |
apt | |
apt-utils | |
base-files | |
base-passwd | |
bash | |
bsdmainutils | |
bsdutils | |
coreutils | |
cpio |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
adduser | |
apt | |
apt-utils | |
base-files | |
base-passwd | |
bash | |
bsdmainutils | |
bsdutils | |
coreutils | |
cpio |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- INSERTS. | |
-- | |
SET foreign_key_checks=0; | |
INSERT INTO logi(ttable) | |
VALUES ('customer'), ('activity'), ('file'); | |
INSERT INTO employee(nickname, password) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- START TRANSACTION; | |
SET foreign_key_checks=0; | |
DROP DATABASE IF EXISTS quiz; | |
CREATE DATABASE quiz; | |
USE quiz; | |
-- TABLES. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
START TRANSACTION; | |
SET foreign_key_checks=0; | |
DROP DATABASE IF EXISTS bestellando; | |
CREATE DATABASE bestellando; | |
USE bestellando; | |
CREATE TABLE dish ( | |
id TINYINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
class Data | |
{ | |
protected $conn; | |
protected $query; | |
protected $fields; | |
public function __construct() | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
START TRANSACTION; | |
SET foreign_key_checks=0; | |
DROP DATABASE IF EXISTS immo; | |
CREATE DATABASE immo; | |
USE immo; | |
-- GRANT ALL ON immo.* TO 'user'@'localhost'; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
TODO | |
pruefeID() |
NewerOlder