From 6691c59a7ab2993f186f9b3309f440cd60ae3bcb Mon Sep 17 00:00:00 2001 From: Evgeniy Khramtsov Date: Wed, 17 May 2017 19:29:19 +0300 Subject: Clean up database code related to mod_vcard_xupdate --- sql/mssql.sql | 10 ---------- 1 file changed, 10 deletions(-) (limited to 'sql/mssql.sql') 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; -- cgit v1.2.3