taylor 2005/01/11 01:33:06
Modified: src/sql populate-db-default.sql
src/schema phase2-schema.xml test-persistence-schema.xml
Log:
added a test table CLUBS for the demo's DatabaseBrowser
Revision Changes Path
1.10 +17 -0 jakarta-jetspeed-2/src/sql/populate-db-default.sql
Index: populate-db-default.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/src/sql/populate-db-default.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- populate-db-default.sql 25 Nov 2004 02:25:57 -0000 1.9
+++ populate-db-default.sql 11 Jan 2005 09:33:06 -0000 1.10
@@ -322,3 +322,20 @@
insert into PRINCIPAL_RULE_ASSOC values ( 'user', 'page', 'j1' );
insert into PRINCIPAL_RULE_ASSOC values ( 'user', 'docset', 'role-group' );
+-- test data for db browser
+insert into CLUBS values ('AC Milan', 'Italy', 'Milan', 'San Siro', 85700,
1926, '105x68m', '');
+insert into CLUBS values ('Arsenal', 'England', 'London', 'Highbury', 38500,
1913, '101x65', 'Gunners');
+insert into CLUBS values ('Barcelona', 'Spain', 'Barcelona', 'Nou Camp',
110000, 1957, '', '');
+insert into CLUBS values ('Bayern Munich', 'Germany', 'Munich',
'Olympiastadion', 69000, 1971, '105x68m', '');
+insert into CLUBS values ('Benfica', 'Portugal', 'Benfica', 'Estadio Da
Luz', 80000, 1954, '', '');
+insert into CLUBS values ('Boca Juniors', 'Argentina', 'Buenos Aires', 'La
Bombonera', 60245, 1940, '', '');
+insert into CLUBS values ('Chelsea', 'England', 'London', 'Stamford Bridge',
42500, 1877, '103x68m', 'The Blues');
+insert into CLUBS values ('Cruz Azul', 'Mexico', 'Mexico City', 'Estadio
Azteca', 114600, 1966, '', '');
+insert into CLUBS values ('Flamenco', 'Brazil', 'Rio de Janeiro',
'Maracana', 70000, 1950, '110x75m', '');
+insert into CLUBS values ('Inter Milan', 'Italy', 'Milan', 'San Siro',
85700, 1926, '105x68m', '');
+insert into CLUBS values ('Juventus', 'Italy', 'Turin', 'Stadio Delle Alpi',
69041, 1990, '105x68m', '');
+insert into CLUBS values ('Lazio', 'Italy', 'Rome', 'Stadio Olimpico',
82307, 1953, '105x67m', '');
+insert into CLUBS values ('Manchester United', 'England', 'Manchester', 'Old
Trafford', 67603, 1910, '106x69m', 'Red Devils');
+insert into CLUBS values ('Paris Saint-Germain', 'France', 'Paris', 'Parc
Des Princes', 48500, 1972, '', '');
+insert into CLUBS values ('Real Madrid', 'Spain', 'Madrid', 'Santiago
Bernabeu', 90000, 1947, '105x68m', '');
+insert into CLUBS values ('River Plate', 'Argentina', 'Buenos Aires', 'El
Monumental', 77000, 1942, '105x70m', 'Los Millionairos');
1.9 +11 -0 jakarta-jetspeed-2/src/schema/phase2-schema.xml
Index: phase2-schema.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/src/schema/phase2-schema.xml,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- phase2-schema.xml 3 Dec 2004 22:00:23 -0000 1.8
+++ phase2-schema.xml 11 Jan 2005 09:33:06 -0000 1.9
@@ -147,4 +147,15 @@
</unique>
</table>
+ <table name="CLUBS">
+ <column name="NAME" primaryKey='true' required="true" size="80"
type="VARCHAR"/>
+ <column name="COUNTRY" required="true" size="40" type="VARCHAR"/>
+ <column name="CITY" required="true" size="40" type="VARCHAR"/>
+ <column name="STADIUM" required="true" size="80" type="VARCHAR"/>
+ <column name="CAPACITY" type='INTEGER'/>
+ <column name="FOUNDED" type='INTEGER'/>
+ <column name="PITCH" size="40" type="VARCHAR"/>
+ <column name="NICKNAME" size="40" type="VARCHAR"/>
+ </table>
+
</database>
1.3 +2 -1 jakarta-jetspeed-2/src/schema/test-persistence-schema.xml
Index: test-persistence-schema.xml
===================================================================
RCS file:
/home/cvs/jakarta-jetspeed-2/src/schema/test-persistence-schema.xml,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- test-persistence-schema.xml 18 Mar 2004 19:39:02 -0000 1.2
+++ test-persistence-schema.xml 11 Jan 2005 09:33:06 -0000 1.3
@@ -29,5 +29,6 @@
<column name="ID" primaryKey="true" required="true" type="INTEGER"/>
<column name="A_ID" required="true" type="INTEGER"/>
<column name="NAME" required="true" size="80" type="VARCHAR"/>
- </table>
+ </table>
+
</database>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
