aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mssql_schema.sql
diff options
context:
space:
mode:
authorDavid M <davidmj@users.sourceforge.net>2007-04-08 17:40:36 +0000
committerDavid M <davidmj@users.sourceforge.net>2007-04-08 17:40:36 +0000
commit887863e5c5ba80cd1bcbcd6097719afe2178c672 (patch)
treee8b433b0b9aaf9266315448c96aa6ac6a0be2f6c /phpBB/install/schemas/mssql_schema.sql
parent0be22140b2338b4b77f257fd3c2928d5038287fd (diff)
downloadforums-887863e5c5ba80cd1bcbcd6097719afe2178c672.tar
forums-887863e5c5ba80cd1bcbcd6097719afe2178c672.tar.gz
forums-887863e5c5ba80cd1bcbcd6097719afe2178c672.tar.bz2
forums-887863e5c5ba80cd1bcbcd6097719afe2178c672.tar.xz
forums-887863e5c5ba80cd1bcbcd6097719afe2178c672.zip
- overhaul of imagesets
imagesets are now "intelligently" multilingual, one may use imagesets inside of CSS files now (as well as properties like the width and height of an imageset's image) all previous styles should change their imageset.cfg to be like prosilver and subsilver2 (notice how there is now an imageset.cfg in the /en folder, there should be one for each language) git-svn-id: file:///svn/phpbb/trunk@7304 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
-rw-r--r--phpBB/install/schemas/mssql_schema.sql121
1 files changed, 26 insertions, 95 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 3fa46ff7dd..537da725a2 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -1356,101 +1356,7 @@ CREATE TABLE [phpbb_styles_imageset] (
[imageset_id] [int] IDENTITY (1, 1) NOT NULL ,
[imageset_name] [varchar] (255) DEFAULT ('') NOT NULL ,
[imageset_copyright] [varchar] (255) DEFAULT ('') NOT NULL ,
- [imageset_path] [varchar] (100) DEFAULT ('') NOT NULL ,
- [site_logo] [varchar] (200) DEFAULT ('') NOT NULL ,
- [upload_bar] [varchar] (200) DEFAULT ('') NOT NULL ,
- [poll_left] [varchar] (200) DEFAULT ('') NOT NULL ,
- [poll_center] [varchar] (200) DEFAULT ('') NOT NULL ,
- [poll_right] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_friend] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_foe] [varchar] (200) DEFAULT ('') NOT NULL ,
- [forum_link] [varchar] (200) DEFAULT ('') NOT NULL ,
- [forum_read] [varchar] (200) DEFAULT ('') NOT NULL ,
- [forum_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
- [forum_read_subforum] [varchar] (200) DEFAULT ('') NOT NULL ,
- [forum_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
- [forum_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
- [forum_unread_subforum] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_moved] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_read] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_read_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_read_hot] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_read_hot_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_read_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_unread_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_unread_hot] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_unread_hot_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
- [topic_unread_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [sticky_read] [varchar] (200) DEFAULT ('') NOT NULL ,
- [sticky_read_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [sticky_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
- [sticky_read_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [sticky_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
- [sticky_unread_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [sticky_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
- [sticky_unread_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [announce_read] [varchar] (200) DEFAULT ('') NOT NULL ,
- [announce_read_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [announce_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
- [announce_read_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [announce_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
- [announce_unread_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [announce_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
- [announce_unread_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [global_read] [varchar] (200) DEFAULT ('') NOT NULL ,
- [global_read_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [global_read_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
- [global_read_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [global_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
- [global_unread_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [global_unread_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
- [global_unread_locked_mine] [varchar] (200) DEFAULT ('') NOT NULL ,
- [pm_read] [varchar] (200) DEFAULT ('') NOT NULL ,
- [pm_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_contact_aim] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_contact_email] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_contact_icq] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_contact_jabber] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_contact_msnm] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_contact_pm] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_contact_yahoo] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_contact_www] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_post_delete] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_post_edit] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_post_info] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_post_quote] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_post_report] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_post_target] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_post_target_unread] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_topic_attach] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_topic_latest] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_topic_newest] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_topic_reported] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_topic_unapproved] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_user_online] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_user_offline] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_user_profile] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_user_search] [varchar] (200) DEFAULT ('') NOT NULL ,
- [icon_user_warn] [varchar] (200) DEFAULT ('') NOT NULL ,
- [button_pm_forward] [varchar] (200) DEFAULT ('') NOT NULL ,
- [button_pm_new] [varchar] (200) DEFAULT ('') NOT NULL ,
- [button_pm_reply] [varchar] (200) DEFAULT ('') NOT NULL ,
- [button_topic_locked] [varchar] (200) DEFAULT ('') NOT NULL ,
- [button_topic_new] [varchar] (200) DEFAULT ('') NOT NULL ,
- [button_topic_reply] [varchar] (200) DEFAULT ('') NOT NULL ,
- [user_icon1] [varchar] (200) DEFAULT ('') NOT NULL ,
- [user_icon2] [varchar] (200) DEFAULT ('') NOT NULL ,
- [user_icon3] [varchar] (200) DEFAULT ('') NOT NULL ,
- [user_icon4] [varchar] (200) DEFAULT ('') NOT NULL ,
- [user_icon5] [varchar] (200) DEFAULT ('') NOT NULL ,
- [user_icon6] [varchar] (200) DEFAULT ('') NOT NULL ,
- [user_icon7] [varchar] (200) DEFAULT ('') NOT NULL ,
- [user_icon8] [varchar] (200) DEFAULT ('') NOT NULL ,
- [user_icon9] [varchar] (200) DEFAULT ('') NOT NULL ,
- [user_icon10] [varchar] (200) DEFAULT ('') NOT NULL
+ [imageset_path] [varchar] (100) DEFAULT ('') NOT NULL
) ON [PRIMARY]
GO
@@ -1466,6 +1372,31 @@ GO
/*
+ Table: 'phpbb_styles_imageset_data'
+*/
+CREATE TABLE [phpbb_styles_imageset_data] (
+ [image_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [image_name] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [image_filename] [varchar] (200) DEFAULT ('') NOT NULL ,
+ [image_lang] [varchar] (30) DEFAULT ('') NOT NULL ,
+ [image_height] [int] DEFAULT (0) NOT NULL ,
+ [image_width] [int] DEFAULT (0) NOT NULL ,
+ [imageset_id] [int] DEFAULT (0) NOT NULL
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_styles_imageset_data] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_styles_imageset_data] PRIMARY KEY CLUSTERED
+ (
+ [image_id]
+ ) ON [PRIMARY]
+GO
+
+CREATE INDEX [imgset_id] ON [phpbb_styles_imageset_data]([imageset_id]) ON [PRIMARY]
+GO
+
+
+/*
Table: 'phpbb_topics'
*/
CREATE TABLE [phpbb_topics] (
generated by cgit v1.2.1 (git 2.21.0) at 2026-02-07 06:05:23 +0000