ext_tables.sql

#
# Table structure for table 'be_groups'
#
CREATE TABLE be_groups
(
    universal_messenger_channels text
);

#
# Table structure for table 'be_users'
#
CREATE TABLE be_users
(
    universal_messenger_channels text
);

#
# Table structure for table 'pages'
#
CREATE TABLE pages
(
    universal_messenger_channel int(11) unsigned DEFAULT '0' NOT NULL
);

#
# Table structure for table 'tx_universalmessenger_domain_model_newsletterchannel'
#
CREATE TABLE tx_universalmessenger_domain_model_newsletterchannel
(
    uid          int(11) unsigned                    NOT NULL auto_increment,
    pid          int(11) unsigned     DEFAULT '0'    NOT NULL,
    tstamp       int(11) unsigned     DEFAULT '0'    NOT NULL,
    crdate       int(11) unsigned     DEFAULT '0'    NOT NULL,
    deleted      smallint(5) unsigned DEFAULT '0'    NOT NULL,
    hidden       smallint(5) unsigned DEFAULT '0'    NOT NULL,
    starttime    int(11) unsigned     DEFAULT '0'    NOT NULL,
    endtime      int(11) unsigned     DEFAULT '0'    NOT NULL,
    sorting      int(11) unsigned     DEFAULT '0'    NOT NULL,

    channel_id   varchar(255)                        NOT NULL,
    title        varchar(255)         DEFAULT ''     NOT NULL,
    description  text                 DEFAULT ''     NOT NULL,
    sender       varchar(255)         DEFAULT ''     NOT NULL,
    reply_to     varchar(255)         DEFAULT ''     NOT NULL,
    skip_used_id smallint(5) unsigned DEFAULT '0'    NOT NULL,
    embed_images varchar(255)         DEFAULT 'none' NOT NULL,

    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY channelId (channel_id)
);