Jump to content
php.lv forumi

Kur kļūda?


kalabox
 Share

Recommended Posts

Sveiki, kur kļūda?>

 

Izveidoju baze.sql..

Pievienojot caur phpmyadmin uzrādās šāda kļūda

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''users' ( ID SMALLINT UNSIGNED NOT NULL auto_increment, login VARCHAR(50) NOT' at line 1

 

CREATE TABLE 'users'

(

ID SMALLINT UNSIGNED NOT NULL auto_increment,

login VARCHAR(50) NOT NULL,

email VARCHAR(50) NOT NULL,

date datetime NOT NULL default '0000-00-00 00:00:00',

pass VARCHAR(20) NOT NULL,

status VARCHAR(15) NOT NULL,

ip VARCHAR(30) NOT NULL,

pay INT(7) NOT NULL,

datepay datetime NOT NULL default '0000-00-00 00:00:00',

PRIMARY KEY(ID)

)

Link to comment
Share on other sites

blin, nonēmu pēdinas

 

tagat rāda par otro tabulu kluudu

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE profiles ( id smallint unsigned not null auto_increment, name VA' at line 15

 

luuk visa db

CREATE TABLE users
(
id smallint unsigned not null auto_increment,
login varchar(50) NOT NULL,
email VARCHAR(50) NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
pass VARCHAR(20) NOT NULL,
status VARCHAR(15) NOT NULL,
ip VARCHAR(30) NOT NULL,
pay INT(7) NOT NULL,
datepay datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY(ID)
)
CREATE TABLE profiles
(
id smallint unsigned not null auto_increment,
name VARCHAR(50) NOT NULL,
email VARCHAR(50) NOT NULL,
city INT(4) NOT NULL,
country INT(4) NOT NULL,
raion VARCHAR(50) NOT NULL,
metro VARCHAR(30) NOT NULL,
telephone TEXT NOT NULL,
howdrive TEXT NOT NULL,
type VARCHAR(50) NOT NULL,
birth date NOT NULL,
height VARCHAR(3) NOT NULL,
weight VARCHAR(3) NOT NULL,
bust VARCHAR(3) NOT NULL,
eyes VARCHAR(10) NOT NULL,
hair VARCHAR(10) NOT NULL,
closes VARCHAR(10) NOT NULL,
dopusl TEXT NOT NULL,
penissize VARCHAR(3) NOT NULL,
penisdim VARCHAR(3) NOT NULL,
orient VARCHAR(10) NOT NULL,
zodiac VARCHAR(15) NOT NULL,
languages TEXT NOT NULL,
agency VARCHAR(50) NOT NULL,
category VARCHAR(30) NOT NULL,
tr TEXT NOT NULL,
appricehour INT(5) NOT NULL,
apprice2hour INT(5) NOT NULL,
appricenight INT(5) NOT NULL,
homepricehour INT(5) NOT NULL,
homeprice2hour INT(5) NOT NULL,
homepricenight INT(5) NOT NULL,
url VARCHAR(70) NOT NULL,
comment TEXT NOT NULL,
hairlength INT(2) NOT NULL,
colorskin VARCHAR(70) NOT NULL,
facetype VARCHAR(70) NOT NULL,
grud INT(3) NOT NULL,
talia INT(3) NOT NULL,
bedra INT(3) NOT NULL,
obuv VARCHAR(10) NOT NULL,
body VARCHAR(20) NOT NULL,
edu VARCHAR(20) NOT NULL,
passport VARCHAR(10) NOT NULL,
expir TEXT NOT NULL,
soglasie TEXT NOT NULL,
video VARCHAR(30) NOT NULL,
audio VARCHAR(30) NOT NULL,
aid INT(9) NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
pay INT(9) NOT NULL,
dateend datetime NOT NULL default '0000-00-00 00:00:00',
expperiod VARCHAR(3) NOT NULL,
reiting INT(9) NOT NULL,
sum INT(9) NOT NULL,
count INT(9) NOT NULL,
today date NOT NULL,
status VARCHAR(15) NOT NULL,
daygirl VARCHAR(15) NOT NULL,
alt1 VARCHAR(15) NOT NULL,
alt2 TEXT NOT NULL,
PRIMARY KEY(ID)
)

CREATE TABLE country
(
ID SMALLINT UNSIGNED NOT NULL auto_increment,
country VARCHAR(100) NOT NULL,
city VARCHAR(100) NOT NULL,
PRIMARY KEY(ID)
)
CREATE TABLE krim
(
ID SMALLINT UNSIGNED NOT NULL auto_increment,
telephone TEXT NOT NULL,
adress TEXT NOT NULL,
comment TEXT NOT NULL,
aid INT(9) NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
alt1 VARCHAR(15) NOT NULL,
alt2 TEXT NOT NULL,
PRIMARY KEY(ID)
)

CREATE TABLE photo
(
ID SMALLINT UNSIGNED NOT NULL auto_increment,
foto VARCHAR(30) NOT NULL,
aid INT(9) NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
status VARCHAR(15) NOT NULL,
main INT(1) NULL default '0',
PRIMARY KEY(ID)
)

CREATE TABLE saluncomm
(
ID SMALLINT UNSIGNED NOT NULL auto_increment,
city INT(4) NOT NULL,
country INT(4) NOT NULL,
name VARCHAR(50) NOT NULL,
email VARCHAR(50) NOT NULL,
raion VARCHAR(50) NOT NULL,
metro VARCHAR(30) NOT NULL,
telephone TEXT NOT NULL,
othercon TEXT NOT NULL,
category VARCHAR(30) NOT NULL,
tr TEXT NOT NULL,
url VARCHAR(70) NOT NULL,
comment TEXT NOT NULL,
price TEXT NOT NULL,
foto1 VARCHAR(30) NOT NULL,
foto2 VARCHAR(30) NOT NULL,
foto3 VARCHAR(30) NOT NULL,
foto4 VARCHAR(30) NOT NULL,
foto5 VARCHAR(30) NOT NULL,
foto6 VARCHAR(30) NOT NULL,
foto7 VARCHAR(30) NOT NULL,
foto8 VARCHAR(30) NOT NULL,
foto9 VARCHAR(30) NOT NULL,
foto10 VARCHAR(30) NOT NULL,
foto11 VARCHAR(30) NOT NULL,
foto12 VARCHAR(30) NOT NULL,
foto13 VARCHAR(30) NOT NULL,
foto14 VARCHAR(30) NOT NULL,
foto15 VARCHAR(30) NOT NULL,
foto16 VARCHAR(30) NOT NULL,
foto17 VARCHAR(30) NOT NULL,
foto18 VARCHAR(30) NOT NULL,
foto19 VARCHAR(30) NOT NULL,
foto20 VARCHAR(30) NOT NULL,
aid INT(9) NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
status VARCHAR(15) NOT NULL,
alt1 VARCHAR(15) NOT NULL,
alt2 TEXT NOT NULL,
PRIMARY KEY(ID)
)

CREATE TABLE obyavl
(
ID SMALLINT UNSIGNED NOT NULL auto_increment,
city INT(4) NOT NULL,
country INT(4) NOT NULL,
comment TEXT NOT NULL,
name VARCHAR(100) NOT NULL,
telephone VARCHAR(50) NOT NULL,
email VARCHAR(50) NOT NULL,
period VARCHAR(4) NOT NULL,
aid INT(9) NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
status VARCHAR(15) NOT NULL,
ip VARCHAR(30) NOT NULL,
PRIMARY KEY(id)
)

CREATE TABLE bunsip
(
ID SMALLINT UNSIGNED NOT NULL auto_increment,
bunsip VARCHAR(30) NOT NULL,
PRIMARY KEY(ID)
)

CREATE TABLE comments
(
ID SMALLINT UNSIGNED NOT NULL auto_increment,
tid SMALLINT NOT NULL,
name VARCHAR(50) NOT NULL,
email VARCHAR(50) NOT NULL,
comment TEXT NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY(ID)
)

CREATE TABLE saluncomm
(
ID SMALLINT UNSIGNED NOT NULL auto_increment,
tid SMALLINT NOT NULL,
name VARCHAR(50) NOT NULL,
email VARCHAR(50) NOT NULL,
comment TEXT NOT NULL,
date date NOT NULL,
PRIMARY KEY(ID)
)

CREATE TABLE votetable
(
aid INT(9) NOT NULL,
ip VARCHAR(30) NOT NULL,
date datetime NOT NULL,
PRIMARY KEY(aid)
)");

CREATE TABLE orderlist
(
ID INT(10) UNSIGNED NOT NULL auto_increment,
user VARCHAR(15) NOT NULL,
unit INT(10) NOT NULL,
number INT(4) NOT NULL,
date datetime NOT NULL,
status VARCHAR(15) NOT NULL,
PRIMARY KEY(ID)
)

CREATE TABLE news
(
idnum SMALLINT UNSIGNED NOT NULL auto_increment,
time varchar(5) NOT NULL,
datum date NOT NULL,
title text NOT NULL,
content text NOT NULL,
visible varchar(3) default 'on' NOT NULL,
ip text NOT NULL,
brouser text NOT NULL,
primary key(idnum)
)

CREATE TABLE adminip
(
ID SMALLINT UNSIGNED NOT NULL auto_increment,
uslov TEXT NOT NULL,
pass VARCHAR(30) NOT NULL,
PRIMARY KEY(ID)
)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...