Yaron Koren has submitted this change and it was merged. ( https://gerrit.wikimedia.org/r/332004 )
Change subject: Add support for Microsoft SQL Server ...................................................................... Add support for Microsoft SQL Server Bug: T155260 Change-Id: If538df3e7af61485547f6abbc7eeeb9f762b4dad --- M Cargo.hooks.php A sql/Cargo.mssql.sql 2 files changed, 21 insertions(+), 0 deletions(-) Approvals: Yaron Koren: Looks good to me, approved jenkins-bot: Verified diff --git a/Cargo.hooks.php b/Cargo.hooks.php index e2053d6..04ecde6 100755 --- a/Cargo.hooks.php +++ b/Cargo.hooks.php @@ -294,6 +294,9 @@ } elseif ( $updater->getDB()->getType() == 'postgres' ) { $updater->addExtensionUpdate( array( 'addTable', 'cargo_tables', __DIR__ . "/sql/Cargo.pg.sql", true ) ); $updater->addExtensionUpdate( array( 'addTable', 'cargo_pages', __DIR__ . "/sql/Cargo.pg.sql", true ) ); + } elseif ( $updater->getDB()->getType() == 'mssql' ) { + $updater->addExtensionUpdate( array( 'addTable', 'cargo_tables', __DIR__ . "/sql/Cargo.mssql.sql", true ) ); + $updater->addExtensionUpdate( array( 'addTable', 'cargo_pages', __DIR__ . "/sql/Cargo.mssql.sql", true ) ); } return true; } diff --git a/sql/Cargo.mssql.sql b/sql/Cargo.mssql.sql new file mode 100644 index 0000000..df29c77 --- /dev/null +++ b/sql/Cargo.mssql.sql @@ -0,0 +1,18 @@ +-- Microsoft SQL Server schema for Cargo extension + +CREATE TABLE /*_*/cargo_tables ( + template_id int NOT NULL, + main_table varchar(200) NOT NULL, + field_tables varchar(max) NOT NULL, + table_schema varchar(max) NOT NULL +) /*$wgDBTableOptions*/; + +CREATE UNIQUE INDEX cargo_tables_template_id ON /*_*/cargo_tables (template_id); +CREATE UNIQUE INDEX cargo_tables_main_table ON /*_*/cargo_tables (main_table); + +CREATE TABLE /*_*/cargo_pages ( + page_id int NOT NULL, + table_name varchar(200) NOT NULL +) /*$wgDBTableOptions*/; + +CREATE INDEX cargo_pages_page_id ON /*_*/cargo_pages (page_id); -- To view, visit https://gerrit.wikimedia.org/r/332004 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: If538df3e7af61485547f6abbc7eeeb9f762b4dad Gerrit-PatchSet: 2 Gerrit-Project: mediawiki/extensions/Cargo Gerrit-Branch: master Gerrit-Owner: Paladox <thomasmulhall...@yahoo.com> Gerrit-Reviewer: Yaron Koren <yaro...@gmail.com> Gerrit-Reviewer: jenkins-bot <> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits