1620 lines
35 KiB
Plaintext
1620 lines
35 KiB
Plaintext
project "Portal de Musica"
|
|
description = "Tablas usadas por el portal infdj.com"
|
|
dbtype = "1"
|
|
copyrights = "1999 - 2002 JDsoft"
|
|
author = "José David Guillén"
|
|
builddate = ""
|
|
scripttype = "1"
|
|
remarks = ""
|
|
table "news"
|
|
description = "Almacena las noticias posteadas"
|
|
remarks = ""
|
|
left = "20"
|
|
top = "10"
|
|
width = "97"
|
|
height = "105"
|
|
column "id"
|
|
description = "id de la noticia posteada"
|
|
coltype = "counter"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "fecha"
|
|
description = "Fecha de la noticia"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "uid"
|
|
description = "usuario que postea la noticia"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "asunto"
|
|
description = "cabecera para la noticia"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "noticia"
|
|
description = "cuerpo de la noticia"
|
|
coltype = "text"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index "PrimaryKey"
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "users"
|
|
description = "Informacion sobre los usuarios"
|
|
remarks = ""
|
|
left = "157"
|
|
top = "36"
|
|
width = "97"
|
|
height = "179"
|
|
column "id"
|
|
description = "Identificador del usuario"
|
|
coltype = "counter"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "idg"
|
|
description = "Grupo al que pertenece"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = "Indica el \'id\' del grupo que puede controlar, para añadir/eliminar/modificar eventos."
|
|
end
|
|
column "nick"
|
|
description = "Nick del usuario"
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "level"
|
|
description = "nivel de acceso concedido"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = "0"
|
|
remarks = ""
|
|
end
|
|
column "ultimaEntrada"
|
|
description = "Última vez que se valido"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "primeraEntrada"
|
|
description = "Fecha de alta en el sistema"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "pass"
|
|
description = "pasword del usuario"
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Nombre"
|
|
description = "nombre real del usuario"
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Apellidos"
|
|
description = "apellidos del usuario"
|
|
coltype = "varchar"
|
|
size = "25"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "fechaNacimiento"
|
|
description = "Fecha de nacimento"
|
|
coltype = "datetime"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "calle"
|
|
description = "dirección del usr"
|
|
coltype = "varchar"
|
|
size = "30"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "ciudad"
|
|
description = "ciudad"
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "provincia"
|
|
description = "provincia"
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "nacionalidad"
|
|
description = "nacionalidad"
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "cp"
|
|
description = "Código Postal"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "telefono"
|
|
description = "teléfono"
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "mobil"
|
|
description = "mobil"
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "email"
|
|
description = "eMail externo a nuestra empresa"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "usaCorreo"
|
|
description = "Indica si usa nuestro servidor de correo"
|
|
coltype = "bool"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = "\'N\'"
|
|
remarks = ""
|
|
end
|
|
column "preguntaSecreta"
|
|
description = "Pregunta secreta (para verificar su identidad)"
|
|
coltype = "varchar"
|
|
size = "25"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "respuestaPregunta"
|
|
description = "Respuesta a la pregunta secreta"
|
|
coltype = "varchar"
|
|
size = "25"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index "PrimaryKey"
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "miniChat"
|
|
description = "miniChat para dejar miniMensajes"
|
|
remarks = ""
|
|
left = "317"
|
|
top = "-3"
|
|
width = "97"
|
|
height = "105"
|
|
column "id"
|
|
description = "id del mensaje"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "fecha"
|
|
description = "Fecha del mensaje"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "hora"
|
|
description = "Hora del mensaje"
|
|
coltype = "time"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "uid"
|
|
description = "Usuario que deja el mensaje"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = "0"
|
|
remarks = ""
|
|
end
|
|
column "msg"
|
|
description = "mensaje"
|
|
coltype = "varchar"
|
|
size = "80"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "encuestas"
|
|
description = ""
|
|
remarks = ""
|
|
left = "20"
|
|
top = "119"
|
|
width = "97"
|
|
height = "152"
|
|
column "id"
|
|
description = "ID encuesta"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "fecha"
|
|
description = "Fecha de la encuesta"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "validaHasta"
|
|
description = "Validez de la encuesta"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "pregunta"
|
|
description = "Pregunta"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "resp1"
|
|
description = "Respuesta 1"
|
|
coltype = "varchar"
|
|
size = "35"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "vresp1"
|
|
description = "Votos a la respuesta 1"
|
|
coltype = "smallint"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = "0"
|
|
remarks = ""
|
|
end
|
|
column "resp2"
|
|
description = "Respuesta 2"
|
|
coltype = "varchar"
|
|
size = "35"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "vresp2"
|
|
description = "Votos a la respuesta 2"
|
|
coltype = "smallint"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = "0"
|
|
remarks = ""
|
|
end
|
|
column "resp3"
|
|
description = "Respuesta 3"
|
|
coltype = "varchar"
|
|
size = "35"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "vresp3"
|
|
description = "Votos a la respuesta 3"
|
|
coltype = "smallint"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = "0"
|
|
remarks = ""
|
|
end
|
|
column "resp4"
|
|
description = "Respuesta 4"
|
|
coltype = "varchar"
|
|
size = "35"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "vresp4"
|
|
description = "Votos a la respuesta 4"
|
|
coltype = "smallint"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = "0"
|
|
remarks = ""
|
|
end
|
|
column "uip"
|
|
description = "Última dirección IP que voto."
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index "primario"
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "useronline"
|
|
description = ""
|
|
remarks = ""
|
|
left = "316"
|
|
top = "149"
|
|
width = "97"
|
|
height = "105"
|
|
column "hora"
|
|
description = "Hora de la última transacción"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "ip"
|
|
description = "Dirección IP"
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "uid"
|
|
description = "Usuario registrado?"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = "Cuando uid < 0 ( Significa invitado )"
|
|
end
|
|
index "hora"
|
|
description = ""
|
|
columns = "hora"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
index "ip"
|
|
description = ""
|
|
columns = "ip"
|
|
indextype = "0"
|
|
remarks = ""
|
|
end
|
|
index "uid"
|
|
description = ""
|
|
columns = "uid"
|
|
indextype = "0"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "artistas"
|
|
description = "Datos personales de un artista concreto\r\n"
|
|
remarks = ""
|
|
left = "28"
|
|
top = "308"
|
|
width = "97"
|
|
height = "111"
|
|
column "id"
|
|
description = "Id del Artista"
|
|
coltype = "counter"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "FAlta"
|
|
description = "FAlta"
|
|
coltype = "datetime"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Nombre"
|
|
description = "Nombre del artista"
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Apellido"
|
|
description = "Apellido del artista"
|
|
coltype = "varchar"
|
|
size = "40"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Instrumento"
|
|
description = "Instrumento o función dentro del grupo"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Foto_mime"
|
|
description = "Tipo mime (Indica si posee foto)"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = "La foto se guardará mediante PHP en un directorio concreto ( ~user/DB/artistas/[ID_ARTISTA] )\r\n"
|
|
end
|
|
column "Foto_W"
|
|
description = "Dimensiones de la imagen"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Foto_H"
|
|
description = "Dimensiones de la imagen"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Telefono1"
|
|
description = "Numero de Telefono"
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Telefono2"
|
|
description = "Numero del Movil"
|
|
coltype = "varchar"
|
|
size = "15"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "NIF"
|
|
description = "NIF"
|
|
coltype = "varchar"
|
|
size = "20"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Calle"
|
|
description = "Dirección"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Localidad"
|
|
description = "Localidad"
|
|
coltype = "varchar"
|
|
size = "20"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Provincia"
|
|
description = "Provincia"
|
|
coltype = "varchar"
|
|
size = "20"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "CP"
|
|
description = "CP"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "url"
|
|
description = "url del artista"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "e_Mail"
|
|
description = "Correo-e del artista"
|
|
coltype = "varchar"
|
|
size = "30"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "FechaNacimiento"
|
|
description = "FechaNacimiento"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "comentario"
|
|
description = "Comentario o curriculum del artista"
|
|
coltype = "text"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index "id"
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
index "FAlta"
|
|
description = ""
|
|
columns = "FAlta"
|
|
indextype = "0"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "grupos"
|
|
description = "Contiene información de los grupos..."
|
|
remarks = "Cada grupo tiene tambien asociada una lista de personas (componentes), esta asociación se puede ver en la tabla \'componentesGrupo\'\r\n"
|
|
left = "314"
|
|
top = "295"
|
|
width = "97"
|
|
height = "192"
|
|
column "id"
|
|
description = "ID del Grupo"
|
|
coltype = "counter"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "ide"
|
|
description = "id - Estilo general del grupo"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "FAlta"
|
|
description = "Fecha de Alta del Grupo"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "nombre"
|
|
description = "Nombre del grupo"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "comentario"
|
|
description = "Comentario del Grupo"
|
|
coltype = "text"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "cache"
|
|
description = "Cache del grupo (cuanto cobran por actuacion y cosas asi)"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "equipoSonidoLuces"
|
|
description = "Indicación si disponen de equipo se sonido y luces"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "estadisticas"
|
|
description = "NPI"
|
|
coltype = "tinytext"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "croquiMusicos"
|
|
description = "Croquis de situacion del grupo dentro del escenario (baterias, altavoces, cantantes)"
|
|
coltype = "varchar"
|
|
size = "100"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "sugerenciasGrupo"
|
|
description = "Sugerencias del grupo"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "contratacion"
|
|
description = "Datos para su contratación"
|
|
coltype = "tinytext"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "imagen"
|
|
description = "Nombre original del archivo que contenia la fotografia..."
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index "PrimaryKey"
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "componentesGrupo"
|
|
description = "Indica los componentes de un grupo"
|
|
remarks = ""
|
|
left = "167"
|
|
top = "295"
|
|
width = "97"
|
|
height = "107"
|
|
column "idg"
|
|
description = "ID del grupo"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "idp"
|
|
description = "ID del artista"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index "idg"
|
|
description = ""
|
|
columns = "idg"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
index "idp"
|
|
description = ""
|
|
columns = "idp"
|
|
indextype = "0"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "estilos"
|
|
description = "Estilos musicales\r\n"
|
|
remarks = ""
|
|
left = "588"
|
|
top = "307"
|
|
width = "97"
|
|
height = "125"
|
|
column "id"
|
|
description = "Id del Artista"
|
|
coltype = "counter"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "parent"
|
|
description = "Padre de este estilo"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = "0"
|
|
remarks = "Los estilos se organizan en una especie de arbol"
|
|
end
|
|
column "titulo"
|
|
description = "Titulo del estilo"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "descr"
|
|
description = "Descripción del estilo"
|
|
coltype = "tinytext"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Foto_mime"
|
|
description = "Tipo mime del grafico asociado"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Foto_w"
|
|
description = "Foto_w"
|
|
coltype = "smallint"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Foto_h"
|
|
description = "Foto_h"
|
|
coltype = "smallint"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index ""
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
index "parent"
|
|
description = ""
|
|
columns = "parent"
|
|
indextype = "0"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "discos"
|
|
description = "Discos de los distintos grupos\r\n"
|
|
remarks = ""
|
|
left = "444"
|
|
top = "176"
|
|
width = "97"
|
|
height = "147"
|
|
column "id"
|
|
description = "id del disco"
|
|
coltype = "counter"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "idg"
|
|
description = "id del Grupo"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "ide"
|
|
description = "id del Estilo de este disco"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "FAlta"
|
|
description = "Fecha de alta de este registro"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "FEdicion"
|
|
description = "Fecha de Edicion del disco"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "ids"
|
|
description = "id Status"
|
|
coltype = "smallint"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = "3"
|
|
remarks = "Los estados pueden ser:\r\n Maqueta sin editar -> 0\r\n Maqueta editada -> 1\r\n Disco no editado -> 2\r\n Disco editado -> 3"
|
|
end
|
|
column "titulo"
|
|
description = "Titulo del disco"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "pv"
|
|
description = "Precio de venta del disco"
|
|
coltype = "numeric"
|
|
size = "6"
|
|
decimals = "2"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "comentario"
|
|
description = "Notas adicionales"
|
|
coltype = "text"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index "PrimaryKey"
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "extrasDiscos"
|
|
description = "Datos extras para los discos"
|
|
remarks = ""
|
|
left = "594"
|
|
top = "163"
|
|
width = "97"
|
|
height = "122"
|
|
column "id"
|
|
description = "id de este extra"
|
|
coltype = "counter"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "idd"
|
|
description = "id del disco "
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "tipo"
|
|
description = "tipo del extra"
|
|
coltype = "char"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = "\'O\'"
|
|
remarks = "Los tipos pueden ser:\r\n\r\n-> Foto \'F\'\r\n-> Audio \'A\'\r\n-> Video \'V\'\r\n-> Texto \'T\'\r\n"
|
|
end
|
|
column "id_data"
|
|
description = "id dentro del disco"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "file"
|
|
description = "Nombre original del fichero"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "W"
|
|
description = "Width en caso de tipo Foto"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "H"
|
|
description = "Heigth en caso de tipo Foto"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index "PrimaryKey"
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "cancionesDisco"
|
|
description = "contiene la información de cada una de las canciones de un disco determinado"
|
|
remarks = ""
|
|
left = "575"
|
|
top = "4"
|
|
width = "97"
|
|
height = "136"
|
|
column "id"
|
|
description = "id de la cancion"
|
|
coltype = "counter"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "idd"
|
|
description = "id del disco"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "posicion"
|
|
description = "posicion de la cancion dentro del disco"
|
|
coltype = "smallint"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "duracion"
|
|
description = "duracion de la cancion"
|
|
coltype = "time"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = "Esta duracion se expresa en formato de tiempo HH:MM:SS"
|
|
end
|
|
column "titulo"
|
|
description = "titulo de la cancion"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "autorLetra"
|
|
description = "autor de la letra de la cancion"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "autorMusica"
|
|
description = "autor de la musica de la cancion"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "f_partitura"
|
|
description = "nombre del fichero que contiene la partitura"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "f_audio"
|
|
description = "nombre del fichero que contiene el audio"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "f_letra"
|
|
description = "nombre del fichero que contiene la letra"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "f_midi"
|
|
description = "nombre del fichero que contiene el midi"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index "PrimaryKey"
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "0"
|
|
remarks = ""
|
|
end
|
|
index "posiciones"
|
|
description = "canciones ordenadas de un disco"
|
|
columns = "id;posicion"
|
|
indextype = "0"
|
|
remarks = ""
|
|
end
|
|
index "PrimaryKey"
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "eventos"
|
|
description = "Describe los eventos de los distintos grupos."
|
|
remarks = "Con esta tabla de eventos, podremos construir un calendario en el cual se observen los dias que hay actuaciones.\r\nCada usuario dispone de la posibilidad (si asi lo indica el administrador), de gestionar los eventos de un (UNICO) grupo.\r\n\r\nAdicionalmente el administrador podrá fijar eventos de cualquier grupo (indicando el grupo mediante su ID)."
|
|
left = "167"
|
|
top = "429"
|
|
width = "97"
|
|
height = "136"
|
|
column "id"
|
|
description = "id del evento"
|
|
coltype = "counter"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "idg"
|
|
description = "Grupo al que pertenece este evento"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "FAlta"
|
|
description = "Fecha de insercion de la noticia en el sistema"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "FEvento"
|
|
description = "Fecha del Evento"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "HEvento"
|
|
description = "Hora del Evento"
|
|
coltype = "time"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Lugar"
|
|
description = "Lugar del Evento"
|
|
coltype = "varchar"
|
|
size = "30"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Titulo"
|
|
description = "Titulo del Evento"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "Notas"
|
|
description = "Informacion ampliada sobre el evento"
|
|
coltype = "text"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index "PrimaryKey"
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
index "EventosGrp"
|
|
description = ""
|
|
columns = "idg;FEvento"
|
|
indextype = "0"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "TiposDiscos"
|
|
description = "Define las distintas clases de discos que existen"
|
|
remarks = ""
|
|
left = "576"
|
|
top = "438"
|
|
width = "97"
|
|
height = "105"
|
|
column "id"
|
|
description = "Id para este tipo de disco"
|
|
coltype = "counter"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "pvp"
|
|
description = "Precio venta público de este tipo"
|
|
coltype = "numeric"
|
|
size = "8"
|
|
decimals = "2"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "descrCorta"
|
|
description = "Breve descripcion del tipo"
|
|
coltype = "varchar"
|
|
size = "20"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "descrLarga"
|
|
description = "Descripcion larga del tipo"
|
|
coltype = "text"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index "PrimaryKey"
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
end
|
|
table "publicidad"
|
|
description = "Gestiona el control de Banners"
|
|
remarks = ""
|
|
left = "431"
|
|
top = "510"
|
|
width = "97"
|
|
height = "105"
|
|
column "id"
|
|
description = "id del banners"
|
|
coltype = "counter"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "FAlta"
|
|
description = "Fecha de Alta"
|
|
coltype = "date"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "anunciante"
|
|
description = "Nombre del Anunciante"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "descr"
|
|
description = "Descripcion del anuncio"
|
|
coltype = "varchar"
|
|
size = "50"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "url"
|
|
description = "Url del banner"
|
|
coltype = "varchar"
|
|
size = "90"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "tipo"
|
|
description = "Tipo del banner"
|
|
coltype = "char"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = "\'H\'"
|
|
remarks = ""
|
|
end
|
|
column "nVistos"
|
|
description = "número de veces que se ha mostrado el banner"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = "0"
|
|
remarks = ""
|
|
end
|
|
column "nVisitas"
|
|
description = "número de clicks sobre este banner"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = "0"
|
|
remarks = ""
|
|
end
|
|
column "filename"
|
|
description = "nombre del archivo conteniendo el banner"
|
|
coltype = "varchar"
|
|
size = "30"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
index "PrimaryKey"
|
|
description = ""
|
|
columns = "id"
|
|
indextype = "2"
|
|
remarks = ""
|
|
end
|
|
end
|
|
link "eventos_grupo"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "grupos"
|
|
leftcolumns = "id"
|
|
righttable = "eventos"
|
|
rightcolumns = "idg"
|
|
end
|
|
link "artistas_componentesGrupo"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "artistas"
|
|
leftcolumns = "id"
|
|
righttable = "componentesGrupo"
|
|
rightcolumns = "idp"
|
|
end
|
|
link "grupo_deComponentesGrupo"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "grupos"
|
|
leftcolumns = "id"
|
|
righttable = "componentesGrupo"
|
|
rightcolumns = "idg"
|
|
end
|
|
link "news_users"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "news"
|
|
leftcolumns = "uid"
|
|
righttable = "users"
|
|
rightcolumns = "id"
|
|
end
|
|
link "users_miniChat"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "users"
|
|
leftcolumns = "id"
|
|
righttable = "miniChat"
|
|
rightcolumns = "uid"
|
|
end
|
|
link "users_useronline"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "users"
|
|
leftcolumns = "id"
|
|
righttable = "useronline"
|
|
rightcolumns = "uid"
|
|
end
|
|
link "estilos_grupo"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "estilos"
|
|
leftcolumns = "id"
|
|
righttable = "grupos"
|
|
rightcolumns = "ide"
|
|
end
|
|
link "discos_grupo"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "grupos"
|
|
leftcolumns = "id"
|
|
righttable = "discos"
|
|
rightcolumns = "idg"
|
|
end
|
|
link "estilo_disco"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "estilos"
|
|
leftcolumns = "id"
|
|
righttable = "discos"
|
|
rightcolumns = "ide"
|
|
end
|
|
link "extras_de_un_disco"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "extrasDiscos"
|
|
leftcolumns = "idd"
|
|
righttable = "discos"
|
|
rightcolumns = "id"
|
|
end
|
|
link "canciones_del_disco"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "discos"
|
|
leftcolumns = "id"
|
|
righttable = "cancionesDisco"
|
|
rightcolumns = "idd"
|
|
end
|
|
link "usuario_controla_grupo"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "users"
|
|
leftcolumns = "idg"
|
|
righttable = "grupos"
|
|
rightcolumns = "id"
|
|
end
|
|
link "tipo_del_disco"
|
|
description = ""
|
|
linktype = "0"
|
|
cascadeupdates = "F"
|
|
cascadedeletes = "F"
|
|
remarks = ""
|
|
lefttable = "discos"
|
|
leftcolumns = "pv"
|
|
righttable = "TiposDiscos"
|
|
rightcolumns = "id"
|
|
end
|
|
end
|