527 lines
11 KiB
Plaintext
527 lines
11 KiB
Plaintext
project "infdj.com"
|
|
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 = "10"
|
|
width = "97"
|
|
height = "105"
|
|
column "id"
|
|
description = "Identificador del usuario"
|
|
coltype = "counter"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "T"
|
|
default = ""
|
|
remarks = ""
|
|
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 = "157"
|
|
top = "135"
|
|
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 = "135"
|
|
width = "97"
|
|
height = "105"
|
|
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 = "294"
|
|
top = "10"
|
|
width = "97"
|
|
height = "109"
|
|
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
|
|
column "visitas"
|
|
description = "Números de paginas visitas"
|
|
coltype = "integer"
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = "0"
|
|
remarks = ""
|
|
end
|
|
column "dias"
|
|
description = "Número de dias distintos que nos ha visitado"
|
|
coltype = ""
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
end
|
|
column "UltimasVistas"
|
|
description = "Número de páginas vistas en el último día"
|
|
coltype = ""
|
|
size = "0"
|
|
decimals = "0"
|
|
notnull = "F"
|
|
default = ""
|
|
remarks = ""
|
|
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
|
|
end
|