XDe Module Install

Update XDe (Recommended)

CREATE TABLE users (id        INTEGER(11) NOT NULL auto_increment,
                    cid       INTEGER(11) REFERENCES contact_name(id),
                    uname     VARCHAR(20) NOT NULL,
                    passwd    VARCHAR(20) NOT NULL,
                    email     VARCHAR(100) NOT NULL,
                    modified  TIMESTAMP(14),
                    created   DATETIME,
                    lastlogin DATETIME,
                    priv      INTEGER(5),
                    block     BOOL NOT NULL DEFAULT '0',
PRIMARY KEY (id),
INDEX idx_users_cid (cid),
INDEX idx_users_uname (uname(20)),
INDEX idx_users_email (email(10)));

FAILED: Table 'users' already exists

CREATE TABLE user_info (uid       INTEGER(11) NOT NULL auto_increment,
                        info      TEXT,
PRIMARY KEY (uid));

FAILED: Table 'user_info' already exists

CREATE TABLE user_options (uid       INTEGER(11) NOT NULL auto_increment,
                           birthday  DATETIME,
                           opt_email BOOL NOT NULL DEFAULT '1',
                           opt_news  BOOL NOT NULL DEFAULT '1',
                           opt_mail  BOOL NOT NULL DEFAULT '1',
                           options   TEXT,
PRIMARY KEY (uid));

FAILED: Table 'user_options' already exists

CREATE TABLE user_session (id            VARCHAR(23) NOT NULL,
                           uid           INTEGER(11) DEFAULT '0' NOT NULL,
                           sdate         DATETIME,
                           edate         DATETIME,
PRIMARY KEY (id(11)));

FAILED: Table 'user_session' already exists

CREATE TABLE form_key (id       INTEGER(11) NOT NULL auto_increment,
                       fkey     CHAR(30),
                       cdate    DATETIME,
                       info     TEXT,
PRIMARY KEY (id));

FAILED: Table 'form_key' already exists

CREATE TABLE contact_category (id           INT(11) NOT NULL auto_increment,
                               name         TINYTEXT,
                               description  TINYTEXT,
                               info         TEXT,
PRIMARY KEY (id));

FAILED: Table 'contact_category' already exists

CREATE TABLE contact_name (id           INTEGER(11) NOT NULL auto_increment,
                          cid           INTEGER(11) NOT NULL REFERENCES contact_category(id),
                          cid2          INTEGER(11) NOT NULL REFERENCES contact_category(id),
                          cid3          INTEGER(11) NOT NULL REFERENCES contact_category(id),
                          datum         timestamp(14),
                          salutation    VARCHAR(7),
                          first_name    TINYTEXT NOT NULL,
                          middle_name   TINYTEXT,
                          last_name     TINYTEXT NOT NULL,
                          company       TINYTEXT,
PRIMARY KEY (id),
INDEX idx_contactname_name (last_name(10)),
INDEX idx_contactname_cid (cid),
INDEX idx_contactname_cid2 (cid2),
INDEX idx_contactname_cid3 (cid3));

FAILED: Table 'contact_name' already exists

CREATE TABLE contact_address (cid           INTEGER(11) NOT NULL REFERENCES contact_name(id),
                              type          VARCHAR(20) NOT NULL,
                              address1      TINYTEXT    NOT NULL,
                              address2      TINYTEXT,
                              city          TINYTEXT,
                              province      TINYTEXT    NOT NULL,
                              country       VARCHAR(3)  NOT NULL,
                              pcode         VARCHAR(10),
                              description   TEXT,
                              old           BOOL DEFAULT '0' NOT NULL,
PRIMARY KEY (cid, type(20)),
INDEX idx_contactaddress_city (city(10)));

FAILED: Table 'contact_address' already exists

