diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-07-27 23:29:58 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-07-27 23:29:58 +0000 |
| commit | 928190dab22d65be0ae577417e5e36463588e062 (patch) | |
| tree | 96dff25ffef4722b4b3ae202b631821fb4779c49 /phpBB/db | |
| parent | 8b82f40009502ea64e5df749bc890fd9547e8b40 (diff) | |
| download | forums-928190dab22d65be0ae577417e5e36463588e062.tar forums-928190dab22d65be0ae577417e5e36463588e062.tar.gz forums-928190dab22d65be0ae577417e5e36463588e062.tar.bz2 forums-928190dab22d65be0ae577417e5e36463588e062.tar.xz forums-928190dab22d65be0ae577417e5e36463588e062.zip | |
Removed header frame, reduced timezone naming, added DB size for MySQL, no major technical changes
git-svn-id: file:///svn/phpbb/trunk@754 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mssql_schema.sql | bin | 38912 -> 40176 bytes | |||
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 63 |
3 files changed, 41 insertions, 23 deletions
diff --git a/phpBB/db/mssql_schema.sql b/phpBB/db/mssql_schema.sql Binary files differindex 5ced86ed97..9b218b0ab9 100644 --- a/phpBB/db/mssql_schema.sql +++ b/phpBB/db/mssql_schema.sql diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 1439032195..a2559de378 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -90,6 +90,7 @@ DROP TABLE IF EXISTS phpbb_config; CREATE TABLE phpbb_config ( config_id int(10) NOT NULL auto_increment, board_disable tinyint(1) DEFAULT '0' NOT NULL, + board_startdate int(11), sitename varchar(100), cookie_name char(20), cookie_path char(25), diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 54564671b0..cf49def9b3 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -87,6 +87,7 @@ CREATE TABLE phpbb_categories ( CREATE TABLE phpbb_config ( config_id int2 NOT NULL, board_disable int2 DEFAULT '0' NOT NULL, + board_startdate int4, sitename varchar(100) NOT NULL, cookie_name char(20), cookie_path char(25), @@ -320,25 +321,33 @@ CREATE TABLE phpbb_themes ( tr_color1 char(6), tr_color2 char(6), tr_color3 char(6), + tr_class1 varchar(25), + tr_class2 varchar(25), + tr_class3 varchar(25), th_color1 char(6), th_color2 char(6), th_color3 char(6), + th_class1 varchar(25), + th_class2 varchar(25), + th_class3 varchar(25), td_color1 char(6), td_color2 char(6), td_color3 char(6), - fontface1 varchar(50), - fontface2 varchar(50), - fontface3 varchar(50), + td_class1 varchar(25), + td_class2 varchar(25), + td_class3 varchar(25), + fontface1 varchar(25), + fontface2 varchar(25), + fontface3 varchar(25), fontsize1 int2, fontsize2 int2, fontsize3 int2, fontcolor1 char(6), fontcolor2 char(6), fontcolor3 char(6), - img1 varchar(100), - img2 varchar(100), - img3 varchar(100), - img4 varchar(100), + span_class1 varchar(25), + span_class2 varchar(25), + span_class3 varchar(25), CONSTRAINT phpbb_themes_pkey PRIMARY KEY (themes_id) ); CREATE INDEX themes_name_phpbb_themes_index ON phpbb_themes (themes_name); @@ -349,28 +358,36 @@ CREATE INDEX themes_name_phpbb_themes_index ON phpbb_themes (themes_name); -------------------------------------------------------- */ CREATE TABLE phpbb_themes_name ( themes_id int4 DEFAULT '0' NOT NULL, - tr_color1_name varchar(50), - tr_color2_name varchar(50), - tr_color3_name varchar(50), - th_color1_name varchar(50), - th_color2_name varchar(50), - th_color3_name varchar(50), - td_color1_name varchar(50), - td_color2_name varchar(50), - td_color3_name varchar(50), + tr_color1_name char(50), + tr_color2_name char(50), + tr_color3_name char(50), + tr_class1_name varchar(50), + tr_class2_name varchar(50), + tr_class3_name varchar(50), + th_color1_name char(50), + th_color2_name char(50), + th_color3_name char(50), + th_class1_name varchar(50), + th_class2_name varchar(50), + th_class3_name varchar(50), + td_color1_name char(50), + td_color2_name char(50), + td_color3_name char(50), + td_class1_name varchar(50), + td_class2_name varchar(50), + td_class3_name varchar(50), fontface1_name varchar(50), fontface2_name varchar(50), fontface3_name varchar(50), fontsize1_name varchar(50), fontsize2_name varchar(50), fontsize3_name varchar(50), - fontcolor1_name varchar(50), - fontcolor2_name varchar(50), - fontcolor3_name varchar(50), - img1_name varchar(50), - img2_name varchar(50), - img3_name varchar(50), - img4_name varchar(50), + fontcolor1_name char(50), + fontcolor2_name char(50), + fontcolor3_name char(50), + span_class1_name varchar(50), + span_class2_name varchar(50), + span_class3_name varchar(50), CONSTRAINT phpbb_themes_name_pkey PRIMARY KEY (themes_id) ); |