source: contrib/MailArchiver/sources/scripts/out/metaarchive-schema-generated.sql @ 6785

Revision 6785, 12.2 KB checked in by rafaelraymundo, 12 years ago (diff)

Ticket #2946 - Liberado codigo do MailArchiver?. Documentação na subpasta DOCS.
Line 
1------------------------------------------------------------------
2-- DataNucleus SchemaTool (ran at 12/03/2012 13:02:28)
3------------------------------------------------------------------
4-- Complete schema required for the following classes:-
5--     serpro.mailarchiver.domain.metaarchive.Address
6--     serpro.mailarchiver.domain.metaarchive.AddressListField
7--     serpro.mailarchiver.domain.metaarchive.AddressListField_Address
8--     serpro.mailarchiver.domain.metaarchive.AddressListField_Group
9--     serpro.mailarchiver.domain.metaarchive.AddressListField_Group_Mailbox
10--     serpro.mailarchiver.domain.metaarchive.AddressListField_Mailbox
11--     serpro.mailarchiver.domain.metaarchive.BinaryBody
12--     serpro.mailarchiver.domain.metaarchive.Body
13--     serpro.mailarchiver.domain.metaarchive.BodyEntity
14--     serpro.mailarchiver.domain.metaarchive.BodyPart
15--     serpro.mailarchiver.domain.metaarchive.ContentDispositionField
16--     serpro.mailarchiver.domain.metaarchive.ContentTypeField
17--     serpro.mailarchiver.domain.metaarchive.DateTimeField
18--     serpro.mailarchiver.domain.metaarchive.EmbeddedMessage
19--     serpro.mailarchiver.domain.metaarchive.Entity
20--     serpro.mailarchiver.domain.metaarchive.Field
21--     serpro.mailarchiver.domain.metaarchive.FieldAddress
22--     serpro.mailarchiver.domain.metaarchive.Folder
23--     serpro.mailarchiver.domain.metaarchive.MailboxField
24--     serpro.mailarchiver.domain.metaarchive.MailboxField_Mailbox
25--     serpro.mailarchiver.domain.metaarchive.MailboxListField
26--     serpro.mailarchiver.domain.metaarchive.MailboxListField_Mailbox
27--     serpro.mailarchiver.domain.metaarchive.Message
28--     serpro.mailarchiver.domain.metaarchive.MessageBody
29--     serpro.mailarchiver.domain.metaarchive.Multipart
30--     serpro.mailarchiver.domain.metaarchive.Setting
31--     serpro.mailarchiver.domain.metaarchive.SingleBody
32--     serpro.mailarchiver.domain.metaarchive.TextBody
33--     serpro.mailarchiver.domain.metaarchive.UnstructuredField
34--     serpro.mailarchiver.domain.metaarchive.User
35--     serpro.mailarchiver.service.Settings
36--     serpro.mailarchiver.service.Utils
37--     serpro.mailarchiver.service.find.FBinaryBody
38--     serpro.mailarchiver.service.find.FFolder
39--     serpro.mailarchiver.service.find.FMessage
40--     serpro.mailarchiver.service.find.FTextBody
41--     serpro.mailarchiver.service.find.FUser
42--     serpro.mailarchiver.service.web.DefaultArchiveOperation
43--     serpro.mailarchiver.service.web.DefaultArchiveServices
44--     serpro.mailarchiver.service.web.DefaultCopyMessagesOperation
45--     serpro.mailarchiver.service.web.DefaultCreateAbsoluteFolderOperation
46--     serpro.mailarchiver.service.web.DefaultCreateFolderOperation
47--     serpro.mailarchiver.service.web.DefaultDeleteFolderOperation
48--     serpro.mailarchiver.service.web.DefaultDeleteMessagesOperation
49--     serpro.mailarchiver.service.web.DefaultGetFaultInfoOperation
50--     serpro.mailarchiver.service.web.DefaultGetFolderInfoOperation
51--     serpro.mailarchiver.service.web.DefaultGetMessageBodyOperation
52--     serpro.mailarchiver.service.web.DefaultGetMessageInfoOperation
53--     serpro.mailarchiver.service.web.DefaultGetRawBinaryBodyOperation
54--     serpro.mailarchiver.service.web.DefaultGetStateOperation
55--     serpro.mailarchiver.service.web.DefaultListAttachmentsOperation
56--     serpro.mailarchiver.service.web.DefaultListFoldersOperation
57--     serpro.mailarchiver.service.web.DefaultListMessagesOperation
58--     serpro.mailarchiver.service.web.DefaultLoginOperation
59--     serpro.mailarchiver.service.web.DefaultLogoutOperation
60--     serpro.mailarchiver.service.web.DefaultMoveFolderOperation
61--     serpro.mailarchiver.service.web.DefaultMoveMessagesOperation
62--     serpro.mailarchiver.service.web.DefaultRenameFolderOperation
63--     serpro.mailarchiver.service.web.DefaultTagMessagesOperation
64--     serpro.mailarchiver.service.web.DefaultZipMessagesOperation
65--     serpro.mailarchiver.service.web.ServiceFault
66--
67-- Table METAARCHIVE.ADDRESS for classes [serpro.mailarchiver.domain.metaarchive.AddressListField_Group_Mailbox, serpro.mailarchiver.domain.metaarchive.Address, serpro.mailarchiver.domain.metaarchive.FieldAddress, serpro.mailarchiver.domain.metaarchive.MailboxListField_Mailbox, serpro.mailarchiver.domain.metaarchive.AddressListField_Mailbox, serpro.mailarchiver.domain.metaarchive.MailboxField_Mailbox, serpro.mailarchiver.domain.metaarchive.AddressListField_Group, serpro.mailarchiver.domain.metaarchive.AddressListField_Address]
68CREATE TABLE METAARCHIVE.ADDRESS
69(
70    OID VARCHAR(36) NOT NULL,
71    MBX_DOMAIN VARCHAR(1000) NULL,
72    MBX_LOCAL_PART VARCHAR(1000) NULL,
73    ADDR_NAME VARCHAR(1000) NULL,
74    MBX_ROUTE VARCHAR(10000) NULL,
75    DISCRIMINATOR VARCHAR(40) NOT NULL,
76    GROUP_OID VARCHAR(36) NULL,
77    GROUP_IDX INTEGER NULL,
78    FIELD_OID VARCHAR(36) NULL,
79    FIELD_IDX INTEGER NULL,
80    CONSTRAINT ADDRESS_PK PRIMARY KEY (OID)
81);
82
83-- Table METAARCHIVE.FIELD for classes [serpro.mailarchiver.domain.metaarchive.DateTimeField, serpro.mailarchiver.domain.metaarchive.ContentTypeField, serpro.mailarchiver.domain.metaarchive.Field, serpro.mailarchiver.domain.metaarchive.AddressListField, serpro.mailarchiver.domain.metaarchive.ContentDispositionField, serpro.mailarchiver.domain.metaarchive.UnstructuredField, serpro.mailarchiver.domain.metaarchive.MailboxField, serpro.mailarchiver.domain.metaarchive.MailboxListField]
84CREATE TABLE METAARCHIVE.FIELD
85(
86    OID VARCHAR(36) NOT NULL,
87    ENTITY_OID VARCHAR(36) NOT NULL,
88    ENTITY_IDX INTEGER NOT NULL,
89    FIELD_NAME VARCHAR(1000) NOT NULL,
90    PARSE_EXCEPTION_STACK_TRACE VARCHAR(100000) NULL,
91    VALID BOOLEAN NOT NULL,
92    DISCRIMINATOR VARCHAR(40) NOT NULL,
93    MEDIA_TYPE VARCHAR(100) NULL,
94    SUB_TYPE VARCHAR(100) NULL,
95    DATE_TIME TIMESTAMP NULL,
96    DISPOSITION_TYPE VARCHAR(100) NULL,
97    TEXT VARCHAR(10000) NULL,
98    CONSTRAINT FIELD_PK PRIMARY KEY (OID)
99);
100
101-- Table METAARCHIVE.BODY for classes [serpro.mailarchiver.domain.metaarchive.Body, serpro.mailarchiver.domain.metaarchive.SingleBody, serpro.mailarchiver.domain.metaarchive.Multipart, serpro.mailarchiver.domain.metaarchive.MessageBody, serpro.mailarchiver.domain.metaarchive.BinaryBody, serpro.mailarchiver.domain.metaarchive.TextBody]
102CREATE TABLE METAARCHIVE.BODY
103(
104    OID VARCHAR(36) NOT NULL,
105    ENTITY_OID VARCHAR(36) NOT NULL,
106    DISCRIMINATOR VARCHAR(40) NOT NULL,
107    PREVIEW VARCHAR(10000) NULL,
108    EPILOGUE VARCHAR(10000) NULL,
109    PREAMBLE VARCHAR(10000) NULL,
110    BODY_LENGTH INTEGER NULL,
111    BODY_OFFSET INTEGER NULL,
112    BODY_SIZE INTEGER NULL,
113    CONSTRAINT BODY_PK PRIMARY KEY (OID)
114);
115
116-- Table METAARCHIVE."USER" for classes [serpro.mailarchiver.domain.metaarchive.User]
117CREATE TABLE METAARCHIVE."USER"
118(
119    USER_ID VARCHAR(100) NOT NULL,
120    PASSWORD VARCHAR(1000) NOT NULL,
121    CONSTRAINT USER_PK PRIMARY KEY (USER_ID)
122);
123
124-- Table METAARCHIVE.ENTITY for classes [serpro.mailarchiver.domain.metaarchive.BodyEntity, serpro.mailarchiver.domain.metaarchive.Message, serpro.mailarchiver.domain.metaarchive.EmbeddedMessage, serpro.mailarchiver.domain.metaarchive.BodyPart, serpro.mailarchiver.domain.metaarchive.Entity]
125CREATE TABLE METAARCHIVE.ENTITY
126(
127    OID VARCHAR(36) NOT NULL,
128    END_LINE INTEGER NULL,
129    SEPARATOR_LINE INTEGER NULL,
130    ENTITY_SIZE INTEGER NULL,
131    START_LINE INTEGER NULL,
132    DISCRIMINATOR VARCHAR(40) NOT NULL,
133    FOLDER_OID VARCHAR(36) NULL,
134    FOLDER_IDX INTEGER NULL,
135    QUERY_CANDIDATES_SET BIGINT NULL,
136    COMPOSITE_OID VARCHAR(36) NULL,
137    COMPOSITE_IDX INTEGER NULL,
138    CONSTRAINT ENTITY_PK PRIMARY KEY (OID)
139);
140
141-- Table METAARCHIVE.SETTING for classes [serpro.mailarchiver.domain.metaarchive.Setting]
142CREATE TABLE METAARCHIVE.SETTING
143(
144    ATTR_NAME VARCHAR(100) NOT NULL,
145    ATTR_VALUE VARCHAR(1000) NOT NULL,
146    CONSTRAINT SETTING_PK PRIMARY KEY (ATTR_NAME)
147);
148
149-- Table METAARCHIVE.FOLDER for classes [serpro.mailarchiver.domain.metaarchive.Folder]
150CREATE TABLE METAARCHIVE.FOLDER
151(
152    OID VARCHAR(36) NOT NULL,
153    FOLDER_NAME VARCHAR(1000) NOT NULL,
154    PARENT_OID VARCHAR(36) NULL,
155    PARENT_IDX INTEGER NULL,
156    CONSTRAINT FOLDER_PK PRIMARY KEY (OID)
157);
158
159-- Table METAARCHIVE."PARAMETER" for join relationship
160CREATE TABLE METAARCHIVE."PARAMETER"
161(
162    FIELD_OID VARCHAR(36) NOT NULL,
163    ATTR_NAME VARCHAR(100) NOT NULL,
164    ATTR_VALUE VARCHAR(1000) NULL,
165    CONSTRAINT PARAMETER_PK PRIMARY KEY (FIELD_OID,ATTR_NAME)
166);
167
168-- Table METAARCHIVE.TAG for join relationship
169CREATE TABLE METAARCHIVE.TAG
170(
171    ENTITY_OID VARCHAR(36) NOT NULL,
172    TAG_VALUE VARCHAR(100) NOT NULL,
173    CONSTRAINT TAG_PK PRIMARY KEY (ENTITY_OID,TAG_VALUE)
174);
175
176-- Constraints for table METAARCHIVE.ADDRESS for class(es) [serpro.mailarchiver.domain.metaarchive.AddressListField_Group_Mailbox, serpro.mailarchiver.domain.metaarchive.Address, serpro.mailarchiver.domain.metaarchive.FieldAddress, serpro.mailarchiver.domain.metaarchive.MailboxListField_Mailbox, serpro.mailarchiver.domain.metaarchive.AddressListField_Mailbox, serpro.mailarchiver.domain.metaarchive.MailboxField_Mailbox, serpro.mailarchiver.domain.metaarchive.AddressListField_Group, serpro.mailarchiver.domain.metaarchive.AddressListField_Address]
177ALTER TABLE METAARCHIVE.ADDRESS ADD CONSTRAINT ADDRESS_FK1 FOREIGN KEY (GROUP_OID) REFERENCES METAARCHIVE.ADDRESS (OID) ;
178
179ALTER TABLE METAARCHIVE.ADDRESS ADD CONSTRAINT ADDRESS_FK2 FOREIGN KEY (FIELD_OID) REFERENCES METAARCHIVE.FIELD (OID) ;
180
181CREATE INDEX ADDRESS_N49 ON METAARCHIVE.ADDRESS (GROUP_OID);
182
183CREATE INDEX ADDRESS_N50 ON METAARCHIVE.ADDRESS (FIELD_OID);
184
185
186-- Constraints for table METAARCHIVE.FIELD for class(es) [serpro.mailarchiver.domain.metaarchive.DateTimeField, serpro.mailarchiver.domain.metaarchive.ContentTypeField, serpro.mailarchiver.domain.metaarchive.Field, serpro.mailarchiver.domain.metaarchive.AddressListField, serpro.mailarchiver.domain.metaarchive.ContentDispositionField, serpro.mailarchiver.domain.metaarchive.UnstructuredField, serpro.mailarchiver.domain.metaarchive.MailboxField, serpro.mailarchiver.domain.metaarchive.MailboxListField]
187ALTER TABLE METAARCHIVE.FIELD ADD CONSTRAINT FIELD_FK1 FOREIGN KEY (ENTITY_OID) REFERENCES METAARCHIVE.ENTITY (OID) ;
188
189CREATE INDEX FIELD_N49 ON METAARCHIVE.FIELD (ENTITY_OID);
190
191
192-- Constraints for table METAARCHIVE.BODY for class(es) [serpro.mailarchiver.domain.metaarchive.Body, serpro.mailarchiver.domain.metaarchive.SingleBody, serpro.mailarchiver.domain.metaarchive.Multipart, serpro.mailarchiver.domain.metaarchive.MessageBody, serpro.mailarchiver.domain.metaarchive.BinaryBody, serpro.mailarchiver.domain.metaarchive.TextBody]
193ALTER TABLE METAARCHIVE.BODY ADD CONSTRAINT BODY_FK1 FOREIGN KEY (ENTITY_OID) REFERENCES METAARCHIVE.ENTITY (OID) ;
194
195CREATE INDEX BODY_N49 ON METAARCHIVE.BODY (ENTITY_OID);
196
197
198-- Constraints for table METAARCHIVE."USER" for class(es) [serpro.mailarchiver.domain.metaarchive.User]
199
200-- Constraints for table METAARCHIVE.ENTITY for class(es) [serpro.mailarchiver.domain.metaarchive.BodyEntity, serpro.mailarchiver.domain.metaarchive.Message, serpro.mailarchiver.domain.metaarchive.EmbeddedMessage, serpro.mailarchiver.domain.metaarchive.BodyPart, serpro.mailarchiver.domain.metaarchive.Entity]
201ALTER TABLE METAARCHIVE.ENTITY ADD CONSTRAINT ENTITY_FK1 FOREIGN KEY (COMPOSITE_OID) REFERENCES METAARCHIVE.BODY (OID) ;
202
203ALTER TABLE METAARCHIVE.ENTITY ADD CONSTRAINT ENTITY_FK2 FOREIGN KEY (FOLDER_OID) REFERENCES METAARCHIVE.FOLDER (OID) ;
204
205CREATE INDEX ENTITY_N50 ON METAARCHIVE.ENTITY (COMPOSITE_OID);
206
207CREATE INDEX ENTITY_N49 ON METAARCHIVE.ENTITY (FOLDER_OID);
208
209
210-- Constraints for table METAARCHIVE.SETTING for class(es) [serpro.mailarchiver.domain.metaarchive.Setting]
211
212-- Constraints for table METAARCHIVE.FOLDER for class(es) [serpro.mailarchiver.domain.metaarchive.Folder]
213ALTER TABLE METAARCHIVE.FOLDER ADD CONSTRAINT FOLDER_FK1 FOREIGN KEY (PARENT_OID) REFERENCES METAARCHIVE.FOLDER (OID) ;
214
215CREATE INDEX FOLDER_N49 ON METAARCHIVE.FOLDER (PARENT_OID);
216
217
218-- Constraints for table METAARCHIVE."PARAMETER"
219ALTER TABLE METAARCHIVE."PARAMETER" ADD CONSTRAINT PARAMETER_FK1 FOREIGN KEY (FIELD_OID) REFERENCES METAARCHIVE.FIELD (OID) ;
220
221CREATE INDEX PARAMETER_N49 ON METAARCHIVE."PARAMETER" (FIELD_OID);
222
223
224-- Constraints for table METAARCHIVE.TAG
225ALTER TABLE METAARCHIVE.TAG ADD CONSTRAINT TAG_FK1 FOREIGN KEY (ENTITY_OID) REFERENCES METAARCHIVE.ENTITY (OID) ;
226
227CREATE INDEX TAG_N49 ON METAARCHIVE.TAG (ENTITY_OID);
228
229
230
231------------------------------------------------------------------
232-- Sequences and SequenceTables
Note: See TracBrowser for help on using the repository browser.