rave-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mpie...@apache.org
Subject svn commit: r1100392 - /incubator/rave/trunk/rave-portal/src/main/resources/initial_data.sql
Date Fri, 06 May 2011 21:49:10 GMT
Author: mpierce
Date: Fri May  6 21:49:09 2011
New Revision: 1100392

URL: http://svn.apache.org/viewvc?rev=1100392&view=rev
Log:
Adding a layout for the OpenID user.


Modified:
    incubator/rave/trunk/rave-portal/src/main/resources/initial_data.sql

Modified: incubator/rave/trunk/rave-portal/src/main/resources/initial_data.sql
URL: http://svn.apache.org/viewvc/incubator/rave/trunk/rave-portal/src/main/resources/initial_data.sql?rev=1100392&r1=1100391&r2=1100392&view=diff
==============================================================================
--- incubator/rave/trunk/rave-portal/src/main/resources/initial_data.sql (original)
+++ incubator/rave/trunk/rave-portal/src/main/resources/initial_data.sql Fri May  6 21:49:09
2011
@@ -1,141 +1,161 @@
- -- Licensed to the Apache Software Foundation (ASF) under one
- -- or more contributor license agreements.  See the NOTICE file
- -- distributed with this work for additional information
- -- regarding copyright ownership.  The ASF licenses this file
- -- to you under the Apache License, Version 2.0 (the
- -- "License"); you may not use this file except in compliance
- -- with the License.  You may obtain a copy of the License at
-  ~
- --   http://www.apache.org/licenses/LICENSE-2.0
-  ~
- -- Unless required by applicable law or agreed to in writing,
- -- software distributed under the License is distributed on an
- -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
- -- KIND, either express or implied.  See the License for the
- -- specific language governing permissions and limitations
- -- under the License.
-
---  --- start user data ---
-insert into user (user_id, username, password, expired, locked, enabled)
-values (set(@user_id_1, next value for user_id_seq), 'canonical', 'canonical', 'N', 'N',
'Y');
-
-insert into user (user_id, username, password, expired, locked, enabled)
-values (set(@user_id_2, next value for user_id_seq), 'john.doe', 'john.doe', 'N', 'N', 'Y');
-
-insert into user (user_id, username, password, expired, locked, enabled)
-values (set(@user_id_3, next value for user_id_seq), 'jane.doe', 'jane.doe', 'N', 'N', 'Y');
-
-insert into user (user_id, username, password, expired, locked, enabled)
-values (set(@user_id_4, next value for user_id_seq), 'george.doe', 'george.doe', 'N', 'N',
'Y');
-
-insert into user (user_id, username, password, expired, locked, enabled)
-values (set(@user_id_5, next value for user_id_seq),'mario.rossi', 'mario.rossi', 'N', 'N',
'Y');
-
-insert into user (user_id, username, password, expired, locked, enabled)
-values (set(@user_id_6, next value for user_id_seq), 'maija.m', 'maija.m', 'N', 'N', 'Y');
-
-insert into user (user_id, username, password, expired, locked, enabled)
-values (set(@user_id_6, next value for user_id_seq), 'http://rave2011.myopenid.com/', 'unused',
'N', 'N', 'Y');
-
---- end user data ---
-
---- gadget data ---
--- wikipedia widget
-insert into widget (id, title, url, type)
-values(set(@wikipedia_widget_id, next value for widget_id_seq), 'Wikipedia','http://www.google.com/ig/modules/wikipedia.xml',
'OpenSocial');
-
--- translate widget
-insert into widget (id, title, url, type)
-values(set(@translate_widget_id, next value for widget_id_seq), 'Translate Gadget', 'http://www.google.com/ig/modules/dictionary.xml',
'OpenSocial');
-
--- nytimes widget
-insert into widget (id, title, url, type)
-values(set(@nyt_widget_id, next value for widget_id_seq), 'NYTimes.com - Top Stories', 'http://widgets.nytimes.com/packages/html/igoogle/topstories.xml',
'OpenSocial');
-
--- google tabbed news widget
-insert into widget (id, title, url, type)
-values(set(@tabnews_widget_id, next value for widget_id_seq), 'Google News Gadget', 'http://www.gstatic.com/ig/modules/tabnews/tabnews.xml',
'OpenSocial');
--- end widget data ----
-
--- hamster widget
-insert into widget (id, title, url, type)
-values(set(@hamster_widget_id, next value for widget_id_seq), 'Pet Hamster', 'http://hosting.gmodules.com/ig/gadgets/file/112581010116074801021/hamster.xml',
'OpenSocial');
--- end widget data ----
-
---- start page layout data ---
-insert into page_layout (id, code,  number_of_regions)
-values (next value for page_layout_id_seq, 'columns_1', 1);
-insert into page_layout (id, code,  number_of_regions)
-values (set(@two_col_id, next value for page_layout_id_seq), 'columns_2', 2);
-insert into page_layout (id, code,  number_of_regions)
-values (next value for page_layout_id_seq, 'columns_2wn', 2);
-insert into page_layout (id, code,  number_of_regions)
-values (next value for page_layout_id_seq, 'columns_3', 3);
-insert into page_layout (id, code,  number_of_regions)
-values (next value for page_layout_id_seq, 'columns_3nwn', 3);
-insert into page_layout (id, code,  number_of_regions)
-values (next value for page_layout_id_seq, 'columns_4', 4);
-insert into page_layout (id, code,  number_of_regions)
-values (next value for page_layout_id_seq, 'columns_3nwn_1_bottom', 4);
---- end page layout data ----
-
-
---- Layout for user_id_1 ---
-INSERT INTO page (id, name, owner_id, render_sequence, page_layout_id)
-values (set(@page_1_id, next value for page_id_seq), 'main', @user_id_1, 1, @two_col_id);
-
-INSERT INTO region(id, page_id)
-values (set(@page_1_region_1, next value for region_id_seq), @page_1_id);
-INSERT INTO region(id, page_id)
-values (set(@page_1_region_2, next value for region_id_seq), @page_1_id);
-
-INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
-values (next value for region_widget_id_seq, @wikipedia_widget_id, @page_1_region_1, 1, 'N');
-INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
-values (next value for region_widget_id_seq, @translate_widget_id, @page_1_region_1, 2, 'N');
-
-INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
-values (next value for region_widget_id_seq, @nyt_widget_id, @page_1_region_2, 1, 'N');
-INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
-values (next value for region_widget_id_seq, @tabnews_widget_id, @page_1_region_2, 2, 'N');
---- End canonical user_id_1 layout ---
-
---- Layout for user_id_2 ---
-INSERT INTO page (id, name, owner_id, render_sequence, page_layout_id)
-values (set(@page_1_id, next value for page_id_seq), 'main', @user_id_2, 1, @two_col_id);
-
-INSERT INTO region(id, page_id)
-values (set(@page_1_region_1, next value for region_id_seq), @page_1_id);
-INSERT INTO region(id, page_id)
-values (set(@page_1_region_2, next value for region_id_seq), @page_1_id);
-
-INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
-values (next value for region_widget_id_seq, @wikipedia_widget_id, @page_1_region_1, 1, 'N');
-INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
-values (next value for region_widget_id_seq, @hamster_widget_id, @page_1_region_1, 2, 'N');
-
-INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
-values (next value for region_widget_id_seq, @nyt_widget_id, @page_1_region_2, 1, 'N');
-INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
-values (next value for region_widget_id_seq, @tabnews_widget_id, @page_1_region_2, 2, 'N');
---- End canonical user_id_2 layout ---
-
---- Layout for user_id_3 ---
-INSERT INTO page (id, name, owner_id, render_sequence, page_layout_id)
-values (set(@page_1_id, next value for page_id_seq), 'main', @user_id_3, 1, @two_col_id);
-
-INSERT INTO region(id, page_id)
-values (set(@page_1_region_1, next value for region_id_seq), @page_1_id);
-INSERT INTO region(id, page_id)
-values (set(@page_1_region_2, next value for region_id_seq), @page_1_id);
-
-INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
-values (next value for region_widget_id_seq, @wikipedia_widget_id, @page_1_region_1, 1, 'N');
-INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
-values (next value for region_widget_id_seq, @translate_widget_id, @page_1_region_1, 2, 'N');
-
-INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
-values (next value for region_widget_id_seq, @hamster_widget_id, @page_1_region_2, 1, 'N');
-INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
-values (next value for region_widget_id_seq, @tabnews_widget_id, @page_1_region_2, 2, 'N');
---- End canonical user_id_3 layout ---
\ No newline at end of file
+ -- Licensed to the Apache Software Foundation (ASF) under one
+ -- or more contributor license agreements.  See the NOTICE file
+ -- distributed with this work for additional information
+ -- regarding copyright ownership.  The ASF licenses this file
+ -- to you under the Apache License, Version 2.0 (the
+ -- "License"); you may not use this file except in compliance
+ -- with the License.  You may obtain a copy of the License at
+  ~
+ --   http://www.apache.org/licenses/LICENSE-2.0
+  ~
+ -- Unless required by applicable law or agreed to in writing,
+ -- software distributed under the License is distributed on an
+ -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ -- KIND, either express or implied.  See the License for the
+ -- specific language governing permissions and limitations
+ -- under the License.
+
+--  --- start user data ---
+insert into user (user_id, username, password, expired, locked, enabled)
+values (set(@user_id_1, next value for user_id_seq), 'canonical', 'canonical', 'N', 'N',
'Y');
+
+insert into user (user_id, username, password, expired, locked, enabled)
+values (set(@user_id_2, next value for user_id_seq), 'john.doe', 'john.doe', 'N', 'N', 'Y');
+
+insert into user (user_id, username, password, expired, locked, enabled)
+values (set(@user_id_3, next value for user_id_seq), 'jane.doe', 'jane.doe', 'N', 'N', 'Y');
+
+insert into user (user_id, username, password, expired, locked, enabled)
+values (set(@user_id_4, next value for user_id_seq), 'george.doe', 'george.doe', 'N', 'N',
'Y');
+
+insert into user (user_id, username, password, expired, locked, enabled)
+values (set(@user_id_5, next value for user_id_seq),'mario.rossi', 'mario.rossi', 'N', 'N',
'Y');
+
+insert into user (user_id, username, password, expired, locked, enabled)
+values (set(@user_id_6, next value for user_id_seq), 'maija.m', 'maija.m', 'N', 'N', 'Y');
+
+insert into user (user_id, username, password, expired, locked, enabled)
+values (set(@user_id_6, next value for user_id_seq), 'http://rave2011.myopenid.com/', 'unused',
'N', 'N', 'Y');
+
+--- end user data ---
+
+--- gadget data ---
+-- wikipedia widget
+insert into widget (id, title, url, type)
+values(set(@wikipedia_widget_id, next value for widget_id_seq), 'Wikipedia','http://www.google.com/ig/modules/wikipedia.xml',
'OpenSocial');
+
+-- translate widget
+insert into widget (id, title, url, type)
+values(set(@translate_widget_id, next value for widget_id_seq), 'Translate Gadget', 'http://www.google.com/ig/modules/dictionary.xml',
'OpenSocial');
+
+-- nytimes widget
+insert into widget (id, title, url, type)
+values(set(@nyt_widget_id, next value for widget_id_seq), 'NYTimes.com - Top Stories', 'http://widgets.nytimes.com/packages/html/igoogle/topstories.xml',
'OpenSocial');
+
+-- google tabbed news widget
+insert into widget (id, title, url, type)
+values(set(@tabnews_widget_id, next value for widget_id_seq), 'Google News Gadget', 'http://www.gstatic.com/ig/modules/tabnews/tabnews.xml',
'OpenSocial');
+-- end widget data ----
+
+-- hamster widget
+insert into widget (id, title, url, type)
+values(set(@hamster_widget_id, next value for widget_id_seq), 'Pet Hamster', 'http://hosting.gmodules.com/ig/gadgets/file/112581010116074801021/hamster.xml',
'OpenSocial');
+-- end widget data ----
+
+--- start page layout data ---
+insert into page_layout (id, code,  number_of_regions)
+values (next value for page_layout_id_seq, 'columns_1', 1);
+insert into page_layout (id, code,  number_of_regions)
+values (set(@two_col_id, next value for page_layout_id_seq), 'columns_2', 2);
+insert into page_layout (id, code,  number_of_regions)
+values (next value for page_layout_id_seq, 'columns_2wn', 2);
+insert into page_layout (id, code,  number_of_regions)
+values (next value for page_layout_id_seq, 'columns_3', 3);
+insert into page_layout (id, code,  number_of_regions)
+values (next value for page_layout_id_seq, 'columns_3nwn', 3);
+insert into page_layout (id, code,  number_of_regions)
+values (next value for page_layout_id_seq, 'columns_4', 4);
+insert into page_layout (id, code,  number_of_regions)
+values (next value for page_layout_id_seq, 'columns_3nwn_1_bottom', 4);
+--- end page layout data ----
+
+
+--- Layout for user_id_1 ---
+INSERT INTO page (id, name, owner_id, render_sequence, page_layout_id)
+values (set(@page_1_id, next value for page_id_seq), 'main', @user_id_1, 1, @two_col_id);
+
+INSERT INTO region(id, page_id)
+values (set(@page_1_region_1, next value for region_id_seq), @page_1_id);
+INSERT INTO region(id, page_id)
+values (set(@page_1_region_2, next value for region_id_seq), @page_1_id);
+
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @wikipedia_widget_id, @page_1_region_1, 1, 'N');
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @translate_widget_id, @page_1_region_1, 2, 'N');
+
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @nyt_widget_id, @page_1_region_2, 1, 'N');
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @tabnews_widget_id, @page_1_region_2, 2, 'N');
+--- End canonical user_id_1 layout ---
+
+--- Layout for user_id_2 ---
+INSERT INTO page (id, name, owner_id, render_sequence, page_layout_id)
+values (set(@page_1_id, next value for page_id_seq), 'main', @user_id_2, 1, @two_col_id);
+
+INSERT INTO region(id, page_id)
+values (set(@page_1_region_1, next value for region_id_seq), @page_1_id);
+INSERT INTO region(id, page_id)
+values (set(@page_1_region_2, next value for region_id_seq), @page_1_id);
+
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @wikipedia_widget_id, @page_1_region_1, 1, 'N');
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @hamster_widget_id, @page_1_region_1, 2, 'N');
+
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @nyt_widget_id, @page_1_region_2, 1, 'N');
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @tabnews_widget_id, @page_1_region_2, 2, 'N');
+--- End canonical user_id_2 layout ---
+
+--- Layout for user_id_3 ---
+INSERT INTO page (id, name, owner_id, render_sequence, page_layout_id)
+values (set(@page_1_id, next value for page_id_seq), 'main', @user_id_3, 1, @two_col_id);
+
+INSERT INTO region(id, page_id)
+values (set(@page_1_region_1, next value for region_id_seq), @page_1_id);
+INSERT INTO region(id, page_id)
+values (set(@page_1_region_2, next value for region_id_seq), @page_1_id);
+
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @wikipedia_widget_id, @page_1_region_1, 1, 'N');
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @translate_widget_id, @page_1_region_1, 2, 'N');
+
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @hamster_widget_id, @page_1_region_2, 1, 'N');
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @tabnews_widget_id, @page_1_region_2, 2, 'N');
+--- End canonical user_id_3 layout ---
+
+--- Layout for user_id_6 ---
+INSERT INTO page (id, name, owner_id, render_sequence, page_layout_id)
+values (set(@page_1_id, next value for page_id_seq), 'main', @user_id_6, 1, @two_col_id);
+
+INSERT INTO region(id, page_id)
+values (set(@page_1_region_1, next value for region_id_seq), @page_1_id);
+INSERT INTO region(id, page_id)
+values (set(@page_1_region_2, next value for region_id_seq), @page_1_id);
+
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @wikipedia_widget_id, @page_1_region_1, 1, 'N');
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @translate_widget_id, @page_1_region_1, 2, 'N');
+
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @hamster_widget_id, @page_1_region_2, 1, 'N');
+INSERT INTO region_widget(id, widget_id, region_id, render_position, collapsed)
+values (next value for region_widget_id_seq, @tabnews_widget_id, @page_1_region_2, 2, 'N');
+--- End canonical user_id_6 layout ---
\ No newline at end of file



Mime
View raw message