Changeset 3070

Show
Ignore:
Timestamp:
04/24/07 09:18:58 (1 week ago)
Author:
demian
Message:

pg subquery reminder

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • modules/block/data/constraints.pg.sql

    r2706 r3070  
    1 -- Last edited: Pierpaolo Toniolo 29-03-2006 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Constraints for /block 
     3-- leave "references" on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/block/data/data.block.add.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- block data for block 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/block/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data dump for /modules/block 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/block/data/data.sample.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Sample data for /block 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/block/data/schema.pg.sql

    r2706 r3070  
    55 
    66-- ============================================================== 
    7 --  Table: block                                                  
     7--  Table: block 
    88-- ============================================================== 
    9 create table block  
     9create table block 
    1010( 
    1111   block_id             INT4                 not null, 
     
    2929 
    3030-- ============================================================== 
    31 --  Table: block_assignment                                       
     31--  Table: block_assignment 
    3232-- ============================================================== 
    3333create table block_assignment 
     
    4545 
    4646-- ============================================================== 
    47 --  Index: block_assignment_fk                                    
     47--  Index: block_assignment_fk 
    4848-- ============================================================== 
    49 create index block_assignment_fk on block_assignment  
     49create index block_assignment_fk on block_assignment 
    5050( 
    5151   block_id 
     
    5353 
    5454-- ============================================================== 
    55 --  Index: block_assignment_fk2                                   
     55--  Index: block_assignment_fk2 
    5656-- ============================================================== 
    57 create index block_assignment_fk2 on block_assignment  
     57create index block_assignment_fk2 on block_assignment 
    5858( 
    5959   section_id 
     
    6262-- ============================================================== 
    6363--  table block_role 
    64 --  DK  
     64--  DK 
    6565-- ============================================================== 
    6666create table block_role ( 
  • modules/comment/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
     2-- leave subqueries on a single line in order that table prefixes works 
    23BEGIN; 
    34INSERT INTO module VALUES ({SGL_NEXT_ID}, 1, 'comment', 'Comments', 'Allows users to associate comments with any module in the system.', '', '48/module_block.png', '', NULL, NULL, NULL); 
  • modules/comment/data/data.sample.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
     2-- leave subqueries on a single line in order that table prefixes works 
    23BEGIN; 
    34INSERT INTO comment VALUES (1, 'faq', NULL, 'Demian Turner', 'demian@phpkitchen.com', 'http://seagullproject.org/', '192.168.1.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7', '', 'comment', 0, 1, 'this is my comment', '2006-09-04 16:16:05'); 
  • modules/contactus/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data dump for /contactus 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/default/data/data.block.add.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
     2-- leave subqueries on a single line in order that table prefixes works 
    23BEGIN; 
    34-- LangSwitcher2 
  • modules/default/data/data.block.remove.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
     2-- leave subqueries on a single line in order that table prefixes works 
    23-- delete assignments 
    3 DELETE FROM `block_assignment` WHERE block_id = ( 
     4DELETE FROM block_assignment WHERE block_id = ( 
    45    SELECT block_id FROM block WHERE name = 'Default_Block_LangSwitcher2' 
    56    ); 
    67 
    78-- delete role assignments 
    8 DELETE FROM `block_role` WHERE block_id =( 
     9DELETE FROM block_role WHERE block_id =( 
    910    SELECT block_id FROM block WHERE name = 'Default_Block_LangSwitcher2' 
    1011    ); 
    1112 
    1213-- delete blocks 
    13 DELETE FROM `block` WHERE block_id = ( 
     14DELETE FROM block WHERE block_id = ( 
    1415    SELECT block_id FROM block WHERE name = 'Default_Block_LangSwitcher2' 
    1516    ); 
  • modules/default/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data for /etc 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/documentor/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data dump for /documentor 
    3  
     3-- leave subqueries on a single line in order that table prefixes works 
    44BEGIN; 
    55 
  • modules/event/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- default data for event 
    3  
     3-- leave subqueries on a single line in order that table prefixes works 
    44BEGIN; 
    55 
  • modules/export/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data dump for /export 
    3  
     3-- leave subqueries on a single line in order that table prefixes works 
    44BEGIN; 
    55 
  • modules/faq/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data dump for /faq 
    3  
     3-- leave subqueries on a single line in order that table prefixes works 
    44BEGIN; 
    55 
  • modules/gallery2/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data dump for /gallery2 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/googlemaps/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
     2-- leave subqueries on a single line in order that table prefixes works 
    23BEGIN; 
    34INSERT INTO module VALUES ({SGL_NEXT_ID}, 0, 'googlemaps', 'Google Maps', 'The ''Google Maps'' module graphs user locations.', NULL, '48/module_map.png', '', NULL, NULL, NULL); 
  • modules/guestbook/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data dump for /guestbook 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/media/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Schema for media 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/messaging/data/constraints.pg.sql

    r2706 r3070  
    1 -- Last edited: Pierpaolo Toniolo 26-07-2005 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Constraints for /messaging 
     3-- leave "references" on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/messaging/data/data.default.pg.sql

    r3064 r3070  
    11-- Last edited: Antonio J. Garcia 2007-04-21 
    22-- Data dump for /messaging 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/messaging/data/data.sample.pg.sql

    r2706 r3070  
    1 -- Last edited: Pierpaolo Toniolo 29-03-2006 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Sample dump for /messaging 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/navigation/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data dump for /navigation 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/newsletter/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- data for /newsletter 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/publisher/data/constraints.pg.sql

    r2706 r3070  
    1 -- Last edited: Pierpaolo Toniolo 29-03-2006 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Constraints for /publisher 
     3-- leave "references" on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/publisher/data/data.block.add.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Setup blocks for publisher 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/publisher/data/data.block.remove.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Setup blocks for publisher 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/publisher/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data dump for /publisher 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/publisher/data/data.sample.pg.sql

    r2706 r3070  
    1 -- Last edited: Pierpaolo Toniolo 29-03-2006 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data dump for /publisher 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
    56 
    67 
    7 --  
     8-- 
    89--  Dumping data for table item 
    9 --  
     10-- 
    1011 
    1112INSERT INTO item VALUES (1,2,5,1,1,'2004-01-03 18:21:25','2004-03-16 22:38:38','2004-01-03 18:21:07','2009-01-03 00:00:00',4,0); 
    1213 
    13 --  
     14-- 
    1415--  Dumping data for table item_addition 
    15 --  
     16-- 
    1617 
    1718INSERT INTO item_addition VALUES (1, 1, 7, 'Content Reshuffle', 0); 
    1819INSERT INTO item_addition VALUES (2, 1, 8, '<p>Test out dynamic language switching here:</p>\r\n<table cellpadding=5 width="75%" align=center border=1>\r\n<tbody>\r\n<tr bgcolor=#cccccc>\r\n<td>\r\n<p align=center> <a href="/seagull/www/index.php/publisher/articleview/frmArticleID/1/staticId/6/lang/de-iso-8859-1/"><img height=20 alt=germany.gif hspace=0 src="/seagull/www/themes/default/images/uploads/germany.gif" width=30 align=baseline border=0></a></p></td>\r\n<td>\r\n<p align=center> <a href="/seagull/www/index.php/publisher/articleview/frmArticleID/1/staticId/6/lang/zh/"><img height=20 alt=china.gif hspace=0 src="/seagull/www/themes/default/images/uploads/china.gif" width=30 align=baseline border=0></a></p></td>\r\n<td>\r\n<p align=center> <a href="/seagull/www/index.php/publisher/articleview/frmArticleID/1/staticId/6/lang/zh-tw/"><img style="WIDTH: 30px; HEIGHT: 20px" height=20 alt=taiwan.gif hspace=0 src="/seagull/www/themes/default/images/uploads/taiwan.gif" width=30 align=baseline border=0></a></p></td>\r\n<td>\r\n<p align=center><a href="/seagull/www/index.php/publisher/articleview/frmArticleID/1/staticId/6/lang/ru-win1251/"><img height=20 alt=russia.gif hspace=0 src="/seagull/www/themes/default/images/uploads/russia.gif" width=30 align=baseline border=0></a> </p></td>\r\n<td>\r\n<p align=center><a href="/seagull/www/index.php/publisher/articleview/frmArticleID/1/staticId/6/lang/en-iso-8859-1/"><img height=15 alt=uk.gif hspace=0 src="/seagull/www/themes/default/images/uploads/uk.gif" width=30 align=baseline border=0></a> </p></td></tr>\r\n<tr>\r\n<td>\r\n<p align=center><a href="/seagull/www/index.php/publisher/articleview/frmArticleID/1/staticId/6/lang/de-iso-8859-1/">German</a></p></td>\r\n<td>\r\n<p align=center><a href="/seagull/www/index.php/publisher/articleview/frmArticleID/1/staticId/6/lang/zh/">Chinese(GB2312)</a></p></td>\r\n<td>\r\n<p align=center><a href="/seagull/www/index.php/publisher/articleview/frmArticleID/1/staticId/6/lang/zh-tw/">Chinese(Big5)</a></p></td>\r\n<td>\r\n<p align=center><a href="/seagull/www/index.php/publisher/articleview/frmArticleID/1/staticId/6/lang/ru-win1251/">Russian</a></p></td>\r\n<td>\r\n<p align=center><a href="/seagull/www/index.php/publisher/articleview/frmArticleID/1/staticId/6/lang/en-iso-8859-15/">English</a></p></td></tr></tbody></table>\r\n<p><strong>nb</strong>: to see the Chinese translation rendered properly english Windows users running Internet Explorer will need to install the Asian language pack - see <a href="http://marc.theaimsgroup.com/?l=seagull-general&m=107814024805423&w=2">this page</a> for more detail.</p>\r\n<p>Thanks to <a href="http://www.stargeek.com/">Dan''s</a> excellent <a href="http://www.stargeek.com/crawler_sim.php">web crawler simulation</a> tool that gives you a search engine view of your site, I''ve shuffled around PHPkitchen''s content in an attempt to put the more relevant stuff at the top.</p>\r\n<p>Please also checkout the new <strong>Thinking Outside of the Box</strong> block in the left column, this is a collection of links to some of the more interesting applications of PHP that have surfaced recently.</p>\r\n<p>Dan''s other tool, the <a href="http://www.stargeek.com/code_to_text.php">code to text analyser</a>, reveals PHPkitchen suffers from a high html bloat, this is being addressed in latest version of <a href="http://seagull.phpkitchen.com/">Seagull</a> project where John Dell is almost finished his XHTML theme.</p>', 0); 
    1920 
    20 --  
     21-- 
    2122--  Dumping data for table category 
    22 --  
     23-- 
    2324 
    2425INSERT INTO category VALUES (0,'MainRoot',NULL,0,0,0,0,0,0); 
  • modules/randommsg/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data dump for /randommsg 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/s9ywrapper/data/data.default.pg.sql

    r3009 r3070  
    1 -- Last edited: Pierpaolo Toniolo 15-08-2006 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Data dump for blog 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/user/data/constraints.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Constraints for /user 
     3-- leave "references" on a single line in order that table prefixes works 
    34 
    45BEGIN; 
  • modules/user/data/data.default.pg.sql

    r3064 r3070  
    1 -- Last edited: Antonio J. Garcia 2007-04-21 
     1-- Last edited: Antonio J. Garcia 2007-04-24 
    22-- Constraints for /user 
     3-- leave subqueries on a single line in order that table prefixes works 
    34 
    45-- Data dump for /modules/user