CREATE TABLE contact_contacts (cid                INTEGER(11) NOT NULL REFERENCES contact_name(id),
                               contact            VARCHAR(100) NOT NULL,
                               contact_type       VARCHAR(50) NOT NULL,
                               publish            BOOL NOT NULL DEFAULT '0',

PRIMARY KEY (cid, contact, contact_type),
INDEX idx_contact_contacttype (contact_type),
INDEX idx_contact_contacts_cid (cid));

FAILED: Table 'contact_contacts' already exists

CREATE TABLE security (uid         INTEGER(11) DEFAULT '0' NOT NULL references users(id),
                       spid        INTEGER(11) DEFAULT '0' NOT NULL references security_profile(id),
                       info        TEXT,
PRIMARY KEY (uid));

FAILED: Table 'security' already exists

CREATE TABLE security_profile (id            INTEGER(11) NOT NULL auto_increment,
                               luid          INTEGER(11) DEFAULT '0' NOT NULL references users(id),
                               name          VARCHAR(50) NOT NULL,
                               info          TEXT,
PRIMARY KEY (id));

FAILED: Table 'security_profile' already exists

CREATE TABLE security_audit (id            INTEGER(11) NOT NULL auto_increment,
                             uid           INTEGER(11) DEFAULT '0' NOT NULL references users(id),
                             cdate         DATETIME NOT NULL,
                             level         INTEGER(2) NOT NULL DEFAULT '0',
                             module        VARCHAR(50),
                             action        TINYTEXT,
                             info          TEXT,
PRIMARY KEY (id));

FAILED: Table 'security_audit' already exists

CREATE TABLE xde_update (id           INTEGER(11) NOT NULL auto_increment,
                         mdate        DATETIME,
                         site         TINYTEXT NOT NULL,
                         server       TINYTEXT NOT NULL,
                         basepath     TINYTEXT NOT NULL,
                         info         TEXT,
PRIMARY KEY (id));

FAILED: Table 'xde_update' already exists

CREATE TABLE images (id           INTEGER(11) NOT NULL auto_increment,
                     iid          INTEGER(11) DEFAULT '0' NOT NULL,
                     uid          INTEGER(11) DEFAULT '0' NOT NULL references users(id),
                     cdate        DATETIME,
                     object       VARCHAR(50) NOT NULL,
                     property     VARCHAR(50) NOT NULL,
                     info         TEXT,
                     filepath     TINYTEXT NOT NULL,
                     filename     TINYTEXT NOT NULL,
                     views        INTEGER(9) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
INDEX idx_images_iid (iid),
INDEX idx_images_object (object(10)),
INDEX idx_images_property (property(10)),
INDEX idx_images_iidobjectproperty (iid, object(10),property(10)));

FAILED: Table 'images' already exists

CREATE TABLE files (id           INTEGER(11) DEFAULT '0' NOT NULL auto_increment,
                    fid          INTEGER(11) DEFAULT '0' NOT NULL,
                    uid          INTEGER(11) DEFAULT '0' NOT NULL references users(id),
                    cdate        DATETIME,
                    object       VARCHAR(50) NOT NULL,
                    property     VARCHAR(50) NOT NULL,
                    info         TEXT,
                    filepath     TINYTEXT NOT NULL,
                    filename     TINYTEXT NOT NULL,
                    obscure      BOOL NOT NULL DEFAULT '0',
                    secure       BOOL NOT NULL DEFAULT '0',
                    reads        INTEGER(9) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
INDEX idx_files_fid (fid),
INDEX idx_files_object (object(10)),
INDEX idx_files_property (property(10)));

FAILED: Table 'files' already exists

CREATE TABLE vtour (id          INTEGER(11) NOT NULL auto_increment,
                   oid          INTEGER(11) DEFAULT '0' NOT NULL,
                   uid          INTEGER(11) DEFAULT '0' NOT NULL references users(id),
                   cdate        DATETIME,
                   object       VARCHAR(50) NOT NULL,
                   property     VARCHAR(50) NOT NULL,
                   info         TEXT,
                   filepath     TINYTEXT NOT NULL,
                   fileprefix   TINYTEXT NOT NULL,
                   smallqtvr    BOOL DEFAULT '0' NOT NULL,
                   largeqtvr    BOOL DEFAULT '0' NOT NULL,
                   smalljpeg    BOOL DEFAULT '0' NOT NULL,
                   largejpeg    BOOL DEFAULT '0' NOT NULL,
                   views        INTEGER(9) DEFAULT '0' NOT NULL,    
PRIMARY KEY (id));

