[root@gandalf root]# mysql -p < mondir.sql
Enter password:
[root@gandalf root]# cat mondir.sql
CREATE DATABASE IF NOT EXISTS mondir;
USE mondir;
CREATE TABLE IF NOT EXISTS clients (
client VARCHAR(20) NOT NULL
);
CREATE TABLE IF NOT EXISTS projects (
client VARCHAR(20) NOT NULL,
project VARCHAR(10) NOT NULL
);
CREATE TABLE IF NOT EXISTS date (
date DATE
);
CREATE TABLE IF NOT EXISTS size_day (
client VARCHAR(20) NOT NULL,
project VARCHAR(10) NOT NULL,
date DATE,
size BIGINT(10) NOT NULL
);
ALTER TABLE clients
ADD PRIMARY KEY (client);
ALTER TABLE projects
ADD PRIMARY KEY (project),
ADD FOREIGN KEY (client) REFERENCES clients(client);
ALTER TABLE date
ADD PRIMARY KEY (date);
ALTER TABLE size_day
ADD FOREIGN KEY (client) REFERENCES clients(client),
ADD FOREIGN KEY (project) REFERENCES projects(project),
ADD FOREIGN KEY (date) REFERENCES date(date);
[root@gandalf root]# mysql -u mondir -p mondir
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 35193
Server version: 5.0.41 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show tables;
+------------------+
| Tables_in_mondir |
+------------------+
| clients |
| date |
| projects |
| size_day |
+------------------+
4 rows in set (0,00 sec)
mysql> insert into projects(client,project) values ('teste','nada');
Query OK, 1 row affected (0,00 sec)
mysql> select * from projects;
+--------+---------+
| client | project |
+--------+---------+
| teste | nada |
+--------+---------+
1 row in set (0,00 sec)
mysql> show columns from projects;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| client | varchar(20) | NO | MUL | | |
| project | varchar(10) | NO | PRI | | |
+---------+-------------+------+-----+---------+-------+
2 rows in set (0,00 sec)
mysql>