Update of /cvsroot/boost/boost/tools/regression/xsl_reports/db
In directory sc8-pr-cvs3.sourceforge.net:/tmp/cvs-serv9764
Modified Files:
Tag: RC_1_34_0
sqlserver_schemas.sql
Log Message:
.
Index: sqlserver_schemas.sql
===================================================================
RCS file:
/cvsroot/boost/boost/tools/regression/xsl_reports/db/Attic/sqlserver_schemas.sql,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- sqlserver_schemas.sql 29 Jan 2007 06:28:00 -0000 1.1.2.1
+++ sqlserver_schemas.sql 29 Jan 2007 06:28:25 -0000 1.1.2.2
@@ -1,19 +1,5 @@
drop table [test-log]
go
-CREATE TABLE [test-log]
- (
- [runner] [varchar] (32) NOT NULL ,
- [timestamp] [varchar] (32) NOT NULL ,
- [test-name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [test-run] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [test-type] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [test-program] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
- [target-directory] [varchar] (1024) NOT NULL ,
- [library] varchar(64)
- PRIMARY KEY ( runner, timestamp, [target-directory] )
- )
-GO
-
drop table [test-run]
go
CREATE TABLE [test-run] (
@@ -27,6 +13,24 @@
)
GO
+go
+CREATE TABLE [test-log]
+ (
+ [runner] [varchar] (32) NOT NULL ,
+ [timestamp] [varchar] (32) NOT NULL ,
+ [test-name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [test-run] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [test-type] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [test-program] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
+ [target-directory] [varchar] (512) NOT NULL ,
+ [library] varchar(64)
+ PRIMARY KEY ( runner, timestamp, [target-directory] )
+ )
+GO
+
+alter table [test-log] add CONSTRAINT parent FOREIGN KEY ( runner, timestamp
) REFERENCES [test-run] ( runner, timestamp )
+
+go
drop table [compile]
go
create table [compile]
@@ -36,7 +40,6 @@
[output] [text],
[timestamp] [varchar] (32) NULL ,
result [varchar] (16)
-
)
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Boost-cvs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/boost-cvs
