Skip to content

Instantly share code, notes, and snippets.

Entertainment Store

DDL

  • Load Customers table
  • Load Items table
    • drop times rented
    • drop quantity
  • Checkout table
  • Drop total
@jpuck
jpuck / ubuntu-boot.md
Created September 21, 2017 15:53
can't upgrade? boot space full?

check current kernel

uname -r
4.4.0-96-generic

view all kernels

ls -1 /boot/

connecting from 130.184.252.46

18:10:12 $ composer -vvv require composer/semver
18:10:18
Reading ./composer.json
Loading config file /home/xenial/.composer/config.json
Loading config file /home/xenial/.composer/auth.json
Loading config file ./composer.json
Checked CA file /etc/ssl/certs/ca-certificates.crt: valid

Executing command (/home/xenial/scratch/gpgl/core): git branch --no-color --no-abbrev -v

@jpuck
jpuck / customer.sql
Created February 22, 2017 20:55
Chapter 6 In-Class Queries
--DROP TABLE c6_customer;
--CREATE TABLE c6_customer (
-- id INT IDENTITY PRIMARY KEY,
-- first_name VARCHAR(50) NOT NULL,
-- created_at DATETIME DEFAULT GETDATE(),
-- email VARCHAR(255) UNIQUE
--);
--INSERT INTO c6_customer (first_name, email)

https://help.ubuntu.com/lts/serverguide/sssd-ad.html

set default shell in [nss] section of /etc/sssd/sssd.conf

[nss]
default_shell = /bin/bash

note that sudo systemctl start sssd.service will fail until after kinit and sudo net ads join -k

add windows "enterprise admins" group to sudoers in root visudo