cls - estrutura das tabelas

--
-- Banco de Dados: `clsv1a0`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `username` varchar(30) NOT NULL,
  `password` varchar(40) NOT NULL,
  `email` varchar(120) NOT NULL,
  `nickname` varchar(25) NOT NULL,
  `active` int(1) NOT NULL DEFAULT '0',
  `date` varchar(25) NOT NULL,
  `products` int(11) NOT NULL DEFAULT '0',
  `adsid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Estrutura da tabela `passwords`
--

CREATE TABLE IF NOT EXISTS `passwords` (
  `password` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `ads` (
  `adsid` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `owner` varchar(35) NOT NULL,
  `type` varchar(30) NOT NULL,
  `price` int(11) NOT NULL,
  `image` text NOT NULL,
  `status` varchar(50) NOT NULL,
  `active` int(11) NOT NULL DEFAULT '0',
  `obs` text NOT NULL,
  `ints` int(11) NOT NULL DEFAULT '0',
  `intsnames` text NOT NULL,
  PRIMARY KEY (`adsid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;