create.sql

b树实现源码,linux和unix下运行,速度快,极好用

create table t1 (f1 int primary key, f2 int);
insert into t1 values(1,11);
insert into t1 values(2,21);
insert into t1 values(3,31);
insert into t1 values(4,41);
insert into t1 values(5,51);
insert into t1 values(6,61);
insert into t1 values(7,71);
insert into t1 values(8,81);
insert into t1 values(9,91);
insert into t1 values(10,101);
create table t2 (f1 int primary key, f2 int);
insert into t2 values(1,11);
insert into t2 values(2,21);
insert into t2 values(3,31);
insert into t2 values(4,41);
insert into t2 values(5,51);
insert into t2 values(6,61);
insert into t2 values(7,71);
insert into t2 values(8,81);
insert into t2 values(9,91);
insert into t2 values(10,101);
create table t3 (f1 int primary key, f2 int);
insert into t3 values(1,11);
insert into t3 values(2,21);
insert into t3 values(3,31);
insert into t3 values(4,41);
insert into t3 values(5,51);
insert into t3 values(6,61);
insert into t3 values(7,71);
insert into t3 values(8,81);
insert into t3 values(9,91);
insert into t3 values(10,101);
create table t4 (f1 int primary key, f2 int);
insert into t4 values(1,11);
insert into t4 values(2,21);
insert into t4 values(3,31);
insert into t4 values(4,41);
insert into t4 values(5,51);
insert into t4 values(6,61);
insert into t4 values(7,71);
insert into t4 values(8,81);
insert into t4 values(9,91);
insert into t4 values(10,101);
create table t5 (f1 int primary key, f2 int);
insert into t5 values(1,11);
insert into t5 values(2,21);
insert into t5 values(3,31);
insert into t5 values(4,41);
insert into t5 values(5,51);
insert into t5 values(6,61);
insert into t5 values(7,71);
insert into t5 values(8,81);
insert into t5 values(9,91);
insert into t5 values(10,101);
create table t6 (f1 int primary key, f2 int);
insert into t6 values(1,11);
insert into t6 values(2,21);
insert into t6 values(3,31);
insert into t6 values(4,41);
insert into t6 values(5,51);
insert into t6 values(6,61);
insert into t6 values(7,71);
insert into t6 values(8,81);
insert into t6 values(9,91);
insert into t6 values(10,101);
create table t7 (f1 int primary key, f2 int);
insert into t7 values(1,11);
insert into t7 values(2,21);
insert into t7 values(3,31);
insert into t7 values(4,41);
insert into t7 values(5,51);
insert into t7 values(6,61);
insert into t7 values(7,71);
insert into t7 values(8,81);
insert into t7 values(9,91);
insert into t7 values(10,101);
create table t8 (f1 int primary key, f2 int);
insert into t8 values(1,11);
insert into t8 values(2,21);
insert into t8 values(3,31);
insert into t8 values(4,41);
insert into t8 values(5,51);
insert into t8 values(6,61);
insert into t8 values(7,71);
insert into t8 values(8,81);
insert into t8 values(9,91);
insert into t8 values(10,101);
create table t9 (f1 int primary key, f2 int);
insert into t9 values(1,11);
insert into t9 values(2,21);
insert into t9 values(3,31);
insert into t9 values(4,41);
insert into t9 values(5,51);
insert into t9 values(6,61);
insert into t9 values(7,71);
insert into t9 values(8,81);
insert into t9 values(9,91);
insert into t9 values(10,101);
create table t10 (f1 int primary key, f2 int);
insert into t10 values(1,11);
insert into t10 values(2,21);
insert into t10 values(3,31);
insert into t10 values(4,41);
insert into t10 values(5,51);
insert into t10 values(6,61);
insert into t10 values(7,71);
insert into t10 values(8,81);
insert into t10 values(9,91);
insert into t10 values(10,101);
create table t11 (f1 int primary key, f2 int);
insert into t11 values(1,11);
insert into t11 values(2,21);
insert into t11 values(3,31);
insert into t11 values(4,41);
insert into t11 values(5,51);
insert into t11 values(6,61);
insert into t11 values(7,71);
insert into t11 values(8,81);
insert into t11 values(9,91);
insert into t11 values(10,101);
create table t12 (f1 int primary key, f2 int);
insert into t12 values(1,11);
insert into t12 values(2,21);
insert into t12 values(3,31);
insert into t12 values(4,41);
insert into t12 values(5,51);
insert into t12 values(6,61);
insert into t12 values(7,71);
insert into t12 values(8,81);
insert into t12 values(9,91);
insert into t12 values(10,101);
create table t13 (f1 int primary key, f2 int);
insert into t13 values(1,11);
insert into t13 values(2,21);
insert into t13 values(3,31);
insert into t13 values(4,41);
insert into t13 values(5,51);
insert into t13 values(6,61);
insert into t13 values(7,71);
insert into t13 values(8,81);
insert into t13 values(9,91);
insert into t13 values(10,101);
create table t14 (f1 int primary key, f2 int);
insert into t14 values(1,11);
insert into t14 values(2,21);
insert into t14 values(3,31);
insert into t14 values(4,41);
insert into t14 values(5,51);
insert into t14 values(6,61);
insert into t14 values(7,71);
insert into t14 values(8,81);
insert into t14 values(9,91);
insert into t14 values(10,101);
create table t15 (f1 int primary key, f2 int);
insert into t15 values(1,11);
insert into t15 values(2,21);
insert into t15 values(3,31);
insert into t15 values(4,41);
insert into t15 values(5,51);
insert into t15 values(6,61);
insert into t15 values(7,71);
insert into t15 values(8,81);
insert into t15 values(9,91);
insert into t15 values(10,101);
create table t16 (f1 int primary key, f2 int);
insert into t16 values(1,11);
insert into t16 values(2,21);
insert into t16 values(3,31);
insert into t16 values(4,41);
insert into t16 values(5,51);
insert into t16 values(6,61);
insert into t16 values(7,71);
insert into t16 values(8,81);
insert into t16 values(9,91);
insert into t16 values(10,101);
create table t17 (f1 int primary key, f2 int);
insert into t17 values(1,11);
insert into t17 values(2,21);
insert into t17 values(3,31);
insert into t17 values(4,41);
insert into t17 values(5,51);
insert into t17 values(6,61);
insert into t17 values(7,71);
insert into t17 values(8,81);
insert into t17 values(9,91);
insert into t17 values(10,101);
create table t18 (f1 int primary key, f2 int);
insert into t18 values(1,11);
insert into t18 values(2,21);
insert into t18 values(3,31);
insert into t18 values(4,41);
insert into t18 values(5,51);
insert into t18 values(6,61);
insert into t18 values(7,71);
insert into t18 values(8,81);
insert into t18 values(9,91);
insert into t18 values(10,101);
create table t19 (f1 int primary key, f2 int);
insert into t19 values(1,11);
insert into t19 values(2,21);
insert into t19 values(3,31);
insert into t19 values(4,41);
insert into t19 values(5,51);
insert into t19 values(6,61);
insert into t19 values(7,71);
insert into t19 values(8,81);
insert into t19 values(9,91);
insert into t19 values(10,101);
create table t20 (f1 int primary key, f2 int);
insert into t20 values(1,11);
insert into t20 values(2,21);
insert into t20 values(3,31);
insert into t20 values(4,41);
insert into t20 values(5,51);
insert into t20 values(6,61);
insert into t20 values(7,71);
insert into t20 values(8,81);
insert into t20 values(9,91);
insert into t20 values(10,101);
create table t21 (f1 int primary key, f2 int);
insert into t21 values(1,11);
insert into t21 values(2,21);
insert into t21 values(3,31);
insert into t21 values(4,41);
insert into t21 values(5,51);
insert into t21 values(6,61);
insert into t21 values(7,71);
insert into t21 values(8,81);
insert into t21 values(9,91);
insert into t21 values(10,101);
create table t22 (f1 int primary key, f2 int);
insert into t22 values(1,11);
insert into t22 values(2,21);
insert into t22 values(3,31);
insert into t22 values(4,41);
insert into t22 values(5,51);
insert into t22 values(6,61);
insert into t22 values(7,71);
insert into t22 values(8,81);
insert into t22 values(9,91);
insert into t22 values(10,101);
create table t23 (f1 int primary key, f2 int);
insert into t23 values(1,11);
insert into t23 values(2,21);
insert into t23 values(3,31);
insert into t23 values(4,41);
insert into t23 values(5,51);
insert into t23 values(6,61);
insert into t23 values(7,71);
insert into t23 values(8,81);
insert into t23 values(9,91);
insert into t23 values(10,101);
create table t24 (f1 int primary key, f2 int);
insert into t24 values(1,11);
insert into t24 values(2,21);
insert into t24 values(3,31);
insert into t24 values(4,41);
insert into t24 values(5,51);
insert into t24 values(6,61);
insert into t24 values(7,71);
insert into t24 values(8,81);
insert into t24 values(9,91);
insert into t24 values(10,101);
create table t25 (f1 int primary key, f2 int);
insert into t25 values(1,11);
insert into t25 values(2,21);
insert into t25 values(3,31);
insert into t25 values(4,41);
insert into t25 values(5,51);
insert into t25 values(6,61);
insert into t25 values(7,71);
insert into t25 values(8,81);
insert into t25 values(9,91);
insert into t25 values(10,101);
create table t26 (f1 int primary key, f2 int);
insert into t26 values(1,11);
insert into t26 values(2,21);
insert into t26 values(3,31);
insert into t26 values(4,41);
insert into t26 values(5,51);
insert into t26 values(6,61);
insert into t26 values(7,71);
insert into t26 values(8,81);
insert into t26 values(9,91);
insert into t26 values(10,101);
create table t27 (f1 int primary key, f2 int);
insert into t27 values(1,11);
insert into t27 values(2,21);
insert into t27 values(3,31);
insert into t27 values(4,41);
insert into t27 values(5,51);
insert into t27 values(6,61);
insert into t27 values(7,71);
insert into t27 values(8,81);
insert into t27 values(9,91);
insert into t27 values(10,101);
create table t28 (f1 int primary key, f2 int);
insert into t28 values(1,11);
insert into t28 values(2,21);
insert into t28 values(3,31);
insert into t28 values(4,41);
insert into t28 values(5,51);
insert into t28 values(6,61);
insert into t28 values(7,71);
insert into t28 values(8,81);
insert into t28 values(9,91);
insert into t28 values(10,101);
create table t29 (f1 int primary key, f2 int);
insert into t29 values(1,11);
insert into t29 values(2,21);
insert into t29 values(3,31);
insert into t29 values(4,41);
insert into t29 values(5,51);
insert into t29 values(6,61);
insert into t29 values(7,71);
insert into t29 values(8,81);
insert into t29 values(9,91);
insert into t29 values(10,101);
create table t30 (f1 int primary key, f2 int);
insert into t30 values(1,11);
insert into t30 values(2,21);
insert into t30 values(3,31);
insert into t30 values(4,41);
insert into t30 values(5,51);
insert into t30 values(6,61);
insert into t30 values(7,71);
insert into t30 values(8,81);
insert into t30 values(9,91);
insert into t30 values(10,101);
create table t31 (f1 int primary key, f2 int);
insert into t31 values(1,11);
insert into t31 values(2,21);
insert into t31 values(3,31);
insert into t31 values(4,41);
insert into t31 values(5,51);
insert into t31 values(6,61);
insert into t31 values(7,71);
insert into t31 values(8,81);
insert into t31 values(9,91);
insert into t31 values(10,101);
create table t32 (f1 int primary key, f2 int);
insert into t32 values(1,11);
insert into t32 values(2,21);
insert into t32 values(3,31);
insert into t32 values(4,41);
insert into t32 values(5,51);
insert into t32 values(6,61);
insert into t32 values(7,71);
insert into t32 values(8,81);
insert into t32 values(9,91);
insert into t32 values(10,101);
create table t33 (f1 int primary key, f2 int);
insert into t33 values(1,11);
insert into t33 values(2,21);
insert into t33 values(3,31);
insert into t33 values(4,41);
insert into t33 values(5,51);
insert into t33 values(6,61);
insert into t33 values(7,71);
insert into t33 values(8,81);
insert into t33 values(9,91);
insert into t33 values(10,101);
create table t34 (f1 int primary key, f2 int);
insert into t34 values(1,11);
insert into t34 values(2,21);
insert into t34 values(3,31);