You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-commits@db.apache.org by an...@apache.org on 2011/06/14 20:25:04 UTC
svn commit: r1135731 - in /db/jdo/trunk/tck/src/sql/derby: applicationidentity/schema11.sql datastoreidentity/schema11.sql

Author: andyj
Date: Tue Jun 14 18:25:03 2011
New Revision: 1135731

URL: http://svn.apache.org/viewvc?rev=1135731&view=rev
Log:
meeting room etc were added to companyAnnotatedFC 4 weeks ago yet no schema added for this schema.

Modified:
    db/jdo/trunk/tck/src/sql/derby/applicationidentity/schema11.sql
    db/jdo/trunk/tck/src/sql/derby/datastoreidentity/schema11.sql

Modified: db/jdo/trunk/tck/src/sql/derby/applicationidentity/schema11.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck/src/sql/derby/applicationidentity/schema11.sql?rev=1135731&r1=1135730&r2=1135731&view=diff
==============================================================================
--- db/jdo/trunk/tck/src/sql/derby/applicationidentity/schema11.sql (original)
+++ db/jdo/trunk/tck/src/sql/derby/applicationidentity/schema11.sql Tue Jun 14 18:25:03 2011
@@ -42,6 +42,8 @@ DROP TABLE persons;
 DROP TABLE projects;
 DROP TABLE comp_depts;
 DROP TABLE companies;
+DROP TABLE meetingrooms;
+DROP TABLE department_rooms;
 
 CREATE TABLE companies (
     ID INTEGER NOT NULL,
@@ -67,6 +69,19 @@ CREATE TABLE comp_depts (
     CONSTRAINT DEPTS_PK PRIMARY KEY (ID)
 );
 
+CREATE TABLE department_rooms (
+    DEPTID INTEGER NOT NULL,
+    ROOMID INTEGER NOT NULL,
+    ROOM_ORDER INTEGER NOT NULL
+);
+
+CREATE TABLE meetingrooms (
+    ID INTEGER NOT NULL,
+    NAME VARCHAR(32) NOT NULL,
+    DISCRIMINATOR VARCHAR(255),
+    CONSTRAINT ROOMS_PK PRIMARY KEY (ID)
+);
+
 CREATE TABLE persons (
     PERSONID INTEGER NOT NULL,
     FIRSTNAME VARCHAR(32) NOT NULL,

Modified: db/jdo/trunk/tck/src/sql/derby/datastoreidentity/schema11.sql
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck/src/sql/derby/datastoreidentity/schema11.sql?rev=1135731&r1=1135730&r2=1135731&view=diff
==============================================================================
--- db/jdo/trunk/tck/src/sql/derby/datastoreidentity/schema11.sql (original)
+++ db/jdo/trunk/tck/src/sql/derby/datastoreidentity/schema11.sql Tue Jun 14 18:25:03 2011
@@ -42,6 +42,8 @@ DROP TABLE persons;
 DROP TABLE projects;
 DROP TABLE comp_depts;
 DROP TABLE companies;
+DROP TABLE meetingrooms;
+DROP TABLE department_rooms;
 
 CREATE TABLE companies (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
@@ -69,6 +71,20 @@ CREATE TABLE comp_depts (
     CONSTRAINT DEPTS_PK PRIMARY KEY (DATASTORE_IDENTITY)
 );
 
+CREATE TABLE department_rooms (
+    DEPTID INTEGER NOT NULL,
+    ROOMID INTEGER NOT NULL,
+    ROOM_ORDER INTEGER NOT NULL
+);
+
+CREATE TABLE meetingrooms (
+    DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
+    ID INTEGER NOT NULL,
+    NAME VARCHAR(32) NOT NULL,
+    DISCRIMINATOR VARCHAR(255),
+    CONSTRAINT ROOMS_PK PRIMARY KEY (DATASTORE_IDENTITY)
+);
+
 CREATE TABLE persons (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     PERSONID INTEGER NOT NULL,