1*d1766043SAndrew Rist/************************************************************** 2cdf0e10cSrcweir * 3*d1766043SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*d1766043SAndrew Rist * or more contributor license agreements. See the NOTICE file 5*d1766043SAndrew Rist * distributed with this work for additional information 6*d1766043SAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*d1766043SAndrew Rist * to you under the Apache License, Version 2.0 (the 8*d1766043SAndrew Rist * "License"); you may not use this file except in compliance 9*d1766043SAndrew Rist * with the License. You may obtain a copy of the License at 10*d1766043SAndrew Rist * 11*d1766043SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12*d1766043SAndrew Rist * 13*d1766043SAndrew Rist * Unless required by applicable law or agreed to in writing, 14*d1766043SAndrew Rist * software distributed under the License is distributed on an 15*d1766043SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*d1766043SAndrew Rist * KIND, either express or implied. See the License for the 17*d1766043SAndrew Rist * specific language governing permissions and limitations 18*d1766043SAndrew Rist * under the License. 19*d1766043SAndrew Rist * 20*d1766043SAndrew Rist *************************************************************/ 21*d1766043SAndrew Rist 22*d1766043SAndrew Rist 23cdf0e10cSrcweir#ifndef __com_sun_star_sdbc_KeyRule_idl__ 24cdf0e10cSrcweir#define __com_sun_star_sdbc_KeyRule_idl__ 25cdf0e10cSrcweir 26cdf0e10cSrcweir module com { module sun { module star { module sdbc { 27cdf0e10cSrcweir 28cdf0e10cSrcweir 29cdf0e10cSrcweir/** determines the rules for foreign key constraints. 30cdf0e10cSrcweir */ 31cdf0e10cSrcweirpublished constants KeyRule 32cdf0e10cSrcweir{ 33cdf0e10cSrcweir 34cdf0e10cSrcweir /** a possible value for the column's 35cdf0e10cSrcweir <code>UPDATE_RULE</code> 36cdf0e10cSrcweir and 37cdf0e10cSrcweir <code>DELETE_RULE</code> 38cdf0e10cSrcweir in the 39cdf0e10cSrcweir <type scope="com::sun::star::sdbc">XResultSet</type> 40cdf0e10cSrcweir objects returned by the methods 41cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getImportedKeys()</member> 42cdf0e10cSrcweir , 43cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getExportedKeys()</member> 44cdf0e10cSrcweir , 45cdf0e10cSrcweir and 46cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getCrossReference()</member> 47cdf0e10cSrcweir . 48cdf0e10cSrcweir <P> 49cdf0e10cSrcweir For the column 50cdf0e10cSrcweir <code>UPDATE_RULE</code> 51cdf0e10cSrcweir , 52cdf0e10cSrcweir it indicates that 53cdf0e10cSrcweir when the primary key is updated, the foreign key (imported key) 54cdf0e10cSrcweir is changed to agree with it. 55cdf0e10cSrcweir </P> 56cdf0e10cSrcweir <P> 57cdf0e10cSrcweir For the column 58cdf0e10cSrcweir <code>DELETE_RULE</code> 59cdf0e10cSrcweir , 60cdf0e10cSrcweir it indicates that 61cdf0e10cSrcweir when the primary key is deleted, rows that imported that key 62cdf0e10cSrcweir are deleted. 63cdf0e10cSrcweir </P> 64cdf0e10cSrcweir */ 65cdf0e10cSrcweir const long CASCADE = 0; 66cdf0e10cSrcweir //------------------------------------------------------------------------- 67cdf0e10cSrcweir 68cdf0e10cSrcweir /** a possible value for the column's 69cdf0e10cSrcweir <code>UPDATE_RULE</code> 70cdf0e10cSrcweir and 71cdf0e10cSrcweir <code>DELETE_RULE</code> 72cdf0e10cSrcweir in the 73cdf0e10cSrcweir <type scope="com::sun::star::sdbc">XResultSet</type> 74cdf0e10cSrcweir objects returned by the methods 75cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getImportedKeys()</member> 76cdf0e10cSrcweir , 77cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getExportedKeys()</member> 78cdf0e10cSrcweir , 79cdf0e10cSrcweir and 80cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getCrossReference()</member> 81cdf0e10cSrcweir . 82cdf0e10cSrcweir <P> 83cdf0e10cSrcweir For the column 84cdf0e10cSrcweir <code>UPDATE_RULE</code> 85cdf0e10cSrcweir , it indicates that 86cdf0e10cSrcweir a primary key may not be updated if it has been imported by 87cdf0e10cSrcweir another table as a foreign key. 88cdf0e10cSrcweir </P> 89cdf0e10cSrcweir <P> 90cdf0e10cSrcweir For the column 91cdf0e10cSrcweir <code>DELETE_RULE</code> 92cdf0e10cSrcweir , it indicates that 93cdf0e10cSrcweir a primary key may not be deleted if it has been imported by 94cdf0e10cSrcweir another table as a foreign key. 95cdf0e10cSrcweir </P> 96cdf0e10cSrcweir */ 97cdf0e10cSrcweir const long RESTRICT = 1; 98cdf0e10cSrcweir //------------------------------------------------------------------------- 99cdf0e10cSrcweir 100cdf0e10cSrcweir /** a possible value for the column's 101cdf0e10cSrcweir <code>UPDATE_RULE</code> 102cdf0e10cSrcweir and 103cdf0e10cSrcweir <code>DELETE_RULE</code> 104cdf0e10cSrcweir in the 105cdf0e10cSrcweir <type scope="com::sun::star::sdbc">XResultSet</type> 106cdf0e10cSrcweir objects returned by the methods 107cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getImportedKeys()</member> 108cdf0e10cSrcweir , 109cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getExportedKeys()</member> 110cdf0e10cSrcweir , 111cdf0e10cSrcweir and 112cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getCrossReference()</member> 113cdf0e10cSrcweir . 114cdf0e10cSrcweir <P> 115cdf0e10cSrcweir For the columns 116cdf0e10cSrcweir <code>UPDATE_RULE</code> 117cdf0e10cSrcweir and 118cdf0e10cSrcweir <code>DELETE_RULE</code> 119cdf0e10cSrcweir , 120cdf0e10cSrcweir it indicates that 121cdf0e10cSrcweir when the primary key is updated or deleted, the foreign key (imported key) 122cdf0e10cSrcweir is changed to <code>NULL</code>. 123cdf0e10cSrcweir </P> 124cdf0e10cSrcweir */ 125cdf0e10cSrcweir const long SET_NULL = 2; 126cdf0e10cSrcweir //------------------------------------------------------------------------- 127cdf0e10cSrcweir 128cdf0e10cSrcweir /** a possible value for the column's 129cdf0e10cSrcweir <code>UPDATE_RULE</code> 130cdf0e10cSrcweir and 131cdf0e10cSrcweir <code>DELETE_RULE</code> 132cdf0e10cSrcweir in the 133cdf0e10cSrcweir <type scope="com::sun::star::sdbc">XResultSet</type> 134cdf0e10cSrcweir objects returned by the methods 135cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getImportedKeys()</member> 136cdf0e10cSrcweir , 137cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getExportedKeys()</member> 138cdf0e10cSrcweir , 139cdf0e10cSrcweir and 140cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getCrossReference()</member> 141cdf0e10cSrcweir . 142cdf0e10cSrcweir <P> 143cdf0e10cSrcweir For the columns 144cdf0e10cSrcweir <code>UPDATE_RULE</code> 145cdf0e10cSrcweir and 146cdf0e10cSrcweir <code>DELETE_RULE</code> 147cdf0e10cSrcweir , 148cdf0e10cSrcweir it indicates that if the primary key has been imported, it cannot be updated or deleted. 149cdf0e10cSrcweir </P> 150cdf0e10cSrcweir */ 151cdf0e10cSrcweir const long NO_ACTION = 3; 152cdf0e10cSrcweir //------------------------------------------------------------------------- 153cdf0e10cSrcweir 154cdf0e10cSrcweir /** a possible value for the column's 155cdf0e10cSrcweir <code>UPDATE_RULE</code> 156cdf0e10cSrcweir and 157cdf0e10cSrcweir <code>DELETE_RULE</code> 158cdf0e10cSrcweir in the 159cdf0e10cSrcweir <type scope="com::sun::star::sdbc">XResultSet</type> 160cdf0e10cSrcweir objects returned by the methods 161cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getImportedKeys()</member> 162cdf0e10cSrcweir , 163cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getExportedKeys()</member> 164cdf0e10cSrcweir , 165cdf0e10cSrcweir and 166cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XDatabaseMetaData::getCrossReference()</member> 167cdf0e10cSrcweir . 168cdf0e10cSrcweir <P> 169cdf0e10cSrcweir For the columns 170cdf0e10cSrcweir <code>UPDATE_RULE</code> 171cdf0e10cSrcweir and 172cdf0e10cSrcweir <code>DELETE_RULE</code> 173cdf0e10cSrcweir , 174cdf0e10cSrcweir it indicates that 175cdf0e10cSrcweir if the primary key is updated or deleted, the foreign key (imported key) 176cdf0e10cSrcweir is set to the default value. 177cdf0e10cSrcweir </P> 178cdf0e10cSrcweir */ 179cdf0e10cSrcweir const long SET_DEFAULT = 4; 180cdf0e10cSrcweir}; 181cdf0e10cSrcweir 182cdf0e10cSrcweir//============================================================================= 183cdf0e10cSrcweir 184cdf0e10cSrcweir}; }; }; }; 185cdf0e10cSrcweir 186cdf0e10cSrcweir/*=========================================================================== 187cdf0e10cSrcweir===========================================================================*/ 188cdf0e10cSrcweir#endif 189