<?php
defined( '_VALID_LM' ) or die( 'Direct Access to this location is not allowed.' );
	/*
	 *	WSI Flat Table Manager CREATE TABLE functions
	 * (C)2003 WSI, ALL RIGHTS RESERVED. E-mail: support@webbstyle.com
	 * Version stable 0.1
	 *
	 * Flat File Database Engine
	*********************************************************************************************/

	if (!defined("DB_ERRORMSG_107")) { define ("DB_ERRORMSG_107", "ERROR 107 Could not create table directory."); }

	function &_create(&$thiz, $sqlstring) {

		$rs = false;

		$sp=&$thiz->sp;
        $sp->setString($sqlstring);
		$vals=$sp->parseSqlQuery();
		$table =  $vals->table;
		$columns = $vals->colNames;
		$columntypes = $vals->colTypes;
		$columndefault = $vals->fieldValues;
		

		if (is_dir ($thiz->db_name.$table) || !@mkdir ($thiz->db_name.$table,0777) ) {

			$thiz->ErrorMsg[0] = DB_ERRORMSG_107;

		} else 	{
			$nncols="";
			$typecols="";
			$body = "<?php\n\n";
			$int = array("int", "smallint", "tinyint");


			for($i=0;$i<count($columns);$i++) {

//				$tmp = explode (" ", trim($column));
				$body .= "\$columns['".$columns[$i]."'] = ";

				if ($columns[$i] == 'id') {

					$body .= "'c'";
					$typecols .= "\n\$typecolumns['id'] = '".$columntypes[$i]."';";

				} else {
					
					if(isset($columndefault[$i]))
						{
						$body .= "'nn'";
						$nncols.="\n\$nncolumns['".$columns[$i]."'] = '".$columndefault[$i]."';";
						}else 
						{
						$body .= "'n'";
						}
												
					$typecols .= "\n\$typecolumns['".$columns[$i]."'] = '".$columntypes[$i]."';";	

				} 
				$body .= ";\n";
				}

				
			$body .= "$nncols\n\n$typecols\n\n?>";

			if ($fp = @fopen($thiz->db_name.$table.'/schema.php', "w+")) {

				fputs($fp, $body);
				fclose ($fp);
				$rs = true;

			} else {

				$thiz->ErrorMsg[] = DB_ERRORMSG_105;
				$rs = false;

			}

		}

		if ($rs) {

			$thiz->nid = $table.' (table) created';
			return true;

		} else {

			return false;

		}

	}

?>