create.sql

本人在工程上收集的比较常用的oracle sql语句 有问题请发email:[e-mail]

drop user dyt cascade;
create user dyt identified by sql default tablespace users;
grant dba to dyt;
connect dyt/sql;

create sequence userinfID start with 10000;
create sequence operateuserID start with 10000;

drop table msgstat;
create table msgstat(
	stime 		date,
	msgid		number(8),
	send		number(8)
);
create index msgstat_stime_idx on msgstat(stime);

create table history(
	stime 		date,
	msisdn		varchar2(20),
	vlr		number(10),
	hcity		number(3),
	vcity		number(3),
	condition 	number,
	errorCode	number(2)
);
create index history_idx on history(stime);
create index history_msisdn_idx on history(msisdn);

create table status(
     	stime      date	primary key,
     	bufmsgcount number(10),
     	total      number(10),
     	lost       number(10),
     	Empty      number(10),
     	sended     number(10),
     	fail       number(10)
);
create index status_idx on status(stime);

create table stat(
	stime 		date,
	city		number(4),
	vlrcity		number(4),
	visit 		number(12),
	send		number(12)
);
create index stat_idx on stat(stime);
create index stat_city_idx on stat(city,vlrcity);

quit;