Aktuelle Strukturen

[infodrom.org/infocon.infodrom.org] / misc / schemes

diff --git a/misc/schemes b/misc/schemes
index ea0215e..851bbac 100644 (file)
--- a/misc/schemes
+++ b/misc/schemes
@@ -21,7 +21,7 @@ CREATE  INDEX "article_name" on "article" using btree ( name );
 CREATE TABLE offer (
        articleid VARCHAR(12),
        article VARCHAR(10),
-       name TEXT,
+       subname TEXT,
        self_width  FLOAT4,
        self_height FLOAT4,
        self_depth  FLOAT4,
@@ -32,7 +32,7 @@ CREATE TABLE offer (
 );
 CREATE UNIQUE INDEX "offer_id" on "offer" using btree ( articleid );
 CREATE  INDEX "offer_offer" on "offer" using btree ( article );
-CREATE  INDEX "offer_name" on "offer" using btree ( name );
+CREATE  INDEX "offer_name" on "offer" using btree ( subname );
 
 CREATE TABLE spool (
        articleid VARCHAR(12),