====== getTableCreate ====== {#JAPI Joomla.Framework Database JDatabase::getTableCreate #} Generates the SQL code that would be required to create new (empty) tables exactly like the ones specified. Returns an array of SQL 'CREATE TABLE' statements. ===== Syntax ===== array getTableCreate ( **$tables** ) | **$tables** | array | is an array of strings containing a list of table names. | ===== Examples ===== $database =& JFactory::getDBO(); $prefix = $database->_table_prefix; $tables = array( $prefix.'content_frontpage', $prefix.'content_rating' ); $result = $database->getTableCreate( $tables ); print_r( $result ); might produce: Array ( [jos_content_frontpage] => Array ( [0] => CREATE TABLE `jos_content_frontpage` ( `content_id` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`content_id`) ) TYPE=MyISAM ) [jos_content_rating] => Array ( [0] => CREATE TABLE `jos_content_rating` ( `content_id` int(11) NOT NULL default '0', `rating_sum` int(11) unsigned NOT NULL default '0', `rating_count` int(11) unsigned NOT NULL default '0', `lastip` varchar(50) NOT NULL default '', PRIMARY KEY (`content_id`) ) TYPE=MyISAM ) ) ---- ~~DISCUSSION~~