Database Model plugin_tmp.xml

ACTORS
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
ActorID INTEGER PK NN UNSIGNED     AI
Name VARCHAR(50)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY ActorID


COLLECT
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
CollectID INTEGER PK NN UNSIGNED     AI
Bezeichnung VARCHAR(50)   NN        
istStandard INTEGER(1)   NN UNSIGNED 0    
brauchtPrivileg INTEGER(2)   NN UNSIGNED 1    
IndexName IndexType Columns
PRIMARY PRIMARY CollectID


COVERS
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
FILME_FilmID INTEGER PK NN UNSIGNED      
Rang SMALLINT PK NN UNSIGNED 1    
Appendix VARCHAR(10)            
Extension VARCHAR(6)            
hatThumbnail INTEGER(1)     UNSIGNED 0    
IndexName IndexType Columns
PRIMARY PRIMARY FILME_FilmID
Rang
COVERS_FKIndex1 Index FILME_FilmID


DISCS
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
DiscID INTEGER PK NN UNSIGNED      
FILME_FilmID INTEGER PK NN UNSIGNED      
USERS_UserID INTEGER   NN UNSIGNED 0    
ausgeliehenAm DATE   NN   0000-00-00    
IndexName IndexType Columns
PRIMARY PRIMARY DiscID
FILME_FilmID
DISCS_FKIndex1 Index FILME_FilmID
DISCS_FKIndex2 Index USERS_UserID


FILME
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
FilmID INTEGER PK NN UNSIGNED     AI
COLLECT_CollectID INTEGER     UNSIGNED      
myFilmID INTEGER     UNSIGNED      
Titel VARCHAR(255)   NN        
Originaltitel VARCHAR(255)            
Jahr INT(4)   NN   0    
Land VARCHAR(255)            
Laufzeit INTEGER(4)   NN UNSIGNED 0    
FSK INTEGER(2)   NN UNSIGNED 0    
FSKunbekannt INTEGER(1)   NN UNSIGNED 0    
Inhalt TEXT            
Bemerkung TEXT            
inserted DATETIME   NN   0000-00-00 00:00:00    
istTopfilm INTEGER(1)   NN UNSIGNED 0    
Webseite VARCHAR(255)            
brauchtPrivileg INTEGER(2)   NN UNSIGNED 1    
USERS_UserID INTEGER   NN UNSIGNED 0    
FORMATE_FormatID INTEGER   NN UNSIGNED 0    
IndexName IndexType Columns
PRIMARY PRIMARY FilmID
FILME_FKIndex1 Index USERS_UserID
FILME_FKIndex2 Index FORMATE_FormatID
FILME_FKIndex3 Index COLLECT_CollectID


FILME_ACTORS
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
FILME_FilmID INTEGER PK NN UNSIGNED      
ACTORS_ActorID INTEGER PK NN UNSIGNED      
Rang SMALLINT   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY FILME_FilmID
ACTORS_ActorID
FILME_ACTORS_FKIndex1 Index FILME_FilmID
FILME_ACTORS_FKIndex2 Index ACTORS_ActorID


FILME_GENRES
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
FILME_FilmID INTEGER PK NN UNSIGNED      
GENRES_GenreID INTEGER PK NN UNSIGNED      
Rang SMALLINT     UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY FILME_FilmID
GENRES_GenreID
FILME_GENRES_FKIndex1 Index FILME_FilmID
FILME_GENRES_FKIndex2 Index GENRES_GenreID


FILME_REGISSEURE
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
FILME_FilmID INTEGER PK NN UNSIGNED      
REGISSEURE_RegisseurID INTEGER PK NN UNSIGNED      
Rang SMALLINT   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY FILME_FilmID
REGISSEURE_RegisseurID
FILME_REGISSEURE_FKIndex1 Index FILME_FilmID
FILME_REGISSEURE_FKIndex2 Index REGISSEURE_RegisseurID


FILME_USERS
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
FILME_FilmID INTEGER PK NN UNSIGNED      
USERS_UserID INTEGER PK NN UNSIGNED      
Kommentar VARCHAR(255)            
zeigeNamen INTEGER(1)   NN UNSIGNED 1    
istNeu INTEGER(1)   NN UNSIGNED 0    
Zeitpunkt DATETIME   NN   0000-00-00 00:00:00    
Bewertung INTEGER(2)   NN UNSIGNED 0    
IndexName IndexType Columns
PRIMARY PRIMARY FILME_FilmID
USERS_UserID
FILME_USERS_FKIndex1 Index FILME_FilmID
FILME_USERS_FKIndex2 Index USERS_UserID


FORMATE
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
FormatID INTEGER PK NN UNSIGNED     AI
Bezeichnung VARCHAR(50)   NN        
istStandard INTEGER(1)   NN UNSIGNED 0    
brauchtPrivileg INTEGER(2)   NN UNSIGNED 1    
IndexName IndexType Columns
PRIMARY PRIMARY FormatID


GENRES
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
GenreID INTEGER PK NN UNSIGNED     AI
Name VARCHAR(50)   NN        
brauchtPrivileg INTEGER(2)   NN UNSIGNED 1    
IndexName IndexType Columns
PRIMARY PRIMARY GenreID


REGISSEURE
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
RegisseurID INTEGER PK NN UNSIGNED     AI
Name VARCHAR(50)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY RegisseurID


SETTINGS
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
Variable VARCHAR(100) PK NN        
Wert VARCHAR(255)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY Variable


USERS
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
UserID INTEGER PK NN UNSIGNED     AI
UserName VARCHAR(50)   NN        
UserRechte INTEGER(3)   NN UNSIGNED 300    
Email VARCHAR(50)   NN        
PWD VARCHAR(50)   NN        
anzLogin INTEGER   NN UNSIGNED 0    
anzFehlLogin INTEGER   NN UNSIGNED 0    
lastLogin DATETIME   NN   0000-00-00 00:00:00    
Birthday DATE   NN   0000-00-00    
FilmPrivileg INTEGER(2)   NN UNSIGNED 1    
FormatPrivileg INTEGER(2)   NN UNSIGNED 1    
GenrePrivileg INTEGER(2)   NN UNSIGNED 1    
CollectPrivileg INTEGER(2)   NN UNSIGNED 1    
getEmail INTEGER(1)   NN UNSIGNED 0    
checkChangePWD VARCHAR(40)            
Style VARCHAR(50)            
hasAccess INTEGER(1)   NN UNSIGNED 1    
showAnzFilme INTEGER   NN UNSIGNED 40    
showSmallCovers INTEGER(2)   NN UNSIGNED 1    
IndexName IndexType Columns
PRIMARY PRIMARY UserID