Viewing file:  sql.php (1.53 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
// $Id: sql.php 320806 2011-12-09 19:37:22Z danielc $
$dbStructure = array(
'mysql' => array(
'setup' => array(
"DROP TABLE IF EXISTS ".TABLE_TREENESTED.";"
,"DROP TABLE IF EXISTS ".TABLE_TREENESTED."_seq;"
,"CREATE TABLE ".TABLE_TREENESTED." (
id int(11) NOT NULL default '0',
name varchar(255) NOT NULL default '',
l int(11) NOT NULL default '0',
r int(11) NOT NULL default '0',
parent int(11) NOT NULL default '0',
comment varchar(255) NOT NULL default '',
user_id int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;"
,"INSERT INTO ".TABLE_TREENESTED." VALUES (1, 'Root', 1, 10, 0, '', 0);"
,"INSERT INTO ".TABLE_TREENESTED." VALUES (2, 'child 1', 8, 9, 1, '', 0);"
,"INSERT INTO ".TABLE_TREENESTED." VALUES (3, 'child 2', 2, 7, 1, '', 0);"
,"INSERT INTO ".TABLE_TREENESTED." VALUES (4, 'child 2_1', 5, 6, 3, '', 0);"
,"INSERT INTO ".TABLE_TREENESTED." VALUES (5, 'child 2_2', 3, 4, 3, '', 0);"
),
'tearDown' => array(
"DROP TABLE IF EXISTS ".TABLE_TREENESTED.";"
,"DROP TABLE IF EXISTS ".TABLE_TREENESTED."_seq;"
)
),
'pgsql' => array(
'setup' => array(),
'tearDown' => array()
),
);
$dbStructure['mysqli'] = $dbStructure['mysql'];
|