Eihen

using System.Collections.Generic;
using System.Data;

// Abstract class, can't be used directly, needs to be inherited in another class implementing the abstract methods

/// <summary>
/// Generic class for DataBase management implementing methods that doesn't depend on the DataBase used
/// </summary>
public abstract class Database
{

Eihen

INSERT INTO alunos VALUES (
  ALUNO_TY (
    '55522214800',
    '1234567890',
    'Manuel',
    'Avenida Qualquer',
    'emaiu@serv.dot',
    '123456789',
    'Tramandai',
    'RS',

Eihen

# REQUIREMENTS
# 1) Understanding that this script is provided as-is and I have no responsibility for whatever damage occurs
#    That said, if the script was strictly tested and no problems should arise if you use it without any modifications
#	of areas which not states that can be modified
#    Also if you find any problems let me know to see if I can help you (and/or fix the script)

# Put this at the end of your ~/.bashrc if you already have one or just throw it in your home directory if you don't
# Make sure there are no other scripts starting ssh-agents or adding keys

# This assumes you have https://github.com/magicmonty/bash-git-prompt in your home directory

Eihen

#!/bin/bash

# REQUIREMENTS:
# 1) SSH Access to the remote server
# 2) Reading the whole script and understanding what it does before using it
#    	If you can't understand something, let me know and I'll be happy to help
# 3) Understanding that this script is provided as-is and I have no responsibility for whatever damage occurs
#    That said, if the script was strictly tested and no problems should arise if you use it without any modifications
#	of areas which not states that can be modified
#    Also if you find any problems let me know to see if I can help you (and/or fix the script)

Eihen

-- https://stackoverflow.com/questions/2250775/force-innodb-to-recheck-foreign-keys-on-a-table-tables
DELIMITER $$

DROP PROCEDURE IF EXISTS ANALYZE_INVALID_FOREIGN_KEYS$$

CREATE
    PROCEDURE `ANALYZE_INVALID_FOREIGN_KEYS`(
        checked_database_name VARCHAR(64), 
        checked_table_name VARCHAR(64), 
        temporary_result_table ENUM('Y', 'N'))

Eihen

; Play/Pause
+F10::
Send, {Media_Play_Pause}
Return

; Previous Song
+F11::
Send, {Media_Prev}
Return

Eihen

[Unit]
Description=ArchSteamFarm
After=network-online.target

[Service]
Type=simple
User={user}
Group={group}
Restart=always
RestartSec=15s

Eihen

#!/bin/bash

# Configurable script to setup a new deployment point for an application
# It helps you create databases, apache configuration files, pushable git bare repositories, diretory creation and file permissions

# This program is free software. It comes without any warranty, to the extent permitted by applicable law.
# You can redistribute it and/or modify it under the terms of the Do What The Fuck You Want To Public License, Version 2,
# as published by Sam Hocevar. See http://www.wtfpl.net/ for more details.

set -e

Eihen

#!/bin/sh
set -ef -o pipefail

# Script to import backups from databases made in a remote server into a local database connection over ssh
# Designed to be used together with the mariadb-backup script (https://gist.github.com/Eihen/53be043c217009d5705da28e07a1b1f4)

# This program is free software. It comes without any warranty, to the extent permitted by applicable law.
# You can redistribute it and/or modify it under the terms of the Do What The Fuck You Want To Public License, Version 2,
# as published by Sam Hocevar. See http://www.wtfpl.net/ for more details.

Eihen

#!/bin/bash

# Based on Gabriel O'Brien's mariadb-backup.sh (https://github.com/gmobrien/mariadb-backup.sh)
# The main difference is that this script use the mysql config groups to allow backups from multiple connections simultaneously
# Check the original license bellow (https://gist.github.com/Eihen/53be043c217009d5705da28e07a1b1f4#file-license)
# If not in violation of that license you can do whatever you want with this

set -ef -o pipefail

# Set the default values