1 CREATE DATABASE IF NOT EXISTS `ryzom_ams`;
3 DROP TABLE IF EXISTS ams_user;
5 CREATE TABLE IF NOT EXISTS `ams_user` (
6 `UId` int(10) NOT NULL AUTO_INCREMENT,
7 `Login` varchar(64) NOT NULL DEFAULT '',
8 `Password` varchar(13) DEFAULT NULL,
9 `Email` varchar(255) NOT NULL DEFAULT '',
10 `Permission` int(3) NOT NULL DEFAULT 1,
12 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='contains all users information for ryzom_ams';
16 CREATE DATABASE IF NOT EXISTS `ryzom_ams_lib`;
18 DROP TABLE IF EXISTS ams_querycache;
20 CREATE TABLE ams_querycache (
21 `SID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
22 `type` VARCHAR( 64 ) NOT NULL ,
23 `query` VARCHAR( 512 ) NOT NULL