· 6 years ago · May 25, 2019, 05:32 PM
1-- Table structure for table `tb_contatos`
2
3DROP TABLE IF EXISTS `tb_contato`;
4CREATE TABLE `tb_contato` (
5 `nome` varchar(100) collate latin1_general_ci NOT NULL default '',
6 `email` varchar(255) collate latin1_general_ci NOT NULL default '',
7 `fone` varchar(30) collate latin1_general_ci NOT NULL default '',
8 `foto` varchar(60) collate latin1_general_ci NOT NULL default '',
9 `id_contato` int(11) NOT NULL auto_increment,
10 `idade` int(5) NOT NULL default '-1',
11 PRIMARY KEY (`id_contato`)
12) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
13
14CREATE TABLE `tb_admin` (
15 `login` varchar(100) collate latin1_general_ci NOT NULL default '',
16 `id_admin` int(11) NOT NULL auto_increment,
17 `password` varchar(33) collate latin1_general_ci NOT NULL default '',
18 PRIMARY KEY (`id_admin`)
19) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;