gistfile1.sql

USE ocal;

DROP TABLE IF EXISTS openclipart_clipart;

-- FILE
CREATE TABLE openclipart_clipart(
  id integer NOT NULL auto_increment, 
  filename varchar(255), 
  owner integer NOT NULL, 
  PRIMARY KEY(id),
  FOREIGN KEY(owner) REFERENCES openclipart_users(id)
);

DROP TABLE IF EXISTS openclipart_users;

-- USERS
CREATE TABLE openclipart_users(
  id integer NOT NULL auto_increment, 
  username varchar(255) UNIQUE, 
  PRIMARY KEY(id), 
  FOREIGN KEY(avatar) REFERENCES openclipart_clipart(id)
);