Advanced Search

Return to Snippet

Revision: 72667
at October 12, 2017 23:23 by acosonic
Initial Code 
# -*- coding: utf-8 -*-
# MySQL Workbench Python script
# <description>
# Written in MySQL Workbench 6.3.6
import grt
for table in schema.tables:
    column = grt.classes.db_mysql_Column()
    column.name = "created"
    table.addColumn(column)
    column.setParseType("TIMESTAMP", None)
    column.defaultValue = "CURRENT_TIMESTAMP"
    column = grt.classes.db_mysql_Column()
    column.name = "modified"
    table.addColumn(column)
    column.setParseType("TIMESTAMP", None)
Initial URL 









Initial Description





Name this script whatever you want, and run it via Workbench Scripting shell









Initial Title





MySql workbench add created and modified columns for CAKEPHP









Initial Tags





mysql, cakephp









Initial Language





Python