← Back to branch summary

~ubuntu-branches/ubuntu/intrepid/prewikka/intrepid

« back to all changes in this revision

Viewing changes to database/pgsql-update-0.9.1.sql

  • Committer: Bazaar Package Importer
  • Author(s): Pierre Chifflier
  • Date: 2007-04-11 14:41:09 UTC
  • Revision ID: james.westby@ubuntu.com-20070411144109-2hh7zx3amwd27b4l
Tags: upstream-0.9.10
Import upstream version 0.9.10

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/pgsql-update-0.9.1.sql
 
1
UPDATE Prewikka_Version SET version='0.9.1';
 
2
 
 
3
DROP TABLE Prewikka_User_Configuration;
 
4
CREATE TABLE Prewikka_User_Configuration (
 
5
        login VARCHAR(32) NOT NULL,
 
6
        view  VARCHAR(32) NOT NULL,
 
7
        name  VARCHAR(255) NOT NULL,
 
8
        value VARCHAR(255) NULL
 
9
);
 
10
 
 
11
CREATE INDEX prewikka_user_configuration_index ON Prewikka_User_Configuration (name, login, view);
 
 
b'\\ No newline at end of file'