FAILED: Table 'vtour' already exists

CREATE TABLE info (id           INTEGER(11) NOT NULL auto_increment,
                   oid          INTEGER(11) DEFAULT '0' NOT NULL,
                   uid          INTEGER(11) DEFAULT '0' NOT NULL references users(id),
                   cdate        DATETIME,
                   object       VARCHAR(50) NOT NULL,
                   property     VARCHAR(50) NOT NULL,
                   info         TEXT,
PRIMARY KEY (id),
INDEX idx_info_oid (oid),
INDEX idx_info_uid (uid),
INDEX idx_info_object (object(10)),
INDEX idx_info_property (property(10)));

FAILED: Table 'info' already exists

CREATE TABLE backup      (id           INTEGER(11) NOT NULL auto_increment,
                          cdate        DATETIME,
                          btype        INTEGER(2) NOT NULL DEFAULT '1',
                          bresult      INTEGER(2) NOT NULL DEFAULT '0',
                          name         TINYTEXT NOT NULL,
                          info         TEXT,
PRIMARY KEY (id));

FAILED: Table 'backup' already exists

CREATE TABLE backup_site_file  (id           INTEGER(11) NOT NULL auto_increment,
                                bsid         INTEGER(11) DEFAULT '0' NOT NULL REFERENCES backup_site(id),
                                name         TINYTEXT NOT NULL,
                                info         TEXT,
PRIMARY KEY (id),
INDEX idx_backup_bsid (bsid));

FAILED: Table 'backup_site_file' already exists

CREATE TABLE backup_site  (id           INTEGER(11) NOT NULL auto_increment,
                           name         TINYTEXT NOT NULL,
                           info         TEXT,
PRIMARY KEY (id));

FAILED: Table 'backup_site' already exists

CREATE TABLE backup_log  (id           INTEGER(11) NOT NULL auto_increment,
                          bsid         INTEGER(11) DEFAULT '0' NOT NULL REFERENCES backup_site(id),
                          rdate        DATETIME,
                          btype        INTEGER(2) NOT NULL DEFAULT '1',
                          bresult      INTEGER(2) NOT NULL DEFAULT '0',
                          info         TEXT,
PRIMARY KEY (id));

FAILED: Table 'backup_log' already exists

CREATE TABLE backup_queue  (id           INTEGER(11) NOT NULL auto_increment,
                            bsid         INTEGER(11) DEFAULT '0' NOT NULL REFERENCES backup_site(id),
                            btype        INTEGER(2) NOT NULL DEFAULT '1',
                            bresult      INTEGER(2) NOT NULL DEFAULT '0',
                            ddate        DATETIME,
PRIMARY KEY (id));

FAILED: Table 'backup_queue' already exists

CREATE TABLE iplocation(id            INTEGER(11) NOT NULL auto_increment,
                        ip_from       DOUBLE NOT NULL DEFAULT '0',
                        ip_to         DOUBLE NOT NULL DEFAULT '0',
                        iso2          VARCHAR(2) NOT NULL DEFAULT 'CA',
                        iso3          VARCHAR(3),
                        province      VARCHAR(50),
                        city          VARCHAR(50),
                        company       TINYTEXT,
                        INFO          TEXT,
PRIMARY KEY (id));

FAILED: Table 'iplocation' already exists

CREATE TABLE stats_process_lock(slock        INTEGER(8) NOT NULL DEFAULT '0',
                                reason      TINYTEXT,
PRIMARY KEY(slock));

