createschema.sql

Sun公司Dream项目

create table mastersubscribers (
masterid	integer NOT NULL,
login	varchar(16),
pin	varchar(16),
firstname	varchar(32),
lastname	varchar(32),
address	varchar(64),
city	varchar(32),
zip	varchar(16),
email	varchar(32),
phone	varchar(16),
simcardnum	varchar(32)
);
	
create table subsubscribers (
masterid 	integer,
id	integer NOT NULL,
login	varchar(16),
pin	varchar(16),
firstname	varchar(32),
lastname	varchar(32),
simcardnum	varchar(32)
);	
	
create table ratings (
id	integer NOT NULL,
name	varchar(16),
descr	varchar(255)
);	
	
create table moviegenres (
id	integer NOT NULL,
genre	varchar(32),
assetcount	integer
);	
	
create table moviecatalog (	
id	number NOT NULL,
lysisid	varchar(32),
fulltitle	varchar(255),
origtitle	varchar(255),
shorttitle	varchar(255),
shortdescr	varchar(255),
longdescr	varchar(255),
version	integer,
genre	integer,
prodcompany	varchar(255),
proddate	date,
releasedate	varchar(32),
country	varchar(32),
screenformat	integer,
showing	varchar(32),
boxofficerating	integer,
parentrating	integer,
duration	integer,
color	integer,
stereo	integer,
surround	integer,
dolby	integer,
dvbcontent	varchar(255),
startdate	date,
enddate	date,
stdprice	number,
minprice	number,
movieurl	varchar(255),
posterurl	varchar(255),
cas	integer,
extracol1	integer,
cid	varchar(32)
);	
	
create table moviedetail (	
movieid	number NOT NULL,
detailtype	integer,
detail	varchar(255)
);	
	
create table subscrstb (
id	varchar(32) NOT NULL,
subscrid	integer,
type	integer,
macaddress	varchar(17),
ipaddress	varchar(15),
regionalhe	varchar(32)
);	
	
create table stbtypes (
id	integer NOT NULL,
brand	varchar(32),
type	varchar(32)
);	
	
create table subscrsessions (
id	number NOT NULL,
subscrid	integer,
starttimest	timestamp,
lastactivityts	timestamp,
currentmovieid	number,
bookmark	varchar(255)
);	
	
create table subscracct (	
subscrid	integer NOT NULL,
balance	number
);	
	
create table billingcdr (
subscrid	integer,
movieid	number,
purchasedate	timestamp,
movieprice	number
);	
	
create table subscrgenres (	
genreid	integer,
subscrid	integer NOT NULL
);	
	
create table subscrentals (	
movieid	number,
subscrid	integer,
starttimest	timestamp,
elapsedviewtime	number,
bookmark	varchar(255)
);	
	
create table auditlog (
timest	timestamp,
subscrid	integer NOT NULL,
action	varchar(255),
params	varchar(255),
errorstatus	varchar(255)
);	
	
create table qamresources (
cpeid	varchar(32),
qamip	varchar(32),
qamport	integer,
tsid	varchar(8),
rfchannel	varchar(8),
timest	timestamp,
free	integer
);	
	
create table movieurls (	
id 	integer,
serverip 	varchar(32),
port 	integer,
rtsppath 	varchar(32)
);	
	
create table rtspsessions (	
userid 	number(38),
movieid	varchar2(255),
timest	timestamp(6),
smpte	varchar2(43)
);	
	
create table opera_license_info (	
rightskey	varchar(30) not null primary key,
licensetype	integer,
userid 	varchar(30) not null,
shopid 	varchar(30) not null,
contentid 	varchar(30) not null,
total 	integer not null,
remaining 	integer not null,
starttime 	timestamp,
endtime 	timestamp
);	
	
create table rights_info (
verbname varchar(30) not null,
verbargname varchar(30) not null,
verbargval varchar(256) not null,
rightskey varchar(30) not null
);
	
create table movie_metadata (	
movieid 	integer,
creationdata 	varchar(32),
language 	varchar(32),
country 	varchar(32),
contentlocation 	varchar(32),
datatype 	varchar(32),
resolution 	varchar(32),
bitrate 	varchar(32),
mimetype 	varchar(32),
drmtype 	varchar(32)
);

create table ipresourcesvod (
slotnum	number(38),
cpeid	varchar2(32),
serverip	varchar2(32),
timest	timestamp,
free	number(38)
);

create table maxidvalues (
maxuserid	integer
);

create table fairuse_urls (
contentid varchar2(255),
url	varchar2(255)
);