Hej i hytten
Vil forsøge mig med dette cms:
http://www.dpp-web.de/index.php?PageId=3&Lang=en&NavId=57
I installationsvejledningen står der:
"Use the file file "dppcms.sql" or "dppcmsdemo.sql" (for the sample project)
to create the required database tables (with phpmyadmin, etc.)."
OK - i den fil står en hel masse der for mig er helt volapyk (indsat
herunder). Hvordan får man de tabeller oprettet på den smarte måde?
ras
-----------------------------
# phpMyAdmin SQL Dump
# version 2.5.6-rc1
#
http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 30, 2004 at 11:59 AM
# Server version: 4.0.16
# PHP Version: 4.3.4
#
# Database : `dppcmsdemo`
#
# --------------------------------------------------------
#
# Table structure for table `cachedata`
#
CREATE TABLE `cachedata` (
`CACHEKEY` varchar(255) NOT NULL default '',
`CACHEEXPIRATION` int(11) NOT NULL default '0',
`GZDATA` blob,
`DATASIZE` int(11) default NULL,
`DATACRC` int(11) default NULL,
PRIMARY KEY (`CACHEKEY`)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table `dpp_content`
#
CREATE TABLE `dpp_content` (
`ID` int(11) NOT NULL auto_increment,
`page_id` int(11) NOT NULL default '0',
`lang` enum('de','en','fr','es','it','ru','tr') NOT NULL default 'de',
`content_pos` float NOT NULL default '0',
`content_type`
enum('headline','subheadline','text','html','php','image','swf','mov')
default NULL,
`content` text,
`content_style` varchar(32) default '0',
`media_id` int(11) NOT NULL default '0',
`media_align`
enum('top','middle','bottom','left','right','texttop','absmiddle','baseline','absbottom')
default NULL,
`link_id` int(11) NOT NULL default '0',
`link_nav` int(11) NOT NULL default '0',
`link_url` tinytext,
`link_target` tinytext,
`content_br` tinyint(4) NOT NULL default '2',
PRIMARY KEY (`ID`),
KEY `page_id` (`page_id`)
) TYPE=MyISAM AUTO_INCREMENT=528 ;
# --------------------------------------------------------
#
# Table structure for table `dpp_media`
#
CREATE TABLE `dpp_media` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`file_type` enum('image','swf','mov','java','real') NOT NULL default
'image',
`file_size` int(11) NOT NULL default '0',
`file_width` int(11) default NULL,
`file_height` int(11) default NULL,
`date_saved` date NOT NULL default '1969-03-02',
`description` text,
`path` tinytext,
`path_thumb` tinytext,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=129 ;
# --------------------------------------------------------
#
# Table structure for table `dpp_nav`
#
CREATE TABLE `dpp_nav` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`nav_pos` float default NULL,
`parent_id` int(11) NOT NULL default '0',
`lang` enum('de','en','fr','es','it','ru','tr') NOT NULL default 'de',
`nav_publish` enum('author','publish','special','offline') NOT NULL
default 'author',
`start_date` date default NULL,
`stop_date` date default NULL,
`link_id` int(11) default NULL,
`link_url` tinytext,
`link_target` tinytext,
`link_nocache` int(1) default NULL,
`link_webgrab` tinytext,
`template_id` int(11) default NULL,
`img_norm_id` int(11) default NULL,
`img_over_id` int(11) default NULL,
`img_click_id` int(11) default NULL,
PRIMARY KEY (`ID`),
KEY `parent_id` (`parent_id`)
) TYPE=MyISAM AUTO_INCREMENT=88 ;
# --------------------------------------------------------
#
# Table structure for table `dpp_page`
#
CREATE TABLE `dpp_page` (
`ID` int(11) NOT NULL auto_increment,
`page_publish` enum('author','publish','special','offline') NOT NULL
default 'author',
`name` varchar(255) default NULL,
`head_de` varchar(255) default NULL,
`head_en` varchar(255) default NULL,
`head_fr` varchar(255) default NULL,
`head_es` varchar(255) default NULL,
`head_it` varchar(255) default NULL,
`head_ru` varchar(255) default NULL,
`head_tr` varchar(255) default NULL,
`description` text,
`template_id` int(11) NOT NULL default '0',
`publish_start` time default NULL,
`publish_stop` time default NULL,
`param_01` tinytext,
`param_02` tinytext,
`param_03` tinytext,
`param_04` tinytext,
PRIMARY KEY (`ID`),
KEY `template_id` (`template_id`)
) TYPE=MyISAM AUTO_INCREMENT=106 ;
# --------------------------------------------------------
#
# Table structure for table `dpp_report`
#
CREATE TABLE `dpp_report` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`email1` varchar(255) default NULL,
`email2` varchar(255) default NULL,
`email3` varchar(255) default NULL,
`reply_ok` int(11) NOT NULL default '0',
`reply_err` int(11) NOT NULL default '0',
`reply_mailerr` int(11) NOT NULL default '0',
`report_publish` enum('author','publish','special','offline') NOT NULL
default 'author',
`description` text,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
# --------------------------------------------------------
#
# Table structure for table `dpp_report_fields`
#
CREATE TABLE `dpp_report_fields` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`position` int(11) default NULL,
`field_type` enum('','req','email','www') NOT NULL default '',
`parent_id` int(11) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;
# --------------------------------------------------------
#
# Table structure for table `dpp_style`
#
CREATE TABLE `dpp_style` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(32) default NULL,
`code` text,
PRIMARY KEY (`ID`),
KEY `name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=28 ;
# --------------------------------------------------------
#
# Table structure for table `dpp_subpage`
#
CREATE TABLE `dpp_subpage` (
`ID` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`parent_pos` int(11) NOT NULL default '0',
`child_id` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `parent_id` (`parent_id`)
) TYPE=MyISAM AUTO_INCREMENT=28 ;
# --------------------------------------------------------
#
# Table structure for table `dpp_template`
#
CREATE TABLE `dpp_template` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(32) default NULL,
`path` varchar(255) default NULL,
`editable` enum('yes','no') NOT NULL default 'no',
`description` text,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=21 ;