| 1 |
lars |
1 |
<?php
|
|
|
2 |
// $Id: sql.php,v 1.1 2003/06/20 16:54:51 cain Exp $
|
|
|
3 |
|
|
|
4 |
$dbStructure = array(
|
|
|
5 |
'mysql' => array(
|
|
|
6 |
'setup' => array(
|
|
|
7 |
"DROP TABLE IF EXISTS ".TABLE_TREENESTED.";"
|
|
|
8 |
,"DROP TABLE IF EXISTS ".TABLE_TREENESTED."_seq;"
|
|
|
9 |
|
|
|
10 |
,"CREATE TABLE ".TABLE_TREENESTED." (
|
|
|
11 |
id int(11) NOT NULL default '0',
|
|
|
12 |
name varchar(255) NOT NULL default '',
|
|
|
13 |
l int(11) NOT NULL default '0',
|
|
|
14 |
r int(11) NOT NULL default '0',
|
|
|
15 |
parent int(11) NOT NULL default '0',
|
|
|
16 |
comment varchar(255) NOT NULL default '',
|
|
|
17 |
user_id int(11) NOT NULL default '0',
|
|
|
18 |
PRIMARY KEY (id)
|
|
|
19 |
) TYPE=MyISAM;"
|
|
|
20 |
,"INSERT INTO ".TABLE_TREENESTED." VALUES (1, 'Root', 1, 10, 0, '', 0);"
|
|
|
21 |
,"INSERT INTO ".TABLE_TREENESTED." VALUES (2, 'child 1', 8, 9, 1, '', 0);"
|
|
|
22 |
,"INSERT INTO ".TABLE_TREENESTED." VALUES (3, 'child 2', 2, 7, 1, '', 0);"
|
|
|
23 |
,"INSERT INTO ".TABLE_TREENESTED." VALUES (4, 'child 2_1', 5, 6, 3, '', 0);"
|
|
|
24 |
,"INSERT INTO ".TABLE_TREENESTED." VALUES (5, 'child 2_2', 3, 4, 3, '', 0);"
|
|
|
25 |
),
|
|
|
26 |
|
|
|
27 |
'tearDown' => array(
|
|
|
28 |
"DROP TABLE IF EXISTS ".TABLE_TREENESTED.";"
|
|
|
29 |
,"DROP TABLE IF EXISTS ".TABLE_TREENESTED."_seq;"
|
|
|
30 |
)
|
|
|
31 |
),
|
|
|
32 |
|
|
|
33 |
'pgsql' => array(
|
|
|
34 |
'setup' => array(),
|
|
|
35 |
'tearDown'=>array()
|
|
|
36 |
)
|
|
|
37 |
);
|
|
|
38 |
|
|
|
39 |
|
|
|
40 |
|
|
|
41 |
?>
|