All pastes #487929 Raw Edit

k001

public sql v1 · immutable
·published 2007-05-14 19:01 UTC
rendered paste body
+---------------+---------------------+------+-----+---------+----------------+| Field         | Type                | Null | Key | Default | Extra          |+---------------+---------------------+------+-----+---------+----------------+| id            | int(3)              | NO   | PRI | NULL    | auto_increment | | id_location   | int(2)              | NO   |     |         |                | | adult_only    | tinyint(1)          | YES  |     | NULL    |                | | all_inclusive | tinyint(1)          | YES  |     | NULL    |                | | in_home       | tinyint(1)          | YES  |     | NULL    |                | | stars         | int(1)              | YES  |     | NULL    |                | | beach_front   | tinyint(1)          | YES  |     | 0       |                | | iva           | int(2)              | YES  |     | NULL    |                | | child_from    | int(2)              | YES  |     | NULL    |                | | child_to      | int(2)              | YES  |     | NULL    |                | | junior_from   | int(2)              | YES  |     | NULL    |                | | junior_to     | int(2)              | YES  |     | NULL    |                | | pic_one       | varchar(255)        | YES  |     | NULL    |                | | pic_two       | varchar(255)        | YES  |     | NULL    |                | | pic_three     | varchar(255)        | YES  |     | NULL    |                | | pic_four      | varchar(255)        | YES  |     | NULL    |                | | pic_five      | varchar(255)        | YES  |     | NULL    |                | | pic_six       | varchar(255)        | YES  |     | NULL    |                | | cut_off       | tinyint(2) unsigned | YES  |     | 9       |                | | id_area       | int(3)              | NO   |     |         |                | +---------------+---------------------+------+-----+---------+----------------+20 rows in set (0.00 sec)+------------------+-----------------+------+-----+---------+----------------+| Field            | Type            | Null | Key | Default | Extra          |+------------------+-----------------+------+-----+---------+----------------+| id               | int(3) unsigned | NO   | PRI | NULL    | auto_increment | | id_location      | int(2) unsigned | NO   |     |         |                | | name             | varchar(150)    | YES  |     | NULL    |                | | meta_descript    | varchar(150)    | YES  |     | NULL    |                | | meta_keyword     | varchar(150)    | YES  |     | NULL    |                | | title            | varchar(100)    | YES  |     | NULL    |                | | overview         | text            | YES  |     | NULL    |                | | amenities        | text            | YES  |     | NULL    |                | | address          | text            | YES  |     | NULL    |                | | restaurants      | text            | YES  |     | NULL    |                | | how_to_get       | mediumtext      | YES  |     | NULL    |                | | term_conditions  | text            | YES  |     | NULL    |                | | what_inclusive   | text            | YES  |     | NULL    |                | | entertaiment     | text            | YES  |     | NULL    |                | | bussiness_center | mediumtext      | YES  |     | NULL    |                | | active           | tinyint(1)      | NO   |     | 0       |                | +------------------+-----------------+------+-----+---------+----------------+16 rows in set (0.00 sec)