FAILED: Table 'stats_process_lock' already exists

CREATE TABLE stats_queue(id            INTEGER(11) NOT NULL auto_increment,
                         object        VARCHAR(50) NOT NULL DEFAULT 'page',
                         property      TINYTEXT NOT NULL DEFAULT '',
                         sub_property  VARCHAR(50) NOT NULL DEFAULT '',
                         rid           INTEGER(11) NOT NULL DEFAULT 0,
                         datum         INTEGER(8) DEFAULT '0' NOT NULL,
                         count         INTEGER(16) DEFAULT '0' NOT NULL,
PRIMARY KEY (id));

FAILED: Table 'stats_queue' already exists

CREATE TABLE stats_daily(id            INTEGER(11) NOT NULL auto_increment,
                         object        VARCHAR(50) NOT NULL DEFAULT 'page',
                         property      TINYTEXT NOT NULL DEFAULT '',
                         sub_property  VARCHAR(50) NOT NULL DEFAULT '',
                         rid           INTEGER(11) NOT NULL DEFAULT 0,
                         datum         INTEGER(8) DEFAULT '0' NOT NULL,
                         count         INTEGER(16) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
INDEX idx_stats_daily_object (object(10)),
INDEX idx_stats_daily_property (property(10)),
INDEX idx_stats_daily_datum (datum),
INDEX idx_stats_daily_objectproperty(object(10),property(20)));

FAILED: Table 'stats_daily' already exists

CREATE TABLE stats_monthly(id            INTEGER(11) NOT NULL auto_increment,
                           object        VARCHAR(50) NOT NULL DEFAULT 'page',
                           property      TINYTEXT NOT NULL DEFAULT '',
                           sub_property  VARCHAR(50) NOT NULL DEFAULT '',
                           rid           INTEGER(11) NOT NULL DEFAULT 0,
                           datum         INTEGER(8) DEFAULT '0' NOT NULL,
                           count         INTEGER(16) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
INDEX idx_stats_monthly_object (object(10)),
INDEX idx_stats_monthly_property (property(10)),
INDEX idx_stats_monthly_datum (datum),
INDEX idx_stats_monthly_objectproperty(object(10),property(20)));

FAILED: Table 'stats_monthly' already exists

CREATE TABLE stats_yearly(id            INTEGER(11) NOT NULL auto_increment,
                          object        VARCHAR(50) NOT NULL DEFAULT 'page',
                          property      TINYTEXT NOT NULL DEFAULT '',
                          sub_property  VARCHAR(50) NOT NULL DEFAULT '',
                          rid           INTEGER(11) NOT NULL DEFAULT 0,
                          datum         INTEGER(8) DEFAULT '0' NOT NULL,
                          count         INTEGER(16) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
INDEX idx_stats_yearly_object (object(10)),
INDEX idx_stats_yearly_property (property(10)),
INDEX idx_stats_yearly_datum (datum),
INDEX idx_stats_yearly_objectproperty(object(10),property(20)));

FAILED: Table 'stats_yearly' already exists

CREATE TABLE help_category (id           INTEGER(11) NOT NULL auto_increment,
                            uid          INTEGER(11) REFERENCES users(id),
                            name         TINYTEXT NOT NULL,
                            description  TEXT,
                            allowupd     BOOL DEFAULT '1' NOT NULL,
                            sort         TINYINT,
                            mdate        DATETIME,
                            usermod      BOOL DEFAULT '1' NOT NULL,
PRIMARY KEY (id));

FAILED: Table 'help_category' already exists

