View file IPS Community Suite 4.7.8 NULLED/applications/blog/setup/upg_105013/queries.json
{
"1": {
"method": "dropTable",
"params": [
"blog_categories",
true
]
},
"2": {
"method": "createTable",
"params": [
{
"name": "blog_categories",
"columns": {
"category_id": {
"allow_null": false,
"auto_increment": true,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 5,
"name": "category_id",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"category_seo_name": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 255,
"name": "category_seo_name",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"category_position": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 5,
"name": "category_position",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"category_parent": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 5,
"name": "category_parent",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
}
},
"indexes": {
"PRIMARY": {
"type": "primary",
"name": "PRIMARY",
"length": [
null
],
"columns": [
"category_id"
]
},
"pg_position": {
"type": "key",
"name": "pg_position",
"length": [
null
],
"columns": [
"category_position"
]
},
"pg_parent": {
"type": "key",
"name": "pg_parent",
"length": [
null
],
"columns": [
"category_parent"
]
}
}
}
]
},
"3": {
"method": "createTable",
"params": [
{
"name": "blog_entry_categories",
"columns": {
"entry_category_id": {
"allow_null": false,
"auto_increment": true,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 10,
"name": "entry_category_id",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_category_name": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 255,
"name": "entry_category_name",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_category_seo_name": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 255,
"name": "entry_category_seo_name",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_category_position": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 5,
"name": "entry_category_position",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_category_blog_id": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "",
"length": 10,
"name": "entry_category_blog_id",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_category_count": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "entry_category_count",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
}
},
"indexes": {
"PRIMARY": {
"type": "primary",
"name": "PRIMARY",
"length": [
null
],
"columns": [
"entry_category_id"
]
},
"pg_position": {
"type": "key",
"name": "pg_position",
"length": [
null
],
"columns": [
"entry_category_position"
]
}
}
}
]
},
"4": {
"method": "addColumn",
"params": [
"blog_blogs",
{
"name": "blog_category_id",
"type": "BIGINT",
"length": 20,
"decimals": null,
"values": null,
"allow_null": true,
"default": null,
"comment": "",
"unsigned": true,
"zerofill": false,
"auto_increment": false,
"binary": false
}
]
},
"5": {
"method": "update",
"params": [
"blog_blogs",
{
"blog_category_id": 1
}
]
},
"6": {
"method": "addColumn",
"params": [
"blog_entries",
{
"name": "entry_category_id",
"type": "INT",
"length": 10,
"decimals": null,
"values": null,
"allow_null": true,
"default": null,
"comment": "",
"unsigned": true,
"zerofill": false,
"auto_increment": false,
"binary": false
}
]
},
"7": {
"method": "addIndex",
"params": [
"blog_blogs",
{
"type": "key",
"name": "blog_category_id",
"columns": [
"blog_category_id"
],
"length": [
null
]
}
]
},
"8": {
"method": "addColumn",
"params": [
"blog_entries",
{
"name": "entry_append_edit",
"type": "TINYINT",
"length": 1,
"decimals": null,
"values": null,
"allow_null": false,
"default": "0",
"comment": "",
"unsigned": false,
"zerofill": false,
"auto_increment": false,
"binary": false
}
]
},
"9": {
"method": "addColumn",
"params": [
"blog_entries",
{
"name": "entry_edit_show",
"type": "TINYINT",
"length": 1,
"decimals": null,
"values": null,
"allow_null": false,
"default": "0",
"comment": "",
"unsigned": false,
"zerofill": false,
"auto_increment": false,
"binary": false
}
]
},
"10": {
"method": "dropColumn",
"params": [
"blog_entries",
"entry_edit_show"
]
},
"11": {
"method": "addColumn",
"params": [
"blog_entries",
{
"name": "entry_edit_reason",
"type": "VARCHAR",
"length": 255,
"decimals": null,
"values": null,
"allow_null": true,
"default": null,
"comment": "",
"unsigned": false,
"zerofill": false,
"auto_increment": false,
"binary": false
}
]
},
"12": {
"method": "delete",
"params": [
"core_sys_lang_words",
[
"word_key=?",
"blog_allow_rss_desc"
]
]
},
"13": {
"method": "changeColumn",
"params": [
"blog_comments",
"comment_text",
{
"name": "comment_text",
"type": "MEDIUMTEXT",
"length": 0,
"decimals": null,
"values": [],
"allow_null": true,
"default": null,
"comment": "",
"unsigned": false,
"auto_increment": false
}
]
},
"14": {
"method": "changeColumn",
"params": [
"blog_entries",
"entry_meta_data",
{
"name": "entry_meta_data",
"type": "TINYINT",
"length": 1,
"decimals": null,
"values": null,
"allow_null": false,
"default": "0",
"comment": "",
"unsigned": true,
"auto_increment": false
}
]
}
}