From e71de17602c2c13beee9d9f2be2e664d6a80926d Mon Sep 17 00:00:00 2001
From: Aleksander Machniak <alec@alec.pl>
Date: Fri, 20 May 2016 08:31:43 -0400
Subject: [PATCH] Add note about need for module name change in IfModule when using PHP7 (#5249)
---
SQL/oracle.initial.sql | 14 ++++++++------
1 files changed, 8 insertions(+), 6 deletions(-)
diff --git a/SQL/oracle.initial.sql b/SQL/oracle.initial.sql
index 84f7a1f..82ee1d8 100644
--- a/SQL/oracle.initial.sql
+++ b/SQL/oracle.initial.sql
@@ -7,6 +7,8 @@
"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(5),
"preferences" long DEFAULT NULL,
CONSTRAINT "users_username_key" UNIQUE ("username", "mail_host")
@@ -20,7 +22,7 @@
BEGIN
:NEW."user_id" := "users_seq".nextval;
END;
-
+/
CREATE TABLE "session" (
"sess_id" varchar(128) NOT NULL PRIMARY KEY,
@@ -60,7 +62,7 @@
BEGIN
:NEW."identity_id" := "identities_seq".nextval;
END;
-
+/
CREATE TABLE "contacts" (
"contact_id" integer PRIMARY KEY,
@@ -86,7 +88,7 @@
BEGIN
:NEW."contact_id" := "contacts_seq".nextval;
END;
-
+/
CREATE TABLE "contactgroups" (
"contactgroup_id" integer PRIMARY KEY,
@@ -107,7 +109,7 @@
BEGIN
:NEW."contactgroup_id" := "contactgroups_seq".nextval;
END;
-
+/
CREATE TABLE "contactgroupmembers" (
"contactgroup_id" integer NOT NULL
@@ -211,11 +213,11 @@
BEGIN
:NEW."search_id" := "searches_seq".nextval;
END;
-
+/
CREATE TABLE "system" (
"name" varchar(64) NOT NULL PRIMARY KEY,
"value" long
);
-INSERT INTO "system" ("name", "value") VALUES ('roundcube-version', '2014042900');
+INSERT INTO "system" ("name", "value") VALUES ('roundcube-version', '2015111100');
--
Gitblit v1.9.1