Advertisement
annya

database

Nov 3rd, 2014
268
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.20 KB | None | 0 0
  1. --
  2. -- Table structure for table `plot_details`
  3. --
  4.  
  5. CREATE TABLE IF NOT EXISTS `plot_details` (
  6.   `plot_detailsid` int(11) NOT NULL AUTO_INCREMENT,
  7.   `title` varchar(100) NOT NULL,
  8.   `content` text NOT NULL,
  9.   `imgname` varchar(100) NOT NULL,
  10.   `imgname1` varchar(100) NOT NULL,
  11.   `imgname2` varchar(100) NOT NULL,
  12.   `imgname3` varchar(100) NOT NULL,
  13.   `imgname4` varchar(100) NOT NULL,
  14.   `cid` varchar(100) NOT NULL,
  15.   `city` varchar(100) NOT NULL,
  16.   `locality` varchar(700) NOT NULL,
  17.   `sqft` varchar(100) NOT NULL,
  18.   `acre` varchar(100) NOT NULL,
  19.   `cent` varchar(100) NOT NULL,
  20.   `sqm` varchar(100) NOT NULL,
  21.   `bedroom` varchar(100) NOT NULL,
  22.   `bathroom` varchar(100) NOT NULL,
  23.   `price` varchar(100) NOT NULL,
  24.   `owner_type` varchar(100) NOT NULL,
  25.   `video_title` varchar(100) NOT NULL,
  26.   `url` varchar(100) NOT NULL,
  27.   `covered_area` varchar(400) NOT NULL,
  28.   `feet` varchar(400) NOT NULL,
  29.   `random_id` varchar(200) NOT NULL,
  30.   `email` varchar(200) NOT NULL,
  31.   `pnumber` varchar(100) NOT NULL,
  32.   `status` int(11) NOT NULL,
  33.   `field` varchar(100) NOT NULL,
  34.   `url_page` varchar(200) NOT NULL,
  35.   PRIMARY KEY (`plot_detailsid`)
  36. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=242 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement