[rjckE]

Hello guys. I was reading some of sql in amxx and i have some questions.

What should be the structure for the table "admins" for the admins?

I know that insert is like

INSERT INTO admins VALUES("STEAM_0:1:23456", "", "abcdefghijklmnopqrstu", "ce");

So table Admins must have SteamID, Password, Privilegies and Flags attributes, but how should i name them? Does the name of the table's attributes matter? And what about type (text, varchar, int, etc)??

Thanks for your replies!

[undrex]

CREATE  TABLE  `admins` ( `id` INT NOT  NULL  AUTO_INCREMENT  PRIMARY  KEY ,
 `steamid` VARCHAR( 64  )  NULL  DEFAULT NULL ,
 `password` VARCHAR( 64  )  NULL  DEFAULT NULL ,
 `privilegies` VARCHAR( 64  )  NULL  DEFAULT NULL ,
 `flags` VARCHAR( 64  )  NULL  DEFAULT NULL 
) ENGINE  =  MYISAM ;

[Exolent[jNr]]

The SQL version of admin.amxx automatically creates the table for you.
Here is the query it uses:

CREATE TABLE IF NOT EXISTS `%s`
( `auth` VARCHAR( 32 ) NOT NULL,
`password` VARCHAR( 32 ) NOT NULL,
`access` VARCHAR( 32 ) NOT NULL,
`flags` VARCHAR( 32 ) NOT NULL )
COMMENT = 'AMX Mod X Admins'

Where '%s' is the value of the cvar amx_sql_table.

[rjckE]

Aw, thanks so much for the info guys! I thought i had to create manually the table!

Thanks a lot