1 files changed, 12 insertions, 36 deletions
diff --git a/vendor/sabre/dav/tests/Sabre/CardDAV/Backend/PDOMySQLTest.php b/vendor/sabre/dav/tests/Sabre/CardDAV/Backend/PDOMySQLTest.php
index b2f871f6e..38cb655d0 100644
--- a/vendor/sabre/dav/tests/Sabre/CardDAV/Backend/PDOMySQLTest.php
+++ b/vendor/sabre/dav/tests/Sabre/CardDAV/Backend/PDOMySQLTest.php
@@ -16,42 +16,18 @@ class PDOMySQLTest extends AbstractPDOTest {
         $pdo = \Sabre\TestUtil::getMySQLDB();
         if (!$pdo) $this->markTestSkipped('Could not connect to MySQL database');
 
-        $pdo->query("DROP TABLE IF EXISTS addressbooks");
-        $pdo->query("DROP TABLE IF EXISTS cards");
-        $pdo->query("
-CREATE TABLE addressbooks (
-    id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
-    principaluri VARCHAR(255),
-    displayname VARCHAR(255),
-    uri VARCHAR(100),
-    description TEXT,
-    ctag INT(11) UNSIGNED NOT NULL DEFAULT '1'
-);
-");
-
-        $pdo->query("
-INSERT INTO addressbooks
-    (principaluri, displayname, uri, description, ctag)
-VALUES
-    ('principals/user1', 'book1', 'book1', 'addressbook 1', 1);
-");
-
-        $pdo->query("
-CREATE TABLE cards (
-    id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
-    addressbookid INT(11) UNSIGNED NOT NULL,
-    carddata TEXT,
-    uri VARCHAR(100),
-    lastmodified INT(11) UNSIGNED
-);
-");
-
-        $pdo->query("
-INSERT INTO cards
-    (addressbookid, carddata, uri, lastmodified)
-VALUES
-    (1, 'card1', 'card1', 0);
-");
+        $pdo->query("DROP TABLE IF EXISTS addressbooks, cards, addressbookchanges");
+
+        $queries = explode(
+            ';',
+            file_get_contents(__DIR__ . '/../../../../examples/sql/mysql.addressbook.sql')
+        );
+
+        foreach($queries as $query) {
+            $query = trim($query," \r\n\t");
+            if ($query)
+                $pdo->exec($query);
+        }
         return $pdo;
 
     }