File: sql/modulebuilder_3.03_migrate.yml

Recommend this page to a friend!
  Classes of Goffy G  >  XOOPS Modules Builder  >  sql/modulebuilder_3.03_migrate.yml  >  Download  
File: sql/modulebuilder_3.03_migrate.yml
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: XOOPS Modules Builder
Generate new modules for the XOOPS CMS
Author: By
Last change:
Date: 2 months ago
Size: 21,174 bytes
 

Contents

Class file image Download
modulebuilder_settings:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: set_id
            attributes: ' int(5) unsigned  NOT NULL auto_increment'
        -
            name: set_name
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''My Module'' '
        -
            name: set_dirname
            attributes: ' varchar(100)  NOT NULL  DEFAULT ''mymoduledirname'' '
        -
            name: set_version
            attributes: ' varchar(5)  NOT NULL  DEFAULT ''1.0'' '
        -
            name: set_since
            attributes: ' varchar(5)  NOT NULL  DEFAULT ''1.0'' '
        -
            name: set_min_php
            attributes: ' varchar(5)  NOT NULL  DEFAULT ''7.0'' '
        -
            name: set_min_xoops
            attributes: ' varchar(8)  NOT NULL  DEFAULT ''2.5.10'' '
        -
            name: set_min_admin
            attributes: ' varchar(8)  NOT NULL  DEFAULT ''1.2'' '
        -
            name: set_min_mysql
            attributes: ' varchar(8)  NOT NULL  DEFAULT ''5.5'' '
        -
            name: set_description
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''This module is for doing following...'' '
        -
            name: set_author
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''TDM XOOPS'' '
        -
            name: set_author_mail
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''info@email.com'' '
        -
            name: set_author_website_url
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''http://xoops.org'' '
        -
            name: set_author_website_name
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''XOOPS Project'' '
        -
            name: set_credits
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''XOOPS Development Team'' '
        -
            name: set_license
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''GPL 2.0 or later'' '
        -
            name: set_release_info
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''release_info'' '
        -
            name: set_release_file
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''release_info file'' '
        -
            name: set_manual
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''link to manual file'' '
        -
            name: set_manual_file
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''install.txt'' '
        -
            name: set_image
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''empty.png'' '
        -
            name: set_demo_site_url
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''https://xoops.org'' '
        -
            name: set_demo_site_name
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''XOOPS Demo Site'' '
        -
            name: set_support_url
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''http://xoops.org/modules/newbb'' '
        -
            name: set_support_name
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''Support Forum'' '
        -
            name: set_website_url
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''www.xoops.org'' '
        -
            name: set_website_name
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''XOOPS Project'' '
        -
            name: set_release
            attributes: ' varchar(11)  NOT NULL  DEFAULT ''2015-05-02'' '
        -
            name: set_status
            attributes: ' varchar(150)  NOT NULL  DEFAULT ''Beta 1'' '
        -
            name: set_admin
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''1'' '
        -
            name: set_user
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''1'' '
        -
            name: set_blocks
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''1'' '
        -
            name: set_search
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: set_comments
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: set_notifications
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: set_permissions
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: set_inroot_copy
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: set_donations
            attributes: ' varchar(50)  NOT NULL  DEFAULT ''6KJ7RW5DR3VTJ'' '
        -
            name: set_subversion
            attributes: ' varchar(10)  NOT NULL  DEFAULT ''13070'' '
        -
            name: set_type
            attributes: ' tinyint(3) unsigned  NOT NULL  DEFAULT ''1'' '
    keys:
        PRIMARY:
            columns: set_id
            unique: true
