CREATE TABLE tx_mspatenschaft_domain_model_categories (
	category_name varchar(255) NOT NULL DEFAULT '',
	slug varchar(255) NOT NULL DEFAULT '',
	category_teaser varchar(255) NOT NULL DEFAULT '',
	image int(11) unsigned NOT NULL DEFAULT '0'
);

CREATE TABLE tx_mspatenschaft_domain_model_museumsitem (
	title varchar(255) NOT NULL DEFAULT '',
	slug varchar(255) NOT NULL DEFAULT '',
	subtitle varchar(255) NOT NULL DEFAULT '',
	image int(11) unsigned NOT NULL DEFAULT '0',
    assigned_orderid int(11) unsigned NOT NULL DEFAULT '0',
    assigned_pate int(11) unsigned NOT NULL DEFAULT '0',
    assigned_pate_date datetime default NULL,
	minimal_donation double(11,2) NOT NULL DEFAULT '0.00',
	donation_time int(11) DEFAULT '0' NOT NULL,
    content int(11) unsigned DEFAULT '0' NOT NULL,
    description  text    NULL DEFAULT '',
    order_data  text    NULL DEFAULT '',
	category int(11) unsigned NOT NULL DEFAULT '0'
);

CREATE TABLE tt_content
(
    patenschaft INT(11) unsigned DEFAULT '0' NOT NULL,
);


#
# Table structure for table 'tx_mspatenschaftmpay24_domain_model_transaction'
#
CREATE TABLE tx_mspatenschaftmpay24_domain_model_transaction
(

    uid              int(11)                         NOT NULL auto_increment,
    pid              int(11)             DEFAULT '0' NOT NULL,

    nr               varchar(255)        DEFAULT ''  NOT NULL,
    customer_id      varchar(255)        DEFAULT ''  NOT NULL,
    success          varchar(255)        DEFAULT ''  NOT NULL,
    order_nr         varchar(255)        DEFAULT ''  NOT NULL,
    payment_type     varchar(255)        DEFAULT ''  NOT NULL,
    mpay_id          varchar(255)        DEFAULT ''  NOT NULL,
    mpay_status      varchar(255)        DEFAULT ''  NOT NULL,
    order_id         int(11) unsigned    DEFAULT '0',

    tstamp           int(11) unsigned    DEFAULT '0' NOT NULL,
    crdate           int(11) unsigned    DEFAULT '0' NOT NULL,
    cruser_id        int(11) unsigned    DEFAULT '0' NOT NULL,
    deleted          tinyint(4) unsigned DEFAULT '0' NOT NULL,
    hidden           tinyint(4) unsigned DEFAULT '0' NOT NULL,
    starttime        int(11) unsigned    DEFAULT '0' NOT NULL,
    endtime          int(11) unsigned    DEFAULT '0' NOT NULL,

    t3ver_oid        int(11)             DEFAULT '0' NOT NULL,
    t3ver_id         int(11)             DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)             DEFAULT '0' NOT NULL,
    t3ver_label      varchar(255)        DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)          DEFAULT '0' NOT NULL,
    t3ver_stage      int(11)             DEFAULT '0' NOT NULL,
    t3ver_count      int(11)             DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)             DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)             DEFAULT '0' NOT NULL,

    t3_origuid       int(11)             DEFAULT '0' NOT NULL,
    sys_language_uid int(11)             DEFAULT '0' NOT NULL,
    l10n_parent      int(11)             DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumblob,

    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY t3ver_oid (t3ver_oid, t3ver_wsid),
    KEY language (l10n_parent, sys_language_uid)

);

#
# Table structure for table 'tx_mspatenschaftmpay24_domain_model_order'
#
CREATE TABLE tx_mspatenschaftmpay24_domain_model_order
(

    uid              int(11)                         NOT NULL auto_increment,
    pid              int(11)             DEFAULT '0' NOT NULL,

    first_name       varchar(255)        DEFAULT ''  NOT NULL,
    last_name        varchar(255)        DEFAULT ''  NOT NULL,
    payment          varchar(255)        DEFAULT ''  NOT NULL,
    data             text                            NOT NULL,

    tstamp           int(11) unsigned    DEFAULT '0' NOT NULL,
    crdate           int(11) unsigned    DEFAULT '0' NOT NULL,
    cruser_id        int(11) unsigned    DEFAULT '0' NOT NULL,
    deleted          tinyint(4) unsigned DEFAULT '0' NOT NULL,
    hidden           tinyint(4) unsigned DEFAULT '0' NOT NULL,
    starttime        int(11) unsigned    DEFAULT '0' NOT NULL,
    endtime          int(11) unsigned    DEFAULT '0' NOT NULL,

    t3ver_oid        int(11)             DEFAULT '0' NOT NULL,
    t3ver_id         int(11)             DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)             DEFAULT '0' NOT NULL,
    t3ver_label      varchar(255)        DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)          DEFAULT '0' NOT NULL,
    t3ver_stage      int(11)             DEFAULT '0' NOT NULL,
    t3ver_count      int(11)             DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)             DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)             DEFAULT '0' NOT NULL,

    t3_origuid       int(11)             DEFAULT '0' NOT NULL,
    sys_language_uid int(11)             DEFAULT '0' NOT NULL,
    l10n_parent      int(11)             DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumblob,

    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY t3ver_oid (t3ver_oid, t3ver_wsid),
    KEY language (l10n_parent, sys_language_uid)

);