-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathall.sql
158 lines (158 loc) · 18.6 KB
/
all.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
CREATE TABLE IF NOT EXISTS software (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT VARCHAR(255) NOT NULL,
category TEXT VARCHAR(255) NOT NULL,
method TEXT VARCHAR(5) NOT NULL,
info TEXT VARCHAR(255)
);
CREATE TABLE IF NOT EXISTS config (
id INTEGER PRIMARY KEY AUTOINCREMENT,
method TEXT VARCHAR(20) NOT NULL,
category TEXT VARCHAR(255) NOT NULL,
domain TEXT VARCHAR(255),
key TEXT VARCHAR(255) NOT NULL,
keytyp TEXT VARCHAR(10),
keyvalue TEXT VARCHAR(25) NOT NULL,
info TEXT VARCHAR(255)
);
INSERT INTO config(method, category, key, keyvalue, info) VALUES ('systemsetup', 'time', 'settimezone', 'Europe/Zurich', 'Set timezone to Zurich.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'window', 'NSGlobalDomain', 'NSAutomaticWindowAnimationsEnabled', 'bool', 'false', 'Disable animations when opening and closing windows.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'window', 'NSGlobalDomain', 'NSAutomaticWindowAnimationsEnabled', 'bool', 'false', 'Disable animations when opening and closing windows.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'window', 'NSGlobalDomain', 'QLPanelAnimationDuration', 'float', '0', 'Disable animations when opening a Quick Look window.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'window', 'NSGlobalDomain', 'QLPanelAnimationDuration', 'float', '0', 'Disable animations when opening a Quick Look window.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'window', 'NSGlobalDomain', 'NSNavPanelExpandedStateForSaveMode', 'bool', 'true', 'Expand save panel by default.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'window', 'NSGlobalDomain', 'NSNavPanelExpandedStateForSaveMode2', 'bool', 'true', 'Expand save panel by default.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'window', 'NSGlobalDomain', 'PMPrintingExpandedStateForPrint', 'bool', 'true', 'Expand print panel by default.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'finder', 'com.apple.finder', 'DisableAllAnimations', 'bool', 'true', 'Disable animation when opening the Info window in Finder (cmd + i).');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'finder', 'com.apple.finder', 'AppleShowAllFiles', 'bool', 'true', 'Show in finder hidden files by default.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'finder', 'com.apple.finder', '_FXShowPosixPathInTitle', 'bool', 'true', 'Display full POSIX path as Finder window title.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'finder', 'com.apple.finder', 'AppleShowAllExtensions', 'bool', 'true', 'Show in finder filename extensions.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'finder', 'com.apple.finder', 'ShowStatusBar', 'bool', 'true', 'Show in status bar in finder.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'finder', 'com.apple.finder', 'ShowPathbar', 'bool', 'true', 'Show Path bar in Finder.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'finder', 'com.apple.finder', 'WarnOnEmptyTrash', 'bool', 'false', 'Disable the warning before emptying the Trash.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'finder', 'com.apple.finder', 'FXEnableExtensionChangeWarning', 'bool', 'false', 'Disable the warning when changing a file extension.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'finder', 'com.apple.finder', 'FXPreferredViewStyle', 'string', 'Nlsv', 'Use list view in all Finder windows by default.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'finder', 'com.apple.desktopservices', 'DSDontWriteNetworkStores', 'bool', 'true', 'Avoid creating .DS_Store files on network volumes.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'finder', 'com.apple.finder', 'FXDefaultSearchScope', 'string', 'SCcf', 'Use current directory as default search scope in Finder.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'dock', 'com.apple.dock', 'launchanim', 'bool', 'false', 'Disable animations when you open an application from the Dock.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'dock', 'com.apple.dock', 'expose-animation-duration', 'float', '0.1', 'Make all animations faster that are used by Mission Control.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'dock', 'com.apple.dock', 'autohide-delay', 'float', '0', 'Disable the delay when you hide the Dock');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'dock', 'com.apple.dock', 'autohide', 'bool', 'true', 'Automatically hide and show the Dock');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'dock', 'com.apple.dock', 'wvous-tl-corner', 'int', '5', 'Top left screen corner enable screen saver');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'dock', 'com.apple.dock', 'wvous-tl-modifier', 'int', '0', 'Top left screen corner enable screen saver');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'safari', 'com.apple.Safari', 'WebKitInitialTimedLayoutDelay', 'string', '0.25', 'Disable the standard delay in rendering a Web page.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'safari', 'com.apple.Safari', 'IncludeInternalDebugMenu', 'bool', 'true', 'Enable Safari’s debug menu.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'com.apple.menuextra.battery', 'ShowPercent', 'string', 'YES', 'Show percentage battery info.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'com.apple.LaunchServices', 'LSQuarantine', 'bool', 'false', 'Disable the “Are you sure you want to open this application?” dialog.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'NSGlobalDomain', 'KeyRepeat', 'int', '1', 'The keyboard react faster to keystrokes.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'NSGlobalDomain', 'InitialKeyRepeat', 'int', '10', 'The keyboard react faster to keystrokes.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'NSGlobalDomain', 'ApplePressAndHoldEnabled', 'bool', 'true', 'Set Press and hold to enable for special character');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'com.apple.SoftwareUpdate', 'AutomaticDownload', 'bool', 'false', 'Disable autoamtic download from updates.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'com.apple.SoftwareUpdate', 'AutomaticDownload', 'bool', 'false', 'Disable autoamtic download from updates.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'com.apple.driver.AppleBluetoothMultitouch.trackpad', 'Clicking', 'bool', 'true', 'Trackpad: enable tap to click for this user and for the login screen.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'NSGlobalDomain', 'com.apple.mouse.tapBehavior', 'int', '1', 'Trackpad: enable tap to click for this user and for the login screen.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'com.apple.BezelServices', 'kDim', 'bool', 'true', 'Automatically illuminate built-in MacBook keyboard in low light.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'com.apple.BezelServices', 'kDimTime', 'int', '300', 'Turn off keyboard illumination when computer is not used for 5 minutes.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'NSGlobalDomain', 'AppleKeyboardUIMode', 'int', '3', 'Enable full keyboard access for all controls (e.g. enable Tab in modal dialogs).');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'NSGlobalDomain', 'AppleFontSmoothing', 'int', '2', 'Enable subpixel font rendering on non-Apple LCDs.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'system', 'com.apple.screencapture', 'disable-shadow', 'bool', 'true', 'Disable shadow in screenshots.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'screensaver', 'com.apple.screensaver', 'askForPassword', 'int', '1', 'Require password immediately after sleep or screen saver begins.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'screensaver', 'com.apple.screensaver', 'askForPasswordDelay', 'int', '0', 'Require password immediately after sleep or screen saver begins.');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'mail', 'com.apple.mail', 'DisableSendAnimations', 'bool', 'true', 'Disable the animation when you sending an e-mail');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'mail', 'com.apple.mail', 'DisableReplyAnimations', 'bool', 'true', 'Disable the animation when you replying an e-mail');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'textedit', 'com.apple.TextEdit', 'RichText', 'int', '0', 'Use plain text as default format in TextEdit');
INSERT INTO config(method, category, domain, key, keytyp, keyvalue, info) VALUES ('defaults', 'appstore', 'com.apple.appstore', 'ShowDebugMenu', 'bool', 'true', 'Show debug menu in appstore.');
INSERT INTO software(name, category, method) VALUES ('caskroom/cask', 'tap', 'tap');
INSERT INTO software(name, category, method) VALUES ('caskroom/drivers', 'tap', 'tap');
INSERT INTO software(name, category, method) VALUES ('caskroom/versions', 'tap', 'tap');
INSERT INTO software(name, category, method) VALUES ('caskroom/fonts', 'tap', 'tap');
INSERT INTO software(name, category, method) VALUES ('font-source-code-pro', 'font', 'cask');
INSERT INTO software(name, category, method) VALUES ('font-dejavu-sans', 'font', 'cask');
INSERT INTO software(name, category, method) VALUES ('font-monoid', 'font', 'cask');
INSERT INTO software(name, category, method) VALUES ('font-raleway', 'font', 'cask');
INSERT INTO software(name, category, method) VALUES ('adobe-creative-cloud', 'multimedia', 'cask');
INSERT INTO software(name, category, method) VALUES ('bartender', 'multimedia', 'cask');
INSERT INTO software(name, category, method) VALUES ('bash', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('shellcheck', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('netcat', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('bash-completion', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('gpg', 'crypt', 'core');
INSERT INTO software(name, category, method) VALUES ('zsh', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('controlplane', 'core', 'cask');
INSERT INTO software(name, category, method) VALUES ('cheatsheet', 'multimedia', 'cask');
INSERT INTO software(name, category, method) VALUES ('cleanmymac', 'core', 'cask');
INSERT INTO software(name, category, method) VALUES ('coreutils', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('dnscrypt', 'core', 'cask');
INSERT INTO software(name, category, method) VALUES ('firefox', 'browser', 'cask');
INSERT INTO software(name, category, method) VALUES ('go', 'programming', 'core');
INSERT INTO software(name, category, method) VALUES ('google-chrome', 'browser', 'cask');
INSERT INTO software(name, category, method) VALUES ('handbrake', 'multimedia', 'cask');
INSERT INTO software(name, category, method) VALUES ('istat-menus', 'core', 'cask');
INSERT INTO software(name, category, method) VALUES ('iterm2', 'core', 'cask');
INSERT INTO software(name, category, method) VALUES ('java', 'programming', 'cask');
INSERT INTO software(name, category, method) VALUES ('keepassx', 'core', 'cask');
INSERT INTO software(name, category, method) VALUES ('libreoffice', 'office', 'cask');
INSERT INTO software(name, category, method) VALUES ('libreoffice-language-pack', 'office', 'cask');
INSERT INTO software(name, category, method) VALUES ('mas', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('microsoft-office', 'office', 'cask');
INSERT INTO software(name, category, method) VALUES ('neovim', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('macvim', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('nextcloud', 'core', 'cask');
INSERT INTO software(name, category, method) VALUES ('nmap', 'security', 'core');
INSERT INTO software(name, category, method) VALUES ('whireshark', 'security', 'core');
INSERT INTO software(name, category, method) VALUES ('hping', 'security', 'core');
INSERT INTO software(name, category, method) VALUES ('node', 'programming', 'core');
INSERT INTO software(name, category, method) VALUES ('omnifocus', 'office', 'cask');
INSERT INTO software(name, category, method) VALUES ('omnigraffle', 'office', 'cask');
INSERT INTO software(name, category, method) VALUES ('opera', 'browser', 'cask');
INSERT INTO software(name, category, method) VALUES ('p7zip', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('pwgen', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('sqlite', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('sizeup', 'core', 'cask');
INSERT INTO software(name, category, method) VALUES ('skype', 'communication', 'cask');
INSERT INTO software(name, category, method) VALUES ('skype-for-business', 'communication', 'cask');
INSERT INTO software(name, category, method) VALUES ('slack', 'communication', 'cask');
INSERT INTO software(name, category, method) VALUES ('vagrant', 'dev', 'cask');
INSERT INTO software(name, category, method) VALUES ('docker', 'dev', 'cask');
INSERT INTO software(name, category, method) VALUES ('chefdk', 'dev', 'cask');
INSERT INTO software(name, category, method) VALUES ('rubocop', 'dev', 'gem');
INSERT INTO software(name, category, method) VALUES ('testssl', 'security', 'core');
INSERT INTO software(name, category, method) VALUES ('wireshark', 'security', 'core');
INSERT INTO software(name, category, method) VALUES ('virtualbox', 'dev', 'cask');
INSERT INTO software(name, category, method) VALUES ('vmware-fusion', 'dev', 'cask');
INSERT INTO software(name, category, method) VALUES ('snagit', 'support', 'cask');
INSERT INTO software(name, category, method) VALUES ('sonos', 'multimedia', 'cask');
INSERT INTO software(name, category, method) VALUES ('i1profiler', 'driver', 'cask');
INSERT INTO software(name, category, method) VALUES ('garmin-express', 'driver', 'cask');
INSERT INTO software(name, category, method) VALUES ('wacom-intuos-tablet', 'driver', 'cask');
INSERT INTO software(name, category, method) VALUES ('teamviewer', 'support', 'cask');
INSERT INTO software(name, category, method) VALUES ('tmux', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('torbrowser', 'browser', 'cask');
INSERT INTO software(name, category, method) VALUES ('unrar', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('vlc', 'multimedia', 'cask');
INSERT INTO software(name, category, method) VALUES ('wget', 'core', 'core');
INSERT INTO software(name, category, method) VALUES ('whatsapp', 'communication', 'cask');
INSERT INTO software(name, category, method) VALUES ('gpg-suite', 'communication', 'cask');
INSERT INTO software(name, category, method) VALUES ('microsoft-teams', 'communication', 'cask');
INSERT INTO software(name, category, method) VALUES ('citrix-receiver', 'communication', 'cask');
INSERT INTO software(name, category, method) VALUES ('youtube-dl', 'multimedia', 'core');
INSERT INTO software(name, category, method, info) VALUES ('1090488118', 'core', 'mas', 'gemini 2');
INSERT INTO software(name, category, method, info) VALUES ('405399194', 'core', 'mas', 'kindle');
INSERT INTO software(name, category, method, info) VALUES ('1063996724', 'core', 'mas', 'Tyme 2');
INSERT INTO software(name, category, method, info) VALUES ('494803304', 'core', 'mas', 'WiFi Explorer');
INSERT INTO software(name, category, method, info) VALUES ('409183694', 'office', 'mas', 'keynote');
INSERT INTO software(name, category, method, info) VALUES ('409201541', 'office', 'mas', 'pages');
INSERT INTO software(name, category, method, info) VALUES ('409203825', 'office', 'mas', 'numbers');
INSERT INTO software(name, category, method, info) VALUES ('424389933', 'multimedia', 'mas', 'final cut pro');
INSERT INTO software(name, category, method, info) VALUES ('424390742', 'multimedia', 'mas', 'compressor');
INSERT INTO software(name, category, method, info) VALUES ('425264550', 'core', 'mas', 'blackmagic disk speed test');
INSERT INTO software(name, category, method, info) VALUES ('425424353', 'core', 'mas', 'the unarchiver');
INSERT INTO software(name, category, method, info) VALUES ('430255202', 'core', 'mas', 'mactracker');
INSERT INTO software(name, category, method, info) VALUES ('434290957', 'multimedia', 'mas', 'motion');
INSERT INTO software(name, category, method, info) VALUES ('497799835', 'programming', 'mas', 'Xcode');
INSERT INTO software(name, category, method, info) VALUES ('572280828', 'core', 'mas', 'MacFamilyTree');
INSERT INTO software(name, category, method, info) VALUES ('634148309', 'multimedia', 'mas', 'logic pro x');
INSERT INTO software(name, category, method, info) VALUES ('634159523', 'multimedia', 'mas', 'main stage');
INSERT INTO software(name, category, method, info) VALUES ('715768417', 'core', 'mas', 'Microsoft Remote Desktop');
INSERT INTO software(name, category, method, info) VALUES ('801463932', 'games', 'mas', 'stockfish');
INSERT INTO software(name, category, method, info) VALUES ('824183456', 'multimedia', 'mas', 'affinity photo');