sfqT5XXC

1drop table if exists users;
2create table users (
3  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
4  name varchar(200),
5  passwd varchar(200),
6  language varchar(200)
7);
8
9
10drop table if exists structures;
11create table structures (
12  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
13  kind varchar(200),
14  name varchar(200),
15  address text,
16  city text,
17  cap varchar(200),
18  province varchar(200),
19  tel varchar(200),
20  fax varchar(200),
21  url varchar(200),
22  emailcomunications varchar(200),
23  emailprenotations varchar(200),
24  rooms int(11),
25  treatments text
26);
27
28
29drop table if exists rooms;
30create table rooms (
31  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
32  kind text,
33  capacity int(11),
34  availability boolean,
35  enabled boolean
36);