You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-commits@db.apache.org by mc...@apache.org on 2007/11/02 20:30:52 UTC
svn commit: r591430 [3/3] - in /db/jdo/trunk/tck2/src: conf/
java/org/apache/jdo/tck/models/fieldtypes/
java/org/apache/jdo/tck/pc/fieldtypes/
jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/
jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldty...
Modified: db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema.sql?rev=591430&r1=591429&r2=591430&view=diff
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema.sql Fri Nov 2 12:30:50 2007
@@ -294,6 +294,8 @@
DROP TABLE ARRAY_OF_INTEGER23;
DROP TABLE ARRAY_OF_LONG25;
DROP TABLE ARRAY_OF_SHORT27;
+DROP TABLE ARRAY_OF_SIMPLEENUM29;
+DROP TABLE ARRAY_OF_SIMPLEENUM30;
DROP TABLE ARRAY_COLLECTIONS;
DROP TABLE ARRAYLIST_OF_OBJECT0;
@@ -327,6 +329,10 @@
DROP TABLE ARRAYLIST_OF_LONG38;
DROP TABLE ARRAYLIST_OF_SHORT39;
DROP TABLE ARRAYLIST_OF_SHORT41;
+DROP TABLE ARRAYLIST_OF_SIMPLEENUM42;
+DROP TABLE ARRAYLIST_OF_SIMPLEENUM44;
+DROP TABLE ARRAYLIST_OF_SIMPLEENUM45;
+DROP TABLE ARRAYLIST_OF_SIMPLEENUM46;
DROP TABLE ARRAYLIST_COLLECTIONS;
DROP TABLE COLLECTION_OF_OBJECT0;
@@ -636,6 +642,18 @@
DROP TABLE MAP_OF_STRING_INTEGER117;
DROP TABLE MAP_OF_STRING_LONG120;
DROP TABLE MAP_OF_STRING_SHORT123;
+DROP TABLE MAP_OF_STRING_SIMPLEENUM126;
+DROP TABLE MAP_OF_STRING_SIMPLEENUM127;
+DROP TABLE MAP_OF_STRING_SIMPLEENUM128;
+DROP TABLE MAP_OF_STRING_SIMPLEENUM129;
+DROP TABLE MAP_OF_STRING_SIMPLEENUM130;
+DROP TABLE MAP_OF_STRING_SIMPLEENUM131;
+DROP TABLE MAP_OF_STRING_SIMPLEENUM133;
+DROP TABLE MAP_OF_STRING_SIMPLEENUM134;
+DROP TABLE MAP_OF_STRING_SIMPLEENUM135;
+DROP TABLE MAP_OF_STRING_SIMPLEENUM136;
+DROP TABLE MAP_OF_STRING_SIMPLEENUM137;
+DROP TABLE MAP_OF_STRING_SIMPLEENUM138;
DROP TABLE MAPSTRINGKEY_COLLECTIONS;
DROP TABLE HASHMAP_STR_OBJECT0;
@@ -802,6 +820,18 @@
DROP TABLE MAP_SHORT111_STR;
DROP TABLE MAP_SHORT112_STR;
DROP TABLE MAP_SHORT114_STR;
+DROP TABLE MAP_SIMPLEENUM117_STR;
+DROP TABLE MAP_SIMPLEENUM118_STR;
+DROP TABLE MAP_SIMPLEENUM119_STR;
+DROP TABLE MAP_SIMPLEENUM120_STR;
+DROP TABLE MAP_SIMPLEENUM121_STR;
+DROP TABLE MAP_SIMPLEENUM122_STR;
+DROP TABLE MAP_SIMPLEENUM124_STR;
+DROP TABLE MAP_SIMPLEENUM125_STR;
+DROP TABLE MAP_SIMPLEENUM126_STR;
+DROP TABLE MAP_SIMPLEENUM127_STR;
+DROP TABLE MAP_SIMPLEENUM128_STR;
+DROP TABLE MAP_SIMPLEENUM129_STR;
DROP TABLE MAPSTRINGVALUE_COLLECTIONS;
DROP TABLE HASHTBL_STR_OBJECT0;
@@ -1225,6 +1255,7 @@
DROP TABLE FIELDSOFCHARACTER;
DROP TABLE FIELDSOFDATE;
DROP TABLE FIELDSOFDOUBLE;
+DROP TABLE FIELDSOFENUMNAME;
DROP TABLE FIELDSOFFLOAT;
DROP TABLE FIELDSOFINTEGER;
DROP TABLE FIELDSOFLOCALE;
@@ -1762,6 +1793,87 @@
ALTER TABLE FIELDSOFDOUBLE ADD CONSTRAINT FIELDSOFDOUBLE_PK PRIMARY KEY (DATASTORE_IDENTITY);
+CREATE TABLE FIELDSOFENUMNAME
+(
+ DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+ IDENTIFIER INTEGER,
+ ENUM0 CHAR(2),
+ ENUM1 CHAR(2),
+ ENUM102 CHAR(2),
+ ENUM103 CHAR(2),
+ ENUM104 VARCHAR(256),
+ ENUM108 VARCHAR(256),
+ ENUM109 VARCHAR(256),
+ ENUM11 VARCHAR(256),
+ ENUM110 CHAR(2),
+ ENUM112 CHAR(2),
+ ENUM113 CHAR(2),
+ ENUM114 CHAR(2),
+ ENUM119 VARCHAR(256),
+ ENUM12 VARCHAR(256),
+ ENUM120 VARCHAR(256),
+ ENUM121 VARCHAR(256),
+ ENUM124 CHAR(2),
+ ENUM125 CHAR(2),
+ ENUM126 CHAR(2),
+ ENUM128 CHAR(2),
+ ENUM129 VARCHAR(256),
+ ENUM13 VARCHAR(256),
+ ENUM130 VARCHAR(256),
+ ENUM138 VARCHAR(256),
+ ENUM139 CHAR(2),
+ ENUM140 CHAR(2),
+ ENUM16 CHAR(2),
+ ENUM17 CHAR(2),
+ ENUM18 VARCHAR(256),
+ ENUM2 VARCHAR(256),
+ ENUM20 VARCHAR(256),
+ ENUM21 VARCHAR(256),
+ ENUM22 CHAR(2),
+ ENUM30 CHAR(2),
+ ENUM31 CHAR(2),
+ ENUM32 CHAR(2),
+ ENUM36 VARCHAR(256),
+ ENUM37 VARCHAR(256),
+ ENUM38 VARCHAR(256),
+ ENUM4 VARCHAR(256),
+ ENUM40 CHAR(2),
+ ENUM41 CHAR(2),
+ ENUM42 CHAR(2),
+ ENUM47 CHAR(2),
+ ENUM48 VARCHAR(256),
+ ENUM49 VARCHAR(256),
+ ENUM5 VARCHAR(256),
+ ENUM52 VARCHAR(256),
+ ENUM53 CHAR(2),
+ ENUM54 CHAR(2),
+ ENUM56 CHAR(2),
+ ENUM57 CHAR(2),
+ ENUM58 VARCHAR(256),
+ ENUM6 VARCHAR(256),
+ ENUM66 VARCHAR(256),
+ ENUM67 VARCHAR(256),
+ ENUM68 CHAR(2),
+ ENUM72 CHAR(2),
+ ENUM73 CHAR(2),
+ ENUM74 CHAR(2),
+ ENUM76 VARCHAR(256),
+ ENUM77 VARCHAR(256),
+ ENUM78 VARCHAR(256),
+ ENUM83 VARCHAR(256),
+ ENUM84 CHAR(2),
+ ENUM85 CHAR(2),
+ ENUM88 CHAR(2),
+ ENUM89 CHAR(2),
+ ENUM90 VARCHAR(256),
+ ENUM92 VARCHAR(256),
+ ENUM93 VARCHAR(256),
+ ENUM94 VARCHAR(256)
+);
+
+ALTER TABLE FIELDSOFENUMNAME ADD CONSTRAINT
+ FIELDSOFENUMNAME_PK PRIMARY KEY (DATASTORE_IDENTITY);
+
CREATE TABLE FIELDSOFFLOAT
(
DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
@@ -3345,6 +3457,20 @@
SHORTVAL SMALLINT
);
+CREATE TABLE ARRAY_OF_SIMPLEENUM29
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ ORDER_COL BIGINT,
+ ENUMVAL CHAR(2)
+);
+
+CREATE TABLE ARRAY_OF_SIMPLEENUM30
+(
+ IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
+ ORDER_COL BIGINT,
+ ENUMVAL NUMERIC(2,0)
+);
+
--CollectionCollections
CREATE TABLE COLLECTION_COLLECTIONS
@@ -3850,6 +3976,7 @@
ARRAYLIST_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_LONG37 LONG VARCHAR FOR BIT DATA,
ARRAYLIST_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
+ ARRAYLIST_OF_SIMPLEENUM43 LONG VARCHAR FOR BIT DATA,
CONSTRAINT ALC_PK PRIMARY KEY (DATASTORE_IDENTITY)
);
@@ -4070,6 +4197,34 @@
INDEX INTEGER NOT NULL
);
+CREATE TABLE ARRAYLIST_OF_SIMPLEENUM42
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ SIMPLEENUMVAL CHAR(2),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLEENUM44
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ SIMPLEENUMVAL CHAR(2),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLEENUM45
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ SIMPLEENUMVAL NUMERIC(2),
+ INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE ARRAYLIST_OF_SIMPLEENUM46
+(
+ IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
+ SIMPLEENUMVAL NUMERIC(2),
+ INDEX INTEGER NOT NULL
+);
+
--LinkedListCollections
CREATE TABLE LINKEDLIST_COLLECTIONS
@@ -5196,6 +5351,7 @@
MAP_OF_STRING_INTEGER119 LONG VARCHAR FOR BIT DATA,
MAP_OF_STRING_LONG122 LONG VARCHAR FOR BIT DATA,
MAP_OF_STRING_SHORT125 LONG VARCHAR FOR BIT DATA,
+ MAP_OF_STRING_SIMPLEENUM132 LONG VARCHAR FOR BIT DATA,
CONSTRAINT MSKC_PK PRIMARY KEY (DATASTORE_IDENTITY)
);
@@ -5799,6 +5955,90 @@
VALUEVAL SMALLINT NOT NULL
);
+CREATE TABLE MAP_OF_STRING_SIMPLEENUM126
+(
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
+ KEYVAL VARCHAR(100) NOT NULL,
+ VALUEVAL CHAR(2) NOT NULL
+);
+
+CREATE TABLE MAP_OF_STRING_SIMPLEENUM127
+(
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
+ KEYVAL VARCHAR(100) NOT NULL,
+ VALUEVAL CHAR(2) NOT NULL
+);
+
+CREATE TABLE MAP_OF_STRING_SIMPLEENUM128
+(
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
+ KEYVAL VARCHAR(100) NOT NULL,
+ VALUEVAL CHAR(2) NOT NULL
+);
+
+CREATE TABLE MAP_OF_STRING_SIMPLEENUM129
+(
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
+ KEYVAL VARCHAR(100) NOT NULL,
+ VALUEVAL CHAR(2) NOT NULL
+);
+
+CREATE TABLE MAP_OF_STRING_SIMPLEENUM130
+(
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
+ KEYVAL VARCHAR(100) NOT NULL,
+ VALUEVAL CHAR(2) NOT NULL
+);
+
+CREATE TABLE MAP_OF_STRING_SIMPLEENUM131
+(
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
+ KEYVAL VARCHAR(100) NOT NULL,
+ VALUEVAL CHAR(2) NOT NULL
+);
+
+CREATE TABLE MAP_OF_STRING_SIMPLEENUM133
+(
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
+ KEYVAL VARCHAR(100) NOT NULL,
+ VALUEVAL NUMERIC(2,0) NOT NULL
+);
+
+CREATE TABLE MAP_OF_STRING_SIMPLEENUM134
+(
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
+ KEYVAL VARCHAR(100) NOT NULL,
+ VALUEVAL NUMERIC(2,0) NOT NULL
+);
+
+CREATE TABLE MAP_OF_STRING_SIMPLEENUM135
+(
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
+ KEYVAL VARCHAR(100) NOT NULL,
+ VALUEVAL NUMERIC(2,0) NOT NULL
+);
+
+CREATE TABLE MAP_OF_STRING_SIMPLEENUM136
+(
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
+ KEYVAL VARCHAR(100) NOT NULL,
+ VALUEVAL NUMERIC(2,0) NOT NULL
+);
+
+CREATE TABLE MAP_OF_STRING_SIMPLEENUM137
+(
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
+ KEYVAL VARCHAR(100) NOT NULL,
+ VALUEVAL NUMERIC(2,0) NOT NULL
+);
+
+CREATE TABLE MAP_OF_STRING_SIMPLEENUM138
+(
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
+ KEYVAL VARCHAR(100) NOT NULL,
+ VALUEVAL NUMERIC(2,0) NOT NULL
+);
+
--HashMapOfStringKeyCollections
CREATE TABLE HASHMAPSTRINGKEY_COLLECTIONS
@@ -8585,6 +8825,7 @@
MAP_INTEGER98_STR LONG VARCHAR FOR BIT DATA,
MAP_LONG107_STR LONG VARCHAR FOR BIT DATA,
MAP_SHORT116_STR LONG VARCHAR FOR BIT DATA,
+ MAP_SIMPLEENUM123_STR LONG VARCHAR FOR BIT DATA,
CONSTRAINT MSVC_PK PRIMARY KEY (DATASTORE_IDENTITY)
);
@@ -9072,6 +9313,78 @@
IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
VALUEVAL VARCHAR(100) NOT NULL,
KEYVAL SMALLINT
+);
+
+CREATE TABLE MAP_SIMPLEENUM117_STR (
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
+ VALUEVAL VARCHAR(100) NOT NULL,
+ KEYVAL CHAR(2)
+);
+
+CREATE TABLE MAP_SIMPLEENUM118_STR (
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
+ VALUEVAL VARCHAR(100) NOT NULL,
+ KEYVAL CHAR(2)
+);
+
+CREATE TABLE MAP_SIMPLEENUM119_STR (
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
+ VALUEVAL VARCHAR(100) NOT NULL,
+ KEYVAL CHAR(2)
+);
+
+CREATE TABLE MAP_SIMPLEENUM120_STR (
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
+ VALUEVAL VARCHAR(100) NOT NULL,
+ KEYVAL CHAR(2)
+);
+
+CREATE TABLE MAP_SIMPLEENUM121_STR (
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
+ VALUEVAL VARCHAR(100) NOT NULL,
+ KEYVAL CHAR(2)
+);
+
+CREATE TABLE MAP_SIMPLEENUM122_STR (
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
+ VALUEVAL VARCHAR(100) NOT NULL,
+ KEYVAL CHAR(2)
+);
+
+CREATE TABLE MAP_SIMPLEENUM124_STR (
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
+ VALUEVAL VARCHAR(100) NOT NULL,
+ KEYVAL NUMERIC(2,0)
+);
+
+CREATE TABLE MAP_SIMPLEENUM125_STR (
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
+ VALUEVAL VARCHAR(100) NOT NULL,
+ KEYVAL NUMERIC(2,0)
+);
+
+CREATE TABLE MAP_SIMPLEENUM126_STR (
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
+ VALUEVAL VARCHAR(100) NOT NULL,
+ KEYVAL NUMERIC(2,0)
+);
+
+CREATE TABLE MAP_SIMPLEENUM127_STR (
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
+ VALUEVAL VARCHAR(100) NOT NULL,
+ KEYVAL NUMERIC(2,0)
+);
+
+CREATE TABLE MAP_SIMPLEENUM128_STR (
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
+ VALUEVAL VARCHAR(100) NOT NULL,
+ KEYVAL NUMERIC(2,0)
+);
+
+CREATE TABLE MAP_SIMPLEENUM129_STR (
+ IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
+ VALUEVAL VARCHAR(100) NOT NULL,
+ KEYVAL NUMERIC(2,0)
);
--TreeMapOfStringKeyCollections
Modified: db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema1.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema1.sql?rev=591430&r1=591429&r2=591430&view=diff
==============================================================================
--- db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema1.sql (original)
+++ db/jdo/trunk/tck2/src/sql/derby/datastoreidentity/schema1.sql Fri Nov 2 12:30:50 2007
@@ -202,4 +202,91 @@
ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
(EMP_OF_THE_MONTH) REFERENCES persons(DATASTORE_IDENTITY) ON DELETE SET NULL;
+-------------------------
+-- fieldtypes (enum)
+-------------------------
+
+DROP TABLE FIELDSOFENUMORDINAL;
+
+CREATE TABLE FIELDSOFENUMORDINAL
+(
+ DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+ IDENTIFIER INTEGER,
+ ENUM0 SMALLINT,
+ ENUM1 SMALLINT,
+ ENUM102 SMALLINT,
+ ENUM103 SMALLINT,
+ ENUM104 INTEGER,
+ ENUM108 INTEGER,
+ ENUM109 INTEGER,
+ ENUM11 INTEGER,
+ ENUM110 BIGINT,
+ ENUM112 BIGINT,
+ ENUM113 BIGINT,
+ ENUM114 BIGINT,
+ ENUM119 NUMERIC(2,0),
+ ENUM12 NUMERIC(2,0),
+ ENUM120 NUMERIC(2,0),
+ ENUM121 NUMERIC(2,0),
+ ENUM124 SMALLINT,
+ ENUM125 SMALLINT,
+ ENUM126 SMALLINT,
+ ENUM128 SMALLINT,
+ ENUM129 INTEGER,
+ ENUM13 INTEGER,
+ ENUM130 INTEGER,
+ ENUM138 INTEGER,
+ ENUM139 BIGINT,
+ ENUM140 BIGINT,
+ ENUM16 BIGINT,
+ ENUM17 BIGINT,
+ ENUM18 NUMERIC(2,0),
+ ENUM2 NUMERIC(2,0),
+ ENUM20 NUMERIC(2,0),
+ ENUM21 NUMERIC(2,0),
+ ENUM22 SMALLINT,
+ ENUM30 SMALLINT,
+ ENUM31 SMALLINT,
+ ENUM32 SMALLINT,
+ ENUM36 INTEGER,
+ ENUM37 INTEGER,
+ ENUM38 INTEGER,
+ ENUM4 INTEGER,
+ ENUM40 BIGINT,
+ ENUM41 BIGINT,
+ ENUM42 BIGINT,
+ ENUM47 BIGINT,
+ ENUM48 NUMERIC(2,0),
+ ENUM49 NUMERIC(2,0),
+ ENUM5 NUMERIC(2,0),
+ ENUM52 NUMERIC(2,0),
+ ENUM53 SMALLINT,
+ ENUM54 SMALLINT,
+ ENUM56 SMALLINT,
+ ENUM57 SMALLINT,
+ ENUM58 INTEGER,
+ ENUM6 INTEGER,
+ ENUM66 INTEGER,
+ ENUM67 INTEGER,
+ ENUM68 BIGINT,
+ ENUM72 BIGINT,
+ ENUM73 BIGINT,
+ ENUM74 BIGINT,
+ ENUM76 NUMERIC(2,0),
+ ENUM77 NUMERIC(2,0),
+ ENUM78 NUMERIC(2,0),
+ ENUM83 NUMERIC(2,0),
+ ENUM84 SMALLINT,
+ ENUM85 SMALLINT,
+ ENUM88 SMALLINT,
+ ENUM89 SMALLINT,
+ ENUM90 INTEGER,
+ ENUM92 INTEGER,
+ ENUM93 INTEGER,
+ ENUM94 INTEGER
+);
+
+ALTER TABLE FIELDSOFENUMORDINAL ADD CONSTRAINT
+ FIELDSOFENUMORDINAL_PK PRIMARY KEY (DATASTORE_IDENTITY);
+
disconnect;