Leser: 4
![]() |
|< 1 2 3 4 ... 7 >| | ![]() |
70 Einträge, 7 Seiten |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
DROP TABLE IF EXISTS `pboard`.`pb_board_boards`;
CREATE TABLE `pboard`.`pb_board_boards` (
`id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'board id',
`name` varchar(64) NOT NULL default '' COMMENT 'board name',
`description` varchar(255) NOT NULL default '' COMMENT 'board description',
`position` int(10) unsigned NOT NULL default '0' COMMENT 'board is displayed at that position',
`parentId` bigint(20) unsigned NOT NULL default '0' COMMENT 'the id of the parent board if any',
`containsMessages` tinyint(1) NOT NULL default '0',
`roleRequired` int(10) unsigned NOT NULL default '0' COMMENT 'restricted access, 0 = everybody',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='board boards';
DROP TABLE IF EXISTS `pboard`.`pb_board_messages`;
CREATE TABLE `pboard`.`pb_board_messages` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`originatorId` bigint(20) unsigned NOT NULL default '0' COMMENT 'id of originator of the message',
`editorId` bigint(20) unsigned NOT NULL default '0' COMMENT 'id of last editor of the message',
`threadId` bigint(20) unsigned NOT NULL default '0' COMMENT 'message belongs to this thread',
`parentMsgId` bigint(20) unsigned default NULL COMMENT 'message may has a parent message',
`messageRaw` text NOT NULL COMMENT 'raw message data',
`messageCompiled` text COMMENT 'compiled message to display',
`created` timestamp NOT NULL default '0000-00-00 00:00:00',
`modified` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'last time the message was modified',
PRIMARY KEY (`id`),
FULLTEXT KEY `FULLTEXT_MESSAGERAW` (`messageRaw`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='board messages';
DROP TABLE IF EXISTS `pboard`.`pb_board_settings`;
CREATE TABLE `pboard`.`pb_board_settings` (
`name` varchar(32) NOT NULL default '',
`value` varchar(512) NOT NULL default '',
`modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='board settings';
DROP TABLE IF EXISTS `pboard`.`pb_board_threads`;
CREATE TABLE `pboard`.`pb_board_threads` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`title` varchar(128) NOT NULL default '',
`subTitle` varchar(128) NOT NULL default '',
`status` set('fixed','deleted','closed','open','virtual') NOT NULL default 'virtual',
`boardId` bigint(20) unsigned NOT NULL default '0',
`readCount` int(10) unsigned NOT NULL default '0',
`messageCount` bigint(20) unsigned NOT NULL default '0',
`lastAction` timestamp NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='board threads';
DROP TABLE IF EXISTS `pboard`.`pb_role`;
CREATE TABLE `pboard`.`pb_role` (
`id` int(10) unsigned NOT NULL auto_increment,
`rolename` varchar(32) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='role';
DROP TABLE IF EXISTS `pboard`.`pb_user`;
CREATE TABLE `pboard`.`pb_user` (
`id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'user id',
`username` varchar(64) NOT NULL default '' COMMENT 'name of the user',
`password` varchar(512) NOT NULL default '' COMMENT 'password of the user',
`oldId` int(10) unsigned default '0' COMMENT 'user id in old board',
PRIMARY KEY (`id`),
UNIQUE KEY `USERNAME_INDEX` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='user';
DROP TABLE IF EXISTS `pboard`.`pb_user_profile`;
CREATE TABLE `pboard`.`pb_user_profile` (
`userId` bigint(20) unsigned NOT NULL default '0',
`realname` varchar(30) NOT NULL default '',
`email` varchar(64) NOT NULL default '',
`homepage` varchar(64) default NULL,
`location` varchar(30) default NULL,
`signatureCompiled` text,
`signatureRaw` text,
`imageUrl` varchar(100) default NULL,
`sex` tinyint(1) default NULL,
`interests` varchar(200) default NULL,
`comment` varchar(100) default NULL,
`birthday` date default NULL,
`aolId` varchar(20) default NULL,
`icqId` varchar(20) default NULL,
`msnId` varchar(30) default NULL,
`yahooId` varchar(20) default NULL,
`avatar` varchar(100) default NULL,
PRIMARY KEY (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='user profile';
DROP TABLE IF EXISTS `pboard`.`pb_user_role`;
CREATE TABLE `pboard`.`pb_user_role` (
`userId` bigint(20) unsigned NOT NULL default '0',
`roleId` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userId`,`roleId`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii COMMENT='user role';
DROP TABLE IF EXISTS `pboard`.`pb_user_session`;
CREATE TABLE `pboard`.`pb_user_session` (
`id` char(136) NOT NULL default '',
`session_data` text NOT NULL,
`expires` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii COMMENT='user sessions';
DROP TABLE IF EXISTS `pboard`.`pb_user_settings`;
CREATE TABLE `pboard`.`pb_user_settings` (
`userId` bigint(20) unsigned NOT NULL default '0',
`lastLogon` datetime NOT NULL default '0000-00-00 00:00:00',
`lastAction` datetime default NULL,
`languageCode` char(3) NOT NULL default 'de',
`showImages` tinyint(1) NOT NULL default '1',
`cssStylesheet` varchar(40) default NULL,
`postCount` int(10) unsigned NOT NULL default '0',
`registerDate` datetime default NULL,
`showEmail` tinyint(1) NOT NULL default '0',
`isApproved` tinyint(1) NOT NULL default '0',
`approveId` char(36) NOT NULL default '',
PRIMARY KEY (`userId`),
KEY `lastaction` (`lastAction`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='user settings';
Quotewarum ist pb_user_profile in 'ner eigenen tabelle?
die zuordnung ist doch 1:1, oder?
![]() |
|< 1 2 3 4 ... 7 >| | ![]() |
70 Einträge, 7 Seiten |