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 \