659bae34a8176e323d6780f92c178952887c90ea
[platform/core/security/suspicious-activity-monitor.git] / server / samserver / src / main / resources / config / liquibase / report / changelog / 20180403081058_added_entity_ReportSyscall.xml
1 <?xml version="1.0" encoding="utf-8"?>
2 <databaseChangeLog
3     xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
4     xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
5     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
6     xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd
7                         http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
8
9     <property name="now" value="now()" dbms="h2"/>
10
11     <property name="now" value="current_timestamp" dbms="postgresql"/>
12
13     <property name="floatType" value="float4" dbms="postgresql, h2"/>
14     <property name="floatType" value="float" dbms="mysql, oracle, mssql"/>
15
16     <!--
17         Added the entity ReportSyscall.
18     -->
19     <changeSet id="20180403081058-1" author="jhipster">
20         <createTable tableName="report_syscall">
21             <column name="id" type="bigint" autoIncrement="${autoIncrement}">
22                 <constraints primaryKey="true" nullable="false"/>
23             </column>
24             <column name="jhi_time" type="integer">
25                 <constraints nullable="true" />
26             </column>
27
28             <column name="subj" type="varchar(1023)">
29                 <constraints nullable="true" />
30             </column>
31
32             <column name="subjowneruid" type="integer">
33                 <constraints nullable="true" />
34             </column>
35
36             <column name="subjownerguid" type="integer">
37                 <constraints nullable="true" />
38             </column>
39
40             <column name="subjownereuid" type="integer">
41                 <constraints nullable="true" />
42             </column>
43
44             <column name="subjowneregid" type="integer">
45                 <constraints nullable="true" />
46             </column>
47
48             <column name="subjpid" type="integer">
49                 <constraints nullable="true" />
50             </column>
51
52             <column name="subjlabel" type="varchar(255)">
53                 <constraints nullable="true" />
54             </column>
55
56             <column name="obj" type="varchar(1023)">
57                 <constraints nullable="true" />
58             </column>
59
60             <column name="objtype" type="integer">
61                 <constraints nullable="true" />
62             </column>
63
64             <column name="objowneruid" type="integer">
65                 <constraints nullable="true" />
66             </column>
67
68             <column name="objownergid" type="integer">
69                 <constraints nullable="true" />
70             </column>
71
72             <column name="objownereuid" type="integer">
73                 <constraints nullable="true" />
74             </column>
75
76             <column name="objowneregid" type="integer">
77                 <constraints nullable="true" />
78             </column>
79
80             <column name="objperm" type="integer">
81                 <constraints nullable="true" />
82             </column>
83
84             <column name="objlabel" type="varchar(255)">
85                 <constraints nullable="true" />
86             </column>
87
88             <column name="objpid" type="integer">
89                 <constraints nullable="true" />
90             </column>
91
92             <column name="objinode" type="integer">
93                 <constraints nullable="true" />
94             </column>
95
96             <column name="syscall" type="integer">
97                 <constraints nullable="true" />
98             </column>
99
100             <column name="syscallargs" type="integer">
101                 <constraints nullable="true" />
102             </column>
103
104             <column name="syscallexitcode" type="integer">
105                 <constraints nullable="true" />
106             </column>
107
108             <!-- jhipster-needle-liquibase-add-column - JHipster will add columns here, do not remove-->
109         </createTable>
110         
111     </changeSet>
112     <!-- jhipster-needle-liquibase-add-changeset - JHipster will add changesets here, do not remove-->
113 </databaseChangeLog>