Skip to content

Instantly share code, notes, and snippets.

@clifff
clifff / add_auto_increment_to_int_single_pk.sql
Created January 11, 2019 20:39 — forked from carlosrobles/add_auto_increment_to_int_single_pk.sql
Add auto_increment to all the single PRIMARY KEY of type int of a database
DROP TABLE if exists temp;
CREATE TABLE temp (
`table` varchar(250) DEFAULT NULL,
`colum` varchar(250) DEFAULT NULL,
`type` varchar(250) DEFAULT NULL,
`number_of_PK` tinyint(2) DEFAULT NULL,
`alter` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
@clifff
clifff / README.md
Last active March 10, 2023 18:58
Post to Mastodon Airtable Script
  • Navigate to https://shakedown.social/settings/applications
  • Click "New Application", name it something like "Airtable"
  • Check off the write:statuses scope and uncheck all the other ones.
  • Click "Submit" at the bottom of the page.
  • Click into the "Airtable" application you just made.
  • Copy the value for "Your access token". Paste it into ACCESS_TOKEN_HERE in the script.
  • Populate STATUS_TEXT_HERE in the script with that status text you want.
@clifff
clifff / custom.css
Created April 10, 2023 01:42
Custom CSS to add reply icons to Mastodon website
div.status.status-public.status-reply span.status__visibility-icon .fa-globe::before {
content: " ";
}
div.status.status-unlisted.status-reply span.status__visibility-icon .fa-unlock::before {
content: " ";
}
div.status.status-direct.status-reply span.status__visibility-icon .fa-at::before {
content: " ";