Project

General

Profile

1
-- phpMyAdmin SQL Dump
2
-- Erstellungszeit: 20. Januar 2012 um 12:37
3
-- Server Version: 5.1.41
4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
5
-- --------------------------------------------------------
6
-- Database structure for module 'news'
7
--
8
-- Replacements: {TABLE_PREFIX}, {TABLE_ENGINE}, {TABLE_COLLATION}
9
--
10
-- --------------------------------------------------------
11
--
12
-- Tabellenstruktur für Tabelle `mod_news_comments`
13
--
14
DROP TABLE IF EXISTS `{TABLE_PREFIX}mod_news_comments`;
15
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}mod_news_comments` (
16
  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
17
  `section_id` int(11) NOT NULL DEFAULT '0',
18
  `page_id` int(11) NOT NULL DEFAULT '0',
19
  `post_id` int(11) NOT NULL DEFAULT '0',
20
  `title` varchar(255){TABLE_COLLATION} NOT NULL,
21
  `comment` text{TABLE_COLLATION} NOT NULL,
22
  `commented_when` int(11) NOT NULL DEFAULT '0',
23
  `commented_by` int(11) NOT NULL DEFAULT '0',
24
  PRIMARY KEY (`comment_id`)
25
){TABLE_ENGINE};
26
-- --------------------------------------------------------
27
--
28
-- Tabellenstruktur für Tabelle `mod_news_groups`
29
--
30
DROP TABLE IF EXISTS `{TABLE_PREFIX}mod_news_groups`;
31
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}mod_news_groups` (
32
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
33
  `section_id` int(11) NOT NULL DEFAULT '0',
34
  `page_id` int(11) NOT NULL DEFAULT '0',
35
  `active` int(11) NOT NULL DEFAULT '0',
36
  `position` int(11) NOT NULL DEFAULT '0',
37
  `title` varchar(255){TABLE_COLLATION} NOT NULL,
38
  PRIMARY KEY (`group_id`)
39
){TABLE_ENGINE};
40
-- --------------------------------------------------------
41
--
42
-- Tabellenstruktur für Tabelle `mod_news_posts`
43
--
44
DROP TABLE IF EXISTS `{TABLE_PREFIX}mod_news_posts`;
45
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}mod_news_posts` (
46
  `post_id` int(11) NOT NULL AUTO_INCREMENT,
47
  `section_id` int(11) NOT NULL DEFAULT '0',
48
  `page_id` int(11) NOT NULL DEFAULT '0',
49
  `group_id` int(11) NOT NULL DEFAULT '0',
50
  `active` int(11) NOT NULL DEFAULT '0',
51
  `position` int(11) NOT NULL DEFAULT '0',
52
  `title` varchar(255){TABLE_COLLATION} NOT NULL,
53
  `link` text{TABLE_COLLATION} NOT NULL,
54
  `content_short` text{TABLE_COLLATION} NOT NULL,
55
  `content_long` text{TABLE_COLLATION} NOT NULL,
56
  `commenting` varchar(7){TABLE_COLLATION} NOT NULL,
57
  `created_when` int(11) NOT NULL,
58
  `created_by` int(11) NOT NULL,
59
  `published_when` int(11) NOT NULL DEFAULT '0',
60
  `published_until` int(11) NOT NULL DEFAULT '0',
61
  `posted_when` int(11) NOT NULL DEFAULT '0',
62
  `posted_by` int(11) NOT NULL DEFAULT '0',
63
  PRIMARY KEY (`post_id`)
64
){TABLE_ENGINE};
65
-- --------------------------------------------------------
66
--
67
-- Tabellenstruktur für Tabelle `mod_news_settings`
68
--
69
DROP TABLE IF EXISTS `{TABLE_PREFIX}mod_news_settings`;
70
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}mod_news_settings` (
71
  `section_id` int(11) NOT NULL DEFAULT '0',
72
  `page_id` int(11) NOT NULL DEFAULT '0',
73
  `header` text{TABLE_COLLATION} NOT NULL,
74
  `post_loop` text{TABLE_COLLATION} NOT NULL,
75
  `footer` text{TABLE_COLLATION} NOT NULL,
76
  `posts_per_page` int(11) NOT NULL DEFAULT '0',
77
  `post_header` text{TABLE_COLLATION} NOT NULL,
78
  `post_footer` text{TABLE_COLLATION} NOT NULL,
79
  `comments_header` text{TABLE_COLLATION} NOT NULL,
80
  `comments_loop` text{TABLE_COLLATION} NOT NULL,
81
  `comments_footer` text{TABLE_COLLATION} NOT NULL,
82
  `comments_page` text{TABLE_COLLATION} NOT NULL,
83
  `commenting` varchar(7){TABLE_COLLATION} NOT NULL,
84
  `resize` int(11) NOT NULL DEFAULT '0',
85
  `use_captcha` int(11) NOT NULL DEFAULT '0',
86
  PRIMARY KEY (`section_id`)
87
){TABLE_ENGINE};
88
-- EndOfFile
(16-16/33)