CREATE TABLE help_topic ( id           INTEGER(11) NOT NULL auto_increment,
                          hcid         INTEGER(11) DEFAULT '1' REFERENCES help_category(id),
                          uid          INTEGER(11) REFERENCES users(id),
                          reference    TINYTEXT NOT NULL,
                          title        TINYTEXT NOT NULL,
                          module       TINYTEXT,
                          content      TEXT,
                          codeformat   INTEGER(1) DEFAULT '0' NOT NULL,
                          seealso      TINYTEXT,
                          accesslevel  INTEGER(1) DEFAULT '0' NOT NULL,
                          allowupd     BOOL DEFAULT '1' NOT NULL,
                          hidetopic    BOOL DEFAULT '0' NOT NULL,
                          mdate        DATETIME,
                          usermod      BOOL DEFAULT '1' NOT NULL,
PRIMARY KEY (id),
UNIQUE INDEX    idx_reference (reference(250)));

FAILED: Table 'help_topic' already exists

CREATE TABLE help_topic_keywords (htid       INTEGER(11) NOT NULL REFERENCES help_topic(id),
                                  keyword    TINYTEXT NOT NULL,
PRIMARY KEY (htid, keyword(10)),
INDEX idx_keyword (keyword(10)));

FAILED: Table 'help_topic_keywords' already exists

CREATE TABLE smiley (id          INTEGER(11) NOT NULL auto_increment,
                     code        VARCHAR(10) NOT NULL,
                     category    VARCHAR(30) NOT NULL,
                     filename    VARCHAR(30) NOT NULL,
                     description TEXT,                  
PRIMARY KEY (id));

FAILED: Table 'smiley' already exists

CREATE TABLE news_category (id               INTEGER(11) NOT NULL auto_increment,
                            name             TINYTEXT NOT NULL,
                            description      TEXT,
                            comments         BOOL NOT NULL DEFAULT 0,
                            glossarize       BOOL NOT NULL DEFAULT 0,
                            offsite          BOOL NOT NULL DEFAULT 0,
                            offsiteurl       TINYTEXT,
                            offsitecat       INTEGER(11) NOT NULL DEFAULT 0,
                            offsitemax       INTEGER(3) NOT NULL DEFAULT 25,
                            autoarchive      INTEGER(2) NOT NULL DEFAULT 0,
                            public           BOOL NOT NULL DEFAULT 0,
PRIMARY KEY (id));

FAILED: Table 'news_category' already exists

CREATE TABLE news (id          INTEGER(11) NOT NULL auto_increment,
                   ncid        INTEGER(11) NOT NULL REFERENCES news_category(id),
                   uid         INTEGER(11) NOT NULL REFERENCES users(id),
                   datum       DATETIME NOT NULL,
                   lang        VARCHAR(3) NOT NULL DEFAULT 'en',
                   headline    TINYTEXT,
                   subhead     TINYTEXT,
                   summary     TEXT,
                   content     TEXT,
                   views       INTEGER(11),
                   html        INTEGER(1) NOT NULL DEFAULT 0,
                   restricted  BOOL NOT NULL DEFAULT 0,
                   archive     BOOL NOT NULL DEFAULT 0,
PRIMARY KEY (id),
INDEX idx_news_ncid (ncid),
INDEX idx_news_restricted (restricted),
INDEX idx_news_archive (archive));

FAILED: Table 'news' already exists

CREATE TABLE news_contact_category_xref (nid      INTEGER(11) NOT NULL REFERENCES news(id),
                                         ccid     INTEGER(11) NOT NULL REFERENCES contact_category(id),
PRIMARY KEY (nid, ccid));

FAILED: Table 'news_contact_category_xref' already exists

CREATE TABLE newsletter_design (id          INTEGER(11) NOT NULL auto_increment,
                                name        TINYTEXT NOT NULL,
                                description TEXT,
                                info        TEXT,
PRIMARY KEY (id));

FAILED: Table 'newsletter_design' already exists

CREATE TABLE newsletter (id          INTEGER(11) NOT NULL auto_increment,
                         nldid       INTEGER(11) NOT NULL REFERENCES newsletter_design(id),
                         subject     TINYTEXT NOT NULL,
                         volume      TINYTEXT,
                         issue       TINYTEXT,
                         datum       DATETIME NOT NULL,
                         lang        VARCHAR(3) NOT NULL DEFAULT 'en',
                         views       INTEGER(11),  
                         sent        BOOL NOT NULL DEFAULT 0,
                         archive     BOOL NOT NULL DEFAULT 0,  
PRIMARY KEY (id));

