Page MenuHomestyx hydra
Files F206982

No OneTemporary
Actions

View Options

diff --git a/resources/sql/patches/010.herald.sql b/resources/sql/patches/010.herald.sql
index 4ec76332b0..df061e360e 100644
--- a/resources/sql/patches/010.herald.sql
+++ b/resources/sql/patches/010.herald.sql
@@ -1,44 +1,44 @@
-CREATE DATABASE phabricator_herald;
+CREATE DATABASE IF NOT EXISTS phabricator_herald;
CREATE TABLE phabricator_herald.herald_action (
id int unsigned not null auto_increment primary key,
ruleID int unsigned not null,
action varchar(255) not null,
target text not null
);
CREATE TABLE phabricator_herald.herald_rule (
id int unsigned not null auto_increment primary key,
name varchar(255) not null,
authorPHID varchar(64) binary not null,
contentType varchar(255) not null,
mustMatchAll bool not null,
configVersion int unsigned not null default '1',
dateCreated int unsigned not null,
dateModified int unsigned not null,
unique key (authorPHID, name)
);
CREATE TABLE phabricator_herald.herald_condition (
id int unsigned not null auto_increment primary key,
ruleID int unsigned not null,
fieldName varchar(255) not null,
fieldCondition varchar(255) not null,
value text not null
);
CREATE TABLE phabricator_herald.herald_transcript (
id int unsigned not null auto_increment primary key,
phid varchar(64) binary not null,
time int unsigned not null,
host varchar(255) not null,
psth varchar(255) not null,
duration float not null,
objectPHID varchar(64) binary not null,
dryRun bool not null,
objectTranscript longblob not null,
ruleTranscripts longblob not null,
conditionTranscripts longblob not null,
applyTranscripts longblob not null,
unique key (phid)
-);
\ No newline at end of file
+);
diff --git a/resources/sql/patches/018.owners.sql b/resources/sql/patches/018.owners.sql
index 9628cc3710..0fa822c315 100644
--- a/resources/sql/patches/018.owners.sql
+++ b/resources/sql/patches/018.owners.sql
@@ -1,27 +1,27 @@
-CREATE DATABASE phabricator_owners;
+CREATE DATABASE IF NOT EXISTS phabricator_owners;
CREATE TABLE phabricator_owners.owners_package (
id int unsigned not null auto_increment primary key,
phid varchar(64) binary not null,
unique key(phid),
name varchar(255) not null,
unique key(name),
description text not null,
primaryOwnerPHID varchar(64) binary
);
CREATE TABLE phabricator_owners.owners_owner (
id int unsigned not null auto_increment primary key,
packageID int unsigned not null,
userPHID varchar(64) binary not null,
UNIQUE KEY(packageID, userPHID),
KEY(userPHID)
);
CREATE TABLE phabricator_owners.owners_path (
id int unsigned not null auto_increment primary key,
packageID int unsigned not null,
key(packageID),
repositoryPHID varchar(64) binary not null,
path varchar(255) not null
-);
\ No newline at end of file
+);
diff --git a/resources/sql/patches/021.xhpastview.sql b/resources/sql/patches/021.xhpastview.sql
index 09ec1b16f0..44c45ddffe 100644
--- a/resources/sql/patches/021.xhpastview.sql
+++ b/resources/sql/patches/021.xhpastview.sql
@@ -1,9 +1,9 @@
-CREATE DATABASE phabricator_xhpastview;
+CREATE DATABASE IF NOT EXISTS phabricator_xhpastview;
CREATE TABLE phabricator_xhpastview.xhpastview_parsetree (
id int unsigned not null auto_increment primary key,
authorPHID varchar(64) binary,
input longblob not null,
stdout longblob not null,
dateCreated int unsigned not null,
dateModified int unsigned not null
-);
\ No newline at end of file
+);
diff --git a/resources/sql/patches/043.pastebin.sql b/resources/sql/patches/043.pastebin.sql
index 208ade90a1..6df5f21b3b 100644
--- a/resources/sql/patches/043.pastebin.sql
+++ b/resources/sql/patches/043.pastebin.sql
@@ -1,17 +1,17 @@
-CREATE DATABASE phabricator_pastebin;
+CREATE DATABASE IF NOT EXISTS phabricator_pastebin;
CREATE TABLE phabricator_pastebin.pastebin_paste (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
phid VARCHAR(64) BINARY NOT NULL,
authorPHID VARCHAR(64) BINARY NOT NULL,
filePHID VARCHAR(64) BINARY NOT NULL,
dateCreated INT UNSIGNED NOT NULL,
dateModified INT UNSIGNED NOT NULL
);
INSERT INTO phabricator_directory.directory_item
(name, description, href, categoryID, sequence, dateCreated, dateModified)
VALUES
("Paste", "Mmm... tasty, delicious paste.", "/paste/", 5, 150,
- UNIX_TIMESTAMP(), UNIX_TIMESTAMP());
\ No newline at end of file
+ UNIX_TIMESTAMP(), UNIX_TIMESTAMP());
diff --git a/resources/sql/patches/044.countdown.sql b/resources/sql/patches/044.countdown.sql
index 77836429a7..38354d2306 100644
--- a/resources/sql/patches/044.countdown.sql
+++ b/resources/sql/patches/044.countdown.sql
@@ -1,16 +1,16 @@
-CREATE DATABASE phabricator_countdown;
+CREATE DATABASE IF NOT EXISTS phabricator_countdown;
CREATE TABLE phabricator_countdown.countdown_timer (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
authorPHID VARCHAR(64) BINARY NOT NULL,
datepoint INT UNSIGNED NOT NULL,
dateCreated INT UNSIGNED NOT NULL,
dateModified INT UNSIGNED NOT NULL
);
INSERT INTO phabricator_directory.directory_item
(name, description, href, categoryID, sequence, dateCreated, dateModified)
VALUES
("Countdown", "Utilize the full capabilities of your ALU.", "/countdown/", 5, 350,
UNIX_TIMESTAMP(), UNIX_TIMESTAMP());
diff --git a/resources/sql/patches/053.feed.sql b/resources/sql/patches/053.feed.sql
index 17dd8b2da7..c0893fb62f 100644
--- a/resources/sql/patches/053.feed.sql
+++ b/resources/sql/patches/053.feed.sql
@@ -1,21 +1,21 @@
-CREATE DATABASE phabricator_feed;
+CREATE DATABASE IF NOT EXISTS phabricator_feed;
CREATE TABLE phabricator_feed.feed_storydata (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
phid VARCHAR(64) BINARY NOT NULL,
UNIQUE KEY (phid),
chronologicalKey BIGINT UNSIGNED NOT NULL,
UNIQUE KEY (chronologicalKey),
storyType varchar(64) NOT NULL,
storyData LONGBLOB NOT NULL,
authorPHID varchar(64) BINARY NOT NULL,
dateCreated INT UNSIGNED NOT NULL,
dateModified INT UNSIGNED NOT NULL
);
CREATE TABLE phabricator_feed.feed_storyreference (
objectPHID varchar(64) BINARY NOT NULL,
chronologicalKey BIGINT UNSIGNED NOT NULL,
UNIQUE KEY (objectPHID, chronologicalKey),
KEY (chronologicalKey)
);
diff --git a/resources/sql/patches/056.slowvote.sql b/resources/sql/patches/056.slowvote.sql
index dd877deba9..829d73dfbc 100644
--- a/resources/sql/patches/056.slowvote.sql
+++ b/resources/sql/patches/056.slowvote.sql
@@ -1,50 +1,50 @@
-CREATE DATABASE phabricator_slowvote;
+CREATE DATABASE IF NOT EXISTS phabricator_slowvote;
CREATE TABLE phabricator_slowvote.slowvote_poll (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
question VARCHAR(255) NOT NULL,
phid VARCHAR(64) BINARY NOT NULL,
UNIQUE KEY (phid),
authorPHID VARCHAR(64) BINARY NOT NULL,
responseVisibility INT UNSIGNED NOT NULL,
shuffle INT UNSIGNED NOT NULL,
method INT UNSIGNED NOT NULL,
dateCreated INT UNSIGNED NOT NULL,
dateModified INT UNSIGNED NOT NULL
);
CREATE TABLE phabricator_slowvote.slowvote_option (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
pollID INT UNSIGNED NOT NULL,
KEY (pollID),
name VARCHAR(255) NOT NULL,
dateCreated INT UNSIGNED NOT NULL,
dateModified INT UNSIGNED NOT NULL
);
CREATE TABLE phabricator_slowvote.slowvote_comment (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
pollID INT UNSIGNED NOT NULL,
UNIQUE KEY (pollID, authorPHID),
authorPHID VARCHAR(64) BINARY NOT NULL,
commentText LONGBLOB NOT NULL,
dateCreated INT UNSIGNED NOT NULL,
dateModified INT UNSIGNED NOT NULL
);
CREATE TABLE phabricator_slowvote.slowvote_choice (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
pollID INT UNSIGNED NOT NULL,
KEY (pollID),
optionID INT UNSIGNED NOT NULL,
authorPHID VARCHAR(64) BINARY NOT NULL,
KEY (authorPHID),
dateCreated INT UNSIGNED NOT NULL,
dateModified INT UNSIGNED NOT NULL
);
INSERT INTO phabricator_directory.directory_item
(name, description, href, categoryID, sequence, dateCreated, dateModified)
VALUES
("Slowvote", "Design by committee.", "/vote/", 5, 250,
- UNIX_TIMESTAMP(), UNIX_TIMESTAMP());
\ No newline at end of file
+ UNIX_TIMESTAMP(), UNIX_TIMESTAMP());
diff --git a/resources/sql/patches/060.phriction.sql b/resources/sql/patches/060.phriction.sql
index d09752e840..c7f5efee4b 100644
--- a/resources/sql/patches/060.phriction.sql
+++ b/resources/sql/patches/060.phriction.sql
@@ -1,12 +1,12 @@
-CREATE DATABASE phabricator_phriction;
+CREATE DATABASE IF NOT EXISTS phabricator_phriction;
CREATE TABLE phabricator_phriction.phriction_document (
id INT UNSIGNED NOT NULL,
phid VARCHAR(64) BINARY NOT NULL,
UNIQUE KEY (phid),
slug VARCHAR(512) NOT NULL,
UNIQUE KEY (slug),
depth INT UNSIGNED NOT NULL,
UNIQUE KEY (depth, slug),
contentID INT UNSIGNED NOT NULL
-) ENGINE=InnoDB;
\ No newline at end of file
+) ENGINE=InnoDB;

File Metadata

Mime Type
text/x-diff
Expires
Tue, Jul 1, 10:51 PM (1 d, 7 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
164564
Default Alt Text
(8 KB)

Event Timeline

styx copyright 2020 sirocyl / ellie (kymkdd) / ncommander / styx contributors
Use of other names and brands is not intended to reflect a claim of, or right to, use the name or brand.
styx is an operating system using the Linux kernel and components, and "styx Linux" as a phrase does not reflect the inclusion of the Linux brand or trademark in the styx project.
Linux® is the registered trademark of Linus Torvalds in the U.S. and other countries.
Terms and Conditions (TODO: fix this!)