modulebuilder_modules:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: mod_id
            attributes: ' int(5) unsigned  NOT NULL auto_increment'
        -
            name: mod_name
            attributes: ' varchar(200)  NOT NULL  DEFAULT '''' '
        -
            name: mod_dirname
            attributes: ' varchar(100)  NOT NULL  DEFAULT '''' '
        -
            name: mod_version
            attributes: ' varchar(4)  NOT NULL  DEFAULT ''1.0'' '
        -
            name: mod_since
            attributes: ' varchar(4)  NOT NULL  DEFAULT ''1.0'' '
        -
            name: mod_min_php
            attributes: ' varchar(4)  NOT NULL  DEFAULT ''5.5'' '
        -
            name: mod_min_xoops
            attributes: ' varchar(6)  NOT NULL  DEFAULT ''2.5.9'' '
        -
            name: mod_min_admin
            attributes: ' varchar(4)  NOT NULL  DEFAULT ''1.2'' '
        -
            name: mod_min_mysql
            attributes: ' varchar(6)  NOT NULL  DEFAULT ''5.5'' '
        -
            name: mod_description
            attributes: ' text '
        -
            name: mod_author
            attributes: ' varchar(200)  NOT NULL  DEFAULT ''TDM XOOPS'' '
        -
            name: mod_author_mail
            attributes: ' varchar(200)  NOT NULL  DEFAULT ''info@email.com'' '
        -
            name: mod_author_website_url
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''http://'' '
        -
            name: mod_author_website_name
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''' '
        -
            name: mod_credits
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''TDM XOOPS'' '
        -
            name: mod_license
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''GNU'' '
        -
            name: mod_release_info
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''' '
        -
            name: mod_release_file
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''' '
        -
            name: mod_manual
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''' '
        -
            name: mod_manual_file
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''' '
        -
            name: mod_image
            attributes: ' varchar(200)  NOT NULL  DEFAULT '''' '
        -
            name: mod_demo_site_url
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''http://'' '
        -
            name: mod_demo_site_name
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''' '
        -
            name: mod_support_url
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''http://'' '
        -
            name: mod_support_name
            attributes: ' varchar(200)  NOT NULL  DEFAULT ''XOOPS Support Forum'' '
        -
            name: mod_website_url
            attributes: ' varchar(255)  NOT NULL  DEFAULT ''http://'' '
        -
            name: mod_website_name
            attributes: ' varchar(200)  NOT NULL  DEFAULT ''XOOPS'' '
        -
            name: mod_release
            attributes: ' varchar(11)  NOT NULL  DEFAULT ''00-00-0000'' '
        -
            name: mod_status
            attributes: ' varchar(150)  NOT NULL  DEFAULT ''Beta 1'' '
        -
            name: mod_admin
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''1'' '
        -
            name: mod_user
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''1'' '
        -
            name: mod_blocks
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''1'' '
        -
            name: mod_search
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: mod_comments
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: mod_notifications
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: mod_permissions
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: mod_inroot_copy
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''1'' '
        -
            name: mod_donations
            attributes: ' varchar(50)  NOT NULL  DEFAULT ''6KJ7RW5DR3VTJ'' '
        -
            name: mod_subversion
            attributes: ' varchar(10)  NOT NULL  DEFAULT ''12550'' '
    keys:
        mod_dirname:
            columns: mod_dirname
            unique: true
        mod_name:
            columns: mod_name
            unique: false
        PRIMARY:
            columns: mod_id
            unique: true
modulebuilder_tables:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: table_id
            attributes: ' int(5) unsigned  NOT NULL auto_increment'
        -
            name: table_mid
            attributes: ' int(5) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_category
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_name
            attributes: ' varchar(150)  NOT NULL  DEFAULT '''' '
        -
            name: table_solename
            attributes: ' varchar(150)  NOT NULL  DEFAULT '''' '
        -
            name: table_fieldname
            attributes: ' varchar(150)  NOT NULL  DEFAULT '''' '
        -
            name: table_nbfields
            attributes: ' int(5) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_order
            attributes: ' int(5) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_image
            attributes: ' varchar(150)  NOT NULL  DEFAULT '''' '
        -
            name: table_autoincrement
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''1'' '
        -
            name: table_install
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_index
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_blocks
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_admin
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''1'' '
        -
            name: table_user
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_submenu
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_submit
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_tag
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_broken
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_search
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_comments
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_notifications
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_permissions
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_rate
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_print
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_pdf
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_rss
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_single
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: table_visit
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
    keys:
        PRIMARY:
            columns: table_id
            unique: true
        table_mid:
            columns: table_mid
            unique: false
        table_name:
            columns: table_name
            unique: false
modulebuilder_fields:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: field_id
            attributes: ' int(8) unsigned  NOT NULL auto_increment'
        -
            name: field_mid
            attributes: ' int(5) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_tid
            attributes: ' int(5) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_order
            attributes: ' int(5) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_name
            attributes: ' varchar(150)  NOT NULL  DEFAULT '''' '
        -
            name: field_type
            attributes: ' varchar(15)  NOT NULL  DEFAULT '''' '
        -
            name: field_value
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''' '
        -
            name: field_attribute
            attributes: ' varchar(20)  NOT NULL  DEFAULT '''' '
        -
            name: field_null
            attributes: ' varchar(10)  NOT NULL  DEFAULT '''' '
        -
            name: field_default
            attributes: ' varchar(100)  NOT NULL  DEFAULT '''' '
        -
            name: field_key
            attributes: ' varchar(10)  NOT NULL  DEFAULT '''' '
        -
            name: field_element
            attributes: ' varchar(80)  NOT NULL  DEFAULT '''' '
        -
            name: field_parent
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_admin
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_inlist
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_inform
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_user
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_thead
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_tbody
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_tfoot
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_block
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_main
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_search
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: field_required
            attributes: ' tinyint(1) unsigned  NOT NULL  DEFAULT ''0'' '
    keys:
        field_mid:
            columns: field_mid
            unique: false
        field_tid:
            columns: field_tid
            unique: false
        PRIMARY:
            columns: field_id
            unique: true
modulebuilder_languages:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: lng_id
            attributes: ' int(5) unsigned  NOT NULL auto_increment'
        -
            name: lng_mid
            attributes: ' int(5) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: lng_file
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''' '
        -
            name: lng_define
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''' '
        -
            name: lng_description
            attributes: ' varchar(255)  NOT NULL  DEFAULT '''' '
    keys:
        lng_mid:
            columns: lng_mid
            unique: false
        PRIMARY:
            columns: lng_id
            unique: true
