Subversion Repositories svnkaklik

Rev

Go to most recent revision | Details | Last modification | View Log

Rev Author Line No. Line
36 kaklik 1 
<?php
2 
 
3 
/**
4 
  V4.80 8 Mar 2006  (c) 2000-2006 John Lim (jlim@natsoft.com.my). All rights reserved.
5 
  Released under both BSD license and Lesser GPL library license.
6 
  Whenever there is any discrepancy between the two licenses,
7 
  the BSD license will take precedence.
8 
 
9 
  Set tabs to 4 for best viewing.
10 
 
11 
*/
12 
 
13 
// security - hide paths
14 
if (!defined('ADODB_DIR')) die();
15 
 
16 
class ADODB2_access extends ADODB_DataDict {
17 
 
18 
	var $databaseType = 'access';
19 
	var $seqField = false;
20 
 
21 
 
22 
 	function ActualType($meta)
23 
	{
24 
		switch($meta) {
25 
		case 'C': return 'TEXT';
26 
		case 'XL':
27 
		case 'X': return 'MEMO';
28 
 
29 
		case 'C2': return 'TEXT'; // up to 32K
30 
		case 'X2': return 'MEMO';
31 
 
32 
		case 'B': return 'BINARY';
33 
 
34 
		case 'D': return 'DATETIME';
35 
		case 'T': return 'DATETIME';
36 
 
37 
		case 'L': return 'BYTE';
38 
		case 'I': return 'INTEGER';
39 
		case 'I1': return 'BYTE';
40 
		case 'I2': return 'SMALLINT';
41 
		case 'I4': return 'INTEGER';
42 
		case 'I8': return 'INTEGER';
43 
 
44 
		case 'F': return 'DOUBLE';
45 
		case 'N': return 'NUMERIC';
46 
		default:
47 
			return $meta;
48 
		}
49 
	}
50 
 
51 
	// return string must begin with space
52 
	function _CreateSuffix($fname, &$ftype, $fnotnull,$fdefault,$fautoinc,$fconstraint)
53 
	{
54 
		if ($fautoinc) {
55 
			$ftype = 'COUNTER';
56 
			return '';
57 
		}
58 
		if (substr($ftype,0,7) == 'DECIMAL') $ftype = 'DECIMAL';
59 
		$suffix = '';
60 
		if (strlen($fdefault)) {
61 
			//$suffix .= " DEFAULT $fdefault";
62 
			if ($this->debug) ADOConnection::outp("Warning: Access does not supported DEFAULT values (field $fname)");
63 
		}
64 
		if ($fnotnull) $suffix .= ' NOT NULL';
65 
		if ($fconstraint) $suffix .= ' '.$fconstraint;
66 
		return $suffix;
67 
	}
68 
 
69 
	function CreateDatabase($dbname,$options=false)
70 
	{
71 
		return array();
72 
	}
73 
 
74 
 
75 
	function SetSchema($schema)
76 
	{
77 
	}
78 
 
79 
	function AlterColumnSQL($tabname, $flds)
80 
	{
81 
		if ($this->debug) ADOConnection::outp("AlterColumnSQL not supported");
82 
		return array();
83 
	}
84 
 
85 
 
86 
	function DropColumnSQL($tabname, $flds)
87 
	{
88 
		if ($this->debug) ADOConnection::outp("DropColumnSQL not supported");
89 
		return array();
90 
	}
91 
 
92 
}
93 
 
94 
 
95 
?>