Difference between revisions of "Database.sql Generator"

From Contao Community Documentation

m
m
Line 13: Line 13:
 
[[Category:Extensions]]
 
[[Category:Extensions]]
  
[[File:Dbsql_gen.jpg|left|thumb|Generator]]<br />The database.sql Generator is a backend helper module for developers.<br />In the backend, there is a new menu item "Developer tools", including the point will "database.sql Generator" to be found.<br />After selecting the table, the corresponding SQL Create statement is generated and displayed.<br />
+
[[File:Dbsql_gen.jpg|left|thumb|Generator]]<br />The database.sql Generator is a backend helper module for developers.<br />In the backend, there is a new menu item "Developer tools", including the point will "database.sql Generator" to be found.<br />After selecting the table, the corresponding SQL Create statement is generated and displayed.
This can then be displayed in separate window (view source) or copied to the clipboard. (copy to clipboard)&sup1;<br /><br />
+
<br />
 +
Has an extension multiple tables with a common prefix, we can all be generated at a time. For this it is possible from version 1.2.0 to be able to enter in another field a table prefix.
 +
To enter the prefix "tl_cal" would be, for example, generate the statements for the tables "tl_calendar" and "tl_calendar_events.
 +
 
 +
<br />
 +
The output can then be displayed in separate window (view source) or copied to the clipboard. (copy to clipboard)&sup1;<br /><br />
 
&sup1;: "copy to clipboard" requires Flash
 
&sup1;: "copy to clipboard" requires Flash
 
<br style="clear: both" />  
 
<br style="clear: both" />  
 
----
 
----
 
--[[User:BugBuster|BugBuster]] 13:53, 7 September 2010 (CEST)
 
--[[User:BugBuster|BugBuster]] 13:53, 7 September 2010 (CEST)

Revision as of 20:09, 25 October 2010

I'm not a native English speaker. Please correct my mistakes.

Extension-Overview
Name of the developer Glen Langer (BugBuster)
Developer Website http://www.contao.glen-langer.de
Version of the extension 1.2.0
Compatibility with Contao Version from 2.9
Compatibility with TYPOlight Version 2.8 (not tested, but should work)
Link to Extension Repository http://www.contao.org/extension-list/view/dbsql_generator.en.html
Donate the developer Cappuccino
Link to Tracker http://dev.typolight-forge.org/projects/dbsqlgen/issues
Generator

The database.sql Generator is a backend helper module for developers.
In the backend, there is a new menu item "Developer tools", including the point will "database.sql Generator" to be found.
After selecting the table, the corresponding SQL Create statement is generated and displayed.


Has an extension multiple tables with a common prefix, we can all be generated at a time. For this it is possible from version 1.2.0 to be able to enter in another field a table prefix. To enter the prefix "tl_cal" would be, for example, generate the statements for the tables "tl_calendar" and "tl_calendar_events.


The output can then be displayed in separate window (view source) or copied to the clipboard. (copy to clipboard)¹

¹: "copy to clipboard" requires Flash


--BugBuster 13:53, 7 September 2010 (CEST)

Views
Personal tools

Contao Community Documentation

In other languages
Navigation
Discover
Understand
Enhance
Miscellaneous
Tools