Back

Create Tables

You will have 4 tables in your database:
Tables_in_database
accounts
comments
entries
helpdesk

TABLE accounts:

+-----------+-------------+------+-----+---------+----------------+
| Field     | Type        | Null | Key | Default | Extra          |
+-----------+-------------+------+-----+---------+----------------+
| id        | int(4)      | NO   | PRI | NULL    | auto_increment | 
| fname     | varchar(20) | YES  |     | NULL    |                | 
| lname     | varchar(30) | YES  |     | NULL    |                | 
| email     | varchar(60) | YES  |     | NULL    |                | 
| username  | varchar(30) | YES  |     | NULL    |                | 
| password  | varchar(30) | YES  |     | NULL    |                | 
| noentries | int(4)      | YES  |     | NULL    |                | 
| mailok    | tinyint(1)  | YES  |     | NULL    |                | 
| blocked   | tinyint(1)  | YES  |     | NULL    |                | 
+-----------+-------------+------+-----+---------+----------------+


** SQL:
CREATE TABLE accounts (id INT(4) NOT NULL PRIMARY KEY AUTO_INCREMENT,fname VARCHAR(20),lname VARCHAR(30),email VARCHAR(60),username VARCHAR(30),password VARCHAR(30),noentries INT(4),mailok TINYINT(1),blocked TINYINT(1));

TABLE comments:

+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| id      | int(4)       | NO   | PRI | NULL    | auto_increment | 
| crsp    | int(4)       | YES  |     | NULL    |                | 
| name    | varchar(100) | YES  |     | NULL    |                | 
| comment | mediumtext   | YES  |     | NULL    |                | 
+---------+--------------+------+-----+---------+----------------+


** SQL:
CREATE TABLE comments (id INT(4) NOT NULL PRIMARY KEY AUTO_INCREMENT,crsp INT(4),name VARCHAR(100),comment MEDIUMTEXT);

TABLE entries:

+-------+------------+------+-----+---------+----------------+
| Field | Type       | Null | Key | Default | Extra          |
+-------+------------+------+-----+---------+----------------+
| id    | int(3)     | NO   | PRI | NULL    | auto_increment | 
| date  | varchar(8) | YES  |     | NULL    |                | 
| entry | longtext   | YES  |     | NULL    |                | 
+-------+------------+------+-----+---------+----------------+


** SQL:
CREATE TABLE entries (id INT(3) NOT NULL PRIMARY KEY AUTO_INCREMENT,date VARCHAR(8),entry LONGTEXT);

TABLE helpdesk:

+---------+-------------+------+-----+---------+----------------+
| Field   | Type        | Null | Key | Default | Extra          |
+---------+-------------+------+-----+---------+----------------+
| id      | int(11)     | NO   | PRI | NULL    | auto_increment | 
| type    | varchar(50) | YES  |     | NULL    |                | 
| name    | varchar(80) | YES  |     | NULL    |                | 
| issue   | mediumtext  | YES  |     | NULL    |                | 
| status  | varchar(10) | YES  |     | NULL    |                | 
| email   | varchar(60) | YES  |     | NULL    |                | 
| comment | mediumtext  | YES  |     | NULL    |                | 
| randint | varchar(5)  | YES  |     | NULL    |                | 
+---------+-------------+------+-----+---------+----------------+


** SQL:
CREATE TABLE helpdesk (id INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,type VARCHAR(50),name VARCHAR(80),issue MEDIUMTEXT,status VARCHAR(10),email VARCHAR(60),comment MEDIUMTEXT,randint INT(5));