[Boost-commit] svn:boost r78489 - sandbox/icl/libs/xplore/br1/sqlbrowser

Subject: [Boost-commit] svn:boost r78489 - sandbox/icl/libs/xplore/br1/sqlbrowser
From: afojgo_at_[hidden]
Date: 2012-05-16 10:57:19

Author: jofaber
Date: 2012-05-16 10:57:16 EDT (Wed, 16 May 2012)
New Revision: 78489
URL: http://svn.boost.org/trac/boost/changeset/78489

Log:
Modifications on the prototype db.
Binary files modified: 
   sandbox/icl/libs/xplore/br1/sqlbrowser/objects1.db
Text files modified: 
   sandbox/icl/libs/xplore/br1/sqlbrowser/TypeExtensibleDag.sql |    16 +++++++++-------                        
   sandbox/icl/libs/xplore/br1/sqlbrowser/sqlbrowser4.pro       |     4 ++--                                    
   2 files changed, 11 insertions(+), 9 deletions(-)

Modified: sandbox/icl/libs/xplore/br1/sqlbrowser/TypeExtensibleDag.sql
==============================================================================
--- sandbox/icl/libs/xplore/br1/sqlbrowser/TypeExtensibleDag.sql	(original)
+++ sandbox/icl/libs/xplore/br1/sqlbrowser/TypeExtensibleDag.sql	2012-05-16 10:57:16 EDT (Wed, 16 May 2012)
@@ -13,7 +13,14 @@
 create table Vertex (key integer primary key, refObjectType integer, refObject integer);
 create table Edge (key integer primary key, refEdgeType integer, refSourceVertex integer, refTargetVertex integer, refObject integer);
 create table Object (key integer primary key);
-create table Attribute (key integer primary key, name varchar);
+create table Attribute (key integer primary key, refObjectType integer, name varchar);
+
+create table Field (key integer primary key, refObject integer, refAttribute integer, seqnum integer);
+
+create table VarCharField (refField integer primary key, value varchar);
+
+
+
 create table IntObject (refObject integer, refAttribute integer, value integer, primary key (refObject, refAttribute));
 create table VarCharObject (refObject integer, refAttribute integer, value varchar, primary key (refObject, refAttribute));
 
@@ -125,9 +132,7 @@
 select Object.key as Obj, VarCharObject.value as Name
 from Object
   inner join VarCharObject   on VarCharObject.refObject = Object.key
-  
-
-  
+    
 -- -----------------------------------------------------------------------------
 -- Vertexes
 select Vertex.key as Vtx, Object.key as Obj, ObjectType.Name as Type , Attribute.Name as Attr, 
@@ -218,6 +223,3 @@
   inner join Object on Object.key = Vertex.refObject
   inner join VarCharObject on Object.key = VarCharObject.refObject
 
-
-
-  
\ No newline at end of file

Modified: sandbox/icl/libs/xplore/br1/sqlbrowser/objects1.db
==============================================================================
Binary files. No diff available.

Modified: sandbox/icl/libs/xplore/br1/sqlbrowser/sqlbrowser4.pro
==============================================================================
--- sandbox/icl/libs/xplore/br1/sqlbrowser/sqlbrowser4.pro	(original)
+++ sandbox/icl/libs/xplore/br1/sqlbrowser/sqlbrowser4.pro	2012-05-16 10:57:16 EDT (Wed, 16 May 2012)
@@ -3,8 +3,8 @@
 
 QT              += sql
 
-INCLUDEPATH     += /cygwin/home/jofa/dev/boost/branches/release
-#INCLUDEPATH     += C:\NIBuild\3rdparty\boost-1.48.0
+#INCLUDEPATH     += /cygwin/home/jofa/dev/boost/branches/release
+INCLUDEPATH     += C:\NIBuild\3rdparty\boost-1.48.0
 
 HEADERS         = browser.h connectionwidget.h qsqlconnectiondialog.h \
     exttableview.h \