[php-blog-cvs] serendipity/sql db_update_0.2_0.3_postgres.sql,NONE,1.2.2.1 db_update_0.3_0.4_postgres.sql,NONE,1.2.2.1 db_update_0.5.1_0.6_postgres.sql,NONE,1.2.2.1 db_update_0.5_0.5.1_postgres.sql,NONE,1.2.2.1 db_update_0.3_0.4_pgsql.sql,1.2,NONE db_update_0.5.1_0.6_pgsql.sql,1.1,NONE db_update_0.5_0.5.1_pgsql.sql,1.3,NONE

[Garvin H. <gar...@us...>]

Update of /cvsroot/php-blog/serendipity/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29625

Added Files:
      Tag: branch_0_6
	db_update_0.2_0.3_postgres.sql db_update_0.3_0.4_postgres.sql 
	db_update_0.5.1_0.6_postgres.sql 
	db_update_0.5_0.5.1_postgres.sql 
Removed Files:
      Tag: branch_0_6
	db_update_0.3_0.4_pgsql.sql db_update_0.5.1_0.6_pgsql.sql 
	db_update_0.5_0.5.1_pgsql.sql 
Log Message:
Merged the new postgresql files to the right branch


--- NEW FILE: db_update_0.2_0.3_postgres.sql ---
ALTER TABLE {PREFIX}entries ADD COLUMN trackbacks INT(4) DEFAULT 0 AFTER `comments`;

ALTER TABLE {PREFIX}entries ADD COLUMN isdraft BOOLEAN NOT NULL FALSE AFTER `categoryid`;

ALTER TABLE {PREFIX}comments ADD COLUMN subscribed BOOLEAN NOT NULL AFTER `type`;

INSERT INTO {PREFIX}config (name, value) VALUES ('allowSubscriptions', 'false');

INSERT INTO {PREFIX}config (name, value) VALUES ('template', 'default');

INSERT INTO {PREFIX}config (name, value) VALUES ('embed', 'false');

INSERT INTO {PREFIX}config (name, value) VALUES ('indexFile', 'index.php');

INSERT INTO {PREFIX}config (name, value) VALUES ('blockReferer', ';');

INSERT INTO {PREFIX}config (name, value) VALUES ('XHTML11', 'false'); 

--- db_update_0.3_0.4_pgsql.sql DELETED ---

--- NEW FILE: db_update_0.5.1_0.6_postgres.sql ---
CREATE INDEX date_idx ON {PREFIX}entries (timestamp);

CREATE INDEX mod_idx ON {PREFIX}entries (last_modified);
--- NEW FILE: db_update_0.3_0.4_postgres.sql ---
ALTER TABLE {PREFIX}entries ADD COLUMN allow_comments BOOLEAN;
UPDATE {PREFIX}entries SET allow_comments=TRUE;
ALTER TABLE {PREFIX}entries ALTER COLUMN allow_comments SET NOT NULL;
ALTER TABLE {PREFIX}entries ALTER COLUMN allow_comments SET DEFAULT TRUE;

--- db_update_0.5_0.5.1_pgsql.sql DELETED ---

--- db_update_0.5.1_0.6_pgsql.sql DELETED ---

--- NEW FILE: db_update_0.5_0.5.1_postgres.sql ---
CREATE TABLE {PREFIX}images (
  id SERIAL primary key,
  name varchar(255) NOT NULL default '',
  extension varchar(5) NOT NULL default '',
  mime varchar(15) NOT NULL default '',
  size int NOT NULL default '0',
  dimensions_width int NOT NULL default '0',
  dimensions_height int NOT NULL default '0',
  thumbnail_name varchar(255) NOT NULL default '',
  date int NOT NULL default '0'
);

UPDATE {PREFIX}plugins
   SET name = REPLACE(name, 'serendipity_plugin_content_rewrite', 'serendipity_event_contentrewrite')
 WHERE name LIKE '%serendipity_plugin_content_rewrite%';

UPDATE {PREFIX}config
   SET name = REPLACE(name, 'serendipity_plugin_content_rewrite', 'serendipity_event_contentrewrite')
 WHERE name LIKE '%serendipity_plugin_content_rewrite%';
 
UPDATE {PREFIX}plugins
   SET placement = 'event'
 WHERE name LIKE '%serendipity_event_contentrewrite%';
 
ALTER TABLE {PREFIX}entries ADD COLUMN last_modified INT;

CREATE INDEX timestamp ON {PREFIX}entries (timestamp);
CREATE INDEX last_modified ON {PREFIX}entries (last_modified);
UPDATE {PREFIX}entries SET last_modified = timestamp;

INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_nl2br:39979424fea674e78399659e67edaf12', 'event', 10);
INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_s9ymarkup:fdd8bf23ff500827cf76d7d31957d3c8', 'event', 11);
INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_emoticate:e30b433546aa10a632b0d703ebe1aa29', 'event', 12);
INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_trackexits:25e6d8eb7d662936abb6454956aaa8ab', 'event', 13);