diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-04-24 22:51:56 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-04-24 22:51:56 +0000 |
| commit | 728d6f66098f70854e32e1f6f4913ba257e4917e (patch) | |
| tree | fd55900d5ea89bd82d82d661471bc2a7beb88fb1 /phpBB/db/mysql_schema.sql | |
| parent | 4643364792c9e4a508e677b01960bb8fae1b8692 (diff) | |
| download | forums-728d6f66098f70854e32e1f6f4913ba257e4917e.tar forums-728d6f66098f70854e32e1f6f4913ba257e4917e.tar.gz forums-728d6f66098f70854e32e1f6f4913ba257e4917e.tar.bz2 forums-728d6f66098f70854e32e1f6f4913ba257e4917e.tar.xz forums-728d6f66098f70854e32e1f6f4913ba257e4917e.zip | |
Quoted default values ...
git-svn-id: file:///svn/phpbb/trunk@206 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/mysql_schema.sql')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index f0ac9e94bb..e3f56e0614 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -1,7 +1,7 @@ # # phpBB2 - MySQL schema # -# $id: mysql_schema.sql,v 1.10 2001/04/19 17:26:24 psotfx Exp $ +# $id: Exp $ # @@ -46,7 +46,7 @@ CREATE TABLE phpbb_config ( allow_bbcode tinyint(3), allow_sig tinyint(3), allow_namechange tinyint(3), - selected int(2) DEFAULT 0 NOT NULL, + selected int(2) DEFAULT '0' NOT NULL, posts_per_page int(11), hot_threshold int(11), topics_per_page int(11), @@ -54,11 +54,11 @@ CREATE TABLE phpbb_config ( override_themes tinyint(3), email_sig varchar(255), email_from varchar(100), - default_theme int(11) DEFAULT 1 NOT NULL, + default_theme int(11) DEFAULT '1' NOT NULL, default_lang varchar(255), - default_dateformat varchar(14) DEFAULT d M Y H:m NOT NULL, - system_timezone int(11) DEFAULT 0 NOT NULL, - sys_template varchar(100) DEFAULT Default NOT NULL, + default_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL, + system_timezone int(11) DEFAULT '0' NOT NULL, + sys_template varchar(100) DEFAULT 'Default' NOT NULL, PRIMARY KEY (config_id), UNIQUE selected (selected) ); @@ -112,7 +112,7 @@ CREATE TABLE phpbb_forums ( forum_desc text, forum_access tinyint(3), cat_id int(11), - forum_order int(11) DEFAULT 1 NOT NULL, + forum_order int(11) DEFAULT '1' NOT NULL, forum_type tinyint(4), forum_posts int(11) NOT NULL, forum_topics tinyint(4) NOT NULL, @@ -344,17 +344,17 @@ CREATE TABLE phpbb_users ( user_aim varchar(255), user_yim varchar(255), user_msnm varchar(255), - user_posts int(11) DEFAULT 0, + user_posts int(11) DEFAULT '0', user_attachsig tinyint(3), user_desmile tinyint(3), user_html tinyint(3), user_bbcode tinyint(3), - user_rank int(11) DEFAULT 0, + user_rank int(11) DEFAULT '0', user_avatar varchar(100), - user_level int(11) DEFAULT 1, + user_level int(11) DEFAULT '1', user_lang varchar(255), - user_timezone int(11) DEFAULT 0 NOT NULL, - user_dateformat varchar(14) DEFAULT d M Y H:m NOT NULL, + user_timezone int(11) DEFAULT '0' NOT NULL, + user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL, user_actkey varchar(32), user_newpasswd varchar(32), user_notify tinyint(3), |