From 3a3cb557ca56e9d0678bb1f3477a37b740b20af1 Mon Sep 17 00:00:00 2001
From: Matthias Andreas Benkard <code@mail.matthias.benkard.de>
Date: Tue, 15 Mar 2011 18:58:45 +0100
Subject: Database schema: Fix column order.

---
 schema.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index b4ce0bc..1efe049 100644
--- a/schema.sql
+++ b/schema.sql
@@ -116,11 +116,11 @@ CREATE TABLE comment_revisions(
   date                 TIMESTAMP DEFAULT now(),
   content              VARCHAR   NOT NULL,
   author               INTEGER,
-  submitter_ip         INET,
-  submitter_user_agent VARCHAR,
   format               VARCHAR   NOT NULL,
   status               VARCHAR   NOT NULL,
   article_revision     INTEGER,
+  submitter_ip         INET,
+  submitter_user_agent VARCHAR,
   PRIMARY KEY (id),
   FOREIGN KEY (comment) REFERENCES comments,
   FOREIGN KEY (author)  REFERENCES users,
-- 
cgit v1.2.3

