MySQL Database Plan

Welcome to ComputerTechMonkey.net

Below is the basic layout of my MySQL database. The tables inside the database are comics, news and users.

Content tables

Comics table

  • Fieldname: imgID - Type: int - Size: 10 - auto incrementing - Primary Key - Unsigned
  • Fieldname: imgName - Type: varchar - Size: 20
  • Fieldname: NavText - Type: varchar - Size: 20
  • Fieldname: altText - Type: varchar - Size: 50
  • Fieldname: title - Type: varchar - Size: 30
  • Fieldname: dateAdded - Type: timestamp - Default: CURRENT_TIMESTAMP
Comics Table image

News table

  • Fieldname: newsID - Type: int - Size: 10 - auto incrementing - Primary Key - Unsigned
  • Fieldname: dateAdded - Type: timestamp - Default: CURRENT_TIMESTAMP
  • Fieldname: newsText - Type: text
  • Fieldname: link - Type: text
News Table image

Other Tables

Users table

  • Fieldname: userID - Type: int - Size: 10 - auto incrementing - Primary Key - Unsigned
  • Fieldname: userFname - Type: varchar - Size: 20
  • Fieldname: userLname - Type: varchar - Size: 40
  • Fieldname: userName - Type: varchar - Size: 50
  • Fieldname: password - Type: varchar - Size: 40
  • Fieldname: userEmail - Type: varchar - Size: 50
  • Fieldname: createdTime - Type: timestamp - Default: CURRENT_TIMESTAMP
  • Fieldname: userLevels - Type: int - Size: 1 - Default: 1
Users Table image