12 lines
205 B
MySQL
12 lines
205 B
MySQL
|
use apidb;
|
||
|
|
|
||
|
|
drop table if exists user_prefs;
|
||
|
|
|
||
|
|
CREATE TABLE user_prefs (
|
||
|
|
userid int not null,
|
||
|
|
name varchar(64) not null,
|
||
|
|
value text,
|
||
|
|
key(userid),
|
||
|
|
key(name)
|
||
|
|
);
|