Project

General

Profile

Download (5.9 KB) Statistics
| Revision:

wb-archiv283/branches/2.8.x/wb/install/sql/install-struct.sql @ 2120

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