modulebuilder_fieldtype:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: fieldtype_id
            attributes: ' int(5) unsigned  NOT NULL auto_increment'
        -
            name: fieldtype_name
            attributes: ' varchar(15)  NOT NULL  DEFAULT '''' '
        -
            name: fieldtype_value
            attributes: ' varchar(15)  NOT NULL  DEFAULT '''' '
    keys:
        fieldtype_name:
            columns: fieldtype_name
            unique: false
        PRIMARY:
            columns: fieldtype_id
            unique: true
modulebuilder_fieldattributes:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: fieldattribute_id
            attributes: ' int(5) unsigned  NOT NULL auto_increment'
        -
            name: fieldattribute_name
            attributes: ' varchar(100)  NOT NULL  DEFAULT '''' '
        -
            name: fieldattribute_value
            attributes: ' varchar(100)  NOT NULL  DEFAULT '''' '
    keys:
        fieldattribute_name:
            columns: fieldattribute_name
            unique: false
        PRIMARY:
            columns: fieldattribute_id
            unique: true
modulebuilder_fieldnull:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: fieldnull_id
            attributes: ' int(5) unsigned  NOT NULL auto_increment'
        -
            name: fieldnull_name
            attributes: ' varchar(100)  NOT NULL  DEFAULT '''' '
        -
            name: fieldnull_value
            attributes: ' varchar(100)  NOT NULL  DEFAULT '''' '
    keys:
        fieldnull_name:
            columns: fieldnull_name
            unique: false
        PRIMARY:
            columns: fieldnull_id
            unique: true
modulebuilder_fieldkey:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: fieldkey_id
            attributes: ' int(5) unsigned  NOT NULL auto_increment'
        -
            name: fieldkey_name
            attributes: ' varchar(100)  NOT NULL  DEFAULT '''' '
        -
            name: fieldkey_value
            attributes: ' varchar(100)  NOT NULL  DEFAULT '''' '
    keys:
        fieldkey_name:
            columns: fieldkey_name
            unique: false
        PRIMARY:
            columns: fieldkey_id
            unique: true
modulebuilder_fieldelements:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: fieldelement_id
            attributes: ' int(5) unsigned  NOT NULL auto_increment'
        -
            name: fieldelement_mid
            attributes: ' int(11) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: fieldelement_tid
            attributes: ' int(11) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: fieldelement_name
            attributes: ' varchar(100)  NOT NULL  DEFAULT '''' '
        -
            name: fieldelement_value
            attributes: ' varchar(100)  NOT NULL  DEFAULT '''' '
        -
            name: fieldelement_sort
            attributes: ' int(1) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: fieldelement_deftype
            attributes: ' int(10) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: fieldelement_defvalue
            attributes: ' int(10) unsigned  NOT NULL  DEFAULT ''0'' '
    keys:
        fieldelement_mid:
            columns: fieldelement_mid
            unique: false
        fieldelement_tid:
            columns: fieldelement_tid
            unique: false
        PRIMARY:
            columns: fieldelement_id
            unique: true
modulebuilder_morefiles:
    options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8'
    columns:
        -
            name: file_id
            attributes: ' int(5) unsigned  NOT NULL auto_increment'
        -
            name: file_mid
            attributes: ' int(5) unsigned  NOT NULL  DEFAULT ''0'' '
        -
            name: file_name
            attributes: ' varchar(100)  NOT NULL  DEFAULT '''' '
        -
            name: file_extension
            attributes: ' varchar(5)  NOT NULL  DEFAULT ''.php'' '
        -
            name: file_infolder
            attributes: ' varchar(50)  NOT NULL  DEFAULT '''' '
    keys:
        PRIMARY:
            columns: file_id
            unique: true

For more information send a message to info at phpclasses dot org.