create table pelicula(
id_pelicula int(10),
titulo text,
fecha int(4),
sinopsis text,
origen text,
idioma text,
color text,
duracion text,
foto text,
misc text
)
type=innodb;

mysql> describe pelicula;
+-------------+---------+------+-----+---------+-------+
| Field       | Type    | Null | Key | Default | Extra |
+-------------+---------+------+-----+---------+-------+
| id_pelicula | int(10) | NO   | PRI | 0       |       |
| titulo      | text    | YES  |     | NULL    |       |
| fecha       | int(4)  | YES  |     | NULL    |       |
| sinopsis    | text    | YES  |     | NULL    |       |
| origen      | text    | YES  |     | NULL    |       |
| idioma      | text    | YES  |     | NULL    |       |
| color       | text    | YES  |     | NULL    |       |
| duracion    | text    | YES  |     | NULL    |       |
| foto        | text    | YES  |     | NULL    |       |
| misc        | text    | YES  |     | NULL    |       |
+-------------+---------+------+-----+---------+-------+
10 rows in set (0.00 sec)

mysql> select id_pelicula from pelicula;
+-------------+
| id_pelicula |
+-------------+
|           0 |
|           1 |
|   418281537 |
|  1025493379 |
|  1248064203 |
|  1483774584 |
|  1613500206 |
|  2147483647 |
+-------------+
8 rows in set (0.00 sec)

mysql> insert into pelicula(id_pelicula) values(8141382586);
ERROR 1062 (23000): Duplicate entry '2147483647' for key 1