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));