Rev 11 | Details | Compare with Previous | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 11 | daniel-mar | 1 | <?php |
| 2 | |||
| 14 | daniel-mar | 3 | if (!defined('WBLEGAL')) die('Kann nicht ohne Personal WebBase ausgeführt werden.'); |
| 11 | daniel-mar | 4 | |
| 5 | ib_newdatabasetable('datentraeger_eintraege', $m2, 'user', "bigint(21) NOT NULL default '0'", |
||
| 6 | 'nr', "bigint(21) NOT NULL default '0'", |
||
| 7 | 'kategorie', "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 NULL", |
||
| 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, 'datentraeger_eintraege', 0); |
||
| 15 | |||
| 16 | ib_newdatabasetable('datentraeger_inhalt', $m2, 'user', "bigint(21) NOT NULL default '0'", |
||
| 17 | 'kategorie', "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, 'datentraeger_inhalt', 0); |
||
| 22 | |||
| 23 | my_add_key($mysql_zugangsdaten['praefix'].'datentraeger_inhalt', 'eintrag', true, 'eintrag'); |
||
| 24 | |||
| 25 | ib_newdatabasetable('datentraeger_kategorien', $m2, 'user', "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($mysql_zugangsdaten['praefix'].'datentraeger_kategorien', 'spalte_and_nummer', true, 'spalte', 'nummer'); |
||
| 31 | |||
| 9 | daniel-mar | 32 | if (function_exists('set_searchable')) set_searchable($m2, 'datentraeger_kategorien', 0); |