Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Fetching contributors…

Cannot retrieve contributors at this time

32 lines (27 sloc) 0.89 kb
# This initializes the Mr. Voice database
# Import it by running:
#
# mysql -u SUPERUSER_NAME -p YOUR_DATABASE < dbinit.sql
#
# where SUPERUSER_NAME is the name of a user that can create tables
# within your database, and YOUR_DATABASE is the name of that database.
CREATE TABLE mrvoice (
id int(8) NOT NULL auto_increment,
title varchar(255) NOT NULL,
artist varchar(255),
category varchar(8) NOT NULL,
info varchar(255),
filename varchar(255) NOT NULL,
time varchar(10),
modtime timestamp(6),
PRIMARY KEY (id)
);
CREATE TABLE categories (
code varchar(8) NOT NULL,
description varchar(255) NOT NULL
);
# We'll give you a default category to put things in. It can
# be deleted from within the program if you don't want it.
INSERT INTO categories VALUES ('GEN','General Category');
#--
# CVS ID: $Id: dbinit.sql,v 1.7 2002/12/10 21:37:02 minter Exp $
Jump to Line
Something went wrong with that request. Please try again.