-- Oracle specific configuration script
Create Table %SCHEMA%SchemaVersion (Version Number) %TABLESPACE%;
Insert Into %SCHEMA%SchemaVersion (Version) Values (3);
Grant Select On %SCHEMA%SchemaVersion To Public;
Create Table %SCHEMA%SessionLog (Id Number Not Null,
Command nvarchar2(32),
StartTime Timestamp,
EndTime Timestamp,
Hostname nvarchar2(256),
Username nvarchar2(256),
SessionId varchar(32),
VirtRepos nvarchar2(256),
PhysRepos nvarchar2(256),
Client varchar(64),
FinalReturnCode Number,
CONSTRAINT SessionLog PRIMARY KEY(Id)) %TABLESPACE%;
Grant Select, Insert On %SCHEMA%SessionLog To Public;
Create Sequence %SCHEMA%SessionLog_sequence
Start with 1
Increment by 1
Nomaxvalue
Nocache
Noorder;
Grant Select On %SCHEMA%SessionLog_sequence To Public;
Create or Replace Trigger %SCHEMA%SessionLog_trigger
Before insert on %SCHEMA%SessionLog
For each row
Begin
Select %SCHEMA%SessionLog_sequence.nextval into :new.Id from dual; End;;
Create Table %SCHEMA%CommitLog (Id Number Not Null,
SessionId Number,
Directory nvarchar2(256),
Message nclob,
Type char(1),
Filename nvarchar2(256),
Tag varchar(64),
BugId varchar(64),
OldRev varchar(64),
NewRev varchar(64),
Added Number,
Removed Number,
Diff nclob,
CONSTRAINT CommitLog PRIMARY KEY(Id)) %TABLESPACE%;
Grant Select, Insert On %SCHEMA%CommitLog To Public;
Create Sequence %SCHEMA%CommitLog_sequence
Start with 1
Increment by 1
Nomaxvalue
Nocache
Noorder;
Grant Select On %SCHEMA%CommitLog_sequence To Public;
Create Or Replace Trigger %SCHEMA%CommitLog_trigger
Before insert on %SCHEMA%CommitLog
For each row
Begin
Select %SCHEMA%CommitLog_sequence.nextval into :new.Id from dual; End;;
Create Index %SCHEMA%Commit_SessionId On %SCHEMA%CommitLog(SessionId) %TABLESPACE%;
Create Table %SCHEMA%HistoryLog (Id Number Not Null,
SessionId Number,
Type char(1),
WorkDir nvarchar2(256),
Revs varchar(64),
Name nvarchar2(256),
BugId varchar(64),
Message nclob,
CONSTRAINT HistoryLog PRIMARY KEY(Id)) %TABLESPACE%;
Grant Select, Insert On %SCHEMA%HistoryLog To Public;
Create Sequence %SCHEMA%HistoryLog_sequence
Start with 1
Increment by 1
Nomaxvalue
Nocache
Noorder;
Grant Select On %SCHEMA%HistoryLog_sequence To Public;
Create Or Replace Trigger %SCHEMA%HistoryLog_trigger
Before insert on %SCHEMA%HistoryLog
For each row
Begin
Select %SCHEMA%HistoryLog_sequence.nextval into :new.Id from dual; End;;
Create Index %SCHEMA%History_SessionId on %SCHEMA%HistoryLog(SessionId) %TABLESPACE%;
Create Table %SCHEMA%TagLog (Id Number Not Null,
SessionId Number,
Directory nvarchar2(256),
Filename nvarchar2(256),
Tag varchar(64),
Revision varchar(64),
Message nclob,
Action varchar(32),
Type char(1),
CONSTRAINT TagLog PRIMARY KEY(Id)) %TABLESPACE%;
Grant Select, Insert On %SCHEMA%TagLog To Public;
Create Sequence %SCHEMA%TagLog_sequence
Start with 1
Increment by 1
Nomaxvalue
Nocache
Noorder;
Grant Select On %SCHEMA%TagLog_sequence To Public;
Create Trigger %SCHEMA%TagLog_trigger
Before insert on %SCHEMA%TagLog
For each row
Begin
Select %SCHEMA%TagLog_sequence.nextval into :new.Id from dual; End;;
Create Index %SCHEMA%Tag_SessionId on %SCHEMA%TagLog(SessionId) %TABLESPACE%;
CVSNT CVSNT
需积分: 3 79 浏览量
2010-06-12
08:56:20
上传
评论
收藏 1.7MB RAR 举报
CVSNT.rar （67个子文件） 
CVSNT 
rcsdiff.exe 12KB
_cvsnt.cpl 167KB postinst.exe 20KB triggers email.dll 95KB audit.dll 45KB script.dll 62KB checkout.dll 29KB info.dll 56KB march-hare.url 58B cvs.exe 844KB cvsnt-wiki.url 53B protocols ssh.dll 17KB pserver.dll 25KB server.dll 18KB gserver.dll 29KB sserver.dll 32KB sync.dll 29KB enum.dll 15KB sspi.dll 34KB ext.dll 15KB cvsservice.exe 53KB mdnsclient.dll 22KB database sqlite.dll 34KB mysql.dll 36KB odbc.dll 45KB mssql.dll 50KB oracle.dll 60KB db2.dll 47KB postgres.dll 38KB extnt.ini 85B plink.dll 234KB cvslock.exe 65KB cvsapi.dll 691KB extnt.exe 19KB co.exe 12KB protocol_map.ini 419B xdiff extdiff.dll 12KB sql upgrade_1_mssql.sql 264B upgrade_2_oracle.sql 190B upgrade_2_mssql.sql 188B upgrade_2_postgres.sql 193B create_tables_db2.sql 1KB create_tables_oracle.sql 3KB create_tables_postgres.sql 1KB upgrade_1_sqlite.sql 421B upgrade_2_mysql.sql 190B upgrade_1_mysql.sql 265B upgrade_1_db2.sql 263B create_tables_mysql.sql 1KB create_tables_sqlite.sql 1KB upgrade_1_oracle.sql 84B upgrade_2_sqlite.sql 195B upgrade_1_postgres.sql 270B upgrade_2_db2.sql 186B create_tables_mssql.sql 1KB cvstools.dll 179KB mdns mini.dll 20KB apple.dll 16KB genkey.exe 12KB cvs.chm 340KB cvsnt.cpl 30KB COPYING 18KB ca.pem 124KB su.exe 16KB
relnotes.rtf 32KB rlog.exe 12KB cvsdiag.exe 18KB资源评论
