Last modified by Thomas Mortagne on 2023/10/10

<
From version < 14.1 >
edited by JohannesStoldt
on 2011/01/17
To version < 14.2 >
edited by wrose
on 2011/06/07
>
Change comment: Added comment

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.JohannesStoldt
1 +XWiki.wrose
XWiki.XWikiComments[7]
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.wrose
Comment
... ... @@ -1,0 +1,147 @@
1 +To get XWiki 3.0 to install on SQL Server 2008, I needed to create some of the schema manually after editing the statements generated by Hibernate. The Hibernate 3.2 SQLServerDialect class is targeted to SQL Server 2000, and the SQLServer2008Dialect is not available until Hibernate 3.6.
2 +
3 +The following statements created the tables that Hibernate was generating incorrectly:(((
4 +{{code language="sql"}}
5 +create table XWIKICLASSES
6 + (
7 + XWO_ID int not null,
8 + XWO_NAME varchar(255) not null,
9 + XWO_CUSTOM_MAPPING varchar(max) null,
10 + XWO_CUSTOM_CLASS varchar(255) null,
11 + XWO_VALIDATION_SCRIPT varchar(255) null,
12 + primary key (XWO_ID)
13 + )
14 +
15 +create table XWIKICLASSESPROP
16 + (
17 + XWP_ID int not null,
18 + XWP_NAME varchar(255) not null,
19 + XWP_PRETTYNAME varchar(255) null,
20 + XWP_CLASSTYPE varchar(255) null,
21 + XWP_UNMODIFIABLE tinyint null,
22 + XWP_NUMBER int null,
23 + XWP_CUSTOMDISPLAY varchar(max) null,
24 + XWP_VALIDATION_REGEXP varchar(255) null,
25 + primary key (XWP_ID, XWP_NAME)
26 + )
27 +
28 +create table XWIKICOMMENTS
29 + (
30 + XWC_ID int not null,
31 + XWC_AUTHOR varchar(255) null,
32 + XWC_HIGHLIGHT varchar(max) null,
33 + XWC_COMMENT varchar(max) null,
34 + XWP_REPLYTO int null,
35 + XWP_DATE datetime null,
36 + primary key (XWC_ID)
37 + )
38 +
39 +create table XWIKIDOC
40 + (
41 + XWD_ID numeric(19, 0) not null,
42 + XWD_FULLNAME varchar(255) not null,
43 + XWD_NAME varchar(255) not null,
44 + XWD_TITLE varchar(255) not null,
45 + XWD_LANGUAGE varchar(5) null,
46 + XWD_DEFAULT_LANGUAGE varchar(5) null,
47 + XWD_TRANSLATION int not null,
48 + XWD_DATE datetime not null,
49 + XWD_CONTENT_UPDATE_DATE datetime not null,
50 + XWD_CREATION_DATE datetime not null,
51 + XWD_AUTHOR varchar(255) not null,
52 + XWD_CONTENT_AUTHOR varchar(255) not null,
53 + XWD_CREATOR varchar(255) not null,
54 + XWD_WEB varchar(255) not null,
55 + XWD_CONTENT varchar(max) not null,
56 + XWD_VERSION varchar(255) not null,
57 + XWD_CUSTOM_CLASS varchar(255) not null,
58 + XWD_PARENT varchar(511) not null,
59 + XWD_CLASS_XML varchar(max) null,
60 + XWD_ELEMENTS int null,
61 + XWD_DEFAULT_TEMPLATE varchar(255) not null,
62 + XWD_VALIDATION_SCRIPT varchar(255) not null,
63 + XWD_COMMENT varchar(1023) not null,
64 + XWD_MINOREDIT tinyint not null,
65 + XWD_SYNTAX_ID varchar(50) null,
66 + XWD_HIDDEN tinyint not null,
67 + primary key (XWD_ID)
68 + )
69 +
70 +create table XWIKILARGESTRINGS
71 + (
72 + XWL_ID int not null,
73 + XWL_NAME varchar(255) not null,
74 + XWL_VALUE varchar(max) null,
75 + primary key (XWL_ID, XWL_NAME)
76 + )
77 +
78 +create table XWIKIPREFERENCES
79 + (
80 + XWP_ID int not null,
81 + XWP_LANGUAGE varchar(255) null,
82 + XWP_DEFAULT_LANGUAGE varchar(255) null,
83 + XWP_MULTI_LINGUAL int null,
84 + XWP_AUTHENTICATE_EDIT int null,
85 + XWP_AUTHENTICATE_VIEW int null,
86 + XWP_AUTH_ACTIVE_CHECK int null,
87 + XWP_BACKLINKS int null,
88 + XWP_SKIN varchar(255) null,
89 + XWP_STYLESHEET varchar(255) null,
90 + XWP_STYLESHEETS varchar(255) null,
91 + XWP_EDITOR varchar(255) null,
92 + XWP_WEBCOPYRIGHT varchar(255) null,
93 + XWP_TITLE varchar(255) null,
94 + XWP_VERSION varchar(255) null,
95 + XWP_META varchar(max) null,
96 + XWP_USE_EMAIL_VERIFICATION int null,
97 + XWP_SMTP_SERVER varchar(255) null,
98 + XWP_ADMIN_EMAIL varchar(255) null,
99 + XWP_VALIDATION_EMAIL_CONTENT varchar(max) null,
100 + XWP_CONFIRMATION_EMAIL_CONTENT varchar(max) null,
101 + XWP_INVITATION_EMAIL_CONTENT varchar(max) null,
102 + XWP_LEFT_PANELS varchar(2000) null,
103 + XWP_RIGHT_PANELS varchar(2000) null,
104 + XWP_SHOW_LEFT_PANELS int null,
105 + XWP_SHOW_RIGHT_PANELS int null,
106 + XWP_LANGUAGES varchar(255) null,
107 + XWP_REGISTRATION_ANONYMOUS varchar(255) null,
108 + XWP_REGISTRATION_REGISTERED varchar(255) null,
109 + XWP_EDIT_ANONYMOUS varchar(255) null,
110 + XWP_EDIT_REGISTERED varchar(255) null,
111 + XWP_COMMENT_ANONYMOUS varchar(255) null,
112 + XWP_COMMENT_REGISTERED varchar(255) null,
113 + XWP_DOCUMENT_BUNDLES varchar(2000) null,
114 + primary key (XWP_ID)
115 + )
116 +
117 +create table XWIKISTATSREFERER
118 + (
119 + XWR_ID int not null,
120 + XWR_NUMBER int null,
121 + XWR_NAME varchar(255) not null,
122 + XWR_CLASSNAME varchar(255) not null,
123 + XWR_REFERER varchar(max) not null,
124 + XWR_PAGE_VIEWS int null,
125 + XWR_PERIOD int null,
126 + primary key (XWR_ID)
127 + )
128 +
129 +create table XWIKISTATSVISIT
130 + (
131 + XWV_ID int not null,
132 + XWV_NUMBER int null,
133 + XWV_NAME varchar(255) not null,
134 + XWV_CLASSNAME varchar(255) not null,
135 + XWV_IP varchar(255) not null,
136 + XWV_USER_AGENT varchar(max) not null,
137 + XWV_COOKIE varchar(max) not null,
138 + XWV_UNIQUE_ID varchar(255) not null,
139 + XWV_PAGE_VIEWS int null,
140 + XWV_PAGE_SAVES int null,
141 + XWV_DOWNLOADS int null,
142 + XWV_START_DATE datetime null,
143 + XWV_END_DATE datetime null,
144 + primary key (XWV_ID)
145 + )
146 +{{/code}}
147 +)))
Date
... ... @@ -1,0 +1,1 @@
1 +2011-06-07 09:57:48.765

Get Connected