FAILED: Table 'newsletter' already exists

CREATE TABLE newsletter_item (id         INTEGER(11) NOT NULL auto_increment,
                              nlid       INTEGER(11) NOT NULL REFERENCES newsletter(id),
                              lang       VARCHAR(3) NOT NULL DEFAULT 'en',
                              col        INTEGER(4) NOT NULL DEFAULT '0',
                              pos        INTEGER(4),
                              module     VARCHAR(60),
                              iid        INTEGER(11),
                              content    TEXT,  
                              info       TEXT,    
PRIMARY KEY (id));

FAILED: Table 'newsletter_item' already exists

CREATE TABLE specials (id               INTEGER(11) DEFAULT '0' NOT NULL auto_increment,
                       start            DATETIME NOT NULL,
                       end              DATETIME NOT NULL,
                       name             TINYTEXT NOT NULL,
                       description      TEXT,
                       code             VARCHAR(20) NOT NULL,
                       image            VARCHAR(23) NOT NULL,
                       image_align      VARCHAR(15),
                       preview_image    VARCHAR(23) NOT NULL,
                       pimage_align     VARCHAR(15),
                       maxuse           INTEGER(2) DEFAULT '1' NOT NULL,  
                       public           INTEGER(2) DEFAULT '0' NOT NULL,
                       nodetail         INTEGER(2) DEFAULT '0' NOT NULL,    
PRIMARY KEY (id),
INDEX idx_specials_start (start),
INDEX idx_specials_end (end));

FAILED: Table 'specials' already exists

CREATE TABLE specials_download (sid             INTEGER(11) NOT NULL REFERENCES specials(id),
                                uid             INTEGER(11) NOT NULL REFERENCES users(id),
                                datum           DATETIME NOT NULL,
                                usecount        INTEGER(3) DEFAULT '1' NOT NULL,    
PRIMARY KEY (sid, uid));

FAILED: Table 'specials_download' already exists

CREATE TABLE calendar_category (id          INTEGER(11) NOT NULL auto_increment,
                                name        TINYTEXT NOT NULL,
                                info        TEXT,
PRIMARY KEY (id));

FAILED: Table 'calendar_category' already exists

CREATE TABLE calendar_event (id               INTEGER(11) NOT NULL auto_increment,
                             ccid             INTEGER(11) NOT NULL DEFAULT '0' references calendar_category(id),
                             start            DATETIME NOT NULL,
                             end              DATETIME NOT NULL,
                             name             TINYTEXT NOT NULL,
                             description      TEXT,
                             repeat_type      VARCHAR(9),
                             repeat_increment VARCHAR(3),
                             repeat_stop      DATETIME,
                             restricted       BOOL  NOT NULL DEFAULT '0',
                             data             TEXT,
PRIMARY KEY (id),
INDEX idx_calevent_start (start),
INDEX idx_calevent_end (end),
INDEX idx_calevent_repeat_type (repeat_type(2)));

FAILED: Table 'calendar_event' already exists

CREATE TABLE trackmail (id          INTEGER(11) NOT NULL auto_increment,
                        subject     TINYTEXT NOT NULL,
                        description TEXT,
                        message     TEXT,
                        cdate       DATETIME NOT NULL,
PRIMARY KEY (id));

FAILED: Table 'trackmail' already exists

CREATE TABLE trackmail_result (tmid          INTEGER(11) NOT NULL DEFAULT '0' REFERENCES trackmail(id),
                               uid           INTEGER(11) NOT NULL DEFAULT '0' REFERENCES users(id),
                               last_read     DATETIME NOT NULL,
                               numreads      INTEGER(4),  
PRIMARY KEY (tmid, uid));

FAILED: Table 'trackmail_result' already exists