Advertisement
Guest User

create_Table

a guest
Aug 20th, 2013
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.60 KB | None | 0 0
  1. CREATE TABLE `capture_captive` (
  2.   `id` int(10) unsigned NOT NULL,
  3.   `nickname` tinytext NOT NULL,
  4.   `item_id` int(10) unsigned NOT NULL,
  5.   `number_captured` int(10) unsigned NOT NULL,
  6.   `number_successed` int(10) unsigned NOT NULL,
  7.   `number_failed` int(10) unsigned NOT NULL,
  8.   `capture_id_1` int(10) unsigned NOT NULL,
  9.   `capture_id_2` int(10) unsigned NOT NULL,
  10.   `capture_id_3` int(10) unsigned NOT NULL,
  11.   `capture_id_4` int(10) unsigned NOT NULL,
  12.   `capture_id_5` int(10) unsigned NOT NULL,
  13.   `timestamp` int(10) unsigned NOT NULL,
  14.   PRIMARY KEY (`id`)
  15. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement