Menu
▾
▴
[Phpbb-checkins] CVS: phpBB2/db/schemas mysql_schema.sql,1.1,1.2
|
From: Bart v. B. <ba...@us...> - 2001-11-23 18:44:15
|
Update of /cvsroot/phpbb/phpBB2/db/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv1439
Modified Files:
mysql_schema.sql
Log Message:
Some space/speed checkups on the types in the MySQL schema
Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** mysql_schema.sql 2001/11/20 22:28:41 1.1
--- mysql_schema.sql 2001/11/23 18:44:11 1.2
***************
*** 10,15 ****
DROP TABLE IF EXISTS phpbb_auth_access;
CREATE TABLE phpbb_auth_access (
! group_id int(11) DEFAULT '0' NOT NULL,
! forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
auth_view tinyint(1) DEFAULT '0' NOT NULL,
auth_read tinyint(1) DEFAULT '0' NOT NULL,
--- 10,15 ----
DROP TABLE IF EXISTS phpbb_auth_access;
CREATE TABLE phpbb_auth_access (
! group_id smallint(5) DEFAULT '0' NOT NULL,
! forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
auth_view tinyint(1) DEFAULT '0' NOT NULL,
auth_read tinyint(1) DEFAULT '0' NOT NULL,
***************
*** 34,39 ****
DROP TABLE IF EXISTS phpbb_user_group;
CREATE TABLE phpbb_user_group (
! group_id int(11) DEFAULT '0' NOT NULL,
! user_id int(11) DEFAULT '0' NOT NULL,
user_pending tinyint(1),
KEY group_id (group_id),
--- 34,39 ----
DROP TABLE IF EXISTS phpbb_user_group;
CREATE TABLE phpbb_user_group (
! group_id smallint(5) DEFAULT '0' NOT NULL,
! user_id mediumint(8) DEFAULT '0' NOT NULL,
user_pending tinyint(1),
KEY group_id (group_id),
***************
*** 46,54 ****
DROP TABLE IF EXISTS phpbb_groups;
CREATE TABLE phpbb_groups (
! group_id int(11) NOT NULL auto_increment,
group_type tinyint(4) DEFAULT '1' NOT NULL,
group_name varchar(40) NOT NULL,
group_description varchar(255) NOT NULL,
! group_moderator int(11) DEFAULT '0' NOT NULL,
group_single_user tinyint(1) DEFAULT '1' NOT NULL,
PRIMARY KEY (group_id),
--- 46,54 ----
DROP TABLE IF EXISTS phpbb_groups;
CREATE TABLE phpbb_groups (
! group_id smallint(5) NOT NULL auto_increment,
group_type tinyint(4) DEFAULT '1' NOT NULL,
group_name varchar(40) NOT NULL,
group_description varchar(255) NOT NULL,
! group_moderator mediumint(8) DEFAULT '0' NOT NULL,
group_single_user tinyint(1) DEFAULT '1' NOT NULL,
PRIMARY KEY (group_id),
***************
*** 64,68 ****
CREATE TABLE phpbb_banlist (
ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! ban_userid int(11) NOT NULL,
ban_ip char(8) NOT NULL,
ban_email varchar(255),
--- 64,68 ----
CREATE TABLE phpbb_banlist (
ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! ban_userid mediumint(8) NOT NULL,
ban_ip char(8) NOT NULL,
ban_email varchar(255),
***************
*** 117,121 ****
CREATE TABLE phpbb_forum_prune (
prune_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! forum_id mediumint(8) UNSIGNED NOT NULL,
prune_days tinyint(4) UNSIGNED NOT NULL,
prune_freq tinyint(4) UNSIGNED NOT NULL,
--- 117,121 ----
CREATE TABLE phpbb_forum_prune (
prune_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! forum_id smallint(5) UNSIGNED NOT NULL,
prune_days tinyint(4) UNSIGNED NOT NULL,
prune_freq tinyint(4) UNSIGNED NOT NULL,
***************
*** 131,135 ****
DROP TABLE IF EXISTS phpbb_forums;
CREATE TABLE phpbb_forums (
! forum_id mediumint(8) UNSIGNED NOT NULL auto_increment,
cat_id mediumint(8) UNSIGNED NOT NULL,
forum_name varchar(150),
--- 131,135 ----
DROP TABLE IF EXISTS phpbb_forums;
CREATE TABLE phpbb_forums (
! forum_id smallint(5) UNSIGNED NOT NULL auto_increment,
cat_id mediumint(8) UNSIGNED NOT NULL,
forum_name varchar(150),
***************
*** 168,173 ****
post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! poster_id int(11) DEFAULT '0' NOT NULL,
post_time int(11) DEFAULT '0' NOT NULL,
poster_ip char(8) NOT NULL,
--- 168,173 ----
post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
! poster_id mediumint(8) DEFAULT '0' NOT NULL,
post_time int(11) DEFAULT '0' NOT NULL,
poster_ip char(8) NOT NULL,
***************
*** 210,215 ****
privmsgs_type tinyint(4) DEFAULT '0' NOT NULL,
privmsgs_subject varchar(255) DEFAULT '0' NOT NULL,
! privmsgs_from_userid int(11) DEFAULT '0' NOT NULL,
! privmsgs_to_userid int(11) DEFAULT '0' NOT NULL,
privmsgs_date int(11) DEFAULT '0' NOT NULL,
privmsgs_ip char(8) NOT NULL,
--- 210,215 ----
privmsgs_type tinyint(4) DEFAULT '0' NOT NULL,
privmsgs_subject varchar(255) DEFAULT '0' NOT NULL,
! privmsgs_from_userid mediumint(8) DEFAULT '0' NOT NULL,
! privmsgs_to_userid mediumint(8) DEFAULT '0' NOT NULL,
privmsgs_date int(11) DEFAULT '0' NOT NULL,
privmsgs_ip char(8) NOT NULL,
***************
*** 311,315 ****
CREATE TABLE phpbb_sessions (
session_id char(32) DEFAULT '' NOT NULL,
! session_user_id int(11) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
--- 311,315 ----
CREATE TABLE phpbb_sessions (
session_id char(32) DEFAULT '' NOT NULL,
! session_user_id mediumint(8) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
***************
*** 439,445 ****
CREATE TABLE phpbb_topics (
topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! topic_title char(100) NOT NULL,
! topic_poster int(11) DEFAULT '0' NOT NULL,
topic_time int(11) DEFAULT '0' NOT NULL,
topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
--- 439,445 ----
CREATE TABLE phpbb_topics (
topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! forum_id smallint(8) UNSIGNED DEFAULT '0' NOT NULL,
! topic_title char(60) NOT NULL,
! topic_poster mediumint(8) DEFAULT '0' NOT NULL,
topic_time int(11) DEFAULT '0' NOT NULL,
topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
***************
*** 464,468 ****
CREATE TABLE phpbb_topics_watch (
topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
! user_id int(11) NOT NULL DEFAULT '0',
notify_status tinyint(1) NOT NULL default '0',
KEY topic_id (topic_id),
--- 464,468 ----
CREATE TABLE phpbb_topics_watch (
topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
! user_id mediumint(8) NOT NULL DEFAULT '0',
notify_status tinyint(1) NOT NULL default '0',
KEY topic_id (topic_id),
***************
*** 478,482 ****
DROP TABLE IF EXISTS phpbb_users;
CREATE TABLE phpbb_users (
! user_id int(11) NOT NULL auto_increment,
user_active tinyint(1) DEFAULT '1',
username varchar(25) NOT NULL,
--- 478,482 ----
DROP TABLE IF EXISTS phpbb_users;
CREATE TABLE phpbb_users (
! user_id mediumint(8) NOT NULL auto_increment,
user_active tinyint(1) DEFAULT '1',
username varchar(25) NOT NULL,
***************
*** 564,568 ****
CREATE TABLE phpbb_vote_voters (
vote_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
! vote_user_id int(11) NOT NULL DEFAULT '0',
vote_user_ip char(8) NOT NULL,
KEY vote_id (vote_id),
--- 564,568 ----
CREATE TABLE phpbb_vote_voters (
vote_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
! vote_user_id mediumint(8) NOT NULL DEFAULT '0',
vote_user_ip char(8) NOT NULL,
KEY vote_id (vote_id),
|
