diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2012-11-13 11:29:25 +0100 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2012-11-13 11:29:25 +0100 |
| commit | df735f46033a92657dce004c2d5ece6866565208 (patch) | |
| tree | 3660ffcae878eff7c0ce1e139e5c80f25f76d309 /phpBB/install/schemas/mssql_schema.sql | |
| parent | ff7465e75f129d23a0f9f4fd6a1c556ec2b7bb13 (diff) | |
| download | forums-df735f46033a92657dce004c2d5ece6866565208.tar forums-df735f46033a92657dce004c2d5ece6866565208.tar.gz forums-df735f46033a92657dce004c2d5ece6866565208.tar.bz2 forums-df735f46033a92657dce004c2d5ece6866565208.tar.xz forums-df735f46033a92657dce004c2d5ece6866565208.zip | |
[ticket/10411] Add new table for teampage
PHPBB3-10411
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 24 |
1 files changed, 22 insertions, 2 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index 84c975942f..bc7164325d 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -1111,8 +1111,8 @@ CREATE TABLE [phpbb_reports] ( [report_time] [int] DEFAULT (0) NOT NULL , [report_text] [text] DEFAULT ('') NOT NULL , [reported_post_text] [text] DEFAULT ('') NOT NULL , - [reported_post_bitfield] [varchar] (255) DEFAULT ('') NOT NULL , - [reported_post_uid] [varchar] (8) DEFAULT ('') NOT NULL + [reported_post_uid] [varchar] (8) DEFAULT ('') NOT NULL , + [reported_post_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO @@ -1345,6 +1345,26 @@ GO /* + Table: 'phpbb_teampage' +*/ +CREATE TABLE [phpbb_teampage] ( + [teampage_id] [int] IDENTITY (1, 1) NOT NULL , + [group_id] [int] DEFAULT (0) NOT NULL , + [teampage_name] [varchar] (255) DEFAULT ('') NOT NULL , + [teampage_position] [int] DEFAULT (0) NOT NULL , + [teampage_parent] [int] DEFAULT (0) NOT NULL +) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_teampage] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_teampage] PRIMARY KEY CLUSTERED + ( + [teampage_id] + ) ON [PRIMARY] +GO + + +/* Table: 'phpbb_topics' */ CREATE TABLE [phpbb_topics] ( |