lav sql fil
Jeg har fundet et forum script som når man installerer det bør lave nogle mySQL ting i mySQL databasen... Men den har ikke gjort det så hjælp mig lige med at lave én SQL fil ud af alle disse udklip fra nogle phpfiler:<?php
$exists = mysql_query("DESCRIBE forum_settings");
if(!$exists) {
mysql_query("CREATE TABLE `forum_settings` (
`id` int(11) NOT NULL auto_increment,
`title` tinytext NOT NULL,
`adminmail` tinytext NOT NULL,
`dato_form` tinytext NOT NULL,
`pr_side` int(3) NOT NULL default '0',
`pr_side_t` int(3) NOT NULL default '0',
`url` tinytext NOT NULL,
`width` tinytext NOT NULL,
`posts` int(1) NOT NULL default '0',
`avatar` int(1) NOT NULL default '0',
`avatarH` int(11) NOT NULL default '0',
`avatarW` int(11) NOT NULL default '0',
`avatarSize` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;");
}
?>
og
<?php
$exists = mysql_query("DESCRIBE forum_users");
if(!$exists) {
mysql_query("CREATE TABLE `forum_users` (
`id` int(11) NOT NULL auto_increment,
`rang` int(1) NOT NULL default '1',
`user` tinytext NOT NULL,
`password` tinytext NOT NULL,
`navn` tinytext NOT NULL,
`email` tinytext NOT NULL,
`vis_mail` int(1) NOT NULL default '1',
`avatar` int(1) NOT NULL default '0',
`avatar_web` tinytext NOT NULL,
`avatar_upload` tinytext NOT NULL,
`hp` tinytext NOT NULL,
`icq` tinytext NOT NULL,
`msn` tinytext NOT NULL,
`yahoo` tinytext NOT NULL,
`fritekst` longtext NOT NULL,
`optSignatur` int(11) NOT NULL default '0',
`signatur` tinytext NOT NULL,
`ip` varchar(16) NOT NULL default '0',
`make_date_stamp` int(20) NOT NULL default '0',
`last_seen_stamp` int(20) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ");
}
?>
og
<?php
$exists = mysql_query("DESCRIBE forum_emne");
if(!$exists) {
mysql_query("CREATE TABLE `forum_emne` (
`id` int(11) NOT NULL auto_increment,
`sort` int(11) NOT NULL default '0',
`emne` tinytext NOT NULL,
`public` int(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=3 ");
mysql_query("INSERT INTO `forum_emne` VALUES (1, 1, 'Co/Admin Emne', 0)");
mysql_query("INSERT INTO `forum_emne` VALUES (2, 0, 'Test Emne', 1)");
}
$exists = mysql_query("DESCRIBE forum_board");
if(!$exists) {
mysql_query("CREATE TABLE `forum_board` (
`id` int(11) NOT NULL auto_increment,
`sort` int(11) NOT NULL default '0',
`board` tinytext NOT NULL,
`emneId` int(2) NOT NULL default '0',
`public` int(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=4 ");
mysql_query("INSERT INTO `forum_board` VALUES (1, 0, 'Board for flyttede tråde', 1, 0)");
mysql_query("INSERT INTO `forum_board` VALUES (2, 1, 'Co/Admin board', 1, 0)");
mysql_query("INSERT INTO `forum_board` VALUES (3, 0, 'Test Board', 2, 1)");
}
$exists = mysql_query("DESCRIBE forum_thread");
if(!$exists) {
mysql_query("CREATE TABLE `forum_thread` (
`id` int(11) NOT NULL auto_increment,
`overskrift` tinytext NOT NULL,
`text` longtext NOT NULL,
`mail` int(1) NOT NULL default '0',
`bruger` tinytext NOT NULL,
`brugerId` varchar(5) NOT NULL default '0',
`ip` varchar(16) NOT NULL default '0',
`board` tinytext NOT NULL,
`emneId` tinytext NOT NULL,
`last_reply_stamp` int(20) NOT NULL default '0',
`public` int(1) NOT NULL default '1',
`lock` int(1) NOT NULL default '0',
`date_stamp` int(20) NOT NULL default '0',
`last_edit_stamp` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ");
}
$exists = mysql_query("DESCRIBE forum_reply");
if(!$exists) {
mysql_query("CREATE TABLE `forum_reply` (
`id` int(11) NOT NULL auto_increment,
`reply_to` int(5) NOT NULL default '0',
`text` longtext NOT NULL,
`bruger` tinytext NOT NULL,
`brugerId` varchar(5) NOT NULL default '0',
`ip` varchar(16) NOT NULL default '0',
`board` tinytext NOT NULL,
`emneId` int(2) NOT NULL default '0',
`date_stamp` int(20) NOT NULL default '0',
`public` int(1) NOT NULL default '1',
`last_edit_stamp` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ");
}
$exists = mysql_query("DESCRIBE forum_pm");
if(!$exists) {
mysql_query("CREATE TABLE `forum_pm` (
`id` int(11) NOT NULL auto_increment,
`til` tinytext NOT NULL,
`fra` tinytext NOT NULL,
`brugernavn` tinytext NOT NULL,
`besked` longtext NOT NULL,
`seen` int(1) NOT NULL default '0',
`dato_stamp` int(20) NOT NULL default '0',
`popup` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ");
}
?>
