home *** CD-ROM | disk | FTP | other *** search
/ Oracle Video Server 3.0.3.1 / OVS_3031_NT.iso / win32 / tracesvr / otrcfmtc.sql < prev    next >
Encoding:
Text File  |  1996-08-23  |  2.4 KB  |  92 lines
  1. rem Create tables for Oracle
  2.  
  3.  
  4. create sequence epc_collection_id increment by 1 start with 1;
  5.  
  6. create table epc_collection
  7.        (
  8.     collection_id number(4) CONSTRAINT epc_pk_coll_rec PRIMARY KEY, 
  9.     collection_name varchar2(255),
  10.     start_time date,
  11.     end_time date,
  12.     scheduled_by    varchar2(8),
  13.     ms_granularity number);
  14.  
  15. create table epc_process
  16.     (collection_id number(4) CONSTRAINT fk_proc_id REFERENCES
  17.                epc_collection (collection_id) on delete cascade,
  18.     epid number(9) ,
  19.     username varchar2(8),
  20.     cpu_type varchar2(32),
  21.     os_ver  varchar2(32),
  22.     nodename varchar2(64),
  23.     time     date,
  24.     time_nano number,
  25.     end_time date,
  26.     end_time_nano number);
  27.  
  28. create table epc_facility
  29. (   
  30.   CONSTRAINT epc_pk_fac_num PRIMARY KEY (vendor, facility_number, 
  31.                      facility_version, class_name),
  32.   vendor number(9),
  33.   facility_number number(4), 
  34.   facility_name varchar2(20),
  35.   facility_version varchar2(11),
  36.   class_name varchar2(20));
  37.  
  38.  
  39. create table epc_event
  40. (   
  41.   CONSTRAINT epc_pk_eve_rec PRIMARY KEY (vendor, facility_number, 
  42.                      facility_version, event_number),
  43.   vendor number(9),
  44.   facility_number number(4), 
  45.   facility_version varchar2(11),
  46.   event_number number (4),
  47.   event_name varchar2(16),
  48.   event_header varchar2(16),
  49.   event_table_name varchar2(30));
  50.  
  51. create table epc_item
  52. (   
  53.   CONSTRAINT epc_pk_ite_rec PRIMARY KEY (vendor, facility_number, 
  54.                      facility_version, item_number),
  55.   vendor number(9),
  56.   facility_number number(4), 
  57.   facility_version varchar2(11),
  58.   item_number number (4),
  59.   item_name varchar2(16),
  60.   item_header varchar2(16),
  61.   item_width number,
  62.   item_size number,
  63.   item_char number);
  64.  
  65. create table epc_event_item
  66. (   
  67.   CONSTRAINT epc_pk_eveite_rec PRIMARY KEY (vendor, facility_number,
  68.                         facility_version, event_number,
  69.                         event_type, item_number, 
  70.                         item_position),
  71.   vendor number(9),
  72.   facility_number number(4), 
  73.   facility_version varchar2(11),
  74.   event_number number(4), 
  75.   event_type number(2),
  76.   item_number number(4),
  77.   item_position number);
  78.  
  79. create table epc_facility_registration
  80. (
  81. collection_id number(4) CONSTRAINT fk_fac_reg_id REFERENCES
  82.           epc_collection (collection_id) on delete cascade,
  83. epid number(8),
  84. timestamp date,
  85. timestamp_nano number,
  86. reg_id_string varchar2(256),
  87. vendor number(9),
  88. facility_number number(4),
  89. facility_version varchar2(11));
  90.  
  91. commit;
  92.