Fenrirthviti / stream-site

Rachni - nginx RTMP streaming front end
Other
195 stars 71 forks source link

sql error #27

Closed kimmoda closed 7 years ago

kimmoda commented 7 years ago

SQL sorgusu:

-- Table: subscribers -- DROP TABLE subscribers; CREATE TABLE subscribers(

host_account TEXT NOT NULL , subscriber TEXT NOT NULL , CONSTRAINT subscribers_pk PRIMARY KEY ( host_account, subscriber ) , CONSTRAINT host_account_fk FOREIGN KEY ( host_account ) REFERENCES users( email ) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE ) WITH ( OIDS = FALSE );

MySQL çıktısı: Belgeler

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 '(

OIDS=FALSE )' at line 14

kimmoda commented 7 years ago

1170 - BLOB/TEXT column 'host_account' used in key specification without a key length

Fenrirthviti commented 7 years ago

MySQL is not supported at this time.

The .sql imports are for PostgreSQL only.