Examples of org.hsqldb.Table.createPrimaryKey()

org.hsqldb.Table.createPrimaryKey()
Shortcut for creating default PK's.

            // false PK, as TABLE_SCHEM and/or TABLE_CAT may be null
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_COLUMNS].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                0, 1, 2, 16
            }, false);


            return t;
        }

View Full Code Here

            // may be null
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_CROSSREFERENCE].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                4, 5, 6, 8, 11
            }, false);


            return t;
        }

View Full Code Here

            // false PK, as INDEX_QUALIFIER may be null
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_INDEXINFO].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                3, 6, 5, 7, 4, 2, 1
            }, false);


            return t;
        }

View Full Code Here

            // false PK, as  TABLE_SCHEM and/or TABLE_CAT may be null
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_PRIMARYKEYS].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                3, 2, 1, 0
            }, false);


            return t;
        }

View Full Code Here

            // false PK, as PROCEDURE_SCHEM and/or PROCEDURE_CAT may be null
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_PROCEDURECOLUMNS].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                1, 2, 19, 20, 0
            }, false);


            return t;
        }

View Full Code Here

            // false PK, as PROCEDURE_SCHEM and/or PROCEDURE_CAT may be null
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_PROCEDURES].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                1, 2, 8, 0
            }, false);


            return t;
        }

View Full Code Here

            // true PK, as rows never have null TABLE_SCHEM
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_SCHEMAS].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[]{ 0 }, true);


            return t;
        }


        PersistentStore store = database.persistentStoreCollection.getStore(t);

View Full Code Here

            // false PK, as TABLE_SCHEM and/or TABLE_CAT may be null
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_TABLES].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                3, 1, 2, 0
            }, false);


            return t;
        }

View Full Code Here

            // true PK
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_TABLETYPES].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[]{ 0 }, true);


            return t;
        }


        PersistentStore store = database.persistentStoreCollection.getStore(t);

View Full Code Here

            // true PK
            HsqlName name = HsqlNameManager.newInfoSchemaObjectName(
                sysTableHsqlNames[SYSTEM_TYPEINFO].name, false,
                SchemaObject.INDEX);


            t.createPrimaryKey(name, new int[] {
                1, 18
            }, true);


            return t;
        }

View Full Code Here

0 1 2 3 4 5 6 7 8

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.