diff options
author | Aleksander Machniak <alec@alec.pl> | 2022-09-11 12:01:03 +0300 |
---|---|---|
committer | Aleksander Machniak <alec@alec.pl> | 2022-09-11 12:01:03 +0300 |
commit | 019801a430e27c95d03cbb24fc233ec22e692500 (patch) | |
tree | cbb783c8abbdec870b1f2dd49c1dbcde2fc9f99a /SQL | |
parent | 2847154cd0b11d4dead83507b8b272d8509d9aaa (diff) |
Removed support for MS SQL Server and Oracle (#7854)
Diffstat (limited to 'SQL')
45 files changed, 0 insertions, 1400 deletions
diff --git a/SQL/mssql.initial.sql b/SQL/mssql.initial.sql deleted file mode 100644 index b49a1eae7..000000000 --- a/SQL/mssql.initial.sql +++ /dev/null @@ -1,491 +0,0 @@ -CREATE TABLE [dbo].[cache] (
- [user_id] [int] NOT NULL ,
- [cache_key] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL ,
- [expires] [datetime] NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[cache_shared] (
- [cache_key] [varchar] (255) COLLATE Latin1_General_CS_AS NOT NULL ,
- [expires] [datetime] NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[cache_index] (
- [user_id] [int] NOT NULL ,
- [mailbox] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL ,
- [expires] [datetime] NULL ,
- [valid] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[cache_thread] (
- [user_id] [int] NOT NULL ,
- [mailbox] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL ,
- [expires] [datetime] NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[cache_messages] (
- [user_id] [int] NOT NULL ,
- [mailbox] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL ,
- [uid] [int] NOT NULL ,
- [expires] [datetime] NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL ,
- [flags] [int] NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[collected_addresses] (
- [address_id] [int] IDENTITY (1, 1) NOT NULL ,
- [user_id] [int] NOT NULL ,
- [changed] [datetime] NOT NULL ,
- [name] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL ,
- [email] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL ,
- [type] [int] NOT NULL
-) ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[contacts] (
- [contact_id] [int] IDENTITY (1, 1) NOT NULL ,
- [user_id] [int] NOT NULL ,
- [changed] [datetime] NOT NULL ,
- [del] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL ,
- [name] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [email] [varchar] (8000) COLLATE Latin1_General_CI_AI NOT NULL ,
- [firstname] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [surname] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [vcard] [text] COLLATE Latin1_General_CI_AI NULL ,
- [words] [text] COLLATE Latin1_General_CI_AI NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[contactgroups] (
- [contactgroup_id] [int] IDENTITY (1, 1) NOT NULL ,
- [user_id] [int] NOT NULL ,
- [changed] [datetime] NOT NULL ,
- [del] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL ,
- [name] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[contactgroupmembers] (
- [contactgroup_id] [int] NOT NULL ,
- [contact_id] [int] NOT NULL ,
- [created] [datetime] NOT NULL
-) ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[identities] (
- [identity_id] [int] IDENTITY (1, 1) NOT NULL ,
- [user_id] [int] NOT NULL ,
- [changed] [datetime] NOT NULL ,
- [del] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL ,
- [standard] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL ,
- [name] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [organization] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [email] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [reply-to] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [bcc] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [signature] [text] COLLATE Latin1_General_CI_AI NULL,
- [html_signature] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[responses] (
- [response_id] [int] IDENTITY (1, 1) NOT NULL ,
- [user_id] [int] NOT NULL ,
- [changed] [datetime] NOT NULL ,
- [del] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL ,
- [name] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL,
- [is_html] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[session] (
- [sess_id] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [changed] [datetime] NULL ,
- [ip] [varchar] (40) COLLATE Latin1_General_CI_AI NOT NULL ,
- [vars] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[users] (
- [user_id] [int] IDENTITY (1, 1) NOT NULL ,
- [username] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL ,
- [mail_host] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [created] [datetime] NOT NULL ,
- [last_login] [datetime] NULL ,
- [failed_login] [datetime] NULL ,
- [failed_login_counter] [int] NULL ,
- [language] [varchar] (16) COLLATE Latin1_General_CI_AI NULL ,
- [preferences] [text] COLLATE Latin1_General_CI_AI NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[dictionary] (
- [user_id] [int] ,
- [language] [varchar] (16) COLLATE Latin1_General_CI_AI NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[searches] (
- [search_id] [int] IDENTITY (1, 1) NOT NULL ,
- [user_id] [int] NOT NULL ,
- [type] [tinyint] NOT NULL ,
- [name] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[filestore] (
- [file_id] [int] IDENTITY (1, 1) NOT NULL ,
- [user_id] [int] NOT NULL ,
- [context] [varchar] (32) COLLATE Latin1_General_CI_AI NOT NULL ,
- [filename] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [mtime] [int] NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NULL ,
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[system] (
- [name] [varchar] (64) COLLATE Latin1_General_CI_AI NOT NULL ,
- [value] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache] WITH NOCHECK ADD
- PRIMARY KEY CLUSTERED
- (
- [user_id],[cache_key]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache_shared] WITH NOCHECK ADD
- PRIMARY KEY CLUSTERED
- (
- [cache_key]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache_index] WITH NOCHECK ADD
- PRIMARY KEY CLUSTERED
- (
- [user_id],[mailbox]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache_thread] WITH NOCHECK ADD
- PRIMARY KEY CLUSTERED
- (
- [user_id],[mailbox]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache_messages] WITH NOCHECK ADD
- PRIMARY KEY CLUSTERED
- (
- [user_id],[mailbox],[uid]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[collected_addresses] WITH NOCHECK ADD
- CONSTRAINT [PK_collected_addresses_address_id] PRIMARY KEY CLUSTERED
- (
- [address_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[contacts] WITH NOCHECK ADD
- CONSTRAINT [PK_contacts_contact_id] PRIMARY KEY CLUSTERED
- (
- [contact_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[contactgroups] WITH NOCHECK ADD
- CONSTRAINT [PK_contactgroups_contactgroup_id] PRIMARY KEY CLUSTERED
- (
- [contactgroup_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[contactgroupmembers] WITH NOCHECK ADD
- CONSTRAINT [PK_contactgroupmembers_id] PRIMARY KEY CLUSTERED
- (
- [contactgroup_id], [contact_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[identities] WITH NOCHECK ADD
- PRIMARY KEY CLUSTERED
- (
- [identity_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[responses] WITH NOCHECK ADD
- PRIMARY KEY CLUSTERED
- (
- [response_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[session] WITH NOCHECK ADD
- CONSTRAINT [PK_session_sess_id] PRIMARY KEY CLUSTERED
- (
- [sess_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[users] WITH NOCHECK ADD
- CONSTRAINT [PK_users_user_id] PRIMARY KEY CLUSTERED
- (
- [user_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[searches] WITH NOCHECK ADD
- CONSTRAINT [PK_searches_search_id] PRIMARY KEY CLUSTERED
- (
- [search_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[filestore] WITH NOCHECK ADD
- CONSTRAINT [PK_filestore_file_id] PRIMARY KEY CLUSTERED
- (
- [file_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[system] WITH NOCHECK ADD
- CONSTRAINT [PK_system_name] PRIMARY KEY CLUSTERED
- (
- [name]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache] ADD
- CONSTRAINT [DF_cache_user_id] DEFAULT ('0') FOR [user_id],
- CONSTRAINT [DF_cache_cache_key] DEFAULT ('') FOR [cache_key]
-GO
-
-ALTER TABLE [dbo].[cache_index] ADD
- CONSTRAINT [DF_cache_index_valid] DEFAULT ('0') FOR [valid]
-GO
-
-ALTER TABLE [dbo].[cache_messages] ADD
- CONSTRAINT [DF_cache_messages_flags] DEFAULT (0) FOR [flags]
-GO
-
-CREATE INDEX [IX_cache_shared_cache_key] ON [dbo].[cache_shared]([cache_key]) ON [PRIMARY]
-GO
-
-CREATE INDEX [IX_cache_index_user_id] ON [dbo].[cache_index]([user_id]) ON [PRIMARY]
-GO
-
-CREATE INDEX [IX_cache_thread_user_id] ON [dbo].[cache_thread]([user_id]) ON [PRIMARY]
-GO
-
-CREATE INDEX [IX_cache_messages_user_id] ON [dbo].[cache_messages]([user_id]) ON [PRIMARY]
-GO
-
-CREATE INDEX [IX_cache_expires] ON [dbo].[cache]([expires]) ON [PRIMARY]
-GO
-
-CREATE INDEX [IX_cache_shared_expires] ON [dbo].[cache_shared]([expires]) ON [PRIMARY]
-GO
-
-CREATE INDEX [IX_cache_index_expires] ON [dbo].[cache_index]([expires]) ON [PRIMARY]
-GO
-
-CREATE INDEX [IX_cache_thread_expires] ON [dbo].[cache_thread]([expires]) ON [PRIMARY]
-GO
-
-CREATE INDEX [IX_cache_messages_expires] ON [dbo].[cache_messages]([expires]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[collected_addresses] ADD
- CONSTRAINT [DF_collected_addresses_user_id] DEFAULT (0) FOR [user_id],
- CONSTRAINT [DF_collected_addresses_changed] DEFAULT (getdate()) FOR [changed],
- CONSTRAINT [DF_collected_addresses_name] DEFAULT ('') FOR [name]
-GO
-
-CREATE UNIQUE INDEX [IX_collected_addresses_user_id] ON [dbo].[collected_addresses]([user_id],[type],[email]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[contacts] ADD
- CONSTRAINT [DF_contacts_user_id] DEFAULT (0) FOR [user_id],
- CONSTRAINT [DF_contacts_changed] DEFAULT (getdate()) FOR [changed],
- CONSTRAINT [DF_contacts_del] DEFAULT ('0') FOR [del],
- CONSTRAINT [DF_contacts_name] DEFAULT ('') FOR [name],
- CONSTRAINT [DF_contacts_email] DEFAULT ('') FOR [email],
- CONSTRAINT [DF_contacts_firstname] DEFAULT ('') FOR [firstname],
- CONSTRAINT [DF_contacts_surname] DEFAULT ('') FOR [surname],
- CONSTRAINT [CK_contacts_del] CHECK ([del] = '1' or [del] = '0')
-GO
-
-CREATE INDEX [IX_contacts_user_id] ON [dbo].[contacts]([user_id]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[contactgroups] ADD
- CONSTRAINT [DF_contactgroups_user_id] DEFAULT (0) FOR [user_id],
- CONSTRAINT [DF_contactgroups_changed] DEFAULT (getdate()) FOR [changed],
- CONSTRAINT [DF_contactgroups_del] DEFAULT ('0') FOR [del],
- CONSTRAINT [DF_contactgroups_name] DEFAULT ('') FOR [name],
- CONSTRAINT [CK_contactgroups_del] CHECK ([del] = '1' or [del] = '0')
-GO
-
-CREATE INDEX [IX_contactgroups_user_id] ON [dbo].[contactgroups]([user_id]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[contactgroupmembers] ADD
- CONSTRAINT [DF_contactgroupmembers_contactgroup_id] DEFAULT (0) FOR [contactgroup_id],
- CONSTRAINT [DF_contactgroupmembers_contact_id] DEFAULT (0) FOR [contact_id],
- CONSTRAINT [DF_contactgroupmembers_created] DEFAULT (getdate()) FOR [created]
-GO
-
-CREATE INDEX [IX_contactgroupmembers_contact_id] ON [dbo].[contactgroupmembers]([contact_id]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[identities] ADD
- CONSTRAINT [DF_identities_user] DEFAULT ('0') FOR [user_id],
- CONSTRAINT [DF_identities_del] DEFAULT ('0') FOR [del],
- CONSTRAINT [DF_identities_standard] DEFAULT ('0') FOR [standard],
- CONSTRAINT [DF_identities_name] DEFAULT ('') FOR [name],
- CONSTRAINT [DF_identities_organization] DEFAULT ('') FOR [organization],
- CONSTRAINT [DF_identities_email] DEFAULT ('') FOR [email],
- CONSTRAINT [DF_identities_reply] DEFAULT ('') FOR [reply-to],
- CONSTRAINT [DF_identities_bcc] DEFAULT ('') FOR [bcc],
- CONSTRAINT [DF_identities_html_signature] DEFAULT ('0') FOR [html_signature],
- CHECK ([standard] = '1' or [standard] = '0'),
- CHECK ([del] = '1' or [del] = '0')
-GO
-
-CREATE INDEX [IX_identities_user_id] ON [dbo].[identities]([user_id]) ON [PRIMARY]
-GO
-CREATE INDEX [IX_identities_email] ON [dbo].[identities]([email],[del]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[responses] ADD
- CONSTRAINT [DF_responses_user] DEFAULT ('0') FOR [user_id],
- CONSTRAINT [DF_responses_del] DEFAULT ('0') FOR [del],
- CONSTRAINT [DF_responses_is_html] DEFAULT ('0') FOR [is_html],
- CHECK ([del] = '1' or [del] = '0'),
- CHECK ([is_html] = '1' or [is_html] = '0')
-GO
-
-CREATE INDEX [IX_responses_user_id] ON [dbo].[responses]([user_id]) ON [PRIMARY]
-GO
-ALTER TABLE [dbo].[session] ADD
- CONSTRAINT [DF_session_sess_id] DEFAULT ('') FOR [sess_id],
- CONSTRAINT [DF_session_ip] DEFAULT ('') FOR [ip]
-GO
-
-CREATE INDEX [IX_session_changed] ON [dbo].[session]([changed]) ON [PRIMARY]
-GO
-
-CREATE INDEX [IX_filestore_user_id] ON [dbo].[filestore]([user_id]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[users] ADD
- CONSTRAINT [DF_users_username] DEFAULT ('') FOR [username],
- CONSTRAINT [DF_users_mail_host] DEFAULT ('') FOR [mail_host],
- CONSTRAINT [DF_users_created] DEFAULT (getdate()) FOR [created]
-GO
-
-CREATE UNIQUE INDEX [IX_users_username] ON [dbo].[users]([username],[mail_host]) ON [PRIMARY]
-GO
-
-CREATE UNIQUE INDEX [IX_dictionary_user_language] ON [dbo].[dictionary]([user_id],[language]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[searches] ADD
- CONSTRAINT [DF_searches_user] DEFAULT (0) FOR [user_id],
- CONSTRAINT [DF_searches_type] DEFAULT (0) FOR [type]
-GO
-
-CREATE UNIQUE INDEX [IX_searches_user_type_name] ON [dbo].[searches]([user_id],[type],[name]) ON [PRIMARY]
-GO
-
-CREATE UNIQUE INDEX [IX_filestore_user_id_context_filename] ON [dbo].[filestore]([user_id],[context],[filename]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[identities] ADD CONSTRAINT [FK_identities_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[responses] ADD CONSTRAINT [FK_responses_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[collected_addresses] ADD CONSTRAINT [FK_collected_addresses_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[contacts] ADD CONSTRAINT [FK_contacts_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[contactgroups] ADD CONSTRAINT [FK_contactgroups_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[cache] ADD CONSTRAINT [FK_cache_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[cache_index] ADD CONSTRAINT [FK_cache_index_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[cache_thread] ADD CONSTRAINT [FK_cache_thread_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[cache_messages] ADD CONSTRAINT [FK_cache_messages_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[contactgroupmembers] ADD CONSTRAINT [FK_contactgroupmembers_contactgroup_id]
- FOREIGN KEY ([contactgroup_id]) REFERENCES [dbo].[contactgroups] ([contactgroup_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[searches] ADD CONSTRAINT [FK_searches_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[filestore] ADD CONSTRAINT [FK_filestore_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
--- Use trigger instead of foreign key (#1487112)
--- "Introducing FOREIGN KEY constraint ... may cause cycles or multiple cascade paths."
-CREATE TRIGGER [contact_delete_member] ON [dbo].[contacts]
- AFTER DELETE AS
- DELETE FROM [dbo].[contactgroupmembers]
- WHERE [contact_id] IN (SELECT [contact_id] FROM deleted)
-GO
-
-INSERT INTO [dbo].[system] ([name], [value]) VALUES ('roundcube-version', '2022081200')
-GO
-
\ No newline at end of file diff --git a/SQL/mssql/2009103100.sql b/SQL/mssql/2009103100.sql deleted file mode 100644 index 646fe38af..000000000 --- a/SQL/mssql/2009103100.sql +++ /dev/null @@ -1,87 +0,0 @@ --- Updates from version 0.3.1
-
-ALTER TABLE [dbo].[messages] ADD CONSTRAINT [FK_messages_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[cache] ADD CONSTRAINT [FK_cache_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[contacts] ADD CONSTRAINT [FK_contacts_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[identities] ADD CONSTRAINT [FK_identities_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[identities] ADD [changed] [datetime] NULL
-GO
-
-CREATE TABLE [dbo].[contactgroups] (
- [contactgroup_id] [int] IDENTITY (1, 1) NOT NULL ,
- [user_id] [int] NOT NULL ,
- [changed] [datetime] NOT NULL ,
- [del] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL ,
- [name] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[contactgroupmembers] (
- [contactgroup_id] [int] NOT NULL ,
- [contact_id] [int] NOT NULL ,
- [created] [datetime] NOT NULL
-) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[contactgroups] WITH NOCHECK ADD
- CONSTRAINT [PK_contactgroups_contactgroup_id] PRIMARY KEY CLUSTERED
- (
- [contactgroup_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[contactgroupmembers] WITH NOCHECK ADD
- CONSTRAINT [PK_contactgroupmembers_id] PRIMARY KEY CLUSTERED
- (
- [contactgroup_id], [contact_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[contactgroups] ADD
- CONSTRAINT [DF_contactgroups_user_id] DEFAULT (0) FOR [user_id],
- CONSTRAINT [DF_contactgroups_changed] DEFAULT (getdate()) FOR [changed],
- CONSTRAINT [DF_contactgroups_del] DEFAULT ('0') FOR [del],
- CONSTRAINT [DF_contactgroups_name] DEFAULT ('') FOR [name],
- CONSTRAINT [CK_contactgroups_del] CHECK ([del] = '1' or [del] = '0')
-GO
-
-CREATE INDEX [IX_contactgroups_user_id] ON [dbo].[contacts]([user_id]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[contactgroupmembers] ADD
- CONSTRAINT [DF_contactgroupmembers_contactgroup_id] DEFAULT (0) FOR [contactgroup_id],
- CONSTRAINT [DF_contactgroupmembers_contact_id] DEFAULT (0) FOR [contact_id],
- CONSTRAINT [DF_contactgroupmembers_created] DEFAULT (getdate()) FOR [created]
-GO
-
-ALTER TABLE [dbo].[contactgroupmembers] ADD CONSTRAINT [FK_contactgroupmembers_contactgroup_id]
- FOREIGN KEY ([contactgroup_id]) REFERENCES [dbo].[contactgroups] ([contactgroup_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-CREATE TRIGGER [contact_delete_member] ON [dbo].[contacts]
- AFTER DELETE AS
- DELETE FROM [dbo].[contactgroupmembers]
- WHERE [contact_id] IN (SELECT [contact_id] FROM deleted)
-GO
-
-ALTER TABLE [dbo].[contactgroups] ADD CONSTRAINT [FK_contactgroups_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
diff --git a/SQL/mssql/2010100600.sql b/SQL/mssql/2010100600.sql deleted file mode 100644 index fb045e303..000000000 --- a/SQL/mssql/2010100600.sql +++ /dev/null @@ -1,9 +0,0 @@ --- Updates from version 0.4.2
-
-DROP INDEX [IX_users_username]
-GO
-CREATE UNIQUE INDEX [IX_users_username] ON [dbo].[users]([username],[mail_host]) ON [PRIMARY]
-GO
-ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL
-GO
-
\ No newline at end of file diff --git a/SQL/mssql/2011011200.sql b/SQL/mssql/2011011200.sql deleted file mode 100644 index 8715455df..000000000 --- a/SQL/mssql/2011011200.sql +++ /dev/null @@ -1,10 +0,0 @@ --- Updates from version 0.5.x
-
-ALTER TABLE [dbo].[contacts] ADD [words] [text] COLLATE Latin1_General_CI_AI NULL
-GO
-CREATE INDEX [IX_contactgroupmembers_contact_id] ON [dbo].[contactgroupmembers]([contact_id]) ON [PRIMARY]
-GO
-DELETE FROM [dbo].[messages]
-GO
-DELETE FROM [dbo].[cache]
-GO
diff --git a/SQL/mssql/2011092800.sql b/SQL/mssql/2011092800.sql deleted file mode 100644 index 00f79bbc0..000000000 --- a/SQL/mssql/2011092800.sql +++ /dev/null @@ -1,127 +0,0 @@ --- Updates from version 0.6
-
-CREATE TABLE [dbo].[dictionary] (
- [user_id] [int] ,
- [language] [varchar] (5) COLLATE Latin1_General_CI_AI NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-CREATE UNIQUE INDEX [IX_dictionary_user_language] ON [dbo].[dictionary]([user_id],[language]) ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[searches] (
- [search_id] [int] IDENTITY (1, 1) NOT NULL ,
- [user_id] [int] NOT NULL ,
- [type] [tinyint] NOT NULL ,
- [name] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[searches] WITH NOCHECK ADD
- CONSTRAINT [PK_searches_search_id] PRIMARY KEY CLUSTERED
- (
- [search_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[searches] ADD
- CONSTRAINT [DF_searches_user] DEFAULT (0) FOR [user_id],
- CONSTRAINT [DF_searches_type] DEFAULT (0) FOR [type],
-GO
-
-CREATE UNIQUE INDEX [IX_searches_user_type_name] ON [dbo].[searches]([user_id],[type],[name]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[searches] ADD CONSTRAINT [FK_searches_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-DROP TABLE [dbo].[messages]
-GO
-CREATE TABLE [dbo].[cache_index] (
- [user_id] [int] NOT NULL ,
- [mailbox] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [changed] [datetime] NOT NULL ,
- [valid] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[cache_thread] (
- [user_id] [int] NOT NULL ,
- [mailbox] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [changed] [datetime] NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE TABLE [dbo].[cache_messages] (
- [user_id] [int] NOT NULL ,
- [mailbox] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [uid] [int] NOT NULL ,
- [changed] [datetime] NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL ,
- [flags] [int] NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache_index] WITH NOCHECK ADD
- PRIMARY KEY CLUSTERED
- (
- [user_id],[mailbox]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache_thread] WITH NOCHECK ADD
- PRIMARY KEY CLUSTERED
- (
- [user_id],[mailbox]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache_messages] WITH NOCHECK ADD
- PRIMARY KEY CLUSTERED
- (
- [user_id],[mailbox],[uid]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache_index] ADD
- CONSTRAINT [DF_cache_index_changed] DEFAULT (getdate()) FOR [changed],
- CONSTRAINT [DF_cache_index_valid] DEFAULT ('0') FOR [valid]
-GO
-
-CREATE INDEX [IX_cache_index_user_id] ON [dbo].[cache_index]([user_id]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache_thread] ADD
- CONSTRAINT [DF_cache_thread_changed] DEFAULT (getdate()) FOR [changed]
-GO
-
-CREATE INDEX [IX_cache_thread_user_id] ON [dbo].[cache_thread]([user_id]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache_messages] ADD
- CONSTRAINT [DF_cache_messages_changed] DEFAULT (getdate()) FOR [changed],
- CONSTRAINT [DF_cache_messages_flags] DEFAULT (0) FOR [flags]
-GO
-
-CREATE INDEX [IX_cache_messages_user_id] ON [dbo].[cache_messages]([user_id]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache_index] ADD CONSTRAINT [FK_cache_index_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[cache_thread] ADD CONSTRAINT [FK_cache_thread_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
-ALTER TABLE [dbo].[cache_messages] ADD CONSTRAINT [FK_cache_messages_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
diff --git a/SQL/mssql/2011111600.sql b/SQL/mssql/2011111600.sql deleted file mode 100644 index 387877604..000000000 --- a/SQL/mssql/2011111600.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Updates from version 0.7-beta
-
-ALTER TABLE [dbo].[session] ALTER COLUMN [sess_id] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL
-GO
diff --git a/SQL/mssql/2011121400.sql b/SQL/mssql/2011121400.sql deleted file mode 100644 index fde63ea79..000000000 --- a/SQL/mssql/2011121400.sql +++ /dev/null @@ -1,9 +0,0 @@ --- Updates from version 0.7
-
-ALTER TABLE [dbo].[contacts] DROP CONSTRAINT [DF_contacts_email]
-GO
-ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [text] COLLATE Latin1_General_CI_AI NOT NULL
-GO
-ALTER TABLE [dbo].[contacts] ADD CONSTRAINT [DF_contacts_email] DEFAULT ('') FOR [email]
-GO
-
\ No newline at end of file diff --git a/SQL/mssql/2012051800.sql b/SQL/mssql/2012051800.sql deleted file mode 100644 index 8dcf7bfc0..000000000 --- a/SQL/mssql/2012051800.sql +++ /dev/null @@ -1,18 +0,0 @@ --- Updates from version 0.8-rc
-
-ALTER TABLE [dbo].[contacts] DROP CONSTRAINT [DF_contacts_email]
-GO
-ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [varchar] (8000) COLLATE Latin1_General_CI_AI NOT NULL
-GO
-ALTER TABLE [dbo].[contacts] ADD CONSTRAINT [DF_contacts_email] DEFAULT ('') FOR [email]
-GO
-
--- Updates from version 0.8
-
-ALTER TABLE [dbo].[cache] DROP COLUMN [cache_id]
-GO
-ALTER TABLE [dbo].[users] DROP COLUMN [alias]
-GO
-CREATE INDEX [IX_identities_email] ON [dbo].[identities]([email],[del]) ON [PRIMARY]
-GO
-
\ No newline at end of file diff --git a/SQL/mssql/2012080700.sql b/SQL/mssql/2012080700.sql deleted file mode 100644 index 33e6133b3..000000000 --- a/SQL/mssql/2012080700.sql +++ /dev/null @@ -1,8 +0,0 @@ --- Updates from version 0.8
-
-ALTER TABLE [dbo].[cache] DROP COLUMN [cache_id]
-GO
-ALTER TABLE [dbo].[users] DROP COLUMN [alias]
-GO
-CREATE INDEX [IX_identities_email] ON [dbo].[identities]([email],[del]) ON [PRIMARY]
-GO
diff --git a/SQL/mssql/2013011000.sql b/SQL/mssql/2013011000.sql deleted file mode 100644 index 2eb51e6b5..000000000 --- a/SQL/mssql/2013011000.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Upgrades from 0.9-beta - -CREATE TABLE [dbo].[system] (
- [name] [varchar] (64) COLLATE Latin1_General_CI_AI NOT NULL ,
- [value] [text] COLLATE Latin1_General_CI_AI
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[system] WITH NOCHECK ADD
- CONSTRAINT [PK_system_name] PRIMARY KEY CLUSTERED
- (
- [name]
- ) ON [PRIMARY]
-GO
diff --git a/SQL/mssql/2013042700.sql b/SQL/mssql/2013042700.sql deleted file mode 100644 index fe6741a02..000000000 --- a/SQL/mssql/2013042700.sql +++ /dev/null @@ -1 +0,0 @@ --- empty
\ No newline at end of file diff --git a/SQL/mssql/2013052500.sql b/SQL/mssql/2013052500.sql deleted file mode 100644 index 6a7e31d46..000000000 --- a/SQL/mssql/2013052500.sql +++ /dev/null @@ -1,17 +0,0 @@ -CREATE TABLE [dbo].[cache_shared] (
- [cache_key] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL ,
- [created] [datetime] NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[cache_shared] ADD
- CONSTRAINT [DF_cache_shared_created] DEFAULT (getdate()) FOR [created]
-GO
-
-CREATE INDEX [IX_cache_shared_cache_key] ON [dbo].[cache_shared]([cache_key]) ON [PRIMARY]
-GO
-
-CREATE INDEX [IX_cache_shared_created] ON [dbo].[cache_shared]([created]) ON [PRIMARY]
-GO
-
diff --git a/SQL/mssql/2013061000.sql b/SQL/mssql/2013061000.sql deleted file mode 100644 index 5e8b791f1..000000000 --- a/SQL/mssql/2013061000.sql +++ /dev/null @@ -1,44 +0,0 @@ -ALTER TABLE [dbo].[cache] ADD [expires] [datetime] NULL
-GO
-ALTER TABLE [dbo].[cache_shared] ADD [expires] [datetime] NULL
-GO
-ALTER TABLE [dbo].[cache_index] ADD [expires] [datetime] NULL
-GO
-ALTER TABLE [dbo].[cache_thread] ADD [expires] [datetime] NULL
-GO
-ALTER TABLE [dbo].[cache_messages] ADD [expires] [datetime] NULL
-GO
-
-UPDATE [dbo].[cache] SET [expires] = DATEADD(second, 604800, [created])
-GO
-UPDATE [dbo].[cache_shared] SET [expires] = DATEADD(second, 604800, [created])
-GO
-UPDATE [dbo].[cache_index] SET [expires] = DATEADD(second, 604800, [changed])
-GO
-UPDATE [dbo].[cache_thread] SET [expires] = DATEADD(second, 604800, [changed])
-GO
-UPDATE [dbo].[cache_messages] SET [expires] = DATEADD(second, 604800, [changed])
-GO
-
-DROP INDEX [IX_cache_created]
-GO
-DROP INDEX [IX_cache_shared_created]
-GO
-ALTER TABLE [dbo].[cache_index] DROP COLUMN [changed]
-GO
-ALTER TABLE [dbo].[cache_thread] DROP COLUMN [changed]
-GO
-ALTER TABLE [dbo].[cache_messages] DROP COLUMN [changed]
-GO
-
-CREATE INDEX [IX_cache_expires] ON [dbo].[cache]([expires]) ON [PRIMARY]
-GO
-CREATE INDEX [IX_cache_shared_expires] ON [dbo].[cache_shared]([expires]) ON [PRIMARY]
-GO
-CREATE INDEX [IX_cache_index_expires] ON [dbo].[cache_index]([expires]) ON [PRIMARY]
-GO
-CREATE INDEX [IX_cache_thread_expires] ON [dbo].[cache_thread]([expires]) ON [PRIMARY]
-GO
-CREATE INDEX [IX_cache_messages_expires] ON [dbo].[cache_messages]([expires]) ON [PRIMARY]
-GO
-
\ No newline at end of file diff --git a/SQL/mssql/2014042900.sql b/SQL/mssql/2014042900.sql deleted file mode 100644 index fe6741a02..000000000 --- a/SQL/mssql/2014042900.sql +++ /dev/null @@ -1 +0,0 @@ --- empty
\ No newline at end of file diff --git a/SQL/mssql/2015030800.sql b/SQL/mssql/2015030800.sql deleted file mode 100644 index fe6741a02..000000000 --- a/SQL/mssql/2015030800.sql +++ /dev/null @@ -1 +0,0 @@ --- empty
\ No newline at end of file diff --git a/SQL/mssql/2015111100.sql b/SQL/mssql/2015111100.sql deleted file mode 100644 index 11c9da3c3..000000000 --- a/SQL/mssql/2015111100.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE [dbo].[users] ADD [failed_login] [datetime] NULL
-GO
-ALTER TABLE [dbo].[users] ADD [failed_login_counter] [int] NULL
-GO
diff --git a/SQL/mssql/2016081200.sql b/SQL/mssql/2016081200.sql deleted file mode 100644 index 8a089443e..000000000 --- a/SQL/mssql/2016081200.sql +++ /dev/null @@ -1,5 +0,0 @@ -ALTER TABLE [dbo].[session] DROP CONSTRAINT [DF_session_created]
-GO
-
-ALTER TABLE [dbo].[session] DROP COLUMN [created]
-GO
diff --git a/SQL/mssql/2016100900.sql b/SQL/mssql/2016100900.sql deleted file mode 100644 index 38b359a48..000000000 --- a/SQL/mssql/2016100900.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE [dbo].[session] ALTER COLUMN [ip] [varchar] (40) COLLATE Latin1_General_CI_AI NOT NULL -GO diff --git a/SQL/mssql/2016112200.sql b/SQL/mssql/2016112200.sql deleted file mode 100644 index 302a3ae16..000000000 --- a/SQL/mssql/2016112200.sql +++ /dev/null @@ -1,36 +0,0 @@ -DROP TABLE [dbo].[cache] -GO -DROP TABLE [dbo].[cache_shared] -GO - -CREATE TABLE [dbo].[cache] ( - [user_id] [int] NOT NULL , - [cache_key] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL , - [expires] [datetime] NULL , - [data] [text] COLLATE Latin1_General_CI_AI NOT NULL -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -GO -CREATE TABLE [dbo].[cache_shared] ( - [cache_key] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL , - [expires] [datetime] NULL , - [data] [text] COLLATE Latin1_General_CI_AI NOT NULL -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] -GO -ALTER TABLE [dbo].[cache] ADD - CONSTRAINT [DF_cache_user_id] DEFAULT ('0') FOR [user_id], - CONSTRAINT [DF_cache_cache_key] DEFAULT ('') FOR [cache_key] -GO -CREATE INDEX [IX_cache_expires] ON [dbo].[cache]([expires]) ON [PRIMARY] -GO -CREATE INDEX [IX_cache_shared_expires] ON [dbo].[cache_shared]([expires]) ON [PRIMARY] -GO -ALTER TABLE [dbo].[cache] WITH NOCHECK ADD - PRIMARY KEY CLUSTERED ( - [user_id],[cache_key] - ) ON [PRIMARY] -GO -ALTER TABLE [dbo].[cache_shared] WITH NOCHECK ADD - PRIMARY KEY CLUSTERED ( - [cache_key] - ) ON [PRIMARY] -GO diff --git a/SQL/mssql/2018021600.sql b/SQL/mssql/2018021600.sql deleted file mode 100644 index dae515d77..000000000 --- a/SQL/mssql/2018021600.sql +++ /dev/null @@ -1,24 +0,0 @@ -CREATE TABLE [dbo].[filestore] (
- [file_id] [int] IDENTITY (1, 1) NOT NULL ,
- [user_id] [int] NOT NULL ,
- [filename] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
- [mtime] [int] NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NULL ,
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[filestore] WITH NOCHECK ADD
- CONSTRAINT [PK_filestore_file_id] PRIMARY KEY CLUSTERED
- (
- [file_id]
- ) ON [PRIMARY]
-GO
-
-CREATE INDEX [IX_filestore_user_id] ON [dbo].[filestore]([user_id]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[filestore] ADD CONSTRAINT [FK_filestore_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
diff --git a/SQL/mssql/2018122300.sql b/SQL/mssql/2018122300.sql deleted file mode 100644 index a4b295c9b..000000000 --- a/SQL/mssql/2018122300.sql +++ /dev/null @@ -1,9 +0,0 @@ -ALTER TABLE [dbo].[filestore] ADD [context] varchar(32) COLLATE Latin1_General_CI_AI NOT NULL
-GO
-
-UPDATE [dbo].[filestore] SET [context] = 'enigma'
-GO
-
-CREATE UNIQUE INDEX [IX_filestore_user_id_context_filename] ON [dbo].[filestore]([user_id],[context],[filename]) ON [PRIMARY]
-GO
-
diff --git a/SQL/mssql/2019092900.sql b/SQL/mssql/2019092900.sql deleted file mode 100644 index bebf01c95..000000000 --- a/SQL/mssql/2019092900.sql +++ /dev/null @@ -1,18 +0,0 @@ -ALTER TABLE [dbo].[cache] ALTER COLUMN
- [cache_key] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL
-GO
-ALTER TABLE [dbo].[cache_shared] ALTER COLUMN
- [cache_key] [varchar] (255) COLLATE Latin1_General_CS_AS NOT NULL
-GO
-ALTER TABLE [dbo].[cache_index] ALTER COLUMN
- [mailbox] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL
-GO
-ALTER TABLE [dbo].[cache_messages] ALTER COLUMN
- [mailbox] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL
-GO
-ALTER TABLE [dbo].[cache_thread] ALTER COLUMN
- [mailbox] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL
-GO
-ALTER TABLE [dbo].[users] ALTER COLUMN
- [username] [varchar] (128) COLLATE Latin1_General_CS_AS NOT NULL
-GO
diff --git a/SQL/mssql/2020020100.sql b/SQL/mssql/2020020100.sql deleted file mode 100644 index c5d059713..000000000 --- a/SQL/mssql/2020020100.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE [dbo].[users] ALTER COLUMN [language] [varchar] (16) COLLATE Latin1_General_CI_AI NULL
-GO
-ALTER TABLE [dbo].[dictionary] ALTER COLUMN [language] [varchar] (16) COLLATE Latin1_General_CI_AI NOT NULL
-GO
diff --git a/SQL/mssql/2020020101.sql b/SQL/mssql/2020020101.sql deleted file mode 100644 index fe6741a02..000000000 --- a/SQL/mssql/2020020101.sql +++ /dev/null @@ -1 +0,0 @@ --- empty
\ No newline at end of file diff --git a/SQL/mssql/2020091000.sql b/SQL/mssql/2020091000.sql deleted file mode 100644 index 202f9ef3f..000000000 --- a/SQL/mssql/2020091000.sql +++ /dev/null @@ -1,31 +0,0 @@ -CREATE TABLE [dbo].[collected_addresses] (
- [address_id] [int] IDENTITY (1, 1) NOT NULL ,
- [user_id] [int] NOT NULL ,
- [changed] [datetime] NOT NULL ,
- [name] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL ,
- [email] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL ,
- [type] [int] NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[collected_addresses] WITH NOCHECK ADD
- CONSTRAINT [PK_collected_addresses_address_id] PRIMARY KEY CLUSTERED
- (
- [address_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[collected_addresses] ADD
- CONSTRAINT [DF_collected_addresses_user_id] DEFAULT (0) FOR [user_id],
- CONSTRAINT [DF_collected_addresses_changed] DEFAULT (getdate()) FOR [changed],
- CONSTRAINT [DF_collected_addresses_name] DEFAULT ('') FOR [name],
-GO
-
-CREATE UNIQUE INDEX [IX_collected_addresses_user_id] ON [dbo].[collected_addresses]([user_id],[type],[email]) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[collected_addresses] ADD CONSTRAINT [FK_collected_addresses_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
diff --git a/SQL/mssql/2020122900.sql b/SQL/mssql/2020122900.sql deleted file mode 100644 index 73cbb589f..000000000 --- a/SQL/mssql/2020122900.sql +++ /dev/null @@ -1 +0,0 @@ ---empty
\ No newline at end of file diff --git a/SQL/mssql/2021081000.sql b/SQL/mssql/2021081000.sql deleted file mode 100644 index 4fa037c17..000000000 --- a/SQL/mssql/2021081000.sql +++ /dev/null @@ -1,33 +0,0 @@ -CREATE TABLE [dbo].[responses] (
- [response_id] [int] IDENTITY (1, 1) NOT NULL ,
- [user_id] [int] NOT NULL ,
- [changed] [datetime] NOT NULL ,
- [del] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL ,
- [name] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL ,
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL,
- [is_html] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[responses] WITH NOCHECK ADD
- PRIMARY KEY CLUSTERED
- (
- [response_id]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[responses] ADD
- CONSTRAINT [DF_responses_user] DEFAULT ('0') FOR [user_id],
- CONSTRAINT [DF_responses_del] DEFAULT ('0') FOR [del],
- CONSTRAINT [DF_responses_is_html] DEFAULT ('0') FOR [is_html],
- CHECK ([del] = '1' or [del] = '0'),
- CHECK ([is_html] = '1' or [is_html] = '0')
-GO
-
-CREATE INDEX [IX_responses_user_id] ON [dbo].[responses]([user_id]) ON [PRIMARY]
-GO
-ALTER TABLE [dbo].[responses] ADD CONSTRAINT [FK_responses_user_id]
- FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
- ON DELETE CASCADE ON UPDATE CASCADE
-GO
-
diff --git a/SQL/mssql/2021100300.sql b/SQL/mssql/2021100300.sql deleted file mode 100644 index 49daeda32..000000000 --- a/SQL/mssql/2021100300.sql +++ /dev/null @@ -1 +0,0 @@ --- SQLite only
\ No newline at end of file diff --git a/SQL/mssql/2022081200.sql b/SQL/mssql/2022081200.sql deleted file mode 100644 index 105e39efb..000000000 --- a/SQL/mssql/2022081200.sql +++ /dev/null @@ -1 +0,0 @@ --- SQLite/Postgres only
\ No newline at end of file diff --git a/SQL/oracle.initial.sql b/SQL/oracle.initial.sql deleted file mode 100644 index 989681cf4..000000000 --- a/SQL/oracle.initial.sql +++ /dev/null @@ -1,288 +0,0 @@ --- Roundcube Webmail initial database structure --- This was tested with Oracle 11g - -CREATE TABLE "users" ( - "user_id" integer PRIMARY KEY, - "username" varchar(128) NOT NULL, - "mail_host" varchar(128) NOT NULL, - "created" timestamp with time zone DEFAULT current_timestamp NOT NULL, - "last_login" timestamp with time zone DEFAULT NULL, - "failed_login" timestamp with time zone DEFAULT NULL, - "failed_login_counter" integer DEFAULT NULL, - "language" varchar(16), - "preferences" long DEFAULT NULL, - CONSTRAINT "users_username_key" UNIQUE ("username", "mail_host") -); - -CREATE SEQUENCE "users_seq" - START WITH 1 INCREMENT BY 1 NOMAXVALUE; - -CREATE TRIGGER "users_seq_trig" -BEFORE INSERT ON "users" FOR EACH ROW -BEGIN - :NEW."user_id" := "users_seq".nextval; -END; -/ - -CREATE TABLE "session" ( - "sess_id" varchar(128) NOT NULL PRIMARY KEY, - "changed" timestamp with time zone DEFAULT current_timestamp NOT NULL, - "ip" varchar(41) NOT NULL, - "vars" long NOT NULL -); - -CREATE INDEX "session_changed_idx" ON "session" ("changed"); - - -CREATE TABLE "identities" ( - "identity_id" integer PRIMARY KEY, - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "changed" timestamp with time zone DEFAULT current_timestamp NOT NULL, - "del" smallint DEFAULT 0 NOT NULL, - "standard" smallint DEFAULT 0 NOT NULL, - "name" varchar(128) NOT NULL, - "organization" varchar(128), - "email" varchar(128) NOT NULL, - "reply-to" varchar(128), - "bcc" varchar(128), - "signature" long, - "html_signature" integer DEFAULT 0 NOT NULL -); - -CREATE INDEX "identities_user_id_idx" ON "identities" ("user_id", "del"); -CREATE INDEX "identities_email_idx" ON "identities" ("email", "del"); - -CREATE SEQUENCE "identities_seq" - START WITH 1 INCREMENT BY 1 NOMAXVALUE; - -CREATE TRIGGER "identities_seq_trig" -BEFORE INSERT ON "identities" FOR EACH ROW -BEGIN - :NEW."identity_id" := "identities_seq".nextval; -END; -/ - - -CREATE TABLE "responses" ( - "response_id" integer PRIMARY KEY, - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "changed" timestamp with time zone DEFAULT current_timestamp NOT NULL, - "del" smallint DEFAULT 0 NOT NULL, - "name" varchar(128) NOT NULL, - "data" long NOT NULL, - "is_html" smallint DEFAULT 0 NOT NULL -); - -CREATE INDEX "responses_user_id_idx" ON "responses" ("user_id", "del"); - -CREATE SEQUENCE "responses_seq" - START WITH 1 INCREMENT BY 1 NOMAXVALUE; - -CREATE TRIGGER "responses_seq_trig" -BEFORE INSERT ON "responses" FOR EACH ROW -BEGIN - :NEW."response_id" := "response_seq".nextval; -END; -/ - - -CREATE TABLE "collected_addresses" ( - "address_id" integer PRIMARY KEY, - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "changed" timestamp with time zone DEFAULT current_timestamp NOT NULL, - "name" varchar(255) DEFAULT NULL, - "email" varchar(255) DEFAULT NULL, - "type" integer NOT NULL -); - -CREATE UNIQUE INDEX "collected_addresses_user_id_idx" ON "collected_addresses" ("user_id", "type", "email"); - -CREATE SEQUENCE "collected_addresses_seq" - START WITH 1 INCREMENT BY 1 NOMAXVALUE; - -CREATE TRIGGER "collected_addresses_seq_trig" -BEFORE INSERT ON "collected_addresses" FOR EACH ROW -BEGIN - :NEW."address_id" := "collected_addresses_seq".nextval; -END; -/ - -CREATE TABLE "contacts" ( - "contact_id" integer PRIMARY KEY, - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "changed" timestamp with time zone DEFAULT current_timestamp NOT NULL, - "del" smallint DEFAULT 0 NOT NULL, - "name" varchar(128) DEFAULT NULL, - "email" varchar(4000) DEFAULT NULL, - "firstname" varchar(128) DEFAULT NULL, - "surname" varchar(128) DEFAULT NULL, - "vcard" long, - "words" varchar(4000) -); - -CREATE INDEX "contacts_user_id_idx" ON "contacts" ("user_id", "del"); - -CREATE SEQUENCE "contacts_seq" - START WITH 1 INCREMENT BY 1 NOMAXVALUE; - -CREATE TRIGGER "contacts_seq_trig" -BEFORE INSERT ON "contacts" FOR EACH ROW -BEGIN - :NEW."contact_id" := "contacts_seq".nextval; -END; -/ - -CREATE TABLE "contactgroups" ( - "contactgroup_id" integer PRIMARY KEY, - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "changed" timestamp with time zone DEFAULT current_timestamp NOT NULL, - "del" smallint DEFAULT 0 NOT NULL, - "name" varchar(128) NOT NULL -); - -CREATE INDEX "contactgroups_user_id_idx" ON "contactgroups" ("user_id", "del"); - -CREATE SEQUENCE "contactgroups_seq" - START WITH 1 INCREMENT BY 1 NOMAXVALUE; - -CREATE TRIGGER "contactgroups_seq_trig" -BEFORE INSERT ON "contactgroups" FOR EACH ROW -BEGIN - :NEW."contactgroup_id" := "contactgroups_seq".nextval; -END; -/ - -CREATE TABLE "contactgroupmembers" ( - "contactgroup_id" integer NOT NULL - REFERENCES "contactgroups" ("contactgroup_id") ON DELETE CASCADE, - "contact_id" integer NOT NULL - REFERENCES "contacts" ("contact_id") ON DELETE CASCADE, - "created" timestamp with time zone DEFAULT current_timestamp NOT NULL, - PRIMARY KEY ("contactgroup_id", "contact_id") -); - -CREATE INDEX "contactgroupmembers_idx" ON "contactgroupmembers" ("contact_id"); - - -CREATE TABLE "cache" ( - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "cache_key" varchar(128) NOT NULL, - "expires" timestamp with time zone DEFAULT NULL, - "data" long NOT NULL, - PRIMARY KEY ("user_id", "cache_key") -); - -CREATE INDEX "cache_expires_idx" ON "cache" ("expires"); - - -CREATE TABLE "cache_shared" ( - "cache_key" varchar(255) NOT NULL, - "expires" timestamp with time zone DEFAULT NULL, - "data" long NOT NULL, - PRIMARY KEY ("cache_key") -); - -CREATE INDEX "cache_shared_expires_idx" ON "cache_shared" ("expires"); - - -CREATE TABLE "cache_index" ( - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "mailbox" varchar(255) NOT NULL, - "expires" timestamp with time zone DEFAULT NULL, - "valid" smallint DEFAULT 0 NOT NULL, - "data" long NOT NULL, - PRIMARY KEY ("user_id", "mailbox") -); - -CREATE INDEX "cache_index_expires_idx" ON "cache_index" ("expires"); - - -CREATE TABLE "cache_thread" ( - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "mailbox" varchar(255) NOT NULL, - "expires" timestamp with time zone DEFAULT NULL, - "data" long NOT NULL, - PRIMARY KEY ("user_id", "mailbox") -); - -CREATE INDEX "cache_thread_expires_idx" ON "cache_thread" ("expires"); - - -CREATE TABLE "cache_messages" ( - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "mailbox" varchar(255) NOT NULL, - "uid" integer NOT NULL, - "expires" timestamp with time zone DEFAULT NULL, - "data" long NOT NULL, - "flags" integer DEFAULT 0 NOT NULL, - PRIMARY KEY ("user_id", "mailbox", "uid") -); - -CREATE INDEX "cache_messages_expires_idx" ON "cache_messages" ("expires"); - - -CREATE TABLE "dictionary" ( - "user_id" integer DEFAULT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "language" varchar(16) NOT NULL, - "data" long DEFAULT NULL, - CONSTRAINT "dictionary_user_id_lang_key" UNIQUE ("user_id", "language") -); - - -CREATE TABLE "searches" ( - "search_id" integer PRIMARY KEY, - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "type" smallint DEFAULT 0 NOT NULL, - "name" varchar(128) NOT NULL, - "data" long NOT NULL, - CONSTRAINT "searches_user_id_key" UNIQUE ("user_id", "type", "name") -); - -CREATE SEQUENCE "searches_seq" - START WITH 1 INCREMENT BY 1 NOMAXVALUE; - -CREATE TRIGGER "searches_seq_trig" -BEFORE INSERT ON "searches" FOR EACH ROW -BEGIN - :NEW."search_id" := "searches_seq".nextval; -END; -/ - -CREATE TABLE "filestore" ( - "file_id" integer PRIMARY KEY, - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE ON UPDATE CASCADE, - "context" varchar(32) NOT NULL, - "filename" varchar(128) NOT NULL, - "mtime" integer NOT NULL, - "data" long, - CONSTRAINT "filestore_user_id_key" UNIQUE ("user_id", "context", "filename") -); - -CREATE SEQUENCE "filestore_seq" - START WITH 1 INCREMENT BY 1 NOMAXVALUE; - -CREATE TRIGGER "filestore_seq_trig" -BEFORE INSERT ON "filestore" FOR EACH ROW -BEGIN - :NEW."user_id" := "filestore_seq".nextval; -END; -/ - -CREATE TABLE "system" ( - "name" varchar(64) NOT NULL PRIMARY KEY, - "value" long -); - -INSERT INTO "system" ("name", "value") VALUES ('roundcube-version', '2022081200'); diff --git a/SQL/oracle/2015030800.sql b/SQL/oracle/2015030800.sql deleted file mode 100644 index fe6741a02..000000000 --- a/SQL/oracle/2015030800.sql +++ /dev/null @@ -1 +0,0 @@ --- empty
\ No newline at end of file diff --git a/SQL/oracle/2015111100.sql b/SQL/oracle/2015111100.sql deleted file mode 100644 index 010203f9f..000000000 --- a/SQL/oracle/2015111100.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE "users" ADD "failed_login" timestamp with time zone DEFAULT NULL; -ALTER TABLE "users" ADD "failed_login_counter" integer DEFAULT NULL; diff --git a/SQL/oracle/2016081200.sql b/SQL/oracle/2016081200.sql deleted file mode 100644 index aacfe4186..000000000 --- a/SQL/oracle/2016081200.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE "session" DROP COLUMN "created"; diff --git a/SQL/oracle/2016100900.sql b/SQL/oracle/2016100900.sql deleted file mode 100644 index 030f169e3..000000000 --- a/SQL/oracle/2016100900.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE "session" MODIFY "ip" varchar(41) NOT NULL; diff --git a/SQL/oracle/2016112200.sql b/SQL/oracle/2016112200.sql deleted file mode 100644 index 3aab26510..000000000 --- a/SQL/oracle/2016112200.sql +++ /dev/null @@ -1,23 +0,0 @@ -DROP TABLE "cache"; -DROP TABLE "cache_shared"; - -CREATE TABLE "cache" ( - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "cache_key" varchar(128) NOT NULL, - "expires" timestamp with time zone DEFAULT NULL, - "data" long NOT NULL, - PRIMARY KEY ("user_id", "cache_key") -); - -CREATE INDEX "cache_expires_idx" ON "cache" ("expires"); - - -CREATE TABLE "cache_shared" ( - "cache_key" varchar(255) NOT NULL, - "expires" timestamp with time zone DEFAULT NULL, - "data" long NOT NULL, - PRIMARY KEY ("cache_key") -); - -CREATE INDEX "cache_shared_expires_idx" ON "cache_shared" ("expires"); diff --git a/SQL/oracle/2018021600.sql b/SQL/oracle/2018021600.sql deleted file mode 100644 index 2fe3bcd42..000000000 --- a/SQL/oracle/2018021600.sql +++ /dev/null @@ -1,19 +0,0 @@ -CREATE TABLE "filestore" ( - "file_id" integer PRIMARY KEY, - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE ON UPDATE CASCADE, - "filename" varchar(128) NOT NULL, - "mtime" integer NOT NULL, - "data" long, - CONSTRAINT "filestore_user_id_key" UNIQUE ("user_id", "filename") -); - -CREATE SEQUENCE "filestore_seq" - START WITH 1 INCREMENT BY 1 NOMAXVALUE; - -CREATE TRIGGER "filestore_seq_trig" -BEFORE INSERT ON "filestore" FOR EACH ROW -BEGIN - :NEW."user_id" := "filestore_seq".nextval; -END; -/ diff --git a/SQL/oracle/2018122300.sql b/SQL/oracle/2018122300.sql deleted file mode 100644 index dd75dfc82..000000000 --- a/SQL/oracle/2018122300.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE "filestore" ADD COLUMN "context" varchar(32) NOT NULL; -UPDATE "filestore" SET "context" = 'enigma'; -ALTER TABLE "filestore" DROP CONSTRAINT "filestore_user_id_key"; -ALTER TABLE "filestore" ADD CONSTRAINT "filestore_user_id_key" UNIQUE ("user_id", "context", "filename"); diff --git a/SQL/oracle/2019092900.sql b/SQL/oracle/2019092900.sql deleted file mode 100644 index fe6741a02..000000000 --- a/SQL/oracle/2019092900.sql +++ /dev/null @@ -1 +0,0 @@ --- empty
\ No newline at end of file diff --git a/SQL/oracle/2020020100.sql b/SQL/oracle/2020020100.sql deleted file mode 100644 index 2590179e3..000000000 --- a/SQL/oracle/2020020100.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE "users" MODIFY "language" varchar(16) NOT NULL; -ALTER TABLE "dictionary" MODIFY "language" varchar(16); diff --git a/SQL/oracle/2020020101.sql b/SQL/oracle/2020020101.sql deleted file mode 100644 index fe6741a02..000000000 --- a/SQL/oracle/2020020101.sql +++ /dev/null @@ -1 +0,0 @@ --- empty
\ No newline at end of file diff --git a/SQL/oracle/2020091000.sql b/SQL/oracle/2020091000.sql deleted file mode 100644 index 0e598cda6..000000000 --- a/SQL/oracle/2020091000.sql +++ /dev/null @@ -1,21 +0,0 @@ -CREATE TABLE "collected_addresses" ( - "address_id" integer PRIMARY KEY, - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "changed" timestamp with time zone DEFAULT current_timestamp NOT NULL, - "name" varchar(255) DEFAULT NULL, - "email" varchar(255) DEFAULT NULL, - "type" integer NOT NULL -); - -CREATE UNIQUE INDEX "collected_addresses_user_id_idx" ON "collected_addresses" ("user_id", "type", "email"); - -CREATE SEQUENCE "collected_addresses_seq" - START WITH 1 INCREMENT BY 1 NOMAXVALUE; - -CREATE TRIGGER "collected_addresses_seq_trig" -BEFORE INSERT ON "collected_addresses" FOR EACH ROW -BEGIN - :NEW."address_id" := "collected_addresses_seq".nextval; -END; -/ diff --git a/SQL/oracle/2020122900.sql b/SQL/oracle/2020122900.sql deleted file mode 100644 index 73cbb589f..000000000 --- a/SQL/oracle/2020122900.sql +++ /dev/null @@ -1 +0,0 @@ ---empty
\ No newline at end of file diff --git a/SQL/oracle/2021081000.sql b/SQL/oracle/2021081000.sql deleted file mode 100644 index fb99b5dbc..000000000 --- a/SQL/oracle/2021081000.sql +++ /dev/null @@ -1,22 +0,0 @@ -CREATE TABLE "responses" ( - "response_id" integer PRIMARY KEY, - "user_id" integer NOT NULL - REFERENCES "users" ("user_id") ON DELETE CASCADE, - "changed" timestamp with time zone DEFAULT current_timestamp NOT NULL, - "del" smallint DEFAULT 0 NOT NULL, - "name" varchar(128) NOT NULL, - "data" long NOT NULL, - "is_html" smallint DEFAULT 0 NOT NULL -); - -CREATE INDEX "responses_user_id_idx" ON "responses" ("user_id", "del"); - -CREATE SEQUENCE "responses_seq" - START WITH 1 INCREMENT BY 1 NOMAXVALUE; - -CREATE TRIGGER "responses_seq_trig" -BEFORE INSERT ON "responses" FOR EACH ROW -BEGIN - :NEW."response_id" := "response_seq".nextval; -END; -/ diff --git a/SQL/oracle/2021100300.sql b/SQL/oracle/2021100300.sql deleted file mode 100644 index 49daeda32..000000000 --- a/SQL/oracle/2021100300.sql +++ /dev/null @@ -1 +0,0 @@ --- SQLite only
\ No newline at end of file diff --git a/SQL/oracle/2022081200.sql b/SQL/oracle/2022081200.sql deleted file mode 100644 index 105e39efb..000000000 --- a/SQL/oracle/2022081200.sql +++ /dev/null @@ -1 +0,0 @@ --- SQLite/Postgres only
\ No newline at end of file |