specjplans.out

derby database source code.good for you.

select c1 from t1
Parse Time: 0
Bind Time: 0
Optimize Time: 0
Generate Time: 0
Compile Time: 0
Execute Time: 0
Begin Compilation Timestamp : null
End Compilation Timestamp : null
Begin Execution Timestamp : null
End Execution Timestamp : null
Statement Execution Plan Text: 
Index Scan ResultSet for T1 using index I11 at read committed isolation level using instantaneous share row locking chosen by the optimizer
Number of opens = 1
Rows seen = 0
Rows filtered = 0
Fetch Size = 16
	constructor time (milliseconds) = 0
	open time (milliseconds) = 0
	next time (milliseconds) = 0
	close time (milliseconds) = 0
scan information: 
	Bit set of columns fetched={0}
	Number of columns fetched=1
	Number of deleted rows visited=0
	Number of pages visited=1
	Number of rows qualified=0
	Number of rows visited=0
	Scan type=btree
	Tree height=1
	start position: 
	None
	stop position: 
	None
	qualifiers:
None
ij> drop table t1;
0 rows inserted/updated/deleted
ij> -- end of something light...
DROP TABLE C_customer;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C_CUSTOMER' because it does not exist.
ij> CREATE TABLE C_customer
(
	c_id		integer not null,
	c_first		char(16),
	c_last		char(16),
	c_street1	char(20),	
	c_street2	char(20),	
	c_city		char(20),	
	c_state		char(2),	
	c_country	char(10),	
	c_zip		char(9),	
	c_phone		char(16),
	c_contact	char(25),	
	c_since		date,
	c_balance	numeric(9,2),
	c_credit	char(2),
	c_credit_limit	numeric(9,2),
	c_ytd_payment	numeric(9,2)
);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX C_c_idx ON C_customer (c_id);
0 rows inserted/updated/deleted
ij> DROP TABLE C_supplier;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C_SUPPLIER' because it does not exist.
ij> CREATE TABLE C_supplier
(
	supp_id			integer not null,
	supp_name		char(16),
	supp_street1	char(20),	
	supp_street2	char(20),	
	supp_city		char(20),	
	supp_state		char(2),	
	supp_country	char(10),	
	supp_zip		char(9),	
	supp_phone		char(16),
	supp_contact	char(25)
);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX C_supp_idx ON C_supplier (supp_id);
0 rows inserted/updated/deleted
ij> DROP TABLE C_site;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C_SITE' because it does not exist.
ij> CREATE TABLE C_site
(
	site_id			integer not null,
	site_name		char(16),
	site_street1	char(20),	
	site_street2	char(20),	
	site_city		char(20),	
	site_state		char(2),	
	site_country	char(10),	
	site_zip		char(9)
);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX C_site_idx ON C_site (site_id);
0 rows inserted/updated/deleted
ij> DROP TABLE C_parts;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C_PARTS' because it does not exist.
ij> CREATE TABLE C_parts
(
	p_id			char(15) not null,
	p_name			char(10),
	p_desc			varchar(100),
	p_rev			char(6),
	p_unit			char(10),
	p_cost			numeric(9,2),
	p_price			numeric(9,2),
	p_planner		integer,
	p_type			integer,
	p_ind			integer,
        p_lomark                integer,
        p_himark                integer
);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX C_p_idx ON C_parts (p_id);
0 rows inserted/updated/deleted
ij> DROP TABLE C_rule;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C_RULE' because it does not exist.
ij> CREATE TABLE C_rule
(
	r_id		varchar(20) not null,
	r_text		long varchar
);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX C_r_idx on C_rule (r_id);
0 rows inserted/updated/deleted
ij> DROP TABLE C_discount;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C_DISCOUNT' because it does not exist.
ij> CREATE TABLE C_discount
(	
	d_id		varchar(64) not null,
	d_percent	integer
);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX C_d_idx on C_discount (d_id);
0 rows inserted/updated/deleted
ij> DROP TABLE M_parts;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'M_PARTS' because it does not exist.
ij> CREATE TABLE M_parts
(
	p_id			char(15) not null,
	p_name			char(10),
	p_desc			varchar(100),
	p_rev			char(6),
	p_planner		integer,
	p_type			integer,
	p_ind			integer,
	p_lomark		integer,
	p_himark		integer
);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX M_parts_idx ON M_parts (p_id);
0 rows inserted/updated/deleted
ij> DROP TABLE M_bom;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'M_BOM' because it does not exist.
ij> CREATE TABLE M_bom
(
	b_comp_id		char(15) not null,
	b_assembly_id		char(15) not null,
	b_line_no		integer,
	b_qty			integer,
	b_ops			integer,	
	b_eng_change		char(10),	
	b_ops_desc		varchar(100)
);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX M_bom_idx ON M_bom (b_assembly_id, b_comp_id, b_line_no);
0 rows inserted/updated/deleted
ij> DROP TABLE M_workorder;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'M_WORKORDER' because it does not exist.
ij> CREATE TABLE M_workorder
(
	wo_number		integer not null,
	wo_o_id			integer,
	wo_ol_id		integer,
	wo_status		integer,
	wo_assembly_id	char(15),
	wo_orig_qty		integer,
	wo_comp_qty		integer,
	wo_due_date		date,
	wo_start_date		timestamp
);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX M_wo_idx ON M_workorder (wo_number);
0 rows inserted/updated/deleted
ij> DROP TABLE M_largeorder;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'M_LARGEORDER' because it does not exist.
ij> CREATE TABLE M_largeorder
(
	lo_id			integer not null,
	lo_o_id			integer,
	lo_ol_id		integer,
	lo_assembly_id	char(15),
	lo_qty			integer,
	lo_due_date		date
);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX M_lo_idx ON M_largeorder (lo_id);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX M_OL_O_idx ON M_largeorder (lo_o_id, lo_ol_id);
0 rows inserted/updated/deleted
ij> DROP TABLE M_inventory;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'M_INVENTORY' because it does not exist.
ij> CREATE TABLE M_inventory
(
	in_p_id			char(15) not null,
	in_qty			integer,
	in_ordered		integer,
	in_location		char(20),	
	in_acc_code		integer,
	in_act_date		date
);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX M_inv_idx ON M_inventory (in_p_id);
0 rows inserted/updated/deleted
ij> DROP TABLE O_customer;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'O_CUSTOMER' because it does not exist.
ij> CREATE TABLE O_customer
(
	c_id		integer not null,
	c_first		char(16),
	c_last		char(16),
	c_street1	char(20),	
	c_street2	char(20),	
	c_city		char(20),	
	c_state		char(2),	
	c_country	char(10),	
	c_zip		char(9),	
	c_phone		char(16),
	c_contact	char(25),
	c_since		date
);
0 rows inserted/updated/deleted
ij> CREATE UNIQUE INDEX O_c_idx ON O_customer (c_id);
0 rows inserted/updated/deleted
ij> DROP TABLE O_orders;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'O_ORDERS' because it does not exist.
ij> CREATE TABLE O_orders
(
	o_id		integer not null,
	o_c_id		integer,
	o_ol_cnt	integer,
	o_discount	numeric(4,2),
	o_total		numeric(9,2),
	o_status	integer,