Update of /cvsroot/phpwebapp/top10/db
In directory sc8-pr-cvs1:/tmp/cvs-serv9959/db
Modified Files:
Tag: maisp
top10_tables.sql
Log Message:
Index: top10_tables.sql
===================================================================
RCS file: /cvsroot/phpwebapp/top10/db/top10_tables.sql,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -C2 -d -r1.1.2.1 -r1.1.2.2
*** top10_tables.sql 6 Jan 2004 15:22:42 -0000 1.1.2.1
--- top10_tables.sql 15 Jan 2004 15:51:50 -0000 1.1.2.2
***************
*** 95,98 ****
--- 95,100 ----
proj_name varchar(100) NOT NULL default '',
proj_descr text NOT NULL,
+ url1 varchar(255) default NULL,
+ url2 varchar(255) default NULL,
category varchar(100) NOT NULL default '',
status varchar(10) NOT NULL default '',
***************
*** 133,134 ****
--- 135,150 ----
) TYPE=MyISAM;
+ ---
+ --- Table structure for table 'users'
+ ---
+
+ DROP TABLE IF EXISTS users;
+ CREATE TABLE users (
+ username varchar(30) NOT NULL default '',
+ realname varchar(50) default NULL,
+ email varchar(50) NOT NULL default '',
+ homepage varchar(50) default NULL,
+ status varchar(10) NOT NULL default 'private',
+ KEY primarykey (username)
+ ) TYPE=MyISAM;
+
|
