All entries for Monday 15 January 2007

January 15, 2007

A gift to myself 2007, PHP, English World

—phpMyAdmin SQL Dump
—version 2.9.1
http://www.phpmyadmin.net

—Host: localhost
—Generation Time: Jan 15, 2007 at 10:09
—Server version: 5.0.27
PHP Version: 5.2.0

—Database: `EnglishStudy`

- ---------------------------


—Table structure for table `UserExamples`

CREATE TABLE `UserExamples` (
`Ids` bigint(20) NOT NULL,
`wordsIDS` bigint(20) NOT NULL,
`username` varchar(20) NOT NULL,
`sentence` mediumtext NOT NULL,
`explanation` mediumtext NOT NULL,
PRIMARY KEY (`Ids`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


—Dumping data for table `UserExamples`

- ---------------------------


—Table structure for table `UserInfo`

CREATE TABLE `UserInfo` (
`username` varchar(20) NOT NULL,
`firstname` varchar(20) default NULL,
`surname` varchar(20) default NULL,
`password` varchar(20) NOT NULL,
`email` varchar(30) NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


—Dumping data for table `UserInfo`

- ---------------------------


—Table structure for table `UserWords`

CREATE TABLE `UserWords` (
`Username` varchar(20) NOT NULL,
`Ids` bigint(20) NOT NULL,
`words` varchar(250) NOT NULL,
`addtime` datetime NOT NULL,
`selfsearchtimes` int(11) NOT NULL,
`level` int(11) NOT NULL,
`explanation` tinyblob NOT NULL,
PRIMARY KEY (`Ids`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


—Dumping data for table `UserWords`


January 2007

Mo Tu We Th Fr Sa Su
Dec |  Today  | Feb
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31            

Search this blog

Tags

Galleries

Most recent comments

  • I would suggest that you define your ID key fields as INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY K… by Max Hammond on this entry
  • The scandinavians and the Germans do it best…bread in the morning, bread in the evening, big main me… by on this entry
  • Usually it’s breakfast, lunch then dinner, or breakfast, dinner and tea (dinner is the main meal of … by Mathew Mannion on this entry

Blog archive

Loading…
Not signed in
Sign in

Powered by BlogBuilder
© MMXXI