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

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

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

Modified Files:
	db_update_0.8-alpha5_0.8-alpha6_sqlite.sql 
Log Message:
fix cr/lf and errors reported by Riscky. Thanks!


Index: db_update_0.8-alpha5_0.8-alpha6_sqlite.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.8-alpha5_0.8-alpha6_sqlite.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- db_update_0.8-alpha5_0.8-alpha6_sqlite.sql	6 Dec 2004 10:47:02 -0000	1.1
+++ db_update_0.8-alpha5_0.8-alpha6_sqlite.sql	16 Dec 2004 11:59:22 -0000	1.2
@@ -1,22 +1,22 @@
-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;
+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 {PREFIX}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}tempplugins;
+DROP TABLE {PREFIX}tempplugins;