You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
17 lines
447 B
MySQL
17 lines
447 B
MySQL
6 years ago
|
CREATE TABLE `messages` (
|
||
|
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
||
|
`pseudo` text NOT NULL,
|
||
|
`message` text NOT NULL,
|
||
|
`couleur` text NOT NULL,
|
||
|
`pieceJointe` text NOT NULL,
|
||
|
PRIMARY KEY (`time`,`pseudo`(5))
|
||
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
||
|
|
||
|
CREATE TABLE `users` (
|
||
|
`pseudo` varchar(10) NOT NULL,
|
||
|
`password` text NOT NULL,
|
||
|
PRIMARY KEY (`pseudo`)
|
||
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
||
|
|
||
|
|