[phpwebapp-commits] CVS: top10/db top10_tables.sql,1.1.2.1,1.1.2.2
Brought to you by:
dashohoxha
From: Dashamir H. <das...@us...> - 2004-01-15 15:51:55
|
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; + |