diff options
author | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2011-03-15 18:58:45 +0100 |
---|---|---|
committer | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2011-03-15 18:58:45 +0100 |
commit | 3a3cb557ca56e9d0678bb1f3477a37b740b20af1 (patch) | |
tree | a5aaa7f65dd5ddb1cf84cf793c564b0444a762b0 /schema.sql | |
parent | 5f927ed417f9dcd74297180ddadbe5d73c5f28a8 (diff) |
Database schema: Fix column order.
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
@@ -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, |