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