Clean up database code related to mod_vcard_xupdate

4 files changed, 0 insertions, 28 deletions

diff --git a/sql/lite.sql b/sql/lite.sql
index 1d057407f..1cc0c4dc5 100644
--- a/sql/lite.sql
+++ b/sql/lite.sql
@@ -116,12 +116,6 @@ CREATE TABLE vcard (
     created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
 
-CREATE TABLE vcard_xupdate (
-    username text PRIMARY KEY,
-    hash text NOT NULL,
-    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
-);
-
 CREATE TABLE vcard_search (
     username text NOT NULL,
     lusername text PRIMARY KEY,
diff --git a/sql/mssql.sql b/sql/mssql.sql
index 72b490ecc..607acae8f 100644
--- a/sql/mssql.sql
+++ b/sql/mssql.sql
@@ -470,16 +470,6 @@ WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW
 CREATE INDEX [vcard_search_lorgunit] ON [vcard_search] (lorgunit)

 WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON);

 

-CREATE TABLE [dbo].[vcard_xupdate] (

-        [username] [varchar] (250) NOT NULL,

-        [hash] [text] NOT NULL,

-        [created_at] [datetime] NOT NULL DEFAULT GETDATE(),

- CONSTRAINT [vcard_xupdate_PRIMARY] PRIMARY KEY CLUSTERED 

-(

-        [username] ASC

-)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

-) TEXTIMAGE_ON [PRIMARY];

-

 ALTER TABLE [dbo].[pubsub_item]  WITH CHECK ADD  CONSTRAINT [pubsub_item_ibfk_1] FOREIGN KEY([nodeid])

 REFERENCES [dbo].[pubsub_node] ([nodeid])

 ON DELETE CASCADE;

diff --git a/sql/mysql.sql b/sql/mysql.sql
index c591cb761..3fddea510 100644
--- a/sql/mysql.sql
+++ b/sql/mysql.sql
@@ -121,12 +121,6 @@ CREATE TABLE vcard (
     created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
 ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
 
-CREATE TABLE vcard_xupdate (
-    username varchar(191) PRIMARY KEY,
-    hash text NOT NULL,
-    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
-) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-
 CREATE TABLE vcard_search (
     username varchar(191) NOT NULL,
     lusername varchar(191) PRIMARY KEY,
diff --git a/sql/pg.sql b/sql/pg.sql
index 539c1263a..f761e68da 100644
--- a/sql/pg.sql
+++ b/sql/pg.sql
@@ -120,12 +120,6 @@ CREATE TABLE vcard (
     created_at TIMESTAMP NOT NULL DEFAULT now()
 );
 
-CREATE TABLE vcard_xupdate (
-    username text PRIMARY KEY,
-    hash text NOT NULL,
-    created_at TIMESTAMP NOT NULL DEFAULT now()
-);
-
 CREATE TABLE vcard_search (
     username text NOT NULL,
     lusername text PRIMARY KEY,