[Request] plus.cms_news Database Table [Request]

[Jwake]

Hello, DevBesters!
So, when I made my hotel, the database for the hotel didn't come with the 'plus.cms_news' table for PlusEMU. If you could give me the SQL, that would be amazing! Thank you :3

 

[NeedForSpreed]

Get the phoenix db and I think it has it, I'm at school so I can't really give it to you right now sorry

Skickat från min FRD-L09 via Tapatalk

 

[Jwake]

Get the phoenix db and I think it has it, I'm at school so I can't really give it to you right now sorry

Skickat från min FRD-L09 via Tapatalk

When you're back, can you? I'll try get it from the Phoenix Database. Never thought of it, thanks

 

[Haid]

Side note, this is nothing to do with PlusEMU, your cms is requiring this table.
A quick google would of bought you to the fix on DB

You must be registered for see links

CREATE TABLE `cms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`shortstory` text COLLATE latin1_general_ci,
`longstory` text COLLATE latin1_general_ci,
`published` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
`author` int(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

 

[Jwake]

Side note, this is nothing to do with PlusEMU, your cms is requiring this table.
A quick google would of bought you to the fix on DB

You must be registered for see links

CREATE TABLE `cms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`shortstory` text COLLATE latin1_general_ci,
`longstory` text COLLATE latin1_general_ci,
`published` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
`author` int(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

I've done what the guy above you said, I'ma mark it best answer as it did work. Thanks though!