Project

General

Profile

1 1820 Luisehahne
--
2
-- Tabellenstruktur für Tabelle '{TABLE_PREFIX}addons'
3
--
4
5
DROP TABLE IF EXISTS {TABLE_PREFIX}addons;
6
CREATE TABLE IF NOT EXISTS {TABLE_PREFIX}addons (
7
  addon_id int(11) NOT NULL AUTO_INCREMENT,
8
  `type` varchar(255) NOT NULL DEFAULT '',
9
  `directory` varchar(255) NOT NULL DEFAULT '',
10
  `name` varchar(255) NOT NULL DEFAULT '',
11
  description text NOT NULL,
12
  `function` varchar(255) NOT NULL DEFAULT '',
13
  version varchar(255) NOT NULL DEFAULT '',
14
  platform varchar(255) NOT NULL DEFAULT '',
15
  author varchar(255) NOT NULL DEFAULT '',
16
  license varchar(255) NOT NULL DEFAULT '',
17
  PRIMARY KEY (addon_id)
18
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
19
20
--
21
-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}groups`
22
--
23
24
DROP TABLE IF EXISTS `{TABLE_PREFIX}groups`;
25
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}groups` (
26
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
27
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
28
  `system_permissions` text COLLATE utf8_unicode_ci NOT NULL,
29
  `module_permissions` text COLLATE utf8_unicode_ci NOT NULL,
30
  `template_permissions` text COLLATE utf8_unicode_ci NOT NULL,
31
  PRIMARY KEY (`group_id`)
32
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
33
34
--
35
-- Daten für Tabelle `{TABLE_PREFIX}groups`
36
--
37
38
INSERT INTO `{TABLE_PREFIX}groups` VALUES(1, 'Administrators', 'access,addons,admintools,admintools_view,groups,groups_add,groups_delete,groups_modify,groups_view,languages,languages_install,languages_uninstall,languages_view,media,media_create,media_delete,media_rename,media_upload,media_view,modules,modules_advanced,modules_install,modules_uninstall,modules_view,pages,pages_add,pages_add_l0,pages_delete,pages_intro,pages_modify,pages_settings,pages_view,preferences,preferences_view,settings,settings_advanced,settings_basic,settings_view,templates,templates_install,templates_uninstall,templates_view,users,users_add,users_delete,users_modify,users_view', '', '');
39
40
-- --------------------------------------------------------
41
42
--
43
-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}pages`
44
--
45
46
DROP TABLE IF EXISTS `{TABLE_PREFIX}pages`;
47
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}pages` (
48
  `page_id` int(11) NOT NULL AUTO_INCREMENT,
49
  `parent` int(11) NOT NULL DEFAULT '0',
50
  `root_parent` int(11) NOT NULL DEFAULT '0',
51
  `level` int(11) NOT NULL DEFAULT '0',
52
  `link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
53
  `target` varchar(7) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
54
  `page_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
55
  `page_icon` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
56
  `menu_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
57
  `menu_icon_0` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
58
  `menu_icon_1` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
59
  `tooltip` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
60
  `description` text COLLATE utf8_unicode_ci NOT NULL,
61
  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
62
  `page_trail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
63
  `template` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
64
  `visibility` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
65
  `position` int(11) NOT NULL DEFAULT '0',
66
  `menu` int(11) NOT NULL DEFAULT '1',
67
  `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
68
  `page_code` int(11) NOT NULL DEFAULT '0',
69
  `searching` int(11) NOT NULL DEFAULT '0',
70
  `admin_groups` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
71
  `admin_users` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
72
  `viewing_groups` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
73
  `viewing_users` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
74
  `modified_when` int(11) NOT NULL DEFAULT '0',
75
  `modified_by` int(11) NOT NULL DEFAULT '0',
76
  `custom01` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
77
  `custom02` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
78
  PRIMARY KEY (`page_id`)
79
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
80
81
-- --------------------------------------------------------
82
83
--
84
-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}sections`
85
--
86
87
DROP TABLE IF EXISTS `{TABLE_PREFIX}sections`;
88
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}sections` (
89
  `section_id` int(11) NOT NULL AUTO_INCREMENT,
90
  `page_id` int(11) NOT NULL DEFAULT '0',
91
  `position` int(11) NOT NULL DEFAULT '0',
92
  `module` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
93
  `block` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
94
  `publ_start` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
95
  `publ_end` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
96
  PRIMARY KEY (`section_id`)
97
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
98
99
-- --------------------------------------------------------
100
101
--
102
-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}users`
103
--
104
105
DROP TABLE IF EXISTS `{TABLE_PREFIX}users`;
106
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}users` (
107
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
108
  `group_id` int(11) NOT NULL DEFAULT '0',
109
  `groups_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
110
  `active` int(11) NOT NULL DEFAULT '0',
111
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
112
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
113
  `confirm_code` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
114
  `confirm_timeout` int(11) NOT NULL DEFAULT '0',
115
  `remember_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
116
  `last_reset` int(11) NOT NULL DEFAULT '0',
117
  `display_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
118
  `email` text COLLATE utf8_unicode_ci NOT NULL,
119
  `timezone` int(11) NOT NULL DEFAULT '0',
120
  `date_format` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
121
  `time_format` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
122
  `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'EN',
123
  `home_folder` text COLLATE utf8_unicode_ci NOT NULL,
124
  `login_when` int(11) NOT NULL DEFAULT '0',
125
  `login_ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
126
  PRIMARY KEY (`user_id`)
127
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
128
129
--
130
-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}settings`
131
--
132
133
DROP TABLE IF EXISTS `{TABLE_PREFIX}settings`;
134
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}settings` (
135
  `setting_id` int(11) NOT NULL AUTO_INCREMENT,
136
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
137
  `value` text COLLATE utf8_unicode_ci NOT NULL,
138
  PRIMARY KEY (`setting_id`)
139
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;