/dd/ -> 0_0024_inc.php
1 <?php
2
3 // 0_0024_inc.php - defines pdb reprint related tables
4 // 0_0024_inc.php - author: Nico Stuurman <nicost@sourceforge.net>
5
6 /***************************************************************************
7 * Copyright (c) 2001 by Nico Stuurman *
8 * ------------------------------------------------------------------------ *
9 * Creates tables pdfs,pd_type1, and inserts initial values *
10 * *
11 * *
12 * *
13 * This program is free software; you can redistribute it and/or modify it *
14 * under the terms of the GNU General Public License as published by the *
15 * Free Software Foundation; either version 2 of the License, or (at your *
16 * option) any later version. *
17 \**************************************************************************/
18
19 $query="CREATE TABLE pdbs (
20 id int PRIMARY KEY,
21 access char(9),
22 ownerid int,
23 magic int,
24 pdbid char(4),
25 title text,
26 author text,
27 notes text,
28 lastmodby int,
29 lastmoddate int,
30 date int)";
31 if (!$db->Execute($query)) $test=false;
32 $db->Execute("CREATE INDEX pdbs_id_index ON pdbs (id)");
33 $db->Execute("CREATE INDEX pdbs_ownerid_index ON pdbs (ownerid)");
34 $db->Execute("CREATE INDEX pdbs_date_index ON pdbs (date)");
35 $db->Execute("CREATE INDEX pdbs_magic_index ON pdbs (magic)");
36 $db->Execute("CREATE INDEX pdbs_title_index ON pdbs (title)");
37 $db->Execute("CREATE INDEX pdbs_title_index ON pdbs (title(10))");
38
39 $tablesid=$db->GenID("tableoftables_id_seq");
40 $query="INSERT INTO tableoftables VALUES ($tablesid,400,'pdbs','pb')";
41 if (!$db->Execute($query)) $test=false;
42 ?>