File: migrate-oracle-schema-to-3-0-0.sql

package info (click to toggle)
dpm-postgres 1.7.4.7-1
  • links: PTS, VCS
  • area: main
  • in suites: squeeze
  • size: 13,788 kB
  • ctags: 10,782
  • sloc: ansic: 146,136; sh: 13,362; perl: 11,142; python: 5,529; cpp: 5,113; sql: 1,790; makefile: 955; fortran: 113
file content (9 lines) | stat: -rw-r--r-- 389 bytes parent folder | download | duplicates (8) 
1
2
3
4
5
6
7
8
9
 
ALTER TABLE Cns_file_metadata MODIFY name VARCHAR2(255);
ALTER TABLE Cns_file_replica ADD ctime NUMBER(10);
ALTER TABLE Cns_file_replica ADD ltime NUMBER(10);
ALTER TABLE Cns_file_replica ADD r_type CHAR(1);
ALTER TABLE Cns_file_replica ADD setname VARCHAR2(36);
CREATE INDEX replica_host ON Cns_file_replica(host);

DELETE FROM schema_version;
INSERT INTO schema_version VALUES(3, 0, 0);