Last active
January 11, 2017 16:30
-
-
Save dmorley/0a2470c91fcc5a6f583c67f51ba409f1 to your computer and use it in GitHub Desktop.
podup sql plan
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ALTER TABLE pods ADD terms text, ADD sslexpire text, ADD uptime_custom text ADD dnssec boolean ADD masterversion text, ADD shortversion text; | |
ALTER TABLE pods DROP Hgitdate, DROP Hgitref, DROP Hruntime, DROP Hencoding, DROP longversion, DROP ptr, DROP whois, DROP postalcode, DROP connection; | |
ALTER TABLE pods RENAME COLUMN pingdomurl TO statsurl; | |
ALTER TABLE pods RENAME COLUMN pingdomlast TO statslast; | |
ALTER TABLE pods RENAME COLUMN xmpp TO service_xmpp; | |
ALTER TABLE pods RENAME COLUMN uptimelast7 TO uptime_alltime; | |
ALTER TABLE pods ALTER COLUMN ipv6 TYPE boolean USING ipv6::boolean; | |
ALTER TABLE pods ALTER COLUMN hidden TYPE boolean USING hidden::boolean; | |
ALTER TABLE pods ALTER COLUMN secure TYPE boolean USING secure::boolean; | |
ALTER TABLE pods ALTER COLUMN signup TYPE boolean USING signup::boolean; | |
DROP TABLE users; | |
CREATE TABLE apikeys ( | |
key text, | |
email text, | |
usage int, | |
dateCreated timestamp DEFAULT current_timestamp | |
); | |
CREATE TABLE clicks ( | |
domain text, | |
manualclick int, | |
autoclick int, | |
dateClicked timestamp DEFAULT current_timestamp | |
); | |
CREATE TABLE checks ( | |
domain text, | |
online boolean, | |
error text, | |
dateChecked timestamp DEFAULT current_timestamp | |
); | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment