From adb1355b272b80cf9904cd0e04c4f26d2528203f Mon Sep 17 00:00:00 2001 From: Sebastian Reichel Date: Tue, 21 May 2013 20:05:12 +0200 Subject: sql: create index --- sql/tables.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'sql') diff --git a/sql/tables.sql b/sql/tables.sql index f42e927..194f4f3 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -6,4 +6,5 @@ CREATE TABLE IF NOT EXISTS prices (product INTEGER NOT NULL REFERENCES products, CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY NOT NULL, email TEXT, firstname TEXT NOT NULL, lastname TEXT NOT NULL, gender TEXT, street TEXT, plz INTEGER, city TEXT, pgp TEXT); CREATE TABLE IF NOT EXISTS authentication(user INTEGER PRIMARY KEY NOT NULL REFERENCES users, password TEXT, session CHARACTER(20), superuser BOOLEAN NOT NULL DEFAULT 0, disabled BOOLEAN NOT NULL DEFAULT 0); CREATE TABLE IF NOT EXISTS supplier(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, city TEXT, postal_code TEXT, street TEXT, phone TEXT, website TEXT); +CREATE INDEX IF NOT EXISTS invoiceindex ON sales (user ASC, timestamp DESC); COMMIT; -- cgit v1.2.3