41 M:\svn\servadmin\erd\ERD01.dez 2007-07-18 2007-07-18 ServAdmin UI Jon Coulter 2008 M:\svn\servadmin\erd\create.sql;M:\svn\servadmin\erd\drop.sql;C:\Program Files\Datanamic\DeZign for Databases V4\logfiles\CreateDBLog_200707184.txt mysql5 10 PK_%table% %relname% CC_%table%_%column% NN_%column% DEF_%table%_%column% TUC_%table%_%counter% TCC_%table%_%counter% %parent%_%child% IDX_%table%_%counter% engine=innodb 1 1 1 1 1 1 1 0 1 1 1 1 1 1 M:\svn\servadmin\erd\create.sql M:\svn\servadmin\erd\drop.sql account 2 0 engine=innodb 9 3 1 1 PK_account PK_%table% 1 0 2 3 2 accountid 2 0 -1

INTEGER 0 1 1

NN_%column% 1 0 1 1 5 2 username 3 0 -1

VARCHAR 100 0 1

password 4 0 -1

VARCHAR 32 0 1

ownername 5 0 -1

VARCHAR 255 0 1

email 6 0 -1

VARCHAR 255 0 1

domain 7 0 -1

VARCHAR 255 0 1

accstatus 8 0 -1

VARCHAR 100 0 1

createdatetime 9 0 -1

DATETIME 0 1

IDX_account_1 IDX_%table%_%counter% 2 0 UNIQUE 0 0 3 IDX_account_2 IDX_%table%_%counter% 3 0 0 0 3 4 server 3 0 engine=innodb 11 2 1 1 PK_server PK_%table% 1 0 2 3 2 serverid 2 0 -1

INTEGER 0 1 1

NN_%column% 1 0 1 1 5 2 servname 3 0 -1

VARCHAR 100 0 1

servkey 4 0 -1

VARCHAR 200 0 1

servurl 5 0 -1

VARCHAR 250 0 1

ftpurl 6 0 -1

VARCHAR 200 0 1

nameserver1 7 0 -1

VARCHAR 200 0 1

nameserver2 8 0 -1

VARCHAR 200 0 1

mailservname 9 0 -1

VARCHAR 200 0 1

smtpservname 10 0 -1

VARCHAR 200 0 1

tmpurl 11 0 -1

VARCHAR 250 0 1

IDX_server_1 IDX_%table%_%counter% 2 0 0 0 4 account_server 4 0 engine=innodb 4 3 1 1 PK_account_server PK_%table% 1 0 2 3 3 4 accountid 3 0 -1

INTEGER 0 1

1 0 1 1 5 3 serverid 4 0 -1

INTEGER 0 1

1 0 1 1 5 4 IDX_account_server_1 IDX_%table%_%counter% 2 0 5 2 3 IDX_account_server_2 IDX_%table%_%counter% 3 0 6 2 4 support_ticket 7 0 engine=innodb 11 3 1 1 PK_support_ticket PK_%table% 1 0 2 3 2 ticketid 2 0 -1

INTEGER 0 1 1

NN_%column% 1 0 1 1 5 2 accountid 10 0 -1

INTEGER 0 1

1 0 1 1 5 10 parentticketid 11 0 -1

INTEGER 0 1

1 0 1 1 5 11 topic 5 0 -1

VARCHAR 255 0 1

content 6 0 -1

LONGTEXT 0 1

createdatetime 7 0 -1

DATETIME 0 1

ticketstatus 8 0 -1

VARCHAR 20 0 1

DEF_%table%_%column% 2 0 open 1 6 8 IDX_support_ticket_1 IDX_%table%_%counter% 2 0 9 2 10 IDX_support_ticket_2 IDX_%table%_%counter% 3 0 10 2 11 account_account_server %parent%_%child% 5 0 2 4 0 0 1 2 2 account_account_server %relname% 1 0 2 4 3 0 0 2 3 server_account_server %parent%_%child% 6 0 3 4 0 0 1 2 2 server_account_server %relname% 1 0 2 4 4 0 0 2 4 account_support_ticket %parent%_%child% 9 0 2 7 0 1 1 2 2 account_support_ticket %relname% 1 0 2 4 10 0 0 2 10 support_ticket_support_ticket %parent%_%child% 10 0 7 7 0 1 1 2 2 support_ticket_support_ticket %relname% 1 0 2 4 11 0 0 2 11 0 2 PK FK PF * 0 16777215 16777215 16777215 8421504 0 0 0 0 0 0 0 0 1 1 0 0 0 0 Arial,9,B,0,clNavy,0 Arial,8,B,0,clWindowText,0 Arial,8,I,0,clWindowText,0 Arial,8,,0,clWindowText,0 Arial,8,,0,clWindowText,0 Arial,8,,0,clWindowText,0 Arial,8,,0,clWindowText,0 Arial,8,,0,clWindowText,0 1 Main Diagram 1 8421376 0 0 0 1 1 0 0 2 1 101 169 145 62 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 3 1 101 203 499 198 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 4 1 98 67 328 217 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 7 1 101 152 100 377 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 5 1 Arial,8,,0,clWindowText,0 0,1,4,0 5000 5000 5000 5000 246 146 316 146 316 251 327 251 6 1 Arial,8,,0,clWindowText,0 0,1,4,0 5000 5000 5000 5000 498 300 469 300 469 251 426 251 9 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 195 231 195 304 150 304 150 376 10 1 Arial,8,,0,clWindowText,0 1,1,4,0 7228 5000 5000 5000 173 376 173 337 241 337 241 453 201 453