Revision 1671
Added by Dietmar over 12 years ago
| save.php | ||
|---|---|---|
| 401 | 401 |
. ' `parent` INT NOT NULL DEFAULT \'0\',' |
| 402 | 402 |
. ' `root_parent` INT NOT NULL DEFAULT \'0\',' |
| 403 | 403 |
. ' `level` INT NOT NULL DEFAULT \'0\',' |
| 404 |
. ' `link` TEXT NOT NULL,'
|
|
| 404 |
. ' `link` VARCHAR( 255 ) NOT NULL,'
|
|
| 405 | 405 |
. ' `target` VARCHAR( 7 ) NOT NULL DEFAULT \'\' ,' |
| 406 | 406 |
. ' `page_title` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,' |
| 407 |
. ' `page_icon` TEXT NOT NULL DEFAULT \'/templates/*/title_images\' ,'
|
|
| 407 |
. ' `page_icon` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
|
|
| 408 | 408 |
. ' `menu_title` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,' |
| 409 |
. ' `menu_icon_0` TEXT NOT NULL DEFAULT \'\' ,'
|
|
| 410 |
. ' `menu_icon_1` TEXT NOT NULL DEFAULT \'\' ,'
|
|
| 409 |
. ' `menu_icon_0` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
|
|
| 410 |
. ' `menu_icon_1` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
|
|
| 411 | 411 |
. ' `description` TEXT NOT NULL ,' |
| 412 | 412 |
. ' `keywords` TEXT NOT NULL ,' |
| 413 |
. ' `page_trail` TEXT NOT NULL ,'
|
|
| 413 |
. ' `page_trail` VARCHAR( 255 ) NOT NULL ,'
|
|
| 414 | 414 |
. ' `template` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,' |
| 415 | 415 |
. ' `visibility` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,' |
| 416 | 416 |
. ' `position` INT NOT NULL DEFAULT \'0\',' |
| 417 | 417 |
. ' `menu` INT NOT NULL DEFAULT \'0\',' |
| 418 | 418 |
. ' `language` VARCHAR( 5 ) NOT NULL DEFAULT \'\' ,' |
| 419 |
. ' `page_code` INT NOT NULL DEFAULT \'0\',' |
|
| 419 | 420 |
. ' `searching` INT NOT NULL DEFAULT \'0\',' |
| 420 |
. ' `admin_groups` TEXT NOT NULL DEFAULT \'1\' ,'
|
|
| 421 |
. ' `admin_users` TEXT NOT NULL ,'
|
|
| 422 |
. ' `viewing_groups` TEXT NOT NULL DEFAULT \'1\' ,'
|
|
| 423 |
. ' `viewing_users` TEXT NOT NULL ,'
|
|
| 421 |
. ' `admin_groups` VARCHAR( 512 ) NOT NULL DEFAULT \'1\' ,'
|
|
| 422 |
. ' `admin_users` VARCHAR( 512 ) NOT NULL ,'
|
|
| 423 |
. ' `viewing_groups` VARCHAR( 512 ) NOT NULL DEFAULT \'1\' ,'
|
|
| 424 |
. ' `viewing_users` VARCHAR( 512 ) NOT NULL ,'
|
|
| 424 | 425 |
. ' `modified_when` INT NOT NULL DEFAULT \'0\',' |
| 425 | 426 |
. ' `modified_by` INT NOT NULL DEFAULT \'0\',' |
| 426 | 427 |
. ' PRIMARY KEY ( `page_id` ) ' |
| 427 | 428 |
. ' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci'; |
| 428 |
$database->query($pages); |
|
| 429 |
if(!$database->query($pages)) {
|
|
| 430 |
} |
|
| 429 | 431 |
|
| 430 | 432 |
// Sections table |
| 431 | 433 |
$pages = 'CREATE TABLE `'.TABLE_PREFIX.'sections` ( `section_id` INT NOT NULL auto_increment,' |
Also available in: Unified diff
fixes installer and upgrade-script