Project

General

Profile

wb-2_10_x / branches / main / install / install-struct.sql @ 9

1
-- phpMyAdmin SQL Dump
2
-- version 4.0.4.1
3
-- http://www.phpmyadmin.net
4
--
5
-- Host: 127.0.0.1
6
-- Erstellungszeit: 14. Aug 2014 um 10:46
7
-- Server Version: 5.5.32
8
-- PHP-Version: 5.4.19
9

    
10
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11
-- --------------------------------------------------------
12
-- Database structure for module 'news'
13
--
14
-- Replacements: {TABLE_PREFIX}, {TABLE_ENGINE}, {FIELD_COLLATION}
15
--
16
-- --------------------------------------------------------
17
--
18
-- Tabellenstruktur für Tabelle `addons`
19
--
20
DROP TABLE IF EXISTS `{TABLE_PREFIX}addons`;
21
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}addons` (
22
  `addon_id` int(11) NOT NULL AUTO_INCREMENT,
23
  `type` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
24
  `directory` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
25
  `name` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
26
  `description` text{FIELD_COLLATION} NOT NULL,
27
  `function` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
28
  `version` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
29
  `platform` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
30
  `author` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
31
  `license` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
32
  PRIMARY KEY (`addon_id`)
33
){TABLE_ENGINE};
34
ALTER TABLE `{TABLE_PREFIX}addons` ADD UNIQUE `ident` ( `directory` );
35
-- --------------------------------------------------------
36
--
37
-- Tabellenstruktur für Tabelle `groups`
38
--
39
DROP TABLE IF EXISTS `{TABLE_PREFIX}groups`;
40
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}groups` (
41
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
42
  `name` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
43
  `system_permissions` text{FIELD_COLLATION} NOT NULL,
44
  `module_permissions` text{FIELD_COLLATION} NOT NULL,
45
  `template_permissions` text{FIELD_COLLATION} NOT NULL,
46
  PRIMARY KEY (`group_id`)
47
){TABLE_ENGINE};
48
-- --------------------------------------------------------
49
--
50
-- Tabellenstruktur für Tabelle `pages`
51
--
52
DROP TABLE IF EXISTS `{TABLE_PREFIX}pages`;
53
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}pages` (
54
  `page_id` int(11) NOT NULL AUTO_INCREMENT,
55
  `parent` int(11) NOT NULL DEFAULT '0',
56
  `root_parent` int(11) NOT NULL DEFAULT '0',
57
  `level` int(11) NOT NULL DEFAULT '0',
58
  `link` text{FIELD_COLLATION} NOT NULL,
59
  `target` varchar(7){FIELD_COLLATION} NOT NULL DEFAULT '',
60
  `page_title` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
61
  `menu_title` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
62
  `description` text{FIELD_COLLATION} NOT NULL,
63
  `keywords` text{FIELD_COLLATION} NOT NULL,
64
  `page_trail` text{FIELD_COLLATION} NOT NULL,
65
  `template` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
66
  `visibility` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
67
  `position` int(11) NOT NULL DEFAULT '0',
68
  `menu` int(11) NOT NULL DEFAULT '0',
69
  `language` varchar(5){FIELD_COLLATION} NOT NULL DEFAULT '',
70
  `searching` int(11) NOT NULL DEFAULT '0',
71
  `admin_groups` text{FIELD_COLLATION} NOT NULL,
72
  `admin_users` text{FIELD_COLLATION} NOT NULL,
73
  `viewing_groups` text{FIELD_COLLATION} NOT NULL,
74
  `viewing_users` text{FIELD_COLLATION} NOT NULL,
75
  `modified_when` int(11) NOT NULL DEFAULT '0',
76
  `modified_by` int(11) NOT NULL DEFAULT '0',
77
  PRIMARY KEY (`page_id`)
78
){TABLE_ENGINE};
79
ALTER TABLE `{TABLE_PREFIX}pages` ADD `page_icon` varchar(512){FIELD_COLLATION} NOT NULL DEFAULT '' AFTER `page_title`;
80
ALTER TABLE `{TABLE_PREFIX}pages` ADD `menu_icon_0` varchar(512){FIELD_COLLATION} NOT NULL DEFAULT '' AFTER `menu_title`;
81
ALTER TABLE `{TABLE_PREFIX}pages` ADD `menu_icon_1` varchar(512){FIELD_COLLATION} NOT NULL DEFAULT '' AFTER `menu_icon_0`;
82
ALTER TABLE `{TABLE_PREFIX}pages` ADD `tooltip` varchar(512){FIELD_COLLATION} NOT NULL DEFAULT '' AFTER `menu_icon_1`;
83
ALTER TABLE `{TABLE_PREFIX}pages` ADD `custom01` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '' AFTER `modified_by`;
84
ALTER TABLE `{TABLE_PREFIX}pages` ADD `custom02` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '' AFTER `custom01`;
85
ALTER TABLE `{TABLE_PREFIX}pages` ADD `page_code` int(11) NOT NULL DEFAULT '0' AFTER `custom02`;
86

    
87
-- --------------------------------------------------------
88
--
89
-- Tabellenstruktur für Tabelle `search`
90
--
91
DROP TABLE IF EXISTS `{TABLE_PREFIX}search`;
92
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}search` (
93
  `search_id` int(11) NOT NULL AUTO_INCREMENT,
94
  `name` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
95
  `value` text{FIELD_COLLATION} NOT NULL,
96
  `extra` text{FIELD_COLLATION} NOT NULL,
97
  PRIMARY KEY (`search_id`)
98
){TABLE_ENGINE};
99
-- --------------------------------------------------------
100
--
101
-- Tabellenstruktur für Tabelle `sections`
102
--
103
DROP TABLE IF EXISTS `{TABLE_PREFIX}sections`;
104
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}sections` (
105
  `section_id` int(11) NOT NULL AUTO_INCREMENT,
106
  `page_id` int(11) NOT NULL DEFAULT '0',
107
  `position` int(11) NOT NULL DEFAULT '0',
108
  `module` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
109
  `block` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
110
  `publ_start` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '0',
111
  `publ_end` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '0',
112
  PRIMARY KEY (`section_id`)
113
){TABLE_ENGINE};
114
ALTER TABLE `{TABLE_PREFIX}sections` ADD `title` VARCHAR(70) {FIELD_COLLATION} NOT NULL DEFAULT '' AFTER `publ_end`;
115
ALTER TABLE `{TABLE_PREFIX}sections` CHANGE `title` `title` VARCHAR(70) {FIELD_COLLATION} NOT NULL DEFAULT '';
116
-- --------------------------------------------------------
117
--
118
-- Tabellenstruktur für Tabelle `settings`
119
--
120
DROP TABLE IF EXISTS `{TABLE_PREFIX}settings`;
121
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}settings` (
122
  `name` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
123
  `value` text{FIELD_COLLATION} NOT NULL,
124
  PRIMARY KEY (`name`)
125
){TABLE_ENGINE};
126
-- Tabellenstruktur für Tabelle `users`
127
--
128
DROP TABLE IF EXISTS `{TABLE_PREFIX}users`;
129
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}users` (
130
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
131
  `group_id` int(11) NOT NULL DEFAULT '0',
132
  `groups_id` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '0',
133
  `active` int(11) NOT NULL DEFAULT '0',
134
  `username` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
135
  `password` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
136
  `remember_key` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
137
  `last_reset` int(11) NOT NULL DEFAULT '0',
138
  `display_name` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
139
  `email` text{FIELD_COLLATION} NOT NULL,
140
  `timezone` int(11) NOT NULL DEFAULT '0',
141
  `date_format` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
142
  `time_format` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
143
  `language` varchar(5){FIELD_COLLATION} NOT NULL DEFAULT 'DE',
144
  `home_folder` text{FIELD_COLLATION} NOT NULL,
145
  `login_when` int(11) NOT NULL DEFAULT '0',
146
  `login_ip` varchar(15){FIELD_COLLATION} NOT NULL DEFAULT '',
147
  PRIMARY KEY (`user_id`)
148
){TABLE_ENGINE};
149
ALTER TABLE `{TABLE_PREFIX}users` ADD `confirm_code` varchar(32){FIELD_COLLATION} NOT NULL DEFAULT '' AFTER `password`;
150
ALTER TABLE `{TABLE_PREFIX}users` ADD `confirm_timeout` int(11) NOT NULL DEFAULT '0' AFTER `confirm_code`;
151

    
152