File: nanourl.sql

package info (click to toggle)
nanourl 0.1-7
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 88 kB
  • ctags: 20
  • sloc: sh: 93; php: 50; makefile: 39; sql: 6
file content (7 lines) | stat: -rw-r--r-- 447 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
 

USE mysql;
INSERT INTO `user` VALUES ('localhost','nanoUser',PASSWORD('nanoPasswd'),'N','N','N','N','N','N','Y','N','Y','N','N','Y','N','N','N','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
INSERT INTO `db` VALUES ('localhost','nanoDB','nanoUser','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
CREATE DATABASE /*!32312 IF NOT EXISTS*/ nanoDB;
USE nanoDB;
CREATE TABLE urls ( hash char(5) NOT NULL, url LONGBLOB, PRIMARY KEY (hash)) type=MyISAM;