Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --
- -- Tabellstruktur `categories`
- --
- CREATE TABLE `categories` (
- `category_id` int(11) UNSIGNED NOT NULL,
- `category_position` int(10) UNSIGNED NOT NULL,
- `category_title` varchar(150) NOT NULL,
- `category_layout` varchar(50) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellstruktur `forums`
- --
- CREATE TABLE `forums` (
- `forum_id` int(11) UNSIGNED NOT NULL,
- `forum_image` varchar(150) NOT NULL,
- `forum_title` varchar(150) NOT NULL,
- `forum_description` varchar(255) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellstruktur `layouts`
- --
- CREATE TABLE `layouts` (
- `position_id` int(10) UNSIGNED NOT NULL,
- `category_id` int(10) UNSIGNED NOT NULL,
- `forum_id` int(10) UNSIGNED NOT NULL,
- `position` int(11) UNSIGNED NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellstruktur `posts`
- --
- CREATE TABLE `posts` (
- `post_id` int(11) NOT NULL,
- `post_topic_id` int(11) NOT NULL,
- `post_position` int(11) NOT NULL,
- `post_title` varchar(150) NOT NULL,
- `post_description` varchar(255) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellstruktur `topics`
- --
- CREATE TABLE `topics` (
- `topic_id` int(11) NOT NULL,
- `topic_forum_id` int(11) NOT NULL,
- `topic_position` int(11) NOT NULL,
- `topic_title` varchar(150) NOT NULL,
- `topic_description` varchar(255) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Index för dumpade tabeller
- --
- --
- -- Index för tabell `categories`
- --
- ALTER TABLE `categories`
- ADD PRIMARY KEY (`category_id`);
- --
- -- Index för tabell `forums`
- --
- ALTER TABLE `forums`
- ADD PRIMARY KEY (`forum_id`);
- --
- -- Index för tabell `posts`
- --
- ALTER TABLE `posts`
- ADD PRIMARY KEY (`post_id`);
- --
- -- Index för tabell `topics`
- --
- ALTER TABLE `topics`
- ADD PRIMARY KEY (`topic_id`);
- --
- -- AUTO_INCREMENT för dumpade tabeller
- --
- --
- -- AUTO_INCREMENT för tabell `categories`
- --
- ALTER TABLE `categories`
- MODIFY `category_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT för tabell `forums`
- --
- ALTER TABLE `forums`
- MODIFY `forum_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT för tabell `posts`
- --
- ALTER TABLE `posts`
- MODIFY `post_id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT för tabell `topics`
- --
- ALTER TABLE `topics`
- MODIFY `topic_id` int(11) NOT NULL AUTO_INCREMENT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement