Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F73214
D7369.diff
All Users
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Size
3 KB
Referenced Files
None
Subscribers
None
D7369.diff
View Options
diff --git a/resources/sql/patches/20131020.pcustom.sql b/resources/sql/patches/20131020.pcustom.sql
new file mode 100644
--- /dev/null
+++ b/resources/sql/patches/20131020.pcustom.sql
@@ -0,0 +1,29 @@
+CREATE TABLE {$NAMESPACE}_project.project_customfieldstorage (
+ id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+ objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
+ fieldIndex CHAR(12) NOT NULL COLLATE utf8_bin,
+ fieldValue LONGTEXT NOT NULL,
+ UNIQUE KEY (objectPHID, fieldIndex)
+) ENGINE=InnoDB, COLLATE utf8_general_ci;
+
+CREATE TABLE {$NAMESPACE}_project.project_customfieldstringindex (
+ id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+ objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
+ indexKey VARCHAR(12) NOT NULL COLLATE utf8_bin,
+ indexValue LONGTEXT NOT NULL COLLATE utf8_general_ci,
+
+ KEY `key_join` (objectPHID, indexKey, indexValue(64)),
+ KEY `key_find` (indexKey, indexValue(64))
+
+) ENGINE=InnoDB, COLLATE utf8_general_ci;
+
+CREATE TABLE {$NAMESPACE}_project.project_customfieldnumericindex (
+ id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+ objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
+ indexKey VARCHAR(12) NOT NULL COLLATE utf8_bin,
+ indexValue BIGINT NOT NULL,
+
+ KEY `key_join` (objectPHID, indexKey, indexValue),
+ KEY `key_find` (indexKey, indexValue)
+
+) ENGINE=InnoDB, COLLATE utf8_general_ci;
diff --git a/src/applications/project/storage/PhabricatorProjectCustomFieldNumericIndex.php b/src/applications/project/storage/PhabricatorProjectCustomFieldNumericIndex.php
new file mode 100644
--- /dev/null
+++ b/src/applications/project/storage/PhabricatorProjectCustomFieldNumericIndex.php
@@ -0,0 +1,11 @@
+<?php
+
+final class PhabricatorProjectCustomFieldNumericIndex
+ extends PhabricatorCustomFieldNumericIndexStorage {
+
+ public function getApplicationName() {
+ return 'project';
+ }
+
+}
+
diff --git a/src/applications/project/storage/PhabricatorProjectCustomFieldStorage.php b/src/applications/project/storage/PhabricatorProjectCustomFieldStorage.php
new file mode 100644
--- /dev/null
+++ b/src/applications/project/storage/PhabricatorProjectCustomFieldStorage.php
@@ -0,0 +1,11 @@
+<?php
+
+final class PhabricatorProjectCustomFieldStorage
+ extends PhabricatorCustomFieldStorage {
+
+ public function getApplicationName() {
+ return 'project';
+ }
+
+}
+
diff --git a/src/applications/project/storage/PhabricatorProjectCustomFieldStringIndex.php b/src/applications/project/storage/PhabricatorProjectCustomFieldStringIndex.php
new file mode 100644
--- /dev/null
+++ b/src/applications/project/storage/PhabricatorProjectCustomFieldStringIndex.php
@@ -0,0 +1,11 @@
+<?php
+
+final class PhabricatorProjectCustomFieldStringIndex
+ extends PhabricatorCustomFieldStringIndexStorage {
+
+ public function getApplicationName() {
+ return 'project';
+ }
+
+}
+
diff --git a/src/infrastructure/storage/patch/PhabricatorBuiltinPatchList.php b/src/infrastructure/storage/patch/PhabricatorBuiltinPatchList.php
--- a/src/infrastructure/storage/patch/PhabricatorBuiltinPatchList.php
+++ b/src/infrastructure/storage/patch/PhabricatorBuiltinPatchList.php
@@ -1684,6 +1684,10 @@
'type' => 'php',
'name' => $this->getPatchPath('20130926.dinline.php'),
),
+ '20131020.pcustom.sql' => array(
+ 'type' => 'sql',
+ 'name' => $this->getPatchPath('20131020.pcustom.sql'),
+ ),
);
}
}
File Metadata
Details
Attached
Mime Type
text/x-diff
Storage Engine
amazon-s3
Storage Format
Raw Data
Storage Handle
phabricator/ph/je/7tbkbvsdqnmh37og
Default Alt Text
D7369.diff (3 KB)
Attached To
Mode
D7369: Add custom field storage to Projects
Attached
Detach File
Event Timeline
Log In to Comment