JJHYYd1a

1drop database IF EXISTS sms;
2create database sms character set utf8;
3use sms;
4create table imenik(
5id int not null primary key auto_increment,
6	ime     nvarchar(50) not null,
7	prezime     nvarchar(50) not null,
8	broj     nvarchar(50) not null
9) engine=innodb;
10
11create table logovi(
12id    int not null primary key auto_increment,
13	poslato    nvarchar(50) not null
14) engine=innodb;
15
16
17
18
19alter database collate = utf8_general_ci;
20
21#1
22insert into imenik (ime, prezime, broj) values ('Zika','Zoster','05454218124');
23
24
25insert into logovi (poslato) values ('0712980300501');