Subversion Repositories personal-webbase

Rev

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

Rev Author Line No. Line
1 daniel-mar 1 
<?php
2 
 
3 
if (!defined('WBLEGAL')) die('Kann nicht ohne Personal WebBase ausgef&uuml;hrt werden.');
4 
 
5 
wb_newdatabasetable('mediacollection_entries', $m2, 'user_cnid', "bigint(21) NOT NULL default '0'",
6 
        'nr', "bigint(21) NOT NULL default '0'",
7 
        'category', "varchar(255) NOT NULL default '0'",
8 
        'name', "varchar(255) NOT NULL default ''",
9 
        'medium', "enum('CD','DVD') NOT NULL default 'CD'",
10 
        'einstellungsdatum', "datetime NOT NULL default '0000-00-00 00:00:00'",
11 
        'gebrannt', "enum('1','0') NOT NULL default '1'",
12 
        'aussortiert', "enum('1','0') NOT NULL default '0'");
13 
 
14 
if (function_exists('set_searchable')) set_searchable($m2, 'mediacollection_entries', 0);
15 
 
16 
wb_newdatabasetable('mediacollection_content', $m2, 'user_cnid', "bigint(21) NOT NULL default '0'",
17 
        'category', "varchar(255) NOT NULL default ''",
18 
        'eintrag', "bigint(21) NOT NULL default '0'",
19 
        'komplett', "longtext NOT NULL");
20 
 
21 
if (function_exists('set_searchable')) set_searchable($m2, 'mediacollection_content', 0);
22 
 
23 
my_add_key($WBConfig->getMySQLPrefix().'mediacollection_content', 'eintrag', true, 'eintrag');
24 
 
25 
wb_newdatabasetable('mediacollection_categories', $m2, 'user_cnid', "bigint(21) NOT NULL default '0'",
26 
        'name', "varchar(255) NOT NULL default ''",
27 
        'nummer', "bigint(21) NOT NULL default '0'",
28 
        'spalte', "char(1) NOT NULL default ''");
29 
 
30 
my_add_key($WBConfig->getMySQLPrefix().'mediacollection_categories', 'spalte_and_nummer', true, 'spalte', 'nummer');
31 
 
32 
if (function_exists('set_searchable')) set_searchable($m2, 'mediacollection_categories', 0);
33 
 
34 
?>