lib/create_db.sql
branchxbelweb
changeset 44 87f94936990d
parent 38 c30e2402deca
child 45 c81d480c3224
equal deleted inserted replaced
43:4d194fce51e1 44:87f94936990d
     1 --
     1 --
     2 
     2 
     3 CREATE TABLE users (
     3 CREATE TABLE users (
     4   id int NOT NULL,
     4   id int NOT NULL,
     5   name varchar(255) DEFAULT '' NOT NULL,
     5   name varchar(255) DEFAULT '' NOT NULL,
       
     6   full_name varchar(255) DEFAULT '',
     6   PRIMARY KEY (id)
     7   PRIMARY KEY (id)
     7 );
     8 );
     8 
     9 
     9 CREATE INDEX index_users_name ON users(name);
    10 CREATE INDEX index_users_name ON users(name);
    10 
    11