CREATE TABLE offer (
articleid VARCHAR(12),
article VARCHAR(10),
- name TEXT,
+ subname TEXT,
self_width FLOAT4,
self_height FLOAT4,
self_depth FLOAT4,
);
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),