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
SQL
17 lines
447 B
SQL
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;
|
|
|
|
|