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