Advertisement
Guest User

Untitled

a guest
Jan 4th, 2014
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.08 KB | None | 0 0
  1. TABLE IF NOT EXISTS `tajemniczy_users` (
  2.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  3.   `username` VARCHAR(100) COLLATE utf8_polish_ci NOT NULL,
  4.   `password` VARCHAR(32) COLLATE utf8_polish_ci NOT NULL,
  5.   `uid` VARCHAR(32) COLLATE utf8_polish_ci NOT NULL,
  6.   `imie` VARCHAR(100) COLLATE utf8_polish_ci NOT NULL,
  7.   `nazwisko` VARCHAR(100) COLLATE utf8_polish_ci NOT NULL,
  8.   `email` VARCHAR(255) COLLATE utf8_polish_ci NOT NULL,
  9.   `pesel` VARCHAR(11) COLLATE utf8_polish_ci NOT NULL,
  10.   `ulica` VARCHAR(255) COLLATE utf8_polish_ci NOT NULL,
  11.   `kodpocztowy` VARCHAR(6) COLLATE utf8_polish_ci NOT NULL,
  12.   `miejscowosc` VARCHAR(255) COLLATE utf8_polish_ci NOT NULL,
  13.   `wojewodztwo` VARCHAR(100) COLLATE utf8_polish_ci NOT NULL,
  14.   `telefon1` VARCHAR(20) COLLATE utf8_polish_ci NOT NULL,
  15.   `telefon2` VARCHAR(20) COLLATE utf8_polish_ci NOT NULL,
  16.   `gg` VARCHAR(30) COLLATE utf8_polish_ci NOT NULL,
  17.   `skype` VARCHAR(100) COLLATE utf8_polish_ci NOT NULL,
  18.   `wyksztalcenie` VARCHAR(100) COLLATE utf8_polish_ci NOT NULL,
  19.   `zatrudnienie` VARCHAR(100) COLLATE utf8_polish_ci NOT NULL,
  20.   `plec` VARCHAR(20) COLLATE utf8_polish_ci NOT NULL,
  21.   `stancywilny` VARCHAR(50) COLLATE utf8_polish_ci NOT NULL,
  22.   `dzieci` INT(1) NOT NULL,
  23.   `internet` INT(1) NOT NULL,
  24.   `dostep` VARCHAR(20) COLLATE utf8_polish_ci NOT NULL,
  25.   `fax` INT(1) NOT NULL,
  26.   `skaner` INT(1) NOT NULL,
  27.   `aparat` INT(1) NOT NULL,
  28.   `dyktafon` INT(1) NOT NULL,
  29.   `miasta` text COLLATE utf8_polish_ci NOT NULL,
  30.   `banki` text COLLATE utf8_polish_ci NOT NULL,
  31.   `d12_16` INT(1) NOT NULL,
  32.   `d16_20` INT(1) NOT NULL,
  33.   `d8_12` INT(1) NOT NULL,
  34.   `brakd` VARCHAR(1000) COLLATE utf8_polish_ci NOT NULL,
  35.   `sklepy` text COLLATE utf8_polish_ci NOT NULL,
  36.   `hipermarkety` text COLLATE utf8_polish_ci NOT NULL,
  37.   `prowadzeniesamochodu` VARCHAR(50) COLLATE utf8_polish_ci NOT NULL,
  38.   `wlasnysamochod` INT(1) NOT NULL,
  39.   `tajemniczy` VARCHAR(255) COLLATE utf8_polish_ci NOT NULL,
  40.   `uwagi` text COLLATE utf8_polish_ci NOT NULL,
  41.   `ban` INT(1) NOT NULL,
  42.   PRIMARY KEY (`id`)
  43. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=20 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement