Return to the Horizons Home Page
The panoramic views of Vancouver from Horizons Restaurant
About Horizons Restaurant on Burnaby Mountain near SFU Horizons Menus - Fine Dining on Burnaby Mountan with a View of Vancouver Information about group and business bookings and special occasions News and special events at Horizons restaurant A Virtual Tour of Horizons Restaurant Dining Specials and information for our patrons Specialty Horizons merchandise
July 16th 2006 @ 19:23

XDe Module Update

Affected Items

ALTER TABLE stats_queue   CHANGE        datum datum INTEGER(8) DEFAULT '0' NOT NULL;

Results

XDe.core

ALTER TABLE users ADD          INDEX idx_users_cid (cid);
FAILED: Duplicate key name 'idx_users_cid'

ALTER TABLE users ADD          INDEX idx_users_uname (uname(20));
FAILED: Duplicate key name 'idx_users_uname'

ALTER TABLE users ADD          INDEX idx_users_email (email(10));
FAILED: Duplicate key name 'idx_users_email'

XDe.contact

ALTER TABLE contact_category ADD info      TEXT AFTER description;
FAILED: Duplicate column name 'info'

ALTER TABLE contact_name ADD cid2          INTEGER(11) NOT NULL REFERENCES contact_category(id) AFTER cid;
FAILED: Duplicate column name 'cid2'

ALTER TABLE contact_name ADD cid3          INTEGER(11) NOT NULL REFERENCES contact_category(id) AFTER cid2;
FAILED: Duplicate column name 'cid3'

ALTER TABLE contact_contacts ADD           INDEX idx_contact_contacts_cid (cid);
FAILED: Duplicate key name 'idx_contact_contacts_cid'

ALTER TABLE contact_name ADD               INDEX idx_contactname_cid (cid);
FAILED: Duplicate key name 'idx_contactname_cid'

ALTER TABLE contact_name ADD               INDEX idx_contactname_cid2 (cid2);
FAILED: Duplicate key name 'idx_contactname_cid2'

ALTER TABLE contact_name ADD               INDEX idx_contactname_cid3 (cid3);
FAILED: Duplicate key name 'idx_contactname_cid3'

XDe.security

XDe.update

XDe.images

ALTER TABLE images ADD            INDEX idx_images_iid (iid);
FAILED: Duplicate key name 'idx_images_iid'

ALTER TABLE images ADD            INDEX idx_images_object (object(10));
FAILED: Duplicate key name 'idx_images_object'

ALTER TABLE images ADD            INDEX idx_images_property (property(10));
FAILED: Duplicate key name 'idx_images_property'

ALTER TABLE images ADD            INDEX idx_images_iidobjectproperty (iid,object(10),property(10));
FAILED: Duplicate key name 'idx_images_iidobjectproperty'

XDe.files

ALTER TABLE files ADD obscure    BOOL NOT NULL DEFAULT '0' AFTER filename;
FAILED: Duplicate column name 'obscure'

ALTER TABLE files ADD secure     BOOL NOT NULL DEFAULT '0' AFTER obscure;
FAILED: Duplicate column name 'secure'

ALTER TABLE files ADD            INDEX idx_files_fid (fid);
FAILED: Duplicate key name 'idx_files_fid'

ALTER TABLE files ADD            INDEX idx_files_object (object(10));
FAILED: Duplicate key name 'idx_files_object'

ALTER TABLE files ADD            INDEX idx_files_property (property(10));
FAILED: Duplicate key name 'idx_files_property'

XDe.vtours

XDe.info

ALTER TABLE info ADD          INDEX idx_info_oid (oid);
FAILED: Duplicate key name 'idx_info_oid'

ALTER TABLE info ADD          INDEX idx_info_uid (uid);
FAILED: Duplicate key name 'idx_info_uid'

ALTER TABLE info ADD          INDEX idx_info_object (object(10));
FAILED: Duplicate key name 'idx_info_object'

ALTER TABLE info ADD          INDEX idx_info_property (property(10));
FAILED: Duplicate key name 'idx_info_property'

backup

ALTER TABLE backup_site_file ADD                INDEX idx_backup_bsid (bsid);
FAILED: Duplicate key name 'idx_backup_bsid'

iplocation

ppstats

ALTER TABLE stats_yearly  ADD           INDEX idx_stats_yearly_objectproperty(object(10),property(20));
FAILED: Duplicate key name 'idx_stats_yearly_objectproperty'

ALTER TABLE stats_monthly ADD           INDEX idx_stats_monthly_objectproperty(object(10),property(20));
FAILED: Duplicate key name 'idx_stats_monthly_objectproperty'

ALTER TABLE stats_daily   ADD           INDEX idx_stats_daily_objectproperty(object(10),property(20));
FAILED: Duplicate key name 'idx_stats_daily_objectproperty'

ALTER TABLE stats_queue   DROP          info;
FAILED: Can't DROP 'info'. Check that column/key exists

ALTER TABLE stats_queue   CHANGE        datum datum INTEGER(8) DEFAULT '0' NOT NULL;
Updated

ALTER TABLE stats_queue   ADD           object        VARCHAR(50) NOT NULL DEFAULT 'page' AFTER id;
FAILED: Duplicate column name 'object'

ALTER TABLE stats_queue   ADD           property      TINYTEXT NOT NULL DEFAULT '' AFTER object;
FAILED: Duplicate column name 'property'

ALTER TABLE stats_queue   ADD           sub_property  VARCHAR(50) NOT NULL DEFAULT '' AFTER property;
FAILED: Duplicate column name 'sub_property'

ALTER TABLE stats_queue   ADD           rid           INTEGER(11) NOT NULL DEFAULT 0 AFTER sub_property;
FAILED: Duplicate column name 'rid'

ALTER TABLE stats_queue   ADD           count         INTEGER(16) DEFAULT '0' NOT NULL AFTER datum;
FAILED: Duplicate column name 'count'

help

ALTER TABLE help_topic DROP COLUMN allowdel;
FAILED: Can't DROP 'allowdel'. Check that column/key exists

ALTER TABLE help_topic ADD COLUMN           usermod BOOL DEFAULT '0' NOT NULL AFTER mdate;
FAILED: Duplicate column name 'usermod'

ALTER TABLE help_category DROP COLUMN allowdel;
FAILED: Can't DROP 'allowdel'. Check that column/key exists

ALTER TABLE help_category ADD COLUMN        usermod BOOL DEFAULT '0' NOT NULL AFTER mdate;
FAILED: Duplicate column name 'usermod'

smiley

news

ALTER TABLE news ADD restricted BOOL NOT NULL DEFAULT '0' after html;
FAILED: Duplicate column name 'restricted'

ALTER TABLE news ADD          INDEX idx_news_ncid (ncid);
FAILED: Duplicate key name 'idx_news_ncid'

ALTER TABLE news ADD          INDEX idx_news_archive (archive);
FAILED: Duplicate key name 'idx_news_archive'

ALTER TABLE news ADD          INDEX idx_news_restricted (restricted);
FAILED: Duplicate key name 'idx_news_restricted'

ALTER TABLE news_category ADD          comments         BOOL NOT NULL DEFAULT 0 AFTER description;
FAILED: Duplicate column name 'comments'

ALTER TABLE news_category ADD          glossarize       BOOL NOT NULL DEFAULT 0 AFTER comments;
FAILED: Duplicate column name 'glossarize'

ALTER TABLE news_category ADD          offsite          BOOL NOT NULL DEFAULT 0 AFTER glossarize;
FAILED: Duplicate column name 'offsite'

ALTER TABLE news_category ADD          offsiteurl       TINYTEXT AFTER offsite;
FAILED: Duplicate column name 'offsiteurl'

ALTER TABLE news_category ADD          offsitecat       INTEGER(11) NOT NULL DEFAULT 0 AFTER offsiteurl;
FAILED: Duplicate column name 'offsitecat'

ALTER TABLE news_category ADD          offsitemax       INTEGER(3) NOT NULL DEFAULT 25 AFTER offsitecat;
FAILED: Duplicate column name 'offsitemax'

ALTER TABLE news_category ADD          autoarchive      INTEGER(2) NOT NULL DEFAULT 0 AFTER offsitemax;
FAILED: Duplicate column name 'autoarchive'

newsletter

special

calendar

ALTER TABLE calendar_event ADD          restricted       BOOL NOT NULL DEFAULT '0'      AFTER repeat_stop;
FAILED: Duplicate column name 'restricted'

ALTER TABLE calendar_event ADD          data             TEXT      AFTER restricted;
FAILED: Duplicate column name 'data'

ALTER TABLE calendar_event ADD          ccid             INTEGER(11) NOT NULL DEFAULT '0' references calendar_category(id) AFTER id;
FAILED: Duplicate column name 'ccid'

ALTER TABLE calendar_event ADD          INDEX idx_calevent_repeat_type (repeat_type(2));
FAILED: Duplicate key name 'idx_calevent_repeat_type'

trackmail

ALTER TABLE trackmail ADD         message TEXT AFTER description;
FAILED: Duplicate column name 'message'

PLEASE DELETE THE UPDATE FILE NOW.
Contact Horizons Restaurant to make a Reservation Careers at Horizons Restaurant in Burnaby BC Canada Visit our sister fine dining restaurant on the water in down town Vancouver Visit our sister fine dining restaurant above Vancouver with breath taking views of the city
Copyright © 1987-2006 Horizons Restaurant
Site designed and maintained by e-clear solutions