y a ca sur le fichier mysql.txt
Structure de la table ´accesslist_phpmyforum´
#
CREATE TABLE accesslist_phpmyforum (
ForumId int(10) unsigned DEFAULT ´0´ NOT NULL,
UserId int(10) unsigned DEFAULT ´0´ NOT NULL,
KEY ForumId (ForumId, UserId)
);
- --------------------------------------------------------
#
- Structure de la table ´forum_phpmyforum´
#
CREATE TABLE forum_phpmyforum (
ForumId int(11) unsigned NOT NULL auto_increment,
Type varchar(20) NOT NULL,
Title tinytext NOT NULL,
LastModification int(20) unsigned DEFAULT ´0´ NOT NULL,
State varchar(20) NOT NULL,
Password tinytext,
Commentary text,
PRIMARY KEY (ForumId),
KEY ForumId (ForumId),
KEY Type (Type),
KEY LastModification (LastModification),
KEY State (State)
);
- --------------------------------------------------------
#
- Structure de la table ´message_phpmyforum´
#
CREATE TABLE message_phpmyforum (
MessageId int(10) unsigned NOT NULL auto_increment,
Author varchar(50),
UserId int(10) unsigned,
Subject tinytext NOT NULL,
LastMessage int(10) unsigned DEFAULT ´0´ NOT NULL,
Text text NOT NULL,
CreationDate int(20) unsigned DEFAULT ´0´ NOT NULL,
PRIMARY KEY (MessageId),
KEY MessageId (MessageId),
KEY LastMessage (LastMessage),
KEY CreationDate (CreationDate)
);
- --------------------------------------------------------
#
- Structure de la table ´moderation_phpmyforum´
#
CREATE TABLE moderation_phpmyforum (
ForumId int(10) unsigned DEFAULT ´0´ NOT NULL,
UserId int(10) unsigned DEFAULT ´0´ NOT NULL,
KEY ForumId (ForumId, UserId)
);
- ------------------------------------------------------
--
#
- Structure de la table ´notification_phpmyforum´
#
CREATE TABLE notification_phpmyforum (
NotificationId int(10) unsigned NOT NULL auto_increment,
ForumId int(10) unsigned,
DestinedUserId int(10) unsigned,
Author varchar(50),
UserId int(10) unsigned,
Text text NOT NULL,
CreationDate int(20) unsigned DEFAULT ´0´ NOT NULL,
PRIMARY KEY (NotificationId),
KEY NotificationId (NotificationId),
KEY CreationDate (CreationDate)
);
- --------------------------------------------------------
#
- Structure de la table ´thread_phpmyforum´
#
CREATE TABLE thread_phpmyforum (
ForumId int(10) unsigned DEFAULT ´0´ NOT NULL,
MessageId int(10) unsigned DEFAULT ´0´ NOT NULL,
LastAuthor varchar(50),
LastUserId int(10) unsigned,
RepliesNumber int(10) unsigned DEFAULT ´0´ NOT NULL,
LastUpdate int(20) unsigned DEFAULT ´0´ NOT NULL,
PRIMARY KEY (ForumId, MessageId),
KEY ForumId (ForumId),
KEY MessageId (MessageId),
KEY LastUpdate (LastUpdate)
);
- --------------------------------------------------------
#
- Structure de la table ´user_phpmyforum´
#
CREATE TABLE user_phpmyforum (
UserId int(10) unsigned NOT NULL auto_increment,
FirstName varchar(50) NOT NULL,
LastName varchar(50) NOT NULL,
Email varchar(50) NOT NULL,
Photograph varchar(200),
WebSite varchar(200),
Login varchar(50) NOT NULL,
Password varchar(50) NOT NULL,
Theme varchar(50) NOT NULL,
Commentary text,
Frequency int(10) unsigned DEFAULT ´0´ NOT NULL,
Administrator varchar(5) DEFAULT ´no´ NOT NULL,
PRIMARY KEY (UserId),
KEY UserId (UserId),
KEY FirstName (FirstName),
KEY LastName (LastName),
KEY Email (Email),
KEY Login (Login),
KEY Password (Password),
KEY Theme (Theme),
KEY Frequency (Frequency),
KEY Administrator (Administrator)
);
- --------------------------------------------------------
#
- Contenu de la table ´accesslist_phpmyforum´
#
INSERT INTO accesslist_phpmyforum VALUES ( ´0´, ´0´);
- --------------------------------------------------------
#
- Contenu de la table ´moderation_phpmyforum´
#
INSERT INTO moderation_phpmyforum VALUES ( ´0´, ´0´);
