34 lines
876 B
Markdown
34 lines
876 B
Markdown
|
Creare un file nella directory **config/config.php**
|
||
|
|
|
||
|
|
```
|
||
|
|
<?php
|
||
|
|
$dbms_user="";
|
||
|
|
$dbms_password="";
|
||
|
|
$dbms_db="";
|
||
|
|
?>
|
||
|
|
```
|
||
|
|
|
||
|
|
Creazione di una tabella:
|
||
|
|
|
||
|
|
```
|
||
|
|
--
|
||
|
|
-- Table structure for table `24h_tablename`
|
||
|
|
--
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `24h_tablename` (
|
||
|
|
`user` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
|
||
|
|
`domain` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
|
||
|
|
`password` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
|
||
|
|
`mcf` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
||
|
|
`goto` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
|
||
|
|
`active` char(1) COLLATE utf8_bin NOT NULL DEFAULT 'Y',
|
||
|
|
`tipo` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT 'mbox',
|
||
|
|
`md5salt` varchar(64) COLLATE utf8_bin NOT NULL,
|
||
|
|
`modified` int(11) NOT NULL,
|
||
|
|
`deleted` int(11) NOT NULL,
|
||
|
|
PRIMARY KEY (`user`,`domain`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
|
|
||
|
|
```
|
||
|
|
|