[Yapcom-commit] rev 115 - yapcom/trunk/lib/YAPC

[prev] [thread] [next] [lurker] [Date index for 2003/12/10]

Author: jon
Date: 2003-12-10 12:01:52 +0200 (Wed, 10 Dec 2003)
New Revision: 115

Modified:
   yapcom/trunk/lib/YAPC/DBI.pm
Log:
data has been moved to db.sql

Modified: yapcom/trunk/lib/YAPC/DBI.pm
===================================================================
--- yapcom/trunk/lib/YAPC/DBI.pm	2003-12-09 15:35:34 UTC (rev 114)
+++ yapcom/trunk/lib/YAPC/DBI.pm	2003-12-10 10:01:52 UTC (rev 115)
@@ -58,48 +58,3 @@
 }
 
 1;
-__DATA__
-
-CREATE TABLE people (
-             id       INTEGER PRIMARY KEY auto_increment,
-             fname    VARCHAR(20) NOT NULL,
-             lname    VARCHAR(20) NOT NULL,
-             email    VARCHAR(40) UNIQUE NOT NULL,
-             password VARCHAR(10) NOT NULL,
-             authcode VARCHAR(20),
-             acked    VARCHAR(1)  NOT NULL,
-             company  VARCHAR(30),
-             country  VARCHAR(20),
-             state    VARCHAR(20),
-             city     VARCHAR(20),
-             street   VARCHAR(30),
-             zip      VARCHAR(10),
-             phone    VARCHAR(20),
-             pauseid  VARCHAR(20),
-             url      VARCHAR(100),
-             mongers  VARCHAR(100),
-             bio      BLOB,
-             photo    VARCHAR(1),
-             other    VARCHAR(10000)
-) TYPE=INNODB;
-
-CREATE TABLE talks (
-             id       INTEGER PRIMARY KEY auto_increment,
-             user_id  INTEGER NOT NULL,
-             title    VARCHAR(100) NOT NULL,
-             length   INTEGER,
-             language VARCHAR(20),
-             abstract BLOB,
-             accepted INTEGER,
-             other    VARCHAR(10000)
-             ,FOREIGN KEY (user_id) REFERENCES people(id)
-) TYPE=INNODB;
-
-CREATE TABLE login (
-             cookie     VARCHAR(100)  PRIMARY KEY,
-             user_id    INTEGER NOT NULL,
-             timeout    VARCHAR(15) NOT NULL
-             ,FOREIGN KEY (user_id) REFERENCES people(id)
-) TYPE=INNODB;
-
-

• [Yapcom-commit] rev 115 - yapcom/trunk/lib/YAPC svn 12:01 on 10 Dec 2003

Generated at 23:05 on 14 Dec 2003 by mariachi 0.52