[Resolved] SQL Problem

[Joseph]

SQL Problem

Sorted thanks

 

[Brujah]

sizelimit is missing an end quote

CREATE TABLE `users`(     
`id` BIGINT AUTO_INCREMENT,     
`username` CHAR(255),     
`password` CHAR(255),     
`email` CHAR(255),     
`aboutme` LONGTEXT,     
`contact` LONGTEXT,     
`sizelimit` BIGINT,     
PRIMARY KEY (`id`) );  

CREATE TABLE `sessions`(     
`id` BIGINT AUTO_INCREMENT,     
`uid` CHAR(255),     
`username` CHAR(255),     
`timestamp` BIGINT,     
PRIMARY KEY (`id`) );  

CREATE TABLE `adverts`(     
`id` BIGINT AUTO_INCREMENT,     
`name` CHAR(255),     
`channel` BIGINT,     
`owner` BIGINT,     
`code` LONGTEXT,     
`hitlimit` BIGINT,     
`hits` BIGINT,     
`uniques` BIGINT,     
`rate` CHAR(255),     
PRIMARY KEY (`id`) );  

CREATE TABLE `banners`(     
`id` BIGINT AUTO_INCREMENT,     
`name` CHAR(255),     
`channel` BIGINT,     
`owner` BIGINT,     
`hitlimit` BIGINT,     
`hits` BIGINT,     
`uniques` BIGINT,     
`rate` CHAR(255),     
`url` CHAR(255),     
PRIMARY KEY (`id`) );  

CREATE TABLE `alertbars`(     
`id` BIGINT AUTO_INCREMENT,     
`name` CHAR(255),     
`channel` BIGINT,     
`owner` BIGINT,     
`text` CHAR(255),     
`hitlimit` BIGINT,     
`hits` BIGINT,     
`uniques` BIGINT,     
`rate` CHAR(255),     
`url` CHAR(255),     
PRIMARY KEY (`id`) );  

CREATE TABLE `channels`(     
`id` BIGINT AUTO_INCREMENT,     
`name` CHAR(255),     
`owner` BIGINT,     
`type` CHAR(255);     
PRIMARY KEY (`id`) );  

CREATE TABLE `uniques`(     
`id` BIGINT AUTO_INCREMENT,     
`ip` CHAR(255),    
`advert` BIGINT,     
`timestamp` BIGINT,     
`hits` BIGINT NOT NULL DEFAULT 0,     
PRIMARY KEY (`id`) );  

CREATE TABLE `uniquesb`(     
`id` BIGINT AUTO_INCREMENT,     
`ip` CHAR(255),     
`banner` BIGINT,     
`timestamp` BIGINT,     
`hits` BIGINT NOT NULL DEFAULT 0,     
PRIMARY KEY (`id`) );  

CREATE TABLE `uniquesa`(     
`id` BIGINT AUTO_INCREMENT,     
`ip` CHAR(255),     
`alertbar` BIGINT,     
`timestamp` BIGINT,     
`hits` BIGINT NOT NULL DEFAULT 0,     
PRIMARY KEY (`id`) );

Try these maybe

 

[bbrez1]

You had an error in table channels at

`type` CHAR(255)

you had a semicolon on end instead of a comma. I tested this and it works great :tu:

CREATE TABLE `users`(
`id` BIGINT AUTO_INCREMENT,
`username` CHAR(255),
`password` CHAR(255),
`email` CHAR(255),
`aboutme` LONGTEXT,
`contact` LONGTEXT,
`sizelimit` BIGINT,
PRIMARY KEY (`id`) );

CREATE TABLE `sessions`(
`id` BIGINT AUTO_INCREMENT,
`uid` CHAR(255),
`username` CHAR(255),
`timestamp` BIGINT,
PRIMARY KEY (`id`) );

CREATE TABLE `adverts`(
`id` BIGINT AUTO_INCREMENT,
`name` CHAR(255),
`channel` BIGINT,
`owner` BIGINT,
`code` LONGTEXT,
`hitlimit` BIGINT,
`hits` BIGINT,
`uniques` BIGINT,
`rate` CHAR(255),
PRIMARY KEY (`id`) );

CREATE TABLE `banners`(
`id` BIGINT AUTO_INCREMENT,
`name` CHAR(255),
`channel` BIGINT,
`owner` BIGINT,
`hitlimit` BIGINT,
`hits` BIGINT,
`uniques` BIGINT,
`rate` CHAR(255),
`url` CHAR(255),
PRIMARY KEY (`id`) );

CREATE TABLE `alertbars`(
`id` BIGINT AUTO_INCREMENT,
`name` CHAR(255),
`channel` BIGINT,
`owner` BIGINT,
`text` CHAR(255),
`hitlimit` BIGINT,
`hits` BIGINT,
`uniques` BIGINT,
`rate` CHAR(255),
`url` CHAR(255),
PRIMARY KEY (`id`) );

CREATE TABLE `channels`(
`id` BIGINT AUTO_INCREMENT,
`name` CHAR(255),
`owner` BIGINT,
`type` CHAR(255),
PRIMARY KEY (`id`) );

CREATE TABLE `uniques`(
`id` BIGINT AUTO_INCREMENT,
`ip` CHAR(255),
`advert` BIGINT,
`timestamp` BIGINT,
`hits` BIGINT NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) );

CREATE TABLE `uniquesb`(
`id` BIGINT AUTO_INCREMENT,
`ip` CHAR(255),
`banner` BIGINT,
`timestamp` BIGINT,
`hits` BIGINT NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) );

CREATE TABLE `uniquesa`(
`id` BIGINT AUTO_INCREMENT,
`ip` CHAR(255),
`alertbar` BIGINT,
`timestamp` BIGINT,
`hits` BIGINT NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) );

 

[Brujah]

Who got the NP$100?