mambax7/extcal

View on GitHub
sql/extcal_2.40_migrate.yml

Summary

Maintainability
Test Coverage
extcal_cat:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: cat_id
            attributes: ' int(11)  NOT NULL auto_increment'
        -
            name: cat_name
            attributes: ' varchar(255)  NOT NULL '
        -
            name: cat_desc
            attributes: ' text  DEFAULT ''NULL'' '
        -
            name: cat_color
            attributes: ' varchar(6)  NOT NULL '
        -
            name: cat_weight
            attributes: ' int(11)  NOT NULL  DEFAULT ''0'' '
        -
            name: cat_icone
            attributes: ' varchar(50)  NOT NULL '
    keys:
        PRIMARY:
            columns: cat_id
            unique: true
extcal_event:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: event_id
            attributes: ' int(11)  NOT NULL auto_increment'
        -
            name: cat_id
            attributes: ' int(11)  NOT NULL  DEFAULT ''0'' '
        -
            name: event_title
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''''''' '
        -
            name: event_desc
            attributes: ' text  DEFAULT ''NULL'' '
        -
            name: event_organisateur
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''''''' '
        -
            name: event_contact
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''''''' '
        -
            name: event_url
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''''''' '
        -
            name: event_email
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''''''' '
        -
            name: event_address
            attributes: ' text  DEFAULT ''NULL'' '
        -
            name: event_approved
            attributes: ' tinyint(1)  NOT NULL  DEFAULT ''0'' '
        -
            name: event_start
            attributes: ' int(11)  NOT NULL  DEFAULT ''0'' '
        -
            name: event_end
            attributes: ' int(11)  NOT NULL  DEFAULT ''0'' '
        -
            name: event_submitter
            attributes: ' int(11)  NOT NULL  DEFAULT ''0'' '
        -
            name: event_submitdate
            attributes: ' int(11)  NOT NULL  DEFAULT ''0'' '
        -
            name: event_nbmember
            attributes: ' tinyint(4)  NOT NULL  DEFAULT ''0'' '
        -
            name: event_isrecur
            attributes: ' tinyint(1)  NOT NULL '
        -
            name: event_recur_rules
            attributes: ' varchar(255)  NOT NULL '
        -
            name: event_recur_start
            attributes: ' int(11)  NOT NULL '
        -
            name: event_recur_end
            attributes: ' int(11)  NOT NULL '
        -
            name: event_picture1
            attributes: ' varchar(255)  NOT NULL '
        -
            name: event_picture2
            attributes: ' varchar(255)  NOT NULL '
        -
            name: event_price
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''''''' '
        -
            name: event_location
            attributes: ' int(5)  NOT NULL  DEFAULT ''0'' '
        -
            name: dohtml
            attributes: ' tinyint(1)  NOT NULL  DEFAULT ''0'' '
        -
            name: event_icone
            attributes: ' varchar(50)  NOT NULL '
    keys:
        PRIMARY:
            columns: event_id
            unique: true
extcal_eventmember:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: eventmember_id
            attributes: ' int(11)  NOT NULL auto_increment'
        -
            name: event_id
            attributes: ' int(11)  NOT NULL  DEFAULT ''0'' '
        -
            name: uid
            attributes: ' int(11)  NOT NULL  DEFAULT ''0'' '
        -
            name: status
            attributes: ' int(11)  NOT NULL  DEFAULT ''0'' '
    keys:
        eventmember:
            columns: 'event_id, uid'
            unique: true
        PRIMARY:
            columns: eventmember_id
            unique: true
extcal_eventnotmember:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: eventnotmember_id
            attributes: ' int(11)  NOT NULL auto_increment'
        -
            name: event_id
            attributes: ' int(11)  NOT NULL  DEFAULT ''0'' '
        -
            name: uid
            attributes: ' int(11)  NOT NULL  DEFAULT ''0'' '
    keys:
        eventnotmember:
            columns: 'event_id, uid'
            unique: true
        PRIMARY:
            columns: eventnotmember_id
            unique: true
extcal_file:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: file_id
            attributes: ' int(11)  NOT NULL auto_increment'
        -
            name: file_name
            attributes: ' varchar(255)  NOT NULL '
        -
            name: file_nicename
            attributes: ' varchar(255)  NOT NULL '
        -
            name: file_mimetype
            attributes: ' varchar(255)  NOT NULL '
        -
            name: file_size
            attributes: ' int(11)  NOT NULL '
        -
            name: file_download
            attributes: ' int(11)  NOT NULL '
        -
            name: file_date
            attributes: ' int(11)  NOT NULL '
        -
            name: file_approved
            attributes: ' tinyint(1)  NOT NULL '
        -
            name: event_id
            attributes: ' int(11)  NOT NULL '
        -
            name: uid
            attributes: ' int(11)  NOT NULL '
    keys:
        PRIMARY:
            columns: file_id
            unique: true
extcal_location:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: id
            attributes: ' int(5)  NOT NULL auto_increment'
        -
            name: nom
            attributes: ' varchar(255)  NOT NULL '
        -
            name: description
            attributes: ' text  DEFAULT ''NULL'' '
        -
            name: logo
            attributes: ' varchar(255)  NOT NULL '
        -
            name: categorie
            attributes: ' varchar(255)  NOT NULL '
        -
            name: adresse
            attributes: ' varchar(255)  NOT NULL '
        -
            name: adresse2
            attributes: ' varchar(255)  NOT NULL '
        -
            name: cp
            attributes: ' varchar(10)  NOT NULL '
        -
            name: ville
            attributes: ' varchar(50)  NOT NULL '
        -
            name: tel_fixe
            attributes: ' varchar(20)  NOT NULL '
        -
            name: tel_portable
            attributes: ' varchar(20)  NOT NULL '
        -
            name: mail
            attributes: ' varchar(255)  NOT NULL '
        -
            name: site
            attributes: ' varchar(255)  NOT NULL '
        -
            name: horaires
            attributes: ' text  DEFAULT ''NULL'' '
        -
            name: divers
            attributes: ' text  DEFAULT ''NULL'' '
        -
            name: tarifs
            attributes: ' text  DEFAULT ''NULL'' '
        -
            name: map
            attributes: ' text  DEFAULT ''NULL'' '
    keys:
        PRIMARY:
            columns: id
            unique: true