diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2017-01-18 00:33:59 +1300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-01-18 00:33:59 +1300 |
| commit | 2cdc0c93b759dfbdaff0c5577862b151d9aadf7f (patch) | |
| tree | b397ec630e858c76d7ea3ca29305def271f08f62 /schema | |
| parent | 09a5ceb7b1681cb50338f37f775e13a5121e4385 (diff) | |
| parent | 68abcc05ddd3633167f4e1c45d0ae9cf05dbcc43 (diff) | |
| download | trackermap-server-2cdc0c93b759dfbdaff0c5577862b151d9aadf7f.tar.gz trackermap-server-2cdc0c93b759dfbdaff0c5577862b151d9aadf7f.tar.bz2 trackermap-server-2cdc0c93b759dfbdaff0c5577862b151d9aadf7f.zip | |
Merge pull request #2801 from Abyss777/manager
Implement user management
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/changelog-3.10.xml | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/schema/changelog-3.10.xml b/schema/changelog-3.10.xml index d39b36112..137b3bc82 100644 --- a/schema/changelog-3.10.xml +++ b/schema/changelog-3.10.xml @@ -48,5 +48,21 @@ <column name="network" type="VARCHAR(4000)" /> </addColumn> + <addColumn tableName="users"> + <column name="userlimit" type="INT" defaultValueNumeric="0" /> + </addColumn> + + <createTable tableName="user_user"> + <column name="userid" type="INT"> + <constraints nullable="false" /> + </column> + <column name="manageduserid" type="INT"> + <constraints nullable="false" /> + </column> + </createTable> + + <addForeignKeyConstraint baseTableName="user_user" baseColumnNames="userid" constraintName="fk_user_user_userid" referencedTableName="users" referencedColumnNames="id" onDelete="CASCADE" /> + <addForeignKeyConstraint baseTableName="user_user" baseColumnNames="manageduserid" constraintName="fk_user_user_manageduserid" referencedTableName="users" referencedColumnNames="id" onDelete="CASCADE" /> + </changeSet> </databaseChangeLog> |