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;
|
