<?php
$create = array("CREATE TABLE IF NOT EXISTS `audio` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`comments` varchar(255) NOT NULL,
`views` varchar(255) NOT NULL,
`allowComments` varchar(255) NOT NULL,
`lastViewed` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1",
"CREATE TABLE IF NOT EXISTS `forum_a` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`sub_id` varchar(255) NOT NULL,
`q_id` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`poster` varchar(255) NOT NULL,
`body` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
`views` varchar(255) NOT NULL,
`replies` varchar(255) NOT NULL,
`lastViewBy` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3",
"CREATE TABLE IF NOT EXISTS `forum_category` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`cat_name` varchar(255) NOT NULL,
`cat_description` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2",
"CREATE TABLE IF NOT EXISTS `forum_main` (
`forum_title` varchar(255) NOT NULL,
`forum_description` varchar(255) NOT NULL,
`forum_status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1",
"CREATE TABLE IF NOT EXISTS `forum_q` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`sub_id` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`poster` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`body` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
`views` varchar(255) NOT NULL,
`replies` varchar(255) NOT NULL,
`lastView` varchar(255) NOT NULL,
`lastViewBy` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2",
"CREATE TABLE IF NOT EXISTS `forum_rights` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`post` varchar(255) NOT NULL,
`thread` varchar(255) NOT NULL,
`delete` varchar(255) NOT NULL,
`edit` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1",
"CREATE TABLE IF NOT EXISTS `forum_stats` (
`total_posts` varchar(255) NOT NULL,
`total_topics` varchar(255) NOT NULL,
`total_subs` varchar(255) NOT NULL,
`total_description` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1",
"CREATE TABLE IF NOT EXISTS `forum_subs` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`cat_id` varchar(255) NOT NULL,
`sub_name` varchar(255) NOT NULL,
`sub_detail` varchar(255) NOT NULL,
`views` varchar(255) NOT NULL,
`replies` varchar(255) NOT NULL,
`lastPost` varchar(255) NOT NULL,
`lastPostOn` varchar(255) NOT NULL,
`forum_post` varchar(255) NOT NULL,
`forum_start_topics` varchar(255) NOT NULL,
`forum_delete` varchar(255) NOT NULL,
`forum_edit` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2",
"CREATE TABLE IF NOT EXISTS `friends` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`friend` varchar(255) NOT NULL,
`foe` varchar(255) NOT NULL,
`friends` varchar(255) NOT NULL,
`foes` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1",
"CREATE TABLE IF NOT EXISTS `jokes` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`contents` mediumtext NOT NULL,
`category` varchar(255) NOT NULL,
`comments` varchar(255) NOT NULL,
`views` varchar(255) NOT NULL,
`allowComments` varchar(255) NOT NULL,
`lastViewed` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1",
"CREATE TABLE IF NOT EXISTS `modules` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`file` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1",
"CREATE TABLE IF NOT EXISTS `pictures` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`category` varchar(255) NOT NULL,
`comments` varchar(255) NOT NULL,
`views` varchar(255) NOT NULL,
`allowComments` varchar(255) NOT NULL,
`height` varchar(255) NOT NULL,
`width` varchar(255) NOT NULL,
`extension` varchar(255) NOT NULL,
`name2` varchar(255) NOT NULL,
`lastViewed` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1",
"CREATE TABLE IF NOT EXISTS `prefs` (
`captcha` varchar(255) NOT NULL,
`login` varchar(255) NOT NULL,
`registration` varchar(255) NOT NULL,
`logintext` varchar(255) NOT NULL,
`registrationtext` varchar(255) NOT NULL,
`emailVerification` varchar(255) NOT NULL,
`forum_status` varchar(255) NOT NULL,
`forum_status_msg` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1",
"CREATE TABLE IF NOT EXISTS `privatemessages` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`to` varchar(255) NOT NULL,
`from` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`body` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1",
"CREATE TABLE IF NOT EXISTS `statistics` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`users` varchar(255) NOT NULL,
`comments` varchar(255) NOT NULL,
`videos` varchar(255) NOT NULL,
`jokes` varchar(255) NOT NULL,
`pictures` varchar(255) NOT NULL,
`stories` varchar(255) NOT NULL,
`total` varchar(255) NOT NULL,
`siteVisits` varchar(255) NOT NULL,
`activeUsers` varchar(255) NOT NULL,
`onlineUsers` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2",
"CREATE TABLE IF NOT EXISTS `users` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`avatar` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`allowEmail` varchar(255) NOT NULL,
`lastActive` varchar(255) NOT NULL,
`lastVisit` varchar(255) NOT NULL,
`visits` varchar(255) NOT NULL,
`acessLevel` varchar(255) NOT NULL,
`verified` varchar(255) NOT NULL,
`forum_theme` varchar(255) NOT NULL,
`signature` varchar(255) NOT NULL,
`forum_post` varchar(255) NOT NULL,
`forum_start_topics` varchar(255) NOT NULL,
`forum_delete` varchar(255) NOT NULL,
`forum_edit` varchar(255) NOT NULL,
`rand_ver_id` varchar(255) NOT NULL,
`posts` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2",
"CREATE TABLE IF NOT EXISTS `usersonline` (
`username` varchar(255) NOT NULL,
`true` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1",
"CREATE TABLE IF NOT EXISTS `videos` (
`ID` tinyint(4) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`comments` varchar(255) NOT NULL,
`views` varchar(255) NOT NULL,
`allowComments` varchar(255) NOT NULL,
`lastViewed` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1"
);
$insert = array("INSERT INTO `forum_a` (`ID`, `sub_id`, `q_id`, `subject`, `poster`, `body`, `date`, `views`, `replies`, `lastViewBy`) VALUES
(1, '1', '1', 'Testing Question', 'User1', 'This is a reply to my question.', '6/6/2008', '0', '0', 'User1 - 6/6/2008'),
(2, '1', '1', 'Answer to Testing Question', 'Admin', 'This is a reply to your question and I don''t even exist!.', '6/6/2008', '0', '0', 'Admin - 6/6/2008')",
"INSERT INTO `forum_category` (`ID`, `cat_name`, `cat_description`) VALUES
(1, 'General Purpose', 'A category for the general purpose')",
"INSERT INTO `forum_main` (`forum_title`, `forum_description`, `forum_status`) VALUES
('Entertainment System Forum', 'A forum for all of your entertainment needs. (This is a description if you haven''t noticed yet', '1'),
('Entertainment System Forum', 'A forum for all of your entertainment needs', '1')",
"INSERT INTO `forum_q` (`ID`, `sub_id`, `subject`, `poster`, `description`, `body`, `date`, `views`, `replies`, `lastView`, `lastViewBy`) VALUES
(1, '1', 'Testing Question', 'User1', 'A question for the testing', 'This is my test. I hope I don''t fail it.', '6/6/2008', '0', '2', 'Answer to Testing Question', 'Admin - 6/6/2008')",
"INSERT INTO `forum_stats` (`total_posts`, `total_topics`, `total_subs`, `total_description`) VALUES
('1', '1', '1', 'The forum''s statistics')",
"INSERT INTO `forum_subs` (`ID`, `cat_id`, `sub_name`, `sub_detail`, `views`, `replies`, `lastPost`, `lastPostOn`, `forum_post`, `forum_start_topics`, `forum_delete`, `forum_edit`) VALUES
(1, '1', 'Rules', 'Read the forum rules before posting anything', '0', '1', 'Testing Question', 'Admin - 6/6/2008', '1', '1', '1', '1')",
"INSERT INTO `prefs` (`captcha`, `login`, `registration`, `logintext`, `registrationtext`, `emailVerification`, `forum_status`, `forum_status_msg`) VALUES
('1', '1', '1', 'Log in to your account to use your benefits', 'Register to obtain all of membership benefits', '1', '1', 'The forum has being temporarily disabled')",
"INSERT INTO `statistics` (`ID`, `users`, `comments`, `videos`, `jokes`, `pictures`, `stories`, `total`, `siteVisits`, `activeUsers`, `onlineUsers`) VALUES
(1, '1', '0', '0', '0', '0', '0', '0', '0', '1', '1')",
"INSERT INTO `users` (`ID`, `username`, `avatar`, `name`, `password`, `email`, `allowEmail`, `lastActive`, `lastVisit`, `visits`, `acessLevel`, `verified`, `forum_theme`, `signature`, `forum_post`, `forum_start_topics`, `forum_delete`, `forum_edit`, `rand_ver_id`, `posts`) VALUES
(1, 'User1', 'Images/noav.jpg', 'Username', '52ee1edf456c54f4213a189f8454b489', 'email@email.com', '1', '1240191686', '', '1', '1', '1', 'Default', 'This is your signature. You can edit it in the User Control Panel', '1', '1', '1', '1', 'ecadc2da47', '2')",
);
|