Filipe Ferreira filipeandre

## convert_utf8_general_ci.sql
SELECT
	CONCAT( 'ALTER TABLE `', TABLE_NAME, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;' ) AS 'Copy & run these SQL statements:'
FROM
	INFORMATION_SCHEMA.TABLES
WHERE
	TABLE_SCHEMA = "database_name"
	AND TABLE_COLLATION != "utf8_general_ci"
	AND TABLE_TYPE = "BASE TABLE";

## gotranslate.go
package main

import (
	"fmt"
	"io"
	"log"
	"os"
	"regexp"
	"bufio"
	"bytes"

## translations.go
package main

import (
	"os"
	"io"
	"regexp"
	"path/filepath"
	"bufio"
	"strings"
	"bytes"

## publish.bat
dotnet publish . -c Release --runtime ubuntu.16.04-x64

## daemon.json
{
  "storage-driver": "overlay2",
  "graph": "/var/lib/docker",
  "log-driver": "json-file",
  "log-opts": {
    "max-size": "10m",
    "max-file": "2"
  },
  "debug": false,
  "userns-remap": "1000:1000"

## smb.conf
[global]
client max protocol = SMB3

## fstab
# Ram mounts
tmpfs /tmp                                                tmpfs   nodev,nosuid,size=1G  0       0
tmpfs /home/xooxx/.cache/google-chrome/Default            tmpfs   nodev,nosuid,size=1G  0       0
tmpfs /home/xooxx/.cache/mozilla/firefox/6xh5l5hs.default tmpfs   nodev,nosuid,size=1G  0       0

# Ntfs windows drives
UUID=F4789A76789A3778 /mnt/WD10EFRX                ntfs    windows_names,hide_hid_files,nosuid,nodev,permissions,defaults 0 0
UUID=C0D680E5D680DD52 /mnt/MK1059GMS               ntfs    windows_names,hide_hid_files,nosuid,nodev,permissions,defaults 0 0

## codecs.sh
sudo apt install ubuntu-restricted-extras

## reset_permissions.sh
sudo chmod -R a+rwX,o-w .
sudo chown $USER:$USER .

## systemd.service
#/lib/systemd/system

Restart=on-failure
RestartSec=5s
	SELECT
	CONCAT( 'ALTER TABLE `', TABLE_NAME, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;' ) AS 'Copy & run these SQL statements:'
	FROM
	INFORMATION_SCHEMA.TABLES
	WHERE
	TABLE_SCHEMA = "database_name"
	AND TABLE_COLLATION != "utf8_general_ci"
	AND TABLE_TYPE = "BASE TABLE";
	package main

	import (
	"fmt"
	"io"
	"log"
	"os"
	"regexp"
	"bufio"
	"bytes"
	{
	"storage-driver": "overlay2",
	"graph": "/var/lib/docker",
	"log-driver": "json-file",
	"log-opts": {
	"max-size": "10m",
	"max-file": "2"
	},
	"debug": false,
	"userns-remap": "1000:1000"
	# Ram mounts
	tmpfs /tmp tmpfs nodev,nosuid,size=1G 0 0
	tmpfs /home/xooxx/.cache/google-chrome/Default tmpfs nodev,nosuid,size=1G 0 0
	tmpfs /home/xooxx/.cache/mozilla/firefox/6xh5l5hs.default tmpfs nodev,nosuid,size=1G 0 0

	# Ntfs windows drives
	UUID=F4789A76789A3778 /mnt/WD10EFRX ntfs windows_names,hide_hid_files,nosuid,nodev,permissions,defaults 0 0
	UUID=C0D680E5D680DD52 /mnt/MK1059GMS ntfs windows_names,hide_hid_files,nosuid,nodev,permissions,defaults 0 0