/* First, create our posts table: */
CREATE TABLE alertas (
    id int(11) NOT NULL auto_increment PRIMARY KEY,
    user_id VARCHAR(50),
    empresa VARCHAR(50),
    simbolo VARCHAR(50),
    indicador VARCHAR(3),
    valor VARCHAR(25),
    created DATETIME DEFAULT NULL,
    modified DATETIME DEFAULT NULL
);

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL UNIQUE,
  `password` varchar(32) NOT NULL,
  `email` varchar(255) NOT NULL,
  `msisdn` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`)
)

CREATE TABLE `stocks` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL UNIQUE,
  `symbol` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`)
)

/* Then insert some posts for testing: */
INSERT INTO alertas (userid,titulo,simbolo, indicador, valor)
    VALUES ('tru3n0', 'Esta es una alerta de prueba','MAP.MC','eq','9', NOW());