1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
<?php
/*
+----------------------------------------------------------------------+
| ini doc settings updater |
+----------------------------------------------------------------------+
| Copyright (c) 1997-2010 The PHP Group |
+----------------------------------------------------------------------+
| This source file is subject to version 3.0 of the PHP license, |
| that is bundled with this package in the file LICENSE, and is |
| available through the world-wide-web at the following url: |
| http://www.php.net/license/3_0.txt. |
| If you did not receive a copy of the PHP license and are unable to |
| obtain it through the world-wide-web, please send a note to |
| license@php.net so we can mail you a copy immediately. |
+----------------------------------------------------------------------+
| Authors: Nuno Lopes <nlopess@php.net> |
+----------------------------------------------------------------------+
$Id: make_db.php 293138 2010-01-05 10:21:11Z rquadling $
*/
require_once './cvs-versions.php';
$db_open = isset($idx) ? true : false;
if (!$db_open && !$idx = sqlite_open('ini_changelog.sqlite', 0666, $error)) {
die("Couldn't create the DB: $error");
}
$sql = '
CREATE TABLE pecl_changelog (
package TEXT,
version TEXT,
name TEXT,
value TEXT
);
';
$sql2 = '
CREATE TABLE last_seen_values (
name TEXT PRIMARY KEY,
defaultval TEXT,
permissions TEXT
);
';
// the query may fail if the tables already exists
@sqlite_query($idx, $sql);
@sqlite_query($idx, $sql2);
$sql = 'CREATE TABLE changelog (
name TEXT PRIMARY KEY,';
foreach($tags as $tag) {
$sql .= "$tag TEXT,";
}
$sql = substr($sql, 0, -1) . ');';
sqlite_query($idx, $sql);
if (!$db_open) {
sqlite_close($idx);
unset($idx);
}
?>
|
