[php-blog-cvs] serendipity/sql db_update_0.8-alpha5_0.8-alpha6_mysql.sql,NONE,1.1 db_update_0.8-alpha5_0.8-alpha6_postgres.sql,NONE,1.1 db_update_0.8-alpha5_0.8-alpha6_sqlite.sql,NONE,1.1

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

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

Added Files:
	db_update_0.8-alpha5_0.8-alpha6_mysql.sql 
	db_update_0.8-alpha5_0.8-alpha6_postgres.sql 
	db_update_0.8-alpha5_0.8-alpha6_sqlite.sql 
Log Message:
db update files. did I mention sqlite sucks at adding columns? ;)


--- NEW FILE: db_update_0.8-alpha5_0.8-alpha6_postgres.sql ---
ALTER TABLE {PREFIX}plugins ADD COLUMN path varchar(255);

--- NEW FILE: db_update_0.8-alpha5_0.8-alpha6_sqlite.sql ---
create table {PREFIX}tempplugins (
  name varchar(128) not null,
  placement varchar(6) not null default 'right',
  sort_order int(4) not null default '0',
  authorid int(11) default '0',
  PRIMARY KEY(name)
);

INSERT INTO {PREFIX}tempplugins (name, placement, sort_order, authorid) SELECT name, placement, sort_order, authorid FROM {PREFIX}plugins;
DROP TABLE plugins;

create table {PREFIX}plugins (
  name varchar(128) not null,
  placement varchar(6) not null default 'right',
  sort_order int(4) not null default '0',
  authorid int(11) default '0',
  path varchar(255) default null,
  PRIMARY KEY(name)
);

INSERT INTO {PREFIX}plugins (name, placement, sort_order, authorid) SELECT name, placement, sort_order, authorid FROM {PREFIX}plugins;
DROP TABLE tempplugins;

--- NEW FILE: db_update_0.8-alpha5_0.8-alpha6_mysql.sql ---
ALTER TABLE {PREFIX}plugins ADD path varchar(255) default null;