📄 dblook_test.out

📁 derby database source code.good for you.
💻 OUT
📖 第 1 页 / 共 4 页
字号:
tee""Hee<systemnumber>Ix"5trueBTREE (1 DESC)false<systemid>----"Quoted"Schema"tee""Hee<systemnumber>tee""Heefalsenullfalse<systemid>----APP"tquoteTwo<systemnumber><systemname>trueBTREE (1)true<systemid>----APP"tquoteTwo<systemnumber>"tquoteTwofalsenullfalse<systemid>----APPREMOVED<systemnumber>REMOVEDfalsenullfalse<systemid>----APPT11<systemnumber><systemname>trueBTREE (1, 2)true<systemid>----APPT11<systemnumber>T11falsenullfalse<systemid>----APPT1<systemnumber>IX1trueBTREE (4, 1)false<systemid>----APPT1<systemnumber>T1falsenullfalse<systemid>----APPT2<systemnumber>T2falsenullfalse<systemid>----APPT8T1T4<systemnumber>T8T1T4falsenullfalse<systemid>----APPX<systemnumber>Xfalsenullfalse<systemid>----APPtquote"One<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----APPtquote"One<systemnumber>tquote"Onefalsenullfalse<systemid>----APPtquoteThree"<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----APPtquoteThree"<systemnumber>tquoteThree"falsenullfalse<systemid>----BARMULTI WORD NAME<systemnumber>MULTI WORD NAMEfalsenullfalse<systemid>----BART1<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----BART1<systemnumber>T1falsenullfalse<systemid>----BART3<systemnumber>IX2trueBTREE (1 DESC, 3 DESC)false<systemid>----BART3<systemnumber>T3falsenullfalse<systemid>----BART3_2<systemnumber>T3_2falsenullfalse<systemid>----BART4<systemnumber>IX4trueUNIQUE BTREE (3)false<systemid>----BART4<systemnumber>T4falsenullfalse<systemid>----BART4_2<systemnumber>T4_2falsenullfalse<systemid>----BART8<systemnumber><systemname>trueBTREE (2)true<systemid>----BART8<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----BART8<systemnumber>T8falsenullfalse<systemid>----BARtWithKeys<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----BARtWithKeys<systemnumber>IX3trueBTREE (1 DESC)false<systemid>----BARtWithKeys<systemnumber>tWithKeysfalsenullfalse<systemid>----FOOT10<systemnumber><systemname>trueUNIQUE BTREE (2)true<systemid>----FOOT10<systemnumber><systemname>trueUNIQUE BTREE (3)true<systemid>----FOOT10<systemnumber>T10falsenullfalse<systemid>----FOOT9<systemnumber><systemname>trueBTREE (1)true<systemid>----FOOT9<systemnumber><systemname>trueUNIQUE BTREE (2, 1)true<systemid>----FOOT9<systemnumber>T9falsenullfalse<systemid>----Foo BarT5<systemnumber>CostIndextrueUNIQUE BTREE (1)false<systemid>----Foo BarT5<systemnumber>T5falsenullfalse<systemid>----Foo BarT6<systemnumber>T6falsenullfalse<systemid>----Foo BarT7<systemnumber>T7falsenullfalse<systemid>----========== SYSCONSTRAINTS =========="ck2"tquoteTwo"ck2CAPPE0----"effkay1"tquoteTwo"effkay1FAPPE0----<systemname>T10<systemname>PFOOE1----<systemname>T10<systemname>UFOOE0----<systemname>T8<systemname>FBARE0----<systemname>T8<systemname>PBARE0----<systemname>tWithKeys<systemname>CBARE0----<systemname>tWithKeys<systemname>PBARE1----NOTEVILtWithKeysNOTEVILCBARE0----<systemname>T11<systemname>FAPPE0----UNQT1UNQUBARE0----c"k1tquote"Onec"k1CAPPE0----chkOneT10chkOneCFOOE0----ck2"tquoteThree"ck2"CAPPE0----fkOneT9fkOneFFOOE0----pee"kay1tquote"Onepee"kay1PAPPE1----pkTwoT9pkTwoPFOOE1----<systemname>tee""Hee<systemname>P"Quoted"Schema"E0----unqkay1"tquoteThree"unqkay1"UAPPE0----========== SYSDEPENDS =========="effkay1<Constraint>APP."effkay1 -> <Constraint>APP.pee"kay1Constraintpee"kay1Constraint----<systemname><Constraint>APP.<sysname> -> <Constraint>FOO.pkTwoConstraintpkTwoConstraint----<systemname><Constraint>BAR.<sysname> -> <Constraint>BAR.<sysname>Constraint<systemname>Constraint----fkOne<Constraint>FOO.fkOne -> <Constraint>FOO.<sysname>Constraint<systemname>Constraint----<systemid><StoredPreparedStatement>"Quoted"Schema".<sysname> -> <Table>"Quoted"Schema".tee""HeeStoredPreparedStatementtee""HeeTable----<systemid><StoredPreparedStatement>APP.<sysname> -> <ColumnsInTable>BAR.T4StoredPreparedStatementT4ColumnsInTable----<systemid><StoredPreparedStatement>APP.<sysname> -> <ColumnsInTable>BAR.tWithKeysStoredPreparedStatementtWithKeysColumnsInTable----<systemid><StoredPreparedStatement>APP.<sysname> -> <Conglomerate>APP.<sysname>StoredPreparedStatement<systemid>Conglomerate----<systemid><StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname>StoredPreparedStatement<systemid>Conglomerate----<systemid><StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.IX3StoredPreparedStatement<systemid>Conglomerate----<systemid><StoredPreparedStatement>APP.<sysname> -> <Table>APP.REMOVEDStoredPreparedStatementREMOVEDTable----<systemid><StoredPreparedStatement>APP.<sysname> -> <Table>APP.XStoredPreparedStatementXTable----<systemid><StoredPreparedStatement>APP.<sysname> -> <Table>BAR.T3StoredPreparedStatementT3Table----<systemid><StoredPreparedStatement>APP.<sysname> -> <Table>BAR.tWithKeysStoredPreparedStatementtWithKeysTable----<systemid><StoredPreparedStatement>BAR.<sysname> -> <Table>BAR.T8StoredPreparedStatementT8Table----<systemid><StoredPreparedStatement>Foo Bar.<sysname> -> <Table>BAR.T1StoredPreparedStatementT1Table----<systemid><Trigger>"Quoted"Schema"."trig"One" -> <StoredPreparedStatement>"Quoted"Schema".<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>"Quoted"Schema"."trig"One" -> <Table>"Quoted"Schema".tee""HeeTriggertee""HeeTable----<systemid><Trigger>APP.TRIGFOUR -> <StoredPreparedStatement>APP.<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>APP.TRIGFOUR -> <Table>APP.XTriggerXTable----<systemid><Trigger>APP.TRIGONE -> <StoredPreparedStatement>APP.<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>APP.TRIGONE -> <Table>BAR.T3TriggerT3Table----<systemid><Trigger>APP.TrigThree -> <StoredPreparedStatement>APP.<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>APP.TrigThree -> <Table>BAR.tWithKeysTriggertWithKeysTable----<systemid><Trigger>BAR.REFTRIG -> <StoredPreparedStatement>BAR.<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>BAR.REFTRIG -> <Table>BAR.T8TriggerT8Table----<systemid><Trigger>Foo Bar.TRIG2 -> <StoredPreparedStatement>Foo Bar.<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>Foo Bar.TRIG2 -> <Table>BAR.T1TriggerT1Table----V1<View>APP.V1 -> <ColumnsInTable>APP.T1ViewT1ColumnsInTable----V1<View>APP.V1 -> <ColumnsInTable>BAR.T3ViewT3ColumnsInTable----V2<View>APP.V2 -> <ColumnsInTable>BAR.T1ViewT1ColumnsInTable----viewTwo<View>BAR.viewTwo -> <ColumnsInTable>APP.T11ViewT11ColumnsInTable----V1<View>FOO.V1 -> <ColumnsInTable>Foo Bar.T6ViewT6ColumnsInTable----========== SYSFILES ==========<systemid>FOOFOOJAR<systemnumber>----========== SYSFOREIGNKEYS ==========<systemname><systemid><systemname>UR----"effkay1<systemid>pee"kay1RR----fkOne<systemid><systemname>RS----<systemname><systemid>pkTwoRR----========== SYSKEYS ==========<systemname><systemid>----<systemname><systemid>----<systemname><systemid>----<systemname><systemid>----<systemname><systemid>----UNQ<systemid>----pee"kay1<systemid>----pkTwo<systemid>----unqkay1"<systemid>----========== SYSSCHEMAS =========="Quoted"Schema""Quoted"Schema"APP----APPAPPAPP----BARBARAPP----FOOFOOAPP----Foo BarFoo BarAPP----========== SYSSTATEMENTS ==========<systemid><systemname>APPT<validityflag>insert into removed select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLD  where x not in (select x from new org.apache.derby.catalog.TriggerNewTransitionRows() NEW  where x < 10)<systemid>APPnull----<systemid><systemname>APPT<validityflag>select c from bar."tWithKeys"<systemid>APPnull----<systemid><systemname>APPT<validityflag>update bar.t4 set j=8 where i=2<systemid>APPnull----<systemid><systemname>"Quoted"Schema"T<validityflag>values(8)<systemid>APPnull----<systemid><systemname>BART<validityflag>select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLDTABLE <systemid>APPnull----<systemid><systemname>Foo BarT<validityflag>values (1), (2)<systemid>APPnull----========== SYSTABLES =========="tquoteTwo"tquoteTwoTAPPR----MULTI WORD NAMEMULTI WORD NAMETBARR----REMOVEDREMOVEDTAPPR----SYNONYM1SYNONYM1AAPPR----SYNONYM2SYNONYM2ABARR----SYNONYM3SYNONYM3ABARR----T10T10TFOOR----T11T11TAPPR----T1T1TAPPR----T1T1TBARR----T2T2TAPPR----T3T3TBARR----T3_2T3_2TBARR----T4T4TBARR----T4_2T4_2TBARR----T5T5TFoo BarR----T6T6TFoo BarR----T7T7TFoo BarR----T8T1T4T8T1T4TAPPR----T8T8TBARR----T9T9TFOOR----V"3V"3VAPPR----V1V1VAPPR----V1V1VFOOR----V2V2VAPPR----XXTAPPR----tWithKeystWithKeysTBARR----tee""Heetee""HeeT"Quoted"Schema"R----tquote"Onetquote"OneTAPPR----tquoteThree"tquoteThree"TAPPR----viewTwoviewTwoVBARR----========== SYSTRIGGERS ==========<systemid>"trig"One""Quoted"Schema"<systemid>IAREtee""Heenull<systemid>nullvalues(8)falsefalsenullnull----<systemid>REFTRIGBAR<systemid>DASET8null<systemid>nullselect * from oldtabletruefalseOLDTABLEnull----<systemid>TRIG2Foo Bar<systemid>DBSET1null<systemid>nullvalues (1), (2)falsefalsenullnull----<systemid>TRIGFOURAPP<systemid>UASEXnull<systemid>(1)insert into removed select * from old where x not in (select x from new where x < 10)truetrueOLDNEW----<systemid>TRIGONEAPP<systemid>IARET3null<systemid>nullupdate bar.t4 set j=8 where i=2falsefalsenullnull----<systemid>TrigThreeAPP<systemid>UAREtWithKeysnull<systemid>(1,2)select c from bar."tWithKeys"falsefalsenullnull----========== SYSVIEWS ==========V"3create view "V""3"(i) as values (8), (28), (78)NAPP----V1create view v1 (dum, dee, dokie) as select a.d, a.c, b.p1 from t1 as a, bar.t3 as bNAPP----V1create view v1 (doo, dwa) as select num, letter from "Foo Bar".t6NFOO----V2create view v2 as select * from bar.t1NAPP----viewTwocreate view bar."viewTwo" as select * from app.t11NAPP----Database 'wombat_new' deleted.--*******************************************Dumping DDL for all objects with schema'BAR', excluding views:*******************************************File dblook.log was empty.Creating database 'wombat_new' from ddl script 'wombat.sql'Dumping system tables for 'wombat_new'----------------=================---------------System Tables for: wombat_new----------------=================---------------========== SYSALIASES ==========<systemid>OP4BARorg.apache.derbyTesting.functionTests.util.ProcedureTestPPfalseinoutparams4(OUT A DECIMAL(4,2),IN B VARCHAR(255)) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA<systemname>----<systemid>SYNONYM2BARnullSSfalse"BAR"."MULTI WORD NAME"<systemname>----<systemid>SYNONYM3BARnullSSfalse"APP"."T11"<systemname>----========== SYSCHECKS ==========<systemname>(i > 0)(2)----NOTEVIL(vc != 'evil')(3)----========== SYSCOLUMNS ==========--- Columns for Tables ---MULTI WORD NAMEC1CHAR(2)nullnull<autoincval>nullnull----T1C2CLOB(15)nullnull<autoincval>nullnull----T1P11VARCHAR(10) NOT NULLnullnull<autoincval>nullnull----T3B2BLOB(20)nullnull<autoincval>nullnull----T3ID3INTEGER NOT NULLnullnull<autoincval>24----T3P11VARCHAR(10)'okie'<systemid><autoincval>nullnull----T3_2B2BLOB(20)nullnull<autoincval>nullnull----T3_2ID3INTEGER NOT NULLGENERATED_BY_DEFAULT<systemid><autoincval>24----T3_2P11VARCHAR(10)'okie'<systemid><autoincval>nullnull----T4I1INTEGER2<systemid><autoincval>nullnull----T4J2INTEGER NOT NULLnullnull<autoincval>nullnull----T4K3
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -