Project

General

Profile

1 1822 Luisehahne
-- phpMyAdmin SQL Dump
2
-- Date of creation: 2012-11-17 12:37am
3
-- Server Version: 5.1.41
4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
5
-- --------------------------------------------------------
6
-- Database structure for WebsiteBaker core
7 1820 Luisehahne
--
8 2110 darkviper
-- Replacements: {TABLE_PREFIX}, {TABLE_ENGINE}, {FIELD_COLLATION}
9 1820 Luisehahne
--
10 1822 Luisehahne
-- --------------------------------------------------------
11
--
12
-- Structure of table  '{TABLE_PREFIX}addons'
13
--
14
DROP TABLE IF EXISTS `{TABLE_PREFIX}addons`;
15
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}addons` (
16
  `addon_id` int(11) NOT NULL AUTO_INCREMENT,
17 2110 darkviper
  `type` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
18
  `directory` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
19
  `name` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
20
  `description` text{FIELD_COLLATION} NOT NULL,
21
  `function` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
22
  `version` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
23
  `platform` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
24
  `author` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
25
  `license` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
26 1820 Luisehahne
  PRIMARY KEY (addon_id)
27 1822 Luisehahne
){TABLE_ENGINE};
28 1820 Luisehahne
--
29 1822 Luisehahne
-- Structure of table  '{TABLE_PREFIX}groups'
30 1820 Luisehahne
--
31
DROP TABLE IF EXISTS `{TABLE_PREFIX}groups`;
32
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}groups` (
33
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
34 2110 darkviper
  `name` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
35
  `system_permissions` text{FIELD_COLLATION} NOT NULL,
36
  `module_permissions` text{FIELD_COLLATION} NOT NULL,
37
  `template_permissions` text{FIELD_COLLATION} NOT NULL,
38 1820 Luisehahne
  PRIMARY KEY (`group_id`)
39 1822 Luisehahne
){TABLE_ENGINE};
40 1820 Luisehahne
--
41 1822 Luisehahne
-- Structure of table  '{TABLE_PREFIX}pages'
42 1820 Luisehahne
--
43
DROP TABLE IF EXISTS `{TABLE_PREFIX}pages`;
44
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}pages` (
45
  `page_id` int(11) NOT NULL AUTO_INCREMENT,
46
  `parent` int(11) NOT NULL DEFAULT '0',
47
  `root_parent` int(11) NOT NULL DEFAULT '0',
48
  `level` int(11) NOT NULL DEFAULT '0',
49 2110 darkviper
  `link` varchar(255){FIELD_COLLATION} NOT NULL,
50
  `target` varchar(7){FIELD_COLLATION} NOT NULL DEFAULT '',
51
  `page_title` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
52
  `page_icon` varchar(512){FIELD_COLLATION} NOT NULL DEFAULT '',
53
  `menu_title` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
54
  `menu_icon_0` varchar(512){FIELD_COLLATION} NOT NULL DEFAULT '',
55
  `menu_icon_1` varchar(512){FIELD_COLLATION} NOT NULL DEFAULT '',
56
  `tooltip` varchar(512){FIELD_COLLATION} NOT NULL DEFAULT '',
57
  `description` text{FIELD_COLLATION} NOT NULL,
58
  `keywords` text{FIELD_COLLATION} NOT NULL,
59
  `page_trail` varchar(255){FIELD_COLLATION} NOT NULL,
60
  `template` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
61
  `visibility` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
62 1820 Luisehahne
  `position` int(11) NOT NULL DEFAULT '0',
63
  `menu` int(11) NOT NULL DEFAULT '1',
64 2110 darkviper
  `language` varchar(5){FIELD_COLLATION} NOT NULL DEFAULT '',
65 1820 Luisehahne
  `page_code` int(11) NOT NULL DEFAULT '0',
66
  `searching` int(11) NOT NULL DEFAULT '0',
67 2110 darkviper
  `admin_groups` varchar(512){FIELD_COLLATION} NOT NULL DEFAULT '1',
68
  `admin_users` varchar(512){FIELD_COLLATION} NOT NULL,
69
  `viewing_groups` varchar(512){FIELD_COLLATION} NOT NULL DEFAULT '1',
70
  `viewing_users` varchar(512){FIELD_COLLATION} NOT NULL,
71 1820 Luisehahne
  `modified_when` int(11) NOT NULL DEFAULT '0',
72
  `modified_by` int(11) NOT NULL DEFAULT '0',
73 2110 darkviper
  `custom01` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
74
  `custom02` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
75 1820 Luisehahne
  PRIMARY KEY (`page_id`)
76 1887 Luisehahne
) {TABLE_ENGINE};
77 1820 Luisehahne
--
78 1822 Luisehahne
-- Structure of table  '{TABLE_PREFIX}sections'
79 1820 Luisehahne
--
80
DROP TABLE IF EXISTS `{TABLE_PREFIX}sections`;
81
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}sections` (
82
  `section_id` int(11) NOT NULL AUTO_INCREMENT,
83
  `page_id` int(11) NOT NULL DEFAULT '0',
84
  `position` int(11) NOT NULL DEFAULT '0',
85 2110 darkviper
  `title` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
86
  `module` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
87 1889 Luisehahne
  `block` int(11) NOT NULL DEFAULT '1',
88
  `publ_start` int(11) NOT NULL DEFAULT '0',
89
  `publ_end` int(11) NOT NULL DEFAULT '0',
90 1820 Luisehahne
  PRIMARY KEY (`section_id`)
91 1887 Luisehahne
) {TABLE_ENGINE};
92 1820 Luisehahne
--
93 1822 Luisehahne
-- Structure of table  '{TABLE_PREFIX}users'
94 1820 Luisehahne
--
95
DROP TABLE IF EXISTS `{TABLE_PREFIX}users`;
96
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}users` (
97
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
98 2017 darkviper
  `group_id` int(11) NOT NULL DEFAULT '0' COMMENT 'this field is set deprecated and never used in WB',
99 2110 darkviper
  `groups_id` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '0',
100 1820 Luisehahne
  `active` int(11) NOT NULL DEFAULT '0',
101 2110 darkviper
  `username` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
102
  `password` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
103
  `confirm_code` varchar(32){FIELD_COLLATION} NOT NULL DEFAULT '',
104 1820 Luisehahne
  `confirm_timeout` int(11) NOT NULL DEFAULT '0',
105 2110 darkviper
  `remember_key` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
106 1820 Luisehahne
  `last_reset` int(11) NOT NULL DEFAULT '0',
107 2110 darkviper
  `display_name` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
108
  `email` text{FIELD_COLLATION} NOT NULL,
109 1820 Luisehahne
  `timezone` int(11) NOT NULL DEFAULT '0',
110 2110 darkviper
  `date_format` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
111
  `time_format` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
112
  `language` varchar(5){FIELD_COLLATION} NOT NULL DEFAULT 'EN',
113
  `home_folder` text{FIELD_COLLATION} NOT NULL,
114 1820 Luisehahne
  `login_when` int(11) NOT NULL DEFAULT '0',
115 2110 darkviper
  `login_ip` varchar(15){FIELD_COLLATION} NOT NULL DEFAULT '',
116 1820 Luisehahne
  PRIMARY KEY (`user_id`)
117 1822 Luisehahne
){TABLE_ENGINE};
118 1820 Luisehahne
--
119 1822 Luisehahne
-- Structure of table  '{TABLE_PREFIX}settings'
120 1820 Luisehahne
--
121
DROP TABLE IF EXISTS `{TABLE_PREFIX}settings`;
122
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}settings` (
123 2110 darkviper
  `name` varchar(255){FIELD_COLLATION} NOT NULL,
124
  `value` text{FIELD_COLLATION} NOT NULL,
125 2104 darkviper
  PRIMARY KEY (`name`)
126 1822 Luisehahne
){TABLE_ENGINE};
127
--
128
-- Structure of table `{TABLE_PREFIX}search`
129
--
130
DROP TABLE IF EXISTS `{TABLE_PREFIX}search`;
131
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}search` (
132
  `search_id` int(11) NOT NULL AUTO_INCREMENT,
133 2110 darkviper
  `name` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT '',
134
  `value` text{FIELD_COLLATION} NOT NULL,
135
  `extra` text{FIELD_COLLATION} NOT NULL,
136 1822 Luisehahne
  PRIMARY KEY (`search_id`)
137
){TABLE_ENGINE};
138
-- EndOfFile